I am trying to write a number of Excel spreadsheets that will manipulate voice & data information from our existing network and be used in determining what bandwidth & CODEC will be used (amoung other things) in building our VoIP network.
The Spreadsheet is based off some models found in various calculators on the web, as well as a few new ones I have seen as of yet. My question concerns the Erlang B model. I have downloaded a few “Excel Addins” that should incorporate the Erlang B formula into my calculations, but the results seem to vary greatly from what calculators that use it show. I have also noticed a slight disparity between the results from one calculator to the next on the web, although I think this may be due to the way the model has been translated into the Javascript functions being used.
Any reccommendations on either where to download the best Erlang Excel Addin, or a good applicable formula that can be used directly into Excel?
Also, what are the advantages of using the B model over the C model?
Do the results vary, or are the two models just used to make calculations for different things?