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

Make a simulation results extractor from equest to excel

asked 2018-10-27 08:07:31 -0600

Chriskab's avatar

updated 2018-10-27 12:38:00 -0600

Hello, I wonder how to start to automatically extract simulation results from equest. I wanna export results to excel. I need to make a macro/program for it.


edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2019-01-25 09:56:55 -0600

mikesweeney's avatar

updated 2020-09-02 18:31:24 -0600

I have a Python repository on my GitHub with a few modules for eQuest file parsing. Most of the 'sim_parse' files will run as scripts and pull out specific reports into csv files for all sim files in the folder from which they are run.

edit flag offensive delete link more



Thanks for sharing this

JasonGlazer's avatar JasonGlazer  ( 2019-01-25 10:01:23 -0600 )edit

I have an outdated one here too:

Julien Marrec's avatar Julien Marrec  ( 2019-01-25 10:37:34 -0600 )edit

Thanks Mike and Julien. I tried adding a .sim file and executed all .py files but no results appear to be shown or any .csv files. Am I missing anything here?

BilalMaarouf's avatar BilalMaarouf  ( 2019-01-27 01:03:49 -0600 )edit

I assume you've installed Python and all dependencies? if so, maybe take a look at the results in Jupyter, or an IDE like Spyder or PyCharm in order to get a sense of why the .csv files aren't generating?

mikesweeney's avatar mikesweeney  ( 2019-01-28 10:36:24 -0600 )edit

For mine, run the eQSimParsing demonstration.ipynb notebook (type jupyter notebook in a terminal (CMD) in a folder that's above the folder that has the jupyter notebook, but isn't the root of your drive, then open the notebook in the navigation that popped up in your browser, and remember that to execute cells of code you have to do CTRL+ENTER). My parsing thingy loads stuff inside pandas dataframe, which happen to have a to_csv and a to_excel function. I usually just plot the results and stuff like that right in Python, but exporting to CSV/Excel is just as easy.

Julien Marrec's avatar Julien Marrec  ( 2019-01-29 01:55:26 -0600 )edit

answered 2019-01-21 11:57:20 -0600

updated 2019-01-21 13:48:18 -0600

I'd suggest you to take a look at the D2Result.dll. Here's a example.

edit flag offensive delete link more

Your Answer

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

Add Answer

Training Workshops

Question Tools



Asked: 2018-10-27 08:07:31 -0600

Seen: 682 times

Last updated: Sep 02 '20