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.

Download Erlang for Excel here:

erlang97.zip (93KB) (version 1.8, 18 October 2001) zipped file containing Erlang for Excel (Office 97/2000 version).
ErlangXL97.xla, ErlangXL.doc, ErlangExample97.xls, ErlangInstall.txt, ErlangXL97Source.xls

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 queuing.
  
• Queue Time - the average waiting time for those calls which are not answered immediately.
  
• SLA - the actual percentage of calls answered with 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