Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question
2

Output variables in sequential order

asked 2018-04-16 12:23:42 -0600

RChidwick's avatar

updated 2018-04-17 06:50:08 -0600

Hello everyone,

I have created a large commercial PV simulation in SketchUp using the OpenStudio plugin with 237 rows of panels, and thus 237 PV generator objects. In EnergyPlus, the objects do not get ordered sequentially. Instead, they get ordered like this: 1,10,100,101,102...

Is there a way to change this? I am spending a lot of time fixing this manually in Excel when I do the data analysis. The rows are grouped together into arrays, and I am interested to know how each array is generating power. Thus, I need to add sequential rows together.

Thank you.

edit retag flag offensive close merge delete

Comments

2

Is it possible to just sort the output variables in excel by number? you could transpose the data and then do the sort if that's the issue.

mdahlhausen's avatar mdahlhausen  ( 2018-04-16 16:42:08 -0600 )edit

I completely forgot about that function in Excel. That solution works perfectly, and very quickly. Thank you very much. If you want to post that as an answer I will mark this question as solved. Thanks again.

RChidwick's avatar RChidwick  ( 2018-04-17 10:12:21 -0600 )edit

Have you tried to create an .RVI file? Assuming you are using ReadVarsESO that should put the order of the objects in what ever order you want. See https://bigladdersoftware.com/epx/doc...

JasonGlazer's avatar JasonGlazer  ( 2018-04-17 17:19:53 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
2

answered 2018-04-17 17:10:31 -0600

(moving comment to answer) Is it possible to just sort the output variables in excel by number? you could transpose the data and then do the sort if that's the issue.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Careers

Question Tools

1 follower

Stats

Asked: 2018-04-16 12:23:42 -0600

Seen: 92 times

Last updated: Apr 17 '18