I've been trying to create an Excel sheet that can correctly show baseball standings for either your fantasy or thought the real life leagues. Here is an example of what my format looks like for the final standings are in the American League East Division for 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 /><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><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">LG/Team</td><td style="font-weight: bold;;">Wins</td><td style="font-weight: bold;;">Losses</td><td style="font-weight: bold;;">Ties</td><td style="font-weight: bold;;">Played</td><td style="font-weight: bold;;">Win %</td><td style="font-weight: bold;;">GB</td><td style="font-weight: bold;;">M/E #</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">AL East</td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;;">Tampa Bay</td><td style="text-align: right;;">96</td><td style="text-align: right;;">66</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5926</td><td style=";">Div Leader</td><td style="border-bottom: 1px solid black;;">Clinched!</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;;">New York (AL)</td><td style="text-align: right;;">95</td><td style="text-align: right;;">67</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5864</td><td style="text-align: right;;">1</td><td style="border-top: 1px solid black;;">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Boston</td><td style="text-align: right;;">89</td><td style="text-align: right;;">73</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5494</td><td style="text-align: right;;">7</td><td style=";">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Toronto</td><td style="text-align: right;;">85</td><td style="text-align: right;;">77</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5247</td><td style="text-align: right;;">11</td><td style=";">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Baltimore</td><td style="text-align: right;;">66</td><td style="text-align: right;;">96</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.4074</td><td style="text-align: right;;">30</td><td style=";">Eliminated</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">Division</p><br /><br />
Where the Win percentage formula is . . .
(Wins+(Ties/2))/(Wins+Losses+Ties)
and the Games Behind (GB) formula is . . .
=IF(MAX(F3:F7)=F3,"Div Leader",((MAX(B3:B7)-B3)+(C3-MIN(C3:C7)))/2)
The formula that I need to work and fix on is the Magic/Elimination Number (also known as "Tragic") number. The equation that I have going on right now is for the Magic Number . . .
=IF(E3=162,"Clinched", B4+(162-E3)-B3+1) Division Leader
and for the Elimination Number . . .
=IF(E4=162,"Eliminated",(162+1)-B3-C4)
Using these formulas here are the numbers (as of today) of the highly charged and close National League Central Division Race . . .
<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 /><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><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Team</td><td style="font-weight: bold;;">Wins</td><td style="font-weight: bold;;">Losses</td><td style="font-weight: bold;;">Ties</td><td style="font-weight: bold;;">Played</td><td style="font-weight: bold;;">Win %</td><td style="font-weight: bold;;">GB</td><td style="font-weight: bold;;">M/E #</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;;">NL Central</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style=";">Milwaukee</td><td style="text-align: right;;">61</td><td style="text-align: right;;">49</td><td style="text-align: right;;">0</td><td style="text-align: right;;">110</td><td style="text-align: right;;">0.5545</td><td style=";">Div Leader</td><td style="text-align: right;border-bottom: 1px solid black;;">49</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style=";">St. Louis</td><td style="text-align: right;;">57</td><td style="text-align: right;;">52</td><td style="text-align: right;;">0</td><td style="text-align: right;;">109</td><td style="text-align: right;;">0.5229</td><td style="text-align: right;;">3.5</td><td style="text-align: right;border-top: 1px solid black;;">45</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style=";">Pittsburgh</td><td style="text-align: right;;">54</td><td style="text-align: right;;">53</td><td style="text-align: right;;">0</td><td style="text-align: right;;">107</td><td style="text-align: right;;">0.5047</td><td style="text-align: right;;">5.5</td><td style="text-align: right;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style=";">Cincinnati</td><td style="text-align: right;;">53</td><td style="text-align: right;;">56</td><td style="text-align: right;;">0</td><td style="text-align: right;;">109</td><td style="text-align: right;;">0.4862</td><td style="text-align: right;;">7.5</td><td style="text-align: right;;">41</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">Division</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">E30</th><td style="text-align:left">=SUM(<font color="Blue">B30:D30</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F30</th><td style="text-align:left">=(<font color="Blue">B30+(<font color="Red">D30/2</font>)</font>)/(<font color="Blue">B30+C30+D30</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G30</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F30,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B30</font>)+(<font color="Green">C30-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H30</th><td style="text-align:left">=IF(<font color="Blue">E30=162,"Clinched!",B31+(<font color="Red">162-E30</font>)-B30+1</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E31</th><td style="text-align:left">=SUM(<font color="Blue">B31:D31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F31</th><td style="text-align:left">=(<font color="Blue">B31+(<font color="Red">D31/2</font>)</font>)/(<font color="Blue">B31+C31+D31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G31</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F31,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B31</font>)+(<font color="Green">C31-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H31</th><td style="text-align:left">=IF(<font color="Blue">E31=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E32</th><td style="text-align:left">=SUM(<font color="Blue">B32:D32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F32</th><td style="text-align:left">=(<font color="Blue">B32+(<font color="Red">D32/2</font>)</font>)/(<font color="Blue">B32+C32+D32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G32</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F32,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B32</font>)+(<font color="Green">C32-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H32</th><td style="text-align:left">=IF(<font color="Blue">E32=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E33</th><td style="text-align:left">=SUM(<font color="Blue">B33:D33</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F33</th><td style="text-align:left">=(<font color="Blue">B33+(<font color="Red">D33/2</font>)</font>)/(<font color="Blue">B33+C33+D33</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G33</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F33,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B33</font>)+(<font color="Green">C33-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H33</th><td style="text-align:left">=IF(<font color="Blue">E33=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C33</font>)</td></tr></tbody></table></td></tr></table><br />
Yet these numbers are slightly off from what these numbers actually are available at (http://www.mlbmagicnumbers.com/) and (http://riot.ieor.berkeley.edu/~baseball/)
Along with this page with the division standings I have a sheet for League and Overall standings. My next problem is how to create a page for the Wild Card standings, eliminating the teams that have a higher win percentage then the wild card leader yet keeping weaker division teams (those with Win % lower then the wild card) within the race.
The final issue is that of creating a playoff picture. There are several conditions that baseball has placed on the current playoff picture. The League Leader will play the wild card unless the wild card should come from the same division then the match ups will be reversed. This is how the playoff picture looks like for the year 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 /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">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><td style="font-weight: bold;;">WS Champion</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;;">AL Division Series</td><td style="font-weight: bold;text-align: center;;">AL Championship Series</td><td style="font-weight: bold;text-align: center;;">World Series</td><td style="font-weight: bold;;">WS Champion</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;;">Texas</td><td style="text-align: center;;"></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="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><td style="text-align: center;;"></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><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><td style="text-align: center;;"></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;;">Tampa Bay</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></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;">8</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><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;">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><td style="text-align: center;;"></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="text-align: center;border-right: 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;">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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</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-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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</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-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="text-align: center;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;">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><td style="text-align: center;border-left: 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><td style="text-align: right;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;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;">17</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-bottom: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-left: 1px solid black;;">NL Division Series</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;;">NL Championship Series</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;;">World Series</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Philadelphia</td><td style="text-align: center;;"></td><td style="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;">21</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><td style="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;">22</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;;">Philadelphia</td><td style="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;">23</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-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;">24</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Cincinnati</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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</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><td style="text-align: center;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;">26</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-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</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="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td><td style="text-align: center;border-right: 1px solid black;;"></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;">29</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-right: 1px solid black;border-left: 1px solid black;;"></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;">30</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-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</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;">31</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-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Atlanta</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></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">I3</th><td style="text-align:left">=IF(<font color="Blue">Division!E17=162,Division!A17,"AL West"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J5</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I3</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I7</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I3</font>)=3,I3,I7</font>),"AL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I7</th><td style="text-align:left">=IF(<font color="Blue">League!E3=162,League!A3,"AL Winner"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K9</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$38:$G$69,J5</font>)>2,COUNTIF(<font color="Green">$G$38:$G$69,J13</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$33:$G$69,J5</font>)=3,J13,J5</font>),"AL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I11</th><td style="text-align:left">=IF(<font color="Blue">Division!E10=162,Division!A10,"AL Central"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J13</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I11</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I15</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I11</font>)=3,I11,I15</font>),"AL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I15</th><td style="text-align:left">=IF(<font color="Blue">'Wild Card'!E3=162,'Wild Card'!A4,"AL Wild Card"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L18</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$72:$G$90,K9</font>)>2,COUNTIF(<font color="Green">$G$72:$G$90,K26</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$72:$G$90,K26</font>)>3,K26,K9</font>),"WS CHAMPS!"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I20</th><td style="text-align:left">=IF(<font color="Blue">League!E19=162,League!A19,"NL Winner"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J22</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I20</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I24</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I20</font>)=3,I20,I24</font>),"NL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I24</th><td style="text-align:left">=IF(<font color="Blue">Division!E30=162,Division!A30,"NL Central"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K26</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$39:$G$69,J22</font>)>2,COUNTIF(<font color="Green">$G$39:$G$69,J30</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$39:$G$69,J22</font>)=3,J22,J30</font>),"NL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I28</th><td style="text-align:left">=IF(<font color="Blue">Division!E38=162,Division!A38,"NL West"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J30</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I28</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I32</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I28</font>)=3,I28,I32</font>),"NL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I32</th><td style="text-align:left">=IF(<font color="Blue">'Wild Card'!E19=162,'Wild Card'!A22,"NL Wild Card"</font>)</td></tr></tbody></table></td></tr></table><br />
To the left of this chart are the individual scores of each of the playoff games with the series winner being placed in the next round. I could use some help making these conditionals for the playoffs as well as making a playoff picture (so as to see what would happen if the playoffs ended today rather then what would occur at the end). With these issues resolved the sheet and the book will be in order.
Thanks for all the help and for reading this really long post.
<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 /><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><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">LG/Team</td><td style="font-weight: bold;;">Wins</td><td style="font-weight: bold;;">Losses</td><td style="font-weight: bold;;">Ties</td><td style="font-weight: bold;;">Played</td><td style="font-weight: bold;;">Win %</td><td style="font-weight: bold;;">GB</td><td style="font-weight: bold;;">M/E #</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;;">AL East</td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;;">Tampa Bay</td><td style="text-align: right;;">96</td><td style="text-align: right;;">66</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5926</td><td style=";">Div Leader</td><td style="border-bottom: 1px solid black;;">Clinched!</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;;">New York (AL)</td><td style="text-align: right;;">95</td><td style="text-align: right;;">67</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5864</td><td style="text-align: right;;">1</td><td style="border-top: 1px solid black;;">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Boston</td><td style="text-align: right;;">89</td><td style="text-align: right;;">73</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5494</td><td style="text-align: right;;">7</td><td style=";">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Toronto</td><td style="text-align: right;;">85</td><td style="text-align: right;;">77</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.5247</td><td style="text-align: right;;">11</td><td style=";">Eliminated</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Baltimore</td><td style="text-align: right;;">66</td><td style="text-align: right;;">96</td><td style="text-align: right;;">0</td><td style="text-align: right;;">162</td><td style="text-align: right;;">0.4074</td><td style="text-align: right;;">30</td><td style=";">Eliminated</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">Division</p><br /><br />
Where the Win percentage formula is . . .
(Wins+(Ties/2))/(Wins+Losses+Ties)
and the Games Behind (GB) formula is . . .
=IF(MAX(F3:F7)=F3,"Div Leader",((MAX(B3:B7)-B3)+(C3-MIN(C3:C7)))/2)
The formula that I need to work and fix on is the Magic/Elimination Number (also known as "Tragic") number. The equation that I have going on right now is for the Magic Number . . .
=IF(E3=162,"Clinched", B4+(162-E3)-B3+1) Division Leader
and for the Elimination Number . . .
=IF(E4=162,"Eliminated",(162+1)-B3-C4)
Using these formulas here are the numbers (as of today) of the highly charged and close National League Central Division Race . . .
<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 /><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><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">Team</td><td style="font-weight: bold;;">Wins</td><td style="font-weight: bold;;">Losses</td><td style="font-weight: bold;;">Ties</td><td style="font-weight: bold;;">Played</td><td style="font-weight: bold;;">Win %</td><td style="font-weight: bold;;">GB</td><td style="font-weight: bold;;">M/E #</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;;">NL Central</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style=";">Milwaukee</td><td style="text-align: right;;">61</td><td style="text-align: right;;">49</td><td style="text-align: right;;">0</td><td style="text-align: right;;">110</td><td style="text-align: right;;">0.5545</td><td style=";">Div Leader</td><td style="text-align: right;border-bottom: 1px solid black;;">49</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style=";">St. Louis</td><td style="text-align: right;;">57</td><td style="text-align: right;;">52</td><td style="text-align: right;;">0</td><td style="text-align: right;;">109</td><td style="text-align: right;;">0.5229</td><td style="text-align: right;;">3.5</td><td style="text-align: right;border-top: 1px solid black;;">45</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style=";">Pittsburgh</td><td style="text-align: right;;">54</td><td style="text-align: right;;">53</td><td style="text-align: right;;">0</td><td style="text-align: right;;">107</td><td style="text-align: right;;">0.5047</td><td style="text-align: right;;">5.5</td><td style="text-align: right;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style=";">Cincinnati</td><td style="text-align: right;;">53</td><td style="text-align: right;;">56</td><td style="text-align: right;;">0</td><td style="text-align: right;;">109</td><td style="text-align: right;;">0.4862</td><td style="text-align: right;;">7.5</td><td style="text-align: right;;">41</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">Division</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">E30</th><td style="text-align:left">=SUM(<font color="Blue">B30:D30</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F30</th><td style="text-align:left">=(<font color="Blue">B30+(<font color="Red">D30/2</font>)</font>)/(<font color="Blue">B30+C30+D30</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G30</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F30,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B30</font>)+(<font color="Green">C30-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H30</th><td style="text-align:left">=IF(<font color="Blue">E30=162,"Clinched!",B31+(<font color="Red">162-E30</font>)-B30+1</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E31</th><td style="text-align:left">=SUM(<font color="Blue">B31:D31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F31</th><td style="text-align:left">=(<font color="Blue">B31+(<font color="Red">D31/2</font>)</font>)/(<font color="Blue">B31+C31+D31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G31</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F31,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B31</font>)+(<font color="Green">C31-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H31</th><td style="text-align:left">=IF(<font color="Blue">E31=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C31</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E32</th><td style="text-align:left">=SUM(<font color="Blue">B32:D32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F32</th><td style="text-align:left">=(<font color="Blue">B32+(<font color="Red">D32/2</font>)</font>)/(<font color="Blue">B32+C32+D32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G32</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F32,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B32</font>)+(<font color="Green">C32-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H32</th><td style="text-align:left">=IF(<font color="Blue">E32=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C32</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E33</th><td style="text-align:left">=SUM(<font color="Blue">B33:D33</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F33</th><td style="text-align:left">=(<font color="Blue">B33+(<font color="Red">D33/2</font>)</font>)/(<font color="Blue">B33+C33+D33</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G33</th><td style="text-align:left">=IF(<font color="Blue">MAX(<font color="Red">$F$30:$F$35</font>)=F33,"Div Leader",(<font color="Red">(<font color="Green">MAX(<font color="Purple">$B$30:$B$35</font>)-B33</font>)+(<font color="Green">C33-MIN(<font color="Purple">$C$30:$C$35</font>)</font>)</font>)/2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H33</th><td style="text-align:left">=IF(<font color="Blue">E33=162,"Eliminated",(<font color="Red">162+1</font>)-B$23-C33</font>)</td></tr></tbody></table></td></tr></table><br />
Yet these numbers are slightly off from what these numbers actually are available at (http://www.mlbmagicnumbers.com/) and (http://riot.ieor.berkeley.edu/~baseball/)
Along with this page with the division standings I have a sheet for League and Overall standings. My next problem is how to create a page for the Wild Card standings, eliminating the teams that have a higher win percentage then the wild card leader yet keeping weaker division teams (those with Win % lower then the wild card) within the race.
The final issue is that of creating a playoff picture. There are several conditions that baseball has placed on the current playoff picture. The League Leader will play the wild card unless the wild card should come from the same division then the match ups will be reversed. This is how the playoff picture looks like for the year 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 /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>I</th><th>J</th><th>K</th><th>L</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">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><td style="font-weight: bold;;">WS Champion</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;;">AL Division Series</td><td style="font-weight: bold;text-align: center;;">AL Championship Series</td><td style="font-weight: bold;text-align: center;;">World Series</td><td style="font-weight: bold;;">WS Champion</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;;">Texas</td><td style="text-align: center;;"></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="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><td style="text-align: center;;"></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><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><td style="text-align: center;;"></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;;">Tampa Bay</td><td style="text-align: center;border-right: 1px solid black;border-left: 1px solid black;;"></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;">8</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><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;">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><td style="text-align: center;;"></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="text-align: center;border-right: 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;">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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</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-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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</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-bottom: 1px solid black;border-left: 1px solid black;;">New York (AL)</td><td style="text-align: center;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;">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><td style="text-align: center;border-left: 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><td style="text-align: right;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;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;">17</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-bottom: 1px solid black;;"></td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-left: 1px solid black;;">NL Division Series</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;;">NL Championship Series</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;;">World Series</td><td style="font-weight: bold;text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;border-right: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">Philadelphia</td><td style="text-align: center;;"></td><td style="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;">21</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><td style="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;">22</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;;">Philadelphia</td><td style="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;">23</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-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;">24</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Cincinnati</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><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</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><td style="text-align: center;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;">26</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-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td><td style="text-align: center;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</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="text-align: center;border-top: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;border-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</td><td style="text-align: center;border-right: 1px solid black;;"></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;">29</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-right: 1px solid black;border-left: 1px solid black;;"></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;">30</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-bottom: 1px solid black;border-left: 1px solid black;;">San Francisco</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;">31</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-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Atlanta</td><td style="text-align: center;border-left: 1px solid black;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></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">I3</th><td style="text-align:left">=IF(<font color="Blue">Division!E17=162,Division!A17,"AL West"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J5</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I3</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I7</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I3</font>)=3,I3,I7</font>),"AL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I7</th><td style="text-align:left">=IF(<font color="Blue">League!E3=162,League!A3,"AL Winner"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K9</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$38:$G$69,J5</font>)>2,COUNTIF(<font color="Green">$G$38:$G$69,J13</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$33:$G$69,J5</font>)=3,J13,J5</font>),"AL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I11</th><td style="text-align:left">=IF(<font color="Blue">Division!E10=162,Division!A10,"AL Central"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J13</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I11</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I15</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I11</font>)=3,I11,I15</font>),"AL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I15</th><td style="text-align:left">=IF(<font color="Blue">'Wild Card'!E3=162,'Wild Card'!A4,"AL Wild Card"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">L18</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$72:$G$90,K9</font>)>2,COUNTIF(<font color="Green">$G$72:$G$90,K26</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$72:$G$90,K26</font>)>3,K26,K9</font>),"WS CHAMPS!"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I20</th><td style="text-align:left">=IF(<font color="Blue">League!E19=162,League!A19,"NL Winner"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J22</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I20</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I24</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I20</font>)=3,I20,I24</font>),"NL Team 1"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I24</th><td style="text-align:left">=IF(<font color="Blue">Division!E30=162,Division!A30,"NL Central"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">K26</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$39:$G$69,J22</font>)>2,COUNTIF(<font color="Green">$G$39:$G$69,J30</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$39:$G$69,J22</font>)=3,J22,J30</font>),"NL Pennant"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I28</th><td style="text-align:left">=IF(<font color="Blue">Division!E38=162,Division!A38,"NL West"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J30</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I28</font>)>2,COUNTIF(<font color="Green">$G$3:$G$33,I32</font>)>2</font>),IF(<font color="Red">COUNTIF(<font color="Green">$G$3:$G$33,I28</font>)=3,I28,I32</font>),"NL Team 2"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I32</th><td style="text-align:left">=IF(<font color="Blue">'Wild Card'!E19=162,'Wild Card'!A22,"NL Wild Card"</font>)</td></tr></tbody></table></td></tr></table><br />
To the left of this chart are the individual scores of each of the playoff games with the series winner being placed in the next round. I could use some help making these conditionals for the playoffs as well as making a playoff picture (so as to see what would happen if the playoffs ended today rather then what would occur at the end). With these issues resolved the sheet and the book will be in order.
Thanks for all the help and for reading this really long post.
