Hi
Is anyone good on excell.....
Trying to make something there that automatic count RPI for me in soccer games
Have "hand-calculated" 3 sesons of one soccer leauge..think I have found something out
But it had gone a lot faster to do it on excell....
If anyone is good on excell maybe can help me
I have no problem to type in the result and games of a leauge...but I have problem when trying to calculate the win% of oponents avrage
If anyone is good at excell but dont know what RPI is...
RPI = 0.25 * win% + 0.5 * oponents win% + 0.25 * oponents oponents win%
Any help is good help
BOL
Mikke
Is anyone good on excell.....
Trying to make something there that automatic count RPI for me in soccer games
Have "hand-calculated" 3 sesons of one soccer leauge..think I have found something out
But it had gone a lot faster to do it on excell....
If anyone is good on excell maybe can help me
I have no problem to type in the result and games of a leauge...but I have problem when trying to calculate the win% of oponents avrage
If anyone is good at excell but dont know what RPI is...
RPI = 0.25 * win% + 0.5 * oponents win% + 0.25 * oponents oponents win%
Any help is good help
BOL
Mikke