Outoubd excel files

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=0n (AHTRPCi*RPCi) / ∑i=0n (RPCi), 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=0n (AHTWPCi*WPCi) / ∑i=0n (WPCi), 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=0n (AHTRBOPCi*RBOPCi) / ∑i=0n (RBOPCi), 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=0n (AHTWBOPCi*WBOPCi) / ∑i=0n (WBOPCi), 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=0n (SetupTimeConnected *(RPCi + WPCi)) / ∑i=0n (RPCi + WPCi), 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=0n (SetupTimeFailed*Failed) / ∑i=0n 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=0n (SetupTimeBusinessOutcome *(RBOPCi + WBOPCi)) / ∑i=0n (RBOPCi + WBOPCi), 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=0n (RPCi + WPCi) / ∑i=0n (RPCi + WPCi + Failedi), 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=0n RB0PCi / ∑i=0n RPCi, i index of shifts in each month's day, i.e., each day as a single ConversionRate value.