San Francisco · Google Sheets template
Repair request and communication log — San Francisco
One row per request, facts only. Heat, hot water and lead rows have their own categories because the Housing Code and federal RRP rules are specific. Planned access carries the 24-hour written notice. Days open and the summary block calculate themselves.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Formulas verified on import.
Open 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 as stated | Acknowledged | Response | Planned access (24h written notice) | 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 water fine | Plumbing / hot water | No leak observed | 2026-08-03 | Email 10:40 acknowledged; 24h notice given | 2026-08-04 15:00 | 15:10 | Water heater relight — landlord | 2026-08-04 | No | PH-0803-01 | Completed | =IF(B7="","",IF(M7="",TODAY()-B7,M7-B7)) | Entry on 24h written notice (Civ. Code 1954) | |
| SAMPLE-002 | 2026-08-20 | Tenant, unit 4 (text) | Unit 4 | Peeling paint; pre-1978 | Lead paint | Child under 6 reported | 2026-08-20 | Text 09:15; certified renovator booked | 2026-08-25 09:00 | Yes | 2026-09-05 | PH-0820-01 | Awaiting access | =IF(B8="","",IF(M8="",TODAY()-B8,M8-B8)) | EPA RRP; CA lead-safe practices (verify) | |||
| SAMPLE-003 | 2026-11-06 | Tenant, unit 1 (phone) | Unit 1 | No heat; 60°F at 08:00 | Heat / hot water | No heat since 06:00 | 2026-11-06 | Phone 08:05; furnace tech called; space heater provided | 2026-11-06 11:00 | Yes | 2026-11-07 | PH-1106-01 | Open | =IF(B9="","",IF(M9="",TODAY()-B9,M9-B9)) | SF Housing Code heat standard — verify |
Field definitions
- Category
- Heat / hot water, lead paint and detectors are their own categories because the rules are specific
- Safety facts as stated
- Observations as reported; temperature readings with time; never a diagnosis
- Planned access
- Carries the 24-hour written notice (date, approximate time, purpose)
- Evidence refs
- Photo and file IDs, not the files
- Days open
- Formula: completed date or today, minus reported
- DBI
- If a notice of violation is issued, add its number and the re-inspection date in Notes