ARR Analysis - Data App

This workflow creates a small web application for the ARR calculation and analysis from contracts data. The contracts data can be uploaded as an Excel file containing contracts IDs, values, and terms.

The first step is to calculate the recurring values in each month based on the contract period and contract value. The second step is to calculate the ARR. The third step is to visualize it.

Here we show three different ways for calculating and visualizing the ARR:

1. Calculating the total ARR in each month and visualizing it in a line plot

2. Calculating the total ARR in each month and year, and comparing the years in a line plot

3. Calculating the total ARR in a selected month, e.g. the current month

Note: The example data files are available in the workflow data area. When deploying the workflow as a Data App, make sure the files can be accessed from your local machine.

From contracts to monthly recurring values

Demo data

From contracts to monthly recurring values