Excel Report for Telco Analysis

I am a cost control consultant and I analyse Telcommunications accounts for clients I have an excel spread sheet that I want you to improve on. One for Landline accounts and one for Mobile accounts. The report is our tool to show the client there current spend with their existing Telecomm povider and also to show the savings they will achieve by changing providers or getting a cheaper rate with the existing provider. ## Deliverables Redesign our current spread sheet to have a corporate look and feel Modify the report to improve on the functionality. Minimise the number of manual entries needed and improve on Data sheet functionality. Landline Services The report must clearly identify the current costs to the client and break up the costs into Local, national, calls to Mobiles, line rental, International calles, and 1300/1800 cost for Land lines Mobile Services National,SMS,Call diversion, inter company calls, calls made OS, Calls recieved while OS, Message retreval The report must then show a comparison between the companies that are tendering for the business and what cost saving that will represent in each area of expense. Data sheets are used to OCR current billing details from hard copy bills and new pricing is entered into this spread sheet to calculate the percentage saving that a new rate will give. This has already been done. I want to link the results of this data back to the main spread sheet. I will send the exising spread sheet if you would like to look at it first before making a decision. Gary ## Platform Windows 2000 Excel 2002