Validation Status

Formula verification across multiple test projects — Craig's answers received

Overall Progress

Metric	Value
Projects Validated	2 of 5 (Church Lane + Salt Lake)
Issues Tracked	8 total
Issues Resolved	6 resolved
Remaining Blockers	1 — equipment mappings
Craig's Response	Received 2026-02-22

Craig's Answers

Question	Answer	Action
WS Install $633	Manual override	No change
PMS $55,876	Fee by project size tier	Fixed — updated 5 tiers
WiFi Heatmap	His mistake	No change
Servers $0	His mistake, rarely used	No change
Decommissioning	From DECOM SUMMARY tab	Implemented
Block mappings	"Need to get back to you"	Waiting

Fixes Applied (2026-02-22)

BAU Formula — Changed from 60% of Equipment to 60% of CAPEX

PMS Fee Schedule — Updated site_sizes.pms_fee: Mini=$25K, Small=$55,876, Medium=$111,752, Large=$223,400, XL=$297K

Decommissioning — Full implementation: 9 activity types, per-project quantities, scope-aware calculation

Decimal Quantities — project_floor_items.quantity: INTEGER to NUMERIC(10,2)

Test Projects

Church Lane (ID 3)

Mini Site, ASA/India, 13 headcount, 10 blocks. Decom: 9 desks = $450. Match rate improved after fixes — remaining gaps are block mappings + Craig's overrides.

Salt Lake (ID 5)

Mini Site, ASA/India, 15 headcount, 9 blocks. 4 scope overrides all correct. 9/15 rows match. Same blockers as Church Lane.

23-25 MGR (ready)

Small Site, New Build. Will test different site size, network design, and PMS tier. Not yet entered.

BCP Strategy S1-S3

3 spreadsheets from IDN (Indonesia). Not yet analyzed. May test different region pricing.

Verified Formulas

Formula	Implementation	Status
Installation	25% of Equipment	Verified
BAU	60% of CAPEX	Fixed + Verified
ITO	10% of (E+I)	Verified
PPS	2% of (E+I) if > $25K	Verified
PMS	Fee by site size tier	Fixed
Decommissioning	9 activities x qty x rate	Implemented
Scope Toggles	9 toggles	All working
Contingency	MAX(5%, $5K)	Under review

Single Remaining Blocker

Six retail/branch banking building blocks (IDs 70, 74, 75, 78, 81, 82) have zero equipment mappings in the database. This causes AV/VC = $0 and Network Equipment undercounts. Craig said he needs to get back to us on this. Once resolved, the majority of remaining mismatches will clear up.

Church Lane Details | Salt Lake Details | All Issues | Back to WIT PropTech