WSU C3 Calculator: Common Problems and How to Get Past Them

Why won't the WSU C3 spreadsheet open on a Mac?

The C3 spreadsheet is built for Excel on Windows. WSU's own documentation states it is not supported on Mac. The macros that run the calculations rely on Visual Basic for Applications (VBA) features that do not work the same way in Excel for Mac.

What to do:

• Run it in a Windows virtual machine (Parallels, VMware Fusion, or Boot Camp on older Intel Macs). Slow but works.
• Use a Windows machine you have access to at the office or a co-working space.
• Use a web-based alternative built for Washington — WSEC.ai calculates both the prescriptive path and R406 credits in any browser, including Safari on Mac.

Why is my antivirus blocking the C3 macros?

Modern Windows security tools — Defender SmartScreen, Norton, McAfee, CrowdStrike, and others — flag macro-enabled spreadsheets downloaded from the internet by default. When you open the C3, you may see a "Macros have been blocked"warning, or the file may simply not run its calculations.

What to do:

1. Right-click the downloaded .xlsm file → Properties → check Unblock at the bottom of the General tab → click OK.
2. Reopen the file. If you still see a yellow security bar across the top, click Enable Content.
3. If your IT department enforces a macro block policy, you will need their help — or you can use WSEC.ai, which has no macros.

Why does the C3 spreadsheet crash or lose my data?

The C3 has a lot of inter-tab formulas. Older versions of Excel and slower hardware sometimes struggle with recalculation. There is no autosave for .xlsm files unless you have explicitly enabled it on a OneDrive or SharePoint location.

What to do:

• Save early and often. Use File → Save As to keep dated versions.
• Disable automatic recalculation while you data-enter (Formulas → Calculation Options → Manual), then switch back to automatic and press F9 to recalculate when you are done.
• For multiple projects, save each one as its own file. Do not try to reuse a single working file across jobs — the named ranges and toggles drift.

Why did plan review reject my C3 submittal?

Plan review rejections of C3 submittals are usually one of three things:

1. The wrong R406 option combination. Several R406.3 categories say"only one option from items X.Y through X.Z may be selected."If you accidentally claim two within the same category, plan review will catch it.
2. Mismatch between the C3 and the plan set. Plan reviewers compare your stated wall assemblies, window U-factors, and HVAC equipment against what is shown on the architectural and mechanical sheets. If they do not match, expect a correction request.
3. Missing supporting documentation. Some jurisdictions want the R406 credit selection signed and dated, the heating system sizing worksheet attached, or a separate Manual J load calculation.

What to do:

• Reread your AHJ's plan submittal checklist. Spokane, Seattle, King County, and Snohomish all have public PDFs listing exactly what they want.
• Run your numbers through a second tool to catch math errors. WSEC.ai is a good cross-check — if our output and your C3 disagree, one of them has an input mistake.

Why does editing one number break the whole C3 sheet?

Macro-enabled Excel files are fragile. A copy-paste from another workbook can replace a formula with a value. A protected cell unlocked by accident can corrupt a calculation. Once a sheet starts misbehaving, the only reliable fix is to start from a fresh copy of the C3 master.

What to do:

• Always work from a fresh download of the current C3 from the WSU Energy Program site.
• Never paste from other Excel files — type values in directly.
• If you find yourself opening the same broken file repeatedly, switch tools.

When should I switch from the C3 to a different tool?

Switch tools if you build more than a handful of homes a year, work on a Mac, build on a tablet in the field, or have ever lost half a day to macro errors. The C3 is fine for one-off projects on a Windows machine when nothing goes wrong. Outside that narrow window, a web-based alternative will pay for itself the first time you use it.

WSEC.ai is built specifically for the 2021 WSEC-R, runs in any browser, saves your projects, and produces a permit-ready PDF in the same format as the C3 output. The online C3 calculator is $19, the full guided wizard with chatbot is $99, and an uploaded plan review is $499.

For a side-by-side comparison of WSU C3, REScheck, and WSEC.ai, see our Alternatives to the WSU C3 Calculator page.