Google Sheets Auto-Price Calculator
Budget: $250 – $750 USD
I'm looking for a freelancer proficient in Google Sheets to create a custom quoting tool. (If another solution would be better than Google Sheets that could be available on our website, we are open to discussing other possibilities.) It will primarily be used for physical products, with the following requirements:
- The tool should auto-calculate prices based on the respective inputs.
- The functionality for manual price adjustments should exist as needed.
Ideal skills:
- Extensive knowledge of Google Sheets and its various functions
- Previous experience in implementing quote generation systems
- Understanding of-sales and pricing structures is a plus
Ideally, I would like a database of our products to be in one sheet. A second sheet would include pricing for the base product and for available options. A third, working sheet would include dropdowns to choose the characteristics of the base products and the available options and calculate a price.
Here are some of our parameters: Wood Species - 5 options; Width - 4 options; Length - many options; thickness - 2 options; Edges - 2 options. Add on options: Branding; shrink wrap; label/sticker; display box; case box, shipping.
- The tool should auto-calculate prices based on the respective inputs.
- The functionality for manual price adjustments should exist as needed.
Ideal skills:
- Extensive knowledge of Google Sheets and its various functions
- Previous experience in implementing quote generation systems
- Understanding of-sales and pricing structures is a plus
Ideally, I would like a database of our products to be in one sheet. A second sheet would include pricing for the base product and for available options. A third, working sheet would include dropdowns to choose the characteristics of the base products and the available options and calculate a price.
Here are some of our parameters: Wood Species - 5 options; Width - 4 options; Length - many options; thickness - 2 options; Edges - 2 options. Add on options: Branding; shrink wrap; label/sticker; display box; case box, shipping.