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

 |  |  |  | Fills |  | air | PLAN
 |  |  |  |  |  |  |  | August
920 |  | launch |  | NEPAAL07 |  |  | 9.2 | 958
9.35 |  | camden |  | 21 | cherry |  | 0.25 | 0.22
10.2 |  | done |  |  |  |  | 0.75 | 0.48
10.572 |  | [NAME] |  | 13 | cherry | 2 | 0.62 | 0.55
11.194 |  | done |  |  |  |  | 0.37 | 0.28 |  |  |  |  |  |  |  |  | 0.8833333333333333
11.524 |  | dal tile |  | 9 | Green Melon | 1 | 0.55 | 0.52 |  |  |  |  |  |  |  |  | 53
12.068 |  | done |  |  |  |  | 0.24 | 0.23
12.458 |  | teleflex |  | 24 | cherry |  | 0.65 | 0.58
1.109999999999999 |  | done |  |  |  |  | 0.42 | 1.15
1.217999999999998 |  | spring city |  | 3 | Green Melon |  | 0.18 | 0.25
1.283999999999999 |  | done |  |  |  |  | 0.11 | 0.11
1.379999999999999 |  | Friendship |  | 10 | Green Melon |  | 0.16 | 0.18
1.559999999999999 |  | done |  |  |  |  | 0.3 | 0.27
2.151999999999999 |  | paoli |  | 22 | [NAME] |  | 0.32 | 0.35
2.409999999999998 |  | Done |  |  |  |  | 0.43 | 0.48
2.488 |  | jwpepper |  | 18 | spring |  | 0.13
3.128 |  | done |  |  |  |  | 0.4
3.176 |  | [NAME] |  | 0 | Blue Card |  | 0.08 | 0.08
3.206 |  | done |  |  |  |  | 0.05 | 0.05 |  |  |  |  |  |  |  |  | Sep Routes
3.266 |  | lunch |  |  |  |  | 0.1 | 0 |  |  |  |  |  |  |  | pa | va
3.326000000000001 |  | done |  |  |  |  | 0.1 | 0 |  |  |  |  |  |  |  | 8.67 | 7 | 15.67
3.488 |  | exton |  | 11 | cherry | 2 | 0.27 | 0.18 |  |  |  |  |  |  |  | 163 | 80 | 243
4.085999999999999 |  | Done |  |  |  |  | 0.33 | 0.28 |  |  |  |  |  |  |  |  |  | 15.50733886407147
4.313999999999997 |  | spitz |  | 12 | Green Melon |  | 0.38 | 0.38
4.511999999999997 |  | done |  |  |  |  | 0.33 | 0.35 |  |  |  |  |  |  |  |  | 2 new route
5.109999999999996 |  | granite run |  | 12 | cherry | 2 | 0.33 | 0.33 |  |  |  |  |  |  |  | org pa | va split
5.307999999999996 |  | done |  |  |  |  | 0.33 | 0.45 |  |  |  |  |  |  |  | 6.5 | 9.75 | 16.25
6.127999999999993 |  | home |  |  |  |  | 0.7 | 0.88 |  |  |  |  |  |  |  | 104 | 139 | 243
 |  |  |  | NEPAAL07 |  | Time home |  |  |  |  |  |  |  |  |  |  |  | 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+St+%26+Hall+St,+Spring+City,+Chester,+Pennsylvania+19475+to:423+W+HIGH+ST%09PHOENIXVILLE+to:40.07179,-75.49435+to:43+Leopard+Road,+Paoli,+PA+19301-1552+(Cook+Kaye+Abbott+MS:+Paoli+Executive+Green+II+Paoli)+to:Unknown+road+to:274+lancaster+suite+100%09+paoli+pa+to:%4040.030357,-75.623354+to:US-1+S%2FBaltimore+Pike+to:1067+West+Baltimore+Pike,+Media,+PA+19063-5185+(Granite+Run+Mall)+to:39.90321,-75.41353+to:dana+run&hl=en&sll=40.125341,-75.335312&sspn=0.4195,0.617294&geocode=FQjjYQId5GOH-ymV4l8GiMrGiTH-fDgae0I2Ng%3BFV94YQId3-eF-ylPms4p48jGiTENbbBoJ7Bm-A%3BFct9YQIdefaF-ymPXICAAsnGiTF7UvRU1S4fdw%3BFUKgYQIdKpaF-ymH1f4w9MjGiTEUDBzl5VYg2w%3BFXcgZAId2kuD-yHgZNxeWI3R3ymXnW3LN7zGiTEYLZNTyQ1kJg%3BFZ86ZgIdEkeD-yl9pAMh2KPGiTEWlV5Go2nQqA%3BFZzoZAId2OaB-ykvO4ODlpfGiTF_5BaMYSWk-Q%3BFbuyZQIdiFd_-ymbAR1HRYXGiTFl949qenlNDg%3BFZENZQIdMTt_-ykzfuH-yI_GiTEvZnigBox-Gg%3BFYZ0ZAIdyal_-ykB2JaN5JHGiTGPcfkKkG6TLg%3BFW5yYwIdMgyA-ykzmcon8JLGiTFrjQiDbH8noA%3BFbrtYgId2lqA-yn7fO2p0-zGiTGmweqIuagqxg%3BFTYPYwIdKOR_-w%3BFVb_YgIdXul_-yl7WCSkSu3GiTEvlXlhdm_wag%3BFZXQYgIdRhR--w%3BFTCBYAId4ip_-w%3BFR4PYQIdswWB-yG314Mh6HKmRCmjXJOIKunGiTFY5ks7EUQjOA%3BFerfYAId5keB-yktrb1U3OjGiTESnACN7fLHTg%3BFQjjYQId5GOH-ymV4l8GiMrGiTH-fDgae0I2Ng&t=h&dirflg=t&mra=dpe&mrsp=6&sz=11&via=2,3,6,10,17&z=11 |  |  |  |  |  |  |  |  |  | 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,-75.27397+to:40.2498449,-75.2813541+to:1010+CANNON+AVE%09LANSDALE+to:40.14364,-75.40606+to:640+N+LEWIS+RD%09LIMERICK+to:Church+St+%26+Hall+St,+Spring+City,+Chester,+Pennsylvania+19475+to:423+W+HIGH+ST%09PHOENIXVILLE+to:40.07029,-75.49324+to:43+Leopard+Road,+Paoli,+PA+19301-1552+(Cook+Kaye+Abbott+MS:+Paoli+Executive+Green+II+Paoli)+to:Unknown+road+to:274+lancaster+suite+100%09+paoli+pa+to:%4040.030357,-75.623354+to:US-1+S%2FBaltimore+Pike+to:1067+West+Baltimore+Pike,+Media,+PA+19063-5185+(Granite+Run+Mall)+to:39.90321,-75.41353+to:dana+run&hl=en&ll=40.085952,-75.309219&spn=0.168896,0.265732&sll=40.069796,-75.458393&sspn=0.084468,0.132866&geocode=FQjjYQId5GOH-ymV4l8GiMrGiTH-fDgae0I2Ng%3BFV94YQId3-eF-ylPms4p48jGiTENbbBoJ7Bm-A%3BFct9YQIdefaF-ymPXICAAsnGiTF7UvRU1S4fdw%3BFSEXZAIdWkKD-yHgZNxeWI3R3ymXnW3LN7zGiTEYLZNTyQ1kJg%3BFYszZAIdIEaD-ynrLW1eT7zGiTHARhF4FS3zNw%3BFV5_ZAIdXHGD-ylVrPok87zGiTFqj6QFSLoHXg%3BFSLZZAIdEaOD-ynrhhMwsLzGiTHx-Ehlz_JTSQ%3BFYDbZQIdjVyD-ymNS9b_u6PGiTEY9_jZpIhaDw%3BFRoUZgIdDmmD-ymdMQIqw6PGiTGo02OeoPwW_g%3BFfQpZgIdNkyD-ymnHc4e2qPGiTEnY6Sryu9hMQ%3BFZ86ZgIdEkeD-yl9pAMh2KPGiTEWlV5Go2nQqA%3BFRiLZAIdFGWB-ym9oa4x5JbGiTFctGDO8Io0Ow%3BFbuyZQIdiFd_-ymbAR1HRYXGiTFl949qenlNDg%3BFZENZQIdMTt_-ykzfuH-yI_GiTEvZnigBox-Gg%3BFYZ0ZAIdyal_-ykB2JaN5JHGiTGPcfkKkG6TLg%3BFZJsYwIdiBCA-ymha9mS75LGiTFLesxshW0kmQ%3BFbrtYgId2lqA-yn7fO2p0-zGiTGmweqIuagqxg%3BFTYPYwIdKOR_-w%3BFVb_YgIdXul_-yl7WCSkSu3GiTEvlXlhdm_wag%3BFZXQYgIdRhR--w%3BFTCBYAId4ip_-w%3BFR4PYQIdswWB-yG314Mh6HKmRCmjXJOIKunGiTFY5ks7EUQjOA%3BFerfYAId5keB-yktrb1U3OjGiTESnACN7fLHTg%3BFQjjYQId5GOH-ymV4l8GiMrGiTH-fDgae0I2Ng&oq=moore&t=h&dirflg=t&mra=dvme&mrsp=15&sz=13&via=2,4,5,6,7,8,9,11,15,22&z=12 |  |  |  |  |  | PLAN |  | wic |  | Wic
 | Plan fill | Planned hours |  | 155 |  | 7 | 8.879999999999999 | 8.63 | 0 | 0 | 0 | 0 | 0
 | 162 | 8.879999999999999 | 18.24324324324325 |  |  | drive | 4.62 | 4.500000000000001 | 0 | 0 | 0 | 0 | 0
 |  | Plan gross per hour |  |  |  | work | 4.259999999999999 | 4.13 | 0 | 0 | 0 | 0 | 0
 |  | 18.24324324324325 |  |  |  | Rate | 17.33108108108108 | 20.25492468134414 | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | PA Total
Springtime |  | 18 |  |  |  |  | 18 | 1.125
Green Melon | 9 | 3 | 10 |  | 12 |  | 34 | 2.266666666666667
[NAME] | 21 | 24 | 12 | 13 | 11 | 22 | 103 | 6.4375
Mandrin |  |  |  |  |  |  | 0 | 0
total in clicks | Clicks back to minutes |  |  | 7 | air |  | 155 | 162
9.333333333333332 |  |  | 0 |  | 0
9.583333333333332 |  | 9.35 | 0 |  | 9.35
10.33333333333333 |  | 10.2 | 0 |  | 10.2
10.95333333333333 |  | 10.572 | 0 |  | 10.572
11.32333333333333 |  | 11.194 | 0 |  | 11.194
11.87333333333333 |  | 11.524 | 0 |  | 11.524
12.11333333333333 |  | 12.068 | 0 |  | 12.068
12.76333333333333 |  | 12.458 | 0 |  | 12.458
13.18333333333333 |  | 13.11 | 12 |  | 1.109999999999999
13.36333333333333 |  | 13.218 | 12 |  | 1.217999999999998
13.47333333333333 |  | 13.284 | 12 |  | 1.283999999999999
13.63333333333333 |  | 13.38 | 12 |  | 1.379999999999999
13.93333333333333 |  | 13.56 | 12 |  | 1.559999999999999
14.25333333333333 |  | 14.152 | 12 |  | 2.151999999999999
14.68333333333333 |  | 14.41 | 12 |  | 2.409999999999998
14.81333333333333 |  | 14.488 | 12 |  | 2.488
15.21333333333333 |  | 15.128 | 12 |  | 3.128
15.29333333333333 |  | 15.176 | 12 |  | 3.176
15.34333333333333 |  | 15.206 | 12 |  | 3.206
15.44333333333333 |  | 15.266 | 12 |  | 3.266
15.54333333333333 |  | 15.326 | 12 |  | 3.326000000000001
15.81333333333333 |  | 15.488 | 12 |  | 3.488
16.14333333333333 |  | 16.086 | 12 |  | 4.085999999999999
16.52333333333333 |  | 16.314 | 12 |  | 4.313999999999997
16.85333333333333 |  | 16.512 | 12 |  | 4.511999999999997
17.18333333333333 |  | 17.11 | 12 |  | 5.109999999999996
17.51333333333332 |  | 17.308 | 12 |  | 5.307999999999996
18.21333333333332 |  | 18.12799999999999 | 12 |  | 6.127999999999993
18.21333333333332 |  | 18.12799999999999 | 12 |  | 6.127999999999993
18.21333333333332 |  | 18.12799999999999 | 12 |  | 6.127999999999993
^
When deleting or adding location,
fix this first row