Round | 2016 Result | 2016 | 2015 | 2014 | 2013 | |||||||||
R1 v Carlton | 1-0 | 1-0 | 0-1 | 1-0 | ||||||||||
R2 v Collingwood | 1-1 | 1-1 | 1-1 | 2-0 | ||||||||||
R3 v Adelaide | 1-2 | 2-1 | 1-2 | 3-0 | ||||||||||
R4 v West Coke Eagles | 1-3 | 2-2 | 1-3 | 3-1 |
Round | 2016 Result | 2016 | 2015 | 2014 | 2013 | |||||||||
R1 v Carlton | 1-0 | 1-0 | 0-1 | 1-0 | ||||||||||
R2 v Collingwood | 1-1 | 1-1 | 1-1 | 2-0 | ||||||||||
R3 v Adelaide | 1-2 | 2-1 | 1-2 | 3-0 | ||||||||||
R4 v West Coke Eagles | 1-3 | 2-2 | 1-3 | 3-1 |
[size=10pt]PREnder[/size] | [size=10pt][/size] | [size=10pt]Round 14[/size] | [size=10pt]Result[/size] | [size=10pt]Cannot pick Round 15[/size] | [size=10pt]Round 15[/size] | [size=10pt]Result[/size] | [size=10pt]Cannot pick Round 16[/size] |
[size=10pt]evo[/size] | [size=10pt][/size] | [size=10pt]West Coast[/size] | [size=10pt][/size] | [size=10pt]WCE, Adel, GWS, St K[/size] | [size=10pt]Sydney[/size] | [size=10pt][/size] | [size=8pt]Syd, WCE, Ric[/size] |
[size=10pt]larabee[/size] | [size=10pt][/size] | [size=10pt]West Coast[/size] | [size=10pt][/size] | [size=10pt]WCE, Adel, GWS, St K[/size] | [size=10pt]Richmond[/size] | [size=10pt][/size] | [size=8pt]Ric, WCE, North, Syd[/size] |
[size=10pt]LeeToRainesToRoach[/size] | [size=10pt][/size] | [size=10pt]West Coast[/size] | [size=10pt][/size] | [size=10pt]WCE, Adel, GWS, St K[/size] | [size=10pt]Fremantle[/size] | [size=10pt][/size] | [size=8pt]Freo, WCE, Melb, Syd[/size] |
[size=10pt]Sammy C[/size] | [size=10pt][/size] | [size=10pt]West Coast[/size] | [size=10pt][/size] | [size=10pt]WCE, Adel, GWS, St K[/size] | [size=10pt]Sydney[/size] | [size=10pt][/size] | [size=8pt]Syd, WCE, Ric[/size] |
[size=10pt]scottyturnerscurse[/size] | [size=10pt][/size] | [size=10pt]Sydney[/size] | [size=10pt][/size] | [size=10pt]Syd, GWS, WCE, Coll[/size] | [size=10pt]Richmond[/size] | [size=10pt][/size] | [size=8pt]Ric, Syd, North, Coll[/size] |
PREnder | Round 14 | Result | Cannot pick Round 15 | Round 15 | Result | Cannot pick Round 16 | |
evo | West Coast | WCE, Adel, GWS, St K | Sydney | Syd, WCE, Ric | |||
larabee | West Coast | WCE, Adel, GWS, St K | Richmond | Ric, WCE, North, Syd | |||
LeeToRainesToRoach | West Coast | WCE, Adel, GWS, St K | Fremantle | Freo, WCE, Melb, Syd | |||
Sammy C | West Coast | WCE, Adel, GWS, St K | Sydney | Syd, WCE, Ric | |||
scottyturnerscurse | Sydney | Syd, GWS, WCE, Coll | Richmond | Ric, Syd, North, Coll |
Looks good
PREnder Round 14 Result Cannot pick Round 15 Round 15 Result Cannot pick Round 16 evo West Coast WCE, Adel, GWS, St K Sydney Syd, WCE, Ric larabee West Coast WCE, Adel, GWS, St K Richmond Ric, WCE, North, Syd LeeToRainesToRoach West Coast WCE, Adel, GWS, St K Fremantle Freo, WCE, Melb, Syd Sammy C West Coast WCE, Adel, GWS, St K Sydney Syd, WCE, Ric scottyturnerscurse Sydney Syd, GWS, WCE, Coll Richmond Ric, Syd, North, Coll
PREnder Round 14 Result Cannot pick Round 15 Round 15 Result Cannot pick Round 16 evo West Coast WCE, Adel, GWS, St K Sydney Syd, WCE, Ric larabee West Coast WCE, Adel, GWS, St K Richmond Ric, WCE, North, Syd LeeToRainesToRoach West Coast WCE, Adel, GWS, St K Fremantle Freo, WCE, Melb, Syd Sammy C West Coast WCE, Adel, GWS, St K Sydney Syd, WCE, Ric scottyturnerscurse Sydney Syd, GWS, WCE, Coll Richmond Ric, Syd, North, Coll
Did you have to type the values into individual cells, Yinnar? Or is there a way to create the table structure and paste the data in?
I have a macro in my Excel that just converts a range of selected cells off the worksheet into BB code and then puts the code into a text box to copy and paste.Did you have to type the values into individual cells, Yinnar? Or is there a way to create the table structure and paste the data in?
I can cut and paste straight from Excel into the post
PRENDER | Round 1 | Result | Cannot pick Round 2 |
14tempany | GWS | GWS, Freo | |
bandoftigers | Port Adelaide | Port, GWS | |
Bennnny | Port Adelaide | Port, GWS | |
Brodders17 | Port Adelaide | Port, GWS | |
capitaltige | GWS | GWS, Freo | |
craig | GWS | GWS, Freo | |
DanMinogue | Port Adelaide | Port, GWS | |
DavidSSS | GWS | GWS, Freo | |
Don Fraser | Geelong | Geel, Coll | |
gold1 | Port Adelaide | Port, GWS | |
grumpytige | Port Adelaide | Port, GWS | |
Jammo3368 | Essendon | Ess, Melb | |
JoMamma | GWS | GWS, Freo | |
larabee | Port Adelaide | Port, GWS | |
Letsroar | GWS | GWS, Freo | |
mainlandy | Geelong | Geel, Coll | |
Maneevo | Carlton | Car, Port | |
marella jube | GWS | GWS, Freo | |
Midsy | GWS | GWS, Freo | |
momentai | GWS | GWS, Freo | |
Mopsy | GWS | GWS, Freo | |
mrposhman | GWS | GWS, Freo | |
nqtiger | Port Adelaide | Port, GWS | |
OldTiger67 | Carlton | Car, Port | |
Platinum member | GWS | GWS, Freo | |
Quickdraw | Geelong | Geel, Coll | |
RoarEmotion | Port Adelaide | Port, GWS | |
Sammy Cougar | Port Adelaide | Port, GWS | |
Smoking Aces | Port Adelaide | Port, GWS | |
snags | GWS | GWS, Freo | |
Streak | Geelong | Geel, Coll | |
tbartiger | Carlton | Car, Port | |
Tigaman | Port Adelaide | Port, GWS | |
tigerdell | Port Adelaide | Port, GWS | |
tigerman | Port Adelaide | Port, GWS | |
Tigers of Old | Port Adelaide | Port, GWS | |
tigers1980 | Essendon | Ess, Melb | |
tommystigers | GWS | GWS, Freo | |
toothless | GWS | GWS, Freo | |
Total Tiger | Port Adelaide | Port, GWS | |
wayne | GWS | GWS, Freo | |
year of the tiger | Port Adelaide | Port, GWS | |
YinnarTiger | Essendon | Ess, Melb |
Position | 18-22 | 23-25 | 26-28 | 28-30 | 31+ |
Small Backs | Kaleb Smith | Liam Baker | |||
Daniel Rioli | |||||
Medium Backs | Tom Brown | Jayden Short | Nathan Broad | ||
James Trezise | Nick Vlaustin | ||||
Key Backs | Jacob Blight | Ben Miller | Dylan Grimes | ||
Josh Gibcus | Tylar Young | ||||
Midfielders | Sam Banks | Jack Ross | Jack Graham | Kamdyn McIntosh | Marlion Pickett |
Thompson Dow | Jacob Hopper | Dion Prestia | |||
Hugo Ralphsmith | Tim Taranto | ||||
Kane McAuliffe | |||||
Tyler Sonsie | |||||
Small Forwards | Seth Campbell | Shai Bolton | |||
Judson Clarke | Matt Coulthard | ||||
Steely Green | Ryan Mansell | ||||
Maurice Rioli | |||||
Medium Forwards | Noah Cumberland | Dustin Martin | |||
Tall Forwards | Jacob Bauer | Noah Balta | Mykelti Lefau | Tom Lynch | |
Liam Fawcett | Jacob Koschitzke | ||||
Campbell Gray | Samson Ryan | ||||
Rucks | Mate Colina | Toby Nankervis | Sam Naismith | ||
Oliver-Hayes Brown |