First time here? Check out the Help page!

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

Make a simulation results extractor from equest to excel

asked 6 years ago

Chriskab's avatar

updated 6 years ago

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.

Thanks

Preview: (hide)

2 Answers

Sort by » oldest newest most voted
3

answered 6 years ago

mikesweeney's avatar

updated 4 years ago

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.

Preview: (hide)
link

Comments

1

Thanks for sharing this

JasonGlazer's avatar JasonGlazer  ( 6 years ago )
3

I have an outdated one here too: https://github.com/jmarrec/eQSimParsing

Julien Marrec's avatar Julien Marrec  ( 6 years ago )

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  ( 6 years ago )

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  ( 6 years ago )

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  ( 6 years ago )
2

answered 6 years ago

updated 6 years ago

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

Preview: (hide)
link

Your Answer

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

Add Answer

Training Workshops

Careers

Question Tools

2 followers

Stats

Asked: 6 years ago

Seen: 1,165 times

Last updated: Sep 02 '20