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.


Lihat lagi: 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\

Tentang Majikan:
( 0 ulasan ) Melbourne, Australia

ID Projek: #11176

8 pekerja bebas membida secara purata $72 untuk pekerjaan ini


hi. we can do it!

$100 USD dalam 5 hari
(66 Ulasan)

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 Lagi

$45 USD dalam 5 hari
(54 Ulasan)

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 Lagi

$50 USD dalam 5 hari
(16 Ulasan)

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 [login to view URL],Nouman.

$60 USD dalam 2 hari
(2 Ulasan)

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 dalam 5 hari
(0 Ulasan)

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 Lagi

$100 USD dalam 4 hari
(2 Ulasan)

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 Lagi

$100 USD dalam 5 hari
(0 Ulasan)

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

$40 USD dalam 10 hari
(0 Ulasan)