Thanks Thanks:  5
Page 2 of 2 FirstFirst 12
Showing results 11 to 12 of 12

Thread: Add Ons ERLANG table for Excel

  1. #11
    Member Reputation: 623
    Join Date
    2010-01-29
    Posts
    874


    Default Re: Add Ons ERLANG table for Excel

    If u mean GOS 2 %
    then type

    =ch2erl(50;2)

    if u want convert "number channel to Erlang offered, assumption FR
    sample 50 Channel with gos 5 %
    type =ch2erl(50;2)

    =erl2ch(XX;Y)
    Where XX = Erlang (prediction traffick that u wanna offer)
    Y = GOS

    Sample, wanna absorb 30 erlang traffick with GOS 5 %
    =erl2ch(30;5)





    Quote Originally Posted by sohappy View Post
    So, the result of this add on were wrong.
    When i type chan2erl(50,0.02) the result is 29.85, but the true value is 40.26 base on Erlang B table, or i type erl2chan(40.26,0.02) the result is 64, but the true value is 50 base on Erlang B table.
    Last edited by paboya; 2011-10-31 at 04:01 PM
    thanx for clicking THANX and REP

  2. #12
    Member Reputation: 26
    Join Date
    2011-02-26
    Posts
    73


    Default Re: Add Ons ERLANG table for Excel

    Results are correct. For 2% of goS , you need to put 2, not 0.02 hence Erlang capacity of 50 channels with 2% GOS you need to put ch2erl(50,2) and result is 40.26 which is correct.

    Quote Originally Posted by sohappy View Post
    So, the result of this add on were wrong.
    When i type chan2erl(50,0.02) the result is 29.85, but the true value is 40.26 base on Erlang B table, or i type erl2chan(40.26,0.02) the result is 64, but the true value is 50 base on Erlang B table.

Bookmarks

Bookmarks

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •