{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Welcome","Home","Instructions","1. Hazard Analysis","2. Exposure Analysis","3. Vulnerability Analysis","4. Risk Score"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,6,26,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Project Consultant"]

{"sheet":"Home","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,16383],[2,0,1048575,0],[2,1,1048575,1],[2,2,2,16383],[3,2,3,10],[3,11,3,28],[4,2,4,28],[5,18,5,28],[6,2,6,18],[7,2,7,28],[3,29,1048575,16383],[6,19,6,28],[8,2,8,8],[8,10,8,28],[9,2,9,18],[10,2,10,28],[9,20,9,28],[11,2,11,8],[11,10,11,28],[19,2,1048575,28],[12,2,12,18],[12,19,12,28],[13,2,13,28],[14,2,14,8],[15,2,15,18],[14,10,14,28],[15,19,15,28],[17,2,17,8],[16,2,16,28],[17,10,17,28],[18,2,18,18],[18,19,18,28]]}
["             Introduction"]
[]
[]
[null,null,"Risk Assessment Framework for E-Bus Depots"]
[]
[null,null,"Understanding the requirement of the tool"]
[null,null,"As Indian cities witness the rapid adoption of electric buses (e-buses), ensuring their safety, reliability, and long-term sustainability is becoming increasingly critical. E-buses operate within a complex ecosystem and are exposed to multiple hazards such as natural (e.g., floods, cyclones, heatwaves), technological (e.g., cybersecurity threats, thermal runaway), and human-induced (e.g., accidents, vandalism). At the same time, the induction, use, and retirement of e-buses can also pose risks to other transport users, the environment, and public infrastructure.\n\nA deeper review of India’s diverse hazard profile spanning Himalayan terrains, coastal zones, flood-prone belts, arid/semi-arid regions, and forested areas reinforces the need for geographically tailored risk assessments. Natural hazards in these varied geographies can trigger mechanical, thermal, and electrical stress on e-bus systems, potentially disrupting operations, damaging assets, and endangering lives. In parallel, technological and human-induced hazards—such as cybersecurity threats, electrical fires, or operational errors—present systemic risks that require robust mitigation planning. While these hazards may appear similar across regions, their manifestation and impact can vary significantly depending on local operating conditions, infrastructure readiness, climate, and terrain.\n\nIn this context, a comprehensive and practical framework for risk assessment of the e-bus depots is developed to foster a resilient, adaptive, and secure e-bus ecosystem."]
[]
[null,null,"Who can benefit from the tool?"]
[null,null,"The framework is intended be used by State Transport Undertakings, City Transit Agencies, Municipal Corporation, and Safety/Regulatory Bodies other agencies that are responsible for city bus system planning, infrastructure development etc."]
[]
[null,null,"Key Concepts"]
[null,null,"Hazard (Likelihood and intensity of hazard) – Natural, technological, and human induced hazards are considered in the risk assessment to ensure comprehensiveness. The hazards are measured as the likelihood of their occurrence based on historic trends, existing social, political conditions, and capacities to manage and operate e-bus. \n\nExposure (Element or Value at risk) – Exposure refers to the potential for loss or harm to various assets and interests due to their presence in areas or situations where they could be adversely affected by hazards. Exposures are typically measured in terms of quantum or amount of element or value at risk. In case of e-bus ecosystems, the key exposures include asset/ infrastructure, personnel, income, and legal liability. \n\nVulnerability (Probability of Damage) – Vulnerability denotes the propensity and predisposition of the e-bus ecosystem's components to suffer harm when exposed to hazards. It reflects the system's inherent capacity to anticipate, cope with, resist, and recover from the impact of adverse events. Vulnerability in risk assessment is measured in terms of probability of damage during hazard."]
[]
[null,null,"Key Assumptions"]
[null,null,"•\tData Availability: The framework assumes access to a mix of primary (operational/geospatial) and secondary (institutional/published) data. Where gaps exist, proxy indicators or expert judgment may be used.\n•\tScalability: Applicable at both city and depot level, allowing localized assessments to be aggregated for system-wide risk profiling. The depot level risk assessment shall exclude operating environment component.\n•\tInstitutional Access: Effective application depends on timely data from agencies such as IMD, NDMA, CPCB, and local municipal and utility departments.\n•\tStatic Snapshot: The tool provides a point-in-time risk view; cities are advised to update assessments periodically to reflect infrastructure and hazard changes.\n•\tMulti-Sectoral Engagement: Effective application of the framework requires coordination among multiple sectors—transport, power, ICT, LGUs, and disaster management. Single-agency assessments may miss critical interdependencies and operational risks.\n•\tUniform E-bus model and operators in a depot: The framework assumes that an e-bus depot will comprise of the same bus model/ make of same manufacturer. It is also assumed that a single operator is operating out of a single depot."]
[]
[null,null,"Methodological Limitations"]
[null,null,"•\tSemi-Quantitative Approach: The framework uses a risk matrix based on likelihood and consequence scoring, yielding relative rather than probabilistic risk estimates. Results are highly dependent on the accuracy and consistency of input data and expert judgment.\n•\tSubjectivity in Interpretation: Risk scoring is inherently influenced by stakeholder perceptions and expertise. Without standardized facilitation and scoring guidelines, variations across assessors or agencies may result in inconsistent or biased outcomes.\n•\tFlexible weightage for Exposure and Vulnerability: We have given the cities more flexibility to change the original weightage of 70% for exposure and 30% for vulnerability. This provision is made to enable cities in replicating the city-specific conditions. However, this may also introduce a level of subjectivity while conducting comparative assessment between two or more cities.\n•\tChallenges in Aggregation: Aggregating risk scores across depots or components may obscure localized vulnerabilities and mask high-risk hotspots that require targeted mitigation measures.\n•\tStatic Snapshot in Dynamic Contexts: The tool provides a point-in-time risk profile and does not automatically account for evolving urban development, hazard intensity, or infrastructure upgrades. Regular updates—ideally on a semi-annual or annual basis—are recommended to maintain relevance.\n•\tLimited Economic Risk Quantification: The framework does not estimate financial losses, cost of service disruptions, or broader economic impacts of risk—elements that are critical for investment planning, cost-benefit analysis, and prioritizing resilience interventions."]

{"sheet":"Instructions","index":2,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,1048575,1],[5,2,5,25],[6,2,6,25],[7,2,7,25],[0,0,1,16383],[2,0,1048575,0],[2,1,2,16383],[3,2,3,25],[4,2,4,25],[8,2,8,25],[9,2,9,25],[10,2,10,25],[3,26,1048575,16383],[11,2,11,25],[13,2,13,25],[12,2,12,25],[14,2,14,25],[15,2,15,25]]}
["             Instructions"]
[]
[]
[null,null,"To use the tool correctly:\n✔ Collect required city‑level hazard data (IMD, NDMA, CGWB, municipal data, operator data)\n✔ Gather depot‑level exposure information\n✔ Gather depot‑level vulnerability information\n\nAll parameters use pre‑defined scoring scales, so the user only needs to choose the correct score from the dropdowns or input boxes."]
[]
[null,null,"STEP 1: Conduct Hazard Analysis\n\n(Sheet: “1. Hazard Analysis”)\nThis sheet captures city-level hazard likelihood and intensity across 11 hazards\n\nHow to fill the sheet:\n✔ For each hazard, you will see multiple parameters (e.g., rainfall, flood frequency, soil permeability, etc.).\n✔ For each parameter, select the appropriate score (0–4) using the dropdowns.\n\nThe tool automatically:\n✔ Averages the parameter scores\n✔ Computes the Hazard Score for each hazard"]
[]
[null,null,"STEP 2: Conduct Exposure Analysis\n\n(Sheet: “2. Exposure Analysis”)\nThis sheet calculates the \"value at risk\" within each depot.\n\nHow to fill the sheet:\nSelect the exposure score (1–5) for each parameter based on depot data.\n\nThe tool automatically:\n✔ Calculates the average Exposure Score for each depot.\n✔ Exposure is weighted 70% during consequence calculation by default."]
[]
[null,null,"STEP 3: Conduct Vulnerability Analysis\n\n(Sheet: “3. Vulnerability Analysis”)\nThis sheet captures how susceptible the depot is to damage.\n\nHow to fill the sheet\nAssign the correct vulnerability score (1–5) for each indicator.\n\nThe tool automatically:\n✔ Computes the average Vulnerability Score for each depot.\n✔ Vulnerability is weighted 30% during consequence calculation by default."]
[]
[null,null,"STEP 4: Consequence Calculation\n(Sheet: “4. Risk Score” )\nThis step combines Exposure and Vulnerability\n\nFormula used in tool:\nConsequence=(Exposure×0.7)+(Vulnerability×0.3)\nThis is based on ADB’s CRVA method\n\nWhat to do\nNothing to fill here—tool auto‑calculates the consequence score using the formulas built into the sheet.\n"]
[]
[null,null,"STEP 5: Final Risk Score Calculation\n(Sheet: “4. Risk Score” – Bottom Section)\n\nFinal Risk Score Formula:\nRisk Score = Hazard Score×Consequence Value\n\nRisk Categories\n1–4 → Very Low Risk\n5–8 → Low Risk\n9–12 → Moderate Risk\n13–16 → High Risk\n17–20 → Very High Risk\n\nHow to use this section\n✔ No data entry required & the tool automatically computes:\n          -Risk score for each hazard\n          -Overall risk level for each depot"]
[]
[null,null,"Interpreting Results\n\nAfter completing all sheets, you will know:\n✔ Which hazards pose the highest likelihood\n✔ Which depots have highest exposure\n✔ Which depots are most vulnerable\n✔ What the overall risk scores are for each hazard\n✔ Which depots require urgent attention\n"]

{"sheet":"1. Hazard Analysis","index":3,"n_rows":79,"n_cols":20,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,16383],[1,0,1048575,0],[54,1,54,6],[59,1,59,6],[65,1,65,6],[29,1,29,6],[35,1,35,6],[39,1,39,6],[45,1,45,6],[49,1,49,6],[12,1,12,6],[2,1,3,1],[1,1,1,7],[17,1,17,6],[23,1,23,6],[2,7,3,7]]}
[]
[null,"Hazard Analysis for a City"]
[null,"Hazard Scoring","Very low","Low","Moderate","High","Very High","City A"]
[null,null,0,1,2,3,4]
[null,"1. Floods"]
[null,"24-hour Rainfall over an area","<15.6 mm","15.6 – 64.4 mm","64.5 – 115.5 mm","115.5 – 204.4 mm",">204.5 mm"]
[null,"Historical flood frequency for last 10 years","No reported floods","Rare","2/3 floods (moderate occurrence)","4-6 floods (recurring issue)",">6 floods (annual or near flooding)"]
[null,"Presence of rivers, lakes, or coastline",">20km away, low exposure","10-20 km (low-moderate exposure)","5-10 km (moderate)","<5km away (high exposure)","Within/adjacent to water body (extreme exposure)"]
[null,"Drainage infrastructure quality","Fully covered, modern, well-maintained system","Mostly covered, periodic maintenance","Mixed – some covered, clogging","Mostly open, poor maintenance","No drainage / frequently failing system"]
[null,"Topography (low-lying, flat areas) ","Hilly / Sloping","Gentle undulations","Flat/ not low-lying","Partially low-lying, likely water stagnation","Fully low-lying – major flood accumulation zone"]
[null,"Soil permeability / Soil permeability  ","Very Highly permeable ","Highly Permeable","Moderately Permeable ","Poorly Permeable","Impermeable  "]
[null,"% of Forest Cover",">40% green cover","30-40% green cover","20-30% green cover","10-20% green cover","<10% green cover"]
[null,"Total Score for Floods"]
[null,"2. Earthquakes"]
[null,"Proximity to fault lines and seismic zones ","Located in Zone II, far (>200 km from active fault lines)","Zone II but within 100-200 km from fault lines","Located in zone III (moderate risk) or 50-100 km from fault lines","Located in zone IV (high risk) or within 50km of active fault","Located in zone V (very high risk) and/or sits directly over <25km from active fault lines"]
[null,"Soil type (soft soils amplify shaking) ","Hard rock, well compacted gravel","Moderately dense soil with low potential for amplification","Mix of soft and dense soils – moderate risks of amplification","Loose alluvium or reclaimed land","Deep soft, clay, riverine / alluvial plains – extreme amplification risk"]
[null,"Historical earthquake activity- past 10 years","No earthquakes recorded within 200 km ","1-2 minor tremors (less/equal to 3.5 magnitude) within 200km","1 moderate earthquake (4.0-5.0) / 3+ minor tremors in 10 yrs.","Greater than /equal to 2 moderate or 1 strong earthquake (>5/6 magnitude) in last 10 yrs.","Recurring seismic activity with multiple moderate to strong quakes in past"]
[null,"Total Score for Earthquakes"]
[null,"3. Cyclones and Storms"]
[null,"Proximity to warm oceans or seas ",">500 km from sea","250-500 km from sea","<250 km from sea, sheltered from cyclone (hills blocking the coastline)","<100km from open coastlines on By of Bengal, Arabian Sea","Coastal locations regularly impacted by cyclones"]
[null,"Topography (flat coastal areas are most vulnerable) ","Hilly terrain, elevation >100m, minimal cyclone impact","Undulating terrain, elevation - 50-100 m","Gently sloping areas, elevation – 20-50m","Flat terrain, elevation -","Flat, low-lying terrain less than/equal to 10m with coastal exposure"]
[null,"Historical cyclone landfalls and tracks- past 10 years","No cyclones within 200 km in past 10 yrs.","1 cyclone within 200km","2-3 cyclones within 100-200 km","More than 2 landfalls within 100km in last decade","Regular / bi-annual landfalls within 100 km"]
[null,"Wind patterns and monsoon behaviour","Located in wind-sheltered zone, low speed monsoon winds","Minor exposure to monsoon or easterly winds","Moderate exposure to shifting monsoon winds","Consistent exposure to high winds from southwest/ northeast monsoon","Region experiences intense gusts / cyclonic winds during every monsoon or pre-monsoon season"]
[null,"Total Score for Cyclones"]
[null,"4. Extreme Temperatures"]
[null,"Historical temperature extremes in last 10 years","No days with temperature > 40°C or temperature < 10°C ","1-2 extreme days- heat or cold in 10 years","1-2 extreme days every 3/5 years","1-2 events annually","> 2 events annually"]
[null,"Latitude and altitude (influence temperature)","High (>1500 m), tropical coastlines with stable climate","Highland cities (1000 m-1500 m), latitude <10 degrees or >28 degrees","Mid-altitude (500-1000m) or sub-tropical zones (10-25 degrees altitude)","Latitude 20-30 degrees, lowland terrain, elevation <500m","Hot interior plains"]
[null,"Urbanization level (urban heat island effect) ","Rural/agricultural with <10% BUA","Small towns/peri-urban zones with 10-30% urbanization","Emerging cities or mid-size towns (30-60% BUA)","Large cities (>60% BUA) with traffic, concrete concentration","Dense metro areas (>80% BUA)"]
[null,"Vegetation cover (green spaces mitigate heat) ",">50%","35-50%","20-35%","10-20%","<10%, fully built-up area"]
[null,"Total Score for Extreme Temperatures"]
[null,"5. Battery Fire and Thermal Runaway"]
[null,"Historical incident rate- for e-bus model/ OEM","No reported incidents","1-2 incidents over 3/5 years","Known history of thermal incidents","Frequent fire related incidents","Mass replacements due to heavy risks"]
[null,"Charging infrastructure reliability","Charger uptime, > 97% AMC in place, BIS certified chargers","Minor delays or connector mismatches","Regular faults requiring manual resets","Failures during peak demand hours","Frequent trips due to capacity overload"]
[null,"Frequency of maintenance of chargers","Weekly","Biweekly","Monthly","Quarterly","Annually"]
[null,"Age of fleet and frequency of maintenance","<1 yr. old, under warranty with OEM support and predictive maintenance","1-3 years with timely replacement and maintenance","4-6 yrs. with observed performance deterioration","6-7 yrs. with minimal battery health tracking, and no maintenance",">7 yrs., untracked battery degradation, warranty expired and no maintenance"]
[null,"Total Score for Battery Fire & Thermal Runaway"]
[null,"6. Power Failure and Grid Instability"]
[null,"Local grid reliability","Smart grid systems, <2 outages per year","Stable grid with <5% downtime","Outdated, voltage fluctuation incidents","Failure of transformers in depots","Backouts due to excessive load, no power backup, regular grid collapse"]
[null,"Frequency of load shedding ","1 incident annually","1 event in 2- 3 months","1 event every month","1 event every weak","1 event everyday"]
[null,"Total Score for Power Failure & Grid Instability"]
[null,"7. Cyber Threats to Depot Management Systems"]
[null,"Past incidents of cyberattacks","None reported on fleet systems.  OEM platforms","Rarely since operations (1-2 no’s) with no operational impact on buses","Known cyber breach, affecting apps, GPS, payment systems in the city earlier","Direct incidents on e-bus ecosystem (depot management system, charger control, GPS spoofing etc.) or SCADA","Repeated attacks with successful access to depot control systems, ransomware in depot SCADA, large scale data leaks, system shutdowns causing bus downtime"]
[null,"Charger communication protocol/ CAN data/ GPS data","Encrypted CAN, isolated GPS","Minor anomalies with spoofing blocked","CAN data anomalies or GPS misalignment","Past spoofing or protocol breach","Charger / system disabled due to spoofing"]
[null,"Third party vendor risks","Fully certified vendors with strong IT security practices","Basic security compliance by vendors","Known third party software vulnerabilities","Past incidents involving third-party breaches","Repeated or active vendor side exploitation"]
[null,"Level of Internet connectivity and remote access to e-bus depot management systems","Use of isolated, restricted network by depot management and energy control systems with 2 FA access","Admin access via private IP, regular audits, and checks, only OEM and depot manager have login rights","Web portal with open access ports or shared credentials, no audit trail logs maintained","Malware / phishing incidents affecting operations","Major shutdowns due to system compromise – depot access disabled, buses misrouted / halted, system encrypted etc."]
[null,"Total Score for Cyber Threats"]
[null,"8. Technological Obsolescence"]
[null,"Past incidents related to technological obsolescence of e-bus components","No significant history of obsolescence across critical components","Minimal history of obsolescence issues; only minor software or component discontinuations with easy alternatives available","Some component-level obsolescence cases but manageable through OEM support","At least one major obsolescence incident requiring costly retrofits or replacements","Multiple incidents in the past where major components (battery, chargers, drivetrain, control systems) became obsolete"]
[null,"Battery Technology Maturity & Upgrade Compatibility","Uses state-of-the-art, future-ready chemistry with modular, upgradeable design","Uses relatively advanced chemistry with moderate upgrade pathways; retrofit partially feasible","Some scope for upgrades but may need high-cost interventions","Current battery chemistry widely used today but facing rapid phase-out trends; limited retrofit options","Uses outdated/legacy chemistry with no upgrade or retrofit path; high likelihood of early obsolescence"]
[null,"Total Score for Technological Obsolescence"]
[null,"9. Protests, Strikes and Vandalism"]
[null,"Local socio-political stability","Stable governance and regulatory eco system for e buses, strong public support for transport reforms","1/ 2 minor incidents in past 5-10 years, low public opposition to fare/ route changes, no recent unrest affecting bus operations","Periodic protests over fare hikes, minor cases of vandalism during strikes, moderate criticism of e-bus reliability","Frequent delays or operational disruptions, known history of civil unrest","Ongoing protests, vandalism, regular service disruptions"]
[null,"Public perception of transport services or government policies (fare hikes, layoffs)","High public approval of e-buses, transparent / participatory policy decisions (fare, routes), no fare hikes in the past","Isolated fare revision protests, minor dissatisfaction over quality of service,","Periodic complaints over bus availability, wait times – fare hikes, layoffs, bad media publicity","Frequent dissatisfaction in feedback surveys, opposition to fare revisions, drivers’ layoffs","Ongoing public unrest and campaigns against bus operators, viral incidents of accidents / poor service, strong media criticism"]
[null,"History of strikes/ vandalism events","1 event in past 10 years","1 event every 2-3 years","1 event every year","2-3 events every year","1 event every 2-3 months"]
[null,"Total Score for Protests & Strikes"]
[null,"10. Traffic and Operational Accidents"]
[null,"Historical accident rates","No major road accidents involving e-buses, comprehensive driver training, advanced ITS systems in place","1-2 minor accidents annually, good accident response system, Depots follow SOPs strictly","Periodic low-severity accidents due to road conditions, technical glitches like brake failure, door sensors etc.","Frequent accidents due to poor training – inadequate depot design or power surges, brake failures and short circuits","Recurring incidents – systematic neglect in driver certification, multiple depots and on-road accidents reported"]
[null,"Driver shift lengths and fatigue risk (long working hours)","Adherence to standard 8-hour shifts with breaks","Isolated cases of overwork, but monitored","Long shifts common during festivals, holidays, driver fatigue suspected in delays","Shift overruns due to staff shortages – health complaints among drivers due to extended hours","Chronic overwork (>10/12-hour shifts) – multiple incidents linked to fatigue, microsleep episodes"]
[null,"Complexity of road and depot manoeuvres (tight spaces, blind spots)","Spacious modern depots with clear signage","Some tight roads but manageable- minimal depot congestion","Complex routes, depot design not fully suited for 12m buses","Frequent driver error during parking/ exit repeated near misses/ minor collisions at depots","Systematic depot congestion, blind spots, and cramped conditions"]
[null,"Total Score for Traffic & Operational Accidents"]
[null,"11. Human Negligence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Workforce size and turnover rate","Stable workforce with attractive wages and working conditions","Isolated resignations or transfers, efficient hiring","Periodic shortages in staffing","High resignation rate due to job stress, chronic understaffing","Inability to run services due to understaffing",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Presence of SOPs","All SOPs documented, displayed, and practiced","SOPs present but under periodic review","SOPs exist but not enforced, depot level variations in awareness","Outdated SOPs or ignored by the staff, lack of procedural clarities","No SOPs available, all operations based on informal practices",null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Training","Structured mandatory staff training – simulator based or on-field modules","Training programs run but refresher modules are infrequent","Only onboarding training provided, few skill enhancement sessions now-and-then","Ad hoc training, not standardized, staff report inadequate preparation","No formal training staff learn on the job without manuals or guidance",null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Workplace Stress Factors (long shifts, lack of resting space etc., ","Rotational shifts with adequate rest,","Slight delays during peak hours, few stresses related complaints","Pressure to meet ridership/frequency targets – drivers occasionally skip breaks","Extended shifts, strict turnaround deadlines- multiple complaints of stress and fatigue","Burnout level stress across staff, strikes or absenteeism linked to working conditions",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Total Score for Human Negligence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA"]

{"sheet":"2. Exposure Analysis","index":4,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,3,1],[2,7,3,7],[2,8,3,8],[0,0,0,16383]]}
[]
[null,"Exposure Analysis for Depots"]
[null,"Parameters","Not exposed","Slightly Exposed","Moderately Exposed","Highly Exposed","Extremely Exposed","Depot A","Depot B"]
[null,null,1,2,3,4,5]
[null,"No of E-buses in a depot","<50","50 to 75","75 to 100","100 to 150",">150"]
[null,"Number of Staff per depot (technicians, supervisors, charging operators, cleaning staff)","<30","30-50","50-75","75-100",">100"]
[null,"Facility Size and Built-up Area (sq. m.)","<3000","3000 to 10000","10000 to 15000","15000 to 30000",">30000"]
[null,"Total number of chargers","10 to 13","17 to 20","22 to 25","35 to 38","40 or more"]
[null,"Percentage of fast chargers/ depots ","<10%","11% to 25%","26% to 50%","51% to 75%","76% or more"]
[null,"Number of spare HV batteries (If applicable)","0 - 2","3 to 4","5 to 7","8 to 10",">10"]
[null,"Number of Transformers (step down)","1 to 2","-","-","-","> 2",null,null,null,null,null,null,null,1]
[null,"Number of substations providing electricity connection","1 to 2","-","-","-","> 2",null,null,null,null,null,null,null,2]
[null,"Length of cabling from Substation to Depot","< 2 Km","3 to 5 km","6 to 8km","8.1 – 10 km","> 10 km",null,null,null,null,null,null,null,3]
[null,"Proximity of the critical land use to affected depot (in km)","> 5 km","3 – 4 Km","2 – 3 km","1 - 2 km","< 1 Km",null,null,null,null,null,null,null,4]
[null,"Daily E-bus ridership per depot","< 10000",50000,100000,150000,">150000",null,null,null,null,null,null,null,5]
[null,"Number of drivers and conductors on route","<100","100 to 3400","3401 to 6700","6701 to 10000",">10000",null,null,null,null,null,null,null,"NA"]
[null,"Number of bus stops on routes assigned to the depot","<50","50 to 1200","1201 to 2350","2351 to 3500",">3500"]
[null,"Exposure Score for a Depot",null,null,null,null,null,{"$f":"AVERAGEIF(H5:H17,\"<>*(NA)\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(I5:I17,\"<>*(NA)\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"3. Vulnerability Analysis","index":5,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,3,1],[2,7,3,7],[2,8,3,8],[0,0,0,16383],[1,0,1048575,0]]}
[]
[null,"Vulnerability Scores for a Depot"]
[null,"Vulnerability parameters","Not Vulnerable","Slightly Vulnerable","Moderately Vulnerable","Highly Vulnerable","Extremely Vulnerable",{"$f":"'2. Exposure Analysis'!H3","v":"Depot A"},{"$f":"'2. Exposure Analysis'!I3","v":"Depot B"}]
[null,null,1,2,3,4,5]
[null,"% buses with battery SOH< 80% ","<10%","10% to 25%","25% to 50%","50% to 75%",">75%"]
[null,"Presence of onboard fire safety systems (FDSS, FDAS, etc.)","FDSS+ FAS + FPS (In engine and passenger compartment)","FDSS+ FPS (in Passenger Area)","FDSS+ FAS (in Passenger Area)","FDAS (Passenger Compartment only)","FDAS (Engine Compartment only)",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Ingress protection standard of e-bus fleet","Greater than IP 67 (e.g. IP 68 or IP 69K)","-","IP 67","-","Lower than IP 67",null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Real-time monitoring of batteries using BMS","Available","-","-","-","Not available",null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Availability of driver’s console for communication and monitoring of vehicle","Available","-","-","-","Not available",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Frequency of maintenance of e-buses","Twice a week","Weekly","Bi-weekly","Monthly","Quarterly",null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Time taken to rectify identified defects & deficiencies in fleet","Daily","Weekly","Bi-weekly","-","-",null,null,null,null,null,null,null,null,null,null,null,null,"NA"]
[null,"Availability of alternate route plan for e-buses during emergency situations","Available","-","-","-","Not available"]
[null,"Type of depot","Only e-bus depot ","-","-","-","Hybrid Depot "]
[null,"Age of chargers (in years)","<2","2 to 5","5 to 7","7 to 10",">10"]
[null,"Ratio of monitoring personnel per depot (including night shifts)","1 personnel for 10 buses or less","-","1 personnel for 10 to 15 buses ","-","1 personnel for 15 buses or more"]
[null,"Clearance from Fire Department for the e-bus depot","Involvement of fire department in depot planning","-","-","-","No Objection Certificate from Fire Department"]
[null,"Clearance from explosive department for the e-bus depot","Yes","-","-","-","No"]
[null,"Compliance of e-bus terminals and bus stops with fire safety standards ","Comply with all of these","-","Comply with some of these","-","No compliance"]
[null,"Dedicated zone for faulty e-buses","Physical separation with fire resistant material","Physical separation but no fire-resistant material","Dedicated zone but no structural separation","No dedicated zone but spatial separation btw 5-10m","No dedicated zone"]
[null,"Presence of multiple entry/exits and evacuation signages","Yes","-","-","-","No"]
[null,"Presence of early warning systems for potential natural hazards ","SMS alerts (IMD/ NDMA/ SDMA)  and Weather Forecasting Device","-","One of the early warning systems is present","-","Absent"]
[null,"Presence of depot level fire detection and suppression systems (smoke detectors, fire extinguishers, automated water sprinklers, fire hydrants)","Both detection and suppression systems available","-","Only detection or suppression systems available","-","None of them are available"]
[null,"Presence of safety equipment (PPE, lockout/tagout procedures, specialized tools for working on high-voltage systems)","All of them are available","-","-","-","None of them are available"]
[null,"Use of armoured and color-coded cables (connection from substation to meter to transformer to chargers)","Available","-","-","-","Not Available"]
[null,"Presence of real-time monitoring system for electricity fluctuations","Available","-","-","-","Not Available"]
[null,"Safety Requirements (Grounding, surge protection, and insulation quality)","Available","-","-","-","Not Available"]
[null,"Presence of more than 1 grid connection","> 1 grid connection with adequate RE Storage","> 1 grid connection with limited backup","> 1 grid connection","single grid connection with limited backup","single grid connection without backup"]
[null,"Frequency of repair and maintenance of charging stations","Monthly","Quarterly","Half-yearly","Yearly","In more than a year"]
[null,"Frequency of maintenance of transformers and cabling","Monthly","Quarterly","Half-yearly","Yearly","In more than a year"]
[null,"Frequency of third-party safety audit of e-bus depot","Quarterly","Half yearly","Annually","Every two years","No Third-Party Auditing"]
[null,"SoPs for handling, operating, and maintaining charging infrastructure","Available","-","-","-","Not Available"]
[null,"SoPs for emergency power cutoff at transformer level","Available","-","-","-","Not Available"]
[null,"Evacuation Plan for depot staff and buses for various hazards","Available","-","-","-","Not Available"]
[null,"Evacuation protocols or guidelines for on-board passengers","Available","-","-","-","Not available"]
[null,"Frequency of Refresher Driver Trainings","Monthly","Quarterly","Half-yearly","Yearly","In more than a year"]
[null,"Frequency of Emergency response trainings for drivers and conductors","Monthly","Quarterly","Half-yearly","Yearly","Only at the time of induction"]
[null,"Frequency of Emergency response trainings for depot staff and STU officials","Monthly","Quarterly","Half-yearly","Yearly","Only at the time of induction"]
[null,"Inclusion of E-bus related hazards in state/district-level disaster management plans","Included","-","-","-","Not included"]
[null,"Coordination protocols between city disaster management officials and transit authorities","Available","-","-","-","Not available"]
[null,"Vulnerability Score for a Depot",null,null,null,null,null,{"$f":"AVERAGEIF(H5:H39,\"<>*(NA)\")","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(I5:I39,\"<>*(NA)\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"4. Risk Score","index":6,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[19,1,20,1],[1,1,1,6],[15,1,15,6],[10,1,10,6],[17,2,17,3],[2,4,7,4],[0,0,0,9],[1,0,1048575,0],[8,1,9,6],[13,1,14,6],[16,1,16,6],[17,4,17,6],[18,1,18,6],[19,4,32,4],[26,5,32,6],[33,1,1048575,16383],[14,8,32,16383],[0,10,13,16383],[1,7,32,7],[19,2,19,3],[19,5,19,6],[1,8,1,9]]}
[]
[null,"Consequence Scores for Depot",null,null,null,null,null,null,"Hazard score summary"]
[null,null,{"$f":"'2. Exposure Analysis'!H3","v":"Depot A"},{"$f":"'2. Exposure Analysis'!I3","v":"Depot B"},null,null,null,null,"Hazard",{"$f":"'1. Hazard Analysis'!H3","v":"City A"}]
[null,{"$f":"'2. Exposure Analysis'!B18","v":"Exposure Score for a Depot"},{"$f":"'2. Exposure Analysis'!H18","v":{"$error":"#DIV/0!"}},{"$f":"'2. Exposure Analysis'!I18","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'1. Hazard Analysis'!B5","v":"1. Floods"},{"$f":"'1. Hazard Analysis'!H13","v":0}]
[null,{"$f":"'3. Vulnerability Analysis'!B40","v":"Vulnerability Score for a Depot"},{"$f":"'3. Vulnerability Analysis'!H40","v":{"$error":"#DIV/0!"}},{"$f":"'3. Vulnerability Analysis'!I40","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'1. Hazard Analysis'!B14","v":"2. Earthquakes"},{"$f":"'1. Hazard Analysis'!H18","v":0}]
[null,"Weightage of Exposure",0.7,0.7,null,null,null,null,{"$f":"'1. Hazard Analysis'!B19","v":"3. Cyclones and Storms"},{"$f":"'1. Hazard Analysis'!H24","v":0}]
[null,"Weightage of Vulnerability",0.3,0.3,null,null,null,null,{"$f":"'1. Hazard Analysis'!B25","v":"4. Extreme Temperatures"},{"$f":"'1. Hazard Analysis'!H30","v":0}]
[null,"Consequence Score",{"$f":"(C4*$C$6)+(C5*$C$7)","v":{"$error":"#DIV/0!"}},{"$f":"(D4*$C$6)+(D5*$C$7)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"'1. Hazard Analysis'!B31","v":"5. Battery Fire and Thermal Runaway"},{"$f":"'1. Hazard Analysis'!H36","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'1. Hazard Analysis'!B37","v":"6. Power Failure and Grid Instability"},{"$f":"'1. Hazard Analysis'!H40","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'1. Hazard Analysis'!B41","v":"7. Cyber Threats to Depot Management Systems"},{"$f":"'1. Hazard Analysis'!H46","v":0}]
[null,"Legend for consequence score",null,null,null,null,null,null,{"$f":"'1. Hazard Analysis'!B47","v":"8. Technological Obsolescence"},{"$f":"'1. Hazard Analysis'!H50","v":0}]
[null,"Value to be used","Very Low (1)","Low (2)","Moderate (3)","High (4)","Very High (5)",null,{"$f":"'1. Hazard Analysis'!B51","v":"9. Protests, Strikes and Vandalism"},{"$f":"'1. Hazard Analysis'!H55","v":0}]
[null,"Consequence Score","1-1.8 ","1.9-2.6 ","2.7-3.4 ","3.5-4.2 ","> 4.2",null,{"$f":"'1. Hazard Analysis'!B56","v":"10. Traffic and Operational Accidents"},{"$f":"'1. Hazard Analysis'!H60","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'1. Hazard Analysis'!B61","v":"11. Human Negligence"},{"$f":"'1. Hazard Analysis'!H66","v":0}]
[]
[null,"Risk Scoring for a Depot"]
[]
[null,"Risk Score  = ","(Hazard * Consequence Value)"]
[]
[null,"Type of Hazard","Risk Score",null,null,"Legend"]
[null,null,{"$f":"C3","v":"Depot A"},{"$f":"D3","v":"Depot B"},null,"Risk Level","Risk Scores"]
[null,{"$f":"I4","v":"1. Floods"},{"$f":"J4*$C$8","v":{"$error":"#DIV/0!"}},{"$f":"J4*$D$8","v":{"$error":"#DIV/0!"}},null,"Very Low Risk","1 to 4"]
[null,{"$f":"I5","v":"2. Earthquakes"},{"$f":"J5*$C$8","v":{"$error":"#DIV/0!"}},{"$f":"J5*$D$8","v":{"$error":"#DIV/0!"}},null,"Low Risk","5 to 8"]
[null,"3. Cyclones and Storms",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Moderate Risk","9 to 12"]
[null,"4. Extreme Temperatures",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"High Risk","13 to 16"]
[null,"5. Battery Fire and Thermal Runaway",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Very High Risk","17 to 20"]
[null,"6. Power Failure and Grid Instability",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"I10","v":"7. Cyber Threats to Depot Management Systems"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"8. Technological Obsolescence",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"9. Protests, Strikes and Vandalism",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"I13","v":"10. Traffic and Operational Accidents"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"I14","v":"11. Human Negligence"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Risk Level of The Depot",{"$f":"F22","v":"Very Low Risk"},{"$f":"F23","v":"Low Risk"}]