`
`1111111111111111111111111111111111111111111111111111111111111
`US007912854B2
`
`c12) United States Patent
`Owens et al.
`
`(10) Patent No.:
`(45) Date of Patent:
`
`US 7,912,854 B2
`Mar.22,2011
`
`(54) REGISTRATION AND MAINTENANCE OF
`ADDRESS DATA FOR EACH SERVICE POINT
`IN A TERRITORY
`
`(75)
`
`Inventors: Timothy C. Owens, New Freedom, PA
`(US); Duane Anderson, Cockeysville,
`MD (US)
`
`(73) Assignee: United Parcel Service of America, Inc.
`
`( *) Notice:
`
`Subject to any disclaimer, the term of this
`patent is extended or adjusted under 35
`U.S.C. 154(b) by 299 days.
`
`(21) Appl. No.: 12/270,665
`
`(22) Filed:
`
`Nov. 13, 2008
`
`(65)
`
`Prior Publication Data
`
`US 2009/0182743 Al
`
`Jul. 16, 2009
`
`Related U.S. Application Data
`
`(63) Continuation of application No. 111342,041, filed on
`Jan. 27, 2006, now Pat. No. 7,542,972.
`
`(60) Provisional application No. 60/648,577, filed on Jan.
`28,2005.
`
`(51)
`
`Int. Cl.
`G06F 17130
`(2006.01)
`(52) U.S. Cl. ........................................ 707/776; 705/400
`(58) Field of Classification Search . ... ... ... ... .. ... 707/77 6,
`707/758, 769, 770, 773; 705/1
`See application file for complete search history.
`
`(56)
`
`References Cited
`
`U.S. PATENT DOCUMENTS
`4,832,204 A *
`5/1989 Handy eta!. ................... 209/3.3
`4,839,813 A *
`6/1989 Hills eta!. .................... 705/404
`5,262,939 A *
`1111993 Vanpoucke ................... 705/330
`5,387,783 A
`2/1995 Mihm eta!.
`6/1995 Allen et al.
`5,422,821 A
`
`5,452,203 A
`5,710,917 A
`5,754,671 A
`5,758,574 A
`5,905,666 A
`5,953,427 A
`5,963,642 A
`
`9/1995 Moore
`111998 Musa et a!.
`511998 Higgins et a!.
`6/1998 Bernardo et a!.
`5/1999 Hoffman eta!.
`9/1999 Cordery et al.
`10/1999 Goldstein
`(Continued)
`
`EP
`
`FOREIGN PATENT DOCUMENTS
`1 197 885
`12/2001
`(Continued)
`
`OTHER PUBLICATIONS
`
`Haderle, D.J., et a!.; "IBM Database 2 Overview;" IBM Systems
`Journal, IBM Corporation; Armonk, New York; vol. 23, No. 2
`(1984), pp. 112-125.
`
`(Continued)
`
`Primary Examiner- John R. Cottingham
`Assistant Examiner- SheriefBadawi
`(74) Attorney, Agent, or Firm- Alston & Bird LLP
`
`ABSTRACT
`(57)
`A computer system and method is disclosed for mining cur(cid:173)
`rent and archived address data in order to identifY a preferred
`address for each service point in a territory. The data mining
`system may start in response to the presentation of a candidate
`address for matching. The set of mined data may be priori(cid:173)
`tized by clustering like characteristics, building similarity
`matrices, and by constructing dendrograms with nodes joined
`according to common characteristics. A computer system and
`method for maintaining a central database of preferred
`addresses is also disclosed. Selected address data gathered in
`a queue may be scored by characteristic, grouped by con(cid:173)
`signee location, and staged for processing. The scored queue
`of data may be prioritized by clustering like characteristics,
`building similarity matrices, and by constructing dendro(cid:173)
`grams.
`
`18 Claims, 62 Drawing Sheets
`
`1ST ITERATION
`
`2ND ITERATION
`
`3RD ITERATION
`
`INHIBITING OUT-TO-TOLERANCE
`DELIVERY PATTERNS
`
`Page 1
`
`RMI EXHIBIT 2052
`CBM2014-00116
`
`
`
`US 7,912,854 B2
`Page 2
`
`U.S. PATENT DOCUMENTS
`5,978,792 A
`1111999 Bhargava et a!.
`6,131,101 A
`10/2000 Maitino eta!.
`6,205,447 B1
`3/2001 Malloy
`6,253,219 B1
`6/2001 Gardner et al.
`6,285,916 B1 * 9/2001 Kadaba eta!. ................ 700/222
`6,321,992 B1 * 1112001 Knowles et a!.
`......... 235/462.01
`8/2002 Hosken
`6,438,579 B1
`6,439,783 B1
`8/2002 Antoshenkov
`6,456,998 B1
`9/2002 Bui eta!.
`6,457,012 B1
`9/2002 Jatkowski
`6,463,420 B1
`10/2002 Guidice et a!.
`6,487,549 B1
`1112002 Amundsen
`6,502,089 B1
`12/2002 Amundsen et a!.
`6,507,835 B1
`112003 Amundsen et a!.
`6,557,000 B1
`4/2003 Seestrom et al.
`6,564,204 B1
`5/2003 Amundsen et a!.
`6,575,376 B2
`6/2003 Yu
`6,647,385 B2
`1112003 Seestrom et al.
`6,681,391 B1
`112004 Marino
`6,772,130 B1 * 8/2004 Karbowski et a!. ............. 705/26
`6,873,963 B1 * 3/2005 Westbury et a!. ................. 705/8
`6,931,418 B1
`8/2005 Barnes
`1112005 Hungerpiller et al.
`6,826,548 B2
`7,069,253 B2 * 6/2006 Leon ............................. 705/408
`7,213,748 B2 * 5/2007 Tsuei et al.
`................... 235/380
`200110043599 A1
`1112001 Redmond
`200110054031 A1
`12/2001 Lee et al.
`2002/0016726 A1
`212002 Ross
`2002/0032612 A1
`3/2002 Williams et a!.
`2002/0065815 A1
`5/2002 Layden
`2002/0078024 A1
`6/2002 Bellamy et a!.
`2002/0124015 A1
`9/2002 Cardno et al.
`2002/0153409 A1
`10/2002 Yu
`2002/0174148 A1
`1112002 Seidman
`2002/0184497 A1 * 12/2002 Gage eta!. .................... 713/168
`2003/0009396 A1 *
`112003 DeVries et al. ................. 705/28
`
`112003 Robertson ......................... 707/6
`4/2003 Murakami eta!.
`12/2003 Kadaba eta!. .................... 705/6
`4/2004 Willoughby ............... 707/104.1
`9/2004 Payne eta!. ................... 714/746
`10/2004 Cornelius ......................... 707/1
`1112004 Kapochunas et a!.
`2/2005 Hilbush eta!. ................ 705/402
`1112005 Robbins ........................ 707/100
`112006 Kim et al .......................... 707/3
`9/2006 Miller et a!.
`...................... 705/7
`
`2003/0014408 A1 *
`2003/0074213 A1
`2003/0236688 A1 *
`2004/0083233 A1 *
`2004/0177305 A1 *
`2004/0215588 A1 *
`2004/0225543 A1
`2005/0038758 A1 *
`2005/0246359 A1 *
`2006/0010110 A1 *
`2006/0212326 A1 *
`FOREIGN PATENT DOCUMENTS
`408323299
`12/1996
`W0-96/34354
`10/1996
`wo 01106414
`1/2001
`W02005/050481
`2/2005
`wo 2006/083694
`10/2006
`OTHER PUBLICATIONS
`
`JP
`wo
`wo
`wo
`wo
`
`Pooch, U.W., et a!.; "A Survey of Indexing Techniques for Sparse
`Matrices;" Computing Surveys; vol. 5, No.2 (Jun. 1973); pp. 109-
`122.
`Fernandez, et al. "Analysis Patterns for the Order and Shipment of
`Product," Department of Computer Science and Engineering, Florida
`Atlantic University, 2000.
`Hu, et al., "A Data Warehouse/Online Analytic Processing Frame(cid:173)
`work for Web Usage Mining and Business Intelligence Reporting,"
`International Journal of Intelligent Systems, 2004, pp. 585-606, vol.
`19.
`Extended European Search Report for European Patent Application
`No. 06719627.9 mailed Jul. 27, 2009.
`International Search Report and Written Opinion for International
`Application No. PCT/US 06/02843 mailed Sep. 25, 2007 .
`* cited by examiner
`
`Page 2
`
`
`
`Maintenance System 10--.
`
`Shipping
`Application 22
`
`Package-Level Detail
`Database 20
`
`Field Input
`Device 35
`
`Archive of Actual
`Delivery Records 30
`
`Initial Data Gathering Step 305
`for a Location
`
`Initial Processing Steps
`310,320,330
`
`~Registration
`Process 300
`
`~
`00
`•
`~
`~
`~
`
`~ = ~
`
`Sources 110 of Address
`Data
`
`Applications 16
`
`Address
`Database
`100
`
`Address
`Database
`Administrator
`200
`
`····-------------------------------------------------------
`
`eve! Detail
`3Se 20
`
`Archive of Actual
`Delivery Records 30
`
`Matching System 12 "")
`
`:herino Step 405 for
`and Maintenance
`
`Maintenance Processing
`Steps 410, 420, 430
`
`i'l-Maintenance
`;
`Process 400
`
`Applications 16
`
`Address Query 510
`
`Execution Step
`520
`
`Address Interpretations Step 530
`
`Applications 16
`
`_flgJ
`
`~
`~ :-:
`N
`N
`N
`
`0 ....
`....
`
`~
`
`('D
`('D
`
`rFJ =(cid:173)
`.....
`....
`0 .....
`0\
`N
`
`d
`rJl
`-....l
`\c
`""""' N
`Oo u.
`~ = N
`
`Page 3
`
`
`
`["a AMS Database Administration
`
`Customer Registration lnformatio
`
`bl~~
`J::!elp
`
`Company Name: Costco Connection
`Receiving Location: Brookstone Store 25
`Address:
`3333 Bristol Street' South Coast Plaza MaiiMCosta Mesa CA 92626A
`Reg. Date: I
`Location Configuration: Multi-Tenant ShoppinQ/Strip Mall
`
`False Positive Rate-
`Match Oat
`Projected:~% Projected:c:::=Q]%
`Current:CQ]J% Current:CQ]J%
`
`Comments: This consignee also receive packages for Brookstone Store I Mining Status: I 4-Mining Complete Minimum Expected Match Rate C]"f}%
`
`Deferral Reason:
`
`number 15
`
`Status: 1
`
`1-'enmng
`
`~
`7J).
`•
`~
`~
`~
`
`~ = ~
`
`~
`~ :-:
`
`N
`N
`
`~
`
`I o 1 2 1 39o \ s4sl 1 17\
`
`[fu]Jo;o RM.OO
`
`.
`
`Co-Delivered
`Most common combination '8QQMLAKE'DRMAISSAQUAW98027MUS' ,CHRISTENSEN, D, BURBANK (1%)
`Most common recorded Delivery Address '999MLAKE'DR'MISSAQUAHA98027MUS'(57%)
`
`'
`
`Join Reason:
`
`Most common combination
`Most common recorded Delivery Address
`
`Sub Group Action: I
`
`IYI
`
`Grouping Confidence: 1
`
`Outcome: I
`
`I
`
`+ v 1 COSTCO'SEAN MCCENERNEY'999 LAKE DRM'ISSAQUAWWA'98027
`+ v 1 COSTCO'QUALITY ASSURANCE DEPARTMENT/SHERA9QO LAKE DRIVEMAISSAQUAH'WAA98027
`l:±:J v 1 COSTCO'BECKY SA1Q45 LAKE DRIVE'MISSAQUAH'WN98027
`v 1 COSTCO'A TTN ALLEN WEBSTER'1 045 LAKE DRMAISSAQUAWWAA98027
`v 2 COSTCQABECKY SCHMIDP1045 LAKE DRAMISSAQUAHAWN98027
`+ v 1 COSTCO'CORPORATE OFFICEM999 LAKE DRIVE'MISSAQUAWWN98027
`+ v 1 COSTCQACORPORATE OFFICEMCOSTCO CORPORATE OFFICE'999 LAKE DRM'ISSAQUAH'WA'98027
`+ v 1 COSTCO WHOLEM999 LAKE DRAMISSAQUAH'WN98027
`+ v 1 COSTCOWHOLESALEMATTN:MICHELLE HUSHBY'SMALL ELECTRIC$'999 LAKE DRIVPMISSAQUAH'WN98027
`
`A-Add
`A-Add
`A-Add
`A-Add
`A-Add
`
`...
`
`I View Registration Information I
`
`I Accept I I Delete I I Reject Registration
`
`I FIG. 2
`
`I Skip
`
`I
`
`Unit of Work loading complete
`
`N
`
`0 ....
`....
`
`('D
`('D
`
`rFJ =(cid:173)
`.....
`N
`0 .....
`0\
`N
`
`d
`rJl
`-....l
`\c
`""'"' N
`Oo
`U"l
`
`~ = N
`
`l'f ....
`....
`....
`....
`....
`....
`....
`....
`I Jill'
`
`Page 4
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 3 of 62
`
`US 7,912,854 B2
`
`Begin Initial
`Data
`Gathering
`Step 305
`
`Step 60:
`Assign a
`Mining Key
`40 to
`Candidate
`Location
`
`~~~~~~--------------
`
`Step 62:
`Retrieve List
`of Tracking
`Numbers 34
`for Similar
`Delivery
`Patterns
`~~~----====~--------------
`
`Archive of
`Actual
`Delivery
`Records
`30
`
`Step 68: Find
`Tracking
`Number 34 for
`Each Parcel
`having the
`same Ship-To
`Address
`
`Package-Level
`Detail
`Database 20
`
`Package-Level
`Detail
`Database 20
`
`Step 64: Find
`Ship-To
`Address 22 for
`Each Tracking
`Number 34
`
`Step 66: Filter
`List of Ship-To
`Addresses 22
`
`Step 70:
`Build Set
`of Mined
`Data
`
`_Eig. 3
`
`Page 5
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 4 of 62
`
`US 7,912,854 B2
`
`Begin of Initial Data Gathering Output Message
`Consignee Token
`Termination Reason {pass max, ship-to count slowed, max'd del patt growth)
`Record 1
`Count
`Outcome Va!ue="Missed/Missedlate/MissedNoOPLD"
`Delivery Pattern
`Driver ID
`Driver Name
`Stop ID
`Signat Clarify
`Delivery Date
`Delivery Status
`Delivery Stop Status
`Over-ride Flag
`Remarks
`Loop
`sue
`Reg/Dist
`Ship To Address, or Null if not Avail.
`End Record 1
`
`]
`
`Record 2
`I
`End Record. 2
`I Record m
`
`End Record: m
`End of Initial Data Gatherin
`
`Fig. 4
`
`Page 6
`
`
`
`~
`00
`•
`~
`~
`~
`
`~ = ~
`
`~
`~ :-:
`
`N
`N
`
`~
`
`Mining ~ey 40
`
`N
`
`0 ....
`....
`
`('D
`('D
`
`rFJ =(cid:173)
`.....
`Ul
`0 .....
`0\
`N
`
`d
`rJl
`-....l
`\c
`""""' N
`Oo
`u.
`
`~ = N
`
`FIG. 5
`
`Page 7
`
`
`
`1ST ITERATION
`
`2ND ITERATION
`
`3RD ITERATION
`
`~
`00
`•
`~
`~
`~
`
`~ = ~
`
`Sig/SLIC-1 I
`
`Sig/SLIC-2
`Sig/SLIC-3
`Drvr-1
`Drvr-2
`PC-1
`=::-11/
`
`I -. ~-
`
`I~ "DP
`
`II
`•••
`
`I
`I
`I
`I
`
`I
`
`urvr-!J!J
`
`\.
`
`I
`
`INHIBITING OUT-TO-TOLERANCE
`DELIVERY PATTERNS
`
`FIG. 6
`
`~
`'"I .
`
`~
`
`N
`N
`
`~
`
`N
`
`0 ....
`....
`
`('D
`
`rFJ =-('D
`.....
`0\
`0 .....
`0\
`N
`
`d
`rJl
`-....l
`\c
`""""' N
`Oo
`u.
`
`~ = N
`
`Page 8
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 7 of 62
`
`US 7,912,854 B2
`
`Mining Key 40
`
`Tracking
`Number
`
`1Z .. Y .. 902
`
`Delivery
`Pattern
`Code
`JZJ
`
`ITERATION #1
`Step 68: Find Tracking
`Step 62: Retrieve List of
`Numbers for Each Parcel
`Tracking Numbers with the
`having the Same Ship-To
`Same Delivery Pattern Code as Address as the Records Found
`the Mining Key 40
`in Step 62
`Packages Found:
`
`·-~
`
`41
`
`Packages Found:
`
`20
`
`Unique Ship-to
`Addresses:
`Delivery
`Pattern
`Code
`
`Tracking
`Number
`
`8
`
`Unique Ship-to
`Addresses:
`
`Ship-To
`Address
`
`Tracking
`Number
`
`Ship-To
`Address
`
`8
`
`Delivery
`Pattern
`Code
`
`----------- --
`
`J2J
`12 .. K .. 286
`12 .. 0 .. 664 J2J
`J2J
`12 .. A .. 990
`12 .. 0 .. 243
`J2J
`
`1Z .. 0 .. 100 J2J
`1Z .. J .. 253
`JZJ
`
`1Z .. G .. 955 JZJ
`1Z .. A..337
`J2J
`
`_Elg. 7-1
`
`F
`R
`H
`N
`
`B
`D
`
`H
`N
`
`12 .. K .. 286
`12 .. 0 .. 664
`1Z .. A .. 990
`12 .. 0 .. 243
`
`12 .. M .. 671
`
`12 .. W.A31
`
`1Z .. 0 .. 633
`1Z .. L .. 220
`1Z .. H .. 117
`12 .. K .. 555
`1Z .. 0 .. 100
`1Z .. J .. 253
`
`1Z .. E .. 141
`1Z .. G .. 955
`1Z .. A .. 337
`1Z .. L .. 569
`1Z .. B .. 505
`
`1Z .. W .. 633
`
`F
`R
`H
`N
`
`B
`
`B
`
`H
`N
`Q
`s
`B
`D
`
`N
`H
`N
`B
`D
`
`D
`
`J2J
`J2J
`J2J
`J2J
`
`TKI
`
`TKI
`
`OZK
`02K
`OZK
`02K
`JZJ
`JZJ
`
`TKI
`J2J
`JZJ
`02K
`OZK
`
`OZK
`
`Page 9
`
`
`
`U.S. Patent
`
`Mar. 22, 2011
`
`Sheet 8 of 62
`
`US 7,912,854 B2
`
`1Z .. Z .. 283
`1Z .. U .. 720
`1Z .. M .. 722
`1Z .. G .. 892
`
`JZJ
`JZJ
`JZJ
`JZJ
`
`1Z .. D .. 139
`1Z .. Z .. 283
`1Z .. U .. 720
`1Z .. M .. 722
`1Z .. G .. 892
`
`B
`F
`F
`s
`
`1Z .. T..463
`
`1Z .. Y .. 122
`1Z .. S .. 503
`
`I
`
`1Z .. U .. 270
`1Z .. D .. 991
`1Z .. K .. 137
`1Z .. K .. 541
`
`JZJ
`JZJ
`JZJ
`JZJ
`
`1Z .. J .. 802
`1Z .. A .. 526
`
`JZJ
`JZJ
`
`1Z .. Y .. 902
`12 .. 1..465
`
`JZJ
`JZJ
`
`'
`
`1Z .. D .. 566
`1Z .. U .. 270
`1Z .. D .. 991
`1Z .. K .. 137
`1Z .. K .. 541
`1Z .. Y .. 504
`1Z .. P..490
`1Z .. J .. 802
`1Z .. A .. 526
`12 .. 0 .. 698
`1Z .. L .. 504
`1Z .. Y .. 902
`1Z .. I . .465
`
`Q
`s
`F
`s
`
`B
`N
`
`8
`D
`
`D
`B
`F
`F
`s
`
`Q
`
`B
`D
`
`R
`Q
`s
`F
`s
`Q
`8
`8
`N
`H
`N
`8
`D
`
`OZK
`JZJ
`JZJ
`JZJ
`JZJ
`
`OZK
`
`OZK
`OZK
`
`PMY
`JZJ
`JZJ
`JZJ
`JZJ
`OZK
`OZK
`JZJ
`JZJ
`OZK
`OZK
`JZJ
`JZJ
`
`· · -
`
`1Z .. K .. 204
`1Z .. M .. 237
`
`D
`H
`
`TKI
`TKI
`
`_flg. 7-2
`
`Page 10
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 9 of 62
`
`US 7,912,854 B2
`
`Step 62: Retrieve List of
`Tracking Numbers with the
`Same Delivery Pattern Code as
`the Mining Key 40
`
`ITERATION #2
`Step 68: Find Tracking
`Numbers for Each Parcel
`having the Same Ship-To
`Address as the Records Found
`in Step 62
`Packages Found:
`
`61
`
`64
`
`Packages Found:
`
`Unique Ship-to
`Addresses:
`Delivery
`Pattern
`Code
`
`Tracking
`Number
`
`12 .. C .. 460 TKI
`12 .. N .. 217 TKI
`
`J2J
`12 .. K .. 286
`J2J
`12 .. 0 .. 664
`JZJ
`12 . .A..990
`12 . .0 .. 243
`JZJ
`1Z .. E .. 826 TKI
`12 .. M .. 671
`TKI
`12 .. 8 .. 119 TKI
`1Z .. W..431 TKI
`
`12 .. W .. 325 TKI
`12 .. U .. 568 TKI
`12 .. 0 .. 633 02K
`12 .. L .. 220
`02K
`1Z .. H .. 117 OZK
`12 .. K .. 555 02K
`12 .. 0 .. 100
`JZJ
`12 .. J .. 253
`JZJ
`12 .. E . .200 TKI
`1Z .. E .. 141
`TKI
`12 .. G .. 955
`JZJ
`12 .. A .. 337
`J2J
`12 .. L .. 569
`02K
`12 .. 8 .. 505 OZK
`1Z .. W .. 585 OZK
`12 .. W .. 633 OZK
`
`1Z .. W .. 356 OZK
`
`12
`
`Unique Ship-to
`Addresses:
`
`Ship-To
`Address
`
`Tracking
`Number
`
`Ship-To
`Address
`
`12
`
`Delivery
`Pattern
`Code
`
`A
`c
`
`F
`R
`H
`N
`A
`B
`A
`B
`
`L
`M
`H
`N
`Q
`s
`B
`D
`L
`N
`H
`N
`B
`D
`c
`D
`
`c
`
`-
`
`12 .. C .. 460
`12 .. N .. 217
`
`12 .. K .. 286
`12 .. 0 .. 664
`12 .. A..990
`12 . .0 .. 243
`1Z .. E .. 826
`12 .. M .. 671
`12 .. 8 .. 119
`1Z .. W .. 431
`12 .. S .. 473
`12 .. C . .429
`1Z .. W .. 325
`12 .. U .. 568
`12 .. 0 .. 633
`12 .. L .. 220
`1Z .. H .. 117
`1Z .. K .. 555
`12 .. 0 .. 100
`12 .. J .. 253
`1Z .. E .. 200
`12 .. E .. 141
`12 .. G .. 955
`12 . .A..337
`12 .. L .. 569
`12 .. 8 .. 505
`12 .. W .. 585
`12 .. W .. 633
`
`1Z .. W .. 356
`
`A
`c
`
`F
`R
`H
`N
`A
`B
`A
`8
`A
`c
`L
`M
`H
`N
`Q
`s
`B
`D
`L
`N
`H
`N
`B
`D
`c
`D
`
`c
`
`TKI
`TKI
`
`J2J
`J2J
`J2J
`J2J
`TKI
`TKI
`TKI
`TKI
`vus
`vus
`TKI
`TKI
`OZK
`02K
`OZK
`02K
`J2J
`JZJ
`TKI
`TKI
`J2J
`J2J
`OZK
`OZK
`OZK
`02K
`
`OZK
`
`_fig. 7-3
`
`Page 11
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 10 of 62
`
`US 7,912,854 B2
`
`12 . .0 .. 139 02K
`12 . .Z .. 283
`J2J
`12 .. U .. 720
`JZJ
`12 .. M .. 722
`J2J
`JZJ
`12 .. G .. 892
`12 .. H .. 309 TKI
`12 .. R .. 975 TKI
`12 .. T .. 177
`02K
`12 .. T . .463
`02K
`
`12 .. Y .. 122 OZK
`02K
`12 .. 8 .. 503
`
`TKI
`12 .. T .. 838
`TKI
`12 .. K .. 851
`12 .. 0 .. 352 TKI
`12 .. A .. 825
`TKI
`12 .. Y .. 506 PMY
`12 . .0 .. 566 PMY
`1Z .. U .. 270
`J2J
`12 .. 0 .. 991
`J2J
`1Z .. K .. 137
`JZJ
`1Z .. K .. 541
`J2J
`12 .. Y .. 504 OZK
`12 .. P .. 490 OZK
`12 .. J .. 802
`JZJ
`J2J
`1Z .. A .. 526
`12 .. 0 .. 698 02K
`12 .. L .. 504
`02K
`12 .. Y .. 902
`J2J
`12 .. 1..465
`J2J
`
`1Z .. W .. 960 PMY
`1Z .. P .. 390 PMY
`12 .. 0 .. 252 TKI
`1Z .. K .. 204 TKI
`12 .. M .. 237 TKI
`
`0
`8
`F
`F
`s
`L
`M
`A
`Q
`
`8
`0
`
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`8
`N
`H
`N
`8
`0
`
`A
`c
`c
`0
`H
`
`12 .. 0 .. 139
`12 . .Z .. 283
`12 .. U .. 720
`12 .. M .. 722
`1Z .. G .. 892
`12 .. H .. 309
`12 .. R .. 975
`1Z .. T .. 177
`12 .. T..463
`
`1Z .. Y .. 122
`12 .. 8 .. 503
`12 .. 0 .. 530
`
`12 .. T .. 838
`12 .. K .. 851
`12 .. 0 .. 352
`12 . .A..825
`12 .. Y .. 506
`12 .. 0 .. 566
`1Z .. U .. 270
`12 .. 0 .. 991
`12 .. K .. 137
`12 .. K .. 541
`12 .. Y .. 504
`1Z .. P..490
`1 2 .. J .. 802
`12 .. A .. 526
`12 .. 0 .. 698
`12 .. L .. 504
`12 .. Y .. 902
`1 2 .. 1..465
`
`12 .. W .. 960
`12 .. P .. 390
`12 .. 0 .. 252
`12 .. K .. 204
`12 .. M .. 237
`
`D
`8
`F
`F
`s
`L
`M
`A
`Q
`
`8
`0
`M
`
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`8
`N
`H
`N
`8
`D
`
`A
`c
`c
`D
`H
`
`02K
`J2J
`J2J
`J2J
`J2J
`TKI
`TKI
`02K
`02K
`
`02K
`02K
`CUL
`
`TKI
`TKI
`TKI
`TKI
`PMY
`PMY
`JZJ
`JZJ
`JZJ
`J2J
`02K
`OZK
`JZJ
`J2J
`02K
`I 02K
`J2J
`J2J
`
`PMY
`PMY
`TKI
`TKI
`TKI
`
`__Elg. 7-4
`
`Page 12
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 11 of 62
`
`US 7,912,854 B2
`
`Step 62: Retrieve List of
`Tracking Numbers with the
`Same Delivery Pattern Code as
`the Mining Key 40
`
`ITERATION # 3
`Step 68: Find Tracking
`Numbers for Each Parcel
`having the Same Ship-To
`Address as the Records Found
`in Step 62
`Packages Found:
`
`73
`
`77
`
`Packages Found:
`
`Unique Ship-to
`Addresses:
`Delivery
`Tracking
`Pattern
`Number
`Code
`12 .. R..350 vus
`12 .. 1 .. 758 vus
`12 .. C .. 460 TKI
`12 .. N .. 217 TKI
`12 .. N .. 479 vus
`12 .. R..480 vus
`12 .. K .. 286
`J2J
`12 .. 0 .. 664
`J2J
`12 .. A .. 990
`J2J
`12 . .0 .. 243
`J2J
`12 .. E .. 826 TKI
`TKI
`12 .. M .. 671
`12 .. 8 .. 119 TKI
`12 .. W . .431 TKI
`12 .. 5 .. 473 vus
`12 .. C .. 429 vus
`12 .. W .. 325 TKI
`12 .. U .. 568 TKI
`12 .. 0 .. 633 OZK
`12 . .L..220 OZK
`12 .. H .. 117 02K
`12 .. K .. 555 OZK
`12 .. 0 .. 100
`JZJ
`12 .. J .. 253
`J2J
`12 .. E..200 TKI
`1Z .. E..141
`TKI
`1Z .. G .. 955
`JZJ
`1Z .. A .. 337
`JZJ
`12 .. L .. 569
`02K
`12 .. 8 .. 505 02K
`12 .. W .. 585 02K
`1Z . .W .. 633 OZK
`
`12 .. W .. 356 02K
`
`15
`
`Unique Ship-to
`Addresses:
`
`Ship-To
`Address
`
`Tracking
`Number
`
`Ship-To
`Address
`
`E
`G
`A
`c
`E
`G
`F
`R
`H
`N
`A
`B
`A
`B
`A
`c
`L
`M
`H
`N
`Q
`s
`8
`D
`L
`N
`H
`N
`B
`D
`c
`D
`
`c
`
`12 .. R.350
`12 .. 1..758
`12 .. C . .460
`12 .. N .. 217
`12 .. N .. 479
`12 .. R.480
`12 .. K .. 286
`12 .. 0 .. 664
`12 .. A .. 990
`12 .. D .. 243
`12 .. E..826
`12 .. M .. 671
`12 .. 8 .. 119
`12 .. W . .431
`12 .. 5 . .473
`12 .. C . .429
`12 .. W .. 325
`12 .. U .. 568
`12 .. 0 .. 633
`12 . .L..220
`12 .. H .. 117
`12 .. K..555
`12 .. 0 .. 100
`1Z .. J .. 253
`1Z .. E .. 200
`1Z .. E .. 141
`12 .. 8 .. 955
`1Z . .A..337
`12 .. L..569
`12 .. 8 .. 505
`12 .. W .. 585
`12 .. W .. 633
`1Z .. N .. 863
`1Z .. Q .. 579
`1Z .. W .. 356
`
`E
`G
`A
`c
`E
`G
`F
`R
`H
`N
`A
`B
`A
`8
`A
`c
`L
`M
`H
`N
`Q
`s
`8
`D
`L
`N
`H
`N
`8
`D
`c
`D
`E
`G
`c
`
`15
`
`Delivery
`Pattern i
`Code
`vus
`vus
`TKI
`TKI
`vus
`vus
`J2J
`J2J
`J2J
`J2J
`TKI
`TKI
`TKI
`TKI
`vus
`vus
`TKI
`TKI
`OZK
`02K
`02K
`OZK
`J2J
`J2J
`TKI
`TKI
`J2J
`JZJ
`02K
`02K
`OZK
`02K
`YTM
`YTM
`OZK
`
`_flg. 7-5
`
`Page 13
`
`
`
`U.S. Patent
`
`Mar. 22, 2011
`
`Sheet 12 of 62
`
`US 7,912,854 B2
`
`1Z .. D .. 139 OZK
`1Z .. Z .. 283
`JZJ
`1Z .. U .. 720
`JZJ
`1Z .. M .. 722
`JZJ
`1Z .. G .. 892
`JZJ
`1Z .. H .. 309 TKI
`1Z .. R..975 TKI
`1Z .. T .. 177 OZK
`1Z .. T .. 463 OZK
`
`1Z .. Y .. 122 OZK
`1Z .. S .. 503 OZK
`1Z .. 0 .. 530 CUL
`1Z .. T .. 481
`CUL
`1Z .. T .. 838
`TKI
`TKI
`1Z .. K .. 851
`1Z . .D .. 352 TKI
`1Z .. A .. 825 TKI
`1Z .. Y .. 506 PMY
`1Z .. D .. 566 PMY
`1Z .. U .. 270
`JZJ
`1Z .. D .. 991
`JZJ
`1Z .. K .. 137
`JZJ
`1Z .. K .. 541
`JZJ
`12 .. Y .. 504
`02K
`1Z .. P .. 490 OZK
`1Z .. J .. 802
`JZJ
`1Z .. A .. 526
`JZJ
`12 .. 0 .. 698 OZK
`1Z .. L .. 504 OZK
`1Z .. Y .. 902
`JZJ
`JZJ
`12 .. 1 .. 465
`12 .. L..889 vus
`12 .. 0 .. 621 vus
`12 .. W .. 960 PMY
`12 .. P .. 390 PMY
`12 .. 0 .. 252 TKI
`1Z .. K .. 204
`TKI
`12 .. M .. 237 TKI
`12 .. T .. 132 vus
`12 .. 0 .. 475 vus
`
`D
`B
`F
`F
`s
`L
`M
`A
`Q
`
`B
`D
`M
`u
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`B
`N
`H
`N
`8
`D
`E
`G
`A
`c
`c
`D
`H
`E
`G
`
`1Z .. D .. 139
`1Z .. Z .. 283
`1Z .. U .. 720
`1Z .. M .. 722
`1Z .. G .. 892
`1Z .. H .. 309
`1Z .. R .. 975
`1Z .. T .. 177
`1 Z .. T . .463
`1Z .. G .. 953
`1Z .. E .. 616
`1Z .. Y .. 122
`1Z .. S .. 503
`1Z .. 0 .. 530
`1Z .. T . .481
`1Z .. T .. 838
`1Z .. K .. 851
`1Z .. D .. 352
`1Z .. A .. 825
`1Z .. Y .. 506
`1Z .. D .. 566
`1Z .. U .. 270
`1Z .. D .. 991
`1Z .. K .. 137
`1Z .. K .. 541
`1Z .. Y .. 504
`1Z .. P . .490
`1Z .. J .. 802
`1Z .. A .. 526
`12 .. 0 .. 698
`1Z .. L .. 504
`1Z .. Y .. 902
`1Z .. I..465
`1Z .. L..889
`1Z .. Q .. 621
`12 .. W .. 960
`12 .. P .. 390
`1Z .. 0 .. 252
`1Z .. K .. 204
`1Z .. M .. 237
`1Z .. T .. 132
`1Z .. D .. 475
`
`D
`B
`F
`F
`s
`L
`M
`A
`Q
`E
`G
`B
`D
`M
`u
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`B
`N
`H
`N
`8
`D
`E
`G
`A
`c
`c
`D
`H
`E
`G
`
`OZK
`JZJ
`JZJ
`JZJ
`JZJ
`TKI
`TKI
`OZK
`OZK
`CEP
`CEP
`OZK
`OZK
`CUL
`CUL
`TKI
`TKI
`TKI
`TKI
`PMY
`PMY
`JZJ
`JZJ
`JZJ
`JZJ
`OZK
`OZK
`JZJ
`JZJ
`OZK
`02K
`JZJ
`JZJ
`vus
`vus
`PMY
`PMY
`TKI
`TKI
`TKI
`vus
`vus
`
`!
`
`_flg. 7-6
`
`Page 14
`
`
`
`U.S. Patent
`
`Mar. 22, 2011
`
`Sheet 13 of 62
`
`US 7,912,854 B2
`
`Step 62: Retrieve List of
`Tracking Numbers with the
`Same Delivery Pattern Code as
`the Mining Key 40
`
`ITERATION # 4
`Step 68: Find Tracking
`Numbers for Each Parcel
`having the Same Ship-To
`Address as the Records Found
`in Step 62
`Packages Found:
`
`77
`
`77
`
`Packages Found:
`
`Unique Ship-to
`Addresses:
`Delivery
`Tracking
`Pattern
`Number
`Code
`12 .. R .. 350 vus
`vus
`12 .. 1 .. 758
`12 .. C .. 460 TKI
`12 .. N .. 217 TKI
`12 .. N .. 479 vus
`12 .. R .. 480 VUS
`1Z .. K .. 286
`J2J
`12 .. 0 .. 664
`J2J
`J2J
`12 .. A .. 990
`J2J
`1Z .. D .. 243
`12 .. E .. 826 TKI
`TKI
`12 .. M .. 671
`12 .. 6 .. 119 TKI
`12 .. W .. 431 TKI
`12 .. 8 . .473 vus
`1Z .. C..429 vus
`12 .. W .. 325 TKI
`1Z .. U .. 568 TKI
`12 .. 0 .. 633 OZK
`1Z .. L .. 220 OZK
`12 .. H .. 117 02K
`1Z .. K .. 555 02K
`12 .. 0 .. 100
`J2J
`12 .. J .. 253
`J2J
`12 .. E .. 200 TKI
`12 .. E .. 141
`TKI
`1Z .. G .. 955
`JZJ
`1Z .. A .. 337
`J2J
`1Z .. L .. 569 OZK
`12 .. 6 .. 505 02K
`1Z .. W .. 585 OZK
`1Z .. W .. 633 OZK
`1Z .. N .. 863 YTM
`12 .. 0 .. 579 YTM
`
`15
`
`Unique Ship-to
`Addresses:
`
`Ship-To
`Address
`
`Tracking
`Number
`
`Ship-To
`Address
`
`E
`G
`A
`c
`E
`G
`F
`R
`H
`N
`A
`B
`A
`B
`A
`c
`L
`M
`H
`N
`Q
`s
`B
`D
`L
`N
`H
`N
`B
`D
`c
`D
`E
`G
`
`12 .. R..350
`12 .. 1 .. 758
`12 .. C .. 460
`12 .. N .. 217
`12 .. N .. 479
`12 .. R .. 480
`12 .. K .. 286
`12 .. 0 .. 664
`12 .. A .. 990
`12 .. 0 .. 243
`1Z .. E .. 826
`12 .. M .. 671
`1Z .. B .. 119
`12 .. W .. 431
`12 .. S . .473
`12 .. C . .429
`12 .. W .. 325
`12 .. U .. 568
`1Z .. 0 .. 633
`12 .. L .. 220
`1Z .. H .. 117
`12 .. K .. 555
`12 .. 0 .. 100
`12 .. J .. 253
`1Z .. E .. 200
`1Z .. E .. 141
`1Z .. G .. 955
`12 .. A .. 337
`1Z .. L .. 569
`12 .. 8 .. 505
`1Z .. W .. 585
`1Z .. W .. 633
`1Z .. N .. 863
`12 .. 0 .. 579
`
`E
`G
`A
`c
`E
`G
`F
`R
`H
`N
`A
`B
`A
`B
`A
`c
`L
`M
`H
`N
`Q
`s
`B
`D
`L
`N
`H
`N
`B
`D
`c
`D
`E
`G
`
`15
`
`Delivery
`Pattern
`Code
`vus
`vus
`TKI
`TKI
`vus
`vus
`J2J
`J2J
`J2J
`JZJ
`TKI
`TKI
`TKI
`TKI
`vus
`vus
`TKI
`TKI
`02K
`02K
`02K
`OZK
`J2J
`JZJ
`TKI
`TKI
`J2J
`JZJ
`OZK
`OZK
`02K
`OZK
`YTM
`YTM
`
`_Eig. 7-7
`
`Page 15
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 14 of 62
`
`US 7,912,854 B2
`
`12 .. W .. 356 02K
`12 .. 0 .. 139 02K
`12 .. 2 .. 283
`J2J
`12 .. U .. 720
`J2J
`12 .. M .. 722
`J2J
`12 .. G .. 892
`J2J
`12 .. H .. 309 TKI
`12 .. R..975 TKI
`12 .. T..177
`02K
`12 .. T . .463
`02K
`12 .. G .. 953 CEP
`12 .. E .. 616 CEP
`12 .. Y .. 122 02K
`12 .. 8 .. 503 02K
`12 .. 0 .. 530 CUL
`CUL
`12 .. T . .481
`12 .. T..838 TKI
`12 . .K..851
`TKI
`12 .. 0 .. 352 TKI
`1Z .. A .. 825 TKI
`12 .. Y .. 506
`PMY
`PMY
`12 .. 0 .. 566
`12 .. U .. 270
`J2J
`J2J
`12 .. 0 .. 991
`12 .. K .. 137
`J2J
`12 .. K .. 541
`J2J
`12 .. Y .. 504 02K
`1Z .. P . .490 02K
`J2J
`12 .. J .. 802
`12 .. A .. 526
`JZJ
`12 .. 0 .. 698 02K
`12 .. L .. 504
`02K
`1Z .. Y .. 902
`JZJ
`12 .. 1 .. 465
`J2J
`12 .. L .. 889 vus
`12 .. 0 .. 621 vus
`12 .. W .. 960 PMY
`1Z .. P .. 390
`PMY
`12 .. 0 .. 252 TKI
`12 .. K .. 204 TKI
`1Z .. M .. 237 TKI
`12 .. T .. 132 vus
`1Z .. 0 .. 475 VUS
`
`c
`0
`B
`F
`F
`s
`L
`M
`A
`Q
`E
`G
`B
`0
`M
`u
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`B
`N
`H
`N
`B
`0
`E
`G
`A
`c
`c
`0
`H
`E
`G
`
`12 .. W .. 356
`12 .. 0 .. 139
`12 . .2 .. 283
`12 .. U .. 720
`1Z .. M .. 722
`12 .. G .. 892
`1Z .. H .. 309
`12 .. R..975
`12 .. T .. 177
`12 .. T . .463
`12 .. G .. 953
`12 .. E .. 616
`12 .. Y .. 122
`12 .. 8 .. 503
`12 .. 0 .. 530
`12 .. T . .481
`12 .. T..838
`12 .. K .. 851
`12 .. 0 .. 352
`12 .. A .. 825
`1Z .. Y .. 506
`12 .. 0 .. 566
`12 .. U .. 270
`12 .. 0 .. 991
`12 .. K .. 137
`12 .. K .. 541
`12 .. Y .. 504
`1Z .. P .. 490
`12 .. J .. 802
`1Z .. A .. 526
`12 .. 0 .. 698
`12 .. L.504
`12 .. Y .. 902
`12 .. 1 .. 465
`12 .. L .. 889
`12 .. 0 .. 621
`12 .. W .. 960
`1Z .. P .. 390
`12 .. 0 .. 252
`12 .. K .. 204
`1Z .. M .. 237
`1Z .. T..132
`1Z .. 0 .. 475
`
`c
`0
`B
`F
`F
`s
`L
`M
`A
`Q
`E
`G
`B
`0
`M
`u
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`B
`N
`H
`N
`B
`D
`E
`G
`A
`c
`c
`0
`H
`E
`G
`
`02K
`02K
`J2J
`J2J
`J2J
`J2J
`TKI
`TKI
`02K
`02K
`CEP
`CEP
`OZK
`02K
`CUL
`CUL
`TKI
`TKI
`TKI
`TKI
`PMY
`PMY
`J2J
`J2J
`J2J
`JZJ
`02K
`OZK
`JZJ
`JZJ
`02K
`02K
`JZJ
`J2J
`vus
`vus
`PMY
`PMY
`TKI
`TKI
`TKI
`vus
`vus
`
`_Elg. 7-8
`
`Page 16
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 15 of 62
`
`US 7,912,854 B2
`
`Table 1.
`Mined Data from Iteration #4
`(Sorted by Stop Identifier)
`
`-
`
`Ship-to
`Address
`E
`G
`A
`c
`E
`G
`F
`R
`H
`N
`A
`B
`A
`B
`--··-·-·-·-·
`A
`c
`L
`M
`H
`N
`Q
`s
`B
`D
`L
`N
`H
`N
`B
`D
`c
`D
`E
`G
`c
`D
`8
`
`Stop
`Identifier
`810
`810
`DOP
`DOP
`D5V
`D5V
`D70
`D70
`FOT
`FOT
`G2G
`G2G
`G21
`G21
`H4S
`H4S
`11R
`11R
`JOG
`JOG
`K91
`K91
`L21
`L21
`L8P
`L8P
`M3K
`M3K
`M9P
`M9P
`N2Q
`N2Q
`N4H
`N4H
`N4S
`N4S
`N8P
`
`·-·-··
`
`Delivery
`Tracking
`Driver
`Number
`RUIZ
`1Z .. R..350
`RU!Z
`1Z .. J..758
`1Z .. C .. 460 JANOVSKI
`1Z .. N .. 217 JANOVSKI
`1Z .. N .. 479
`SIMONS
`SIMONS
`1Z .. R..480
`1Z .. K .. 286
`JANOVSKI
`1Z .. 0 .. 664 JANOVSKI
`JANOVSKI
`1Z .. A..990
`1Z .. D .. 243 JANOVSKI
`1Z .. E .. 826
`SMITH
`1Z .. M .. 671
`SMITH
`1Z .. B .. 119 JANOVSKI
`JANOVSKI
`1Z .. W . .431
`1Z .. S .. 473 JANOVSKI
`1Z .. C . .429 JANOVSKI
`1Z .. W .. 325 JANOVSKI
`1Z .. U .. 568 JANOVSKI
`1Z .. 0 .. 633 JANOVSKI
`JANOVSKI
`1Z .. L..220
`1Z .. H .. 117 JANOVSKI
`JANOVSKI
`1Z .. K .. 555
`1Z .. 0 .. 100 JANOVSKI
`1Z .. J .. 253
`JANOVSKI
`1Z .. E .. 200 JANOVSKI
`JANOVSKI
`1Z .. E .. 141
`1Z .. G .. 955 JANOVSKI
`1Z .. A..337 JANOVSKI
`JANOVSKI
`1Z .. L..569
`1Z .. B .. 505 JANOVSKI
`BEATTY
`1Z .. W .. 585
`1Z .. W .. 633
`BEATTY
`SIMONS
`1Z .. N .. 863
`1Z .. Q .. 579
`SIMONS
`1Z .. W .. 356
`BEATTY
`BEATTY
`1Z .. D .. 139
`1Z .. Z .. 283
`JANOVSKI
`-------···---
`
`Delivery
`Pattern Code
`vus
`vus
`TKI
`TKI
`vus
`vus
`JZJ
`JZJ
`JZJ
`JZJ
`TKI
`TKI
`TKI
`TKI
`vus
`vus
`TKI
`TKI
`OZK
`OZK
`OZK
`OZK
`JZJ
`JZJ
`TKI
`TKI
`JZJ
`JZJ
`OZK
`OZK
`OZK
`OZK
`YTM
`YTM
`OZK
`OZK
`JZJ
`
`Signature
`Clarification
`Gramm
`Gramm
`Bergeron
`Bergeron
`Lloyd
`Llo_yd
`Choi
`Choi
`Amy
`Amy
`Amy
`Am_y
`Bergeron
`Bergeron
`Bergeron
`Bergeron
`Bergeron
`Ber-geron
`Amy
`Amy
`Bergeron
`Bergeron
`Amy
`Amy
`White
`White
`Smit
`Smit
`Bergeron
`Bergeron
`Bergeron
`Bergeron
`Chris
`Chris
`Bergeron
`Bergeron
`White
`
`_flg. 8-1
`
`Page 17
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 16 of 62
`
`US 7,912,854 B2
`
`--~---·-·---
`
`Ship-to
`Address
`F
`F
`s
`L
`M
`A
`Q
`E
`G
`B
`D
`M
`u
`A
`A
`A
`A
`L
`R
`Q
`s
`F
`s
`Q
`s
`B
`N
`H
`N
`B
`D
`E
`G
`A
`c
`c
`D
`H
`E
`G
`
`--·--·
`
`Stop
`Identifier
`N8P
`08E
`08E
`P4H
`P4H
`Q8W
`Q8W
`R1E
`R1E
`R1P
`R1P
`S3/
`S3/
`S4T
`S4T
`S4T
`S4T
`S9L
`S9L
`S9P
`S9P
`W1J
`W1J
`W4E
`W4E
`W4M
`W4M
`W5J
`W5J
`X5E
`X5E
`X9P
`X9P
`Y2F
`Y2F
`Y3B
`Y3B
`Y3B
`Y4S
`Y4S
`
`Delivery
`Tracking
`Driver
`Number
`1Z .. U .. 720 JANOVSKI
`1Z .. M322 JANOVSKI
`1Z .. G .. 892 JANOVSKI
`1Z .. H .. 309 JANOVSKI
`1Z .. R .. 975 JANOVSKI
`1Z .. T .. 177 JANOVSKI
`1Z .. T .. 463
`JANOVSKI
`1Z .. G .. 953
`RUIZ
`1Z .. E .. 616
`RUIZ
`1Z .. Y .. 122 JANOVSKI
`1Z .. S .. 503
`JANOVSKI
`1Z .. 0 .. 530
`SMITH
`1Z .. T..481
`SMITH
`1Z .. T .. 838
`JANOVSKI
`1Z .. K .. 851
`JANOVSKI
`1Z .. D .. 352 JANOVSKI
`1Z .. A .. 825 JANOVSKI
`1Z .. Y .. 506 JANOVSKI
`1Z .. D .. 566 JANOVSKI
`1Z .. U .. 270 JANOVSKI
`1Z .. D .. 991
`JANOVSKI
`1Z .. K .. 137 JANOVSKI
`1Z .. K .. 541
`JANOVSKI
`1Z .. Y .. 504 JANOVSKI
`1Z .. P .. 490 JANOVSKI
`1Z .. J .. 802
`JANOVSKI
`1Z .. A .. 526
`JANOVSKI
`1Z .. 0 .. 698 JANOVSKI
`1Z .. L .. 504
`JANOVSKI
`1Z .. Y .. 902 JANOVSKI
`1Z .. I .. 465
`JANOVSKI
`1Z .. L .. 889
`SIMONS
`1Z .. Q .. 621 l SIMONS
`1Z .. W .. 960 JANOVSKI
`1Z .. P .. 390 JANOVSKI
`1Z .. 0 .. 252 JANOVSKI
`1Z .. K .. 204 JANOVSKI
`1Z .. M .. 237 JANOVSKI
`SIMONS
`1Z .. T .. 132
`1Z .. D .. 475
`SIMONS
`
`Signature
`Delivery
`Pattern Code Clarification
`JZJ
`White
`Amy
`JZJ
`JZJ
`Amy
`TKI
`White
`TKI
`White
`OZK
`Amy
`OZK
`Amy
`CEP
`Yoe
`CEP
`Yoe
`OZK
`Amy
`OZK
`Amy
`CUL
`Davis
`Davis
`CUL
`TKI
`Bergeron
`TKI
`Bergeron
`TKI
`Bergeron
`TKI
`Bergeron
`PMY
`Bergeron
`PMY
`Bergeron
`JZJ
`Bergeron
`JZJ
`Bergeron
`JZJ
`Bergeron
`Bergeron
`JZJ
`OZK
`White
`White
`OZK
`JZJ
`Smit
`JZJ
`Smit
`Bergeron
`OZK
`OZK
`Bergeron
`JZJ
`Smit
`JZJ
`Smit
`vus
`Lloyd
`vus
`Lloyd
`PMY
`Brgeron
`Brgeron
`PMY
`TKI
`Bergeron
`Bergeron
`TKI
`Bergeron
`TKI
`vus
`Chris
`vus
`Chris
`
`_Elg. 8-2
`
`Page 18
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 17 of 62
`
`US 7,912,854 B2
`
`Table 2.
`Mined Data from Iteration #4
`(Sorted by Delivery Pattern Code)
`
`Ship-to
`Address
`E
`G
`M
`u
`B
`B
`B
`B
`D
`D
`F
`F
`F
`F
`H
`H
`N
`N
`N
`Q
`R
`s
`s
`s
`A
`B
`B
`c
`c
`D
`D
`D
`D
`H
`H
`N
`N
`
`--··--
`
`Stop
`Identifier
`R1E
`R1E
`S3/
`S31
`L21
`NBP
`W4M
`X5E
`L21
`X5E
`D?Q
`NBP
`OBE
`W1J
`FOT
`M3K
`FOT
`M3K
`W4M
`S9P
`D?Q
`OBE
`S9P
`W1J
`QBW
`M9P
`R1P
`N2Q
`N4S
`M9P
`N2Q
`N4S
`R1P
`JOG
`W5J
`JOG
`W5J
`
`Delivery
`Tracking
`Driver
`Number
`RUI2
`12 .. G .. 953
`12 .. E .. 616
`RUIZ
`SMITH
`1Z .. 0 .. 530
`SMITH
`1Z .. T . .481
`12 .. 0 .. 100 JANOVSKI
`12 . .Z .. 283
`JANOVSKI
`12 .. J .. 802
`JANOVSKJ
`12 .. Y .. 902 JANOVSKI
`12 .. J .. 253
`JANOVSKI
`JANOVSKI
`12 .. 1 .. 465
`12 .. K .. 286
`JANOVSKI
`12 .. U .. 720 JANOVSKI
`12 .. M .. 722 JANOVSKI
`1Z .. K .. 137 JANOVSKI
`12 .. A .. 990 JANOVSKI
`1Z .. G .. 955 JANOVSKI
`1Z .. D .. 243 JANOVSKI
`JANOVSKI
`12 .. A .. 337
`JANOVSKI
`1Z .. A .. 526
`12 .. U .. 270 JANOVSKI
`12 .. 0 .. 664 JANOVSKI
`12 .. G .. 892 JANOVSKI
`1Z .. D .. 991
`JANOVSKI
`12 .. K .. 541
`JANOVSKJ
`12 .. T .. 177
`JANOVSKI
`12 .. L .. 569
`JANOVSKI
`1Z .. Y .. 122 JANOVSKI
`1Z .. W .. 585
`BEATTY
`1Z .. W .. 356
`BEATTY
`12 .. B .. 505
`JANOVSKI
`1Z .. W .. 633
`BEATTY
`BEATTY
`1Z .. D .. 139
`1Z .. S .. 503
`JANOVSKI
`1Z .. 0 .. 633 JANOVSKI
`1Z .. 0 .. 698 JANOVSKI
`JANOVSKI
`1Z .. L..220
`1Z .. L .. 504
`JANOVSKI
`
`_flg. 8-3
`
`Delivery
`Pattern Code
`CEP
`CEP
`CUL
`CUL
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`J2J
`02K
`02K
`02K
`OZK
`02K
`02K
`OZK
`OZK
`OZK
`02K
`OZK
`OZK
`OZK
`
`Signature
`CIa rification
`Yoe
`Yoe
`Davis
`Davis
`Amy
`White
`Smit
`Smit
`Amy
`Smit
`Choi
`White
`Amy
`Bergeron
`Amy
`Smit
`Amy
`Smit
`Smit
`Bergeron
`Choi
`Amy
`Bergeron
`Bergeron
`Amy
`Bergeron
`Amy
`Bergeron
`Bergeron
`Bergeron
`Bergeron
`Bergeron
`Amy
`Amy
`Bergeron
`Amy
`Bergeron
`
`Page 19
`
`
`
`U.S. Patent
`
`Mar.22,2011
`
`Sheet 18 of 62
`
`US 7,912,854 B2
`
`Ship-to
`Address
`Q
`Q
`Q
`s
`s
`A
`c
`L
`R
`A
`A
`A
`A
`A
`A
`A
`B
`B
`c
`c
`D
`H
`L
`L
`L
`M
`M
`N
`A
`c
`E
`E
`E
`E
`G
`G
`G
`G
`E
`G
`
`Stop
`Identifier
`K91
`Q8W
`W4E
`K91
`W4E
`Y2F
`Y2F
`S9L
`S9L
`DOP
`G2G
`G21
`S4T
`S4T
`S4T
`S4T
`G2G
`G21
`DOP
`Y3B
`Y3B
`Y3B
`11R
`L8P
`P4H
`11R
`P4H
`L8P
`H4S
`H4S
`B1Q
`D5V
`X9P
`Y4S
`B1Q
`D5V
`X9P
`Y4S
`N4H
`N4H
`
`Delivery
`Tracking
`Driver
`Number
`1Z .. H .. 117 JANOVSKI
`1Z . .T .. 463
`JANOVSKI
`1Z .. Y .. 504 JANOVSKI
`1Z .. K .. 555 JANOVSKI
`12 .. P . .490 JANOVSKI
`12 .. W .. 960 JANOVSKI
`12 .. P .. 390 JANOVSKI
`1 2 .. Y .. 506
`JANOVSKI
`1Z .. D .. 566 JANOVSKI
`12 .. C .. 460 JANOVSKI
`12 .. E .. 826
`SMITH
`1 2 .. B .. 119 JANOVSKI
`12 .. T .. 838
`JANOVSKI
`12 .. K .. 851
`JANOVSKI
`12 .. 0 .. 352 JANOVSKI
`12 .. A .. 825
`JANOVSKI
`12 .. M .. 671
`SMITH
`12 .. W .. 431
`JANOVSKI
`1Z .. N .. 217 JANOVSKI
`12 .. 0 .. 252 JANOVSKI
`12 .. K .. 204
`JANOVSKI
`12 .. M .. 237 JANOVSKI
`12 .. W .. 325 JANOVSKI
`12 .. E .. 200
`JANOVSKI
`12 .. H .. 309
`JANOVSKI