Salt Lake Validation
Test Case
Salt Lake Expansion is Craig’s second reference project. Same site size (Mini) but different scope toggles than Church Lane — tests our scope consideration logic.
Source Files
| File | Path |
|---|---|
| Spreadsheet | /home/chas-watkins/Downloads/WIT project/craig-examples/IND_Salt_Lake/241223_IND_Salt Lake Expansion CE_v0.2(CC).xlsx |
| Reference PDF | /home/chas-watkins/Downloads/WIT project/craig-examples/IND_Salt_Lake/250107_IND_Salt Lake Expansion_DB_v0.2(CC).pdf |
Project Inputs
Region: ASA (India), Site Size: Mini, Headcount: 15, Sqft: 523, 1 Floor, Tier 1, WiFi Centric, Test Fit, Refurbishment / Relocation and Refurbishment.
9 building blocks on Floor 1 (includes decimal quantity: Team Storage = 3.12).
Scope Overrides (4 non-defaults)
| Toggle | Value | Default |
|---|---|---|
| WiFi Heatmap | included | not included |
| Voice Allowance | not included | included |
| Servers | not included | included |
| Cabinets and Racks | not included | included |
Results (Including Network)
| Row | Our App | Match | Explanation | |
|---|---|---|---|---|
| Network Equipment (E) | $27,960 | $15,654 | NO | Missing retail block mappings |
| Network Services (O) | $0 | $0 | YES | Voice excluded |
| Workstation Tech | $0 | $0 | YES | |
| AV/VC Solution (E) | $12,206 | $0 | NO | Missing retail block mappings |
| IoT | $0 | $0 | YES | |
| Servers | $0 | $0 | YES | Excluded |
| ITO (O) | $5,024 | $1,957 | NO | Cascades from equipment |
| PMS (O) | $55,877 | $25,000 | NO | Craig used Small PMS on Mini site |
| Design AV/SCS (O) | $10,000 | $10,000 | YES | |
| Design WiFi (O) | $2,000 | $2,000 | YES | Scope included |
| PPS (O) | $1,005 | $0 | NO | Cascades — our base under $25K |
| Contingency © | $5,880 | $5,000 | NO | Possible formula issue or override |
| Decommissioning © | $0 | $0 | YES |
9 of 15 rows match (up from 7 in Church Lane).
Key Findings
- Scope toggles work perfectly — Voice=$0, Servers=$0, WiFi=$2,000 all correct
- Same root causes as Church Lane — Missing block mappings and PMS override
- Network Equipment identical — $27,960 in both (same Mini site size)
- PMS nearly identical — $55,877 vs $55,876 (both Mini/ASA/India)
- Contingency = $5,880 — doesn’t match our MAX(5%, $5K) formula
Schema Fix Required
project_floor_items.quantity was INTEGER — changed to NUMERIC(10,2) to support decimal quantities like 3.12.