Originally Posted by runnaman
that, and the 2 in =F19+(C22/2) are the only random numbers, but they're in because they're the numbers that worked.
I see. Thanks for pointing out the other random number. I had not seen that one before.
It appears in the equation "Projected rating for a score of 51=F19+(C22/2)" that you divided the ratings points per stroke in half in order to add that half stroke to the average score. This makes some sense and is becuase the average score was about 50.5, which no one can actually shoot. But what happens when I repopulate the scores and player ratings for a different round and the average score is 50.0? I think at that point, the equation "rating for score of 51=F19+(C22/2)" will have an error by adding only half of cell C22 (rating points per stroke).
For example, I can change Gagne's score to 53. Doing so changes the average score to 51 exactly. The average rating is still 1018.25. So a score of 51 should = a rating of 1018. However, your spreadsheet is still adding that half stroke to the projected rating for 51 and giving a rating of 1024.