Does anyone have an excel template that they created to calculate the baseline vs. installed case? I've been working on it, but it is complicated. Email: curley@american.edu if so. Thanks!
You rely on LEEDuser. Can we rely on you?
LEEDuser is supported by our premium members, not by advertisers.
Go premium for
Jason Franken
Sustainability ProfessionalLEEDuser Expert
608 thumbs up
January 23, 2012 - 5:30 pm
Emily, the easiest way to accomplish this is to use the actual WEp1 Credit Form from LEED Online. If you don't have a registered project yet, you can download a sample WEp1 form from LEED Online as well.
Once you have the form, you can enter your Fixture Usage Group data (occupancy, fixtures installed pre/post 1993, etc.) and the information for the Baseline fixture case. After that, you can play around with the Installed case by entering different flow and flush rates to see how different retrofitting initiatives will play out at your facility and track the results of each scenario separately.
This is really the best way to do it because you're taking advantage of the USGBC-published calculation methodology within their own form. When you use a custom excel calculator, there's always a chance that your formulas will differ somehow. This way, you can be confident that the results are accurate.
American University
SustainabilityAmerican University
56 thumbs up
January 26, 2012 - 3:02 pm
Thanks. I find the online form to be even more complicated and obtuse than what I'm trying to build to aid our facilities staff in taking an inventory, but I suppose it still may be the best bet.
Michael Miller
Project Architect236 thumbs up
January 26, 2012 - 3:25 pm
Emily,
If you're talking about the fixture inventory itself -- rather than the calculation of the baseline vs. installed cases -- then there is a template available through the 'Documentation Toolkit' tab for this credit (on this site).