Has anyone taken a look at the new calculator (v06, Jan 4, 2016)? This version combines the BD+C and ID+C calculators and changes the way the data for Option 1 and Option 2 are entered.
The instructions confirm that you still need to enter manufacturing and extraction distances for Option 1, but there doesn't appear to be a place for those numbers to be entered.
Anyone???????
Meghan Ward
Architectural Technologist, Sustainable Design ConsultantAurecon South Africa
10 thumbs up
January 19, 2016 - 4:19 am
Hi Tiffany,
I have also realized this with the material calculator, which we need to complete.
Have you managed to figure out how we include the extracted and manufactured distance?
Tiffany Moore
Built Environment ProfessionalBuilt Kansas City LLC
35 thumbs up
January 19, 2016 - 12:40 pm
GBCI replied and indicated they would develop a set of instructions for the new calculator, which does require the information be documented in a different way. (No, I haven't figured out how to document extraction and manufacturing distances OR the percentage of back-up documents provided.)
I responded and explained that wholesale changes in the documentation process for existing projects and existing rating systems was unfair to project team members for many reasons. They acquiesced and confirmed I could continue using the old version on a project-specific basis.
My suggestion to you is to send a feedback/contact question regarding this issue. If they receive feedback on the implications of a new v2009 calculator from several people, perhaps they will re-evaluate the need to make this type of change retroactively on v2009 projects.
Honestly, I'm at a loss as to the purpose of this change in v2009.
Tiffany
Jon Clifford
LEED-AP BD+CGREENSQUARE
LEEDuser Expert
326 thumbs up
February 11, 2016 - 11:06 pm
Well, I have finally had a chance to take the new MR calculator (2009_Materials and Resources Calculator_v06.xlsm) for a test drive, and I have a few observations:
. . 1. I think that the new spreadsheet should only be used in conjunction with the new MRc5 form v06 from LEEDonline v3.
. . 2. The new LEEDonline form appears not to require the upload of cutsheets, so the new spreadsheet does not calculate the percentage uploaded either.
. . 3. Only use Column S for ID+C projects.
. . 4. For assemblies, enter the percentage of regional extraction into Column Y.
. . 5. On B+D projects, if you are using the Option 2 weighted average travel distance, enter manufacture & extraction distances into Columns T, U, V, & W.
. . 6. On B+D projects, if you are using the Option 1 500-mile radius, the instruction to enter both the manufacture & extraction distances is just plain wrong. Until GBCI issues definitive instructions, I would just enter the Manufacture distance into Column W.
Following this approach appears to tally up the proper percentages on the BD+C, CS, & HC Summary tabs, but GBCI might choose another approach.
Jon Clifford
LEED-AP BD+CGREENSQUARE
LEEDuser Expert
326 thumbs up
May 17, 2016 - 8:17 pm
Just as an update: On April 8, 2016, USGBC issued a revised version of the Materials and Resources Calculator (v07). For now, at least, you can download this spreadsheet from http://www.usgbc.org/resources/materials-and-resources-calculator-v2009. There appear to have been some modifications to the instructions (including a contradiction to my guess in Item 6 above). However, I suspect that v07 does not resolve all the issues raised concerning v06.
LEEDuser has a new forum, “LEED Online Status Updates” (http://www.leeduser.com/strategy/leed-online-status-updates) to address issues with the latest LEED Online forms and calculators. There, Michelle Reott is working with USGBC to answer or resolve issues with the new tools. Check in to the new forum for the latest news.
RETIRED
LEEDuser Expert
623 thumbs up
November 22, 2016 - 4:57 pm
Tiffany, Meghan, and Jon - I was asked to review the latest Materials and Resources Calculator v08. It should be released with (or before) the 1/1/2017 quarterly LEED Addenda Update. It will be cataloged as a Form Update (under Entry Type) in the Addenda Database - http://www.usgbc.org/leed-interpretations.
Keep an eye on http://www.usgbc.org/resources/materials-and-resources-calculator-v2009 for the new version.
One of the fixes was to rename the dropdowns in Column S to differentiate between BD+C and the further clarify the two options in ID+C. Column S was also renamed to make things clearer. “BD+C” was added to cell T7 to make it clearer this is the Distance for BD+C and ID+C project. And the embedded comment in cell T7 has been updated to reflect that for BD+C only the furthest of the compliant manufacturing/extraction distances is to be entered. At least this method of entering the further compliant distance can be used and you’ll be on the same page when the updated version is released.