CC-Excel FAQ

Here is a list of questions we are commonly asked about CC-Excel. Please contact us if you have any others.

How do I use call center functions in my workbooks?

CC-Excel adds nine call center staffing functions to Microsoft Excel that help you model your call center performance in your own workbooks. They work exactly the same as Microsoft Excel’s own built-in functions: in a blank cell, you enter an equals sign (=) followed by the function’s name and its arguments.

For example, a cell with this function:

=CCXLAgents(1050,250,10)

will display the result 81, which is an estimate of the number of agents required to answer 1050 calls per hour of duration 250 seconds, where the average speed of answering the calls is 10 seconds. Instead of entering numbers as the arguments, you could specify references to other cells within the workbook.

Does CC-Excel include an example workbook?

CC-Excel installs a workbook with twelve calculators and an example staffing table. You can use them as they are, or build on them to create your own call center staffing tools.

CC-Excel staffing table

How accurate are CC-Excel’s results?

CC-Excel uses the Erlang traffic models that were developed in the first half of the twentieth century to model the performance of telecommunications systems. They make the following assumptions:

– Call arrivals are random
– Callers will wait if the system is busy
– Service times are exponential
– Callers are answered in the order of arrival
– Queue sizes are unlimited

Can I share CC-Excel workbooks with colleagues?

The calculations behind Excel add-ins are not transportable within workbooks. Only references to the functions’ names are embedded within workbooks and the calculations themselves are resolved using coding that is integrated within an Excel installation. Anyone wishing to make use of the workbooks you create must also have CC-Excel installed locally on their computer.

What are CC-Excel’s operational limits

CC-Excel can model up to 300,000 calls per hour, 10,000 agents and call durations up to 7200 seconds. Details for each function are available in the User Guide.

How does CC-Excel differ from Erlang for Excel?

Erlang for Excel is an Excel add-in that provides functions for Erlang B, Extended Erlang B and Erlang C. It includes two call center functions (ErlCAgents and ErlCalls). The remaining six functions relate to telecommunications network design. By contrast, CC-Excel is a specialist product for call center management and includes nine functions for calculating many aspects of contact center performance.

How does CC-Excel deal with 30 minute analytical intervals?

CC-Excel’s call center functions assume that your call volumes are based on the number of call handled during a one-hour period. In some cases, call volumes for only thirty minutes are available. Before you apply those values as an argument to a CC-Excel function, you should double them to convert them to hourly figures.

What version of Excel does CC-Excel require

Our Excel add-ins work on all Windows desktop versions of Excel from 97 to 2021, both 32-bit and 64-bit, and with the Windows desktop version of Excel provided with Microsoft 365 (formerly Office 365) subscriptions. They will not work with Excel for the web (the cloud-based workbook product), or with any Apple Mac versions of Excel.

How much does CC-Excel cost?

CC-Excel costs $99 (US dollars) for an installation on a single computer. We also offer enterprise licences for multiple installations.

This is a once-only payment and includes free upgrades for the lifetime of the product.

Visa, Mastercard and PayPal

9 Replies to “CC-Excel FAQ”

  1. Hi!

    I had to format my computer, and now when I want to install the program again, it gives me an error.

    Thanks

    1. Hello. Our support team (service@erlang.com) have just contacted you by email. You should now be able to install the software, but please feel free to contact them if you need any further help.

      Kind regards.

  2. Why am I getting an unconfirmed download error even though I approved the download and marked it not a scam?

  3. Is there any way to test this product before purchase? I would like to see if it will be something the Workforce Management Team will want to use.

    1. We do not have a trial version – sorry. But if you decide within fourteen days that the software is not right for you, we will refund your purchase as long as you uninstall the software from your computer.

    1. Sorry, but our products do not support silent or remote installations. You need to run the downloaded installation software on the computer that the software will be used on.

Leave a Reply

Your email address will not be published. Required fields are marked *