Greetings,
Back again looking for some help.... See sample spreadsheet below.... My data is organized in "Groups" of varying size. In column Q, I use the following code to rank the output illustrated in column P:
Sub aVBAcode()
Dim e As Range, q As Range
Application.ScreenUpdating = False
Set e = Range("A2")
Do While e.Row < Rows.Count
If e(2) = "" Then
Set q = e.Offset(, 15)
Set e = e.End(4)
Else
Set q = Range(e, e.End(4)).Offset(, 15)
Set e = e.End(4).End(4)
End If
q.Offset(, 1) = "=RANK(" & q.Address & "," & q.Address & ",1)"
Loop
Application.ScreenUpdating = True
End Sub
Next, I "call" a recorded macro to execute the formula shown in column R.... If possible, I would like to add code to include this process in the above "aVBAcode". Additionally and most importantly, I would like to also include a formula to classify all items (column R) in each group with this same letter grade (ie: Group grade) as shown below in the "finished" example:
RACE TEMPLATE
<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: 52px"><COL style="WIDTH: 37px"><COL style="WIDTH: 32px"><COL style="WIDTH: 46px"><COL style="WIDTH: 74px"><COL style="WIDTH: 27px"><COL style="WIDTH: 18px"><COL style="WIDTH: 40px"><COL style="WIDTH: 48px"><COL style="WIDTH: 63px"><COL style="WIDTH: 24px"><COL style="WIDTH: 58px"></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>K</TD><TD>P</TD><TD>Q</TD><TD>R</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.43</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">0.8</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">5.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3.25</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">6.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.94</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">8.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">11.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.09</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">20.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">72.1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">9.76</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.83</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">8.7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.26</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">5.3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.21</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.33</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">10.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6.5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.15</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">12.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">31.9</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">7.73</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; 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>P2</TD><TD>=IF(N2>0,(N2+O2)/2,"")</TD></TR><TR><TD>Q2</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R2</TD><TD>=IF(A2="","",IF(AND(B2>3.25,Q2=1),"A",IF(AND(B2>2.5,Q2=1),"B",IF(AND(B2>2,Q2=1),"C",IF(AND(B2<=2,Q2=1),"D","")))))</TD></TR><TR><TD>P3</TD><TD>=IF(N3>0,(N3+O3)/2,"")</TD></TR><TR><TD>Q3</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R3</TD><TD>=IF(A3="","",IF(AND(B3>3.25,Q3=1),"A",IF(AND(B3>2.5,Q3=1),"B",IF(AND(B3>2,Q3=1),"C",IF(AND(B3<=2,Q3=1),"D","")))))</TD></TR><TR><TD>P4</TD><TD>=IF(N4>0,(N4+O4)/2,"")</TD></TR><TR><TD>Q4</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R4</TD><TD>=IF(A4="","",IF(AND(B4>3.25,Q4=1),"A",IF(AND(B4>2.5,Q4=1),"B",IF(AND(B4>2,Q4=1),"C",IF(AND(B4<=2,Q4=1),"D","")))))</TD></TR><TR><TD>P5</TD><TD>=IF(N5>0,(N5+O5)/2,"")</TD></TR><TR><TD>Q5</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R5</TD><TD>=IF(A5="","",IF(AND(B5>3.25,Q5=1),"A",IF(AND(B5>2.5,Q5=1),"B",IF(AND(B5>2,Q5=1),"C",IF(AND(B5<=2,Q5=1),"D","")))))</TD></TR><TR><TD>P6</TD><TD>=IF(N6>0,(N6+O6)/2,"")</TD></TR><TR><TD>Q6</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R6</TD><TD>=IF(A6="","",IF(AND(B6>3.25,Q6=1),"A",IF(AND(B6>2.5,Q6=1),"B",IF(AND(B6>2,Q6=1),"C",IF(AND(B6<=2,Q6=1),"D","")))))</TD></TR><TR><TD>P7</TD><TD>=IF(N7>0,(N7+O7)/2,"")</TD></TR><TR><TD>Q7</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R7</TD><TD>=IF(A7="","",IF(AND(B7>3.25,Q7=1),"A",IF(AND(B7>2.5,Q7=1),"B",IF(AND(B7>2,Q7=1),"C",IF(AND(B7<=2,Q7=1),"D","")))))</TD></TR><TR><TD>B8</TD><TD>=SUM(B2:B7)</TD></TR><TR><TD>P8</TD><TD>=IF(N8>0,(N8+O8)/2,"")</TD></TR><TR><TD>R8</TD><TD>=IF(A8="","",IF(AND(B8>3.25,Q8=1),"A",IF(AND(B8>2.5,Q8=1),"B",IF(AND(B8>2,Q8=1),"C",IF(AND(B8<=2,Q8=1),"D","")))))</TD></TR><TR><TD>P9</TD><TD>=IF(N9>0,(N9+O9)/2,"")</TD></TR><TR><TD>Q9</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R9</TD><TD>=IF(A9="","",IF(AND(B9>3.25,Q9=1),"A",IF(AND(B9>2.5,Q9=1),"B",IF(AND(B9>2,Q9=1),"C",IF(AND(B9<=2,Q9=1),"D","")))))</TD></TR><TR><TD>P10</TD><TD>=IF(N10>0,(N10+O10)/2,"")</TD></TR><TR><TD>Q10</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R10</TD><TD>=IF(A10="","",IF(AND(B10>3.25,Q10=1),"A",IF(AND(B10>2.5,Q10=1),"B",IF(AND(B10>2,Q10=1),"C",IF(AND(B10<=2,Q10=1),"D","")))))</TD></TR><TR><TD>P11</TD><TD>=IF(N11>0,(N11+O11)/2,"")</TD></TR><TR><TD>Q11</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R11</TD><TD>=IF(A11="","",IF(AND(B11>3.25,Q11=1),"A",IF(AND(B11>2.5,Q11=1),"B",IF(AND(B11>2,Q11=1),"C",IF(AND(B11<=2,Q11=1),"D","")))))</TD></TR><TR><TD>P12</TD><TD>=IF(N12>0,(N12+O12)/2,"")</TD></TR><TR><TD>Q12</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R12</TD><TD>=IF(A12="","",IF(AND(B12>3.25,Q12=1),"A",IF(AND(B12>2.5,Q12=1),"B",IF(AND(B12>2,Q12=1),"C",IF(AND(B12<=2,Q12=1),"D","")))))</TD></TR><TR><TD>P13</TD><TD>=IF(N13>0,(N13+O13)/2,"")</TD></TR><TR><TD>Q13</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R13</TD><TD>=IF(A13="","",IF(AND(B13>3.25,Q13=1),"A",IF(AND(B13>2.5,Q13=1),"B",IF(AND(B13>2,Q13=1),"C",IF(AND(B13<=2,Q13=1),"D","")))))</TD></TR><TR><TD>P14</TD><TD>=IF(N14>0,(N14+O14)/2,"")</TD></TR><TR><TD>Q14</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R14</TD><TD>=IF(A14="","",IF(AND(B14>3.25,Q14=1),"A",IF(AND(B14>2.5,Q14=1),"B",IF(AND(B14>2,Q14=1),"C",IF(AND(B14<=2,Q14=1),"D","")))))</TD></TR><TR><TD>B15</TD><TD>=SUM(B9:B14)</TD></TR><TR><TD>P15</TD><TD>=IF(N15>0,(N15+O15)/2,"")</TD></TR><TR><TD>R15</TD><TD>=IF(A15="","",IF(AND(B15>3.25,Q15=1),"A",IF(AND(B15>2.5,Q15=1),"B",IF(AND(B15>2,Q15=1),"C",IF(AND(B15<=2,Q15=1),"D","")))))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
This is the "finished" example:
RACE TEMPLATE
<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: 52px"><COL style="WIDTH: 37px"><COL style="WIDTH: 32px"><COL style="WIDTH: 46px"><COL style="WIDTH: 74px"><COL style="WIDTH: 27px"><COL style="WIDTH: 18px"><COL style="WIDTH: 40px"><COL style="WIDTH: 48px"><COL style="WIDTH: 63px"><COL style="WIDTH: 24px"><COL style="WIDTH: 58px"></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>K</TD><TD>P</TD><TD>Q</TD><TD>R</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.43</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">0.8</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">5.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3.25</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">6.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.94</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">8.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">11.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.09</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">20.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">72.1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">9.76</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.83</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">8.7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.26</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">5.3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.21</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.33</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">10.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6.5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.15</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">12.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">31.9</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">7.73</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR></TBODY></TABLE>
Thanks in advance for any available help,
KWL
Back again looking for some help.... See sample spreadsheet below.... My data is organized in "Groups" of varying size. In column Q, I use the following code to rank the output illustrated in column P:
Sub aVBAcode()
Dim e As Range, q As Range
Application.ScreenUpdating = False
Set e = Range("A2")
Do While e.Row < Rows.Count
If e(2) = "" Then
Set q = e.Offset(, 15)
Set e = e.End(4)
Else
Set q = Range(e, e.End(4)).Offset(, 15)
Set e = e.End(4).End(4)
End If
q.Offset(, 1) = "=RANK(" & q.Address & "," & q.Address & ",1)"
Loop
Application.ScreenUpdating = True
End Sub
Next, I "call" a recorded macro to execute the formula shown in column R.... If possible, I would like to add code to include this process in the above "aVBAcode". Additionally and most importantly, I would like to also include a formula to classify all items (column R) in each group with this same letter grade (ie: Group grade) as shown below in the "finished" example:
RACE TEMPLATE
<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: 52px"><COL style="WIDTH: 37px"><COL style="WIDTH: 32px"><COL style="WIDTH: 46px"><COL style="WIDTH: 74px"><COL style="WIDTH: 27px"><COL style="WIDTH: 18px"><COL style="WIDTH: 40px"><COL style="WIDTH: 48px"><COL style="WIDTH: 63px"><COL style="WIDTH: 24px"><COL style="WIDTH: 58px"></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>K</TD><TD>P</TD><TD>Q</TD><TD>R</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.43</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">0.8</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">5.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3.25</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">6.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.94</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">8.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">11.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.09</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">20.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">72.1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">9.76</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.83</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">8.7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.26</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">5.3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.21</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.33</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">10.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6.5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.15</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">12.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">31.9</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">7.73</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; 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>P2</TD><TD>=IF(N2>0,(N2+O2)/2,"")</TD></TR><TR><TD>Q2</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R2</TD><TD>=IF(A2="","",IF(AND(B2>3.25,Q2=1),"A",IF(AND(B2>2.5,Q2=1),"B",IF(AND(B2>2,Q2=1),"C",IF(AND(B2<=2,Q2=1),"D","")))))</TD></TR><TR><TD>P3</TD><TD>=IF(N3>0,(N3+O3)/2,"")</TD></TR><TR><TD>Q3</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R3</TD><TD>=IF(A3="","",IF(AND(B3>3.25,Q3=1),"A",IF(AND(B3>2.5,Q3=1),"B",IF(AND(B3>2,Q3=1),"C",IF(AND(B3<=2,Q3=1),"D","")))))</TD></TR><TR><TD>P4</TD><TD>=IF(N4>0,(N4+O4)/2,"")</TD></TR><TR><TD>Q4</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R4</TD><TD>=IF(A4="","",IF(AND(B4>3.25,Q4=1),"A",IF(AND(B4>2.5,Q4=1),"B",IF(AND(B4>2,Q4=1),"C",IF(AND(B4<=2,Q4=1),"D","")))))</TD></TR><TR><TD>P5</TD><TD>=IF(N5>0,(N5+O5)/2,"")</TD></TR><TR><TD>Q5</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R5</TD><TD>=IF(A5="","",IF(AND(B5>3.25,Q5=1),"A",IF(AND(B5>2.5,Q5=1),"B",IF(AND(B5>2,Q5=1),"C",IF(AND(B5<=2,Q5=1),"D","")))))</TD></TR><TR><TD>P6</TD><TD>=IF(N6>0,(N6+O6)/2,"")</TD></TR><TR><TD>Q6</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R6</TD><TD>=IF(A6="","",IF(AND(B6>3.25,Q6=1),"A",IF(AND(B6>2.5,Q6=1),"B",IF(AND(B6>2,Q6=1),"C",IF(AND(B6<=2,Q6=1),"D","")))))</TD></TR><TR><TD>P7</TD><TD>=IF(N7>0,(N7+O7)/2,"")</TD></TR><TR><TD>Q7</TD><TD>=RANK($P$2:$P$7,$P$2:$P$7,1)</TD></TR><TR><TD>R7</TD><TD>=IF(A7="","",IF(AND(B7>3.25,Q7=1),"A",IF(AND(B7>2.5,Q7=1),"B",IF(AND(B7>2,Q7=1),"C",IF(AND(B7<=2,Q7=1),"D","")))))</TD></TR><TR><TD>B8</TD><TD>=SUM(B2:B7)</TD></TR><TR><TD>P8</TD><TD>=IF(N8>0,(N8+O8)/2,"")</TD></TR><TR><TD>R8</TD><TD>=IF(A8="","",IF(AND(B8>3.25,Q8=1),"A",IF(AND(B8>2.5,Q8=1),"B",IF(AND(B8>2,Q8=1),"C",IF(AND(B8<=2,Q8=1),"D","")))))</TD></TR><TR><TD>P9</TD><TD>=IF(N9>0,(N9+O9)/2,"")</TD></TR><TR><TD>Q9</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R9</TD><TD>=IF(A9="","",IF(AND(B9>3.25,Q9=1),"A",IF(AND(B9>2.5,Q9=1),"B",IF(AND(B9>2,Q9=1),"C",IF(AND(B9<=2,Q9=1),"D","")))))</TD></TR><TR><TD>P10</TD><TD>=IF(N10>0,(N10+O10)/2,"")</TD></TR><TR><TD>Q10</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R10</TD><TD>=IF(A10="","",IF(AND(B10>3.25,Q10=1),"A",IF(AND(B10>2.5,Q10=1),"B",IF(AND(B10>2,Q10=1),"C",IF(AND(B10<=2,Q10=1),"D","")))))</TD></TR><TR><TD>P11</TD><TD>=IF(N11>0,(N11+O11)/2,"")</TD></TR><TR><TD>Q11</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R11</TD><TD>=IF(A11="","",IF(AND(B11>3.25,Q11=1),"A",IF(AND(B11>2.5,Q11=1),"B",IF(AND(B11>2,Q11=1),"C",IF(AND(B11<=2,Q11=1),"D","")))))</TD></TR><TR><TD>P12</TD><TD>=IF(N12>0,(N12+O12)/2,"")</TD></TR><TR><TD>Q12</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R12</TD><TD>=IF(A12="","",IF(AND(B12>3.25,Q12=1),"A",IF(AND(B12>2.5,Q12=1),"B",IF(AND(B12>2,Q12=1),"C",IF(AND(B12<=2,Q12=1),"D","")))))</TD></TR><TR><TD>P13</TD><TD>=IF(N13>0,(N13+O13)/2,"")</TD></TR><TR><TD>Q13</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R13</TD><TD>=IF(A13="","",IF(AND(B13>3.25,Q13=1),"A",IF(AND(B13>2.5,Q13=1),"B",IF(AND(B13>2,Q13=1),"C",IF(AND(B13<=2,Q13=1),"D","")))))</TD></TR><TR><TD>P14</TD><TD>=IF(N14>0,(N14+O14)/2,"")</TD></TR><TR><TD>Q14</TD><TD>=RANK($P$9:$P$14,$P$9:$P$14,1)</TD></TR><TR><TD>R14</TD><TD>=IF(A14="","",IF(AND(B14>3.25,Q14=1),"A",IF(AND(B14>2.5,Q14=1),"B",IF(AND(B14>2,Q14=1),"C",IF(AND(B14<=2,Q14=1),"D","")))))</TD></TR><TR><TD>B15</TD><TD>=SUM(B9:B14)</TD></TR><TR><TD>P15</TD><TD>=IF(N15>0,(N15+O15)/2,"")</TD></TR><TR><TD>R15</TD><TD>=IF(A15="","",IF(AND(B15>3.25,Q15=1),"A",IF(AND(B15>2.5,Q15=1),"B",IF(AND(B15>2,Q15=1),"C",IF(AND(B15<=2,Q15=1),"D","")))))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
This is the "finished" example:
RACE TEMPLATE
<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: 52px"><COL style="WIDTH: 37px"><COL style="WIDTH: 32px"><COL style="WIDTH: 46px"><COL style="WIDTH: 74px"><COL style="WIDTH: 27px"><COL style="WIDTH: 18px"><COL style="WIDTH: 40px"><COL style="WIDTH: 48px"><COL style="WIDTH: 63px"><COL style="WIDTH: 24px"><COL style="WIDTH: 58px"></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>K</TD><TD>P</TD><TD>Q</TD><TD>R</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.43</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">0.8</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">4.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">5.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">3.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3.25</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">6.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">4.2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.94</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">8.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">11.0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">AQU1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.09</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$37</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C30</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">6</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">20.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">72.1</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">D</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">9.76</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.95</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff00; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.83</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">2.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">8.7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #8db4e3; FONT-SIZE: 9pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.26</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">5.3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #fac090; FONT-SIZE: 9pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">2.21</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">3.5</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">2.4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #00b050; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 42px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">1.33</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">10.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">6.5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #a5a5a5; FONT-SIZE: 9pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-WEIGHT: bold">TAM1</TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">0.15</TD><TD style="TEXT-ALIGN: center; COLOR: #993300; FONT-SIZE: 8pt">11:25</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">$15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">4up C16</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">5.5</TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold">12.0</TD><TD style="TEXT-ALIGN: center; COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold">31.9</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt">C</TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="COLOR: #993300; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; FONT-STYLE: italic; COLOR: #333333; FONT-SIZE: 9pt; FONT-WEIGHT: bold">7.73</TD><TD style="COLOR: #993300; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #993300; FONT-SIZE: 11pt; FONT-WEIGHT: bold"></TD><TD style="FONT-STYLE: italic; FONT-SIZE: 16pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; COLOR: #666699; FONT-SIZE: 14pt; FONT-WEIGHT: bold"></TD><TD style="COLOR: #0066cc; FONT-SIZE: 12pt; FONT-WEIGHT: bold"></TD><TD style="FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Bodoni MT Black; FONT-SIZE: 14pt"></TD></TR></TBODY></TABLE>
Thanks in advance for any available help,
KWL
