|
|
Post by 347pg on Sept 4, 2018 12:37:12 GMT -5
Hello everyone. Let's review the contests. If you have any questions let me know.
Total Wins - Pick all the teams you think will win. Highest total at the end of the season wins. Offensive Points Scored Contest - Pick the team you think will score the most points. You can only pick that team once during the season. Defensive Points Allowed Contest - Pick the team you think will allow the least points to the opponent. You can only pick that team once during the season. Points Differential Contest - Pick the team you think will win by the most points. If the team you pick loses, those points are negative and will deduct from your total. You CAN pick a team more than once during the season. Single Pick Winner Contest - Like a Knockout game, but you keep picking, even if you picked a loser the previous week. You can only pick a team once during the season. Spread Contest - Pick a team from each game. If you pick the favorite (highlighted in orange), they have to win by more than the spread to "Cover" the spread. If they win by exactly the spread, that is a push (which is why Vegas usually puts a .5 at the end of the line, to prevent pushes). If you pick the underdog (no highlight), they must prevent the favorite from winning by more than the spread. If the do that, you get a point. Over/Under Contest - For each game, pick "Over" if you think the combined scores of both teams will be over the line, and "Under" if you think they will be under the line. You can also pick "Push" if you think the combined scores will be exactly the line (rare, which is why Vegas sometimes adds a .5 to this line as well).
NOTE: Sometimes there will be a disparity between the point spread and the FPI (FPI is ESPN's take on the percentage of a teams chances of winning. not a contest in and of itself. Just extra info for you to factor in or not, your choice), i.e. Vegas picks one team and FPI shows the other. In this case, I will designate the spread favorite as orange colored and the FPI favorite with a pale red/pink color. Just something to be aware of.
Also, correct picks are highlighted in green AFTER THE WEEK IS OVER! You will see some of my picks are coming up green in the screen shot. This is because I haven't put in the scores yet. Once the scores are final and I put them in, all the cells will update with the correct color.
If you're not an Excel person, no worries. Just post your picks and I will enter them. If you can, try to list them in the order of the attached schedule.
Good luck everyone. Hope you have fun!
Click to view, back button to return to thread.
|
|
|
|
Post by NEGAME on Sept 4, 2018 12:57:04 GMT -5
ok here's what I'm doing:
total wins
offensive points scored
defensive points allowed
single pick winner
I will post them here if that s ok with you, not on the spreadsheet
Thank you for all the work you do on this, wish we could get more people to participate.
|
|
|
|
Post by Shelly on Sept 4, 2018 13:01:11 GMT -5
Hello everyone. Let's review the contests. If you have any questions let me know.
Total Wins - Pick all the teams you think will win. Highest total at the end of the season wins. Offensive Points Scored Contest - Pick the team you think will score the most points. You can only pick that team once during the season. Defensive Points Allowed Contest - Pick the team you think will allow the least points to the opponent. You can only pick that team once during the season. Points Differential Contest - Pick the team you think will win by the most points. If the team you pick loses, those points are negative and will deduct from your total. You CAN pick a team more than once during the season. Single Pick Winner Contest - Like a Knockout game, but you keep picking, even if you picked a loser the previous week. You can only pick a team once during the season. Spread Contest - Pick a team from each game. If you pick the favorite (highlighted in orange), they have to win by more than the spread to "Cover" the spread. If they win by exactly the spread, that is a push (which is why Vegas usually puts a .5 at the end of the line, to prevent pushes). If you pick the underdog (no highlight), they must prevent the favorite from winning by more than the spread. If the do that, you get a point. Over/Under Contest - For each game, pick "Over" if you think the combined scores of both teams will be over the line, and "Under" if you think they will be under the line. You can also pick "Push" if you think the combined scores will be exactly the line (rare, which is why Vegas sometimes adds a .5 to this line as well).
NOTE: Sometimes there will be a disparity between the point spread and the FPI (FPI is ESPN's take on the percentage of a teams chances of winning. not a contest in and of itself. Just extra info for you to factor in or not, your choice), i.e. Vegas picks one team and FPI shows the other. In this case, I will designate the spread favorite as orange colored and the FPI favorite with a pale red/pink color. Just something to be aware of.
Also, correct picks are highlighted in green AFTER THE WEEK IS OVER! You will see some of my picks are coming up green in the screen shot. This is because I haven't put in the scores yet. Once the scores are final and I put them in, all the cells will update with the correct color.
If you're not an Excel person, no worries. Just post your picks and I will enter them. If you can, try to list them in the order of the attached schedule.
Good luck everyone. Hope you have fun!
Click to view, back button to return to thread.
Here is my week 1: (Note to all: If you fill out the spreadsheet, save it to your disk. Then do the add attachment to upload that file. It will make it much easier for him to do the work.) |
|
|
|
Post by NEGAME on Sept 4, 2018 13:22:01 GMT -5
Shelly, could't you have just posted you comment without quote 347pg? takes up so much room on the page. I think we all know what you were talking about.
|
|
|
|
Post by 347pg on Sept 4, 2018 14:27:52 GMT -5
ok here's what I'm doing: total wins offensive points scored defensive points allowed single pick winner I will post them here if that s ok with you, not on the spreadsheet Thank you for all the work you do on this, wish we could get more people to participate. Thanks Gamer. No problem. You can post them here and I'll put them on the spreadsheet. |
|
|
|
Post by thejuice on Sept 4, 2018 14:30:35 GMT -5
Week 1 for me
|
|
|
|
Post by jri37 on Sept 4, 2018 17:08:21 GMT -5
|
|
|
|
Post by thehub on Sept 5, 2018 9:36:21 GMT -5
|
|
|
|
Post by 347pg on Sept 5, 2018 11:01:13 GMT -5
Click to view, back button to return to thread.
MY PICKS:
thehub Understand no Total Wins, Spread or Over/Under, correct?
|
|
|
|
Post by 347pg on Sept 5, 2018 11:01:50 GMT -5
juice Understand no Spread or Over/under, correct?
|
|
|
|
Post by 347pg on Sept 5, 2018 11:03:26 GMT -5
Updated screenshots. I'll update these as I get inputs. Let me know if I've entered anything incorrectly or if you see any errors. Click to view. Back button to return to thread.
|
|
|
|
Post by 347pg on Sept 5, 2018 11:09:44 GMT -5
Just so everyone is aware. If you are updating and then uploading a personal version of the spreadsheet, you don't have to go to each individual sheet to make your picks. There is a set of cells below the total wins/spread/over/under columns where you put single pick/off/def/diff picks. Those cells automatically update the other individual sheets. See first post in this thread for image.
Thanks
|
|
|
|
Post by NEGAME on Sept 5, 2018 12:32:27 GMT -5
My picks week#1:
total wins
Falcons
Ravens
Jaguars
Saints
Pats
Vikings
Titans
Colts
Steelers
Chargers
Seahawks
Panthers
Redskins
Packers
Lions
Rams
Offensive Points- Saints
Defensive points allowed-Steelers
Single pick-Saints
|
|
danpat
3rd String but playing on Special Teams
Posts: 832 
Likes: 283
|
Post by danpat on Sept 5, 2018 16:48:52 GMT -5
Hello everyone. Let's review the contests. If you have any questions let me know.
Total Wins - Pick all the teams you think will win. Highest total at the end of the season wins. Offensive Points Scored Contest - Pick the team you think will score the most points. You can only pick that team once during the season. Defensive Points Allowed Contest - Pick the team you think will allow the least points to the opponent. You can only pick that team once during the season. Points Differential Contest - Pick the team you think will win by the most points. If the team you pick loses, those points are negative and will deduct from your total. You CAN pick a team more than once during the season. Single Pick Winner Contest - Like a Knockout game, but you keep picking, even if you picked a loser the previous week. You can only pick a team once during the season. Spread Contest - Pick a team from each game. If you pick the favorite (highlighted in orange), they have to win by more than the spread to "Cover" the spread. If they win by exactly the spread, that is a push (which is why Vegas usually puts a .5 at the end of the line, to prevent pushes). If you pick the underdog (no highlight), they must prevent the favorite from winning by more than the spread. If the do that, you get a point. Over/Under Contest - For each game, pick "Over" if you think the combined scores of both teams will be over the line, and "Under" if you think they will be under the line. You can also pick "Push" if you think the combined scores will be exactly the line (rare, which is why Vegas sometimes adds a .5 to this line as well).
NOTE: Sometimes there will be a disparity between the point spread and the FPI (FPI is ESPN's take on the percentage of a teams chances of winning. not a contest in and of itself. Just extra info for you to factor in or not, your choice), i.e. Vegas picks one team and FPI shows the other. In this case, I will designate the spread favorite as orange colored and the FPI favorite with a pale red/pink color. Just something to be aware of.
Also, correct picks are highlighted in green AFTER THE WEEK IS OVER! You will see some of my picks are coming up green in the screen shot. This is because I haven't put in the scores yet. Once the scores are final and I put them in, all the cells will update with the correct color.
If you're not an Excel person, no worries. Just post your picks and I will enter them. If you can, try to list them in the order of the attached schedule.
Good luck everyone. Hope you have fun!
Click to view, back button to return to thread.
Here we go. Hope it works. I've just picked total winner, not picked against the spread or over/under. |
|
|
|
Post by homefield on Sept 5, 2018 20:13:55 GMT -5
Offense points: ravens
Defense points: ravens
Single pick: ravens
Thanks for running all of these 347!
|
|
sentinel
On the Game Day Roster
Posts: 374
Likes: 260
|
Post by sentinel on Sept 5, 2018 22:52:13 GMT -5
Here are my picks. Not sure why file is so huge. Thank you for running this!
|
|
|
|
Post by 347pg on Sept 6, 2018 9:48:14 GMT -5
Offense points: ravens Defense points: ravens Single pick: ravens Thanks for running all of these 347! Thanks HomeField. Did you want to add Total wins picks?
|
|
|
|
Post by 347pg on Sept 6, 2018 9:59:22 GMT -5
Here are my picks. Not sure why file is so huge. Thank you for running this! Fair amount of code to make it more automatic for me. After the week is done, I basically only have to put the scores in and it calculates everything. My college one is even bigger. Can't post it due to the 1 meg limit. Hopefully this one will stay below 1 meg.
|
|
|
|
Post by 347pg on Sept 6, 2018 10:04:52 GMT -5
Post #11 images updated with info I have at this point.
|
|
|
|
Post by homefield on Sept 6, 2018 12:53:43 GMT -5
Offense points: ravens Defense points: ravens Single pick: ravens Thanks for running all of these 347! Thanks HomeField. Did you want to add Total wins picks?
I think I'll pass on total wins for this year and just stick with the three (offense, defense, single pick) Thanks man!
|
|
|
|
Post by TFB12 on Sept 6, 2018 16:34:32 GMT -5
For tonight's game I will take the Falcons for the straight up win and win vs the pointspread. I'll also take the over for tonight's game.
|
|
|
|
Post by thehub on Sept 6, 2018 21:31:17 GMT -5
thehub Understand no Total Wins, Spread or Over/Under, correct?
I picked them all - perhaps it did not save??? I can try again the am. Atlanta Over Atlanta to cover |
|
|
|
Post by 347pg on Sept 7, 2018 9:33:59 GMT -5
thehub Understand no Total Wins, Spread or Over/Under, correct?
I picked them all - perhaps it did not save??? I can try again the am. Atlanta Over Atlanta to cover You populated all the tabs except the "Week 1 - Selections" tab, which has the Total Wins, Spread and Over/Under columns. It actually has the other games at the bottom of those columns so you don't have to go to each individual tab, but that's besides the point. It may not have saved. Sorry about that. If you could populate those columns for me, I'd appreciate it. I'll put you down for last night's selections until you get a chance to update. Thanks
|
|
|
|
Post by thehub on Sept 7, 2018 12:24:05 GMT -5
I picked them all - perhaps it did not save??? I can try again the am. Atlanta Over Atlanta to cover You populated all the tabs except the "Week 1 - Selections" tab, which has the Total Wins, Spread and Over/Under columns. It actually has the other games at the bottom of those columns so you don't have to go to each individual tab, but that's besides the point. It may not have saved. Sorry about that. If you could populate those columns for me, I'd appreciate it. I'll put you down for last night's selections until you get a chance to update. Thanks
I know what I did - I picked for you in columns R S T ---- I am in Z AA AB.  Its attached below and in type as well in case there are any other issues. Let me know if it worked.
Atlanta Falcons Atlanta Falcons Over
Pittsburgh Steelers Pittsburgh Steelers Over
Cincinnati Bengals Cincinnati Bengals Under
Tennessee Titans Tennessee Titans Under
Minnesota Vikings Minnesota Vikings Over
New England Patriots New England Patriots Over
New Orleans Saints Tampa Bay Buccaneers Under
Jacksonville Jaguars Jacksonville Jaguars Over
Baltimore Ravens Baltimore Ravens Over
Los Angeles Chargers Kansas City Chiefs Over
Seattle Seahawks Seattle Seahawks Over
Arizona Cardinals Arizona Cardinals Under
Carolina Panthers Carolina Panthers Over
Chicago Bears Chicago Bears Under
Detroit Lions Detroit Lions Under
Los Angeles Rams Los Angeles Rams Over
View Attachment
|
|
|
|
Post by 347pg on Sept 7, 2018 15:35:35 GMT -5
You populated all the tabs except the "Week 1 - Selections" tab, which has the Total Wins, Spread and Over/Under columns. It actually has the other games at the bottom of those columns so you don't have to go to each individual tab, but that's besides the point. It may not have saved. Sorry about that. If you could populate those columns for me, I'd appreciate it. I'll put you down for last night's selections until you get a chance to update. Thanks
I know what I did - I picked for you in columns R S T ---- I am in Z AA AB. Its attached below and in type as well in case there are any other issues. Let me know if it worked.
Atlanta Falcons Atlanta Falcons Over
Pittsburgh Steelers Pittsburgh Steelers Over
Cincinnati Bengals Cincinnati Bengals Under
Tennessee Titans Tennessee Titans Under
Minnesota Vikings Minnesota Vikings Over
New England Patriots New England Patriots Over
New Orleans Saints Tampa Bay Buccaneers Under
Jacksonville Jaguars Jacksonville Jaguars Over
Baltimore Ravens Baltimore Ravens Over
Los Angeles Chargers Kansas City Chiefs Over
Seattle Seahawks Seattle Seahawks Over
Arizona Cardinals Arizona Cardinals Under
Carolina Panthers Carolina Panthers Over
Chicago Bears Chicago Bears Under
Detroit Lions Detroit Lions Under
Los Angeles Rams Los Angeles Rams Over
That worked. Thanks. We picked almost exactly the same, which is why I thought I was reading my inputs. So far, we're 0 for 3!! |
|
Its attached below and in type as well in case there are any other issues. Let me know if it worked.