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

Customer Name | Machine Job # | Pallets | Trays | Postage Type |  | Rate | Date Shipped | Date Received | Suggested Drop Date | Actual Drop Date | Notes | Machine Counts
 | 934
 | 613
 | 657
 | 917
1 | NO COUNT | First | Regular | Metered | 0.414
2 | NO COUNT | Standard | Regular | Metered | 0.276
19 | Default 4oz | First | Regular | Permit | 0
40 | Default Permit PC | First | Non-Profit | Permit | 0
51 | Default 3 oz | First | Regular | Permit | 0
55 | Default FF | Standard | Regular | Metered | 0.255
56 | Default NP FF | Standard | Non-Profit | Metered | 0.132
57 | Default NP FF Stamp | Standard | Non-Profit | Stamped | 0.05
58 | Default NP FF 1oz | Standard | Non-Profit | Permit | 0
59 | Default | Standard | Regular | Metered | 0.26
60 | Default NP FF | Standard | Non-Profit | Metered | 0.174
61 | Default 2 oz | First | Regular | Permit | 0
62 | Default 1 oz | First | Regular | Permit | 0
63 | Default | First | Regular | Metered | 0.34
65 | [NAME] FF | Standard | Regular | Stamped | 0.1
66 | [NAME] Permit FF | Standard | Regular | Permit | 0
67 | Default FF | Standard | Regular | Metered | 0.257
68 | Default FF | Standard | Regular | Metered | 0.273
69 | Default FF | Standard | Regular | Metered | 0.276
71 | Default | First | Regular | Metered | 0.365
72 | Default | First | Regular | Metered | 0.368
73 | Default | First | Regular | Metered | 0.39
80 | Default Permit PC FF | First | Non-Profit | Permit | 0
81 | Default PC FF | First | Non-Profit | Metered | 0.26
89 | Default FF Ret | First | Regular | Metered | 0.414
90 | Default FF Batch | First | Regular | Metered | 0.414
91 | Default FF 3oz. | First | Regular | Permit | 0
92 | Default FF Stamp | First | Regular | Stamped | 0.25
93 | Default FF 2oz. | First | Regular | Permit | 0
94 | Default FF 1oz. | First | Regular | Permit | 0
95 | Default FF | First | Regular | Metered | 0.34
96 | Default FF | First | Regular | Metered | 0.365
97 | Default FF | First | Regular | Metered | 0.368
98 | Default FF | First | Regular | Metered | 0.39
99 | [NAME] | First | Regular | Metered | 0.414
101 | Deluxe Check 1oz. Permit | First | Regular | Permit | 0
102 | Deluxe Check 2oz. Permit | First | Regular | Permit | 0
105 | HH Black and Decker | First | Regular | Permit | 0
106 | CVS 1oz | First | Regular | Permit | 0
107 | CVS 2oz | First | Regular | Permit | 0
108 | CVS 3oz | First | Regular | Permit | 0
113 | Childrens International | First | Regular | Metered | 0.365
114 | Childrens International | First | Regular | Permit | 0
115 | SEC BEN STD PRUDENT | Standard | Regular | Metered | 0.276
116 | Childrens 3oz. | First | Regular | Permit | 0
118 | DRM 1oz  EARLY | First | Regular | Permit | 0
119 | DRM 2oz EARLY | First | Regular | Permit | 0
121 | Children 1 oz permit | First | Regular | Permit | 0
124 | CSC Covansys Corp. | First | Regular | Metered | 0.365
125 | SecBen MASS MUTUAL | First | Regular | Metered | 0.365
126 | Tangent Press Inc. | Standard | Regular | Metered | 0.26
128 | CSC Covansys Corp. | First | Regular | Metered | 0.365
129 | Valley View 3 digit flats | First | Regular | Metered | 0.365
130 | SEC BEN - CHASE | Standard | Regular | Metered | 0.276
131 | Deluxe Direct Checks | Standard | Regular | Permit | 0
132 | SEC BEN  CALIC | Standard | Regular | Metered | 0.276
133 | TPMC  Permit PC | First | Non-Profit | Permit | 0
135 | DST Key 1oz | First | Regular | Permit | 0
136 | DST Key 2oz | First | Regular | Permit | 0
137 | DST Key 3oz | First | Regular | Permit | 0
138 | DST Key 4oz | First | Regular | Permit | 0
139 | Armed Forces Bank | First | Regular | Metered | 0.39
142 | AF Academy | First | Regular | Metered | 0.39
143 | SECUR BENEFIT | Standard | Regular | Metered | 0.276
145 | PB Presortxtra  NEXT DAY | First | Regular | Metered | 0.414
149 | AF  Academy MW | First | Regular | Metered | 0.39
153 | [NAME]3 oz | First | Regular | Metered | 0.365
154 | [NAME]oz | First | Regular | Stamped | 0.25
155 | KCPL | First | Regular | Permit | 0
156 | HH  ABBOTT 1 oz | First | Regular | Permit | 0
158 | Nies  -CINTAS | First | Regular | Permit | 0
164 | DST Mailing Services | Standard | Regular | Permit | 0
170 | JPMorgan CORPORATE | First | Regular | Metered | 0.365
174 | [NAME] | First | Non-Profit | Permit | 0
175 | SEC BENEFIT CALIC | First | Regular | Metered | 0.365
176 | DST Mailing Services FF | Standard | Regular | Permit | 0
178 | ISI | First | Regular | Metered | 0.39
181 | JPMorgan OPERATIONS | First | Regular | Permit | 0
182 | JPMorgan OPERATIONS | First | Regular | Permit | 0
184 | Stampede | Standard | Non-Profit | Metered | 0.174
185 | Stampede | Standard | Regular | Metered | 0.276
186 | On Demand Technologies  I | First | Non-Profit | Permit | 0
187 | Assurant Print shop flats | First | Regular | Metered | 0.365
191 | JPMorgan COMMUNICATIONS | First | Regular | Permit | 0
192 | JPMorgan COMMUNICATIONS | First | Regular | Permit | 0
194 | Unity OM Daily Word | Standard | Non-Profit | Permit | 0
195 | Unity 2 oz 4x6 Daily Word | First | Regular | Permit | 0
197 | Unity 2 oz 4x6 La Palabra | First | Regular | Permit | 0
198 | Unity OM La Palabra Diari | Standard | Non-Profit | Permit | 0
199 | Unity OM large Type | Standard | Non-Profit | Permit | 0
201 | CSC Covansys Corp | First | Regular | Metered | 0.365
204 | Chartis Insurance | First | Regular | Metered | 0.365
205 | [NAME] | First | Regular | Metered | 0.365
208 | Heart of America FLATS | First | Regular | Metered | 0.365
209 | [NAME] | First | Regular | Metered | 0.365
210 | Bank of America   PBMS | First | Regular | Metered | 0.365
213 | SEC BEN Modern Woodman | First | Regular | Metered | 0.365
217 | Boilermakers National Fun | Standard | Regular | Permit | 0
219 | DRM 1oz | First | Regular | Permit | 0
223 | ODT - self mailers | Standard | Regular | Permit | 0
227 | Deluxe 2 oz | First | Regular | Permit | 0
228 | Clayton Capital Partners | Standard | Regular | Metered | 0.276
230 | DST Key 1oz LATE | First | Regular | Permit | 0
231 | DST Key 2oz LATE | First | Regular | Permit | 0
232 | DST Key 3oz LATE | First | Regular | Permit | 0
233 | DST Key 4oz LATE | First | Regular | Permit | 0
246 | Boilermakers 1oz | First | Regular | Permit | 0
247 | Boilermakers | First | Regular | Metered | 0.365
249 | CFCA | First | Regular | Metered | 0.39
250 | DST 1oz EARLY | First | Regular | Permit | 0
251 | DST 1oz LATE | First | Regular | Permit | 0
252 | DST 2oz EARLY | First | Regular | Permit | 0
253 | DST 2oz LATE | First | Regular | Permit | 0
254 | DST 3oz EARLY | First | Regular | Permit | 0
255 | DST 3oz LATE | First | Regular | Permit | 0
256 | KC Clinical Oncology Prog | First | Regular | Metered | 0.365
257 | Bank Midwest | First | Regular | Metered | 0.39
258 | SEC [NAME] | First | Regular | Metered | 0.365
266 | AF Southern Commerce | First | Regular | Metered | 0.39
267 | State Farm Insurance  MO | First | Regular | Metered | 0.365
268 | TPMC   DIGEST FC 1 OZ | First | Regular | Permit | 0
271 | Kansas City Life Insuranc | Standard | Regular | Metered | 0.255
272 | Hillcrest Bank | First | Regular | Metered | 0.365
274 | [NAME] of Nazarene | First | Regular | Metered | 0.365
285 | DST FULL SERVICE | First | Regular | Metered | 0.414
286 | On Demand Technologies | Standard | Regular | Permit | 0
288 | TPMC DIGEST STD 1 OZ | Standard | Regular | Permit | 0
289 | State Farm MO Claims Offi | First | Regular | Metered | 0.365
291 | [NAME] | First | Non-Profit | Metered | 0.26
297 | Armed Forces | First | Regular | Metered | 0.39
299 | Unity 4 oz permit | First | Regular | Permit | 0
302 | SEC BEN INSURANCE SERV | First | Regular | Metered | 0.365
304 | [NAME] | First | Regular | Permit | 0
306 | Children International | First | Regular | Metered | 0.365
308 | DEFAULT FLATS | First | Regular | Metered | 0.365
317 | Armed Forces Leavenworth | First | Regular | Metered | 0.414
320 | Chartis Insurance | First | Regular | Metered | 0.365
325 | GEHA | First | Regular | Metered | 0.365
326 | CVS 2oz EARLY | First | Regular | Permit | 0
328 | UMB Bank 3 digit metered | First | Regular | Metered | 0.365
331 | CFCA misc sporadic mail | First | Regular | Metered | 0.39
337 | Leggett & Platt  Inc. | First | Regular | Metered | 0.39
350 | DST EARLY | First | Regular | Metered | 0.365
351 | DST | First | Regular | Metered | 0.365
353 | CVS 1oz EARLY | First | Regular | Permit | 0
354 | DST LATE | First | Regular | Metered | 0.365
356 | DST [NAME] | Standard | Regular | Permit | 0
358 | DST Systems Inc. | First | Regular | Metered | 0.414
367 | CVS 3oz EARLY | First | Regular | Permit | 0
369 | Unity | First | Regular | Permit | 0
370 | RR Donnelly WWatchers | First | Regular | Permit | 0
372 | RR Donnelly WWatchers | First | Regular | Permit | 0
373 | RR Donnelly WW LATE | First | Regular | Permit | 0
377 | Overland Solutions | First | Regular | Metered | 0.414
378 | State Farm Ins MO | First | Regular | Metered | 0.365
379 | DST Postcards | First | Non-Profit | Permit | 0
381 | SEC BEN PRUDENTIAL | First | Regular | Metered | 0.365
386 | On Demand Technologies  I | First | Regular | Permit | 0
388 | PB PresortXtra SAME DAY | First | Regular | Metered | 0.414
394 | CFCA | First | Regular | Metered | 0.365
395 | PBPS OM  Firstcomp | First | Regular | Metered | 0.365
397 | Unity 4x6 Daily Word | Standard | Non-Profit | Permit | 0
398 | Unity 4x6 spanish permit | Standard | Non-Profit | Permit | 0
399 | Unity 6x9 NP permit | Standard | Non-Profit | Permit | 0
412 | PBPS OM Woodmen of the | First | Regular | Metered | 0.365
414 | PBPS OM Physician Mutu | First | Regular | Metered | 0.365
417 | [NAME] of Nazarene | First | Regular | Metered | 0.414
419 | KC Life | First | Regular | Metered | 0.365
420 | DST 1oz | First | Regular | Permit | 0
421 | DST 2oz | First | Regular | Permit | 0
422 | DST 3oz | First | Regular | Permit | 0
429 | [NAME] | First | Regular | Metered | 0.365
430 | [NAME] of Nazarene | First | Regular | Metered | 0.39
431 | BOA  PBMS ST.LOUIS | First | Regular | Metered | 0.365
432 | BOA PBMS  ST.LOUIS | First | Regular | Metered | 0.365
433 | SECURITY BENEFIT | First | Regular | Metered | 0.365
437 | BOA  PBMS ST LOUIS | First | Regular | Metered | 0.365
444 | Zurich | First | Regular | Metered | 0.39
452 | Assurant | First | Regular | Metered | 0.365
461 | PPPS OM Lincoln Financi | First | Regular | Metered | 0.365
463 | Bank of America  PBMS | First | Regular | Metered | 0.365
464 | Bank of America  PBMS | First | Regular | Metered | 0.365
468 | Stampede  MIXED AADC | First | Regular | Metered | 0.39
471 | Unity  Stamp 1oz | First | Regular | Stamped | 0.25
472 | Unity Permit 1oz | First | Regular | Permit | 0
473 | Lockton Affinity | First | Regular | Metered | 0.39
475 | Allied National | First | Regular | Metered | 0.414
478 | Federated Rural FLATS | First | Regular | Metered | 0.365
480 | PBPS OM Werner | First | Regular | Metered | 0.365
482 | GEHA Indep FLATS | First | Regular | Metered | 0.365
487 | Armed Forces AF | First | Regular | Metered | 0.39
492 | GEHA [NAME] FLATS | First | Regular | Metered | 0.365
501 | Tangent FLATS | First | Regular | Metered | 0.365
502 | College Rehab Medicine | First | Regular | Metered | 0.365
504 | Bayer Health FLATS | First | Regular | Metered | 0.365
505 | PB PresortXtra  FLATS | First | Regular | Metered | 0.365
506 | [NAME] | First | Regular | Metered | 0.365
507 | Uhlig LLC FLATS | First | Regular | Metered | 0.365
508 | SECURITY BENEFIT FLATS | First | Regular | Metered | 0.365
511 | Ladies Auxiliary  FLATS | First | Regular | Metered | 0.365
513 | North KC Hospital  FLATS | First | Regular | Metered | 0.365
515 | PBPS OM PVP | First | Regular | Metered | 0.365
516 | FMH Benefit FLATS | First | Regular | Metered | 0.365
517 | KC Clinical Oncology Prog | First | Regular | Metered | 0.365
522 | HCA Midwest  FLATS | First | Regular | Metered | 0.365
523 | Vangen DRG 734  KC 523 | First | Regular | Metered | 0.365
524 | GMAC  FLATS | First | Regular | Metered | 0.365
525 | First National Bank Mixed | First | Regular | Metered | 0.39
527 | ACT Scott FLATS | First | Regular | Metered | 0.365
529 | CUNA MUTUAL | First | Regular | Metered | 0.365
530 | IOWA MUTUAL | First | Regular | Metered | 0.365
532 | TOYOTA 718 | First | Regular | Metered | 0.365
533 | VANGENT FSAIC | First | Regular | Metered | 0.365
534 | Gentiva Health Services | First | Regular | Metered | 0.365
536 | Vangent ASE | First | Regular | Metered | 0.365
537 | Vangent HS College | First | Regular | Metered | 0.365
539 | Pediatric Ortho FLATS | First | Regular | Metered | 0.365
540 | PBPS OM BCBS | First | Regular | Metered | 0.365
542 | Ladies Aux  VFW | First | Regular | Metered | 0.39
543 | SEABURY and SMITH | First | Regular | Metered | 0.365
544 | College Park Family FLATS | First | Regular | Metered | 0.365
545 | Urgent Care of KC FLATS | First | Regular | Metered | 0.365
552 | KCKCC NP Permit | Standard | Non-Profit | Permit | 0
558 | PBPS OM Pacific Life | First | Regular | Metered | 0.365
559 | Pearson FLATS | First | Regular | Metered | 0.365
562 | PBPS Des Moines - Regulus | First | Regular | Metered | 0.365
563 | Pearson PCAT | First | Regular | Metered | 0.365
564 | YELLOW BOOK FLATS | First | Regular | Metered | 0.365
566 | Gentiva Health Services | First | Regular | Metered | 0.414
571 | JPMorgan CORPORATE | First | Regular | Metered | 0.365
581 | JPMorgan OPERATIONS | First | Regular | Metered | 0.365
582 | US Bank FLATS | First | Regular | Metered | 0.365
586 | CBIZ FLATS | First | Regular | Metered | 0.365
589 | Bank Midwest | First | Regular | Metered | 0.365
590 | JPMorgan COMMUNICATIONS | First | Regular | Metered | 0.365
591 | Armed Forces Ins FLATS | First | Regular | Metered | 0.365
592 | GovEmpHosp INDEP | First | Regular | Metered | 0.365
593 | Richardson FLATS | First | Regular | Metered | 0.365
596 | USBA   FLATS | First | Regular | Metered | 0.365
597 | PBPS Des Moines - GuideOn | First | Regular | Metered | 0.365
599 | PBPS OM Gallup | First | Regular | Metered | 0.365
613 | [NAME] FLATS | First | Regular | Metered | 0.365
614 | AAFP | Standard | Non-Profit | Permit | 0
615 | Harte Hanks ABBOTT | Standard | Regular | Permit | 0
617 | Armed Forces Bank FLATS | First | Regular | Metered | 0.365
622 | HCA Midwest | First | Regular | Metered | 0.365
627 | TFS REMEL | First | Regular | Metered | 0.39
631 | PBPS OM TMI | First | Regular | Metered | 0.365
639 | Pediatric Orthopedic Surg | First | Regular | Metered | 0.365
644 | College Park Family Care | First | Regular | Metered | 0.365
645 | Urgent Care of Kansas Cit | First | Regular | Metered | 0.365
649 | CFCA | First | Regular | Metered | 0.39
651 | Uhlig LLC  1 oz | First | Regular | Permit | 0
652 | Uhlig LLC 2 oz | First | Regular | Permit | 0
653 | Uhlig LLC  3 oz | First | Regular | Permit | 0
657 | PBPS OM Christian Reco | First | Regular | Metered | 0.365
664 | DST Key 1oz EARLY | First | Regular | Permit | 0
665 | DST Key 2oz EARLY | First | Regular | Permit | 0
666 | DST Key 3oz EARLY | First | Regular | Permit | 0
673 | Lockton Affinity  FLATS | First | Regular | Metered | 0.365
677 | SEC BEN PRUDENTIAL | Standard | Regular | Metered | 0.237
679 | DST Key 4oz EARLY | First | Regular | Permit | 0
684 | DST  FLATS | First | Regular | Metered | 0.365
686 | On Demand Technologies  I | First | Regular | Permit | 0
691 | Armed Forces Ins | First | Regular | Metered | 0.39
693 | Armed Forces Ins | Standard | Regular | Metered | 0.273
696 | PBPS OM Union Pacific | First | Regular | Metered | 0.365
698 | Swiss Re FLATS | First | Regular | Metered | 0.365
700 | CFCA metered by cust | First | Regular | Metered | 0.39
706 | CVS 1oz LATE | First | Regular | Permit | 0
707 | CVS 2oz LATE | First | Regular | Permit | 0
708 | CVS 3oz LATE | First | Regular | Permit | 0
713 | RR Donnelly | First | Regular | Permit | 0
715 | Armed Forces  Academy | First | Regular | Metered | 0.39
717 | [NAME] | First | Regular | Metered | 0.365
718 | [NAME] | First | Regular | Metered | 0.365
719 | [NAME] | First | Regular | Metered | 0.365
721 | UMB Bank 1 oz permit | First | Regular | Permit | 0
722 | UMB Bank 2 oz permit | First | Regular | Permit | 0
723 | UMB Bank 3 oz permit | First | Regular | Permit | 0
724 | [NAME] | First | Regular | Metered | 0.365
725 | [NAME] | First | Regular | Metered | 0.365
726 | [NAME] | First | Regular | Metered | 0.365
727 | College Rehab Medicine | First | Regular | Metered | 0.365
741 | Heartland Hospital | First | Regular | Metered | 0.414
758 | C and S Mailing | Standard | Regular | Metered | 0.276
770 | KCPL | First | Regular | Metered | 0.39
778 | Tangent Press | Standard | Regular | Permit | 0
780 | Tangent Press | Standard | Regular | Stamped | 0.1
782 | Stampede | First | Regular | Metered | 0.414
798 | Stampede | First | Regular | Metered | 0.365
814 | KU Med [NAME] | Standard | Non-Profit | Metered | 0.174
889 | PBPS OM AgSource | First | Regular | Metered | 0.365
890 | PBPS OM Mutual | First | Regular | Metered | 0.365
899 | PBPS OM Nelnet | First | Regular | Metered | 0.365
901 | VFW NP OM drop | Standard | Non-Profit | Permit | 0
907 | TPMC [NAME]. Permit | Standard | Regular | Permit | 0
908 | TPMC Std Permit Newsltr | Standard | Regular | Permit | 0
909 | TPMC STD Jumbo PC | Standard | Regular | Permit | 0
916 | Childrens Std NP Permit | Standard | Non-Profit | Permit | 0
917 | Childrens Std NP Stamp | Standard | Non-Profit | Stamped | 0.05
920 | [NAME]. CLARITY FF | First | Regular | Permit | 0
925 | VFW | First | Regular | Metered | 0.39
929 | The Personal Marketing Co | First | Regular | Permit | 0
931 | Deluxe Check Printers | Standard | Regular | Permit | 0
934 | Unity NP Permit | Standard | Non-Profit | Permit | 0
937 | HH  GSK standard | Standard | Regular | Permit | 0
938 | HH 3 oz GSK | First | Regular | Permit | 0
939 | HH 2 oz GSK | First | Regular | Permit | 0
949 | CFCA Sacred Gr NP permit | Standard | Non-Profit | Permit | 0
967 | [NAME] | First | Regular | Metered | 0.414
975 | [NAME] CLARITY FF LATE | First | Regular | Permit | 0