[cisco-voip] PRI Utilization

[Voll, Scott]

New question.  How do I find out how many concurrent calls I have between
locations?  IE.  central site to remote site.  We are getting fiber and I
want to know how much I really need to support our on net calls.

Thanks

Scott

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Voll, Scott
Sent: Thursday, June 09, 2005 11:09 AM
To: Court Schuett; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] PRI Utilization

Thank You..... I'm going to cancel a PRI.  Wish I would have had this a
year ago.  PRI's aren't cheap.

Scott

PS.  Something so easy and Cisco can't do it?  Switch packets by the
millions but can't write a simple ASP.  Cisco, are you listening.  The
works done you just need to make the ASP. :-)



-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Court Schuett
Sent: Thursday, June 09, 2005 7:30 AM
To: cisco-voip at puck.nether.net
Cc: Drew Achterhof
Subject: [cisco-voip] PRI Utilization

I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution.  It's an
ugly one, but it does work.

Here's how it goes.

Go to CAR
Device-Reports -> Gateway -> Detail

Export the data you're looking for to a CSV.

In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time

Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format.  It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444

Expand that down all the way until it reaches 1.  

In Column E, Row 1, enter the date you want to study.  
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$10000<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))

That will analyze the first 10,000 calls for the day you put in E1.  
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.  

Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.  

The analysis is not perfect.  It only analyzes by minute so it can miss
some connections, but it is pretty good.  Usually good enough.  If you
wanted to take it out to the second, it wouldn't be that difficult
either.

I have plans to create a PHP or perl script that will perform better
analysis but this is what I have for now. 

Hope that helps!

Court Schuett
 
630-909-5560
cschuett at hprlogistics.com

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3291 bytes
Desc: not available
Url : https://puck.nether.net/pipermail/cisco-voip/attachments/20050629/62c71b30/smime.bin