Mileage log needed Excel 2007

[Joe727]

Hi - I am looking for a daily mileage template for Excel 2007.

In addition to starting and ending odometer entries, I need a template with
a column that will keep track of the *daily* mileage reimbursement I
receive. This daily mileage reimbursement is less that the standard mileage
deduction the IRS allows.

So, I will need to subtract the daily reimbursement from the standard IRS
mileage deduction.

I don't need to make this particular calculation on a daily basis, but I do
need to keep a running total of the daily mileage reimbursement.

Just a heads up, I really don't know much about creating spreadsheets, which
is why I am looking for a template.

Thanks

Joe

 

[Gord Dibben]

Have a look at the Template Gallery search for mileage.

http://office.microsoft.com/en-us/templates/results.aspx?qu=mileage&av=TPL000


Gord Dibben MS Excel MVP

 

[Joe727]

Hi - thanks for responding. It looks like this template might work if I can
add the daily mileage reimburstment and keep a running total of it:

http://office.microsoft.com/en-us/templates/TC060884581033.aspx?pid=CT101440991033

Can you point me to a formula that will add the daily mileage reimburstment
and keep a running total of it?

Joe

 

[Gord Dibben]

I could explain it all to you but I did not like some of the features and
formulas of the template.

I have re-worked it quite a bit so best if you send me an email and I can send
you the re-worked file.

Change the AT and DOT in my email address to appropriate punctuation.


Gord

 

[Joe727]

Hi - I sent you the e-mail.

Thanks

Joe

I could explain it all to you but I did not like some of the features and
formulas of the template.

I have re-worked it quite a bit so best if you send me an email and I can
send
you the re-worked file.

Change the AT and DOT in my email address to appropriate punctuation.


Gord

 

[Gord Dibben]

Got it and sent you a file.

Gord

Hi - I sent you the e-mail.

Thanks

Joe

 

[Joe727]

Thanks Gord - I really appreciate you helping me with this template.

Joe

 

[chapamark66]

Thanks Gord - I really appreciate you helping me with this template.

Joe

Joe do you still have the template for this if so can you email it to me. Thanks

 

[chapamark66]

Hi - I am looking for a daily mileage template for Excel 2007.

In addition to starting and ending odometer entries, I need a template with
a column that will keep track of the *daily* mileage reimbursement I
receive. This daily mileage reimbursement is less that the standard mileage
deduction the IRS allows.

So, I will need to subtract the daily reimbursement from the standard IRS
mileage deduction.

I don't need to make this particular calculation on a daily basis, but I do
need to keep a running total of the daily mileage reimbursement.

Just a heads up, I really don't know much about creating spreadsheets, which
is why I am looking for a template.

Thanks

Joe