Complex Erlang maths and formulae.

[jaybest]

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.

Thanks again!
Jay Best

 

[RalphA]

I would like to try to help you, but,the downloaded file was not an Excel file. I am sending you a Personal Message (a PM) regarding it.

 

[VoG]

I would like to try to help you, but,the downloaded file was not an Excel file. I am sending you a Personal Message (a PM) regarding it.

Hi Ralph.

You will need http://www.microsoft.com/downloads/...-8F43-C6BB74CD1466&mg_id=10049&displaylang=en to view an XL 2007 file.

 

[jaybest]

Ah of course! Hate that compatibility issues..
I was just looking through a resource that would help me and I got to this site, which actually has the answer in downloadable form!

http://www.mitan.co.uk/erlang/elgcspsh.htm

This must have been where I first started out with the base code from ages ago..

When I finish it up, it will be up on www.jaybest.com/tempo for free download, for those that wanted to use it.

Thanks so much for your help though, I am sure you know what it is like when you get stuck on an issue like this!

Thank heaps,
JB

 

[RalphA]

Thank you, VoGII, for noticing and saving me a heap of trouble, as I only have my one and only, Excel 97, as I show in my signature!

Jay, I', happy that you found your answer, as that is the main goal of all of us who post here, to help others when we can. "All's well that ends well!"

 

[jaybest]

Hey there!

Thanks heaps again and it is all sorted out now.

The complete version is up on jaybest.com/tempo if you wanted to see how I had put it in place.

OH! and thanks heaps as well to VoGII for spotting me loading it as Excel 2007, I have changed the version so everyone can see and use it.

Only if you were interested tho!

Cheers,
Jay

 

[RalphA]

Thanks for the offer, Jay. I went to your websit and read your page. I decided, as I thought at the beginning, that it is not really my cup of tea. My only interest in responding to your post was, 1. I thought I just might be able to help you, and, 2.nobody had yet responded to it.

So, thanks again for your invitation, and I wish you all the best for your oviously useful, though specialized, new tool.