Hi there,
I am doing mathematics that is just extending me a bit too far.
I have an excel spreadsheet that is trying to calculate the hold times for a helpdesk.
This is the spreadsheet to download
http://www.jaybest.com/tempo/Tempo_RosterTool-BetaV1.02(Exposed).xlsx
This is the formulae that I tried to re-create, but I am sure that this is wrong, because if the volume gets too high, then the calculations start going into negative hold times, which isn't right!
http://en.wikipedia.org/wiki/Erlang_unit#Erlang_C_formula
I would put the formulae on the site but they are fairly long, and it is much easier to see in the spreadsheet.
Any help will be greatly appreciated! I am pulling out my hair, as when I first wrote this it was working fine.![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks again!
Jay Best
I am doing mathematics that is just extending me a bit too far.
I have an excel spreadsheet that is trying to calculate the hold times for a helpdesk.
This is the spreadsheet to download
http://www.jaybest.com/tempo/Tempo_RosterTool-BetaV1.02(Exposed).xlsx
This is the formulae that I tried to re-create, but I am sure that this is wrong, because if the volume gets too high, then the calculations start going into negative hold times, which isn't right!
http://en.wikipedia.org/wiki/Erlang_unit#Erlang_C_formula
I would put the formulae on the site but they are fairly long, and it is much easier to see in the spreadsheet.
Any help will be greatly appreciated! I am pulling out my hair, as when I first wrote this it was working fine.
Thanks again!
Jay Best