Spreadsheet: 198835d1354906649-keep-portion-of-excel-spreadsheer-on-screen-at-all-times-toll_data_12_7_12-modified-by-tigeravatar-
Sheet: Toll Data

 |  | TOTAL COST: |  | TOTAL RECEIVED: |  | DIFFERENCE:
 |  | E-Z PASS BALANCE:
 |  | [NAME]:
 |  | GOING TO WORK |  |  | GOING HOME (OR TO SCHOOL)
AVG $ | # of TRIPS | LANE | AMOUNT | SILVER | LANE | AMOUNT | SILVER | # of TRIPS | AVG $
 |  | DTW 46 |  |  | 93 34
 |  | PWS 7 |  |  | PWN 10
 |  | 93 33 |  |  | PWN 11
 |  | PWS 6 |  |  | PWN 12
 |  | DTW 45 |  |  | DTE 55
 |  | PWS 5 |  |  | DTE 56
 |  | PWS 3 |  |  | PWN 9
 |  | PWS 4 |  |  | DTE 54
DO NOT USE LANE |  | DTW 44
 |  | To Work Total |  |  | To School/Home Total
 |  | TOTAL |  | SHOULD MATCH 'TOTAL RECEIVED'
 |  | Silver per Trip
LANE NAME | DAY | TIME | COST | AMOUNT RECEIVED | SILVER | ACTUAL DATE
DTW 46 | THURSDAY | 1330 |  |  |  | 2012-11-15 00:00:00
PWS 7 | THURSDAY | 1330 |  |  |  | 2012-11-15 00:00:00
93 33 | THURSDAY | 1330 |  |  |  | 2012-11-15 00:00:00
93 34 | THURSDAY | 1710 | 0.25 | 0.01 |  | 2012-11-15 00:00:00
PWN 10 | THURSDAY | 1710 | 0.7 | 0.5 |  | 2012-11-15 00:00:00
DTW 46 | FRIDAY | 1045 | 0.7 | 0 |  | 2012-11-16 00:00:00
PWS 6 | FRIDAY | 1045 | 0.7 | 0 |  | 2012-11-16 00:00:00
93 33 | FRIDAY | 1045 | 0.25 | 0.1 |  | 2012-11-16 00:00:00
93 34 | FRIDAY | 1705 | 0.25 | 0.03 |  | 2012-11-16 00:00:00
PWN 11 | FRIDAY | 1710 | 0.7 | 0.2 | 1 DIME | 2012-11-16 00:00:00
PWS 6 | MONDAY | 730 | 0.7 | 0 |  | 2012-11-19 00:00:00
93 33 | MONDAY | 730 | 0.25 | 0.02 |  | 2012-11-19 00:00:00
93 34 | MONDAY | 1115 | 0.25 | 0.08 |  | 2012-11-19 00:00:00
PWN 10 | MONDAY | 1115 | 0.7 | 0.45 |  | 2012-11-19 00:00:00
DTE 55 | MONDAY | 1115 | 0.7 | 0 |  | 2012-11-19 00:00:00
DTW 45 | MONDAY | 1330 | 0.7 | 0.27 |  | 2012-11-19 00:00:00
PWS 5 | MONDAY | 1330 | 0.7 | 0 |  | 2012-11-19 00:00:00
93 33 | MONDAY | 1330 | 0.25 | 0.12 |  | 2012-11-19 00:00:00
93 34 | MONDAY | 1710 | 0.25 | 0.38 |  | 2012-11-19 00:00:00
PWN 12 | MONDAY | 1710 | 0.7 | 0 |  | 2012-11-19 00:00:00
PWS 7 | TUESDAY | 1330 | 0.7 | 0 |  | 2012-11-20 00:00:00
93 33 | TUESDAY | 1330 | 0.25 | 0.26 |  | 2012-11-20 00:00:00
93 34 | TUESDAY | 1700 | 0.25 | 0 |  | 2012-11-20 00:00:00
PWN 11 | TUESDAY | 1700 | 0.7 | 0 |  | 2012-11-20 00:00:00
DTE 56 | TUESDAY | 1700 | 0.7 | 0 |  | 2012-11-20 00:00:00
PWS 3 | WEDNESDAY | 810 | 0.7 | 0.15 |  | 2012-11-21 00:00:00
93 33 | WEDNESDAY | 810 | 0.25 | 1.44 |  | 2012-11-21 00:00:00
93 36 | WEDNESDAY | 1615 | 0.25 | 0 |  | 2012-11-21 00:00:00
PWN 9 | WEDNESDAY | 1615 | 0.7 | 0 |  | 2012-11-21 00:00:00
PWS 4 | MONDAY | 810 | 0.7 | 0 |  | 2012-11-26 00:00:00
93 33 | MONDAY | 815 | 0.25 | 0.25 |  | 2012-11-26 00:00:00
93 34 | MONDAY | 1710 | 0.25 | 0.01 |  | 2012-11-26 00:00:00
PWN 12 | MONDAY | 1710 | 0.7 | 0.91 |  | 2012-11-26 00:00:00
PWS 5 | TUESDAY | 1335 | 0.7 | 0.03 |  | 2012-11-27 00:00:00
93 33 | TUESDAY | 1340 | 0.25 | 0.59 |  | 2012-11-27 00:00:00
93 34 | TUESDAY | 1710 | 0.25 | 0.35 |  | 2012-11-27 00:00:00
PWN 12 | TUESDAY | 1715 | 0.7 | 0.79 |  | 2012-11-27 00:00:00
DTW 45 | WEDNESDAY | 1105 | 0.7 | 0 |  | 2012-11-28 00:00:00
PWS 4 | WEDNESDAY | 1110 | 0.7 | 0.1 |  | 2012-11-28 00:00:00
93 33 | WEDNESDAY | 1115 | 0.25 | 0.45 |  | 2012-11-28 00:00:00
93 34 | WEDNESDAY | 1705 | 0.25 | 0 |  | 2012-11-28 00:00:00
PWN 9 | WEDNESDAY | 1710 | 0.7 | 0 |  | 2012-11-28 00:00:00
DTW 45 | THURSDAY | 1330 | 0 | 0.5 |  | 2012-11-29 00:00:00
PWS 7 | THURSDAY | 1335 | 0.7 | 0.75 |  | 2012-11-29 00:00:00
93 33 | THURSDAY | 1340 | 0.25 | 0.94 |  | 2012-11-29 00:00:00
93 34 | THURSDAY | 1655 | 0.25 | 0.01 |  | 2012-11-29 00:00:00
PWN 9 | THURSDAY | 1700 | 0.7 | 0.15 |  | 2012-11-29 00:00:00
DTW 45 | FRIDAY | 945 | 0.7 | 0.06 |  | 2012-11-30 00:00:00
PWS 5 | FRIDAY | 950 | 0.7 | 0 |  | 2012-11-30 00:00:00
93 33 | FRIDAY | 955 | 0.25 | 0.32 |  | 2012-11-30 00:00:00
93 34 | FRIDAY | 1640 | 0.25 | 0.15 |  | 2012-11-30 00:00:00
PWN 11 | FRIDAY | 1645 | 0.7 | 0.77 | 1 QUARTER | 2012-11-30 00:00:00
93 34 | MONDAY | 1715 | 0.25 | 0.05 |  | 2012-12-03 00:00:00
DTW 46 | TUESDAY | 1330 | 0.7 | 0.13 |  | 2012-12-04 00:00:00
93 34 | TUESDAY | 1640 | 0.25 | 0.05 |  | 2012-12-04 00:00:00
PWN 11 | TUESDAY | 1645 | 0.7 | 0 |  | 2012-12-04 00:00:00
DTW 46 | WEDNESDAY | 1100 | 0.7 | 0.11 | 1 DIME | 2012-12-05 00:00:00
PWS 5 | WEDNESDAY | 1105 | 0.7 | 0 |  | 2012-12-05 00:00:00
93 33 | WEDNESDAY | 1105 | 0.25 | 0 |  | 2012-12-05 00:00:00
93 34 | WEDNESDAY | 1650 | 0.25 | 0.09 |  | 2012-12-05 00:00:00
PWN 10 | WEDNESDAY | 1655 | 0.7 | 0 |  | 2012-12-05 00:00:00
PWS 7 | THURSDAY | 1350 | 0.7 | 0.1 |  | 2012-12-06 00:00:00
93 33 | THURSDAY | 1350 | 0.25 | 1.69 |  | 2012-12-06 00:00:00
93 34 | THURSDAY | 1710 | 0.25 | 0.03 |  | 2012-12-06 00:00:00
PWN 12 | THURSDAY | 1710 | 0.7 | 0 |  | 2012-12-06 00:00:00
DTW 46 | FRIDAY | 945 | 0.7 | 0.1 |  | 2012-12-07 00:00:00
PWS 3 | FRIDAY | 950 | 0.7 | 0.25 |  | 2012-12-07 00:00:00
93 33 | FRIDAY | 955 | 0.25 | 1.15 |  | 2012-12-07 00:00:00