I would like a tool developed that, given a set of electronic call data in Excel, can calculate the number of simultaneous calls that were made.
As shown in the attachment (with dummy data), the tool would need to take the call date and time for each call and use the duration to work out what 'space of time' the call took up e.g. Call 1 in the data started at 16:43:48 on 31/03/2011 and duration was 34 seconds and therefore the call was active between 16:43:48 and 16:44:22. The tool would then need to search the rest of the call data to see if any other call was active at this time.
The aim is to produce an output of when, and how many, simultaneous calls took place. So that I can then produce a line graph showing the number of simultaneous calls that took place on a given day or on a given period.
I am excel macro expert and can complete this as per your requirement. I would require anywhere between 2 to 4 days to complete this. Kindly let me know. Thanks Looking forward for this work.