architecture-building-systems / CityEnergyAnalyst

The City Energy Analyst (CEA)
https://www.cityenergyanalyst.com/
MIT License
194 stars 61 forks source link

Correspondence between graphic and table units #3441

Closed montecinosmedel closed 8 months ago

montecinosmedel commented 8 months ago

Description

When reviewing the data in Excel and the data shown in the graph for final energy use (within the CEA programme), I get an inconsistency with the units.

In the graph the electricity demand corresponds to 4.91 MWh/yr (see picture below). Screenshot 2023-12-21 130215

When obtaining the total values in Excel of the GRID_kWh column for the Building B1014 , the result ist 4912073 kWh/yr (see picture below). aaa

Expected behaviour

If the value shown in Excel were in Wh, would correspond to 4.91 MWh/yr, which would be in accordance with the graph provided by the software. Since the value in the Excel table is in kWh units, the result shown in the graph should be 4912.073 MWh/yr instead of 4.91 MWh/yr.

What are the correct units? The ones in the graph or the ones in the excel table?

Thank you in Advance

Hardware:

ShiZhongming commented 8 months ago

Hi @montecinosmedel

Sorry for the late reply as we were on winter break during Christmas and New Year.

I just used a random test case in Zurich for energy demand simulation and I could not replicate your results. The individual energy demand file (e.g. B1000.csv)'s unit is GRID_kWh and it matches the Electricity demand in the plot using the unit GRID_MWh.

Will you share your CEA scenario folder so that we can take a look?

montecinosmedel commented 8 months ago

Hi ShiZhongming,

the problem was in excel because the program did not read the comma separation correctly.

Thank you for your time