Excel Spreadsheet: 2008 Schedule by Team and ATS Tracker

[RJ Esq]

Just got done with this and checked the code. May be a few errors, but I don't think so. Then again, there are over 3,000 lines of data.

Team Schedules
Organized alphabetically by conference and then team, the schedule provides a place for you to enter whether the team won ATS, the spread, pts for, pts against, predicted SU win, and notes.

<table x:str="" style="border-collapse: collapse; width: 598pt;" border="0" cellpadding="0" cellspacing="0" width="796"><col style="width: 73pt;" width="97"> <col style="width: 91pt;" width="121"> <col style="width: 48pt;" span="5" width="64"> <col style="width: 194pt;" width="258"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 73pt;" width="97" height="17">Boston College</td> <td style="width: 91pt;" width="121">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 194pt;" width="258">
</td> </tr> <tr style="height: 25.5pt;" height="34"> <td class="xl24" style="height: 25.5pt; width: 73pt;" width="97" height="34">Date</td> <td class="xl24" style="border-left: medium none; width: 91pt;" width="121">Opponent</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">ATS</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Line</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Score</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Opponent Score</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Predicted SU Result</td> <td class="xl24" style="border-left: medium none; width: 194pt;" width="258">Notes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">A.30</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Kent St</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.06</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">G Tech</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.13</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Bye Week</td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl30" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.20</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">UCF</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.27</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Rhode Island</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.04</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ NC State</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.11</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Bye Week</td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl30" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.18</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Va Tech</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.25</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ UNC</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.01</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Clemson</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.08</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Notre Dame</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.15</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ FSU</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.22</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ Wake Forest</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.29</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Maryland</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
Here is how I use it. First, in pre-season I go through and try to pick the SU winner for each game and look for motivation/soft spots in the schedule which I then include in notes. Second, at the beginning of the week I enter in the spread for each game. After the game, I enter in whether the team covered and the score for each game.

I also like to write down each team's schedule of goals at the beginning of the season. Teams that can't make their goals tend to get down on themselves and play worse as the season goes on.

ATS Tracker

I want to know as early as possible which teams are getting hammered by the line and which ones are hammering it. As one capper once said, if you can determine which teams are the hottest and coldest against the spread early on, you can ride and fade accordingly to profit.

When you enter the ATS result in each team's schedule, type either "W" or "L". The result is then posted automatically in the ATS tracker at the top of the sheet.

For example:

<table x:str="" style="border-collapse: collapse; width: 598pt;" border="0" cellpadding="0" cellspacing="0" width="796"><col style="width: 73pt;" width="97"> <col style="width: 91pt;" width="121"> <col style="width: 48pt;" span="5" width="64"> <col style="width: 194pt;" width="258"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 73pt;" width="97" height="17">Boston College</td> <td style="width: 91pt;" width="121">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 194pt;" width="258">
</td> </tr> <tr style="height: 25.5pt;" height="34"> <td class="xl24" style="height: 25.5pt; width: 73pt;" width="97" height="34">Date</td> <td class="xl24" style="border-left: medium none; width: 91pt;" width="121">Opponent</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">ATS</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Line</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Score</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Opponent Score</td> <td class="xl24" style="border-left: medium none; width: 48pt;" width="64">Predicted SU Result</td> <td class="xl24" style="border-left: medium none; width: 194pt;" width="258">Notes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">A.30</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Kent St</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">W</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.06</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">G Tech</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">L</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.13</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Bye Week</td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl30" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.20</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">UCF</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">W</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">S.27</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Rhode Island</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">L</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.04</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ NC State</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">W</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.11</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Bye Week</td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl30" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl31" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.18</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Va Tech</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">W</td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">O.25</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ UNC</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.01</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Clemson</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.08</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Notre Dame</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.15</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ FSU</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.22</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">@ Wake Forest</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="border-top: medium none; height: 12.75pt;" height="17">N.29</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">Maryland</td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl29" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl26" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
The results show up as:

<table x:str="" style="border-collapse: collapse; width: 260pt;" border="0" cellpadding="0" cellspacing="0" width="346"><col style="width: 73pt;" width="97"> <col style="width: 91pt;" width="121"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; width: 73pt;" width="97" height="17">Team Name</td> <td class="xl26" style="border-left: medium none; width: 91pt;" width="121">Conference</td> <td class="xl26" style="border-left: medium none; width: 48pt;" width="64">ATS Wins</td> <td class="xl26" style="border-left: medium none; width: 48pt;" width="64">ATS Losses</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">BC</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">ACC</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">4</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Clemson</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">ACC</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">0</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Duke</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">ACC</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">0</td> <td class="xl25" style="border-top: medium none; border-left: medium none;" x:num="">0</td> </tr> </tbody></table>
Hope it helps some people.

View attachment 22347

 

[G-Man]

Awesome layout.

Would you like to build one that I can send you a model of?

 

[RJ Esq]

Awesome layout.

Would you like to build one that I can send you a model of?

You've gotta be kidding.

 

[Mags]

:36_11_6:

You've gotta be kidding.

 

[ducks97]

spreadsheet update

RJ, with your permission, I am going to modify your sheet a little bit. I can tell you put a lot of work into it. I am to try to make data entry a little easier. So everything flows to both teams at the same time. what do you think?

 

[RJ Esq]

RJ, with your permission, I am going to modify your sheet a little bit. I can tell you put a lot of work into it. I am to try to make data entry a little easier. So everything flows to both teams at the same time. what do you think?

Do whatever you want.

 

[G-Man]

RJ, with your permission, I am going to modify your sheet a little bit. I can tell you put a lot of work into it. I am to try to make data entry a little easier. So everything flows to both teams at the same time. what do you think?

Cool Ducks, I'll be looking at it as well. :shake:

 

[CollegeKingRex]

Morning boys.

I am officially jumping into the fray shortly.

I am getting caught up on reading (re:Steele) and other odds and ends and hope to be contributing in here by this time next week...

:shake:

Good shit, RJ...

 

[cubsker]

about time, Rex.

 

[E.T.G.]

wow, just saw this, thank you very much RJ

 

[ducks97]

my version

I have modified RJ's spreadsheet. I created a data entry tab where you can enter the lines and the score of each game. The results here automatically populate the results tab.

I took some liberties on the neutral games as to who is the home team. For example on the result tab, see the Colorado vs Colorado state game.

I would appreciate any feedback/errors/questions from you guys.

Good luck this season.

 

[mjpomares42]

beautiful. thanks for this chief

 

[RJ Esq]

I have modified RJ's spreadsheet. I created a data entry tab where you can enter the lines and the score of each game. The results here automatically populate the results tab.

I took some liberties on the neutral games as to who is the home team. For example on the result tab, see the Colorado vs Colorado state game.

I would appreciate any feedback/errors/questions from you guys.

Good luck this season.

Like it Ducks. That'll save alot of time. I was inputting each one, meaning the score and line for each team twice.

 

[ducks97]

cool. thanks for checking it out.

 

[RJ Esq]

Minor edit: I always think that it's better to freeze panels so that the heading is always on the top. I froze them on the data entry sheet.

Also, what happens if you don't want to track D-1A vs. D-1AA teams? If you put in N/A, does that work? Or should I just enter "0" for the line?

 

[ducks97]

i would go with zero for line and score. that way it will count as a push.