{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Calculator","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,3,4,3],[16,4,16,6],[39,2,40,5],[32,2,33,5],[34,2,35,5],[37,2,38,5],[2,4,2,6],[6,4,6,6],[19,4,19,6],[10,4,10,6]]}
[]
[]
[null,null,null,null,"Furniture and Medical Furnishings Calculator\nLEED v4 MR Credit Furniture and Medical Furnishings"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros"]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2."]
[null,null,null,null,"Unit of measurement",null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"Actual materials cost for all freestanding furniture and medical furnishings",null,0]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Complete the Calculator tab for all freestanding furniture and medical furnishings that meet the credit requirements."]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[]
[null,null,null,null,null,null,null,"V02",null,"UOM"]
[null,null,null,null,null,null,null,"Copyright © 2012",null,{"$f":"IF(G10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,null,"U.S. Green Building Council",null,"1 = IP; 2 = SI"]
[null,null,null,null,null,null,null,"All Rights Reserved"]

{"sheet":"Calculator","index":1,"n_rows":26,"n_cols":34,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,33,7,33],[6,29,7,29],[18,1,18,2],[5,14,5,31],[6,1,7,1],[6,2,7,2],[6,3,7,3],[5,1,5,3],[5,5,5,12],[6,31,7,31],[6,5,6,9],[6,11,7,11],[6,12,7,12],[6,10,7,10],[6,17,6,18],[6,26,6,27],[18,5,18,10],[18,19,18,20],[6,30,7,30],[6,22,6,23],[6,24,6,25],[6,14,6,16],[18,14,18,15],[6,19,6,21]]}
[]
[null,"Calculator"]
[]
[]
[null,"Complete all columns with applicable material data for the attempted options.  If the option is not attempted, leave the column blank.  "]
[null,"General Information",null,null,null,"Option 1. Minimal Chemical Content and Option 2. Testing and Modeling of Chemical Content",null,null,null,null,null,null,null,null,"Option 3\nMulti-Attribute Assessment of Products",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sustainable Criteria Value for all Options\n($)"]
[null,"Description of Material","Manufacturer or Vendor Name","Material Cost\n($)",null,"Chemical Groups",null,null,null,null,"Meets or \nExceeds \nANSI/BIFMA Standard Method M7.1-2011","Option 1 \nSustainable \nCriteria Value\n($)","Option 2 \nSustainable \nCriteria Value\n($)",null,"Environmental Product Declaration",null,null,"Materials Reuse",null,"Recycled Content",null,null,"Extended Producer Responsibility",null,"Bio-based Materials",null,"Wood Products",null,null,"Does the entire product meet local criteria?","Sustainable \nCriteria Value Subtotal \n($)","Option 3 Sustainable Criteria Value with Location Valuation Factor\n($)"]
[null,null,null,null,null,"Urea \nFormaldehyde\nunder 100 ppm","Heavy Metals \nunder 100 ppm","Hexavalent \nChromium\nunder 100 ppm","PFCs and \nPFOA \nunder 100 ppm","Added \nAntimicrobial Treatment \nunder 100 ppm",null,null,null,null,"EPD Program Operator","EPD \nType","Sustainable \nCriteria\nValue\n($)","Percent \nSalvaged \nor Reused\n(%)","Sustainable \nCriteria Value\n($)","Percent \nPost-Consumer\n(%)","Percent\nPre-Consumer\n(%)","Sustainable \nCriteria Value\n($)","Extended Producer Responsibility\nClosed Loop or \nTake Back Program Name","Sustainable \nCriteria Value \n($)","Percent Meeting Sustainable Agriculture Network Standard\n(%)","Sustainable \nCriteria Value \n($)","Percent \nFSC Certified\n(%)","Sustainable \nCriteria Value \n($)"]
[{"$f":"IF(B9>=0,0,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(F9:J9,\"Yes\")>=4,D9,0)","v":0},{"$f":"IF(AND(OR(K9=\"Yes\",K9=\"N/A\"),COUNTIF(F9:J9,\"Yes\")>=2),D9,0)","v":0},null,null,null,{"$f":"IF(ISBLANK(P9),0,IF(P9=\"Product-specific Type III\",D9,IF(P9=\"Product-specific\",D9*0.25,IF(P9=\"Industry-wide (generic)\",D9*0.5,0))))","v":0},null,{"$f":"IFERROR(D9*R9,0)","v":0},null,null,{"$f":"IFERROR((T9*D9)+((U9*D9)/2),0)","v":0},null,{"$f":"IF(W9>0,D9,0)","v":0},null,{"$f":"IFERROR(Y9*D9,0)","v":0},null,{"$f":"IFERROR(AA9*D9,0)","v":0},null,null,{"$f":"SUM(Z9,AB9,X9,V9,S9,Q9)","v":0},{"$f":"IF(AD9=\"Yes\",AE9*2,AE9)","v":0},null,{"$f":"SUM(L9,M9,AF9)","v":0}]
[{"$f":"IF(B10>=0,0,0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(F10:J10,\"Yes\")>=4,D10,0)","v":0},{"$f":"IF(AND(OR(K10=\"Yes\",K10=\"N/A\"),COUNTIF(F10:J10,\"Yes\")>=2),D10,0)","v":0},null,null,null,{"$f":"IF(ISBLANK(P10),0,IF(P10=\"Product-specific Type III\",D10,IF(P10=\"Product-specific\",D10*0.25,IF(P10=\"Industry-wide (generic)\",D10*0.5,0))))","v":0},null,{"$f":"IFERROR(D10*R10,0)","v":0},null,null,{"$f":"IFERROR((T10*D10)+((U10*D10)/2),0)","v":0},null,{"$f":"IF(W10>0,D10,0)","v":0},null,{"$f":"IFERROR(Y10*D10,0)","v":0},null,{"$f":"IFERROR(AA10*D10,0)","v":0},null,null,{"$f":"SUM(Z10,AB10,X10,V10,S10,Q10)","v":0},{"$f":"IF(AD10=\"Yes\",AE10*2,AE10)","v":0},null,{"$f":"SUM(L10,M10,AF10)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D11*R11,0)","v":0},null,null,{"$f":"IFERROR((T11*D11)+((U11*D11)/2),0)","v":0},null,{"$f":"IF(W11>0,D11,0)","v":0},null,{"$f":"IFERROR(Y11*D11,0)","v":0},null,{"$f":"IFERROR(AA11*D11,0)","v":0},null,null,{"$f":"SUM(Z11,AB11,X11,V11,S11,Q11)","v":0},0,null,{"$f":"SUM(L11,M11,AF11)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D12*R12,0)","v":0},null,null,{"$f":"IFERROR((T12*D12)+((U12*D12)/2),0)","v":0},null,{"$f":"IF(W12>0,D12,0)","v":0},null,{"$f":"IFERROR(Y12*D12,0)","v":0},null,{"$f":"IFERROR(AA12*D12,0)","v":0},null,null,{"$f":"SUM(Z12,AB12,X12,V12,S12,Q12)","v":0},0,null,{"$f":"SUM(L12,M12,AF12)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D13*R13,0)","v":0},null,null,{"$f":"IFERROR((T13*D13)+((U13*D13)/2),0)","v":0},null,{"$f":"IF(W13>0,D13,0)","v":0},null,{"$f":"IFERROR(Y13*D13,0)","v":0},null,{"$f":"IFERROR(AA13*D13,0)","v":0},null,null,{"$f":"SUM(Z13,AB13,X13,V13,S13,Q13)","v":0},0,null,{"$f":"SUM(L13,M13,AF13)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D14*R14,0)","v":0},null,null,{"$f":"IFERROR((T14*D14)+((U14*D14)/2),0)","v":0},null,{"$f":"IF(W14>0,D14,0)","v":0},null,{"$f":"IFERROR(Y14*D14,0)","v":0},null,{"$f":"IFERROR(AA14*D14,0)","v":0},null,null,{"$f":"SUM(Z14,AB14,X14,V14,S14,Q14)","v":0},0,null,{"$f":"SUM(L14,M14,AF14)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D15*R15,0)","v":0},null,null,{"$f":"IFERROR((T15*D15)+((U15*D15)/2),0)","v":0},null,{"$f":"IF(W15>0,D15,0)","v":0},null,{"$f":"IFERROR(Y15*D15,0)","v":0},null,{"$f":"IFERROR(AA15*D15,0)","v":0},null,null,{"$f":"SUM(Z15,AB15,X15,V15,S15,Q15)","v":0},0,null,{"$f":"SUM(L15,M15,AF15)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D16*R16,0)","v":0},null,null,{"$f":"IFERROR((T16*D16)+((U16*D16)/2),0)","v":0},null,{"$f":"IF(W16>0,D16,0)","v":0},null,{"$f":"IFERROR(Y16*D16,0)","v":0},null,{"$f":"IFERROR(AA16*D16,0)","v":0},null,null,{"$f":"SUM(Z16,AB16,X16,V16,S16,Q16)","v":0},0,null,{"$f":"SUM(L16,M16,AF16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D17*R17,0)","v":0},null,null,{"$f":"IFERROR((T17*D17)+((U17*D17)/2),0)","v":0},null,{"$f":"IF(W17>0,D17,0)","v":0},null,{"$f":"IFERROR(Y17*D17,0)","v":0},null,{"$f":"IFERROR(AA17*D17,0)","v":0},null,null,{"$f":"SUM(Z17,AB17,X17,V17,S17,Q17)","v":0},0,null,{"$f":"SUM(L17,M17,AF17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,0,null,{"$f":"IFERROR(D18*R18,0)","v":0},null,null,{"$f":"IFERROR((T18*D18)+((U18*D18)/2),0)","v":0},null,{"$f":"IF(W18>0,D18,0)","v":0},null,{"$f":"IFERROR(Y18*D18,0)","v":0},null,{"$f":"IFERROR(AA18*D18,0)","v":0},null,null,{"$f":"SUM(Z18,AB18,X18,V18,S18,Q18)","v":0},0,null,{"$f":"SUM(L18,M18,AF18)","v":0}]
["A","Total value of sustainable materials ",null,{"$f":"SUM(D9:D18)","v":0},null,"Total value",null,null,null,null,null,{"$f":"SUM(L9:L18)","v":0},{"$f":"SUM(M9:M18)","v":0},null,"Total value",null,{"$f":"SUM(Q9:Q18)","v":0},"Total value",{"$f":"SUM(S9:S18)","v":0},"Total value",null,{"$f":"SUM(V9:V18)","v":0},"Total value",{"$f":"SUM(X9:X18)","v":0},"Total value",{"$f":"SUM(Z9:Z18)","v":0},"Total value",{"$f":"SUM(AB9:AB18)","v":0},null,"Total value",{"$f":"SUM(AE9:AE18)","v":0},{"$f":"SUM(AF9:AF18)","v":0},null,{"$f":"SUM(AH9:AH18)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"`"]

{"sheet":"Summary","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[20,3,20,4],[20,10,21,10],[13,3,14,5],[13,10,14,10],[15,3,16,4],[17,3,17,6],[17,10,18,10],[18,3,19,4]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tabs."]
[]
[null,null,"Actual materials cost for all freestanding furniture and medical furnishings ($)",null,null,null,null,{"$f":"Instructions!G14","v":0}]
[]
[null,null,"Total sustainable criteria value for all options ($)",null,null,null,null,{"$f":"Calculator!AH19","v":0}]
[]
[null,null,"Sustainable criteria value as a percentage of total furniture cost (%)",null,null,null,null,{"$f":"IFERROR(H8/H6,0)","v":0}]