Erlang for Excel

This page has freeware versions of add-ins for Microsoft Excel 97/2000 and Microsoft Excel 7 (95) which allow you to use standard Erlang-C calculations within Excel spreadsheets.

You are allowed to download and use these files for your own use, however the content remains the copyright of the author. You may not sell, rent or lease these files or any part of them without prior written consent of the copyright owner.

These files are provided as-is, the author makes no guarantees as to the suitability of them for any task and will not be held liable for any damages that might be caused to your hardware, software or data.

Excel 97 - 2010

Erlang97.zip (93KB)
(version 1.8a, 19 July 2022)
zipped file containing Erlang for Excel (Office 97/2000/3/7/10 version).
ErlangXL97.xla
ErlangXL.doc
ErlangExample97.xls
ErlangInstall.txt
ErlangXL97Source.xls

Excel 95

Erlang95.zip (44KB)
(version 1.5, 6 Jan 2000)
zipped file containing Erlang for Excel (Office 95 version).

ErlangXL95.xla
ErlangXL.doc
ErlangExample95.xls
ErlangInstall.txt
ErlangXL95.xls

Functions available within Excel:
• Abandoned - the percentage of callers who will abandon after a given time.
• Agents - calculate the number of agents required to achieve a SLA target.
• AgentsASA - calculate the number of agents required to achieve an ASA target.
• Average Speed to Answer (ASA) - the average time taken to connect to an agent.
• Call Capacity - the maximum number of calls that can be handled.
• Fractional Agents - calculate the number of notional agents required to achieve a SLA target.
• Fractional Call Capacity - the maximum number of calls that can be handled.
• Queued - the percentage of calls which will be queued.
• Queue Size - average number of calls queueing.
• Fractional Queue Size - average number of notional calls queueing, to 1 decimal place.
• Queue Time - the average waiting time for those calls which are not answered immediately.
• SLA - the actual percentage of calls answered within the target time.
• Service Time - the time within which a certain percentage of calls will be answered.
• Trunks - the number of telephone trunks required for a given call load.
• Utilisation - percentage of agent's time spent on the telephone.
• ErlangB - blocking factor
• ErlangBExt - blocking factor with retry facility
• ErlangC - queuing factor
• EngsetB - blocking factor using the Engset model
• NBTrunks - number of busy hour trunks required
• Traffic - traffic in Erlangs from the number of trunks and blocking achieved