{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":[" Page 1","Page 2","RR Indicators","Scale","CR Indicators","EI Indicators","RR-Results","RR-Graphs","CR-Results","CR-Graphs","EI-Results","Main Dashboard","EI-Graphs","OverAll Analysis","Sheet1","Answers for the results"],"not_rendered":{"charts":25,"images":4,"macros":1,"external_links":0,"defined_names":27,"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":" Page 1","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,2],[2,0,2,2],[9,0,9,2],[3,0,3,2],[12,0,12,2],[8,0,8,2],[10,0,10,2],[11,0,11,2]]}
[]
[]
[]
["Building Back Better (BBB) is a  holistic approach taken following a pandemic to improve the physical, social and economic conditions of affected communities during the during/post-pandemic recovery process in an effective and efficient way.  BBB is centred around the local community's best interests.  A recovery effort that aims to build back better consists of three focus areas: Risk Reduction, Community Recovery and Effective Implementation."]
[]
[]
[]
[]
["Build Back Better Framework, © Mannakkara 2020"]
["For more information about Build Back Better framework please follow the links below"]
["https://buildbackbetter.co.nz/wp-content/uploads/2017/02/Reconceptualising-BBB_published-ppr.pdf  "]
[" "]
["Build Back Better Tool for Planning and Implementing Post-Pandemic Recovery uses indicators derived from International case studies and literature review based on Build Back Better Framework developed by Manakkara and Wilkinson."]
[]
["Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"Page 2","index":1,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,1,3],[20,0,21,0],[20,1,21,1],[20,2,21,2],[3,0,3,2],[4,0,4,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[18,0,18,2],[22,0,22,2],[28,0,28,2],[47,0,47,2],[46,0,46,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2]]}
[]
[]
[]
["Features of BBB Tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions for using the BBB Tool to assess the recovery"]
["Rate","Evaluate","Improve"]
["Rate the BBB indicators listed under each BBB Principle based on your current practices","Evaluate the results from the output to identify performance in-line with BBB concepts.  Explore how and why performance under the BBB Principles varied. ","Identify the BBB gaps in the recovery effort and brainstorm practical solutions to overcome the obstacles faced to improve BBB ratings."]
[]
["Please enter your details here"]
["Name"]
["Organisation"]
["Date"]
["Location"]
[]
["Start with any BBB dimension below (Risk Reduction or Community Recovery or Effective implementation)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This online assessment tool can be used for general assessment of recovery. The reliability of assessment depends on the judgement of users.  Genuine and impartial rating by users can increase the reliability of this tool."]

{"sheet":"RR Indicators","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,0,25,0],[22,10,25,10],[22,11,25,11],[15,0,15,11],[16,0,20,0],[16,10,20,10],[16,11,20,11],[21,0,21,11],[0,0,0,11],[1,0,1,11],[3,0,14,0],[3,10,14,10],[3,11,14,11]]}
["BUILD BACK BETTER TOOL"]
["1.  Risk Reduction"]
["BBB Principle","Indicator code","Indicators",null,"0 (Not applicable)",1,2,3,4,"ANSWER","Your Rating","Max Rating","Max Rating"]
["1.1 Health Sector Resilience Strengthening the health sector to withstand emergency/ pandemic","HR1","Knowledge of the hazard (Understanding of thealth hazards affecting individual or community and resulting risks and vulnerabilities)",null,"Not applicable","Poor or outdated understanding of diseases and no accurate knowledge of risks and vulnerabilities","Very little knowledge of diseases affecting the community and resulting risks and vulnerabilities","Moderate knowledge of diseases affecting the community and its resulting risks and vulnerabilities","Accurate, up-to-date understanding of all the diseases affecting individuals or community and their resulting risks and vulnerabilities",null,{"$f":"SUM(J4:J15)","v":0},{"$f":"SUM(M4:M15)","v":0},{"$f":"IF(J4>0,4,0)","v":0}]
[null,"HR2","Health infrastructure (Hospitals equipped with good quality infrastructure and medical equpiment)",null,"Not applicable","Poor availability of medical equipment available and facilities at the hospital","Only limited good quality medical equipment is available. Facilities at the hopsital are mediocre. ","Medical equipment is mostly good quality. Majority of hospital facilities are available during emergency/pandemic situations","Hospitals equipped with good quality equipment related to the disease (e.g. ventilators, testing kits, etc.) and there are adequate facilities (beds, toilets, water, safe waste management, etc.) to accommodate high demands during emergency/pandemic situations ",null,null,null,{"$f":"IF(J5>0,4,0)","v":0}]
[null,"HR3","Medical supplies",null,"Not applicable","Insufficient medical supplies are available. Usually need to refer to neighbouring hospitals ","Limited medical supplies are available. Typically can't manage during emergencies. In case of shortage, need to rely on the neighbouring hospitals ","Moderate medical supplies are available and able to manage medical emergencies most of the time. In case of shortage, there is an adhoc plan to acquire the necessary medical supplies","Adequate medical supplies are available and emergencies are efficiently managed. In case of shortage, an effective plan is in place to acquire the necessary medical supplies from the health network",null,null,null,0]
[null,"HR4","Communication with stakeholders (Communicating with stakeholders and health networks to know the community's needs and demands and disseminate health information to the community)",null,"Not applicable","No or little communication with stakeholders to gather information on community's needs and demands and disseminate up to date health information to the community","Sporadic communication of the community's needs and demands and dissemination of up to date health information to the community","Moderate communication of the community's needs and demands and dissemination of up to date health information to the community","Regular and well-thought out communication with stakeholders and health network to gather community's needs and demands prior to developing strategy plans during emergencies. Regular and well-thought out disseminatino of up to date health information to the community based on the developed strategy and plans",null,null,null,0]
[null,"HR5","Extra funding (Plan for supporting future demand of resources like equipment, medication, staff etc.)",null,"Not applicable","No planning at all for extra funding","Little planning for extra funding with regards to medical supplies and staff for emergencies","Plans for long term funding for medical supplies and staff during uncertainties is available but there is no support provided by the government","Long-term funding mechanisms is in place to fund extra costs  incurred to purchase medical supplies and hire medical professionals and staff during emergencies",null,null,null,0]
[null,"HR6","Equity and cross-cutting issues (Equity in health services and consideration of cross-cutting issues)",null,"Not applicable","No consideration of equity and cross-cutting issues","Socio-cultural factors, equity and cross-cutting issues are considered sometimes","Socio-cultural factors, equity and cross-cutting issues are considered most of the time","Social and cultural factors, equity and cross-cutting issues are carefully considered in the provision of health services",null,null,null,0]
[null,"HR7","Staff and their welfare (Taking care of the staff by avoiding overworking)",null,"Not applicable","Very limited number of staff are available at the hospital/s, and they overwork daily","Only limited number of staff are available at the hospital/s, and they over work frequently","Moderate number of staff are available at the hospital/s, but they rarely have to overwork","Adequate number of staff are available at the hospital/s to avoid over working. Flexible working time and access to psycho-socio care is available to the staff",null,null,null,0]
[null,"HR8","Redundancy and transitional arrangements (Arrange transitional facilities to relieve pressures to avoid exhausting available resources)",null,"Not applicable","No redundancy and transitional arrangements ","High pressure during emergencies due to inefficient redundancy and transitional arrangements ","Mediocre redundancy and transitional arrangements are in place but creates pressure at times","Transitional arrangements in place to relieve pressures during emergencies (e.g. transitional shelters/accommodation/facilities, alternative medical suppliers etc.)",null,null,null,0]
[null,"HR9","Quality Assurance (Quality assurance measures for emergency environments)",null,"Not applicable","No quality assurance in place","Complicated inefficient quality assurance mechanisms in place that are inappropriate for high pressure emergency/pandemic environments","Quality assurance mechanisms in place and are carried out to some extent","Practical, uncomplicated and efficient quality assurance measures in place appropriate for emergency/pandemic environments",null,null,null,0]
[null,"HR10","Incentives to attract skilled nurses/caretakers (Incentives to attract skilled certified nurses/caretakers to meet emergency demands)",null,"Not applicable","No incentives at all","Use of unskilled, uncertified nurses/caretakers during emergencies/pandemics due to an inability to meet the demands","Incentives are provided to attract skilled nurses/caretakers to work at some hospitals","Incentives or special arrangements planned and in place to attract skilled certified nurses/caretakers to meet  demands during emergencies or pandemics",null,null,null,0]
[null,"HR11","Professional supervision (Professional supervision of junior/unqualified/inexperienced healthworkers during emergencies)",null,"Not applicable","No professional supervision available","Very limited professional staff to supervise","Professional supervision is available most of the time during emergencies/pandemics","Professional supervision is available all the time",null,null,null,0]
[null,"HR12","Recovery advisory services (to support, educate and assist patients and their families to recover)",null,"Not applicable","No advisory services","Affected individual or families are isolated during emergencies/pandemic with no support or information regarding the emergency creating chaos","Limited support is available to support the affected individual or families during emergencies","Advisory service with medical professionals in place to support, educate and assist affected individuals or families during emergencies/pandemics",null,null,null,0]
[]
["1.2. Risk-based Zoning  Systematic risk based zoning of areas to contain or manage disease spread.","RZ1","Risk Zone Maps (creating clear risk zone maps for diseases/pandemic)",null,"Not applicable","No Risk Zone Maps","Poor or outdated knowledge of disease/pandemic risks","Good knowledge of disease/pandemic spread, but no maps created","Accurate, clear risk zone maps created for diseases/pandemics",null,{"$f":"SUM(J17:J21)","v":0},{"$f":"SUM(M17:M21)","v":0},{"$f":"IF(J17>0,4,0)","v":0}]
[null,"RZ2","Risk Zone-based Activity Maps (Maps generated based on up-to-date risk zone maps detailing types of activities allowed/restricted to contain or manage the disease/pandemic)",null,"Not applicable","Activities are never restricted in response to modified risk levels","Activity allowances/restrictions based on risk zone maps are determined but not communicated effectively","Activity allowances/restrictions based on risk zone maps are updated regularly and communicated but not enforced","Activity allowances/restrictions based on risk zone maps are updated regularly and enforced",null,null,null,{"$f":"IF(J18>0,4,0)","v":0}]
[null,"RZ3","Risk Zone-based Staff and Resource Allocations (Allocation of staff based on risk zones)",null,"Not applicable","Not at all considered","Facilitations are rarely provided to assist or encourage the distribution of staff and resources to high risk areas to manage emergencies/pandemics","Facilitations are  provided most of the time to assist or encourage the distribution of staff and resources to high risk areas to manage emergencies/pandemics","Adequate facilities available to encourage the relocation of staff and resources to high risk areas to manage emergencies/pandemics",null,null,null,{"$f":"IF(J19>0,4,0)","v":0}]
[null,"RZ4","Temporary isolation plans (Temporary resettlement plans to isolate affected people to minimise or contain pandemic outbreaks)",null,"Not applicable","Never considered","Resettlement for isolation opted for without considering other options, or resettlement/isolation performed with no consideration for the needs and wellbeing of affected individuals","Resettlement for isolation opted for with due consideration of other options, but little consideration given to the needs and wellbeing of affected individuals","In the instance where resettlement for isolation is opted for as a last resort, a comprehensive temporary resettlement plan is in place minimising disruption and supporting affected individuals",null,null,null,{"$f":"IF(J20>0,4,0)","v":0}]
[null,"RZ5","Risk-based Zoning and Activity Education (Educating stakeholders and the community regarding risk-based zoning and activities during emergencies/pandemics)",null,"Not applicable","No communication and education provided to stakeholders and the community","Little communication and education provided to stakeholders and the community on risk-based zoning and activity plans for emergencies/pandemics","Stakeholders and communities are educated most of the time on risk-based zoning and activity plans for emergencies/pandemics","Education and regular communication to stakeholders and the community on risk-based zoning and activity plans for emergencies/pandmics on risk zones and land-use plans",null,null,null,{"$f":"IF(J21>0,4,0)","v":0}]
[" "]
["1.3 Early Warning and Risk Reduction Education\nEarly warning mechanisms along with educating stakeholders and the community on health emergencies and risks employed complementarily to strategies for health sector resilience and risk-based zoning initiatives to reduce a community's risks. ","EW1","Hazard prediction (Outbreak prediction)",null,"Not applicable","No hazard/outbreak prediction systems available","Hazard/outbreak predictions poor.  Local and international knowledge disregarded","Hazard/outbreak prediction system is in place but local and international inputs are considered only if needed","Advanced models for hazard/outbreak predictions with different scenarios (optimistic, pessimistic and most likely) using science and technology are available to improve the accuracy of hazard predictions. Local and international knowledge inputs used ",null,{"$f":"SUM(J23:J26)","v":0},16,{"$f":"IF(J23>0,4,0)","v":0}]
[null,"EW2","Early warning systems (Early warning systems to disseminate information during an emergency/pandemic)",null,"Not applicable","No early warning systems","Early warning systems put in place are inappropriate, ineffective or unusable by the local community","Early warning systems put in place are appropriate but unusable by the local community","Early warning systems appropriate to the local community are employed using a combination of new technology and local knowledge and traditional methods to disseminate timely information",null,null,null,{"$f":"IF(J24>0,4,0)","v":0}]
[null,"EW3","Education on risk reduction measures (Educating stakeholders and communities on preparedness and risk reduction measures)",null,"Not applicable","No education provided to stakeholders and communities on risk reduction methods for diseases/pandemics","Little education and information provided to the community and stakeholders on prevalent disease/pandemic risks, risk reduction and preparedness methods","Education and information provided sporadically to the community and stakeholders  on prevalent disease/pandemic risks, risk reduction and preparedness methods","Accurate, regular, practical education and information provided to the community and stakeholders on disease/pandemic risks. Preparedness and practical risk reduction methods are in place and communicated",null,null,null,{"$f":"IF(J25>0,4,0)","v":0}]
[null,"EW4","Support and Training (Support and training for local organisations (hospitals, clinics, etc.) and stakeholders on early warning and risk reduction)",null,"Not applicable","No support at all","Organisations and stakeholders in the local community are rarely supported to help them prepare for and operate after an emergency/pandemic event","Organisations and stakeholders in the community are supported most of the time to help them prepare for and operate after an emergency/pandemic event","Training and resources provided regularly to local organisations, health workers, and stakeholders on early warning systems and risk reduction methods to help them prepare for and operate after an emergency/pandemic event",null,null,null,{"$f":"IF(J26>0,4,0)","v":0}]
[]
[null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"Scale","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Definitely not, probably not, might or might not, probably yes, Definitely Yes"]
[]
["Not at all, small degree, moderate degree, high degree, very high degree","https://www.google.com/search?q=yes+no+likert+scale&rlz=1C1CHBF_enNZ770NZ770&source=lnms&tbm=isch&sa=X&ved=0ahUKEwjPg5a7sM7fAhWEabwKHZBdAisQ_AUIDigB&biw=767&bih=710&dpr=1.25#imgrc=CpUXrD4phRanBM:"]
[]
[]
["None at all, A little, A moderate amount, A lot, A great deal"]
["Not well at all, slightly well, moderately well, very well, extremely well"]
["Not knowledgable at all, slightly knowledgeable, moderately knowledgeable, very knowledgeable, extremely knowledgeable"]
["Extremely slow, somewhat slow, avegrage slow, somewhat fast, extremely fast"]
["Not effective at all, slighlt effective, moderatley effective, very efective, extremely effective"]
["Never, sometimes, most of the time, always","Frequency sca"]

{"sheet":"CR Indicators","index":4,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,12],[11,1,20,1],[11,11,20,11],[11,12,20,12],[3,1,9,1],[3,11,9,11],[3,12,9,12]]}
[null,"BUILD BACK BETTER TOOL"]
[null,"2. Community Recovery"]
[null,"BBB Principle","Indicator code","Indicators",null,"0 (Not applicable)",1,2,3,4,"ANSWER","Your Rating","Max Rating","Max Rating"]
[null,"2.1 Psychological and Social Recovery \nRestoring community wellbeing and strengthening the community’s ability to bounce back by supporting and empowering the community. ","PR1","Community Advisory Service (Advisory service to provide information on emergencies/pandemics and connect with affected households)",null,"Not applicable","No single, reliable source of information and support for the community to consult","Some ad-hoc information provided to the community but no service in place for the community to consult","Community advisory service is in place but difficult to reach","Community advisory services established to provide information and connect with affected households ",null,{"$f":"SUM(K4:K10)","v":0},{"$f":"SUM(N4:N10)","v":0},{"$f":"IF(K4>0,4,0)","v":0}]
[null,null,"PR2","Specialised assistance to vulnerable groups (providing specialised assistance to support them)",null,"Not applicable","No assistance at all","Little to no information on vulnerable groups in the community and no specialised assistance to support them","Vulnerable groups in the community are identified but no specialised assistance to support them","Vulnerable groups in the community identified and specialised assistance organised to support them",null,null,null,{"$f":"IF(K5>0,4,0)","v":0}]
[null,null,"PR3","Psychological support and counselling services (Providing psychological support and counselling services to the community)",null,"Not applicable","No counselling services available","Some psychological support and counselling services provided to the community","Psychological support and counselling services provided to the community most of the time","Psychological support and counselling services are well organised for the community",null,null,null,0]
[null,null,"PR4","Alternative activities to create community togetherness during emergency/pandemic situations (Organising activities and support groups to bring the community together)",null,"Not applicable","No consideration given to bring the community together and build community cohesion","Little consideration given to planning and implementing activities to bring the community together and build community cohesion","Support groups are formed and appropriate alternative activities (e.g. Online activities, events and groups) are planned but there is a lack of cohesion among the community due to poor execution","Appropriate alternative activities and support groups organised to bring the community together and build social cohesion during emergencies/pandemics. Sense of community and togetherness created",null,null,null,0]
[null,null,"PR5","Informing the Community (Informing the community regularly on recovery decisions and progress)",null,"Not applicable","No communication with the community at all","Irregular communication with the community to inform and update on recovery decisions and progress ","Communication with the community only when deemed necessary by authorities to inform and update on recovery decisions and progress  ","Community informed regularly on recovery decisions and progress using appropriate channels",null,null,null,0]
[null,null,"PR6","Community input (Incorporating bottom-up approaches)",null,"Not applicable","No community input is taken into consideration ","Mostly top-down approach employed with little community input taken into consideration for planning and implementing emergency/pandemic management and recovery","Community is involved most of the time while planning and implementing emergency/pandemic management and recovery activities","Community empowered by incorporating bottom-up approaches for emergency/pandemic management and recovery",null,null,null,0]
[null,null,"PR7","Transparency in recovery decisions (Maintaining full transparency with affected communities)",null,"Not applicable","No transparency with local community ","Top-down decisions made with vague explanations given to the community","Most of the time the community is informed with regards to major emergency/pandemic management and recovery decisions","Full transparency maintained with affected communities with regards to emergency/pandemic management and recovery decisions",null,null,null,0]
[null," "]
[null,"2.2  Economic Recovery  \nRestore and rejuvenate businesses and the economy post-emergency/pandemic","ER1","Economic recovery strategy plan (Strategy created catering to local needs)",null,"Not applicable","No Economic Recovery Strategy","Impromptu strategy developed without local input and consideration of local livelihoods","Economic strategy developed with little local inputs and consideration of local livelihoods","Tailor-made economic recovery strategy developed catering to local needs using information collected from locals and local councils ",null,{"$f":"SUM(K12:K21)","v":0},{"$f":"SUM(N12:N21)","v":0},0]
[null,null,"ER2","Supporting locals to rejuvenate businesses (Empowering and supporting locals to re-establish their livelihoods)",null,"Not applicable","No support at all","Little consideration given to re-establish traditional and pre-emergency/pandemic livelihoods","Re-establishment of traditional and pre-emergency/pandemic livelihoods are considered most of the time. Rejuvenation and upgrading of livelihoods for better opportunities are supported when necessary/requested","Locals empowered and supported to re-establish traditional and pre-emergency/pandemic livelihoods and to upgrade facilities (eg: online orders, work from home) and technologies (eg:EFTPOS machine for contact-less payment) for business rejuvenation if appropriate",null,null,null,0]
[null,null,"ER3","Alternative livelihood options (Introducing new livelihood options utilising local resources)",null,"Not applicable","No alternative livelihood options provided","Alternative livelihood options provided to a few in the event that restoring traditional and pre-emergency/pandemic livelihoods is not feasible.  Taking advantage of local resources overlooked","Alternative livelihood options are available to most people in the event that restoring traditional and pre-emergency/pandemic livelihoods is not feasible. Use of local resources are taken into account sometimes","New livelihood options (e.g. Delivery-based services during/after pandemics) utilising local resources introduced and opportunities for upskilling provided to cater to skills shortages",null,null,null,0]
[null,null,"ER4","Supporting economic restoration (Restoration of economic activities)",null,"Not applicable","No consideration given to restoration of economic activities","Little consideration given to ways of restoring key economic activities/sectors","Planning and implementing an economic recovery strategy considered most of the time to support restoration of key economic activities/sectors","Restoration of key economic activities/sectors planned and implemented (E.g. local industries and attractions advertised and promoted to appeal to residents and tourists)",null,null,null,0]
[null,null,"ER5","Tracking economic recovery (Measurement tool to track economic recovery progress)",null,"Not applicable","No formal tracking of economic recovery to assess progress","Complicated and impractical measurement tool to track economic recovery to assess progress is available","Mediocre measurement tool is available to track the economic recovery and assess progress","A simplified measurement tool adopted to track economic recovery progress",null,null,null,0]
[null,null,"ER6","Government support (Support to assist business recovery)",null,"Not applicable","No support at all","Little support from the Government to assist business recovery","Moderate support from the Government to assist business recovery","Government support provided to assist business recovery (e.g. provision of special Government grants and flexible low-interest loans) ",null,null,null,0]
[null,null,"ER7","Business advisory services (Services to support and advise businesses)",null,"Not applicable","No advice provided to businesses","Some advice is provided to businesses to support them in recovery.  Businesses left to recover on their own","Businesses are supported and advised most of the time","Business advisory services put in place to support and advise businesses",null,null,null,0]
[null,null,"ER8","Speedy business recovery (Supporting speedy re-establishment of businesses)",null,"Not applicable","No facilitations or support provided","Little support and facilitations put in place to speed up the re-establishment and rejuvenation of businesses","Some support and facilitations in place to support most businesses ","Speedy re-establishment of businesses supported (e.g. setting up temporary online based retail/work for businesses, fast-tracked permit procedures, incentives provided to workers)",null,null,null,0]
[null,null,"ER9","Alternative business options (Alternative options such as introducing a big business to boost the economy)",null,"Not applicable","No alternative options considered","Alternative options to boost economic recovery are considered rarely if progress is slow or unsatisfactory","Alternative options to boost economic recovery are planned after an emergency situation and considered if progress is unsatisfactory","Alternative options are pre-planned and executed if economic recovery progress is poor ",null,null,null,0]
[null,null,"ER10","Information to community (Informing local community regularly on economic recovery plans)",null,"Not applicable","No communication","Little communication about economic recovery plans and progress to the local community or tourists.  Locals have low morale and confidence about economic vitality and opportunities, which may encourage relocation","Specific/major information about economic recovery plans and progress is communicated to the local community or tourists.  Locals have moderate morale and confidence about economic vitality and opportunities","Local community regularly informed on all the economic recovery plans and progress to encourage residents and boost morale",null,null,null,0]
[]
[]
[null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"EI Indicators","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,12],[20,1,22,1],[20,11,22,11],[20,12,22,12],[3,1,13,1],[3,11,13,11],[3,12,13,12],[15,1,18,1],[15,11,18,11],[15,12,18,12],[19,1,19,12],[1,1,1,12]]}
[null,"BUILD BACK BETTER TOOL"]
[null,"3. Effective Implementation"]
[null,"BBB Principle","Indicator code","Indicators",null,"0 (Not applicable)",1,2,3,4,"ANSWER","Your Rating","Max Rating","Max Rating"]
[null,"3.1 Institutional Mechanism      Choosing an appropriate institutional mechanism to plan and implement recovery and long-term resilience building activities","IM1","Recovery Authority (Creating a local-level separate body to plan, implement and manage recovery activities)",null,"Not applicable","No Recovery Authority at all","Ad-hoc, reactive, uncoordinated recovery planning and implementation by individual organisations, or an external Recovery Authority created with little to no involvement of local government and local leaders","Coordinated recovery planning and implementation by individual organisations, or an external Recovery Authority created with some involvement of local government and local leaders","A local-level body most suited to the local context consisting of local government and local community representation chosen to plan, implement and manage recovery activities, and facilitate coordination and partnerships between stakeholders involved in recovery ",null,{"$f":"SUM(K4:K14)","v":0},{"$f":"SUM(N4:N14)","v":0},{"$f":"IF(K4>0,4,0)","v":0}]
[null,null,"IM2","Level of Centralisation/ Decentralisation (Selecting the level of centralisation and/or decentralisation most suited to the local context)",null,"Not applicable","Level of centralisation/decentralisation unclear or inappropriate for the local community context","Level of centralisation/decentralisation sometimes inappropriate for the local community context","Level of centralisation and/or decentralisation appropriate most of the time for local context","Level of centralisation and/or decentralisation most suited to the local context and community chosen to combine central-level coordination of recovery with decentralised planning and implementation",null,null,null,{"$f":"IF(K5>0,4,0)","v":0}]
[null,null,"IM3","Supporting impacted organisations (Strengthening the capacity of impacted organisations)",null,"Not applicable","No support provided to organisations impacted during pandemic","Little support provided to the organisations impacted by pandemic, who are key local stakeholders such as hospitals to take part in recovery","Moderate support provided to organisations impacted by pandemic","Significant support provided and capacity of impacted organisations  strengthened (eg: hospitals/clinics)  to be able to take part in recovery",null,null,null,0]
[null,null,"IM4","Defining Roles and Responsibilities for Stakeholders (Determining stakeholder’s roles and responsibilities to avoid ad-hoc and duplicated activities)",null,"Not applicable","No clear roles and responsibilities for health workers and health network stakeholders leading to ad-hoc and duplicated activities","Only a few roles and responsibilities are defined ","Most of the health workers, and stakeholder's roles and responsibilities are defined","Clear roles and responsibilities established for all health workers and stakeholders in the health network",null,null,null,0]
[null,null,"IM5","Recovery fund (Fund for emegency/pandemic recovery)",null,"Not applicable","No recovery funding mechanism in place","Ad-hoc funding arrangements with little control and accountability on funds received and spent for recovery ","Funding arrangements are in place with control most of the time and accountability on funds received and spent for recovery ","An exclusive, singular fund for recovery created to direct all funds dedicated to recovery into one pool for clear accountability and allocation for different recovery needs",null,null,null,0]
[null,null,"IM6","Information Database (Information database for easy and transparent access)",null,"Not applicable","Does not exist","Poor information storage and sharing. Poor set information database","Average information storage, sharing and set information database","Thorough information database maintained with systems for easy and transparent access to information between stakeholders involved in the recovery",null,null,null,0]
[null,null,"IM7","Multi-stakeholder meetings (To discuss, plan and implement recovery activities)",null,"Not applicable","No meetings at all","Little to no collaboration and communication between the various stakeholders involved in recovery. As a result, recovery activities duplicated and uncoordinated","Stakeholders involved in the recovery collaborate and communicate most of the time. Some recovery activities are duplicated and uncoordinated","Effective partnerships fostered by holding multi-stakeholder meetings held regularly to discuss, plan and implement recovery activities avoiding duplication and allowing consultation and information exchanges between stakeholders",null,null,null,0]
[null,null,"IM8","Partnership (Creating a formal partnership for stakeholder cooperation and coordination)",null,"Not applicable","No partnership and collaboration between stakeholders. ","Little partnership and collaboration between stakeholders. Information needed for recovery work inaccessible by stakeholders due to restricted privacy and confidentiality rules","Partnership and collaboration between stakeholders are created most of the time. Information is restricted due to privacy and confidentiality rules but given to stakeholders on request","Formal partnerships created (e.g. health organisations of neighbhouring communities, WHO) for stakeholder cooperation and coordination. Systems generated for easy and transparent access to information between stakeholders ",null,null,null,0]
[null,null,"IM10","Quality assurance for recovery activities (Qualified reputed stakeholders for recovery activities)",null,"Not applicable","No quality assurance for recovery activities during/after emergency/pandemic","Ad-hoc approach to post-emergency/pandemic recovery with some quality controls for selecting stakeholders ","Quality assurance for recovery activities while selecting stakeholders for recovery activities is maintained most of the time and training provided after commencing the work","Quality assurance for recovery activities by using qualified reputed stakeholders and providing training prior to recovery work as appropriate",null,null,null,0]
[null,null,"IM11","Transition strategy planning (Planning an effective and appropriate exit strategy)",null,"Not applicable","No exit strategy/chaotic","Ineffective exit strategy put in place that is not practical and does not take into account the realistic pressures and timelines of recovery work","Exit strategy put in place to end recovery work but does not facilitate smooth transition to business as usual and knowledge transfer to local authorities","An effective, practical and appropriate exit strategy planned and implemented to transition smoothly from emergency and short-term recovery  operations to business as usual and transfer knowledge and lessons to local authorities for future emergency/pandemic preparedness",null,null,null,0]
[null,null,"IM12","Monitoring and evaluation (Mechanism for monitoring and evaluation of recovery progress)",null,"Not applicable","No mechanism in place","A mechanism in place but not implemented","Typical/standard mechanism in place to capture lessons learnt and transfer knowledge for future practice and capacity building","Easy mechanism in place for monitoring and evaluation of recovery progress and to transfer lessons learnt to local and National Government and all relevant stakeholders for future resilience work, pre-emergency/panademic planning, emergency management and post-emergency/panademic recovery",null,null,null,0]
[]
[null,"3.2 Legislation and Regulation\nUsing legislation and regulation to comply with BBB and to facilitate recovery","LR1","BBB based recovery decisions (Changing legislation and regulations to enforce the adoption of BBB-based recovery initiatives)",null,"Not applicable","Legislation not changed to aid BBB","Legislation is updated for certain aspects but does not enforce BBB-based recovery initiatives ","BBB-based recovery decisions made but only few are enforced and regulated due to lack of appropriate legislation and regulations","Legislation and regulations put in place as appropriate to enforce and comply with BBB-based recovery decisions",null,{"$f":"SUM(K16:K19)","v":0},{"$f":"SUM(N16:N19)","v":0},0]
[null,null,"LR2","Efficiency for recovery (Changing legislation and regulations to improve efficiency for recovery)",null,"Not applicable","No plans for having an efficient recovery process","Mostly business-as-usual processes with some legislation updated for BBB, which are still lengthy and delaying recovery","Some legislation and regulation updates put in place to facilitate business-as-usual processes and for BBB","Legislation and regulations put in place as appropriate to facilitate business-as-usual processes and BBB focused on improving efficiency for recovery",null,null,null,0]
[null,null,"LR3","Legislative Provisions (Flexible end dates of legislative provisions)",null,"Not applicable","No Legislative provisions","Legislative provisions are in place, but with rigid end dates that do not correspond with actual recovery activities and progress/lack of progress","Legislative provisions are maintained most of the time with flexible end dates that corresponds with actual recovery activities and progress/ lack of progress","Flexibility with end dates of legislative provisions maintained always that correspond with actual recovery activities and progress/lack of progress",null,null,null,0]
[null,null,"LR4","Stakeholder Training on Legislative changes (Providing training on new legislative changes)",null,"Not applicable","No information or training provided to stakeholders on new legislative changes","Legislative provisions are in place, but stakeholders and the community are unaware/unfamiliar with them and therefore do not use them","Legislative provisions are in place, stakeholders and the community are aware/familiar with them but there is a delay in communicating the new changes","Training and education provided for stakeholders and the community on new legislative changes as soon as they are enforced",null,null,null,0]
[]
[null,"3.3 Monitoring and Evaluation \nMechanisms put in place to monitor and evaluate recovery for compliance with BBB and for future improvement","ME1","Comprehensive data collection (A proper mechanism to collect comprehensive data about the on-going recovery)",null,"Not applicable","No formal mechanism is available","Complicated mechanisms put in place to collect data, track recovery progress, monitor quality and ensure compliance with BBB, which are difficult to understand and implement","Mechanisms put in place to collect data, track recovery progress, monitor quality and ensure compliance with BBB which are someimtes difficult to implement","Easy mechanisms put in place to collect comprehensive data about the on-going recovery effort to track progress, monitor quality and ensure compliance with BBB",null,{"$f":"SUM(K21:K23)","v":0},{"$f":"SUM(N21:N23)","v":0},0]
[null,null,"ME2","Obtaining lessons from the recovery process (Using monitoring and evaluation mechanism effectively to obtain lessons learnt)",null,"Not applicable","No learning from the recovery effort ","Little learnings from recovery effort. Poor knowledge retention and transfer of lessons for future emergency/pandemic management practices","Learning information from the on-going recovery effort. Moderate knowledge retention and transfer of lessons for future emmergency/pandemic management practices","Monitoring and evaluation mechanism effectively used to obtain lessons learnt to improve on-going recovery and transfer knowledge to revise policies and procedures for future emergency/pandemic management practices",null,null,null,0]
[null,null,"ME3","Planning Stakeholder training (Planning and implementing stakeholder training and capacity building from lessons learnt)",null,"Not applicable","No arrangements to train stakeholders, build capacity and educate the public from lessons learnt","Some arrangements to train stakeholders, build capacity and educate the public from lessons learnt","Stakeholder training and capacity building are planned and implemented most of the time from lessons learnt. Also, Educational campaigns planned and implemented for the public when requested","Stakeholder training and capacity building planned and implemented from lessons learnt. Educational campaigns planned and implemented for the public regularly",null,null,null,0]
[]
[null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"RR-Results","index":6,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,5,1,6],[2,1,2,5],[4,1,26,1],[4,2,15,2],[16,2,16,6],[17,2,21,2],[22,2,22,6],[23,2,26,2]]}
[]
[null,"Results",null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,"Disaster Risk Reduction ",null,null,null,null,{"$f":"'Page 2'!B26","v":"00:00:00"}]
[null,"Dimension","Principle","Indicator code","Indicators","Your Rating","Do this to improve Resilience of your Community"]
[null,"Disaster Risk Reduction","Health Sector Resilience","HR1","Knowledge of the hazard",{"$f":"'RR Indicators'!$J4","v":0},{"$f":"IF(AND($F5>0,$F5<4),'Answers for the results'!$B3,IF('RR-Results'!$F5=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR2","Health infrastructure (Hospitals equipped with good quality infrastructure and medical equpiment)",{"$f":"'RR Indicators'!$J5","v":0},{"$f":"IF(AND($F6>0,$F6<4),'Answers for the results'!$B4,IF('RR-Results'!$F6=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR3","Medical supplies",{"$f":"'RR Indicators'!$J6","v":0},{"$f":"IF(AND($F7>0,$F7<4),'Answers for the results'!$B5,IF('RR-Results'!$F7=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR4","Communication with stakeholders ",{"$f":"'RR Indicators'!$J7","v":0},{"$f":"IF(AND($F8>0,$F8<4),'Answers for the results'!$B6,IF('RR-Results'!$F8=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR5","Extra funding ",{"$f":"'RR Indicators'!$J8","v":0},{"$f":"IF(AND($F9>0,$F9<4),'Answers for the results'!$B7,IF('RR-Results'!$F9=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR6","Equity and cross-cutting issues ",{"$f":"'RR Indicators'!$J9","v":0},{"$f":"IF(AND($F10>0,$F10<4),'Answers for the results'!$B8,IF('RR-Results'!$F10=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR7","Staff and their welfare (Taking care of the staff by avoiding overworking)",{"$f":"'RR Indicators'!$J10","v":0},{"$f":"IF(AND($F11>0,$F11<4),'Answers for the results'!$B9,IF('RR-Results'!$F11=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR8","Redundancy and transitional arrangements ",{"$f":"'RR Indicators'!$J11","v":0},{"$f":"IF(AND($F12>0,$F12<4),'Answers for the results'!$B10,IF('RR-Results'!$F12=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR9","Quality Assurance ",{"$f":"'RR Indicators'!$J12","v":0},{"$f":"IF(AND($F13>0,$F13<4),'Answers for the results'!$B11,IF('RR-Results'!$F13=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR10","Incentives to attract skilled nurses/caretakers ",{"$f":"'RR Indicators'!$J13","v":0},{"$f":"IF(AND($F14>0,$F14<4),'Answers for the results'!$B12,IF('RR-Results'!$F14=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR11","Professional supervision ",{"$f":"'RR Indicators'!$J14","v":0},{"$f":"IF(AND($F15>0,$F15<4),'Answers for the results'!$B13,IF('RR-Results'!$F15=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"HR12","Recovery advisory services ",{"$f":"'RR Indicators'!$J15","v":0},{"$f":"IF(AND($F16>0,$F16<4),'Answers for the results'!$B14,IF('RR-Results'!$F16=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[]
[null,null,"Multi-hazard based Land-use Planning ","LP1","Risk Zone Maps",{"$f":"'RR Indicators'!$J17","v":0},{"$f":"IF(AND($F18>0,$F18<4),'Answers for the results'!$B16,IF('RR-Results'!$F18=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LP2","Risk Zone-based Activity Maps ",{"$f":"'RR Indicators'!$J18","v":0},{"$f":"IF(AND($F19>0,$F19<4),'Answers for the results'!$B17,IF('RR-Results'!$F19=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LP3","Risk Zone-based Staff and Resource Allocations ",{"$f":"'RR Indicators'!$J19","v":0},{"$f":"IF(AND($F20>0,$F20<4),'Answers for the results'!$B18,IF('RR-Results'!$F20=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LP4","Temporary isolation plans ",{"$f":"'RR Indicators'!$J20","v":0},{"$f":"IF(AND($F21>0,$F21<4),'Answers for the results'!$B19,IF('RR-Results'!$F21=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LP5","Risk-based Zoning and Activity Education ",{"$f":"'RR Indicators'!$J21","v":0},{"$f":"IF(AND($F22>0,$F22<4),'Answers for the results'!$B20,IF('RR-Results'!$F22=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null," "]
[null,null,"Early Warning and DRR Education","EW1","Hazard prediction",{"$f":"'RR Indicators'!$J23","v":0},{"$f":"IF(AND($F24>0,$F24<4),'Answers for the results'!$B22,IF('RR-Results'!$F24=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"EW2","Early warning systems",{"$f":"'RR Indicators'!$J24","v":0},{"$f":"IF(AND($F25>0,$F25<4),'Answers for the results'!$B23,IF('RR-Results'!$F25=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"EW3","Educating on risk reduction measures",{"$f":"'RR Indicators'!$J25","v":0},{"$f":"IF(AND($F26>0,$F26<4),'Answers for the results'!$B24,IF('RR-Results'!$F26=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"EW4","Support and Training",{"$f":"'RR Indicators'!$J26","v":0},{"$f":"IF(AND($F27>0,$F27<4),'Answers for the results'!$B25,IF('RR-Results'!$F27=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"RR-Graphs","index":7,"n_rows":259,"n_cols":16,"rows_kept":259,"cut":false,"hidden":false,"merged":[[54,15,54,22],[8,1,8,2],[9,1,9,2],[7,1,7,21],[8,15,8,22],[9,15,9,22]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Risk Reduction Graphs"]
[null,"Location",null,":",{"$f":"'Page 2'!B27","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2'!B26","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Actual","Ideal"]
[null,"SR",{"$f":"'RR Indicators'!K4","v":0},{"$f":"'RR Indicators'!L4","v":0},{"$f":"C257/D257","v":{"$error":"#DIV/0!"}},{"$f":"MAX(100%,E257)-E257","v":{"$error":"#DIV/0!"}}]
[null,"MH",{"$f":"'RR Indicators'!K17","v":0},{"$f":"'RR Indicators'!L17","v":0},{"$f":"C258/D258","v":{"$error":"#DIV/0!"}},{"$f":"MAX(100%,E258)-E258","v":{"$error":"#DIV/0!"}}]
[null,"EW",{"$f":"'RR Indicators'!K23","v":0},{"$f":"'RR Indicators'!L23","v":16},{"$f":"C259/D259","v":0},{"$f":"MAX(100%,E259)-E259","v":1}]

{"sheet":"CR-Results","index":8,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6],[12,2,12,6],[5,1,22,1],[5,2,11,2],[13,2,22,2],[2,1,2,4],[2,5,2,6],[3,1,3,5]]}
[]
[]
[null,"Results",null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,"Community Recovery",null,null,null,null,{"$f":"'Page 2'!B26","v":"00:00:00"}]
[null,"Dimension","Principle","Indicator code","Indicators","Your Rating","Suggestions/comments"]
[null,"Community Recovery","Psychological and Social Recovery ","PR1","Community Advisory Service",{"$f":"'CR Indicators'!$K4","v":0},{"$f":"IF(AND($F6>0,$F6<4),'Answers for the results'!$B27,IF('CR-Results'!$F6=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR2","Specialised assistance to vulnerable group",{"$f":"'CR Indicators'!$K5","v":0},{"$f":"IF(AND($F7>0,$F7<4),'Answers for the results'!$B28,IF('CR-Results'!$F7=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR3","Psychological support and counselling services",{"$f":"'CR Indicators'!$K6","v":0},{"$f":"IF(AND($F8>0,$F8<4),'Answers for the results'!$B29,IF('CR-Results'!$F8=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR4","Alternative activities to create communities togetherness during emergency/pandemic situation",{"$f":"'CR Indicators'!$K7","v":0},{"$f":"IF(AND($F9>0,$F9<4),'Answers for the results'!$B30,IF('CR-Results'!$F9=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR5","Informing Community",{"$f":"'CR Indicators'!$K8","v":0},{"$f":"IF(AND($F10>0,$F10<4),'Answers for the results'!$B31,IF('CR-Results'!$F10=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR6","Community input",{"$f":"'CR Indicators'!$K9","v":0},{"$f":"IF(AND($F11>0,$F11<4),'Answers for the results'!$B32,IF('CR-Results'!$F11=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"PR7","Transparency in recovery decisions",{"$f":"'CR Indicators'!$K10","v":0},{"$f":"IF(AND($F12>0,$F12<4),'Answers for the results'!$B33,IF('CR-Results'!$F12=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null," "]
[null,null,"Economic Recovery  ","ER1","Economic recovery strategy plan",{"$f":"'CR Indicators'!$K12","v":0},{"$f":"IF(AND($F14>0,$F14<4),'Answers for the results'!$B35,IF('CR-Results'!$F14=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER2","Supporting locals to rejuvenate businesses",{"$f":"'CR Indicators'!$K13","v":0},{"$f":"IF(AND($F15>0,$F15<4),'Answers for the results'!$B36,IF('CR-Results'!$F15=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER3","Alternative livelihood options",{"$f":"'CR Indicators'!$K14","v":0},{"$f":"IF(AND($F16>0,$F16<4),'Answers for the results'!$B37,IF('CR-Results'!$F16=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER4","Supporting economic restoration",{"$f":"'CR Indicators'!$K15","v":0},{"$f":"IF(AND($F17>0,$F17<4),'Answers for the results'!$B38,IF('CR-Results'!$F17=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER5","Tracking economic recovery",{"$f":"'CR Indicators'!$K16","v":0},{"$f":"IF(AND($F18>0,$F18<4),'Answers for the results'!$B39,IF('CR-Results'!$F18=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER6","Government support",{"$f":"'CR Indicators'!$K17","v":0},{"$f":"IF(AND($F19>0,$F19<4),'Answers for the results'!$B40,IF('CR-Results'!$F19=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER7","Business advisory services",{"$f":"'CR Indicators'!$K18","v":0},{"$f":"IF(AND($F20>0,$F20<4),'Answers for the results'!$B41,IF('CR-Results'!$F20=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER8","Speedy business recovery",{"$f":"'CR Indicators'!$K19","v":0},{"$f":"IF(AND($F21>0,$F21<4),'Answers for the results'!$B42,IF('CR-Results'!$F21=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER9","Alternative business options",{"$f":"'CR Indicators'!$K20","v":0},{"$f":"IF(AND($F22>0,$F22<4),'Answers for the results'!$B43,IF('CR-Results'!$F22=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ER10","Information to community",{"$f":"'CR Indicators'!$K21","v":0},{"$f":"IF(AND($F23>0,$F23<4),'Answers for the results'!$B44,IF('CR-Results'!$F23=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"CR-Graphs","index":9,"n_rows":311,"n_cols":16,"rows_kept":311,"cut":false,"hidden":false,"merged":[[6,0,6,1],[7,0,7,1],[5,6,5,12],[46,12,46,19]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Community Recovery Graphs"]
["Location",null,":",{"$f":"'Page 2'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2'!B26","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Community Recovery","Actual","Ideal"]
["PSR",{"$f":"'CR Indicators'!L4","v":0},{"$f":"'CR Indicators'!M4","v":0},{"$f":"B310/C310","v":{"$error":"#DIV/0!"}},{"$f":"1-D310","v":{"$error":"#DIV/0!"}}]
["ER",{"$f":"'CR Indicators'!L12","v":0},{"$f":"'CR Indicators'!M12","v":0},{"$f":"B311/C311","v":{"$error":"#DIV/0!"}},{"$f":"1-D311","v":{"$error":"#DIV/0!"}}]

{"sheet":"EI-Results","index":10,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,2,24,2],[17,2,20,2],[5,2,15,2],[5,1,24,1],[1,1,1,6],[2,1,2,4],[2,5,2,6],[3,1,3,5],[21,2,21,6]]}
[]
[]
[null,"Results ",null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,"Effective Implementation",null,null,null,null,{"$f":"'Page 2'!B26","v":"00:00:00"}]
[null,"Dimension","Principle","Indicator code","Indicators","Your Rating","Suggestions/Comments"]
[null,"Effective Implementation","Institutional Mechanism ","IM1","Recovery Authority",{"$f":"'EI Indicators'!$K4","v":0},{"$f":"IF(AND($F6>0,$F6<4),'Answers for the results'!$B46,IF('EI-Results'!$F6=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM2","Level of Centralisation/ Decentralisation",{"$f":"'EI Indicators'!$K5","v":0},{"$f":"IF(AND($F7>0,$F7<4),'Answers for the results'!$B47,IF('EI-Results'!$F7=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM3","Supporting impacted organisations",{"$f":"'EI Indicators'!$K6","v":0},{"$f":"IF(AND($F8>0,$F8<4),'Answers for the results'!$B48,IF('EI-Results'!$F8=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM4","Defining Roles and Responsibilities for stakeholders",{"$f":"'EI Indicators'!$K7","v":0},{"$f":"IF(AND($F9>0,$F9<4),'Answers for the results'!$B49,IF('EI-Results'!$F9=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM5","Recovery fund",{"$f":"'EI Indicators'!$K8","v":0},{"$f":"IF(AND($F10>0,$F10<4),'Answers for the results'!$B50,IF('EI-Results'!$F10=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM6","Information Database",{"$f":"'EI Indicators'!$K9","v":0},{"$f":"IF(AND($F11>0,$F11<4),'Answers for the results'!$B51,IF('EI-Results'!$F11=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM7","Multi-stakeholder meetings",{"$f":"'EI Indicators'!$K10","v":0},{"$f":"IF(AND($F12>0,$F12<4),'Answers for the results'!$B52,IF('EI-Results'!$F12=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM8","Partnership",{"$f":"'EI Indicators'!$K11","v":0},{"$f":"IF(AND($F13>0,$F13<4),'Answers for the results'!$B53,IF('EI-Results'!$F13=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM9","Quality assurance for recovery activities",{"$f":"'EI Indicators'!$K12","v":0},{"$f":"IF(AND($F14>0,$F14<4),'Answers for the results'!$B54,IF('EI-Results'!$F14=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM10","Transition strategy planning",{"$f":"'EI Indicators'!$K13","v":0},{"$f":"IF(AND($F15>0,$F15<4),'Answers for the results'!$B55,IF('EI-Results'!$F15=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"IM11","Monitoring and evaluation",{"$f":"'EI Indicators'!$K14","v":0},{"$f":"IF(AND($F16>0,$F16<4),'Answers for the results'!$B56,IF('EI-Results'!$F16=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[]
[null,null,"Legislation and Regulation","LR1","BBB based recovery decisions",{"$f":"'EI Indicators'!$K16","v":0},{"$f":"IF(AND($F18>0,$F18<4),'Answers for the results'!$B58,IF('EI-Results'!$F18=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LR2","Efficiency for recovery",{"$f":"'EI Indicators'!$K17","v":0},{"$f":"IF(AND($F19>0,$F19<4),'Answers for the results'!$B59,IF('EI-Results'!$F19=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LR3","Legislative Provisions",{"$f":"'EI Indicators'!$K18","v":0},{"$f":"IF(AND($F20>0,$F20<4),'Answers for the results'!$B60,IF('EI-Results'!$F20=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"LR4","Stakeholders Training",{"$f":"'EI Indicators'!$K19","v":0},{"$f":"IF(AND($F21>0,$F21<4),'Answers for the results'!$B61,IF('EI-Results'!$F21=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null," "]
[null,null,"Monitoring and Evaluation","ME1","Comprehensive data collection ",{"$f":"'EI Indicators'!$K21","v":0},{"$f":"IF(AND($F23>0,$F23<4),'Answers for the results'!$B63,IF('EI-Results'!$F23=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ME2","Obtaining lesson from ongoing recovery process",{"$f":"'EI Indicators'!$K22","v":0},{"$f":"IF(AND($F24>0,$F24<4),'Answers for the results'!$B64,IF('EI-Results'!$F24=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,"ME3","Planning Stakeholder training",{"$f":"'EI Indicators'!$K23","v":0},{"$f":"IF(AND($F25>0,$F25<4),'Answers for the results'!$B65,IF('EI-Results'!$F25=0,'Answers for the results'!$D$6, 'Answers for the results'!$D$3))","v":"Not applicable"}]
[null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]

{"sheet":"Main Dashboard","index":11,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[9,1,10,10],[11,1,13,5],[11,6,13,8],[0,1,8,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Graph Calculation",null,null,null,null,"Radar Graph Calculation"]
[]
[]
["BBB Dimension","BBB Principles","Your rating ","Possible max rating","Your rating as percentage of max rating","Weighting of indicator rating as % of total",{"$f":"A16","v":"Disaster Risk Reduction"},{"$f":"A19","v":"Community Recovery"},{"$f":"A21","v":"Effective Implementation"}]
["Disaster Risk Reduction","Structural Resilience",{"$f":"'RR Indicators'!$K$4","v":0},{"$f":"SUM('RR Indicators'!$M$4:$M$15)","v":0},{"$f":"(C16/D16)","v":{"$error":"#DIV/0!"}},{"$f":"(D16/D24)*100","v":{"$error":"#DIV/0!"}},{"$f":"E16","v":{"$error":"#DIV/0!"}}]
["Disaster Risk Reduction","Multi-hazard based Land-use Planning",{"$f":"'RR Indicators'!$K$17","v":0},{"$f":"SUM('RR Indicators'!$M$17:$M$21)","v":0},{"$f":"(C17/D17)","v":{"$error":"#DIV/0!"}},{"$f":"D17/D24%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Disaster Risk Reduction","Early Warning and DRR Education",{"$f":"'RR Indicators'!$K$23","v":0},{"$f":"SUM('RR Indicators'!$M$23:$M$26)","v":0},{"$error":"#DIV/0!"},{"$f":"(D18/D24)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Community Recovery","Psychological and Social Recovery",{"$f":"'CR Indicators'!$L$4","v":0},{"$f":"SUM('CR Indicators'!$N$4:$N$10)","v":0},{"$error":"#DIV/0!"},{"$f":"D19/D24%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Community Recovery","Economic Recovery",{"$f":"'CR Indicators'!$L$12","v":0},{"$f":"SUM('CR Indicators'!$N$12:$N$21)","v":0},{"$error":"#DIV/0!"},{"$f":"(D20/D24)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Effective Implementation","Institutional Mechanism",{"$f":"'EI Indicators'!$L$4","v":0},{"$f":"SUM('EI Indicators'!$N$4:$N$14)","v":0},{"$error":"#DIV/0!"},{"$f":"D21/D24%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Effective Implementation","Legislation and Regulation",{"$f":"'EI Indicators'!$L$16","v":0},{"$f":"SUM('EI Indicators'!$N$16:$N$19)","v":0},{"$error":"#DIV/0!"},{"$f":"(D22/D24)*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Effective Implementation","Monitoring and Evaluation",{"$f":"'EI Indicators'!$L$21","v":0},{"$f":"SUM('EI Indicators'!$N$21:$N$23)","v":0},{"$error":"#DIV/0!"},{"$f":"D23/D24%","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"TOTAL",{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D23)","v":0},null,{"$f":"SUM(F16:F23)","v":{"$error":"#DIV/0!"}}]

{"sheet":"EI-Graphs","index":12,"n_rows":382,"n_cols":18,"rows_kept":382,"cut":false,"hidden":false,"merged":[[51,14,51,22],[6,7,7,14],[8,17,8,22],[9,17,9,22],[8,0,8,1],[9,0,9,1]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Effective Implementation Graphs"]
[]
["Location",null,":",{"$f":"'Page 2'!B27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Page 2'!B25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" 'Page 2'!B26","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Actual","Ideal"]
["IM",{"$f":"'EI Indicators'!L4","v":0},{"$f":"'EI Indicators'!M4","v":0},{"$f":"B380/C380","v":{"$error":"#DIV/0!"}},{"$f":"1-D380","v":{"$error":"#DIV/0!"}}]
["LR",{"$f":"'EI Indicators'!L16","v":0},{"$f":"'EI Indicators'!M16","v":0},{"$f":"B381/C381","v":{"$error":"#DIV/0!"}},{"$f":"1-D381","v":{"$error":"#DIV/0!"}}]
["ME",{"$f":"'EI Indicators'!L21","v":0},{"$f":"'EI Indicators'!M21","v":0},{"$f":"B382/C382","v":{"$error":"#DIV/0!"}},{"$f":"1-D382","v":{"$error":"#DIV/0!"}}]

{"sheet":"OverAll Analysis","index":13,"n_rows":264,"n_cols":262,"rows_kept":264,"cut":false,"hidden":false,"merged":[[100,1,100,3],[10,2,10,3],[9,2,9,3],[1,1,7,15],[12,1,40,15],[41,1,62,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Organisation                   :",{"$f":"'Page 2'!$B$25","v":0},null,null,null,null,null,"Location",":",{"$f":"'Page 2'!$B$27","v":0}]
[null,"Date                                :",{"$f":"'Page 2'!$B$26","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"For more information please visit : www.buildbackbetter.co.nz "]
[null,null,null,null,null,null,null,null,null,null,"or"]
[null,null,null,null,null,null,null,null,"Email us: manager@buildbackbetter.co.nz"]
[null,"Build Back Better Tool, © Neeraj, Mannakkara and Wilkinson 2018, 2019, 2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,"Overall Analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["````"]
[]
[]
[]
[null,null,"Actual","Ideal","Actual","Ideal"]
[null,"Disaster Risk Reduction",{"$f":"+SUM(C255:C257)","v":0},{"$f":"+SUM(D255:D257)","v":0},{"$f":"C254/D254","v":{"$error":"#DIV/0!"}},{"$f":"1-E254","v":{"$error":"#DIV/0!"}}]
[null,"Health Sector Resilience",{"$f":"SUM('RR Indicators'!J4:J15)","v":0},{"$f":"SUM('RR Indicators'!M4:M15)","v":0},{"$f":"C255/D255","v":{"$error":"#DIV/0!"}},{"$f":"1-E255","v":{"$error":"#DIV/0!"}}]
[null,"Risk basesd Zoning",{"$f":"SUM('RR Indicators'!J17:J21)","v":0},{"$f":"SUM('RR Indicators'!M17:M21)","v":0},{"$f":"C256/D256","v":{"$error":"#DIV/0!"}},{"$f":"1-E256","v":{"$error":"#DIV/0!"}}]
[null,"Early Warning and Risk Education",{"$f":"SUM('RR Indicators'!J23:J26)","v":0},{"$f":"SUM('RR Indicators'!M23:M26)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Community Recovery",{"$f":"SUM(C259:C260)","v":0},{"$f":"SUM(D259:D260)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Psychological and Social Recovery",{"$f":"SUM('CR Indicators'!K4:K10)","v":0},{"$f":"SUM('CR Indicators'!N4:N10)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Economic Recovery",{"$f":"SUM('CR Indicators'!K12:K21)","v":0},{"$f":"SUM('CR Indicators'!N12:N21)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Effective Implementation",{"$f":"+SUM(C262:C264)","v":0},{"$f":"+SUM(D262:D264)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Institutional Mechanism",{"$f":"SUM('EI Indicators'!K4:K14)","v":0},{"$f":"SUM('EI Indicators'!N4:N14)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Legislation and Regulation",{"$f":"SUM('EI Indicators'!K16:K19)","v":0},{"$f":"SUM('EI Indicators'!N16:N19)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Monitoring and Evaluation",{"$f":"SUM('EI Indicators'!K21:K23)","v":0},{"$f":"SUM('EI Indicators'!N21:N23)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

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

{"sheet":"Answers for the results","index":15,"n_rows":65,"n_cols":4,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Indicator Codes","High Resilience Indicators",null,"Used combination formula ( &\" \"&) "]
[null,"Answers for 1 to 3",null,"Answers for only 4"]
["SR1","Obtain accurate, up-to-date understanding of all the diseases affecting individuals or community and their resulting risks and vulnerabilities",null,"You are doing a great job!!"]
["SR2","Make sure hospitals are equipped with good quality equipment related to the disease (e.g. ventilators, testing kits, etc.) and there are adequate facilities (beds, toilets, water, safe waste management, etc.) to accommodate high demands during emergency/pandemic situations "]
["SR3","Make sure adequate medical supplies are available to manage emergencies efficiently. In case of shortage, be prepaded with an effective plan to acquire the necessary medical supplies from the health network",null,"Answers for only 0"]
["SR4","Communicate regularly  with stakeholders and health network to gather community's needs and demands prior to developing strategy plans during emergencies. Disseminate up to date health information to the community based on the developed strategy and plans",null,"Not applicable"]
["SR5","To avoid disruption during emergencies/pandemic, prepare a long-term funding mechanism to fund extra costs incurred to purchase medical supplies, hiring medical professionals and staff."]
["SR6","Consider social and cultural factors in the provision of health services, eliminate inequity, and address possible cross-cutting issues"]
["SR7","Make sure there is an adequate staff at the hospital/s to avoid staff burnout/overworking. Provide flexibility of working time and enable access to psycho-social care to cope up with disruption to a normal routine during emergencies/pandemic."]
["SR8","Make necessary transitional arrangements to relieve high pressure during emergencies (e.g. transitional shelters/accommodation/facilities, alternative medical suppliers, transition team to avoid staff burnout etc.)"]
["SR9","Prepare a practical, uncomplicated and efficient quality assurance measures which are appropriate for emergency/pandemic environments."]
["SR10","Provide incentives or special arrangements to attract skilled certified health workers to meet the demands during any emergency/pandemic"]
["SR11","Make sure professional supervision is available all the time to address the patients during emergencies/pandemic and also to take care of the general emergencies/outpatient. "]
["SR12","Advisory service with medical professionals should be in place to support, educate and assist affected individuals or families during emergency/pandemic so that the individual or families have accurate, timely information and support "]
[]
["LP1","Prepare accurate, clear risk zone maps during the pandemic, to establish strict risk reduction (e.g. lockdown) measures."]
["LP2","Enforce and regularly updater the activity allowances/restrictions based on risk zone maps"]
["LP3","Use additional staff during emergencies. Make sure adequate facilities/resources and incentives are available to encourage the relocation of Health workers from low-demand to high-demand areas."]
["LP4","In the instance where resettlement for isolation is opted for as a last resort, prepare a comprehensive temporary resettlement plan to minimise disruption and to support the affected individuals"]
["LP5","Provide education and maintain regular communication with the stakeholders and the community on risk-based zoning and activity plans for emergencies/pandmics on risk zones and land-use plans"]
[]
["EW1","Utilise and adopt advanced models for hazard/outbreak predictions with different scenarios (optimistic, pessimistic and most likely) using science and technology to improve the accuracy of hazard predictions. Use local and international knowledge inputs "]
["EW2","Adopt early warning systems appropriate to the local community using a combination of new technology and local knowledge and traditional methods to disseminate timely information"]
["EW3","Provide practical education and inform to the community and stakeholders accurately and regularly on disease/pandemic risks. Prepare and communicate preparedness and practical risk reduction methods"]
["EW4","Provide training and resources regularly to the local organisations, health workers, and stakeholders on early warning systems and risk reduction methods to help them prepare for and operate after an emergency/pandemic event"]
[]
["PR1","Establish community advisory services to provide information on the recovery process and to connect with affected households"]
["PR2","Identify vulnerable groups in the community and organise specialised assistance to support them during the emergency/pandemic."]
["PR3","Organise psychological support and counselling services for the health workers and the community"]
["PR4","Design and organise appropriate activities and support groups to bring the community together and to build social cohesion during the pandemic, thereby creating a sense of community and togetherness."]
["PR5","Inform the community regularly on recovery decisions and progress using appropriate channels (e.g. Television news, radio, social media, newspaper, pamphlets, etc.)"]
["PR6","Empower the community by incorporating bottom-up approaches for emergencies/pandemics management and recovery"]
["PR7","Full transparency should be maintained with affected communities with regards to emergency/pandemic management and recovery decisions."]
[]
["ER1","Develop a tailor-made economic recovery strategy catering to local need using information collected from locals and local councils"]
["ER2","Empower and support locals to re-establish traditional livelihoods and to upgrade facilities (e.g. online orders, work from home, etc.) and technologies (e.g. EFTPOS machine for contactless payment, online delivery platforms, etc.) for business rejuvenation."]
["ER3","Introduce new livelihood options (food business, product delivery, courier services, manufacturing essential items) utilising local resources and provide opportunities for upskilling to cater to skills shortages"]
["ER4","Plan to restore the economic activities during emergencies/pandemic (advertise local industries with online delivery of products or services, promote tourism to attract residents and tourist after the pandemic, etc.)"]
["ER5","Adopt a simplified measurement tool to track economic recovery progress"]
["ER6","Provide Government support to assist business recovery (e.g. provision of special Government grants and flexible low-interest loans)"]
["ER7","Provide business advisory services to support and advise businesses"]
["ER8","Support speedy re-establishment of businesses (e.g. setting up temporary online based retail/work for businesses, and provide fast-tracked permit procedures, incentives to businesses to facilitate the demand, etc.)"]
["ER9","Plan alternative options and execute the planned activities if economic recovery progress is poor"]
["ER10","Inform local community regularly on all the economic recovery progress and plans to encourage residents and boost morale."]
[]
["IM1","A local-level body most suited to the local context consisting of local government and local community representation should be chosen to plan, implement and manage recovery activities, and facilitate coordination and partnerships between stakeholders involved in recovery "]
["IM2","Choose the level of centralisation and/or decentralisation most suited to the local context and community (e.g. central-level coordination of recovery with decentralised planning and implementation)"]
["IM3","Provide significant support to increase the capacity of impacted organisations strengthened (e.g. hospitals/clinics) to be able to take part in the recovery"]
["IM4","Establish clear roles and responsibilities for all health workers and stakeholders in the health network to avoid duplication of the works."]
["IM5","Create an exclusive, singular fund for recovery to direct all funds dedicated to recovery into one pool for clear accountability and allocation for different recovery needs"]
["IM6","Maintain thorough information database with systems for easy and transparent access to information between stakeholders involved in the recovery"]
["IM7","Foster effective partnerships by holding multi-stakeholder meetings held regularly to discuss, plan and implement recovery activities avoiding duplication and allowing consultation and information exchanges between stakeholders"]
["IM8","Foster effective partnerships by holding multi-stakeholder meetings held regularly to discuss, plan and implement recovery activities avoiding duplication and allowing consultation and information exchanges between stakeholders"]
["IM9","Maintain quality assurance for all the recovery by using qualified reputed health workers and stakeholders for recovery activities and provide training before recovery work as appropriate."]
["IM10","Plan and implement an effective, practical and appropriate exit strategy to transition smoothly from emergency and short-term recovery operations to business as usual. Transfer knowledge and lessons to local authorities for future emergency/pandemic preparedness."]
["IM11","An easy mechanism should be in place for monitoring and evaluation of recovery progress and to transfer lessons learnt to local and national Government and all relevant stakeholders for future resilience work, pre-emergency/pandemic planning, emergency management and post-emergency/pandemic recovery"]
[]
["LR1","Adopt appropriate legislation and regulations to enforce and comply with BBB-based recovery decisions"]
["LR2","Legislation and regulations should be in place as appropriate to facilitate business-as-usual processes and BBB focused on improving efficiency for recovery"]
["LR3","Maintain flexibility with end dates of legislative provisions (e.g. license extension during the lockdown, pausing the interest rate on loans, etc.) that correspond with actual recovery activities and progress/lack of progress"]
["LR4","Provide training and education for stakeholders and the community on new legislative changes as soon as they are enforced."]
[]
["ME1","Design and implement an easy mechanism to collect comprehensive data about the on-going recovery effort to track progress, monitor quality and ensure compliance with BBB"]
["ME2","Use monitoring and evaluation mechanism effectively to obtain lessons learnt to improve on-going recovery and transfer knowledge to revise policies and procedures for future emergency/pandemic recovery practices"]
["ME3","Plan and implement the training and capacity building from lessons learnt to the health network stakeholder. Further, plan and implement an educational campaign on preparedness measure (e.g. Television or Radio broadcast, social media platforms, etc.) for the health workers and public regularly. "]