Max occupancy on the Excel Calculator Template

Topic Views - 67

Max occupancy on the Excel Calculator Template
I am using the excel tool to do some high level modelling, on the online tool there is an option to input a maximum occupancy and a patients level, I cannot find the equivalent functions on the excel tool. I am familiar with excel VBA and I have looked at the UDF's but can't find it there, although there is a one called utilisation. this takes an input of Intensity and Agents. my question is
is there a version of the formula that replicates the Online tool, if not how do I calculate intensity?
thanks in advance for any assistance


Call Centre Helper

It is only available on the online tool
Hi Andrew.

The online tool is way ahead of the Excel based tool. The online version supports up to 10,000 agents, has maximum occupancy, shrinkage and also the Erlang A abandon rate.

These are not supported in the Excel version. We are channelling our effort into developing the online tools, where we can apply better change control, rather than the excel based ones.

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question