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

Post a reply

LEEDuser Expert

472 thumbs up

Tue, 02/17/2015 - 20:37

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

Principal

TCA Architecture Planning

LEEDuser Premium Member

5 thumbs up

Tue, 02/17/2015 - 22:06

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

Principal

TCA Architecture Planning

LEEDuser Premium Member

5 thumbs up

Tue, 02/17/2015 - 22:14

Never mind, Michelle. I figured out what i need to do. Thank you!

Ashley Johnson

Senior Project Engineer

DPR Construction

LEEDuser Basic Member

1 thumbs up

Tue, 04/21/2015 - 19:11

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...

LEEDuser Expert

472 thumbs up

Tue, 04/21/2015 - 20:49

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 AP

Bywater Woodworks, Inc.

LEEDuser Basic Member

42 thumbs up

Wed, 07/31/2019 - 18:19

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!!!

Add new comment

To post a comment, you need to register for a LEEDuser Basic membership (free) or login to your existing profile.

You are currently logged in under an enterprise account

FAQs about MRc4 :

Excel spreadsheets

You rely on LEEDuser. Can we rely on you?

Add new comment