After each game the spreadsheet will be updated so we can track Pools's progress over the season.

Hi Stocksfield.
I may sound a bit thick here, but I don't understand how it works, is it possible for you to explain this in layman's terms?

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.

So far so good after 2 matches, predicted total points, 2.88, Pools have 4.
Now our attentions turn to the away match at Altrincham...