Predictions for Tuesday's Championship games

[chappyblue]

Burnley vs West Ham United 1-2
Crewe Alexandra vs Derby County 0-2
Ipswich Town vs Rotherham United 3-0
Leeds United vs Sheffield United 2-2
Leicester City vs Wolverhampton Wanderers 1-1
Plymouth Argyle vs Watford 2-1
Preston North End vs Brighton and Hove Albion 2-0
Queens Park Rangers vs Gillingham 2-2
Stoke City vs Cardiff City 3-1
Reading vs Millwall 1-0
Wigan Athletic vs Sunderland 1-1

 

[Brauny Blue]

Just the mere thought that MK is some kind of pervert

fear not brave brauny, i remain a paragon of virtue. a shining beacon for the true against the perversity of mankind.
it's just i said i'd help homer shift some grubby rodents...

Lazzer been round then.

Oh shite thats another apology i owe. Soz Lazzer its me and my over active keyboard.

 

[highland fox]

Burnley vs West Ham United (2-1)
Crewe Alexandra vs Derby County (0-2)
Ipswich Town vs Rotherham United (3-0)
Leeds United vs Sheffield United (1-1)
Leicester City vs Wolverhampton Wanderers (0-0)
Plymouth Argyle vs Watford (1-1)
Preston North End vs Brighton and Hove Albion (4-0)
Queens Park Rangers vs Gillingham (1-1)
Stoke City vs Cardiff City (2-0)
Reading vs Millwall (1-0)
Wigan Athletic vs Sunderland (1-2)

 

[cooperLCFCanstey]

Burnley vs West Ham United (2-3)
Crewe Alexandra vs Derby County (0-1)
Ipswich Town vs Rotherham United (3-0)
Leeds United vs Sheffield United (1-1)
Leicester City vs Wolverhampton Wanderers (2-0)
Plymouth Argyle vs Watford (1-1)
Preston North End vs Brighton and Hove Albion (2-2)
Queens Park Rangers vs Gillingham (1-0)
Stoke City vs Cardiff City (2-1)
Reading vs Millwall (0-0)
Wigan Athletic vs Sunderland (1-1)

 

[lazzer]

Just the mere thought that MK is some kind of pervert

fear not brave brauny, i remain a paragon of virtue. a shining beacon for the true against the perversity of mankind.
it's just i said i'd help homer shift some grubby rodents...

Lazzer been round then.

Oh shite thats another apology i owe. Soz Lazzer its me and my over active keyboard.

probably a bit tacky brauny after you viewing triple f mamas.com again :roll:

 

[Joe_Fox]

I've made a spreadsheet in which each entry has three columns for the corresponding local variables: 1 for the home score, one for the away score and one for the points gained (0,1 or 2)

There are two global variables in two columns as well: actual home score and actual away score.

To work out the points awarded for the prediction made I have come up with this formula (based around the key shown)

B2=actual home score
C2=actual away score
D2=predicted home score
E2=predicted away score

Here is the formula:

=IF(AND(D2=$B$2,E2=$C$2),3,IF(AND(D2=E2,$B$2=$C$2),1,IF(AND(D2=$B$2,E2>D2),1,IF(AND(E2=$C$2,D2>E2),1,IF(AND(D2>$B$2,E2>$C$2),1,IF(AND(D2=$B$2,E2<$C$2),0,IF(AND(D2=$B$2,E2>$C$2),0,0)))))))

I've tested all the possible deviations in the score line and it seems to be working well although I'm sure there is a shorter formula that does the same job.

Any ideas?

 

[Joe_Fox]

I think this does the same:

=IF(AND(B2=D2,C2=E2),3,IF(AND(B2>C2,D2>E2),1,IF(AND(B2=C2,D2=E2,B2>D2),1,IF(AND(B2=C2,D2=E2,B2<D2),1,0))))

N.B. $ to be added.

 

[alex]

I had an idea.

I thought that I may do a photography book, detailing on one page my day's diet and mirroring that with subsequent poos.

I was going to call it 'Eat Shit'.

 

[Joe_Fox]

Ok, both of the previous have flaws.

This is the correct one:

=IF(AND(B2=D2,C2=E2),3,IF(AND(B2>C2,D2>E2),1,IF(AND(B2<C2,D2<E2),1,IF(AND(B2=C2,D2=E2,B2>D2),1,IF(AND(B2=C2,D2=E2,B2<D2),1,0)))))

 

[Durham Fox]

Just been on an Advanced Excel course?

 

[highland fox]

:smt015

 

[Naughty Fox]

Joe Fox - most boring post of 2005 1st, second and third well done

 

[Steven]

Ok, both of the previous have flaws.

This is the correct one:

=IF(AND(B2=D2,C2=E2),3,IF(AND(B2>C2,D2>E2),1,IF(AND(B2<C2,D2<E2),1,IF(AND(B2=C2,D2=E2,B2>D2),1,IF(AND(B2=C2,D2=E2,B2<D2),1,0)))))

I am not sure what you are trying to do. :roll: :-( :-( :? :? Applying this formula to any cell always yields the answer 3. :roll: :-( :-(

 

[highland fox]

:smt015 :smt015 :smt015 :smt015

 

[Durham Fox]

:smt015 :smt015 :smt015 :smt015

:smt075 :smt015 HF - wake up!! Its OK, Joe has gone.

 

[SilverFox]

I've made a spreadsheet in which each entry has three columns for the corresponding local variables: 1 for the home score, one for the away score and one for the points gained (0,1 or 2)

There are two global variables in two columns as well: actual home score and actual away score.

To work out the points awarded for the prediction made I have come up with this formula (based around the key shown)

B2=actual home score
C2=actual away score
D2=predicted home score
E2=predicted away score

Here is the formula:

=IF(AND(D2=$B$2,E2=$C$2),3,IF(AND(D2=E2,$B$2=$C$2),1,IF(AND(D2=$B$2,E2>D2),1,IF(AND(E2=$C$2,D2>E2),1,IF(AND(D2>$B$2,E2>$C$2),1,IF(AND(D2=$B$2,E2<$C$2),0,IF(AND(D2=$B$2,E2>$C$2),0,0)))))))

I've tested all the possible deviations in the score line and it seems to be working well although I'm sure there is a shorter formula that does the same job.

Any ideas?

 

[highland fox]

Quiet on here today isn't it? No idea why though............

 

[highland fox]

Give Steven a sheet of 'Algebra' and he's as happy as a pig in shit.

 

[Durham Fox]

Quiet on here today isn't it? No idea why though............

Fear not HF, your old sparring partner DF is here.

 

[Steven]

:smt015 :smt015 :smt015 :smt015

:smt064 :smt087