Website User Guide

Step-by-step instructions for managing images, reviews, and the Get Estimation rate table — no coding required.

1) Editing Get Estimation Rates From a Google Sheet

The Get Estimation calculator can read its pricing straight from a Google Sheet, so you can update rates yourself without asking a developer.

1. Go to sheets.google.com and create a spreadsheet named "Quote Rates".
2. Row 1 header: RateKey, RateValue, Description.
3. Add one row per rate. The RateKey must exactly match one of these (case-sensitive):
   labourWagePerDay, supervisorPerDay, safetyOfficerPerDay, safetyEquipmentPerDay, fireExtinguisherPerUnit, workstationPerUnit, partitionPerInch, metalPartitionPerFt, falseCeilingPerInch, glassAcpPerSqFt, tilesRemovalPerSqFt, acElectricalPerPoint, materialEquipmentPerSqFt, machineToolsFlat, machineryFuelPerDay, debrisRemovalPerSqFt, transportationBase, floorBreakingPerSqFtPerInch, toiletFloorBreakingPerSqFtPerInch, conditionGoodFactor, conditionNormalFactor, conditionWorstFactor
4. File → Share → Publish to web → select the sheet → Comma-separated values (.csv) → Publish. Copy the link.
5. Open js/quote-calculator.js and paste the link into: const QUOTE_RATES_SHEET_CSV_URL = "PASTE LINK HERE";
6. Re-deploy once. After that, any rate you change in the sheet updates the calculator immediately — no redeploy needed for future price changes.

2) Google Sheet Setup for Images & Reviews

1. Create a spreadsheet with tabs Images and Reviews.
2. Images header: Key, Category, ImageURL, Caption.
3. Reviews header: Name, Rating, Text, PhotoURL, Date.
4. Publish each tab to web as CSV, then paste the links into js/sheet-data.js.

3) Deploying to Netlify

1. Go to app.netlify.com, sign in.
2. Click Add new site → Deploy manually, drag the folder containing index.html.
3. For future content/rate changes via Google Sheet, no redeploy is needed. For HTML/CSS/JS changes, drag-and-drop the updated folder again.