Lukket

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 $[url removed, login to view] 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.

Færdigheder:

Se mere: sample problems, on audit, information audit, green audit, excel special, call minutes, telephone audit sheet, telephony audit xls, audit excel worksheet, n excel, need audit, rows, price excel, perform, peak to, it green, is audit, fair, excel calculation, excel based, copy excel, cap, calculations, beyond the, attachment

Om arbejdsgiveren:
( 0 bedømmelser ) Melbourne, Australia

Projekt-ID: #11176

8 freelancere byder i gennemsnit $72 for dette job

evsoft

hi. we can do it!

$100 USD in 5 dage
(66 bedømmelser)
6.2
rajanlengde

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 Mere

$45 USD in 5 dage
(54 bedømmelser)
2.5
sureshmalankar

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 Mere

$50 USD in 5 dage
(16 bedømmelser)
1.0
hightech

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 further.Regards,Nouman.

$60 USD in 2 dage
(2 bedømmelser)
0.0
varun82

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 in 5 dage
(0 bedømmelser)
0.0
Spreadsh33t

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 Mere

$100 USD in 4 dage
(2 bedømmelser)
0.0
sunita1234

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 Mere

$100 USD in 5 dage
(0 bedømmelser)
0.0
manivelank

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

$40 USD in 10 dage
(0 bedømmelser)
0.0