It is possible to do this entirely within Anaplan using the existing AGENTS and SLA functions. The popular FractionalAgents Excel addin function from T&C Limited is a linear interpolation between AGENTS and AGENTS-1 based on the SLA for each, as follows. Line Item Formula agents AGENTS(sla, serviceTime, callsPerSecond, duration) nextSLA SLA(agents - 1, serviceTime, callsPerSecond, duration) previousSLA SLA(agents, serviceTime, callsPerSecond, duration) fractionalAgents agents - (nextSla - sla) / (nextSla - previousSla) To answer the concern about accuracy, the answer in Anaplan is more accurate than the one in Excel. The Excel add-in FractionalAgents function uses single precision floating point numbers, whereas Anaplan uses double precision. If you change the Excel implementation to use double precision then the answers agree to about the 15th decimal place, which is considerably less than a mote of dust from the skin of one of your agents.
... View more
