Spreadsheet: 116676d1311978266-excel-2007-generating-a-master-spreadsheet-from-9-sub-sheets-mailflow-spreadsheet
Sheet: Cedar Rapids

Customer Name | Machine Job # | Pallets | Trays | Postage Type |  | Rate | Date Shipped | Date Received | Suggested Drop Date | Actual Drop Date | Notes | Machine Counts
 | 333
 | 334
 | 338
 | 339
3 | Kirkwood | First | Regular | Metered | 0.414
4 | Hills Bank | First | Regular | Metered | 0.39
6 | Cuna | First | Regular | Metered | 0.365
7 | Mercy IC | First | Regular | Metered | 0.414
11 | [NAME] | First | Regular | Metered | 0.414
12 | Aegon-KC | First | Regular | Metered | 0.39
14 | Aegon-FL | First | Regular | Metered | 0.39
15 | United Fire | First | Regular | Metered | 0.39
16 | Annuities | First | Regular | Metered | 0.39
17 | MSI  REC | First | Regular | Metered | 0.39
18 | CRST | First | Regular | Metered | 0.414
21 | Seabury | First | Regular | Metered | 0.414
31 | Alliant | First | Regular | Metered | 0.414
33 | True North | First | Regular | Metered | 0.414
34 | Aegon TRS | First | Regular | Metered | 0.39
35 | GMAC | First | Regular | Metered | 0.365
46 | St Lukes | First | Regular | Metered | 0.414
53 | MSI ACT | First | Regular | Metered | 0.39
54 | Chappell | First | Regular | Metered | 0.414
55 | ACT Student Report | First | Regular | Metered | 0.39
57 | ACT ASE | First | Regular | Metered | 0.39
62 | Linn Area CU | First | Regular | Metered | 0.414
64 | MSI | First | Regular | Metered | 0.39
68 | Vangent Sporadic | First | Regular | Metered | 0.39
70 | Hawkeye International | First | Regular | Metered | 0.414
77 | PresortXtra | First | Regular | Metered | 0.414
82 | MSI Auxiant | First | Regular | Metered | 0.39
86 | [NAME] | First | Regular | Metered | 0.39
89 | MSI  Misc  NonFF | First | Regular | Metered | 0.39
92 | MSI  West Music | First | Regular | Metered | 0.39
99 | MSI Linn County | First | Regular | Metered | 0.39
100 | Great America | First | Regular | Metered | 0.414
110 | MSI Reinhart | First | Regular | Metered | 0.39
111 | [NAME] | First | Regular | Metered | 0.414
112 | ACT Scott | First | Regular | Metered | 0.39
115 | Wartburg College | First | Regular | Metered | 0.414
116 | Covenant | First | Regular | Metered | 0.414
120 | MSI  McLeod Service | First | Regular | Metered | 0.39
124 | Vangent | First | Regular | Permit | 0
127 | Toyota | First | Regular | Metered | 0.414
132 | Iowa Mutual | First | Regular | Metered | 0.39
135 | Black Hawk Co | First | Regular | Metered | 0.39
136 | CR School | First | Regular | Metered | 0.414
138 | Aegon Daily | First | Regular | Metered | 0.39
139 | Written Correspondence | First | Regular | Permit | 0
140 | Linn County | First | Regular | Metered | 0.414
141 | Yellowbook | First | Regular | Metered | 0.414
144 | Mercy CR | First | Regular | Metered | 0.414
147 | South Slope | First | Regular | Metered | 0.365
148 | CR Water Dept | First | Regular | Metered | 0.39
154 | Black Hawk Clerk | First | Regular | Metered | 0.414
155 | U of I Campus | First | Regular | Metered | 0.39
157 | [NAME] CCU | First | Regular | Metered | 0.414
160 | MSI GE Commercial | First | Regular | Metered | 0.39
164 | City  Waterloo | First | Regular | Metered | 0.414
165 | [NAME] | First | Regular | Metered | 0.414
166 | FNB WAVERLY | First | Regular | Metered | 0.414
167 | Vangent BCC | First | Regular | Permit | 0
169 | Vangent [NAME] | First | Regular | Metered | 0.39
170 | West Music | First | Regular | Metered | 0.414
173 | Modern Woodmen | First | Regular | Metered | 0.39
180 | Chappell | First | Regular | Permit | 0
181 | Deere and Co | First | Regular | Metered | 0.365
182 | United Healthcare | First | Regular | Metered | 0.365
189 | Cedar Graphics PC Stamp | First | Regular | Stamped | 0.25
191 | MSI | First | Regular | Metered | 0.39
198 | Chappell 2 oz. Permit | First | Regular | Permit | 0
199 | Chappell 3 oz Permit | First | Regular | Permit | 0
200 | Miller SA | First | Regular | Metered | 0.39
201 | MSI - DRG | First | Regular | Metered | 0.39
202 | MSI - FSAIC | First | Regular | Metered | 0.39
203 | Hawkeye Foodservice Distr | First | Regular | Metered | 0.414
206 | Pearson Inc | First | Regular | Metered | 0.39
207 | UIHC | First | Regular | Permit | 0
208 | Mailing Services Inc | First | Regular | Metered | 0.39
211 | PCat | First | Regular | Metered | 0.39
304 | Mercy IC Permit | Standard | Non-Profit | Permit | 0
318 | Chappell | Standard | Regular | Metered | 0.273
319 | Grant Wood NP | Standard | Non-Profit | Permit | 0
321 | Black Hawk County | Standard | Regular | Metered | 0.276
324 | MSI COE COLLEGE | Standard | Non-Profit | Metered | 0.089
326 | UNITED FIRE | Standard | Regular | Metered | 0.276
329 | MSI | Standard | Regular | Metered | 0.255
331 | Ruffalo Cody Inc | Standard | Non-Profit | Permit | 0
333 | Modern Wdmn NP | Standard | Non-Profit | Metered | 0.168
334 | Modern Woodmen | Standard | Regular | Metered | 0.26
336 | Vangent Inc | Standard | Regular | Metered | 0.273
338 | Vangent Inc | Standard | Regular | Permit | 0
339 | Modern Woodmen NP | Standard | Non-Profit | Permit | 0
391 | Ruffalo Cody Inc | Standard | Regular | Permit | 0
502 | Multi oz Rejects | First | Regular | Metered | 0.414
505 | Permit 1 oz Rejects FF | First | Regular | Permit | 0
506 | 1oz Rejects NonFF | First | Regular | Permit | 0
507 | Permit 2 oz Rejects FF | First | Regular | Permit | 0
508 | 2oz Rejects NonFF | First | Regular | Permit | 0
509 | Stamp Rejects FF | First | Regular | Stamped | 0.25
510 | Rejects FF | First | Regular | Metered | 0.365
511 | Rejects FF | First | Regular | Metered | 0.39
512 | Rejects FF | First | Regular | Metered | 0.414
513 | Permit Rejects 3oz Non-FF | First | Regular | Permit | 0
520 | PSI [NAME] FF | First | Regular | Metered | 0.414
521 | Rejects FF | First | Regular | Metered | 0.368
525 | PB Presort Services | First | Regular | Metered | 0.414
531 | 1 oz Rejects | First | Regular | Metered | 0.365
541 | 1 oz Rejects | First | Regular | Metered | 0.368
551 | 1 oz Rejects | First | Regular | Metered | 0.39
600 | Sporadic | First | Regular | Metered | 0.365
601 | Sporadic | First | Regular | Metered | 0.39
602 | Sporadic | First | Regular | Metered | 0.414
610 | Sporadic non-FF | First | Regular | Permit | 0
611 | Sporadic | First | Regular | Permit | 0
615 | Sporadic | First | Regular | Metered | 0.34
891 | Standard Register | First | Regular | Metered | 0.365
999 | Second Pass | First | Regular | Permit | 0