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

How can you extract large sets of parametric data from BEopt?

asked 2020-06-30 11:35:24 -0600

Craig Simmons's avatar

I set up some fairly large parametric in BEopt to test it out a bit. I am not finding a straightforward way to extract all of the resulting data. I can export up to 13 points, but I'd like to get all 600 or so into a csv or something so we can look at the data in different ways. Any one know a trick?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2020-06-30 11:44:37 -0600

All input and output data can be accessed in CSV format by choosing Reports > Detailed Report in the BEopt menu.

edit flag offensive delete link more


Thank you Scott!

Craig Simmons's avatar Craig Simmons  ( 2020-07-02 06:59:22 -0600 )edit

answered 2020-07-02 07:02:36 -0600

Craig Simmons's avatar

In addition to Scott's answer I also discovered that the "*.BEopt" file is just a compressed file containing a json and 2 sqlite files (inputs and outputs). You can extract these using 7-zip and access the sqlite databases directly, which might work better for my use case.

edit flag offensive delete link more


That is true. Use at your own risk, there is no public documentation on how the databases are structured.

shorowit's avatar shorowit  ( 2020-07-02 14:16:44 -0600 )edit

I'll update this if it turns out to be a disaster :)

Craig Simmons's avatar Craig Simmons  ( 2020-07-04 05:30:32 -0600 )edit

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

1 follower


Asked: 2020-06-30 11:35:24 -0600

Seen: 283 times

Last updated: Jul 02 '20