Spreadsheet: 153963d1336132164-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6maxhyper
Sheet: Sheet3

 |  |  | Cell | Players | Button | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:17:24 CET [2012/05/01 13:17:24 ET] | # of chips |  |  |  | Seat |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
Table '554589676 1' 6-max Seat #1 is the button |  |  |  |  |  |  |  |  |  |  |  |  | 6 | BU | SB | BB | UTG | MP | CO
Seat 1: avvvvvvv (500 in chips) |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BU | SB | BB | UTG | CO
Seat 2: parcerito22 (500 in chips) |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BU | SB | BB | CO
Seat 3: waixingren88 (500 in chips) |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BU | SB | BB
Seat 4: marin243 (500 in chips)
Seat 5: 6/5suited (500 in chips)
Seat 6: Blossom100 (500 in chips)
avvvvvvv: posts the ante 10
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10 |  |  |  |  |  |  |  |  |  |  |  | If there are 6 players and seat #1 has button, seat #2 will have SB, seat #3 BB, #4 UTG, #5 MP and #6 will have CO.
6/5suited: posts the ante 10 |  |  |  |  |  |  |  |  |  |  |  | If #2 has button then #3 has SB, #4 BB, #5 UTG, #6 MP and #1 CO and so on. If there are 5 players then there is no MP
Blossom100: posts the ante 10 |  |  |  |  |  |  |  |  |  |  |  | and if there are 4 players there is no MP and no UTG. If there are only 3 players (the minimum) then there is only
parcerito22: posts small blind 25 |  |  |  |  |  |  |  |  |  |  |  | BU, SB and BB.
waixingren88: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [Qs Ad]
marin243: folds
6/5suited: folds
Blossom100: folds
avvvvvvv: raises 440 to 490 and is all-in
parcerito22: folds
waixingren88: calls 440 and is all-in
*** FLOP *** [5h 7d 8d]
*** TURN *** [5h 7d 8d] [7h]
*** RIVER *** [5h 7d 8d 7h] [Ah]
*** SHOW DOWN ***
waixingren88: shows [Qs Ad] (two pair, Aces and [NAME])
avvvvvvv: shows [Tc Qc] (a pair of [NAME])
waixingren88 collected 1065 from pot
avvvvvvv finished the tournament in 6th place
*** SUMMARY ***
Total pot 1065 | Rake 0
Board [5h 7d 8d 7h Ah]
Seat 1: avvvvvvv (button) showed [[NAME]] and lost with a pair of [NAME]
Seat 2: parcerito22 (small blind) folded before Flop
Seat 3: waixingren88 (big blind) showed [Qs Ad] and won (1065) with two pair, Aces and [NAME]
Seat 4: marin243 folded before Flop (didn't bet)
Seat 5: 6/5suited folded before Flop (didn't bet)
Seat 6: Blossom100 folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:17:54 CET [2012/05/01 13:17:54 ET]
Table '554589676 1' 6-max Seat #2 is the button
Seat 2: parcerito22 (465 in chips)
Seat 3: waixingren88 (1065 in chips)
Seat 4: marin243 (490 in chips)
Seat 5: 6/5suited (490 in chips)
Seat 6: Blossom100 (490 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
waixingren88: posts small blind 25
marin243: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [5s Kd]
6/5suited: folds
Blossom100: folds
parcerito22: folds
waixingren88: raises 1005 to 1055 and is all-in
marin243: calls 430 and is all-in
Uncalled bet (575) returned to waixingren88
*** FLOP *** [9s 9d 7h]
*** TURN *** [9s 9d 7h] [3c]
*** RIVER *** [9s 9d 7h 3c] [7c]
*** SHOW DOWN ***
waixingren88: shows [5s Kd] (two pair, Nines and [NAME])
marin243: shows [Qh Qd] (two pair, Queens and Nines)
marin243 collected 1010 from pot
*** SUMMARY ***
Total pot 1010 | Rake 0
Board [9s 9d 7h 3c 7c]
Seat 2: parcerito22 (button) folded before Flop (didn't bet)
Seat 3: waixingren88 (small blind) showed [5s Kd] and lost with two pair, Nines and [NAME]
Seat 4: marin243 (big blind) showed [Qh Qd] and won (1010) with two pair, Queens and Nines
Seat 5: 6/5suited folded before Flop (didn't bet)
Seat 6: Blossom100 folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:18:16 CET [2012/05/01 13:18:16 ET]
Table '554589676 1' 6-max Seat #3 is the button
Seat 2: parcerito22 (455 in chips)
Seat 3: waixingren88 (575 in chips)
Seat 4: marin243 (1010 in chips)
Seat 5: 6/5suited (480 in chips)
Seat 6: Blossom100 (480 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
marin243: posts small blind 25
6/5suited: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [2d 3s]
Blossom100: folds
parcerito22: folds
waixingren88: folds
marin243: raises 950 to 1000 and is all-in
6/5suited is disconnected
6/5suited is connected
6/5suited: folds
Uncalled bet (950) returned to marin243
marin243 collected 150 from pot
*** SUMMARY ***
Total pot 150 | Rake 0
Seat 2: parcerito22 folded before Flop (didn't bet)
Seat 3: waixingren88 (button) folded before Flop (didn't bet)
Seat 4: marin243 (small blind) collected (150)
Seat 5: 6/5suited (big blind) folded before Flop
Seat 6: Blossom100 folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:18:39 CET [2012/05/01 13:18:39 ET]
Table '554589676 1' 6-max Seat #4 is the button
Seat 2: parcerito22 (445 in chips)
Seat 3: waixingren88 (565 in chips)
Seat 4: marin243 (1100 in chips)
Seat 5: 6/5suited (420 in chips)
Seat 6: Blossom100 (470 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
6/5suited: posts small blind 25
Blossom100: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [4d Jd]
parcerito22: folds
waixingren88: folds
marin243: raises 1040 to 1090 and is all-in
6/5suited: folds
Blossom100: folds
Uncalled bet (1040) returned to marin243
marin243 collected 175 from pot
*** SUMMARY ***
Total pot 175 | Rake 0
Seat 2: parcerito22 folded before Flop (didn't bet)
Seat 3: waixingren88 folded before Flop (didn't bet)
Seat 4: marin243 (button) collected (175)
Seat 5: 6/5suited (small blind) folded before Flop
Seat 6: Blossom100 (big blind) folded before Flop
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:19:01 CET [2012/05/01 13:19:01 ET]
Table '554589676 1' 6-max Seat #5 is the button
Seat 2: parcerito22 (435 in chips)
Seat 3: waixingren88 (555 in chips)
Seat 4: marin243 (1215 in chips)
Seat 5: 6/5suited (385 in chips)
Seat 6: Blossom100 (410 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
Blossom100: posts small blind 25
parcerito22: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [6d 5h]
waixingren88: folds
marin243: raises 1155 to 1205 and is all-in
6/5suited: folds
Blossom100: folds
parcerito22: folds
Uncalled bet (1155) returned to marin243
marin243 collected 175 from pot
*** SUMMARY ***
Total pot 175 | Rake 0
Seat 2: parcerito22 (big blind) folded before Flop
Seat 3: waixingren88 folded before Flop (didn't bet)
Seat 4: marin243 collected (175)
Seat 5: 6/5suited (button) folded before Flop (didn't bet)
Seat 6: Blossom100 (small blind) folded before Flop
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:19:27 CET [2012/05/01 13:19:27 ET]
Table '554589676 1' 6-max Seat #6 is the button
Seat 2: parcerito22 (375 in chips)
Seat 3: waixingren88 (545 in chips)
Seat 4: marin243 (1330 in chips)
Seat 5: 6/5suited (375 in chips)
Seat 6: Blossom100 (375 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
parcerito22: posts small blind 25
waixingren88: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [Ad 3c]
marin243: folds
6/5suited: folds
Blossom100: folds
parcerito22: raises 315 to 365 and is all-in
waixingren88: calls 315
*** FLOP *** [Js Jc As]
*** TURN *** [Js Jc As] [5s]
*** RIVER *** [Js Jc As 5s] [9c]
*** SHOW DOWN ***
parcerito22: shows [Qd Jh] (three of a kind, [NAME])
waixingren88: shows [Ad 3c] (two pair, Aces and [NAME])
parcerito22 collected 780 from pot
*** SUMMARY ***
Total pot 780 | Rake 0
Board [Js Jc As 5s 9c]
Seat 2: parcerito22 (small blind) showed [Qd Jh] and won (780) with three of a kind, [NAME]
Seat 3: waixingren88 (big blind) showed [Ad 3c] and lost with two pair, Aces and [NAME]
Seat 4: marin243 folded before Flop (didn't bet)
Seat 5: 6/5suited folded before Flop (didn't bet)
Seat 6: Blossom100 (button) folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:19:45 CET [2012/05/01 13:19:45 ET]
Table '554589676 1' 6-max Seat #2 is the button
Seat 2: parcerito22 (780 in chips)
Seat 3: waixingren88 (170 in chips)
Seat 4: marin243 (1320 in chips)
Seat 5: 6/5suited (365 in chips)
Seat 6: Blossom100 (365 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
6/5suited: posts the ante 10
Blossom100: posts the ante 10
waixingren88: posts small blind 25
marin243: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [8h 6h]
6/5suited: raises 300 to 350
Blossom100: raises 5 to 355 and is all-in
parcerito22: folds
waixingren88: calls 135 and is all-in
marin243: folds
6/5suited: calls 5 and is all-in
*** FLOP *** [Qd 7h Td]
*** TURN *** [Qd 7h Td] [9d]
*** RIVER *** [Qd 7h Td 9d] [7s]
*** SHOW DOWN ***
6/5suited: shows [8d Qc] (two pair, Queens and [NAME])
Blossom100: shows [Js Qs] (two pair, Queens and [NAME] kicker)
Blossom100 collected 390 from side pot
waixingren88: shows [8h 6h] (a straight, Six to Ten)
waixingren88 collected 580 from main pot
6/5suited finished the tournament in 5th place
*** SUMMARY ***
Total pot 970 Main pot 580. Side pot 390. | Rake 0
Board [Qd 7h Td 9d 7s]
Seat 2: parcerito22 (button) folded before Flop (didn't bet)
Seat 3: waixingren88 (small blind) showed [8h 6h] and won (580) with a straight, Six to Ten
Seat 4: marin243 (big blind) folded before Flop
Seat 5: 6/5suited showed [8d Qc] and lost with two pair, Queens and [NAME]
Seat 6: Blossom100 showed [Js Qs] and won (390) with two pair, Queens and [NAME]
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:20:15 CET [2012/05/01 13:20:15 ET]
Table '554589676 1' 6-max Seat #3 is the button
Seat 2: parcerito22 (770 in chips)
Seat 3: waixingren88 (580 in chips)
Seat 4: marin243 (1260 in chips)
Seat 6: Blossom100 (390 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
Blossom100: posts the ante 10
marin243: posts small blind 25
Blossom100: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [Ac Jd]
parcerito22: folds
waixingren88: raises 520 to 570 and is all-in
marin243: folds
Blossom100: folds
Uncalled bet (520) returned to waixingren88
waixingren88 collected 165 from pot
*** SUMMARY ***
Total pot 165 | Rake 0
Seat 2: parcerito22 folded before Flop (didn't bet)
Seat 3: waixingren88 (button) collected (165)
Seat 4: marin243 (small blind) folded before Flop
Seat 6: Blossom100 (big blind) folded before Flop
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level I (25/50) - 2012/05/01 19:20:24 CET [2012/05/01 13:20:24 ET]
Table '554589676 1' 6-max Seat #4 is the button
Seat 2: parcerito22 (760 in chips)
Seat 3: waixingren88 (685 in chips)
Seat 4: marin243 (1225 in chips)
Seat 6: Blossom100 (330 in chips)
parcerito22: posts the ante 10
waixingren88: posts the ante 10
marin243: posts the ante 10
Blossom100: posts the ante 10
Blossom100: posts small blind 25
parcerito22: posts big blind 50
*** HOLE CARDS ***
Dealt to waixingren88 [[NAME]]
waixingren88: raises 625 to 675 and is all-in
marin243: folds
Blossom100: folds
parcerito22: folds
Uncalled bet (625) returned to waixingren88
waixingren88 collected 165 from pot
*** SUMMARY ***
Total pot 165 | Rake 0
Seat 2: parcerito22 (big blind) folded before Flop
Seat 3: waixingren88 collected (165)
Seat 4: marin243 (button) folded before Flop (didn't bet)
Seat 6: Blossom100 (small blind) folded before Flop
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level II (50/100) - 2012/05/01 19:20:37 CET [2012/05/01 13:20:37 ET]
Table '554589676 1' 6-max Seat #6 is the button
Seat 2: parcerito22 (700 in chips)
Seat 3: waixingren88 (790 in chips)
Seat 4: marin243 (1215 in chips)
Seat 6: Blossom100 (295 in chips)
parcerito22: posts the ante 20
waixingren88: posts the ante 20
marin243: posts the ante 20
Blossom100: posts the ante 20
parcerito22: posts small blind 50
waixingren88: posts big blind 100
*** HOLE CARDS ***
Dealt to waixingren88 [2h 4d]
marin243: raises 1095 to 1195 and is all-in
Blossom100: folds
parcerito22: folds
waixingren88: folds
Uncalled bet (1095) returned to marin243
marin243 collected 330 from pot
*** SUMMARY ***
Total pot 330 | Rake 0
Seat 2: parcerito22 (small blind) folded before Flop
Seat 3: waixingren88 (big blind) folded before Flop
Seat 4: marin243 collected (330)
Seat 6: Blossom100 (button) folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level II (50/100) - 2012/05/01 19:20:45 CET [2012/05/01 13:20:45 ET]
Table '554589676 1' 6-max Seat #2 is the button
Seat 2: parcerito22 (630 in chips)
Seat 3: waixingren88 (670 in chips)
Seat 4: marin243 (1425 in chips)
Seat 6: Blossom100 (275 in chips)
parcerito22: posts the ante 20
waixingren88: posts the ante 20
marin243: posts the ante 20
Blossom100: posts the ante 20
waixingren88: posts small blind 50
marin243: posts big blind 100
*** HOLE CARDS ***
Dealt to waixingren88 [3d 5c]
Blossom100: folds
parcerito22: folds
waixingren88: folds
Uncalled bet (50) returned to marin243
marin243 collected 180 from pot
*** SUMMARY ***
Total pot 180 | Rake 0
Seat 2: parcerito22 (button) folded before Flop (didn't bet)
Seat 3: waixingren88 (small blind) folded before Flop
Seat 4: marin243 (big blind) collected (180)
Seat 6: Blossom100 folded before Flop (didn't bet)
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level II (50/100) - 2012/05/01 19:20:50 CET [2012/05/01 13:20:50 ET]
Table '554589676 1' 6-max Seat #3 is the button
Seat 2: parcerito22 (610 in chips)
Seat 3: waixingren88 (600 in chips)
Seat 4: marin243 (1535 in chips)
Seat 6: Blossom100 (255 in chips)
parcerito22: posts the ante 20
waixingren88: posts the ante 20
marin243: posts the ante 20
Blossom100: posts the ante 20
marin243: posts small blind 50
Blossom100: posts big blind 100
*** HOLE CARDS ***
Dealt to waixingren88 [4c Ah]
parcerito22: folds
waixingren88: raises 480 to 580 and is all-in
marin243: folds
Blossom100: calls 135 and is all-in
Uncalled bet (345) returned to waixingren88
*** FLOP *** [7d 2d 4h]
*** TURN *** [7d 2d 4h] [4d]
*** RIVER *** [7d 2d 4h 4d] [4s]
*** SHOW DOWN ***
Blossom100: shows [Td 9h] (three of a kind, Fours)
waixingren88: shows [4c Ah] (four of a kind, Fours)
waixingren88 collected 600 from pot
Blossom100 finished the tournament in 4th place
*** SUMMARY ***
Total pot 600 | Rake 0
Board [7d 2d 4h 4d 4s]
Seat 2: parcerito22 folded before Flop (didn't bet)
Seat 3: waixingren88 (button) showed [4c Ah] and won (600) with four of a kind, Fours
Seat 4: marin243 (small blind) folded before Flop
Seat 6: Blossom100 (big blind) showed [Td 9h] and lost with three of a kind, Fours
PokerStars Hand #[PHONE]: Tournament #554589676, $3.67+$0.07 USD Hold'em No Limit - Level II (50/100) - 2012/05/01 19:21:06 CET [2012/05/01 13:21:06 ET]
Table '554589676 1' 6-max Seat #4 is the button
Seat 2: parcerito22 (590 in chips)
Seat 3: waixingren88 (945 in chips)
Seat 4: marin243 (1465 in chips)
parcerito22: posts the ante 20
waixingren88: posts the ante 20
marin243: posts the ante 20
parcerito22: posts small blind 50
waixingren88: posts big blind 100
*** HOLE CARDS ***
Dealt to waixingren88 [Qh Ks]
marin243: folds
parcerito22: raises 470 to 570 and is all-in
waixingren88: calls 470
*** FLOP *** [Kd 3d 4d]
*** TURN *** [Kd 3d 4d] [Js]
*** RIVER *** [Kd 3d 4d Js] [7s]
*** SHOW DOWN ***
parcerito22: shows [6s Ah] (high card Ace)
waixingren88: shows [Qh Ks] (a pair of Kings)
waixingren88 collected 1200 from pot
*** SUMMARY ***
Total pot 1200 | Rake 0
Board [Kd 3d 4d Js 7s]
Seat 2: parcerito22 (small blind) showed [6s Ah] and lost with high card Ace
Seat 3: waixingren88 (big blind) showed [Qh Ks] and won (1200) with a pair of Kings
Seat 4: marin243 (button) folded before Flop (didn't bet)