Ejercicio 2.pdf

Gas Mileage Calculator

© 2007-2018 Vertex42.com

$1,00

19

$0,90

18

$0,80

17

$0,70

16

$0,60

15

$0,50

14

$0,40

13

$0,30

12

$0,20

11

$0,10

10

$3/27/19

3/26/19

3/25/19

3/24/19

3/23/19

3/22/19

[42]

Trip Fuel Cost Estimator $Cost per km $ 18,89 Distance 103,7 Km Cost 1958,893

$Cost per km

20

3/21/19

Mileage

https://www.vertex42.com/ExcelTemplates/mileage-calculator.html

Instructions Refuel Date

Odometer Reading

Km

Gallons (fuel added)

$Cost

MPG (mileage)

$Cost per km

← Change the labels if you want to use km and liters instead of Miles and Gallons

Beginning: 3/21/19

45000 45104

103,7

5,49

$

18,89

18,9

$

0,182

← Enter your beginning odometer reading in cell B24 ← When you re-fuel, enter the Date, Odometer, Gallons, and Cost

3/22/19

45167

63,7

3,37

$

18,89

18,9

$

0,297

← Columns highlighted blue contain formulas

3/23/19

45258

91,0

4,81

$

18,89

18,9

$

0,208

3/24/19

45280

21,6

1,14

$

18,89

18,9

$

0,875

3/25/19

45330

49,8

2,63

$

18,89

18,9

$

0,379

3/26/19

45352

22,6

1,195

$

18,89

18,9

$

0,836

3/27/19

45664

312,0

16,51

$

18,89

18,9

$

0,061