Build panel schedules and load calcs in Excel and link them into AutoCAD
Keep panel schedules and the load calc in one Excel workbook, apply demand factors from a load-type column, and use AutoCAD Data Link so the drawing table updates when the spreadsheet changes.
MEP Engineer · MEP · Microsoft Excel · AutoCAD
Content updated · Tool links listed below; vendor features and pricing change, so confirm with the vendor
Short answer
Use Copilot in Excel or Gemini in Google Sheets: The AI builds the panel schedule tabs, the demand-factor lookup and the summary rollup for you. Keep panel schedules and the load calc in one Excel workbook, apply demand factors from a load-type column, and use AutoCAD Data Link so the drawing table updates when the spreadsheet changes. A person still checks: demand factors against your adopted NEC edition and the totals before issue.
Free tool: Schedule unit-mismatch checker. Paste a door, equipment or panel schedule export. Flags columns that mix ft, in, mm and m, unitless values, duplicate marks and blanks.
Runs in your browser. Nothing is uploaded.
AI tie-in
Tool: Copilot in Excel or Gemini in Google Sheets
The AI builds the panel schedule tabs, the demand-factor lookup and the summary rollup for you.
Prompt 1
Build a panel schedule workbook: one tab per panel with circuit, description, load type, VA per phase A/B/C and breaker; a lookup tab mapping load type to demand factor (leave factors blank for me); and a summary tab with connected load and demand load per panel using SUMIFS. Show the formulas.
Human check: Demand factors against your adopted NEC edition and the totals before issue.
The problem
Build panel schedules and load calcs in Excel and link them into AutoCAD. This is a common, time-consuming task for a mep engineer.
What this workflow does
Keep panel schedules and the load calc in one Excel workbook, apply demand factors from a load-type column, and use AutoCAD Data Link so the drawing table updates when the spreadsheet changes.
How it works: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
Your checkpoint: Demand factors and code edition are the engineer's call, so verify them with your jurisdiction. Linked tables only update when you refresh them.
Before you start
- Access to the named tool; confirm license, version and cost with the vendor.
- A small, non-confidential sample to try the workflow on first.
- A qualified person to review the output before it is used.
Tools and access
Follow the steps
- Make one tab per panel with circuit, description, load type, VA per phase and breaker.
- Add a lookup table of demand factors by load type, taken from the NEC edition your jurisdiction has adopted.
- Roll every panel up to a summary tab with connected and demand load.
- Keep the workbook at a fixed path, then in AutoCAD run DATALINK and insert the range as a table.
- After any change in Excel, run DATALINKUPDATE before plotting.
- Have the engineer check factors and totals before issue.
Try a small example
Replace the bracketed fields with your own project details. No tested sample run is published for this workflow yet.
Sample input
Fill in the bracketed [fields] in the text below with your project data.
Starter prompt
Build an Excel layout for a panel schedule tab and a load summary tab. Use a load-type column that looks up a demand factor from a separate table I will fill in from my code edition. Show the formulas. Do not pick the factors for me.
Expected output
Not published yet. Treat any output as a draft and check it against the source documents.
Check the result
- Every value, citation or quantity traces back to a source document.
- Missing information is marked as missing, not filled in.
Limits and recovery
- Demand factors and code edition are the engineer's call, so verify them with your jurisdiction. Linked tables only update when you refresh them.
- Check your organization’s data policy before sharing project files with third-party tools.
Stop or switch when: The source cannot be verified, permissions are missing, or the result contains unsupported facts.
Frequently asked questions
How does AI help with this?
Copilot in Excel or Gemini in Google Sheets: The AI builds the panel schedule tabs, the demand-factor lookup and the summary rollup for you. A person still checks: Demand factors against your adopted NEC edition and the totals before issue.
How do I build panel schedules and load calcs in Excel and link them into AutoCAD?
Make one tab per panel with circuit, description, load type, VA per phase and breaker. Add a lookup table of demand factors by load type, taken from the NEC edition your jurisdiction has adopted. Roll every panel up to a summary tab with connected and demand load. The full step list is above.
Does this use an AI agent or regular software?
It is labeled AI assists: AI drafts or analyzes. A person operates the tools, checks the work, and takes action.
What tools do I need?
Microsoft Excel, AutoCAD. Confirm license, version and cost with the vendor, and try it on a small non-confidential sample first.
Has this workflow been tested?
Workflow guide · not independently tested. It is written from vendor documentation and practitioner use.
Evidence and maintenance
Written from vendor documentation and practitioner use. Labels apply to the steps described here, not every feature of a product. Links were checked when the page was written.