READY FOR SOME FOOTBALL: Week 1 and Season Update

Well, I guess I should have known it was too good to be true - that I didn't have the manually update information for certain weeks in order to get an accurate result for my calculation, but at least Chicago doesn't win the Super Bowl anymore.

UPDATE 9/9/2018

Every year is a relearning experience with my spreadsheet to try to remember all of the little tricks I've hidden within the cells. After a massive simplification effort that removed a number of experimental calculations and then data entry for the early games of Week 1, I discovered that the Master sheet used an area where the schedule was hand-coded to create the main calculation. (sigh) So I automated it to update it for this year and had to re-update those certain weeks mentioned above. This gave me a new-but-also-old Super Bowl prediction.

Conference									Conference
N3	MIN								JAX	A3
			NFC		Super Bowl		AFC
		N3	MIN		MIN		PIT	A1
				Champions
N1	PHI								PIT	A1
					Super Bowl
		N1	PHI		JAX		JAX	A3
					^Alternate^

The alternate is included because there is a disagreement between the two columns that I thought used the same calculation. One variation is in an AFC divisional playoff and puts either New England or Jacksonville into the Conference Championship. Regardless, however, Pittsburgh goes to the Super Bowl. The other is in the NFC Championship. If we do get the Battle of Pennsylvania, Pittsburgh would win.

Instead, my boy Cam Newton and his Panthers get their dream.

Conference									Conference
N4	CAR								TEN	A5
			NFC		Super Bowl		AFC
		N4	CAR		CAR		TEN	A5
				Champions
N3	MIN								JAX	A3

Sorry, Cam, you know you're still my angel. Also, I like what you're doing with your hair.