New Materials & Resources Calculator

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?

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.

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.

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.