Creating a Calendar

Joneye · Jul 1, 2011

Any advice on creating a calendar in excel 2003.

Needs to include tracking staff of 40 peoples holidays both AM, PM, and Full day.

My offering is below, problem with this is the dates are static and need to be entered in each year, tab one note shown, that collects the detail and reports it as an overview.

Just trying to see if thre are better methods than mine.

Excel 2003<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 /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><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><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th><th>AE</th><th>AF</th><th>AG</th><th>AH</th><th>AI</th><th>AJ</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #99CCFF;;">April</td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></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;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">6</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">7</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">9</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">14</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">15</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">16</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">17</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">18</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">19</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">21</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">22</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">23</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">24</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">25</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">26</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">27</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">28</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">29</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">30</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;"></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;">3</td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></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;">4</td><td style="border-right: 1px solid black;;">Name 1 </td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-right: 1px solid black;;">Name 2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-right: 1px solid black;;">Name 3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">3</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-right: 1px solid black;;">Name 4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="border-right: 1px solid black;;">Name 5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">2</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="border-right: 1px solid black;;">Name 6</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-bottom: 1px solid black;;"></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;">11</td><td style="border-right: 1px solid black;;">Name 6</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">3</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="border-right: 1px solid black;;">Name 7</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">4</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="border-right: 1px solid black;;">Name 8</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">1</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="border-right: 1px solid black;;">Name 9</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="border-right: 1px solid black;;">Name 10</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">5</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="border-right: 1px solid black;;">Name 11</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">L</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">4</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">4</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="border-right: 1px solid black;;">Name 12</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="border-right: 1px solid black;;">Name 13</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #CCFFFF;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CCFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-left: 1px solid black;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td><td style="text-align: right;;">0</td></tr></tbody></table>Sheet1 <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" >Worksheet Formulas<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">AG4</th><td style="text-align:left">=COUNTIF(B4:AF4,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH4</th><td style="text-align:left">=COUNTIF(B4:AF4,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI4</th><td style="text-align:left">=COUNTIF(B4:AF4,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ4</th><td style="text-align:left">=SUM(AG4:AI4)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG5</th><td style="text-align:left">=COUNTIF(B5:AF5,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH5</th><td style="text-align:left">=COUNTIF(B5:AF5,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI5</th><td style="text-align:left">=COUNTIF(B5:AF5,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ5</th><td style="text-align:left">=SUM(AG5:AI5)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG6</th><td style="text-align:left">=COUNTIF(B6:AF6,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH6</th><td style="text-align:left">=COUNTIF(B6:AF6,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI6</th><td style="text-align:left">=COUNTIF(B6:AF6,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ6</th><td style="text-align:left">=SUM(AG6:AI6)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG7</th><td style="text-align:left">=COUNTIF(B7:AF7,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH7</th><td style="text-align:left">=COUNTIF(B7:AF7,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI7</th><td style="text-align:left">=COUNTIF(B7:AF7,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ7</th><td style="text-align:left">=SUM(AG7:AI7)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG8</th><td style="text-align:left">=COUNTIF(B8:AF8,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH8</th><td style="text-align:left">=COUNTIF(B8:AF8,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI8</th><td style="text-align:left">=COUNTIF(B8:AF8,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ8</th><td style="text-align:left">=SUM(AG8:AI8)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG9</th><td style="text-align:left">=COUNTIF(B9:AF9,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH9</th><td style="text-align:left">=COUNTIF(B9:AF9,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI9</th><td style="text-align:left">=COUNTIF(B9:AF9,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ9</th><td style="text-align:left">=SUM(AG9:AI9)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG11</th><td style="text-align:left">=COUNTIF(B11:AF11,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH11</th><td style="text-align:left">=COUNTIF(B11:AF11,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI11</th><td style="text-align:left">=COUNTIF(B11:AF11,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ11</th><td style="text-align:left">=SUM(AG11:AI11)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG12</th><td style="text-align:left">=COUNTIF(B12:AF12,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH12</th><td style="text-align:left">=COUNTIF(B12:AF12,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI12</th><td style="text-align:left">=COUNTIF(B12:AF12,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ12</th><td style="text-align:left">=SUM(AG12:AI12)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG13</th><td style="text-align:left">=COUNTIF(B13:AF13,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH13</th><td style="text-align:left">=COUNTIF(B13:AF13,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI13</th><td style="text-align:left">=COUNTIF(B13:AF13,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ13</th><td style="text-align:left">=SUM(AG13:AI13)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG14</th><td style="text-align:left">=COUNTIF(B14:AF14,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH14</th><td style="text-align:left">=COUNTIF(B14:AF14,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI14</th><td style="text-align:left">=COUNTIF(B14:AF14,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ14</th><td style="text-align:left">=SUM(AG14:AI14)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG15</th><td style="text-align:left">=COUNTIF(B15:AF15,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH15</th><td style="text-align:left">=COUNTIF(B15:AF15,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI15</th><td style="text-align:left">=COUNTIF(B15:AF15,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ15</th><td style="text-align:left">=SUM(AG15:AI15)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG16</th><td style="text-align:left">=COUNTIF(B16:AF16,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH16</th><td style="text-align:left">=COUNTIF(B16:AF16,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI16</th><td style="text-align:left">=COUNTIF(B16:AF16,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ16</th><td style="text-align:left">=SUM(AG16:AI16)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG17</th><td style="text-align:left">=COUNTIF(B17:AF17,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH17</th><td style="text-align:left">=COUNTIF(B17:AF17,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI17</th><td style="text-align:left">=COUNTIF(B17:AF17,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ17</th><td style="text-align:left">=SUM(AG17:AI17)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AG18</th><td style="text-align:left">=COUNTIF(B18:AF18,"L")</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AH18</th><td style="text-align:left">=COUNTIF(B18:AF18,"AM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AI18</th><td style="text-align:left">=COUNTIF(B18:AF18,"PM")/2</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">AJ18</th><td style="text-align:left">=SUM(AG18:AI18)</td></tr></tbody></table></td></tr></table>

yytsunamiyy · Jul 1, 2011

Joneye said:
Any advice on creating a calendar in excel 2003.

Needs to include tracking staff of 40 peoples holidays both AM, PM, and Full day.

My offering is below, problem with this is the dates are static and need to be entered in each year, tab one note shown, that collects the detail and reports it as an overview.

Just trying to see if thre are better methods than mine.

Excel 2003<table style="background-color: rgb(255, 255, 255); border: 1px solid rgb(166, 170, 182); border-collapse: collapse;" cellpadding="2.5px" rules="all"><colgroup><col style="background-color: rgb(224, 224, 240);" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style="background-color: rgb(224, 224, 240); text-align: center; color: rgb(22, 17, 32);"><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><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th><th>AE</th><th>AF</th><th>AG</th><th>AH</th><th>AI</th><th>AJ</th></tr></thead><tbody><tr><td style="color: rgb(22, 17, 32); text-align: center;">1</td><td style="font-weight: bold; border: 1px solid black; color: rgb(255, 255, 255); background-color: rgb(153, 204, 255);">April</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black;">
</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: rgb(22, 17, 32); text-align: center;">2</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">1</td><td style="text-align: right; border: 1px solid black;">2</td><td style="text-align: right; border: 1px solid black;">3</td><td style="text-align: right; border: 1px solid black;">4</td><td style="text-align: right; border: 1px solid black;">5</td><td style="text-align: right; border: 1px solid black;">6</td><td style="text-align: right; border: 1px solid black;">7</td><td style="text-align: right; border: 1px solid black;">8</td><td style="text-align: right; border: 1px solid black;">9</td><td style="text-align: right; border: 1px solid black;">10</td><td style="text-align: right; border: 1px solid black;">11</td><td style="text-align: right; border: 1px solid black;">12</td><td style="text-align: right; border: 1px solid black;">13</td><td style="text-align: right; border: 1px solid black;">14</td><td style="text-align: right; border: 1px solid black;">15</td><td style="text-align: right; border: 1px solid black;">16</td><td style="text-align: right; border: 1px solid black;">17</td><td style="text-align: right; border: 1px solid black;">18</td><td style="text-align: right; border: 1px solid black;">19</td><td style="text-align: right; border: 1px solid black;">20</td><td style="text-align: right; border: 1px solid black;">21</td><td style="text-align: right; border: 1px solid black;">22</td><td style="text-align: right; border: 1px solid black;">23</td><td style="text-align: right; border: 1px solid black;">24</td><td style="text-align: right; border: 1px solid black;">25</td><td style="text-align: right; border: 1px solid black;">26</td><td style="text-align: right; border: 1px solid black;">27</td><td style="text-align: right; border: 1px solid black;">28</td><td style="text-align: right; border: 1px solid black;">29</td><td style="text-align: right; border: 1px solid black;">30</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">
</td><td style="text-align: right;">
</td><td style="text-align: right;">
</td><td style="text-align: right;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">3</td><td style="text-align: right;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</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: rgb(22, 17, 32); text-align: center;">4</td><td style="border-right: 1px solid black;">Name 1 </td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">5</td><td style="border-right: 1px solid black;">Name 2</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">6</td><td style="border-right: 1px solid black;">Name 3</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">3</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">3</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">7</td><td style="border-right: 1px solid black;">Name 4</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">8</td><td style="border-right: 1px solid black;">Name 5</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">2</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">2</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">9</td><td style="border-right: 1px solid black;">Name 6</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">10</td><td style="text-align: right;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-bottom: 1px solid black;">
</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: rgb(22, 17, 32); text-align: center;">11</td><td style="border-right: 1px solid black;">Name 6</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-top: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-top: 1px solid black; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">3</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">3</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">12</td><td style="border-right: 1px solid black;">Name 7</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">L</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">4</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">4</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">13</td><td style="border-right: 1px solid black;">Name 8</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">L</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">1</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">1</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">14</td><td style="border-right: 1px solid black;">Name 9</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">15</td><td style="border-right: 1px solid black;">Name 10</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">5</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">5</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">16</td><td style="border-right: 1px solid black;">Name 11</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">L</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">4</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">4</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">17</td><td style="border-right: 1px solid black;">Name 12</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">18</td><td style="border-right: 1px solid black;">Name 13</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="border: 1px solid black;">B</td><td style="text-align: right; border-right: 1px solid black; border-bottom: 1px solid black; border-left: 1px solid black; background-color: rgb(204, 255, 255);">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: right; border-left: 1px solid black;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td><td style="text-align: right;">0</td></tr></tbody></table>
Sheet1

Sorry, your question is not very clear. What are you actually wanting to do? Do you need a wb with 12 sheets that gives you a monthly calender with weekends marked light blue automatically where you can enter attendence manually?

Joneye · Jul 1, 2011

All the calendar data is manual, im looking to automate it somehow, the sanp shot is for a month, forget the names etc... Im looking to automate colours and dates within the calendar.

yytsunamiyy · Jul 1, 2011

Maybe you are after something like this:

Excel Workbook

A

B

C

D

E

F

G

H

I

J

K

L

1

Year

2011

2

Month

Jul

3

01

02

03

04

05

06

07

08

09

10

11

4

Name 1

5

Name 2

6

Name 3

7

Name 4

Tabelle2

Cell Formulas
Range	Formula
B3	=DATEVALUE("01."&MONTH($B$2)&"."&$B$1)
C3	=IF(B3+1DATEVALUE("01."&MONTH($B$2)&"."&$B$1),1),B3+1,"")

B1 contains a number formated as a number
B2 contains the date 01.07.2011 formated as "MMM"
B3 - AF3 have formulas with formula in C3 right filled to AF, formated as "DD"

To highlight weekends use conditional formating with the formula:

Excel Workbook

Formula

=OR(WEEKDAY(B$3)=7,WEEKDAY(B$3)=1)

...

with a fillcolor of your choice.

Excelboy_01 · Sep 15, 2011

Hello people,
I have a rather related but different problem. I am trying to assign cells with specific dates based on the week number in the corresponding year. Lets say, in Cell A1 i have "Year" and and Cell A2 I have the "week" as illustrated below:

<table style="width: 491px; height: 76px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:768; width:16pt" span="19" width="21"> <col style="mso-width-source:userset;mso-width-alt:768;width:16pt" width="21"> <col style="mso-width-source:userset;mso-width-alt:768; width:16pt" span="2" width="21"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td colspan="22" class="xl326" style="border-right:1.0pt solid black; height:15.0pt;width:352pt" height="20" width="462">YEAR: .................................2011.................</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl329" style="height:14.25pt;border-top:none" height="19">Week:1
</td> <td class="xl325" style="border-top:none;border-left:none">.2.</td> <td class="xl325" style="border-top:none;border-left:none">3.</td> <td class="xl325" style="border-top:none;border-left:none">4.</td> <td class="xl325" style="border-top:none;border-left:none">5.</td> <td class="xl325" style="border-top:none;border-left:none">6</td> <td class="xl325" style="border-top:none;border-left:none">.7</td> <td class="xl325" style="border-top:none;border-left:none">.8</td> <td class="xl325" style="border-top:none;border-left:none">.9.</td> <td class="xl325" style="border-top:none;border-left:none">10..............37</td> <td class="xl325" style="border-top:none;border-left:none"> .38.
</td> <td class="xl325" style="border-top:none;border-left:none"> 39</td><td class="xl325" style="border-top:none;border-left:none">........</td><td class="xl325" style="border-top:none;border-left:none">.</td><td class="xl325" style="border-top:none;border-left:none">
</td><td class="xl325" style="border-top:none;border-left:none">
</td><td class="xl325" style="border-top:none;border-left:none">
</td><td class="xl325" style="border-top:none;border-left:none">
</td><td class="xl325" style="border-top:none;border-left:none">
</td> <td class="xl325" style="border-top:none;border-left:none">50</td> <td class="xl325" style="border-top:none;border-left:none">.51.</td> <td class="xl330" style="border-top:none;border-left:none">52</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl331" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl332" style="border-top:none;border-left:none">
</td> <td class="xl333" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>
Since I know (for example) that the 37th week of 2011 starts from Monday, 12th - 18th September, 2011. I would like to assign this time to a specific cell. Which will in the end help me create a reminder (with conditional formatting) so that one week before Sept. 12th I get a remonder.

Essentially, I think even if I get a solution that can calculate / tell me the first day of every week, that should also be good.

Thanks in advance

Moses

Bill C · Sep 15, 2011

Hello yytsunamiyy,
I read your post and followed your tips on a self generating calendar and had to change a few things to make the date functions work with US date format. Everything works great with one exception. I can not make the conditional format work with B$3 to highlight Saturday and Sunday. I know it works with datevalue() if I just make a list of date numbers as reference for the datevalue function.

Thu 40787 FALSE
Fri 40788 FALSE
Sat 40789 TRUE
Sun 40790 TRUE
Mon 40791 FALSE
Tue 40792 FALSE
Wed 40793 FALSE
Thu 40794 FALSE
Fri 40795 FALSE
Sat 40796 TRUE
Sun 40797 TRUE
Mon 40798 FALSE
Tue 40799 FALSE
Wed 40800 FALSE
Thu 40801 FALSE
Fri 40802 FALSE
Sat 40803 TRUE
Sun 40804 TRUE
Mon 40805 FALSE
Tue 40806 FALSE
Wed 40807 FALSE

Can you help with this?

Bill C

Excelboy_01 · Sep 16, 2011

I am not sure if I got what you really want to do, but in case you were trying to solve my initial problem of "Converting week number to a date" there is actually an easier in which it can be solved.
Say, I write

37 (number of week in cell A1)
2011(the year, in cell A2)
To get the date in C1, I can use the formula =DATE(A2,1,A1*7-2)-WEEKDAY(DATE(A2,1,3))

Convert from European to US format select the cell FORMAT - Cells - (Under Number) Date and choose the format of your choice.

Hope that helps

Moses

Bill C · Sep 16, 2011

I finally figured it out. It's not elegant but it works. I hid the extra rows That I used to refer "true" "False" for the conditional formatting.
Thanks,
Bill C

Creating a Calendar

Joneye

Well-known Member

Excel Facts

yytsunamiyy

Well-known Member

Joneye

Well-known Member

yytsunamiyy

Well-known Member

Excelboy_01

New Member

Bill C

New Member

Excelboy_01

New Member

Bill C

New Member

Similar threads

Forum statistics

Share this page

Creating a Calendar

Well-known Member

Excel Facts

Well-known Member

Well-known Member

Well-known Member

New Member

New Member

New Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock