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.
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.
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.
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.
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.
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.
Eight working/reference Sheets are registered: four established authenticated import paths, two deliberately manual-only readers (Vendor Bills and Contractor Bills), and two reference/template books. Contractor Bills has passed an authenticated read; Vendor Bills uses the same existing Google publishing identity. Each optional source card checks its current deployed status JSON so a verified snapshot is never mistaken for an authenticated read.
4 VERIFIED PATHS2 OPTIONAL MANUAL2 REFERENCES
MANUAL-FIRST MODE: Edit original Google Sheets by hand, or explicitly prompt an operator to prepare a controlled revision. Refresh using GitHub Actions Run workflow or a user-authorized website commit. No cron / unattended interval. No automated data-entry template or step-test system has been approved yet.
Loading the eight-Sheet source inventory…
Reading source roles and configured import paths…
Manual update procedure — what to ask next time
Edit the existing owner-designated LIVE Sheet; never create a second editable authority or overwrite source evidence.
Preserve a numbered A7 PRE → edit → inspect/reconcile → POST history; maintain stable file ID and explicit approval status.
For Vendor Bills, the repository's JP_VENDOR_BILLS_SHEET_ID source setting and the publishing identity's read access must be verified before a separately requested manual research Pages refresh. Push deployment is only a verified snapshot.
Check the exact Actions run log, public-safe output, publication commit and live Pages rendering. A successful old run is not evidence of today's refresh.
No private source Sheet IDs, raw payment transactions, credentials or permission details are embedded in this Memory Wall. Google Drive is the human source of truth; GitHub tracks transformation and derived publication. A7 only routes to this Estimation-owned record.
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.
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.
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.
VERIFIED07 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.
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.