Welcome to the help system for Abstract Micro Systems' Erlang Library for Excel.
About the Erlang Library for Excel
End User License (EULA)
Installation
Erlang Toolbar
C Calculator
SL Calculator
W Calculator
Erlang Worksheet Functions reference
About the Erlang Worksheet Functions
Getting Help on the Erlang Worksheet
Functions
ErlbBlockage( nsrv, trafficInErlangs)
ErlbNsrvFromBlockage( blockageFraction,
trafficInErlangs)
ErlbTrafFromBlockage( blockageFraction,
nsrv)
ErlcFractionDelayed(nsrv,
trafficInErlangs)
ErlcFractionOk( nsrv, trafficInErlangs,
ahtSeconds, okWaitSeconds)
ErlcNsrvFromFractionOk(
trafficInErlangs, ahtSeconds, okWaitSeconds, fractionOk)
ErlcNsrvFromFractionOk5(
secondsPerPeriod, callsPerPeriod, ahtSeconds, okWaitSeconds, fractionOk)
ErlcNsrvFromWait( trafficInErlangs,
ahtSeconds, averageWaitSeconds)
ErlcNsrvFromWait4( secondsPerPeriod,
callsPerPeriod, ahtSeconds, averageWaitSeconds)
ErlcNwaiting( nsrv, trafficInErlangs)
ErlcNwaiting4( nsrv, secondsPerPeriod,
callsPerPeriod, ahtSeconds)
ErlcTrafFromFractionOk(nsrv,
ahtSeconds, okWaitSeconds, fractionOk)
ErlcTrafFromWait( nsrv, ahtSeconds,
averageWaitSeconds)
ErlcWait( nsrv, trafficInErlangs, ahtSeconds)
ErlcWait4( nsrv, secondsPerPeriod,
callsPerPeriod, ahtSeconds)
Erlang Queueing Models
About Erlang Queueing Models
Erlang B Queueing Model
Erlang C Queueing Model
The Erlang Library for Excel is an Excel Add-In file named A_Erlang.xla. The Add-In augments the power of Microsoft Excel with additional functionality useful to call center administrators and other telecom professionals. The additional functionality consists of Erlang calculators, and Erlang worksheet functions that you can use from within Excel. You install the Add-In by using the Excel menu option Tools|Add-Ins.
After installing the Erlang Library for Excel, a new custom toolbar appears in your Excel workbook windows: the Erlang Toolbar. There are four buttons on the Erlang Toolbar, labeled "C", "SL", and "W". You use the C, SL, and W buttons to launch small windows forms called the C Calculator, the SL Calculator, and the W Calculator, respectively. You use these calculators to perform common calculations related to the staffing and performance of call centers. You use the "?" button to open the help system.
Although the Erlang calculators are often helpful, most users will make more frequent use of the Erlang Library's worksheet functions that you can use in any Excel workbook to perform calculations with Erlang functions. These functions are used in exactly the same way as Excel's built-in worksheet functions such as EXP() or ABS().
©2008 Abstract Micro Systems