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

How to extract data from Adaptive Comfort Summary in energyplus?

asked 2021-05-01 19:18:46 -0500

Grayce gravatar image

updated 2021-05-06 15:42:04 -0500

I'm trying to extract data from Eletricidade and Adaptive Comfort Summary in energyplus using the sql command in jeplus. However, I am getting only the Electricity data. I configured the People and Output object: Table: SummaryReports (AdaptiveComfortSummary) for adaptive comfort and enabled the following outputs.

Output: Variable, *,! - Key Value Zone Thermal Comfort ASHRAE 55 Adaptive Model 80% Acceptability Status,! - Variable Name RunPeriod; ! - Reporting Frequency

Output: Variable, *,! - Key Value Zone Thermal Comfort ASHRAE 55 Adaptive Model 90% Acceptability Status,! - Variable Name RunPeriod; ! - Reporting Frequency

Output: Variable, *,! - Key Value Zone Adaptive Comfort Operative Temperature Set Point,! - Variable Name RunPeriod; ! - Reporting Frequency

Output: Variable, *,! - Key Value Zone Thermal Comfort ASHRAE 55 Adaptive Model Running Average Outdoor Air Temperature,! - Variable Name RunPeriod; ! - Reporting Frequency

Output: Variable, *,! - Key Value Zone Thermal Comfort ASHRAE 55 Adaptive Model Temperature,! - Variable Name RunPeriod; ! - Reporting Frequency

Output: Meter, Electricity: Facility,! - Key Name RunPeriod; ! - Reporting Frequency

The sql layer for jeplus is as follows:

"sqls": [{ "sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (ReportName = 'AdaptiveComfortSummary' AND ColumnName = 'ASHRAE55 80% Acceptability Limits' AND RowName = 'THERMAL_ZONE_1 PEOPLE_ESCRITORIO')", "tableName": "Desc_sql", "columnHeaders": "Discomfort [hrs]", "usedInCalc": true }, { "sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (ReportName = 'AnnualBuildingUtilityPerformanceSummary' AND ColumnName = 'Electricity' AND RowName = 'Total End Uses')", "tableName": "Elet_sql", "columnHeaders": "Electricity", "usedInCalc": true }],

Don't know what may be missing? If anyone can help me, I will be very grateful.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2021-05-03 03:39:36 -0500

Yi Zhang gravatar image

updated 2021-05-04 04:22:01 -0500

First, check if the Adaptive Comfort Summary report in eplustbl.htm is populated. If the table is empty, check if you still have cooling on in your model. If the numbers are there, use the CSV method (available in jEPlus v2) rather than SQL. It is a lot easier. The relevant manual is here: https://www.jeplus.org/wiki/doku.php?...

Edit:

As per the comments below, it turned out that in eplustbl.csv, the column headers can have extra spaces between words, which is not visible in Html form. So if you follow the video tutorial and copied the texts from eplustbl.htm, and it did not work, do that again using eplustbl.csv may solve the problem.

edit flag offensive delete link more

Comments

Hello, thanks for the feedback. The Adaptive Comfort Summary report is completed at eplustbl.htm. I had tried before to extract the values with the CSV method, however I was not successful. I need the data from the Adaptive Comfort Summary (ASHRAE55 90% Acceptability Limits) to proceed with an optimization job. My files are on this link link text. If it is possible to check what may be wrong, I will be very grateful. I've been trying to get this data for a long time.

Grayce gravatar image Grayce  ( 2021-05-03 15:08:43 -0500 )edit

Thanks for sharing the project files. It turns out that the column header in eplustbl.csv is ASHRAE55 80% Acceptability Limits [Hours], where there are two spaces between 'Limits' and '[Hours]'. So if you have copied the column header from the eplustbl.htm as in the tutorial, then the CSV element won't work... ... Here you probably don't see the extra space either, as the browser eliminates it when rendering the comment.

Yi Zhang gravatar image Yi Zhang  ( 2021-05-03 18:16:47 -0500 )edit

I am immensely grateful, thank you very much. It really was that, it worked.

Grayce gravatar image Grayce  ( 2021-05-03 19:06:04 -0500 )edit

You are welcome! Please mark the question as solved when you can. Cheers.

Yi Zhang gravatar image Yi Zhang  ( 2021-05-04 04:23:06 -0500 )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

Stats

Asked: 2021-05-01 19:18:46 -0500

Seen: 65 times

Last updated: May 04