{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["V1","V2","Overview","Project Details","Cal _ Area Statement Circulatio","Water efficient plumbing fixtur","Conditioned space","Cal _ Natural Ventilation","LPD Space function method","LPD Building area method","On-Site Renewable Energy","Ver 1_Master Material Sheet","Ver 2_Master Material Sheet","Waste management installation","Ver 1 Cal _ Daylight  CO2 Noise","Ver 2 Cal _ Daylight Noise","Fresh air AC","Occupant wellbeing facility"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":51,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"V1","index":0,"n_rows":192,"n_cols":6,"rows_kept":192,"cut":false,"hidden":false,"merged":[[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[183,0,183,1],[184,0,184,3],[172,0,172,1],[173,0,174,1],[173,2,174,2],[175,0,175,1],[176,0,176,3],[177,0,177,5],[162,0,163,1],[162,2,163,2],[164,0,167,1],[164,2,167,2],[164,5,167,5],[168,0,171,1],[168,2,171,2],[168,4,169,4],[168,5,171,5],[170,4,171,4],[152,0,153,1],[152,2,153,2],[154,0,156,1],[154,2,156,2],[154,5,156,5],[157,0,161,1],[157,2,161,2],[161,4,161,5],[143,0,143,1],[144,0,145,1],[144,2,145,2],[146,0,151,0],[146,1,147,1],[146,2,151,2],[148,1,149,1],[150,1,151,1],[133,0,134,1],[133,2,138,2],[135,0,138,0],[135,1,136,1],[137,1,138,1],[139,0,142,1],[139,2,142,2],[126,0,126,3],[127,0,127,5],[129,0,129,1],[130,0,130,1],[130,2,132,2],[130,4,132,4],[130,5,132,5],[131,0,132,0],[118,0,122,1],[118,2,122,2],[123,0,125,1],[123,2,125,2],[123,4,125,4],[123,5,125,5],[108,0,110,1],[108,2,110,2],[108,5,110,5],[111,0,117,1],[111,2,117,2],[111,5,117,5],[98,0,107,0],[98,1,102,1],[98,2,107,2],[98,5,102,5],[103,1,107,1],[103,5,107,5],[89,0,92,1],[89,2,92,2],[89,5,92,5],[93,0,97,1],[93,2,97,2],[93,5,97,5],[76,4,76,5],[77,1,83,1],[83,4,83,5],[85,0,85,3],[86,0,86,5],[88,0,88,1],[66,0,69,0],[66,1,67,1],[66,2,69,2],[68,1,69,1],[70,0,83,0],[70,1,76,1],[70,2,83,2],[63,0,65,1],[63,2,65,2],[63,4,65,4],[63,5,65,5],[50,4,50,5],[51,1,57,1],[57,4,57,5],[58,0,60,1],[58,2,60,2],[60,4,60,5],[33,0,33,3],[34,0,34,5],[36,0,36,1],[37,0,57,0],[37,1,43,1],[37,2,57,2],[43,4,43,5],[44,1,50,1],[61,0,62,0],[61,2,62,2],[61,4,62,4],[61,5,62,5],[14,0,14,1],[15,0,16,1],[15,2,16,2],[17,0,17,3],[18,0,18,5],[20,0,32,1],[20,2,32,2],[32,4,32,5],[7,5,8,5],[9,0,10,1],[9,2,10,2],[11,0,13,1],[11,2,13,2],[11,4,11,5],[12,4,13,4],[12,5,13,5],[0,0,1,3],[2,0,2,1],[2,4,2,5],[3,0,3,5],[4,2,4,5],[5,0,8,1],[5,2,8,2],[5,4,6,4],[5,5,6,5],[7,4,8,4]]}
["Version 1",null,null,null,"New Interiors","Existing Interiors"]
[null,null,null,null,{"$f":"SUM(E18,E34,E127,E177,E185,E86)","v":100},{"$f":"SUM(F18,F34,F127,F177,F185,F86)","v":75}]
["Credit Name",null,"Total Available Points","Requirement","Point Distribution"]
[]
["Eco Design Approach\n"]
["Eco Vision for Interior Design",null,2,"Measure-1",1,1]
[null,null,null,"Measure-2"]
[null,null,null,"Measure-3",2,2]
[null,null,null,"Measure-4"]
["Optimise Circulation Spaces",null,2,"≥ 25% ",1,1]
[null,null,null,"≥ 30%",2,2]
["Eco-friendly commuting ",null,1,"Either option 1 or option 2"]
[null,null,null,"Public transport",1,1]
[null,null,null,"Shuttle Service"]
["Occupancy in a Green Facility",null,1,"Yes / No",1,1]
["Commercial Lease Term/ Ownership",null,2,"3 years ",1,1]
[null,null,null,"5 years",2,2]
["Total achievable points",null,null,null,{"$f":"E8+E11+E12+E15+E17+E13","v":8},{"$f":"F8+F11+F12+F15+F17+F13","v":8}]
[]
["Water Conservation"]
["Water efficient plumbing fixtures",null,12,"10% less than the baseline criteria ",1,1]
[null,null,null,"12.5% less than the baseline criteria ",2,2]
[null,null,null,"15% less than the baseline criteria ",3,3]
[null,null,null,"17.5% less than the baseline criteria ",4,4]
[null,null,null,"20% less than the baseline criteria ",5,5]
[null,null,null,"22.5% less than the baseline criteria ",6,6]
[null,null,null,"25% less than the baseline criteria ",7,7]
[null,null,null,"27.5% less than the baseline criteria ",8,8]
[null,null,null,"30% less than the baseline criteria ",9,9]
[null,null,null,"32.5% less than the baseline criteria ",10,10]
[null,null,null,"35% less than the baseline criteria ",11,11]
[null,null,null,"37.5% less than the baseline criteria ",12,12]
[null,null,null,"40% less than the baseline criteria","Exemplary performance"]
["Total achievable points",null,null,null,{"$f":"E32","v":12},{"$f":"F32","v":12}]
[]
["Energy Efficiency"]
["Eco-friendly Refrigerants & Halons",null,1,null,1,1]
[" Efficient space conditioning\n\n\n","Option 1A : Non Air-conditioned spaces ( Door & Window Openings)",6,"5% over baseline ",1,1]
[null,null,null,"6% over baseline ",2,2]
[null,null,null,"7% over baseline ",3,3]
[null,null,null,"8% over baseline ",4,4]
[null,null,null,"9% over baseline ",5,5]
[null,null,null,"10% over baseline ",6,6]
[null,null,null,"11% over baseline ","Exemplary performance"]
[null,"Option 1B :  Non Air-conditioned spaces (Alternate  efficient cooling methods)",null,"25% of the carpet area",1,1]
[null,null,null,"30% of the carpet area",2,2]
[null,null,null,"35% of the carpet area",3,3]
[null,null,null,"40% of the carpet area",4,4]
[null,null,null,"45% of the carpet area",5,5]
[null,null,null,"50% of the carpet area",6,6]
[null,null,null,"55% of the carpet area","Exemplary performance"]
[null,"Option 2: Conditioned spaces",null,"50% of efficiently Conditioned spaces ",1,1]
[null,null,null,"55% of efficiently Conditioned spaces ",2,2]
[null,null,null,"60% of efficiently Conditioned spaces ",3,3]
[null,null,null,"65% of efficiently Conditioned spaces ",4,4]
[null,null,null,"70% of efficiently Conditioned spaces ",5,5]
[null,null,null,"75% of efficiently Conditioned spaces ",6,6]
[null,null,null,"95% of efficiently Conditioned spaces ","Exemplary performance"]
[" Energy Efficient lighting\n\n1. Lighting Power Density",null,2," 20% of Lighting Power Density",1,1]
[null,null,null," 25% of Lighting Power Density",2,2]
[null,null,null," 30% of Lighting Power Density","Exemplary performance"]
["2. Sensors","Regularly occupied spaces",1,"75% of regularly occupied areas",1,1]
[null,"Non-Regularly occupied spaces",null,"95% of non regularly occupied areas"]
[" Energy Efficient Appliance",null,1,"Appliance-1",1,1]
[null,null,null,"Appliance-2"]
[null,null,null,"Appliance-3"]
["Energy Metering & Management","Sub-Metering",4,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
[null,"Building Management System",null,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
["On-site  / Off-site Renewable Energy\n","On-site renewable energy systems",6,"2% of the total energy consumption",1,1]
[null,null,null,"4% of the total energy consumption",2,2]
[null,null,null,"6% of the total energy consumption",3,3]
[null,null,null,"8% of the total energy consumption",4,4]
[null,null,null,"10% of the total energy consumption",5,5]
[null,null,null,"12% of the total energy consumption",6,6]
[null,null,null,"14% of the total energy consumption","Exemplary performance"]
[null,"Off-site renewable energy systems",null,"5% of the total energy consumption",1,1]
[null,null,null,"10% of the total energy consumption",2,2]
[null,null,null,"15% of the total energy consumption",3,3]
[null,null,null,"20% of the total energy consumption",4,4]
[null,null,null,"25% of the total energy consumption",5,5]
[null,null,null,"30% of the total energy consumption",6,6]
[null,null,null,"35% of the total energy consumption","Exemplary performance"]
["Embodied Energy",null,1,null,1,1]
["Total achievable points",null,null,null,22,21]
[]
["Interior Materials"]
["IM Mandatory Requirement 1",null,"MR","Segregation of Waste, Post Occupancy","Required","Required"]
["Waste Management (During Installation) ",null,3,"Percentage of Waste diverted away from landfill : 20% ",1,"NA"]
[null,null,null,"Percentage of Waste diverted away from landfill : 40% ",2]
[null,null,null,"Percentage of Waste diverted away from landfill : 60% ",3]
[null,null,null,"Percentage of Waste diverted away from landfill : 80% ","Exemplary performance"]
["Local Materials",null,4,"20% of Local Materials ",1,"NA"]
[null,null,null,"30% of Local Materials ",2]
[null,null,null,"40% of Local Materials ",3]
[null,null,null,"50 %of Local Materials ",4]
[null,null,null,"60 %of Local Materials ","Exemplary performance"]
["Recycled Content Materials\n","Source materials with recycled content",4,"≥ 10% of Materials with Recycled Content",1,"NA"]
[null,null,null,"≥ 15% of Materials with Recycled Content",2]
[null,null,null,"≥ 20% of Materials with Recycled Content",3]
[null,null,null,"≥ 25% of Materials with Recycled Content",4]
[null,null,null,"≥ 30% of Materials with Recycled Content","Exemplary performance"]
[null,"Source type I ecolabelled products",null,"1 certified product(s)",1,"NA"]
[null,null,null,"2 certified product(s)",2]
[null,null,null,"3 certified product(s)",3]
[null,null,null,"4 certified product(s)",4]
[null,null,null,"5 certified product(s)","Exemplary performance"]
["Salvaged Materials ",null,2,"≥ 2.5% of Salvaged Materials ",1,"NA"]
[null,null,null," ≥ 5% of Salvaged Materials ",2]
[null,null,null," ≥ 7.5% of Salvaged Materials ","Exemplary performance"]
["Eco Friendly Wood Based Materials ",null,6,"20% of total cost of ecofriendly woodbased material",1,"NA"]
[null,null,null,"25% of total cost of ecofriendly woodbased material",2]
[null,null,null,"30% of total cost of ecofriendly woodbased material",3]
[null,null,null,"35% of total cost of ecofriendly woodbased material",4]
[null,null,null,"40% of total cost of ecofriendly woodbased material",5]
[null,null,null,"45% of total cost of ecofriendly woodbased material",6]
[null,null,null,"50% of total cost of ecofriendly woodbased material","Exemplary performance"]
["Eco-certified Interior Furniture",null,4,"10% of total furniture cost",1,1]
[null,null,null,"20% of total furniture cost",2,2]
[null,null,null,"30% of total furniture cost",3,3]
[null,null,null,"40% of total furniture cost",4]
[null,null,null,"50% of total furniture cost","Exemplary performance",4]
["Purchase of Green Consumables",null,3,"Measure-1","NA",3]
[null,null,null,"Measure-2"]
[null,null,null,"Measure-3"]
["Total achievable points",null,null,null,23,7]
[]
["Indoor Environment"]
["Tobacco Smoke Pollution ",null,"Mandatory Requirement","Required","Required","Required"]
["Fresh Air Ventilation\nOption 1: Mechanical ventilation",null,"Mandatory Requirement"," Design as per baseline","Required","Required"]
["Fresh Air Ventilation\nOption 2 : Natural Ventilation","Regularly occupied area <150 sq m",null,0.04]
[null,"Regularly occupied area ≥150 sq.m",null,0.06]
["Enhanced Fresh Air Ventilation\nOption 1: Mechanical ventilation",null,2,"≥ 5% more than baseline criteria ",1,1]
[null,null,null,"≥ 10% more than baseline criteria ",2,2]
["Enchanced Fresh Air Ventilation\nOption 2 : Natural Ventilation","Regularly occupied area <150 sq m",null,0.06,1,1]
[null,null,null,0.08,2,2]
[null,"Regularly occupied area ≥150 sq.m",null,0.08,1,1]
[null,null,null,0.1,2,2]
["Daylighting ",null,4,"≥ 25%  of regularly occupied Spaces with daylight ",1,1]
[null,null,null," ≥ 50%  of regularly occupied Spaces with daylight ",2,2]
[null,null,null," ≥ 75%  of regularly occupied Spaces with daylight ",3,3]
[null,null,null," ≥ 95%  of regularly occupied Spaces with daylight ",4,4]
["Thermal Comfort",null,1,"Yes / No","NA",1]
["Ergonomic Design",null,2,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
["CO2  Monitoring","Mechanical ventilation",2,"50% in regularly occupied areas",1,1]
[null,null,null,"95% in regularly occupied areas",2,2]
[null,"Regularly occupied area <150 sq m",null,"10% of openable area to total\ncarpet area",1,1]
[null,null,null,"12% of openable area to total\ncarpet area",2,2]
[null,"Regularly occupied area ≥150 sq.m",null,"12% of openable area to total\ncarpet area",1,1]
[null,null,null,"14% of openable area to total\ncarpet area",2,2]
["Indoor Plants",null,2,"50% of regularly occupied area",1,1]
[null,null,null,"95% of regularly occupied area",2,2]
["Material Acoustic performance",null,3,"Ceiling Systems",1,"NA"]
[null,null,null,"Flooring Systems ",1]
[null,null,null,"Office Type \n          1. Enclosed offices \n          2. Open office ",1]
["Outdoor Views",null,4,"≥ 40% of regularly occupied spaces having outdoor views",1,1]
[null,null,null,"≥ 50% of regularly occupied spaces having outdoor views",2,2]
[null,null,null,"≥ 60% of regularly occupied spaces having outdoor views",3,3]
[null,null,null," ≥ 70% of regularly occupied spaces having outdoor views",4,4]
[null,null,null," ≥ 80% of regularly occupied spaces having outdoor views","Exemplary performance"]
["Minimise Indoor Pollutant Contamination",null,2,"Measures-1",1,1]
[null,null,null,"Measures-2",2,2]
["Low-Emitting Materials",null,4,"Paints & Coatings",1,"NA"]
[null,null,null,"Adhesives",1]
[null,null,null,"Flooring Systems",1]
[null,null,null,"Composite Wood",1]
["Indoor Air Quality Management, During Installation",null,2,"Measures-1",1,"NA"]
[null,null,null,"Measures-2"]
[null,null,null,"Measures-3",2]
[null,null,null,"Measures-4"]
["Interior Flush out",null,1,"Yes / No",1,"NA"]
["Occupant Well-being Facilities",null,2,"5% of occupants with access to recreational facilities at a given time",1,1]
[null,null,null,"10% of occupants with access to recreational facilities at a given time",2,2]
["Dedicated Dining Spaces",null,1,"Yes / No","NA",1]
["Total achievable points",null,null,null,30,22]
[]
["Innovation in Interior Design"]
["Innovation in Interior Design",null,1,"Innovation or Exemplorray performance",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplorray performance",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplorray performance",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplorray performance",1,1]
["IGBC Accredited Professional",null,1,"Yes / No",1,1]
["Total achievable points",null,null,null,5,{"$f":"SUM(E180:E184)","v":5}]
[]
[]
[null,"Certification Level","New Interiors Points","Existing Interiors Points"]
[null,"Certified","30-44","22-32"]
[null,"Silver","45-59","33-44"]
[null,"Gold","60 -79","45-59"]
[null,"Platinum","80-100","60-75"]

{"sheet":"V2","index":1,"n_rows":185,"n_cols":6,"rows_kept":185,"cut":false,"hidden":false,"merged":[[0,0,1,3],[2,0,2,1],[2,4,2,5],[3,2,3,5],[4,0,5,1],[4,2,5,2],[10,0,11,1],[10,2,11,2],[12,0,13,1],[12,2,13,2],[14,0,14,3],[15,0,15,5],[6,0,8,1],[6,2,8,2],[6,4,6,5],[7,4,8,4],[7,5,8,5],[9,0,9,1],[30,0,30,3],[33,0,33,1],[34,0,35,1],[34,2,35,2],[36,0,53,0],[36,1,41,1],[36,2,53,2],[16,0,16,5],[17,0,27,1],[17,2,27,2],[27,4,27,5],[28,0,29,1],[28,2,29,2],[41,4,41,5],[42,1,47,1],[47,4,47,5],[48,1,53,1],[53,4,53,5],[54,0,59,0],[54,1,56,1],[54,2,59,2],[56,4,56,5],[57,1,59,1],[67,0,80,0],[67,1,73,1],[67,2,80,2],[73,4,73,5],[74,1,80,1],[80,4,80,5],[59,4,59,5],[60,0,62,1],[60,2,62,2],[60,4,62,4],[60,5,62,5],[63,0,66,0],[63,1,64,1],[63,2,66,2],[65,1,66,1],[89,0,91,1],[89,2,91,2],[89,5,91,5],[92,0,94,1],[92,2,94,2],[92,5,94,5],[81,0,81,3],[84,0,84,1],[85,0,85,1],[86,0,88,1],[86,2,88,2],[86,5,88,5],[103,0,105,1],[103,2,105,2],[103,5,105,5],[106,0,108,1],[106,2,108,2],[106,5,108,5],[95,0,102,0],[95,1,99,1],[95,2,102,2],[95,4,96,4],[95,5,102,5],[97,4,98,4],[100,1,102,1],[119,0,120,1],[119,2,120,2],[121,0,121,3],[124,0,124,1],[125,0,125,1],[125,2,127,2],[109,0,113,1],[109,2,113,2],[109,5,113,5],[114,0,118,1],[114,2,118,2],[118,4,118,5],[134,0,137,1],[134,2,137,2],[138,0,139,1],[138,2,139,2],[138,4,139,4],[138,5,139,5],[125,4,127,4],[125,5,127,5],[126,0,127,0],[128,0,129,1],[128,2,133,2],[130,0,133,0],[130,1,131,1],[132,1,133,1],[148,0,150,1],[148,2,150,2],[148,5,150,5],[151,0,155,1],[151,2,155,2],[155,4,155,5],[140,0,141,1],[140,2,141,2],[142,0,145,1],[142,2,145,2],[145,4,145,5],[146,0,147,1],[146,2,147,2],[162,0,163,1],[162,2,163,2],[162,4,163,4],[162,5,163,5],[164,0,164,1],[165,0,166,1],[165,2,166,2],[156,0,157,1],[156,2,157,2],[156,4,157,4],[156,5,157,5],[158,0,161,1],[158,2,161,2],[158,5,161,5],[174,0,174,1],[175,0,175,1],[176,0,176,3],[178,0,178,5],[167,0,167,1],[168,0,168,3],[170,0,170,5],[171,0,171,1],[172,0,172,1],[173,0,173,1]]}
["IGBC Green Interiors Checklist Ver 2",null,null,null,"New Interiors","Existing Interiors"]
[null,null,null,null,{"$f":"E15+E31+E82+E122+E169+E177","v":100},{"$f":"F15+F31+F82+F122+F169+F177","v":75}]
["Credit Name",null,"Total Available Points","Requirement","Point Distribution"]
["Eco Design Approach"]
["Optimise Circulation Spaces",null,2,"≥ 25% ",1,1]
[null,null,null,"≥ 30%",2,2]
["Eco-friendly commuting ",null,1,"Either option 1 or option 2"]
[null,null,null,"Public transport",1,1]
[null,null,null,"Shuttle Service"]
["Occupancy in a Green Facility",null,1,"Yes/No",1,1]
["Commercial Lease Term/ Ownership",null,2,"3 years ",1,1]
[null,null,null,"5 years",2,2]
[" Awareness on Sustainability Concepts ",null,2,"Display of permanent signages",1,1]
[null,null,null,"Awareness sessions ",1,1]
["Total achievable points",null,null,null,8,8]
[]
["Water Conservation"]
["Water efficient plumbing fixtures",null,10,"15% less than the baseline criteria ",1,1]
[null,null,null,"17.5% less than the baseline criteria ",2,2]
[null,null,null,"20% less than the baseline criteria ",3,3]
[null,null,null,"22.5% less than the baseline criteria ",4,4]
[null,null,null,"25% less than the baseline criteria ",5,5]
[null,null,null,"27.5% less than the baseline criteria ",6,6]
[null,null,null,"30% less than the baseline criteria ",7,7]
[null,null,null,"32.5% less than the baseline criteria ",8,8]
[null,null,null,"35% less than the baseline criteria ",9,9]
[null,null,null,"37.5% less than the baseline criteria ",10,10]
[null,null,null,"40% less than the baseline criteria ","Exemplary performance"]
["Repurposing Rejected Water",null,2,"Measure-1",1,1]
[null,null,null,"Measure-2",1,1]
["Total achievable points",null,null,null,12,12]
[]
["Energy Efficiency"]
["Eco-friendly Refrigerants & Halons",null,"MR",null,"Required","Required"]
["Enhanced Eco-friendly Refrigerants",null,2,"GWP ≤ 1,500 ",1,1]
[null,null,null,"GWP ≤ 1, 000",2,2]
[" Efficient space conditioning","Option 1A : Non Air-conditioned spaces ( Door & Window Openings)",5,"5% over baseline ",1,1]
[null,null,null,"6% over baseline ",2,2]
[null,null,null,"7% over baseline ",3,3]
[null,null,null,"8% over baseline ",4,4]
[null,null,null,"10% over baseline ",5,5]
[null,null,null,"12% over baseline ","Exemplary performance"]
[null,"Option 1B :  Non Air-conditioned spaces (Alternate efficient cooling methods)",null,"25% of the carpet area",1,1]
[null,null,null,"30% of the carpet area",2,2]
[null,null,null,"35% of the carpet area",3,3]
[null,null,null,"40% of the carpet area",4,4]
[null,null,null,"45% of the carpet area",5,5]
[null,null,null,"50% of the carpet area","Exemplary performance"]
[null,"Option 2: Conditioned spaces",null,"55% of Conditioned spaces of regularly occupied areas",1,1]
[null,null,null,"60% of Conditioned spaces of regularly occupied areas",2,2]
[null,null,null,"65% of Conditioned spaces of regularly occupied areas",3,3]
[null,null,null,"70% of Conditioned spaces of regularly occupied areas",4,4]
[null,null,null,"75% of Conditioned spaces of regularly occupied areas",5,5]
[null,null,null,"95% of Conditioned spaces of regularly occupied areas","Exemplary performance"]
["Energy Efficient Lighting","Lighting Power Density",4," 20% of Lighting Power Density",1,1]
[null,null,null," 25% of Lighting Power Density",2,2]
[null,null,null," 30% of Lighting Power Density","Exemplary performance"]
[null,"Sensors ",null,"75% of regularly occupied areas",1,1]
[null,null,null,"95% of non regulalry occupied areas",1,1]
[null,null,null,"95% of the total carpet area","Exemplary performance"]
["Energy Efficient Appliances",null,1,"Appliance-1",1,1]
[null,null,null,"Appliance-2"]
[null,null,null,"Appliance-3"]
["Energy Metering & Management","Sub-Metering",4,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
[null,"Building Management System",null,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
["On-site /Off-site Renewable Energy\n","On-site renewable energy systems",6,"2% of the total energy consumption",1,1]
[null,null,null,"4% of the total energy consumption",2,2]
[null,null,null,"6% of the total energy consumption",3,3]
[null,null,null,"8% of the total energy consumption",4,4]
[null,null,null,"10% of the total energy consumption",5,5]
[null,null,null,"12% of the total energy consumption",6,6]
[null,null,null,"14% of the total energy consumption","Exemplary performance"]
[null,"(Off-site renewable energy systems)",null,"5% of the total energy consumption",1,1]
[null,null,null,"10% of the total energy consumption",2,2]
[null,null,null,"15% of the total energy consumption",3,3]
[null,null,null,"20% of the total energy consumption",4,4]
[null,null,null,"25% of the total energy consumption",5,5]
[null,null,null,"30% of the total energy consumption",6,6]
[null,null,null,"35% of the total energy consumption","Exemplary performance"]
["Total Achievable Points",null,null,null,22,22]
[]
["Interior Materials"]
["Segregation of Waste, Post Occupancy",null,"MR",null,"Required","Required"]
["Green Procurement Policy",null,"MR",null,"Required","Required"]
["Waste Management (During Installation) ",null,2,"Percentage of Waste reused / sold / donated\n(by weight/ volume) : 40% ",1,"NA"]
[null,null,null,"Percentage of Waste reused / sold / donated\n(by weight/ volume) : 60%",2]
[null,null,null,"Percentage of Waste reused / sold / donated\n(by weight/ volume) : 80%","Exemplary \nperformance"]
["Local Materials",null,2,"40% of Local Materials ",1,"NA"]
[null,null,null,"50% of Local Materials ",2]
[null,null,null,"60 %of Local Materials ","Exemplary \nperformance"]
["Recycled Content Materials ",null,2,"≥ 10% of Materials with Recycled Content",1,"NA"]
[null,null,null,"≥ 15% of Materials with Recycled Content",2]
[null,null,null,"≥ 30% of Materials with Recycled Content","Exemplary \nperformance"]
["Ecolabelled products","Option1 :  Ecolabelled products",2,"1 Product(s)",1,"NA"]
[null,null,null,"2 Product(s)"]
[null,null,null,"3 Product(s)",2]
[null,null,null,"4 Product(s)"]
[null,null,null,"6 Product(s)","Exemplary \nperformance"]
[null,"Option 2 : atleast 10% of the total cost of products\n & materials used for construction",null,"10% of the total cost",1]
[null,null,null,"15% of the total cost",2]
[null,null,null,"20% of the total cost","Exemplary \nperformance"]
["Salvaged Materials ",null,2,"≥ 2.5% of Salvaged Materials ",1,"NA"]
[null,null,null," ≥ 5% of Salvaged Materials ",2]
[null,null,null," ≥ 7.5% of Salvaged Materials ","Exemplary \nperformance"]
["Reuse of materials",null,2,"≥ 2.5%  of Reused Materials ",1,"NA"]
[null,null,null," ≥ 5% of Reused Materials ",2]
[null,null,null," ≥ 7.5% of Reused Materials ","Exemplary \nperformance"]
["Eco Friendly Wood Based Materials ",null,4,"30% of cost of alternate wood products",1,"NA"]
[null,null,null,"35% of cost of alternate wood products",2]
[null,null,null,"40% of cost of alternate wood products",3]
[null,null,null,"45% of cost of alternate wood products",4]
[null,null,null,"50% of cost of alternate wood products","Exemplary \nperformance"]
["Eco-certified Interior Furniture",null,4,"10% of total furniture cost",1,1]
[null,null,null,"20% of total furniture cost",2,2]
[null,null,null,"30% of total furniture cost",3,3]
[null,null,null,"40% of total furniture cost",4,4]
[null,null,null,"50% of total furniture cost","Exemplary performance"]
["Purchase of Green Consumables",null,2,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
["Total Achievable Points",null,null,null,{"$f":"SUM(C87:C121)","v":22},6]
[]
["Indoor Environment"]
["Tobacco Smoke Pollution ",null,"MR",null,"Required","Required"]
["Fresh Air Ventilation\nOption 1: Mechanical ventilation",null,"MR"," Design as per baseline","Required","Required"]
["Fresh Air Ventilation\nOption 2 : Natural Ventilation","Regularly occupied area <150 sq m",null,0.04]
[null,"Regularly occupied area ≥150 sq.m",null,0.06]
["Enhanced Fresh Air Ventilation\nOption 1: Mechanical ventilation",null,2,"≥ 5% more than baseline criteria ",1,1]
[null,null,null,"≥ 10% more than baseline criteria ",2,2]
["Enchanced Fresh Air Ventilation\nOption 2 : Natural Ventilation","Regularly occupied area <150 sq m",null,0.06,1,1]
[null,null,null,0.08,2,2]
[null,"Regularly occupied area ≥150 sq.m",null,0.08,1,1]
[null,null,null,0.1,2,2]
["Daylighting ",null,4,"≥ 25%  of Regularly occupied Spaces with Daylight ",1,1]
[null,null,null," ≥ 50%  of Regularly occupied Spaces with Daylight ",2,2]
[null,null,null," ≥ 75%  of Regularly occupied Spaces with Daylight ",3,3]
[null,null,null," ≥ 95%  of Regularly occupied Spaces with Daylight ",4,4]
["Thermal Comfort",null,1,"Temperature of 26 ± 2 deg C",1,1]
[null,null,null,"Relative Humidity of 50 – 60 %"]
["Ergonomic Design",null,2,"Measure-1",1,1]
[null,null,null,"Measure-2",2,2]
["Air Quality Monitoring",null,3,"Daily Monitoring ",1,1]
[null,null,null,"Daily and Quarterly Monitoring ",2,2]
[null,null,null,"Display of IAQ parameters",1,1]
[null,null,null,"Enhanced Daily and Quarterly Monitoring","Exemplary performance"]
["Indoor Plants",null,2,"50% of regularly occupied area",1,1]
[null,null,null,"95% of regularly occupied area",2,2]
["Material Acoustic performance",null,3,"Ceiling Systems",1,"NA"]
[null,null,null,"Flooring Systems ",1]
[null,null,null,"Office Type \n          1. Enclosed offices \n          2. Open office ",1]
["Outdoor Views",null,4,"≥ 40% of regularly occupied spaces having outdoor views",1,1]
[null,null,null,"≥ 50% of regularly occupied spaces having outdoor views",2,2]
[null,null,null,"≥ 60% of regularly occupied spaces having outdoor views",3,3]
[null,null,null," ≥ 70% of regularly occupied spaces having outdoor views",4,4]
[null,null,null," ≥ 80% of regularly occupied spaces having outdoor views","Exemplary performance"]
["Minimise Indoor Pollutant Contamination",null,1,"Measure-1",1,1]
[null,null,null,"Measure-2"]
["Low-Emitting Materials",null,4,"Paints & Coatings",1,"NA"]
[null,null,null,"Adhesives",1]
[null,null,null,"Flooring Systems",1]
[null,null,null,"Composite Wood",1]
["Indoor Air Quality Management, During Installation",null,1,"Measure-1",1,"NA"]
[null,null,null,"Measure-2"]
["Interior Flush out",null,1,"Yes / No",1,"NA"]
["Occupant Well-being Facilities",null,2,"5% of Recreational spaces For Building occupants ",1,1]
[null,null,null,"10% of Recreational spaces For Building occupants ",2,2]
["Dedicated Dining Spaces",null,1,"Yes / No",1,1]
["Total Achievable Points",null,null,null,{"$f":"SUM(C129:C168)","v":31},22]
[]
["Innovation in Interior Design"]
["Innovation in Interior Design",null,1,"Carbon emissions* or Innovation or Exemplary performance ",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplary performance",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplary performance",1,1]
["Innovation in Interior Design",null,1,"Innovation or Exemplary performance",1,1]
["IGBC Accredited Professional",null,1,"Yes / No",1,1]
["Total Achievable Points",null,null,null,5,5]
[]
["(* Perform project life cycle analysis (LCA) to estimate embioded carbon as per standard indicated in the Green Interior Manual ver 2)"]
[]
[null,"Certification Level","New Interiors Points","Existing Interiors Points"]
[null,"Certified","50-59","37-44"]
[null,"Silver","60-69","45-52"]
[null,"Gold","70-79","53-60"]
[null,"Platinum","80-100","61-75"]

{"sheet":"Overview","index":2,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,5,0,12],[35,0,36,1],[42,0,43,1],[52,0,53,1],[61,0,62,1],[5,0,6,1],[12,0,13,1],[16,0,17,1],[25,0,26,1],[28,0,29,1]]}
["Project Details"]
["Project ID","IGBCGI250235"]
["Project Name","Infoedge, Runwal R Square, Mumbai"]
["Project Category","New Project"]
["Rating System","GBC Green Interiors Rating System"]
[]
[]
["Certification Deatils"]
["Category","New Project"]
["Version","GBC Green Interiors Rating System"]
["Total Built-up area (sq ft)",1634]
["No. of Floors",1]
[]
[]
["Membership Deatils"]
["Is the parent organization an IGBC Member?","NO"]
[]
[]
["Project Details"]
["Organization/ Individual Name","Info edge India Ltd. "]
["Address Line 1","902, 9th Floor, Runwal R Square, Andheri - Kurla Rd"]
["City","Bhim Nagar, Andheri East, Mumbai"]
["State / UT","MH"]
["Country","India "]
["Pincode",400053]
[]
[]
["Completion Status","Completed "]
[]
[]
["Credit Summary"]
[40]
["Total Credits"]
["Credits Attempted"]
["Credits Not attempted"]
[]
[]
["Credit point summary"]
[]
["Total credit points"]
["Credit points attempted"]
["Credit points not Attempted"]
[]
[]
["Payment Details",35400]
["Registration Fee (INR/Rs)","Online"]
["Payment Type","CMS4915163431"]
["Demand Draft Number","ICICI Bank"]
["Bank","Preet Vihar, New Delhi "]
["Branch","28/2/2025"]
["Date",32400]
["Amount paid (INR/Rs)"]
[]
[]
["Certification Fee"]
["Payment Type"]
["Demand Draft Number"]
["Bank"]
["Branch"]
["Date"]
["Amount paid (INR/Rs)"]
[]
[]
["Project Deatils"]
["No. of Floors",1]
["Total Built-up area In sq.m",1634]

{"sheet":"Project Details","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Project Details"]
["Occupancy Type (Tenant/Owner) \n","Tenant"]
["Total Lease Area",17534]
["Total Carpet Area (sq ft)",{"$f":"SUM('Cal _ Area Statement Circulatio'!E4:E19)","v":9468}]
["Total carpet area (sq m)",{"$f":"B4/10.764","v":879.59866220735796}]
["Regularly Occupied Area (sq ft)",{"$f":"SUMIF('Cal _ Area Statement Circulatio'!C4:C19, \"Regularly occupied space\", 'Cal _ Area Statement Circulatio'!E4:E19)","v":8855}]
["Area of Conditioned Spaces (sq ft)",{"$f":"SUMIF('Cal _ Area Statement Circulatio'!D4:D19, \"Air conditioned space\", 'Cal _ Area Statement Circulatio'!E4:E19)","v":4028}]
["Area of Non Conditioned Spaces (sq ft)",{"$f":"SUMIF('Cal _ Area Statement Circulatio'!D4:D19, \"Non air conditioned space\", 'Cal _ Area Statement Circulatio'!E4:E19)","v":5440}]
["Non regularly occupied spaces (sq ft)",{"$f":"SUMIF('Cal _ Area Statement Circulatio'!C4:C19, \"Non regularly occupied space\", 'Cal _ Area Statement Circulatio'!E4:E19)","v":613}]
["Design occupancy (No. of  occupants as per the seating capacity indicated in floor plan)",178]
["Transient occupancy (visitors and part-time employees)",4]
["Permanent occupancy ( employee, housekeeping staff and security staff)",{"$f":"B10+6","v":184}]
["Energy Details"]

{"sheet":"Cal _ Area Statement Circulatio","index":4,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,10,6,11],[24,1,24,7],[29,1,29,7],[21,1,21,6],[20,1,20,7],[25,1,25,7],[23,1,23,6],[20,10,20,15],[22,1,22,6],[26,1,26,6],[27,1,27,6],[31,1,31,6],[28,1,28,6],[33,1,33,6],[32,1,32,6],[37,1,37,7],[30,1,30,7]]}
[]
[]
[null,"Description of spaces (e.g. core workstation, meeting room, electrical room, restroom etc)","Regularly / non regularly occupied spaces","Air conditioned / Non - Air conditioned spaces","Total carpet area \n(sq ft)","Total Area of Furniture \n(sq ft)","Total Area of Storage \n(sq ft)","Circulation space \n(sq ft)","Area covered by daylight / occupancy / motion sensors\n(sq ft )",null,null,null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) "]
[null,"Workstation Area","Regularly occupied space","Non air conditioned space",{"$f":"3963+1363","v":5326},1868,4,{"$f":"E4-(F4+G4)","v":3454}]
[null,"Workstation Area-JS","Regularly occupied space","Air conditioned space",490,203,0,287]
[null,"Café Area","Regularly occupied space","Air conditioned space",692,320,22,350]
[null,"Hand wash Area","Non regularly occupied space","Non air conditioned space",67,0,46,21,null,null,"Setup file"]
[null,"Dish wash Area","Non regularly occupied space","Non air conditioned space",47,0,37,10]
[null,"Meetings Room Area","Regularly occupied space","Air conditioned space",742,400,0,342,{"$f":"E9","v":742},null,"Air conditioned space","Regularly occupied space"]
[null,"Cabins Area","Regularly occupied space","Air conditioned space",325,170,0,155,{"$f":"E10","v":325},null,"Non air conditioned space","Non regularly occupied space"]
[null,"UPS Room Area","Non regularly occupied space","Air conditioned space",95,24,18,53]
[null,"AHU Room Area","Non regularly occupied space","Air conditioned space",279,0,0,279]
[null,"Reprographic/ Store Area","Non regularly occupied space","Air conditioned space",43,10,6,27,{"$f":"E13","v":43}]
[null,"Reception Area","Regularly occupied space","Air conditioned space",319,219,0,100]
[null,"Phone Booths Area","Regularly occupied space","Air conditioned space",260,87,0,173,{"$f":"E15","v":260}]
[null,"Lounge Areas","Regularly occupied space","Air conditioned space",177,{"$f":"E16-140","v":37},0,140]
[null,"Server Room","Non regularly occupied space","Air conditioned space",82,6,0,76]
[null,"Board Room","Regularly occupied space","Air conditioned space",524,243,7,274,{"$f":"H18","v":274}]
[]
[]
[null,"Optimise Circulation Spaces"]
[null,"Total carpet area (sq ft)",null,null,null,null,null,{"$f":"SUM(E4:E19)","v":9468}]
[null,"Total circulation area (sq ft)",null,null,null,null,null,{"$f":"SUM(H4:H19)","v":5741}]
[null,"Percentage of circulation area",null,null,null,null,null,{"$f":"H23/H22","v":0.60635825940008448}]
[]
[null,"Energy Efficient Lighting (Sensors Regularly occupied spaces )"]
[null,"Total regularly occupied area  (sq ft)",null,null,null,null,null,{"$f":"SUMIF(C4:C19, \"Regularly occupied space\", E4:E19)","v":8855}]
[null,"Total regularly occupied area covered by sensors (sq ft)",null,null,null,null,null,{"$f":"SUMIF(C4:C19, \"Regularly occupied space\", I4:I19)","v":1601}]
[null,"Percentage of regularly occupied spaces covered by sensors",null,null,null,null,null,{"$f":"H28/H27","v":0.18080180688876341}]
[]
[null,"Energy Efficient Lighting (Sensors Non - Regularly occupied spaces )"]
[null,"Total non regularly occupied area (sq ft)",null,null,null,null,null,{"$f":"SUMIF(C4:C19, \"Non regularly occupied space\", E4:E19)","v":613}]
[null,"Total non regularly occupied area covered by sensors (sq ft)",null,null,null,null,null,{"$f":"SUMIF(C4:C19, \"Non regularly occupied space\", I4:I19)","v":43}]
[null,"Percentage of non regularly occupied spaces covered by sensors",null,null,null,null,null,{"$f":"H33/H32","v":7.01468189233279E-2}]
[]
[]
[]
[null,"1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1 & V2\n\n2. Provide multiple addition of rows for multiple input field \n\n3. Change name of sheet to \"Cal _ Area Statement/Circulation/Sensors\""]

{"sheet":"Water efficient plumbing fixtur","index":5,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,0,4,0],[25,11,25,16],[26,11,26,16],[30,4,30,8],[31,4,31,8],[27,9,27,10],[31,9,31,10],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[24,4,24,8],[13,8,14,8],[13,9,13,11],[13,12,13,14],[1,4,1,7],[7,4,7,6],[10,4,10,6],[12,4,12,14],[8,4,8,6],[9,4,9,6],[13,4,14,4],[13,5,14,5],[13,6,14,7],[3,9,3,11],[5,9,5,11]]}
[]
[null,null,null,null,"FTE CALCULATION"]
[null,null,null,null,null,"No's","Time spent \n(hr)","FTE"]
[null,"All the cells filled with yellow, the values to be entered by project team ",null,null,"Permanent Occupancy\n(employees and house-keeping staff)",{"$f":"'Project Details'!B12","v":184},9,{"$f":"((F4*G4)/8)","v":207}]
[null,null,null,null,"Part-time employees",0,0,{"$f":"((F5*G5)/8)","v":0}]
[null,"All the cells filled with pink, the values to be hyperlinked from project details ",null,null,"Transient Occupancy (Visitors )\n(assuming a visitor spends 20 mins in the building , therefore 20/60 = 0.3 hrs)",{"$f":"'Project Details'!B11","v":4},1,{"$f":"((F6*G6)/8)","v":0.5}]
[]
[null,null,null,null,"Total FTE",null,null,{"$f":"SUM(H4:H6)","v":207.5}]
[null,null,null,null,"Total Male Occupants",null,null,{"$f":"H8/2","v":103.75}]
[null,null,null,null,"Total Female Occupants",null,null,{"$f":"H8/2","v":103.75}]
[]
[]
[null,null,null,null,"WATER REDUCTION CALCULATION\n"]
[null,null,null,null,"Fixture type","Duration","Estimated Daily Uses \nper FTE",null,"Total FTE","Baseline",null,null,"Proposed"]
[null,null,null,null,null,null,null,null,null,"Maximum Flow Rate/ Consumption","Unit","Water Consumption \n(per day)","Maximum Flow Rate/ Consumption","Unit","Water Consumption \n(per day)"]
[null,null,null,null,"Water Closet (Full flush)",1,1,"Male",{"$f":"H9","v":103.75},6,"LPF",{"$f":"(F16*G16*I16*J16)","v":622.5},4,"LPF",{"$f":"(F16*G16*I16*M16)","v":415}]
[null,null,null,null,null,1,1,"Female",{"$f":"H10","v":103.75},6,"LPF",{"$f":"(F17*G17*I17*J17)","v":622.5},4,"LPF",{"$f":"(F17*G17*I17*M17)","v":415}]
[null,null,null,null,"Water Closet (Half flush)",1,2,"Female",{"$f":"H10","v":103.75},3,"LPF",622.5,2,"LPF",415]
[null,null,null,null,"Urinals",1,2,"Male",{"$f":"H9","v":103.75},4,"LPF",{"$f":"(F19*G19*I19*J19)","v":830},1.5,"LPF",311.25]
[null,null,null,null,"Kitchen/Pantry Faucet",0.25,4,"Both ",{"$f":"H8","v":207.5},6,"LPM",1245,3,"LPM",622.5]
[null,null,null,null,"Faucets/Taps",0.25,4,"Both ",{"$f":"H8","v":207.5},6,"LPM",1245,4.5,"LPM",933.75]
[null,null,null,null,"Health Faucet",0.25,1,"Both ",{"$f":"H8","v":207.5},6,"LPM",311.25,3,"LPM",155.625]
[null,null,null,null,"Showerhead/ Handheld Spray",8,0.1,"Both ",{"$f":"H8","v":207.5},10,"LPM",1660,0,"LPM",0]
[]
[null,null,null,null,null,null,null,null,null,"Base case\n\nTo be added","Design case\n\nTo be added"]
[null,null,null,null,"Daily volume from flush fixtures (Black water)",null,null,null,null,{"$f":"SUM(L16,L17,L18,L19,L22)","v":3008.75},{"$f":"SUM(O16,O17,O18,O19,O22)","v":1711.875},"Black water includes water from WC, urinal, health faucet"]
[null,null,null,null,"Daily volume from flow fixtures (Grey water)",null,null,null,null,{"$f":"SUM(L23,L20,L21)","v":4150},{"$f":"SUM(O23,O21,O20)","v":1556.25},"Grey water includes water from pantry faucet, faucet, shower head"]
[null,null,null,null,"Annual Working Days",null,null,null,null,2]
[null,null,null,null,"Annual volume from flush fixtures (Black water)",null,null,null,null,{"$f":"J26*J28","v":6017.5},{"$f":"K26*J28","v":3423.75}]
[null,null,null,null,"Annual volume from flow fixtures (Grey water)",null,null,null,null,{"$f":"J27*J28","v":8300},{"$f":"K27*J28","v":3112.5}]
[null,null,null,null,"Annual volume from flush & flow fixtures",null,null,null,null,{"$f":"SUM(J29:J30)","v":14317.5},{"$f":"SUM(K29:K30)","v":6536.25}]
[null,null,null,null,"Percentage Savings (%)",null,null,null,null,{"$f":"(J31-K31)/J31","v":0.54347826086956519}]

{"sheet":"Conditioned space","index":6,"n_rows":68,"n_cols":28,"rows_kept":68,"cut":false,"hidden":false,"merged":[[21,23,21,24],[21,26,21,27],[38,0,38,4],[0,3,0,4],[0,7,0,8],[0,10,0,13],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,15,19,16],[21,15,21,16],[21,18,21,21],[43,0,43,4],[42,0,42,4],[39,0,39,3],[40,0,40,3],[51,1,51,5],[48,1,48,5],[44,5,44,6],[41,0,41,3],[65,18,67,18],[44,0,44,3],[49,1,49,5],[50,1,50,5],[52,1,52,5]]}
[null,null,null,"Actual Efficiency",null,null,null,"Baseline Values",null,null,"Savings calculation"]
["Type of air conditioning system installed","Qty","Capacity (kWr)","Unit","Value","Refrigerant Type","Refrigerant GWP","Unit","Value","Meets the\nCredit Compliance","Total Cooling capacity","Hours of Operation","Days of Operations ","Actual Annual Energy consumption (kWh)"]
["Unitary Split AC",2,3.5,"BEE Star Rating",4,"R-32",{"$f":"VLOOKUP(F3,$X$26:$Y$46,2,FALSE)","v":675},{"$f":"D3","v":"BEE Star Rating"},{"$f":"IF(AND(D3=\"BEE Star Rating\",A3=\"Unitary Split AC\"),U26,0)","v":3},{"$f":"IF(E3>I3,\"True\",\"False\")","v":"True"},{"$f":"C3*B3","v":7},12,250,{"$f":"IF(AND(D3=AA25,E3=AA37),K3/AB37*L3*M3,0)","v":5675.6756756756758}]
["VRV/VRF",2,13.4,"EER",3.3,"R-32",{"$f":"VLOOKUP(F4,$X$26:$Y$46,2,FALSE)","v":675},{"$f":"D4","v":"EER"},{"$f":"IF(AND(D4=\"EER\",A4=\"VRV/VRF\",C4<40),U66,0)","v":3.28},{"$f":"IF(E4>I4,\"True\",\"False\")","v":"True"},{"$f":"B4*C4","v":26.8},12,250,{"$f":"K4/E4*L4*M4","v":24363.636363636364}]
["Water Cooled Chiller ",3,13.4,"COP",3.3,"R-32",{"$f":"VLOOKUP(F5,$X$26:$Y$46,2,FALSE)","v":675},{"$f":"D5","v":"COP"},{"$f":"IF(AND(A5=\"Water Cooled Chiller\",D5=\"COP\",C5<260),U45,0)","v":0},{"$f":"IF(E5>I5,\"True\",\"False\")","v":"True"},{"$f":"B5*C5","v":40.200000000000003},12,250,{"$f":"K5/E5*L5*M5","v":36545.454545454544}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(F6,$X$26:$Y$46,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"D6","v":0},0,{"$f":"IF(E6>I6,\"True\",\"False\")","v":"False"}]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(F10,$X$26:$Y$46,2,FALSE)","v":{"$error":"#N/A"}},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[null,null,null,null,null,null,{"$error":"#N/A"},0,0,"False"]
[]
[]
[]
[]
["Air Conditioned Spaces","Type of air conditioner","Scope of air conditioner","Area of the space\n(sq ft)","Area Meeting the credit compliance","Refrigerant GWP",null,null,null,null,null,null,null,null,null,"Type of Air Conditioning System "]
[]
[{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B4:B19,'Cal _ Area Statement Circulatio'!D4:D19 = \"Air conditioned space\")","v":"Workstation Area-JS"},"Unitary Split AC","client",{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E4:E19,'Cal _ Area Statement Circulatio'!D4:D19 = \"Air conditioned space\")","v":490},{"$f":"IF(AND(B22=A3,J3=\"True\"),D22,0)","v":490},{"$f":"VLOOKUP(B22,$A$3:$G$5,7,FALSE)","v":675},null,null,null,null,null,null,null,null,null,"Units check",null,null,"Baseline values",null,null,null,null,"Refrigerant type & GWP",null,null,"Savings Calculation"]
["Café Area","VRV/VRF","client",692,{"$f":"IF(AND(B23=A4,J4=\"True\"),D23,0)","v":692},{"$f":"VLOOKUP(B23,$A$3:$G$5,7,FALSE)","v":675}]
["Meetings Room Area","Water Cooled Chiller ","client",742,{"$f":"IF(AND(B24=A5,J5=\"True\"),D24,0)","v":742},{"$f":"VLOOKUP(B24,$A$3:$G$5,7,FALSE)","v":675}]
["Cabins Area","Water Cooled Chiller ","client",325,{"$f":"IF(AND(B25=A6,J6=\"True\"),D25,0)","v":0},{"$f":"VLOOKUP(B25,$A$3:$G$5,7,FALSE)","v":675},null,null,null,null,null,null,null,null,null,"Type","Unit",null,"Type","Cooling Capacity (kWr)","Baseline Value","Unit",null,"Refrigerant Name","GWP (AR4)",null,"BEE Star Rating","ISEER Values"]
["UPS Room Area","Water Cooled Chiller ","client",95,0,{"$f":"VLOOKUP(B26,$A$3:$G$5,7,FALSE)","v":675},null,null,null,null,null,null,null,null,null,"Unitary Split AC","BEE Star Rating",null,"Unitary Split AC","≤ 10.5",3,"BEE Star Rating",null,"R-22",1810,null,3,3.5]
["AHU Room Area",null,null,279]
["Reprographic/ Store Area",null,null,43]
["Reception Area",null,null,319]
["Phone Booths Area",null,null,260]
["Lounge Areas",null,null,177]
["Server Room",null,null,82]
["Board Room",null,null,524]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISEER",null,null,"> 10.5",2.8,"EER / ISEER",null,"R-134a",1430,null,4,3.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unitary Cassette AC","≤ 10.5",3,"BEE Star Rating",null,"R-410A",2088,null,5,4.5]
["Efficient Space Conditioning (Conditioned Spaces)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 10.5",2.8,"EER / ISEER",null,"R-407C",1774]
["Total air conditioned area",null,null,null,{"$f":"SUM(_xlfn.ANCHORARRAY(D22))","v":4028},null,null,null,null,null,null,null,null,null,null,"Unitary Cassette Unit","BEE Star Rating",null,"Unitary Packaged Air conditioning","≤ 10.5",3,"BEE Star Rating",null,"R-32",675]
["Total efficiently air conditioned area",null,null,null,{"$f":"SUM(E22:E26)","v":1924},null,null,null,null,null,null,null,null,null,null,null,"ISEER",null,null,"> 10.5",2.8,"EER / ISEER",null,"R-1234yf",4]
["Percentage of area efficiently air conditioned",null,null,null,{"$f":"E41/E40","v":0.47765640516385305},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-1234ze",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-513A",631]
["Enhanced Eco-friendly Refrigerants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VRV/VRF","EER",null,"Type","Cooling Capacity (kWr)","Baseline Value COP","Baseline Value IPLV",null,"R-290",3]
["Meeting the GWP Credit Requirement ",null,null,null,{"$f":"IF(SUMIFS(_xlfn.ANCHORARRAY(D22),F22:F26, \"<1000\") >= 0.95 * SUM(_xlfn.ANCHORARRAY(D22)), \"For 2 points\",\n IF(SUMIFS(_xlfn.ANCHORARRAY(D22), F22:F26, \"<1500\") >= 0.95 * SUM(_xlfn.ANCHORARRAY(D22)), \"For 1 point\", \"Not Meeting\"))","v":{"$error":"#VALUE!"}},"95% of total air conditioned area should meet threshold levels indicated to achieve points",null,null,null,null,null,null,null,null,null,null,"COP",null,"Water Cooled Chiller","<260",4.7,5.8,null,"R-744",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISEER",null,null,"≥260 &<530",4.9000000000000004,5.9,null,"R-123",77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Cooled Chiller ","COP",null,null,"≥530 &<1050",5.4,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV",null,null,"≥1050 & ≥ 1580",5.8,6.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Cooled Scroll Chiller","COP",null,null,"≥ 1580",6.3,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV"]
[null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Cooled Rotary Screw Chiller","COP",null,"Water Cooled Scroll Chiller","< 264",4.2,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV",null,null,"≥ 264 and < 526",4.6500000000000004,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Cooled Chiller","EER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,"Water Cooled Rotary Screw Chiller","< 264",4.2,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV",null,null,"≥ 264 and < 526",4.6500000000000004,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Cooled Scroll Chiller","COP",null,null,"≥ 526 and < 1055",5,5.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unitary Packaged Air Conditioning","BEE Star Rating",null,"Air Cooled Chiller","<260",2.8,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER",null,null,"≥260",3,3.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,"Air Cooled Scroll Chiller","< 264",2.9,3.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Others","BEE Star Rating",null,null,"≥ 264",3,3.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISEER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EER",null,"VRV/VRF","Cooling Category (kWr)","EER (W/W)","IEER (W/W)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IPLV",null,null,"< 40",3.28,4.3600000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Others",null,null,"≥ 40 and < 70",3.26,4.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 70",3.02,4.07]

{"sheet":"Cal _ Natural Ventilation","index":7,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,3,18],[0,14,0,18],[1,14,1,18],[2,14,2,18],[4,14,4,18],[31,1,31,5],[32,1,32,5],[35,1,35,5],[33,1,33,6],[36,1,36,5],[34,1,34,6],[24,1,24,5],[25,1,25,5],[26,1,26,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,7,0,9],[18,1,18,5],[19,1,19,5],[0,6,1,6],[29,1,29,6],[20,1,20,6],[22,1,22,5],[21,1,21,6],[27,1,27,5],[30,1,30,5],[0,10,0,11],[28,1,28,6],[0,5,1,5],[23,1,23,5]]}
["S.No","Regularly occupied spaces (eg. Core workstation, meeting room, cabin etc) ","Carpet area of regularly occupied space (sq m) \n\nFormula to convert sq ft to sq m\n\nSquare feet / 10.764","Openable Window Area- Towards Exterior (sq m)\n","Openable Door Area -Towards Exterior (sq m)\n\n","Total Opening Area (sq m)\n\n","% of opening area to total carpet area (Designed)","Fresh Air Natural Ventilation",null,null,"CO2  Monitoring"]
[null,null,null,null,null,null,null,"Meets Mandatory (True/False)","Meets Enhanced for 1 point (Yes/No)","Meets Enhanced for 2 point (Yes/No)","Meets credit compliance for 1 point (Yes/No)","Meets Enhanced for 2 point (Yes/No)"]
[1,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B4:B19,('Cal _ Area Statement Circulatio'!C4:C19=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D4:D19=\"Non air conditioned space\"))","v":"Workstation Area"},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E4:E19,('Cal _ Area Statement Circulatio'!C4:C19=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D4:D19=\"Non air conditioned space\"))/10.764","v":494.79747305834263},111,1,{"$f":"SUM(D3:E3)","v":112},{"$f":"F3/C3","v":0.2263552384528727},{"$f":"IF(AND(C3<=150, G3>=0.04), TRUE, IF(AND(C3>150, G3>=0.06), TRUE, FALSE))","v":true},{"$f":"IF(AND(C3<=150, G3>=0.06), TRUE, IF(AND(C3>150, G3>=0.08), TRUE, FALSE))","v":true},{"$f":"IF(AND(C3<=150, G3>=0.08), TRUE, IF(AND(C3>150, G3>=0.1), TRUE, FALSE))","v":true},{"$f":"IF(AND(C3<=150, G3>=0.1), TRUE, IF(AND(C3>150, G3>=0.12), TRUE, FALSE))","v":true},{"$f":"IF(AND(C3<=150, G3>=0.12), TRUE, IF(AND(C3>150, G3>=0.14), TRUE, FALSE))","v":true},null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) "]
[2,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B5:B20,('Cal _ Area Statement Circulatio'!C5:C20=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D5:D20=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E5:E20,('Cal _ Area Statement Circulatio'!C5:C20=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D5:D20=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},1,3,{"$f":"SUM(D4:E4)","v":4},{"$f":"F4/C4","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C4<=150, G4>=0.04), TRUE, IF(AND(C4>150, G4>=0.06), TRUE, FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C4<=150, G4>=0.06), TRUE, IF(AND(C4>150, G4>=0.08), TRUE, FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C4<=150, G4>=0.08), TRUE, IF(AND(C4>150, G4>=0.1), TRUE, FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C4<=150, G4>=0.1), TRUE, IF(AND(C4>150, G4>=0.12), TRUE, FALSE))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(C4<=150, G4>=0.12), TRUE, IF(AND(C4>150, G4>=0.14), TRUE, FALSE))","v":{"$error":"#VALUE!"}}]
[3,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B6:B21,('Cal _ Area Statement Circulatio'!C6:C21=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D6:D21=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E6:E21,('Cal _ Area Statement Circulatio'!C6:C21=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D6:D21=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},2,1,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B7:B22,('Cal _ Area Statement Circulatio'!C7:C22=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D7:D22=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E7:E22,('Cal _ Area Statement Circulatio'!C7:C22=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D7:D22=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},1,3,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B8:B23,('Cal _ Area Statement Circulatio'!C8:C23=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D8:D23=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E8:E23,('Cal _ Area Statement Circulatio'!C8:C23=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D8:D23=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B9:B24,('Cal _ Area Statement Circulatio'!C9:C24=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D9:D24=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E9:E24,('Cal _ Area Statement Circulatio'!C9:C24=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D9:D24=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B10:B25,('Cal _ Area Statement Circulatio'!C10:C25=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D10:D25=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E10:E25,('Cal _ Area Statement Circulatio'!C10:C25=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D10:D25=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B11:B26,('Cal _ Area Statement Circulatio'!C11:C26=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D11:D26=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E11:E26,('Cal _ Area Statement Circulatio'!C11:C26=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D11:D26=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B12:B27,('Cal _ Area Statement Circulatio'!C12:C27=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D12:D27=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E12:E27,('Cal _ Area Statement Circulatio'!C12:C27=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D12:D27=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B13:B28,('Cal _ Area Statement Circulatio'!C13:C28=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D13:D28=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E13:E28,('Cal _ Area Statement Circulatio'!C13:C28=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D13:D28=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B14:B29,('Cal _ Area Statement Circulatio'!C14:C29=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D14:D29=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E14:E29,('Cal _ Area Statement Circulatio'!C14:C29=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D14:D29=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B15:B30,('Cal _ Area Statement Circulatio'!C15:C30=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D15:D30=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E15:E30,('Cal _ Area Statement Circulatio'!C15:C30=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D15:D30=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B16:B31,('Cal _ Area Statement Circulatio'!C16:C31=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D16:D31=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E16:E31,('Cal _ Area Statement Circulatio'!C16:C31=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D16:D31=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B17:B32,('Cal _ Area Statement Circulatio'!C17:C32=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D17:D32=\"Non air conditioned space\"))","v":{"$error":"#VALUE!"}},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E17:E32,('Cal _ Area Statement Circulatio'!C17:C32=\"Regularly occupied space\")*('Cal _ Area Statement Circulatio'!D17:D32=\"Non air conditioned space\"))/10.764","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Total regularly occupied area with natural ventilation (sq m)\n",null,null,null,null,{"$f":"SUM(C3:C6)","v":{"$error":"#VALUE!"}}]
[null,"Minimum percentage of opening \n",null,null,null,null,{"$f":"MIN(G3:G6)","v":{"$error":"#VALUE!"}}]
[]
[null," Efficient space conditioning -  Non Air-conditioned spaces"]
[null,"Meets 5% opening for more than 90% of naturally ventilated  spaces for 1 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C2:C5)=0, \"No Data\", COUNTIFS(G2:G5, \">=5%\")/COUNTA(C2:C5) >= 0.9)","v":false}]
[null,"Meets 6% opening for more than 90% of naturally ventilated  spaces for 2 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C3:C6)=0, \"No Data\", COUNTIFS(G3:G6, \">=6%\")/COUNTA(C3:C6) >= 0.9)","v":false}]
[null,"Meets 7% opening for more than 90% of naturally ventilated  spaces for 3 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C3:C6)=0, \"No Data\", COUNTIFS(G3:G6, \">=7%\")/COUNTA(C3:C6) >= 0.9)","v":false}]
[null,"Meets 8% opening for more than 90% of naturally ventilated  spaces for 4 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C3:C6)=0, \"No Data\", COUNTIFS(G3:G6, \">=8%\")/COUNTA(C3:C6) >= 0.9)","v":false}]
[null,"Meets 9% opening for more than 90% of naturally ventilated  spaces for 5 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C3:C6)=0, \"No Data\", COUNTIFS(G3:G6, \">=9%\")/COUNTA(C3:C6) >= 0.9)","v":false}]
[null,"Meets 10% opening for more than 90% of naturally ventilated  spaces for 6 Point\"",null,null,null,null,{"$f":"IF(COUNTA(C3:C6)=0, \"No Data\", COUNTIFS(G3:G6, \">=10%\")/COUNTA(C3:C6) >= 0.9)","v":false}]
[]
[null,"Fresh Air Natural Ventilation"]
[null,"Meets the mandatory fresh-air requirement for all naturally ventilated spaces",null,null,null,null,{"$f":"AND(EXACT(H3:H6, \"TRUE\"))","v":{"$error":"#VALUE!"}}]
[null,"Meets the Enhanced fresh-air requirement for all naturally ventilated spaces for 1 Point",null,null,null,null,{"$f":"AND(EXACT(I3:I6, \"TRUE\"))","v":{"$error":"#VALUE!"}}]
[null,"Meets the Enhanced fresh-air requirement for all naturally ventilated spaces for 2 Point",null,null,null,null,{"$f":"AND(EXACT(J3:J6, \"TRUE\"))","v":{"$error":"#VALUE!"}}]
[]
[null,"CO2  Monitoring"]
[null,"Meets the CO2 monitoring credit compliance for all naturally ventilated spaces for 1 Point",null,null,null,null,{"$f":"AND(EXACT(K3:K6, \"TRUE\"))","v":{"$error":"#VALUE!"}}]
[null,"Meets the CO2 monitoring credit compliance for all naturally ventilated spaces for 2 Point",null,null,null,null,{"$f":"AND(EXACT(L3:L6, \"TRUE\"))","v":{"$error":"#VALUE!"}}]

{"sheet":"LPD Space function method","index":8,"n_rows":66,"n_cols":20,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,15,2,16],[1,19,1,23],[2,19,2,23],[3,19,3,23],[3,15,3,16],[37,10,38,10],[0,10,1,10],[0,9,1,9],[0,11,0,12],[27,0,27,8],[27,10,27,13],[26,0,26,8],[25,0,25,13],[0,13,1,13],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,5],[0,6,1,6],[0,7,1,7],[0,8,1,8]]}
["Description of spaces (e.g. core workstation, meeting room, electrical room, restroom etc)\n\n","Type of Space","Carpet Area (sq m)","Lighting fixtures",null,null,"Total wattage","Design LPD\n(W/sq m","Baseline LPD (W/sq.m)","LPD reduction (W/sq m)","Baseline\n(total Consumption)","Period Of Operations",null,"Annual Lighting Energy Consumption\n(kWh)"]
[null,null,null,"Type (decorative, linear, CFL etc)","No. of lighting fixture","Wattage of each lighting fixture",null,null,null,null,null,"Hours","Days"]
[{"$f":"'Cal _ Area Statement Circulatio'!B4","v":"Workstation Area"},"Conference/Meeting",{"$f":"'Cal _ Area Statement Circulatio'!E4/10.764","v":494.79747305834263},"LED linear lights",4,20,{"$f":"E3*F3","v":80},{"$f":"G3/C3","v":0.16168231318062334},{"$f":"VLOOKUP(B3,$P$6:$Q$66,2,FALSE)","v":11.5},{"$f":"(I3-H3)/I3","v":0.98594066841907624},{"$f":"I3*C3","v":5690.1709401709404},12,250,{"$f":"G3*L3*M3/1000","v":240},null,"Setup Table"]
[{"$f":"'Cal _ Area Statement Circulatio'!B5","v":"Workstation Area-JS"},"Conference/Meeting",{"$f":"'Cal _ Area Statement Circulatio'!E5/10.764","v":45.522110739502047},"LED troffer",4,15,{"$f":"E4*F4","v":60},{"$f":"G4/C4","v":1.3180408163265305},{"$f":"VLOOKUP(B4,$P$4:$Q$66,2,FALSE)","v":11.5},{"$f":"(I4-H4)/I4","v":0.88538775510204093},523.50427350427356,12,250,180,null,"LPD - Space function Method",null,null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) "]
[{"$f":"'Cal _ Area Statement Circulatio'!B6","v":"Café Area"},"Conference/Meeting",{"$f":"'Cal _ Area Statement Circulatio'!E6/10.764","v":64.288368636194733},"LED troffer",4,5,20,0.31109826589595369,11.5,0.97294797687861279,739.31623931623938,12,250,60,null,"Space Type","LPD (W/m²)"]
[{"$f":"'Cal _ Area Statement Circulatio'!B7","v":"Hand wash Area"},"Bar Lounge/Registration",{"$f":"'Cal _ Area Statement Circulatio'!E7/10.764","v":6.2244518766257899},"LED spot lights",2,6,12,1.9278805970149253,14.1,0.86327087964433158,87.764771460423631,12,250,36,null,"Restroom",7.7]
[{"$f":"'Cal _ Area Statement Circulatio'!B8","v":"Dish wash Area"},"Conference/Meeting",{"$f":"'Cal _ Area Statement Circulatio'!E8/10.764","v":4.3664065403195842},"LED linear lights",8,5,40,9.1608510638297869,11.5,0.20340425531914896,50.213675213675216,12,250,120,null,"Storage",6.8]
[{"$f":"'Cal _ Area Statement Circulatio'!B9","v":"Meetings Room Area"},"Corridor/Transition",{"$f":"'Cal _ Area Statement Circulatio'!E9/10.764","v":68.933481976960238},"LED decorative fixtures",1,2,2,{"$f":"G8/C8","v":2.9013477088948789E-2},7.1,0.99591359477620445,489.42772203641766,12,250,6,null,"Conference/Meeting",11.5]
[{"$f":"'Cal _ Area Statement Circulatio'!B10","v":"Cabins Area"},"Storage",{"$f":"'Cal _ Area Statement Circulatio'!E10/10.764","v":30.193236714975846},"LED linear lights",2,2,4,{"$f":"G9/C9","v":0.13247999999999999},6.8,0.98051764705882349,{"$f":"I9*C9","v":205.31400966183574},12,250,{"$f":"G9*L9*M9/1000","v":12},null,"Parking Bays (covered/ basement)",2.2000000000000002]
[{"$f":"'Cal _ Area Statement Circulatio'!B11","v":"UPS Room Area"},"Storage",{"$f":"'Cal _ Area Statement Circulatio'!E11/10.764","v":8.8257153474544783},"LED linear lights",2,2,{"$f":"E10*F10","v":4},{"$f":"G10/C10","v":0.45322105263157891},6.8,{"$f":"(I10-H10)/I10","v":0.93334984520123832},{"$f":"I10*C10","v":60.014864362690453},12,250,{"$f":"G10*L10*M10/1000","v":12},null,"Electrical/Mechanical",7.1]
[{"$f":"'Cal _ Area Statement Circulatio'!B12","v":"AHU Room Area"},"Electrical/Mechanical",{"$f":"'Cal _ Area Statement Circulatio'!E12/10.764","v":25.919732441471574},"LED spot lights",2,3,6,0.23148387096774192,7.1,0.96739663789186725,184.03010033444818,12,250,18,null,"Stairway",5.5]
[{"$f":"'Cal _ Area Statement Circulatio'!B13","v":"Reprographic/ Store Area"},"Electrical/Mechanical",{"$f":"'Cal _ Area Statement Circulatio'!E13/10.764","v":3.9947974730583429},"LED spot lights",2,2,4,1.0013023255813953,7.1,0.85897150343924,28.363062058714235,12,250,12,null,"Corridor/Transition",7.1]
[{"$f":"'Cal _ Area Statement Circulatio'!B14","v":"Reception Area"},"Restroom",{"$f":"'Cal _ Area Statement Circulatio'!E14/10.764","v":29.635823114083987},"LED spot lights",3,2,6,0.20245768025078367,7.7,0.97370679477262556,228.19583797844672,12,250,18,null,"Lobby",9.1]
[{"$f":"'Cal _ Area Statement Circulatio'!B15","v":"Phone Booths Area"},"Restroom",{"$f":"'Cal _ Area Statement Circulatio'!E15/10.764","v":24.154589371980677},"LED spot lights",4,2,8,0.33119999999999999,7.7,0.95698701298701294,185.99033816425123,12,250,24,null,"Parking Driveways (covered/ basement)",3]
[{"$f":"'Cal _ Area Statement Circulatio'!B19","v":0},"Corridor/Transition",{"$f":"'Cal _ Area Statement Circulatio'!E19/10.764","v":0},"LED troffer",2,2,4,{"$error":"#DIV/0!"},7.1,{"$error":"#DIV/0!"},0,12,250,12,null,"Workshop",17.100000000000001]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business (Open Plan)",10]
["Total carpet area (sq m)",null,null,null,null,null,null,null,null,{"$f":"SUM(C3:C25)","v":806.85618729096984},null,null,null,null,null,"Service/Repair",6.8]
["Percentage of LPD reduction ",null,null,null,null,null,null,null,null,{"$f":"MIN(J3:J25)","v":{"$error":"#DIV/0!"}},"Display the minimum percentage achieved\n\nThe percentage (column J) of all the individual spaces listed above should meet the baseline percentage for each point as indicated in point distribution sheet V1 & V2  ",null,null,null,null,"Emergency Treatment",13.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nurse Station",9.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patient Room",7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacy",10.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiology/Imaging",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency",22.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recovery",8.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laundry/Washing",7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical Supply",13.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corridor/Transition",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel Dining",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bar Lounge/Registration",14.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel Guest Rooms",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel Lobby",10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Dining",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motel Guest Rooms",7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mall Concourse",12.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Area",18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motion Picture Theatre",9.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Family Dining",10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bar Food Preparation",12.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bar Lounge/Dining",14.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Classroom/Lecture",13.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For classrooms",13.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laboratory",15.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Card File & Cataloguing",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stacks (Lib)",18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reading Area (Library)",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dressing Room",9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit Space – Convention centre",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seating Area - Gymnasium",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fitness Area - Gymnasium",13.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Museum - General Exhibition",16.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Museum - Restoration",18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seating Area – Performing Arts Theatre",22.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobby - Performing Arts",21.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seating Area – Convention area",6.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seating Religious Building",16.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Playing Area - Gymnasium",18.3]

{"sheet":"LPD Building area method","index":9,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,13,3,17],[0,13,0,17],[1,13,1,17],[2,13,2,17],[4,13,4,17],[34,0,34,4],[32,0,33,2],[0,2,0,4],[0,5,1,5],[1,8,1,9],[0,8,0,9],[29,0,29,2],[29,3,29,4],[30,0,30,4],[32,3,32,4],[33,3,33,4],[0,0,1,0],[0,1,1,1],[26,0,26,4],[27,0,27,4],[28,0,28,4]]}
["Description of spaces (e.g. core workstation, meeting room, electrical room, restroom etc)\n\n","Carpet Area (sq m)\n\nFormula to convert sq ft to sq m\n\nSquare feet / 10.764","Lighting fixtures",null,null,"Total wattage",null,null,"Lighting "]
[null,null,"Type (decorative, linear, CFL etc)","No. of lighting fixture","Wattage of each lighting fixture",null,null,null,"Building Area Method"]
[{"$f":"'Cal _ Area Statement Circulatio'!B4","v":"Workstation Area"},{"$f":"'Cal _ Area Statement Circulatio'!E4/10.764","v":494.79747305834263},{"$f":"'LPD Space function method'!D3","v":"LED linear lights"},4,20,{"$f":"D3*E3","v":80},null,null,"Typology","Baseline LPD",null,null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) "]
[{"$f":"'Cal _ Area Statement Circulatio'!B5","v":"Workstation Area-JS"},{"$f":"'Cal _ Area Statement Circulatio'!E5/10.764","v":45.522110739502047},{"$f":"'LPD Space function method'!D4","v":"LED troffer"},4,15,{"$f":"D4*E4","v":60},null,null,"Office Building",9.5]
[{"$f":"'Cal _ Area Statement Circulatio'!B6","v":"Café Area"},{"$f":"'Cal _ Area Statement Circulatio'!E6/10.764","v":64.288368636194733},{"$f":"'LPD Space function method'!D5","v":"LED troffer"},4,12,48,null,null,"Hospitals",9.6999999999999993]
[{"$f":"'Cal _ Area Statement Circulatio'!B7","v":"Hand wash Area"},{"$f":"'Cal _ Area Statement Circulatio'!E7/10.764","v":6.2244518766257899},{"$f":"'LPD Space function method'!D6","v":"LED spot lights"},2,6,12,null,null,"Hotels",9.5]
[{"$f":"'Cal _ Area Statement Circulatio'!B8","v":"Dish wash Area"},{"$f":"'Cal _ Area Statement Circulatio'!E8/10.764","v":4.3664065403195842},{"$f":"'LPD Space function method'!D7","v":"LED linear lights"},8,15,120,null,null,"Shopping Mall",14.1]
[{"$f":"'Cal _ Area Statement Circulatio'!B9","v":"Meetings Room Area"},{"$f":"'Cal _ Area Statement Circulatio'!E9/10.764","v":68.933481976960238},{"$f":"'LPD Space function method'!D8","v":"LED decorative fixtures"},1,30,30,null,null,"University and Schools",11.2]
[{"$f":"'Cal _ Area Statement Circulatio'!B10","v":"Cabins Area"},{"$f":"'Cal _ Area Statement Circulatio'!E10/10.764","v":30.193236714975846},{"$f":"'LPD Space function method'!D9","v":"LED linear lights"},2,30,60,null,null,"Library",12.2]
[{"$f":"'Cal _ Area Statement Circulatio'!B11","v":"UPS Room Area"},{"$f":"'Cal _ Area Statement Circulatio'!E11/10.764","v":8.8257153474544783},{"$f":"'LPD Space function method'!D10","v":"LED linear lights"},2,31,62,null,null,"Dining: bar lounge/ leisure",12.2]
[{"$f":"'Cal _ Area Statement Circulatio'!B12","v":"AHU Room Area"},{"$f":"'Cal _ Area Statement Circulatio'!E12/10.764","v":25.919732441471574},{"$f":"'LPD Space function method'!D11","v":"LED spot lights"},2,45,90,null,null,"Dining: cafeteria/ fast food",11.5]
[{"$f":"'Cal _ Area Statement Circulatio'!B13","v":"Reprographic/ Store Area"},{"$f":"'Cal _ Area Statement Circulatio'!E13/10.764","v":3.9947974730583429},{"$f":"'LPD Space function method'!D12","v":"LED spot lights"},2,25,50,null,null,"Dining: family",10.9]
[{"$f":"'Cal _ Area Statement Circulatio'!B14","v":"Reception Area"},{"$f":"'Cal _ Area Statement Circulatio'!E14/10.764","v":29.635823114083987},{"$f":"'LPD Space function method'!D13","v":"LED spot lights"},3,6,18,null,null,"Dormitory",9.1]
[{"$f":"'Cal _ Area Statement Circulatio'!B15","v":"Phone Booths Area"},{"$f":"'Cal _ Area Statement Circulatio'!E15/10.764","v":24.154589371980677},{"$f":"'LPD Space function method'!D14","v":"LED spot lights"},4,6,24,null,null,"Fire station",9.6999999999999993]
[{"$f":"'Cal _ Area Statement Circulatio'!B19","v":0},{"$f":"'Cal _ Area Statement Circulatio'!E19/10.764","v":0},{"$f":"'LPD Space function method'!D15","v":"LED troffer"},2,15,30,null,null,"Gymnasium",10]
[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,null,null,null,"Manufacturing facility",12]
["Total carpet area ( sq m)",null,null,null,null,{"$f":"SUM(B3:B15)","v":806.85618729096984},null,null,"Motion picture theatre",9.43]
["Total wattage ( W)",null,null,null,null,{"$f":"SUM(F3:F15)","v":684},null,null,"Museum",10.199999999999999]
["Design LPD (W/sq m)",null,null,null,null,{"$f":"F28/F27","v":0.8477347150259068},null,null,"Post office",10.5]
[" Baseline LPD (W/sq m)",null,null,"Office Building",null,{"$f":"VLOOKUP(D30,I4:J38,2,FALSE)","v":9.5},null,null,"Religious building",12]
[" Percentage of LPD reduction",null,null,null,null,{"$f":"(F30-F29)/F30","v":0.91076476683937835},null,null,"Sports arena",9.6999999999999993]
[null,null,null,null,null,null,null,null,"Transportation",9.1999999999999993]
["Period Of Operations",null,null,"Hours",null,12,null,null,"Warehouse",7.08]
[null,null,null,"Days",null,250,null,null,"Performing arts theatre",16.3]
["Annual Lighting Energy Consumption\n(kWh)",null,null,null,null,{"$f":"F28*F33*F34","v":2052000},null,null,"Police station",9.9]
[null,null,null,null,null,null,null,null,"Workshop",14.1]
[null,null,null,null,null,null,null,null,"Automotive facility",9]
[null,null,null,null,null,null,null,null,"Parking Garage",3]

{"sheet":"On-Site Renewable Energy","index":10,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,14,2],[17,1,17,4],[18,1,18,4]]}
[]
[null,"S. No.","Month","Energy Consumption (as per bills) in kWh","On-Site Renewable Energy Generation \n( kWh)","Off-Site Renewable Energy Procured \n( kWh)"]
[null,1,"2024-01-01",1000,900,100]
[null,2,"2024-02-01",1395,1168,1168]
[null,3,"2024-03-01",1400,1450,0]
[null,4,"2024-04-01",2535,1465,1243]
[null,5,"2024-05-01",2800,1500,600]
[null,6,"2024-06-01",2534,1465,700]
[null,7,"2024-07-01",2205,590,590]
[null,8,"2024-08-01",2700,915,915]
[null,9,"2024-09-01",2600,850,800]
[null,10,"2024-10-01",2610,124,124]
[null,11,"2024-11-01",1395,875,214]
[null,12,"2024-12-01",2670,900,300]
[null,"Total",null,{"$f":"SUM(D3:D14)","v":25844},{"$f":"SUM(E3:E14)","v":12202},{"$f":"SUM(F3:F14)","v":6754}]
[]
[]
[null,"Percentage of energy consumption met through on-site renewable energy ",null,null,null,{"$f":"E15/D15","v":0.4721405355208172}]
[null,"Percentage of energy consumption met through off-site renewable energy ",null,null,null,{"$f":"F15/D15","v":0.26133725429500076}]

{"sheet":"Ver 1_Master Material Sheet","index":11,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[[101,1,101,7],[96,1,96,3],[97,1,97,3],[94,4,94,6],[96,4,96,6],[97,4,97,6],[95,1,95,3],[95,4,95,6],[91,1,91,3],[91,4,91,6],[92,1,92,3],[93,1,93,3],[94,1,94,3],[92,4,92,6],[93,4,93,6]]}
["S.No","Category\n\nGive below options as drop down option","Sub - Category\n\nGive below options as drop down specific to the material selected in Category column","Material Quantity","Unit","Rates","Total material Cost","Manufacturer Details","Manufacturing Unit Location","Distance from Manufacturing Unit Location to project site \n(km)","Cost of Local Materials Procured","Salvaged Material (Y/N)","Salvaged Material Cost","Eco-Labelled Material (Y/N)","Recycled Content (%)","Recycled Material Cost","Rapidly Renewable wood (%)","Composite wood (%)\n","Eco-friendly/ Rapidly Renewable Wood Cost\n\n","Eco-Certified furniture (Y/N)","Eco -Certified furniture cost"]
[1,"Wall","AAC",null,null,null,{"$f":"D2*F2","v":0},null,null,null,{"$f":"G2","v":0},null,null,null,null,{"$f":"O2*G2","v":0},null,null,{"$f":"(Q2*G2)+(R2*G2)","v":0},null,{"$f":"IF(T2=\"Y\",G2,0)","v":0},null,null,null,"Wall","AAC"]
[null,null,"Flyash",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,{"$f":"IF(T3=\"Y\",G3,0)","v":0},null,null,null,null,"Flyash"]
[null,null,"Red brick",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Red brick"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[2,"Cement","Cement",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Cement","Cement"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[3,"Wood","Plywood",100,null,150,{"$f":"D8*F8","v":15000},null,"Noida",300,{"$f":"G8","v":15000},"N",0,"Y",0.2,{"$f":"O8*G8","v":3000},0.1,0.3,{"$f":"(Q8*G8)+(R8*G8)","v":6000},null,0,null,null,null,"Wood","Plywood"]
[null,null,"MDF",400,null,1000,{"$f":"D9*F9","v":400000},null,null,900,{"$f":"G9","v":400000},"N",0,"N",null,{"$f":"O9*G9","v":0},0,1,400000,null,0,null,null,null,null,"MDF"]
[null,null,"Laminate",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Laminate"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[4,"Flooring","Vitrified Tile",101,null,65,6565,null,null,56,{"$f":"G12","v":6565},"N",0,"N",null,0,null,null,0,null,0,null,null,null,"Flooring","Vitrified Tile"]
[null,null,"Granite",null,null,null,0,null,null,null,{"$f":"G13","v":0},null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Granite"]
[null,null,"Carpet",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Carpet"]
[null,null,"RCC",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"RCC"]
[null,null,"Raised flooring modular",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Raised flooring modular"]
[null,null,"Laminate",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Laminate"]
[null,null,"Tile",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Tile"]
[null,null,"Dado",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Dado"]
[null,null,"Wooden",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Wooden"]
[null,null,"VDF",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"VDF"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[5,"Paint","Emulsion",50,null,400,20000,null,null,467,{"$f":"G23","v":20000},"N",0,"Y",null,0,null,null,0,null,0,null,null,null,"Paint","Emulsion"]
[null,null,"Primer",30,null,400,12000,null,null,null,12000,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Primer"]
[null,null,"Enamel",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Enamel"]
[null,null,"Texture",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Texture"]
[null,null,"Putty",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Putty"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[6,"Furniture","Workstation",20,null,5000,100000,null,null,null,100000,null,null,null,null,0,null,null,0,"Y",100000,null,null,null,"Furniture","Workstation"]
[null,null,"Chair",20,null,2000,40000,null,null,null,40000,null,null,null,null,0,null,null,0,"N",0,null,null,null,null,"Chair"]
[null,null,"Storage unit",20,null,1500,30000,null,null,null,30000,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Storage unit"]
[null,null,"Meeting room table",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Meeting room table"]
[null,null,"Cabin table",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Cabin table"]
[null,null,"Loose furniture",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Loose furniture"]
[null,null,"Sofa",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Sofa"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[7,"Partition","Glass",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Partition","Glass"]
[null,null,"Wood",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Wood"]
[null,null,"Aluminium",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Aluminium"]
[null,null,"Gypsum with insulation",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Gypsum with insulation"]
[null,null,"Sliding & folding",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Sliding & folding"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[8,"Door","Wooded door",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Door","Wooded door"]
[null,null,"Glass door",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Glass door"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[9,"Wall panelling","Plywood",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Wall panelling","Plywood"]
[null,null,"Acoustic panel",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Acoustic panel"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[10,"Ceiling","Grid false ceiling",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Ceiling","Grid false ceiling"]
[null,null,"Gypsum false ceiling",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Gypsum false ceiling"]
[null,null,"Baffle ceiling",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Baffle ceiling"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[11,"Soft Furnishing","Blinds for openings",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Soft Furnishing","Blinds for openings"]
[null,null,"Signage",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Signage"]
[null,null,"Writing board",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Writing board"]
[null,null,"Hardware for furniture",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,{"$f":"(Q56*G56)+(R56*G56)","v":0},null,0,null,null,null,null,"Hardware for furniture"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[12,"Plumbing fixtures","Water closet",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Plumbing fixtures","Water closet"]
[null,null,"Health faucet ",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Health faucet "]
[null,null,"Urinal",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Urinal"]
[null,null,"Faucet/Tap",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Faucet/Tap"]
[null,null,"Kitchen / Pantry faucet",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Kitchen / Pantry faucet"]
[null,null,"Showerhead ",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Showerhead "]
[null,null,"Handheld shower spray ",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Handheld shower spray "]
[null,null,"Others",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Others"]
[13,"Indoor plants","Snake plant",null,null,null,{"$f":"D66*F66","v":0},null,null,null,0,null,null,null,null,0,null,null,{"$f":"(Q66*G66)+(R66*G66)","v":0},null,0,null,null,null,"Indoor plants","Snake plant"]
[null,null,"Peace lily",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,{"$f":"IF(T67=\"Y\",G67,0)","v":0},null,null,null,null,"Peace lily"]
[null,null,"ZZ plant",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"ZZ plant"]
[null,null," Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null," Other"]
[14,"Air conditioning","Air conditioning high side",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Air conditioning","Air conditioning high side"]
[null,null,"Air conditioning low side",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Air conditioning low side"]
[15,"Electrical","Wires",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,"Electrical","Wires"]
[null,null,"Cables",null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"O73*G73","v":0},null,null,0,null,0,null,null,null,null,"Cables"]
[null,null,"MS/ GI pipes / Conduits - Fire hydrant system",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"MS/ GI pipes / Conduits - Fire hydrant system"]
[null,null,"Raceways",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Raceways"]
[null,null,"Lighting - Square light (12W)",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Lighting - Square light (12W)"]
[null,null,"Lighting - Square light (22W)",null,null,null,0,null,null,null,{"$f":"G77","v":0},null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Lighting - Square light (22W)"]
[null,null,"Lighting - Decorative light (22W)",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Lighting - Decorative light (22W)"]
[null,null,"Lighting - Recessed light (6W)",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Lighting - Recessed light (6W)"]
[null,null,"Sensors",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,{"$f":"(Q80*G80)+(R80*G80)","v":0},null,0,null,null,null,null,"Sensors"]
[null,null,"Switch boards",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Switch boards"]
[null,null,"Switches/ controls",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Switches/ controls"]
[null,null,"Electrical Panels",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Electrical Panels"]
[null,null,"Switch gear",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Switch gear"]
[null,null,"Energy sub-meter",null,null,null,0,null,null,null,{"$f":"G85","v":0},null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Energy sub-meter"]
[null,null,"Appliances - Refrigerator",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Appliances - Refrigerator"]
[null,null,"Appliances - Printer",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Appliances - Printer"]
[null,null,"Appliances - UPS",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Appliances - UPS"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Other"]
[null,"Others (not included in the above list)",null,{"$f":"SUM(D2:D89)","v":741},null,null,{"$f":"SUM(G2:G89)","v":623565},null,null,null,623565,null,{"$f":"SUM(M2:M89)","v":0},{"$f":"COUNTIF(N2:N89,\"Y\")","v":2},{"$f":"SUM(O2:O89)","v":0.2},{"$f":"SUM(P2:P89)","v":3000},{"$f":"SUM(Q2:Q89)","v":0.1},{"$f":"SUM(R2:R89)","v":1.3},{"$f":"SUM(S2:S89)","v":406000},null,{"$f":"SUM(U2:U89)","v":100000}]
[]
[null,"Total material Procured",null,null,{"$f":"G90","v":623565}]
[null,"Percentage of local materials procured",null,null,{"$f":"(K90/G90)*100","v":100}]
[null," Percentage of recycled content materials procured",null,null,{"$f":"(P90/G90)*100","v":0.48110461619879241}]
[null,"Number of type I eco-labelled products procured",null,null,{"$f":"N90","v":2}]
[null,"Percentage of salvaged materials procured",null,null,{"$f":"(M90/G90)*100","v":0}]
[null,"Percentage of total cost of eco-friendly wood based material procured",null,null,{"$f":"(S90/G90)*100","v":65.109491392236578}]
[null,"Percentage of eco-certified interior furniture procured",null,null,{"$f":"(U90/G90)*100","v":16.036820539959749}]
[]
[]
[]
[null,"1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1\n\n2. Provide multiple addition of rows for other option within each category "]

{"sheet":"Ver 2_Master Material Sheet","index":12,"n_rows":104,"n_cols":26,"rows_kept":104,"cut":false,"hidden":false,"merged":[[92,1,92,3],[92,4,92,6],[93,1,93,3],[93,4,93,6],[94,1,94,3],[94,4,94,6],[98,4,98,6],[103,1,103,7],[95,1,95,3],[95,4,95,6],[96,1,96,3],[96,4,96,6],[97,1,97,3],[97,4,97,6],[98,1,98,3],[99,1,99,3],[99,4,99,6]]}
["S.No","Category\n\nGive below options as drop down option","Sub - Category\n\nGive below options as drop down specific to the material selected in Category column","Material Quantity","Unit","Rates","Total material Cost","Manufacturer Details","Manufacturing Unit Location","Distance from Manufacturing Unit Location to project site (km)","Cost of Local Materials Procured","Salvaged Material (Y/N)","Salvaged Material Cost","Reuse Material (%)","Reuse Material Cost","Eco-Labelled Material (Y/N)","Eco-Labelled Material Cost","Recycled Content (%)","Recycled Material Cost","Rapidly Renewable wood (%)"," Composite wood (%)\n","Eco-friendly/ Rapidly Renewable Wood Cost\n\n","Eco-Certified interior furniture (Y/N)","Eco -Certified interior furniture cost"]
[1,"Wall","AAC",null,null,null,{"$f":"D2*F2","v":0},null,null,null,{"$f":"G2","v":0},null,null,null,{"$f":"N2*G2","v":0},null,null,null,{"$f":"R2*G2","v":0},null,null,{"$f":"(T2*G2)+(U2*G2)","v":0},null,{"$f":"IF(W2=\"Y\",G2,0)","v":0},"Wall","AAC"]
[null,null,"Flyash",null,null,null,0,null,null,null,0,null,null,null,{"$f":"N3*G3","v":0},null,null,null,{"$f":"R3*G3","v":0},null,null,{"$f":"(T3*G3)+(U3*G3)","v":0},null,{"$f":"IF(W3=\"Y\",G3,0)","v":0},null,"Flyash"]
[null,null,"Red brick",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Red brick"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[2,"Cement","Cement",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Cement","Cement"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[3,"Wood","Plywood",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Wood","Plywood"]
[null,null,"MDF",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"MDF"]
[null,null,"Laminate",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Laminate"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[4,"Flooring","Vitrified Tile",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Flooring","Vitrified Tile"]
[null,null,"Granite",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Granite"]
[null,null,"Carpet",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Carpet"]
[null,null,"RCC",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"RCC"]
[null,null,"Raised flooring modular",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Raised flooring modular"]
[null,null,"Laminate",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Laminate"]
[null,null,"Tile",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Tile"]
[null,null,"Dado",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Dado"]
[null,null,"Wooden",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Wooden"]
[null,null,"VDF",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"VDF"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[5,"Paint","Emulsion",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Paint","Emulsion"]
[null,null,"Primer",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Primer"]
[null,null,"Enamel",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Enamel"]
[null,null,"Texture",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Texture"]
[null,null,"Putty",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Putty"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[6,"Furniture","Workstation",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Furniture","Workstation"]
[null,null,"Chair",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Chair"]
[null,null,"Storage unit",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Storage unit"]
[null,null,"Meeting room table",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Meeting room table"]
[null,null,"Cabin table",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Cabin table"]
[null,null,"Loose furniture",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Loose furniture"]
[null,null,"Sofa",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Sofa"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[7,"Partition","Glass",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Partition","Glass"]
[null,null,"Wood",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Wood"]
[null,null,"Aluminium",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Aluminium"]
[null,null,"Gypsum with insulation",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Gypsum with insulation"]
[null,null,"Sliding & folding",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Sliding & folding"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[8,"Door","Wooded door",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Door","Wooded door"]
[null,null,"Glass door",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Glass door"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[9,"Wall panelling","Plywood",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Wall panelling","Plywood"]
[null,null,"Acoustic panel",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Acoustic panel"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[10,"Ceiling","Grid false ceiling",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Ceiling","Grid false ceiling"]
[null,null,"Gypsum false ceiling",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Gypsum false ceiling"]
[null,null,"Baffle ceiling",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Baffle ceiling"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[11,"Soft Furnishing","Blinds for openings",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Soft Furnishing","Blinds for openings"]
[null,null,"Signage",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,{"$f":"IF(W54=\"Y\",G54,0)","v":0},null,"Signage"]
[null,null,"Writing board",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Writing board"]
[null,null,"Hardware for furniture",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Hardware for furniture"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[12,"Plumbing fixtures","Water closet",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,{"$f":"(T58*G58)+(U58*G58)","v":0},null,0,"Plumbing fixtures","Water closet"]
[null,null,"Health faucet ",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Health faucet "]
[null,null,"Urinal",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Urinal"]
[null,null,"Faucet/Tap",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Faucet/Tap"]
[null,null,"Kitchen / Pantry faucet",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Kitchen / Pantry faucet"]
[null,null,"Showerhead ",null,null,null,0,null,null,null,0,null,null,null,{"$f":"N63*G63","v":0},null,null,null,0,null,null,0,null,0,null,"Showerhead "]
[null,null,"Handheld shower spray ",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Handheld shower spray "]
[null,null,"Others",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Others"]
[13,"Indoor plants","Snake plant",null,null,null,{"$f":"D66*F66","v":0},null,null,null,{"$f":"G66","v":0},null,null,null,0,null,null,null,0,null,null,0,null,0,"Indoor plants","Snake plant"]
[null,null,"Peace lily",null,null,null,0,null,null,null,0,null,null,null,{"$f":"N67*G67","v":0},null,null,null,{"$f":"R67*G67","v":0},null,null,{"$f":"(T67*G67)+(U67*G67)","v":0},null,{"$f":"IF(W67=\"Y\",G67,0)","v":0},null,"Peace lily"]
[null,null,"ZZ plant",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"ZZ plant"]
[null,null," Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,{"$f":"R69*G69","v":0},null,null,0,null,0,null," Other"]
[14,"Air conditioning","Air conditioning high side",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Air conditioning","Air conditioning high side"]
[null,null,"Air conditioning low side",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Air conditioning low side"]
[15,"Electrical","Wires",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,"Electrical","Wires"]
[null,null,"Cables",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Cables"]
[null,null,"MS/ GI pipes / Conduits - Fire hydrant system",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"MS/ GI pipes / Conduits - Fire hydrant system"]
[null,null,"Raceways",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Raceways"]
[null,null,"Lighting - Square light (12W)",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Lighting - Square light (12W)"]
[null,null,"Lighting - Square light (22W)",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Lighting - Square light (22W)"]
[null,null,"Lighting - Decorative light (22W)",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Lighting - Decorative light (22W)"]
[null,null,"Lighting - Recessed light (6W)",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Lighting - Recessed light (6W)"]
[null,null,"Sensors",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Sensors"]
[null,null,"Switch boards",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Switch boards"]
[null,null,"Switches/ controls",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Switches/ controls"]
[null,null,"Electrical Panels",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Electrical Panels"]
[null,null,"Switch gear",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Switch gear"]
[null,null,"Energy sub-meter",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Energy sub-meter"]
[null,null,"Appliances - Refrigerator",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Appliances - Refrigerator"]
[null,null,"Appliances - Printer",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Appliances - Printer"]
[null,null,"Appliances - UPS",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Appliances - UPS"]
[null,null,"Other",null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,0,null,0,null,"Other"]
[null,"Others (not included in the above list)",null,{"$f":"SUM(D2:D89)","v":0},null,null,{"$f":"SUM(G2:G89)","v":0},null,null,null,{"$f":"SUM(K2:K89)","v":0},null,{"$f":"SUM(M2:M89)","v":0},null,{"$f":"SUM(O2:O89)","v":0},{"$f":"COUNTIF(P2:P89,\"Y\")","v":0},{"$f":"SUM(Q2:Q89)","v":0},null,{"$f":"SUM(S2:S89)","v":0},null,null,{"$f":"SUM(V2:V89)","v":0},null,{"$f":"SUM(X2:X89)","v":0}]
[]
[]
[null,"Total material Procured",null,null,{"$f":"G90","v":0}]
[null,"Percentage of local materials procured",null,null,{"$f":"(K90/G90)*100","v":{"$error":"#DIV/0!"}}]
[null," Percentage of recycled content materials procured",null,null,{"$f":"(S90/G90)*100","v":{"$error":"#DIV/0!"}}]
[null,"Number of type I eco-labelled products procured",null,null,{"$f":"P90","v":0}]
[null,"Percentage of salvaged materials procured",null,null,{"$f":"(M90/G90)*100","v":{"$error":"#DIV/0!"}}]
[null,"Percentage of total cost of eco-friendly wood based material procured",null,null,{"$f":"(V90/G90)*100","v":{"$error":"#DIV/0!"}}]
[null,"Percentage of eco-certified interior furniture procured",null,null,{"$f":"(X90/G90)*100","v":{"$error":"#DIV/0!"}}]
[null," Percentage of reused materials procured",null,null,{"$f":"(O90/G90)*100","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1\n\n2. Provide multiple addition of rows for other option within each category "]

{"sheet":"Waste management installation","index":13,"n_rows":97,"n_cols":11,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,0,96,8],[0,0,0,1],[93,1,93,3],[0,2,0,4]]}
["Quantity of Waste ",null,"Drop down:\nBy weight (kg)\nBy volume [cubic meter (m3)"]
[]
["S. NO","Description of Material","Generated","Reused on project site","Sent to recycle vendor","Donate to other project site","Sent to landfill",null,null,null,"All the cells filled with yellow, the values to be entered by project team "]
[1,{"$f":"'Ver 1_Master Material Sheet'!C2","v":"AAC"},100,20,30,20,30]
[2,{"$f":"'Ver 1_Master Material Sheet'!C3","v":"Flyash"},75,null,null,75]
[3,{"$f":"'Ver 1_Master Material Sheet'!C4","v":"Red brick"},50,null,null,null,50]
[4,{"$f":"'Ver 1_Master Material Sheet'!C5","v":"Other"},65,15,15,35]
[5,{"$f":"'Ver 1_Master Material Sheet'!C6","v":"Cement"}]
[6,{"$f":"'Ver 1_Master Material Sheet'!C7","v":"Other"}]
[7,{"$f":"'Ver 1_Master Material Sheet'!C8","v":"Plywood"}]
[8,{"$f":"'Ver 1_Master Material Sheet'!C9","v":"MDF"}]
[9,{"$f":"'Ver 1_Master Material Sheet'!C10","v":"Laminate"}]
[10,{"$f":"'Ver 1_Master Material Sheet'!C11","v":"Other"}]
[11,{"$f":"'Ver 1_Master Material Sheet'!C12","v":"Vitrified Tile"}]
[12,{"$f":"'Ver 1_Master Material Sheet'!C13","v":"Granite"}]
[13,{"$f":"'Ver 1_Master Material Sheet'!C14","v":"Carpet"}]
[14,{"$f":"'Ver 1_Master Material Sheet'!C15","v":"RCC"}]
[15,{"$f":"'Ver 1_Master Material Sheet'!C16","v":"Raised flooring modular"}]
[16,{"$f":"'Ver 1_Master Material Sheet'!C17","v":"Laminate"}]
[17,{"$f":"'Ver 1_Master Material Sheet'!C18","v":"Tile"}]
[18,{"$f":"'Ver 1_Master Material Sheet'!C19","v":"Dado"}]
[19,{"$f":"'Ver 1_Master Material Sheet'!C20","v":"Wooden"}]
[20,{"$f":"'Ver 1_Master Material Sheet'!C21","v":"VDF"}]
[21,{"$f":"'Ver 1_Master Material Sheet'!C22","v":"Other"}]
[22,{"$f":"'Ver 1_Master Material Sheet'!C23","v":"Emulsion"}]
[23,{"$f":"'Ver 1_Master Material Sheet'!C24","v":"Primer"}]
[24,{"$f":"'Ver 1_Master Material Sheet'!C25","v":"Enamel"}]
[25,{"$f":"'Ver 1_Master Material Sheet'!C26","v":"Texture"}]
[26,{"$f":"'Ver 1_Master Material Sheet'!C27","v":"Putty"}]
[27,{"$f":"'Ver 1_Master Material Sheet'!C28","v":"Other"}]
[28,{"$f":"'Ver 1_Master Material Sheet'!C29","v":"Workstation"}]
[29,{"$f":"'Ver 1_Master Material Sheet'!C30","v":"Chair"}]
[30,{"$f":"'Ver 1_Master Material Sheet'!C31","v":"Storage unit"}]
[31,{"$f":"'Ver 1_Master Material Sheet'!C32","v":"Meeting room table"}]
[32,{"$f":"'Ver 1_Master Material Sheet'!C33","v":"Cabin table"}]
[33,{"$f":"'Ver 1_Master Material Sheet'!C34","v":"Loose furniture"}]
[34,{"$f":"'Ver 1_Master Material Sheet'!C35","v":"Sofa"}]
[35,{"$f":"'Ver 1_Master Material Sheet'!C36","v":"Other"}]
[36,{"$f":"'Ver 1_Master Material Sheet'!C37","v":"Glass"}]
[37,{"$f":"'Ver 1_Master Material Sheet'!C38","v":"Wood"}]
[38,{"$f":"'Ver 1_Master Material Sheet'!C39","v":"Aluminium"}]
[39,{"$f":"'Ver 1_Master Material Sheet'!C40","v":"Gypsum with insulation"}]
[40,{"$f":"'Ver 1_Master Material Sheet'!C41","v":"Sliding & folding"}]
[41,{"$f":"'Ver 1_Master Material Sheet'!C42","v":"Other"}]
[42,{"$f":"'Ver 1_Master Material Sheet'!C43","v":"Wooded door"}]
[43,{"$f":"'Ver 1_Master Material Sheet'!C44","v":"Glass door"}]
[44,{"$f":"'Ver 1_Master Material Sheet'!C45","v":"Other"}]
[45,{"$f":"'Ver 1_Master Material Sheet'!C46","v":"Plywood"}]
[46,{"$f":"'Ver 1_Master Material Sheet'!C47","v":"Acoustic panel"}]
[47,{"$f":"'Ver 1_Master Material Sheet'!C48","v":"Other"}]
[48,{"$f":"'Ver 1_Master Material Sheet'!C49","v":"Grid false ceiling"}]
[49,{"$f":"'Ver 1_Master Material Sheet'!C50","v":"Gypsum false ceiling"}]
[50,{"$f":"'Ver 1_Master Material Sheet'!C51","v":"Baffle ceiling"}]
[51,{"$f":"'Ver 1_Master Material Sheet'!C52","v":"Other"}]
[52,{"$f":"'Ver 1_Master Material Sheet'!C53","v":"Blinds for openings"}]
[53,{"$f":"'Ver 1_Master Material Sheet'!C54","v":"Signage"}]
[54,{"$f":"'Ver 1_Master Material Sheet'!C55","v":"Writing board"}]
[55,{"$f":"'Ver 1_Master Material Sheet'!C56","v":"Hardware for furniture"}]
[56,{"$f":"'Ver 1_Master Material Sheet'!C57","v":"Other"}]
[57,{"$f":"'Ver 1_Master Material Sheet'!C58","v":"Water closet"}]
[58,{"$f":"'Ver 1_Master Material Sheet'!C59","v":"Health faucet "}]
[59,{"$f":"'Ver 1_Master Material Sheet'!C60","v":"Urinal"}]
[60,{"$f":"'Ver 1_Master Material Sheet'!C61","v":"Faucet/Tap"}]
[61,{"$f":"'Ver 1_Master Material Sheet'!C62","v":"Kitchen / Pantry faucet"}]
[62,{"$f":"'Ver 1_Master Material Sheet'!C63","v":"Showerhead "}]
[63,{"$f":"'Ver 1_Master Material Sheet'!C64","v":"Handheld shower spray "}]
[64,{"$f":"'Ver 1_Master Material Sheet'!C65","v":"Others"}]
[65,{"$f":"'Ver 1_Master Material Sheet'!C66","v":"Snake plant"}]
[66,{"$f":"'Ver 1_Master Material Sheet'!C67","v":"Peace lily"}]
[67,{"$f":"'Ver 1_Master Material Sheet'!C68","v":"ZZ plant"}]
[68,{"$f":"'Ver 1_Master Material Sheet'!C69","v":" Other"}]
[69,{"$f":"'Ver 1_Master Material Sheet'!C70","v":"Air conditioning high side"}]
[70,{"$f":"'Ver 1_Master Material Sheet'!C71","v":"Air conditioning low side"}]
[71,{"$f":"'Ver 1_Master Material Sheet'!C72","v":"Wires"}]
[72,{"$f":"'Ver 1_Master Material Sheet'!C73","v":"Cables"}]
[73,{"$f":"'Ver 1_Master Material Sheet'!C74","v":"MS/ GI pipes / Conduits - Fire hydrant system"}]
[74,{"$f":"'Ver 1_Master Material Sheet'!C75","v":"Raceways"}]
[75,{"$f":"'Ver 1_Master Material Sheet'!C76","v":"Lighting - Square light (12W)"}]
[76,{"$f":"'Ver 1_Master Material Sheet'!C77","v":"Lighting - Square light (22W)"}]
[77,{"$f":"'Ver 1_Master Material Sheet'!C78","v":"Lighting - Decorative light (22W)"}]
[78,{"$f":"'Ver 1_Master Material Sheet'!C79","v":"Lighting - Recessed light (6W)"}]
[79,{"$f":"'Ver 1_Master Material Sheet'!C80","v":"Sensors"}]
[80,{"$f":"'Ver 1_Master Material Sheet'!C81","v":"Switch boards"}]
[81,{"$f":"'Ver 1_Master Material Sheet'!C82","v":"Switches/ controls"}]
[82,{"$f":"'Ver 1_Master Material Sheet'!C83","v":"Electrical Panels"}]
[83,{"$f":"'Ver 1_Master Material Sheet'!C84","v":"Switch gear"}]
[84,{"$f":"'Ver 1_Master Material Sheet'!C85","v":"Energy sub-meter"}]
[85,{"$f":"'Ver 1_Master Material Sheet'!C86","v":"Appliances - Refrigerator"}]
[86,{"$f":"'Ver 1_Master Material Sheet'!C87","v":"Appliances - Printer"}]
[87,{"$f":"'Ver 1_Master Material Sheet'!C88","v":"Appliances - UPS"}]
[88,{"$f":"'Ver 1_Master Material Sheet'!C89","v":"Other"}]
[null,"Total\t",{"$f":"SUM(C4:C91)","v":290},{"$f":"SUM(D4:D91)","v":35},45,130,{"$f":"SUM(G4:G91)","v":80}]
[]
[null,"% of waste diverted away from landfill",null,null,{"$f":"(C92-(SUM(D92:F92)))/C92","v":0.27586206896551724}]
[]
[]
["1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1 & V2\n\n2. Provide multiple addition of rows for multiple input field \n\n3. If project is meeting exemplary performance threshold a pop up message to be reflected. ( only for version 2 )\n\nDisplay -  \"This credit is eligible for exemplary performance\"\n\n4. Change name of sheet to \"'Cal _ Waste Management (During Installation)\""]

{"sheet":"Ver 1 Cal _ Daylight  CO2 Noise","index":14,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,1,37,6],[39,1,39,7],[23,1,23,7],[24,1,24,7],[27,1,27,7],[28,1,28,7],[31,1,31,7],[32,1,32,7],[34,1,34,7],[26,1,26,6],[29,1,29,6],[30,1,30,6],[33,1,33,6],[36,1,36,6],[35,1,35,7],[3,17,3,18],[4,17,4,18],[19,17,19,18],[25,1,25,6],[23,10,23,14],[24,10,24,14],[26,10,26,14],[25,10,25,14],[2,10,2,14],[22,1,22,6],[22,10,22,14],[2,1,3,1],[2,2,3,2],[2,3,2,7],[2,8,2,9]]}
[]
[]
[null,"Description of spaces (e.g. core workstation, meeting room, electrical room, restroom etc)","Total carpet area \n(sq ft)","Daylighting ",null,null,null,null,"CO2  Monitoring\n (Mechanical Ventilation )",null,"Material Acoustic performance - Noise Criteria",null,null,null,null,"Outdoor view ",null,null,null,null,null,"Measured lux level"]
[null,null,null,"Space type","Daylight Benchmark Lux Level\n","Simulated lux level","Daylight \nCompliant Area (sq ft)","Meets daylight credit compliance","Provision of CO2 sensor","Compliant Area\n(sq ft)","Space Type","Baseline maximum Value (dB)","Measured Value (dB)","Compliant Area\n(sq ft)","Meets Credit Compliance"," Compliant Area \n(sq ft)",null,"Setup Table",null,null,null,"Simulated lux level"]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B4:B19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":"Workstation Area"},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E4:E19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":5326},"General Offices",{"$f":"VLOOKUP(D5,R22:S36,2,FALSE)","v":300},301,{"$f":"IF(F5>=E5,C5,0)","v":5326},{"$f":"IF(F5>=E5,TRUE,FALSE)","v":true},"Yes",{"$f":"IF(I5=\"yes\",C5,0)","v":5326},"Enclosed office",{"$f":"IF(K5 =\"Enclosed office\",$S$7,$S$8)","v":35},34,{"$f":"IF(M5<L5,C5,0)","v":5326},{"$f":"IF(M5<L5,TRUE, FALSE)","v":true},20,null,"Noise Criteria"]
[null,"Workstation Area-JS",490,"Deep Plan General Offices",{"$f":"VLOOKUP(D6,R23:S37,2,FALSE)","v":500},400,0,false,"No",{"$f":"IF(I6=\"yes\",C6,0)","v":0},"Enclosed office",{"$f":"IF(K6 =\"Enclosed office\",$S$7,$S$8)","v":35},32,{"$f":"IF(M6<L6,C6,0)","v":490},{"$f":"IF(M6<L6,TRUE, FALSE)","v":true},10,null,"Space Type ","Baseline maximum Value (dB)",null,null,"Yes"]
[null,"Café Area",692,"Deep Plan General Offices",{"$f":"VLOOKUP(D7,R22:S36,2,FALSE)","v":500},300,{"$f":"IF(F7>=E7,C7,0)","v":0},{"$f":"IF(F7>=E7,TRUE,FALSE)","v":false},"Yes",692,"Enclosed office",{"$f":"IF(K7 =\"Enclosed office\",$S$7,$S$8)","v":35},32,692,true,15,null,"Enclosed office",35,null,null,"No"]
[null,"Meetings Room Area",742,"Deep Plan General Offices",{"$f":"VLOOKUP(D8,R22:S36,2,FALSE)","v":500},299,0,{"$f":"IF(F8>=E8,TRUE,FALSE)","v":false},"Yes",742,"Open office",{"$f":"IF(K8 =\"Enclosed office\",$S$7,$S$8)","v":40},32,742,true,80,null,"Open office",40]
[null,"Cabins Area",325,"Deep Plan General Offices",{"$f":"VLOOKUP(D9,R22:S36,2,FALSE)","v":500},null,0,false,"Yes",325,"Enclosed office",{"$f":"IF(K9 =\"Enclosed office\",$S$7,$S$8)","v":35},43,{"$f":"IF(M9<L9,C9,0)","v":0},{"$f":"IF(M9<L9,TRUE, FALSE)","v":false},15]
[null,"Reception Area",319,"Drawing Boards",{"$f":"VLOOKUP(D10,R22:S36,2,FALSE)","v":500},null,0,false,null,null,null,{"$f":"IF(K10 =\"Enclosed office\",$S$7,$S$8)","v":40},null,{"$f":"IF(M10<L10,C10,0)","v":319},{"$f":"IF(M10<L10,TRUE, FALSE)","v":true}]
[null,"Phone Booths Area",260,"Computer Work Stations",{"$f":"VLOOKUP(D11,R22:S36,2,FALSE)","v":300},null,0,false,null,null,"Enclosed office",35,null,260,true]
[null,"Lounge Areas",177,"Computer Work Stations",{"$f":"VLOOKUP(D12,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,177,true]
[null,"Board Room",524,"Computer Work Stations",{"$f":"VLOOKUP(D13,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,524,true]
[null,null,null,"Computer Work Stations",{"$f":"VLOOKUP(D14,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,0,true]
[null,null,null,"Computer Work Stations",{"$f":"VLOOKUP(D15,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,0,true]
[null,null,null,"Computer Work Stations",{"$f":"VLOOKUP(D16,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,0,true]
[null,null,null,"Computer Work Stations",{"$f":"VLOOKUP(D17,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,0,true]
[null,null,null,"Computer Work Stations",{"$f":"VLOOKUP(D18,R22:S36,2,FALSE)","v":300},null,0,false,null,null,null,40,null,0,true]
[null,null,null,"Drawing Boards",{"$f":"VLOOKUP(D19,R22:S36,2,FALSE)","v":500},null,0,false,null,null,null,{"$f":"IF(K19 =\"Enclosed office\",$S$7,$S$8)","v":40},null,0,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daylighting "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Space Type","Average Illuminance(in lux)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Offices",300]
[null,"Total regularly occupied area  (sq ft)",null,null,null,null,null,{"$f":" SUM(_xlfn.ANCHORARRAY(C5))","v":8855},null,null,null,null,null,null,null,null,null,"Deep Plan General Offices",500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer Work Stations",300]
[null,"Daylighting ",null,null,null,null,null,null,null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) ",null,null,null,null,null,null,"Conference Rooms, Executive Offices",300]
[null,"Total area with adequate daylight (sq ft )",null,null,null,null,null,{"$f":"SUM(G5:G9)","v":5326},null,null,null,null,null,null,null,null,null,"Computer and Data Preparation Rooms",300]
[null,"Percentage of regularly occupied spaces with access to daylight",null,null,null,null,null,{"$f":"H26/H23","v":0.60146809712027105},null,null,null,null,null,null,null,null,null,"Drawing Boards",500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print rooms",200]
[null,"CO2  Monitoring\n (Mechanical Ventilation )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counter, Office Areas",300]
[null,"Total regularly occupied area covered by CO2 sensors (sq ft)",null,null,null,null,null,{"$f":"SUM(J5:J9)","v":7085},null,null,null,null,null,null,null,null,null,"Supermarkets/ Hyper Markets",300]
[null,"Percentage of regularly occupied area meeting CO2 monitoring credit compliance",null,null,null,null,null,{"$f":"H30/H23","v":0.80011293054771315},null,null,null,null,null,null,null,null,null,"Showrooms for Large Objects example Cars, Furniture",300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Entrance Halls",50]
[null,"Material Acoustic performance - Noise Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Reception/ Cashiers",200]
[null,"Office area meeting noise level\n\nTo be changed to \"Meets noise criteria requirements for all regularly occupied spaces\"",null,null,null,null,null,{"$f":"AND(EXACT(O22:O30, \"TRUE\"))","v":false},null,null,null,null,null,null,null,null,null,"Hotel– Bed room",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Bathrooms",50]
[null,"Outdoor view ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Food Preparation & Stores, Cellars, Lifts &Corridors",100]
[null,"Total regularly occupied area with access to outdoor views",null,null,null,null,null,{"$f":"SUM(P5:P9)","v":140}]
[null,"Percentage of regularly occupied area with access to outdoor views",null,null,null,null,null,{"$f":"H37/H23","v":1.5810276679841896E-2}]
[]
[null,"1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1 & V2\n\n2. Provide multiple addition of rows for multiple input field \n\n3. Change name of sheet to \"Ver 1 Cal _ Daylight/CO2/Noise/Outdoor\""]

{"sheet":"Ver 2 Cal _ Daylight Noise","index":15,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,1,29,6],[32,1,32,6],[33,1,33,6],[31,1,31,7],[30,1,30,7],[3,18,3,24],[23,1,23,7],[24,1,24,7],[28,1,28,7],[27,1,27,7],[26,1,26,6],[2,1,3,1],[2,2,3,2],[2,3,2,7],[2,8,2,12],[4,19,4,20],[6,19,6,20],[21,19,21,20],[22,1,22,6],[25,1,25,6]]}
[]
[]
[null,"Description of spaces (e.g. core workstation, meeting room, electrical room, restroom etc)","Total carpet area \n(sq ft)","Daylighting ",null,null,null,null,"Material Acoustic performance - Noise Criteria",null,null,null,null,"Outdoor view ",null,null,"All the cells highlighted with yellow background are input fields (data to be entered by project team) "]
[null,null,null,"Space type","Daylight Benchmark Lux Levels","Simulated lux level","Daylight \nCompliant Area (sq ft)","Meets daylight credit compliance","Space Type","Baseline maximum Value (dB)","Measured Value (dB)","Compliant Area","Meets Credit Compliance"," Compliant Area (sq ft)"]
[null,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B4:B19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":"Workstation Area"},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E4:E19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":5326},"Deep Plan General Offices",{"$f":"VLOOKUP(D5,T24:U38,2,FALSE)","v":500},301,{"$f":"IF(F5>=E5,C5,0)","v":0},{"$f":"IF(F5>=E5,TRUE,FALSE)","v":false},"Open office",{"$f":"IF(I5 =\"Enclosed office\",$U$9,$U$10)","v":40},34,{"$f":"IF(K5<J5,C5,0)","v":5326},{"$f":"IF(K5<J5,TRUE, FALSE)","v":true},20,null,null,null,null,null,"Setup Table"]
[null,"Workstation Area-JS",490,"Deep Plan General Offices",{"$f":"VLOOKUP(D6,T24:U38,2,FALSE)","v":500},400,{"$f":"IF(F6>=E6,C6,0)","v":0},{"$f":"IF(F6>=E6,TRUE,FALSE)","v":false},"Open office",{"$f":"IF(I6 =\"Enclosed office\",$U$9,$U$10)","v":40},32,{"$f":"IF(K6<J6,C6,0)","v":490},{"$f":"IF(K6<J6,TRUE, FALSE)","v":true},10]
[null,"Café Area",692,"Deep Plan General Offices",{"$f":"VLOOKUP(D7,T24:U38,2,FALSE)","v":500},300,{"$f":"IF(F7>=E7,C7,0)","v":0},{"$f":"IF(F7>=E7,TRUE,FALSE)","v":false},null,{"$f":"IF(I7 =\"Enclosed office\",$U$9,$U$10)","v":40},32,{"$f":"IF(K7<J7,C7,0)","v":692},true,15,null,null,null,null,null,"Noise Criteria"]
[null,"Meetings Room Area",742,"Deep Plan General Offices",{"$f":"VLOOKUP(D8,T24:U38,2,FALSE)","v":500},299,0,{"$f":"IF(F8>=E8,TRUE,FALSE)","v":false},null,{"$f":"IF(I8 =\"Enclosed office\",$U$9,$U$10)","v":40},32,{"$f":"IF(K8<J8,C8,0)","v":742},true,80,null,null,null,null,null,"Space Type ","Baseline maximum Value (dB)","Yes"]
[null,"Cabins Area",325,"Computer Work Stations",{"$f":"VLOOKUP(D9,T24:U38,2,FALSE)","v":300},null,0,false,null,40,43,{"$f":"IF(K9<J9,C9,0)","v":0},false,15,null,null,null,null,null,"Enclosed office",35,"No"]
[null,"Reception Area",319,null,{"$f":"VLOOKUP(D10,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,{"$f":"IF(K10<J10,C10,0)","v":319},true,null,null,null,null,null,null,"Open office",40]
[null,"Phone Booths Area",260,null,{"$f":"VLOOKUP(D11,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,260,true]
[null,"Lounge Areas",177,"Computer Work Stations",{"$f":"VLOOKUP(D12,T24:U38,2,FALSE)","v":300},null,0,false,null,40,null,177,true]
[null,"Board Room",524,null,{"$f":"VLOOKUP(D13,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,524,true]
[null,null,null,null,{"$f":"VLOOKUP(D14,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[null,null,null,null,{"$f":"VLOOKUP(D15,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[null,null,null,null,{"$f":"VLOOKUP(D16,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[null,null,null,null,{"$f":"VLOOKUP(D17,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[null,null,null,null,{"$f":"VLOOKUP(D18,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[null,null,null,null,{"$f":"VLOOKUP(D19,T24:U38,2,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"},null,40,null,0,true]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daylighting "]
[null,"Total regularly occupied area  (sq ft)",null,null,null,null,null,{"$f":"SUM(_xlfn.ANCHORARRAY(C5))","v":8855},null,null,null,null,null,null,null,null,null,null,null,"Space Type","Average Illuminance(in lux)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Offices",300]
[null,"Daylighting ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deep Plan General Offices",500]
[null,"Total area with adequate daylight (sq ft )",null,null,null,null,null,{"$f":"SUM(G5:G9)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Computer Work Stations",300]
[null,"Percentage of regularly occupied spaces with access to daylight",null,null,null,null,null,{"$f":"H26/H23","v":0},null,null,null,null,null,null,null,null,null,null,null,"Conference Rooms, Executive Offices",300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer and Data Preparation Rooms",300]
[null,"Material Acoustic performance - Noise Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawing Boards",500]
[null,"Meets noise criteria requirements for all regularly occupied spaces",null,null,null,null,null,{"$f":"AND(EXACT(O22:O30, \"TRUE\"))","v":false},null,null,null,null,null,null,null,null,null,null,null,"Print rooms",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counter, Office Areas",300]
[null,"Outdoor view ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supermarkets/ Hyper Markets",300]
[null,"Total regularly occupied area with access to outdoor views",null,null,null,null,null,{"$f":"SUM(N5:N9)","v":140},null,null,null,null,null,null,null,null,null,null,null,"Showrooms for Large Objects example Cars, Furniture",300]
[null,"Percentage of regularly occupied area with access to outdoor views",null,null,null,null,null,{"$f":"H33/H23","v":1.5810276679841896E-2},null,null,null,null,null,null,null,null,null,null,null,"Hotel– Entrance Halls",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Reception/ Cashiers",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Bed room",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hotel– Bathrooms",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Food Preparation & Stores, Cellars, Lifts &Corridors",100]

{"sheet":"Fresh air AC","index":16,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,0,25,7],[9,0,11,0],[9,1,11,1],[10,16,12,16],[12,0,13,0],[12,1,13,1],[31,0,31,10],[26,0,26,7],[27,0,27,7],[28,0,28,7],[29,0,29,7]]}
[null,null,"Type of fresh air system","Capacity of fresh air system (CFM)"]
[null,null,"Inline fan 1",50]
[null,null,"Inline fan 2",50]
[null,null,"TFA 1",100]
[]
[]
[]
[]
["Fresh Air System/ TFA\n\nTo be changed to \"Type of fresh air system\"","TFA Capacity (CFM)\n\nTo be changed to \"Capacity of fresh air system (CFM)\"","Regularly occupied Spaces (e.g. Core workstation, meeting room, cabin etc) \n","Carpet area of regularly occupied space (sq ft) ","Space Type","Type of fresh air system","Outdoor Air Rate (CFM) / Unit area","Design Occupancy","Outdoor Air Rate (CFM) /Person","Minimum ventilation rate required (CFM) - Baseline","10% more than minimum ventilation rate required"]
["Inline fan 1",150,{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!B4:B19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":"Workstation Area"},{"$f":"_xlfn._xlws.FILTER('Cal _ Area Statement Circulatio'!E4:E19,'Cal _ Area Statement Circulatio'!C4:C19 = \"Regularly occupied space\")","v":5326},"Office space/ reception area/ telephone/ data entry/ main entry lobby","Inline fan 1",{"$f":"VLOOKUP(E10,U25:V35,2,FALSE)","v":0.06},14,{"$f":"VLOOKUP(E10,Q14:R35,2,FALSE)","v":5},{"$f":"(H10*I10)+(G10*D10)","v":389.56},{"$f":"J10+(10%*J10)","v":428.51600000000002}]
[null,null,"Workstation Area-JS",490,"Conference/meeting","Inline fan 1",{"$f":"VLOOKUP(E11,U25:V35,2,FALSE)","v":0.06},3,{"$f":"VLOOKUP(E11,Q14:R35,2,FALSE)","v":5},{"$f":"(H11*I11)+(G11*D11)","v":44.4},{"$f":"J11+(10%*J11)","v":48.839999999999996},null,null,null,null,null,"Space Type","People",null,null,"Space Type","Area"]
[null,null,"Café Area",692,"Conference/meeting","Inline fan 2",{"$f":"VLOOKUP(E12,U25:V35,2,FALSE)","v":0.06},9,{"$f":"VLOOKUP(E12,Q14:R35,2,FALSE)","v":5},{"$f":"(H12*I12)+(G12*D12)","v":86.52},95.171999999999997,null,null,null,null,null,null,"Outdoor Air Rate (Rp)",null,null,null,"Outdoor Air Rate (Ra)"]
["Inline Fan 2",100,"Meetings Room Area",742,"Office space/ reception area/ telephone/ data entry/ main entry lobby","TFA 1",{"$f":"VLOOKUP(E13,U25:V35,2,FALSE)","v":0.06},2,{"$f":"VLOOKUP(E13,Q14:R35,2,FALSE)","v":5},{"$f":"(H13*I13)+(G13*D13)","v":54.519999999999996},59.971999999999994,null,null,null,null,null,null,"(cfm/person) ",null,null,null,"(cfm/sq.ft) "]
[null,null,"Cabins Area",325,"Cafeteria/Fast food dining","Inline Fan 3",{"$f":"VLOOKUP(E14,U25:V35,2,FALSE)","v":0.18},3,{"$f":"VLOOKUP(E14,Q14:R35,2,FALSE)","v":7.7},{"$f":"(H14*I14)+(G14*D14)","v":81.599999999999994},89.759999999999991,null,null,null,null,null,"Restaurant Dining rooms",7.5,null,null,"Restaurant Dining rooms",0.18]
[null,null,"Reception Area",319,null,null,{"$f":"VLOOKUP(E15,U26:V36,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(E15,Q15:R36,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"(H15*I15)+(G15*D15)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,"Phone Booths Area",260,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Lounge Areas",177,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Board Room",524,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cafeteria/Fast food dining",7.7,null,null,"Cafeteria/Fast food dining",0.18]
["Mandatory fresh-air requirement (CFM)",null,null,null,null,null,null,null,{"$f":"SUM(J10:J14)","v":656.6},null,null,null,null,null,null,null,"Conference/meeting",5,null,null,"Conference/meeting",0.06]
["Fresh air Ventilation provided in Project (CFM)",null,null,null,null,null,null,null,{"$f":"SUM(D2:D5)","v":200},null,null,null,null,null,null,null,"Hotels-bed/living rooms",5,null,null,"Hotels-bed/living rooms",0.06]
["Percentage of fresh air supplied against the ASHRAE 62.1 baseline\n\nTo be changed to \"Percentage of fresh air supplied against the ASHRAE 62.1 baseline\"",null,null,null,null,null,null,null,{"$f":"(I27-I26)/I26","v":-0.6954005482790131},null,null,null,null,null,null,null,"Office space/ reception area/ telephone/ data entry/ main entry lobby",5,null,null,"Office space/ reception area/ telephone/ data entry/ main entry lobby",0.06]
["Design Occupancy",null,null,null,null,null,null,null,{"$f":"SUM(H10:H14)","v":31},null,null,null,null,null,null,null,"Libraries",5,null,null,"Libraries",0.12]
["Total regularly occupied area (sq ft)",null,null,null,null,null,null,null,{"$f":"SUM(D10:D14)","v":7575},null,null,null,null,null,null,null,"Retail Spaces",7.5,null,null,"Retail Spaces",0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Super Market",7.5,null,null,"Super Market",0.06]
["1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1 & V2\n\n2. Provide multiple addition of rows for other option within each category \n\n3. Kindly name the calculation sheet from Annexure Fresh Air Ac to  \"Cal _ Fresh Air Mechanical Ventilation\"\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auditorium",5,null,null,"Auditorium",0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health Club",20,null,null,"Health Club",0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corridors",null,null,null,"Corridors",0.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computer Lab",10,null,null,"Computer Lab",0.12]

{"sheet":"Occupant wellbeing facility","index":17,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,1,10,3],[11,1,11,3],[12,1,12,3],[14,1,14,8]]}
[]
[]
["S.No","Occupant wellbeing facilities provided","No of occupants served by each facility\n","No of facility","Total occupants"]
[1,"Table tennis",2,4,{"$f":"D4*C4","v":8}]
[2,"Carrom",1,4,{"$f":"D5*C5","v":4}]
[3,"Foosball",1,2,2]
[4,"Gym",1,10,10]
[5,"Other"]
[6,"Other"]
[]
[null,"Total number occupants with access to occupant wellbeing facilities",null,null,{"$f":"SUM(E4:E9)","v":24}]
[null,"Permanent Occupancy ",null,null,{"$f":"'Project Details'!B12","v":184}]
[null,"Percentage of occupants with access to recreational facilities at any given point of time",null,null,{"$f":"E11/E12","v":0.13043478260869565}]
[]
[null,"1. Based on the percentage savings, points achieved by the project team to be automatically  reflected in checklist and respective credit page. \n\nRefer to the point distribution sheet V1 & V2\n\n2. Provide multiple addition of rows for multiple input field \n\n3. Kindly change the name of this calculation sheet from Annexure Acoustic to   \"Cal _Occupant Wellbeing facilities\""]