Automatic sort data on entry by Grade

C

confusedjo

New Member
Joined
Aug 16, 2011
Messages
28
Hi, I have the following table and wish to have the data automically sort on entry so that all the A grades are at the top, followed by all B grades, then C grades, then D grade
Shooter No = Col B, Name = Col C Grade = Col E, Scoring Cols = G-N total = Col O
This worksheet data comes from a seperate worksheet using the = formula

<TABLE style="WIDTH: 566pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=751><COLGROUP><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1184" width=37><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5088" width=159><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312" width=41><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1184" width=37><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" span=3 width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1696" width=53><TBODY><TR style="HEIGHT: 39pt; mso-height-source: userset" height=52><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d9d9d9; WIDTH: 28pt; HEIGHT: 39pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl67 height=52 width=37>Shooter No</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: #d9d9d9; WIDTH: 119pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl68 width=159>NAME</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: #d9d9d9; WIDTH: 31pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl97 width=41>GRADE</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: #d9d9d9; WIDTH: 28pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl96 width=37>SPEC GRADE</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl67 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl70 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: gray 0.5pt solid" class=xl72 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl71 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl73 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl74 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl75 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d9d9d9; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #f0f0f0" class=xl73 width=53>SCORE 50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 40pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl95 width=53>TOTAL </TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl65 height=22 width=37>1</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl76 width=159>Henry</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl88>C</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl77 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>23</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>23</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>2</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>bob</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>D</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>24</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>55</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>3</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Bruce</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>37</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>68</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>4</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Steven</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>33</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>64</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>5</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Ben</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>37</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>37</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>6</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Murray </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>27</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>27</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>7</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Jason </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>34</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>35</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>100</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>8</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Mark </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>44</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl98 width=53>45</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>89</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>9</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Andrew </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>23</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>23</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>10</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Claire</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>22</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>17</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>39</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>11</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Darryl </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>43</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>35</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>36</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>114</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>12</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Glenn </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>34</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>65</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>13</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Derek </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>30</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>36</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>34</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>100</TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>14</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Terry </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>32</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>33</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>32</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>97</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>15</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Bob </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>28</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>37</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>96</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>16</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Alex </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>25</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>34</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>25</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>84</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>17</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Zane </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>34</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>34</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>18</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Sarah</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>C</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>25</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>30</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>55</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>19</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Kelvin</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>32</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78>31</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>94</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>20</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Richard </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>27</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>29</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>56</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>21</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Geoff</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>33</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>39</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>72</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>22</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Simon</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>24</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>32</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>56</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>23</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>Marian</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>B</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>26</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53>23</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>49</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; HEIGHT: 16.5pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl66 height=22 width=37>24</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 119pt; BORDER-TOP: gray; BORDER-RIGHT: gray 0.5pt solid" class=xl82 width=159>David </TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl89>A</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 28pt; BORDER-TOP: gray; BORDER-RIGHT: #f0f0f0" class=xl83 width=37></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl91 width=53>39</TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; WIDTH: 40pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl92 width=53></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl78></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl80></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: gray 0.5pt solid" class=xl81></TD><TD style="BORDER-BOTTOM: gray 0.5pt solid; BORDER-LEFT: gray; BACKGROUND-COLOR: white; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 1pt solid" class=xl94>39</TD></TR></TBODY></TABLE>

Thanks for your time
 
Last edited:

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
Is this what you mean?
Sheet1


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD></TR><TR style="HEIGHT: 35px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">Shooter No</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">NAME</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">GRADE</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SPEC GRADE</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Arial Narrow">SCORE 50</TD><TD style="FONT-FAMILY: Arial Narrow; FONT-WEIGHT: bold">TOTAL </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">1</TD><TD style="FONT-FAMILY: Arial Narrow">Henry</TD><TD style="FONT-FAMILY: Arial Narrow">C</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">2</TD><TD style="FONT-FAMILY: Arial Narrow">bob</TD><TD style="FONT-FAMILY: Arial Narrow">D</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">24</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">55</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">3</TD><TD style="FONT-FAMILY: Arial Narrow">Bruce</TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">37</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">68</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">4</TD><TD style="FONT-FAMILY: Arial Narrow">Steven</TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">33</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">64</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">5</TD><TD style="FONT-FAMILY: Arial Narrow">Ben</TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">37</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">37</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">6</TD><TD style="FONT-FAMILY: Arial Narrow">Murray </TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">27</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">27</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">7</TD><TD style="FONT-FAMILY: Arial Narrow">Jason </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">35</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">100</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">8</TD><TD style="FONT-FAMILY: Arial Narrow">Mark </TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">44</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">45</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">89</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">9</TD><TD style="FONT-FAMILY: Arial Narrow">Andrew </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">10</TD><TD style="FONT-FAMILY: Arial Narrow">Claire</TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">22</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">17</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">39</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">11</TD><TD style="FONT-FAMILY: Arial Narrow">Darryl </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">43</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">35</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">36</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">114</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">12</TD><TD style="FONT-FAMILY: Arial Narrow">Glenn </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">65</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">13</TD><TD style="FONT-FAMILY: Arial Narrow">Derek </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">36</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">100</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">14</TD><TD style="FONT-FAMILY: Arial Narrow">Terry </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">32</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">33</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">32</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">97</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">15</TD><TD style="FONT-FAMILY: Arial Narrow">Bob </TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">28</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">37</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">96</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">16</TD><TD style="FONT-FAMILY: Arial Narrow">Alex </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">25</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">25</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">84</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">17</TD><TD style="FONT-FAMILY: Arial Narrow">Zane </TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">34</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">18</TD><TD style="FONT-FAMILY: Arial Narrow">Sarah</TD><TD style="FONT-FAMILY: Arial Narrow">C</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">25</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">30</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">55</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">19</TD><TD style="FONT-FAMILY: Arial Narrow">Kelvin</TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">32</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">31</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">94</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">20</TD><TD style="FONT-FAMILY: Arial Narrow">Richard </TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">27</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">29</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">56</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">21</TD><TD style="FONT-FAMILY: Arial Narrow">Geoff</TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">33</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">39</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">72</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">22</TD><TD style="FONT-FAMILY: Arial Narrow">Simon</TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">24</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">32</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">56</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD><TD style="FONT-FAMILY: Arial Narrow">Marian</TD><TD style="FONT-FAMILY: Arial Narrow">B</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">26</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">23</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">49</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">24</TD><TD style="FONT-FAMILY: Arial Narrow">David </TD><TD style="FONT-FAMILY: Arial Narrow">A</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">39</TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="FONT-FAMILY: Verdana"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial Narrow">39</TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>N2</TD><TD>=SUM(F2:M2)</TD></TR><TR><TD>N3</TD><TD>=SUM(F3:M3)</TD></TR><TR><TD>N4</TD><TD>=SUM(F4:M4)</TD></TR><TR><TD>N5</TD><TD>=SUM(F5:M5)</TD></TR><TR><TD>N6</TD><TD>=SUM(F6:M6)</TD></TR><TR><TD>N7</TD><TD>=SUM(F7:M7)</TD></TR><TR><TD>N8</TD><TD>=SUM(F8:M8)</TD></TR><TR><TD>N9</TD><TD>=SUM(F9:M9)</TD></TR><TR><TD>N10</TD><TD>=SUM(F10:M10)</TD></TR><TR><TD>N11</TD><TD>=SUM(F11:M11)</TD></TR><TR><TD>N12</TD><TD>=SUM(F12:M12)</TD></TR><TR><TD>N13</TD><TD>=SUM(F13:M13)</TD></TR><TR><TD>N14</TD><TD>=SUM(F14:M14)</TD></TR><TR><TD>N15</TD><TD>=SUM(F15:M15)</TD></TR><TR><TD>N16</TD><TD>=SUM(F16:M16)</TD></TR><TR><TD>N17</TD><TD>=SUM(F17:M17)</TD></TR><TR><TD>N18</TD><TD>=SUM(F18:M18)</TD></TR><TR><TD>N19</TD><TD>=SUM(F19:M19)</TD></TR><TR><TD>N20</TD><TD>=SUM(F20:M20)</TD></TR><TR><TD>N21</TD><TD>=SUM(F21:M21)</TD></TR><TR><TD>N22</TD><TD>=SUM(F22:M22)</TD></TR><TR><TD>N23</TD><TD>=SUM(F23:M23)</TD></TR><TR><TD>N24</TD><TD>=SUM(F24:M24)</TD></TR><TR><TD>N25</TD><TD>=SUM(F25:M25)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4


Then this code in the worksheet module for Sheet1
Code: 
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim isect As Range
    Dim LastRow As Long
    LastRow = Range("B" & Rows.Count).End(xlUp).Row
    If LastRow = 1 Then Exit Sub
    If Target.Cells.Count > 1 Then Exit Sub
    Set isect = Intersect(Target, Range("F2:M" & LastRow))
    If Not isect Is Nothing Then
        Range("B2:N" & LastRow).Sort key1:=Range("D2"), Order1:=xlAscending, _
                                     key2:=Range("N2"), Order2:=xlDescending
    End If
End Sub


Enter or edit the scores in Columns E:M the data should sort as you go.
 
Upvote 0
Sorry, I really didnt explain myself very well
I am currently pulling this data from worksheet "event" usinf the = forumla, trying to work out that easy way to copy data (left that in another post).
So currently when data is entered into "event sheet" it copies to "sheet1" using =event!$E3 (example). I have tried the code you supplied but not having much luck. Any idea's would be great
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
624
smozgur
smozgur
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
921
epactheactor
E

Forum statistics

Threads
1,224,609
Messages
6,179,882
Members
452,948
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top