Fantasy Football League

[1964white]

PLAYERS/TEAMS

Dr's Dad - Arsenal
Ratscoot - Middlesbro'
Genghers - Southampton
Andy Watson - Wycombe Wanderers
MOTliam - York City
Gandi - Leeds United
Kyle - Swindon Town
Woody - Accrington Stanley
Bob Hirst - Wigan
Hector - Portsmouth
1304 - Bristol City
Mango - Brentford
Rich 64 - Leyton Orient
BB - Doncaster Rovers
Paddy - Millwall
CptCrash - Luton Town
Ges - Sheffield United
Mrs 64 - Cardiff City
Hibbi - Wolves
Norm - Burnley
MeeTa - Manchester City
Jamie - Preston North End
lusutd - Derby County
Velo - Chesterfield
Leedsalex - Swansea City
Whiteswan - Burton Albion
Dezzy - Hull City
Wolfie - Fleetwood
Leedsmad - Bradford City
Dr.Leeds - Oxford United
64 - Chelsea
Pat Hirst - Manchester Utd

Round 1

SATURDAY RESULTS

Chesterfield 3-2 Hull City
Burnley 1-4 Swindon Town
Bristol City 0-2 Brentford
Doncaster Rovers 1-2 Swansea City
Cardiff City 1-1 Manchester Utd
Oxford United 1-2 Millwall
Derby County 0-0 York City
Fleetwood Town 1-1 Accrington Stanley
Wigan 0-1 Luton Town
Chelsea 2-2 Leyton Orient
Wolverhampton Wanderers 2-0 Sheffield United
Wycombe Wanderers 3-1 Leeds United

SUNDAY 8th AUGUST

Bradford City v Middlesbro'
Preston v Portsmouth
Southampton v Burton

MONDAY 9th AUGUST

Arsenal v Manchester City

Table to follow after the Gooners v Citeh game

[1964white]

No other imput required on this thread from anyon until the weekend when i shall post up the scores & table in this crazy competition

By all means make comments if you feel the need to when the Round One results are in

[1964white]

Each team on the list plays each other twice over the season

2 points for a win
1 point for a draw
1 point for scoring three goals or more
1 point for keeping a clean sheet
1 point for no yellow/red cards during a match
1 point deducted for a team who incurs 3 yellow cards
2 points deducted for a team who incurs 6+ yellow cards
2 points deducted for a team who incurs a red card, two red cards 4 points deducted

For example if we have four players & their teams

Ges - Walsall
BB - Doncaster Rovers
Gandi - Chelsea
Nick - Man Utd_____Sorry Nick

Official results on the day

Chelsea 1-1 Man City______________Chelsea shown 3 yellowcards
Man Utd 0-1 Southampton__________Man U shown 1 yellow + 1 red card
Donny 3-1 Coventry
Walsall 4-0 Sheff Utd

Taking the scores from the official scores on the day & inserting them into our Fantasy League fixtures/results, they would read :

Donny 3-1 Chelsea
Walsall 4-0 Man U

So the points scored would be

Walsall___ +2, +1, +1, +1 = 5
Donny____ +2, +1, +1 = 4
Chelsea___ -1 = -1
Man Utd___ -2 = -3

Table after Round One

Ges (Walsall) 5
BB (Donny) 4
Gandi (Chelsea) -1
Nick (Man Utd) -3

So as you can see although your team may have won or drawn on the day the result could be completely different in our crazy Fantasy League. It is more about goals scored & good discipline which determines the outcome of each round of matches

[1964white]

Screenshot 2015-08-09 at 15.55.53.png

Bradford 1-0 Middlesbro'
Preston 0-3 Portsmouth
Southampton 2-2 Burton
Arsenal 0-3 Machester City

[Gandalf]

Ignore

[1964white]

Hope to post this table on a spreadsheet, just waiting on some advice. Bear with me folks !

FANTASY FOOTBALL LEAGUE TABLE

+5 Portsmouth
+4 Luton
+4 Manchester City
+3 Brentford
+3 Bradford
+3 Chesterfield
+2 Derby
+2 Millwall
+2 Swindon
+2 Wolves
+2 Wycombe
+2 York
+1 Accrington
+1 Burton
+1 Cardiff
+1 Doncaster
+1 Fleetwood
+1 Manchester Utd
+1 Swansea
=0 Arsenal
=0 Burnley
=0 Hull
=0 Leeds
=0 Leyton
=0 Middlesbro'
=0 Oxford
=0 Preston
=0 Sheffield Utd
=0 Southampton
-1 Bristol City
-1 Chelsea
-1 Wigan

[1964white]

ROUND 2

Hull City v Preston North End
Swindon Town v Portsmouth
Brentford v Chesterfield
Swansea City v Burnley
Manchester United v Bristol City
Middlesborough v Doncaster Rovers
Millwall v Cardiff City
York City v Bradford City
Burton Albion v Oxford United
Accrington Stanley v Derby County
Luton Town v Southampton
Leyton Orient v Fleetwood Town
Manchester City v Wigan
Sheffield United v Chelsea
Leeds United v Arsenal
Wycombe Wanderers v Wolverhampton Wanderers

[1964white]

Screenshot 2015-08-17 at 20.52.46.png

[1964white]

FANTASY FOOTBALL LEAGUE TABLE - ROUND 2

+8 Luton
+7 Manchester City
+7 Brentford
+6 Derby
+5 Cardiff
+5 Portsmouth
+5 Leyton
+5 Middlesbro'
+4 Bradford
+3 Arsenal
+3 Chesterfield
+3 Swindon
+3 Wolves
+3 Wycombe
+3 York
+3 Oxford
+3 Sheffield Utd
+2 Doncaster
-2 Preston
+2 Swansea
+1 Millwall
+1 Accrington
+1 Burton
+1 Fleetwood
+1 Manchester Utd
+1 Hull
=0 Burnley
-1 Leeds
-1 Southampton
-1 Bristol City
-1 Chelsea
-1 Wigan

[1964white]

Round 3 for this weekend's fixtures

Preston North End v Swindon Town
Hull City v Brentford
Portsmouth v Swansea City
Chesterfield v Manchester United
Burnley v Middlesborough
Bristol City v Millwall
Doncaster Rovers v York City
Cardiff City v Burton Albion
Bradford City v Accrington Stanley
Oxford United v Luton Town
Derby County v Leyton Orient
Southampton v Manchester City
Fleetwood Town v Sheffield United
Wigan v Leeds United
Chelsea v Wycombe Wanderers
Arsenal v Wolverhampton Wanderers

[hibbi86]

Hope you dont mind 64 but i created a little table im trying to write some VBA code to input all the data for me but that will take some time



i note you have preston down as -2 but they are halfway up the list? should they be 2 or -2

[1964white]

Hope you dont mind 64 but i created a little table im trying to write some VBA code to input all the data for me but that will take some time



i note you have preston down as -2 but they are halfway up the list? should they be 2 or -2

I love the idea I just felt it would be too much work for me especially as i'm not ofay with computing as most are on here. Would you like to assist me each week Hibbi & post up a table after each round of games ?

Do you think we need to include in the table graph where teams gain or lose points ?

Amazingly Preston gained 2 points for their win plus a bonus point for keeping a clean sheet then lost 2 points for a red card & lost 1 point for 3+ yellows ending up with zero this weekend
Preston should have a score of +2 btw gained in their first match so they are mid-table not bottom

I shall include all the points gained & lost in next week's results list & if you agree you could post up a league table for us all. Looks far more interesting mate

[hibbi86]

Hi Leon,

yeah i dont mind at all, i was going to try and include a Yellow (Y) and Red (R) Card tally in there also. If you want to post up the results as you are doing in its present format i can rework the data into this table format. I spend my lunch hours playing around with Excel and Formulas. So i am more than happy to complete a weekly running table in this format from your data.

if you want me to include the R and Y cards then is it possible for you to show them in your results.

[1964white]

Hi Leon,

yeah i dont mind at all, i was going to try and include a Yellow (Y) and Red (R) Card tally in there also. If you want to post up the results as you are doing in its present format i can rework the data into this table format. I spend my lunch hours playing around with Excel and Formulas. So i am more than happy to complete a weekly running table in this format from your data.

if you want me to include the R and Y cards then is it possible for you to show them in your results.

Great thanks for your help, much appreciated Matt

Between us we'll try come up with as much information as possible. I see one of our fantasy teams Arsenal don't play until Monday night so the next Results/Tables will probably be posted up midweek

[hibbi86]

Thats fine,

i have a written some very simple excel codes that can auto complete the majority of the data, I assume you already have the fixture lists for all the rounds in the season?

If you have this then i could complete the workbook now and it would only need some small data inputting each week and it would auto complete the rest

[1964white]

Thats fine,

i have a written some very simple excel codes that can auto complete the majority of the data, I assume you already have the fixture lists for all the rounds in the season?

If you have this then i could complete the workbook now and it would only need some small data inputting each week and it would auto complete the rest

Nice one you clever man, top work Matt

[hibbi86]

Once ive completed the whole thing i will send you a copy, So you can see how it all works. I will still add the table for you on a weekly basis

[ldsutd]

Well done guys I can only just manage to write on a forum I wouldn't have a clue where to start with all this spread sheet/excel stuff. I looks very neat and a professional job.

[hibbi86]

Alot of it has been self taught,

I remember when as a kid in maths i used to say why the hell do we use Algebra i would never need that in my life.
Excel is basically Algebra haha. I wish i would have listened more during those math lessons i would certainly know alot more now

[1964white]

Once ive completed the whole thing i will send you a copy, So you can see how it all works. I will still add the table for you on a weekly basis

Thank you Hibbi