3

jePLUS 2.0 - hourly data outputs in different columns

Hello Unmet users,

I'm using jePLUS 2.0 for sensitive analysis and I want to extract all ElectricityBuilding [hourly] and DistricHeating [Hourly] data after running all *.idf files in jePLUS. However, the outputs from different models are combined in the same column of *.csv hourly file.

I would like to have the results of each *.idf separately by columns.

Any suggestion to do it in jePLUS?

Best, Rui Oliveira

ruifoliveira's avatar
57
ruifoliveira
asked 2020-07-01 06:48:53 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2020-07-01 07:49:47 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

1

Hi Rui,

The hourly data extracted to csv for individual cases are stored in the case folders. See example below.

image description

You cannot put them in separate columns in the aggregated SimResults.csv with jEPlus alone. However, I think you can do that in Excel quite easily. Try Insert/Pivot Table, and use job_id as column labels and Date/Time as row labels...

Yi

Yi Zhang's avatar
1.2k
Yi Zhang
answered 2020-07-02 05:01:33 -0500, updated 2020-07-02 05:20:02 -0500
edit flag offensive 0 remove flag delete link

Comments

Many thanks Dr. Yi Zhang.

Great Excel easy tip.

Rui Oliveira

ruifoliveira's avatar ruifoliveira (2020-07-09 06:43:17 -0500) edit

You are welcome!

Yi Zhang's avatar Yi Zhang (2020-07-10 08:58:49 -0500) edit
add a comment see more comments