[Equest-users] A possible solution for exporting hourly .csv data

[Drew Morrison via Equest-users]

Good Afternoon All,

I've seen a few questions recently about finding a way to directly export hourly eQuest results to a .csv file or similar without going through the time-consuming process of opening the .sim file first. I think I've found a way - it turns out that eQuest does, in fact, output its hourly results to a comma-delimited text file, only the file doesn't have a .csv extension.

Please correct me if I'm wrong or if this is somehow unique to my installation, but when eQuest runs a simulation it outputs a file with a .hsr extension. If you open this file in a text editor like Notepad (or my personal preference, Notepad++), you'll see some text that looks an awful lot like the default hourly report block headers and accompanying hourly output data, all separated by commas. If you create custom hourly reports in addition to the default ones, they show up in the .hsr file as well. You can either open this file directly to a spreadsheet program like Excel using the data import wizard or, if you're willing to go the extra mile, provide a one-click solution with a little bit of scripting - in my case, in unglamorous but useful VBA.

Other than the content and comma-delimited format, an .hsr file seems to behave in the same way a .sim file does. eQuest uses the same naming convention for these as it does with .sim files with respect to parametric simulations, and it overwrites an .hsr file if a simulation is run again.

Hope this helps provide a solution! I'd appreciate it if someone could look into one of their project directories and verify that what I've said is, in fact, the case.

Good Modeling,
Drew

Drew Morrison, Energy Engineer
Seventhwave
608.210.7151 seventhwave.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20161019/d5b2ff20/attachment.htm>