• How to Make a Line Analysis Spreadsheet

    Added - Aug. 11, 2014 Sports

    For people who bet sports on money lines, one of the problems that comes up a lot is figuring out exactly what the lines mean. Fortunately, there are simple tools that you can use to do this analysis for you so that you have a clear picture of exactly what a money line is telling you. We are going to show you how to put in formulas on a spreadsheet that will calculate certain numbers for you that are particularly useful when it comes to deciding which games or matches to bet on and which teams to take when betting on sports.

    You're going to need a spreadsheet like Microsoft Excel (paid option) or OpenOffice Calc (free option) to do this. Start off by putting together five columns. On the first row, you'll want to put labels for those five columns: description of the game, underdog line, favorite line, underdog win percentage and favorite win percentage. In the first column which should be marked 'A' you are going to type in the name of the game. For example, if Detroit is playing Chicago in the NBA, you would put that into that column.

    One team will be the favorite (marked by a money line with a negative) and another will be the positive (marked by a money line with a positive). In the B column is where your underdog lines will go, so if Chicago was +125, you would put 125 in the B column for that game. Along similar lines, the C column is where the favorite lines will go, so if Detroit was -100, you'll put in 100 in that column. For the last two columns, D and E, we're going to put in formulas that will tell us the win percentage needed for each time for a bet on either of them to be profitable.

    So if your favorite line is in cell C2, then the formula to calculate how often that team needs to win is "=C2/(C2+100)" without the quotes. Then if the underdog line is in cell D2, then the percentage that team needs to win is "=100/(D2+100)" again without the quotes. The formulas for these two figures are a little different, so make sure that you don't mix them up. Once you have them in once correctly, you can just copy and paste them down to other columns, and the cells used in the calculations will automatically update themselves.