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

AylaZiger's profile - activity

2016-06-20 06:51:21 -0500 commented answer Operative temperature in .csv file doesn't match with .sql file

When I open the csv file, all the results appear in just one column, cause my excel are in portuguese. Then I go to Data > Text to columns to specify comma as separator, and the spread sheet change to columns like the image I posted.

2016-06-16 13:03:50 -0500 received badge  Supporter (source)
2016-06-16 12:51:29 -0500 received badge  Student (source)
2016-06-16 10:09:59 -0500 asked a question Operative temperature in .csv file doesn't match with .sql file

I have my simulation results, i also have exported them to excel with ReadVarsESO.exe. When I open the .sql file on the Results Viewer, the operative temperature variates from 34 to 14°C, but when I open the .csv file in excel, the result appear with 16 numbers. For example, in ResulstsViewer the operative temperature is 21,9°C, but in excel is 219575258579145. How do I fix it?

English is not my first language, sorry for any mistake.

Edit: image description