Gas Mileage Spreadsheet

Making a spreadsheet to keep track of your vehicle's gas mileage in Google Spreadsheets

---

Closed Caption:

hello today we'll be looking at how to
make a spreadsheet to track
your gas mileage for your giclee start
by opening
a new spreadsheet in Google Spreadsheets
in cell a one
enter the text overall mileage islet
cells
a 1-3-1 and click merge cells
how it all the cells in the entire
spreadsheet by pressure control plus
a for Windows machines or command a
from Max and click center alignment
in cell a2 enter text date in cell
be too and to the text miles in cell c2
and to the text gale
in cell d2 and to the techs mpg
in cell e2 enter the text location
highlight cells
a one through e2
at all borders to the Highland it sells
highly colony
and add a border to the right hand side
and so f2
enter the text notes in Celje 1&2 the
text
if city islet cells g1 through g1
and more quick merge cells and sell k1
enter if highway islet cells K 12 and
one and click
parcells capita cells with the text
date miles gal mpg
and paste them into the cells g2
HQ I to NJ to repeat Purcell's
k to you l2 m2 and into
I'll accounts a G&K
and click Format and that set format to
be
a date set the formats for counts be
see d H hi J
L and and n to be a number format
in cell d3 and to the formula
equals if C three equal 0 empty quotes
b3 divided by c3
highlights ld3 and drank the corner down
to copy the formula to the next
100 rose
and sold g3 into the formula equals if
e3 equals City 83
empty quotes
in cell h3 enter the formula equals
if eat regal City b3
empty quotes
and so i three enter the formula equals
if
e3 equal City c3
empty group
and sell g3 and to the formula equals if
e3 equal City d3 anti quotes
in cell k3 enter the formula equals if
e3 equals highway
a3 anti quotes in cell
l3 and to the formula equals if e3
equals highway
b3 empty quotes in cell
m3 and to the formula equals if e3
equals highway
c3 empty quotes in cell n3 n2 the
formula
equals if e3 Eagles highway d3
and quotes
highlight cells g3 2&3 Android the
corner down to copy the formula to the
next 100 rose
highly columns G through n change the
font to these columns
size six
trade com dividers to minimize the with
but these cops
do not use the hike function
Intel p4 enter the text averages islet
cells
p4 and q4 and merge them
in cell p5 and to the text average
mpg in cell 6
into the text average city its LP seven
and to the text average highway
in cell q5 enter the text equals
some see want to see 999
equals 0 empty quotes some
be one to be 999 divided by some
see want to see night night in Syracuse
6 and to the text Eagles if some
I want I 999 equal 0
empty quotes some h1 H 999 divided by
some
I want i nite nite nite in cell q7
and to the text if some am 12 and
999 equal 0 empty quotes some
l1 tell 999 divided by some M-one 2m
nite nite nite
highlight column D
and sells a one f2 p for
q5 q6 q7
and click bolt
islet cells p4 through q7 at all borders
to highlight it sells
Cetaphil cleanser for the cells like a
light grey
at a few Rosa te stated your spreadsheet
this allows you to make the required
charts
select cells a 2-2 a6
and d2 2d6 and click insert
than chart 10 charts then scatter
and click the upper church
click Customize
changed church title two overall mileage
set the legend to none
set the trend line to linear
click Insert
the church to an open space on the
spreadsheet make two copies
%uh just checked
right click on one
for copies and click advanced at it
quick start
in the day to sell change a two-day 62 G
two
2g 999 and change d2d 62
J to DJ 99 under customize
change the title to city much quick
update
I clicked the other copy church and
click Advanced at
good start
and change today to sell from a two-day
62
etude k 999 and change di tutti 62
and 22 n nite nite nite
under customize change the tail to
highway mileage
click Update right click on the first
church
and select arrested change the data
from a 2-2 a 6-2 a two-day 999
nd 2d6 to d2d 99
congratulations you successfully
completed spreadsheet
to use it enter the required data in the
fields
as you did with the testator the
averages and church will display
your gas mileage we hope that this has
many useful tool to help you keep track
but the mileage
and help with your vehicle thank you for
watching