{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Environment","Sheet3","START","Sheet4","Summary","Scoring","Averages","Results graph","graphs","Maximum scores"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":8,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Results graph","index":7,"reason":"not_a_worksheet"}],"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":"Environment","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,22,1,32]]}
[null,"Yes ","Regularly but not specified timeframe","KWh","day",null,"Previous year",null,"day"]
["Automotive and Auto Ancillary","No","Times per year","MJ","week",null,"Previous semester",null,"week"]
["Banking and Financial Services","Unknown","Every ____ months",null,"month",null,"Previous month",null,"month"]
["Broadcasting",null,"Unknown",null,"year",null,"Not specified",null,"year"]
["Chemicals",null,null,null,"unit of production",null,null,null,"Not specified"]
["Construction",null,null,null,"unit of revenue"]
["Cosmetics / Personal Care",null,null,null,"Not specified"]
["Extracting / Production"]
["IT/ITES & Electronics"]
["Materials"]
["Mining & Metals"]
["Personal Accessories"]
["Pharmaceuticals"]
["Power (Generation/Distribution) "]
["Processed food and beverages"]
["Refining and Marketing"]
["Telecom"]
["Others "]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"START","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"India 2014v12"]

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Summary","index":4,"n_rows":128,"n_cols":130,"rows_kept":128,"cut":false,"hidden":false,"merged":[[7,4,7,5],[17,0,23,0],[26,0,30,0],[33,0,35,0],[38,0,39,0],[10,3,10,4],[0,0,5,0],[90,0,93,0],[96,0,98,0],[42,0,44,0],[47,0,48,0],[51,0,53,0],[56,0,58,0],[61,0,66,0],[11,0,14,0],[124,0,127,0],[69,0,79,0],[71,6,79,6],[102,8,103,8],[110,8,111,8],[112,8,113,8],[120,0,121,0],[85,0,87,0],[116,0,117,0],[109,0,111,0],[101,0,108,0],[112,0,114,0]]}
["General data","Name of the company",null,null,"India 2014v12"]
[null,"Sector of operations","Chemicals",null,null,null,null,"Maximum possible score"]
[null,"Sustainability report","No",null,"Total score",{"$f":"SUM(L:L)","v":0},null,{"$f":"'Maximum scores'!X3","v":87},null,{"$f":"F3/H3","v":0}]
[null,"Reporting format"]
[null,"Assured report","No",null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH($C$2,Averages!$B$2:$B$18)+1","v":5}]
[null,"Auditor"]
[null,null,null,null,null,null,null,null,null,null,null,"Total","Normalization"]
[null,null,"Answer","Hyperlink","Frequency",null,null,"Score",null,null,"Total",{"$f":"H9","v":0},{"$f":"L8/'Maximum scores'!C3","v":0},{"$f":"HLOOKUP($A$9,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.5},{"$f":"IF(L8>N8,\"ABOVE AVERAGE\",\"BELOW AVERAGE\")","v":"BELOW AVERAGE"}]
["Disclosure and labelling","Does the Company publish a BR or a Sustainability Report? What is the hyperlink for viewing this report? How frequently it is published?",null,null,null,null,null,{"$f":"Scoring!D4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","asdfmafer",null,"mafer"]
[]
[null,"Parameter","Answer","Details",null,null,null,"Score",null,null,"Total",{"$f":"SUM(H12:H15)","v":0},{"$f":"L11/'Maximum scores'!D3","v":0},{"$f":"HLOOKUP($A$12,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.6},{"$f":"IF(L11>N11,\"ABOVE AVERAGE\",\"BELOW AVERAGE\")","v":"BELOW AVERAGE"}]
["Board structure and independence","Details on composition of the board",null,null,null,null,null,{"$f":"Scoring!G4","v":0}]
[null,"Frequency with which the board and Chief executive meets",null,null,null,null,null,{"$f":"Scoring!I4","v":0}]
[null,"Details on who is responsible for the sutainability reporting",null,null,null,null,null,{"$f":"Scoring!L4","v":0}]
[null,"Details on frequency whith which the sustainability performance is reviewed",null,null,null,null,null,{"$f":"Scoring!N4","v":0}]
[]
[null,null,"Existance","Shared","Details",null,null,"Score",null,null,"Total",{"$f":"SUM(H18:H24)","v":0},{"$f":"L17/'Maximum scores'!E3","v":0},{"$f":"HLOOKUP($A$18,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.625},"BELOW AVERAGE"]
["Policies, standards, codes of conduct","Indicate whether the organization has a written code of ethics that has been communicated to employees.",null,null,null,null,null,{"$f":"Scoring!R4","v":0}]
[null,"Does the policy relating to ethics, bribery and corruption cover only the company? Yes/ No. Does it extend to the Group/Joint Ventures/ Suppliers/Contractors/NGOs /Others?",null,null,null,null,null,{"$f":"Scoring!V4","v":0}]
[null,"Externally developed economic, environmental, and social charters, principles, or other initiatives to which the organization subscribes or endorses.",null,null,null,null,null,{"$f":"Scoring!Y4","v":0}]
[null,"Has the policy been formally communicated to all relevant internal and external stakeholders?",null,null,null,null,null,{"$f":"Scoring!AB4","v":0}]
[null,"Does the company have in-house structure to implement the policy/policies.",null,null,null,null,null,{"$f":"Scoring!AE4","v":0}]
[null,"Does the Company have a grievance redressal mechanism related to the policy/policies to address stakeholders’ grievances related to the policy/policies?",null,null,null,null,null,{"$f":"Scoring!AH4","v":0}]
[null,"Has the company carried out independent 3  audit/evaluation of the working of this policy by an internal or external agency?",null,null,null,null,null,{"$f":"Scoring!AK4","v":0}]
[]
[null,null,"Disclosure","Details",null,null,null,null,null,"Score","Total",{"$f":"SUM(J27:J31)","v":0},{"$f":"L26/'Maximum scores'!F3","v":0},{"$f":"HLOOKUP($A$27,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.34090909090909094},"BELOW AVERAGE"]
["Communication and engagement","List of stakeholder groups engaged by the organization",null,null,null,null,null,null,null,{"$f":"Scoring!AN4","v":0}]
[null,"Key topics and concerns that have been raised through stakeholder engagement, and how the organization has responded to those key topics and concerns, including through its reporting",null,null,null,null,null,null,null,{"$f":"Scoring!AR4","v":0}]
[null,"How many stakeholder complaints have been received in the past financial year and what percentage was satisfactorily resolved by the management?",null,null,null,null,null,null,null,{"$f":"Scoring!AZ4","v":0}]
[null,"Out of the above, has the company identified the disadvantaged, vulnerable & marginalized stakeholders. Are there any special initiatives taken by the company to engage with the disadvantaged, vulnerable and marginalized stakeholders.",null,null,null,null,null,null,null,{"$f":"Scoring!BE4","v":0}]
[null,"Is there any case filed by any stakeholder against the company regarding unfair trade practices, irresponsible advertising and/or anti-competitive behaviour during the last five years and pending as on end of financial year.",null,null,null,null,null,null,null,{"$f":"Scoring!BI4","v":0}]
[]
[null,null,"Disclosure","Details",null,null,null,"Score",null,null,"total",{"$f":"SUM(H34:H36)","v":0},{"$f":"L33/'Maximum scores'!G3","v":0},{"$f":"HLOOKUP($A$34,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.54545454545454541},"BELOW AVERAGE"]
["Marketing and ethical advertising","Programs for adherence to laws, standards, and voluntary codes related to marketing and voluntary codes related to marketing promotion, and sponsorship.",null,null,null,null,null,{"$f":"Scoring!BL4","v":0}]
[null,"Total number of incidents of non-compliance with regulations and voluntary codes concerning product and service information and labelling, by type of outcomes.",null,null,null,null,null,{"$f":"Scoring!BP4","v":0}]
[null,"Does the company display product information on the product label, over and above what is mandated as per local laws? Yes/No/N.A. /Remarks (additional information)",null,null,null,null,null,{"$f":"Scoring!BS4","v":0}]
[]
[null,null,"Disclosure","Details","Per","Related to","Score",null,null,null,"Total",{"$f":"SUM(G39:G40)","v":0},{"$f":"L38/'Maximum scores'!H3","v":0},{"$f":"HLOOKUP(A39,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.36363636363636365},"BELOW AVERAGE"]
["Child and forced labour","Is there a policy against child labor / forced labour in the supply chain / partners / contractors?",null,null,null,null,{"$f":"Scoring!BV4","v":0}]
[null,"Have there been any number of complaints relating to child labour, forced labour, involuntary labour, sexual harassment in the last financial year and pending, as on the end of the financial year.",null,null,null,null,{"$f":"Scoring!BZ4","v":0}]
[]
[null,null,"Disclosure","Details","Per","Related to","Score",null,null,null,"Total",{"$f":"SUM(G43:G45)","v":0},{"$f":"L42/'Maximum scores'!I3","v":0},{"$f":"HLOOKUP(A43,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.5},"BELOW AVERAGE"]
["Employee health, safety and wellness / Training and Development","Average hours of training per year per employee by employee category.",null,null,null,null,{"$f":"Scoring!CD4","v":0}]
[null,"What percentage of your under mentioned employees were given safety & skill up-gradation training in the last year?",null,null,null,null,{"$f":"Scoring!CH4","v":0}]
[null,"Rates of injury, occupational diseases, lost days, and absenteeism, and number of work-related fatalities",null,null,null,null,{"$f":"Scoring!CL4","v":0}]
[]
[null,null,"Disclosure","Details","Per","Related to","Score",null,null,null,"Total",{"$f":"SUM(G48:G49)","v":0},{"$f":"L47/'Maximum scores'!J3","v":0},{"$f":"HLOOKUP(A48,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.45454545454545453},"BELOW AVERAGE"]
["Customer satisfaction","What percentage of customer complaints/consumer cases are pending as on the end of financial year.",null,null,null,null,{"$f":"Scoring!CP4","v":0}]
[null,"Did your company carry out any consumer survey/ consumer satisfaction trends?",null,null,null,null,{"$f":"Scoring!CS4","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(G52:G54)","v":0},{"$f":"L50/'Maximum scores'!K3","v":0},{"$f":"HLOOKUP(A52,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.3},"BELOW AVERAGE"]
[null,null,"Disclosure","Details","Per","Related to","Score"]
["Regulatory and legal challenges","Monetary value of significant fines for noncompliance with laws and regulations concerning the provision and use of products and services.",null,null,null,null,{"$f":"Scoring!CW4","v":0}]
[null,"Number of show cause/ legal notices received from CPCB/SPCB which are pending (i.e. not resolved to satisfaction) as on end of Financial Year.",null,null,null,null,{"$f":"Scoring!DA4","v":0}]
[null,"Are there any court cases being reported?",null,null,null,null,{"$f":"Scoring!DE4","v":0}]
[]
[null,null,"Disclosure","Details","Per","Related to","Score",null,null,null,"Total",{"$f":"SUM(G57:G59)","v":0},{"$f":"L56/'Maximum scores'!L3","v":0},{"$f":"HLOOKUP(A57,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.125},"BELOW AVERAGE"]
["Labour relations and union practices","Health and safety topics covered in formal agreements with trade unions.",null,null,null,null,{"$f":"Scoring!DH4","v":0}]
[null,"Please indicate the total number of employees hired on temporary/ contractual/ casual basis",null,null,null,null,{"$f":"Scoring!DL4","v":0}]
[null,"What percentage of the permanent employees are members of formal employee association?",null,null,null,null,{"$f":"Scoring!DP4","v":0}]
[]
[null,null,"Disclosure","Details","Per","Related to","Score",null,null,null,"Total",{"$f":"SUM(G62:G67)","v":0},{"$f":"L61/'Maximum scores'!M3","v":0},{"$f":"HLOOKUP(A62,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.25757575757575757},"BELOW AVERAGE"]
["Supply chain standards and selection","Percentage and total # of significant suppliers and contractors that have undergone screening on human rights and actions taken.",null,null,null,null,{"$f":"Scoring!DT4","v":0}]
[null,"Total number of incidents of discrimination and actions taken.",null,null,null,null,{"$f":"Scoring!DX4","v":0}]
[null,"Does the company have procedures in place for sustainable sourcing (including transportation)? i. If yes, what percentage of your inputs was sourced sustainably?",null,null,null,null,{"$f":"Scoring!EB4","v":0}]
[null,"Has the company taken any steps to procure goods and services from local & small producers, including communities surrounding their place of work? If yes, what steps have been taken to improve their capacity and capability of local and small vendors?",null,null,null,null,{"$f":"Scoring!EF4","v":0}]
[null,"Does the policy of the company on human rights cover only the company or extend to the Group/ Joint Ventures/ Suppliers/ Contractors/ NGOs/Others?",null,null,null,null,{"$f":"Scoring!EI4","v":0}]
[null,"Does the policy related environment cover only the company or extends to the Group/ Joint Ventures/ Suppliers/ Contractors / NGOs/ others",null,null,null,null,{"$f":"Scoring!EL4","v":0}]
[]
[null,null,"Disclosure","Product A","Product B","Product C","Score",null,null,null,"Total",{"$f":"SUM(G70:G80)","v":0},{"$f":"L69/'Maximum scores'!N3","v":0},{"$f":"HLOOKUP(A70,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.38888888888888884},"BELOW AVERAGE"]
["Product life cycle impact","List up to 3 of your products or services whose design has incorporated social or environmental concerns, risks and/or opportunities.",null,null,null,null,{"$f":"Scoring!EO4","v":0}]
[null,"For each such product, provide the details in respect of resource use  per unit of product during sourcing/production/distribution throughout the value chain.",null,"Details","Per","Related to"]
[null,"Product A","Sourcing ",null,null,null,{"$f":"Scoring!FZ4","v":0}]
[null,null,"Production"]
[null,null,"Distribution"]
[null,"Product B","Sourcing "]
[null,null,"Production"]
[null,null,"Distribution"]
[null,"Product C","Sourcing "]
[null,null,"Production"]
[null,null,"Distribution"]
[]
[null,null,"Disclosure","Details","Details","Per","Related to","Score",null,null,"Total",{"$f":"SUM(H83)","v":0},{"$f":"L82/'Maximum scores'!O3","v":0},{"$f":"HLOOKUP(A83,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0},{"$f":"IF(L82>N82,\"ABOVE AVERAGE\",\"BELOW AVERAGE\")","v":"BELOW AVERAGE"}]
["Biodiversity impacts","Strategies, current actions, and future plans for managing impacts on biodiversity.",null,null,null,null,null,{"$f":"Scoring!GE4","v":0}]
[]
[null,null,"Disclosure","Details","Details","Per","Related to","Score",null,null,"Total",{"$f":"SUM(H86:H88)","v":0},{"$f":"L85/'Maximum scores'!P3","v":0},{"$f":"HLOOKUP(A86,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.4375},"BELOW AVERAGE"]
["Climate Change Risk","Does the company have strategies/ initiatives to address global environmental issues such as climate change, global warming, etc.? Y/N. If yes, please give hyperlink for webpage etc.",null,null,null,null,null,{"$f":"Scoring!GJ4","v":0}]
[null,"Does the company identify and assess potential environmental risks? Y/N",null,null,null,null,null,{"$f":"Scoring!GO4","v":0}]
[null,"Does the company have any project related to Clean Development Mechanism? If Yes, whether any environmental compliance report is filed?",null,null,null,null,null,{"$f":"Scoring!GT4","v":0}]
[]
[null,null,"Known","Number","Unit","Per","Relative to","Score",null,null,"Total",{"$f":"SUM(H91:H94)","v":0},{"$f":"L90/'Maximum scores'!Q3","v":0},{"$f":"HLOOKUP(A91,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.48},"BELOW AVERAGE"]
["Energy Management","Total energy consumed by the business entity for its operations",null,null,null,null,null,{"$f":"Scoring!GY4","v":0}]
[null,"Use of energy saving processes and the total energy saved due to use of such processes",null,null,null,null,null,{"$f":"Scoring!HD4","v":0}]
[null,"Use of renewable energy ",null,null,null,null,null,{"$f":"Scoring!HI4","v":0}]
[null,"Has the company undertaken any other initiatives on – clean technology, energy efficiency, renewable energy, etc. Y/N. If yes, please give hyperlink for web page etc.",null,null,null,null,null,{"$f":"Scoring!HM4","v":0}]
[]
[null,null,"Known","Number","Tons of","Per","Relative to","Score",null,null,"Total",{"$f":"SUM(H97:H99)","v":0},{"$f":"L96/'Maximum scores'!R3","v":0},{"$f":"HLOOKUP(A97,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["GHG emissions and air pollution","Total direct and indirect greenhouse gas emissions by weight.",null,null,null,null,null,{"$f":"Scoring!HQ4","v":0}]
[null,"Emissions of ozone-depleting substances by weight",null,null,null,null,null,{"$f":"Scoring!HU4","v":0}]
[null,"NO, SO, and other significant air emissions by type and weight.",null,null,null,null,null,{"$f":"Scoring!HY4","v":0}]
[]
[null,null,"Disclosure","Detail","Detail","Amount","Per","Relative to","Score",null,"Total",{"$f":"SUM(I102:I109)","v":0},{"$f":"Summary!L101/'Maximum scores'!S3","v":0},{"$f":"HLOOKUP(A102,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.36956521739130432},"BELOW AVERAGE"]
["Waste management and effluents","Statement on discharge of water and effluents indicating the treatment done before discharge and the destination of disposal",null,null,null,null,null,null,{"$f":"Scoring!IE4","v":0}]
[null,"Total weight of waste by type and disposal method",null,null,null,null,null,null,{"$f":"Scoring!IR4","v":0}]
[null,"Total weight of waste by type and disposal method"]
[null,"Amount of hazardous waste created by the organization's operations during the reporting period. Note: hazardous waste as defined by national legislation at the point of generation.",null,null,null,null,null,null,{"$f":"Scoring!IV4","v":0}]
[null,"Amount of non-hazardous waste created by the organization's operations during the reporting period.",null,null,null,null,null,null,{"$f":"Scoring!IZ4","v":0}]
[null,"Waste reductions achieved during the reporting period through programs for substitution, recycling or recovery.",null,null,null,null,null,null,{"$f":"Scoring!JD4","v":0}]
[null,"Does the company have a mechanism to recycle products and waste? If yes what is the percentage of recycling of products and waste",null,null,null,null,null,null,{"$f":"Scoring!JH4","v":0}]
[null,"Are the Emissions/Waste generated by the company within the permissible limits given by CPCB/SPCB for the financial year being reported?",null,null,null,null,null,null,{"$f":"Scoring!JK4","v":0}]
["Water Management","Water sources significantly affected by withdrawal of water.",null,null,null,null,null,null,{"$f":"Scoring!JN4","v":0},null,"Total",{"$f":"SUM(I110:I112)","v":0},{"$f":"L110/'Maximum scores'!T3","v":0},{"$f":"HLOOKUP(A110,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.54545454545454541},{"$f":"IF(L110>N110,\"ABOVE AVERAGE\",\"BELOW AVERAGE\")","v":"BELOW AVERAGE"}]
[null,"Total water consumed ",null,null,null,null,null,null,{"$f":"Scoring!JW4","v":0}]
[null,"Percentage of water that is recycled and reused"]
["Environmental expenditure","Total environmental protection expenditures and investments by type.",null,null,null,null,null,null,{"$f":"Scoring!KF4","v":0}]
[null,"Total environmental protection expenditures and investments by type.",null,null,null,null,null,null,null,null,"Total",{"$f":"I113","v":0},{"$f":"L114/'Maximum scores'!U3","v":0},{"$f":"HLOOKUP(A113,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.3},{"$f":"IF(L114>N114,\"ABOVE AVERAGE\",\"BELOW AVERAGE\")","v":"BELOW AVERAGE"}]
[]
[null,null,"Disclosure","Details","Score",null,null,"Total",{"$f":"SUM(E117:E118)","v":0}]
["Community development","Details of community investment and development work undertaken indicating the financial resources deployed and the impact of this work with a longer term perspective"]
[null,"Details of innovative practices, products and services that particularly enhance access and allocation of resources to the poor and the marginalized groups of the society"]
[]
[null,null,"Disclosure","Details","Score",null,null,null,null,null,"total",{"$f":"SUM(E121:E122)","v":0},{"$f":"L120/'Maximum scores'!V3","v":0},{"$f":"HLOOKUP(A121,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.25},"BELOW AVERAGE"]
["Political and lobbying","Public policy positions and participation in public policy development and lobbying."]
[null,"Total value of financial and in-kind contributions to political parties, politicians, and related institutions by country."]
[]
[null,null,"Disclosure","Detail","Per","Relative to","Score",null,null,null,"Total",{"$f":"SUM(G125:G128)+I116","v":0},{"$f":"L124/'Maximum scores'!W3","v":0},{"$f":"HLOOKUP(A125,Averages!$B$1:$W$18,Summary!$N$5,FALSE)","v":0.625},"BELOW AVERAGE"]
["Community Developemnt ","Does the company have specified programmes/initiatives/projects in pursuit of the policy related to CSR? If yes details thereof.",null,null,null,null,{"$f":"Scoring!KU4","v":0}]
[null,"Are the programmes/projects undertaken through in-house team/own foundation/external NGO/government structures/any other organization?",null,null,null,null,{"$f":"Scoring!KW4","v":0}]
[null,"What is your company’s direct contribution to community development projects- Amount in INR and the details of the projects undertaken.",null,null,null,null,{"$f":"Scoring!LA4","v":0}]
[null,"Have you taken steps to ensure that this community development initiative is successfully adopted by the community? Please explain in 50 words, or so.",null,null,null,null,{"$f":"Scoring!LD4","v":0}]

{"sheet":"Scoring","index":5,"n_rows":4,"n_cols":316,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,225,1,228],[1,229,1,232],[0,221,0,232],[1,187,1,191],[1,192,1,196],[1,197,1,201],[0,187,0,201],[1,221,1,224],[1,202,1,206],[0,202,0,220],[1,207,1,211],[1,212,1,216],[1,217,1,220],[1,142,1,144],[1,145,1,181],[0,142,0,181],[1,182,1,186],[0,182,0,186],[1,7,1,8],[1,12,1,13],[1,9,1,11],[1,71,1,73],[1,61,1,63],[1,64,1,67],[1,68,1,70],[1,57,1,60],[0,37,0,60],[0,61,0,70],[1,0,1,3],[1,37,1,39],[1,40,1,43],[1,44,1,51],[1,52,1,56],[1,34,1,36],[1,14,1,17],[1,18,1,21],[1,22,1,24],[1,25,1,27],[1,28,1,30],[1,31,1,33],[0,4,0,13],[1,4,1,6],[0,71,0,77],[1,78,1,81],[1,82,1,85],[1,86,1,89],[0,78,0,89],[1,74,1,77],[1,90,1,93],[1,94,1,96],[0,90,0,96],[1,97,1,100],[1,101,1,104],[1,105,1,108],[0,97,0,108],[1,109,1,111],[1,112,1,115],[1,116,1,119],[0,109,0,119],[1,139,1,141],[0,120,0,141],[1,120,1,123],[1,124,1,127],[1,128,1,131],[1,132,1,135],[1,136,1,138],[1,233,1,238],[1,239,1,251],[1,252,1,255],[1,256,1,259],[0,252,0,259],[1,260,1,263],[1,264,1,267],[1,268,1,270],[1,271,1,273],[1,274,1,282],[1,283,1,291],[1,292,1,294],[1,295,1,297],[1,298,1,300],[1,301,1,303],[0,298,0,303],[1,304,1,306],[1,307,1,308],[1,309,1,312],[0,304,0,315],[1,313,1,315]]}
[null,null,null,null,"Board structure and independence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Communication and engagement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marketing and ethical advertising",null,null,null,null,null,null,null,null,null,"Child and forced labour",null,null,null,null,null,null,"Employee health, safety and wellness/ training and development",null,null,null,null,null,null,null,null,null,null,null,"Customer Satisfaction",null,null,null,null,null,null,"Regulatory and legal challenges",null,null,null,null,null,null,null,null,null,null,null,"Labour relations and union practices",null,null,null,null,null,null,null,null,null,null,"Supply chain standards and selection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product life cycle use impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biodiversity impacts",null,null,null,null,"Climate change risk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHG emissions and air pollution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lobbying and political contributions",null,null,null,null,null,"Community development"]
["Disclosure and labeling",null,null,null,"Details on composition of the board",null,null,"Details about frequency with which the board / bord committee and chief executive meet",null,"Is there a person responsible for the sustainability disclosure",null,null,"Details on the frequency with which the sustainability performance is reviewed",null,"Indicate whether the organization has a written code of ethics that has been communicated to employees.",null,null,null,"Does the policy relating to ethics, bribery and corruption cover only the company? Yes/ No. Does it extend to the Group/Joint Ventures/ Suppliers/Contractors/NGOs /Others?",null,null,null,"Externally developed economic, environmental, and social charters, principles, or other initiatives to which the organization subscribes or endorses.",null,null,"Has the policy been formally communicated to all relevant internal and external stakeholders?",null,null,"Does the company have in-house structure to implement the policy/policies.",null,null,"Does the Company have a grievance redressal mechanism related to the policy/policies to address stakeholders’ grievances related to the policy/policies?",null,null,"Has the company carried out independent 3  audit/evaluation of the working of this policy by an internal or external agency?",null,null,"List of stakeholder groups engaged by the organization",null,null,"What are the key topics / issues for stakeholder consultations",null,null,null,"How many stakeholder complaints have been received in the past financial year and what percentage was satisfactorily resolved by the management?",null,null,null,null,null,null,null,"Out of the above, has the company identified the disadvantaged, vulnerable & marginalized stakeholders. Are there any special initiatives taken by the company to engage ",null,null,null,null,"Is there any case filed by any stakeholder against the company regarding unfair trade practices, irresponsible advertising and/or anti-competitive behaviour during the last five years and pending as on end of financial year.",null,null,null,"Programs for adherence to laws, standards, and voluntary codes related to marketing and voluntary codes related to marketing promotion, and sponsorship.",null,null,"Total number of incidents of non-compliance with regulations and voluntary codes concerning product and service information and labelling, by type of outcomes.",null,null,null,"Does the company display product information on the product label, over and above what is mandated as per local laws? Yes/No/N.A. /Remarks (additional information)",null,null,"Is there a policy against child labor / forced labour in the supply chain / partners / contractors?",null,null,"Have there been any number of complaints relating to child labour, forced labour, involuntary labour, sexual harassment in the last financial year and pending, as on the end of the financial year.",null,null,null,"Average hours of training per year per employee by employee category.",null,null,null,"How many of your employees were given safety & skill up-gradation training in the last year?",null,null,null,"Rates of injury, occupational diseases, lost days, and absenteeism, and number of work-related fatalities",null,null,null,"What percentage of customer complaints/consumer cases are pending as on the end of financial year.",null,null,null,"Did your company carry out any consumer survey/ consumer satisfaction trends?",null,null,"Monetary value of significant fines for noncompliance with laws and regulations concerning the provision and use of products and services.",null,null,null,"Number of show cause/ legal notices received from CPCB/SPCB which are pending (i.e. not resolved to satisfaction) as on end of Financial Year.",null,null,null,"Are there any court cases being reported?",null,null,null,"Health and safety topics covered in formal agreements with trade unions.",null,null,"Please indicate the total number of employees hired on temporary/ contractual/ casual basis",null,null,null,"What percentage of the permanent employees are members of formal employee association?",null,null,null,"Percentage and total # of significant suppliers and contractors that have undergone screening on human rights and actions taken.",null,null,null,"Total number of incidents of discrimination and actions taken.",null,null,null,"Does the company have procedures in place for sustainable sourcing (including transportation)? i. If yes, what percentage of your inputs was sourced sustainably?",null,null,null,"Has the company taken any steps to procure goods and services from local & small producers, including communities surrounding their place of work? If yes, what steps have been taken to improve their capacity and capability of local and small vendors?",null,null,null,"Does the policy of the company on human rights cover only the company or extend to the Group/ Joint Ventures/ Suppliers/ Contractors/ NGOs/Others?",null,null,"Does the policy related environment cover only the company or extends to the Group/ Joint Ventures/ Suppliers/ Contractors / NGOs/ others",null,null,"List up to 3 of your products or services whose design has incorporated social or environmental concerns, risks and/or opportunities.",null,null,"For each such product, provide the details in respect of resource use  per unit of product during sourcing/production/distribution throughout the value chain.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strategies, current actions, and future plans for managing impacts on biodiversity.",null,null,null,null,"Does the company have strategies/ initiatives to address global environmental issues such as climate change, global warming, etc.? Y/N. If yes, please give hyperlink for webpage etc.",null,null,null,null,"Does the company identify and assess potential environmental risks? Y/N",null,null,null,null,"Does the company have any project related to Clean Development Mechanism? If Yes, whether any environmental compliance report is filed?",null,null,null,null,"Total energy consumed ",null,null,null,null,"Statement on use of energy saving processes and the total energy saved due to use of such processes",null,null,null,null,"Use of renewable energy as percentage of total energy consumption",null,null,null,null,"Has the company undertaken any other initiatives on – clean technology, energy efficiency, renewable energy, etc. Y/N. If yes, please give hyperlink for web page etc.",null,null,null,"Total direct and indirect greenhouse gas emissions by weight.",null,null,null,"Emissions of ozone-depleting substances by weight",null,null,null,"NO, SO, and other significant air emissions by type and weight.",null,null,null,"Statement on discharge of water and effluents indicating the treatment done before discharge and the destination of disposal",null,null,null,null,null,"Total weight of waste by type and disposal method",null,null,null,null,null,null,null,null,null,null,null,null,"Amount of hazardous waste created by the organization's operations during the reporting period. Note: hazardous waste as defined by national legislation at the point of generation.",null,null,null,"Amount of non-hazardous waste created by the organization's operations during the reporting period.",null,null,null,"Waste reductions achieved during the reporting period through programs for substitution, recycling or recovery.",null,null,null,"Does the company have a mechanism to recycle products and waste? If yes what is the percentage of recycling of products and waste",null,null,null,"Are the Emissions/Waste generated by the company within the permissible limits given by CPCB/SPCB for the financial year being reported?",null,null,"Water sources significantly affected by withdrawal of water.",null,null,"Total water consumed and the percentage of water that is recycled and reused",null,null,null,null,null,null,null,null,"Total environmental protection expenditures and investments by type.",null,null,null,null,null,null,null,null,"Details of community investment and development work undertaken indicating the financial resources deployed and the impact of this work with a longer term perspective",null,null,"Details of innovative practices, products and services that particularly enhance access and allocation of resources to the poor and the marginalized groups of the society",null,null,"Public policy positions and participation in public policy development and lobbying.",null,null,"Total value of financial and in-kind contributions to political parties, politicians, and related institutions by country.",null,null,"Does the company have specified programmes/initiatives/projects in pursuit of the policy related to CSR? If yes details thereof.",null,null,"Are the programmes/projects undertaken through in-house team/own foundation/external NGO/government structures/any other organization?",null,"What is your company’s direct contribution to community development projects- Amount in INR and the details of the projects undertaken.",null,null,null,"Have you taken steps to ensure that this community development initiative is successfully adopted by the community? Please explain in 50 words, or so."]
["Disclosure and labeling","Details","Frequency","Score","Disclosure","Number of non executive directors","Score",null,"Score","Detail","Disclosure","Score",null,"Score","Disclosure","Shared","Details","Score","Disclosure","Shared","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure 1 ","Disclosure 2","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure 1 ","Disclosure 2","Details 1","Details 2","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Score","Disclosure","Details",null,"Score","Disclosure","Details",null,"Score","Disclosure","Details",null,"Score","Disclosure","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Details",null,"Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Final","Disclosure","Details","Per","Relative to","Score","Disclosure","Details","Per","Relative to","Score","Disclosure","Details","Per","Relative to","Score","Disclosure","Details","Per","Relative to","Score","Disclosure",null,"Per","Relative to","Score","Disclosure",null,"Per","Relative to","Score","Disclosure",null,"Per","Relative to","Score","Disclosure","Detail",null,"Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Details","Per","Relative to","Score","Disclosure","Details","Details","Per","Relative to","Score","Disclosure","Details","Details","Per","Relative to","Score","Final score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Final score","Disclosure","Per","Relative to","Score","Disclosure","Per","Relative to","Score","Final score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Details","Score","Disclosure","Score","Disclosure","Per","Relative to","Score","Disclosure","Details","Score"]
[{"$f":"IF(ISBLANK(Summary!C9)=TRUE,0,IF(Summary!C9=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(ISBLANK(Summary!E9)=TRUE,0,IF(Summary!E9=Environment!$C$4,0,IF(Summary!E9=Environment!$C$1,0.25,IF(ISBLANK(Summary!F9)=TRUE,0,IF(ISTEXT(Summary!F9)=TRUE,0,0.5)))))","v":0},{"$f":"SUM(A4:C4)","v":0},{"$f":"IF(ISBLANK(Summary!C12)=TRUE,0,IF(Summary!C12=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D12)=TRUE,0,0.25)","v":0},{"$f":"SUM(E4:F4)","v":0},{"$f":"Summary!D13","v":0},{"$f":"IF(Summary!E13=Environment!$C$4,0,IF(Summary!E13=Environment!$C$1,0.25,IF(ISBLANK(Summary!D13)=TRUE,0,IF(ISTEXT(Summary!D13)=TRUE,0,0.5))))","v":0},{"$f":"IF(ISBLANK(Summary!C14)=TRUE,0,IF(Summary!C14=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(Summary!C14=Environment!$B$1,IF(COUNTA(Summary!D14:'Summary'!E14)=0,0,0.25),0)","v":0},{"$f":"SUM(J4:K4)","v":0},{"$f":"Summary!D15","v":0},{"$f":"IF(Summary!E15=Environment!$C$4,0,IF(Summary!E15=Environment!$C$1,0.25,IF(ISBLANK(Summary!D15)=TRUE,0,IF(ISTEXT(Summary!D15)=TRUE,0,0.5))))","v":0},{"$f":"IF(ISBLANK(Summary!C18)=TRUE,0,IF(Summary!C18=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D18)=TRUE,0,(IF(Summary!D18=Environment!$B$3,0,0.25)))","v":0},{"$f":"IF(ISBLANK(Summary!E18)=TRUE,0,0.5)","v":0},{"$f":"SUM(O4:Q4)","v":0},{"$f":"IF(ISBLANK(Summary!C19)=TRUE,0,IF(Summary!C19=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(S4=0,0,IF(ISBLANK(Summary!D19)=TRUE,0,IF(Summary!D19=Environment!$B$3,0,0.25)))","v":0},{"$f":"IF(ISBLANK(Summary!E19)=TRUE,0,0.5)","v":0},{"$f":"SUM(S4:U4)","v":0},{"$f":"IF(ISBLANK(Summary!C20)=TRUE,0,IF(Summary!C20=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E20)=TRUE,0,0.25)","v":0},{"$f":"SUM(W4:X4)","v":0},{"$f":"IF(ISBLANK(Summary!C21)=TRUE,0,IF(Summary!C21=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E21)=TRUE,0,0.25)","v":0},{"$f":"SUM(Z4:AA4)","v":0},{"$f":"IF(ISBLANK(Summary!C22)=TRUE, 0,IF(Summary!C22=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E22)=TRUE,0,0.25)","v":0},{"$f":"SUM(AC4:AD4)","v":0},{"$f":"IF(ISBLANK(Summary!C23)=TRUE,0,IF(Summary!C23=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E23)=TRUE,0,0.25)","v":0},{"$f":"SUM(AF4:AG4)","v":0},{"$f":"IF(ISBLANK(Summary!C24)=TRUE,0,IF(Summary!C24=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E24)=TRUE,0,0.25)","v":0},{"$f":"SUM(AI4:AJ4)","v":0},{"$f":"IF(ISBLANK(Summary!C27)=TRUE,0,IF(Summary!C27=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D27)=TRUE,0,0.25)","v":0},{"$f":"SUM(AL4:AM4)","v":0},{"$f":"IF(ISBLANK(Summary!C28)=TRUE,0,IF(Summary!C28=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(ISBLANK(Summary!D28)=TRUE,0,IF(Summary!D28=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E28)=TRUE,0,0.25)","v":0},{"$f":"SUM(AO4:AQ4)","v":0},{"$f":"IF(Summary!C29=Environment!$B$3,0,IF(ISBLANK(Summary!D29)=TRUE,0,IF(ISTEXT(Summary!D29)=TRUE,0,0.5)))","v":0},{"$f":"IF(AS4=0,0,IF(ISBLANK(Summary!E29)=TRUE,0,IF(Summary!E29=Environment!$E$7,0,IF(Summary!E29=Environment!$E$6,1.25,IF(Summary!E29=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(AS4=0,0,IF(ISBLANK(Summary!F29)=TRUE,0,IF(Summary!F29=Environment!$E$7,0,1)*IF(AT4=0.75,1.5,IF(AT4=1.25,1.75,1))))","v":0},{"$f":"MAX(AS4,AT4,AU4)","v":0},{"$f":"IF(ISBLANK(Summary!G29)=TRUE,0,IF(ISTEXT(Summary!G29)=TRUE,0,0.5))","v":0},null,{"$f":"IF(AW4=0,0,IF(ISBLANK(Summary!I29)=TRUE,0,IF(Summary!I29=Environment!$E$7,0,1.5)))","v":0},{"$f":"MAX(AW4,AX4,AY4)+AV4","v":0},{"$f":"IF(ISBLANK(Summary!C30)=TRUE,0,IF(Summary!C30=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(ISBLANK(Summary!D30)=TRUE,0,IF(Summary!D30=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E30)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(BA4:BD4)","v":0},{"$f":"IF(ISBLANK(Summary!C31)=TRUE,0,IF(Summary!C31=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(BF4=0,0,IF(ISBLANK(Summary!D31)=TRUE,0,IF(Summary!E31=Environment!$E$7,0,IF(Summary!E31=Environment!$E$6,1.25,IF(Summary!E31=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(BF4=0,0,IF(ISBLANK(Summary!F31)=TRUE,0,IF(Summary!F31=Environment!$E$7,0,1)*IF(BG4=0.75,1.5,IF(BG4=1.25,1.75,1))))","v":0},{"$f":"MAX(BF4,BG4,BH4)","v":0},{"$f":"IF(ISBLANK(Summary!C34)=TRUE,0,IF(Summary!C34=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D34)=TRUE,0,0.25)","v":0},{"$f":"SUM(BJ4:BK4)","v":0},{"$f":"IF(ISBLANK(Summary!C35)=TRUE,0,IF(Summary!C35=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(BM4=0,0,IF(ISBLANK(Summary!E35)=TRUE,0,IF(Summary!E35=Environment!$E$7,0,IF(Summary!E35=Environment!$E$6,1.25,IF(Summary!E35=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(BM4=0,0,IF(ISBLANK(Summary!F35)=TRUE,0,IF(Summary!F35=Environment!$E$7,0,1)*IF(BN4=0.75,1.5,IF(BN4=1.25,1.75,1))))","v":0},{"$f":"MAX(BM4,BN4,BO4)","v":0},{"$f":"IF(ISBLANK(Summary!C36)=TRUE,0,IF(Summary!C36=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D36)=TRUE,0,0.25)","v":0},{"$f":"SUM(BQ4:BR4)","v":0},{"$f":"IF(ISBLANK(Summary!C39)=TRUE,0,IF(Summary!C39=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D39)=TRUE,0,0.25)","v":0},{"$f":"SUM(BT4:BU4)","v":0},{"$f":"IF(ISBLANK(Summary!C40)=TRUE,0,IF(Summary!C40=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(BW4=0,0,IF(ISBLANK(Summary!D40)=TRUE,0,IF(Summary!E40=Environment!$E$7,0,IF(Summary!E40=Environment!$E$6,1.25,IF(Summary!E40=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(BW4=0,0,IF(ISBLANK(Summary!F40)=TRUE,0,IF(Summary!F40=Environment!$E$7,0,1)*IF(BX4=0.75,1.5,IF(BX4=1.25,1.75,1))))","v":0},{"$f":"MAX(BW4,BX4,BY4)","v":0},{"$f":"IF(ISBLANK(Summary!C43)=TRUE,0,IF(Summary!C43=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(CA4=0,0,IF(ISBLANK(Summary!D43)=TRUE,0,IF(Summary!E43=Environment!$E$7,0,IF(Summary!E43=Environment!$E$6,1.25,IF(Summary!E43=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(CA4=0,0,IF(ISBLANK(Summary!F43)=TRUE,0,IF(Summary!F43=Environment!$E$7,0,1)*IF(CB4=0.75,1.5,IF(CB4=1.25,1.75,1))))","v":0},{"$f":"MAX(CA4,CB4,CC4)","v":0},{"$f":"IF(ISBLANK(Summary!C44)=TRUE,0,IF(Summary!C44=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(CE4=0,0,IF(ISBLANK(Summary!D44)=TRUE,0,IF(Summary!E44=Environment!$E$7,0,IF(Summary!E44=Environment!$E$6,1.25,IF(Summary!E44=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(CE4=0,0,IF(ISBLANK(Summary!F44)=TRUE,0,IF(Summary!F44=Environment!$E$7,0,1)*IF(CF4=0.75,1.5,IF(CF4=1.25,1.75,1))))","v":0},{"$f":"MAX(CE4,CF4,CG4)","v":0},{"$f":"IF(ISBLANK(Summary!C45)=TRUE,0,IF(Summary!C45=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(CI4=0,0,IF(ISBLANK(Summary!D45)=TRUE,0,IF(Summary!E45=Environment!$E$7,0,IF(Summary!E45=Environment!$E$6,1.25,IF(Summary!E45=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(CI4=0,0,IF(ISBLANK(Summary!F45)=TRUE,0,IF(Summary!F45=Environment!$E$7,0,1)*IF(CJ4=0.75,1.5,IF(CJ4=1.25,1.75,1))))","v":0},{"$f":"MAX(CI4,CJ4,CK4)","v":0},{"$f":"IF(ISBLANK(Summary!C48)=TRUE,0,IF(Summary!C48=Environment!$B$3,0,0.75))","v":0},null,{"$f":"IF(CM4=0,0,IF(ISBLANK(Summary!D48)=TRUE,0,IF(Summary!F48=Environment!$E$7,0,1.5)))","v":0},{"$f":"MAX(CM4,CO4)","v":0},{"$f":"IF(ISBLANK(Summary!C49)=TRUE,0,IF(Summary!C49=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D49)=TRUE,0,0.25)","v":0},{"$f":"SUM(CQ4:CR4)","v":0},{"$f":"IF(ISBLANK(Summary!C52)=TRUE,0,IF(Summary!C52=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D52)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(CT4:CU4)","v":0},{"$f":"IF(ISBLANK(Summary!C53)=TRUE,0,IF(Summary!C53=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D53)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(CX4:CY4)","v":0},{"$f":"IF(ISBLANK(Summary!C54)=TRUE,0,IF(Summary!C54=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D54)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(DB4:DC4)","v":0},{"$f":"IF(ISBLANK(Summary!C57)=TRUE,0,IF(Summary!C57=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D57)=TRUE,0,0.25)","v":0},{"$f":"SUM(DF4:DG4)","v":0},{"$f":"IF(ISBLANK(Summary!C58)=TRUE,0,IF(Summary!C58=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(DI4=0,0,IF(ISBLANK(Summary!D58)=TRUE,0,IF(Summary!E58=Environment!$E$7,0,IF(Summary!E58=Environment!$E$6,1.25,IF(Summary!E58=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(DI4=0,0,IF(ISBLANK(Summary!F58)=TRUE,0,IF(Summary!F58=Environment!$E$7,0,1)*IF(DJ4=0.75,1.5,IF(DJ4=1.25,1.75,1))))","v":0},{"$f":"MAX(DI4,DJ4,DK4)","v":0},{"$f":"IF(ISBLANK(Summary!C59)=TRUE,0,IF(Summary!C59=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(DM4=0,0,IF(ISBLANK(Summary!F59)=TRUE,0,IF(Summary!F59=Environment!$E$7,0,1.5)))","v":0},{"$f":"MAX(DM4,DO4)","v":0},{"$f":"IF(ISBLANK(Summary!C62)=TRUE,0,IF(Summary!C62=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(DQ4=0,0,IF(ISBLANK(Summary!D62)=TRUE,0,IF(Summary!E62=Environment!$E$7,0,IF(Summary!E62=Environment!$E$6,1.25,IF(Summary!E62=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(DQ4=0,0,IF(ISBLANK(Summary!F62)=TRUE,0,IF(Summary!F62=Environment!$E$7,0,1)*IF(DR4=0.75,1.5,IF(DR4=1.25,1.75,1))))","v":0},{"$f":"MAX(DQ4,DR4,DS4)","v":0},{"$f":"IF(ISBLANK(Summary!C63)=TRUE,0,IF(Summary!C63=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(DU4=0,0,IF(ISBLANK(Summary!D63)=TRUE,0,IF(Summary!E63=Environment!$E$7,0,IF(Summary!E63=Environment!$E$6,1.25,IF(Summary!E63=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(DU4=0,0,IF(ISBLANK(Summary!F63)=TRUE,0,IF(Summary!F63=Environment!$E$7,0,1)*IF(DV4=0.75,1.5,IF(DV4=1.25,1.75,1))))","v":0},{"$f":"MAX(DU4,DV4,DW4)","v":0},{"$f":"IF(ISBLANK(Summary!C64)=TRUE,0,IF(Summary!C64=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(DY4=0,0,IF(ISBLANK(Summary!D64)=TRUE,0,IF(Summary!F64=Environment!$E$7,0,1.5)))","v":0},{"$f":"MAX(DY4,EA4)","v":0},{"$f":"IF(ISBLANK(Summary!C65)=TRUE,0,IF(Summary!C65=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(ISBLANK(Summary!D65)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(EC4:ED4)","v":0},{"$f":"IF(ISBLANK(Summary!C66)=TRUE,0,IF(Summary!C66=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D66)=TRUE,0,0.25)","v":0},{"$f":"SUM(EG4,EH4)","v":0},{"$f":"IF(ISBLANK(Summary!C67)=TRUE,0,IF(Summary!C67=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D67)=TRUE,0,0.25)","v":0},{"$f":"SUM(EJ4,EK4)","v":0},{"$f":"IF(ISBLANK(Summary!C70)=TRUE,0,IF(Summary!C70=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(COUNTA(Summary!D70:F70)=0,0,0.25)","v":0},{"$f":"SUM(EM4:EN4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E72)=TRUE,0,(IF(Summary!E72=Environment!$E$7,0,IF(Summary!E72=Environment!$E$6,1.25,IF(Summary!E72=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(ISBLANK(Summary!F72)=TRUE,0,(IF(Summary!F72=Environment!$E$7,0,1)*IF(EQ4=0.75,1.5,IF(EQ4=1.25,1.75,1))))","v":0},{"$f":"MAX(EQ4,ER4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E73)=TRUE,0,IF(Summary!E73=Environment!$E$7,0,IF(Summary!E73=Environment!$E$6,1.25,IF(Summary!E73=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F73)=TRUE,0,IF(Summary!F73=Environment!$E$7,0,1)*IF(EU4=0.75,1.5,IF(EU4=1.25,1.75,1)))","v":0},{"$f":"MAX(EU4,EV4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E74)=TRUE,0,IF(Summary!E74=Environment!$E$7,0,IF(Summary!E74=Environment!$E$6,1.25,IF(Summary!E74=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F74)=TRUE,0,IF(Summary!F74=Environment!$E$7,0,1)*IF(EY4=0.75,1.5,IF(EY4=1.25,1.75,1)))","v":0},{"$f":"MAX(EY4,EZ4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E75)=TRUE,0,IF(Summary!E75=Environment!$E$7,0,IF(Summary!E75=Environment!$E$6,1.25,IF(Summary!E75=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F75)=TRUE,0,IF(Summary!F75=Environment!$E$7,0,1)*IF(FC4=0.75,1.5,IF(FC4=1.25,1.75,1)))","v":0},{"$f":"MAX(FC4,FD4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E76)=TRUE,0,IF(Summary!E76=Environment!$E$7,0,IF(Summary!E76=Environment!$E$6,1.25,IF(Summary!E76=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F76)=TRUE,0,IF(Summary!F76=Environment!$E$7,0,1)*IF(FG4=0.75,1.5,IF(FG4=1.25,1.75,1)))","v":0},{"$f":"MAX(FG4,FH4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E77)=TRUE,0,IF(Summary!E77=Environment!$E$7,0,IF(Summary!E77=Environment!$E$6,1.25,IF(Summary!E77=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F77)=TRUE,0,IF(Summary!F77=Environment!$E$7,0,1)*IF(FK4=0.75,1.5,IF(FK4=1.25,1.75,1)))","v":0},{"$f":"MAX(FK4,FL4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E78)=TRUE,0,IF(Summary!E78=Environment!$E$7,0,IF(Summary!E78=Environment!$E$6,1.25,IF(Summary!E78=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F78)=TRUE,0,IF(Summary!F78=Environment!$E$7,0,1)*IF(FO4=0.75,1.5,IF(FO4=1.25,1.75,1)))","v":0},{"$f":"MAX(FO4,FP4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E79)=TRUE,0,IF(Summary!E79=Environment!$E$7,0,IF(Summary!E79=Environment!$E$6,1.25,IF(Summary!E79=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F79)=TRUE,0,IF(Summary!F79=Environment!$E$7,0,1)*IF(FS4=0.75,1.5,IF(FS4=1.25,1.75,1)))","v":0},{"$f":"MAX(FS4,FT4)","v":0},null,{"$f":"IF(ISBLANK(Summary!E80)=TRUE,0,IF(Summary!E80=Environment!$E$7,0,IF(Summary!E80=Environment!$E$6,1.25,IF(Summary!E80=Environment!$E$5,1.25,0.75))))","v":0},{"$f":"IF(ISBLANK(Summary!F80)=TRUE,0,IF(Summary!F80=Environment!$E$7,0,1)*IF(FW4=0.75,1.5,IF(FW4=1.25,1.75,1)))","v":0},{"$f":"MAX(FW4,FX4)","v":0},{"$f":"SUM(ES4,EW4,FA4,FE4,FI4,FM4,FQ4,FU4,FY4)","v":0},{"$f":"IF(ISBLANK(Summary!C83)=TRUE,0,IF(Summary!C83=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D83)=TRUE,0,0.25)","v":0},null,null,{"$f":"SUM(GA4:GB4)","v":0},{"$f":"IF(ISBLANK(Summary!C86)=TRUE,0,IF(Summary!C86=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!E86)=TRUE,0,0.25)","v":0},null,null,{"$f":"SUM(GF4:GG4)","v":0},{"$f":"IF(ISBLANK(Summary!C87)=TRUE,0,IF(Summary!C87=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D87)=TRUE,0,0.25)","v":0},null,null,{"$f":"SUM(GK4:GL4)","v":0},{"$f":"IF(ISBLANK(Summary!C88)=TRUE,0,IF(Summary!C88=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D88)=TRUE,0,0.25)","v":0},null,null,{"$f":"SUM(GP4:GQ4)","v":0},{"$f":"IF(ISBLANK(Summary!C91)=TRUE,0,IF(Summary!C91=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(GU4=0,0,IF(ISBLANK(Summary!D91)=TRUE,0,IF(Summary!F91=Environment!$E$7,0,IF(Summary!F91=Environment!$E$6,1.25,IF(Summary!F91=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(GU4=0,0,IF(ISBLANK(Summary!G91)=TRUE,0,IF(Summary!GU91=Environment!$E$7,0,1)*IF(GW4=0.75,1.5,IF(GW4=1.25,1.75,1))))","v":0},{"$f":"MAX(GU4,GW4,GX4)","v":0},{"$f":"IF(ISBLANK(Summary!C92)=TRUE,0,IF(Summary!C92=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(GZ4=0,0,IF(ISBLANK(Summary!D92)=TRUE,0,IF(Summary!F92=Environment!$E$7,0,IF(Summary!F92=Environment!$E$6,1.25,IF(Summary!F92=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(GZ4=0,0,IF(ISBLANK(Summary!G92)=TRUE,0,IF(Summary!GU92=Environment!$E$7,0,1)*IF(HB4=0.75,1.5,IF(HB4=1.25,1.75,1))))","v":0},{"$f":"MAX(GZ4,HB4,HC4)","v":0},{"$f":"IF(ISBLANK(Summary!C93)=TRUE,0,IF(Summary!C93=Environment!$B$3,0,0.5))","v":0},null,{"$f":"IF(HE4=0,0,IF(ISBLANK(Summary!D93)=TRUE,0,IF(Summary!F93=Environment!$E$7,0,IF(Summary!F93=Environment!$E$6,1.25,IF(Summary!F93=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(HE4=0,0,IF(ISBLANK(Summary!G93)=TRUE,0,IF(Summary!GU93=Environment!$E$7,0,1)*IF(HG4=0.75,1.5,IF(HG4=1.25,1.75,1))))","v":0},{"$f":"MAX(HE4,HG4,HH4)","v":0},{"$f":"IF(ISBLANK(Summary!C94)=TRUE,0,IF(Summary!C94=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D94)=TRUE,0,0.25)","v":0},null,{"$f":"SUM(HJ4:HK4)","v":0},{"$f":"IF(ISBLANK(Summary!C97)=TRUE,0,IF(Summary!C97=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(HN4=0,0,IF(ISBLANK(Summary!D97)=TRUE,0,IF(Summary!F97=Environment!$E$7,0,IF(Summary!F97=Environment!$E$6,1.25,IF(Summary!F97=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(HN4=0,0,IF(ISBLANK(Summary!G97)=TRUE,0,IF(Summary!G97=Environment!$E$7,0,1)*IF(HO4=0.75,1.5,IF(HO4=1.25,1.75,1))))","v":0},{"$f":"MAX(HN4,HO4,HP4)","v":0},{"$f":"IF(ISBLANK(Summary!C98)=TRUE,0,IF(Summary!C98=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(HR4=0,0,IF(ISBLANK(Summary!D98)=TRUE,0,IF(Summary!F98=Environment!$E$7,0,IF(Summary!F98=Environment!$E$6,1.25,IF(Summary!F98=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(HR4=0,0,IF(ISBLANK(Summary!G98)=TRUE,0,IF(Summary!G98=Environment!$E$7,0,1)*IF(HS4=0.75,1.5,IF(HS4=1.25,1.75,1))))","v":0},{"$f":"MAX(HR4,HS4,HT4)","v":0},{"$f":"IF(ISBLANK(Summary!C99)=TRUE,0,IF(Summary!C99=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(HV4=0,0,IF(ISBLANK(Summary!D99)=TRUE,0,IF(Summary!F99=Environment!$E$7,0,IF(Summary!F99=Environment!$E$6,1.25,IF(Summary!F99=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(HV4=0,0,IF(ISBLANK(Summary!G99)=TRUE,0,IF(Summary!G99=Environment!$E$7,0,1)*IF(HW4=0.75,1.5,IF(HW4=1.25,1.75,1))))","v":0},{"$f":"MAX(HV4,HW4,HX4)","v":0},{"$f":"IF(ISBLANK(Summary!C102)=TRUE,0,IF(Summary!C102=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D102)=TRUE,0,0.125)","v":0},{"$f":"IF(ISBLANK(Summary!E102)=TRUE,0,0.125)","v":0},{"$f":"IF(HZ4=0,0,IF(ISBLANK(Summary!F102)=TRUE,0,IF(Summary!G102=Environment!$E$7,0,IF(Summary!G102=Environment!$E$6,1.25,IF(Summary!G102=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(HZ4=0,0,IF(ISBLANK(Summary!H102)=TRUE,0,IF(Summary!H102=Environment!$E$7,0,1)*IF(IC4=0.75,1.5,IF(IC4=1.25,1.75,1))))","v":0},{"$f":"MAX(SUM(HZ4:IB4),IC4,ID4)","v":0},{"$f":"IF(ISBLANK(Summary!C103)=TRUE,0,IF(Summary!C103=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D103)=TRUE,0,0.125)","v":0},{"$f":"IF(ISBLANK(Summary!E103)=TRUE,0,0.125)","v":0},{"$f":"IF(IF4=0,0,IF(ISBLANK(Summary!F103)=TRUE,0,IF(Summary!G103=Environment!$E$7,0,IF(Summary!G103=Environment!$E$6,1.25,IF(Summary!G103=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(IF4=0,0,IF(ISBLANK(Summary!H103)=TRUE,0,IF(Summary!H103=Environment!$E$7,0,1)*IF(II4=0.75,1.5,IF(II4=1.25,1.75,1))))","v":0},{"$f":"MAX(SUM(IF4:IH4),II4,IJ4)","v":0},{"$f":"IF4","v":0},{"$f":"IF(ISBLANK(Summary!D104)=TRUE,0,0.125)","v":0},{"$f":"IF(ISBLANK(Summary!E104)=TRUE,0,0.125)","v":0},{"$f":"IF(IL4=0,0,IF(ISBLANK(Summary!F104)=TRUE,0,IF(Summary!G104=Environment!$E$7,0,IF(Summary!G104=Environment!$E$6,1.25,IF(Summary!G104=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(IL4=0,0,IF(ISBLANK(Summary!H104)=TRUE,0,IF(Summary!H104=Environment!$E$7,0,1)*IF(IO4=0.75,1.5,IF(IO4=1.25,1.75,1))))","v":0},{"$f":"MAX(SUM(IM4:IN4),IO4,IP4)","v":0},{"$f":"SUM(IK4,IQ4)","v":0},{"$f":"IF(ISBLANK(Summary!C105)=TRUE,0,IF(Summary!C105=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(IS4=0,0,IF(ISBLANK(Summary!F105)=TRUE,0,IF(Summary!G105=Environment!$E$7,0,IF(Summary!G105=Environment!$E$6,1.25,IF(Summary!G105=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(IS4=0,0,IF(ISBLANK(Summary!H105)=TRUE,0,IF(Summary!H105=Environment!$E$7,0,1)*IF(IT4=0.75,1.5,IF(IT4=1.25,1.75,1))))","v":0},{"$f":"MAX(IS4,IT4,IU4)","v":0},{"$f":"IF(ISBLANK(Summary!C106)=TRUE,0,IF(Summary!C106=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(IW4=0,0,IF(ISBLANK(Summary!F106)=TRUE,0,IF(Summary!G106=Environment!$E$7,0,IF(Summary!G106=Environment!$E$6,1.25,IF(Summary!G106=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(IW4=0,0,IF(ISBLANK(Summary!H106)=TRUE,0,IF(Summary!H106=Environment!$E$7,0,1)*IF(IX4=0.75,1.5,IF(IX4=1.25,1.75,1))))","v":0},{"$f":"MAX(IW4,IX4,IY4)","v":0},{"$f":"IF(ISBLANK(Summary!C107)=TRUE,0,IF(Summary!C107=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(JA4=0,0,IF(ISBLANK(Summary!F107)=TRUE,0,IF(Summary!G107=Environment!$E$7,0,IF(Summary!G107=Environment!$E$6,1.25,IF(Summary!G107=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(JA4=0,0,IF(ISBLANK(Summary!H107)=TRUE,0,IF(Summary!H107=Environment!$E$7,0,1)*IF(JB4=0.75,1.5,IF(JB4=1.25,1.75,1))))","v":0},{"$f":"MAX(JA4,JB4,JC4)","v":0},{"$f":"IF(ISBLANK(Summary!C108)=TRUE,0,IF(Summary!C108=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(JE4=0,0,IF(ISBLANK(Summary!F108)=TRUE,0,IF(Summary!G108=Environment!$E$7,0,IF(Summary!G108=Environment!$E$6,1.25,IF(Summary!G108=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(JE4=0,0,IF(ISBLANK(Summary!H108)=TRUE,0,IF(Summary!H108=Environment!$E$7,0,1)*IF(JF4=0.75,1.5,IF(JF4=1.25,1.75,1))))","v":0},{"$f":"MAX(JE4,JF4,JG4)","v":0},{"$f":"IF(ISBLANK(Summary!C109)=TRUE,0,IF(Summary!C109=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D109)=TRUE,0,0.25)","v":0},{"$f":"SUM(JI4:JJ4)","v":0},{"$f":"IF(ISBLANK(Summary!C110)=TRUE,0,IF(Summary!C110=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D110)=TRUE,0,0.25)","v":0},{"$f":"SUM(JL4:JM4)","v":0},{"$f":"IF(ISBLANK(Summary!C111)=TRUE,0,IF(Summary!C111=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(JO4=0,0,IF(ISBLANK(Summary!F111)=TRUE,0,IF(Summary!G111=Environment!$E$7,0,IF(Summary!G111=Environment!$E$6,1.25,IF(Summary!G111=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(JO4=0,0,IF(ISBLANK(Summary!H111)=TRUE,0,IF(Summary!H111=Environment!$E$7,0,1)*IF(JP4=0.75,1.5,IF(JP4=1.25,1.75,1))))","v":0},{"$f":"MAX(JO4,JP4,JQ4)","v":0},{"$f":"JO4","v":0},{"$f":"IF(JS4=0,0,IF(ISBLANK(Summary!F112)=TRUE,0,IF(Summary!G112=Environment!$E$7,0,IF(Summary!G112=Environment!$E$6,1.25,IF(Summary!G112=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(JS4=0,0,IF(ISBLANK(Summary!H112)=TRUE,0,IF(Summary!H112=Environment!$E$7,0,1)*IF(JT4=0.75,1.5,IF(JT4=1.25,1.75,1))))","v":0},{"$f":"MAX(JT4,JU4)","v":0},{"$f":"JR4+JV4","v":0},{"$f":"IF(ISBLANK(Summary!C113)=TRUE,0,IF(Summary!C113=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(JX4=0,0,IF(ISBLANK(Summary!F113)=TRUE,0,IF(Summary!G113=Environment!$E$7,0,IF(Summary!G113=Environment!$E$6,1.25,IF(Summary!G113=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(JX4=0,0,IF(ISBLANK(Summary!H113)=TRUE,0,IF(Summary!H113=Environment!$E$7,0,1)*IF(JY4=0.75,1.5,IF(JY4=1.25,1.75,1))))","v":0},{"$f":"MAX(JX4,JY4,JZ4)","v":0},{"$f":"JX4","v":0},{"$f":"IF(KB4=0,0,IF(ISBLANK(Summary!F114)=TRUE,0,IF(Summary!G114=Environment!$E$7,0,IF(Summary!G114=Environment!$E$6,1.25,IF(Summary!G114=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(KB4=0,0,IF(ISBLANK(Summary!H114)=TRUE,0,IF(Summary!H114=Environment!$E$7,0,1)*IF(KC4=0.75,1.5,IF(KC4=1.25,1.75,1))))","v":0},{"$f":"MAX(KC4,KD4)","v":0},{"$f":"KA4+KE4","v":0},{"$f":"IF(ISBLANK(Summary!C117)=TRUE,0,IF(Summary!C117=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D117)=TRUE,0,0.25)","v":0},{"$f":"SUM(KG4:KH4)","v":0},{"$f":"IF(ISBLANK(Summary!C118)=TRUE,0,IF(Summary!C118=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D118)=TRUE,0,0.25)","v":0},{"$f":"SUM(KJ4:KK4)","v":0},{"$f":"IF(ISBLANK(Summary!C121)=TRUE,0,IF(Summary!C121=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D121)=TRUE,0,0.25)","v":0},{"$f":"SUM(KM4:KN4)","v":0},{"$f":"IF(ISBLANK(Summary!C122)=TRUE,0,IF(Summary!C122=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D122)=TRUE,0,0.25)","v":0},{"$f":"SUM(KP4:KQ4)","v":0},{"$f":"IF(ISBLANK(Summary!C125)=TRUE,0,IF(Summary!C125=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D125)=TRUE,0,0.25)","v":0},{"$f":"SUM(KS4:KT4)","v":0},{"$f":"IF(ISBLANK(Summary!C126)=TRUE,0,IF(Summary!C126=Environment!$B$3,0,0.5))","v":0},{"$f":"KV4","v":0},{"$f":"IF(ISBLANK(Summary!C127)=TRUE,0,IF(Summary!C127=Environment!$B$3,0,0.5))","v":0},{"$f":"IF(KX4=0,0,IF(ISBLANK(Summary!D127)=TRUE,0,IF(Summary!E127=Environment!$E$7,0,IF(Summary!E127=Environment!$E$6,1.25,IF(Summary!E127=Environment!$E$5,1.25,0.75)))))","v":0},{"$f":"IF(KX4=0,0,IF(ISBLANK(Summary!F127)=TRUE,0,IF(Summary!F127=Environment!$E$7,0,1)*IF(KY4=0.75,1.5,IF(KY4=1.25,1.75,1))))","v":0},{"$f":"MAX(KX4,KY4,KZ4)","v":0},{"$f":"IF(ISBLANK(Summary!C128)=TRUE,0,IF(Summary!C128=Environment!$B$3,0,0.25))","v":0},{"$f":"IF(ISBLANK(Summary!D128)=TRUE,0,0.25)","v":0},{"$f":"SUM(LB4:LC4)","v":0}]

{"sheet":"Averages","index":6,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"Sector","Disclosure and labelling","Board structure and independence","Policies, standards, codes of conduct","Communication and engagement","Marketing and ethical advertising","Child and forced labour","Employee health, safety and wellness / Training and Development","Customer satisfaction","Regulatory and legal challenges","Labour relations and union practices","Supply chain standards and selection","Product life cycle impact","Biodiversity impacts","Climate Change Risk","Energy management","GHG emissions and air pollution","Waste management and effluents","Water Management","Environmental expenditure","Political and lobbying","Community Developemnt ","Maximum possible score"]
[null,"Automotive and Auto Ancillary",0.58333333333333337,1.0999999999999999,1.5208333333333333,1.2348484848484849,{"$error":"#DIV/0!"},0.76136363636363635,1.1527777777777777,0.85227272727272718,0.84722222222222232,0.95833333333333337,1.6376262626262628,0.74537037037037035,0,0.6875,1.3083333333333333,1.0257936507936507,2.2028985507246377,0.68560606060606066,0,0.91666666666666663,0.91666666666666663,73.25]
[null,"Banking and Financial Services",0.5,0.87222222222222223,0.56944444444444431,0.35353535353535359,0.24074074074074078,0.30952380952380948,0.26587301587301587,0.46464646464646442,0.18148148148148147,0.20634920634920628,0.33080808080808072,{"$error":"#DIV/0!"},0,0.45833333333333331,0.17555555555555558,{"$error":"#DIV/0!"},0.16161616161616157,{"$error":"#DIV/0!"},0,0.2361111111111111,0.73148148148148151,44.75]
[null,"Broadcasting",0.5,0.7,0.58333333333333337,0.40909090909090912,0,0.2857142857142857,0.21428571428571427,0.36363636363636365,0.13333333333333333,0.2857142857142857,5.5555555555555552E-2,{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},9.0909090909090912E-2,{"$error":"#DIV/0!"},0,0.5,0.66666666666666663,46.75]
[null,"Chemicals",0.5,0.6,0.625,0.34090909090909094,0.54545454545454541,0.36363636363636365,0.5,0.45454545454545453,0.3,0.125,0.25757575757575757,0.38888888888888884,0,0.4375,0.48,{"$error":"#DIV/0!"},0.36956521739130432,0.54545454545454541,0.3,0.25,0.625,71.25]
[null,"Construction",0.5,0.67999999999999994,0.60833333333333339,0.35454545454545455,0.6,0.29090909090909089,0.2857142857142857,0.37142857142857133,0.26666666666666666,0.36249999999999999,0.2848484848484848,0.28888888888888886,0.35,0.55000000000000004,0.27199999999999996,{"$error":"#DIV/0!"},0.23809523809523805,0.25454545454545452,0.1,0.35,0.67500000000000004,70.5]
[null,"Cosmetics / Personal Care",0.4,0.72,0.56666666666666665,0.37272727272727274,0.43636363636363634,0.36363636363636365,0.27619047619047621,0.42207792207792211,0.26666666666666672,0.28749999999999998,0.27272727272727271,0.51111111111111107,0,0.4,0.41600000000000004,{"$error":"#DIV/0!"},0.25217391304347825,0.23636363636363639,0.1,0.25,0.65,71.25]
[null,"Extracting / Production",0.75,0.7,0.41666666666666669,0.38636363636363635,{"$error":"#DIV/0!"},0.18181818181818182,0.59523809523809523,{"$error":"#DIV/0!"},0.33333333333333337,0.25,0.17241379310344829,0.5,0.375,0.33333333333333331,0.44000000000000006,0.64285714285714279,0.38043478260869562,0.90909090909090917,0.4,0.5,0.625,74.5]
[null,"IT/ITES & Electronics",0.5,0.73333333333333339,0.65277777777777779,0.48484848484848486,{"$error":"#DIV/0!"},0.2857142857142857,0.45238095238095238,{"$error":"#DIV/0!"},0.22222222222222221,0.23809523809523805,0.27777777777777779,{"$error":"#DIV/0!"},0,0.45833333333333331,0.61333333333333329,{"$error":"#DIV/0!"},0.42424242424242425,0.54545454545454541,0.2,0.33333333333333331,0.83333333333333337,45.75]
[null,"Materials",0.625,0.64999999999999991,0.58333333333333337,0.37499999999999994,1,0.27272727272727271,0.42857142857142855,0.45454545454545453,0.30000000000000004,0.40625,0.31060606060606061,0.44444444444444442,0,{"$error":"#DIV/0!"},0.37,0.25,0.29285714285714287,0.47727272727272729,0.1,0.4375,0.625,67.75]
[null,"Mining & Metals",0.5,0.91999999999999993,1.4583333333333335,0.44545454545454549,{"$error":"#DIV/0!"},0.36363636363636365,0.49523809523809526,0.68571428571428572,0.24,0.375,0.30344827586206902,0.53333333333333344,0.5,0.55000000000000004,0.38400000000000001,0.26666666666666666,0.30434782608695649,0.43636363636363634,0.2,0.4,0.65,74.25]
[null,"Others ",0.5,0.76,0.45833333333333331,0.46363636363636368,{"$error":"#DIV/0!"},0.36363636363636365,0.16190476190476191,0.54805194805194801,0.31714285714285712,0.35,0.24158829676071053,0.42222222222222217,0,{"$error":"#DIV/0!"},0.248,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0.3,0.7,50]
[null,"Personal Accessories",0.5,0.6,0.58333333333333337,0.5,1,0.27272727272727271,0.38095238095238093,0.45454545454545453,0.26666666666666666,0.4375,0.41379310344827586,0.44444444444444442,0,0.5,0.6,0.19047619047619047,0.25714285714285712,0.27272727272727271,0,0.25,1,69.5]
[null,"Pharmaceuticals",0.5,0.78749999999999998,0.62500000000000011,0.32954545454545459,0.47727272727272729,0.23863636363636365,0.19047619047619047,0.36363636363636365,0.23333333333333334,0.21875,0.26136363636363635,0.34722222222222221,0,0.5,0.30000000000000004,{"$error":"#DIV/0!"},0.16576086956521741,0.13636363636363635,0,0.34375,0.74999999999999989,72.25]
[null,"Power (Generation/Distribution) ",0.5,0.83333333333333337,0.59722222222222232,0.45454545454545459,{"$error":"#DIV/0!"},0.36363636363636359,0.49206349206349209,0.61904761904761907,0.26666666666666666,0.35416666666666669,0.32183908045977011,0.40740740740740738,0.33333333333333331,0.55555555555555569,0.48,0.44444444444444442,0.48550724637681159,0.45454545454545459,0.4,0.41666666666666669,0.66666666666666663,76.25]
[null,"Processed food and beverages",0.66666666666666663,0.76666666666666661,0.69444444444444453,0.39393939393939398,0.54545454545454541,0.36363636363636359,0.31746031746031744,0.42424242424242425,0.13333333333333333,0.35416666666666669,0.36363636363636359,0.25925925925925924,0,0.45833333333333331,0.28000000000000003,{"$error":"#DIV/0!"},0.25362318840579712,0.36363636363636359,0,0.33333333333333331,0.66666666666666663,71.25]
[null,"Refining and Marketing",0.5,0.91999999999999993,0.625,0.49090909090909091,{"$error":"#DIV/0!"},0.36363636363636365,0.5714285714285714,0.47272727272727277,0.4,0.36249999999999999,0.24827586206896549,0.57777777777777783,0.55000000000000004,0.48333333333333328,0.504,0.38095238095238088,0.41739130434782606,0.56363636363636371,0.3,0.5,0.65,76.75]
[null,"Telecom",0.5,0.8,0.58333333333333337,0.45454545454545459,{"$error":"#DIV/0!"},0.5714285714285714,0.42857142857142855,0.45454545454545453,0.2,0.2857142857142857,0.1111111111111111,0.27777777777777779,0,0.5,0.22,0,7.6086956521739135E-2,{"$error":"#DIV/0!"},0,0.375,0.41666666666666663,59.25]

{"sheet":"graphs","index":8,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,{"$f":"Summary!C1","v":0},"2014 Sector average"]
[null,"Disclosure and labelling",{"$f":"Summary!M8","v":0},{"$f":"Summary!N8","v":0.5}]
[null,"Board structure and independence",{"$f":"Summary!M11","v":0},{"$f":"Summary!N11","v":0.6}]
[null,"Policies, standards, codes of conduct",{"$f":"Summary!M17","v":0},{"$f":"Summary!N17","v":0.625}]
[null,"Communication and engagement",{"$f":"Summary!M26","v":0},{"$f":"Summary!N26","v":0.34090909090909094}]
[null,"Marketing and ethical advertising",{"$f":"Summary!M33","v":0},{"$f":"Summary!N33","v":0.54545454545454541}]
[null,"Child and forced labour",{"$f":"Summary!M38","v":0},{"$f":"Summary!N38","v":0.36363636363636365}]
[null,"Employee health, safety and wellness / Training and Development",{"$f":"Summary!M42","v":0},{"$f":"Summary!N42","v":0.5}]
[null,"Customer satisfaction",{"$f":"Summary!M47","v":0},{"$f":"Summary!N47","v":0.45454545454545453}]
[null,"Regulatory and legal challenges",{"$f":"Summary!M50","v":0},{"$f":"Summary!N50","v":0.3}]
[null,"Labour relations and union practices",{"$f":"Summary!M56","v":0},{"$f":"Summary!N56","v":0.125}]
[null,"Supply chain standards and selection",{"$f":"Summary!M61","v":0},{"$f":"Summary!N61","v":0.25757575757575757}]
[null,"Product life cycle impact",{"$f":"Summary!M69","v":0},{"$f":"Summary!N69","v":0.38888888888888884}]
[null,"Biodiversity impacts",{"$f":"Summary!M82","v":0},{"$f":"Summary!N82","v":0}]
[null,"Climate Change Risk",{"$f":"Summary!M85","v":0},{"$f":"Summary!N85","v":0.4375}]
[null,"Energy management",{"$f":"Summary!M90","v":0},{"$f":"Summary!N90","v":0.48}]
[null,"GHG emissions and air pollution",{"$f":"Summary!M96","v":0},{"$f":"Summary!N96","v":{"$error":"#DIV/0!"}}]
[null,"Waste management and effluents",{"$f":"Summary!M101","v":0},{"$f":"Summary!N101","v":0.36956521739130432}]
[null,"Water Management",{"$f":"Summary!M110","v":0},{"$f":"Summary!N110","v":0.54545454545454541}]
[null,"Environmental protection expenditure",{"$f":"Summary!M114","v":0},{"$f":"Summary!N114","v":0.3}]
[null,"Political and lobbying",{"$f":"Summary!M120","v":0},{"$f":"Summary!N120","v":0.25}]
[null,"Community Developemnt ",{"$f":"Summary!M124","v":0},{"$f":"Summary!N124","v":0.625}]

{"sheet":"Maximum scores","index":9,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Sector","Disclosure and labelling","Board structure and independence","Policies, standards, codes of conduct","Communication and engagement","Marketing and ethical advertising","Child and forced labour","Employee health, safety and wellness / Training and Development","Customer satisfaction","Regulatory and legal challenges","Labour relations and union practices","Supply chain standards and selection","Product life cycle impact","Biodiversity impacts","Climate Change Risk","Energy management","GHG emissions and air pollution","Waste management and effluents","Water Management","Environmental expenditure","Political and lobbying","Community Developemnt ","Maximum possible score"]
[null,null,1,2.5,6,5.5,4.5,2.75,5.25,1,4.25,4,8.25,2.25,1,3,6.25,5.25,11.5,2.75,1.75,2,6.25,{"$f":"SUM(C3:W3)","v":87}]