Cost Calculator
Alexandru Bordei
Data Visualizer
Data Analyst
Script Writer
Google Drive
Google Sheets
JavaScript
Project that allows cost calculation for various contracts.
Instructions Page
The project is a multi-stage approach to a per/client calculator.
Stage 1:
Generate a new job sheet. This is done via a prompt. This leads to generating a new tab which allows cost calculation for this particular client.
Submit form.
Stage 2:
The page allowed materials and contractors listing. The items are pulled live from a database maintained on a different tab (more info on this later).
Job Interface
Stage 3:
PDF generation with custom template for each client via a function call.
Invoice before generation
The invoice allows last minute editing before PDF generation.
Items & Prices:
Items get live price feeds from Homedepo. This involves crawling their specific links and getting live data from the website. Homedepo is notorious in blocking API calls.
Back-end with Item prices
This back-end sheet is referenced for live prices. It updates daily while also allowing a manual trigger of all price update.
