{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Daylight","Quality Views","Quality Views HC","Summary D+C","Summary HC","Summary WDC","Summary O+M"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"comments":3,"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":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[46,2,46,4],[50,2,50,4],[13,4,13,9],[26,4,26,9],[32,4,32,9],[35,4,35,9],[41,2,41,6],[49,2,49,4],[48,2,48,4],[47,2,47,4],[23,4,23,9],[20,4,20,9],[43,2,43,4],[44,2,44,4],[41,7,41,9],[2,4,2,9],[29,4,29,9],[42,7,42,8],[42,2,42,5],[45,2,45,4],[17,4,17,9]]}
[]
[]
[null,null,null,null,"Daylight and Quality Views Calculator\nLEED v4 EQ Credit Daylight, EQ Credit Quality Views, and EQ Credit Daylight and Quality Views"]
[]
[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,null,null,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,"If attempting EQ Credit: Daylight, complete the Daylight tab for each regularly occupied space."]
[]
[]
[null,null,null,null,"For Healthcare projects"]
[null,null,null,null,"Complete the Daylight tab for each regularly occupied space within the perimeter."]
[]
[null,null,null,null,"For Operations and Maintenance projects"]
[null,null,null,null,"If attempting Option 1, complete the Measurement section on the Daylight tab for each regularly occupied space."]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"If attempting EQ Credit: Quality Views, complete the Quality Views tab for each regularly occupied space."]
[]
[null,null,null,null,"For Healthcare projects"]
[null,null,null,null,"Complete the Quality Views HC tab for each floor in the project building."]
[]
[null,null,null,null,"For Warehouses and Distribution Centers projects"]
[null,null,null,null,"Complete the Quality Views tab for each regularly occuiped space.  Indicate if the space is bulk storage, sorting, and distribution."]
[]
[null,null,null,null,"For Operations and Maintenance projects"]
[null,null,null,null,"If attempting Option 2, complete the Quality Views tab for each regularly occupied space."]
[]
[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,"Assumptions"]
[null,null,"For Healthcare projects attempting Quality Views"]
[null,null,"IP",null,null,null,null,"SI"]
[null,null,"Floor Plate Area\n(sq ft)",null,null,null,"Minimum \nPerimeter Area\n(sq ft)","Floor Plate Area\n(sq m)",null,"Mininum \nPerimeter Area\n(sq m)"]
[null,null,"less than",null,null,20000,7348,"less than",1400,682]
[null,null,"less than",null,null,25000,8785,"less than",1800,816]
[null,null,"less than",null,null,30000,10087,"less than",2300,937]
[null,null,"less than",null,null,35000,11292,"less than",2800,1049]
[null,null,"less than",null,null,40000,12425,"less than",3300,1154]
[null,null,"less than",null,null,45000,13500,"less than",3700,1254]
[null,null,"less than",null,null,50000,14528,"less than",4200,1349]
[null,null,"greater than",null,null,50001,15516,"greater than",4601,1441]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"V02",null,"UOM"]
[null,null,null,null,null,null,null,null,null,null,"Copyright © 2012",null,{"$f":"IF(J10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"U.S. Green Building Council",null,"IP = 1, SI = 2"]
[null,null,null,null,null,null,null,null,null,null,"All Rights Reserved"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CONCATENATE"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M55=1,\"(sq ft)\",\"(sq m)\")","v":"(sq ft)"}]

{"sheet":"Daylight","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,3,5,3],[23,5,23,8],[23,1,23,2],[4,5,4,9],[4,1,5,1],[4,2,5,2]]}
[]
[null,"Daylight"]
[]
[]
[null,"Space ID","Space Description",{"$f":"CONCATENATE(\"Total \nRegularly Occupied \nArea \n\",Instructions!$M$59)","v":"Total \rRegularly Occupied \rArea \r(sq ft)"},null,"Option 1 \nSimulation: Spatial Daylight Autonomy and Annual Sunlight Exposure",null,null,null,null,null,"Option 2 \nSimulation: \nIlluminance Calculations",null,"Option 3\n Measurement \n(O+M Option 1)"]
[null,null,null,null,null,"Analysis Area ID","Analysis Area Description","Analysis Area \nsDA300/50% \n(%)","Analysis Area \nASE1000,250 \n(%)","ASE1000,250\nCriteria Met",null,{"$f":"CONCATENATE(\"Area with daylight illuminance levels between 300 lux and 3,000 lux \n\",Instructions!$M$59)","v":"Area with daylight illuminance levels between 300 lux and 3,000 lux \r(sq ft)"},null,{"$f":"CONCATENATE(\"Area with daylight illuminance levels between 300 lux and 3,000 lux \n\",Instructions!$M$59)","v":"Area with daylight illuminance levels between 300 lux and 3,000 lux \r(sq ft)"}]
[{"$f":"IF(D7>=0,0,1)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(I7),\"N/A\",(IF(I7<=10,\"Yes\",\"No\"))),\"No\")","v":"N/A"}]
[0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(I8),\"N/A\",(IF(I8<=10,\"Yes\",\"No\"))),\"No\")","v":"N/A"}]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[{"$f":"IF(D15>=0,0,1)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(I15),\"N/A\",(IF(I15<=10,\"Yes\",\"No\"))),\"No\")","v":"N/A"}]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,null,null,"N/A"]
[{"$f":"IF(D21>=0,0,1)","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(I21),\"N/A\",(IF(I21<=10,\"Yes\",\"No\"))),\"No\")","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,"N/A"]
["A",{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,{"$f":"SUM(D7:D23)","v":0},null,"Average sDA300/50% value",null,null,null,{"$f":"IFERROR(SUMPRODUCT(--(J7:J23<>\"N/A\"),H7:H23,D7:D23)/SUM(D7:D23),0)","v":0},null,{"$f":"CONCATENATE(\"Total daylighted area \",Instructions!$M$59)","v":"Total daylighted area (sq ft)"},null,{"$f":"CONCATENATE(\"Total daylighted area \",Instructions!$M$59)","v":"Total daylighted area (sq ft)"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L23)","v":0},null,{"$f":"SUM(N7:N23)","v":0}]

{"sheet":"Quality Views","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,2,26,8],[28,2,28,8],[24,1,24,8],[23,1,23,8],[25,1,28,1],[25,2,25,8],[27,2,27,8],[4,8,4,9],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,5,5,5],[4,7,5,7]]}
[]
[null,"Quality Views"]
[]
[]
[null,"Space ID","Space Description",{"$f":"CONCATENATE(\"Total Regularly Occupied Area \n\",Instructions!$M$59)","v":"Total Regularly Occupied Area \r(sq ft)"},null,"For Warehouses and Distribution Centers projects\n\nOffice or bulk storage, sorting, \nand distribution for each space",null,{"$f":"CONCATENATE(\"Area with Direct \nLine of Sight \nto the Outdoors \nvia Vision Glazing \n\",Instructions!$M$59)","v":"Area with Direct \rLine of Sight \rto the Outdoors \rvia Vision Glazing \r(sq ft)"},"View Types"]
[null,null,null,null,null,null,null,null,"First \nView Type","Second \nView Type",null,"Count for identical view types"]
[{"$f":"IF(D7>=0,0,1)","v":0},1,"Office (115)",147,null,null,null,146,"View Type 2","View Type 4",null,{"$f":"IF(I7=J7,1,0)","v":0}]
[0,2,"Office (113/114)",225,null,null,null,220.5,"View Type 2","View Type 4",null,0]
[0,3,"Office (112)",117,null,null,null,116.5,"View Type 2","View Type 4",null,0]
[0,4,"Office (111)",122,null,null,null,121.5,"View Type 2","View Type 4",null,0]
[0,5,"Office (110)",121,null,null,null,120.5,"View Type 2","View Type 4",null,0]
[0,6,"Office (109)",118,null,null,null,117.5,"View Type 2","View Type 4",null,0]
[0,7,"Roger's Office (108)",208,null,null,null,208,"View Type 2","View Type 4",null,0]
[0,8,"Lounge (107)",128,null,null,null,127.5,"View Type 2","View Type 4",null,0]
[{"$f":"IF(D15>=0,0,1)","v":0},9,"Admin (122)",189,null,null,null,167,"View Type 2","View Type 1",null,{"$f":"IF(I15=J15,1,0)","v":0}]
[0,10,"Office (103)",139,null,null,null,138.5,"View Type 2","View Type 4",null,0]
[0,11,"Office (104)",139,null,null,null,139,"View Type 2","View Type 4",null,0]
[0,12,"EA Office (105)",137.4,null,null,null,137,"View Type 2","View Type 4",null,0]
[0,13,"Viki's Office (106)",250,null,null,null,249.5,"View Type 2","View Type 4",null,0]
[0,14,"Conf (101)",470,null,null,null,97.5,"View Type 2","View Type 1",null,0]
[{"$f":"IF(D21>=0,0,1)","v":0},15,"Conf (102)",246,null,null,null,46.5,"View Type 2","View Type 1",null,{"$f":"IF(I21=J21,1,0)","v":0}]
[null,16,"Reception (100)",54,null,null,null,17.5,"View Type 2",null,null,{"$f":"IF(I22=J22,1,0)","v":0}]
[null,17,"Lounge (118)",194,null,null,null,186.5,"View Type 2","View Type 4",null,{"$f":"IF(I23=J23,1,0)","v":0}]
["A",{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,null,null,null,{"$f":"SUM(D7:D23)","v":3004.4}]
[null,{"$f":"CONCATENATE(\"Total regularly occupied area with access to views \",Instructions!$M$59)","v":"Total regularly occupied area with access to views (sq ft)"},null,null,null,null,null,null,null,{"$f":"SUMIFS(H7:H23,I7:I23,\"=View*\",J7:J23,\"=View*\",L7:L23,\"=0\")","v":2339.5}]
[null,"For Warehouses and Distribution \nCenters projects",{"$f":"CONCATENATE(\"Total regularly occupied area in office portions of the building \",Instructions!$M$59)","v":"Total regularly occupied area in office portions of the building (sq ft)"},null,null,null,null,null,null,{"$f":"SUMIF(F7:F23,\"=Office\",D7:D23)","v":0}]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in office portions of the building with access to views \",Instructions!$M$59)","v":"Total regularly occupied area in office portions of the building with access to views (sq ft)"},null,null,null,null,null,null,{"$f":"SUMIFS(H7:H23,I7:I23,\"=View*\",J7:J23,\"=View*\",F7:F23,\"=Office\")","v":0}]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building \",Instructions!$M$59)","v":"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building (sq ft)"},null,null,null,null,null,null,{"$f":"SUMIF(F7:F23,\"=Bulk storage‚ sorting‚ and distribution\",D7:D23)","v":0}]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building with access to views \",Instructions!$M$59)","v":"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building with access to views (sq ft)"},null,null,null,null,null,null,{"$f":"SUMIFS(H7:H23,I7:I23,\"=View*\",J7:J23,\"=View*\",F7:F23,\"=Bulk storage‚ sorting‚ and distribution\")","v":0}]

{"sheet":"Quality Views HC","index":3,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,1,14,4],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,6,5],[13,1,13,4],[20,7,21,7],[20,8,21,8],[20,9,20,10],[29,1,29,9],[30,1,30,9],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6]]}
[]
[null,"Quality Views - Healthcare"]
[]
[]
[null,"Inpatient Floors"]
[null,"Complete the table for all inpatient floors.  Floors may be grouped for simplicity."]
[null,"Floor ID",{"$f":"CONCATENATE(\"Total \nRegularly \nOccupied Area\n\",Instructions!$M$59)","v":"Total \nRegularly \nOccupied Area\n(sq ft)"},{"$f":"CONCATENATE(\"Regularly Occupied Area with Direct Line of Sight to the Outdoors via Vision Glazing\n \",Instructions!$M$59)","v":"Regularly Occupied Area with Direct Line of Sight to the Outdoors via Vision Glazing\n (sq ft)"},"View Types"]
[null,null,null,null,"First View Type","Second View Type",null,null,null,null,null,null,"Count for identical view types"]
[{"$f":"IF(B9>=0,0,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E9=F9,1,0)","v":1}]
[{"$f":"IF(B10>=0,0,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E10=F10,1,0)","v":1}]
[{"$f":"IF(B11>=0,0,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E11=F11,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E12=F12,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E13=F13,1,0)","v":1}]
["A",{"$f":"CONCATENATE(\"Total regularly occupied area on inpatient floors \",Instructions!$M$59)","v":"Total regularly occupied area on inpatient floors (sq ft)"},null,null,null,{"$f":"SUM(C9:C13)","v":0}]
[null,{"$f":"CONCATENATE(\"Total regularly occupied area on inpatient floors with access to views \",Instructions!$M$59)","v":"Total regularly occupied area on inpatient floors with access to views (sq ft)"},null,null,null,{"$f":"SUMIF(M9:M13,\"=0\",D9:D13)","v":0}]
[]
[]
[]
[null,"Non-Inpatient Floors"]
[null,"Complete the table for all non-inpatient floors.  Each floor must be calculated separately."]
[null,"Floor ID",{"$f":"CONCATENATE(\"Total \nFloor Plate Area\n\",Instructions!$M$59)","v":"Total \nFloor Plate Area\n(sq ft)"},{"$f":"CONCATENATE(\"Total \nPerimeter Area\n\",Instructions!$M$59)","v":"Total \nPerimeter Area\n(sq ft)"},{"$f":"CONCATENATE(\"Minimum \nPerimeter Area\n\",Instructions!$M$59)","v":"Minimum \nPerimeter Area\n(sq ft)"},"Floor Meets Minimum \nPerimeter Area Requirements","Percent Perimeter Area Exceeding\nMinimum Perimeter Area Requirement\n(%)",{"$f":"CONCATENATE(\"Total Regularly Occupied Area within Perimeter\n\",Instructions!$M$59)","v":"Total Regularly Occupied Area within Perimeter\n(sq ft)"},{"$f":"CONCATENATE(\"Perimeter Area with Direct Line of Sight to the Outdoors via Vision Glazing\n\",Instructions!$M$59)","v":"Perimeter Area with Direct Line of Sight to the Outdoors via Vision Glazing\n(sq ft)"},"View Types"]
[null,null,null,null,null,null,null,null,null,"First View Type","Second View Type",null,"Count for identical view types"]
[{"$f":"IF(B23>=0,0,0)","v":0},null,null,null,{"$f":"IF(C23=\"\",0,IF(Instructions!$M$55=1,IF(C23>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C23)+1)),IF(C23>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C23)+1))))","v":0},{"$f":"IF(AND(C23>0,D23>0),IF(D23>=E23,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},{"$f":"IF(F23=\"Yes\",(D23-E23)/E23,0)","v":0},null,null,null,null,null,{"$f":"IF(J23=K23,1,0)","v":1}]
[{"$f":"IF(B24>=0,0,0)","v":0},null,null,null,{"$f":"IF(C24=\"\",0,IF(Instructions!$M$55=1,IF(C24>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C24)+1)),IF(C24>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C24)+1))))","v":0},{"$f":"IF(AND(C24>0,D24>0),IF(D24>=E24,\"Yes\",\"No\"),\"N/A\")","v":"N/A"},{"$f":"IF(F24=\"Yes\",(D24-E24)/E24,0)","v":0},null,null,null,null,null,{"$f":"IF(J24=K24,1,0)","v":1}]
[{"$f":"IF(B25>=0,0,0)","v":0},null,null,null,{"$f":"IF(C25=\"\",0,IF(Instructions!$M$55=1,IF(C25>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C25)+1)),IF(C25>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C25)+1))))","v":0},"N/A",0,null,null,null,null,null,1]
[{"$f":"IF(B26>=0,0,0)","v":0},null,null,null,{"$f":"IF(C26=\"\",0,IF(Instructions!$M$55=1,IF(C26>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C26)+1)),IF(C26>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C26)+1))))","v":0},"N/A",0,null,null,null,null,null,1]
[{"$f":"IF(B27>=0,0,0)","v":0},null,null,null,{"$f":"IF(C27=\"\",0,IF(Instructions!$M$55=1,IF(C27>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C27)+1)),IF(C27>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C27)+1))))","v":0},"N/A",0,null,null,null,null,null,1]
[null,null,null,null,{"$f":"IF(C28=\"\",0,IF(Instructions!$M$55=1,IF(C28>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C28)+1)),IF(C28>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C28)+1))))","v":0},"N/A",0,null,null,null,null,null,1]
[null,null,null,null,{"$f":"IF(C29=\"\",0,IF(Instructions!$M$55=1,IF(C29>Instructions!$F$51,Instructions!$G$51,INDEX(Instructions!$G$44:$G$51,COUNTIF(Instructions!$F$44:$F$51,\"<\"&C29)+1)),IF(C29>Instructions!$I$51,Instructions!$J$51,INDEX(Instructions!$J$44:$J$51,COUNTIF(Instructions!$I$44:$I$51,\"<\"&C29)+1))))","v":0},"N/A",0,null,null,null,null,null,1]
["B",{"$f":"CONCATENATE(\"Total regularly occupied area within perimeter on non-inpatient floors \",Instructions!$M$59)","v":"Total regularly occupied area within perimeter on non-inpatient floors (sq ft)"},null,null,null,null,null,null,null,null,{"$f":"SUM(H23:H29)","v":0}]
[null,{"$f":"CONCATENATE(\"Total regularly occupied area within perimeter on non-inpatient floors with access to views \",Instructions!$M$59)","v":"Total regularly occupied area within perimeter on non-inpatient floors with access to views (sq ft)"},null,null,null,null,null,null,null,null,{"$f":"SUMIF(M23:M29,\"=0\",I23:I29)","v":0}]

{"sheet":"Summary D+C","index":4,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Summary for Design and Construction Rating Systems"]
[null,null,"(except Healthcare and Warehouses and Distribution Centers)"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[]
[null,null,"EQ Credit Daylight"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!D24","v":0}]
[]
[null,null,"Option 1. Simulation: Spatial Daylight Autonomy and Annual Sunlight Exposure"]
[]
[null,null,"Average sDA300/50% value",null,null,null,null,{"$f":"Daylight!J24","v":0}]
[]
[null,null,"ASE1000,250 is 10% or less for all regularly occupied floor area",null,null,null,null,{"$f":"IF(COUNTIF(Daylight!J7:J23,\"No\"),\"No\",IF(COUNTIF(Daylight!J7:J23,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,"Option 2. Simulation: Illuminance Calculations"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",Instructions!$M$59)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!L25","v":0}]
[]
[null,null,"Percentage of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H20/H10,0)","v":0}]
[]
[null,null,"Option 3. Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",Instructions!$M$59)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!N25","v":0}]
[]
[null,null,"Percentage of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H26/H10,0)","v":0}]
[]
[]
[null,null,"EQ Credit Quality Views"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J24","v":3004.4}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area with access to quality views \",Instructions!$M$59)","v":"Total regularly occupied area with access to quality views (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J25","v":2339.5}]
[]
[null,null,"Percentage of regularly occupied area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H35/H33,0)","v":0.77869125282918383}]

{"sheet":"Summary HC","index":5,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[48,2,49,5],[52,2,52,5],[45,2,46,5]]}
[]
[]
[null,null,"Summary for Healthcare",null,null,null,{"$f":"Daylight!D2","v":0}]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[]
[null,null,"EQ Credit Daylight"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area within perimeter \",Instructions!$M$59)","v":"Total regularly occupied area within perimeter (sq ft)"},null,null,null,null,{"$f":"Daylight!D24","v":0}]
[]
[null,null,"Option 1. Simulation: Spatial Daylight Autonomy and Annual Sunlight Exposure"]
[]
[null,null,"Average sDA300/50% value",null,null,null,null,{"$f":"Daylight!J24","v":0}]
[]
[null,null,"ASE1000,250 is 10% or less for all regularly occupied area within perimeter",null,null,null,null,{"$f":"IF(COUNTIF(Daylight!J7:J23,\"No\"),\"No\",IF(COUNTIF(Daylight!J7:J23,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,"Option 2. Simulation: Illuminance Calculations"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area within perimeter \",Instructions!$M$59)","v":"Total daylighted regularly occupied area within perimeter (sq ft)"},null,null,null,null,{"$f":"Daylight!L25","v":0}]
[]
[null,null,"Percentage of regularly occupied area within perimeter that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H19/H9,0)","v":0}]
[]
[null,null,"Option 3. Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area within perimeter \",Instructions!$M$59)","v":"Total daylighted regularly occupied area within perimeter (sq ft)"},null,null,null,null,{"$f":"Daylight!N25","v":0}]
[]
[null,null,"Percentage of regularly occupied area within perimeter that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H25/H9,0)","v":0}]
[]
[]
[null,null,"EQ Credit Quality Views"]
[]
[null,null,"Inpatient Floors"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area on inpatient floors \",Instructions!$M$59)","v":"Total regularly occupied area on inpatient floors (sq ft)"},null,null,null,null,{"$f":"'Quality Views HC'!F14","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area on inpatient floors with access to views \",Instructions!$M$59)","v":"Total regularly occupied area on inpatient floors with access to views (sq ft)"},null,null,null,null,{"$f":"'Quality Views HC'!F15","v":0}]
[]
[null,null,"Percentage of regularly occupied area on inpatient floors with access to views (%)",null,null,null,null,{"$f":"IFERROR(H36/H34,0)","v":0}]
[]
[null,null,"Non-Inpatient Floors"]
[]
[null,null,"Each non-inpatient floor meets the minimum perimeter area",null,null,null,null,{"$f":"IF(COUNTIF('Quality Views HC'!F23:F29,\"No\"),\"No\",IF(COUNTIF('Quality Views HC'!F23:F29,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area within perimeter on non-inpatient floors \",Instructions!$M$59)","v":"Total regularly occupied area within perimeter on non-inpatient floors (sq ft)"},null,null,null,null,{"$f":"'Quality Views HC'!K30","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area within perimeter on non-inpatient floors with access to views \",Instructions!$M$59)","v":"Total regularly occupied area within perimeter on non-inpatient floors with access to views (sq ft)"},null,null,null,null,{"$f":"'Quality Views HC'!K31","v":0}]
[]
[]
[null,null,"Percentage of regularly occupied area within perimeter on non-inpatient floors with access to views (%)",null,null,null,null,{"$f":"IFERROR(H46/H44,0)","v":0}]
[]
[]
[null,null,"For projects attempting exemplary performance"]
[null,null,"Each non-inpatient floor is 10% or greater than the minimum perimeter area",null,null,null,null,{"$f":"IF(H42=\"Yes\",IF(COUNTIF('Quality Views HC'!G23:G29,\">=.1\"),\"Yes\",\"No\"),\"No\")","v":"No"}]

{"sheet":"Summary WDC","index":6,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[43,2,44,5],[46,2,47,5]]}
[]
[]
[null,null,"Summary for Warehouses and Distribution Centers"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[]
[null,null,"EQ Credit Daylight"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!D24","v":0}]
[]
[null,null,"Option 1. Simulation: Spatial Daylight Autonomy and Annual Sunlight Exposure"]
[]
[null,null,"Average sDA300/50% value",null,null,null,null,{"$f":"Daylight!J24","v":0}]
[]
[null,null,"ASE1000,250 is 10% or less for all regularly occupied area",null,null,null,null,{"$f":"IF(COUNTIF(Daylight!J7:J23,\"No\"),\"No\",IF(COUNTIF(Daylight!J7:J23,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[]
[null,null,"Option 2. Simulation: Illuminance Calculations"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",Instructions!$M$59)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!L25","v":0}]
[]
[null,null,"Percentage of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H19/H9,0)","v":0}]
[]
[null,null,"Option 3. Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",Instructions!$M$59)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!N25","v":0}]
[]
[null,null,"Percentage of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H25/H9,0)","v":0}]
[]
[]
[null,null,"EQ Credit Quality Views"]
[]
[null,null,"Office Portions of the Building"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in office portions of the building \",Instructions!$M$59)","v":"Total regularly occupied area in office portions of the building (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J26","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in office portions of the building with access to views \",Instructions!$M$59)","v":"Total regularly occupied area in office portions of the building with access to views (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J27","v":0}]
[]
[null,null,"Percentage of regularly occupied area in office portions of the building with access to views (%)",null,null,null,null,{"$f":"IFERROR(H36/H34,0)","v":0}]
[]
[null,null,"Bulk Storage, Sorting and Distribution Portions of the Building"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building \",Instructions!$M$59)","v":"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J28","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building with access to views \",Instructions!$M$59)","v":"Total regularly occupied area in bulk storage, sorting, and distribution portions of the building with access to views (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J29","v":0}]
[]
[]
[null,null,"Percentage of regularly occupied area in bulk storage, sorting, and distribution portions of the building with access to views (%)",null,null,null,null,{"$f":"IFERROR(H44/H42,0)","v":0}]

{"sheet":"Summary O+M","index":7,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,2,2,7]]}
[]
[]
[null,null,"Summary for Operations and Maintenance Rating Systems"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see the previous tabs."]
[]
[null,null,"Option 1. Daylight Measurement"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!D24","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total daylighted regularly occupied area \",Instructions!$M$59)","v":"Total daylighted regularly occupied area (sq ft)"},null,null,null,null,{"$f":"Daylight!N25","v":0}]
[]
[null,null,"Percentage of regularly occupied area that is daylighted (%)",null,null,null,null,{"$f":"IFERROR(H10/H8,0)","v":0}]
[]
[null,null,"Option 2. Quality Views"]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area \",Instructions!$M$59)","v":"Total regularly occupied area (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J24","v":3004.4}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied area with access to quality views \",Instructions!$M$59)","v":"Total regularly occupied area with access to quality views (sq ft)"},null,null,null,null,{"$f":"'Quality Views'!J25","v":2339.5}]
[]
[null,null,"Percentage of regularly occupied area with access to views (%)",null,null,null,null,{"$f":"IFERROR(H18/H16,0)","v":0.77869125282918383}]