Flaw in my logic...

[How_Do_I]

This is a strange one… somewhere along the lines there is a flaw in my logic… I’ve spent a long time thinking about this and I just can not see where I’m going wrong…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I’m working on the basis of in a football league of 24 teams every team will play each other in week 1 to week 23… At week 24 the reverse fixtures commence… (Team A v Team B… the reverse fixture is Team B v Team A)…
<o></o>
If I drag the formulas across in my 1<SUP>st</SUP> Jeanie to Week 46 and then SUM the highlighted ROWS I get a set of values…
<o></o>

Excel Workbook
	BR	BS
6	Away Win	2
7	Away Draw	0
8	Away Loss	2
9	Reverse Home Draw	6
10	Away Win	2
11	Away Draw	3
12	Away Loss	1
13	Reverse Home Loss	2
14	Away Win	0
15	Away Draw	0
16	Away Loss	2
17	Week	24
Six Points

<o></o>
In the Jeanie below I have used a different formulas as this time I am trying to get the data by teams and not weeks. If I drag the formulas across for the 24 teams and SUM the rows I get the SAME results as in the 1<SUP>st</SUP> Jeanie….
<o></o>
However if I SUM the columns in this Jeanie why don’t I get 12 for the 12 reverse fixtures played by each time… Note if I total the SUMS (at the end of each ROW I get 276 which is correct i.e. 276 reverse fixtures… My problem is, why don’t the columns of the 2<SUP>nd</SUP> Jeanie add up to 12… What am I missing please?
<o></o>

Excel Workbook
	AJ	AK	AL
36	Reverse Home Win
37	Home Win	2	3
38	Home Draw	1	0
39	Home Loss	3	3
40	Reverse Home Draw
41	Home Win	2	2
42	Home Draw	0	1
43	Home Loss	0	0
44	Reverse Home Loss
45	Home Win	1	1
46	Home Draw	2	0
47	Home Loss	0	2
Output

 

[taurean]

Yes the distribution is even exactly along the lines as you wrote…
<!--?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /--><o></o>
In the Jeanie in post #8 you can see that in C26:C48 there are 12 Barnsley that have 24 or above in A26:A48 where for <!--?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /--><st1lace w:st="on"><st1lacename w:st="on">Bristol</st1lacename> <st1lacetype w:st="on">City</st1lacetype></st1lace> there are 11 that meet the criteria…
<o></o>
I just thought they’d be the same amount of games per team per half season for some reason but, there isn’t and I can’t think of an explanation for that.
As you said if there are 23 weeks until half season then a team can not play 11.5 match though...

Looking at your data more closely, this is mere stating of obvious:

--> Barnsley plays HOME game on "Even" Weeks e.g. 2, 4, 6 etc.
--> Barnsley plays AWAY game on "Odd" Weeks e.g. 1, 3, 5 etc.

So when you will check total for Barnsley for first 23 weeks then it will have
12 odd weeks and 11 even weeks so their total will be always 12 for first half.

And when you check total for Barnsley for second half of the season it will have exactly reverse situation i.e. 11 odd weeks and 12 even weeks. So for HOME game Barnsley will have totals as 11 and 12 in the first and second half respectively and vice versa for AWAY games.

------------------------------------------------------------------------
Exact opposite will be : Bristol City.
------------------------------------------------------------------------

Are we still missing something?

 

[How_Do_I]

No. You are spot on... It just wasn't what I expected before we starting digging deeper in to how the fixtures are set up...

 

[taurean]

Glad that it was sorted. Importantly, the formulas are correct.

And perhaps this is Football (English League)...never went beyond Man United...!

 

[How_Do_I]

English football is not as good as some folk think at the moment... A couple of the minor teams (City and Spurs) have their best teams in years, whereas the established teams have their worst teams in years (Chelsea and United)... That said, I think most of my woes are caused by Chelsea's manager.