First time here? Check our help page!
2

Output variables in sequential order

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.

RChidwick's avatar
509
RChidwick
asked 2018-04-16 12:23:42 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2018-04-17 06:50:08 -0500
edit flag offensive 0 remove flag 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 -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's avatar RChidwick (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's avatar JasonGlazer (2018-04-17 17:19:53 -0500) edit
add a comment see more comments

1 Answer

2

(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.

mdahlhausen's avatar
9.5k
mdahlhausen
answered 2018-04-17 17:10:31 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments