View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
nwatkins nwatkins is offline
external usenet poster
 
Posts: 6
Default Calculate actual trunk utilization based on call start/duration

I was surprised as well - I assumed it would take hours to run...plus
I'm doing this on one of our ultra-portables, so it isn't the fastest
machine in the world to start with. My main concern with the whole
plotting concept was to get an idea how often the lines were being
utilized. The printout works even better, as it shows how many
"times" (aka - how many seconds) each line was utilized (correct me if
I'm wrong). I couldn't have asked for a better solution. I am
planning on pulling out the same data from one of our other phone
switches and combining it with this one. That will give us a very
accurate representation on how many trunks we actually need in order
to support both locations. Thanks again for this solution.

Nathaniel