The Church Lane Expansion is Craig’s original reference project. We entered the same inputs from his spreadsheet into our web app and compared every output line against his PDF.
| File |
Path |
| Spreadsheet |
/home/chas-watkins/Downloads/WIT project/251124_IND_Church Lane Expansion CE_v0.2(CC).xlsx |
| Reference PDF |
/home/chas-watkins/Downloads/WIT project/251125_IND_Church Lane Expansion_DB_v0.2(CC).pdf |
Region: ASA (India), Site Size: Mini, Headcount: 13, Sqft: 3,296, 1 Floor, Tier 1, WiFi Centric, Test Fit source, Relocations and Restacks / Relocation and Refurbishment.
10 building blocks entered on Floor 1. Scope considerations all at defaults. Decommissioning: 9 desks.
| Row |
PDF |
Our App |
Match |
Explanation |
| Network Equipment (E) |
$27,960 |
$19,269 |
NO |
Missing retail block mappings |
| Network Services (O) |
$20,000 |
$20,000 |
YES |
|
| Workstation Tech (E) |
$733 |
$733 |
YES |
|
| Workstation Tech (I) |
$633 |
$183 |
NO |
Craig confirmed: manual override |
| AV/VC Solution (E) |
$23,530 |
$0 |
NO |
Missing retail block mappings |
| Servers |
$0 |
$1,000 |
NO |
Craig confirmed: his mistake, rarely used |
| ITO (O) |
$6,573 |
$2,625 |
NO |
Cascades from equipment gap |
| PMS (O) |
$55,876 |
$25,000 |
NO |
Craig confirmed: used Small PMS on Mini site (override) |
| Design AV/SCS (O) |
$10,000 |
$10,000 |
YES |
|
| Design WiFi (O) |
$2,000 |
$0 |
NO |
Craig confirmed: his mistake |
| PPS (O) |
$1,315 |
$525 |
NO |
Cascades from equipment gap |
| Contingency © |
$5,000 |
$5,000 |
YES |
|
| Decommissioning © |
$450 |
$450 |
YES |
Fixed: 9 desks x $50 |
| Category |
Rows |
Root Cause |
| Missing data |
Network Equip, AV/VC, ITO, PPS |
Retail block equipment mappings not imported |
| Craig’s manual choices |
WS Install, PMS, WiFi Heatmap, Servers |
Confirmed by Craig as project-specific overrides/mistakes |
| Our formulas correct |
All matching rows |
Installation 25%, BAU 60% CAPEX, Contingency, Design, Voice |
| Formula |
Proof |
| Installation = 25% of Equipment |
Network: $6,990/$27,960 = 25.0%, AV: $5,883/$23,530 = 25.0% |
| BAU = 60% of CAPEX |
Network: $20,970/$34,950 = 60.0%, AV: $17,648/$29,413 = 60.0% |
| ITO = 10% of (E+I) |
$6,573 = 10% of $65,729 |
| PPS = 2% of (E+I) if > $25K |
$1,315 = 2% of $65,729 |
| Decommissioning |
9 desks x $50/desk = $450 |