Hi I was wondering if this was possible in excel 2007(Or 2010, I am thinking about buying it).
Can Excel Tally, what do I mean? Well say we have a school carnival there are 5 grades/classes and they are having a sports carnival. Each kid in each class will compete in all 5 events. The winner of each class will be the highest point scorer across each event. The teachers record height jumped, time run and so forth for each kid.
So say if for finishing first in an event we asigned the student 5 points, 2nd 4pts, 3rd 3pts, 4th 2pts and 5th 1pts. Do this for each event and each class and have a list/table of winners for each class.
Is this possible? Is there a good way to design a scenario like this?
Even in a table manually calculating it the highest results come to the top regardless of class. NB no this isn't a school test or anything I am 36 with three kids as it happens
.
I have created a sample table I was working with to see if I could do it.
<table border="0" cellpadding="0" cellspacing="0" width="638"><col style="width: 53pt;" width="71"> <col style="width: 62pt;" width="82"> <col style="width: 48pt;" span="5" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 53pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" height="20" width="71">number</td> <td class="xl66" style="width: 62pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="82">Column1</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">High Jump</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">200m Sprint</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Ring Toss</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Cricket</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Scrabble</td> <td class="xl66" style="width: 76pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="101">Tally</td> <td class="xl67" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Tally Score</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Mark </td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.78</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">24</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">2</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">16</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.79</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.1</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">5</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">23</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tim</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.45</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">24.5</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">11</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">36</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Bill</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.85</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.6</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">12</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">13</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">David</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.23</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">19</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Tom</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.65</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">8</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">19</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tammy</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">0.85</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">4</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">18</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sam</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">0.56</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Paul</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.01</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">13</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Matthew</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.7</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">36</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">15</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Ben</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.49</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.1</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">12</td> <td class="xl81" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt 0.5pt medium; border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">John</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.3</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">3</td> <td class="xl80" style="border-left: medium none;" align="right">19</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">14</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Luke</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.32</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">5</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">19</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">55</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Constantine</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">1.56</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">25.9</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">11</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl82" style="border-top: medium none; border-left: medium none;" align="right">65</td> <td class="xl73" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl74" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Ben</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.2</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">18</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">29</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Tim</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.35</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25.8</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">47</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tammy</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">50</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Mark </td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.24</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.2</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">17</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">54</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Matthew</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">0.58</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.1</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">58</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Bill</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">0.98</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">13</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">61</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Bill</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.02</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23.5</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">16</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">65</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.05</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.8</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">69</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">Bruce</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.56</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.3</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">73</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">David</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.78</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25.4</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">15</td> <td class="xl82" style="border-top: medium none; border-left: medium none;" align="right">76</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Matthew</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.45</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.2</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">80</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">28.5</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">36</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">14</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">84</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl76" style="height: 15.75pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="21">2</td> <td class="xl77" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Sam</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.55</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">27.6</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">14</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">88</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl79" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> </tbody></table>
Can Excel Tally, what do I mean? Well say we have a school carnival there are 5 grades/classes and they are having a sports carnival. Each kid in each class will compete in all 5 events. The winner of each class will be the highest point scorer across each event. The teachers record height jumped, time run and so forth for each kid.
So say if for finishing first in an event we asigned the student 5 points, 2nd 4pts, 3rd 3pts, 4th 2pts and 5th 1pts. Do this for each event and each class and have a list/table of winners for each class.
Is this possible? Is there a good way to design a scenario like this?
Even in a table manually calculating it the highest results come to the top regardless of class. NB no this isn't a school test or anything I am 36 with three kids as it happens
I have created a sample table I was working with to see if I could do it.
<table border="0" cellpadding="0" cellspacing="0" width="638"><col style="width: 53pt;" width="71"> <col style="width: 62pt;" width="82"> <col style="width: 48pt;" span="5" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 53pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" height="20" width="71">number</td> <td class="xl66" style="width: 62pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="82">Column1</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">High Jump</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">200m Sprint</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Ring Toss</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Cricket</td> <td class="xl66" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Scrabble</td> <td class="xl66" style="width: 76pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="101">Tally</td> <td class="xl67" style="width: 48pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" width="64">Tally Score</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Mark </td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.78</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">24</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">2</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">16</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.79</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.1</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">5</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">23</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tim</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.45</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">24.5</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">11</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">36</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Bill</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.85</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.6</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">12</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">13</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">David</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.23</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">19</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Tom</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.65</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">8</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">19</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tammy</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">0.85</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">4</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">18</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sam</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">0.56</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Paul</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.01</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">13</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Matthew</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.7</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">36</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">15</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Ben</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.49</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.1</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">12</td> <td class="xl81" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border-width: 0.5pt 0.5pt medium; border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;" align="right" height="20">1</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">John</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.3</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">3</td> <td class="xl80" style="border-left: medium none;" align="right">19</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">14</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right" height="20">1</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Luke</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.32</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">5</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">19</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">55</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Constantine</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">1.56</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">25.9</td> <td class="xl73" style="border-top: medium none; border-left: medium none;" align="right">11</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl82" style="border-top: medium none; border-left: medium none;" align="right">65</td> <td class="xl73" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl74" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Ben</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.2</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">26.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">18</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">29</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Tim</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.35</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25.8</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">47</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Tammy</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.8</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.4</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">50</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Mark </td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.24</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.2</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">17</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">54</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Matthew</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">0.58</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.1</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">58</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Bill</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">0.98</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">24.9</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">13</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">61</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Bill</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.02</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23.5</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">16</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">65</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.05</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">26.8</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">18</td> <td class="xl81" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">69</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">Bruce</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.56</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.3</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">17</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">73</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">David</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.78</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">25.4</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">15</td> <td class="xl82" style="border-top: medium none; border-left: medium none;" align="right">76</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Matthew</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.45</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">25.2</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">23</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">15</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">80</td> <td class="xl70" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl72" style="height: 15pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="20">2</td> <td class="xl69" style="border-top: medium none; border-left: medium none;">Sammy</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">1.52</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">28.5</td> <td class="xl70" style="border-top: medium none; border-left: medium none;" align="right">36</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">14</td> <td class="xl80" style="border-top: medium none; border-left: medium none;" align="right">84</td> <td class="xl70" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl71" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl76" style="height: 15.75pt; font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow;" align="right" height="21">2</td> <td class="xl77" style="font-size: 11pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);">Sam</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">1.55</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">27.6</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">9</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">14</td> <td class="xl80" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);" align="right">88</td> <td class="xl78" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> <td class="xl79" style="font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(229, 224, 236);"> </td> </tr> </tbody></table>