Reservations Melted Grid Analysis

• Vacancy / occupancy / open units -> availability-summary
• Check-ins / check-outs / same-day turns -> turnovers
• Show one unit over time -> unit-timeline
• Why is this unit not open / what is this cell -> explain-cell
• Show the grid / multicalendar -> render-multicalendar

Commands

Availability summary:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  availability-summary \
  --start-date 2026-04-14 \
  --end-date 2026-04-14 \
  --building "Noble" \
  --format summary

Turnovers:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  turnovers \
  --start-date 2026-04-14 \
  --end-date 2026-04-15 \
  --building "Noble" \
  --format summary

Unit timeline:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  unit-timeline \
  --start-date 2026-04-14 \
  --end-date 2026-04-16 \
  --unit PH913TN \
  --format summary

Explain one cell:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  explain-cell \
  --date 2026-04-14 \
  --unit PH913TN \
  --with-readiness \
  --format summary

Render the grid:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  render-multicalendar \
  --start-date 2026-04-14 \
  --end-date 2026-04-16 \
  --building "Noble" \
  --format markdown

Ignore manual blocks:

python3 plugins/reservations-melted-grid/scripts/reservations_melted_grid.py \
  availability-summary \
  --start-date 2026-04-14 \
  --end-date 2026-04-14 \
  --building "Noble" \
  --exclude-blocks \
  --format json

Filters

Available filters:

• --building case-insensitive substring on buildingName
• --property-id
• --parent-listing-id
• --name-contains
• --type-of-unit
• --unit for exact unit targeting on unit-timeline and explain-cell

Defaults:

• If no --type-of-unit is passed, the script defaults to unit rows: MTL_CHILD and SINGLE
• Manual blocks are included unless --exclude-blocks is passed
• Readiness reconciliation is off unless --with-readiness is passed

Output contract

Every command returns:

• meta
• days
• units or cells
• mismatches

Fixed status vocabulary:

• Grid: reserved, vacant, blocked, unavailable
• Turnover: arrival_only, departure_only, same_day_turn, stayover, vacant_hold
• Reconciliation: clean_but_reserved, occupied_but_vacant, dirty_but_vacant, unknown_readiness_state

Reconciliation rules

• --with-readiness reads the current apartment_attributes_apt_ready snapshot from MySQL
• Join on internal name / property id only
• Never let readiness override grid vacancy
• Surface disagreements as annotations, not corrections

When answering, keep the structure explicit:

• Availability summary
• Arrivals and departures
• Same-day turns
• Open units
• Readiness disagreements, if requested

Do not mix readiness with availability unless the user explicitly wants compare mode.