# simple excel spreadsheet

easy project

we need a mileage calculator for our office spreadsheet

the calculator needs to be backdated in years

ie 2009 2010 2011 2012

years = 4

miles x 0.45 up to 10000

after 10000 its 0.25

for example

miles eg 1 mile 0.45

2 mile 0.90

3 mile 1.35 etc etc up to 10000 which would come to 4500

after 10000 reduce calculating rate to 0.25

so 1 mile =0.25

2 mile =0.50 etc etc

so in this example 12000 miles would calculate to 10000 x 0.45 = 4500 + 2000 x 0.25= 5000

we then need this total figure (whatever the total figure is )

to be multipled by

20% 40% and 50%

so if the total figure is 5000

we need the output for 20% = 1000

40% = 2000

50% = 2500

so the output would read ie 1 year 12000 miles(10000 at 0.45 + 2000 at 0.25)* 20% rate = 10000

calculation =

years x miles x miles rate

total multiplied by rate either 20 40 0r 50%

pm for immediate decision simple job probably an hrs work

Kemahiran: Pemasukan Data, Excel

Tentang Majikan:
( 0 ulasan ) United Kingdom

ID Projek: #1592332

## Dianugerahkan kepada:

kujsal

Please check PMB

\$30 USD dalam sehari
(1 Ulasan)
1.0

## 16 pekerja bebas membida secara purata \$31 untuk pekerjaan ini

pishty

I am interested in your project.

\$34 USD dalam 2 hari
(35 Ulasan)
5.8
nagybatonyi

Hi, See PMB for a draft solution!

\$30 USD dalam 0 hari
(48 Ulasan)
5.6
samitXI

Ready to start now. Thanks

\$34 USD dalam sehari
(36 Ulasan)
5.6
ethicalboy

Hello, I can do it.

\$30 USD dalam 0 hari
(26 Ulasan)
4.5
kulhanekd

I have 15 years exp in excel and can do the formulas you request. Thanks Donna

\$30 USD dalam sehari
(11 Ulasan)
4.5
Pichart

Yes, this is not difficult, I will be ready for the project 6 hrs after this...more in PM

\$30 USD dalam sehari
(17 Ulasan)
4.4
Midlander

Chris, Needs three simple formulae. Have put spreadsheet together giving you two choices of layout: (a) Shows you all 4 years and 3 percentage rates. (b) One column of four rows where you select year and rate f Lagi

\$30 USD dalam sehari
(4 Ulasan)
3.6
ahmedmayeen

Hi, Please refer to my private message as bidding's cover letter. Thanks, Mayeen

\$33 USD dalam sehari
(4 Ulasan)
3.5
phpthebest

Hi I made part of your project check PM I sent you.

\$30 USD dalam 0 hari
(5 Ulasan)
3.3
manohartvs

Hi, I've started working on some sample calculations and can have your result ready soon. Please contact me and we can complete all formalities asap. Cheers

\$40 USD dalam sehari
(3 Ulasan)
2.6
zekili

It is the job for me. Check your PM

\$30 USD dalam sehari
(3 Ulasan)
2.5
mynameisajay

Please check pm for details.

\$30 USD dalam 0 hari
(1 Ulasan)
1.0
scs9gp

hi i can do this job for you.

\$30 USD dalam 2 hari
(0 Ulasan)
0.0
sanjaybabu1

Hi, I am interested to work. I am a honest man with very hard working for every possible work. Thank you.

\$30 USD dalam sehari
(0 Ulasan)
0.0
shailvaishali

Give me a chance to prove

\$30 USD dalam sehari
(0 Ulasan)
0.0
sifullah

hi, it's an simple job. if you are interested i can do it for you. just waiting for your permission . thx

\$30 USD dalam sehari
(0 Ulasan)
0.0