British Columbia · Google Sheet template
Repair request and communication log
One row per request, facts only: dates, what was said, what was done, where the evidence is. "Days open" and the summary block calculate themselves. The rows marked SAMPLE are synthetic and are meant to be deleted.
Live Google Sheet
Created in Claude Co-Work › Platuni Compliance Hub. Formulas verified on import (summary counts and days-open resolve). Make a copy to use it.
Open Google SheetPreview
What the sheet looks like with the three sample rows. Blue cells are formulas.
| Summary | Open | =COUNTIF(Q:Q,"Open") | Awaiting access | =COUNTIF(Q:Q,"Awaiting access") | Completed | =COUNTIF(Q:Q,"Completed") | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ref | Reported date | Reported by | Unit | Issue (factual) | Category | Safety facts noted | Acknowledged | Response sent | Planned access | Actual access | Work done / 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 since morning; cold water fine | Plumbing / hot water | Tenant reports no hot water; no leak observed | 2026-08-03 | Email 10:40: acknowledged, asked for access same day | 2026-08-03 15:00 | 2026-08-03 15:10 | Reset tank thermostat; tested — landlord | 2026-08-03 | No | PH-0803-01, PH-0803-02 | Completed | =IF(B7="","",IF(M7="",TODAY()-B7,M7-B7)) | Tank is 14 years old | |
| SAMPLE-002 | 2026-08-19 | Tenant, unit 4 (text) | Unit 4 | Bedroom window latch broken; cannot lock | Doors / windows / locks | Ground-floor window does not lock | 2026-08-19 | Text 09:12: acknowledged; proposed access 08-20 with notice | 2026-08-20 09:00–12:00 | 2026-08-20 09:30 | Latch replaced — ABC Glazing INV-2291 | 2026-08-20 | Yes | 2026-09-03 | PH-0819-01, INV-2291 | Completed | =IF(B8="","",IF(M8="",TODAY()-B8,M8-B8)) | Confirm latch holds |
| SAMPLE-003 | 2026-09-06 | Tenant, unit 1 (phone) | Unit 1 | Water dripping from bathroom ceiling | Leak / water ingress | Active drip approx. 1 cup/hour per tenant | 2026-09-06 | Phone 18:05: acknowledged; asked for photo; contacted unit 3 | 2026-09-06 19:00 | Yes | 2026-09-07 | PH-0906-01, CALLLOG-0906 | Awaiting access | =IF(B9="","",IF(M9="",TODAY()-B9,M9-B9)) | Entry notice served for 09-07 09:00 |
Field definitions
Why each column exists. Nothing here asks for a legal conclusion.
- Ref
- Your own ID; SAMPLE- rows are synthetic
- Reported date / by
- When and from whom; text or email counts
- Issue (factual)
- What was reported, not the cause
- Safety facts noted
- Observations as stated; never a diagnosis
- Acknowledged / Response
- Your first reply and how it was sent
- Planned vs actual access
- The pair that entry disputes turn on
- Work done / by whom
- Invoice or work record reference
- Follow-up
- Yes/No and date; feeds the summary
- Evidence refs
- Photo and file IDs, not the files
- Status
- Open · Awaiting access · Completed
- Days open
- Formula: completed date or today, minus reported
- Notes
- Anything factual that doesn't fit