2018 Superbowl Grid - Read 'em & Weep - International Association of Penturners
     International Association of Penturners
Pens for Service Members
 
Support The IAP

Go Back   International Association of Penturners > Welcome to penturners.org! > IAP Management Team > Activities Manager
  Forgot Password
Register FAQ Members List Search Today's Posts Mark Forums Read
Activities Manager Mike Redburn is the IAP Activities Manager


Logged on members can hide ads!

Welcome to penturners.org!

You've found the home of The International Association of Penturners. You are currently viewing our site as a guest, which gives you limited access to view discussions, photos, and library articles.

Consider joining our community today. You'll have full access to all of our content, be able to enter our contests, find local chapters near you, and post your questions and share your experience with our members all over the world.

Membership is completely free!!

If you have any problems with the registration process or your account login, please contact us.

Reply
 
LinkBack Thread Tools Display Modes
Old 02-02-2018, 01:40 PM   #1 (permalink)
New Member Advocate
 
Edgar's Avatar
 
Join Date: Feb 2013
Location: Alvin, TX 77511
Posts: 5,216
Photos: 23

Default 2018 Superbowl Grid - Read 'em & Weep

OK Folks,

Here it is - the long-awaited 2018 Superbowl Pool Chart. I have attached the chart both as an Excel xlxs file and as a jpg file. Hopefully you can all view at least one of them, but let me know if you can't.

I checked everything twice, so I hope that there are no errors, but if you think you see a mistake, please let me know as soon as possible so I can investigate and try to correct it. No adjustments will be made after kickoff.

If you don't like your square, don't blame me - I had nothing to do with assigning the squares. Blame alunkulwiki7 (Doug), flyitfast (Gordon) or chartle (Cliff).

You can also thank them if you happen to like your square & I would like to thank them for helping me with this

I will explain how the grid was laid out and how the squares were chosen in another post. In the meantime, let the wailing & gnashing of teeth begin.
Attached Thumbnails
2018-sb-grid.jpg  
Attached Files
File Type: xlsx 2018 SB grid.xlsx (13.6 KB, 56 views)
__________________
Eat pecans - 10,000,000 squirrels can't be wrong.
Likes: (1)
Edgar is offline   Reply With Quote Top
Old 02-02-2018, 01:48 PM   #2 (permalink)
New Member Advocate
 
Edgar's Avatar
 
Join Date: Feb 2013
Location: Alvin, TX 77511
Posts: 5,216
Photos: 23

Default How the Grid was Generated

Here's how your square assignment was determined:

I asked Doug (alankulwicki7) to send me two randomized lists from 0-9 and call them Set 1 & Set 2.

I asked Gordon (flyitfast) to flip a coin to determine whether Set 1 or Set 2 went across the top - it was Set 1, so those are the column numbers. Set 2 is therefore the row numbers.

I also asked Gordon to flip a coin to determine if Patriots or Eagles goes on the top of the grid - it came up Patriots, so Eagles is on the left side.

I asked Doug to flip a coin to determine if the names would be placed in the grid L-R by rows or T-B by columns. It came up L-R.

I listed all the players 1-100 by your signup order as I reported in another post. I asked Cliff (chartle) to randomize the numbers 1-100. I used his randomized list to re-order the players accordingly. I then placed the reordered list into the grid L-R by rows.


Thanks again to Doug, Gordon & Cliff for helping with this. I believe this is a completely fair and impartial way to set up and fill out the grid, but let me know if you have any questions or concerns.

Thanks for playing & good luck to all.

Pack up those blanks so you can mail them early next week!

Edgar
__________________
Eat pecans - 10,000,000 squirrels can't be wrong.
Edgar is offline   Reply With Quote Top
Old 02-02-2018, 02:01 PM   #3 (permalink)
 
Join Date: Aug 2012
Location: Cincinnati, OH
Posts: 1,530
Photos: 0

Default

You can go ahead and send me your blanks for the 4th qtr.
Its in the bag
Yep
I guarantee it!
Patriots 28 - Eagles 7
Likes: (1)
lyonsacc is offline   Reply With Quote Top
Advertisement
Old 02-02-2018, 02:04 PM   #4 (permalink)
 
MRDucks2's Avatar
 
Join Date: Jul 2017
Location: Franklin, IN
Posts: 1,142
Photos: 0

Default

I got lucky! Being in the same section twice means I only have to pack up twice as many blanks once.

Thanks for the all the work putting it together guys.


Sent from my iPhone using Penturners.org mobile app
__________________
Think deeply, Speak gently
Love much, Laugh alot
Work hard, Give freely
Be kind &
Leave The Rest to God
Likes: (2)
MRDucks2 is offline   Reply With Quote Top
Old 02-02-2018, 02:05 PM   #5 (permalink)
New Member Advocate
 
Edgar's Avatar
 
Join Date: Feb 2013
Location: Alvin, TX 77511
Posts: 5,216
Photos: 23

Default How the Grid Works

In case you have not played our game before, here is a review of how the Grid Works.

Note that there are 4 quadrants of the grid, each in a different color.

The 25 players in the gray (lower left) quadrant will each send a box of blanks to the 1st Quarter winner.

The 25 players in the yellow (upper left) quadrant will each send a box of blanks to the 2nd Quarter winner.

The 25 players in the blue (upper right) quadrant will each send a box of blanks to the 3rd Quarter winner.

The 25 players in the beige (lower right) quadrant will each send a box of blanks to the 4th Quarter winner (which will be determined by the final score of the game).

The 4 winners will be determined by the last digit of the scores at the end of each quarter (or the end of the game in case of quarter 4). For example, if the score is Patriots 10 - Eagle 0 at the end of the first quarter, the winner for that quarter would be hcpens. In that example, hcpens is also a donor for the first quarter, so he obviously would not need to send himself a box of blanks.

Special Notes for those of you with 2 squares:
1. If both of your squares happen to be in the same quadrant, you do not need to send 2 boxes of blanks to your winner. Each player (square holder) is obligated to send at least 4 or 5 blanks to their winner. So, if you owe 2 sets of blanks to the same person, you can simply double up on the number of blanks you were planning to ship and pack them into the same box. That way you will only have to pay once for shipping.

2. If your 2 squares are in different quadrants, you will have to make two shipments (unless the same player happens to win both of your quarters, in which case see note 1 above).


Let me know if you have any questions.

Thanks for playing & have fun!
Edgar
Attached Thumbnails
2018-sb-grid.jpg  
__________________
Eat pecans - 10,000,000 squirrels can't be wrong.
Edgar is offline   Reply With Quote Top
Old 02-02-2018, 02:21 PM   #6 (permalink)
 
Join Date: Mar 2017
Location: Houston, Texas
Photos: 12

Default

The upside to getting 2,2 and 2,3 is that I will only have to pay for shipping once :). Come on safeties!

Thanks for coordinating Edgar, this was quite an effort, if (when) I win you'll have some blanks headed your way :)
__________________
--Sam
Likes: (1)
Dehn0045 is offline   Reply With Quote Top
Old 02-02-2018, 03:46 PM   #7 (permalink)
 
chartle's Avatar
 
Join Date: Mar 2015
Location: Pgh, PA
Posts: 1,055
Photos: 0

Default

I like My eagles 8 patriots 0.

So 8-0 or 18-0 or 28-0 or 38-0 or 48-0. All good. ;)
__________________
Cliff
Likes: (1)
chartle is offline   Reply With Quote Top
Old 02-02-2018, 07:37 PM   #8 (permalink)
 
Brian G's Avatar
 
Join Date: Jul 2013
Location: Bloomington, MN
Posts: 1,373
Photos: 4

Default

5-5 and 5-7?

Sheesh. . . .at least they're in the same rectangle.
Brian G is offline   Reply With Quote Top
Old 02-02-2018, 07:37 PM   #9 (permalink)
 
Join Date: May 2017
Location: Northwest IN
Posts: 609
Photos: 0

Default

Quote:
Originally Posted by MRDucks2 View Post
I got lucky! Being in the same section twice means I only have to pack up twice as many blanks once.

Thanks for the all the work putting it together guys.


Sent from my iPhone using Penturners.org mobile app
LOL, same here!! I was grateful that I could just send twice as much to one person. Looking forward to it!!
earl
greenacres2 is offline   Reply With Quote Top
Old 02-04-2018, 06:23 PM   #10 (permalink)
 
Joe S.'s Avatar
 
Join Date: Jan 2012
Location: South Lyon, MI
Posts: 1,996
Photos: 3

Default

Who's here to discuss plays and adds?
__________________
Joe S.

5th place 2014 tube-on casting contest.
Joe S. is offline   Reply With Quote Top
Related Content
Logged on members can hide ads
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -5. The time now is 06:52 AM.

Powered by vBulletin® Version 3.7.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0

Content Copyright © 2003-2018 by Penturners.org, LLC; All Rights Reserved
Terms Of Service   Acceptable Use Policy