Free PropTech Tool #3 • Vacant-Unit Leak & >1.5x Spike Detector
Open Portfolio Reconciliation Grid →Apartment Utility Variance & Vacant-Unit Leak Auditor
Automatically flags apartments where monthly utility bills exceed 1.5x the trailing 6-month average or where a VACANT unit exceeds €15.00.
| Door & Occupancy | Utility | 6-Mo Trailing Avg | Current Bill | Ratio | Detected Anomaly Flags |
|---|---|---|---|---|---|
| Apt 88 (VACANT) | Cold Water (m³) | €21.50 | €64.20 | 2.99x | ⚠️ HIGH_VARIANCE_SPIKE (>1.5x)⚠️ VACANT_UNIT_USAGE (>€15.00) |
| Apt 4B (OCCUPIED) | District Heating (MWh) | €72.00 | €128.40 | 1.78x | ⚠️ HIGH_VARIANCE_SPIKE (>1.5x) |
| Apt 14 (OCCUPIED) | Electricity (kWh) | €48.00 | €51.20 | 1.07x | ✓ Normal Range |