Estimate the impact of downtime to determine appropriate, acceptable recovery time objectives (RTOs) and recovery point objectives (RPOs), and review gaps between objectives and actuals. Specifically, this tool enables you to:

  • Identify critical applications/systems.
  • Identify dependencies.
  • Define objective scoring criteria to evaluate the impact of application/system downtime.
  • Determine the impact of downtime and establish criticality tiers.
  • Set recovery objectives (RTO/RPO) based on the impact of downtime.
  • Record recovery actuals (RTA/RPA) and identify any gaps between objectives and actuals.
  • Identify dependencies that regularly fail, and have a significant impact when they fail, to prioritize efforts to improve resiliency.

This tool requires Excel 2013 or 2016 with the following components for the complete user experience:

  • Power Query (Excel 2013 add-on) or Get & Transform (Excel 2016 standard feature)
  • Power Pivot (Excel 2013/2016 add-on)

To enable Power Query (Excel 2013 only) and Power Pivot for the first time, go to File -> Options -> Add-ins -> Manage COM Add-ins and check the appropriate boxes. You may require support from your IT department to enable these features.

If you are unable to run Excel 2016 or 2013 with the appropriate add-ons, you can download and use the legacy version of the tool on this page. Although the legacy tool can be used in lieu of the current version, note that the legacy version is no longer supported.

Also In

Assess Your Cybersecurity Insurance Policy

Learn to avoid common insurance pitfalls.

Also In

Develop and Document a Disaster Recovery Plan for the Small Enterprise

Show the business you are ready to handle a crisis.

Also In

Bridge the Gap between Service Management & Disaster Recovery

Treating DR as separate from normal IT operations leaves organizations vulnerable to common causes of extended service interruptions.

Also In

Establish an Effective Data Protection Plan

Give data the attention it deserves by building a strategy that goes beyond backup.

Also In

Create a Right-Sized Disaster Recovery Plan

Close the gap between your DR capabilities and service continuity requirements.

Related Content


Get Access

Get Instant Access
To unlock the full content, please fill out our simple form and receive instant access.
Visit our COVID-19 Resource Center and our Cost Management Center
Over 100 analysts waiting to take your call right now: 1-519-432-3550 x2019