Material and Resource Calculator

On Tab B of the IDC MR Calculator, “Total Sustainable Materials Cost” is the sum of all individual “Material Cost” amounts entered into the column above. The “Total Material Cost” cell equals the “Total Materials Cost, Excluding Labor and Equipment” from Tab A of the Calculator. That total is the sum of the non-furniture and furniture “Actual Materials Cost” entries (also on Tab A).

If you have entered costs for every material into Tab B, the “Total Sustainable Materials Cost” and the “Total Material Cost” should be equal, and the “Sustainable Criteria Value as Percentage of Total” will report “100.00%.” The “Total Sustainable Materials Cost” value does not figure into any other calculations on the spreadsheet.

Apparently, the spreadsheet provides the “Total Sustainable Materials Cost” cell as a convenient way to crosscheck how complete your entries are. Also, if your “Total Sustainable Materials Cost” exceeds your “Total Material Cost,” the Calculator spits out a polite, but firm, “Error” message.

Is there a way to override the spreadsheet if your furniture cost is more than your materials cost?