Spreadsheet: 90813d1290537391-excel-2007-sorting-by-color-example
Sheet: Tracking

# | Terminal | Contact | # | Completed | Delievered | Working | [NAME] | Need | Tracking # | EXC | Added |  | Notes
1 | Richmond | [NAME] | 5 | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 |  | 0 | 0 | N/A
40 | Savannah | [NAME] | 4 | 2010-11-23 00:00:00 |  |  | 0
62 | Cincinnati | [NAME] | 1 | 2010-11-23 00:00:00 |  |  | 0
82 | Syracuse | [NAME] | 2 | 2010-11-23 00:00:00 |  |  | 0
88 | New Haven | [NAME] | 3 | 2010-11-23 00:00:00 |  |  | 0
89 | Dallas | [NAME] | 2 | 2010-11-23 00:00:00 |  |  | 0
3 | Norfolk | [NAME] | 8 | 2010-11-01 00:00:00 | 2010-11-03 00:00:00 | 7 | 1 | 0 | 1Z36E95E0342025270 | 1 | O |  | Telecom failure
5 | Winchester | [NAME] | 4 | 2010-11-05 00:00:00 | 2010-11-11 00:00:00 | 3 | 1 | 0 | 1Z36E95E0340434699 | 1 | x
7 | Roanoke | Lane Largent | 2 | 2010-11-03 00:00:00 | 2010-11-08 00:00:00 | 2 | 0 | 0 | 1Z36E95E0342925771 |  |  |  | Telecom
10 | Charlotte | [NAME] | 2 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 2 | 0 | 0 | 1Z36E95E0342390394
12 | West Palm | [NAME] | 2 | 2010-11-01 00:00:00 | 2010-11-04 00:00:00 | 1 | 1 | 0 | 1Z36E95E0340640537 | 1 | X
14 | Pulaski | [NAME] | 3 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 2 | 1 | 0 | 1Z36E95E0342255405 | 1 | O
16 | Wilson | [NAME] | 4 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 4 | 0 | 0 | 1Z36E95E0342773766 |  |  |  | (11/18 1:12) Left Message
21 | Altoona | Heather Holland | 2 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 2 | 0 | 0 | 1Z36E95E0342776816
24 | Harrisburg | [NAME] | 6 | 2010-11-02 00:00:00 | 2010-11-04 00:00:00 | 6 | 0 | 0 | 1Z36E95E0341125379 |  |  |  | Came with no atennas, [NAME] informed EDPS
25 | Pittsburgh | [NAME] | 9 | 2010-11-01 00:00:00 | 2010-11-04 00:00:00 | 5 | 4 | 0 | 1Z36E95E0342970329 | 4 | O |  | 1 will not download, cold booted and reset
26 | Allentown | [NAME] | 5 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 4 | 1 | 0 | 1Z36E95E0342894199 | 1 | X |  | These went to the wrong Portland, OR.  [NAME] for 222 so I just re-added 170
28 | Chicago | [NAME] | 8 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 3 | 5 | 0 | 1Z36E95E0340950158 | 5 | X |  | 2 got telecom error message along with 3 more.
30 | Lexington | [NAME] | 3 | 2010-11-01 00:00:00 | 2010-11-04 00:00:00 | 3 | 0 | 0 | 1Z36E95E0341765464
31 | Greenville | [NAME] | 6 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 6 | 0 | 0 | 1Z36E95E0341751344 |  |  |  | Already on the list for 11
32 | Columbia | [NAME] | 3 | 2010-11-09 00:00:00 | 2010-11-17 00:00:00 | 0 | 3 | 0 | 1Z36E95E0341651121 | 3 | x
36 | Huntsville | [NAME] | 2 | 2010-11-05 00:00:00 | 2010-11-10 00:00:00 | 2 | 0 | 0 | 1Z36E95E0342810653 |  |  |  | Ramina error
38 | Chattanooga | Homer Green | 3 | 2010-11-01 00:00:00 | 2010-11-03 00:00:00 | 0 | 3 | 0 | 1Z36E95E0341127046 | 3 | X
40 | Savannah | [NAME] | 5 | 2010-11-16 00:00:00 | 2010-11-18 00:00:00 | 5 | 0 |  | 1Z36E95E0341430388 |  |  |  | None of the 6 working, already on list for 6
41 | Atlanta | [NAME] | 3 | 2010-11-09 00:00:00 | 2010-11-16 00:00:00 | 1 | 2 | 0 | 1Z36E95E0342591846 | 2
42 | Albany | [NAME] | 3 | 2010-11-03 00:00:00 | 2010-11-09 00:00:00 | 3 | 0 | 0 | 1Z36E95E0341645969
45 | Jacksonville | [NAME] Justice | 2 | 2010-11-03 00:00:00 | 2010-11-09 00:00:00 | 2 | 0 | 0 | 1Z36E95E0341333984 |  |  |  | Both running slow but working
46 | Orlando | [NAME] | 2 | 2010-11-09 00:00:00 | 2010-11-12 00:00:00 | 2 | 0 | 0 | 1Z36E95E0340690920
47 | Athens | Rabun [NAME] | 4 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 4 | 0 | 0 | 1Z36E95E0341624615
51 | Scranton | [NAME] | 2 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 2 | 0 | 0 | 1Z36E95E0341050628 |  |  |  | (11/15) TM has them, not been used yet.  Will call if they do not work.
53 | Philadelphia | [NAME] | 7 | 2010-11-03 00:00:00 | 2010-11-05 00:00:00 | 7 | 0 | 0 | 1Z36E95E0341612833 |  |  |  | (11/12 to 11/16) Emailed multiple times, no response.
56 | Little Rock | [NAME] | 1 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 1 | 0 | 0 | 1Z36E95E0341065470
58 | Seekonk | [NAME] | 1 | 2010-11-09 00:00:00 | 2010-11-16 00:00:00 | 1 | 0 | 0 | 1Z36E95E0341502185
61 | Middletown | [NAME] | 8 | 2010-11-03 00:00:00 | 2010-11-05 00:00:00 | 8 | 0 | 0 | 1Z36E95E0340503248 |  |  |  | Ramina error on them
62 | Cincinnati | [NAME] | 7 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 5 | 2 | 0 | 1Z36E95E0340277583 | 2 | X
64 | St Louis, MO | [NAME] | 4 | 2010-11-09 00:00:00 | 2010-11-17 00:00:00 | 4 | 0 | 0 | 1Z36E95E0342251025
66 | [NAME] | Rex Primm | 5 | 2010-11-02 00:00:00 | 2010-11-09 00:00:00 | 5 | 0 | 0 | 1Z36E95E0342848739
68 | Grand Rapids | [NAME] | 4 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 4 | 0 | 0 | 1Z36E95E0341861565 |  |  |  | Telecom failure
69 | Flint | [NAME] | 2 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 1 | 1 | 0 | 1Z36E95E0340842257 | 1 | X
77 | [NAME] | [NAME] | 1 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 0 | 1 | 0 | 1Z36E95E0342850520 | 1 | x
78 | Racine | [NAME] | 6 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 6 | 0 | 0 | 1Z36E95E0342197666 |  |  |  | (11/11) trying to get ahold of [NAME]
80 | Boston | [NAME] | 1 | 2010-11-01 00:00:00 | 2010-11-03 00:00:00 | 0 | 1 | 0 | 1Z36E95E0341432411 | 1 | X |  | Worked for 1-2 days and then got internal keys error message
82 | Syracuse | [NAME] | 3 | 2010-11-05 00:00:00 | 2010-11-09 00:00:00 | 3 | 0 | 0 | 1Z36E95E0342879607
83 | Buffalo | [NAME] | 1 | 2010-11-02 00:00:00 | 2010-11-05 00:00:00 | 1 | 0 | 0 | 1Z36E95E0341381682 |  |  |  | 1 Frozen, (11/11) Already down for 4 more.
84 | Parsippany | [NAME] | 17 | 2010-11-01 00:00:00 | 2010-11-04 00:00:00 | 17 | 0 | 0 | 1Z36E95E0340613487
86 | Louisville | [NAME] | 1 | 2010-11-01 00:00:00 | 2010-11-03 00:00:00 | 1 | 0 | 0 | 1Z36E95E0341290226
87 | Columbus | [NAME] | 4 | 2010-11-09 00:00:00 | 2010-11-16 00:00:00 | 4 | 0 | 0 | 1Z36E95E0342069232
88 | New Haven | [NAME] | 4 | 2010-11-05 00:00:00 | 2010-11-10 00:00:00 | 3 | 1 | 0 | 1Z36E95E0342942065 | 1 | x |  | (11/11) Already down for 3 replacements
89 | Dallas | [NAME] | 1 | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 | 1 | 0 | 0 | 1Z36E95E0340580718 |  |  |  | (11/11) No answer
128 | Elgin | [NAME] | 4 | 2010-11-09 00:00:00 | 2010-11-17 00:00:00 | 3 | 1 | 0 | 1Z36E95E0341961215 | 1 | x |  | 1 does not scan.
138 | Minneapolis | [NAME] | 3 | 2010-11-09 00:00:00 | 2010-11-17 00:00:00 | 3 | 0 | 0 | 1Z36E95E0341862797
155 | Cleveland | Becky | 1 | 2010-11-01 00:00:00 | 2010-11-03 00:00:00 | 1 | 0 | 0 | 1Z36E95E0340196438 |  |  |  | One doesn't turn, one frozen
164 | Kansas City | [NAME] | 7 | 2010-11-01 00:00:00 | 2010-11-05 00:00:00 | 5 | 2 | 0 | 1Z36E95E0340698057 | 2 | X |  | Already on the list for 1 handheld
165 | Houston | [NAME] | 6 | 2010-11-02 00:00:00 | 2010-11-10 00:00:00 | 6 | 0 | 0 | 1Z36E95E0340191200
170 | Portland | [NAME] | 5 | 2010-11-03 00:00:00 | 2010-11-11 00:00:00 | 5 | 0 | 0 | 1Z36E95E0342546458 |  |  |  | (11/11) [NAME] has broken ones, over limit
179 | Chicopee | [NAME] | 5 | 2010-11-02 00:00:00 | 2010-11-12 00:00:00 | 5 | 0 | 0 | 1Z36E95E0140902758
186 | [NAME] | Todd | 3 | 2010-11-02 00:00:00 | 2010-11-09 00:00:00 | 3 | 0 | 0 | 1Z36E95E0340374352
192 | Oklahoma City | [NAME] | 6 | 2010-11-02 00:00:00 | 2010-11-09 00:00:00 | 6 | 0 | 0 | 1Z36E95E0342524632 |  |  |  | 1 did not work but not needed, already over #
212 | Sacramento | [NAME] | 2 | 2010-11-03 00:00:00 | 2010-11-11 00:00:00 | 0 | 2 | 0 | 1Z36E95E0342039443 | 2 | X |  | Tried Coldbooting and reseting (11/11)
223 | Seattle | [NAME] | 1 | 2010-11-03 00:00:00 | 2010-11-11 00:00:00 | 0 | 1 | 0 | 1Z36E95E0341909880 | 1 | x |  | Already on the list for 1 handheld
224 | Denver | [NAME] | 6 | 2010-11-03 00:00:00 | 2010-11-10 00:00:00 | 0 | 6 | 0 | 1Z36E95E0340465674 | 6 | x
295 | Riverside | [NAME] | 4 | 2010-11-03 00:00:00 | 2010-11-11 00:00:00 | 0 | 4 | 0 | 1Z36E95E0340589862 | 4 | x |  | (11/11) Becky in the morning would know
299 | City of Industry | Jess Razo | 2 | 2010-11-02 00:00:00 | 2010-11-10 00:00:00 | 2 | 0 | 0 | 1Z36E95E0342490428
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0