I require program that analyses phone bills based on cost, duration, day, time of day and compares them to a number of telephone companies and plans.
There are many contingencies required. The software must cater for the following
• 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
• To be able to cater for price caps on call duration and call cost after these call durations. For example, Monday to Friday between 8pm and 12am calls capped at $2.00 for 2 hours (120minutes) then after this time normal call rates apply
• 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.
Sample of the raw data I require to be analysed and the differing fields required