JP / PROJECT REFERENCE ROOM

The memory wall.

The project-owned source register: which Google Sheets our engine reads, what remains reference-only, and how to refresh everything manually. Older verified checkpoints and original learning posters remain preserved below.

← Back to the project overview

A7/A9 · ESTIMATION / SOURCE-TO-PUBLICATION TOOL ARSENAL · 17 NOVEMBER 2026

What we already have, what each tool can do, and where the data belongs.

These systems are already deployed and working; no new service account, standalone database, duplicate editable register or scheduled refresh is required to read an authorized Google Sheet. The original Google Sheets remain authoritative and any source change follows numbered A7 full PRE → same LIVE ID → QA → POST.

1. Google Drive + Google Sheets

Eight governed working/reference Sheets: Krishna Kumar Gupta V1.1, Fabin Payments, Vendor Bills V000004, Contractor Bills V000002, and Amrit/rates/reference books. Original invoices, measurements, project allocations and the full private audit Docs live in Drive. Each source has one canonical LIVE ID; Krishna was intentionally migrated to a NEW clean ID while its former V0.5 source was archived. Archives are not alternative working authorities.

Open the owner-controlled source directory →

2. ChatGPT + connected Drive editor

With the user's permission the connected Google Drive/Sheets tools can directly read cells, inspect formulas, reorganize tabs, move files, maintain versioned PRE/POST copies and append audit Docs. This interactive access is different from GitHub Actions' cloud identity; a chat being able to read a Sheet does not itself give a GitHub runner permission.

3. Existing Google Cloud Workload Identity

Google Cloud project just-a-project-5007 already provides keyless GitHub federation to jp-pages-publisher. The runner obtains a short-lived scoped Google token and must have Viewer permission on each private source workbook. Vendor and Contractor LIVE readers now reuse these grants; no new account or source-ID secret is mandatory when an exact unique title is discoverable.

4. GitHub — versioned source and QA

FabinGurung/jp-estimating-and-boq owns finance source adapters, public-safe source map data/connected-website-sheets.v1.json, per-source aggregate contracts, application pages and CI tests. The publishing branch is research/open-estimation-engine-v0.1. A7 is a navigation and governance pointer, not a duplicate financial ledger.

Inspect owning Estimation repository →

5. Python source readers and reconciliation

build_finance_from_google_sheets.py reads Krishna; build_fabin_finance_from_google_sheets.py reads Fabin; build_vendor_bills_public.py and build_contractor_bills_public.py read aggregate-only Vendor/Contractor records. Amrit's separate measurement/rate readers remain in place. Every importer validates its own grain and source constraints before publishing a safe summary.

Read full tool and importer inventory →

6. GitHub Actions → static GitHub Pages

deploy-research-pages.yml already authenticates to Google, reads existing finance/Amrit sources, tests the generated output and publishes Pages. Vendor and Contractor reads are explicitly opt-in via workflow dispatch or a user-approved marked release, not by a timer. The deployed sourceMode reports MANUAL_AUTHENTICATED_READ only after the real source passes validation; ordinary commits retain the checked VERIFIED_SNAPSHOT.

Open the manual GitHub Actions workflow →

Separation: Google Sheets = human authority; A7 PRE/POST = reversible audit history; connected ChatGPT = authorized interactive editor; Google WIF = private read permission for unattended runners; GitHub Actions = explicit read/QA/publication; GitHub Pages = versioned static presentation; Field & Desk Resource Library = scanned evidence/document custody. No payment, vendor bill or contractor claim becomes commercially approved merely by passing an arithmetic check.

ROHINI ENGINEERING / KRISHNA KUMAR GUPTA · KKG V1.1 / A7 CONTROL V000002

One clean Bishal Paija source: 27 vendor mini-tables with linked amount, discount and QR.

The old 20-tab V0.5 workbook was fully archived after an A7 PRE, and a NEW native V1.1 LIVE workbook was established with exactly Total, Bishal Paija, and 00_SYSTEM_MEMORY. The user edits source payments directly inside 27 vendor-specific mini-tables; their footers drive clickable vendor summary values and the master project/vendor rollups. All 74 original payment entries and 27 vendor groups reconciled with no field differences. Full V000002 PRE/POST, original audit, private workbook URLs and raw payment evidence live only in restricted Cost Estimation Drive. Source-recorded, NOT bank/tax-certified. Existing Google WIF identity and read-only exact-title source discovery require an authenticated Pages-run readback before claiming current website freshness; no cron.

Read the governed KKG V1.1 source and mini-table update rules →

COST ESTIMATION / FINANCE

Vendor Bills & Supplier Invoices

V000004 human-first QA — 14 November 2026. The permanent LIVE working register is in the Cost Estimation working Sheets folder. Its 46 tabs now start with the guide and three original projects, followed by 30 original supplier tabs; two ambiguous source tabs are retained, and eight normalized/review tables plus controls are at the back. All 35 original source tabs and 1,895 indexed rows are traceable. 509 flags remain OPEN; no bills approved. The published status directly below distinguishes Verified snapshot from Manual source read; only a verified authenticated Google Sheets read may claim the latter.

Loading Vendor Bills status…

Source history

The original working Google Sheet retains its permanent ID. A7 V000004 whole-workbook PRE and POST archives have been verified. The complete human-readable QA and change-history Google Doc is now stored beside the LIVE working Sheet in the same restricted Drive folder.

Evidence review

The original source-index row and normalized bill/detail IDs have been checked. There are no orphan bill-to-line pointers. Supplier/project source comparisons still include two unresolved differences, and evidence issues such as missing invoice numbers and unverified dates remain. Original invoice values, source formulas and statuses were not rewritten.

Manual refresh

Refreshes are manual only. V000004 currently means a verified aggregate snapshot, not an authenticated import. Manual source read will only appear after the separate read-only authenticated GitHub Actions step succeeds with authorized private Google Sheet access.

Read the V000004 human-first QA and source-contract checkpoint →

COST ESTIMATION / CONTRACTOR WORK CLAIMS

Contractor Bills & Running-Account Evidence

V000002 contractor QA — 16 November 2026. The existing permanent native working Google Sheet was renamed and moved into the Cost Estimation source folder without changing its ID. Six original source tabs and all original formulas are retained; ten new human/normalized views show two claim summaries, 33 primary work lines, 34 historical non-additive lines, five source comparisons and 16 OPEN review issues. The primary 33-line claim and source subtotal agree arithmetically; no claim is certified, and no payment is proven. The published status below displays Manual source read only after a successful authenticated workflow; normal code releases retain the checked aggregate snapshot fallback.

Loading Contractor Bills status…

One controlled working Sheet

The original six source tabs, two original control tabs and ten normalized review tabs coexist in the same permanent Google Sheet. V000002 full native PRE/POST copies and a detailed private QA Google Doc preserve the source history; old duplicate views are indexed as evidence and never summed again.

Hold: certificate and payment evidence

The 16 review issues remain OPEN. Rates, measured quantities, work dates, project/contractor identities and signed running bills still need manual verification. A zero-valued Hari Baral source formula points to Rate rather than Amount and is flagged but preserved, not silently corrected.

Manual read-only projection

GitHub can publish a Verified snapshot · V000002 without accessing the private Sheet. A separate authenticated source read is optional on explicit manual GitHub Actions dispatch and uses the existing viewer-authorized Google publishing identity, discovering the uniquely named LIVE Sheet via read-only Drive metadata. The private `JP_CONTRACTOR_BILLS_SHEET_ID` secret is optional. A live read occurs only on explicit manual workflow selection or an authorized marked release push. No cron or automatic approval.

Read the public-safe V000002 source-contract and QA checkpoint →

CHECKPOINT / 07 NOVEMBER 2026 · PRESERVED 08 NOVEMBER

Where we left off.

Historical 7 November checkpoint (preserved, not current). The foundations work. Google Sheets authenticate, Finance and Amrit rates refresh, and Pages deploys. The next unlock is verified project measurements before any real Amrit BOQ, AOC or bills.

VERIFIED 07 NOV 2026 · not a live feed
71Registered web pages
5Original Google Sheets
32Amrit indicative rates
26Measurement methods
01 / WORKING

Google → GitHub → Website

Shared keyless Google identity is configured. All five Sheets passed read-only authentication. Finance refresh, Amrit rate sync, CI and Pages deployment passed.

Finance: 27 vendors · 74 payments · NPR 268,798 in the separate Bishal Paija / KKG source—not an Amrit cost estimate.

Finance view →
02 / STILL ON HOLD

No invented quantities.

Amrit has 0 admitted measurement rows, 0 BOQ rows, 0 running bills and no approved AOC total. Rates are indicative, not certified.

Templates and work methods are ready; project evidence and approvals are not.

Amrit project →
03 / WHAT COMES NEXT

From drawing to cost.

  1. Verify unattended scheduled source refresh. Superseded 13 November: manual updates only.
  2. Admit measured CAD/drawing/FID quantities.
  3. Derive BOQ → AOC → bills only after review.
  4. QA navigation and layout on mobile + desktop.
Measurement workflow →

Historical note, superseded by the manual-first source register above: all FabinGurung public repositories using main are eligible for the new public-only Google identity, but no Google Sheet permissions are automatically granted. This is an archived evidence checkpoint, not a live tracker. Open machine-readable memory →

THE REFERENCE BOARD

The reference posters.

The original posters remain here, with new checkpoint reminders added. Filter by category or search for a rule.

Loading posters…