Workbook guide
Prepare two revisions of the same electrical panel for comparison.
Download the sample revisions
Upload these in order to see one modified circuit, one addition and one removal.
Prepare your own revision pair
- In PanelLink, export the same panel from both Revit revisions. Keep the original exports as records.
- Use one worksheet and one vertical circuit table per file. If your exported schedule places odd and even circuits side by side, copy both groups into one table with the headers below. Paste values only.
- Use plain numeric amperes and volt-amperes. Remove totals and footers. Omit empty slots or leave their description, breaker and load blank.
- Save as Excel Workbook (.xlsx), up to 5 MB per file. Select the older file first.
| Circuit Number | Description | Breaker (A) | Load (VA) | Circuit ID (optional) |
|---|
| 1 | Corridor lighting | 10 | 500 | EXAMPLE-A |
Use Circuit ID as the exact header for the optional column. Keep IDs unique and stable across revisions. If you omit the column from both files, matching uses circuit numbers and a move appears as an addition and removal.
Import a formatted PanelLink export
Try the DB-L1 office fit-out sample. These fictional workbooks are Excel fixtures modeled on a split panel schedule. They include a merged title, mirrored circuit groups, dedicated phase loads and stable circuit IDs. Use them to practise reviewing a revision.
For this pair use 8-10; A,B,C,D+E+F,G; N,M,L,I+J+K,H. The expected totals are 3 modified, 1 added, 1 removed and 1 unchanged. The lobby sockets move from circuit 3 to 7, and the fan load rises from 1,200 VA to 1,350 VA.
In PanelLink, export to Excel with Keep Formatting of the Schedules enabled. Open the exported sheet to identify the first and last circuit rows and the column letters. Choose Import a formatted PanelLink schedule in the checker and enter the mapping. The original workbooks remain intact.
Example for a side-by-side schedule: 8-29; A,B,C,D+E+F; N,M,L,I+J+K. This reads rows 8–29, with separate left and right circuit, description, breaker and three phase load columns. Replace the example coordinates with yours. A single total load column can replace the three phase columns.
Select apparent load columns in VA. Explicit text units such as 1.2 kVA are converted. A bare number is read as VA even if its Excel header or number format says kVA. Use the flat template for bare kVA values, shared phase columns, formula cells, or schedules outside the supported layout. Do not select totals or combine a total column with phase columns.
Review and share
Check the previous and new values in the results. Download the CSV for a review record. The download contains all detected changes, even when the dashboard is filtered. The tool reads the workbooks locally and leaves them intact.
The checker compares workbook values. Use the original panel schedule and model to verify changes before issuing a revision. PanelLink formatting varies by Revit schedule template. Mapped import has been tested with generated workbooks. Compatibility with an original PanelLink workbook pair is still pending.