Forum discussion

CS-v4 EQp1:Minimum indoor air quality performance

Excel issue with Minimum IAQ Performance Calculator

To whom it may concern,

I believe there is an issue with the v2009v4v4.1_Minimum_IAQ_Performance_Calculator_v04.xlsm "Summary" Tab.

When I fill out the required info for the Air systems tabs (my project has 100% outdoor air systems) and then click 'Refresh Systems' in the "Summary" tab, the sheet does not produce any results. Also, every time the 'Refresh Systems' button is pressed, mulitple rows appear saying 'MultipleZone Systems' and '100% Outdoor Air Systems' with NO RESULTS.

Can you please advise on what may be the issue?

We have tried on many PCs in our office with no conclusion...

1

You rely on LEEDuser. Can we rely on you?

LEEDuser is supported by our premium members, not by advertisers.

Go premium for $15.95  »

Mon, 03/07/2022 - 20:10

I am having this very issue and was looking for answers as well. Did you end up finding a solution?

Tue, 03/08/2022 - 04:50

Hi, This is a calculator issue that was faced in some of my project submissions. For this, I prepared a separate spreadsheet for only a summary of the same format as that of the calculator. You can find the compliance from the individual system-wise tab with required and provided outdoor air cfm. You can upload it with calculator. This was accepted by the reviewer.

Fri, 05/13/2022 - 17:31

I found this to fix the issue in our office. Go to Options in Excel. Select Trust Center then open Trust Center Settings. Go to Macro Settings and be sure to check Enable VBA Macros, Enable Excel 4.0 Macros, and Trust Access to VBA Project. Then hit OK twice and close Excel. When you open Excel again the selections will be applied and should resolve the issue.

Add new comment

To post a comment, you need to register for a LEEDuser Basic membership (free) or login to your existing profile.