Ontario and Toronto · Google Sheets template
Repair request and communication log — Toronto
One row per request, facts only. A vital-service sample row shows how heat outages are recorded with the interim measure. Days open and the summary block calculate themselves.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Formulas verified on import.
Open in Google SheetPreview
Blue cells are formulas; SAMPLE rows are synthetic.
| Summary | Open | =COUNTIF(Q:Q,"Open") | Awaiting access | =COUNTIF(Q:Q,"Awaiting access") | Completed | =COUNTIF(Q:Q,"Completed") | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ref | Reported | Reported by | Unit | Issue (factual) | Category | Safety facts | Acknowledged | Response | Planned access | Actual access | Work / by whom | Completed | Follow-up? | Follow-up date | Evidence refs | Status | Days open | Notes |
| SAMPLE-001 | 2026-08-03 | Tenant, unit 2 (email) | Unit 2 | No hot water; cold fine | Plumbing / hot water | No leak observed | 2026-08-03 | Email 10:40 acknowledged | 2026-08-03 15:00 | 15:10 | Thermostat reset — landlord | 2026-08-03 | No | PH-0803-01 | Completed | =IF(B7="","",IF(M7="",TODAY()-B7,M7-B7)) | Tank 14 yrs; capital plan | |
| SAMPLE-003 | 2026-09-06 | Tenant, unit 1 (phone) | Unit 1 | No heat; thermostat 16°C | Heating (vital service) | No heat since 06:00; outdoor 4°C | 2026-09-06 | Phone 08:05; HVAC called; portable heater provided | 2026-09-06 11:00 | Yes | 2026-09-07 | PH-0906-01 | Awaiting access | =IF(B9="","",IF(M9="",TODAY()-B9,M9-B9)) | Vital service (Ch. 629 — verify) |
Field definitions
- Category
- Vital services (heat, hydro, gas, water) are flagged as their own category
- RentSafeTO
- Buildings 3+ storeys, 10+ units also keep the city's service request log (verify)
- Planned vs actual access
- Entry disputes turn on this pair; 8 a.m.–8 p.m.
- Safety facts noted
- Observations as stated; never a diagnosis
- Days open
- Formula: completed date or today, minus reported
- Evidence refs
- Photo and file IDs, not the files