by Stocksfield_Poolie » Fri Aug 15, 2025 3:20 pm
Thanks for your reply, yes hopefully I can!
Each game, I work out the chances of Pools winning, the chances of Pools losing and the chances of the draw.
So say for example, I think Pools have a 50% chance of winning a match, 25% chance of losing and 25% chance of winning.
I then work out what are the expected points to be gained from that match taking into account the chances of Pools winning and drawing.
So the % chance of a win multipled by 3 points then we add the % chance of a draw multiplied by 1 point and we get the expected points from that game.
So in the example, we get 50% of 3 plus 25% of 1 which gives an expected points from that game as 1.75.
I have split the spreadsheet into home, away and total points, expected and actual.
And then used a formula from these expected points and the actual gained points to calculate what will be the final points home, away and the total.
At the moment from these 2 matches Pools are expected to finish the season on around 62.44 points.
This will change from game to game and will give a good indication if Pools are doing well or not!
Hopefully that explains it in a way you can understand.