Construction Rate and Cost References
Enter reusable rate references, units, effective dates, locations and cited authority. A vendor quotation is not a government standard.
08 / ORIGINAL WORKING GOOGLE SHEETS
Every current connected, referenced or template Google Sheet lives in one original-file folder, following the Communication & Web approach. No duplicate authority created.
Open original Google Sheets folder ↗The Estimation Memory Wall tool arsenal records the working A7 PRE/POST source governance, connected ChatGPT Google Sheets editing, Google Cloud keyless Workload Identity, original-source Reader/Viewer grants, validated Python importers, GitHub Actions release gates and public-safe Pages. A ChatGPT session reading a workbook is not the same credential as GitHub Actions reading it later. Vendor/Contractor source reads are deliberately manual-only and fail safely when a source cannot be uniquely identified.
The source types and publication states are deliberately different. A linked or moved Google Sheet is not proof that GitHub Actions has authenticated to it. Archives and original CAD/PDF documents remain in their governed folders.
Loading source-role directory…
Use the eight original and working Google Sheets in the Cost Estimation folder above. Vendor Bills remains the seventh registered workbook, and Contractor Bills is now the eighth. Both retain their original native live Sheet IDs with evidence-backed normalized QA views; archive copies are outside this owner folder. Their file titles are written for people; the worksheet tabs and column headers have been left intact to protect the existing data integrations.
Enter reusable rate references, units, effective dates, locations and cited authority. A vendor quotation is not a government standard.
Enter or revise client-specific pricing assumptions. They remain indicative until the applicable source, unit and approval are verified.
Start with 01_MEASUREMENTS for drawing-referenced quantities; use 02_RATE_SELECTIONS for separately approved unit rates. The BOQ and cost summary are not certified merely because values exist.
Reference for creating future project workbooks. Do not post one client's actual measurements into the master template.
Three native human worksheets: Total displays one project and 27 vendor totals; Bishal Paija contains a vendor summary with hyperlinked Amount/Discount/QR and 27 directly editable vendor mini-tables; 00_SYSTEM_MEMORY holds rules, migration QA, A7 PRE/POST, legacy audit and publication status. 74 original payment events reconcile. Edit ONLY the appropriate vendor mini-table; the summary formulas update without Apps Script. The original 20-tab V0.5 and both V000002 copies remain privately archived; source arithmetic is not payment certification. The existing publisher uses a new exact-title read contract, not the retired Sheet ID.
Use 00_PAYMENT_SUMMARY for source-reported totals, 07_PARTY_DETAIL_VIEW to inspect project/party records and 06_REVIEW_QUEUE for unresolved discrepancies. All entries remain unverified until documented approval; the original Finance evidence is in Cost Estimation’s payment-register folder.
Start at VB_START_HERE. The three original project tabs come first, followed by 30 supplier tabs. Review bill details through VB_BILL_RECORDS and VB_DETAIL_ROWS; use VB_REVIEW_QUEUE for 509 OPEN evidence flags. Do not hand-edit derived tables, approve invoices or infer payment from a bill. Full A7 V000004 PRE/POST history and the detailed QA Google Doc stay with the restricted live working folder.
Start at CT_START_HERE, then inspect the original Hari_Chaudhari and Khem_Bahadur_Thapa tabs. Use CT_WORK_ITEMS for 33 primary work lines and CT_REVIEW_QUEUE for 16 OPEN QA issues. The 34 alternate/historical rows are explicitly non-additive. No claim, measurement or payment is certified. The Google Doc audit and V000002 PRE/POST are in restricted Drive, not public GitHub Pages.
Labour and daily attendance: Those original worker and site-capture Sheets are owned outside Cost Estimation. This site consumes verified aggregates only; see Finance custody boundary.
Read the Source ownership and workbook entry guide before starting a new project.
AUTHENTICATED FINANCE SOURCE · AGGREGATES ONLY
The original 20-section Excel workbook and the newer seven-tab v0.7 Excel source remain preserved in Google Drive. The native v0.7 working Sheet now has separate manifest, projects, party records, 439 source-row-linked events, reconciliation, source-reported project summary, review queue and version history. A complete PRE/POST archival pair is retained in private Drive custody.
The manual, read-only GitHub Actions importer checks normalized event/source-row coverage, project summary agreement and the controlled source version whenever an operator invokes the publishing workflow. The public Finance overview shows only source-reported per-project aggregates, clearly marked NOT VERIFIED. No transaction, vendor, source Sheet ID or private payment link is included.
V000004: Pabitra Ganesh suppliers was linked to the Hari Baral top summary, removing the earlier NPR 500 source-arithmetic discrepancy while preserving the PRE history. The Basketball/Prithivi duplicate source entries remain deferred; payment evidence, project identities and invoices are not approved. Amounts are not certified actuals and are not joined with Krishna Kumar Gupta. See review and admission rules.
VERIFIED SOURCE SNAPSHOT · OPTIONAL MANUAL GOOGLE READ
This is the seventh source/reference workbook, not a fifth proven always-on feed. The Cost Estimation repository owns its source-adapter scripts/build_vendor_bills_public.py, the data/vendor-bills-status.v1.json public-safe counts and the Estimation Memory Wall. GitHub Pages currently publishes Verified snapshot · V000004. The authenticated read is manual-only and uses the existing keyless Google publisher and its granted Viewer permission. It can find the unique exact-titled LIVE workbook via Drive metadata, without any new secret; JP_VENDOR_BILLS_SHEET_ID remains an optional private override. Use the research Pages workflow when a new source read is required; no cron.
The source file's ID and protected financial rows stay in the private working Drive folder. The original workbook's three project summaries, 30 supplier tabs, ambiguous historical tabs, normalized tables and control tabs are preserved, with a complete Google Doc QA audit next to the working Sheet. All 509 review flags remain OPEN and no payment is certified.
VERIFIED SOURCE SNAPSHOT · OPTIONAL MANUAL GOOGLE READ
This is the eighth original working/reference Google Sheet. Its permanent native ID was retained when the file moved to the Cost Estimation working folder. The 6 original source tabs and original formulas are preserved; 10 additional CT_* human/normalized views account for 2 source claims, 33 primary work lines, 34 non-additive historical records and 16 OPEN reviews. The source-reported main amount agrees with its primary work subtotal, but no signed certificate or payment is verified.
Cost Estimation owns scripts/build_contractor_bills_public.py, aggregate-only data/contractor-bills-status.v1.json, and the Contractor Bills Memory Wall. A prior authorized authenticated Contractor Bills read was verified on 17 November 2026; the public sourceMode changes between Manual source read and Verified snapshot depending on the last successful publication, not on whether a source ID exists. The optional authenticated import uses the existing Google identity with granted Sheet Viewer permission and fail-closed exact-name Drive metadata discovery (or optional private JP_CONTRACTOR_BILLS_SHEET_ID override) on an explicit manual research Pages dispatch. No cron, no contractor source-row amounts on the public website, and no second editable source.
Original Google Sheet IDs are unchanged; existing direct links and computations continue to identify the same files. Project archival folders and version histories stay in their original locations. The source folder is access controlled by Drive permissions, not GitHub Pages.
The former project-folder reader access on both Amrit LIVE workbooks was preserved explicitly after the move. Do not make the entire folder or finance workbook public merely to enable read-only Actions; use approved Workload Identity and source-level permissions.
The previous 1 November snapshot had no authenticated Actions connection. That limitation was resolved: the five-Sheet authentication check, LIVE Finance read and deployment and Amrit rate source check all passed. Amrit V000001 rate values did not change, so the snapshot was preserved without an unnecessary commit. The Amrit measurement/BOQ workbook has no populated measured quantities, rate selections, bills or payment mappings as of 9 November 2026. The manually invoked Pages build has a read-only authenticated measurement + approved-rate adapter that publishes explicit zero-admission status until engineering evidence is entered in the same original LIVE workbook. The AEC rate master and blank costing template remain reference sources, not authenticated website refresh feeds.
A connected Drive folder does not configure authentication by itself. Future source refreshes are manual via user-invoked GitHub Actions or a user-authorized publishing commit; there is no approved daily/interval schedule. A completed historic run is not current freshness evidence. Read the current Estimation-owned import Memory Wall →
Review GitHub Actions logs →