lansdowne
11-12-2006, 12:07 PM
I am trying to develop a spreadsheet to predict the outcome of Soccer Games
using Prof ELO rating method for chess players.
Each league has its own worksheet The Premier League example is:-
COL A COL B COL C COL D
TEAM MASTER HFORM AFORM
LIVERPOLL 1000 75 45
ARSENAL 1000 75 34
What I am trying to do is when I input the weeks matches in the match worksheet, as I enter the team name the data from a,b,c etc in the Premier League sheet is automatically put in the same boxes in the Match sheet. Then after the result is known and the teams new rating is calculated, the new rating overwrites the original rating in the Premier league sheet and then clears the match sheet ready for the next fixtures.The match sheet is thus :-
COL A COL B COL C COL D COL E COL F COL G COL H COL I
HFORM HMASTER HOME AWAY AMASTER AFORM HNEW ANEW RES
75 1000 LIVERPOOL ARSENAL 1000 34 988 1013 3
RES= (1=HOME WIN, 2= AWAY WIN, 3= DRAW)
Unfortunately being a VBA virgin (at 49!!!), I've searched the Excel program help andthe net but they all seem to suppose some VBA knowledge
Perhaps it is not possible to do, but I would be truly grateful( So would my long suffering wife!) if you could help.:mkay
Davey H
using Prof ELO rating method for chess players.
Each league has its own worksheet The Premier League example is:-
COL A COL B COL C COL D
TEAM MASTER HFORM AFORM
LIVERPOLL 1000 75 45
ARSENAL 1000 75 34
What I am trying to do is when I input the weeks matches in the match worksheet, as I enter the team name the data from a,b,c etc in the Premier League sheet is automatically put in the same boxes in the Match sheet. Then after the result is known and the teams new rating is calculated, the new rating overwrites the original rating in the Premier league sheet and then clears the match sheet ready for the next fixtures.The match sheet is thus :-
COL A COL B COL C COL D COL E COL F COL G COL H COL I
HFORM HMASTER HOME AWAY AMASTER AFORM HNEW ANEW RES
75 1000 LIVERPOOL ARSENAL 1000 34 988 1013 3
RES= (1=HOME WIN, 2= AWAY WIN, 3= DRAW)
Unfortunately being a VBA virgin (at 49!!!), I've searched the Excel program help andthe net but they all seem to suppose some VBA knowledge
Perhaps it is not possible to do, but I would be truly grateful( So would my long suffering wife!) if you could help.:mkay
Davey H