Spreadsheet: 98409d1297319822-excel-2007-creating-a-formula-that-addresses-three-separate-columns-career-olsen-md
Sheet: Batting

Season | Date | Type | Opponents | Ground | Toss | Captain | Capt / W/K | Result | Inngs | Bat No. | How Out | Where Caught | Fielder | Bowler | Runs | Balls | 6s | 4s | 50 P/S | Aggregate | Cum. Balls | Cum. Average | Cum. S/Rate | Cum. 50 P/S | Cum. 6s | Cum. 4s
2001/02 | 2002-03-16 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | WF | AW Saunders |  | Won chasing target | 2 | 10 | caught | WK / Slips | W Wyngaard | Z Meyer | 2 | 7 | 0 | 0 | 0
2001/02 | 2002-03-21 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | WF | AW Saunders |  | Won chasing target | 4 | 11 | not out |  |  |  | 5 | 21 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Bowler
2002/03 | 2002-10-19 00:00:00 | Two-Day | Western Province CC | The Vineyard, Newlands | WF | AW Saunders |  | Lost by an Innings | 2 | 9 | caught | WK / Slips | D Bassage | K Snyman | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | WK / Slips
2002/03 | 2002-10-20 00:00:00 | Two-Day | Western Province CC | The Vineyard, Newlands | WF | AW Saunders |  | Lost by an Innings | 3 | 9 | caught | WK / Slips | D Bassage | K Snyman | 7 | 20 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | Gulley / Short catcher
2002/03 | 2002-11-02 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | WB | AW Saunders |  | Lost defending target | 3 | 9 | bowled |  |  | M de Stadler | 0 | 2 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | [NAME]
2002/03 | 2002-11-23 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 1 | 10 | bowled |  |  | E Schiferli | 15 | 17 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | Infield
2002/03 | 2002-11-30 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 3 | 9 | caught | [NAME] | A Little | E Schiferli | 4 | 6 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Outfield
2002/03 | 2002-12-15 00:00:00 | Two-Day | Montrose | [NAME], Rylands | WF | AW Saunders |  | [NAME] | 2 | 11 | not out |  |  |  | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Unknown
2003/04 | 2004-03-20 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 1 | 10 | caught | [NAME] | G Taliep | [NAME] | 0 | 6 | 0 | 0 | 0
2003/04 | 2004-03-27 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 3 | 10 | bowled |  |  | [NAME] | 3 | 9 | 0 | 0 | 0
2005/06 | 2005-10-01 00:00:00 | Ltd Overs | Western Province CC | The Vineyard, Newlands | WF | [NAME] |  | Won chasing target | 2 | 8 | caught | Bowler | R Hendricks | R Hendricks | 7 | 11 | 1 | 0 | 0 |  |  |  |  |  |  |  |  | caught
2006/07 | 2006-10-07 00:00:00 | Two-Day | Durbanville | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target | 1 | 7 | caught | Infield | M Heyneke | [NAME] der [NAME] | 2 | 7 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | bowled
2006/07 | 2006-10-14 00:00:00 | Two-Day | Durbanville | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target | 3 | 7 | stumped |  | Z [NAME] | F Gantz | 7 | 13 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | lbw
2006/07 | 2006-10-21 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | LB | [NAME] |  | [NAME] | 1 | 7 | lbw |  |  | R Teladia | 1 | 11 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | stumped
2006/07 | 2006-10-28 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | LB | [NAME] |  | [NAME] | 3 | 7 | caught | Infield | Y Petersen | R Teladia | 13 | 50 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | run out
2006/07 | 2006-11-05 00:00:00 | Two-Day | Almar | [NAME], [NAME] | LB | [NAME] |  | Won defending target | 1 | 7 | lbw |  |  | W Pieterse | 0 | 2 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | hit wicket
2006/07 | 2006-11-11 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target | 2 | 7 | bowled |  |  | S Conrad | 0 | 11 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | not out
2006/07 | 2006-11-12 00:00:00 | Ltd Overs | Victoria | [NAME] Oval, Plumstead | WB | [NAME] |  | Won defending target | 1 | 8 | caught | Bowler | W Wyngaard | W Wyngaard | 17 | 31 | 0 | 0 | 0
2006/07 | 2006-11-18 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target | 4 | 7 | lbw |  |  | [NAME] | 4 | 11 | 0 | 0 | 0
2006/07 | 2007-01-21 00:00:00 | Two-Day | Claremont | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME] | 2 | 8 | caught | Gulley / Short catcher | A Gilder | T Main | 4 | 7 | 0 | 0 | 0
2006/07 | 2007-01-21 00:00:00 | Two-Day | Claremont | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME] | 4 | 8 | bowled |  |  | A Sinclair | 13 | 29 | 0 | 2 | 0
2006/07 | 2007-02-04 00:00:00 | Two-Day | University of Cape Town | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target | 1 | 8 | lbw |  |  | T Rock | 38 | 62 | 2 | 2 | 1
2006/07 | 2007-02-11 00:00:00 | Two-Day | University of Cape Town | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target | 3 | 8 | not out |  |  |  | 66 | 103 | 1 | 7 | 1
2006/07 | 2007-02-24 00:00:00 | Two-Day | Montrose | [NAME] Oval, Plumstead | WB | [NAME] |  | [NAME] | 1 | 8 | caught | WK / Slips | B Barros | A Ansari | 0 | 5 | 0 | 0 | 0
2006/07 | 2007-03-10 00:00:00 | Two-Day | Western Province CC | [NAME], [NAME] | WB | [NAME] |  | Lost defending target | 1 | 8 | caught | Outfield | T Brink | [NAME] | 2 | 6 | 0 | 0 | 0
2006/07 | 2007-03-17 00:00:00 | Two-Day | Western Province CC | [NAME], [NAME] | WB | [NAME] |  | Lost defending target | 3 | 8 | lbw |  |  | S George | 2 | 5 | 0 | 0 | 0
2006/07 | 2007-03-24 00:00:00 | Two-Day | Tygerberg | Florida Park, Ravensmead | WF | [NAME] |  | Won chasing target | 2 | 8 | bowled |  |  | S Januarie | 22 | 24 | 0 | 3 | 0
2007/08 | 2007-10-06 00:00:00 | Ltd Overs | Durbanville | [NAME], Durbanville | WF | [NAME] |  | Won chasing target | 2 | 8 | not out |  |  |  | 44 | 61 | 0 | 6 | 0
2007/08 | 2007-10-20 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | WF | [NAME] |  | Won chasing target | 2 | 8 | not out |  |  |  | 25 | 36 | 1 | 0 | 0
2007/08 | 2007-11-03 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | [NAME] | 1 | 7 | caught | Infield | S Taliep | J [NAME] | 0 | 3 | 0 | 0 | 0
2007/08 | 2007-11-10 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | [NAME] | 3 | 7 | caught | WK / Slips | E Solomons | J [NAME] | 0 | 2 | 0 | 0 | 0
2007/08 | 2007-11-17 00:00:00 | Two-Day | Durbanville | [NAME], Durbanville | LB | [NAME] |  | [NAME] | 1 | 8 | bowled |  |  | F Gantz | 3 | 7 | 0 | 0 | 0
2007/08 | 2007-11-24 00:00:00 | Two-Day | Durbanville | [NAME], Durbanville | LB | [NAME] |  | [NAME] | 3 | 6 | caught | Outfield | S Halley | D Nagel | 26 | 28 | 0 | 3 | 0
2007/08 | 2007-11-25 00:00:00 | Two-Day | Claremont | [NAME], [NAME] | LF | [NAME] |  | [NAME] | 2 | 8 | caught | WK / Slips | sub (A Kirsten) | M Barham | 8 | 13 | 0 | 1 | 0
2007/08 | 2007-11-25 00:00:00 | Two-Day | Claremont | [NAME], [NAME] | LF | [NAME] |  | [NAME] | 4 | 8 | run out |  |  | - | 3 | 7 | 0 | 0 | 0
2007/08 | 2008-01-05 00:00:00 | Ltd Overs | [NAME] | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target | 1 | 8 | bowled |  |  | A Gray | 8 | 14 | 0 | 1 | 0
2007/08 | 2008-01-19 00:00:00 | Two-Day | Western Province CC | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME] | 2 | 8 | lbw |  |  | [NAME] | 6 | 7 | 0 | 0 | 0
2007/08 | 2008-01-19 00:00:00 | Two-Day | Western Province CC | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME] | 4 | 8 | caught | WK / Slips | A Northcote | [NAME] | 2 | 5 | 0 | 0 | 0
2007/08 | 2008-02-09 00:00:00 | Two-Day | University of Cape Town | UCT Oval, Groote Schuur | WF | [NAME] |  | Lost defending target | 2 | 8 | caught | Infield | A Kritzinger | D Bonellie | 13 | 19 | 0 | 3 | 0
2007/08 | 2008-02-16 00:00:00 | Two-Day | University of Cape Town | UCT Oval, Groote Schuur | WF | [NAME] |  | Lost defending target | 3 | 8 | caught | WK / Slips | C Cooke | S Miinnaar | 35 | 34 | 2 | 4 | 0
2007/08 | 2008-02-23 00:00:00 | Two-Day | University of the Western Cape | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 1 | 9 | lbw |  |  | B [NAME] | 4 | 6 | 0 | 1 | 0
2007/08 | 2008-03-01 00:00:00 | Two-Day | University of the Western Cape | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target | 3 | 10 | caught | Bowler | R van der [NAME] | R van der [NAME] | 2 | 9 | 0 | 0 | 0
2007/08 | 2008-03-28 00:00:00 | Ltd Overs | University of the Western Cape | Sahara Park Newlands | LF | [NAME] |  | Lost chasing target | 2 | 8 | not out |  |  |  | 4 | 9 | 0 | 0 | 0
2007/08 | 2008-03-29 00:00:00 | Two-Day | Rondebosch | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target | 2 | 8 | caught | WK / Slips | [NAME] | L de Jager | 1 | 9 | 0 | 0 | 0
2007/08 | 2008-03-30 00:00:00 | Two-Day | Rondebosch | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target | 4 | 9 | stumped |  | [NAME] | A Gray | 24 | 30 | 2 | 1 | 0
2008/09 | 2008-10-11 00:00:00 | Ltd Overs | Claremont | [NAME] Oval, Plumstead | WF | JS Holgate |  | Lost chasing target | 2 | 9 | caught | Infield | C Lederle | S Potgieter | 2 | 9 | 0 | 0 | 0
2008/09 | 2008-11-01 00:00:00 | Two-Day | Northerns-Goodwood | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 1 | 10 | stumped |  | [NAME] | T [NAME] | 16 | 16 | 0 | 1 | 0
2008/09 | 2008-11-08 00:00:00 | Two-Day | Northerns-Goodwood | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 3 | 10 | not out |  |  |  | 26 | 30 | 0 | 3 | 0
2008/09 | 2008-11-15 00:00:00 | Two-Day | [NAME] | [NAME], Ruyterwacht | LF | JS Holgate |  | [NAME] | 2 | 10 | caught | WK / Slips | R Roberts | R Williams | 0 | 4 | 0 | 0 | 0
2008/09 | 2008-11-22 00:00:00 | Two-Day | [NAME] | [NAME], Ruyterwacht | LF | JS Holgate |  | [NAME] | 4 | 8 | stumped |  | A Jackson | F Kippie | 2 | 2 | 0 | 0 | 0
2008/09 | 2008-12-13 00:00:00 | Two-Day | Old Mutual | Mutual Park, Pinelands | LB | JS Holgate |  | Lost defending target | 1 | 9 | bowled |  |  | M de Stadler | 67 | 74 | 0 | 8 | 1
2008/09 | 2008-12-16 00:00:00 | Two-Day | Old Mutual | Mutual Park, Pinelands | LB | JS Holgate |  | Lost defending target | 3 | 9 | caught | Infield | Z [NAME] | R Daniels | 18 | 29 | 0 | 1 | 0
2008/09 | 2009-01-11 00:00:00 | Ltd Overs | Western Province CC | [NAME], [NAME] | LF | JS Holgate |  | Lost chasing target | 2 | 10 | caught | Infield | [NAME] | M Mahlombe | 38 | 21 | 3 | 4 | 0
2008/09 | 2009-01-24 00:00:00 | Two-Day | Primrose | Rosmead Sports Grounds, Kenilworth | LF | JS Holgate |  | Won chasing target | 2 | 8 | caught | Infield | F Emandien | J Theron | 7 | 10 | 0 | 1 | 0
2008/09 | 2009-02-07 00:00:00 | Two-Day | Kuils River | Sarepta Sports Complex, Kuils River | WB | [NAME] |  | Lost defending target | 1 | 8 | not out |  |  |  | 18 | 15 | 0 | 3 | 0
2008/09 | 2009-02-08 00:00:00 | Ltd Overs | Kuils River | [NAME] Oval, Plumstead | WB | [NAME] |  | Won defending target | 1 | 7 | bowled |  |  | S Adams | 3 | 17 | 0 | 0 | 0
2008/09 | 2009-02-14 00:00:00 | Two-Day | Kuils River | Sarepta Sports Complex, Kuils River | WB | [NAME] |  | Lost defending target | 2 | 8 | stumped |  | M Solomons | A Jantjies | 17 | 15 | 2 | 0 | 0
2008/09 | 2009-02-21 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | JS Holgate |  | Lost defending target | 1 | 9 | lbw |  |  | M Temple | 0 | 3 | 0 | 0 | 0
2008/09 | 2009-02-28 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | JS Holgate |  | Lost defending target | 2 | 10 | not out |  |  |  | 35 | 43 | 0 | 6 | 0
2008/09 | 2009-03-07 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 1 | 8 | not out |  |  |  | 34 | 19 | 3 | 1 | 0
2008/09 | 2009-03-14 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 2 | 8 | not out |  |  |  | 31 | 16 | 1 | 4 | 0
2008/09 | 2009-03-21 00:00:00 | AMA20-20 | Old Mutual | Edgemead Crcket Club, Edgemead | LF | [NAME] |  | Lost chasing target | 2 | 5 | lbw |  |  | R Daniels | 7 | 4 | 0 | 1 | 0
2008/09 | 2009-03-21 00:00:00 | AMA20-20 | Primrose | Edgemead Crcket Club, Edgemead | LF | [NAME] |  | Won chasing target | 2 | 3 | caught | Unknown | S Taliep | [NAME] | 12 | 8 | 1 | 1 | 0
2008/09 | 2009-03-28 00:00:00 | AMA20-20 | Northerns-Goodwood | [NAME], Somerset West | WF | [NAME] |  | Lost chasing target | 2 | 6 | caught | WK / Slips | I [NAME] | E Rossouw | 23 | 22 | 0 | 5 | 0
2008/09 | 2009-03-29 00:00:00 | AMA20-20 | Pinelands | [NAME], [NAME] | WB | [NAME] |  | Won defending target | 1 | 6 | caught | Outfield | G Knott | R Bannatyne | 3 | 5 | 0 | 0 | 0
2009/10 | 2009-10-17 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | WF | JS Holgate |  | Lost chasing target | 2 | 8 | bowled |  |  | F Emandien | 2 | 6 | 0 | 0 | 0
2009/10 | 2009-10-24 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | WF | JS Holgate |  | Lost chasing target | 4 | 8 | stumped |  | A Allie | A Magiet | 31 | 26 | 2 | 4 | 0
2009/10 | 2009-10-31 00:00:00 | Two-Day | [NAME] | [NAME] Oval, Plumstead | WB | JS Holgate |  | Lost defending target | 1 | 8 | caught | Infield | R Brown | F Kippie | 1 | 4 | 0 | 0 | 0
2009/10 | 2009-11-07 00:00:00 | Two-Day | [NAME] | [NAME] Oval, Plumstead | WB | JS Holgate |  | Lost defending target | 3 | 8 | bowled |  |  | A Jackson | 2 | 8 | 0 | 0 | 0
2009/10 | 2009-11-14 00:00:00 | Two-Day | Almar | [NAME], [NAME] | WF | JS Holgate |  | Won chasing target | 2 | 7 | bowled |  |  | L Brittow | 16 | 12 | 0 | 3 | 0
2009/10 | 2009-11-21 00:00:00 | Two-Day | Almar | [NAME], [NAME] | WF | JS Holgate |  | Won chasing target | 4 | 6 | not out |  |  |  | 4 | 1 | 0 | 1 | 0
2009/10 | 2009-11-28 00:00:00 | Ltd Overs | Victoria | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 1 | 7 | caught | WK / Slips | L Daniels | Z Meyer | 6 | 5 | 0 | 1 | 0
2009/10 | 2009-12-05 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | LF | JS Holgate |  | Won chasing target | 2 | 8 | caught | Outfield | Z Meyer | R Hendricks | 20 | 18 | 1 | 1 | 1
2009/10 | 2009-12-16 00:00:00 | Two-Day | Pinelands | Pinelands Oval, Pinelands | LF | JS Holgate |  | Won chasing target | 2 | 8 | caught | Bowler | R Bannatyne | R Bannatyne | 21 | 19 | 1 | 1 | 0
2009/10 | 2010-01-09 00:00:00 | Two-Day | Montrose | The Vineyard, Newlands | WF | JS Holgate |  | Won chasing target | 2 | 8 | caught | Infield | C [NAME] | C Fortune | 3 | 4 | 0 | 0 | 0
2009/10 | 2010-01-16 00:00:00 | Two-Day | Montrose | The Vineyard, Newlands | WF | JS Holgate |  | Won chasing target | 4 | 9 | not out |  |  |  | 10 | 31 | 0 | 1 | 0
2009/10 | 2010-01-23 00:00:00 | AMA20-20 | [NAME] | PP Smit Sports Complex, Bellville | WF | JS Holgate |  | Won chasing target | 2 | 4 | caught | Infield | B [NAME] | D Reynecke | 3 | 5 | 0 | 0 | 0
2009/10 | 2010-01-23 00:00:00 | AMA20-20 | Tygerberg | PP Smit Sports Complex, Bellville | WB | JS Holgate |  | Won defending target | 1 | 4 | bowled |  |  | D Carolus | 0 | 6 | 0 | 0 | 0
2009/10 | 2010-01-30 00:00:00 | AMA20-20 | Pinelands | Edgemead Crcket Club, Edgemead | WB | JS Holgate |  | Won defending target | 1 | 4 | caught | Outfield | R Canning | A Mgijima | 19 | 14 | 1 | 2 | 0
2009/10 | 2010-01-31 00:00:00 | AMA20-20 | Primrose | [NAME] Oval, Plumstead | LB | JS Holgate |  | Lost chasing target | 1 | 5 | stumped |  | A Allie | [NAME] | 5 | 7 | 0 | 0 | 0
2009/10 | 2010-02-06 00:00:00 | Two-Day | Northerns-Goodwood | Northerns-Goodwood CC Oval, Goodwood | LB | JS Holgate |  | Won defending target | 1 | 9 | not out |  |  |  | 11 | 6 | 0 | 2 | 0
2009/10 | 2010-02-13 00:00:00 | Two-Day | Northerns-Goodwood | Northerns-Goodwood CC Oval, Goodwood | LB | JS Holgate |  | Won defending target | 3 | 9 | stumped |  | D Dorman | D Brand | 6 | 8 | 0 | 1 | 0
2009/10 | 2010-02-20 00:00:00 | Ltd Overs | University of the Western Cape | Western Cape University Oval, Bellville South | LB | JS Holgate |  | Won defending target | 1 | 7 | not out |  |  |  | 0 | 0 | 0 | 0 | 0
2009/10 | 2010-03-06 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 1 | 9 | caught | Gulley / Short catcher | J Adams | D Carolus | 7 | 7 | 0 | 1 | 0
2009/10 | 2010-03-07 00:00:00 | Ltd Overs | Durbanville | [NAME], Durbanville | WB | JS Holgate |  | Won defending target | 1 | 9 | bowled |  |  | M Heyneke | 2 | 6 | 0 | 0 | 0
2009/10 | 2010-03-13 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target | 3 | 8 | not out |  |  |  | 16 | 17 | 0 | 2 | 0
2009/10 | 2010-03-20 00:00:00 | Two-Day | Kuils River | [NAME] Oval, Plumstead | LB | JS Holgate |  | Won defending target | 1 | 9 | stumped |  | R Langley | A Jantjies | 26 | 17 | 1 | 4 | 0
2009/10 | 2010-03-31 00:00:00 | Ltd Overs | Old Mutual | Sahara Park Newlands | WB | JS Holgate |  | Lost defending target | 1 | 9 | caught | Infield | sub (C Daniels) | D Piedt | 0 | 2 | 0 | 0 | 0
2010/11 | 2010-10-02 00:00:00 | AMA20-20 | Tygerberg | [NAME], [NAME] | WF | GA Dods |  | Lost chasing target | 2 | 5 | bowled |  |  | R Parker | 0 | 1 | 0 | 0 | 0
2010/11 | 2010-10-09 00:00:00 | AMA20-20 | Green Point-CPUT | Chukker Road Sports Complex, Lansdowne | WB | GA Dods |  | Won defending target | 1 | 7 | not out |  |  |  | 42 | 23 | 2 | 3 | 0
2010/11 | 2010-10-09 00:00:00 | AMA20-20 | St Augustines | Chukker Road Sports Complex, Lansdowne | WB | GA Dods |  | Won defending target | 1 | 7 | run out |  |  | - | 15 | 9 | 0 | 2 | 0
2010/11 | 2010-10-10 00:00:00 | AMA20-20 | Victoria | [NAME], Green Point | WB | GA Dods |  | No Result / Abandoned | 1 | 7 | not out |  |  |  | 2 | 2 | 0 | 0 | 0
2010/11 | 2010-10-30 00:00:00 | Two-Day | Primrose | Rosmead Sports Grounds, Kenilworth | WB | GA Dods |  | Lost defending target | 1 | 7 | bowled |  |  | S Toefy | 11 | 25 | 0 | 1 | 0
2010/11 | 2010-10-30 00:00:00 | Two-Day | Primrose | Rosmead Sports Grounds, Kenilworth | WB | GA Dods |  | Lost defending target | 3 | 8 | bowled |  |  | S Toefy | 37 | 36 | 4 | 2 | 0
2010/11 | 2010-11-13 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | LF | GA Dods |  | [NAME] | 2 | 6 | run out |  |  | - | 22 | 19 | 1 | 3 | 0
2010/11 | 2010-12-04 00:00:00 | Two-Day | Montrose | [NAME] Oval, Plumstead | WF | GA Dods |  | Lost chasing target | 2 | 8 | lbw |  |  | R Peterson | 4 | 2 | 0 | 1 | 0
2010/11 | 2010-12-04 00:00:00 | Two-Day | Montrose | [NAME] Oval, Plumstead | WF | GA Dods |  | Lost chasing target | 4 | 8 | caught | Infield | N Samaai | R Peterson | 6 | 16 | 0 | 1 | 0
2010/11 | 2010-12-11 00:00:00 | Ltd Overs | Northerns-Goodwood | Northerns-Goodwood CC Oval, Goodwood | LF | GA Dods |  | Won chasing target | 2 | 7 | not out |  |  |  | 1 | 3 | 0 | 0 | 0
2010/11 | 2010-12-16 00:00:00 | Ltd Overs | St Augustines | [NAME] Oval, Plumstead | LB | GA Dods |  | Lost defending target | 1 | 8 | run out |  |  | - | 0 | 1 | 0 | 0 | 0
2010/11 | 2010-12-18 00:00:00 | Ltd Overs | Bellville | PP Smit Sports Complex, Bellville | LF | GA Dods |  | Lost chasing target | 2 | 9 | caught | WK / Slips | H Theron | M Feldman | 6 | 23 | 0 | 0 | 0
2010/11 | 2011-01-22 00:00:00 | Two-Day | Almar | [NAME] Oval, Plumstead | LB | GA Dods |  | Won by an innings | 1 | 9 | caught | Outfield | T [NAME] | D Sandmann | 7 | 17 | 0 | 0 | 0
2010/11 | 2011-02-05 00:00:00 | Two-Day | [NAME] | [NAME], Ruyterwacht | LB | GA Dods |  |  | 1 | 9 | caught | WK / Slips | D Arries | L Pastor | 0 | 3 | 0 | 0 | 0
 |  | SUBTOTAL(function_num, ref1, ref2, ...)
 |  | Function_num | Function_num | Function
 |  | (includes hidden values) | (ignores hidden values)
 |  | 1 | 101 | AVERAGE |  |  | Type | How Out |  | Type | How Out
 |  | 2 | 102 | COUNT |  |  | Two-Day | not out |  | AMA20-20 | not out
 |  | 3 | 103 | COUNTA
 |  | 4 | 104 | MAX
 |  | 5 | 105 | MIN |  |  | Type | How Out |  | Type | Runs
 |  | 6 | 106 | PRODUCT |  |  | Ltd Overs | not out |  | AMA20-20 | >=50
 |  | 7 | 107 | STDEV
 |  | 8 | 108 | STDEVP
 |  | 9 | 109 | SUM
 |  | 10 | 110 | VAR |  |  | Type | Runs |  | Type | Runs
 |  | 11 | 111 | VARP |  |  | Two-Day | >=50 |  | AMA20-20 | >=100
 | Two-Day
 | Ltd Overs |  |  |  |  |  | Type | Runs |  | Type | How Out | Runs
 | AMA20-20 |  |  |  |  |  | Ltd Overs | >=50 |  | AMA20-20 | <>not out
 | Almar
 | Bellville |  |  |  |  |  | Type | Runs
 | [NAME] |  |  |  |  |  | Two-Day | >=100
 | Brooklyn-Telkom
 | Claremont
 | Durbanville |  |  |  |  |  | Type | Runs
 | Fish Hoek |  |  |  |  |  | Ltd Overs | >=100
 | [NAME]
 | Green Point-CPUT
 | Kuils River |  |  |  |  |  | Type | How Out | Runs
 | Langa |  |  |  |  |  | Two-Day | <>not out
 | Montrose
 | Northerns-Goodwood
 | Oakdale |  |  |  |  |  | Type | How Out | Runs
 | Old Mutual |  |  |  |  |  | Ltd Overs | <>not out
 | Pinelands
 | Primrose
 | Rondebosch |  |  |  |  |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught
 | Somerset West |  |  |  |  |  | Two-Day | caught | Bowler |  |  | Two-Day | caught | WK / Slips |  | Two-Day | caught | [NAME] |  |  | Two-Day | caught | Infield |  | Two-Day | caught | Outfield |  | Two-Day | caught | Unknown |  |  | Two-Day | caught | Gulley / Short catcher
 | St Augustines
 | [NAME]
 | Tygerberg |  |  |  |  |  | Type | How Out |  | Type | How Out
 | United |  |  |  |  |  | Two-Day | bowled |  | AMA20-20 | bowled
 | University of Cape Town
 | University of the Western Cape
 | Victoria |  |  |  |  |  | Type | How Out |  | Type | How Out
 | Western Province CC |  |  |  |  |  | Two-Day | lbw |  | AMA20-20 | lbw
 | [NAME], Elfindale
 | Bishop Lavis Cricket Club, [NAME] |  |  |  |  |  | Type | How Out |  | Type | How Out
 | [NAME] Oval, Plumstead |  |  |  |  |  | Two-Day | stumped |  | AMA20-20 | stumped
 | Chukker Road Sports Complex, Lansdowne
 | [NAME], [NAME]
 | [NAME], [NAME] |  |  |  |  |  | Type | How Out |  | Type | How Out
 | [NAME], Durbanville |  |  |  |  |  | Two-Day | run out |  | AMA20-20 | run out
 | Edgemead Cricket Club, Edgemead
 | Florida Park, Ravensmead
 | Green Point Track, Green Point |  |  |  |  |  | Type | How Out |  | Type | How Out
 | [NAME], Wynberg Boys' High School |  |  |  |  |  | Two-Day | hit wicket |  | AMA20-20 | hit wicket
 | [NAME], Langa
 | [NAME], Rylands
 | Mutual Park, Pinelands |  |  |  |  |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught
 | Northerns-Goodwood CC Oval, Goodwood |  |  |  |  |  | Ltd Overs | caught | Bowler |  |  | Ltd Overs | caught | WK / Slips |  | Ltd Overs | caught | [NAME] |  |  | Ltd Overs | caught | Infield |  | Ltd Overs | caught | Outfield |  | Ltd Overs | caught | Unknown |  |  | Ltd Overs | caught | Gulley / Short catcher
 | Pinelands Oval, Pinelands
 | PP Smit Sports Complex, Bellville
 | [NAME], Somerset West |  |  |  |  |  | Type | How Out
 | [NAME], [NAME] |  |  |  |  |  | Ltd Overs | bowled
 | Rosmead Sports Grounds, Kenilworth
 | [NAME], Rondebosch
 | Sahara Park Newlands |  |  |  |  |  | Type | How Out
 | Sarepta Sports Complex, Kuils River |  |  |  |  |  | Ltd Overs | lbw
 | Silverglades, Fish Hoek
 | [NAME], Ruyterwacht
 | [NAME], Green Point |  |  |  |  |  | Type | How Out
 | The Vineyard, Newlands |  |  |  |  |  | Ltd Overs | stumped
 | UCT Oval, Groote Schuur
 | [NAME], [NAME]
 | Western Cape University Oval, Bellville South |  |  |  |  |  | Type | How Out
 | Wynberg Sports Club, Wynberg |  |  |  |  |  | Ltd Overs | run out
 | WB
 | WF |  |  |  |  |  | Type | How Out
 | LB |  |  |  |  |  | Ltd Overs | hit wicket
 | LF
 | Won by an innings |  |  |  |  |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  | Type | How Out | Where Caught |  |  | Type | How Out | Where Caught
 | Won chasing target |  |  |  |  |  | AMA20-20 | caught | Bowler |  |  | AMA20-20 | caught | WK / Slips |  | AMA20-20 | caught | [NAME] |  |  | AMA20-20 | caught | Infield |  | AMA20-20 | caught | Outfield |  | AMA20-20 | caught | Unknown |  |  | AMA20-20 | caught | Gulley / Short catcher
 | Won defending target
 | Tie
 | [NAME]
 | No Result / Abandoned
 | Lost by an innings
 | Lost chasing target
 | Lost defending target