ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Instructions:
2
1. Complete the configuration items below by entering information in the "B" column.
3
2. By default the spreadsheet is configured to start with the year 2016. If you wish to add more years (before or after) do the following:
4
a. Right click on the tab/sheet called "Blank" and create a copy / duplicate.
5
b. Rename the copy to the year - example "2017" . Do NOT put additional names or spaces in the sheet/tab name - just the year number.
6
c. In "Configuration Item #6" below - enter the years / sheet names (which should be a year number) separated by semicolon. Put them in numerical order.
7
d. Select the newly created spreadsheet for the year you just entered, go to Row 1 and edit the appropriate year number in the title.
8
9
10
Notes & Tips:
11
1. It is much easier to do the setup / configuration on a PC/Mac browser. However once configured - adding data can easily be done via a mobile device.
12
2. The sheets/tabs can be in any order. I like to place the current year as the first tab making editting on a smartphone easier and faster at the pump.
13
3. Do not delete this "Setup" sheet - the spreadsheet will cease to function correctly.
14
4. Do not enter data into the "Blank" sheet - it should only be used as a template for making new tabs/sheets for new years.
15
16
17
Spreadsheet Configuration
18
Input response in column "B"
19
Configuration ItemUser InputNotes & Information
20
1. Name:Example: John Doe
21
2. Vehicle Year:Example: 2017
22
3. Vehicle Make:Example: Ford
23
4. Vehicle Model:Example: F-350
24
5. Avatar Image URL: (optional)URL to a small avatar photo or picture. If you are a Ford FTE Forum member, I suggest using the Avatar image from your profile.
25
6. Yearly Sheet/Tab Names - separate with semicolon ";":
No spaces - just a semicolon between the tab names that hold the raw data. Example: 2015;2016
26
27
28
29
Protected Calculations | Do NOT Modify
30
#VALUE!
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100