On a Friday, while the boss watches “Gardner’s world”, I usually plug into the Salut podcast and browse the SAFC world in general. But recently I’ve been keeping my spreadsheet skills up to date by practising inserting formulas so I thought I’d share this with you. It turned out to be a bit fiddly as I had to copy the spreadsheet formulae and then paste the lot into an HTML editor, which wasn’t as easy as it sounds, but it should work. If not I’m sure M. Salut will remove the post when he returns to duty.
To use the reckoner copy the table and paste it into the top left corner of an excel spreadsheet (starting the paste from square A1 should keep the formulae correct). Then type in the points gained for each game by clicking on the relevant cell and entering 1, 3 or zero. Go from the top downwards. It’s important to start from the top as some of the lower cells have formulae already entered and you don’t want to type over them. These formula will autocomplete some of the remaining cells, so e.g filling in the top cell for the Reading v QPR match (i.e. QPR’s points) will autocomplete the square for Reading’s points for the same game. Some of the squares are blank because these games only include one of the bottom teams. If you do find a formula comes up in the formula bar when you click on a cell in the spreadsheet then I suggest you leave it and move on to one which is empty. Generally speaking, the cells with a formula in will have a 3 in them at the start
(This has now been changed and will show a zero if you tweak the italics, see the comments below) .
This will change to reflect the actual points gained when you complete the complementary cell
You can add points as games progress or try predicting results. Have fun
|Salut Sunderland’s end of season predictor:|
|Reading||QPR||Fulham||Man City||W Ham|
|Norwich||Stoke||Villa||W Brom||Man City|