Answers
Questions people in the trades asked in public forums, paraphrased (no usernames), with the answer we gave and the free workflow behind it. Newest first.
2026-10-14 · MEP · Pending: drafted, not yet posted
Q: How do you produce residential load calcs and panel schedules, and does it have to be in AutoCAD?
Have Copilot in Excel build it: one tab per panel, a load-type column that looks up demand factors from a table you fill in from your NEC edition, and a summary with SUMIFS. Then DATALINK the range into AutoCAD and refresh after changes. Reviewers care that the math is shown, not which program made it.
Full workflow: Build panel schedules and load calcs in Excel and link them into AutoCAD
2026-10-14 · Insurance & compliance · Pending: drafted, not yet posted
Q: Running 15 to 20 subs on a spreadsheet, how do you keep COIs, workers comp and licenses from lapsing?
Have Gemini in Google Sheets build a tracker: a date per required document, a next-expiration MIN column, red/yellow formatting and a can-schedule/pay column that says NO if anything is red. You can also paste a COI into it and have it list the policies and whether additional insured and waiver of subrogation show. A current date still isn't proof of coverage, so check the endorsements against your contract.
Full workflow: Track subcontractor insurance certificates and licenses before anything expires
2026-10-14 · Estimating · Pending: drafted, not yet posted
Q: Is there a single estimate workbook template with bid leveling tabs linked to the estimate?
Have Copilot in Excel or ChatGPT build it around one cost-code column on every tab. Leveling tabs carry a value per scope line that feeds the estimate with SUMIFS. Then paste sub quotes into ChatGPT and have it map each line to your scope as included, excluded or unclear. Read the exclusions yourself.
Full workflow: Tie bid leveling tabs into your estimate workbook with one cost-code key