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...
Sankar R
1 thumbs up
March 7, 2022 - 3:10 pm
I am having this very issue and was looking for answers as well. Did you end up finding a solution?
Devendra Chaughule
Senior Manager - Sustainable ServicesSurmount
29 thumbs up
March 7, 2022 - 11:50 pm
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.
Keith Lane
Project EngineerGGD Consulting Engineers
May 13, 2022 - 1:31 pm
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.