Devam Ediyor

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ün: graph use data, search graph, line graph excel, how phone, phone call, call and, active call, excel line work, excel line graph time, simultaneous, excel line, call graph, excel phone number search, excel phone search, line graph excel time, phone call excel, work dummy data, search phone number, excel phone number, excel graph data set, excel search phone number, need call data, search phone number excel, tool calculate, call number

İş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.

3 gün içinde 60$ USD
(34 Değerlendirme)