Description
This excel template created for getting estimation of travel budget expenses. In this excel estimating template you can estimate and calculate fuel expenses for travel by own vehicle, Calculation of distance by road trip. Gas fuel estimator for trip, Petrol fuel estimator, Diesel fuel estimator, Calculation of budget expenses trip by flight, Estimation of travel expenses in excel by train, This excel template is very easy to use for getting estimation of budget expenses travel by bus. In this travel planning spreadsheet you can plane and keep a record of your travel history for long time and this estimator template sheet will help you to choose a best way and cheap cost budget expenses plan.
How to use this excel template?
Note! Which column you need to edit or delete?
First of all before using this template you need to learn that where formulas are applied. If you edit or delete these columns then formula will not work automatic calculation.
So, Highlighted columns with yellow colour where you can edit or fill your data.
1st Column of (Date)
1st column is about date. If you want plan or keeping a travel record of trip or tour you need to fill this column with planning date when you travel.
2nd Column of (Route Description)
In this column you need to write a route plan where you want to travel or tour.
3rd Column of (Enter Distance)
In this column you need to enter your route distance in Kilometer where you plan to travel.
4th Column of (Enter Average of KM per Liter)
In this column you need to enter running average of vehicle travel in 1 liter kilometer. For example a car travel 90 Kilometer and fuel consumed 5 Liters. So, its average comes to 18 Kilometer per Liter. Formula in this column used as {Total Distance / Average running per Liter = Total Fuel Required} (90/18= 5 Liter).
5th Column of (Fuel Required Liter)
Do not edit or delete this column because formula applied for calculation of fuel requirement.
0 Comments