Skip to content

Releases

Estimation M01 — Manual Google Sheets and Source Governance

Choose a tag to compare

@github-actions github-actions released this 13 Nov 09:02
45a6fea

Estimation M01 — Manual Google Sheets and Source Governance

Milestone date: 13 November 2026 (Asia/Kathmandu)
Release scope: First-party Estimation publishing-source baseline and manual-first source governance. This is a software/source-control milestone, not an approval of expenditure, measured quantities, BOQs, invoices or payable bills.

Frozen source and history

  • Canonical publishing branch: research/open-estimation-engine-v0.1
  • Git release tag points to publishing commit 45a6fea641008b1792abf140fea8c193110edf86 (PR #53).
  • Default-branch workflow-governance baseline: 0bbd6d90c1260ce07166f4f1a9141a34c653259d (PR #52).
  • A7 central pointer: PR #108 in FabinGurung/jp-a7-system-registry.
  • PRE/POST snapshot branches from 13 November preserve the prior and updated branch states.

Delivered

  • Estimation-owned Memory Wall memory-posters.html#google-sheets-fetched, public-safe data inventory V000005.
  • Six controlled working/reference Google Sheets: four authenticated import paths (Amrit rates, Amrit measurements, Krishna Kumar Gupta Finance, Fabin Gurung Finance); two references/template-only sources.
  • Read-only fetch-contract map with exact tab names, importer scripts, output artifacts, source role, and approval boundaries; private IDs and raw payment details excluded.
  • Two default-branch daily schedule triggers removed; workflow_dispatch manual actions preserved. Existing publishing-branch push deploy remains independent of interval-based source refreshes.
  • Fabin importer updated to accept the controlled V000004 top-summary revision; original normalized events remain V000001, with no payment approval granted.
  • Estimation PR CI successful for the source-map change. A7 validation/browser QA successful for its pointer change.

Known holds (not release blockers for the source-control baseline)

  1. Live GitHub Pages response and a fresh end-to-end authenticated source publication were not independently certified at this checkpoint. A successful prior PR CI is not proof of the current deployed website.
  2. The Vercel external status reported a build-rate-limit failure; this is independent of GitHub Pages and is not represented as a passing Vercel deployment.
  3. Basketball/Prithivi overlap: 19 cross-listed Prithivi detail transactions remain awaiting owner allocation and approval.
  4. Hari Baral NPR 500 top-summary arithmetic now reconciles after controlled Pabitra Ganesh Suppliers linkage; evidence and payment approvals remain pending.
  5. No unattended Google Sheet polling, cadence, new automatic entry system, or fully built step-test template is authorized. Source changes must be manual or explicitly prompted.
  6. Broader 34-Sheet cross-repository audit remains deferred and registered under Site Operations issue #36.
  7. Vendor Bills / bill_of_vendor source inventory, project/vendor allocation and bill-evidence workflow are the next distinct module to assess. Original Excel and legacy native Google Sheet are preserved; do not silently promote historical copies or prototypes into current authority.

QA and recovery rule

Use original Google Drive files for human truth; GitHub commits for code and public-safe projections; Actions for scoped validators; Pages for read-only presentation. Do not mutate original source data during a milestone tag. Treat the tag as immutable. Future finance/bill work begins a new governed change set with explicit PRE/POST, source lineage and approvals.

Useful paths

A9 Cost Estimation v0.10.0 — Human Sources, Ownership and Browser QA

Choose a tag to compare

@github-actions github-actions released this 09 Nov 11:26
478a00f

A9 JP Cost Estimation — v0.10.0

9 November 2026 · Source-governed prerelease · Cost Estimation repository only

What changed

  • Human-readable original working spreadsheets: renamed exactly the same five original native Google Sheets and their Drive folder. All permanent IDs, worksheet tab keys, formulas, data, permissions and version histories remain as before. The website source catalogue now displays their human titles and explains what to fill in each.
  • Clear ownership separation: Rate references, project measurements/BOQ/AOC and actual Finance stay in Cost Estimation. The public Finance selector no longer offers individual worker/attendance/capture workbooks as payment registers. Labour, worker Money & Goods and field capture remain with their existing original custodians and are linked to Field and Desk resources; maps and Slack/Discord-derived daily progress remain with the Communication/Progress workstream. Neither other repository was modified.
  • Slim N/W/E/S website: preserved 71 registered routes and four-direction navigation. The current branded layout and its historical cost/finance calculations remain working.
  • Browser-quality evidence: automated 27 of 27 real Chromium page/viewport checks passed against the source, and 27 of 27 passed against the actual published site (9 routes × desktop 1440, mobile 390 and tablet 820). Screenshots and machine-readable report are attached to GitHub Actions for 30 days; these are emulated viewports, not physical-device manual tests.
  • Daily LIVE source publication: main now owns the daily 06:32 Nepal time workflow dispatch to the single research-branch Pages publisher (which already owns WIF authentication, source validation, JSON staging and Pages publishing). Initial push-triggered dispatch and the actual target Pages build passed. No PAT, password, new Sheets database or duplicate Pages publisher was created.
  • Release governance: this tag freezes the audited tested source commit 478a00fb513ebf29a02cd0687673db15d6e4161a. Changes to the release records and workflows made after this source commit are versioned but do not alter that frozen source revision.

Verified evidence

Gate Result GitHub Actions
Estimation CI, all 71 routes Passed https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42607859733
Source-branch Pages deployment Succeeded https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42607859713
Source-rendered Chromium browser QA 27/27 passed https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42607859756
Daily Pages workflow dispatch (first test) Succeeded https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42607882654
Dispatched LIVE Google Sheets → Pages run Succeeded https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42607894761
Published-site Chromium browser QA 27/27 passed https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42608296229

Actual Pages URL: https://fabingurung.github.io/JP_Cost_Estimation/
Source folder: https://drive.google.com/drive/folders/1v0yTowZ8mbTtT7euPgrPeEndFKPPH0IU
Live-browser screenshots: https://github.com/FabinGurung/JP_Cost_Estimation/actions/runs/42608296229/artifacts/13668124257

Verified commercial boundary and holds

  • Finance source adapter reported 27 vendor groups, 74 payment rows and NPR 268,798 from the separate KKG/Rohini source; that is not an Amrit payment total.
  • The Amrit project remains at 0 verified measured quantities and 0 approved selected rates. No certified BOQ, AOC, bills or total are invented.
  • JP_Field_and_Desk_Resource_Library and JP_Communication-Command-Centre-and-Resource-Hub are handover targets only; this release does not change them.
  • First actual time-triggered future cron refresh has not yet occurred; only the identical path-filtered initial dispatch has passed. Physical-device/manual visual QA beyond nine routes remains a separately distinguishable check.

How to resume

  1. Open the five original working Google Sheets (the permanent IDs did not change) and enter verified project evidence in the appropriate workbook.
  2. For Amrit, write approved drawing-revision quantities to 01_MEASUREMENTS and approved matched unit rates to 02_RATE_SELECTIONS, keeping verification statuses and source links.
  3. Use the shared Cost Estimation Pages/Actions; source-admission logic refuses to manufacture QTO/BOQ/AOC/paid amounts without evidence.
  4. Read docs/REPOSITORY_BOUNDARIES_AND_SHEET_FILLING.md for exact record rules and cross-repository ownership.

Previous prerelease v0.9.0 and all old Git history remain available.

A9 JP Cost Estimation v0.9.0 — LIVE Sheets, Memory Wall and Amrit intake

Choose a tag to compare

@github-actions github-actions released this 09 Nov 02:31
5a20ba6

A9 / JP Cost Estimation — Milestone v0.9.0

Testing-period prerelease / source-governed infrastructure checkpoint — 9 November 2026.

Frozen exact website source: 5a20ba6db016bdae005d3048c2ea116a0dd942f6 on research/open-estimation-engine-v0.1.

Verification on that exact commit: CI run 42539475582 and Pages deployment 42539475453 both succeeded.

What is saved

  • 71 governed website routes, six site departments, the existing attractive Memory Wall with searchable posters, human-readable history and machine-readable checkpoint V000001.
  • Five original LIVE Google Sheets, preserved IDs, centralized in the existing restricted Edit Here folder. No parallel source system created.
  • Existing project just-a-project-5007: one Google Workload Identity provider for eligible FabinGurung public repositories on main; original Communication & Web rule and an explicit JP Cost Estimation branch exception preserved. Finance-capable and public-only Google identities remain separate.
  • Authenticated Finance publication: verified 27 vendors, 74 payments, NPR 268,798, belonging to the separate Rohini / Krishna Kumar Gupta / Bishal Paija source. Not an Amrit cost estimate.
  • 32 Amrit indicative rate entries (14 plinth, 12 trade, 6 wage), version V000001, source authenticated and unchanged; not engineering-approved unit rates.
  • 26 reusable measurement methods plus the single governed Measurement → BOQ → AOC → bills framework.
  • NEW Amrit LIVE measurement intake: the original nine-tab Amrit costing Sheet is authenticated read-only during Pages deployment; strict project identity, evidence, revision, verification and approved-rate gates produce only a derived public website projection.

Actual engineering state — HOLD

The authenticated Amrit measurement intake in run 42539475453 reported 0 verified measurements and 0 approved rate selections. There is no accepted Amrit BOQ, approved AOC total, certified running bill, vendor invoice, or payment allocation. Empty is deliberate: no fabricated quantities, no use of another project's CAD or finance records.

The source adapter checks row structure, source references, approval declarations and source admission, not independently the engineering adequacy or correctness of external drawing geometry. Do not represent the adapter as design verification.

Next work in this thread: 14_Amrit Rawat

  1. Locate/verify Amrit's actual approved drawing revision, grid/FID/element source and measured quantities. If absent, keep the engineering hold.
  2. Preserve the permanent LIVE Google Sheet ID and enter only evidenced items into 01_MEASUREMENTS, with IDs, units, revisions, source references and reviewer approvals.
  3. Match approved, compatible scope/unit prices in 02_RATE_SELECTIONS; never assume the 32 indicative entries are approved.
  4. Re-run authenticated Pages source projection; inspect draft BOQ source lineage. Keep AOC and billing gated by separate human acceptance.
  5. Validate future unattended refresh and real-device web usability.

Audit and rollback

  • User-facing Memory Wall is a dated 7 November checkpoint, not live telemetry.
  • Source intake contract.
  • Pre-release restoration branch.
  • Prior v0.8.0 and older tags/releases preserved; no force-push, removal or history rewrite.
  • The release notes and JSON asset were authored as a milestone record after the frozen source commit. The tag intentionally points to the CI- and Pages-tested source, not the administrative release workflow commit.

Source of truth: original Drive/Sheets for mutable evidence, versioned GitHub for code and approved public derivations; actual bills only from separately admitted sources. This prerelease is not a professional engineering sign-off.

Website milestone v0.8.0 — shared presentation and reference wall

Choose a tag to compare

@github-actions github-actions released this 20 Oct 11:49
4c9928e

JP Cost Estimation — Website Milestone v0.8.0

Status: Public website snapshot from 2026-10-20; testing-period prerelease.

Frozen website source: 4c9928ed02d0c8a193df4e0e4f0d273994b192d3 on research/open-estimation-engine-v0.1.

Verification: Estimation CI 39368416437 and research preview 39368416492 succeeded on this exact source. GitHub Pages deployment 39368463189 succeeded using the main deployment workflow that checked out the research source.

Included

  • Shared responsive presentation and global navigation
  • Rate source collections, personal working rates, MEP construction stages, rate comparison and contractor reference pages
  • Company finance overview and detailed payment dashboard using a published, validated snapshot
  • Memory Posters and the system map

Important boundaries

  • Google Sheets remains the editable payment source; public JSON is a static publication snapshot.
  • Rate collections and company payment records remain separate.
  • This tag preserves a specific historical website source. Later page maps, workflow simplification and navigation changes are separate follow-on changes.
  • No private access control is provided by GitHub Pages.

Reference

M03 · Approved Contractor Views & Numbered Personal Library (v0.5.16)

Choose a tag to compare

@github-actions github-actions released this 13 Oct 02:53

M03 · Approved rate-library and contractor views (v0.5.16)

User-approved website milestone, frozen at commit 84f7595adaa5c187b88b75ac186576624212c8f4 from website/rate-labels-enumeration-20261013.

  • Personal rate library: four columns with S.N. numbering, including inline Mechanical/Electrical/Plumbing views; numbering continues across pagination.
  • Contractor index: 158 source-specific work-item/variant readings with short editorial labels, search and page/unit filters.
  • Item details retain full descriptions, Norms No., Specification Clause No., units, rates, source-page previews and actual PDF links.
  • Contractor table wrapping prevents descriptions overlapping unit/rate columns.
  • Earlier evidence explorer retains all 9,574 numeric candidates and 234 page transcripts.
  • Frozen M02 raw extraction and full contractor reading projection remain unchanged; rates and other departments were preserved.

Evidence and interpretation

The evidence page is the earlier machine-extracted numeric-cell/transcript presentation, preserved separately from the readable item index. It is not the original PDF itself, and its numeric candidates include values whose roles may be coefficients, quantities, serial numbers or prices. The item index is a derived summary-row assembly; its short labels are another keyed editorial overlay.

Full semantic source verification remains pending; four item rates remain unresolved. This prerelease freezes the approved website experience, not an approved engineering rate master.

Version anchors

  • Annotated tag: v0.5.16
  • Frozen product commit: 84f7595adaa5c187b88b75ac186576624212c8f4
  • Approved iteration branch: website/rate-labels-enumeration-20261013
  • Previous contractor iteration: 80863e5c8c2e4f161187abac5ea74bb6df6fd2d3
  • Frozen raw baseline M02: 80a3650e8de3be1488b742f79246620543d2cffc

The tag must never be moved. Future edits should create a new iteration branch and a subsequent version, retaining this milestone for rollback.

Completed checks

Estimation CI 38336448230, research-preview validation 38336448304 and deployment 38336477275 succeeded. Published changed assets were read back and matched the authored files.

Source archives are available automatically through this release. The attached JSON manifest records the frozen commit, scope and evidence runs.

M01 · Rate Library, Construction Journey & Inline MEP (v0.5.12)

Choose a tag to compare

@github-actions github-actions released this 11 Oct 02:57

JP Cost & Rate Intelligence — Milestone M01

Rate Library, Construction Journey & Inline MEP · v0.5.12

Release classification: Functional pre-release milestone (not certified rates or production-approved estimating software).
Scope freeze: 2026-10-11 (Nepal local date).
Source commit: 726d60538b390e2a944f87d3a389be4bf30e93c8
Website: https://fabingurung.github.io/JP_Cost_Estimation/
Rate Library: https://fabingurung.github.io/JP_Cost_Estimation/rate-library.html
MEP stage: https://fabingurung.github.io/JP_Cost_Estimation/rate-library.html?stage=mep

What this milestone freezes

  • A human-readable Description of Work | Unit | Rate (NPR) catalog; concise, emoji-supported item labels with an original-description drilldown.
  • An illustrative, filterable construction sequence from site preparation / excavation → soling → PCC → reinforcement / formwork → RCC → masonry / openings → MEP → finishes. It is navigation, not a project-specific construction schedule.
  • MEP is a child of the Rate Library. Mechanical, Electrical and Plumbing are in-page switches, never separate user-facing workspaces; clicking a trade filters the existing rate table without leaving the page. Stable deep links: ?stage=mep&trade=mechanical, ?stage=mep&trade=electrical, ?stage=mep&trade=plumbing.
  • The selected MEP work-item groups contain 3 Mechanical, 37 Electrical and 22 Plumbing/Sanitary entries per Excel worksheet set (62 distinct MEP entries per set). Exhaust fan appears under Mechanical for navigation but retains its original Electrical worksheet identity.
  • Search uses both concise names and full source text, including cut piece → CUTPIECE normalization; mobile column wrapping/legible prices, sorting, pagination, category filters and SI/Imperial converted rate-per-unit display.
  • A separate Work Specifications detail page shows exact source wording and Excel provenance, distinct from educational workmanship/quality prompts. SI/Imperial display is mathematically derived from original NPR, without currency exchange.
  • Existing standalone mep.html and trade URLs redirect to the equivalent in-page views; source IDs and older Git branches remain retrievable.
  • Existing Rate Analysis and Rohini Finance remain separate and preserved.

How the project reached this milestone

Development checkpoint Capability or correction
v0.5.1–v0.5.3 Sunlit valley Rate Portal and extracted three-column workbook price index
v0.5.4 Short titles and complete original-work-description pages
v0.5.5 Editorial work taxonomy and visible/hidden worksheet rate comparison
v0.5.6 Improved rate alignment, normalized searching and SI/Imperial calculations
v0.5.7–v0.5.8 Emoji construction journey, quality-guidance separation and truthful Excel worksheet terminology
v0.5.9–v0.5.10 MEP grouping, deep-link context and automated regression coverage
v0.5.11 MEP relocated under Rate Library construction journey
v0.5.12 — M01 Mechanical, Electrical and Plumbing switch in the same Rate Library table; old routes redirect

Earlier version numbers are descriptive development checkpoints, not fabricated prior GitHub Releases.

Provenance and limitations

  • 204 unchanged historical estimate-rate observations: 102 visible-worksheet + 102 hidden-worksheet alternatives, housed in the same Excel workbook; their revision chronology is unknown. The alternative sets differ on four item rates.
  • Source year, region and approval status are unverified. These are not government schedules, current supplier quotations, contractual/approved rates, or measured CAD/FID quantities.
  • The source Excel workbook and financial authorities reside separately; the website only projects a public-safe derived subset. Public source records do not assert client identity or expose bill quantities.
  • No migration or mutation of master rates, Rohini financial records, CAD geometry/quantity takeoff, blocked BOQ readiness, source PKs, or source prices was part of the release.
  • Outstanding: real tablet/mobile visual acceptance, rate-source verification, engineering approval, live financial synchronization, BOQ/QTO population, and production-hardening.

Evidence and rollback

  • Estimation CI: successful run 38093014816.
  • Research Preview QA: successful run 38093014818.
  • GitHub Pages deployment: successful run 38093060021. Deployment ran from main but checked out the pinned research-source branch at the source commit above.
  • Regression: scripts/qa_mep_site_v0.5.10.mjs on the pinned source.
  • PRE rollback: snapshot/pre-inline-mep-tabs-v0.5.12-20261011 (prior candidate).
  • POST rollback: snapshot/post-inline-mep-tabs-v0.5.12-20261011 (this frozen source).
  • Tag: v0.5.12, an annotated Git tag pointing to the source commit, not the later release-metadata or Pages trigger commits. The GitHub Release is a pre-release, not a certified engineering release.

This is a milestone freeze. Future modifications require a new version and another audited release rather than changing this tag.