Queuing Theory with Excel - extra

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 . . . → Read More: Queuing Theory with Excel - extra

Queuing Theory with Excel pt2

The previous blog post showed the formulas that are used in M/M/c queuing models, and finished by showing that we need an Excel formula for if we are going to use Excel to help us.

The previous blog entry also introduced us to = the number of servers, and = the average utilisation

Excel does . . . → Read More: Queuing Theory with Excel pt2

Queuing Theory with Excel pt1

Capacity Planning makes extensive use of Queuing theory to predict future response times of a system when the workload increases.  There are many tools available that will automatically calculate the queues and can do multi-variate planning. However, if you have a really simple system and no money to buy a dedicated toolset, what can you . . . → Read More: Queuing Theory with Excel pt1