PAT spreadsheet export

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

Matt Koch
1998 ●3 ●17

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

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

add a comment

2 Answers

Sort by » oldest newest most voted

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

ljbrackney

3816 ●2 ●14 http://openstudio.net/

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

Comments

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 ( 2016-11-30 16:26:55 -0600 )edit

add a comment

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

Matt Koch
1998 ●3 ●17

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.