SiteCore BOQ Engine
7 IS-Metric Construction Calculators & Local Project BOQ Engine (`sitecore_v1`)
Role & Context
Creator & Lead Systems Engineer
Verified Static SPA (`/demos/sitecore/`) + Public Overview (`sites.google.com/view/sitecore-ak/`)
Built-In Calculators
7 IS-Metric Tools + ft/in Helper
Core Workflow
Calculate → Explain → Save → Price → Work
Local Persistence
IndexedDB (sitecore_v1) · JSON / CSV Backup
Scope Boundary
Estimation Aid Only (Not Structural / BBS)
Formula: Vg = L × W × T ; Vn = Vg − D ; Vo = Vn × (1 + waste% / 100)
Audited Concrete BOQ Breakdown
Net BOQ Volume (Vn)
3.800 m³
Order (+5% waste)
3.990 m³
Engine runs purely in TypeScript (`sitecore_v1` IndexedDB) with immutable snapshots.
Workflow · Calculate → Explain → Save to Project → Price → Record Work
All 7 Built-In SiteCore v0.1 Calculators & Golden Verification Checks
Slabs/beams/columns minus deductions · Ex: 5×4×0.125m = 2.500 m³
Bricks & wet mortar minus openings · Ex: 5×3×0.23m = 2.967 m³ (1,558 units)
1/2-face plaster + cement/sand · Ex: 2 faces @ 12mm = 25.8 m² (0.3096 m³)
N-coat paint area + 10% allowance · Ex: 12.9 m² × 2 ÷ 10 + 10% = 2.838 L
Whole tiles & boxes minus cutouts · Ex: 5×4m (600mm) = 62 tiles, 16 boxes
Circular rebar π/4×d²×7850×L×N · Ex: Ø12mm × 10m × 5 = 44.391 kg
Exact metric-imperial helper · Ex: 12 ft 2 in ↔ 3.7084 m
INR totals separated from physical units · OVERRUN (>100%) alerts · JSON/CSV
Estimation Aid Disclaimer: Quantities, mortar splits, and rates are geometric planning estimates only — not structural design, mix design, Bar Bending Schedules (BBS), BIS/byelaw compliance, or certified contractor billing. Always verify quantities against approved contract drawings.
Problem & Engineering Context
Site engineers and students rely on fragile spreadsheets that conflate nominal vs. actual brick sizes, sum incompatible physical units (m³, m², kg), skip opening deductions, or overwrite planned baseline quantities when logging daily progress.
Architecture & Key Implementation Details
- Core workflow (Calculate → Explain → Save to Project → Price → Record Work): saving stores an immutable baseline snapshot in browser IndexedDB (`sitecore_v1`), so later unit-rate edits or YYYY-MM-DD work logs never corrupt planned quantities.
- Strict unit discipline: physical quantities (m³, m², kg) remain separated; only priced items (INR / ₹) roll up into project cost, accompanied by OVERRUN (>100%) progress indicators and 1-click JSON/CSV backup & validated import.
- Auditable explanations with exact metric-imperial conversions (1 ft = 0.3048 m, 1 in = 0.0254 m) plus an explicit Estimation Aid Disclaimer: geometric planning estimates only — not certified structural design, mix design, Bar Bending Schedules (BBS), BIS/byelaw compliance, or contractor billing.
Key Deliverables
- All 7 Built-In Calculators (Concrete, Masonry, Plaster, Paint, Flooring, Steel, Geometry/Units)
- Instant DEMO-01 Loader (`Studio Residence — DEMO`), Itemized INR Pricing & OVERRUN Alerts
- Live Static App (/demos/sitecore/) + SiteCore Portal (sites.google.com/view/sitecore-ak/)