As you know, soon the postseason will be upon us in baseball. To prepare for this, I created a sheet in my MLB standings sheet specifically for the postseason.
On the left side of the sheet you find a list where each individual game of the postseason and series. Underneath you'll find an example of the first day of the playoffs from 2010.
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Date</td><td style="font-weight: bold;text-align: center;;">Visiting Team</td><td style="font-weight: bold;text-align: center;;">Home Team</td><td style="font-weight: bold;text-align: center;;">Away/Home Score</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Winning Team</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Wednessday</td><td style=";">Texas</td><td style=";">Tampa Bay</td><td style="text-align: center;;">5</td><td style="text-align: center;;">1</td><td style="font-weight: bold;border-right: 1px solid black;;">Texas</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">10/6</td><td style=";">New York (AL)</td><td style=";">Minnesota</td><td style="text-align: center;;">6</td><td style="text-align: center;;">1</td><td style="font-weight: bold;border-right: 1px solid black;;">New York (AL)</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Cincinnati</td><td style=";">Philadelphia</td><td style="text-align: center;;">0</td><td style="text-align: center;;">4</td><td style="font-weight: bold;border-right: 1px solid black;;">Philadelphia</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B6</th><td style="text-align:left">=G7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C6</th><td style="text-align:left">=G3</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F6</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D6<>"",E6<>""</font>),(<font color="Red">IF(<font color="Green">D6>E6,B6,C6</font>)</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />
Sorry that the columns on the score are not so well spaced. Should the series go beyond those games that are necessary then this is the equation that shows up for games beyond game 3 in a 5 game series and game 4 in a 7 game series.
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Date</td><td style="font-weight: bold;text-align: center;;">Visiting Team</td><td style="font-weight: bold;text-align: center;;">Home Team</td><td style="font-weight: bold;text-align: center;;">Away/Home Score</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Winning Team</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="border-top: 1px solid black;;">Sunday</td><td style="border-top: 1px solid black;;">Tampa Bay</td><td style="border-top: 1px solid black;;">Texas</td><td style="text-align: center;border-top: 1px solid black;;">5</td><td style="text-align: center;border-top: 1px solid black;;">2</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;;">Tampa Bay</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">10/10</td><td style=";">San Francisco</td><td style=";">Atlanta</td><td style="text-align: center;;">3</td><td style="text-align: center;;">2</td><td style="font-weight: bold;border-right: 1px solid black;;">San Francisco</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;"></td><td style=";">Philadelphia</td><td style=";">Cincinnati</td><td style="text-align: center;;">2</td><td style="text-align: center;;">0</td><td style="font-weight: bold;border-right: 1px solid black;;">Philadelphia</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B20</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">COUNTIF(<font color="Green">$F6:$F18,$G7</font>)<3,COUNTIF(<font color="Green">$F6:$F18,$G3</font>)<3</font>),$G3,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C20</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">COUNTIF(<font color="Green">$F6:$F18,$G3</font>)<3,COUNTIF(<font color="Green">$F6:$F18,$G7</font>)<3</font>),$G7,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F20</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D20<>"",E20<>""</font>),(<font color="Red">IF(<font color="Green">D20>E20,B20,C20</font>)</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />
On the right side of the sheet the teams should be placed into their respective bracket location based on this criteria.
1) the top seed is the team with the best record in the league.
2) the lower seeded division teams will face each other (unless if 4 happens)
3) the wild card is the team with the best record that did NOT win their division, they should face the league winner (unless if 4 happens)
4) if the wild card is from the same division as the team with the best record of the league then they will not face each other in the first round (division series) so the wild card faces the second highest divisional winner. This is what the bracket should look like for the American League. My problem is how after 162 games to place the teams in the right bracket using the conditions above (either with macros or with some formulas)
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;;">Division Series</td><td style="font-weight: bold;text-align: center;;">Championship Series</td><td style="font-weight: bold;text-align: center;;">World Series</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;;">ALDS</td><td style="font-weight: bold;text-align: center;;">ALCS</td><td style="font-weight: bold;text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Tampa Bay</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Unless Wild Card</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Minnesota</td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">Unless WC</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">3,4,5</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G3</th><td style="text-align:left">=IF(<font color="Blue">League!J3:J16="Clinched!",League!A3,"AL Leader"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H5</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G3</font>)>2,COUNTIF(<font color="Green">$F$6:$F$32,G7</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G3</font>)=3,G3,G7</font>),"AL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I9</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$35:$F$57,H5</font>)>3,COUNTIF(<font color="Green">$F$35:$F$57,H13</font>)>3</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$35:$F$57,H5</font>)=4,H5,H13</font>),"AL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H13</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G11</font>)>2,COUNTIF(<font color="Green">$F$6:$F$32,G15</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G11</font>)=3,G11,G15</font>),"AL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I13</th><td style="text-align:left">=IF(<font color="Blue">F4=C4,"Home Field","3,4,5"</font>)</td></tr></tbody></table></td></tr></table><br />
If anyone could give me some idea of how this should be done it would be greatly appreciated. Thanks again for reading through
On the left side of the sheet you find a list where each individual game of the postseason and series. Underneath you'll find an example of the first day of the playoffs from 2010.
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Date</td><td style="font-weight: bold;text-align: center;;">Visiting Team</td><td style="font-weight: bold;text-align: center;;">Home Team</td><td style="font-weight: bold;text-align: center;;">Away/Home Score</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Winning Team</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Wednessday</td><td style=";">Texas</td><td style=";">Tampa Bay</td><td style="text-align: center;;">5</td><td style="text-align: center;;">1</td><td style="font-weight: bold;border-right: 1px solid black;;">Texas</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">10/6</td><td style=";">New York (AL)</td><td style=";">Minnesota</td><td style="text-align: center;;">6</td><td style="text-align: center;;">1</td><td style="font-weight: bold;border-right: 1px solid black;;">New York (AL)</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style=";">Cincinnati</td><td style=";">Philadelphia</td><td style="text-align: center;;">0</td><td style="text-align: center;;">4</td><td style="font-weight: bold;border-right: 1px solid black;;">Philadelphia</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B6</th><td style="text-align:left">=G7</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C6</th><td style="text-align:left">=G3</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F6</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D6<>"",E6<>""</font>),(<font color="Red">IF(<font color="Green">D6>E6,B6,C6</font>)</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />
Sorry that the columns on the score are not so well spaced. Should the series go beyond those games that are necessary then this is the equation that shows up for games beyond game 3 in a 5 game series and game 4 in a 7 game series.
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Date</td><td style="font-weight: bold;text-align: center;;">Visiting Team</td><td style="font-weight: bold;text-align: center;;">Home Team</td><td style="font-weight: bold;text-align: center;;">Away/Home Score</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Winning Team</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="border-top: 1px solid black;;">Sunday</td><td style="border-top: 1px solid black;;">Tampa Bay</td><td style="border-top: 1px solid black;;">Texas</td><td style="text-align: center;border-top: 1px solid black;;">5</td><td style="text-align: center;border-top: 1px solid black;;">2</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;;">Tampa Bay</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">10/10</td><td style=";">San Francisco</td><td style=";">Atlanta</td><td style="text-align: center;;">3</td><td style="text-align: center;;">2</td><td style="font-weight: bold;border-right: 1px solid black;;">San Francisco</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;"></td><td style=";">Philadelphia</td><td style=";">Cincinnati</td><td style="text-align: center;;">2</td><td style="text-align: center;;">0</td><td style="font-weight: bold;border-right: 1px solid black;;">Philadelphia</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B20</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">COUNTIF(<font color="Green">$F6:$F18,$G7</font>)<3,COUNTIF(<font color="Green">$F6:$F18,$G3</font>)<3</font>),$G3,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C20</th><td style="text-align:left">=IF(<font color="Blue">AND(<font color="Red">COUNTIF(<font color="Green">$F6:$F18,$G3</font>)<3,COUNTIF(<font color="Green">$F6:$F18,$G7</font>)<3</font>),$G7,""</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F20</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D20<>"",E20<>""</font>),(<font color="Red">IF(<font color="Green">D20>E20,B20,C20</font>)</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />
On the right side of the sheet the teams should be placed into their respective bracket location based on this criteria.
1) the top seed is the team with the best record in the league.
2) the lower seeded division teams will face each other (unless if 4 happens)
3) the wild card is the team with the best record that did NOT win their division, they should face the league winner (unless if 4 happens)
4) if the wild card is from the same division as the team with the best record of the league then they will not face each other in the first round (division series) so the wild card faces the second highest divisional winner. This is what the bracket should look like for the American League. My problem is how after 162 games to place the teams in the right bracket using the conditions above (either with macros or with some formulas)
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;;">Division Series</td><td style="font-weight: bold;text-align: center;;">Championship Series</td><td style="font-weight: bold;text-align: center;;">World Series</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-align: center;border-left: 1px solid black;;">ALDS</td><td style="font-weight: bold;text-align: center;;">ALCS</td><td style="font-weight: bold;text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Tampa Bay</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Texas</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;;">Unless Wild Card</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Minnesota</td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">Home Field</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">Unless WC</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="font-weight: bold;text-align: center;border-right: 1px solid black;border-left: 1px solid black;;">3,4,5</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Playoffs</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G3</th><td style="text-align:left">=IF(<font color="Blue">League!J3:J16="Clinched!",League!A3,"AL Leader"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H5</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G3</font>)>2,COUNTIF(<font color="Green">$F$6:$F$32,G7</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G3</font>)=3,G3,G7</font>),"AL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I9</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$35:$F$57,H5</font>)>3,COUNTIF(<font color="Green">$F$35:$F$57,H13</font>)>3</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$35:$F$57,H5</font>)=4,H5,H13</font>),"AL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H13</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G11</font>)>2,COUNTIF(<font color="Green">$F$6:$F$32,G15</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$F$6:$F$32,G11</font>)=3,G11,G15</font>),"AL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I13</th><td style="text-align:left">=IF(<font color="Blue">F4=C4,"Home Field","3,4,5"</font>)</td></tr></tbody></table></td></tr></table><br />
If anyone could give me some idea of how this should be done it would be greatly appreciated. Thanks again for reading through
