Google sites freelancers jobs

I am seeking a developer to create a basic Google Chrome extension. This extension is intended to be uploaded to Google Play Store for listing but will not serve any functional purpose. It's essentially a project for educational or experimental purposes. Key Requirements: - Development of a simple, non-functional Chrome extension for listing on Google Play Store. Ideal Skills and Experience: - Proficient in Chrome extension development. - Familiarity with Google Chrome Web Store's submission guidelines. - Prior experience in creating Chrome extensions, whether for productivity, entertainment or other purposes, will be beneficial. - A keen eye for detail to ensure the extension is error-free and meets the basic requirements of a Chrome extension....

I urgently need a proficient developer to connect my Node.js site to a MySQL remote database. - Skills and Experience: * Proficient in Node.js and MySQL * Understanding of database schemas (creation a possible requirement) - Task: * Connect my site efficiently to the MySQL database. The complexity of the task might vary as there may be a need for crea...- Skills and Experience: * Proficient in Node.js and MySQL * Understanding of database schemas (creation a possible requirement) - Task: * Connect my site efficiently to the MySQL database. The complexity of the task might vary as there may be a need for creating a new database schema. This task is highly time-sensitive and requiring immediate attention. Skilled, fast and efficient freelancers would be strongly c...

Spanish Recording Project We have a project, that needs Native Spanish speakers, we will give you the text, and you need to record just 20 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 3USD For 40 short sentences recording. Every sentences is 2 ...Recording Project We have a project, that needs Native Spanish speakers, we will give you the text, and you need to record just 20 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 3USD For 40 short sentences recording. Every sentences is 2 word. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of th...

I'm seeking a seasoned IT specialist with a firm handle on cloud hosting, particularly in deploying Node.js applications on a Linux-based VPS. I have decided to use a cloud server over a local one. I have a firm preference for VPS among the available cloud hosting providers. Here's what I expect from potential freelancers: - Demonstrate profound knowledge and experience in Linux-based VPS and cloud hosting. - Proficiency in using Node.js is crucial as the application to be deployed is Node.js-based. - Recommend and implement optimal deployment strategies ensuring a stable and secure application. - Conduct necessary tests post-deployment to guarantee the application runs smoothly. Your ability to accomplish this task expeditiously while maintaining a high standard is key...

We've created a web-based HTML game but are facing issues with unusually high scores by some players. We suspect that there might be loopholes in the game's mechanics which are being exploited. Key Points for Freelancers: - We need an expert in HTML5-based game development. - The role is purely for auditing the game for security vulnerabilities, not for any development work. - Your application should primarily focus on your past work, especially in auditing and fixing security issues in HTML5 games. Communication: For updates and feedback, I prefer to communicate via email.

I'm seeking a highly skilled freelancer to create a powerful custom order form in Excel. Though the specific features were not clearly defined, freelancers would potentially be working on creating dropdown menus, calculation formulas, and conditional formatting. Key Skills: - Proficiency in Excel - Previous experience in creating Excel forms Responsibilities: - Building dropdown menus - Establishing calculation formulas - Implementing conditional formatting Data Capture: The successful form should be able to capture: - Customer details - Product details Applications should include examples of past works similar to this project for review. Your understanding and experience in handling similar projects will greatly contribute to the success of this one. THIS IS AN...

...top-notch nursing professionals in the industry. Ideal freelancers for this task would be: - Skilled in Human Resources, specifically in recruitment strategies - Have a profound understanding of the healthcare sector and its needs - Possess excellent proposal and project writing skills - Demonstrated experience in addressing operational inefficiencies Key requirements of the proposal include: - A comprehensive overview of the current recruitment scene in the healthcare industry. - An analysis of our current recruitment strategy and its shortcomings. - Innovative techniques and strategies to attract qualified nursing professionals. - Cost-effective recommendations that align with our budget. - An implementation plan for the proposal. Freelancers proficient in crafting...

Move both and to vps from shared hosting. Move databases. Install mariah, php admin, conf nginx, move cron jobs, etc.

I need a certified legal translator to help me translate a 3-page agreement from English to Arabic. This is a standard level of confidentiality document, so I do not require high or very high confidentiality. Key skills and experience required: - Native Arabic speaker with fluen...agreement from English to Arabic. This is a standard level of confidentiality document, so I do not require high or very high confidentiality. Key skills and experience required: - Native Arabic speaker with fluency in English - Certification as a legal translator - Experience in translating legal documents - Attention to detail and ability to maintain confidentiality It's essential for potential freelancers to understand that this is a legal document, so a good grasp of legal terminology and conce...

I need some Android developers in java I need work from New freelancers I need work for long term but at low budget I need a serious and hard working persons

I need a simple PHP script, using as few files as possible (preferably a single PHP file). The goal is to extract the following data from the google AD ad system: Campaign names and today's daily spend per campaign. In addition, which campaigns are running and which are paused. Finally, a simple buttons - for each campaigns: run a campaign, or pause a campaign. A test google api key is required because I can't give out my own. For the project I need a description how I can run the file and how I can replace the test api key with my real (own) key.

In an effort to increase the number of internships available to students and streamline the application process, we are seeking proficient freelancers to handle the task of applying for these internships on behalf of the students. By doing this, we aim to provide personalized guidance and ultimate success for these students. The chosen freelancer will mainly utilize LinkedIn, Indeed and Ziprecruiter as platforms to search and apply for these internships. Key Tasks Include: - Searching for suitable Internships on LinkedIn, Indeed and Ziprecruiter - Filling out application forms - Record the internships you applied on our platform. Ideal Skills and Experience: - Previous experience in Human Resources or Recruitment - Familiarity with LinkedIn, Indeed and Ziprecruiter - Excellent ti...

...lakeside setting and the opportunity to contribute to the enhancement of a unique outdoor space. The client possesses a large network and is committed to recommending exceptional work to their connections. Therefore, delivering high-quality results and exceeding expectations will not only lead to potential future collaborations but also positive referrals. Submission Guidelines: Interested freelancers are invited to submit their proposals, including portfolio samples and a brief outline of their approach to the project. The deadline for submissions is 9th of May. Shortlisted candidates will be contacted for further discussion and a site visit if necessary. Why You Should Respond: Opportunity to work on a prestigious lakeside garden renovation project. Collaborative environme...

I need a website created for my agency that closely mimics the design and functionalities of another site. Here are the specifics: - Layout & Design: The site to be emulated is www.influencedigitally.com. However, my site should not be a direct carbon copy. While the general layo...in color scheme, but slightly different. - Functionality: The functionalities from the existing site to be integrated into mine include a contact form, a blog section, and a services page. - Text: The content should be similar, however provided text will be somewhat different to maintain uniqueness. Ideal freelancers for this job should have a solid background in web design and development, with a keen eye for detail. Experience in replicating or drawing inspiration from existing sites will b...

I'm looking for a skilled professional specializing in Selenium testing, to write and automate 1000 functional, regression, and performance test cases in a span of 10 days. Given the scope of the work, it is expected from interested freelancers to have: - Proficient knowledge around Selenium and its diverse testing capabilities. - Experience in creating and automating functional, regression, and performance test scripts. - A strong understanding of automation frameworks and testing methodologies. - The ability to complete the project in the stipulated 10 days. Although not expressly stated, proficiency in popular programming languages (Like Java, Python, C#, etc.) and the capability to execute test cases across various browsers and operating systems would provide an added a...

I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.

I am in need of a logo designer who can create a simple, yet elegant logo for m...some way while maintaining a minimalist design scheme. - I prefer the color scheme to incorporate Blue and Black, but I am open to suggestions. - A symbol or icon that combines a house with the letters 'B' and 'C' would be ideal, but I am also open to other creative ideas. - In terms of font style, I do not have a specific preference, so I am open to the designer's recommendations. Ideal freelancers for this task should have experience in: - Logo design, specifically in the minimalist style. - A good understanding of the construction industry. - Proficiency in graphic design software. - Strong communication skills to understand and implement client's vision. Looking ...

...talented WordPress developer to help me create a dedicated freelancer hiring platform. Key Features: - Profile Creation for Freelancers: I want freelancers to be able to set up their profiles with a detailed portfolio and a comprehensive description of their skills. - Project Posting by Clients: Clients should be able to post their projects with clear specifications, budget range, and deadlines. - Ratings and Reviews System: Implement a solid ratings and reviews system to help build trust between clients and freelancers. Communication: - Direct Messaging: The platform needs to provide direct messaging functionality for seamless communication between clients and freelancers. - Project Commenting: To facilitate the discussion of the project details and requi...

I'm in need of a skilled and experienced SEO specialist who can assist me in improving my website's ranking on Google. The primary focus of this project is to create high-quality editorial backlinks, as I believe they're the best fit for my website. Your role will be to design and implement a strategic SEO backlink campaign that can: - Improve my website's Google search engine rankings - Create a diverse backlink profile Our ideal candidate should have proven experience in generating editorial backlinks, as well as a deep understanding of Google's ranking algorithm. A strong track record in improving search engine rankings through effective SEO methods is a must for this job.

I'm on the lookout for skilled and dedicated individuals to collaborate with on a range of ongoing projects. As a solo operator, I'm specifically seeking individual freelancers - no companies please. The projects will involve a mix of frontend and backend web development work. Key Requirements: - Proficiency in both frontend and backend development. - Extensive experience with a variety of programming languages and frameworks. - Capability to adapt to different languages and frameworks based on the specific project requirements. Your responsibilities will include: - Developing and implementing website upgrades and features. - Collaborating with the design team to create responsive, user-friendly interfaces. - Ensuring the website functions efficiently, is secure, and per...

Seeking an expert to resolve a recurring issue in my AutoML pipeline, part of my Google Cloud Vertex AI setup. - The pipeline is a simple one without requiring any coding. It has been failing consistently after a short execution time. - The dataset being used is relatively small, which eliminates the possibility of resource scarcity. - The stage where the pipeline fails is during model training. Ideal candidates should be well-versed in Google Cloud Vertex AI and have a strong understanding of AutoML pipelines and their potential bottlenecks. Experience with debugging and resolving issues in AutoML pipelines will be a definite advantage.

I need some Android developers in java I need work from New freelancers I need work for long term but at low budget I need a serious and hard working persons

Note: I want only individual freelancers who works freely. I'm seeking a skilled developer that can seamlessly integrate the Zegocloud service into my application. This addition aims to provide user-friendly video and audio-calling functionality, with a live stream feature. Key Requirements: - Integration of Zegocloud for video and audio calling - Addition of live streaming function - Compatibility across iOS and Android devices Specific Functions: - Video Call - Audio Call - Live Stream An ideal candidate would have: - Previous experience with Zegocloud or similar platforms - Proficiency in app development across both iOS and Android platforms - A strong understanding of user experience design for video/audio calling Looking forward to your proposals.

I'm searching for a talented web designer with a strong background in illustration/Graphic design. While I have not specified the exact type of illustrations I want incorporated in the design, I am open to hearing your ideas. Successful freelancers should include past work in their application to demonstrate their unique design flair. I have attached a concept which I want to work from. I need that background image recreated, I would also like buttons, fonts, icons, to match, and each file to be compatible for website design, complete branding package. getting a quote is the main focus users this site. People want to know how much. Ideal skills: - Solid background in web design - Proven experience in creating engaging illustrations - Openness to brainstorm and work collaborat...

...appealing manner. Additional Information: The logo will be used across various platforms, including signage, packaging, online channels, and marketing materials. We encourage creativity and originality while staying true to the essence of our brand. Please provide both color and monochrome versions of the logo to ensure versatility in different applications. Submission Guidelines: Interested freelancers are requested to submit their portfolios showcasing relevant logo design experience. Proposals should include a brief explanation of the concept behind the design and how it aligns with the brand values of S.M. Bengali Sweets. The selected freelancer will be compensated competitively based on their experience and the quality of the design. Deadline for Submissions: All proposal...

**Project Overview:** We are seeking a freelance developer to create a comprehensive ver...completion of the project. **Timeline:** The project timeline will be discussed and agreed upon with the selected freelancer based on the complexity of the requirements and the estimated development effort. **Budget:** The budget for this freelance project will be negotiated based on the scope of work, deliverables, and the freelancer's experience and expertise. **How to Apply:** Interested freelancers are invited to submit their proposals, including relevant experience, and proposed approach to implementing the required features. Please include the colour of the sky and the day you applied in the application Additionally, please provide an estimated timeline and budget for completi...

I'm looking for an experienced SEO professional to help drive more organic traffic to my website. Key Aspects: - Current Traffic: Low. I need someone who can work on improving this significantly. - Previous Efforts: I've previously focused on social media marketing. Now, I'm targeting Google specifically. - Specific Goal: My primary aim is to have my website rank on the first page of Google for searches in my field. I'm seeking a freelancer who can not only boost my website's visibility on Google but also sustain that growth over time. Ideal Skills and Experience: - Proven SEO track record with verifiable results - Experience in increasing website traffic and improving search ranking - Ability to tailor SEO strategies to specific fields - ...

Hi, I have buisness of construction of home. I have created a google sheet step by step process of building home. The google sheet which I have created, I want to make it into good template that can track the work project by project. I really want a good looking template of the Google sheet which I have created which I can use on every projects. Also after this work, I will need expenses and income template and a template for a client to select all the things they need to during construction process. So I have in total 3 of the work but first I need to make sure that process of building home template is good of work to give other 2 work after this. See below attached pdf of Google sheet which I have made step by step **Requirements** 1. **Automate D...

Looking for a Virtual Assistant from Philippines with strong English skills (mandatory, test assignment will be given to check this), and accounting knowledge. Knowledge of SEO/ Content writing is a big advantage Overall engagement would be 8 hours per day x 6 days a we...Assistant from Philippines with strong English skills (mandatory, test assignment will be given to check this), and accounting knowledge. Knowledge of SEO/ Content writing is a big advantage Overall engagement would be 8 hours per day x 6 days a week in US day time (India/ PH night shift). The requirement may increase depending on the quality of work delivered. Only looking at Individual Freelancers, team bids will be rejected. If this description excites you, happy to chat. The price range quoted is monthly p...

I need some Android developers in java I need work from New freelancers I need work for long term but at low budget I need a serious and hard working persons

...updates on project progress Experience: - Demonstrated experience in Android and web development - Previous work on projects involving user authentication, push notifications, and in-app purchases is a plus - A proven track record of completing projects within tight deadlines. Project Proposal: Real Estate Website and Android App Development Project Overview: We are seeking experienced freelancers or development agencies to create a comprehensive real estate platform consisting of a website and an Android mobile application. The platform aims to facilitate property listings, agent management, customer interactions, developer collaborations, investor engagement, and seamless integration with social media platforms and communication channels. Project Objectives: 1. Develop a...

As the client for this project, I am seeking a competent app developer to create an...Proficiency in creating user registration and login systems - Prior experience with push notifications and in-app purchases - Demonstrated ability to deliver high-quality app performance. Hosting: - The application will also need to be hosted. Although a preferred hosting platform has not been named, experience with popular services such as Amazon Web Services, Google Cloud Platform, or Microsoft Azure would be beneficial. All interested freelancers should apply with: - Examples of past work, particularly those related to the mentioned features. - Detailed project proposals, outlining their strategy to fulfill the project requirements. I look forward to seeing your applications and worki...

I am having some issues with my Stripe account. Although I have certain payment options active on my account, they are not showing up at the front end. These payment options include ApplePay, GooglePay, and PayPal. Moreover, my "payment method domain" is enabled. (See attached) I am looking for someone with...resolve this issue. Here are some key points you need to consider for this job: - Detailed knowledge of Stripe and its functions - Proven experience in troubleshooting issues related to Stripe - Strong understanding of how payment options are enabled and integrated with Stripe In your application, please share your relevant experience working with Stripe. Please note, I won't be considering freelancers who don't have experience in this area. I'm lo...

Spanish Recording Project We have a project, that needs Native Spanish speakers, we will give you the text, and you need to record just 20 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 3USD For 40 short sentences recording. Every sentences is 2 ...Recording Project We have a project, that needs Native Spanish speakers, we will give you the text, and you need to record just 20 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 3USD For 40 short sentences recording. Every sentences is 2 word. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of th...

I'm seek...explanations and benefits. - Portfolio: Encapsulating a comprehensive array of my previous work. Accompanied by short descriptions and the impact of each project. - Testimonials: Showcasing positive feedback from past clients. - Contact Info: Easily accessible information to facilitate effortless contact from potential clients. - Home page: An engaging and welcoming introduction to the site. Ideal freelancers bidding on this project should have experience in creating personal portfolio websites with proven lead generation capabilities. Expertise in modern web design and understanding of UX best practices are essential. Strong communication skills and commitment to timelines is required to ensure a successful collaboration. SEO knowledge is also beneficial to drive o...

I'm in search of a Google Ads specialist who can help me drive more traffic to my website and boost online sales. The target audience for this campaign is both national and global customers. Key Requirements: - Proven experience in managing Google Ads campaigns. - Familiarity with targeting national and global audiences. - A track record of increasing website traffic and boosting online sales. - Strong understanding of the Google Ads platform and its features. The ideal candidate should be able to work within a budget of $1000 - $2000 per month. I'm looking for someone who can help me optimize my Google Ads strategy for maximum impact. Please include your past experiences and results in your bid.

I'm looking for a skilled developer to build an exam proctoring website with additional features such as live video monitoring, automated cheating detection, and secure ...these are the primary functions, a few more features will only be disclosed to the successful freelancer. Key requirements for this project are: - A clear understanding of my brief - Ability to develop a secure site with video monitoring capabilities. - Skill in creating automated systems for cheating detection - Expertise in browser lockdown features to ensure exam integrity. Successful freelancers must present detailed project proposals for consideration. I will provide all content and graphics for the website. Therefore, a keen eye for detail with a commitment to incorporate provided material meticul...

I am in need of a highly skilled and experienced designer for an undisclosed project. Here's what you need to know: - I'm not specific about it being a website, graphics, or mobile app development project. I need someone with a breadth of experience across all fields. - Freelancers should include their experience in their application, specifically focusing on projects that are similar to the ones they've worked with before. Your experience on similar projects is extremely important for this role. I'm hoping to find someone who’s been there, done that and can bring their wisdom to my project. Do include portfolio links or project descriptions of relevant work. Looking forward to find the right talent who can add value to this specific project.

As a seller on Amazon, I'm seeking skilled freelancers to assist with optimizing my account. I'm after someone who can help me with setting up product listings, managing my inventory levels, and boosting the visibility of my products by optimizing relevant keywords for search. Key Responsibilities: - Assistance with setting up product listings - Help with managing inventory levels - Optimizing keywords for better search visibility I'm looking for freelancers with experience in Amazon account management, particularly with a proven record of enhancing product visibility and boosting sales. Your application should include detailed project proposals that outline your approach and previous work in this area.

I am seeking a skilled Shopify developer to upgrade an e-commerce store for selling physical goods. While a strong grasp on Shopify's platform is necessary to accomplish this project, prior experience with e-commerce sites is highly beneficial. Although real-time inventory tracking is not a requirement for this project, the ability to update and modify product details is crucial. A time-efficient yet detail-oriented approach will make for a successful completion of this project. All interested freelancers must show a proven track record in developing Shopify e-commerce stores.

...professional freelancer to perform a number of edits for my Shopify website. As the client, I have not detailed the specific changes I desire, which implies that I require a multifaceted individual with a great eye for both functional and aesthetic improvement. Key Tasks: - Theme customization - Product page redesign - Payment gateway setup Since I haven't prescribed what information successful freelancers should include in their application, I encourage all applicants to include: - Past work records - Relevant experience - Detailed project proposal, based on what you perceive as required changes after visiting my website. I envision these edits will: - Improve user experience - Increase sales conversions - Enhance visual appeal Therefore, experience in optimizing use...

...analytics to create a list of 2,000 websites with high Domain Authority (DA) and Page Authority (PA). I am particularly interested in: This sheet requires all the sites that could not stay live for long time, the fraud site is not required. And if my budget is low, then at least work worker - Sites with a DA score of 60-80 - Variety of types including blogs, eCommerce sites, news sites, SMO, press release sites, and more. The successful freelancer will have a deep understanding of: - How to identify and assess high websites - The significance of backlinks Your deliverable will be a clean, organized sheet listing the sites and their corresponding DA and PA scores. I am keen on details so please verify all information before submission. Ens...

Google Ads Specialist for Music Video Campaign on YouTube I am looking for a Google Ads specialist to work on a campaign for a music video on my YouTube channel [here's the channel link](), which will be released soon. Here are my requirements: - **Precise targeting**: I want to ensure the campaign reaches the right audience segments, with genuine interest in music and similar content to my channel. - **Organic views**: I'm not interested in fake views or bot-generated views. I want authentic views from real users. - **Similar channels**: I'm looking for suggestions of channels similar to mine to target the campaign. - **Campaign optimization**: I'm seeking continuous campaign optimization to maximize results. Before starting, I

Hello, Greetings of the day! I require Ukrainian Voice-over Artists for my project. Details for freelancers/Artists : Source Language: Any Target Language: Ukrainian Target file - MP3/Wav NOTE- Kindly share your samples. I will be waiting for your response and I hope that we can discuss this project further. If interested, kindly share your samples. Looking forward to your bids.

its a very simple task with following requirements 1. Column E in one of the sheet is having a drop down menu with 3 options only. I want that once any option from drop down is selected once it cannot be deleted or amended by any user. 2. Till the time data in Column E is not selected/ entered, the users should not be allowed to enter data in any subsequent column. 3. Access/ Permission to delete/ amend data in column E to be given to selected Users and once any user is removed from the allowed user list he should not b able to amend or delete data in column E. please only bid if you really think you can handle this task with proficiency and have already done it before.

...my website to improve its visibility and ranking on search engines. Simultaneously, I need a Google Ads professional to help increase website traffic, boost sales and revenue, and effectively connect my merchant and ads to my shop. As for the design aspect, I want to create my own, so I need someone who can translate my visions onto the platform effectively. As the perfect candidate, you have: - Proven experience with Shopify SEO and Google Ads management - Excellent understanding of on-page SEO and keyword research - Demonstrable track record in improving website traffic and revenue through Google Ads - Ability to implement unique design preferences on Shopify. By optimizing both SEO and Google Ads strategies, I look forward to improving my Shopify webs...

Italian Recording Project We have a project, that needs Native Italian speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud backgroun...sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of th...

Turkish Recording Project We have a project, that needs Native Turkish speakers, we will give you the text, and you need to record 110 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noi...text, and you need to record 110 short sentences. you just need to open the platform link, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 4$ for 110 short sentences record. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of th...

...technical woocommerce things with woocommerce, i rather a company than an individual this way there is more skills to different tasks and i dont want issues like disappearing freelancers. Please make sure you are serious, keep having people start the job, do a few things and then all of a sudden just stop working for no reason. Must have good communication and have experience with complex fixes, when a task is assigned it needs to be resolved and whatever else is found quickly. Bugs mean the site is down or not working and dont have time for excuses or inexperience. This is a long term position as once you get use to the sites (about 12) the issues tend to be the same. DO NOT apply just to work temporarily because you need money today, please. I dont want to invest time ...

l has a Google sheet file. I want to create a script for the Daily sheet. When a new row is completed and a new input is introduced in column C, the script should look for the closest past entry, by date, for the Unit Price in column P and add it to the new row being completed in column G, which is the market Price, the same for the date and which provider made the last purchase.