# Monthly Leasing Tracker

This folder contains:
- `leasing-baseline-analysis-2026-03.md` — baseline narrative analysis
- `monthly-leasing-tracker.csv` — month-over-month tracker

## New fields for unleased unit-type mix
The tracker now includes these columns for **Vacant Not Leased** mix by type:
- `unleased_A1`, `unleased_A2`, `unleased_A3`, `unleased_A4`
- `unleased_B1`, `unleased_B2`, `unleased_B3`, `unleased_B4`
- `unleased_C1`, `unleased_S1`, `unleased_other`

## How to update monthly
1. Upload latest rent rolls.
2. Extract summary counts for each property:
   - Occupied, no NTV
   - Occupied, NTV
   - Occupied NTV Leased
   - Vacant Leased
   - Admin/Down
   - Vacant Not Leased
3. Count **Vacant Not Leased** by floorplan/type (A1/A2/etc.) and fill unleased type columns.
4. Add one row per property to `monthly-leasing-tracker.csv`.
5. Recalculate:
   - `physical_occupied_units = occupied_no_ntv + occupied_ntv + occupied_ntv_leased`
   - `physical_occupancy_pct = physical_occupied_units / total_units * 100`
   - `leased_units = physical_occupied_units + vacant_leased`
   - `leased_occupancy_pct = leased_units / total_units * 100`
   - `unleased_vacancy_pct = vacant_not_leased / total_units * 100`

— Added by Tracy Assistant, 2026-03-27