| A | B | |
|---|---|---|
1 | Directions on how to use the Mileage Tracker Spreadsheet | |
2 | ||
3 | Step 1) | Go to the tabs at the bottom of this page and find the DATA tab. |
4 | Note: Only edit the cells with this YELLOW background. | |
5 | ||
6 | Step 2) | In the DATA tab, replace the Location Names and Addresses that you will use. |
7 | NOTE: Type over the existing names and addresses rather than deleting them. | |
8 | ||
9 | Step 3) | Type in your name. |
10 | ||
11 | Step 4) | Type in the number of miles you want subtracted each day for your commute. |
12 | ||
13 | Step 5) | Click Form > Edit Form |
14 | Enter the Location Names EXACTLY as you have typed them in the Travelling To and Travelling From fields. | |
15 | ||
16 | Step 6) | Click Form > Go to live form. |
17 | The date must be in this FORMAT: mm/dd/yy | |
18 | Select a Location Name from Travelling To and Travelling From. | |
19 | Click Submit. | |
20 | ||
21 | Step 7) | Go to the REPORT tab at the bottom to print out the results. |
22 | Note: In the Report tab, Double-Click the date to pull up a calendar. | |
23 | ||
24 | Optional | Copy the live form URL and paste it at http://goo.gl or the URL shortener of your choice to easily use on your mobile device. |
25 | ||