RAMPUP() function

Ramp from 0 to a target value over a defined number of periods

🗒️ Description

The rampup function is designed to address the common use case of Sales ramping times.

It takes an input indicator, and returns new values increasing linearly from 0 to the full value over the course of a defined number of periods. Once ramped, the result remains at the full value for all future periods

This can be used to model the effectiveness of a sales team - where a new joiner is expected to hit 0% of their quota in their first month, but after 6 months is expected to hit 100%. By applying the ramp function, we can calculate the quota as a linear increase over 6 months rather than a step change.

✏️ Syntax & Variables

• “Indicator name” : string. Name of the indicator to ramp up
• ramping_periods : number or reference to another indicator - number of periods to ramp from 0 to 100% of the value

✅ Expected result & examples

In ramping we can calculate the data up to 100 percent of the value.

In this example, we want to model how it may take a new Salesperson 4 months to ramp when they start a new job, rather than adding their full Sales Quota on day one, it is phased in over a suitable ramp period. We can input the target quota as a single value in the first month, and use the RAMPUP formula to ramp this quota over 4 periods:

The value is ramped up by 25 each month for 4 months, before continuing at the maximum value for future months

Suppose we take a raw data starting from 0.