Google Sheets Quoter Calculator
Budget: $10 – $30 USD
I need a Google Sheets file that mirrors the quoting logic from a current web-based quoter. I will be typing the input values by hand, after which the sheet should run a set of advanced formulas—think nested IFs, LOOKUPs, array calculations, or any other complex functions you deem best—to return one final quoted figure in a clearly labeled cell.
The results has to be compared to those of the web based quoter.
The structure of the file must stay tidy and easy for non-technical teammates to follow, with protective formatting on any formula cells. Please document the key formulas inline (brief comments are fine) so future tweaks are straightforward. The formula part has to be in a special sheet, so we have the plenty of space to create more modifications. The formula can be changed (change of price year per year or increase because of inflation) easily using cell names instead of column-row naming convention.
Once complete, I will test the sheet against several real quotes from the web system; the single output value needs to match every time for the job to be accepted.
This is simple, I require ONLY to be 2 to 4 layers only (not the rest) (more simple)
tip: The shipping calculator uses the average weight of the pcb (google it)
The GUI (formating) has to be user friendly.
This is the reference:
https://cart.jlcpcb.com/quote?spm=jlcpcb.Public.2006
The results has to be compared to those of the web based quoter.
The structure of the file must stay tidy and easy for non-technical teammates to follow, with protective formatting on any formula cells. Please document the key formulas inline (brief comments are fine) so future tweaks are straightforward. The formula part has to be in a special sheet, so we have the plenty of space to create more modifications. The formula can be changed (change of price year per year or increase because of inflation) easily using cell names instead of column-row naming convention.
Once complete, I will test the sheet against several real quotes from the web system; the single output value needs to match every time for the job to be accepted.
This is simple, I require ONLY to be 2 to 4 layers only (not the rest) (more simple)
tip: The shipping calculator uses the average weight of the pcb (google it)
The GUI (formating) has to be user friendly.
This is the reference:
https://cart.jlcpcb.com/quote?spm=jlcpcb.Public.2006
Related categories:
Data Entry
Excel
Documentation
Data Analysis
Google Sheets
Financial Modeling
Data Management