Mandela’s Library of Alexandria

Man working with Internet-in-a-Box home page

Internet-in-a-Box learning content examples

Quality Content

Internet-in-a-Box shows you the latest Content Packs
installable in the languages your community needs (from online
libraries like
Kiwix,
OER2Go,
Archive.org)
then takes care of all the downloading details for you!

See

Mexico’s live demo

and our

medical examples

used by clinics in Asia and Africa especially, as hosted by
Wikipedia.

Schools can also choose among

almost 40 powerful apps

for teachers and students — optionally with a complete LMS
(learning management system) like Kolibri, Moodle, Nextcloud,
Sugarizer or WordPress.

Two Haitian schoolgirls working on a laptop

Friendly Community

Internet-in-a-Box is a

community product

enabled by professional volunteers working

side-by-side

with schools, clinics and libraries around the world — and the

Wikipedia community

especially.

Thank you everyone for humbly being part of this

OFF.NETWORK

grassroots learning

movement
.

Please consider

how you too might assist

this epic effort.
It’s astonishing how far we’ve come since Internet-in-a-Box’s
original demo in 2013 — and how far we will go together,
If You Too Can Help!

Read More

Erlang for Excel

The original add-in that brings eight Erlang B and Erlang C functions into Microsoft Excel to help you to build your own traffic and call center workbooks. Simple to install. Lifetime upgrades.

Erlang for Excel examples

If you’re a telecommunications analyst or call center specialist, you’re probably familiar with Erlang functions. Erlang B estimates how many lines you need and Erlang C helps you work out how many agents should be answering your queued calls. We were the first company to put Erlang functions online (in 1996) and, three years later, the first to integrate Erlang with Microsoft Excel.

“We’ve used the Erlang for Excel add-in for years and it works great.”

Mark Rolag, xtDirect LLC

Supporting all versions of Excel (both 32 and 64 bit), this original add-in introduces eight Erlang functions that you can easily use in your workbooks to analyse your telecommunications trunk groups and estimate the number of call center agents you need at your inbound call center.

Using Erlang for Excel

Here is an example of how you can use Erlang for Excel to create traffic tables. The left table uses Erlang B – the ErlBLines() function is shown in the formula bar. The right table is for Erlang C and uses the ErlCAgents() function to estimate the agents required to meet the performance specified in the orange shaded table.

Erlang for Excel examples
Tables created using Erlang for Excel

You can design your own traffic workbooks by using these eight functions and referencing existing cells in your worksheets. With some knowledge of Excel, you can use its more advanced features such as lookup tables, conditional formatting and charting to build complex modelling tools.

Erlang Excel functions

Erlang for Excel installs eight 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)

Example calculators

We install ten example Erlang calculators in a workbook. Here are two of the Erlang B calculators:

Erlang for Excel calculators
Example Erlang calculators installed with Erlang for Excel

Documentation

We offer an illustrated user guide and help system. You’re welcome to contact us if you have any questions about the software, but please check the FAQ first.

Purchase and download

Visa, two circles and PayPal

“This product is useful, functional and accurate.”

Robert Scott Read, Consultant, Traffic Engineering.

Erlang for Excel provides your total Erlang calculation requirements, for life. It can be working on your PC in five minutes for a once-only licence fee that entitles you to free upgrades forever. Please choose the licence type you need:

Read More

By |2023-09-17T04:09:08+00:00September 17, 2023|Life and Health|0 Comments

About the Author:

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Go to Top