fantasy EIHL League

Thread starter #1
Well, I know that Fantastar have one going, but if anyone is feeling like a scrounge on the run up to Christmas then i'll set my own up. Am doing a IT course at college so will be a decent test of my spreadsheet skills!

I'm unashamedly stealing Fantastars system, with a few small tweaks :D

A team consists of 18 players.
Only two can be selected from any team
1 goalie
4 British D men
3 Non-Brit D men
5 British forwards
4 Non-Brit forwards.
1 Enforcer, which shall have a different points system.

A brit is defined at per the EIHL rules, I believe hockeyDB give the payers nationalities for any borderline cases.

All Players will score:

1 point for every appearance.
3 points for every goal.
2 points for every assist.
1 point for every win.

A Goaltender will also score:

2 points for every shutout.
-1 point for every goal conceded.
4 points for every win.

Your specialist enforcer will score:

1 point for every fight
2 points for every 10 minute misconduct.
3 points for a game or match penalty.
He will also recieve the same points as a normal skater (goals, assists etc.)

As many as transfers as you like until the season officially starts (4th September). Any players who leave their clubs will be replaced by the clubs replacement.
In the week of January 1st to January 8th, each team will be allowed 3 transfers, to get rid of any bad underachievers!

Please send me your teams to sbp434@hotmail.com using the form:

Full Name:
Team Name:
Goalie:
Brit D-Men:
Import D-Men:
Brit Forwards:
Import Forwards:
Enforcer:
 
#2
Have set up my team, but could I PM it to you instead as I don't have email access from work.

Also, would it be a good idea to tweak the fight system a bit so an enforcer gets a point for dropping the gloves, and extra point or two for a win?
 
Thread starter #3
No worries about the PM, please send to me as and when you can.
I was discussing the fight system with a friend, and as i'd only be taking the penalties, or fights, off ih-update & texts from friends at the games, a 'win' system can't really work, especially as friends at the game will normally be biased towards their particular fighter.
Cheers, Jamie.
 
Thread starter #4
These are the updated, and final, rules, after some very helpful ideas from the guys over at FireAndIce(thaks!).

Well, I know that Fantastar have one going, but if anyone is feeling like a scrounge on the run up to Christmas then i'll set my own up. Am doing a IT course at college so will be a decent test of my spreadsheet skills!

I'm unashamedly stealing Fantastars system, with a few small tweaks :D

A team consists of 18 players.
Only two can be selected from any team
1 goalie
4 British D men
3 Non-Brit D men
5 British forwards
4 Non-Brit forwards.
1 Enforcer, which shall have a different points system.

A brit is defined at per the EIHL rules, I believe hockeyDB give the payers nationalities for any borderline cases.

All Players will score:

3 points for every goal.
A bonus 5 points for a hat-trick (3 goals).
2 points for every assist.
1 point for every win.

A Goaltender will also score:

1 point for starting the match.
15 points for a goal
3 points for a assist
5 points for every shutout.
-1 point for every goal conceded.
3 points for every win.


Your specialist enforcer will score:

1 point for every fight
2 points for every 10 minute misconduct.
3 points for a game or match penalty.
1 point for a goal or assist.

As many as transfers as you like until the season officially starts (4th September). Any players who leave their clubs will be replaced by the clubs replacement.
In the week of January 1st to January 8th, each team will be allowed 3 transfers, to get rid of any bad underachievers!

Please send me your teams to sbp434@hotmail.com using the form:

Full Name:
Team Name:
Goalie:
Brit D-Men:
Import D-Men:
Brit Forwards:
Import Forwards:
Enforcer:
 
#5
Fair point about the fight results. I was just thinking of a few extra points in the event of a clear win or knockdown, although with jersey pullers like McMorrow, a true knockdown could be disputed.

Like the idea of 15 points for a goalie goal too. Don't think I've ever seen one in the Elite League although I've seen Stevie Lyle shoot at an empty net a few times!
 
Thread starter #6
No worries, to be honest, I think my friends who will be sending me penalties and goals updates will say that Ryan Finnerty beat up McMorrow just to stick up for their club!
Ive only seen one, back in the early EIHL days when Sundberg hit a empty net goal in our barn :D Oh well, you never know!
Jamie
 
#7
Just in case anyone wants to get involved in this and keep track of their own team, I've knocked up a quick spreadsheet where you can enter your own team's stats and it will automatically calculate the points for you.

I've knocked it up in Openoffice, but it should work in any version of Excel.

Paganpanther, if you want to borrow any of the formulae for your master sheet, feel free.
 

Attachments

Thread starter #8
Thanks a lot Ghost Dog, much appreciated.
I've just finished setting mine up, slightly different to that but I'm fairly sure both versions work just as well!
Will be posting updates on the leaderboard across the forums on a Tuesday or Wednesday, but anyone who wants to keep track of their own, many thanks to Ghost Dog for setting this up :)

Jamie
 
Thread starter #9
Hi everyone!
Sorry about the delay to getting this up, there were a few small problems with the spreadsheet i'm using (me making most of them)! They've all been sorted, and i'm now proud to be able to get the table up with the first weekends games on them.

EIHL Fantasy League 2010
1) Gedling All Stars 60
2) Andy’s All Stars 59
3) Average Joes 55
4) The Munnster 53
5) Hitmen 49
6) Basford Phantoms 47
7) Team Fanta 47
8) Outlaws Team 47
9) Cage Renegades 47
10) Jukebox Hero 46
11) Cakeboys 46
12) The Crusaders 46
13) Long Eaton Lounge Lizards 45
14) The Evtushock Aftershock 44
15) Dizzle’s Destroyers 44
16) Roxie’s Team 43
17) Hollies 43
18) Pagan Panthers 42
19) Wright Offs 42
20) Team Gemma 42
21) Coreys Kids Picked My Team 42
22) Tantra Temptation 42
23) Ravens Rejects 41
24) Johnnos Allstars 41
25) Chig 41
26) Icers 40
27) Michael Hunt UK Tour 38
28) Lee’s Team 38
29) Lou’s Elite 38
30) Partick Clan 38
31) Tykes R Us 37
32) Beeston Panthers 36
33) Matts Mosquitos 35
34) Teamp Champ 35
35) Cardiff Predators 34
36) ChickenAndChipsAndThatsALovelyFence 34
37) Grumpy Miners 2010 34
38) Pink Panthers 34
39) Peters Pirates 34
40) A Town Called Google 31
41) Bowens Bunch 30
42) Hockey Jockey 29
43) Outlaw Torn 28
44) Blah Blah Blades 24
 
Thread starter #11
EIHL Fantasy League 2010 - 13/9/2010
1) Andy’s All Stars 126
2) Hitmen 120
3) The Evtushock Aftershock 118
4) Basford Phantoms 115
5) Gedling Allstars 112
6) Dizzle’s Destroyers 111
7) Average Joes 108
8) Long Eaton Lounge Lizards 107
9) The Munnster 106
10) Team Fanta 105
11) Tantra Temptation 104
12) Cage Renegades 100
13) Coreys Kids Picked My Team 99
14) Johnnos Allstars 99
15) Team Gemma 98
16) Ravens Rejects 98
17) Cake Boys 96
18) Partick Clan 96
19) Roxies Team 96
20) Chig 95
21) Outlaws Team 94
22) Crusaders 93
23) Wright Offs 93
24) Lees Team 90
25) Jukebox Hero 89
26) Tykes R Us 89
27) Hollies 88
28) Michael Hunt UK Tour 87
29) Grumpy Miner 2010 86
30) Pagan Panthers 85
31) Beeston Panthers 83
32) Lous Elite 79
33) Pink Panthers 75
34) Icers 75
35) Team Champ 73
36) Outlaw Torn 73
37) Matts Mosquitos 72
38) ChickenAndChipsAndThatsALovelyFence 72
39) A Town Called Google 65
40) Hockey Jockey 64
41) Cardiff Predators 64
42) Bowens Bunch 59
43) Blah Blah Blades 59
44) Peters Pirates 54
 
Thread starter #13
EIHL Fantasy League 2010
1) The Evtushock Aftershock 176
2) Andy’s AllStars 175
3) Basford Phantoms 172
4) Gedling Allstars 171
5) Dizzles Destroyers 160
6) Cage Renegades 160
7) Tantra Temptations 159
8) Team Fanta 158
9) Average Joes 158
10) Team Gemma 157
11) Long Eaton Lounge Lizards 157
12) The Munnster 156
13) Hitmen 154
14) CakeBoys 153
15) The Crusaders 151
16) Partick Clan 148
17) Michael Hunt UK Tour 147
18) Roxies Team 146
19) Outlaws Team 145
20) Johnnos Allstars 143
21) Pagan Panthers 141
22) Coreys Kids Picked My Team 141
23) Chig 140
24) Ravens Rejects 140
25) Wright Offs 139
26) Lees Team 138
27) Juke Box Hero 133
28) Tykes R Us 131
29) Hollies 131
30) Grumpy Miners 2010 130
31) SabresAndPanthers 130
32) Outlaw Torn 127
33) Icers 127
34) Team Champ 127
35) Beeston Panthers 125
36) Matts Mosquitos 124
37) Lous Elite 119
38) ChickenAndChipsAndThatsALovelyFence 115
39) Cardiff Predators 114
40) Peters Pirates 114
41) Pink Panthers 112
42) Hockey Jockey 109
43) Town Called Google 106
44) Bowens Bunch 99
45) Blah Blah Blades 99
 
Top