Forum discussion
NC-2009 MRc4: Recycled Content
How does one "Unprotect" protected cells in the Materials and Resources Calculator and Low-Emitting Materials Calculator excel spreadsheets provided through LEEDonline? There is a password request when I try to edit certain cells in these documents.
Thanks,
Myles
LEEDuser is supported by our premium members, not by advertisers.
Go premium forTo post a comment, you need to register for a LEEDuser Basic membership (free) or login to your existing profile.
The recycled content percentage on the product data sheet is given as a range. What should I do?
Is the default average recycled content value of 25% for steel still allowed?
Can site materials, such as soil, be included in the MR credit calculations?
Are there recycled content claims that I should be wary of?
RETIRED
LEEDuser Expert
623 thumbs up
February 17, 2015 - 3:37 pm
Myles - I am not sure why you would need to edit protected cells within the BDC MR Calculator provided for MRc3-7. I've never had to. Frankly I try to minimize unnecessary edits (font or fill changes, etc.) to the BDC MR Calculator to avoid any appearance of modification (tampering).
I am not aware of a spreadsheet for IEQc4 credits.
Brian Harris
PrincipalTCA Architecture Planning
5 thumbs up
February 17, 2015 - 5:06 pm
Michelle - I must be missing something. The forms for MRc4-7 have instructions to download, complete, and upload the MR Calculator. When I try to input the requested information into the spreadsheet (value of recycled content, e.g.) a notice comes up telling me to Unprotect the sheet. When I try to do this, a password is requested.
Myles
Brian Harris
PrincipalTCA Architecture Planning
5 thumbs up
February 17, 2015 - 5:14 pm
Never mind, Michelle. I figured out what i need to do.
Thank you!
Ashley Johnson
Senior Project EngineerDPR Construction
1 thumbs up
April 21, 2015 - 3:11 pm
So what was the fix? I need to go back and insert rows in my massive spreadsheet but I cannot because of the protected sheet! Please advise...
RETIRED
LEEDuser Expert
623 thumbs up
April 21, 2015 - 4:49 pm
Ashley - I think your question is directed to Brian and he may not be monitoring this forum any longer. I am not aware of the B. Inputs worksheet being protected in the BDC MR Calculator. You can add lines at the bottom by clicking the Add Material button or copy or insert lines elsewhere by copying and pasting a row.
After we talked, I learned you were using the HC BDC Calculator from 2013 and it indeed does not let you add lines except by using the Add Material button, which puts the new line at the bottom. That is frustrating but I think you have a solution.
Debra a. Lombard
Construction Administrator/ LEED APBywater Woodworks, Inc.
47 thumbs up
July 31, 2019 - 2:19 pm
I'm trying to also edit a materiuals v07 excel spreadsheet I filled out 2 months ago and now it's protected and won't let me edit it at all - without "unprotecting" it by putting in a password.
Anyone know ?
thanks!!!