Google Sheets and Excel Price Sheet
Budget: $50 – $0 USD
Project Description: Google Sheets and Excel Price Sheet
I am looking for a freelancer to create a price sheet using Google Sheets. I am open to using Excel as well, but Google Sheets is my preferred software.
I am not sure about the specific formulas or functions that should be included in the price sheet. I would appreciate some advice from the freelancer on this matter.
The price sheet should accommodate more than 100 products or items.
require a comprehensive price sheet that:
Automatically updates prices and part numbers from www.nivelparts.com and www.golfcart.com.
Includes a visual representation of each part (pictures).
Features a dashboard for easy navigation and a search bar for efficient data retrieval.
Ideal skills and experience for this project include:
Dynamic Price Update:
Utilizing advanced data import and scripting functions (like IMPORTXML, VLOOKUP, and Google Apps Script in Google Sheets or Power Query and VBA in Excel), I will ensure real-time price updates from the specified websites.
This will involve creating a link between the price sheet and the websites' databases to fetch and update data automatically.
Integration of Part Numbers and Pictures:
Each part number will be linked with its corresponding image, providing a user-friendly visual reference.
I will implement a system to ensure these images are automatically updated alongside their respective part numbers and prices.
Dashboard and Search Functionality:
The dashboard will be designed for easy navigation, enabling quick access to different sections of the price sheet.
A custom search bar will be integrated, allowing you to search by part number, name, or any other relevant criteria.
User Experience and Design:
Special attention will be given to the layout and design for ease of use, ensuring that the data is presented in a clear, concise, and visually appealing manner.
The interface will be intuitive, catering to users with varying levels of technical expertise.
- Proficiency in Google Sheets and/or Excel
- Strong understanding of spreadsheet functions and formulas
- Ability to provide recommendations on the best formulas and functions to use for the price sheet
- Experience in working with large datasets and managing multiple products or items in a spreadsheet.
If you are interested in this project, please provide examples of similar price sheets you have created in the past.
I am looking for a freelancer to create a price sheet using Google Sheets. I am open to using Excel as well, but Google Sheets is my preferred software.
I am not sure about the specific formulas or functions that should be included in the price sheet. I would appreciate some advice from the freelancer on this matter.
The price sheet should accommodate more than 100 products or items.
require a comprehensive price sheet that:
Automatically updates prices and part numbers from www.nivelparts.com and www.golfcart.com.
Includes a visual representation of each part (pictures).
Features a dashboard for easy navigation and a search bar for efficient data retrieval.
Ideal skills and experience for this project include:
Dynamic Price Update:
Utilizing advanced data import and scripting functions (like IMPORTXML, VLOOKUP, and Google Apps Script in Google Sheets or Power Query and VBA in Excel), I will ensure real-time price updates from the specified websites.
This will involve creating a link between the price sheet and the websites' databases to fetch and update data automatically.
Integration of Part Numbers and Pictures:
Each part number will be linked with its corresponding image, providing a user-friendly visual reference.
I will implement a system to ensure these images are automatically updated alongside their respective part numbers and prices.
Dashboard and Search Functionality:
The dashboard will be designed for easy navigation, enabling quick access to different sections of the price sheet.
A custom search bar will be integrated, allowing you to search by part number, name, or any other relevant criteria.
User Experience and Design:
Special attention will be given to the layout and design for ease of use, ensuring that the data is presented in a clear, concise, and visually appealing manner.
The interface will be intuitive, catering to users with varying levels of technical expertise.
- Proficiency in Google Sheets and/or Excel
- Strong understanding of spreadsheet functions and formulas
- Ability to provide recommendations on the best formulas and functions to use for the price sheet
- Experience in working with large datasets and managing multiple products or items in a spreadsheet.
If you are interested in this project, please provide examples of similar price sheets you have created in the past.