{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["A. Introduction","B. Calculator","C. Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":0,"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":"A. Introduction","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,4,12,5],[15,4,15,7],[2,3,4,3],[2,4,2,5],[18,4,18,7],[20,3,20,6],[31,2,32,5],[33,2,34,5],[36,2,37,5],[38,2,39,5]]}
[]
[]
[null,null,null,null,"LEED v4\nMR Lamp Purchasing Calculator",null,null,null,null,null,"Interior paints and coatings applied on site"]
[null,null,null,null,null,null,null,null,null,null,"Interior adhesives and sealants applied on site (including flooring adhesive)",null,null,null,"Actual Materials Cost"]
[null,null,null,null,"Step 1.",null,null,null,null,null,"Flooring",null,null,null,"Total Construction Cost"]
[null,null,null,null,"Enable macros",null,null,null,null,null,"Composite wood"]
[null,null,null,null,null,null,null,null,null,null,"Ceilings, walls, thermal, and acoustic insulation"]
[null,null,null,null,"Step 2",null,null,null,null,null,"Furniture"]
[null,null,null,null,"Enter total lamps installed in the project"]
[]
[null,null,null,null,"Total number of mercury-containing lamps (plus high-efficiency mercury-free counterparts) presently installed in the project building and on the associated grounds:",null,null,220]
[]
[]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"Complete tab B. Calculator for all lamps purchased during the performance period."]
[]
[null,null,null,null,"Step 4."]
[null,null,null,null,"Use the summary information on tab C. Summary to complete the LEED Credit Form."]

{"sheet":"B. Calculator","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,5,4,9],[16,1,16,8],[20,1,20,9],[17,1,17,8],[18,1,18,8]]}
[]
[null,"Lamp Purchasing Calculator"]
[]
[]
[null,"Table 1",null,null,null,{"$f":"IF(L17>0,\"Error: Mercury Content per Bulb must be in the following ranges: 0 - 0.001 or 0.5 - 300. Please revise the values entered.\",\"\")","v":""}]
[null,"Bulb General Type","Bulb Specific Description or Code","Documentation Provided1","Quantity of \nSpecific Bulb Type","Mercury Content \nper Bulb2 \n(mg)","Mean \nLight Output \nper Bulb Type\n(lumens)","Rated Life \nper Bulb \n(hrs)","Total \nLumen Hours \nper Bulb","Total \nMercury Content \nper Bulb\n(picograms/lumen-hr)",null,"Mercury Content invalid range","Cutsheets"]
[null,"Regular fluorescent","PHIL 281535 F32T8TL835ALTO30PK","Yes",30,1.7,2950,30000,{"$f":"E7*G7*H7","v":2655000000},{"$f":"IF(AND(G7>0,H7>0),(F7/(G7*H7))*1000000000,0)","v":19.209039548022599},null,{"$f":"IF(AND(OR(F7<0,F7>0.001),OR(F7<0.5,F7>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(D7=\"Yes\",1,0)","v":1}]
[null,"HID","PHIL 230821 F21T5835ALTO40PK","Yes",20,1.4,2100,24000,{"$f":"E8*G8*H8","v":1008000000},{"$f":"IF(AND(G8>0,H8>0),(F8/(G8*H8))*1000000000,0)","v":27.777777777777779},null,{"$f":"IF(AND(OR(F8<0,F8>0.001),OR(F8<0.5,F8>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(D8=\"Yes\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,0,0,null,"",0]
[null,null,null,null,null,null,null,null,{"$f":"E10*G10*H10","v":0},{"$f":"IF(AND(G10>0,H10>0),(F10/(G10*H10))*1000000000,0)","v":0},null,{"$f":"IF(AND(OR(F10<0,F10>0.001),OR(F10<0.5,F10>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(D10=\"Yes\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0,null,"",0]
[null,null,null,null,null,null,null,null,0,0,null,"",0]
[null,null,null,null,null,null,null,null,0,0,null,"",0]
[null,null,null,null,null,null,null,null,0,0,null,"",0]
[null,null,null,null,null,null,null,null,{"$f":"E15*G15*H15","v":0},{"$f":"IF(AND(G15>0,H15>0),(F15/(G15*H15))*1000000000,0)","v":0},null,{"$f":"IF(AND(OR(F15<0,F15>0.001),OR(F15<0.5,F15>300)),\"ERROR\",\"\")","v":""},{"$f":"IF(D15=\"Yes\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(AND(OR(F16<0,F16>0.001),OR(F16<0.5,F16>300)),\"ERROR\",\"\")","v":""},0]
[null,"Total number of lamps purchased",null,null,null,null,null,null,null,{"$f":"SUM(E7:E16)","v":50},null,{"$f":"COUNTIF(L7:L16,\"ERROR\")","v":0},{"$f":"SUM(M7:M16)","v":2}]
[null,"Building maximum (picograms/lumen-hr)",null,null,null,null,null,null,null,{"$f":"MAX(J7:J16)","v":27.777777777777779}]
[null,"Percent Documentation provided",null,null,null,null,null,null,null,{"$f":"IF(M17>0,COUNTIF(D7:D16,\"Yes\")/COUNTA(E7:E16),0)","v":1}]
[]
[null,"Notes:\n1    Supporting documentation has been uploaded to LEED Online.\n2   Successfully completing the picogram per lumen hour calculations requires information about the mercury content in milligrams per bulb for each type of mercury-containing bulb in the building. This information should be obtained from MSDSs or other public literature from the manufacturer, or by directly contacting the manufacturer/vendor and requesting a written statement reporting mercury content values. Mercury values generated by TCLP (Toxicity Characteristic Leaching Procedure) tests are measured in mg per liter of test solution, and do not reflect total mercury content or mercury concentration in the bulb, and therefore are not appropriate for use in the LEED-EB: O&M calculations. These values cannot be converted to total mercury content through calculations. Only the following ranges of values for mercury content are valid: less than 0.001 mg, or between 0.5 mg and 300 mg."]

{"sheet":"C. Summary","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[22,3,22,4],[22,10,23,10],[12,10,13,10],[15,3,16,5],[15,10,16,10],[17,3,18,4],[19,3,19,6],[19,10,20,10],[20,3,21,4]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see tab B. Calculator. "]
[]
[null,null,"Total number of lamps purchased",null,null,null,null,{"$f":"'B. Calculator'!J17","v":50}]
[]
[null,null,"Percentage of total installed lamps (%)",null,null,null,null,{"$f":"IF('A. Introduction'!H11>0,H6/'A. Introduction'!H11,0)","v":0.22727272727272727}]
[]
[null,null,"Building maximum (picograms/lumen-hr)",null,null,null,null,{"$f":"'B. Calculator'!J18","v":27.777777777777779},null,null,"Note: May not exceed 70."]
[]
[null,null,"Percent documentation provided (%)",null,null,null,null,{"$f":"'B. Calculator'!J19","v":1},null,null,"Note: Must be at least 20%."]