[Equest-users] Equest freeze and Spreadsheet refresh error

[Dahlstrom, Aaron]

We have definitely have had models that were so large we couldn't make changes in the spreadsheet view.
It's tedious but one option is to make any changes needed in the dialog boxes.

AD

Aaron Dahlstrom , PE, LEED(r) AP
In Posse - A subsidiary of AKF| 1500 Walnut Street, Suite 1414, Philadelphia, PA 19102
d: 215-282-6753| m: 267-507-5470| In Posse: 215-282-6800| AKF: 215-735-7290
e: ADahlstrom at in-posse.com | in posse web: www.in-posse.com<http://www.in-posse.com/> | akf web: www.akfgroup.com<http://www.akfgroup.com/>



From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Chakraborty, Jude
Sent: Friday, October 21, 2011 1:41 PM
To: equest-users at lists.onebuilding.org
Subject: [Equest-users] Equest freeze and Spreadsheet refresh error

Dear all,

I am trying to model a high rise 25 floor courthouse building with multiple shells (12) and  many zones (near 500). I have used floor multipliers where I could to make the model simpler but it ended up with 60,000 lines and about 7500 components. The .bdl file doesn't show any error and I have also run a default simulation, which took its time but gave results without any errors.

Now in the detailed interface, equest freezes whenever I try to make changes on anything or create a new schedule. Also when I go to the building shell spreadsheet, it shows this "Spreadsheet refresh error" with the following text "Selection list exceeds maximum length of 65,500 characters (98,339required). Notify program support representative".

Does it mean that I need to reduce number of spaces/zones or divide my building into two separate files? Any idea how to solve this problem?

Thanks,
Jude.






This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unintended recipients are prohibited from taking action on the basis of information in this e-mail. E-mail messages may contain computer viruses or other defects, may not be accurately replicated on other systems, or may be intercepted, deleted or interfered without the knowledge of the sender or the intended recipient. If you are not comfortable with the risks associated with e-mail messages, you may decide not to use e-mail to communicate with In Posse.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20111021/9929f1f5/attachment-0002.htm>