Spreadsheet for Calculating Retention

Updated

You can use a spreadsheet to calculate retention. Click here to download the spreadsheet, and then enter your data into the spreadsheet.

  1. Open the spreadsheet.

  2. Enter the appropriate data in the Input section that is highlighted in yellow.

    • Days: The number of days defined in the storage policy.

    • Cycles: The number of cycles defined in the storage policy.

    • Days Between Fulls: The number of days that fall between the full backup operations in the storage policy.

  3. Enter the number of extra days in the Extra Days field in the Illustration section to see how retention is affected.

    • Enter 0 to display the maximum number of ageable days.

    • Enter 1 to add an additional day and display the minimum number of ageable days.

    • Enter 2 to add two additional days and so on.

    In the Illustration section of the spreadsheet, you can see when the data will be aged.

Was this page helpful?