WattShed Comply
Turn a program export into the report a regulator actually asks for.
Export your program's application list to CSV, choose that file here, and tell this tool which columns are the application ID, the status, and the submitted (and, if you have it, decided) date. It builds counts by status, an approval rate, turnaround time, and monthly volume from exactly those columns, computed in this browser from your own export. Nothing is uploaded.
The figures are only as good as the export's columns and the status buckets you confirm. A wrong column mapping produces a wrong report with no warning bell, so check the mapping and the Approved/Denied sort before trusting a number out of it.
This is a reporting convenience, not a substitute for a program's official filing. Use it to see your own numbers before you file, not as the filing itself.
1. Load an export
Choose a CSV file
Export your program's application list to CSV, then choose it here. Or load a small example first to see how the report works.
Computed entirely in this browser. Your export never leaves this device, and nothing is uploaded or stored.
Load an export and map its columns to see a report here.
No file handy? Load the example data to see the full report first.
Related tools
What it reports
Five figures, built from four columns you point it at.
Counts by status
Every distinct value found in the status column, tallied on its own, alongside how many rows land in your Approved, Denied, and Other buckets.
Approval rate
Approved rows as a share of every row this tool could count, once skipped and unmapped rows are set aside.
Turnaround
Median and mean days between a row's submitted date and its decided date, across every row that carries both.
Monthly volume
Applications submitted per month, read straight off the submitted-date column and laid out as a simple bar list.
Skipped-row accounting
Every row this tool could not count, with a reason: a blank required field, an unparseable date, or a status that never got sorted into a bucket.
Nothing beyond the four columns you map is read for this report. If your export carries applicant names or other sensitive columns, 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.