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 -0500

RChidwick gravatar image

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

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 gravatar imagemdahlhausen ( 2018-04-16 16:42:08 -0500 )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 gravatar imageRChidwick ( 2018-04-17 10:12:21 -0500 )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 gravatar imageJasonGlazer ( 2018-04-17 17:19:53 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
2

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

(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

 

Question Tools

1 follower

Stats

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

Seen: 38 times

Last updated: Apr 17