The number of miles a vehicle can travel using a certain amount of gas or fuel is known as gas mileage. A vehicle user might want to keep track of the vehicle running costs that he is spending. For that, he will need to know the mileage of each day of his vehicle. In this article, we will walk you through six easy steps to create a gas mileage calculator in Excel. Here’s an overview of the gas mileage calculator we have prepared for this article.
Download Practice Workbook
Download this practice workbook to exercise while reading this article.
Step-by-Step Procedures to Create Gas Mileage Calculator in Excel
In this article, we will demonstrate six steps to create a gas mileage calculator in Excel. The steps are described in detail with proper illustrations in the following section.
Step 1: Insert Date and Odometer Reading
In the first step, we will need the odometer reading from a vehicle. We will use this reading as input.
- First of all, Insert two columns and name them Date and Odometer Reading.
- Then write the dates and odometer reading of each date as input in the columns.
Read More: How to Make Vehicle Life Cycle Cost Analysis Spreadsheet in Excel
Step 2: Calculate the Distance Traveled
We will now calculate the distance traveled by the vehicle on each date.
- First, add a column named Distance Traveled.
- Then select cell D6 and write down the following formula.
=C6-C5
- Afterward, press Enter to get the distance traveled on 01-12-2022.
- After that, AutoFill this formula to the rest of the cells of column D.
- Hence, you will get the value of distance traveled for all 7 days.
Step 3: Insert Fuel Consumed
In this step, we will need the amount of fuel consumed on each date.
- First, insert a column and name it Fuel Consumed.
- Then input consumed fuel in gallons for each date.
Read More: How to Make Daily Vehicle Mileage and Fuel Report in Excel
Step 4: Determine Gas Mileage
In this step, we will determine gas mileage for all 7 days in the Mileage column.
- First of all, select cell F6 and type the following formula.
=D6/E6
- Then Hit Enter.
- Finally, AutoFill this formula and you will have the Mileage for all the dates.
Read More: How to Calculate Mileage Reimbursement in Excel (Step-by-Step Guide)
Step 5: Calculate Cost Per Mile
Now we will calculate the cost per mile driven by the vehicle. For that, we need the value of Fuel Cost per Gallon.
- First of all, insert the value of Fuel Cost per Gallon.
- Next, select cell G6 and write the formula given below, and press Enter.
=E6*$D$14/D6
- Then AutoFill this formula to the rest of column G to determine the Cost per Mile of each date.
Read More: How to Calculate Mileage in Excel (Step-by-Step Guide)
Step 6: Compute Total Cost
In the final step, we will calculate the total cost for the distance traveled on each day.
- First, select cell H6 and type the following formula.
=D6*G6
- Further, hit the Enter button on your keyboard.
- Finally, AutoFill this formula to the rest of the cells and you will get the total vehicle running cost for all 7 days.
- Don’t forget to give proper cell references or you won’t get your desired result.
- You can change the units of distance and fuel as per your need.
Conclusion
Thanks for making it this far. I hope you find this article useful. Now you know six easy steps to create a gas mileage calculator in Excel. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.