<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Under CAR > Device Reports > Gateway Utilization, I've created
graphical reports of the gateways that tell me how often they are used. </DIV>
<DIV> </DIV>
<DIV>It doesn't provide those fancy numbers required for erlang and busy time of
day calculations, but it does show when a PRI isn't being used at all and how
often a PRI is used. </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Scott.Voll@wesd.org href="mailto:Scott.Voll@wesd.org">Voll, Scott</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cschuett@hfsnorthamerica.com
href="mailto:cschuett@hfsnorthamerica.com">Court Schuett</A> ; <A
title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, June 09, 2005 2:09
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [cisco-voip] PRI
Utilization</DIV>
<DIV><BR></DIV>Thank You..... I'm going to cancel a PRI. Wish I would
have had this a<BR>year ago. PRI's aren't
cheap.<BR><BR>Scott<BR><BR>PS. Something so easy and Cisco can't do
it? Switch packets by the<BR>millions but can't write a simple
ASP. Cisco, are you listening. The<BR>works done you just need to
make the ASP. :-)<BR><BR><BR><BR>-----Original Message-----<BR>From: <A
href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</A><BR>[mailto:cisco-voip-bounces@puck.nether.net]
On Behalf Of Court Schuett<BR>Sent: Thursday, June 09, 2005 7:30 AM<BR>To: <A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR>Cc:
Drew Achterhof<BR>Subject: [cisco-voip] PRI Utilization<BR><BR>I thought I've
seen this request go out before and just wanted to let<BR>people who were
looking for it know that I've got a solution. It's an<BR>ugly one, but
it does work.<BR><BR>Here's how it goes.<BR><BR>Go to CAR<BR>Device-Reports
-> Gateway -> Detail<BR><BR>Export the data you're looking for to a
CSV.<BR><BR>In Excel, strip out everything you don't need until your columns
look<BR>like this:<BR>Column A: Date<BR>Column B: Start Time<BR>Column C: End
Time<BR><BR>Then, in Column E, starting in Row 2, put in the minutes of the
day in<BR>number (I use Decimal 10) format. It should look like
this:<BR>0.0000000000<BR>0.0006944444<BR>0.0013888889<BR>0.0020833333<BR>0.0027777778<BR>0.0034722222<BR>0.0041666667<BR>0.0048611111<BR>0.0055555556<BR>0.0062500000<BR>0.0069444444<BR>0.0076388889<BR>0.0083333333<BR>0.0090277778<BR>0.0097222222<BR>0.0104166667<BR>0.0111111111<BR>0.0118055556<BR>0.0125000000<BR>0.0131944444<BR><BR>Expand
that down all the way until it reaches 1. <BR><BR>In Column E, Row 1,
enter the date you want to study. <BR>In Column F, put this
function:<BR>=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$10000<=E2+1/1440)*(C$1:C$10000>=E2+<BR>1/1440))<BR><BR>That
will analyze the first 10,000 calls for the day you put in E1. <BR>In
Column G, I put =MAX(F2:F1441) to give me the max concurrent calls<BR>for the
day. <BR><BR>Management really likes this information because it gives
them a good<BR>idea if they need to buy more PRIs or cancel some.
<BR><BR>The analysis is not perfect. It only analyzes by minute so it
can miss<BR>some connections, but it is pretty good. Usually good
enough. If you<BR>wanted to take it out to the second, it wouldn't be
that difficult<BR>either.<BR><BR>I have plans to create a PHP or perl script
that will perform better<BR>analysis but this is what I have for now.
<BR><BR>Hope that helps!<BR><BR>Court Schuett<BR> <BR>630-909-5560<BR><A
href="mailto:cschuett@hprlogistics.com">cschuett@hprlogistics.com</A><BR><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR><BR>_______________________________________________<BR>cisco-voip
mailing list<BR><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A><BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR></BLOCKQUOTE></BODY></HTML>