Excel telephone audit

I would like to develop an excel spreadsheet that analyses my home phone bill so I can perform an audit each time I receive it each month. I have provided a sample sheet of the data and the call costs involved. I am having problems with categorizing the days of week and times. This is only a sample of the data. It is usually over 200 hundred rows deep and the data in the green changes every month.

I need excel to calculate the raw data based on the call rates based on times of day and days of week. The following calculations for various times of day, day of week and time are call are shown on the attachment but I have also provided further information on the calculation required;

© Peak times between 7am to 6pm Monday to Friday

© Special call rates between 6pm and 12am Monday to Friday that offers a call cap for 2 hours. I also need the calculation to be made if the call goes beyond the 2 hour limit (120minutes) and past 12am

© The same applies for the cell phone calls. Calls are capped at $1.75 for 20 minutes between 6pm to 12am Monday to Sunday. Calls beyond the 20 minute limit are calculated at the cell phone rate on the excel worksheet.

© For all calls there is call connection fee for home phone and cell phones. Can you also include this in the calculation?

Please suggest a fair price for this project.

Compétences :

Voir plus : sample problems, on audit, information audit, green audit, excel special, excel &, call minutes, telephone audit sheet, telephony audit xls, audit excel worksheet, n excel, need an audit, rows, price excel, perform, peak to, it green, IS audit, fair, excel\ , excel, excel calculation, excel c#, excel based, copy excel

Concernant l'employeur :
( 0 commentaires ) Melbourne, Australia

N° du projet : #11176

8 freelance font une offre moyenne de $72 pour ce travail


hi. we can do it!

100 $ USD en 5 jours
(66 Commentaires)

You require to calculate the call charges based on rules specified in the sheet. Formlae can be written directly on sheet for this. If felt complx we can have solution through VBA custom functions and validations. I Plus

45 $ USD en 5 jours
(54 Commentaires)

I am sure your requirements can be fully met and in a very presentable and user friendly form. I have designed lots of Excel spreadsheets for my office in such a way that a person who has no idea about excel can use it Plus

50 $ USD en 5 jours
(16 Commentaires)

Hello I can provide you this just send me a previous copy of bill or some other related formulaes or some other description you want it to my knowledge. Waiting to hear from you soon to discuss [url removed, login to view],Nouman.

60 $ USD en 2 jours
(2 Commentaires)

Hello I can provide you with a solution. I've developed many projects in spreadsheet. Infact I am very much comfortable in Excel. Waiting to hear from you soon to discuss about ur work.

80 $ USD en 5 jours
(0 Commentaires)

My name is Patrick Staring. I have been making Excel sheets and macro's for businesses for more than 10 years. If I understand correctly you want to have a sheet that calculates the costs for your phonecalls. If all va Plus

100 $ USD en 4 jours
(2 Commentaires)

Hello, I have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash and Excel Worksheet macro development. Beside this we can propo Plus

100 $ USD en 5 jours
(0 Commentaires)

I have done complex excel projects and I can do this project.

40 $ USD en 10 jours
(0 Commentaires)