WattShed Clear
The homes you deferred are still waiting. Know which, and why.
A deferral list is a promise to come back. Export it to CSV, choose it here, and tell this tool which columns are the case, the reason, and the date it was deferred. It computes how many cases are still open, how long each has been waiting, whether one reason is doing most of the damage, and which cases have already been resolved, computed in this browser from the list you load. Nothing is uploaded.
Case ids stay on your device, and this report never needs a name or an address to work. If your export carries them, leave those columns out. Export without them when you can.
This is a waiting-list check, not a verification that a barrier is real or fixed. It tracks how long a case has sat since it was deferred and whether your list marks it resolved. It does not call a roofer, a licensing board, or an asbestos lab to confirm anything about the underlying condition.
1. Load a deferral list
Choose a CSV file
Export your deferral list to CSV, one row per case, then choose it here. Or load a small example first to see how the report works.
Computed entirely in this browser. Your list never leaves this device, and nothing is uploaded or stored.
Load a deferral list to see the report here.
No file handy? Load the example list to see the full report first.
Related tools
Why deferrals slip
A deferred case does not close itself.
Cases waiting past 180 days are flagged as aging in the report below. That threshold is not a guess about any one case; it is the point past which a program should already know why a case is still open, not be finding out for the first time.
The barrier gets fixed and nobody rechecks
A contractor patches the roof, an electrician clears the panel, and the underlying reason for the deferral is gone. But closing the loop takes a second visit or a phone call someone has to remember to make, and the case sits open in the file long after the household is actually ready.
One reason quietly dominates
A roofing backlog, a shortage of electricians willing to do panel work, an asbestos-testing lab with a two-week turnaround: any one of these can account for most of a program's open deferrals without anyone noticing, because each case looks like an isolated exception until they are counted together.
Waiting time compounds into attrition
A household deferred for a few weeks is still engaged. A household deferred for eight months has often moved on: a new tenant, a change of mind, a homeowner who stopped returning calls. The deferral itself was reasonable. How long it sat unresolved is what turns it into a lost case.
Nothing beyond the columns you map is read for this report. If your export carries other case details, they load into this browser tab like the rest of the file and are never sent anywhere, but you are still handling that data, so treat the file the way your program already requires.