Solved

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

Posted on 2014-11-17
7
47 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
7 Comments
 
LVL 25

Accepted Solution

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

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

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 25

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 45

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
VBA Code Mixed Combining Two User Forms 7 38
Resource cost of NAT vs routing 3 23
TT Copy Formula 3 16
Rearrange Macro 7 18
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
When posting a question about a Cisco ASA, Cisco Router or Cisco Switch, it can aid diagnosis if a suitably sanitised copy of the config is provided. It is much better to leave as much of the configuration as original as possible, as it could be tha…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now