+ Reply to Thread
Results 1 to 5 of 5

Daily Fuel Level Consumption

  1. #1
    Registered User
    Join Date
    11-16-2015
    Location
    Rugby England
    MS-Off Ver
    2016
    Posts
    8

    Daily Fuel Level Consumption

    Dear all

    I have 3x diesel tanks which fuel our generators. Each tank holds 125000 litres of diesel. The generators run 24 hours a day currently. We take readings from each of the 3 tanks every morning and add them to our spreadsheet. We can work out the fuel consumption over the last 24 hours using simple math. That is the easy bit. It has got complicated however when we fill the tanks with more fuel. This completely screws the usage figure, putting it into minus. We have tried all sorts but cannot figure it out. You smart people have helped me in the past and hopefully can do the same.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,910

    Re: Daily Fuel Level Consumption

    Hi Philip,
    My first impression and reading your formula, all numbers ARE negative, you're subtracting 0 - 8648 = -8648 and you add three minus value together the result stays negative
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    11-16-2015
    Location
    Rugby England
    MS-Off Ver
    2016
    Posts
    8

    Re: Daily Fuel Level Consumption

    You missunderstand.

    if i have a reading of 1000 litres on day one then take a measurement on day 2 and the reading is 500 then the consumption is 500. simple.

    if i have a delivery of 2000 litres AFTER i have taken the reading from day 1 then the reading on day 2 will show 2500 assuming i have used the same amount. however the daily usage with show as -1500 not 500.

    i need a formula that disregards any fuel delivery on the usage column.

    i hope i make sense :-)

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,910

    Re: Daily Fuel Level Consumption

    Honestly? Nope.
    You formula result is negative because you're subtracting a larger number then the input

  5. #5
    Registered User
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    35

    Re: Daily Fuel Level Consumption

    Hi - you still need help on this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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