[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EnergyPlus_Support] Re: Post Processing



Has anyone tried using tableau? http://www.tableausoftware.com/ . You can import data from the csv files produced by E+ quite easily and create interesting data visualisations. You can also convert quite easily from hourly to sub-hourly or monthly values etc.

--- In EnergyPlus_Support@xxxxxxxxxxxxxxx, "Jim Dirkes" <jim@...> wrote:
>
> Dear Jean,
> 
>  
> 
> I suspect that there is a lot of potential to discuss the methods which are
> used by energy modelers to evaluate their output.  An entire conference
> track, perhaps?  Here are a couple of thoughts on how I go about review:
> 
> .         I do not look at sizing outputs much and do not use the
> "..Ssz.csv" or "..Zsz.csv" files at all, except in rare cases. Rather, I
> call for various of the SummaryReports, including the HVACSizingSummary,
> EquipmentSummary, SystemSummary and ComponentSizingSummary. Fast, nicely
> formatted, and the HTML version has links so I can jump around to different
> sections. Blessed with ~35 years of HVAC experience, I have a reasonable
> feel for something that looks way out of line ... but I am not using these
> reports for load calculations or envelope performance research, just a sense
> of load magnitudes and relationships.  I also copy the airflows and
> capacities of autosized systems to a separate spreadsheet table which
> calculates for me what a DX coil COP should be in order to obtain a desired
> system EER / COP (for ASHRAE 90.1 compliance).
> 
> .         The principal .csv file that I use (other than the Table file
> mentioned above) is the one which contains all of the Report Variables
> output.  This is only created if you specify Output:Variables.  I generally
> specify the Timestep frequency, but don't really know why J.
> 
> .         I check each System and each Zone in reasonable detail.  System
> level checks are always important, but there is often a lot happening on the
> zone level which aids troubleshooting.
> 
> .         As mentioned and offered previously:  There are now 2 greatly
> improved GUIs available (DesignBuilder v3 and Bentley Energy Simulator) and
> one on the way (from LBNL).  I have not tried any of them yet, so I cannot
> comment from experience.  I do know that DB is working on a Reports tool for
> v3 that isn't quite ready.  The LBNL tool also will have something similar.
> Life will improve in that regard!  At one point I had thoughts about
> commercializing my handy spreadsheet tool, but with others bringing out much
> more sophisticated tools and knowing how much of a spreadsheet geek you must
> be to use mine, I abandoned that thought.  If you would like a copy, I'll be
> happy to send it (including minimal instructions).
> 
> .         Your spelling and communication skills are excellent.  I have no
> idea why you are apologizing!
> 
> .         Similar comment about your laziness.  I doubt you have any.
> 
>  
> 
> The Building Performance Team
> James V. Dirkes II, P.E., BEMP , LEED AP
> 1631 Acacia Drive NW
> Grand Rapids, MI 49504
> 616 450 8653
> 
>  
> 
> From: EnergyPlus_Support@xxxxxxxxxxxxxxx
> [mailto:EnergyPlus_Support@xxxxxxxxxxxxxxx] On Behalf Of Jean marais
> Sent: Wednesday, October 12, 2011 12:30 AM
> To: EnergyPlus_Support@xxxxxxxxxxxxxxx
> Subject: [EnergyPlus_Support] Re: Post Processing
> 
>  
> 
>   
> 
> Great response, James. As I'm pretty much in the same boat here, I would
> like to ask you about your famous excel sheets and (vbscript?) macros. I am
> very inexperienced in using the e+ generated csv files. I have gathered that
> all the basic sizing outcomes and inputs for sizing outcomes are summarized
> in the eio file. Output variable vs output time slots are in a eso file
> which change everytime the number of desired output variables are changed.
> That's about as far as my knowledge goes. I use almost exclusively xEsoview
> and clumsily copy past the output tables into excel to be able to overlay
> the graphs over each other. In the e+ results viewer one can also overlay
> variables on one graph, but I don't know how to get them like this into
> excel. 
> 
> Q1) With which csv files specifically do you work with?
> Q2) Do you tend to average or sum the individual zone outputs for the entire
> building and how?
> 
> Thanks again for the input.
> 
> ps I also can't spell well, but as an engineer I always feel somehow excused
> for this small inability (which probably stems from my laziness).
>




------------------------------------

Primary EnergyPlus support is found at:
http://energyplus.helpserve.com or send a message to energyplus-support@xxxxxxxx

The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are currently allowed but be mindful that not everyone has a high speed connection.  Limit attachments to small files.

EnergyPlus Documentation is searchable.  Open EPlusMainMenu.pdf under the Documentation link and press the "search" button.
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/join
    (Yahoo! ID required)

<*> To change settings via email:
    EnergyPlus_Support-digest@xxxxxxxxxxxxxxx 
    EnergyPlus_Support-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    EnergyPlus_Support-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/