chris
Should take up another sport!
Posts: 6
|
Post by chris on Dec 9, 2006 17:47:57 GMT
ask andy or martin as they might have that info but if they dont it not been keep or lost on computers that broke and all files have been lost
|
|
ed
County Player
Posts: 452
|
Post by ed on Dec 10, 2006 23:23:45 GMT
I want to know if Poolking100 has missed a game in the last 4 years? If so how many? 1? 2? Andy probably has most of the info on recent leagues. Poolking missed a few games last season. In the last four seasons, Dom Cobley has played more frames than anyone (115).
|
|
savage
County Player
Posts: 438
|
Post by savage on Dec 11, 2006 0:02:00 GMT
I think it would be good to get all cup efforts included...perhaps from QFs onwards as info should be available
|
|
savage
County Player
Posts: 438
|
Post by savage on Dec 11, 2006 0:03:43 GMT
I'd need that to get on the list having played non-premier pool for the last few seasons! Only prob with averaging over 50 games is that new players could only get ranked after more than 2 seasons... ?
|
|
|
Post by Box on Dec 11, 2006 0:04:37 GMT
Cool, maybe I won't be bottom for a change ;D
|
|
|
Post by orrible on Dec 11, 2006 0:06:22 GMT
I think it would be good to get all cup efforts included...perhaps from QFs onwards as info should be available You're sad
|
|
savage
County Player
Posts: 438
|
Post by savage on Dec 11, 2006 0:09:20 GMT
Still £5.90 better off than you tonight :-D
|
|
|
Post by orrible on Dec 11, 2006 9:48:26 GMT
as i said...
|
|
ed
County Player
Posts: 452
|
Post by ed on Dec 11, 2006 17:45:09 GMT
I'd need that to get on the list having played non-premier pool for the last few seasons! Only prob with averaging over 50 games is that new players could only get ranked after more than 2 seasons... ? actually, it was playing at least 40 games (I miscounted!). The cup games aren't recorded and often aren't sent in - too much hastle me thinks. You'll just have to stop rearranging games!!
|
|
|
Post by shadydaz on Dec 13, 2006 9:26:26 GMT
This isnt that difficult to do. I already have spreadsheets set up to give season figures, percentages and total games played. At the moment i am incorperating a running totals sheet for my team which will automatically picked out the required info from each season and total it up to give overall %, total games played, total games won, winning streaks etc. If the records are there and you want to use this database as a template just give me a shout. It is still a work in progress so not quite ready. It only takes me 30 seconds to put my teams info in each week, so doing 80 players would take 5mins a week.
I know some of you think i am probably very sad- its true-there is no defence other than boredom in the evenings while my missus is at work!!
|
|
|
Post by orrible on Jan 9, 2007 17:16:30 GMT
This isnt that difficult to do. I already have spreadsheets set up to give season figures, percentages and total games played. At the moment i am incorperating a running totals sheet for my team which will automatically picked out the required info from each season and total it up to give overall %, total games played, total games won, winning streaks etc. If the records are there and you want to use this database as a template just give me a shout. It is still a work in progress so not quite ready. It only takes me 30 seconds to put my teams info in each week, so doing 80 players would take 5mins a week. I know some of you think i am probably very sad- its true-there is no defence other than boredom in the evenings while my missus is at work!! Can we change your name to "spreadsheet"? ;D
|
|
|
Post by shadydaz on Jan 12, 2007 10:21:18 GMT
This isnt that difficult to do. I already have spreadsheets set up to give season figures, percentages and total games played. At the moment i am incorperating a running totals sheet for my team which will automatically picked out the required info from each season and total it up to give overall %, total games played, total games won, winning streaks etc. If the records are there and you want to use this database as a template just give me a shout. It is still a work in progress so not quite ready. It only takes me 30 seconds to put my teams info in each week, so doing 80 players would take 5mins a week. I know some of you think i am probably very sad- its true-there is no defence other than boredom in the evenings while my missus is at work!! Can we change your name to "spreadsheet"? ;D ok!
|
|
ed
County Player
Posts: 452
|
Post by ed on Jan 17, 2007 22:31:40 GMT
POS ……… NAME ……… RANKING ……… +/- ……… TOTAL (LAST 4 SEASONS) 1 ……… S Rivers……... ……… 809 ……… -18 ……… (P 110 W 89 % 80.9 ) 2 ……… J Middleton…. ……… 750 ……… +5 ……… (P 116 W 87 % 75.0 ) 3 ……… M Conlon…….. ……… 728 ……… -9 ……… (P 103 W 75 % 72.8 ) 4 ……… I Norris………. ……… 716 ……… -5 ……… (P 74 W 53 % 71.6 ) 5 ……… R Cork………… ……… 688 ……… -4 ……… (P 109 W 75 % 68.8 ) 6 ……… A Richardson. ……… 676 ……… -27 ……… (P 68 W 46 % 67.6 ) 7 ……… J Nixon……….. ……… 675 ……… +8 ……… (P 114 W 77 % 67.5 ) 8 ……… P Stelmaszuk. ……… 667 ……… +7 ……… (P 54 W 36 % 66.7 ) 9 ……… M O'Boyle……. ……… 654 ……… +8 ……… (P 52 W 34 % 65.4 ) 10 ……… S Magrath…... ……… 652 ……… -8 ……… (P 112 W 73 % 65.2 ) 11 ……… E Savory……… ……… 629 ……… +15 ……… (P 105 W 66 % 62.9 ) 12 ……… D Barton……… ……… 625 ……… = ……… (P 48 W 30 % 62.5 ) 13 ……… P Mcgannon… ……… 620 ……… = ……… (P 50 W 31 % 62.0 ) 14 ……… N Williamson.. ……… 615 ……… +6 ……… (P 91 W 56 % 61.5 ) 14 ……… M Bradford….. ……… 615 ……… -11 ……… (P 96 W 59 % 61.5 ) 16 ……… D Cobley…….. ……… 607 ……… +5 ……… (P 117 W 71 % 60.7 ) 16 ……… G Cassidy……. ……… 607 ……… = ……… (P 89 W 54 % 60.7 ) 16 ……… M Fisher……… ……… 607 ……… = ……… (P 61 W 37 % 60.7 ) 19 ……… A Greenley….. ……… 603 ……… +12 ……… (P 68 W 41 % 60.3 ) 20 ……… S Osbourn…… ……… 600 ……… +14 ……… (P 60 W 36 % 60.0 ) 21 ……… B Lindsey……. ……… 588 ……… -14 ……… (P 114 W 67 % 58.8 ) 22 ……… S Allen………… ……… 583 ……… -4 ……… (P 96 W 56 % 58.3 ) 23 ……… K De La Riva… ……… 574 ……… = ……… (P 47 W 27 % 57.4 ) 24 ……… J Mayes………. ……… 573 ……… +4 ……… (P 75 W 43 % 57.3 ) 25 ……… J Clements….. ……… 563 ……… = ……… (P 48 W 27 % 56.3 ) 26 ……… P Brassnett….. ……… 560 ……… -3 ……… (P 84 W 47 % 56.0 ) 27 ……… A Steel………… ……… 545 ……… = ……… (P 66 W 36 % 54.5 ) 28 ……… S Kinnley…….. ……… 544 ……… = ……… (P 90 W 49 % 54.4 ) 29 ……… C McDonald….. ……… 539 ……… +5 ……… (P 76 W 41 % 53.9 ) 30 ……… K Sweeney….. ……… 538 ……… = ……… (P 78 W 42 % 53.8 ) 30 ……… C Patient…….. ……… 538 ……… = ……… (P 80 W 43 % 53.8 ) 32 ……… M Colville…….. ……… 528 ……… +13 ……… (P 72 W 38 % 52.8 ) 33 ……… D Graham……. ……… 526 ……… = ……… (P 57 W 30 % 52.6 ) 34 ……… M Cullen……… ……… 523 ……… +23 ……… (P 44 W 23 % 52.3 ) 35 ……… M Early……….. ……… 520 ……… -5 ……… (P 100 W 52 % 52.0 ) 35 ……… L Vargas……… ……… 520 ……… = ……… (P 50 W 26 % 52.0 ) 37 ……… A Plumb………. ……… 516 ……… = ……… (P 64 W 33 % 51.6 ) 38 ……… A Armstrong… ……… 512 ……… -25 ……… (P 86 W 44 % 51.2 ) 39 ……… W Martin…….. ……… 509 ……… -10 ……… (P 112 W 57 % 50.9 ) 40 ……… M Benson…….. ……… 507 ……… +7 ……… (P 67 W 34 % 50.7 ) 41 ……… R Lemmon…… ……… 500 ……… = ……… (P 84 W 42 % 50.0 ) 41 ……… N Caldecote…. ……… 500 ……… = ……… (P 52 W 26 % 50.0 ) 42 ……… S McCann……. ……… 500 ……… new ……… (P 40 W 20 % 50.0 ) 43 ……… S Griffiths…… ……… 480 ……… +1 ……… (P 75 W 36 % 48.0 ) 44 ……… D Taylor……… ……… 477 ……… new ……… (P 44 W 21 % 47.7 ) 45 ……… E Pride……….. ……… 475 ……… = ……… (P 61 W 29 % 47.5 ) 45 ……… A Canning……. ……… 475 ……… = ……… (P 40 W 19 % 47.5 ) 46 ……… G Penny……… ……… 475 ……… = ……… (P 40 W 19 % 47.5 ) 47 ……… D Hart…………. ……… 473 ……… = ……… (P 55 W 26 % 47.3 ) 48 ……… B Brownlie…… ……… 472 ……… = ……… (P 53 W 25 % 47.2 ) 49 ……… C Marchant….. ……… 468 ……… -9 ……… (P 77 W 36 % 46.8 ) 50 ……… A Taylor………. ……… 463 ……… new ……… (P 41 W 19 % 46.3 ) 51 ……… A Drew……….. ……… 444 ……… -26 ……… (P 72 W 32 % 44.4 ) 52 ……… C Benstock….. ……… 434 ……… +15 ……… (P 99 W 43 % 43.4 ) 53 ……… A Pavlaki…….. ……… 417 ……… +26 ……… (P 48 W 20 % 41.7 ) 54 ……… R Joyce……….. ……… 405 ……… +17 ……… (P 84 W 34 % 40.5 ) 55 ……… L Jaffery……… ……… 387 ……… -6 ……… (P 62 W 24 % 38.7 ) 56 ……… S Fegan………. ……… 382 ……… = ……… (P 55 W 21 % 38.2 ) 57 ……… J Vargas……… ……… 381 ……… = ……… (P 42 W 16 % 38.1 ) 58 ……… D Kidd…………. ……… 380 ……… -16 ……… (P 50 W 19 % 38.0 ) 59 ……… E Harrison…… ……… 375 ……… = ……… (P 56 W 21 % 37.5 ) 60 ……… A Cockbill……. ……… 375 ……… = ……… (P 40 W 15 % 37.5 ) 61 ……… G Dougal…….. ……… 357 ……… = ……… (P 56 W 20 % 35.7 ) 62 ……… M Whalley…… ……… 349 ……… +18 ……… (P 83 W 29 % 34.9 ) 63 ……… C Macmillan… ……… 340 ……… = ……… (P 50 W 17 % 34.0 ) 64 ……… M Cook……….. ……… 318 ……… = ……… (P 44 W 14 % 31.8 ) 65 ……… J Wilson……… ……… 316 ……… = ……… (P 95 W 30 % 31.6 ) 66 ……… M Howell…….. ……… 308 ……… -12 ……… (P 52 W 16 % 30.8 )
|
|
ed
County Player
Posts: 452
|
Post by ed on Jan 17, 2007 22:34:26 GMT
Jim's off the bottom!
|
|
chris
Should take up another sport!
Posts: 6
|
Post by chris on Jan 17, 2007 22:59:15 GMT
hi mate these look great just a couple of queastions,are these just league matches and do they have this season games or you adding them on at the end of the season
cheers
chris
|
|
ed
County Player
Posts: 452
|
Post by ed on Jan 17, 2007 23:02:43 GMT
they contain all the league games (and no other games) from the current season and the previous 3 seasons before that (i.e. 2 summer leagues and a winter league. Condition of being ranked is playing >40 games over that period
|
|
chris
Should take up another sport!
Posts: 6
|
Post by chris on Jan 17, 2007 23:05:35 GMT
well its great and perhaps i with alittle help from others i can do a singles handicap
|
|
ed
County Player
Posts: 452
|
Post by ed on Jan 17, 2007 23:06:42 GMT
well its great and perhaps i with alittle help from others i can do a singles handicap thanks mate
|
|
|
Post by schmack on Jan 17, 2007 23:14:30 GMT
cracking piece of work Ed
All i need to do now is play for another 3 seasons and i might get on this!! lol
|
|
|
Post by orrible on Jan 18, 2007 1:03:34 GMT
golly gosh. can we have a league on the most posts on here? ;D
|
|