Trying to recreate the spreadsheet on here didn't work out lol. The below will be under the sample tab.
https://docs.google.com/spreadsheets/d/1zsOu2wbFSWaAvwauUnVy4hzpFSVN5Wnsacab5WArHx4/edit?usp=sharing
A) First 7 numbers to the right of the teams are their predictions from different newsletters and websites.
B) Under average is the average score of the newsletters.
C) Under total, is the Over/under for the game at hand, and also the number I have at the time of posting the sheet. ( I'm not tracking closing lines, barely have time to do this honestly)
D) Under avg-total all i'm doing is taking the total of the numbers under AVG, which in this case equals 70 and subtracting the TOTAL line. 70-76= -6. ANYTHING that comes up with a differential of 5 or more, I'm marking it yellow as a play to track. Why 5? No reason. That's what I chose. It seemed like a decent # at the time to not have a ton of plays. So in this situation, the play would be under 76. Game ended up going over, so it's marked RED as a loser
E) Lets move to the spreads. Under spread, it says 13.5 . If you look where the spread is, it's on the FAU line. It'll always be on the away team line of the sheet. FAU was +13.5
F) Let's look at the spread vs avg line. Underneath of it says 18. All this is doing is taking the average for UCF points scored which was 44 and subtracting it from the 26 points FAU was averaged to score. 44-26= 18 which is what is under the spread vs avg.
H) The last column DIFF is taking the spread 13.5 and subtracting what the newsletters say FAU will lose by which was 18. My spreadsheet rounds up so this has the difference being 5. This would make UCF a play ATS at 13.5 since the newsletters have them winning by 18. UCF covered that spread so the cell is highlighted in green for being a winner.
Hope that helps. Not sure I'll be able to get this done this week. Heading to Chicago Friday for my first visit and then off to the Notre Dame game the next day. Will try to get it done Thursday if I can. If not I'll fill in the spreadsheet when I get home to keep up with tracking purposes.