mcpwayne2005
New Member
- Joined
- Jul 3, 2008
- Messages
- 6
Hi,
First I will mention I am using Excel 2007 on windows Vista, and I do not know a whole lot about excel and virtually nothing about VBA, but I am willing to learn.
First some back ground on what this is for...
I am in a fantasy drum corps league (for any of you who know what Drum corps is) and scoring works like this.
There are 8 captions (GE,GM,VP,VE,VG,MB,ME,MP) and together the 8 captions form the total score following this formula. GE+GM+((VP+VE+VG)/2)+((ME+MB+MP)/2)=Total score.
The fantasy part works by selecting 8 individual captions from different corps based on a point system that is attached. Now when selecting these 8 captions I have 120 points to do so. What I would like to do is be able to insert current scores for each corps and see what combination of captions will produce the highest score while using no more than 120 points.
below is the point layout for each corps and caption and a sample chart of scores.
I would like to be able to of course keep adding current scores and it provide the best combination for me. Also if possible to have it pick the best combo's using no more than 132 points as well while producing the highest score for another league I am in.
Thank you so much for any help you can give me.
Adam
This chart is the point value for each corps caption.
<table style="border-collapse: collapse; width: 484pt;" border="0" cellpadding="0" cellspacing="0" width="646"><col style="width: 100pt;" width="134"> <col style="width: 48pt;" span="8" width="64"> <tbody><tr style="height: 14.4pt;" height="19"> <td style="height: 14.4pt; width: 100pt;" height="19" width="134">
</td> <td style="width: 48pt;" width="64">GEV</td> <td style="width: 48pt;" width="64">GEM</td> <td style="width: 48pt;" width="64">VE</td> <td style="width: 48pt;" width="64">VP</td> <td style="width: 48pt;" width="64">VG</td> <td style="width: 48pt;" width="64">ME</td> <td style="width: 48pt;" width="64">MB</td> <td style="width: 48pt;" width="64">MP</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Devils</td> <td class="xl64">24</td> <td class="xl64">25</td> <td class="xl64">24</td> <td class="xl64">25</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">25</td> <td class="xl64">25</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Knights</td> <td class="xl64">18</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Stars</td> <td class="xl64">11</td> <td class="xl64">12</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">11</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">13</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Bluecoats</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">19</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">22</td> <td class="xl64">24</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Boston Crusaders</td> <td class="xl64">17</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Carolina Crown</td> <td class="xl64">20</td> <td class="xl64">21</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">24</td> <td class="xl64">19</td> <td class="xl64">19</td> <td class="xl64">21</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Colts</td> <td class="xl64">16</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">14</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">14</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Crossmen</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">13</td> <td class="xl64">11</td> <td class="xl64">9</td> <td class="xl64">11</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Glassmen</td> <td class="xl64">15</td> <td class="xl64">15</td> <td class="xl64">14</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">16</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Madison Scouts</td> <td class="xl64">12</td> <td class="xl64">11</td> <td class="xl64">11</td> <td class="xl64">11</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">11</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Mandarins</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">8</td> <td class="xl64">7</td> <td class="xl64">7</td> <td class="xl64">7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Pacific Crest</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">12</td> <td class="xl64">9</td> <td class="xl64">11</td> <td class="xl64">9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Phantom Regiment</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">24</td> <td class="xl64">23</td> <td class="xl64">23</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Pioneer</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">SC Vanguard</td> <td class="xl64">22</td> <td class="xl64">19</td> <td class="xl64">21</td> <td class="xl64">21</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">21</td> <td class="xl64">19</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Spirit from JSU</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">16</td> <td class="xl64">16</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">15</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Academy</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">12</td> <td class="xl64">12</td> <td class="xl64">9</td> <td class="xl64">12</td> <td class="xl64">12</td> <td class="xl64">13</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Cadets</td> <td class="xl64">25</td> <td class="xl64">24</td> <td class="xl64">23</td> <td class="xl64">24</td> <td class="xl64">22</td> <td class="xl64">23</td> <td class="xl64">24</td> <td class="xl64">22</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Cavaliers</td> <td class="xl64">23</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">20</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Troopers</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">7</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> </tr> </tbody></table>
This is a sample list of scores
<table style="border-collapse: collapse; width: 484pt;" border="0" cellpadding="0" cellspacing="0" width="646"><col style="width: 100pt;" width="134"> <col style="width: 48pt;" span="8" width="64"> <tbody><tr style="height: 14.4pt;" height="19"> <td style="height: 14.4pt; width: 100pt;" height="19" width="134">
</td> <td style="width: 48pt;" width="64">GEV</td> <td style="width: 48pt;" width="64">GEM</td> <td style="width: 48pt;" width="64">VE</td> <td style="width: 48pt;" width="64">VP</td> <td style="width: 48pt;" width="64">VG</td> <td style="width: 48pt;" width="64">ME</td> <td style="width: 48pt;" width="64">MB</td> <td style="width: 48pt;" width="64">MP</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Devils</td> <td class="xl65">16.4</td> <td class="xl65">16</td> <td class="xl66">15.5</td> <td class="xl65">16.6</td> <td class="xl66">15.5</td> <td class="xl65">16.2</td> <td class="xl65">15.9</td> <td class="xl66">16.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Knights</td> <td class="xl65">13.4</td> <td class="xl65">14.9</td> <td class="xl66">13.4</td> <td class="xl65">14.9</td> <td class="xl65">15</td> <td class="xl65">15.3</td> <td class="xl65">14.7</td> <td class="xl65">15.4</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Stars</td> <td class="xl65">13.6</td> <td class="xl65">13.8</td> <td class="xl66">13.7</td> <td class="xl65">15</td> <td class="xl66">13.2</td> <td class="xl65">14.4</td> <td class="xl65">14.7</td> <td class="xl65">14.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">BlueCoats</td> <td class="xl65">14.7</td> <td class="xl65">14.5</td> <td class="xl66">15</td> <td class="xl65">15.5</td> <td class="xl66">14.4</td> <td class="xl65">15.3</td> <td class="xl65">14.7</td> <td class="xl65">15.4</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Boston Crusaders</td> <td class="xl65">12.4</td> <td class="xl65">14.8</td> <td class="xl66">14</td> <td class="xl65">14.1</td> <td class="xl66">14.7</td> <td class="xl65">15.5</td> <td class="xl65">14.9</td> <td class="xl65">14.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Carolina Crown</td> <td class="xl65">14.8</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl65">15.2</td> <td class="xl66">15.2</td> <td class="xl65">15</td> <td class="xl65">15.8</td> <td class="xl65">15.6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Colts </td> <td class="xl65">15</td> <td class="xl65">14.4</td> <td class="xl66">14.6</td> <td class="xl65">14.9</td> <td class="xl66">14.1</td> <td class="xl65">14.5</td> <td class="xl65">14.7</td> <td class="xl65">14.7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Crossmen</td> <td class="xl65">12.7</td> <td class="xl65">13.7</td> <td class="xl65">15</td> <td class="xl65">12.5</td> <td class="xl66">13.7</td> <td class="xl65">14.3</td> <td class="xl65">12.9</td> <td class="xl65">13.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Glassmen</td> <td class="xl65">13.8</td> <td class="xl65">14.3</td> <td class="xl66">14.4</td> <td class="xl65">14.6</td> <td class="xl66">14.3</td> <td class="xl65">13.7</td> <td class="xl65">12.6</td> <td class="xl65">14.7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Madison Scouts</td> <td class="xl65">12.3</td> <td class="xl65">14.1</td> <td class="xl66">12.9</td> <td class="xl65">13.9</td> <td class="xl66">14</td> <td class="xl65">14</td> <td class="xl65">14.1</td> <td class="xl65">14</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Mandarins</td> <td class="xl65">13.4</td> <td class="xl65">12.8</td> <td class="xl66">11.7</td> <td class="xl65">11.8</td> <td class="xl66">11.7</td> <td class="xl65">13.3</td> <td class="xl65">11.4</td> <td class="xl65">11.6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Pacific Crest</td> <td class="xl65">14.2</td> <td class="xl65">13.9</td> <td class="xl66">13.5</td> <td class="xl65">12.8</td> <td class="xl66">12.8</td> <td class="xl65">14.3</td> <td class="xl65">13.9</td> <td class="xl65">13.5</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Phantom Regiment</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl66">15.3</td> <td class="xl65">15.7</td> <td class="xl66">15.1</td> <td class="xl65">15.1</td> <td class="xl65">15.3</td> <td class="xl65">15.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Pioneer</td> <td class="xl65">11.2</td> <td class="xl65">13.5</td> <td class="xl66">13.2</td> <td class="xl65">13.1</td> <td class="xl66">12.4</td> <td class="xl65">12.6</td> <td class="xl65">12</td> <td class="xl65">13.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Santa Clara Vanguard</td> <td class="xl65">15.8</td> <td class="xl65">15.5</td> <td class="xl66">15.9</td> <td class="xl65">15.9</td> <td class="xl66">15.3</td> <td class="xl65">15.7</td> <td class="xl65">14.8</td> <td class="xl65">15.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Spirit</td> <td class="xl65">12.9</td> <td class="xl65">14</td> <td class="xl66">14</td> <td class="xl65">14.3</td> <td class="xl65">15</td> <td class="xl65">14.3</td> <td class="xl65">13.2</td> <td class="xl65">14.5</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Academy</td> <td class="xl65">12.9</td> <td class="xl65">13.9</td> <td class="xl66">13.7</td> <td class="xl65">14.4</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl65">13.5</td> <td class="xl65">14.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Cadets</td> <td class="xl65">15.7</td> <td class="xl65">16.3</td> <td class="xl66">16.4</td> <td class="xl65">16.6</td> <td class="xl66">16.3</td> <td class="xl65">15.8</td> <td class="xl65">16.1</td> <td class="xl65">16.2</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Cavaliers</td> <td class="xl65">16</td> <td class="xl65">14.6</td> <td class="xl66">16</td> <td class="xl65">16.3</td> <td class="xl66">15.9</td> <td class="xl65">15.9</td> <td class="xl65">15.6</td> <td class="xl65">16.2</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl67" style="height: 14.4pt;" height="19">Troopers</td> <td class="xl65">13.1</td> <td class="xl65">15</td> <td class="xl66">13.2</td> <td class="xl65">13.5</td> <td class="xl65">14.3</td> <td class="xl65">13</td> <td class="xl65">13.5</td> <td class="xl65">13.9</td> </tr> </tbody></table>
First I will mention I am using Excel 2007 on windows Vista, and I do not know a whole lot about excel and virtually nothing about VBA, but I am willing to learn.
First some back ground on what this is for...
I am in a fantasy drum corps league (for any of you who know what Drum corps is) and scoring works like this.
There are 8 captions (GE,GM,VP,VE,VG,MB,ME,MP) and together the 8 captions form the total score following this formula. GE+GM+((VP+VE+VG)/2)+((ME+MB+MP)/2)=Total score.
The fantasy part works by selecting 8 individual captions from different corps based on a point system that is attached. Now when selecting these 8 captions I have 120 points to do so. What I would like to do is be able to insert current scores for each corps and see what combination of captions will produce the highest score while using no more than 120 points.
below is the point layout for each corps and caption and a sample chart of scores.
I would like to be able to of course keep adding current scores and it provide the best combination for me. Also if possible to have it pick the best combo's using no more than 132 points as well while producing the highest score for another league I am in.
Thank you so much for any help you can give me.
Adam
This chart is the point value for each corps caption.
<table style="border-collapse: collapse; width: 484pt;" border="0" cellpadding="0" cellspacing="0" width="646"><col style="width: 100pt;" width="134"> <col style="width: 48pt;" span="8" width="64"> <tbody><tr style="height: 14.4pt;" height="19"> <td style="height: 14.4pt; width: 100pt;" height="19" width="134">
</td> <td style="width: 48pt;" width="64">GEV</td> <td style="width: 48pt;" width="64">GEM</td> <td style="width: 48pt;" width="64">VE</td> <td style="width: 48pt;" width="64">VP</td> <td style="width: 48pt;" width="64">VG</td> <td style="width: 48pt;" width="64">ME</td> <td style="width: 48pt;" width="64">MB</td> <td style="width: 48pt;" width="64">MP</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Devils</td> <td class="xl64">24</td> <td class="xl64">25</td> <td class="xl64">24</td> <td class="xl64">25</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">25</td> <td class="xl64">25</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Knights</td> <td class="xl64">18</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Blue Stars</td> <td class="xl64">11</td> <td class="xl64">12</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">11</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">13</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Bluecoats</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">19</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">22</td> <td class="xl64">24</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Boston Crusaders</td> <td class="xl64">17</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">17</td> <td class="xl64">18</td> <td class="xl64">17</td> <td class="xl64">18</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Carolina Crown</td> <td class="xl64">20</td> <td class="xl64">21</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">24</td> <td class="xl64">19</td> <td class="xl64">19</td> <td class="xl64">21</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Colts</td> <td class="xl64">16</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">14</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">14</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Crossmen</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">13</td> <td class="xl64">11</td> <td class="xl64">9</td> <td class="xl64">11</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Glassmen</td> <td class="xl64">15</td> <td class="xl64">15</td> <td class="xl64">14</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">15</td> <td class="xl64">16</td> <td class="xl64">16</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Madison Scouts</td> <td class="xl64">12</td> <td class="xl64">11</td> <td class="xl64">11</td> <td class="xl64">11</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">10</td> <td class="xl64">11</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Mandarins</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">8</td> <td class="xl64">7</td> <td class="xl64">7</td> <td class="xl64">7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Pacific Crest</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">9</td> <td class="xl64">12</td> <td class="xl64">9</td> <td class="xl64">11</td> <td class="xl64">9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Phantom Regiment</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">19</td> <td class="xl64">22</td> <td class="xl64">20</td> <td class="xl64">24</td> <td class="xl64">23</td> <td class="xl64">23</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Pioneer</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">7</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> <td class="xl64">6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">SC Vanguard</td> <td class="xl64">22</td> <td class="xl64">19</td> <td class="xl64">21</td> <td class="xl64">21</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">21</td> <td class="xl64">19</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Spirit from JSU</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">16</td> <td class="xl64">16</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">14</td> <td class="xl64">15</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Academy</td> <td class="xl64">13</td> <td class="xl64">13</td> <td class="xl64">12</td> <td class="xl64">12</td> <td class="xl64">9</td> <td class="xl64">12</td> <td class="xl64">12</td> <td class="xl64">13</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Cadets</td> <td class="xl64">25</td> <td class="xl64">24</td> <td class="xl64">23</td> <td class="xl64">24</td> <td class="xl64">22</td> <td class="xl64">23</td> <td class="xl64">24</td> <td class="xl64">22</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">The Cavaliers</td> <td class="xl64">23</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">23</td> <td class="xl64">25</td> <td class="xl64">21</td> <td class="xl64">20</td> <td class="xl64">20</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl63" style="height: 14.4pt;" height="19">Troopers</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">7</td> <td class="xl64">8</td> <td class="xl64">8</td> <td class="xl64">8</td> </tr> </tbody></table>
This is a sample list of scores
<table style="border-collapse: collapse; width: 484pt;" border="0" cellpadding="0" cellspacing="0" width="646"><col style="width: 100pt;" width="134"> <col style="width: 48pt;" span="8" width="64"> <tbody><tr style="height: 14.4pt;" height="19"> <td style="height: 14.4pt; width: 100pt;" height="19" width="134">
</td> <td style="width: 48pt;" width="64">GEV</td> <td style="width: 48pt;" width="64">GEM</td> <td style="width: 48pt;" width="64">VE</td> <td style="width: 48pt;" width="64">VP</td> <td style="width: 48pt;" width="64">VG</td> <td style="width: 48pt;" width="64">ME</td> <td style="width: 48pt;" width="64">MB</td> <td style="width: 48pt;" width="64">MP</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Devils</td> <td class="xl65">16.4</td> <td class="xl65">16</td> <td class="xl66">15.5</td> <td class="xl65">16.6</td> <td class="xl66">15.5</td> <td class="xl65">16.2</td> <td class="xl65">15.9</td> <td class="xl66">16.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Knights</td> <td class="xl65">13.4</td> <td class="xl65">14.9</td> <td class="xl66">13.4</td> <td class="xl65">14.9</td> <td class="xl65">15</td> <td class="xl65">15.3</td> <td class="xl65">14.7</td> <td class="xl65">15.4</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Blue Stars</td> <td class="xl65">13.6</td> <td class="xl65">13.8</td> <td class="xl66">13.7</td> <td class="xl65">15</td> <td class="xl66">13.2</td> <td class="xl65">14.4</td> <td class="xl65">14.7</td> <td class="xl65">14.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">BlueCoats</td> <td class="xl65">14.7</td> <td class="xl65">14.5</td> <td class="xl66">15</td> <td class="xl65">15.5</td> <td class="xl66">14.4</td> <td class="xl65">15.3</td> <td class="xl65">14.7</td> <td class="xl65">15.4</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Boston Crusaders</td> <td class="xl65">12.4</td> <td class="xl65">14.8</td> <td class="xl66">14</td> <td class="xl65">14.1</td> <td class="xl66">14.7</td> <td class="xl65">15.5</td> <td class="xl65">14.9</td> <td class="xl65">14.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Carolina Crown</td> <td class="xl65">14.8</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl65">15.2</td> <td class="xl66">15.2</td> <td class="xl65">15</td> <td class="xl65">15.8</td> <td class="xl65">15.6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Colts </td> <td class="xl65">15</td> <td class="xl65">14.4</td> <td class="xl66">14.6</td> <td class="xl65">14.9</td> <td class="xl66">14.1</td> <td class="xl65">14.5</td> <td class="xl65">14.7</td> <td class="xl65">14.7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Crossmen</td> <td class="xl65">12.7</td> <td class="xl65">13.7</td> <td class="xl65">15</td> <td class="xl65">12.5</td> <td class="xl66">13.7</td> <td class="xl65">14.3</td> <td class="xl65">12.9</td> <td class="xl65">13.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Glassmen</td> <td class="xl65">13.8</td> <td class="xl65">14.3</td> <td class="xl66">14.4</td> <td class="xl65">14.6</td> <td class="xl66">14.3</td> <td class="xl65">13.7</td> <td class="xl65">12.6</td> <td class="xl65">14.7</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Madison Scouts</td> <td class="xl65">12.3</td> <td class="xl65">14.1</td> <td class="xl66">12.9</td> <td class="xl65">13.9</td> <td class="xl66">14</td> <td class="xl65">14</td> <td class="xl65">14.1</td> <td class="xl65">14</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Mandarins</td> <td class="xl65">13.4</td> <td class="xl65">12.8</td> <td class="xl66">11.7</td> <td class="xl65">11.8</td> <td class="xl66">11.7</td> <td class="xl65">13.3</td> <td class="xl65">11.4</td> <td class="xl65">11.6</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Pacific Crest</td> <td class="xl65">14.2</td> <td class="xl65">13.9</td> <td class="xl66">13.5</td> <td class="xl65">12.8</td> <td class="xl66">12.8</td> <td class="xl65">14.3</td> <td class="xl65">13.9</td> <td class="xl65">13.5</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Phantom Regiment</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl66">15.3</td> <td class="xl65">15.7</td> <td class="xl66">15.1</td> <td class="xl65">15.1</td> <td class="xl65">15.3</td> <td class="xl65">15.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Pioneer</td> <td class="xl65">11.2</td> <td class="xl65">13.5</td> <td class="xl66">13.2</td> <td class="xl65">13.1</td> <td class="xl66">12.4</td> <td class="xl65">12.6</td> <td class="xl65">12</td> <td class="xl65">13.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Santa Clara Vanguard</td> <td class="xl65">15.8</td> <td class="xl65">15.5</td> <td class="xl66">15.9</td> <td class="xl65">15.9</td> <td class="xl66">15.3</td> <td class="xl65">15.7</td> <td class="xl65">14.8</td> <td class="xl65">15.9</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">Spirit</td> <td class="xl65">12.9</td> <td class="xl65">14</td> <td class="xl66">14</td> <td class="xl65">14.3</td> <td class="xl65">15</td> <td class="xl65">14.3</td> <td class="xl65">13.2</td> <td class="xl65">14.5</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Academy</td> <td class="xl65">12.9</td> <td class="xl65">13.9</td> <td class="xl66">13.7</td> <td class="xl65">14.4</td> <td class="xl65">15</td> <td class="xl65">15</td> <td class="xl65">13.5</td> <td class="xl65">14.3</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Cadets</td> <td class="xl65">15.7</td> <td class="xl65">16.3</td> <td class="xl66">16.4</td> <td class="xl65">16.6</td> <td class="xl66">16.3</td> <td class="xl65">15.8</td> <td class="xl65">16.1</td> <td class="xl65">16.2</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl65" style="height: 14.4pt;" height="19">The Cavaliers</td> <td class="xl65">16</td> <td class="xl65">14.6</td> <td class="xl66">16</td> <td class="xl65">16.3</td> <td class="xl66">15.9</td> <td class="xl65">15.9</td> <td class="xl65">15.6</td> <td class="xl65">16.2</td> </tr> <tr style="height: 14.4pt;" height="19"> <td class="xl67" style="height: 14.4pt;" height="19">Troopers</td> <td class="xl65">13.1</td> <td class="xl65">15</td> <td class="xl66">13.2</td> <td class="xl65">13.5</td> <td class="xl65">14.3</td> <td class="xl65">13</td> <td class="xl65">13.5</td> <td class="xl65">13.9</td> </tr> </tbody></table>