+ Reply to Thread
Results 1 to 4 of 4

Fuel Consumption Calculator

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    4

    Fuel Consumption Calculator

    Dear all,
    i want to make calculator for calculating fuel consumption on the selected parameter like model, capacity (sheet attached).
    Pls. help me out with formulas required for the same.
    Early response will be highly obliged.

    Regards,
    Aman
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Fuel Consumption Calculator

    Unless I have misunderstood your request, your data are rather badly organised. What is the expected answer if I select the following:

    A CUM30
    B 125 KVA
    C Backhoe Loader
    D 0.5

    This is an impossible combination, isn't it?? Can you/I rearrange it to allow only POSSIBLE combinations....
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    07-31-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    4

    Re: Fuel Consumption Calculator

    Sir,
    The combination as follows:
    For selected model: 25% of capacity utilization of cp30: fuel consumption will be calculated as 25% of selected DG fuel consumption * 25% of selected loader fuel consumption.

    Rest u can rearrange the same for possible combinations.

  4. #4
    Registered User
    Join Date
    07-31-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    4

    Re: Fuel Consumption Calculator

    Sir,
    As advised, i have rearrange the same for possible combinations.
    For e.g MA20 Batching Plant is run with either 75 or 125 kva and with Backhoe or Wheel Loader.
    so for combination like MA20 runs with 75kva & backhoe with capacity utilization of 25%.
    ltr/hr shall be sum of 25% of fuel consumption of both backhoe & DG 75 kva: (4.4+2.0).
    ltr/*** shall be division of total fuel consumption/ (25% of capacity utilization of MA20): (4.4+2.0)/5
    Revised sheet is attached for your ready reference.

    Regards,
    Attached Files Attached Files
    Last edited by aman1561; 09-29-2015 at 03:02 AM. Reason: spell mistake

+ 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. Fuel Consumption
    By josephgeoffreymark in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-26-2014, 12:53 PM
  2. Fuel Consumption
    By mroyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2014, 10:57 AM
  3. Fuel Consumption
    By Puerto in forum Excel General
    Replies: 4
    Last Post: 04-17-2014, 08:22 AM
  4. Fuel consumption with 5 engine.
    By einar.a.petersen in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 03-21-2014, 12:25 PM
  5. Fuel Consumption Calc
    By colinface in forum Excel General
    Replies: 7
    Last Post: 04-26-2009, 01:50 AM
  6. [SOLVED] Fuel Consumption Figures
    By Santa-D in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2006, 03:20 AM
  7. Fuel Consumption Problem
    By Rusty in forum Excel General
    Replies: 16
    Last Post: 06-25-2006, 11:15 PM

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