|
|
Post by 347pg on May 3, 2018 11:46:13 GMT -5
Hi Everyone I believe I have this spreadsheet where I want it. It's more user friendly for you and me and will take me a lot less time this year. You are more than welcome to use it to hold your own contests with family, friends, classmates etc. There is room for 30 players. There are the standard total wins, spread, over/under, Off pts, Def Points and pts differential games plus a Single pick game, similar to a knockout game but it runs all season. If you want to run a contest with fam/friends, let me know and I can give you the tutorial. You have to put in the spread, over/under and the fpi each week. You also have to select appropriate coding for each games spread (in some hidden cells) and then highlight the favorite for each game. After you've put in everyone's selections (all done in the "Wk X - Selections" page, i.e. this page populates the Off pts, def pts, pts diff, and single pick pages), you'll just add the scores for the week and voila, it's all done.
Let me know if you see any errors.
One other thing. Last year and in previous years, the Points Differential game allowed you to pick a team more than once during the season. Do we want to make it like the other games or leave it like that (Loaded spreadsheet says you can pick one team more than once but is currently coded to highlight duplicate picks). I have no preference one way or the other and will do what the majority prefers. |
|
|
|
Post by 347pg on May 3, 2018 11:51:53 GMT -5
Click to view larger image. Back button to return.
|
|
|
|
Post by jri37 on May 3, 2018 12:32:21 GMT -5
Thanks 337, looks good!
|
|
|
|
Post by Shelly on Sept 3, 2018 21:10:07 GMT -5
Hi Everyone I believe I have this spreadsheet where I want it. It's more user friendly for you and me and will take me a lot less time this year. You are more than welcome to use it to hold your own contests with family, friends, classmates etc. There is room for 30 players. There are the standard total wins, spread, over/under, Off pts, Def Points and pts differential games plus a Single pick game, similar to a knockout game but it runs all season. If you want to run a contest with fam/friends, let me know and I can give you the tutorial. You have to put in the spread, over/under and the fpi each week. You also have to select appropriate coding for each games spread (in some hidden cells) and then highlight the favorite for each game. After you've put in everyone's selections (all done in the "Wk X - Selections" page, i.e. this page populates the Off pts, def pts, pts diff, and single pick pages), you'll just add the scores for the week and voila, it's all done.
Let me know if you see any errors.
One other thing. Last year and in previous years, the Points Differential game allowed you to pick a team more than once during the season. Do we want to make it like the other games or leave it like that (Loaded spreadsheet says you can pick one team more than once but is currently coded to highlight duplicate picks). I have no preference one way or the other and will do what the majority prefers. How do we read this? Looking at the spreadsheet all the point spread are negative. - Does that mean that Team 1 is favored by that many points over Team 2 in all cases (that is the visiting team is favored)?
- does it mean Team 2 is favored in all cases (home team)?
- what is FPI?
- why is there no spread with the last game. It doesn't say zero.
|
|
|
|
Post by TFB12 on Sept 3, 2018 22:50:59 GMT -5
Very well put together spreadsheet!!
|
|
|
|
Post by 347pg on Sept 4, 2018 8:05:26 GMT -5
Hi Everyone I believe I have this spreadsheet where I want it. It's more user friendly for you and me and will take me a lot less time this year. You are more than welcome to use it to hold your own contests with family, friends, classmates etc. There is room for 30 players. There are the standard total wins, spread, over/under, Off pts, Def Points and pts differential games plus a Single pick game, similar to a knockout game but it runs all season. If you want to run a contest with fam/friends, let me know and I can give you the tutorial. You have to put in the spread, over/under and the fpi each week. You also have to select appropriate coding for each games spread (in some hidden cells) and then highlight the favorite for each game. After you've put in everyone's selections (all done in the "Wk X - Selections" page, i.e. this page populates the Off pts, def pts, pts diff, and single pick pages), you'll just add the scores for the week and voila, it's all done.
Let me know if you see any errors.
One other thing. Last year and in previous years, the Points Differential game allowed you to pick a team more than once during the season. Do we want to make it like the other games or leave it like that (Loaded spreadsheet says you can pick one team more than once but is currently coded to highlight duplicate picks). I have no preference one way or the other and will do what the majority prefers. How do we read this? Looking at the spreadsheet all the point spread are negative. - Does that mean that Team 1 is favored by that many points over Team 2 in all cases (that is the visiting team is favored)?
- does it mean Team 2 is favored in all cases (home team)?
- what is FPI?
- why is there no spread with the last game. It doesn't say zero.
So the spread applies to the favorite (orange colored team). The FPI (which is ESPN's take at the favorite's chances of winning in percent, i.e. 89.0 = 89% chance that the favorite will win. Not a contest in and of itself. Just extra info for you to factor in or not.) also applies to the favorite unless it is a pale red/pink color, which means there is a split between who Vegas picks for the spread and who ESPN picks as far as FPI. The spread will always apply to the favorite though. The favorite must win BY MORE than the spread. So if the spread is -33, they must win by 34 to cover the spread. If the difference in the scores is 33, then it's a push. Less than that, the underdog wins the spread. The spreads in the sheet are examples. I will get the new ones posted today.
|
|
|
|
Post by Shelly on Sept 4, 2018 8:12:23 GMT -5
How do we read this? Looking at the spreadsheet all the point spread are negative. - Does that mean that Team 1 is favored by that many points over Team 2 in all cases (that is the visiting team is favored)?
- does it mean Team 2 is favored in all cases (home team)?
- what is FPI?
- why is there no spread with the last game. It doesn't say zero.
So the spread applies to the favorite (orange colored team). The FPI (which is ESPN's take at the favorite's chances of winning in percent, i.e. 89.0 = 89% chance that the favorite will win. Not a contest in and of itself. Just extra info for you to factor in or not.) also applies to the favorite unless it is a pale red/pink color, which means there is a split between who Vegas picks for the spread and who ESPN picks as far as FPI. The spread will always apply to the favorite though. The favorite must win BY MORE than the spread. So if the spread is -33, they must win by 34 to cover the spread. If the difference in the scores is 33, then it's a push. Less than that, the underdog wins the spread. The spreads in the sheet are examples. I will get the new ones posted today.
I downloaded the sheet you had in the example, which is upon what I based my comments. In that sheet, there was no orange team. Both were blue. There was also nothing in the FPI column, which is another reason I asked about it. |
|
|
|
Post by 347pg on Sept 4, 2018 9:07:47 GMT -5
So the spread applies to the favorite (orange colored team). The FPI (which is ESPN's take at the favorite's chances of winning in percent, i.e. 89.0 = 89% chance that the favorite will win. Not a contest in and of itself. Just extra info for you to factor in or not.) also applies to the favorite unless it is a pale red/pink color, which means there is a split between who Vegas picks for the spread and who ESPN picks as far as FPI. The spread will always apply to the favorite though. The favorite must win BY MORE than the spread. So if the spread is -33, they must win by 34 to cover the spread. If the difference in the scores is 33, then it's a push. Less than that, the underdog wins the spread. The spreads in the sheet are examples. I will get the new ones posted today.
I downloaded the sheet you had in the example, which is upon what I based my comments. In that sheet, there was no orange team. Both were blue. There was also nothing in the FPI column, which is another reason I asked about it. Yes, once a favorite is determined, I will highlight the team in orange. |
|
|
|
Post by NEGAME on Sept 4, 2018 10:12:31 GMT -5
miss pia here. Remind me again what the contest are. I'm probably not going to do all of them Thanks
|
|
|
|
Post by 347pg on Sept 4, 2018 11:42:17 GMT -5
miss pia here. Remind me again what the contest are. I'm probably not going to do all of them Thanks Total wins Offensive points scored Defensive points allowed Points differential over/under spread single pick ( same as a knockout but you keep picking if you pick a loser)
|
|
