{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Building information","Rating_Cal","Content","Site Parameters","Criterion 1","Criterion 2","Maintenance & Housekeeping","Criterion 3","Criterion 4","Energy","Criterion 5","Base Case","Existing Case","Appr5","Criterion 6","Water","Criterion 7","BuildingwaterCons-BaseCase","BuildingwaterCons-ExistingCase","Landscape water - Base case","Landscape water - Existing Case","Criterion 8","Appr6","Human Health & Comfort","Criterion 9","Criterion 10","Soical Aspects","Criterion 13","Criterion 14","Sheet1","Social Aspects","Criterion 11","Bonus Point","Criterion 12"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":40,"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":"Building information","index":0,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,2,15,5],[16,2,16,5],[17,2,17,5],[0,0,0,5],[1,1,2,5],[5,0,9,0],[10,2,10,5],[11,2,11,5],[6,10,9,10],[12,2,12,5],[13,2,13,5],[5,1,9,1],[3,2,3,5],[4,2,4,5]]}
["Building Information",null,null,null,null,null,null,"*  - All mark fields are mandatory to fill"]
[null,{"$f":"IF(AND(K3>1,C16<2500),\"Please answer all\",IF(AND(K3>0,C16>=2500),\"Please answer all\",IF(C16<2500,\"As build up area is less than 2500 Sqm project is not eligible under GRIHA for exsiting buildings rating category\",\"\")))","v":"Please answer all"}]
[null,null,null,null,null,null,null,null,"User input cell",null,{"$f":"COUNTIF(K4:K18,1)","v":4}]
[1,"Project Name*","ABC ABC",null,null,null,null,null,null,null,{"$f":"IF(OR(C4=\"\",N4<=3),1,0)","v":0},null,null,{"$f":"LEN(C4)","v":7},null,null,"Residential","Commercial","Mixed Used"]
[2,"City*","ABC ABC",null,null,null,null,null,null,null,{"$f":"IF(OR(C5=\"\",N5<=3),1,0)","v":0},null,null,{"$f":"LEN(C5)","v":7},null,null,null,"Day time Occupied Commercial","24x7 Occupied Commercial"]
[3,"Contact details",null,"Name","Email ID","Phone No",null,null,null,null,{"$f":"IF(D6=\"\",1,0)","v":0}]
[null,null,"1*","ABC","AA.bb@cc.com",1234567890,null,null,null,{"$f":"IF(OR(D7=\"\",E7=\"\",F7=\"\"),1,0)","v":0},{"$f":"IF(AND(J7=0,I9=0),0,1)","v":0},null,null,{"$f":"LEN(F9)","v":0}]
[null,null,2,null,null,null,null,null,null,{"$f":"IF(AND(D8=\"\",E8=\"\",F8=\"\"),0,IF(OR(D8=\"\",E8=\"\",F8=\"\"),1,0))","v":0}]
[null,null,3,null,null,null,null,null,{"$f":"COUNTIF(J8:J10,1)","v":0},{"$f":"IF(AND(D9=\"\",E9=\"\",F9=\"\"),0,IF(OR(D9=\"\",E9=\"\",F9=\"\"),1,0))","v":0}]
[null,null,4,null,null,null,null,null,null,0]
[4,"Please select the building type that most accurately describes your building*","Residential",null,null,null,null,null,null,null,{"$f":"IF(C11=\"--Select--\",1,0)","v":0},0]
[null,"Residential built up area*",null,null,null,null,"Sq.m",null,null,null,{"$f":"IF(AND(C11=\"Mixed Used\",C12=\"\"),1,IF(AND(C11=\"Residential\",C12=\"\"),1,0))","v":1}]
[null,"Day time occupied commercial built up area*",50,null,null,null,"Sq.m",null,null,null,{"$f":"IF(C13=\"\",1,0)","v":0}]
[null,"24x7 Occupied commercial built up area*",50,null,null,null,"Sq.m",null,null,null,0]
[]
[null,"Total built up area",{"$f":"IF(C11=\"Residential\",C12,IF(C11=\"Commercial\",C13+C14,IF(C11=\"Mixed Used\",C12+C13+C14)))","v":0},null,null,null,"Sq.m",null,null,null,{"$f":"IF(C16<2500,1,0)","v":1}]
[5,"Total plot/site area*",null,null,null,null,"Sq.m",null,null,null,{"$f":"IF(C17=\"\",1,0)","v":1}]
[6,"Building is operational since*",null,null,null,null,null,null,null,null,{"$f":"IF(C18=\"\",1,0)","v":1}]

{"sheet":"Rating_Cal","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Maximum Point",{"$f":"Content!D16","v":100}]
[null,null,null,"Aniticipated Point",{"$f":"Content!E16","v":"Not eligible for rating"},null,"Threshold",{"$f":"IF(E3=\"Not eligible for rating\",0,E3/E2)","v":0}]
[]
[]
[null,null,null,null,"Offset (Mixed Usage)","Points"]
[null,null,null,"1_Star",null,1,null,null,{"$f":"IF(Threshold>86%,\"5-Star\",IF(Threshold>71%,\"4-Star\",IF(Threshold>56%,\"3-Star\",IF(Threshold>41%,\"2-Star\",IF(Threshold>25%,\"1-Star\",\"--\")))))","v":"--"},{"$f":"IF(I7=\"1-Star\",1,IF(I7=\"2-Star\",2,IF(I7=\"3-Star\",3,IF(I7=\"4-Star\",4,IF(I7=\"5-Star\",5,0)))))","v":0}]
[null,null,null,"2_Star",null,2]
[null,null,null,"3_Star",null,3]
[null,null,null,"4_Star",null,4]
[null,null,null,"5_Star",null,5]

{"sheet":"Content","index":2,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0],[11,0,12,0],[16,2,17,3],[16,4,17,4],[3,5,4,5],[5,5,6,5],[7,5,8,5],[9,5,10,5],[11,5,12,5]]}
[]
[]
["Section Name","Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Site Parameters","Criterion 1 ","Accessibility to Basic Services",2,{"$f":"'Site Parameters'!$D$4","v":2},null,null,null,null,null,{"$f":"IF(OR(E4=\"Not meeting the mandatory complience, hence not eligible for rating\",E4=\"Please answer all\"),1,0)","v":0}]
[null,"Criterion 2 ","Microclimatic Impact",{"$f":"'Site Parameters'!$C$5","v":4},{"$f":"'Site Parameters'!$D$5","v":4},null,null,null,null,null,{"$f":"IF(OR(E5=\"Not meeting the mandatory complience, hence not eligible for rating\",E5=\"Please answer all\"),1,0)","v":0}]
["Maintenance & Housekeeping","Criterion 3","Maintenance, Green Procurement & Waste Management",{"$f":"'Maintenance & Housekeeping'!$C$4","v":7},{"$f":"'Maintenance & Housekeeping'!$D$4","v":3},null,null,null,null,null,0]
[null,"Criterion 4","Metering & Monitoring",10,{"$f":"'Maintenance & Housekeeping'!$D$5","v":6},null,null,null,null,null,0]
["Energy","Criterion 5","Energy Efficiency",{"$f":"Energy!C4","v":20},{"$f":"Energy!$D$4","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,"Criterion 6","Renewable Energy Utilization",15,{"$f":"Energy!$D$5","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$error":"#DIV/0!"}]
["Water","Criterion 7","Water Footprint",{"$f":"'Criterion 7'!$B$3","v":15},{"$f":"Water!$D$4","v":0},null,null,null,null,null,0]
[null,"Criterion 8","Reduction in Cumulative water Performance",10,{"$f":"Water!$D$5","v":"Please answer all"},null,null,null,null,null,1]
["Human Health & Comfort","Criterion 9","Achieving Indoor Comfort Requirements",8,{"$f":"'Human Health & Comfort'!$D$4","v":8},null,null,null,null,null,0]
[null,"Criterion 10","Maintaining Good IAQ",{"$f":"'Human Health & Comfort'!$C$5","v":4},{"$f":"'Human Health & Comfort'!$D$5","v":4},null,null,null,null,null,0]
["Social Aspects","Criterion 11","Universal Accessibility & Environmental Awareness",5,{"$f":"'Social Aspects'!$D$4","v":5},null,null,null,null,null,0]
["Bonus Points","Criterion 12","Bonus Points",4,{"$f":"'Bonus Point'!$D$4","v":4},null,null,null,null,null,0]
[null,null,"Total (Excluding bonus points)",{"$f":"SUM(D4:D14)","v":100},{"$f":"IF(K16>0,\"Not eligible for rating\",SUM(E4:E14))","v":"Not eligible for rating"},null,null,null,null,null,{"$f":"COUNTIF(K4:K15,1)","v":1}]
[null,null,"Anticipated Rating",null,{"$f":"IF(Threshold>86%,\"5-Star\",IF(Threshold>71%,\"4-Star\",IF(Threshold>56%,\"3-Star\",IF(Threshold>41%,\"2-Star\",IF(Threshold>25%,\"1-Star\",\"--\")))))","v":"--"}]

{"sheet":"Site Parameters","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!$A$4","v":"Site Parameters"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 1 ",{"$f":"Content!$C$4","v":"Accessibility to Basic Services"},{"$f":"Content!$D$4","v":2},{"$f":"'Criterion 1'!B4","v":2}]
["Criterion 2 ",{"$f":"Content!$C$5","v":"Microclimatic Impact"},{"$f":"'Criterion 2'!B3","v":4},{"$f":"'Criterion 2'!B4","v":4}]

{"sheet":"Criterion 1","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Criterion 1: Accessibility to Services"]
[]
["Maximum Possible Points",{"$f":"'Site Parameters'!$C$4","v":2}]
["Anticipated Points",{"$f":"IF(B8=\"Yes\",1,0)+IF(B11=\"Yes\",1,0)","v":2}]
[]
[]
["Appraisal 1.1.1","Answer"]
["At least 5 services within campus or within 500 m from the main entrance gate","Yes"]
[]
["Appraisal 1.1.2","Answer"]
["Collective transport to provide connectivity to nearest public transportation nodes","Yes"]
[]
[]
[]
[null,null,null," "]

{"sheet":"Criterion 2","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,0,0,1],[8,0,16,0],[17,2,17,6],[9,9,14,9],[19,9,22,9],[11,2,11,6],[17,0,25,0],[9,10,14,10],[7,1,7,6],[9,2,9,6],[10,2,10,6],[7,7,7,8],[12,2,12,6],[19,10,22,10],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6]]}
["Criterion 2: Microclimatic Impact"]
[]
["Maximum Possible Points",{"$f":"SUM(K10,K20)","v":4}]
["Anticipated Points",{"$f":"SUM(J10,J20)","v":4}]
[]
[]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer",null,"Feasible Points","Maximum Points"]
["2.1.1 - Analyze total number of trees planted on site and demonstrate compliance with GRIHA Existing Building threshold of 1 tree per 80 m2 of plot area.  Total number of trees on site must meet/exceed the GRIHA Existing Building threshold."]
[null,1,"Total site / plot area",null,null,null,null,{"$f":"'Building information'!C17","v":0},"Sq.m.",{"$f":"IF(K10=0,0,IF(H15<=80,2,0))","v":2},{"$f":"IF(H10-H11=0,0,2)","v":2}]
[null,2,"Building footprint area",null,null,null,null,500,"Sq.m."]
[null,3,"Total built-up area",null,null,null,null,{"$f":"'Building information'!$C$16","v":0},"Sq.m."]
[null,4,"Number of trees",null,null,null,null,20,"Quantity"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(H11=\"\",H13=\"\"),\"Please answer all\",H10/H13)","v":0},"Sq.m./tree"]
[]
[]
["2.1.2 To reduce the urban heat island effect: \n1. More than 25% of the site surface visible to sky (including building roofs) are either soft paved/covered with high SRI coating (SRI >50)/shaded by trees/shaded by vegetated pergolas/shaded by solar panels or any combination of these strategies.\n2. More than 50% of the site surface visible to sky (including building roofs) are either soft paved/covered with high SRI coating (SRI >50)/shaded by trees/shaded by vegetated pergolas/shaded by solar panels or any combination of these strategies.",1,"Total area visible to sky",null,null,null,null,1000,"Sq.m."]
[null,2,"Area Under -"]
[null,"a)","Soft landscape area",null,null,null,null,200,"Sq.m.",{"$f":"IF(K20=0,0,IF(AND(H25>25%,H25<=50%,N23=1),1,IF(AND(H25>50%,N23=1),2,0)))","v":2},{"$f":"IF(AND(H18=0,H20=0,H21=0,H22=0,N23=1),0,2)","v":2}]
[null,"b)","Hard paved area with vegetation and / green roof and / Solar panels and / China Mosaic",null,null,null,null,300,"Sq.m"]
[null,"c)","Hard paved area with SRI>50%",null,null,null,null,100]
[null,null,null,null,null,null,"Total treated area",{"$f":"IF(OR(H18=\"\",H20=\"\",H21=\"\",H22=\"\"),\"Please answer all\",IF(SUM(H20:H22)>H18,\"Treated area can not be greater than total area visible to sky, please enter correct values\",SUM(H20:H22)))","v":600},null,null,null,null,null,{"$f":"IF(OR(H23=\"Please answer all\",H23=\"Treated area can not be greater than total area visible to sky, please enter correct values\"),0,1)","v":1}]
[]
[null,null,null,null,null,null,"Percentage treated area (%)",{"$f":"IF(AND(H18>0,SUM(H20:H22)<=H18),SUM(H20:H22)/H18,IF(AND(H18=0,H20=0,H21=0,H22=0),0,\"-\"))","v":0.6}]

{"sheet":"Maintenance & Housekeeping","index":6,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!$A$6","v":"Maintenance & Housekeeping"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 3",{"$f":"Content!$C$6","v":"Maintenance, Green Procurement & Waste Management"},{"$f":" 'Criterion 3'!B3","v":7},{"$f":" 'Criterion 3'!B4","v":3}]
["Criterion 4",{"$f":"Content!$C$7","v":"Metering & Monitoring"},{"$f":"Content!$D$7","v":10},{"$f":"'Criterion 4'!B4","v":6}]

{"sheet":"Criterion 3","index":7,"n_rows":100,"n_cols":22,"rows_kept":100,"cut":false,"hidden":true,"merged":[[11,7,11,8],[16,7,16,8],[17,2,17,6],[17,7,17,8],[18,2,18,6],[18,7,18,8],[21,2,21,8],[21,9,21,11],[22,2,22,6],[22,7,22,8],[22,9,25,11],[23,2,23,6],[13,9,20,11],[14,2,14,6],[14,7,14,8],[15,2,15,6],[15,7,15,8],[16,2,16,6],[20,2,20,6],[20,7,20,8],[23,7,23,8],[24,2,24,6],[60,0,61,0],[60,1,60,6],[4,0,4,6],[4,7,4,11],[5,1,5,6],[5,7,5,8],[5,9,7,11],[6,0,39,0],[6,1,6,8],[7,2,7,8],[8,2,8,6],[8,7,8,8],[8,9,11,11],[9,2,9,6],[9,7,9,8],[10,2,10,6],[10,7,10,8],[11,2,11,6],[19,2,19,6],[19,7,19,8],[12,2,12,8],[12,9,12,11],[13,2,13,6],[13,7,13,8],[30,9,30,11],[24,7,24,8],[25,2,25,6],[25,7,25,8],[26,2,26,8],[26,9,26,11],[27,2,27,6],[27,7,27,8],[27,9,29,11],[28,2,28,6],[28,7,28,8],[29,7,29,8],[30,2,30,8],[29,2,29,6],[39,2,39,6],[39,7,39,8],[31,9,39,11],[36,2,36,6],[36,7,36,8],[31,2,31,6],[31,7,31,8],[32,2,32,6],[32,7,32,8],[33,2,33,6],[33,7,33,8],[34,2,34,6],[34,7,34,8],[35,2,35,6],[35,7,35,8],[0,0,1,1],[50,10,56,11],[50,8,56,9],[58,1,58,6],[58,8,58,9],[58,10,58,11],[59,1,59,6],[59,8,59,9],[59,10,59,11],[57,1,57,6],[57,8,57,9],[57,10,57,11],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[47,2,47,6],[42,0,42,6],[41,7,41,8],[37,2,37,6],[37,7,37,8],[38,2,38,6],[38,7,38,8],[60,8,61,9],[60,10,61,11],[61,1,61,6],[42,7,42,11],[43,1,43,6],[43,8,43,9],[43,10,43,11],[45,2,45,6],[46,2,46,6],[48,1,49,6],[44,10,47,11],[44,8,47,9],[44,0,47,0],[55,2,55,6],[56,2,56,6],[48,0,56,0],[40,0,41,0],[40,1,40,6],[40,7,40,8],[40,9,41,11],[41,1,41,6]]}
["Criterion 3: Maintenance, Green Procurement & Waste Management"]
[]
["Maximum Possible Points",{"$f":"SUM(K45,K51:L62)","v":7}]
["Anticipated Points",{"$f":"IF(H43=\"Eligible for Rating\",I45+I51+I58+I59+I60+I61,\"Not meeting the mandatory complience, hence not eligible for rating\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential","Commercial"]
["Appraisal","Eligibility Check",null,null,null,null,null,"Answer",null,null,null,null,null,null,"Yes","No","NA",null,null,"Y","N","NA"]
["3.1.1 (Mandatory) - Maintenance and housekeeping protocols of all installed systems","Do maintenance protocols exist for the following systems?"]
[null,1,"Electrical system"]
[null,"a)","Transformers",null,null,null,null,"Yes",null,{"$f":"IF(Q12>0,\"Maintenance protocols for all applicable systems is a necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H9=\"Yes\",H9=\"NA\"),1,IF(H9=\"No\",0,\"\"))","v":1},null,null,null,null,null,"Yes","No","NA"]
[null,"b)","Diesel generator sets",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(OR(H10=\"Yes\",H10=\"NA\"),1,IF(H10=\"No\",0,\"\"))","v":1}]
[null,"c)","HT, LT panels",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"d)","Motors",null,null,null,null,"Yes",null,null,null,null,null,1,null,{"$f":"COUNTIF(N9:N12,\"\")","v":0},{"$f":"COUNTIF(N9:N12,0)","v":0}]
[null,2,"Mechanical system"]
[null,"a)","Window/Split AC units",null,null,null,null,"Yes",null,{"$f":"IF(Q21>0,\"Maintenance protocols for all applicable systems is a necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"b)","AHU",null,null,null,null,"NA",null,null,null,null,null,1]
[null,"c)","Cooling tower",null,null,null,null,"NA",null,null,null,null,null,1]
[null,"d)","Chillers",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"e)","Pumps",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"f)","VRF",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"g)","Ventilation fans",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"h)","Ducting",null,null,null,null,"Yes",null,null,null,null,null,1,null,{"$f":"COUNTIF(N14:N21,\"\")","v":0},{"$f":"COUNTIF(N14:N21,0)","v":0}]
[null,3,"Plumbing system"]
[null,"a)","Piping",null,null,null,null,"Yes",null,{"$f":"IF(Q26>0,\"Maintenance protocols for all applicable systems is a necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"b)","Fixtures and fittings",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"c)","Fire safety pumps",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"d)","Sprinklers",null,null,null,null,"Yes",null,null,null,null,null,1,null,{"$f":"COUNTIF(N23:N26,\"\")","v":0},{"$f":"COUNTIF(N23:N26,0)","v":0}]
[null,4,"Metering and Sensors"]
[null,"a)","Energy Meters",null,null,null,null,"Yes",null,{"$f":"IF(Q30>0,\"Maintenance protocols for all applicable systems is a necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"b)","Water Meters",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"c)","Air Quality Meters",null,null,null,null,"Yes",null,null,null,null,null,1,null,{"$f":"COUNTIF(N28:N30,\"\")","v":0},{"$f":"COUNTIF(N28:N30,0)","v":0}]
[null,5,"Renewable Energy Systems"]
[null,"a)","Solar PV",null,null,null,null,"Yes",null,{"$f":"IF(Q37>0,\"Maintenance protocols for all applicable systems is a necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"b)","Solar water heaters",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,"c)","Wind Turbines",null,null,null,null,"NA",null,null,null,null,null,1]
[null,"d)","Bio-gasifiers",null,null,null,null,"NA",null,null,null,null,null,1]
[null,"e)","Any other RE system (defined as per MNRE guidelines)",null,null,null,null,"NA",null,null,null,null,null,1]
[null,6,"Sewage Treatment plant",null,null,null,null,"Yes",null,null,null,null,null,1,null,null,{"$f":"COUNTIF(N32:N40,0)","v":0}]
[null,7,"Waste treatment plant",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,8,"Storm water drainage system",null,null,null,null,"Yes",null,null,null,null,null,1]
[null,9,"Rainwater harvesting system",null,null,null,null,"Yes",null,null,null,null,null,1]
["3.1.2 (Mandatory) - Ensure following \n1. In case of conditioned spaces all HVAC equipment are CFC free and all insulation used in building should be CFCs and HCFCs free OR phase-out plan for HCFC/CFC using equipment\n2. Firefighting equipment are Halon free","Are refrigerants in all HVAC equipment are CFC free and all the insulation used in building should be CFCs and HCFCs free OR do you have a phase-out plan for HCFC/CFC using equipment?",null,null,null,null,null,"Yes",null,{"$f":"IF(H41=\"No\",\"Ensuring all HVAC equipment are CFC free & all insulation used in the building are CFC and HCFC free or Phase-out plan for HCFC/CFC using equpment is a mandatory requirement to be eligible for rating\", IF(H42=\"No\",\"Ensuring firefighting equipment are Halon free is mandatory requirement to be eligible for rating\",\"\"))","v":""},null,null,null,1]
[null,"Are all firefighting equipment Halon free?",null,null,null,null,null,"Yes",null,null,null,null,null,1,null,{"$f":"COUNTIF(N32:N42,\"\")","v":0},{"$f":"COUNTIF(N32:N42,0)","v":0}]
["Eligibility",null,null,null,null,null,null,{"$f":"IF(AND(count_zeroes>=1,30>sum_values>=0),\"Not eligible for Rating\",IF(AND(count_zeroes=0,sum_values=30),\"Eligible for Rating\",IF(AND(count_blanks>0,sum_values<30),\"Please fill all fields\",IF(AND(count_blanks>0,sum_values=30),\"Please ans all fields\",\"Eligible for Rating\"))))","v":"Eligible for Rating"},null,null,null,null,null,null,null,{"$f":"SUM(P42,P26,P30,P21,P12)","v":0},{"$f":"SUM(Q42,Q30,Q26,Q21,Q12)","v":0},{"$f":"SUM(N9:N12,N14:N21,N23:N26,N28:N30,N32:N42)","v":30}]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer","Feasible Points",null,"Maximum Points"]
["3.1.3 - Maintain and follow a policy of purchasing housekeeping materials with low ODP ","Are these product categories a part of your green procurement policy?",null,null,null,null,null,null,{"$f":"IF(SUM(N46:N48)=3,1,IF(P47>0,\"Please answer all\",0))","v":1},null,1]
[null,1,"Low-VOC interior paints",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(H46=\"Yes\",1,0)","v":1},{"$f":"IF(H46=\"\",1,0)","v":0}]
[null,2,"Low-VOC adhesives",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(OR(H47=\"Yes\",H47=\"NA\"),1,IF(H47=\"No\",0,\"\"))","v":1},{"$f":"IF(H47=\"\",1,0)","v":0},{"$f":"COUNTIF(O46:O48,1)","v":0}]
[null,3,"Low-VOC sealants",null,null,null,null,"Yes",null,null,null,null,null,1,0]
["3.1.4 - Maintain and follow a policy of purchasing appliances with at least BEE 3-star rating ","Is a policy for purchasing at least the following BEE star rated products in place? "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O51:O57)","v":7},{"$f":"SUM(P51:P57)","v":0}]
[null,1,"Frost-free refrigerators",null,null,null,null,"Yes",{"$f":"IF(AND(O50=7,P50=0,Q54=0),\"1\",IF(AND(11>=O50>=0,11>=P50>=0,Q54>=1),\"Please ans all\",\"0\"))","v":"1"},null,1,null,null,{"$f":"IF(OR(H51=\"Yes\",H51=\"NA\"),1,IF(H51=\"No\",0,\"\"))","v":1},{"$f":"IF(OR(H51=\"Yes\",H51=\"NA\"),1,0)","v":1},{"$f":"IF(H51=\"No\",1,0)","v":0}]
[null,2,"Direct cool refrigerators",null,null,null,null,"Yes",null,null,null,null,null,1,{"$f":"IF(OR(H52=\"Yes\",H52=\"NA\"),1,0)","v":1},{"$f":"IF(H52=\"No\",1,0)","v":0}]
[null,3,"Tubular Fluorescent lights",null,null,null,null,"Yes",null,null,null,null,null,1,1,0]
[null,4,"Room air conditioners",null,null,null,null,"Yes",null,null,null,null,null,1,1,0,{"$f":"COUNTIF(N51:N57,\"\")","v":0}]
[null,5,"Distribution transformers",null,null,null,null,"Yes",null,null,null,null,null,1,1,0]
[null,6,"Electric geysers",null,null,null,null,"Yes",null,null,null,null,null,1,1,0]
[null,7,"Colour televisions",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(OR(H57=\"Yes\",H57=\"NA\"),1,IF(H57=\"No\",0,\"\"))","v":1},1,0]
["3.1.5 - Provide provision for segregation of waste at source","Is there a provision for segregation of waste at source?",null,null,null,null,null,"Yes",{"$f":"IF(AND(N58=1,H58=\"Yes\",Q58=0),\"1\",IF(Q58=1,\"Please ans all\",\"0\"))","v":"1"},null,1,null,null,{"$f":"IF(OR(H58=\"Yes\",H58=\"No\"),1,\"\")","v":1},null,null,{"$f":"COUNTIF(N58,\"\")","v":0}]
["3.1.6 - Provide dedicated storage areas for different types of wastes","Is there a provision for different storage areas for different types of wastes?",null,null,null,null,null,"No",{"$f":"IF(AND(N59=1,H59=\"Yes\",Q59=0),\"1\",IF(Q59=1,\"Please ans all\",\"0\"))","v":"0"},null,1,null,null,{"$f":"IF(OR(H59=\"Yes\",H59=\"No\"),1,\"\")","v":1},null,null,{"$f":"COUNTIF(N59,\"\")","v":0}]
["3.1.7 - Provide details of contractual tie-ups with authorized waste recyclers for safe recycling ","Are there contractual tie-ups with authorized recyclers for recycling waste?",null,null,null,null,null,"No",{"$f":"IF(AND(N60=1,H60=\"Yes\",Q60=0),\"1\",IF(Q60=1,\"Please ans all\",\"0\"))","v":"0"},null,1,null,null,{"$f":"IF(OR(H60=\"Yes\",H60=\"No\"),1,\"\")","v":1},null,null,{"$f":"COUNTIF(N60,\"\")","v":0}]
["3.1.8 - \n1. Implement strategies to treat all organic waste on-site\n2. Reuse the treated organic waste on-site","Is the amount of organic waste generated more than 100kg/day?",null,null,null,null,null,"No",{"$f":"IF(AND(H62=\"Yes\",H61=\"Yes\"),2,IF(H61=\"NA\",0,0))","v":0},null,{"$f":"IF(H61=\"NA\",0,2)","v":2},null,null,{"$f":"IF(OR(H61=\"Yes\",H61=\"No\"),1,\"\")","v":1},null,null,{"$f":"COUNTIF(N61,\"\")","v":0},null,{"$f":"COUNTIF(N61,\"\")","v":0}]
[null,"Is this organic waste treated and reuse on-site?",null,null,null,null,null,"No",null,null,null,null,null,{"$f":"IF(OR(H62=\"Yes\",H62=\"No\"),1,\"\")","v":1},null,null,{"$f":"COUNTIF(N62,\"\")","v":0},null,{"$f":"COUNTIF(N62,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N78:N90,1)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N92:N95,1)","v":0},null,{"$f":"SUM(P90,P95)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N98:N100)","v":0}]

{"sheet":"Criterion 4","index":8,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,0,0,1],[36,8,38,9],[39,8,39,9],[36,10,38,11],[39,10,39,11],[18,0,33,0],[34,0,38,0],[39,1,39,6],[34,1,35,7],[36,2,36,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[19,2,19,6],[5,1,5,6],[16,0,16,6],[40,8,40,9],[40,10,40,11],[40,0,40,7],[29,2,29,6],[37,2,37,6],[38,2,38,6],[30,2,30,6],[31,1,31,7],[32,2,32,6],[33,2,33,6],[5,7,5,8],[5,9,15,11],[6,0,15,0],[6,1,6,8],[7,2,7,6],[7,7,7,8],[8,2,8,6],[8,7,8,8],[14,2,14,6],[14,7,14,8],[9,2,9,6],[9,7,9,8],[10,2,10,6],[10,7,10,8],[11,1,11,8],[12,2,12,6],[12,7,12,8],[13,2,13,6],[13,7,13,8],[15,2,15,6],[15,7,15,8],[16,7,16,11],[17,1,17,6],[17,8,17,9],[17,10,17,11],[19,10,26,11],[27,10,30,11],[32,10,33,11],[19,8,26,9],[27,8,30,9],[32,8,33,9],[18,1,18,7],[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6]]}
["Criterion 4: Metering & Monitoring"]
[]
["Maximum Possible Points",{"$f":"'Maintenance & Housekeeping'!$C$5","v":10}]
["Anticipated Points",{"$f":"IF(H17=\"Eligible for Rating\",I41,\"Not meeting the mandatory complience, hence not eligible for rating\")","v":6}]
[]
["Appraisal","Eligibility Check",null,null,null,null,null,"Answer",null,null,null,null,null,null,"Yes","No","NA"]
["4.1.1 (Mandatory) - Basic metering requirements","Do meters exist at all of the following points?"]
[null,1,"Utility grid",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H8=\"Yes\",1,0)","v":1},{"$f":"IF(H8=\"No\",1,0)","v":0},{"$f":"IF(H8=\"NA\",1,0)","v":0}]
[null,2,"On-site renewable energy system",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H9=\"Yes\",1,0)","v":1},{"$f":"IF(H9=\"No\",1,0)","v":0},{"$f":"IF(H9=\"NA\",1,0)","v":0}]
[null,3,"Gas generator sets",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(H10=\"Yes\",1,0)","v":0},0,1]
[null,4,"Diesel generators",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(H11=\"Yes\",1,0)","v":0},0,1]
[null,"Do meters exist at all of the following points?"]
[null,1,"Municipal Supply",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H13=\"Yes\",1,0)","v":1},{"$f":"IF(H13=\"No\",1,0)","v":0},{"$f":"IF(H13=\"NA\",1,0)","v":0}]
[null,2,"Bore well",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(H14=\"Yes\",1,0)","v":0},{"$f":"IF(H14=\"No\",1,0)","v":0},{"$f":"IF(H14=\"NA\",1,0)","v":1}]
[null,3,"STP Inlet",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H15=\"Yes\",1,0)","v":1},0,0]
[null,4,"STP Outlet",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H16=\"Yes\",1,0)","v":1},0,0]
["Eligibility",null,null,null,null,null,null,{"$f":"IF(AND(8>O17>=2,6>=Q17,P17=0,H8=\"Yes\",H13=\"Yes\"),\"Eligible for rating\",IF(AND(8>O17>=2,6>=Q17,P17=0,H9=\"Yes\",H14=\"Yes\"),\"Eligible for rating\",IF(AND(8>O17>=2,6>=Q17,P17=0,H8=\"Yes\",H14=\"Yes\"),\"Eligible for rating\",IF(AND(8>O17>=2,6>=Q17,P17=0,H9=\"Yes\",H13=\"Yes\"),\"Eligible for rating\",\"Not eligible for rating\"))))","v":"Eligible for rating"},null,null,null,null,null,null,{"$f":"SUM(O8:O11,O13:O16)","v":5},{"$f":"SUM(P8:P11,P13:P16)","v":0},{"$f":"SUM(Q8:Q11,Q13:Q16)","v":3}]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer","Feasible Points",null,"Maximum Points",null,null,null,null,{"$f":"IF(AND(8>O17>=2,6>=Q17,P17=0,H8=\"Yes\",H13=\"Yes\"),\"Y\",\"N\")","v":"Y"}]
["4.1.2 - Advance metering requirements","Do sub-meters exist at the following points?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:O27)","v":8}]
[null,1,"AHUs ",null,null,null,null,"NA",{"$f":"IF(AND(H25=\"Yes\",H26=\"Yes\",O19=8),1,0)","v":1},null,1,null,null,null,{"$f":"IF(OR(H20=\"Yes\",H20=\"NA\"),1,0)","v":1}]
[null,2,"Cooling tower",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(OR(H21=\"Yes\",H21=\"NA\"),1,0)","v":1}]
[null,3,"Chillers (BTU meters)",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(OR(H22=\"Yes\",H22=\"NA\"),1,0)","v":1}]
[null,4,"Distributed units (split/window ACs)",null,null,null,null,"NA",null,null,null,null,null,null,1]
[null,5,"Indoor lighting",null,null,null,null,"NA",null,null,null,null,null,null,1]
[null,6,"Outdoor lighting",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H25=\"Yes\",1,0)","v":1}]
[null,7,"Basement parking lighting",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H26=\"Yes\",1,0)","v":1},{"$f":"SUM(P28:P31)","v":4}]
[null,8,"Community/recreation centre",null,null,null,null,"NA",null,null,null,null,null,null,{"$f":"IF(OR(H27=\"Yes\",H27=\"NA\"),1,0)","v":1}]
[null,9,"Water pumping",null,null,null,null,"Yes",{"$f":"IF(AND(H28=\"Yes\",P26=4),1,0)","v":1},null,1,null,null,null,null,{"$f":"IF(H28=\"Yes\",1,0)","v":1}]
[null,10,"Irrigation",null,null,null,null,"Yes",null,null,null,null,null,null,null,{"$f":"IF(OR(H29=\"Yes\",H29=\"NA\"),1,0)","v":1}]
[null,11,"Captured rain water",null,null,null,null,"Yes",null,null,null,null,null,null,null,{"$f":"IF(OR(H30=\"Yes\",H30=\"NA\"),1,0)","v":1}]
[null,12,"Fresh water and waste water consumption at each building level",null,null,null,null,"NA",null,null,null,null,null,null,null,{"$f":"IF(OR(H31=\"Yes\",H31=\"NA\"),1,0)","v":1}]
[null,"Are sensors for air quality installed in following areas?",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O33:O34)","v":2}]
[null,1,"Basement and /or closed parking spaces",null,null,null,null,"NA",{"$f":"IF(AND(H34=\"Yes\",O32=2),1,0)","v":1},null,1,null,null,null,{"$f":"IF(OR(H33=\"Yes\",H33=\"NA\"),1,0)","v":1}]
[null,2,"All regularly occupied spaces",null,null,null,null,"Yes",null,null,null,null,null,null,{"$f":"IF(H34=\"Yes\",1,0)","v":1}]
["4.1.3 - One-way communicable smart meters and monitoring systems","Are one-way communicable smart meters installed for these categories of meters?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P37:P39)","v":3}]
[null,1,"Energy",null,null,null,null,"Yes",{"$f":"IF(P36=3,3,0)","v":3},null,3,null,null,null,null,{"$f":"IF(H37=\"Yes\",1,0)","v":1}]
[null,2,"Water",null,null,null,null,"Yes",null,null,null,null,null,null,null,{"$f":"IF(H38=\"Yes\",1,0)","v":1}]
[null,3,"Air Quality",null,null,null,null,"Yes",null,null,null,null,null,null,null,1]
["4.1.4 - Connect to GRIHA IT platform","Are two-way communicable smart energy meters installed?",null,null,null,null,null,"No",{"$f":"IF(H40=\"Yes\",4,0)","v":0},null,4,null,null,null,{"$f":"IF(H40=\"Yes\",1,0)","v":0}]
["TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I19:J40)","v":6},null,{"$f":"SUM(K19:L40)","v":10}]

{"sheet":"Energy","index":9,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!A8","v":"Energy"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 5",{"$f":"Content!$C$8","v":"Energy Efficiency"},{"$f":"'Criterion 5'!B3","v":20},{"$f":"'Criterion 5'!B4","v":{"$error":"#DIV/0!"}}]
["Criterion 6  ",{"$f":"Content!$C$9","v":"Renewable Energy Utilization"},{"$f":"Content!$D$9","v":15},{"$f":"'Criterion 6'!B3","v":{"$error":"#DIV/0!"}}]

{"sheet":"Criterion 5","index":10,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":true,"merged":[[17,2,17,6],[17,7,17,8],[18,2,18,6],[18,7,18,8],[19,2,19,6],[19,7,19,8],[15,9,15,10],[16,9,16,10],[20,9,20,10],[21,9,21,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[29,9,29,10],[26,2,26,6],[0,0,0,1],[12,1,12,6],[14,7,14,8],[15,7,15,8],[16,7,16,8],[12,7,12,8],[13,1,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[22,2,22,6],[27,2,27,6],[20,7,20,8],[21,7,21,8],[28,7,28,8],[29,7,29,8],[25,2,25,6],[22,7,22,8],[22,9,22,10],[23,2,23,6],[28,2,28,6],[29,2,29,6],[23,7,23,8],[23,9,23,10],[24,2,24,6],[24,7,24,8],[24,9,24,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[44,5,44,6],[30,2,30,6],[30,7,30,8],[34,7,34,8],[30,9,30,10],[33,9,33,10],[34,0,34,6],[31,2,31,6],[31,7,31,8],[31,9,31,10],[32,2,32,6],[32,7,32,8],[32,9,32,10],[13,0,33,0],[26,7,26,8],[27,7,27,8],[20,2,20,6],[21,2,21,6],[38,0,45,0],[36,7,36,8],[37,7,37,8],[33,2,33,6],[33,7,33,8],[38,1,38,6],[40,1,40,6],[36,1,36,6],[37,1,37,6],[41,1,41,6],[42,1,42,6],[42,7,42,8],[41,7,41,8],[44,7,44,8]]}
["Criterion 5: Energy Efficiency"]
[]
["Maximum Possible Points",{"$f":"SUM(K38:K39)","v":20}]
["Anticipated Points",{"$f":"IF(H35=\"Eligible for Rating\",SUM(J38:J39),\"Not meeting the mandatory complience, hence not eligible for rating\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No","NA"]
[]
[]
[]
[]
[]
["Appraisal","Eligibility Check",null,null,null,null,null,"Answer"]
["5.1.1 (Mandatory) - Details of building system and energy consumption","Do you have following details ?"]
[null,1,"Energy consumptions from all major sources (for at least past 12 months)"]
[null,"a)","Utility/ grid electricity bills ",null,null,null,null,"Yes",null,{"$f":"IF(H16=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H16=\"Yes\",H16=\"NA\"),1,IF(H16=\"No\",0,\"\"))","v":1},null,null,{"$f":"IF(AND(H16=\"NA\",H18=\"NA\",H22=\"NA\"),1,0)","v":0}]
[null,"b)","Diesel Consumptions bills",null,null,null,null,"Yes",null,{"$f":"IF(H17=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H17=\"Yes\",H17=\"NA\"),1,IF(H17=\"No\",0,\"\"))","v":1}]
[null,"c)","Coal Consumptions bills",null,null,null,null,"Yes",null,{"$f":"IF(H18=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H18=\"Yes\",H18=\"NA\"),1,IF(H18=\"No\",0,\"\"))","v":1}]
[null,"d)","Furnace Oil Consumptions bills",null,null,null,null,"Yes",null,{"$f":"IF(H19=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"e)","Gas (PNG) Consumptions bills",null,null,null,null,"Yes",null,{"$f":"IF(H20=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"f)","Gas (LPG) Consumptions bills",null,null,null,null,"Yes",null,{"$f":"IF(H21=\"No\",\"Submiting details of energy consumption from all major sources are necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H21=\"Yes\",H21=\"NA\"),1,IF(H21=\"No\",0,\"\"))","v":1}]
[null,"g)","Renewable energy generation data",null,null,null,null,"Yes",null,"",null,null,null,1]
[null,2,"Building plans demarking conditioned and un conditioned area",null,null,null,null,"Yes",null,{"$f":"IF(H23=\"No\",\"Submiting building plans demarking constioned and uncondtoned area is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,3,"Building operation schedule",null,null,null,null,"Yes",null,{"$f":"IF(H24=\"No\",\"Submiting building operation schedule is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H24=\"Yes\",H24=\"NA\"),1,IF(H24=\"No\",0,\"\"))","v":1}]
[null,4,"Building occupancy details",null,null,null,null,"Yes",null,{"$f":"IF(H25=\"No\",\"Submiting building occupancy is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,5,"Inventory of connected load including -",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(N16:N25,0)","v":0},{"$f":"COUNTIF(N16:N25,\"\")","v":0}]
[null,"a)","HVAC system",null,null,null,null,"NA",null,{"$f":"IF(H27=\"No\",\"Submiting inventory of all connected loads is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H27=\"Yes\",H27=\"NA\"),1,IF(H27=\"No\",0,\"\"))","v":1}]
[null,"b)","Internal lighting ",null,null,null,null,"NA",null,{"$f":"IF(H28=\"No\",\"Submiting inventory of all connected loads is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H28=\"Yes\",H28=\"NA\"),1,IF(H28=\"No\",0,\"\"))","v":1}]
[null,"c)","Outdoor lighting",null,null,null,null,"Yes",null,{"$f":"IF(H29=\"No\",\"Submiting inventory of all connected loads is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,"d)","Pumping load",null,null,null,null,"Yes",null,"",null,null,null,1]
[null,"e)","Miscellaneous load",null,null,null,null,"Yes",null,"",null,null,null,1]
[null,6,"As build mechanical and electrical floor plans",null,null,null,null,"Yes",null,{"$f":"IF(H32=\"No\",\"Submiting as build mechanical and electrical floor plans is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,7,"As build single line drawing of low side & high side HAVC system and electrical loads along with set points for all seasons",null,null,null,null,"Yes",null,{"$f":"IF(H33=\"No\",\"Submiting single line drawing of low & high side HVAC system and electrical loads with set points for all seasons is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,1]
[null,8,"As build drawing of all architectural plans, elevations and sections",null,null,null,null,"Yes",null,{"$f":"IF(H34=\"No\",\"Submiting as build drawing of all architectural plans, elevations and sections is necessary requirement to be eligible for rating\",\"\")","v":""},null,null,null,{"$f":"IF(OR(H34=\"Yes\",H34=\"NA\"),1,IF(H34=\"No\",0,\"\"))","v":1},{"$f":"COUNTIF(N27:N34,0)","v":0},{"$f":"COUNTIF(N27:N34,\"\")","v":0}]
["Eligibility",null,null,null,null,null,null,{"$f":"IF(AND(N35=18,Q16=0),\"Eligible for rating\",IF(P35>\"0\",\"Please ans all\",\"Not eligible for rating\"))","v":"Eligible for rating"},null,null,null,null,null,{"$f":"SUM(N16:N25,N27:N34)","v":18},{"$f":"SUM(O26,O34)","v":0},{"$f":"SUM(P26,P34)","v":0},null,{"$f":"IF(H35=\"Not eligible for rating\",0,1)","v":1}]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer",null,"Feasible Points","Maximum Points"]
["5.1.2 - Implementation of operation and maintenance, no cost EEM's","Do you have details of implemented no cost EEM's ?",null,null,null,null,null,"Yes",null,{"$f":"IF(H38=\"Yes\",5,IF(H38=\"No\",0, IF(H38=\"NA\",0,IF(P38>0,\"Please ans all\"))))","v":5},{"$f":"IF(H38=\"Yes\",5,IF(H38=\"No\",5, IF(H38=\"NA\",0)))","v":5},null,null,{"$f":"IF(OR(H38=\"Yes\",H38=\"NA\"),1,IF(H38=\"No\",0,\"\"))","v":1},null,{"$f":"COUNTIF(H38,\"\")","v":0}]
["5.1.3 - Percentage reduction in energy consumption over the base case.","Demonstrate percentage reduction in energy consumption over the base case",null,null,null,null,null,null,null,{"$f":"IF(K39=0,0,IF(Reduction>Point_15,15,IF(Reduction>Point_11,11,IF(Reduction>Point_8,8,IF(Reduction>Point_5,5,IF(Reduction>Point_2,2,0))))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H38=\"NA\",0,15)","v":15}]
[]
[null,"Where -"]
[null,"Base Case energy consumption (kwh/year)",null,null,null,null,null,{"$f":"IF(H38=\"NA\",0,Base_case)","v":0}]
[null,"Existing case energy consumption (kWh/year)",null,null,null,null,null,{"$f":"Existing_Case","v":0}]
[]
[null,null,null,null,null,"% Reduction",null,{"$f":"IF(OR(H38=\"NA\",Base_case=0,Existing_Case=0),0,(Base_case-Existing_Case)/Base_case)","v":0}]

{"sheet":"Base Case","index":11,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,0,1,8],[6,8,7,8],[32,0,32,7],[6,0,7,0],[6,1,7,1],[6,2,6,7],[3,1,3,8]]}
["Base Case"]
[]
[]
[null,"Note -To develop a base case, the energy consumption data of two consecutive years (before implementation of energy conservation measures) within the last seven years dating back from the registration date will only be accepted. \nFor example; if a project is registered in the year 2017, then energy consumption data from 2010 to 2016 will only be accepted. Now, for calculating the base case the project can consider data of any two consecutive years between the said period such as, 2010-2012 data/ 2011-2013 data/ 2012-2014 data, and so on up till data of 2016.",null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())-1947","v":70}]
[]
[]
["Sl. No.","Date (MM/DD/YY)","Energy Consumption",null,null,null,null,null,"Total Energy consumption (kWh)",null,null,null,null,{"$f":"TODAY()","v":"2017-06-07"}]
[null,null,"Electricity Grid (kWh)","PNG (SCM)","Gas (LPG)","Diesel (liters)","Furnace Oil (liters)","Coal (kg)"]
[1,"2014-05-14",0,0,0,0,0,0,{"$f":"IF((C9*1+D9*10.467+E9*6.654+F9*13.875+G9*10.59+H9*7.734)>0,(C9*1+D9*10.467+E9*6.654+F9*13.875+G9*10.59+H9*7.734), \"Please enter valid consumption\")","v":"Please enter valid consumption"},null,null,null,{"$f":"YEAR(B9)","v":2014}]
[2,{"$f":"DATE(YEAR(B9),MONTH(B9)+1,DAY(1))","v":"2014-06-01"},0,0,0,0,0,0,{"$f":"IF((C10*1+D10*10.467+E10*6.654+F10*13.875+G10*10.59+H10*7.734)>0,(C10*1+D10*10.467+E10*6.654+F10*13.875+G10*10.59+H10*7.734), \"Please enter valid consumption\")","v":"Please enter valid consumption"},null,null,null,{"$f":"YEAR(B10)","v":2014}]
[3,{"$f":"DATE(YEAR(B10),MONTH(B10)+1,DAY(1))","v":"2014-07-01"},0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[4,"2014-08-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[5,"2014-09-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[6,"2014-10-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[7,"2014-11-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[8,"2014-12-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2014]
[9,"2015-01-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[10,"2015-02-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[11,"2015-03-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[12,"2015-04-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[13,"2015-05-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[14,"2015-06-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[15,"2015-07-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[16,"2015-08-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[17,"2015-09-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,{"$f":"YEAR(B25)","v":2015}]
[18,"2015-10-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[19,"2015-11-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[20,"2015-12-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2015]
[21,"2016-01-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2016]
[22,"2016-02-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2016]
[23,"2016-03-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,{"$f":"YEAR(B31)","v":2016}]
[24,"2016-04-01",0,0,0,0,0,0,"Please enter valid consumption",null,null,null,2016]
["Base case",null,null,null,null,null,null,null,{"$f":"SUM(I9:I32)/2","v":0},"KWh/year"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]

{"sheet":"Existing Case","index":12,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,1,8],[5,8,6,8],[19,0,19,7],[5,0,6,0],[5,1,6,1],[5,2,5,7],[3,1,3,8]]}
["Existing Case"]
[]
[]
[null,"Note - To develop existing case, the energy consumption data of latest 12 months (after implementation of energy conservation measures) will only be accepted. \nFor example -if a project registered in year 2017, existing case can be develop by accounting energy consumption data of 2016-2017."]
[]
["Sl. No.","Month (MM/DD/YY)","Energy Consumption",null,null,null,null,null,"Total Energy consumption (kWh)"]
[null,null,"Electricity Grid (kWh)","PNG (SCM)","Gas (LPG)","Diesel (liters)","Furnace Oil (liters)","Coal (kg)",null,null,null,{"$f":"TODAY()","v":"2017-06-07"}]
[1,"2016-05-12",0,0,0,0,0,0,{"$f":"IF((C8*1+D8*10.467+E8*6.654+F8*13.875+G8*10.59+H8*7.734)>0,(C8*1+D8*10.467+E8*6.654+F8*13.875+G8*10.59+H8*7.734), \"Please enter valid consumption\")","v":"Please enter valid consumption"}]
[2,{"$f":"DATE(YEAR(B8),MONTH(B8)+1,DAY(B8))","v":"2016-06-12"},0,0,0,0,0,0,{"$f":"IF((C9*1+D9*10.467+E9*6.654+F9*13.875+G9*10.59+H9*7.734)>0,(C9*1+D9*10.467+E9*6.654+F9*13.875+G9*10.59+H9*7.734), \"Please enter valid consumption\")","v":"Please enter valid consumption"}]
[3,{"$f":"DATE(YEAR(B9),MONTH(B9)+1,DAY(B9))","v":"2016-07-12"},0,0,0,0,0,0,"Please enter valid consumption"]
[4,"2016-08-12",0,0,0,0,0,0,"Please enter valid consumption"]
[5,"2016-09-12",0,0,0,0,0,0,"Please enter valid consumption"]
[6,"2016-10-12",0,0,0,0,0,0,"Please enter valid consumption"]
[7,"2016-11-12",0,0,0,0,0,0,"Please enter valid consumption"]
[8,"2016-12-12",0,0,0,0,0,0,"Please enter valid consumption"]
[9,"2017-01-12",0,0,0,0,0,0,"Please enter valid consumption"]
[10,"2017-02-12",0,0,0,0,0,0,"Please enter valid consumption"]
[11,"2017-03-12",0,0,0,0,0,0,"Please enter valid consumption"]
[12,"2017-04-12",0,0,0,0,0,0,"Please enter valid consumption"]
["Existing Case",null,null,null,null,null,null,null,{"$f":"SUM(I8:I19)","v":0},"kWh/year"]

{"sheet":"Appr5","index":13,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,"% Reduction in energy consumption for residential project","% Reduction in energy consumption for commercial project"]
[null,"% Reduction in energy consumption "]
[]
[null,"Residential","Commercial","Points",null,null,null,null,"Points"]
[null,0.03,0.04,2]
[null,0.06,0.08,5]
[null,0.09,0.12,8]
[null,0.12,0.16,11]
[null,0.15,0.2,15]
[]
[]
[]
[null,"Reduction (Mixed Usage)","Points"]
["Point_0",0,0]
["Point_2",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*B5+Commercial*C5*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*B5*0+Commercial*C5)/Total_Area,(Residential*B5+Commercial*C5)/Total_Area))","v":{"$error":"#DIV/0!"}},2]
["Point_5",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*B6+Commercial*C6*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*B6*0+Commercial*C6)/Total_Area,(Residential*B6+Commercial*C6)/Total_Area))","v":{"$error":"#DIV/0!"}},5]
["Point_8",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*B7+Commercial*C7*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*B7*0+Commercial*C7)/Total_Area,(Residential*B7+Commercial*C7)/Total_Area))","v":{"$error":"#DIV/0!"}},8]
["Point_11",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*B8+Commercial*C8*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*B8*0+Commercial*C8)/Total_Area,(Residential*B8+Commercial*C8)/Total_Area))","v":{"$error":"#DIV/0!"}},11]
["Point_15",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*B9+Commercial*C9*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*B9*0+Commercial*C9)/Total_Area,(Residential*B9+Commercial*C9)/Total_Area))","v":{"$error":"#DIV/0!"}},15]

{"sheet":"Criterion 6","index":14,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":true,"merged":[[35,0,35,2],[14,0,14,2],[0,0,0,1]]}
["Criterion 6: Renewable Energy"]
["Maximum Possible Points",{"$f":"Content!$D$9","v":15}]
["Anticipated Points",{"$f":"IF(B12=\"Alternative I - On-site/On-site & off-site combination of RE system installation\",D18,IF(B12=\"Alternative II- off-site RE system installation\",D37))","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"Alternative I - On-site/On-site & off-site combination of RE system installation\",1,IF(B12=\"Alternative II- off-site RE system installation\",0))","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"Alternative I - On-site/On-site & off-site combination of RE system installation\",1,IF(B12=\"Alternative II- off-site RE system installation\",0))","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alternative I - On-site/On-site & off-site combination of RE system installation","Alternative II- off-site RE system installation"]
["Choose among the two alternatives","Alternative I - On-site/On-site & off-site combination of RE system installation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Onsite generation","Onsite - offsite combination "]
["Appraisal 6.1.1 - Alternative I Percentage of energy consumption offset through On site/On-site and off-site combination of renewable energy generation",null,null,"Feasible Points","Maximum Points"]
[]
[]
["Choose among the following","Onsite - offsite combination ",null,{"$f":"IF(AND(Energy_offset_combine>Point_15_RE,M25=0),15,IF(AND(Energy_offset_combine>Point_10_RE,M25=0),10,IF(AND(Energy_offset_combine>Point_7_RE,M25=0),7,IF(AND(Energy_offset_combine>Point_5_RE,M25=0),5,IF(AND(Energy_offset_combine>Point_3_RE,M25=0),3,0)))))","v":{"$error":"#DIV/0!"}},15]
[]
["Capacity installed onsite",null,"kW",null,null,null,null,null,null,null,null,null,{"$f":"IF(B20=\"\",1,0)","v":1},{"$f":"IF(B20=0,1,0)","v":1}]
["On-site energy generation from renewable energy sources",null,"kWh/year",null,null,null,null,null,null,null,null,null,{"$f":"IF(B21=\"\",1,0)","v":1},{"$f":"IF(B21=0,1,0)","v":1}]
[]
["Capacity installed offsite",0,"kW",null,null,null,null,null,null,null,null,null,{"$f":"IF(B23=\"\",1,0)","v":0},{"$f":"IF(B23=0,1,0)","v":1}]
["Off-site energy generation from renewable energy sources",0,"kWh/year",null,null,null,null,null,null,null,null,null,0,{"$f":"IF(B24=0,1,0)","v":1}]
["Total energy generation from renewable energy sources",{"$f":"IF(OR(N25>0,M25>0),\"Please ans all\",B21+B24)","v":"Please ans all"},null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M20:M24,1)","v":2},{"$f":"IF(B18=\"Onsite generation\",COUNTIF(N20:N21,1),COUNTIF(N20:N24,1))","v":4},{"$f":"SUM(M25:N25)","v":6}]
[]
["Total energy consumption ",{"$f":"Existing_Case","v":0},"kWh/year"]
[]
["% energy offset through on site generation",{"$f":"IF(OR(Existing_Case=0,Total_energy_generation_from_RE=\"Please ans all\"),0,Total_energy_generation_from_RE/Existing_Case)","v":0}]
[]
["% energy offset through on site & off-side combination",{"$f":"IF(OR(Existing_Case=0,Total_energy_generation_from_RE=\"Please ans all\"),0,Total_energy_generation_from_RE/Existing_Case)","v":0}]
[]
[]
[]
[]
["Appraisal 6.1.1 - Alternative II Percentage of energy consumption offset through Offsite renewable energy generation",null,null,"Feasible Points","Maximum Points"]
[null,null,null,{"$f":"IF(AND(Energy_offset_offside>Point_15_RE1,M41=0),15,IF(AND(Energy_offset_offside>Point_10_RE1,M41=0),10,IF(AND(Energy_offset_offside>Point_7_RE1,M41=0),7,IF(AND(Energy_offset_offside>Point_5_RE1,M41=0),5,IF(AND(Energy_offset_offside>Point_3_RE1,M41=0),3,IF(M41>0,\"Please ans all\",0))))))","v":"Please ans all"},{"$f":"Content!$D$9","v":15}]
[]
["Capacity installed offsite",null,"kW",null,null,null,null,null,null,null,null,null,{"$f":"IF(B39=\"\",1,0)","v":1}]
["Off-site energy generation from renewable energy sources",null,"kWh/year",null,null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M39:M40,1)","v":2}]
["Total energy consumption ",{"$f":"Existing_Case","v":0},"kWh/year"]
[]
[]
["% energy offset through off-side RE generation",{"$f":"IF(OR(Existing_Case=0,B40=0),0,B40/Existing_Case)","v":0}]

{"sheet":"Water","index":15,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!$A$10","v":"Water"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 7",{"$f":"Content!$C$10","v":"Water Footprint"},{"$f":"'Criterion 7'!$B$3","v":15},{"$f":"'Criterion 7'!$B$4","v":0}]
["Criterion 8",{"$f":"Content!$C$11","v":"Reduction in Cumulative water Performance"},{"$f":"Content!$D$11","v":10},{"$f":"'Criterion 8'!$B$4","v":"Please answer all"}]

{"sheet":"Criterion 7","index":16,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":true,"merged":[[52,0,55,0],[52,2,52,6],[53,2,53,6],[54,2,54,6],[52,10,54,10],[52,9,54,9],[23,0,26,0],[28,0,31,0],[33,0,49,0],[39,2,39,6],[37,2,37,6],[47,2,47,6],[28,2,28,6],[29,2,29,6],[41,2,41,6],[45,2,45,6],[49,2,49,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[43,2,43,6],[31,2,31,6],[0,0,0,1],[6,1,6,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[7,1,7,6],[8,0,8,6],[10,1,10,6],[11,0,21,0],[10,7,10,8],[24,2,24,6],[15,2,15,6],[16,2,16,6],[18,2,18,6],[19,2,19,6],[23,2,23,6],[26,2,26,6],[21,2,21,6],[11,9,21,9],[33,9,39,9],[33,10,39,10],[23,9,26,9],[23,10,26,10],[28,10,31,10],[28,9,31,9],[11,10,21,10]]}
["Criterion 7: Water Footprint"]
[]
["Maximum Possible Points",{"$f":"K12+K24+K29+K34+K53","v":15}]
["Anticipated Points",{"$f":"IF(H9=\"Eligible for Rating\",(J12+J24+J29+J34+J53),\"Not meeting the mandatory complience, hence not eligible for rating\")","v":0}]
[]
[]
["Appraisal","Eligibility Check",null,null,null,null,null,"Answer"]
["7.1.1 (Mandatory)- Detailed water audit report clearly demonstrating the following -\n1. Water supply and Usage study\n2. Process and system audit\n3. Discharge analysis","Do you have a detailed water audit report demonstrating the points as mentioned in the appraisal 7.1.1 ? (Please refer annexure 3 - Water audit sample format in GRIHA for Existing Buildings abridged manual for detail)",null,null,null,null,null,"Yes",null,null,null,null,{"$f":"IF(H8=\"Yes\",1,0)","v":1},"Choose from below","Only for grey water","For sewage water(grey water and black water combine)","Yes","No"]
["Eligibility",null,null,null,null,null,null,{"$f":"IF(M8=1,\"Eligible for Rating\",IF(M8=\"\",\"Please answer all\",\"Not eligible for Rating\"))","v":"Eligible for Rating"}]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer",null,"Feasible Points","Maximum Points"]
["7.1.2 Reduction in building water consumption by 30 % below the base case* through water efficient fixtures. (Refer table 11 for flow values of water fixtures to create base case).\n* - For buildings with conventional fixtures, base case would be the actual flow rate as monitored on site.",1,"Total no of male occupants",null,null,null,null,50,null,{"$f":"IF(K12=0,0,IF(H22>=30%,3,0))","v":0},{"$f":"IF(AND(H16=\"Yes\",H17=\"Yes\"),0,3)","v":3}]
[null,2,"Total no of female occupants",null,null,null,null,50]
[null,null,"Total Occupancy",null,null,null,null,{"$f":"SUM(H12:H13)","v":100}]
[]
[null,3,"Are you using gravity fed systems for entire building ?",null,null,null,null,"No"]
[null,"a)","Is water head height is less than 5 meter or 17 feet ?",null,null,null,null,"No"]
[]
[null,4,"Building water consumption through water fixture- Base case",null,null,null,null,{"$f":"Water_fixtures_Base_Case","v":0},"liters/year"]
[null,null,"Building water consumption through water fixture- Existing case",null,null,null,null,{"$f":"Wate_fixtures_Existing_Case","v":0},"liters/year"]
[]
[null,null,"%Reduction in water consumption through use of water efficient fixtures",null,null,null,null,{"$f":"IF(OR(Water_fixtures_Base_Case=0,Wate_fixtures_Existing_Case=0),0,((Water_fixtures_Base_Case - Wate_fixtures_Existing_Case)/Water_fixtures_Base_Case))","v":0}]
[]
["7.1.3 Minimize lawn area and restricting it to 25% of total landscape area",1,"Total landscape area in Sq. m.",null,null,null,null,0,"Sq. m.",{"$f":"IF(H27<=25%,2,0)","v":0},2]
[null,2,"Lawn area",null,null,null,null,0,"Sq. m."]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(H24=\"\",H25=\"\"),\"-\",IF(OR(H24=0,H25=0),\"-\",IF(H25>H24,\"Enter correct value\",H25/H24)))","v":"-"}]
[]
["7.1.4 Use of water-efficient irrigation systems to reduce the water requirement by at least 50% from the GRIHA base case",1,"Annual landscape water demand of - base case",null,null,null,null,{"$f":"'Landscape water - Base case'!$H$18","v":0},"liters/year",{"$f":"IF(H32>=50%,1,0)","v":0},2]
[null,2,"Annual landscape water demand of - Existing case",null,null,null,null,{"$f":"'Landscape water - Existing Case'!$K$113","v":0},"liters/year"]
[]
[null,null,"% Reduction in landscape water use",null,null,null,null,{"$f":"IF(OR(H29 =0,H30=0),0,IF(H30>H29,\"Check value enter\",((H29 - H30)/H29)))","v":0}]
[]
["7.1.5 Provision of treatment of waste water on-site -\n1. 100 % of grey water treatment on site.\n2. Treatment of sewage water(grey water and black water combine) for meeting the 100 % of non-potable requirements\nDefinition - \n1. Sewage water - liquid waste and wastewater generated and carried in sewers.\n2. Grey Water - Water that has already been used for bathing, washing, laundry, dishwashing etc. but does not contain excreta.\n3. Black Water - Combined domestic effluent including liquid and solid human body waste and the water discharged from the toilet usage.",1,"Grey water from domestic use ",null,null,null,null,{"$f":"H20*0.66","v":0},"liters/year",{"$f":"IF(K34=0,0,IF(OR(H35=\"\",H44=\"\",H40=\"\",H42=\"Choose from below\",H48=\"\",'BuildingwaterCons-BaseCase'!$D$11=\"\"),0,IF(AND(H42=\"For sewage water(grey water and black water combine)\",H50>=100%),4,IF(AND(H42=\"Only for grey water\",H46>=100%),2,0))))","v":0},{"$f":"IF(OR(H35=\"\",H40=\"\",H42=\"Choose from below\",'BuildingwaterCons-BaseCase'!$D$11=\"\"),4,IF(AND(H42=\"For sewage water(grey water and black water combine)\",H48=\"\"),4,IF(AND(H42=\"Only for grey water\",H44=\"\"),4,IF((H38/'BuildingwaterCons-BaseCase'!$D$11)<10000,0,4))))","v":4}]
[null,2,"Grey water from other miscellaneous use like - vehicle washing etc.",null,null,null,null,0,"liters/year"]
[null,3,"Total grey water generated ",null,null,null,null,{"$f":"H34+(H35*0.9)","v":0},"liters/year"]
[]
[null,4,"Total sewage water generated on-site",null,null,null,null,{"$f":"(H20+H35)*0.9","v":0},"liters/year"]
[]
[null,5,"Total non-potable water demand",null,null,null,null,null,"liters/year"]
[]
[null,6,"Type of waste water treatment system ",null,null,null,null,"For sewage water(grey water and black water combine)"]
[]
[null,null,"Quantity of grey water treated on-site",null,null,null,null,null,"liters/year"]
[]
[null,null,"% of grey water treated on-site",null,null,null,null,{"$f":"IF(OR(H44=0,H36=0),0,H44/H36)","v":0}]
[]
[null,null,"Quantity of sewage water treated on-site",null,null,null,null,null,"liters/year"]
[]
[null,null,"% of sewage water treated on-site to meet non-potable water demand",null,null,null,null,{"$f":"IF(OR(H40=0,H48=0),0,H48/H40)","v":0}]
[]
[]
["7.1.6 - Provision of rainwater harvesting system:\n1. Only roof rainwater harvesting.\n2. 100 % of catchment area.",null,"Does project has a provision for rainwater harvesting ?",null,null,null,null,"No",null,{"$f":"IF(AND(H53=\"Yes\",H54=\"Yes\",H55=\"Yes\"),4,IF(AND(H53=\"Yes\",H54=\"Yes\"),2,IF(AND(H53=\"Yes\",H55=\"Yes\"),2,IF(H53=\"No\",0,0))))","v":0},4]
[null,"a)","Whether harvesting only the roof rainwater ?",null,null,null,null,"No"]
[null,"b)","Whether harvesting rainwater from 100 % of catchment area ?",null,null,null,null,"No"]

{"sheet":"BuildingwaterCons-BaseCase","index":17,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":true,"merged":[[14,15,14,17],[14,12,14,14],[22,0,22,4],[0,0,1,5],[36,0,36,4],[38,1,38,4],[3,0,3,3],[4,0,4,3]]}
["Building water consumption - Base Case"]
[]
[]
["Unit of No. of uses* (In case of water closets and urinals) = number of usage per person per flush/ day"]
["Unit of No. of uses* (In case of faucets) = duration of use * number of usage per person/day = minutes per person/day"]
[null,null,"Total no of male occupants in residential space"]
[null,null,"Total no of female occupants in residential space"]
[null,null,"Total no of male occupants in Commercial space",{"$f":"IF('Criterion 7'!$H$12=1,0,'Criterion 7'!$H$12-D6)","v":50}]
[null,null,"Total no of female occupants in Commercial space",{"$f":"IF('Criterion 7'!$H$13=0,0,'Criterion 7'!$H$13-D7)","v":50}]
[]
[null,null,"Total no working of days in a year",365,null,null,null,null,null,{"$f":"IF(D11=\"\",0,1)","v":1}]
[]
[]
[]
["S.No.","Fixtures types","No. of fixtures","Flow rates (lpf/lpm)","No. of uses *","Daily water consumption (l)",null,null,null,null,null,null,"Residential",null,null,"Commercial"]
[1,"Water Closets (solids)",null,9,1,{"$f":"IF(C16=\"\",\"Please answer all\",IF(C16=0,0,IF('Building information'!$C$11=\"Residential\",D16*E16*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D16*E16*SUM($D$6:$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(C16=\"\",0,1)","v":0},null,null,"Water Closets (solids)",9,1,"Water Closets (Solids)",9,0.1]
[2,"Kitchen Faucets",null,10,3,{"$f":"IF(C17=\"\",\"Please answer all\",IF(C17=0,0,IF('Building information'!$C$11=\"Residential\",D17*E17*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D17*E17*SUM($D$6:$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(C17=\"\",0,1)","v":0},null,null,"Kitchen Faucets",10,3,"Kitchen Faucets",10,0.5]
[3,"Water Closets (liquid)(female)",null,9,5,{"$f":"IF(C18=\"\",\"Please answer all\",IF(C18=0,0,IF('Building information'!$C$11=\"Residential\",D18*E18*'Criterion 7'!$H$13,IF('Building information'!$C$11=\"Mixed Used\",D18*E18*$D$7,0))))","v":"Please answer all"},null,null,null,0,{"$f":"IF(B22=\"\",0,IF(B22=\"If other (please mention)\",1,2))","v":1},null,"Water Closets (liquid)(female)",9,5,"Conventional urinals (female)",4,3]
[4,"Conventional urinals (male)",null,4,5,{"$f":"IF(C19=\"\",\"Please answer all\",IF(C19=0,0,IF('Building information'!$C$11=\"Residential\",D19*E19*'Criterion 7'!$H$12,IF('Building information'!$C$11=\"Mixed Used\",D19*E19*$D$6,0))))","v":"Please answer all"},null,null,null,0,null,null,"Conventional urinals (male)",4,5,"Conventional urinals (male)",4,3]
[5,"Showers",null,10,5,{"$f":"IF(C20=\"\",\"Please answer all\",IF(C20=0,0,IF('Building information'!$C$11=\"Residential\",D20*E20*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D20*E20*SUM($D$6:$D$7),0))))","v":"Please answer all"},null,null,null,0,null,null,"Showers",10,5,"Lavatory faucets",10,0.75]
[6,"Lavatory faucets",null,10,3,{"$f":"IF(C21=\"\",\"Please answer all\",IF(C21=0,0,IF('Building information'!$C$11=\"Residential\",D21*E21*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D21*E21*SUM($D$6:$D$7),0))))","v":"Please answer all"},null,null,null,0,{"$f":"IF(K18=1,1,IF(K18=0,0,IF(AND(K18=2,C22=\"\"),0,1)))","v":1},null,"Lavatory faucets",10,3,"Other ( please mention)"]
[7,"If other (please mention)",null,null,null,{"$f":"IF(J22=0,\"Please answer all\",IF(C22=0,0,IF(AND('Building information'!$C$11=\"Residential\",K18=2),D22*E22*'Criterion 7'!$H$14,IF(AND('Building information'!$C$11=\"Mixed Used\",K18=2),D22*E22*SUM($D$6:$D$7),0))))","v":0},null,null,null,{"$f":"IF(B22=\"\",0,IF(SUM(K21:K23)<3,0,1))","v":1},{"$f":"IF(AND(C22>0,D22=\"\"),0,1)","v":1},null,"Other ( please mention)"]
["Annual building water consumption through water fixtures - Base case",null,null,null,null,{"$f":"IF(J23<8,0,SUM(F16:F22)*D11)","v":0},"liters/year",null,null,{"$f":"SUM(J11:J22)","v":2},{"$f":"IF(AND(C22>0,E22=\"\"),0,1)","v":1}]
[]
[]
[]
[]
[]
["S.No.","Fixtures types","No. of fixtures","Flow rates (lpf/lpm)","No. of uses *","Daily water consumption (l)"]
[1,"Water Closets (Solids)",null,9,0.1,{"$f":"IF(C30=\"\",\"Please answer all\",IF(C30=0,0,IF('Building information'!$C$11=\"Commercial\",D30*E30*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D30*E30*SUM($D$8:$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(C30=\"\",0,1)","v":0},{"$f":"IF(B36=\"\",0,IF(B36=\"If other (please mention)\",1,2))","v":1}]
[2,"Kitchen Faucets",null,10,0.5,{"$f":"IF(C31=\"\",\"Please answer all\",IF(C31=0,0,IF('Building information'!$C$11=\"Commercial\",D31*E31*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D31*E31*SUM($D$8:$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(C31=\"\",0,1)","v":0}]
[3,"Conventional urinals (female)",null,4,3,{"$f":"IF(C32=\"\",\"Please answer all\",IF(C32=0,0,IF('Building information'!$C$11=\"Commercial\",D32*E32*'Criterion 7'!$H$13,IF('Building information'!$C$11=\"Mixed Used\",D32*E32*$D$9,0))))","v":"Please answer all"},null,null,null,0]
[4,"Conventional urinals (male)",null,4,3,{"$f":"IF(C33=\"\",\"Please answer all\",IF(C33=0,0,IF('Building information'!$C$11=\"Commercial\",D33*E33*'Criterion 7'!$H$12,IF('Building information'!$C$11=\"Mixed Used\",D33*E33*$D$8,0))))","v":"Please answer all"},null,null,null,0]
[5,"Showers",null,10,5,{"$f":"IF(C34=\"\",\"Please answer all\",IF(C34=0,0,IF('Building information'!$C$11=\"Commercial\",D34*E34*'Criterion 7'!$H$12,IF('Building information'!$C$11=\"Mixed Used\",D34*E34*$D$8,0))))","v":"Please answer all"},null,null,null,0,{"$f":"IF(K30=1,1,IF(K30=0,0,IF(AND(K30=2,C36=\"\"),0,1)))","v":1}]
[6,"Lavatory faucets",null,10,0.75,{"$f":"IF(C35=\"\",\"Please answer all\",IF(C35=0,0,IF('Building information'!$C$11=\"Commercial\",D35*E35*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D35*E35*SUM($D$8:$D$9),0))))","v":"Please answer all"},null,null,null,0,{"$f":"IF(AND(C36>0,D36=\"\"),0,1)","v":1}]
[7,"If other (please mention)",null,null,null,{"$f":"IF(J36=0,\"Please answer all\",IF(C36=0,0,IF(AND(K30=2,'Building information'!$C$11=\"Commercial\"),D36*E36*'Criterion 7'!$H$14,IF(AND(K30=2,'Building information'!$C$11=\"Mixed Used\"),D36*E36*SUM($D$8:$D$9),0))))","v":0},null,null,null,{"$f":"IF(B36=\"\",0,IF(SUM(K34:K36)<3,0,1))","v":1},{"$f":"IF(AND(C36>0,E36=\"\"),0,1)","v":1}]
["Annual building water consumption through water fixtures - Base case",null,null,null,null,{"$f":"IF(J37<8,0,SUM(F30:F36)*$D$11)","v":0},"liters/year",null,null,{"$f":"J11+J30+J31+J32+J33+J34+J35+J36","v":2}]
[]
[null,"Total annual building water consumption through water fixtures - Base case ",null,null,null,{"$f":"F23+F37","v":0},"liters/year"]

{"sheet":"BuildingwaterCons-ExistingCase","index":18,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[[40,1,40,4],[0,0,1,5],[3,0,3,3],[4,0,4,3],[23,0,23,4],[38,0,38,4]]}
["Building water consumption - Existing Case"]
[]
[]
["Unit of No. of uses* (In case of water closets and urinals) = number of usage per person per flush/ day"]
["Unit of No. of uses* (In case of faucets) = duration of use * number of usage per person/day = minutes per person/day"]
[]
[]
[]
[]
[]
[null,null,"Total no working of days in year",{"$f":"'BuildingwaterCons-BaseCase'!$D$11","v":365},null,null,null,null,null,{"$f":"IF(D11=\"\",0,1)","v":1}]
[]
[]
[]
["S.No.","Fixtures types","No. of fixtures","Flow rates (lpf/lpm)","No. of uses *","Daily water consumption (l)"]
[1,"Water Closets (solids)",null,null,1,{"$f":"IF(J16=0,\"Please answer all\",IF(C16=0,0,IF('Building information'!$C$11=\"Residential\",D16*E16*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D16*E16*SUM('BuildingwaterCons-BaseCase'!$D$6:'BuildingwaterCons-BaseCase'!$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C16=\"\",D16=\"\"),0,1)","v":0}]
[2,"Kitchen Faucets",null,null,3,{"$f":"IF(J17=0,\"Please answer all\",IF(C17=0,0,IF('Building information'!$C$11=\"Residential\",D17*E17*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D17*E17*SUM('BuildingwaterCons-BaseCase'!$D$6:'BuildingwaterCons-BaseCase'!$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C17=\"\",D17=\"\"),0,1)","v":0}]
[3,"Water Closets (liquid)(female)",null,null,5,{"$f":"IF(J18=0,\"Please answer all\",IF(C18=0,0,IF('Building information'!$C$11=\"Residential\",D18*E18*'Criterion 7'!$H$13,IF('Building information'!$C$11=\"Mixed Used\",D18*E18*'BuildingwaterCons-BaseCase'!$D$7,0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C18=\"\",D18=\"\"),0,1)","v":0},{"$f":"IF(B23=\"\",0,IF(B23=\"If other (please mention)\",1,2))","v":1}]
[4,"Water Closets (liquid)/Urinals(male)",null,null,5,{"$f":"IF(J19=0,\"Please answer all\",IF(C19=0,0,IF('Building information'!$C$11=\"Residential\",D19*E19*'Criterion 7'!$H$12,IF('Building information'!$C$11=\"Mixed Used\",D19*E19*'BuildingwaterCons-BaseCase'!$D$6,0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C19=\"\",D19=\"\"),0,1)","v":0}]
[5,"Waterless urinals (male)",null,0,5,{"$f":"IF(C20=\"\", \"Please answer all\",0)","v":"Please answer all"},null,null,null,{"$f":"IF(C20=\"\",0,1)","v":0}]
[6,"Showers",null,null,5,{"$f":"IF(J21=0,\"Please answer all\",IF(C21=0,0,IF('Building information'!$C$11=\"Residential\",D21*E21*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D21*E21*SUM('BuildingwaterCons-BaseCase'!$D$6:'BuildingwaterCons-BaseCase'!$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C21=\"\",D21=\"\"),0,1)","v":0}]
[7,"Lavatory faucets",null,null,3,{"$f":"IF(J22=0,\"Please answer all\",IF(C22=0,0,IF('Building information'!$C$11=\"Residential\",D22*E22*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D22*E22*SUM('BuildingwaterCons-BaseCase'!$D$6:'BuildingwaterCons-BaseCase'!$D$7),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C22=\"\",D22=\"\"),0,1)","v":0},{"$f":"IF(K18=1,1,IF(K18=0,0,IF(AND(K18=2,C23=\"\"),0,1)))","v":1}]
[8,"If other (please mention)",null,null,null,{"$f":"IF(J23=0,\"Please answer all\",IF(C23=0,0,IF(AND(K18=2,'Building information'!$C$11=\"Residential\"),D23*E23*'Criterion 7'!$H$14,IF(AND(K18=2,'Building information'!$C$11=\"Mixed Used\"),D23*E23*SUM('BuildingwaterCons-BaseCase'!$D$6:'BuildingwaterCons-BaseCase'!$D$7),0))))","v":0},null,null,null,{"$f":"IF(B23=\"\",0,IF(SUM(K22:K24)<3,0,1))","v":1},{"$f":"IF(AND(C23>0,D23=\"\"),0,1)","v":1}]
["Annual building water consumption through water fixtures - Existing Case",null,null,null,null,{"$f":"IF(J24<9,0,SUM(F16:F23)*'BuildingwaterCons-BaseCase'!$D$11)","v":0},"liters/year",null,null,{"$f":"SUM(J11:J23)","v":2},{"$f":"IF(AND(C23>0,E23=\"\"),0,1)","v":1}]
[]
[]
[]
[]
[]
["S.No.","Fixtures types","No. of fixtures","Flow rates (lpf/lpm)","No. of uses *","Daily water consumption (l)"]
[1,"Water Closets (solids)",null,null,0.1,{"$f":"IF(J31=0,\"Please answer all\",IF(C31=0,0,IF('Building information'!$C$11=\"Commercial\",D31*E31*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D31*E31*SUM('BuildingwaterCons-BaseCase'!$D$8:'BuildingwaterCons-BaseCase'!$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C31=\"\",D31=\"\"),0,1)","v":0}]
[2,"Kitchen Faucets",null,null,0.5,{"$f":"IF(J32=0,\"Please answer all\",IF(C32=0,0,IF('Building information'!$C$11=\"Commercial\",D32*E32*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D32*E32*SUM('BuildingwaterCons-BaseCase'!$D$8:'BuildingwaterCons-BaseCase'!$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C32=\"\",D32=\"\"),0,1)","v":0}]
[3,"Water Closets (liquid)(female)",null,null,3,{"$f":"IF(J33=0,\"Please answer all\",IF(C33=0,0,IF('Building information'!$C$11=\"Commercial\",D33*E33*'Criterion 7'!$H$13,IF('Building information'!$C$11=\"Mixed Used\",D33*E33*'BuildingwaterCons-BaseCase'!$D$9,0))))","v":"Please answer all"},null,null,null,0,{"$f":"IF(B38=\"\",0,IF(B38=\"If other (please mention)\",1,2))","v":1}]
[4,"Water Closets (liquid)/Urinals (male)",null,null,3,{"$f":"IF(J34=0,\"Please answer all\",IF(C34=0,0,IF('Building information'!$C$11=\"Commercial\",D34*E34*'Criterion 7'!$H$12,IF('Building information'!$C$11=\"Mixed Used\",D34*E34*'BuildingwaterCons-BaseCase'!$D$8,0))))","v":"Please answer all"},null,null,null,0]
[5,"Waterless urinals (male)",null,0,3,{"$f":"IF(C35=\"\", \"Please answer all\",0)","v":"Please answer all"},null,null,null,{"$f":"IF(C35=\"\",0,1)","v":0}]
[6,"Showers",null,null,5,{"$f":"IF(J36=0,\"Please answer all\",IF(C36=0,0,IF('Building information'!$C$11=\"Commercial\",D36*E36*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D36*E36*SUM('BuildingwaterCons-BaseCase'!$D$8:'BuildingwaterCons-BaseCase'!$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C36=\"\",D36=\"\"),0,1)","v":0}]
[7,"Lavatory faucets",null,null,0.75,{"$f":"IF(J37=0,\"Please answer all\",IF(C37=0,0,IF('Building information'!$C$11=\"Commercial\",D37*E37*'Criterion 7'!$H$14,IF('Building information'!$C$11=\"Mixed Used\",D37*E37*SUM('BuildingwaterCons-BaseCase'!$D$8:'BuildingwaterCons-BaseCase'!$D$9),0))))","v":"Please answer all"},null,null,null,{"$f":"IF(OR(C37=\"\",D37=\"\"),0,1)","v":0},{"$f":"IF(K33=1,1,IF(K33=0,0,IF(AND(K33=2,C38=\"\"),0,1)))","v":1}]
[8,"If other (please mention)",null,null,null,{"$f":"IF(J38=0,\"Please answer all\",IF(C38=0,0,IF(AND(K33=2,'Building information'!$C$11=\"Commercial\"),D38*E38*'Criterion 7'!$H$14,IF(AND(K33=2,'Building information'!$C$11=\"Mixed Used\"),D38*E38*SUM('BuildingwaterCons-BaseCase'!$D$8:'BuildingwaterCons-BaseCase'!$D$9),0))))","v":0},null,null,null,{"$f":"IF(B38=\"\",0,IF(SUM(K37:K39)<3,0,1))","v":1},{"$f":"IF(AND(C38>0,D38=\"\"),0,1)","v":1}]
["Annual building water consumption through water fixtures - Existing Case",null,null,null,null,{"$f":"IF(J39<9,0,SUM(F31:F38)*'BuildingwaterCons-BaseCase'!$D$11)","v":0},"liters/year",null,null,{"$f":"J11+J31+J32+J33+J34+J35+J36+J37+J38","v":2},{"$f":"IF(AND(C38>0,E38=\"\"),0,1)","v":1}]
[]
[null,"Total annual building water consumption through water fixtures - Existing Case ",null,null,null,{"$f":"F24+F39","v":0},"liters/year"]

{"sheet":"Landscape water - Base case","index":19,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,0,4,0],[17,0,17,6],[0,0,1,7],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,2,4,2],[3,1,4,1],[3,3,4,3],[3,4,4,4]]}
["Annual landscape water demand - Base Case"]
[]
[]
["S. No.","Month","Plant Species","Evapotranspiration rate (m/day)","Plant factor","Canopy area         (sq. m)","Irrigation system efficiency","Monthly Water requirement (l)"]
[]
[1,"January","Lawns",null,1,null,0.45,{"$f":"IF(OR(D6=\"\",F6=\"\"),\"Please answer all\",((1000*E6*D6*F6)/G6)*31)","v":"Please answer all"},null,null,null,null,{"$f":"IF(H6=\"Please answer all\",0,1)","v":0}]
[2,"February","Lawns",null,1,{"$f":"$F$6","v":0},0.45,{"$f":"IF(OR(D7=\"\",$F$6=\"\"),\"Please answer all\",((1000*E7*D7*F7)/G7)*28)","v":"Please answer all"},null,null,null,null,{"$f":"IF(H7=\"Please answer all\",0,1)","v":0}]
[3,"March","Lawns",null,1,{"$f":"$F$6","v":0},0.45,{"$f":"IF(OR(D8=\"\",$F$6=\"\"),\"Please answer all\",((1000*E8*D8*F8)/G8)*28)","v":"Please answer all"},null,null,null,null,0]
[4,"April","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[5,"May","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[6,"June","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[7,"July","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[8,"August","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[9,"September","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[10,"October","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[11,"November","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
[12,"December","Lawns",null,1,0,0.45,"Please answer all",null,null,null,null,0]
["Annual landscape water demand - Base Case",null,null,null,null,null,null,{"$f":"IF(M18<12,0,SUM(H6:H17))","v":0},"liters/year",null,null,null,{"$f":"COUNTIF(M6:M17,1)","v":0}]

{"sheet":"Landscape water - Existing Case","index":20,"n_rows":114,"n_cols":23,"rows_kept":114,"cut":false,"hidden":true,"merged":[[77,0,84,0],[77,1,84,1],[77,10,84,10],[104,0,111,0],[104,1,111,1],[104,10,111,10],[86,0,93,0],[86,1,93,1],[86,10,93,10],[95,0,102,0],[95,1,102,1],[95,10,102,10],[59,0,66,0],[59,1,66,1],[59,10,66,10],[68,0,75,0],[68,1,75,1],[68,10,75,10],[3,2,4,3],[3,7,3,8],[50,0,57,0],[50,1,57,1],[50,10,57,10],[41,1,48,1],[41,10,48,10],[23,0,30,0],[23,1,30,1],[23,10,30,10],[32,0,39,0],[32,1,39,1],[32,10,39,10],[112,0,112,9],[0,0,1,10],[5,10,12,10],[5,0,12,0],[5,1,12,1],[14,0,21,0],[14,1,21,1],[14,10,21,10],[3,10,4,10],[3,0,4,0],[3,1,4,1],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,9,4,9],[41,0,48,0]]}
["Annual landscape water demand - Existing Case"]
[]
[]
["S. No.","Month","Plant Species",null,"Evapotranspiration rate (m/day)","Plant factor","Canopy area         (sq. m)","Irrigation system",null,"Daily Water requirement (lpd)","Monthly Water requirement (l)"]
[null,null,null,null,null,null,null,"Type","Efficiency"]
[1,"January","a)","Lawns(On ground /podium)",null,1,null,"Micro, drip",{"$f":"+VLOOKUP(H6,$V$7:$W$13,2,FALSE)","v":0.85},{"$f":"IF(OR(E6=\"\",G6=\"\",H6=\"\"),\"Please answer all\",((1000*E6*F6*G6)/I6))","v":"Please answer all"},{"$f":"IF(S9<8,\"Please answer all\",SUM(J6:J13)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J6=\"Please answer all\",0,1)","v":0},null,null,null,"Irrigation system","Efficiency"]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,null,"Micro, spray",{"$f":"+VLOOKUP(H7,$V$7:$W$13,2,FALSE)","v":0.8},{"$f":"IF(OR(E7=\"\",G7=\"\",H7=\"\"),\"Please answer all\",((1000*E7*F7*G7)/I7))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J7=\"Please answer all\",0,1)","v":0},null,null,null,"Micro, drip",0.85]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,null,"Sprinkler, large guns",0.7,"Please answer all",null,null,null,null,null,null,null,0,null,null,null,"Micro, spray",0.8]
[null,null,"d)","Existing Trees (native)",null,0,null,"Micro, spray",0.8,"Please answer all",null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R6:R13,1)","v":0},null,null,"Multiple sprinkler",0.75]
[null,null,"e)","Native Trees on Podium",null,1.2,null,"Micro, drip",0.85,"Please answer all",null,null,null,null,null,null,null,0,null,null,null,"Sprinkler, large guns",0.7]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,null,"Micro, drip",0.85,"Please answer all",null,null,null,null,null,null,null,0,null,null,null,"Seepage",0.5]
[null,null,"g)","If Other, please specify",null,null,null,"Micro, drip",0.85,{"$f":"IF(OR(E12=\"\",G12=\"\",H12=\"\",F12=\"\"),\"Please answer all\",((1000*E12*F12*G12)/I12))","v":"Please answer all"},null,null,null,null,null,null,null,0,null,null,null,"Crown flood",0.5]
[null,null,"h)","If Other, please specify",null,null,null,"Micro, drip",0.85,{"$f":"IF(OR(E13=\"\",G13=\"\",H13=\"\",F13=\"\"),\"Please answer all\",((1000*E13*F13*G13)/I13))","v":"Please answer all"},null,null,null,null,null,null,null,0,null,null,null,"Flood",0.5]
[]
[2,"February","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"I6","v":0.85},{"$f":"IF(OR(E15=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E15*F15*G15)/I15))","v":"Please answer all"},{"$f":"IF(S18<8,\"Please answer all\",SUM(J15:J22)*28)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J15=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E16=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E16*F16*G16)/I16))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E17=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E17*F17*G17)/I17))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E18=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E18*F18*G18)/I18))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R15:R22,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E19=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E19*F19*G19)/I19))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E20=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E20*F20*G20)/I20))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E21=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E21*F21*G21)/I21))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E22=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E22*F22*G22)/I22))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[3,"March","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E24=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E24*F24*G24)/I24))","v":"Please answer all"},{"$f":"IF(S27<8,\"Please answer all\",SUM(J24:J31)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J24=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E25=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E25*F25*G25)/I25))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E26=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E26*F26*G26)/I26))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E27=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E27*F27*G27)/I27))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R24:R31,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E28=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E28*F28*G28)/I28))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E29=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E29*F29*G29)/I29))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E30=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E30*F30*G30)/I30))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E31=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E31*F31*G31)/I31))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[4,"April","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E33=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E33*F33*G33)/I33))","v":"Please answer all"},{"$f":"IF(S36<8,\"Please answer all\",SUM(J33:J40)*30)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J33=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E34=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E34*F34*G34)/I34))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E35=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E35*F35*G35)/I35))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E36=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E36*F36*G36)/I36))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R33:R40,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E37=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E37*F37*G37)/I37))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E38=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E38*F38*G38)/I38))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E39=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E39*F39*G39)/I39))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E40=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E40*F40*G40)/I40))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[5,"May","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E42=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E42*F42*G42)/I42))","v":"Please answer all"},{"$f":"IF(S45<8,\"Please answer all\",SUM(J42:J49)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J42=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E43=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E43*F43*G43)/I43))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J43=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E44=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E44*F44*G44)/I44))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E45=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E45*F45*G45)/I45))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R42:R49,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E46=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E46*F46*G46)/I46))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E47=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E47*F47*G47)/I47))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E48=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E48*F48*G48)/I48))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E49=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E49*F49*G49)/I49))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[6,"June","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E51=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E51*F51*G51)/I51))","v":"Please answer all"},{"$f":"IF(S54<8,\"Please answer all\",SUM(J51:J58)*30)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J51=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E52=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E52*F52*G52)/I52))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J52=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E53=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E53*F53*G53)/I53))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E54=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E54*F54*G54)/I54))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R51:R58,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E55=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E55*F55*G55)/I55))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E56=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E56*F56*G56)/I56))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E57=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E57*F57*G57)/I57))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E58=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E58*F58*G58)/I58))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[7,"July","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E60=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E60*F60*G60)/I60))","v":"Please answer all"},{"$f":"IF(S63<8,\"Please answer all\",SUM(J60:J67)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J60=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E61=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E61*F61*G61)/I61))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J61=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E62=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E62*F62*G62)/I62))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E63=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E63*F63*G63)/I63))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R60:R67,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E64=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E64*F64*G64)/I64))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E65=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E65*F65*G65)/I65))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E66=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E66*F66*G66)/I66))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E67=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E67*F67*G67)/I67))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[8,"August","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E69=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E69*F69*G69)/I69))","v":"Please answer all"},{"$f":"IF(S72<8,\"Please answer all\",SUM(J69:J76)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J69=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E70=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E70*F70*G70)/I70))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J70=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E71=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E71*F71*G71)/I71))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E72=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E72*F72*G72)/I72))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R69:R76,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E73=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E73*F73*G73)/I73))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E74=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E74*F74*G74)/I74))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E75=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E75*F75*G75)/I75))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E76=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E76*F76*G76)/I76))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[9,"September","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E78=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E78*F78*G78)/I78))","v":"Please answer all"},{"$f":"IF(S81<8,\"Please answer all\",SUM(J78:J85)*30)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J78=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E79=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E79*F79*G79)/I79))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J79=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E80=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E80*F80*G80)/I80))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E81=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E81*F81*G81)/I81))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R78:R85,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E82=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E82*F82*G82)/I82))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E83=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E83*F83*G83)/I83))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E84=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E84*F84*G84)/I84))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E85=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E85*F85*G85)/I85))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[10,"October","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E87=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E87*F87*G87)/I87))","v":"Please answer all"},{"$f":"IF(S90<8,\"Please answer all\",SUM(J87:J94)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J87=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E88=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E88*F88*G88)/I88))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J88=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E89=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E89*F89*G89)/I89))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E90=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E90*F90*G90)/I90))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R87:R94,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E91=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E91*F91*G91)/I91))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E92=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E92*F92*G92)/I92))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E93=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E93*F93*G93)/I93))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E94=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E94*F94*G94)/I94))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[11,"November","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E96=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E96*F96*G96)/I96))","v":"Please answer all"},{"$f":"IF(S99<8,\"Please answer all\",SUM(J96:J103)*30)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J96=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E97=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E97*F97*G97)/I97))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J97=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E98=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E98*F98*G98)/I98))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E99=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E99*F99*G99)/I99))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R96:R103,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E100=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E100*F100*G100)/I100))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E101=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E101*F101*G101)/I101))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E102=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E102*F102*G102)/I102))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E103=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E103*F103*G103)/I103))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[]
[12,"December","a)","Lawns(On ground /podium)",null,1,{"$f":"$G$6","v":0},{"$f":"$H$6","v":"Micro, drip"},{"$f":"$I$6","v":0.85},{"$f":"IF(OR(E105=\"\",$G$6=\"\",$H$6=\"\"),\"Please answer all\",((1000*E105*F105*G105)/I105))","v":"Please answer all"},{"$f":"IF(S108<8,\"Please answer all\",SUM(J105:J112)*31)","v":"Please answer all"},null,null,null,null,null,null,{"$f":"IF(J105=\"Please answer all\",0,1)","v":0}]
[null,null,"b)","Native/Naturalized shrubs (On ground / podium)",null,0.4,{"$f":"$G$7","v":0},{"$f":"$H$7","v":"Micro, spray"},{"$f":"$I$7","v":0.8},{"$f":"IF(OR(E106=\"\",$G$7=\"\",$H$7=\"\"),\"Please answer all\",((1000*E106*F106*G106)/I106))","v":"Please answer all"},null,null,null,null,null,null,null,{"$f":"IF(J106=\"Please answer all\",0,1)","v":0}]
[null,null,"c)","Exotic shrubs(newly planted)",null,0.7,{"$f":"$G$8","v":0},{"$f":"$H$8","v":"Sprinkler, large guns"},{"$f":"$I$8","v":0.7},{"$f":"IF(OR(E107=\"\",$G$8=\"\",$H$8=\"\"),\"Please answer all\",((1000*E107*F107*G107)/I107))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"d)","Existing Trees (native)",null,0,{"$f":"$G$9","v":0},{"$f":"$H$9","v":"Micro, spray"},{"$f":"$I$9","v":0.8},{"$f":"IF(OR(E108=\"\",$G$9=\"\",$H$9=\"\"),\"Please answer all\",((1000*E108*F108*G108)/I108))","v":"Please answer all"},null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R105:R112,1)","v":0}]
[null,null,"e)","Native Trees on Podium",null,1.2,{"$f":"$G$10","v":0},{"$f":"$H$10","v":"Micro, drip"},{"$f":"$I$10","v":0.85},{"$f":"IF(OR(E109=\"\",$G$10=\"\",$H$10=\"\"),\"Please answer all\",((1000*E109*F109*G109)/I109))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"f)","Exotic Trees on Podium",null,2.2000000000000002,{"$f":"$G$11","v":0},{"$f":"$H$11","v":"Micro, drip"},{"$f":"$I$11","v":0.85},{"$f":"IF(OR(E110=\"\",$G$11=\"\",$H$11=\"\"),\"Please answer all\",((1000*E110*F110*G110)/I110))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"g)",{"$f":"$D$12","v":"If Other, please specify"},null,{"$f":"$F$12","v":0},{"$f":"$G$12","v":0},{"$f":"$H$12","v":"Micro, drip"},{"$f":"$I$12","v":0.85},{"$f":"IF(OR(E111=\"\",$G$12=\"\",$H$12=\"\",$F$12=\"\"),\"Please answer all\",((1000*E111*F111*G111)/I111))","v":"Please answer all"},null,null,null,null,null,null,null,0]
[null,null,"h)",{"$f":"$D$13","v":"If Other, please specify"},null,{"$f":"$F$13","v":0},{"$f":"$G$13","v":0},{"$f":"$H$13","v":"Micro, drip"},{"$f":"$I$13","v":0.85},{"$f":"IF(OR(E112=\"\",$G$13=\"\",$H$13=\"\",$F$13=\"\"),\"Please answer all\",((1000*E112*F112*G112)/I112))","v":"Please answer all"},null,null,null,null,null,null,null,0]
["Annual Landscape water demand - Existing  Case",null,null,null,null,null,null,null,null,null,{"$f":"IF(S114<96,0,K6+K15+K24+K33+K42+K51+K60+K69+K78+K87+K96+K105)","v":0},"liters/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S9:S108)","v":0}]

{"sheet":"Criterion 8","index":21,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":true,"merged":[[8,9,24,9],[8,10,24,10],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[20,2,20,6],[22,2,22,6],[24,2,24,6],[0,0,0,1],[7,1,7,6],[7,7,7,8],[8,2,8,6],[8,0,24,0]]}
["Criterion 8: Reduction in Cumulative Water Performance"]
[]
["Maximum Possible Points",{"$f":"Water!$C$5","v":10}]
["Anticipated Points",{"$f":"J9","v":"Please answer all"}]
[]
[]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer",null,"Feasible Points","Maximum Points"]
["8.1.1.to 8.1.4 - Reduction in cumulative water performance ",1,"Sources of water supply -",null,null,null,null,null,null,{"$f":"IF(Q22<6,\"Please answer all\",IF(H25>=70%,10,IF(H25>=50%,6,IF(H25>=30%,3,IF(H25>=20%,2,0)))))","v":"Please answer all"},10]
[null,"a)","Quantity of municipality water ",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,{"$f":"IF(H10=\"\",0,1)","v":0}]
[null,"b)","Quantity of bore-well water",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",0,1)","v":0}]
[null,"c)","Quantity of tanker water",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,0]
[null,"d)","Quantity of treated sewage water from STP",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,0]
[null,"e)","Quantity of harvested rainwater reused",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,0]
[]
[null,2,"Water demand / consumption -"]
[null,"a)","Annual domestic water demand /consumption",null,null,null,null,{"$f":"'Criterion 7'!$H$20","v":0},"liters/year"]
[null,"b)","Landscape water demand/consumption",null,null,null,null,{"$f":"'Criterion 7'!$H$30","v":0},"liters/year"]
[null,"c)","Other miscellaneous water demand such as HVAC cooling water and / fire-fighting etc.",null,null,null,null,null,"liters/year",null,null,null,null,null,null,null,{"$f":"IF(H19=\"\",0,1)","v":0}]
[]
[null,null,"Annual water demand ",null,null,null,null,{"$f":"H17+H18+H19","v":0},"liters/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q10:Q19)","v":0}]
[null,null,"Annual fresh water demand",null,null,null,null,{"$f":"IF(SUM(H17:H19)<(H13+H14),0,SUM(H17:H19)-(H13+H14))","v":0},"liters/year"]
[]
[null,null,"Cumulative water performance ",null,null,null,null,{"$f":"IF(OR(H21=0,H23=0),0,IF(H23>H21,\"Annual water demand can not be greater than annual water supply\",H23/H21))","v":0}]

{"sheet":"Appr6","index":22,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,"% offset for daytime occupied commercial buildings","% offset for Residential buildings","% offset for 24X7 occupied commercial buildings","Points"]
[null,2.5000000000000001E-2,0,5.0000000000000001E-3,"Mandatory"]
[null,0.05,0.05,0.01,3]
[null,0.1,0.1,0.03,5]
[null,0.15,0.15,0.05,7]
[null,0.2,0.2,7.0000000000000007E-2,10]
[null,0.25,0.25,0.1,15]
[]
[]
[]
[null,null,"Offset (Mixed Usage)","Points",null,null,null,null,null,"Offset(offsite generation)","Points"]
[null,"Point_0_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C3+Day_time_Occupied_Commercial*B3*0+Commercial_24x7_Occupied*D3*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C3*0+Day_time_Occupied_Commercial*B3+Commercial_24x7_Occupied*D3)/Total_Area,(Residential*C3+Day_time_Occupied_Commercial*B3+Commercial_24x7_Occupied*D3)/Total_Area))","v":{"$error":"#DIV/0!"}},0,null,null,null,null,"Point_0_RE1",0.1,0]
[null,"Point_3_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C4+Day_time_Occupied_Commercial*B4*0+Commercial_24x7_Occupied*D4*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C4*0+Day_time_Occupied_Commercial*B4+Commercial_24x7_Occupied*D4)/Total_Area,(Residential*C4+Day_time_Occupied_Commercial*B4+Commercial_24x7_Occupied*D4)/Total_Area))","v":{"$error":"#DIV/0!"}},3,null,null,null,null,"Point_3_RE1",0.2,3]
[null,"Point_5_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C5+Day_time_Occupied_Commercial*B5*0+Commercial_24x7_Occupied*D5*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C5*0+Day_time_Occupied_Commercial*B5+Commercial_24x7_Occupied*D5)/Total_Area,(Residential*C5+Day_time_Occupied_Commercial*B5+Commercial_24x7_Occupied*D5)/Total_Area))","v":{"$error":"#DIV/0!"}},5,null,null,null,null,"Point_5_RE1",0.4,5]
[null,"Point_7_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C6+Day_time_Occupied_Commercial*B6*0+Commercial_24x7_Occupied*D6*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C6*0+Day_time_Occupied_Commercial*B6+Commercial_24x7_Occupied*D6)/Total_Area,(Residential*C6+Day_time_Occupied_Commercial*B6+Commercial_24x7_Occupied*D6)/Total_Area))","v":{"$error":"#DIV/0!"}},7,null,null,null,null,"Point_7_RE1",0.6,7]
[null,"Point_10_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C7+Day_time_Occupied_Commercial*B7*0+Commercial_24x7_Occupied*D7*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C7*0+Day_time_Occupied_Commercial*B7+Commercial_24x7_Occupied*D7)/Total_Area,(Residential*C7+Day_time_Occupied_Commercial*B7+Commercial_24x7_Occupied*D7)/Total_Area))","v":{"$error":"#DIV/0!"}},10,null,null,null,null,"Point_10_RE1",0.8,10]
[null,"Point_15_RE",{"$f":"IF('Building information'!$C$11=\"Residential\",(Residential*C8+Day_time_Occupied_Commercial*B8*0+Commercial_24x7_Occupied*D8*0)/Total_Area,IF('Building information'!$C$11=\"Commercial\",(Residential*C8*0+Day_time_Occupied_Commercial*B8+Commercial_24x7_Occupied*D8)/Total_Area,(Residential*C8+Day_time_Occupied_Commercial*B8+Commercial_24x7_Occupied*D8)/Total_Area))","v":{"$error":"#DIV/0!"}},15,null,null,null,null,"Point_15_RE1",1,15]

{"sheet":"Human Health & Comfort","index":23,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Human Health & Comfort"]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 9",{"$f":"Content!$C$12","v":"Achieving Indoor Comfort Requirements"},{"$f":"Content!$D$12","v":8},{"$f":"'Criterion 9'!B3","v":8}]
["Criterion 10",{"$f":"Content!$C$13","v":"Maintaining Good IAQ"},{"$f":"'Criterion 10'!B2","v":4},{"$f":"'Criterion 10'!B3","v":4}]

{"sheet":"Criterion 9","index":24,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,1],[5,1,5,6],[7,2,7,6],[8,2,8,6],[7,0,8,0],[6,2,6,6],[10,2,10,6],[13,2,13,6],[14,2,14,6],[13,0,14,0],[7,9,8,9],[13,9,14,9],[7,8,8,8],[13,8,14,8],[11,2,11,6],[10,0,11,0]]}
["Criterion 9: Achieving Indoor Comfort Requirements"]
["Maximum Possible Points",{"$f":"Content!$D$12","v":8}]
["Anticipated Points",{"$f":"I8+I11+I12+I14","v":8}]
[]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer","Feasible Points","Maximum Points",null,null,null,null,"Yes","No"]
[null,null,"Do you have following details needed to show compliance ?"]
["9.1.1 - Demonstrate project can achieve thermal comfort requirement of NBC 2005 / ASHRAE 55 / Indian adaptive comfort model",1,"Hourly temperature and relative humidity profile of at least 80 % of all representative spaces of building for at least one day",null,null,null,null,"Yes",{"$f":"IF(AND(O8=2,R8=0),J8,IF(R8>0,\"Please ans all\",0))","v":2},2,null,null,null,null,{"$f":"IF(AND(H8=\"Yes\",H9=\"Yes\"),2,0)","v":2},null,{"$f":"IF(OR(H8=\"Yes\",H8=\"No\"),0,1)","v":0},{"$f":"COUNTIF(Q8:Q9,1)","v":0}]
[null,2,"Detail of space wise temperature and RH schedule maintain for all season",null,null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(H9=\"Yes\",H9=\"No\"),0,1)","v":0}]
[]
["9.1.2 - \n1.Artificial lighting Lux level to fall within limits as per NBC.\n2. Daylight Factor (DF) of at least 25% of all living area should meet the adequate levels as prescribed in SP 41",1,"Artificial lighting lux level of all regularly occupied spaces fall within the limits defined in NBC",null,null,null,null,"Yes",{"$f":"IF(AND(H11=\"Yes\",Q11=0),J11,IF(Q11>0,\"Please ans all\",0))","v":2},2,null,null,null,null,null,null,{"$f":"IF(OR(H11=\"Yes\",H11=\"No\"),0,1)","v":0}]
[null,2,"Is Daylight Factor (DF) of at least 25% of all regularly occupied living area is fall with the adequate level as prescribed in SP41 ?",null,null,null,null,"Yes",{"$f":"IF(AND(H12=\"Yes\",Q12=0),J12,IF(Q12>0,\"Please ans all\",0))","v":2},2,null,null,null,null,null,null,{"$f":"IF(OR(H12=\"Yes\",H12=\"No\"),0,1)","v":0}]
[]
["9.1.3 - Indoor noise levels should be within acceptable limits as specified in NBC 2005 and key noise source onsite should have sufficient acoustic insulation as per NBC 2005 norms.",1,"A third-party noise audit report highlighting indoor noise level at regularly occupied locations",null,null,null,null,"Yes",{"$f":"IF(AND(O14=2,R14=0),J8,IF(R14>0,\"Please ans all\",0))","v":2},2,null,null,null,null,{"$f":"IF(AND(H14=\"Yes\",H15=\"Yes\"),2,0)","v":2},null,{"$f":"IF(OR(H14=\"Yes\",H14=\"No\"),0,1)","v":0},{"$f":"COUNTIF(Q14:Q15,1)","v":0}]
[null,2,"A narrative highlighting all measures adopted to meet indoor noise levels of NBC 2005",null,null,null,null,"Yes",null,null,null,null,null,null,null,null,{"$f":"IF(OR(H15=\"Yes\",H15=\"No\"),0,1)","v":0}]

{"sheet":"Criterion 10","index":25,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[[25,9,31,9],[25,8,31,8],[31,2,31,6],[24,0,31,0],[25,2,25,6],[28,2,28,6],[26,2,26,6],[27,2,27,6],[29,2,29,6],[24,2,24,6],[30,2,30,6],[2,1,2,2],[1,1,1,2],[0,0,0,2],[12,2,12,6],[23,1,23,6],[18,2,18,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[5,2,5,3],[21,0,21,6],[11,2,11,6],[10,1,10,6],[11,0,20,0]]}
["Criterion 10: Maintaining Good IAQ"]
["Maximum Possible Points",{"$f":"IF(H22=\"Not eligible for Rating\",6,J26)","v":4}]
["Anticipated Points",{"$f":"IF(H22=\"Eligible for Rating\",I26,\"Not meeting the mandatory complience, hence not eligible for rating\")","v":4}]
[]
[]
[null,null,"Choose among the type of space you have ",null,"Conditioned space"]
[null,null,null,"Un-conditioned space area",null,"Sq.m",null,null,null,null,null,null,null,null,{"$f":"SUM(E7:E8)","v":0}]
[null,null,null,"Conditioned space area",null,"Sq.m"]
[]
[]
["Appraisal","Eligibility Check",null,null,null,null,null,"Answer",null,null,null,null,"Select","Yes","No","NA","Conditioned space","Un-conditioned space","Mixed space"]
["10.1.1 (Mandatory) - Smoking must be banned /prohibited within the building premises. In case smoking is allowed then air from smoking area must be isolated to prevent recirculation of tobacco smoke containing air to non-smoking areas",null,"Do you have following details needed to show compliance ?"]
[null,1,"No-smoking policy along with photographs of no-smoking signage along with penalty clauses",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(H13=\"Yes\",1,0)","v":1},null,{"$f":"IF(OR(H13=\"Yes\",H13=\"NA\",H13=\"No\"),0,1)","v":0}]
[null,2,"Photographs of no-smoking signage along with penalty clauses ",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(H14=\"Yes\",1,0)","v":1},null,{"$f":"IF(OR(H14=\"Yes\",H14=\"NA\",H14=\"No\"),0,1)","v":0}]
[null,3,"Company policy for ban/prohibition on smoking within the building premise ",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(H15=\"Yes\",1,0)","v":1},null,0]
[null,4,"Building floor plan or interior layout demonstrating the internal planning for smoke control ",null,null,null,null,"Yes",null,null,null,null,null,1,null,0]
[null,5,"As built ducting drawing highlighting designated smoking area is independent of non-smoking areas in the building",null,null,null,null,"Yes",null,null,null,null,{"$f":"SUM(N13:N16,N20)","v":5},null,null,0,{"$f":"IF(OR(E6=\"Conditioned space\",E6=\"Mixed space\"),1,0)","v":1},{"$f":"COUNTIF(P13:P19,1)","v":0}]
[null,6,"As built ducting drawing highlighting smoking air is exhausted directly to the outdoor such that no recirculation of tobacco smoke air to non-smoking spaces",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(OR(H17=\"Yes\",H17=\"NA\"),1,0)","v":1},null,0]
[null,7,"Presence of separate ventilation systems for smoking spaces  ?",null,null,null,null,"Yes",null,null,null,null,null,{"$f":"IF(OR(H18=\"Yes\",H18=\"NA\"),1,0)","v":1},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H19=\"Yes\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N13,N14,N15,N16,N18,N19,N20)","v":7}]
["Eligibility",null,null,null,null,null,null,{"$f":"IF(AND(N21=7,Q17=1,R17=0,H17=\"Yes\",H18=\"Yes\"),\"Eligible for Rating\",IF(AND(M17=5,Q17=0,R17=0),\"Eligible for Rating\",IF(R17>0,\"Please ans all\",\"Not eligible for Rating\")))","v":"Eligible for Rating"}]
[]
["Appraisal","Feasibility check",null,null,null,null,null,"Answer","Feasible Points","Maximum Points"]
["10.1.2 - Meet minimum requirements of - \n1. For quality of fresh air - CPCB national ambient air quality standard (treatment of outdoor air for PM2.5, PM10 and CO2.\n2. For fresh air quantity - ASHRAE standard 62.1 - 2010 / NBC.",null,"Do you have following details needed to show compliance ?"]
[null,1,"For quality of fresh air -",null,null,null,null,null,{"$f":"IF(AND(Q17=1,H27=\"Yes\",H28=\"Yes\",H30=\"Yes\",H31=\"Yes\",H32=\"Yes\"),4,IF(AND(Q17=1,H27=\"Yes\",H28=\"Yes\",H32=\"Yes\"),2,IF(AND(Q17=1,H30=\"Yes\",H31=\"Yes\",H32=\"Yes\"),2,IF(Q17=0,0,0))))","v":4},{"$f":"IF(Q17=0,0,4)","v":4}]
[null,"a)","A test report from an NABL accredited laboratory highlighting the fresh air quality ",null,null,null,null,"Yes"]
[null,"b)","Specifications of filtration system",null,null,null,null,"Yes"]
[null,2,"For quantity of fresh air - "]
[null,"a)","As built drawings of HVAC floor plans",null,null,null,null,"Yes"]
[null,"b)","Space by space calculation for all regular occupied spaces highlighting provision of sufficient fresh air as per ASHARE 62.1/NBC",null,null,null,null,"Yes"]
[null,3,"Occupant comfort survey conducted within three months prior to document submission to demonstrate that 80% of the building occupant are satisfied with indoor air quality and quantity",null,null,null,null,"Yes"]

{"sheet":"Soical Aspects","index":26,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Soical Aspects"]
[]
["Criterion Number","Criterion Name","Maixum Point","Anticipated points"]
["Criterion 12","Universal accessibility ",2]
["Criterion 13","Environmental Awareness",2]

{"sheet":"Criterion 13","index":27,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Criterion 14: Enviormental Awareness"]
[]
["Maximum Possible Points",{"$f":"'Soical Aspects'!$C$5","v":2}]
["Anticipated Points"]

{"sheet":"Criterion 14","index":28,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Criterion 12: Bouns Points"]
[]
["Maximum Possible Points",{"$f":"Content!$D$15","v":4}]
["Anticipated Points"]

{"sheet":"Sheet1","index":29,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Logical"]
["Yes"]
["No"]

{"sheet":"Social Aspects","index":30,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!$A$14","v":"Social Aspects"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 11",{"$f":"Content!$C$14","v":"Universal Accessibility & Environmental Awareness"},{"$f":"Content!$D$14","v":5},{"$f":"'Criterion 11'!C4","v":5}]

{"sheet":"Criterion 11","index":31,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":true,"merged":[[20,5,24,5],[20,6,24,6],[6,5,16,5],[6,6,16,6],[20,2,20,3],[22,2,22,3],[15,2,15,3],[16,2,16,3],[19,2,19,3],[21,2,21,3],[18,0,18,3],[7,1,14,1],[7,0,14,0],[0,0,0,2],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,0,6,3]]}
["Criterion 11: Accessibility to Services and Environmental Awareness"]
[]
["Maximum Possible Points",null,{"$f":"'Social Aspects'!$C$4","v":5}]
["Anticipated Points",null,{"$f":"IF(OR(P8>0,S21>0),\"Please answer all\",F7+F21)","v":5}]
[]
["Appraisal 11.1.1 - Universal Accessibility",null,null,null,"Answer","Feasible Points","Maximum Points"]
["The project complies with minimum provisions as per Harmonized Guidelines and Space Standards for Barrier-Free Built Environment for persons with Disability and Elderly Persons ",null,null,null,"Choose Below",{"$f":"IF(AND(E8=\"Yes\",E9=\"Yes\",E10=\"Yes\",E11=\"Yes\",E12=\"Yes\",E13=\"Yes\",E14=\"Yes\",E15=\"Yes\",E16=\"Yes\",E17=\"Yes\",P8=0),2,IF(P8>0,\"Please ans all\",0))","v":2},2]
[1,"Provision of Ramps at the entrance","At least one Ramp exists at either main , side or back entrance",null,"Yes",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(R8:R17,1)","v":0},null,{"$f":"IF(OR(E8=\"Yes\",E8=\"No\"),0,1)","v":0}]
[null,null,"Direction Signs leading to Ramp are placed",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E9=\"Yes\",E9=\"No\"),0,1)","v":0}]
[null,null,"Handrails all through the ramp  are graspable on both side",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Width between handrails is more than  900 mm",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Tactile warning blocks (Dot-type) at appropriate places",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Where pathways meet the road a kerb ramp is provided",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"The ramp Gradient is less than 1:12 (1 Vertical to 12 Horizontal)",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Level area 1670 X 1670 at top and bottom ",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E15=\"Yes\",E15=\"No\"),0,1)","v":0}]
[2,"Preferred  parking Space","At least one Parking Space for car is reserved for elderly and differently abled.",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[3,"Toilet for Persons for special needs","At least one unisex accessible toilet is functional for the usages of persons with special needs. ",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Appraisal 11.1.2 - Environmental Awareness",null,null,null,"Answer","Feasible Points","Maximum Points"]
[]
[1,"Innovative displays","Innovative display on ‘Environmental concerns and possible solutions at individual level’ in common area/lobby\n",null,"Yes",{"$f":"IF(AND(O21>2,S21=0),3,IF(S21>0,\"Please answer all\",0))","v":3},3,null,null,null,null,null,null,null,{"$f":"SUM(P21:P25)","v":5},{"$f":"IF(E21=\"Yes\",1,0)","v":1},null,{"$f":"IF(OR(E21=\"Yes\",E21=\"No\"),0,1)","v":0},{"$f":"COUNTIF(R21:R25,1)","v":0}]
[2,"Local outreach through posters, brochures and social media","Formal environmental awareness programme / activities in building space and social media take place at least twice yearly.",null,"Yes",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E22=\"Yes\",1,0)","v":1},null,0]
[3,"Short environmental tours","Short formal  tours are organized  within the facility to highlight the green initiatives taken by the project proponent at least twice yearly. ",null,"Yes",null,null,null,null,null,null,null,null,null,null,1,null,0]
[4,"Awareness programme for occupants/ and\nO & M staff.","Formal training programme on Environmental awareness are available for  are available for the occupants and O & M staff on demand  and are conducted al least twice yearly. ",null,"Yes",null,null,null,null,null,null,null,{"$f":"IF(AND(O21>2,S21=0),3,IF(S21>0,\"Please ans all\",0))","v":3},null,null,1,null,0]
[5,"Adopt innovative strategies","The building has adopted innovative strategies such as labeling the water fixtures highlighting the water source. For example, this tap uses rainwater harvested from the roof.",null,"Yes",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E25=\"Yes\",1,0)","v":1},null,0]

{"sheet":"Bonus Point","index":32,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
[{"$f":"Content!$A$15","v":"Bonus Points"}]
[]
["Criterion Number","Criterion Name","Maximum Point","Anticipated points"]
["Criterion 12",{"$f":"Content!$C$15","v":"Bonus Points"},{"$f":"Content!$D$15","v":4},{"$f":"'Criterion 12'!C4","v":4}]

{"sheet":"Criterion 12","index":33,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":true,"merged":[[9,5,13,5],[9,6,13,6],[0,0,0,2],[2,0,2,1],[3,0,3,1],[7,1,7,3],[8,1,8,3],[8,0,14,0],[11,2,11,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[13,2,13,3]]}
["Criterion 12: Bonus Points"]
[]
["Maximum Possible Points",null,{"$f":"'Bonus Point'!$C$4","v":4}]
["Anticipated Points",null,{"$f":"F10","v":4}]
[]
[]
[]
["Appraisal","Feasibility Check",null,null,"Answer","Feasible Points","Maximum Points",null,null,null,null,"Yes","No"]
["12.1.1 - Adopt strategies in improving the sustainability of the project","Choose any two "]
[null,1,"Net zero water discharge",null,"No",{"$f":"IF(M16>0,\"Please ans all\",IF(L16=2,2,IF(L16>=4,4,0)))","v":4},4,null,null,null,null,{"$f":"IF(E10=\"Yes\",2,0)","v":0},{"$f":"IF(E10=\"--Select--\",1,0)","v":0}]
[null,2,"Net positive energy/ net zero energy - generation of energy from renewable energy sources at onsite",null,"Yes",null,null,null,null,null,null,2,0]
[null,3,"Previously GRIHA certified project ",null,"Yes",null,null,null,null,null,null,2,0]
[null,4,"Urban farming",null,"Yes",null,null,null,null,null,null,2,0]
[null,5,"Any other strategy that is not covered in the previous section but can significantly improve the sustainability of the project",null,"No",null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L14)","v":6},{"$f":"COUNTIF(M10:M14,1)","v":0}]