510416 Excel Phone Call Analysis

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.

Beceriler: Her şey Kabul, Excel, Mobile App Development

Daha fazlasını gör: excel phone duration analysis, excel phone number simultaneous calls analysis, phone call analysis, phone call analysis excel, what graph to use for data, search graph, on call work, excel for data analysis, line graph excel, how phone, phone call, Data analysis in excel , data analysis excel, call and, analysis excel, analysis data excel, set analysis, active call, date analysis excel, space analysis, analysis space, excel line work, excel line graph time, graph data analysis, data analysis tool

İşveren Hakkında:
( 8 değerlendirme ) United Kingdom

Proje NO: #2256347



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.

%selectedBids___i_period_sub_7% gün içinde 60%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(34 Değerlendirme)