LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Creating a worksheet/template for Mileage

I have been given the task to figure out what it will cost us a year to
deliver to a certain branch.

We have a branch that we would like to start delivering to. We need to find
out how much it is going to cost us a year to deliver items to and from this
branch.

I need the following information to show and I need the ability to change if
gas prices change, weekdays in the year, etc.:

1. Weekdays we work a year: 261 week days in 2009
2. # of miles from the branch we work at to the other branch we want to
deliver to. - Estimated mileage is 140 miles round trip per day.
3. The trucks take 20 mpg
4. We want to use the gas price of $2.10.

Can anyone help me set up a template or does anyone have one to forward me
that I can use.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating summary worksheet from template Ballwin Tom New Users to Excel 7 July 22nd 08 10:39 PM
How do I setup a worksheet to track gas mileage/gallon? billymick New Users to Excel 2 August 30th 07 04:48 PM
gas mileage template ronoftn Excel Discussion (Misc queries) 1 September 5th 06 04:40 AM
Creating a new worksheet from a template username Excel Discussion (Misc queries) 0 May 19th 05 04:36 PM
PDA MS OFFICE Where can I find a mileage template to download???? Landis Excel Discussion (Misc queries) 0 December 3rd 04 01:31 AM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"