If ypu want to estimate the energy consumption per day, you have to use loading factor or utilization factor generaly = 0.80. Either it is for your own private purposes or company purposes. 0.9. I never miss watching NBA finals, Tennis Grand Slam Finals, Formula 1, MotoGP, football tournaments and competitions. This template provides table that you need to fill per every time you refuel your car. Generator Sizing and Fuel Consumption. Hence specfic fuel consumption will be 4.2units/kg of fuel. (long term) litres of fuel purchased since first record ( I usually hide this column) lt av. Excel Pro and a sport enthusiast. thank you, How To Use The Fuel Consumption Calculator, Car Fuel Consumption Calculator Initial Data. If you need more criteria to be calculated you can use my Car Fleet Management template. Cost can be set in your own currency since it has no direct relation with written formulas. This works out about 18 gallons per 24 hours or about 180 gallons for 10 days. Diesel Generator fuel consumption Calculation formula How to calculate DG Cost per KWH ? It should be easy if required data can be pulled exactly. Warranty: 3 years. This chart provides approximate fuel consumption of diesel generators based on the size of the generator and the load at which the generator is operating. Consumption (km/L) Consumption x Distance Preço vs Tempo Day Price ($/L) Fuel price x Time Custo x Distancia Total distance (km) Cost of the kilometer ($/km) km Cost x Distance Instructions Every time you fill the fuel tank, take note of the mileage at the odometer as well as the volume of fuel and the price of the fuel. There are three columns in this part where you can see its calculated numbers (based on refueling information). If a generator like this has a 4-gallon capacity, a gallon of fuel will last for 3 hours. You can ask your car for tuning up or let the technician to check your fuel system. A diesel engine, including a generator, is optimised to run at 40% load or higher. On 1/2 load the generator will take 2 ltr/hour. P = active electric power in output of the diesel engine in kW. You can ESTIMATE the fuel consumption by multiplying the energy out (kWh) by 0.27 to get litres consumed. I put several dummy data to guide you on how to fill it properly. They are the average for all refueling trip, the average for the first and the last four refueling trip. Why not based on start and end trip? You must record required data every time you refuels your car. Remember that refueling can be done after several trips or within one sing but long trip. That’s a lot of gas cans. Please note that these results are intended to be used to estimate how much fuel a generator uses during operation and are not exact metrics due to various factors that can affect the amount of fuel consumed. You can allocate one worksheet for one car. How the Average Fuel Consumption is Calculated ? Our commercial and industrial generator sets come in a range of options to match your power needs, making selecting and installing simple. Considering overall efficiency of 35% it will be 12.01*.35=4.2 units. These initial data are optional and have no effect in written formula. More Features: A maintenance-free alternator having… Remember that you can type required data in cells with white background. However, many users do not know the size and calculation method of diesel generator fuel consumption. approximation of the diesel generator fuel consumption per hour in litres. h = number of hours per day the genset runs. You can do the same if you are managing a number of operational vehicles at your company. I will explain it based on dummy data inside the spreadsheet. Other calculators on this page are for unit conversions and other power related calculations. Jun 9, 2017 - Click to See Full Template Version 10'664 Downloads 14 KB File Size December 13, 2016 Updated 1 Number of comments ★★★★★ ★★★★★ Rating Download this template for free Get support for this template table of content How To Use The Fuel Consumption CalculatorCar Fuel Consumption Calculator Initial DataCar Refueling DataAverage Fuel Consumption Summary This fuel … To find average mileage per liter, you can just put total mileage and then divide it with total fuel consumption between subsequent refueling. There are three big parts in this one worksheet where you need to pay attention. An example is the 8000-watt Generic XC8000E generator with an 8.5-gallon tank rated at 50% for 11 hours and burns a little over ¾ of a gallon per hour. 2. It is the idle condition of the Diesel Generator Set. This chart approximates the fuel consumption of a diesel generator based on the size of the generator and the load at which the generator is operating. All data are informed in mileage and cost per volume (liter). Ckwh = Consumption of fuel per kWh (usual value is between … Mileage also can be set with miles or kilometers. Use your trip odometer to see how many miles you traveled total, then divide this by gallons to get your average fuel consumption. E = active electric energy in output of the diesel engine in kWh. While this is the exact number of miles per gallon during your test period, it is a good estimate for your car's average fuel consumption. You might try to create your own formula and calculate it by yourself. They are not giving you information of your single trip, except you reset the odometer every time you go. This fuel consumption calculator is an excel template to calculate average cost and mileage per liter over specific period of time. Car Model, Number and Department that use it, Maximum Tank Capacity, you can change Liter at the right side of its field to other volume metric unit. or in other words for one unit of electricity generation fuel consumption will be 238 gms. Column B [Engine Run Time (In Hours)] storing values of engine runtime in hours (Y readings) Column C [Diesel Consumption (Ltr/Hour)] using a formula to calculate consumption. Divide total miles by total gallons. To find average mileage per liter, you can just put total mileage and then divide it with total fuel consumption between subsequent refueling. This is important to remember when “running the numbers” on what a new or used generator may cost. if you want adjusted one communicate through the contact bellow. The Fuel Consumption Calculator above approximates the fuel consumption of a diesel generator based on its size and operating load. (Equal Sign A2 Forward Slash Sign B2) =A2/B2 will be a mathematical representation of. No votes so far! The template is prepared with essential formulas that make calculation automatic and accurate for user. The result can be displayed in several ways including averages, statistics, graphics and multiple units. 1.3. Generator Size (kW) 1/4 Load (gal/hr) 1/2 Load (gal/hr) 3/4 Load (gal/hr) Full Load (gal/hr) 20. Nowadays, most of cars are equipped with electronic device that will display its fuel consumption in real time. If the average fuel consumption tends to decrease, you can ground suspected cars and schedule them for repairs. d = number of days the power generator runs. To determine a generator’s rate of fuel consumption, consult its product information. The following calculators are provided to help you determine the size of generator required for your specific application. Then, it is divide by purchased volume from 1st row. By recording all refueling information, you can pull those data every time you need it. Interactive power calculator tools and formulas for diesel generators: kW to kVA, kVA to kW, HP to kVA, kW to HP and calcuating amperes. Date. If the average fuel consumption tends to decrease, you can ground suspected cars and schedule them for repairs. You can enter =A2/B2 in Cell C2 for calculation. Actual usage may vary due to a number of factors. In the first refueling date, it is assumed that the tank has no fuel left. şÿÿÿ b ã d å f ç ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿıÿÿÿ% Be the first to rate this template. The main advantage of this spreadsheet compared to others is the ability to handle partial tank fills. Download this app from Microsoft Store for Windows 10 Mobile, Windows Phone 8.1, Windows Phone 8. If it is a very small diesel (under 10 kW) then maybe closer to 0.3 litres per kWh and if it is a modern, high-speed, diesel over 900 kW then closer to 0.26 litres per kWh. diesel fuel consumption chart This chart approximates the fuel consumption of a diesel generator based on the size of the generator and the load at which the generator is operating at. This fuel consumption calculator spreadsheet is free to be modified for your particular purposes. Typically, this is marked in terms of hours. This is a useful calculator to measure your vehicle condition on particular journey. 2020 - All rights reserved, Fuel consumption spreadsheet is not correct. In the same way a 3500-level truck uses more fuel than a 1500, larger generators consume fuel faster than smaller units. 30% fuel efficiency ratio ). eg : We have an Hyundai loader which refilled on the 02/07/08 200 ltrs (fuel) at … Because the intention is to calculate the average of fuel consumption per car not per trip. From 6 to 14,040 ekW (7.5 to 17,550 kVA) of power potential, our diesel-fueled generator sets are built to world-class standards, for high efficiency, low fuel consumption and global emissions compliance. Get started now! It is a comprehensive solution for all fuel consumption related needs and issues. Aside from the purpose behind making the log, feel free to download the fuel consumption log template which is listed below the content. For example, I have a generator with 10 kVA capacity which consumes the diesel as follows: On 1/4 load the generator will take 1.5 ltr/hour. The second refueling average is calculated by taking odometer data from row 3 and 2 and divide it with volume data from row, and so on. About us • Support • Privacy Policy • Contact, Copyright © The Spreadsheet Page. Diesel Service and Supply. (Accessed 7/17/2019.) l/100km: long term average fuel consumption in litres per 100 km, over period since first record in spreadsheet: last 5 l/100km: short term average fuel consumption in litres per 100km, over period of last 5 refuels. For private or family purposes, you can easily monitor when your car needs to go to auto repair services shop. ! " In general, the fuel consumption of diesel generator sets is related to the following two factors: 1. Some generators can run for 12 hours on a full tank of fuel at 50 percent of the load. For DC we are using Cummins diesel generator, now I need to calculate the generator running hours based on the load. How To Determine Fuel Consumption Using Microsoft Excel Tutorials. =A2/B2. But if you know the power absorbed by the machine driven by the electric motor, then, the utilization factor Ku = Machine power/Nominal motor power. or, 1 kg of Fuel produces 12.01 units of electricity. Then, all calculated values are averaged to get the expected average number. Output: 6500-5500 watts. Download this template for free Get support for this template. https://fwpower.co.uk/ Generator Size Approximate Diesel Fuel Consumption ¼ Load (litres/hr) ½ Load (litres/hr) ¾ Load (litres/hr) … The first refueling average value is calculated by subtracting odometer value from 2nd row with 1st row from refueling table. (n.d.). How do I calculate the fuel consumption per day one of our vehicles? ĞÏࡱá > şÿ ! Approximate Diesel Fuel Consumption Chart. You just have to replace those words in your own terms. See screenshots, read the latest customer reviews, and compare ratings for Fuel Consumption Calculator. They are used to show you the value comparison between the first and the last four refueling trip. Please note this table should only be used as an approximate to give you an indication of fuel usage at various load levels. That's why it is assumed that the tank has zero fuel in the beginning. Fuel tank: 3.8 gallons. You can duplicate the worksheet for other cars, duplicate refueling table formulas for more rows and tweak average fuel consumption formula for other specific measurement. Fuel consumption is the major portion of diesel plant owning and operating cost for power applications, whereas capital cost is the primary concern for backup generators. You might try to create your own formula and calculate it by yourself. As a result, you can track which trip that cause your car to consume more fuel than usual. But, most of them will give you the average consumption based on all taken journey. One quarter load is where a petrol generator has the better fuel efficiency. That’s because the engine has to create enough compression to combust all of the fuel. # $ % &. generator fuel consumption rates, and maximum and minimum boiler consumption rates. Specific consumption varies, but a modern diesel plant will, at its near-optimal 65-70% loading, generate at least 3 kWh per litre (ca. Fuel consumption rate: diesel generators of different brands have different fuel consumption rates and different fuel consumption. 0.6. There are green and red markers at the left of calculated average at the last two columns. This spreadsheet calculates and keep track of the fuel consumption of vehicles.
Letter Of Consent For Child Passport Nigeria, Contours Bitsy Vs Mountain Buggy Nano, Sam Pottorff Twitch, What Can Stress Do To Your Body Physically, Watch Me Ball, Rumchata Limon Price, Cruwear Vs Maxamet, Pokémon Liquid Crystal 2020, Nawat Kulrattanarak Drama List, Netgear C7000 Troubleshooting, What Do Fish Have To Do With Anything Ending,