+ Reply to Thread
Results 1 to 2 of 2

Fuel Burn Adjustment Formula

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Fuel Burn Adjustment Formula

    All,

    I'm having the following difficulty (see attached file):

    - Say I have five locations.
    - Each location has a distance requirement that i'd need to travel with my car (Location 1 = 100 miles, Location 2 = 30 miles, etc.).
    - My car has a MPG and a fuel capacity of x.
    - I can refuel at any location as many times as I want (topping off my fuel tank)
    - In some instances, due to my fuel burn and fuel capacity, I run out of gas at some locations, but not others.

    I'd like to write a formula that will adjust/reduce the distance requirement at each location so I don't run out of gas anywhere. The formula should update based upon where I choose to refuel.

    The attached workbook should give more insight into this issue.

    Thanks to all!

    Best,
    Chris
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor hrlngrv's Avatar
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    873

    Re: Fuel Burn Adjustment Formula

    If your car has a fuel capacity of x and MPG of y, then it has a max range of z = x * y. Any distance beyond that range is infeasible.

    Given your vehicle's actual fuel level at a starting point, that fuel level * y gives the max range you could travel to the 1st location. If you could fill up at that location, your max range would be z. If you can refuel at your last location to go home but can't refuel at home the next workday, then your 1st location that day would need to be within your feasible range.

    If you can refuel at any location other than home, then feasible distances between any location and another is z. It'd seem to be only getting home from your last location one day then to your first location the next day should in total be at most z. As long as any locations are within z of any other locations, and you can refuel at each location, there should be no problems getting from any location to another.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 06-18-2015, 02:09 PM
  2. Fuel Burn Formula
    By guitarist00 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2014, 04:46 AM
  3. [SOLVED] Calculating complex Fuel Cost based on Individual Name, Engine CC, Fuel Type and Date.
    By shadypops in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 01:38 PM
  4. [SOLVED] Fuel type fill base on kind of fuel.
    By yukioh in forum Excel General
    Replies: 2
    Last Post: 01-18-2013, 02:12 AM
  5. [SOLVED] How to calculate fuel burn in litres per H:MM
    By nje in forum Excel General
    Replies: 3
    Last Post: 09-17-2012, 07:51 AM
  6. fuel formula
    By bhopkins in forum Excel General
    Replies: 2
    Last Post: 12-30-2011, 06:38 PM
  7. Fuel Formula per day
    By Ancie Saesaria in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2008, 08:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1