How to extract data from Adaptive Comfort Summary in energyplus?

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

Grayce
23 ●2

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

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

add a comment

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

Yi Zhang
1250 ●11 ●6

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

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.

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 ( 2021-05-03 15:08:43 -0600 )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.