I thought I would post this link to Office Solver. This can be helpful when establishing point spreads in sports betting. I am working on a project and would like to ask for help from people with neural networks and AI experience. This could be fun and it will be profitable for the right person or group of people.
I have some other formulas to help derive at the proper point spread as well as handicapping formulas. I will be glad to correspond off forum. I do not wish to clutter the site.
Thanks again. – JG"
I. Ion Saliu's Answer: Evidently, SPORTS.XLS Is Pirated at Microsoft Office Site
What else is new about Microsoft? Windows was a copy of Mac, which in turn was a copy of Xerox. First, it was Lotus 1-2-3 — only after copying 1-2-3 was Microsoft able to create Excel… and so on… and so forth…
I don't know who you are, John Gator. But thanks for the information, axiomatic colleague of mine. I checked the link you provided. It appears to be genuinely a Microsoft domain (for Office Online).
The material at Microsofty.Office.com is barely a disguise of plagiarism and piracy of my spreadsheet known as SPORTS.XLS. It's been a free download since 2000. The Microsoft “author” doesn't make any effort to add something new to something he simply copied.
SPORTS.XLS takes into account the records of each team in two distinct categories: home record (host), and road record (visitor). For example, Team A has a home record of PointA11 – PointA12 and a visiting record of PointA21 – PointA22. Team B has a home record of PointB11 – PointB12 and a visiting record of PointB21 – PointB22.
Suppose Team B plays at Team A. You calculate the average of points scored at home by Team A and points allowed on the road by Team B:
Next, you calculate the average of points allowed at home by Team A and points scored on the road by Team B:
Make the deduction:
Of course, that's the ideal — call it the statistical ideal. It comes to life in around 65% of the situations (as far as I tested). No doubt, every week comes with a number of surprises or upsets. In the NFL, for example, around 1 in 3 games is a surprise.
One way to evaluate a team is to look at its offensive yards per play and defensive yards allowed per play. As you would expect, the team that outgains more than they allow, tend to win. This is not exclusively accurate. This measure is good to indicate or predict future performance. Using the Internet and Excel, you can evaluate the entire league in a few minutes.
Using a spreadsheet downloaded with stats from NFL.com Select regular season. At the bottom of the page under sortable team rankings there are offense and defense options.
This can be used to assist you analyzing point spreads.
As with all tools this is just a guide to help ascertain if the point spread is correct. – Johnny Gator"
"I am not really sure about Microsoft's thoughts or intentions, but thanks for the information. Sounds like you have a very strong case."
If you were a lawyer, we could have made big bucks!
I know about the stats at NFL.com. Most of the sports statistics, especially in the US, are worthless. Or, you might say, it's like eating spaghetti with a chainsaw. The TV sports guys sound like statistical maniacs at times. You would hear them present the weirdest of the facts wrapped as bright stats. Things like:
There are lots of stats at NFL.com. But they are a huge eater of time while gaining no weight and no strength. Lots of offensive yardage doesn't necessarily translate into wins. There are teams who can barely convert good yardage into points. They only score field goals, or come up empty at the end of a long drive. On the other hand, teams get good field position, don't have a long TOP (time of possession): They score quickly and they score touchdowns. And then there are the turnovers. But they are also deceptive more often than not.
In the end, it all boils down to the WL columns: Wins-Losses. The Win-Loss thing is determined OFFICIALLY by deducting POINTS SCORED from POINTS ALLOWED. That's the foundation of my sports-betting system incorporated in the SPORTS.XLS spreadsheet. That system and spreadsheet are often imitated but never duplicated — not even when pirated. Microsoft is included among the incapable would-be duplicators.
I know who they are and what their intentions are when they attack me. When they mouth-foam in emails to yours truly:
“Your damn betting spreadsheet is a piece of idiotism! Take your website off line!”
I think to myself:
“Self, another self-destructing parasite wants to pirate one of my systems! He kills himself to no avail. Halleluiah!”
How we use statistics very much resembles how we breathe. The healthy manner of breathing consists of one-two seconds air intake followed by one-two seconds of air expel. The sports statistics on TV resemble breathing in front of a high-powered ventilator.
The Best Bettor At-Large