Excel/VBA project to summarise Skype call log data
$30-100 USD
Closed
Posted over 13 years ago
$30-100 USD
Paid on delivery
It may well be that someone out there has already done this.
I currently have an Excel worksheet (attached) that takes a raw Skype call history file and processes it to give me the following information by unique phone number (I am interested not just in the number of calls but the number of calls to unique telephone numbers).
Number of calls per day/week/month
Number of non contact calls per day/week/month (ie where the phone call = 0 seconds)
Number of contact calls per day/week/month (ie where the phone call >0 and <120 seconds)
Number of successful calls per day (ie where the phone call > 120 seconds)
The number of times any individual number is called per day/week/month
The rolling average number of the different type of calls per day/week/month
The information also shows whether the call was a Landline/Mobile/Premium number and if it is outside the UK.
The problem is that although the worksheet provides the information it takes a lot of time to set up and process. There are several manual stages involved.
I want someone to take the worksheet and automate it so that all I need to do is import the raw data file for it to produce the data that I want.
This shouldn't be too big a job for an Excel/VBA expert
Alternatively you may already be aware of a module that can do this?
Many thanks
Chris
## Deliverables
The final product must take a standard Skype call history file and provide the specified outputs in an Excel 2007 file, together with the outputs in the current Excel spreadsheet.