{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Assessment Tool","Reports"],"not_rendered":{"charts":0,"images":1,"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":"Assessment Tool","index":0,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,3],[5,1,5,2],[6,1,6,2],[2,0,3,4],[5,3,5,4],[6,3,6,4]]}
["Business Impact Assessment and Planning Tool"]
[]
["The Business Impact Assessment and Planning Tool can be used to identify critical business functions, and plan for their resilience. The assessment tool can be used for any particular threat (e.g., tornado, flood, terrorism, etc.) or for \"All Hazards\". Use drop-down menus in the digital version to mark the priority, vulnerability, and recovery timeline needed for each business function. "]
[]
[]
["Business Name","Date of Assessment",null,"Type of Threat"]
[]
[]
["Business Function","Priority","Vulnerability","Recovery Need","Mitigation Plan"]
[null,"Critical","Highly Vulnerable","Immediate"]
[null,"Essential","Vulnerable","Short-Term"]
[null,"Not-Essential","Not Vulnerable","Medium-Term"]
[null,null,null,"Long-Term"]
["Example: Payroll","Critical","Vulnerable","Long-Term","Move to a 3rd party payroll system."]
["Physical Capital/Facilities"]
["Access/stability of primary business site"]
["Access/stability of other sites (e.g. warehouse)"]
["Availability/capacity of building owner(s)"]
["Security of sites (e.g. alarms/guards/etc.)"]
["Working condition of equipment"]
[]
["Operations"]
["Availability of inventory"]
["Availability of suppliers/vendors"]
["Availability of partner businesses/organizations"]
["Internal shipping and receiving capacity"]
["Marketing systems (website, etc.)"]
[]
["Utilities"]
["Electricity"]
["Water"]
["Gas"]
["Sewage"]
["Telephone"]
["Internet"]
["Heat/Cooling"]
[]
["IT Systems"]
["Operation of servers/computers"]
["Operation of payment processing system"]
["Operation of inventory tracking system"]
["Operation of receivables/payables tracking system"]
["Operation of CRM system"]
["Access to data/records/etc."]
["Operation of data security system"]
[]
["Transportation"]
["Access to major highways/rail/air"]
["Access to local surface streets"]
["Access to transportation providers"]
[]
["Governance"]
["Presence of owner for operation"]
["Presence of board/partners for operation"]
["Presence of core management team for operation"]
[]
["Employees/Human Resources"]
["Availability of operation staff"]
["Availability of admin/support staff"]
["Operation of payroll system"]
[]
["Customers/Market"]
["Availability of buyers/customers"]
["Reputational quality of local market area"]
["Demand for the firm's products or services"]
[]
["Legal/Compliance"]
["Access to permits/proof of business/records"]
["Access to lawyer or legal support"]
["Ability to meet tax requirements"]
["Ability to meet contractural requirements"]
[]
["Financial Capital"]
["Access to cash or bank accounts"]
["Coverage of losses through insurance/savings"]
["Availability of accountant"]
["Proof of assets"]
[]
["Other"]

{"sheet":"Reports","index":1,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,3],[6,1,6,2],[6,3,6,4],[5,0,5,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
["Business Impact Assessment and Planning Tool"]
[]
["Business Name","Date of Assessment",null,"Type of Threat"]
[{"$f":"'Assessment Tool'!A7","v":0},{"$f":"'Assessment Tool'!B7:C7","v":0},null,{"$f":"'Assessment Tool'!D7:E7","v":0}]
[]
["Reporting Options"]
[]
[]
["Business Function","Priority","Vulnerability","Recovery Need","Mitigation Plan"]
[null,"Critical","Highly Vulnerable","Immediate"]
[null,"Essential","Vulnerable","Short-Term"]
[null,"Not-Essential","Not Vulnerable","Medium-Term"]
[null,null,null,"Long-Term"]
["Example: Payroll","Critical","Vulnerable","Medium-Term","Move to a 3rd party payroll system."]
["Physical Capital/Facilities"]
["Access/stability of primary business site"]
["Access/stability of other sites (e.g. warehouse)"]
["Availability/capacity of building owner(s)"]
["Security of sites (e.g. alarms/guards/etc.)"]
["Working condition of equipment"]
[]
["Operations"]
["Availability of inventory"]
["Availability of suppliers/vendors"]
["Availability of partner businesses/organizations"]
["Internal shipping and receiving capacity"]
["Marketing systems (website, etc.)"]
[]
["Utilities"]
["Electricity"]
["Water"]
["Gas"]
["Sewage"]
["Telephone"]
["Internet"]
["Heat/Cooling"]
[]
["IT Systems"]
["Operation of servers/computers"]
["Operation of payment processing system"]
["Operation of inventory tracking system"]
["Operation of receivables/payables tracking system"]
["Operation of CRM system"]
["Access to data/records/etc."]
["Operation of data security system"]
[]
["Transportation"]
["Access to major highways/rail/air"]
["Access to local surface streets"]
["Access to transportation providers"]
[]
["Governance"]
["Presence of owner for operation"]
["Presence of board/partners for operation"]
["Presence of core management team for operation"]
[]
["Employees/Human Resources"]
["Availability of operation staff"]
["Availability of admin/support staff"]
["Operation of payroll system"]
[]
["Customers/Market"]
["Availability of buyers/customers"]
["Reputational quality of local market area"]
["Demand for the firm's products or services"]
[]
["Legal/Compliance"]
["Access to permits/proof of business/records"]
["Access to lawyer or legal support"]
["Ability to meet tax requirements"]
["Ability to meet contractural requirements"]
[]
["Financial Capital"]
["Access to cash or bank accounts"]
["Coverage of losses through insurance/savings"]
["Availability of accountant"]
["Proof of assets"]
[]
["Other"]