Only a few days ago, I blithly said

The Excel formula of 1/(Poisson(,,false)*exp()/() + Poisson(,,true)*exp() - Poisson(,,false)*exp())

Is equal to

Now you have the "tricky" value, all other values in the M/M/c queuing theory are MUCH easier to calculate.

It has been suggested to me, that it *might *help if I made this formula a little easier still.

Never one to shirk a challenge.....

**What can we do with this?**

Starting with the formula

1/(Poisson(,,false)*exp()/() + Poisson(,,true)*exp() - Poisson(,,false)*exp())

The exp() gets used quite a lot in that formula, so we can take it out and use it only once.

1/(exp() * (Poisson(,,false)/() + Poisson(,,true) - Poisson(,,false)))

Already, that looks much simpler to the eye.

Or if you want to limit the number of times you have to use the Poisson formula, you could then put those two Poisson(,,false) statements together and say

1/(exp() * (Poisson(,,true) + (Poisson(,,false)*() )))

**Checking that you've got it right**

Of course. It is always useful to check that you have entered formula correctly. For this purpose, I always try a "simple" calculation.

Let's look at an example queue in which there are 5 servers (), events occur every 6 minutes and the service time is 20 minutes.

The arrival rate is

The service rate is

So the Utilisation or is which is = 0.6667

**Traditional Formula**

**Excel Formula**

1 / (exp() * (Poisson(,,true) + (Poisson(,,false) * () )))

1 / (EXP(5*0.6667) * (POISSON(5,5*0.6667,TRUE) + (POISSON(5,5*0.6667,FALSE) * (0.6667/(1-0.6667)))))

1 / (28.0363 * (0.8788 + (0.1223 * (2) ) ) ) = 0.03175

So. I now know that I have got the right Excel formula (with the right brackets in the right place). I can now continue with my queuing model, fully able to calculate queue probability in a single cell, even for very large systems with a large number of servers.

I'm impressed that you can do this in Excel. To be honest I would recommend some other software like MATLAB and Simulink for Queuing Theory modeling http://www.mathworks.com/discovery/queuing-theory.html.

To be honest, I completely agree. Given a preference, I would always use a tool that is designed for the task. However in my consulting positions I often find that the client sadly doesn't have any tools beyond Excel (and no budget either).