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.


Näytä lisää: 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\

Tietoa työnantajasta:
( 0 arvostelua ) Melbourne, Australia

Projektin tunnus: #11176

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


hi. we can do it!

$100 USD 5 päivässä
(66 arvostelua)

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 Lisää

$45 USD 5 päivässä
(54 arvostelua)

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 Lisää

$50 USD 5 päivässä
(16 arvostelua)

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 2 päivässä
(2 arvostelua)

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 5 päivässä
(0 arvostelua)

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 Lisää

$100 USD 4 päivässä
(2 arvostelua)

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 Lisää

$100 USD 5 päivässä
(0 arvostelua)

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

$40 USD 10 päivässä
(0 arvostelua)