|
Sorry about the lameness of the spreadsheet -
It's not really meant as a tool so much as a display of what the SE would be in the event of specific match scores. The two teams in the match are 'WE' and 'THEY'. The number of match points scored by 'THEY' runs along the top of the sheet, and the number of points scored by 'WE' runs along the side. The cells in the middle contain basically a souped up version of the SE. It takes the Logarithm of the SE in order to make the distribution better, and then scales it so that the highest positive values lie somewhere around 1000 (which was just an arbitrary number).
The interesting thing that I was trying to show with the spreadsheet (and didn't) was that the SE is high when the team's scores are similar, and lower when they differ greatly.
I'm trying to come up with a way to scout teams and find the proverbial 'diamonds in the rough', and i figured that this was a start.
I'm posting an updated version of the spreadsheet that shows good SE's in green, average SE's in yellow, and bad SE's in red. This should make it easier to read
__________________
...Only a few people are awake and they live in a state of constant total amazement. -JP Shanley, Joe vs. the Volcano
|