how to calculate fuel consumption per km in excel

The Litres per 100km calculator enables you to quickly convert to the standard litres per 100km given a distance and the amount of petrol used for the distance. Can you please explain if I put the time in time format like 11:35 then what I have to do to calculate. as 11.35 is not the proper time format and... The formula column, which needs to calcualate automatically the fuel consumption/100 kms whenever there are new entries in columns 2 and 3 as shown above. Therefore, they do not know how much their car consumes gasoline or diesel. This information is not easy to provide: There is a lot of variable to consider… that we don’t know about with your question. The 320 DL have a 6.4... Cell B7: total time: 2:00 formula in cell: =TEXT (B6-B5,"h:mm") Cell B8: total batches processed: 22 (this is entered manually) Cell B9: batches per hour: formula in cell: =B8/TEXT (B7,"h") as long as I have this formula in cell B9 the answer comes out correct which should be 11 per hour. distance 200 km; fuel volume 20 liter - which indicates a fuel consumption … You can print out the template and start maintaining a record for your vehicle. Fuel / gas efficiency can mean the output one gets for a unit amount of gas input such as " miles per gallon " or " liters per 100 kilometers " for an car / SUV (sometimes called fuel economy ). So this is the formula –> Liters consumed ⁄ Kms traveled x 100 Below the chart,check "MPG" if your car is in Mile and "KPG" if your car is in Kilometer. If 500 divided by 40, then we get a gas mileage of 1 kilometer. 4. To use the fuel levy figure in the truck cost calculator: Set the current fuel price to today's cost. If 500 divided by 40, then we get the consumption of gasoline for 1 kilometer. Regards Howard Mileage also can be set with miles or kilometers. Do not confused Fuel Consumption (FC) with Fuel Economy/Efficiency (FE), they … 300-hp Gasoline Engine Example For example, if you drove 335 miles before refueling, and you filled your car up with 12 gallons of gas, your fuel consumption was 27.9 miles per gallon, or mpg (335 miles / 12 gallon = 27.9 mpg). Fuel economy - the combined rating expressed in miles per imperial gallon (mi/gal) 4. Formulae used for conversion and calculation of fuel consumption: Divide the distance by the litres used to get the km/litre Convert the km/litre to L/100 km i.e. Annual fuel cost - an estimate based on the combined fuel consumption rating, 20,000 km driven and the fuel price indicated 5. Car fuel usage. Countries that use the metric system, such as South Africa, calculate fuel consumption in terms of number of litres used over 100 kilometres (litres/100km). Computing the Fuel Consumption of your Vehicle This is a fairly straightforward approach. With the fluctuations in the fuel price it would be easier to control something like this in Excel I am not sure how to set this up. Average Fuel Consumption Summary. Many car owners do not know how to calculate fuel consumption per 100 km. 300-hp Diesel Engine Example GPH = (0.4 x 300)/ 7.2 = 105/7.2 = 16.6 GPH. Let’s make some assumptions: The efficiency of the diesel engine driving your generator is 35%; the energy of a gallon of diesel fuel is 138000BTUs... A little notebook to note your gallons purchased at each fill-up and the miles traversed since the last fill-up is all you need. In order to calculate the amount of fuel for a given trip using our fuel cost calculator or otherwise, you need to know the total distance you will be covering and the expected average fuel consumption of your vehicle. The calculator automatically counts how many kilometers or miles you ride per one unit of fuel (per one litre or per one gallon). You can fill in a cost of fuel as complementary information and the calculator automatically calculate a cost per one kilometer of distance traveled. The following sample online Fuel Consumption Excel Template will present that. Nu-merical results are visualized, explained, and discussed. • a) Definition Fuel Consumption (FC) is the measurement of fuel usage of a car over the distance covered by that car or in short; The amount of fuel used per distance. fuel consumption in kilometres per litre since last full tank (easier when working how far you go per tank) l/100km: fuel consumption in metric units of litres per 100 km (since last full tank) mpg: fuel consumption in imperial miles per gallon (since last full tank) $ since full: dollar cost of fuel purchased since last full tank: cent/km: cents per km for travel since last full tank: lt litres And then write down the miles or kilometers in column B that your car has done. It is the ratio of distance units per unit amount of input fuel (gasoline, diesel, petrol etc.). Cost can be set in your own currency since it has no direct relation with written formulas. This fuel consumption calculator is an excel template to calculate average cost and mileage per liter over specific period of time. The Petrol consumption calculator enables you to quickly calculate petrol cost based on the given distance and the amount of petrol consumed for that distance. At longer range, where payload reduction becomes necessary, fuel consumption increases significantly. This means that for 500 kilometers, 40 liters of gasoline is spent. In other words: Divide the total distance (km) by 100. Example: Suppose your car uses 8 liters of fuel per 100 kilometers. fuel consumption ratings in litres per 100 kilometres (L/100 km). Calculating a vehicle’s fuel consumption is not difficult. With the help of this Microsoft Excel Formula you can Calculate Fuel Consumption. craft's fuel consumption per passenger and 100 flown kilometers decreases rapidly with range, until a near constant level is reached around the aircraft’s average range. A good way to determine the distance is to set your trip meter back to zero when you fill up your tank. This will make the log a convenient size and just the right thickness to allow you to keep it in your car and write down the date, odometer reading, amount of fuel put in, and the $ cost. Works for both miles per gallon (MPG) or kilometers per liter (km/L). Calculate gas mileage and track it over time. What I am looking for is a mileage calculator set up in Excel that will calculate what is a costing per mile of fuel used. multiply km/litre by 2.825 Fuel Needed & Fuel Cost Calculations. 3. In the example shown, the formulas in E5 and F5 are: = [ @ Mileage] - SUM(C4) // E5 calculate mileage = [ @ Distance] / [ @ Gallons] // F5 calculate mpg These formulas use the structured references available in Excel … You get the liters and you divide it by the kms you’ve driven and then you multiply it by 100. This fuel consumption calculator is an excel template to calculate average cost and mileage per liter over specific period of time. Cost can be set in your own currency since it has no direct relation with written formulas. Normally to calculate the fuel consumption/100 kms is: x= litres x 100 kms / kms done. per HP .40 lb. NOTE: Driver Wage Update to allow a DAILY rate. The most accurate way is to tee into the fuel supply lines. Most diesels run a bypass line and a suction line to the tank. Both lines need to be us... To successfully calculate your fuel consumption, you are to divide your total miles traveled by your fuel usage, i.e the amount of fuel it took to refill your tank again. Fuel Consumption - mpg ; Fuel Consumption Chart. Yes miles/gallon Total distance Total fuel volume Total spent Average consumption Minumum consumption Maximum consumption Average km cost Minumum km cost Maximum km cost Total refills done Considered period days Fuel consumption calculator From there, Excel provides a simple spreadsheet solution for the calculation. To calculate gas (MPG) based on odometer readings you can build a table with a few simple formulas. Advertisement. You just have to replace those words in your own terms. This Vehicle Log Book for Excel in particular can help you calculate the various expenses that are part of owning a vehicle. Mass Air Flow - The mass of Air in grams per second consumed. 1. 2. If you measured in kilometers and liters, you should instead divide fuel used by kilometers traveled and multiply the result by 100 to get "liters per 100 kilometers". Whenever you re-fuel, take an extra minute to jot down your miles and how much fuel you've added. In this case, there will be 0.08 liters per kilometer. RESULTS reflect the "Current Fuel Price". First, you need to write the date in column A in the Excel sheet, as shown in the picture below. This fuel consumption calculator is an excel template to calculate average cost and mileage per liter over specific period of time. Also, based on the consumption you can calculate the petrol cost per kilometer using the fuel cost per km … Petrol 93 Petrol 95 Diesel 50ppm Diesel 500ppm. You’d need to know the prime mover’s fuel consumption-to-horsepower output as well as the Generator’s working output—not the rated output, but how... To estimate the fuel cost for a trip you need the trip distance, cost of fuel per litre, and the vehicle’s average fuel consumption. Distance: Enter the distance. How can I calculate the fuel consumption per hour of my generator set on average load? You can measure it just by measuring the actual fuel used. T... The units of fuel consumption are liters per 100 kilometers, abbreviated L/100km. You can calculate mileage and fuel expenses with the Vehicle Log Book for Excel. But we need to know how to calculate fuel consumption per 100 km, which means that … Simply note down the distance travelled since the last top-up and then take a note of how much fuel it consumed to travel that distance, then divide the litres used by the kilometres travelled and multiply by 100 to calculate consumption in litres/100km. The SI (metric) standard method to calculate the petrol cost is liters per 100 km. It works the same way for cars, trucks, buses, vans, SUVs, and even boats and planes. That’s why driving in a city will always push your truck to use more fuel than on a highway. This log can also provide important information to your car mechanic during the vehicle’s servicing. Fuel consumption log templates can be easily found on the internet. The calculator automatically counts how many kilometers or miles you ride per one unit of fuel (per one litre or per one gallon). Mileage also can be set with miles or kilometers. If C is the fuel consumption, then the cost of gas is given by the formula Cost = DPC/100. Thanks for the reply. If you want to watershed your tasks by enough time of the day, type of task, or its goal, get ahead. Car / SUV fuel efficiency can be calculated in either l/100 km or MPG (Litres per 100 km). But we need to know how to calculate fuel consumption per 100 km, which means that the resulting value needs to be multiplied by 100. The "Base Rate Fuel Price" in Step 9 calculates the fuel levy as if the current fuel price was the base price. Measure by kilometers. Now the problem is that we don't know the power factor so the left two columns contain the fuel consumption in millilitres per hour per kilowatt hour ( ml kWhr-1) and litres per day ( l day-1) for a power factor of 1.00.