Google Sheet Quotation
Budget: $10 – $30 USD
I need a Google Sheet that lets me price jobs by square meter and keeps the workflow clear for one admin (me) and one standard user.
Admin side
– I must be able to adjust or add new square-meter rates at any time.
PRICING LOGIC (PER LINE ITEM)
All main components are priced per m².
Final price per m² = Design + Material + Color + Glass + Screen (if selected)
Line m² = Width × Height
Unit Price per item = (Line m² × Final price per m²) + Key Lock (if selected)
Line Total = Unit Price × Quantity
Key Lock is a fixed price per piece and is multiplied by Quantity.
PROJECT TOTAL CALCULATION
Subtotal = Sum of all line totals
INSTALLATION LOGIC (PROJECT LEVEL)
Installation is optional (Yes / No).
If Yes:System detects all materials used in the quotation.Finds the highest installation price per m² among them.Applies it to total project m².
Installation = Total m² × Highest Installation Rate
DELIVERY LOGIC (PROJECT LEVEL)
User inputs distance in km.
If distance ≤ 30 km → Delivery = 0If distance > 30 km → Delivery = Total km × Rate
– I need full visibility of every quotation and every customer record.
– I should also control the user’s access level, deciding when the user can edit an individual quotation.
User side
– The user will enter new quotation requests through a simple, guided input section.
– They can open a read-only history of their previous quotations at any time.
– When I grant permission, they may edit their own quotation; otherwise the sheet stays locked for them.
Structure ideas I have in mind
• One clean data table that stores all quotations.
• A protected rate table visible only to admin.
• A front-end entry form or neatly laid-out input sheet for the user.
• Filters or a lightweight dashboard so I can quickly search and review quotes.
You’re free to use Apps Script, protected ranges, or any other native Google Workspace tools as long as the end result is easy for me to maintain. Share the finished file with clear notes on where to update rates and how to toggle user permissions.
Admin side
– I must be able to adjust or add new square-meter rates at any time.
PRICING LOGIC (PER LINE ITEM)
All main components are priced per m².
Final price per m² = Design + Material + Color + Glass + Screen (if selected)
Line m² = Width × Height
Unit Price per item = (Line m² × Final price per m²) + Key Lock (if selected)
Line Total = Unit Price × Quantity
Key Lock is a fixed price per piece and is multiplied by Quantity.
PROJECT TOTAL CALCULATION
Subtotal = Sum of all line totals
INSTALLATION LOGIC (PROJECT LEVEL)
Installation is optional (Yes / No).
If Yes:System detects all materials used in the quotation.Finds the highest installation price per m² among them.Applies it to total project m².
Installation = Total m² × Highest Installation Rate
DELIVERY LOGIC (PROJECT LEVEL)
User inputs distance in km.
If distance ≤ 30 km → Delivery = 0If distance > 30 km → Delivery = Total km × Rate
– I need full visibility of every quotation and every customer record.
– I should also control the user’s access level, deciding when the user can edit an individual quotation.
User side
– The user will enter new quotation requests through a simple, guided input section.
– They can open a read-only history of their previous quotations at any time.
– When I grant permission, they may edit their own quotation; otherwise the sheet stays locked for them.
Structure ideas I have in mind
• One clean data table that stores all quotations.
• A protected rate table visible only to admin.
• A front-end entry form or neatly laid-out input sheet for the user.
• Filters or a lightweight dashboard so I can quickly search and review quotes.
You’re free to use Apps Script, protected ranges, or any other native Google Workspace tools as long as the end result is easy for me to maintain. Share the finished file with clear notes on where to update rates and how to toggle user permissions.