{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","A and D","B and C","E and F ","G and H","I (India ACP)","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":2,"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":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,4,2,7],[17,4,17,7],[19,4,19,7],[23,4,23,5],[24,4,24,7],[4,4,4,5],[5,4,5,5],[12,4,12,5],[13,4,13,7],[15,4,15,7],[10,4,10,6],[6,4,6,6],[21,4,21,7]]}
[]
[]
[null,null,null,null,"Interior Lighting Calculator\nLEED v4 EQ Credit Interior Lighting, Option 2. Lighting Quality"]
[]
[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,"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,"Complete the \"A and D\" tab if attempting:\nA. Light fixture luminance\nD. Direct-only overhead lighting"]
[]
[null,null,null,null,"Complete the \"B and C\" tab if attempting:\nB. Color rendering index (CRI)\nC. Lamp life"]
[]
[null,null,null,null,"Complete the \"E and F\" tab if attempting:\nE. Surface reflectance: ceilings, walls, floors\nF. Surface reflectance: furnishings"]
[]
[null,null,null,null,"Complete the \"G and H\" tab if attempting:\nG. Surface illuminance ratio: wall to work surface\nH. Surface illuminance ratio: ceiling to work surface"]
[]
[null,null,null,null,"For projects located in India pursuing the regional alternative compliance path\nComplete the \"I (India ACP)\" tab"]
[]
[null,null,null,null,"Step 4. "]
[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,null,"V03",null,"UOM"]
[null,null,null,null,null,null,null,null,"Copyright © 2015",null,{"$f":"IF(H10=\"IP units\",1,2)","v":1}]
[null,null,null,null,null,null,null,null,"U.S. Green Building Council",null,"1 = IP, 2 = SI"]
[null,null,null,null,null,null,null,null,"All Rights Reserved"]

{"sheet":"A and D","index":1,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,5,3],[5,4,5,6],[5,7,5,10],[17,2,17,9],[18,1,20,1],[18,2,18,9],[19,2,19,9],[20,2,20,9]]}
[]
[null,"A. Light Fixture Luminance and D. Direct-Only Overhead Lighting"]
[]
[]
[null,"Complete the table below. Include light fixtures for all regularly occupied spaces."]
[null,"General Information",null,null," A. Light Fixture Luminance",null,null,"D. Direct-Only Overhead Lighting"]
[null,"Light Fixture Description","Manufacturer Name\n(Optional)","Model Number\nor Name\n(Optional)","Is luminance less than 2,500 cd/m2 between 45˚ and 90˚  from nadir?","Exclude \nlight fixture?","Meets \nLuminance Requirements","Connected \nLoad \n(W)","Number\nof\nFixtures","Total \nConnected \nLoad \n(W)","Is this\ndirect-only overhead lighting?"]
[{"$f":"IF(B8>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IF(AND(ISBLANK(E8),ISBLANK(F8)),\"N/A\",IF(E8=\"Yes\",\"Yes\",IF(F8=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,{"$f":"H8*I8","v":0}]
[{"$f":"IF(B9>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IF(AND(ISBLANK(E9),ISBLANK(F9)),\"N/A\",IF(E9=\"Yes\",\"Yes\",IF(F9=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,{"$f":"H9*I9","v":0}]
[0,null,null,null,null,null,"N/A",null,null,0]
[0,null,null,null,null,null,"N/A",null,null,0]
[0,null,null,null,null,null,"N/A",null,null,0]
[0,null,null,null,null,null,"N/A",null,null,0]
[0,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(E14),ISBLANK(F14)),\"N/A\",IF(E14=\"Yes\",\"Yes\",IF(F14=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,{"$f":"H14*I14","v":0}]
[0,null,null,null,null,null,"N/A",null,null,0]
[null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(E16),ISBLANK(F16)),\"N/A\",IF(E16=\"Yes\",\"Yes\",IF(F16=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,{"$f":"H16*I16","v":0}]
[null,null,null,null,null,null,"N/A",null,null,0]
["A","A. Light Fixture Luminance","All light fixtures in regularly occupied spaces have a luminance of less than 2,500 cd/m2 between 45 and 95 degrees from nadir ",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(G8:G17,\"yes\"),IF(COUNTIF(G8:G17,\"No\")>0,\"No\",\"Yes\"),\"N/A\")","v":"N/A"}]
[null,"D. Direct-Only Overhead Lighting","Total connected lighting load (W)",null,null,null,null,null,null,null,{"$f":"SUM(J8:J17)","v":0}]
[null,null,"Connected lighting load for regularly occupied spaces that is direct-only overhead lighting (W)",null,null,null,null,null,null,null,{"$f":"SUMIF(K8:K17,\"Yes\",J8:J17)","v":0}]
[null,null,"Percentage of connected lighting load for regularly occupied spaces that is direct-only overhead lighting (%)",null,null,null,null,null,null,null,{"$f":"IF(K19>0,K20/ K19,0)","v":0}]

{"sheet":"B and C","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,3,5,5],[18,1,20,1],[5,1,5,2],[5,6,5,10],[17,2,17,9],[18,2,18,9],[19,2,19,9],[20,2,20,9]]}
[]
[null,"B. Color Rendering Index and C. Lamp Life"]
[]
[]
[null,"Complete the table below. Include all light sources used on the project."]
[null,"General Information",null,"B. Color Rendering Index (CRI)",null,null,"C. Lamp Life"]
[null,"Light Source \nDescription","Manufacturer or\nVendor Name\n(Optional)","Light Source \nCRI","Exclude light \nsource?","Meets CRI Requirements","Light Fixture Description","Connected \nLoad \n(W)","Number of Fixtures","Total \nConnected Load \n(W)","Light Source Rated Life\n(hours)"]
[{"$f":"IF(B8>=0,0,0)","v":0},null,null,null,null,{"$f":"IF(AND(ISBLANK(D8),ISBLANK(E8)),\"N/A\",IF(D8>=80,\"Yes\",IF(E8=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,null,{"$f":"H8*I8","v":0}]
[{"$f":"IF(B9>=0,0,0)","v":0},null,null,null,null,{"$f":"IF(AND(ISBLANK(D9),ISBLANK(E9)),\"N/A\",IF(D9>=80,\"Yes\",IF(E9=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,null,{"$f":"H9*I9","v":0}]
[0,null,null,null,null,"N/A",null,null,null,0]
[0,null,null,null,null,"N/A",null,null,null,0]
[0,null,null,null,null,"N/A",null,null,null,0]
[0,null,null,null,null,"N/A",null,null,null,0]
[0,null,null,null,null,"N/A",null,null,null,0]
[0,null,null,null,null,"N/A",null,null,null,0]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK(D16),ISBLANK(E16)),\"N/A\",IF(D16>=80,\"Yes\",IF(E16=\"Yes\",\"Yes\",\"No\")))","v":"N/A"},null,null,null,{"$f":"H16*I16","v":0}]
[null,null,null,null,null,"N/A",null,null,null,0]
["A","B. Color Rendering Index","All light sources have CRI of 80 or higher ",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(F8:F17,\"No\")>0,\"No\",IF(COUNTIF(F8:F17,\"Yes\"),\"Yes\",\"N/A\"))","v":"N/A"}]
[null,"C. Lamp Life","Total connected lighting load (W)",null,null,null,null,null,null,null,{"$f":"SUM(J8:J17)","v":0}]
[null,null,"Connected lighting load with rated life of at least 24,000 hours (or L70 for LED sources) (W)",null,null,null,null,null,null,null,{"$f":"SUMIF(K8:K17,\">=24000\",J8:J17)+SUMIF(K8:K17,\"=L70\",J8:J17)","v":0}]
[null,null,"Percentage of connected lighting load with rated life of at least 24,000 hours or L70 for LED sources (%)",null,null,null,null,null,null,null,{"$f":"IF(K19>0,K20/K19,0)","v":0}]

{"sheet":"E and F ","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[16,1,22,1],[16,2,16,5],[4,1,4,6],[23,1,26,1],[23,2,24,2],[25,2,26,2],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[17,3,17,5],[18,3,18,5],[17,2,18,2],[19,2,20,2],[21,2,22,2]]}
[]
[null,"E. Surface Reflectance: Ceilings, Walls, Floors and F. Surface Reflectance: Furnishings"]
[]
[]
[null,"Complete the table below. For E, include the surfaces in all regularly occupied spaces included in the calculations.  For F, include all furniture that is a work surface or moveable partition."]
[null,"Description of Surface ","Manufacturer or Vendor Name\n(Optional)","Surface Location","Reflectance \n(%)",{"$f":"CONCATENATE(\"Surface Area \n\",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Surface Area \n(sq ft)"},{"$f":"CONCATENATE(\"Reflectance x Surface Area\n\",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Reflectance x Surface Area\n(sq ft)"}]
[{"$f":"IF(B7>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(F7>0,E7*F7,0),0)","v":0}]
[{"$f":"IF(B8>=0,0,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(F8>0,E8*F8,0),0)","v":0}]
[0,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
[0,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["A","E. Surface Reflectance: Ceilings, Walls, Floors","Percentage of total regularly occupied floor area included in the calculations (%)"]
[null,null,"Ceilings",{"$f":"CONCATENATE(\"Total ceiling area \",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Total ceiling area (sq ft)"},null,null,{"$f":"SUMIF(D7:D16,\"Ceiling\",F7:F16)","v":0}]
[null,null,null,"Average surface reflectance for ceilings ",null,null,{"$f":"IFERROR(SUMIF(D7:D16,\"Ceiling\",G7:G16)/G18,0)","v":0}]
[null,null,"Walls",{"$f":"CONCATENATE(\"Total wall area \",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Total wall area (sq ft)"},null,null,{"$f":"SUMIF(D7:D16,\"Wall\",F7:F16)","v":0}]
[null,null,null,"Average surface reflectance for walls",null,null,{"$f":"IFERROR(SUMIF(D7:D16,\"Wall\",G7:G16)/G20,0)","v":0}]
[null,null,"Floors",{"$f":"CONCATENATE(\"Total floor area \",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Total floor area (sq ft)"},null,null,{"$f":"SUMIF(D7:D16,\"Floor\",F7:F16)","v":0}]
[null,null,null,"Average surface reflectance for floors",null,null,{"$f":"IFERROR(SUMIF(D7:D16,\"Floor\",G7:G16)/G22,0)","v":0}]
[null,"F. Surface Reflectance: Furnishings","Work Surfaces",{"$f":"CONCATENATE(\"Total work surface area \",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Total work surface area (sq ft)"},null,null,{"$f":"SUMIF(D7:D16,\"Work surface\",F7:F16)","v":0}]
[null,null,null,"Average surface reflectance for work surfaces",null,null,{"$f":"IFERROR(SUMIF(D7:D16,\"Work surface\",G7:G16)/G24,0)","v":0}]
[null,null,"Moveable Partitions",{"$f":"CONCATENATE(\"Total moveable partition area \",IF(Instructions!$K$29=1,\"(sq ft)\",\"(sq m)\"))","v":"Total moveable partition area (sq ft)"},null,null,{"$f":"SUMIF(D7:D16,\"Moveable partition\",F7:F16)","v":0}]
[null,null,null,"Average surface reflectance for moveable partitions",null,null,{"$f":"IFERROR(SUMIF(D7:D16,\"Moveable partition\",G7:G16)/G26,0)","v":0}]

{"sheet":"G and H","index":4,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,6,5,8],[5,9,5,11],[4,1,4,11],[5,1,5,5],[17,1,17,10],[18,2,18,10],[21,2,21,10],[18,1,20,1],[21,1,23,1],[19,2,19,10],[22,2,22,10],[20,2,20,10],[23,2,23,10]]}
[]
[null,"G. Surface Illuminance Ratio: Wall to Work Surface and H. Surface Illuminance Ratio: Ceiling to Work Surface"]
[]
[]
[null,"Complete the table below for all regularly occupied spaces.  If illuminance values vary widely throughout the space, either subdivide or use the predominant illuminance level.  Spaces with similar illuminance ratios may be grouped."]
[null,"General Information",null,null,null,null,"G. Surface Illuminance Ratio: Wall to Work Surface",null,null,"H. Surface Illuminance Ratio: Ceiling to Work Surface"]
[null,"Area Description","Area Location(s)","Description of \nWork Surface \n(Optional)","Average Work Plane Illuminance\n(lux)",{"$f":"IF(Instructions!K29=2,\"Regularly Occupied Floor Area \n(sq m)\",\"Regularly Occupied Floor Area \n(sq ft)\")","v":"Regularly Occupied Floor Area \n(sq ft)"},"Description of \nWall Surface","Average \nWall Surface\nIlluminance \n(lux)","Ratio","Description of \nCeiling Surface","Average \nCeiling Surface\nIlluminance \n(lux)","Ratio"]
[{"$f":"IF(B8>=0,0,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AND(E8>0,H8>0),E8/H8,\"\")","v":""},null,null,{"$f":"IF(AND(E8>0,K8>0),E8/K8,\"\")","v":""}]
[{"$f":"IF(B9>=0,0,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AND(E9>0,H9>0),E9/H9,\"\")","v":""},null,null,{"$f":"IF(AND(E9>0,K9>0),E9/K9,\"\")","v":""}]
[0,null,null,null,null,null,null,null,"",null,null,""]
[0,null,null,null,null,null,null,null,"",null,null,""]
[0,null,null,null,null,null,null,null,"",null,null,""]
[0,null,null,null,null,null,null,null,"",null,null,""]
[0,null,null,null,null,null,null,null,"",null,null,""]
[0,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
["A",{"$f":"IF(Instructions!K29=2,\"Total regularly occupied floor area (sq m)\",\"Total regularly occupied floor area (sq ft)\")","v":"Total regularly occupied floor area (sq ft)"},null,null,null,null,null,null,null,null,null,{"$f":"SUM(F8:F17)","v":0}]
[null,"G. Surface Illuminance Ratio: Wall to Work Surface",{"$f":"CONCATENATE(\"Total regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less (sq ft)"},null,null,null,null,null,null,null,null,{"$f":"SUMIF(I8:I17,\"<=10\",F8:F17)","v":0}]
[null,null,"Percentage of regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less (%)",null,null,null,null,null,null,null,null,{"$f":"IF(L18>0,L19/L18,0)","v":0}]
[null,null,"For projects attempting strategy G but not attempting strategy E or F: Average surface reflectance for walls "]
[null,"H. Surface Illuminance Ratio: Ceiling to Work Surface",{"$f":"CONCATENATE(\"Total regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less (sq ft)"},null,null,null,null,null,null,null,null,{"$f":"SUMIF(L8:L17,\"<=10\",F8:F17)","v":0}]
[null,null,"Percentage of regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less (%)",null,null,null,null,null,null,null,null,{"$f":"IF(L18>0,L22/L18,0)","v":0}]
[null,null,"For projects attempting strategy H but not attempting strategy E or F: Average surface reflectance for ceilings"]

{"sheet":"I (India ACP)","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,6],[4,1,4,7],[16,1,16,6],[17,1,17,6]]}
[]
[null,"I. Illumination levels: BIS code"]
[]
[]
[null,"Complete the table below for all regularly occupied spaces.  If illuminance values vary widely throughout the space, either subdivide or use the predominant illuminance level.  Spaces with similar illuminance values or activities may be grouped."]
[null,"Area \nDescription","Area \nLocation(s)","Type of Interior \nor Activity",{"$f":"CONCATENATE(\"Regularly Occupied Floor Area\n\",\nIF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Regularly Occupied Floor Area\n(sq ft)"},"Average Illuminance\nLevel\n(lux)","BIS Recommended Illuminance \nLevel\n(lux)","Meets \nIlluminance Requirements"]
[{"$f":"IF(B7>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(F7),ISBLANK(G7)),\"N/A\",IF(F7>=G7,\"Yes\",\"No\"))","v":"N/A"}]
[{"$f":"IF(B8>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(F8),ISBLANK(G8)),\"N/A\",IF(F8>=G8,\"Yes\",\"No\"))","v":"N/A"}]
[0,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A"]
[0,null,null,null,null,null,null,"N/A"]
[{"$f":"IF(B14>=0,0,0)","v":0},null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(F14),ISBLANK(G14)),\"N/A\",IF(F14>=G14,\"Yes\",\"No\"))","v":"N/A"}]
[null,null,null,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,"N/A"]
["A",{"$f":"CONCATENATE(\"Total regularly occupied floor area \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area (sq ft)"},null,null,null,null,null,{"$f":"SUM(E7:E16)","v":0}]
[null,{"$f":"CONCATENATE(\"Total regularly occupied floor area that meets or exceeds the recommended illuminance levels \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area that meets or exceeds the recommended illuminance levels (sq ft)"},null,null,null,null,null,{"$f":"SUMIF(H7:H16,\"Yes\",E7:E16)","v":0}]
[null,"Percentage of regularly occupied floor area that meets or exceeds the recommended illuminance levels (%)",null,null,null,null,null,{"$f":"IF(H17>0,H18/H17,0)","v":0}]

{"sheet":"Summary","index":6,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,2,8,5],[16,2,16,5],[25,2,25,5],[36,2,36,5],[44,2,44,5],[34,2,34,5],[29,2,30,5],[67,2,68,5],[64,2,65,5],[20,2,21,5],[52,2,53,5],[70,10,71,10],[50,2,50,5],[62,2,62,5],[58,2,58,5],[58,10,59,10],[70,2,70,5],[55,2,56,5]]}
[]
[]
[null,null,"Summary "]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tabs. "]
[]
[null,null,"A. Light fixture luminance"]
[]
[null,null,"All light fixtures in regularly occupied spaces have a luminance of less than 2,500 cd/m2 between 45 and 95 degrees from nadir ",null,null,null,null,{"$f":"'A and D'!K18","v":"N/A"}]
[]
[]
[null,null,"B. Color rendering index (CRI)"]
[]
[null,null,"All light sources have CRI of 80 or higher ",null,null,null,null,{"$f":"'B and C'!K18","v":"N/A"}]
[]
[null,null,"C. Lamp life"]
[]
[null,null,"Total connected light load (W)",null,null,null,null,{"$f":"'B and C'!K19","v":0}]
[]
[null,null,"Connected lighting load with lamp life of at least 24,000 hours (W)",null,null,null,null,{"$f":"'B and C'!K20","v":0}]
[]
[null,null,"Percentage of connected lighting load with lamp life of at least 24,000 hours or L70 for LED sources (%)",null,null,null,null,{"$f":"'B and C'!K21","v":0}]
[]
[]
[null,null,"D. Direct-only overhead lighting"]
[]
[null,null,"Total connected lighting load (W)",null,null,null,null,{"$f":"'A and D'!K19","v":0}]
[]
[null,null,"Connected lighting load for regularly occupied spaces that is direct-only overhead lighting (W)",null,null,null,null,{"$f":"'A and D'!K20","v":0}]
[]
[null,null,"Percentage of connected lighting load for regularly occupied spaces that is direct-only overhead lighting (%)",null,null,null,null,{"$f":"'A and D'!K21","v":0}]
[]
[]
[null,null,"E. Surface reflectance: ceilings, walls, floors"]
[]
[null,null,"Percentage of regularly occupied floor area included in calculation (%)",null,null,null,null,{"$f":"'E and F '!G17","v":0}]
[]
[null,null,"Average surface reflectance for ceilings",null,null,null,null,{"$f":"'E and F '!G19","v":0}]
[]
[null,null,"Average surface reflectance for walls",null,null,null,null,{"$f":"'E and F '!G21","v":0}]
[]
[null,null,"Average surface reflectance for floors",null,null,null,null,{"$f":"'E and F '!G23","v":0}]
[]
[null,null,"F. Surface reflectance: furnishings"]
[]
[null,null,"Average surface reflectance for work surfaces",null,null,null,null,{"$f":"'E and F '!G25","v":0}]
[]
[null,null,"Average surface reflectance for moveable partitions",null,null,null,null,{"$f":"'E and F '!G27","v":0}]
[]
[null,null,"G. Surface illuminance ratio: wall to work surface"]
[]
[null,null,{"$f":"IF(Instructions!$K$29=2,\"Total regularly occupied floor area (sq m)\",\"Total regularly occupied floor area (sq ft)\")","v":"Total regularly occupied floor area (sq ft)"},null,null,null,null,{"$f":"'G and H'!L18","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less (sq ft)"},null,null,null,null,{"$f":"'G and H'!L19","v":0}]
[]
[]
[null,null,"Percentage of regularly occupied floor area with wall to work surface illuminance ratio of 1:10 or less (%)",null,null,null,null,{"$f":"'G and H'!L20","v":0}]
[]
[]
[null,null,"For projects not attempting E or F: Average surface reflectance for walls",null,null,null,null,{"$f":"'G and H'!L21","v":0}]
[]
[null,null,"H. Surface illuminance ratio: ceiling to work surface"]
[]
[null,null,{"$f":"IF(Instructions!$K$29=2,\"Total regularly occupied floor area (sq m)\",\"Total regularly occupied floor area (sq ft)\")","v":"Total regularly occupied floor area (sq ft)"},null,null,null,null,{"$f":"'G and H'!L18","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Total regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less \",IF(Instructions!K29=2,\"(sq m)\",\"(sq ft)\"))","v":"Total regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less (sq ft)"},null,null,null,null,{"$f":"'G and H'!L22","v":0}]
[]
[]
[null,null,"Percentage of regularly occupied floor area with ceiling to work surface illuminance ratio of 1:10 or less (%)",null,null,null,null,{"$f":"'G and H'!L23","v":0}]
[]
[]
[null,null,"For projects not attempting E or F: Average surface reflectance for ceilings ",null,null,null,null,{"$f":"'G and H'!L24","v":0}]
[]
[null,null,"I. Illuminance levels: BIS code (India ACP)"]
[]
[null,null,"All regularly occupied spaces meet or exceed the recommended illuminance levels",null,null,null,null,{"$f":"IF('I (India ACP)'!H17>0,IF('I (India ACP)'!H19>=1,\"Yes\",\"No\"),\"N/A\")","v":"N/A"}]