Spreadsheet: 178080d1346650386-number-tabulation-change-by-other-cells-contents-kbs-2012_postable
Sheet:  PA  std (2)

 |  |  |  | Fills |  | air | PLAN | April | may | june | july | august | sept | oct | nov
108 |  | launch |  | NEPAAL07 |  |  | 1.08 | 824 | 831 | 846 | 910 | 837 | 835 | 920 | 916
1.2 |  | camden |  | 21 | cherry |  | 0.2 | 0.25 | 0.23 | 0.22 | 0.27 | 0.23 | 0.27 |  | 0.23
1.2 |  | done |  |  |  |  |  | 1.35 | 1 | 0.98 | 0.67 | 0.47 | 1.17 |  | 0.58
1.572 |  | [NAME] |  | 13 | cherry | 2 | 0.62 | 0.52 | 0.58 | 0.85 | 0.58 | 0.65 | 0.52
2.194 |  | done |  |  |  |  | 0.37 | 0.37 | 0.42 | 0.43 | 0.47 | 0.35 | 0.33 |  |  |  | 0.3666666666666666
2.524 |  | dal tile |  | 9 | Green Melon | 1 | 0.55 | 0.63 | 0.53 | 0.45 | 0.52 | 0.5 | 0.57 |  |  |  | 22
3.068000000000001 |  | done |  |  |  |  | 0.24 | 0.22 | 0.23 | 0.25 | 0.32 | 0.23 | 0.3
3.458 |  | teleflex |  | 25 | cherry |  | 0.65 | 0.57 | 0.58 | 0.78 | 0.58 | 0.62 | 0.55
4.11 |  | done |  |  |  |  | 0.42 | 0.45 | 0.53 | 0.42 | 0.55 | 0.52 | 0.52
4.218000000000001 |  | spring city |  | 3 | Green Melon |  | 0.18 | 0.22 | 0.18 | 0.17 | 0.17 | 0.82 | 0.17
4.284000000000001 |  | done |  |  |  |  | 0.11 | 0.1 | 0.08 | 0.1 | 0.1 | 0.13 | 0.1
4.380000000000001 |  | Friendship |  | 10 | Green Melon |  | 0.16 | 0.17 | 0.17 | 0.12 | 0.15 | 0.15 | 0.17
4.56 |  | done |  |  |  |  | 0.3 | 0.23 | 0.32 | 0.48 | 0.32 | 0.28 | 0.27
5.152000000000001 |  | paoli |  | 22 | Green Melon |  | 0.32 | 0.32 | 0.32 | 0.32 | 0.32 | 0.32 | 0.35
5.410000000000001 |  | Done |  |  |  |  | 0.43 | 0.35 | 0.4 | 0.4 | 0.5 | 0.45 | 0.48
5.488 |  | jwpepper |  | 18 | spring |  | 0.13 | 0.13 | 0.15 | 0.1 | 0.13 | 0.13 | 0.08
6.128000000000001 |  | done |  |  |  |  | 0.4 | 0.47 | 0.42 | 0.4 | 0.4 | 0.4 | 0.37
6.128000000000001 |  | [NAME] |  | 0 | Blue Card |  |  |  |  |  | 0.07 | 0.07 | 0.17
6.128000000000001 |  | done |  |  |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 0.07 |  |  |  | Sep Routes
6.128000000000001 |  | lunch |  |  |  |  |  |  |  |  | 0 | 0.08 | 0 |  |  | pa | va
6.128000000000001 |  | done |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | 8.67 | 7 | 15.67
6.128000000000001 |  | exton |  | 11 | cherry | 2 |  | 0.27 | 0.27 | 0.33 | 0.28 | 0.23 | 0.28 |  |  | 163 | 80 | 243
6.128000000000001 |  | Done |  |  |  |  |  | 0.32 | 0.32 | 0.3 | 0.3 | 0.33 | 0.35 |  |  |  |  | 15.50733886407147
6.128000000000001 |  | spitz |  | 12 | Green Melon |  |  | 0.35 | 0.42 | 0.42 | 0.42 | 0.35 | 0.35
6.128000000000001 |  | done |  |  |  |  |  | 0.35 | 0.3 | 0.35 | 0.28 | 0.3 | 0.37 |  |  |  | 2 new route
6.128000000000001 |  | granite run |  | 12 | cherry | 2 |  | 0.3 | 0.3 | 0.38 | 0.35 | 0.25 | 0.37 |  |  | org pa | va split
6.128000000000001 |  | done |  |  |  |  |  | 0.32 | 0.38 | 0.28 | 0.35 | 0.23 | 0.3 |  |  | 6.5 | 9.75 | 16.25
7.008000000000001 |  | home |  |  |  |  | 0.8 | 0.67 | 0.67 | 0.79 | 0.72 | 0.57 | 0.55 |  |  | 104 | 139 | 243
 |  |  |  | NEPAAL07 |  | Time home |  | 621 | 715 |  | 626 | 525 | 545 |  |  |  |  | 14.95384615384615
740 est | http://maps.google.com/maps?saddr=dana+run&daddr=101+newton+ave.+camden+to:39.943627,-75.1066951+to:39.95245,-75.13135+to:PLYMOUTH+MEETING+MALL%09PLYMOUTH+MEETING+to:1010+CANNON+AVE%09LANSDALE+to:40.16758,-75.37284+to:640+N+LEWIS+RD%09LIMERICK+to:Church+S |  |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00
 | http://maps.google.com/maps?saddr=dana+run&daddr=101+newton+ave.+camden+to:39.943627,-75.1066951+to:PLYMOUTH+MEETING+MALL%09PLYMOUTH+MEETING+to:40.1212271,-75.2829123+to:40.140638,-75.271844+to:40.1636181,-75.2591199+to:40.2297609,-75.2771712+to:40.24425, |  |  |  |  |  | PLAN |  | wic |  | Wic
 | Plan fill | Planned hours |  | 156 |  | 7 | 5.88 | 8.929999999999998 | 8.8 | 9.370000000000001 | 8.870000000000001 | 8.710000000000003 | 9.030000000000001
 | 163 | 5.88 | 27.72108843537415 |  |  | drive | 3.61 | 4.399999999999999 | 4.4 | 4.93 | 4.559999999999999 | 4.89 | 4.4
 |  | Plan gross per hour |  |  |  | work | 2.27 | 4.529999999999998 | 4.4 | 4.440000000000001 | 4.310000000000002 | 3.82 | 4.63
 |  | 27.72108843537415 |  |  |  | Rate | 26.33503401360544 | 19.57446808510639 | 19.86363636363636 | 17.35859124866595 | 18.33709131905299 | 18.67393800229621 | 17.89435215946844
 |  |  |  | PA Total
Springtime |  | 18 |  |  |  | 18 | 1.125
Green Melon | 9 | 3 | 10 | 22 | 12 | 56 | 3.5
[NAME] | 21 | 25 | 12 | 13 | 11 | 82 | 5.125
Mandrin |  |  |  |  |  | 0 | 0
total in clicks | Clicks back to minutes |  |  | 7 | air | 156 | 163
1.133333333333334 |  |  | 0 |  | 0
1.333333333333333 |  | 1.2 | 0 |  | 1.2
1.333333333333333 |  | 1.2 | 0 |  | 1.2
1.953333333333334 |  | 1.572 | 0 |  | 1.572
2.323333333333334 |  | 2.194 | 0 |  | 2.194
2.873333333333334 |  | 2.524 | 0 |  | 2.524
3.113333333333334 |  | 3.068000000000001 | 0 |  | 3.068000000000001
3.763333333333334 |  | 3.458 | 0 |  | 3.458
4.183333333333334 |  | 4.11 | 0 |  | 4.11
4.363333333333334 |  | 4.218000000000001 | 0 |  | 4.218000000000001
4.473333333333334 |  | 4.284000000000001 | 0 |  | 4.284000000000001
4.633333333333335 |  | 4.380000000000001 | 0 |  | 4.380000000000001
4.933333333333334 |  | 4.56 | 0 |  | 4.56
5.253333333333335 |  | 5.152000000000001 | 0 |  | 5.152000000000001
5.683333333333334 |  | 5.410000000000001 | 0 |  | 5.410000000000001
5.813333333333334 |  | 5.488 | 0 |  | 5.488
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
6.213333333333335 |  | 6.128000000000001 | 0 |  | 6.128000000000001
7.013333333333335 |  | 7.008000000000001 | 0 |  | 7.008000000000001
7.013333333333335 |  | 7.008000000000001 | 0 |  | 7.008000000000001
7.013333333333335 |  | 7.008000000000001 | 0 |  | 7.008000000000001
^
When deleting or adding location,
fix this first row