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

PAT spreadsheet export

asked 2016-11-30 13:28:22 -0500

Matt Koch's avatar

updated 2017-08-20 15:01:40 -0500

I am running OpenStudio 1.13.0 and PAT 1.13.0 on Windows 7 Pro. I can run PAT just fine, and it generates results, but I am finding that I cannot export the results to a spreadsheet, nor can I select them off the report tab and copy them to a spreadsheet. When I try to File -> Export XML Report, the resulting zipped XML file is basically empty. When I try to File -> Export Analysis Spreadsheet, it fails outright with an error message. I am extremely happy I have made it this far, but all that work might have been in vain if I cannot find a way export the numbers to make pretty graphs from!

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2016-11-30 14:45:50 -0500

While I can't say why those exports didn't work correctly, I can state that neither does what you're attempting to do. The export Analysis Spreadsheet functionality is/was intended to export a spreadsheet suitable as a starting point for large-scale parametric analysis or optimization. That workflow is documented here.

PAT 1.x was designed to pretty much generate only what you see in the results table and not much more. Cutting and pasting from the results tab is a possibility, as is scripted analysis that scrapes results from the individual data point directories located in your PAT project.

The upcoming version of PAT (2.x) has been redesigned from the ground-up, and will provide a number of mechanisms to get data out of your project. It has more of a client/server structure, and the server allows data dumps into R, csv, etc. The team is also adding the concept of a "Project Measure." This is a new type of Reporting Measure (Ruby script) that can pull results from multiple data points and create custom reports, plots, etc. The new app will come with some example Project Measures built in as starting points for making your own.

edit flag offensive delete link more


Wow, that sounds rather complex. Not sure I can get my arms around that right now. I was thinking of scripting indeed. I think for now, and until you release PAT 2.0, that may be the most efficient path to success. By the way, I cannot select and copy data from the table on the results tab of PAT, which is what I would rather do.

Matt Koch's avatar Matt Koch  ( 2016-11-30 16:26:55 -0500 )edit

answered 2016-12-15 13:38:12 -0500

Matt Koch's avatar

So, I ended up scripting this in Scilab (sorry, it's the only language I feel really comfortable in). It's not pretty, but self-explanatory, and right now, I still have to cut and paste from the Scilab window into a spreadsheet, but it does the trick for now. Happy to share the raw bits if anyone cares to know.

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

1 follower


Asked: 2016-11-30 13:28:22 -0500

Seen: 250 times

Last updated: Dec 15 '16