Spreadsheet: 486328d1477419065-mileage-reimbursement-formulas-not-working-test-with-new-locations
Sheet: Ref-Mileage

Mileage Chart | Amityville | Bay Shore 180 | Bay Shore 375 | Hauppauge (LIVM / Middle Country Management) | Brentwood | Hauppauge 110 Marcus Blvd | [NAME] 281 Main | Port Jefferson | Sayville | West Islip | Deer Park | Garden City | Hempstead | Holbrook | Riverhead | Smithtown | Southampton | Southold | Huntington 148 E Main | Little Neck | Huntington Park Avenue | Manhattan E. 27th Street | Rockville Center | Patchogue | Other (Please explain thoroughly in the next column)
Amityville |  | 11.8 | 11.4 | 17 | 13.9 | 16.6 | 17.1 | 33 | 19.4 | 8.9 | 9 | 16 | 15 | 25 | 45 | 23 | 59 | 62 | 14 | 23 | 16 | 39 | 16 | 26
Bay Shore 180 | 11.8 |  | 0.4 | 6.7 | 4.6 | 6.5 | 18 | 23.7 | 9.6 | 3.6 | 6 | 25 | 24 | 13 | 36 | 16 | 49 | 57 | 18 | 33 | 17 | 49 | 35 | 15
Bay Shore 375 | 11.4 | 0.4 |  | 6.2 | 4.3 | 6.2 | 18.5 | 23.3 | 9.6 | 4 | 9 | 26 | 26 | 13 | 35 | 12 | 49 | 57 | 19 | 34 | 16 | 42 | 26 | 16
Hauppauge (LIVM / Middle Country Management) | 17 | 6.7 | 6.2 |  | 3.1 | 1.8 | 11 | 20.2 | 12.8 | 9.9 | 7 | 25 | 26 | 10 | 32 | 9 | 50 | 52 | 11 | 27 | 10 | 26 | 27 | 19
Brentwood | 13.9 | 4.6 | 4.3 | 3.1 |  | 2.5 | 13.1 | 18.8 | 11.3 | 7.6 | 5 | 25 | 26 | 11 | 33 | 8 | 51 | 52 | 13 | 28 | 11 | 42 | 26 | 17
Hauppauge 110 Marcus Blvd | 16.6 | 6.5 | 6.2 | 1.8 | 2.5 |  | 12.4 | 14.2 | 13.4 | 11 | 7 | 24 | 25 | 9 | 32 | 6 | 49 | 51 | 12 | 27 | 10 | 42 | 29 | 18
[NAME] 281 Main | 17.1 | 18 | 18.5 | 11 | 13.1 | 12.4 |  | 25.2 | 23.8 | 18.7 | 10 | 18 | 19 | 21 | 43 | 17 | 61 | 63 | 1 | 20 | 2 | 35 | 27 | 31
Port Jefferson | 33 | 23.7 | 23.3 | 20.2 | 18.8 | 14.2 | 25.2 |  | 16 | 27.5 | 27 | 39 | 40 | 11 | 19 | 10 | 45 | 37 | 25 | 46 | 23 | 60 | 47 | 16
Sayville | 19.4 | 9.6 | 9.6 | 12.8 | 11.3 | 13.4 | 23.8 | 16 |  | 15 | 17 | 38 | 34 | 6 | 28 | 13 | 42 | 49 | 26 | 41 | 24 | 54 | 35 | 8
West Islip | 8.9 | 3.6 | 4 | 9.9 | 7.6 | 11 | 18.7 | 27.5 | 15 |  | 6 | 33 | 32 | 18 | 40 | 17 | 53 | 62 | 19 | 34 | 16 | 48 | 27 | 20
Deer Park | 9 | 6 | 9 | 7 | 5 | 7 | 10 | 27 | 17 | 6 |  | 21 | 20 | 16 | 39 | 14 | 56 | 58 | 10 | 24 | 8 | 39 | 31 | 21
Garden City | 16 | 25 | 26 | 25 | 25 | 24 | 18 | 39 | 38 | 33 | 21 |  | 0.8 | 33 | 55 | 30 | 72 | 74 | 19 | 8 | 23 | 26 | 5 | 40
Hempstead | 15 | 24 | 26 | 26 | 26 | 25 | 19 | 40 | 34 | 32 | 20 | 0.8 |  | 33 | 56 | 31 | 72 | 75 | 20 | 7 | 25 | 27 | 4 | 40
Holbrook | 25 | 13 | 13 | 10 | 11 | 9 | 21 | 11 | 6 | 18 | 16 | 33 | 33 |  | 23 | 9.1 | 40 | 42 | 20 | 37 | 19 | 50 | 37 | 7
Riverhead | 45 | 36 | 35 | 32 | 33 | 32 | 43 | 19 | 28 | 40 | 39 | 55 | 56 | 23 |  | 32 | 21 | 20 | 45 | 58 | 41 | 73 | 60 | 19
Smithtown | 23 | 16 | 12 | 9 | 8 | 6 | 17 | 10 | 13 | 17 | 14 | 30 | 31 | 9.1 | 32 |  | 47 | 49 | 15 | 33 | 15 | 48 | 35 | 18
Southampton | 59 | 49 | 49 | 50 | 51 | 49 | 61 | 45 | 42 | 53 | 56 | 72 | 72 | 40 | 21 | 47 |  | 34 | 60 | 75 | 58 | 90 | 74 | 34
Southold | 62 | 57 | 57 | 52 | 52 | 51 | 63 | 37 | 49 | 62 | 58 | 74 | 75 | 42 | 20 | 49 | 34 |  | 61 | 80 | 60 | 92 | 79 | 42
Huntington 148 E Main | 14 | 18 | 19 | 11 | 13 | 12 | 1 | 25 | 26 | 19 | 10 | 19 | 20 | 20 | 45 | 15 | 60 | 61 |  | 21 | 2 | 37 | 35 | 18
Little Neck | 23 | 33 | 34 | 27 | 28 | 27 | 20 | 46 | 41 | 34 | 24 | 8 | 7 | 37 | 58 | 33 | 70 | 80 | 21 |  | 21 | 15 | 15 | 45
Huntington Park Ave | 16 | 17 | 16 | 10 | 11 | 10 | 2 | 23 | 24 | 16 | 8 | 23 | 25 | 19 | 41 | 15 | 58 | 60 | 2 | 21 |  | 36 | 25 | 30
Manhattan E. 27th Street | 39 | 49 | 42 | 46 | 42 | 42 | 35 | 60 | 54 | 48 | 39 | 26 | 27 | 50 | 73 | 48 | 90 | 92 | 37 | 15 | 36 |  | 27 | 60
Rockville Center | 16 | 35 | 26 | 27 | 26 | 29 | 27 | 47 | 35 | 27 | 31 | 5 | 4 | 37 | 60 | 35 | 74 | 79 | 35 | 15 | 25 | 27 |  | 41
Patchoque | 26 | 15 | 16 | 19 | 17 | 18 | 31 | 16 | 8 | 20 | 21 | 40 | 40 | 7 | 19 | 18 | 34 | 42 | 18 | 45 | 30 | 60 | 41
Other (Please explain thoroughly in the next column)