Question-and-Answer Resource for the Building Energy Modeling Community

Get started with the Help page

2

How to extract comfortable data from jeplus+EA

asked 2019-05-15 08:49:11 -0600

Start
41 ●1

updated 2019-05-15 10:35:59 -0600

flag of United States of America

4436 ●5 ●17 http://bleedinggreenna...

eplusout.eso eplusout.csv Heating:Electricity Cooling:Electricity 0

!-sqlite ! Output file name; Column headers; SQL command PEOPLE_F3_CORRIDOR_Discomfort_CEN15251_CategoryII; RoomEast Cat II [Hours]; SELECT Value FROM TabularDataWithStrings WHERE (ReportName="Adaptive Comfort summary" AND ColumnName="CEN15251 Category II Acceptability Limits" AND RowName="PEOPLE F3:CORRIDOR") !-end sqlite !-objectives ! Name of the objective; unit; formula (c0,c1, c2... are columns in the result table generated from the statements above) Heating Electriciy; kWh; c0 Cooling Electriciy; kWh; c1 RoomEast Cat II; Hr; c2 !-end objectives

This is my rvi ,but I didn't get the value of RoomEast Cat II, What's wrong with this rvi file?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

1

answered 2019-05-26 10:47:23 -0600

Yi Zhang
1250 ●11 ●6

The SQL statement you have shown is to get Cat 2 for the space F3:Corridor. Change the zone name in the RowName field for other zones. You may try removing "AND RowName="PEOPLE F3:CORRIDOR")" from the SQL statement and see if it gives you all the zones at once.

If you are only interested in a few zones, it is an easier to get the comfort data from tabular output rather than using SQL. See http://www.jeplus.org/wiki/doku.php?i... for more details.

Yi

edit flag offensive delete link

Your Answer

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

Training Workshops

Careers

Question Tools

1 follower

Stats

Asked: 2019-05-15 08:49:11 -0600

Seen: 236 times

Last updated: May 26 '19

Site design and logo: Copyright © 2015 Big Ladder Software LLC. All rights reserved.
The Unmet Hours and Big Ladder names and logos are trademarks of Big Ladder Software LLC.
User contributions licensed under the Creative Commons Attribution Share Alike 3.0 License.

Powered by