2011 Hamilton NFL Pool: Notes on how the spreadsheet works
construction on spreadsheet started on August 20, 2011 by Dave Woods; used my survival pool template as a starting point
1	You only need to enter the following 2 items (everything else will be calculated automatically) with regards to the week-to-week progression of the pool
1.1		The abbreviation of each poolee's pick in the appropriate cell of the appropriate worksheet for each poolee
1.11			Abbreviations can be changed to fit the user's preference by changing the entry in the "Abbr." column of the 'Team Selection Summary' worksheet
1.111				If abbreviations are changed, the same abbreviation can obviously not be used for more than one team
1.112				The same abbreviation must obviously be used for the same team for the entire season
1.12			If a poolee fails to submit a pick for any or all of the point totals for a given week then enter "none" in the appropriate row of the "Abbr." column
1.2		The final score of each game in the 'Schedule & Results' worksheet
1.21			All scores should be updated to ensure standings remain accurate
2	There are 2 hidden columns in the 'Poolee Point Totals' worksheet
2.1		One column to indicate a possible link to another poolee (i.e. the "Sponsor?" column)
2.2		One column to indicate if the poolee has paid their entry fee
3	Formulas within this file have been constructed with the following rules in mind
3.1		If a poolee's selection wins their game then that poolee receives the point total assigned to that selection
3.2		If a poolee's selection loses their game then that poolee loses the point total assigned to that selection
3.3		If a poolee's selection ties their game then that poolee received 0 points for that selection
3.4		If a poolee selects a team more than 3 times then that poolee automatically loses the point total assigned to that selection
3.41			It is up to each individual poolee to ensure they don't pick a team more than 3 times
3.5		If a poolee selects a team that has a bye week then that poolee loses the point total assigned to that selection
3.6		If a poolee fails to submit a team for a given point total then that poolee loses the point total for the omitted team
3.61			If a poolee fails to submit any teams for a given week than that poolee loses all 15 points for that week
3.7		If a poolee selects a team more than once in a single week then only the highest point total assigned to that team will be dependent on the game's outcome
3.71			Other than the highest point total assigned to that team, the poolee will automatically lose the point total assigned to that team for every additional selection within the same week
4	The 'Poolee Pick Summary' worksheet lists the selections from all the poolees in an easy-to-read table
4.1		The worksheet uses the format of x/y (i.e. the pick was made in week x and received y points)
4.2		This worksheet has been conditionally formatted to clearly identify any "tbd" entries
5	The 'Team Selection Summary' worksheet has been conditionally formatted in 2 ways
5.1		If a team has been selected exactly 2 times by a poolee then the cell will be shaded yellow
5.2		If a team has been selected 3 or more times by a poolee then the cell will be shaded black and the font will be changed to bolded red
6	The 'Prizes' worksheet has been added to track the winners
6.1		The 'Prizes' worksheet assumes that once the score of the Monday night game is entered then all the scores have been entered for that week
6.11			In the case of Week 1, this applies to the later of the two Monday night games
6.12			In the case of Week 17, this applies to the Sunday night game
6.2		Cell B13 must say "Yes!!!"; if it does not adjust cells B7, B9, B10, and B11 until it does
6.3		If there is a tie for the Week 17 prize, the co-winners must be manually entered
7	To add additional poolees, exactly follow the following steps
7.1		Copy an existing poolee's worksheet and change the name of the newly copied worksheet to create a new poolee worksheet
7.11			Ensure that all picks have been deleted from the "Abbr." column of the new copy
7.2		Using the EXACT name of the newly added poolee worksheet, add a row to the 'Poolee Point Totals' worksheet to the bottom of the existing entries
7.21			Copy the formulas from all columns into the new row
7.22			Ensure that the hidden column entries are correct for the new poolee (the "Sponsor?" column and the "Amount Paid" column)
7.3		Using the EXACT name of the newly added poolee worksheet, add a column to the 'Team Selection Summary' worksheet to the right of the existing entries
7.31			Copy the formulas from all rows into the new column
7.4		Using the EXACT name of the newly added poolee worksheet, add a row to the 'Poolee Pick Summary' worksheet to the bottom of the existing entries
7.41			Copy the formulas and formats from all columns into the new row