I'm looking for the creation of mobile analysis software in which, an Excel spreadsheet containing companies mobile usage can be broken down into graphs and reports. The reports are then to be displayed in an Excel spreadsheet presentation.
Please find a spreadsheet attached of how we wish the results to appear.
• To be able to input a set of raw data from Microsoft excel that includes cost, date, time, duration of call and distance and have this information analysed.
• Prepare a database on telephone companies and the different services they offer
• Categorise time and day for each call and costs associated with those calls. Length of time compared to call cost based on various times of day and day of week
• An extra provision for local calls, long distance and mobile (cell phone) phone calls
• • The ability input and delete a number of companies
• Ability to produce reports that includes information and graphs describing the analysis. This information and set out will be provided.
The data will include each users call usage, call destination, length of call etc.
We want to find out the folowing data extracted for each user;
-Off peak calls
-Calls to Orange, O2, Vodafone, T Mobile and 3
-Calls to voicemail
and International Roaming calls
We then want the overall data and statistics to be populated and presented in straightforward graphs.