{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Calculator","Summary","Summary - HC","Summary - EB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Introduction","index":0,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,4,24,7],[30,4,30,7],[2,4,2,5],[15,4,15,7],[21,4,21,7],[27,4,27,7],[18,4,18,7],[11,6,11,7]]}
[]
[]
[null,null,null,null,"LEED v4\nDaylight and Quality Views Calculator"]
[]
[null,null,null,null,"Step 1."]
[null,null,null,null,"Enable macros."]
[]
[null,null,null,null,"Step 2."]
[null,null,null,null,"Select units of measurement",null,"feet"]
[]
[null,null,null,null,"Step 3."]
[null,null,null,null,"Select rating system family",null,"LEED v4 ID+C"]
[]
[null,null,null,null,"Step 4. "]
[]
[null,null,null,null,"If attempting EQ Credit: Daylight, complete the Daylight section on the Calculator tab for each daylighted regularly occupied space.\n\nIf attempting EQ Credit: Quality Views, complete the Quality Views section on the Calculator tab for each regularly occupied space with views."]
[]
[null,null,null,null,"For Healthcare projects"]
[null,null,null,null,"If attempting EQ Credit: Daylight, complete the Daylight section on the Calculator tab for each daylighted regularly occupied and non-regularly occupied space.\n\nIf attempting EQ Credit: Quality Views, complete the Quality Views section on the Calculator tab for each inpatient and non-inpatient space with views."]
[]
[null,null,null,null,"For Existing Building projects"]
[null,null,null,null,"If attempting Option 1, complete the Daylight: Measurement section on the Calculator tab for each daylighted regularly occupied space.\n\nIf attempting Option 2, complete the Quality Views section on the Calculator tab for each regularly occupied space with views."]
[]
[null,null,null,null,"Step 5. "]
[null,null,null,null,"Use the information on the Summary tab to complete the LEED Credit Form(s)."]
[]
[null,null,null,null,"For Healthcare projects"]
[null,null,null,null,"Use the information on the Summary - HC tab to complete the LEED Credit Form(s)."]
[]
[null,null,null,null,"For Existing Building projects"]
[null,null,null,null,"Use the information on the Summary - EB tab to complete the LEED Credit Form."]
[]
[null,null,null,null,null,null,null,null,null,"Rating System"]
[null,null,null,null,null,null,null,null,null,"LEED v4 BD+C: All Except Healthcare"]
[null,null,null,null,null,null,null,null,null,"LEED v4 BD+C: Healthcare"]
[null,null,null,null,null,null,null,null,null,"LEED v4 ID+C"]
[null,null,null,null,null,null,null,null,null,"LEED v4 O+M"]

{"sheet":"Calculator","index":1,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,1,13,2],[7,16,8,16],[16,14,16,15],[6,14,6,16],[5,6,5,16],[7,10,8,10],[7,12,8,12],[7,6,8,6],[7,7,8,7],[12,1,12,2],[6,1,8,2],[10,1,10,2],[11,1,11,2],[9,1,9,2],[6,4,7,4],[6,3,8,3],[7,15,8,15],[7,14,8,14],[7,9,8,9],[7,8,8,8],[6,6,6,10],[16,18,16,20],[5,18,5,21],[7,18,8,18],[6,20,6,21],[6,19,8,19],[7,20,8,20],[7,21,8,21],[18,6,18,10],[17,17,18,17],[16,6,16,9],[17,6,17,9],[14,1,14,2],[15,1,15,2],[17,14,18,16],[16,1,16,3]]}
[]
[null,"Calculator",null,null,{"$f":"IF(Introduction!G9=\"feet\",\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"}]
[]
[]
[]
[null,"General Information",null,null,null,null,"Daylight",null,null,null,null,null,null,null,null,null,null,null,"Quality Views"]
[null,"Space ID",null,"Space Description",{"$f":"IF(Introduction!G12<>\"LEED v4 BD+C: Healthcare\",\"Total Regularly Occupied Floor Area\",\"Total Perimeter Area\")","v":"Total Regularly Occupied Floor Area"},null,"Option 1. \nSimulation: Spatial Daylight Autonomy and Annual Sunlight Exposure",null,null,null,null,null,"Option 2.\nSimulation: Illuminance Calculations",null,{"$f":"IF(Introduction!G12<>\"LEED v4 O+M\",\"Option 3. Measurement\",\"Option 1. Daylight Measurement\")","v":"Option 3. Measurement"},null,null,null,"For Healthcare projects only",{"$f":"CONCATENATE(IF(Introduction!G12=\"LEED v4 BD+C: Healthcare\",\"Inpatient Floor Area with Direct Line of Sight to the Outdoors \",\"Floor Area with Direct Line of Sight to the Outdoors via Vision Glazing \"),E2)","v":"Floor Area with Direct Line of Sight to the Outdoors via Vision Glazing (sq ft)"},"View Types"]
[null,null,null,null,null,null,"Analysis Area ID","Analysis Area Description","Analysis Area \nsDA300/50% \n(%)","Analysis Area \nASE1000,250 \n(%)","ASE1000,250 is \n10% or Less of \nFloor Area",null,{"$f":"CONCATENATE(\"Floor Area with Daylight Illuminance Levels Between 300 lux and 3,000 lux \",E2)","v":"Floor Area with Daylight Illuminance Levels Between 300 lux and 3,000 lux (sq ft)"},null,{"$f":"IF(E2= \"(sq ft)\",\"Size of Calculation Grid (ft)\",\"Size of Calculation Grid (m)\")","v":"Size of Calculation Grid (ft)"},{"$f":"CONCATENATE(\"Floor Area with Daylight Illuminance Levels Between 300 lux and 3,000 lux \",E2)","v":"Floor Area with Daylight Illuminance Levels Between 300 lux and 3,000 lux (sq ft)"},"Criteria Met",null,{"$f":"CONCATENATE(\"Non-Inpatient Perimeter Area With Direct Line of Sight to Outdoors \",E2)","v":"Non-Inpatient Perimeter Area With Direct Line of Sight to Outdoors (sq ft)"},null,"First View Type","Second View Type"]
[null,null,null,null,{"$f":"IF(Introduction!G9=\"feet\",\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"}]
[{"$f":"IF(E10>=0,0,1)","v":0},"1st Floor",null,"Office",2201.63,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J10),\"N/A\",(IF(J10/E10<0.1,\"Yes\",\"No\"))),\"No\")","v":"N/A"},null,null,null,10,1042.48,{"$f":"IFERROR(IF(OR(ISBLANK(O10),ISBLANK(P10)),\"N/A\",(IF(OR(AND($E$2=\"(sq ft)\",E10>150,O10<=10),AND($E$2=\"(sq ft)\",E10<=150,O10<=3),AND($E$2=\"(sq m)\",E10>14,O10<=3),AND($E$2=\"(sq m)\",E10<=14,O10<=0.9)),\"Yes\",\"No\"))),\"No\")","v":"Yes"},null,null,1656.82,"View Type 2","View Type 3"]
[{"$f":"IF(E11>=0,0,1)","v":0},"2nd Floor",null,"Office",6940.47,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J11),\"N/A\",(IF(J11/E11<0.1,\"Yes\",\"No\"))),\"No\")","v":"N/A"},null,null,null,10,3566.37,{"$f":"IFERROR(IF(OR(ISBLANK(O11),ISBLANK(P11)),\"N/A\",(IF(OR(AND($E$2=\"(sq ft)\",E11>150,O11<=10),AND($E$2=\"(sq ft)\",E11<=150,O11<=3),AND($E$2=\"(sq m)\",E11>14,O11<=3),AND($E$2=\"(sq m)\",E11<=14,O11<=0.9)),\"Yes\",\"No\"))),\"No\")","v":"Yes"},null,null,6692.85,"View Type 2","View Type 3"]
[0,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,"N/A"]
[{"$f":"IF(E14>=0,0,1)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(J14),\"N/A\",(IF(J14/E14<0.1,\"Yes\",\"No\"))),\"No\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(IF(OR(ISBLANK(O14),ISBLANK(P14)),\"N/A\",(IF(OR(AND($E$2=\"(sq ft)\",E14>150,O14<=10),AND($E$2=\"(sq ft)\",E14<=150,O14<=3),AND($E$2=\"(sq m)\",E14>14,O14<=3),AND($E$2=\"(sq m)\",E14<=14,O14<=0.9)),\"Yes\",\"No\"))),\"No\")","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,"N/A"]
["A",{"$f":"CONCATENATE(IF(Introduction!G12=\"LEED v4 BD+C: Healthcare\",\"Total perimeter floor area \",\"Total regularly occupied floor area \"),E2)","v":"Total regularly occupied floor area (sq ft)"},null,null,{"$f":"SUM(E10:E16)","v":9142.1},null,{"$f":"IF(Introduction!G12=\"LEED v4 BD+C: Healthcare\",\"sDA300/50% for all perimeter floor area (%)\",\"sDA300/50% for all regularly occupied floor area (%)\")","v":"sDA300/50% for all regularly occupied floor area (%)"},null,null,null,{"$f":"MIN(I10:I16)","v":0},null,{"$f":"CONCATENATE(\"Total daylighted area \",E2)","v":"Total daylighted area (sq ft)"},null,{"$f":"CONCATENATE(\"Total daylighted area \",E2)","v":"Total daylighted area (sq ft)"},null,{"$f":"SUMIF(Q10:Q16,\"Yes\",P10:P16)","v":4608.8500000000004},null,{"$f":"CONCATENATE(\"Total area with access to views \",E2)","v":"Total area with access to views (sq ft)"},null,null,{"$f":"SUMIFS(T10:T16,U10:U16,\"=View*\",V10:V16,\"=View*\")","v":8349.67}]
[null,null,null,null,null,null,{"$f":"IF(Introduction!G12=\"LEED v4 BD+C: Healthcare\",\"ASE1000,250 is 10% or less for all perimeter floor area\",\"ASE1000,250 is 10% or less for all regularly occupied floor area\")","v":"ASE1000,250 is 10% or less for all regularly occupied floor area"},null,null,null,{"$f":"IF(COUNTIF(K10:K16,\"No\"),\"No\",IF(COUNTIF(K10:K16,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"},null,{"$f":"SUM(M10:M16)","v":0},null,null,null,null,"Healthcare",{"$f":"CONCATENATE(\"Total inpatient area \",E2)","v":"Total inpatient area (sq ft)"},{"$f":"SUM(T10:T16)","v":8349.67},{"$f":"CONCATENATE(\"Total inpatient area with access to views \",E2)","v":"Total inpatient area with access to views (sq ft)"},{"$f":"SUMIFS(T10:T16,U10:U16,\"=View*\",V10:V16,\"=View*\")","v":8349.67}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Total non-inpatient area \",E2)","v":"Total non-inpatient area (sq ft)"},{"$f":"SUM(S10:S16)","v":0},{"$f":"CONCATENATE(\"Total non-inpatient area with access to views \",E2)","v":"Total non-inpatient area with access to views (sq ft)"},{"$f":"SUMIFS(S10:S16,U10:U16,\"=View*\",V10:V16,\"=View*\")","v":0}]

{"sheet":"Summary","index":2,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Summary ",null,null,{"$f":"Calculator!E2","v":"(sq ft)"}]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab."]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",F3)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Calculator!E17","v":9142.1}]
[]
[null,null,"EQ Credit Daylight"]
[]
[null,null,"Option 1. Simulation: Spatial Daylight Autonomy and Annual Sunlight Exposure"]
[]
[null,null,"sDA300/50% for all regularly occupied floor area (%)",null,null,null,null,{"$f":"Calculator!K17","v":0}]
[]
[null,null,"ASE1000,250 is 10% or less for all regularly occupied floor area",null,null,null,null,{"$f":"Calculator!K18","v":"N/A"}]
[]
[null,null,"Option 2. Simulation: Illuminance Calculations"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",F3)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Calculator!M18","v":0}]
[]
[null,null,"Percent of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H18/H6,0)","v":0}]
[]
[null,null,"Option 3. Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",F3)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Calculator!Q17","v":4608.8500000000004}]
[]
[null,null,"Percent of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H24/H6,0)","v":0.50413471740628524}]
[]
[null,null,"EQ Credit Quality Views"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area with access to quality views \",F3)","v":"Total regularly occupied area with access to quality views (sq ft)"},null,null,null,null,{"$f":"Calculator!V17","v":8349.67}]
[]
[null,null,"Percent of regularly occupied area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H30/H6,0)","v":0.91332079062797389}]

{"sheet":"Summary - HC","index":3,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Summary for Healthcare",null,null,null,{"$f":"Calculator!E2","v":"(sq ft)"}]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab."]
[]
[null,null,"EQ Credit Daylight"]
[]
[null,null,{"$f":"CONCATENATE(\"Total perimeter area \",G3)","v":"Total perimeter area (sq ft)"},null,null,null,null,{"$f":"Calculator!E17","v":9142.1}]
[]
[null,null,"Option 1. Simulation: Spatial Daylight Autonomy and Annual Sunlight Exposure"]
[]
[null,null,"sDA300/50% for all perimeter floor area (%)",null,null,null,null,{"$f":"Calculator!K17","v":0}]
[]
[null,null,"ASE1000,250 is 10% or less for all perimeter floor area",null,null,null,null,{"$f":"Calculator!K18","v":"N/A"}]
[]
[null,null,"Option 2. Simulation: Illuminance Calculations"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted perimeter area \",G3)","v":"Total daylighted perimeter area (sq ft)"},null,null,null,null,{"$f":"Calculator!M18","v":0}]
[]
[null,null,"Percent of perimeter area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H18/H8,0)","v":0}]
[]
[null,null,"Option 3. Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted perimeter area \",G3)","v":"Total daylighted perimeter area (sq ft)"},null,null,null,null,{"$f":"Calculator!Q17","v":4608.8500000000004}]
[]
[null,null,"Percent of perimeter area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H24/H8,0)","v":0.50413471740628524}]
[]
[null,null,"EQ Credit Quality Views"]
[]
[null,null,"Inpatient Area"]
[]
[null,null,{"$f":"CONCATENATE(\"Total inpatient area with access to quality views \",G3)","v":"Total inpatient area with access to quality views (sq ft)"},null,null,null,null,{"$f":"Calculator!V18","v":8349.67}]
[]
[null,null,{"$f":"CONCATENATE(\"Total inpatient area \",G3)","v":"Total inpatient area (sq ft)"},null,null,null,null,{"$f":"Calculator!T18","v":8349.67}]
[]
[null,null,"Percent of inpatient area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H32/H34,0)","v":1}]
[]
[null,null,"Non-Inpatient Area"]
[]
[null,null,{"$f":"CONCATENATE(\"Total non-inpatient perimeter area with access to quality views \",G3)","v":"Total non-inpatient perimeter area with access to quality views (sq ft)"},null,null,null,null,{"$f":"Calculator!V19","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total non-inpatient perimeter area \",G3)","v":"Total non-inpatient perimeter area (sq ft)"},null,null,null,null,{"$f":"Calculator!T19","v":0}]
[]
[null,null,"Percent of non-inpatient perimeter area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H40/H42,0)","v":0}]

{"sheet":"Summary - EB","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Summary for Existing Buildings",null,null,null,{"$f":"Calculator!E2","v":"(sq ft)"}]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tab."]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",G3)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Calculator!E17","v":9142.1}]
[]
[null,null,"Option 1. Daylight Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",G3)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Calculator!Q17","v":4608.8500000000004}]
[]
[null,null,"Percent of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H10/H6,0)","v":0.50413471740628524}]
[]
[null,null,"Option 2. Quality Views"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area with access to quality views \",G3)","v":"Total regularly occupied area with access to quality views (sq ft)"},null,null,null,null,{"$f":"Calculator!V17","v":8349.67}]
[]
[null,null,"Percent of regularly occupied area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H16/H6,0)","v":0.91332079062797389}]