?
Solved

Visualize list of calls in csv file to learn max # of simultaneous calls

Posted on 2014-11-17
7
Medium Priority
?
59 Views
Last Modified: 2014-12-22
I have a csv file with a list of telephone calls, with columns for start time, end time, and duration for 30 days. I need to figure out how calls overlapped, to see what was the highest amount of simultaneous calls, and average amount of simultaneous calls by day, and for the month.

==========
Prior related question: http:Q_28533850.html
0
Comment
Question by:bigbangtech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 2000 total points
ID: 40449591
here is the file.

see if this is exactly what you are looking for.
ee.xlsb
0
 
LVL 46

Expert Comment

by:aikimark
ID: 40449648
@ProfessorJimJam

Where did you get the workbook?  Is there a prior related question that we should know about?
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40449661
@aikimark

i recalled a similar question that Glenn and I, we have provided solution in month of October

the reference link is here http://www.experts-exchange.com/Software/Office_Productivity/Q_28533850.html
0
 

Author Comment

by:bigbangtech
ID: 40458426
I will review the excel sheet and get back next week.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 40512692
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question