The schedule against the test results
You have a circuit schedule and a sheet of test results, and nobody can say which circuits are still outstanding.
The result, on the sample
This is the finished result, made on this page from the sample file below. It is not a picture of one.
2 outside tolerance, 2 still outstanding, 1 identifier ambiguous, 9 comparisons without verified units.
- 12 scheduled circuits against 12 results.
- 7 inside the 5% tolerance, 2 outside it.
- 2 scheduled with no result; 1 result with no scheduled circuit.
- 1 identifier with more than one reading; 0 rows this page could not read.
- 0 comparisons refused because declared units differ or are missing. 9 numeric comparisons have no unit column on either side; physical compatibility is unverified. Add a unit column to both files to check it.
Outside the 5% tolerance
| Circuit | Scheduled | Measured | Difference | Off by | Unit |
|---|---|---|---|---|---|
| A-04 | 35 | 31.2 | -3.8 | 10.9% of the scheduled value | unspecified; numeric comparison only |
| B-03 | 30 | 34.6 | 4.6 | 15.3% of the scheduled value | unspecified; numeric comparison only |
Scheduled, with no result
These are a different problem from the list below, so they are a different list.
| Circuit | Scheduled | From the schedule | Unit |
|---|---|---|---|
| C-03 | 10 | Panel C to signage | unspecified |
| C-04 | 10 | Panel C to spare | unspecified |
A result, with no circuit on the schedule
| Circuit | Measured | From the results | Unit |
|---|---|---|---|
| C-05 | 10.1 | unspecified |
The same identifier more than once
| File | Circuit | Readings recorded | What happened |
|---|---|---|---|
| results | C-01 | line 10 (20), line 13 (19.95) | 2 readings recorded for this identifier. This page will not choose between them. |
Readings this page could not compare
No declared units prevented a comparison.
Inside the 5% tolerance
| Circuit | Scheduled | Measured | Difference | Off by | Unit |
|---|---|---|---|---|---|
| A-01 | 12.5 | 12.48 | -0.02 | 0.2% of the scheduled value | unspecified; numeric comparison only |
| A-02 | 12.5 | 12.51 | 0.01 | 0.1% of the scheduled value | unspecified; numeric comparison only |
| A-03 | 20 | 19.9 | -0.1 | 0.5% of the scheduled value | unspecified; numeric comparison only |
| B-01 | 20 | 20.05 | 0.05 | 0.3% of the scheduled value | unspecified; numeric comparison only |
| B-02 | 50 | 50 | 0 | 0.0% of the scheduled value | unspecified; numeric comparison only |
| B-04 | 15 | 15.1 | 0.1 | 0.7% of the scheduled value | unspecified; numeric comparison only |
| C-02 | 40 | 39.8 | -0.2 | 0.5% of the scheduled value | unspecified; numeric comparison only |
Rows this page could not read
Every row in both files was read.
The sample it came from — A 12-circuit schedule and the 11 results that came back
schedule.csv — What was scheduled
circuit,description,scheduled A-01,Panel A to lighting west,12.500 A-02,Panel A to lighting east,12.500 A-03,Panel A to receptacles,20.000 A-04,Panel A to condenser,35.000 B-01,Panel B to shop receptacles,20.000 B-02,Panel B to welder,50.000 B-03,Panel B to compressor,30.000 B-04,Panel B to office,15.000 C-01,Panel C to server room,20.000 C-02,Panel C to rooftop unit,40.000 C-03,Panel C to signage,10.000 C-04,Panel C to spare,10.000
results.csv — What came back from the field
circuit,reading,tested on A-01,12.480,2026-09-08 A-02,12.510,2026-09-08 A-03,19.900,2026-09-08 A-04,31.200,2026-09-09 B-01,20.050,2026-09-09 B-02,50.000,2026-09-09 B-03,34.600,2026-09-10 B-04,15.100,2026-09-10 C-01,20.000,2026-09-10 C-02,39.800,2026-09-11 C-05,10.100,2026-09-11 C-01,19.950,2026-09-11
Sample data.
Run it on your own file
Pick a file and it runs here, in this page.
Both files are read in this page and are never sent to us. Close the tab and they are gone.
% of the scheduled value
Running your own file needs scripting turned on. The result above, and every word on this page, do not.
What it does
Pairs each scheduled circuit with its result on the identifier, and compares the reading against the scheduled value at your tolerance.
It will not It pairs two rows only when the identifiers are the same. It will not pair a result with a circuit whose identifier merely looks close.
Lists the scheduled circuits with no result, and the results with no scheduled circuit, as two separate lists.
It will not It never nets one against the other. A count of eleven against twelve tells you nothing about which eleven.
Flags an identifier that appears twice in either file, and leaves both rows in place.
It will not It will not choose which of two rows with the same identifier is the real one.
What it will and will not do
- Two CSV files, each with a header row
- Up to 5,000 rows per file and 2 MB per file.
- Circuits are matched on the identifier, exactly, after surrounding spaces are trimmed.
- A tolerance you set, as a percentage of the scheduled value. Readings are compared as numbers, not as text.
Your version
Three questions about the work, not about you. All optional, and there is no account.
If you want us to do it
$199.00 version 2026-09-13
Two whole exports, reconciled on our server and returned as an exceptions file you download, plus a configuration you keep and can run again. Priced as a guess; nobody has bought it.
A price we have guessed at. Nobody has bought this, and the version is on the record.
The paid version runs on our server, not in this page: you send both exports, we return every exception as a file you download, and a configuration file that runs the same job again next month.