T
Terry
Hi group
Automated league table
I have included 3 "snapshots" below as an illustration, so I hope I am not
in error doing so.?
Thus far I have utilised a soccer worksheet, but what I am unable to do is
add 2 columns in each of the sections named Home, Away, Overall and a
corresponing Total Shot Diff' column to enable me to include the "shots" for
and against,(as well as the scores already on). The shot scores are a in the
form of a number/dash/number (e.g. 45-23), just the same as in the
spreadsheet for scores (e.g. 3-2).
3 spreadsheets in the workbook...RESULTS, LEAGUE TABLES, and DATA.
The data has been amended to suit so far.
I expect an extra column will be required in the RESULTS sheet, to
accommodate "Shots Difference" total ?
I can email the above virus checked worksheet if you wish, because there are
many formulae on it which will require "tweaking" and near impossible to
relay via messaging. Majority of the formulae are VVlookup's.
The team names have been substuted here by using A to G.
Here is a snap shot of the "League table" sheet
Shots Diff' col.I have done
manually at present), the remainder is from the other 2 sheets.
League 2007-2008 Home Away Overall Total Shots
Position P W D L F A Pts P W D L F A Pts P W D L F A Pts Diff'
1 A 3 2 1 0 19 11 19 5 3 0 2 24 26 26 8 5 1 2 43 37 45 58
2 B 2 2 0 0 12 8 12 3 1 1 1 17 13 17 5 3 1 1 29 21 29 -29
3 C 1 1 0 0 8 2 8 1 0 1 0 5 5 5 2 1 1 0 13 7 13 78
4 D 2 1 0 1 10 10 10 0 0 0 0 0 0 0 2 1 0 1 10 10 10 -59
5 E 1 1 0 0 8 2 8 2 0 0 2 6 14 14 3 1 0 2 14 16 22 -133
6 F 3 1 0 2 14 16 16 2 0 0 2 6 14 14 5 1 0 4 20 30 30 39
7 G 2 0 1 1 9 11 11 1 0 0 1 2 8 8 3 0 1 2 11 19 19 78
Here is snapshot of "Results" sheet:
2007-2008 A B C D E F G
A - 5-5 6-4 8-2
B 8-2 -
C 4-6 - 5-5
D 4-6 - 6-4
E 8-2 -
F 6-4 - 6-4
G 4-6 8-2 2-8 -
Here is snapshot of the "Data" sheet:
Points Score Season
Home Win 10 2007-2008
Away Win 10
Draw 5
TIA
Terry
Automated league table
I have included 3 "snapshots" below as an illustration, so I hope I am not
in error doing so.?
Thus far I have utilised a soccer worksheet, but what I am unable to do is
add 2 columns in each of the sections named Home, Away, Overall and a
corresponing Total Shot Diff' column to enable me to include the "shots" for
and against,(as well as the scores already on). The shot scores are a in the
form of a number/dash/number (e.g. 45-23), just the same as in the
spreadsheet for scores (e.g. 3-2).
3 spreadsheets in the workbook...RESULTS, LEAGUE TABLES, and DATA.
The data has been amended to suit so far.
I expect an extra column will be required in the RESULTS sheet, to
accommodate "Shots Difference" total ?
I can email the above virus checked worksheet if you wish, because there are
many formulae on it which will require "tweaking" and near impossible to
relay via messaging. Majority of the formulae are VVlookup's.
The team names have been substuted here by using A to G.
Here is a snap shot of the "League table" sheet
Shots Diff' col.I have donemanually at present), the remainder is from the other 2 sheets.
League 2007-2008 Home Away Overall Total Shots
Position P W D L F A Pts P W D L F A Pts P W D L F A Pts Diff'
1 A 3 2 1 0 19 11 19 5 3 0 2 24 26 26 8 5 1 2 43 37 45 58
2 B 2 2 0 0 12 8 12 3 1 1 1 17 13 17 5 3 1 1 29 21 29 -29
3 C 1 1 0 0 8 2 8 1 0 1 0 5 5 5 2 1 1 0 13 7 13 78
4 D 2 1 0 1 10 10 10 0 0 0 0 0 0 0 2 1 0 1 10 10 10 -59
5 E 1 1 0 0 8 2 8 2 0 0 2 6 14 14 3 1 0 2 14 16 22 -133
6 F 3 1 0 2 14 16 16 2 0 0 2 6 14 14 5 1 0 4 20 30 30 39
7 G 2 0 1 1 9 11 11 1 0 0 1 2 8 8 3 0 1 2 11 19 19 78
Here is snapshot of "Results" sheet:
2007-2008 A B C D E F G
A - 5-5 6-4 8-2
B 8-2 -
C 4-6 - 5-5
D 4-6 - 6-4
E 8-2 -
F 6-4 - 6-4
G 4-6 8-2 2-8 -
Here is snapshot of the "Data" sheet:
Points Score Season
Home Win 10 2007-2008
Away Win 10
Draw 5
TIA
Terry