Erlang-calcs in Excel Tagged: Excel This topic has 2 replies, 2 voices, and was last updated 2 years ago by Tom Howard. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts 8th January 2004 at 09:50 #26073 Erik KofoedGuest Has anyone designed an Excel-file that calculates Erlang (or has the formula for calculating Erlang) ? Thanks in advance… 13th January 2004 at 21:46 #26074 LanceGuest Try this site: http://www.voip-calculator.com/calculator/ Regards, Lance 15th June 2020 at 09:18 #72905 Tom HowardKeymaster Yes, we offer an Excel add-in called Erlang for Excel that adds Erlang functionality to your own spreadsheets. It adds these functions: Erlang for Excel installs nine Erlang B and Erlang C functions into Microsoft Excel: Function name Description ErlBLines() Estimates how many lines you need if you know your busy hour traffic. ErlBBlocking() Estimates the blocking a trunk group will experience. ErlBTraffic() Estimates the traffic that can be offered to your trunk group before blocking exceeds your target. ErlCAgents() Estimates how many agents you need to handle your incoming calls. ErlCCalls() Estimates how many inbound calls your agents can handle, keeping within your performance targets. ExtErlBLines() Same as ErlBLines, but takes call retries into account. ErlBBlocking() Same as ErlBBlocking, but takes call retries into account. ExtErlBTraffic() Same as ErlBTraffic, but takes call retries into account. For example, if you want a cell to show the number of lines required to keep to your blocking target of 0.01 and your Busy Hour Traffic is in cell B6, you would enter this formula into the cell: =ErlBLines(B6,0.01) Erlang for Excel is packaged with Westbay Traffic Calculators, an Erlang calculator for Windows. Together, they can provide your total Erlang calculation requirements, for life. Author Posts Viewing 3 posts - 1 through 3 (of 3 total) The forum ‘Voice over IP’ is closed to new topics and replies.