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

jePLUS 2.0 - hourly data outputs in different columns

asked 2020-07-01 06:48:53 -0600

ruifoliveira's avatar

updated 2020-07-01 07:49:47 -0600

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-07-02 05:01:33 -0600

Yi Zhang's avatar

updated 2020-07-02 05:20:02 -0600

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


edit flag offensive delete link more


Many thanks Dr. Yi Zhang.

Great Excel easy tip.

Rui Oliveira

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

You are welcome!

Yi Zhang's avatar Yi Zhang  ( 2020-07-10 08:58:49 -0600 )edit

Your Answer

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

Add Answer

Question Tools



Asked: 2020-07-01 06:48:53 -0600

Seen: 76 times

Last updated: Jul 02 '20