DTP data

Infrastructure Project Manager (Local + Sync)

Select Project: -- New Project --

Project Name:

Total Cost (₹):

Schedule "A" (₹):

Asphalt (₹):

Pipe (₹):

Cement (₹):

Steel (₹):

Royalty (₹):

Labour (₹):

POL (₹):

Material (₹):

Lab Testing (₹):

W (Excl. Materials): ₹0 K1: 0% K2: 0% K3: 0%

Locally Saved Projects

Project Name	W (Excluded)	K1%	K2%	K3%	Actions

User Guide: Project Cost Estimator & Cloud Sync Tool

Operational documentation for local cost management, mathematical verification, and automated cloud logging

1. Overview

This program is a dedicated construction estimation utility designed to evaluate project budgets, calculate baseline overhead dynamics, and log historical data. It utilizes a zero-latency hybrid infrastructure: records are compiled securely on your device while simultaneously running a background sync routine with an external Google Sheets database.

2. System Components & Flow

• Local Storage Core (IndexedDB): Powered by an internal database called ProjectDB. It writes directly to your browser's persistent storage engine, preventing data loss even if you refresh or close the page.
• Live Cloud Sync: Submits an integrated JSON payload over a secure webhook architecture to a Google Apps Script macro address (SCRIPT_URL) to populate standard data cell spreadsheets automatically.
• Automatic Balance Verification: Evaluates structural component inputs dynamically against calculated residual cost variables to flag proportioning imbalances instantly.

3. Operating Instructions

Step 1: Setting Up Your Workspace

• Initiate a New Project: Keep the main dropdown element marked as -- New Project -- and enter a unique descriptor in the Project Name field box.
• Load Existing Record: Click the selection drop-down panel. Selecting an item calls the internal loadProject() framework to read database logs and accurately re-populate the form layout.

Step 2: Inputting Financial Vectors

Provide baseline cost values inside the interface form boxes. Numerical entries are automatically aggregated to complete the calculation steps:

1. Total Work Cost: The overall gross cap structural budget estimation value.
2. Material Costs: Individual structural metrics representing specialized line expenditures (Asphalt, Pipe, Cement, and Steel line-items).
3. Deductions & Fixed Costs: Fixed charges including Royalty values and flat Labor line costs.

Step 3: Calculating Excluded Costs and Proportions

When financial values are updated, the application triggers its calculate() matrix engine:

• Excluded Cost Calculation: The calculator identifies the core project index through the following formula:
  Excluded Cost = Total Work - (Asphalt + Pipe + Cement + Steel) - Royalty - Labor
• Proportional Distributions: If your net excluded baseline value remains positive, the system evaluates the internal proportions of your secondary allocations (Labor, POL, and Materials) relative to that value.

Proportional Distribution Warning: The system automatically verifies that the total percentage split equals 100%. If the aggregate total deviates from 100% by more than 0.05%, a warning alert will be displayed: ⚠️ Total: [Calculated Value]%. Re-adjust your inputs until the error alert disappears.

Step 4: Commit Changes & Trigger Cloud Sync

Once your values are finalized, click the Save action control.

• The system packages all form values alongside your calculated proportion metrics.
• The system updates your browser database file. Once verified, a non-blocking background POST request transmits the dataset directly to your designated cloud spreadsheet dashboard.

4. Control Functions Quick Reference

Interface Control Trigger	Underlying Javascript Macro	Operational Consequence
Save to DB	saveToDB()	Saves data locally, refreshes user interface tables, and transmits a mirror entry out to the designated Google Sheets cloud endpoint.
Edit (Table Row Button)	editProject(name)	Queries target indexes by name and populates active editing views with historical data metrics.
Export JSON	exportJSON()	Compiles all browser database files into a standard plain text file format, downloading it as projects_backup.json.
Import Data File	importJSON(event)	Reads an uploaded configuration backup array, merges records safely over matching local storage indexes, and updates your user interface.

5. Technical Safety & Operational Integrity

Data Retention Guidelines:

• Cross-Device Access: Local storage is limited to the current browser profile on your device. To populate fields across different workstations, use the built-in Export/Import options to migrate data files manually.
• Data Security: The integration features a fire-and-forget sync utility (no-cors mode). This architecture ensures rapid database updates without letting remote connection drops freeze your active browser tab.