Forecast outbound indicators (*OneForecast*) are the values placed into the template while others are obtained by formulas, as follows:

**RPC**is the value in**RPC**cells.**WPC**is the value in**WPC**cells.**Failed**depends on**RPC**value cells.**RBOPC**is the value in**RBOPC**cells.**WBOPC**is the value in**WBOPC**cells.

**AHTRPC**

if **RPC == 0 -> AHTRPC = 0**;

if **RPC != 0 -> AHTRPC** = **∑ _{i=0}^{n} (AHTRPC_{i}*RPC_{i}) / ∑_{i=0}^{n} (RPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**AHTRPC**value.

**AHTWPC**

if **WPC == 0 -> AHTWPC = 0**;

if **WPC != 0 -> AHTWPC** = **∑ _{i=0}^{n} (AHTWPC_{i}*WPC_{i}) / ∑_{i=0}^{n} (WPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**AHTWPC**value.

**AHTRBOPC**

if **RBOPC == 0 -> AHTRBOPC = 0**;

if **RBOPC != 0 ->** **AHTRBOPC** = **∑ _{i=0}^{n} (AHTRBOPC_{i}*RBOPC_{i}) / ∑_{i=0}^{n} (RBOPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**AHTRBOPC**value.

**AHTWBOPC**

if **WBOPC == 0 -> AHTWBOPC = 0**;

if **WBOPC != 0** -> **AHTWBOPC** = **∑ _{i=0}^{n} (AHTWBOPC_{i}*WBOPC_{i}) / ∑_{i=0}^{n} (WBOPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**AHTWBOPC**value.

**SetupTimeConnected**

if **RPC <= 0 || WPC <= 0 -> SetupTimeConnected = 0**;

if **RPC > 0 &&** **WPC > 0 -> SetupTimeConnected = ****∑ _{i=0}^{n} (SetupTimeConnected *(RPC_{i} + WPC_{i})) / ∑_{i=0}^{n} (RPC_{i} + WPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**SetupTimeConnected**value.

**SetupTimeFailed**

if **Failed <= 0 -> SetupTimeFailed= 0**;

if **Failed > 0 -> SetupTimeFailed= ∑ _{i=0}^{n} (SetupTimeFailed*Failed) / ∑_{i=0}^{n} Failed, i **index of shifts in each month's day, i.e., each day as a single

**SetupTimeFailed**value.

**SetupTimeBusinessOutcome**

if **RBOPC <= 0 || WBOPC <= 0 -> SetupTimeConnected = 0**;

if **RBOPC > 0 &&** **WBOPC > 0 -> SetupTimeBusinessOutcome = ****∑ _{i=0}^{n} (SetupTimeBusinessOutcome *(RBOPC_{i} + WBOPC_{i})) / ∑_{i=0}^{n} (RBOPC_{i} + WBOPC_{i}), i **index of shifts in each month's day, i.e., each day as a single

**SetupTimeBusinessOutcome**value.

Indicators calculated based on cells in the uploaded template not present in the template:

**DialRate**

If **RPC <= 0 || WPC <= 0 || Failed <= 0 -> DialRate = 0**;

If **RPC > 0 &&** **WPC > 0 &&** **Failed > 0 -> DialRate = 100 * ****∑ _{i=0}^{n} (RPC_{i} + WPC_{i}) / ∑_{i=0}^{n} (RPC_{i} + WPC_{i} + Failed_{i}), i **index of shifts in each month's day, i.e., each day as a single

**DialRate**value.

**ConversionRate**

If **RPC <= 0**;

If **RPC > 0 -> ConversionRate = 100 * ∑ _{i=0}^{n} RB0PC_{i} / ∑_{i=0}^{n} RPC_{i}, i **index of shifts in each month's day, i.e., each day as a single

**ConversionRate**value.