Quote ="FoxyDread"You are quite right but i´ve fallen in love with Excel spreadsheets. With a new bit of excel know how it only took a few minutes to create, and it does have real life applications, gambling for example.'"
If you are looking to gamble (any more seriously than just for fun) I really wouldn't do so based on your season long predictions. There are so many uncertainties involved over the course of a season (the main one being injuries) that if you want to successfully gamble you need to make a spreadsheet that predicts the outcome of individual matches (that way you can make a lot of small bets and the uncertainties should average out).
I'm currently making a program (I'm using Matlab) that analyses previous results of matches and will hopefully predict the winner of future matches with a decent accuracy. I'm designing my program for women's Australian basketball as this is pretty much the most obscure team sport, in which draws are unlikely (makes my program much simpler), which you can place bets on - based on the idea that the odds for these matches are far more erratic (pretty much chosen at random) so there is more chance of consistently beating the bookies odds.
Just out of interest, given the relative ratings of each team how are you predicting the winner of match? Are you using form from last season to make predictions or are are you updating and using form from the current season? i.e. if Wigan were to lose the first 10 games of the season would your spreadsheet be able to take this into account, lower the odds of them winning future games and thus make an updated simulation of the remaining season?