Front Range unit map Signature view
Every unit under management as one cell, grouped by property along the I-25 spine — Denver south to Pueblo. Hover a block for the property.
What this board answers
The three questions from the October–January thread, answered from the current filter.
Physical vs economic occupancy — 12 months
Physical = units occupied or on notice ÷ total. Economic = rent collected ÷ gross scheduled rent. The gap is vacancy loss plus delinquency.
Vacancy loss by property
Vacancy loss $ as a share of scheduled rent for the period. Sandstone = above the 5% watch line.
Rent collected vs scheduled
Delinquency ageing of open resident balances at period end.
Work orders & maintenance
Open vs closed, average days to complete, spend per unit — at Boardwalk's 0% markup.
Lease expirations — next 90 days
Expiring leases by month, and how the last period's expirations resolved.
Owner statement view
The same measures rolled up per owner — the slice each owner sees in their portal report.
AppFolio → Power BI refresh
No re-keying. The Occupancy Report and Performance workbook become tables in one model, refreshed on a schedule.
Ask the data Mock · AI layer
A natural-language question over the same model. Answer generated from the numbers on this board.
