Hi There,
<link rel="File-List" href="file:///C:%5CUsers%5Cmcm%5CAppData%5CLocal%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:"MS Mincho"; panose-1:2 2 6 9 4 2 5 8 3 4; mso-font-alt:"ＭＳ 明朝"; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"\@MS Mincho"; panose-1:2 2 6 9 4 2 5 8 3 4; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"MS Mincho";} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> First of all apologies that this is rather a complicated question (even if the answer may be simple!)
<o
> </o>
I have an extremely large data set (>560,000 rows).
<o> </o>
The first column contains sample data, which I require to calculate the average of (every nth number of samples).
See example below.
The range for the average calculation is dependent on the data in the second column, that is marked by a 1 or a 2 every few rows (however this spacing is not constant).
<o> </o>
I require the row number where the 1 or 2 is in the second column to be the mid-point of the average calculation of the data in the first column (with no overlap). Therefore the range for average calculation changes. Because of the massive data set, I require a formula that I can just fill down to make this dynamic calculation.
<o> </o>
I would be most grateful to anyone who can help.
Thanks,
Mike
<o> </o>
e.g. highly simplified example!
the first average calculation would be rows (1:5)
second rows (6:8)
third (9:15)
<o> </o>
<table class="MsoNormalTable" style="width: 144pt; margin-left: 4.65pt; border-collapse: collapse;" width="192" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap"> <o></o>
</td> </tr> </tbody></table> <o> </o>
<link rel="File-List" href="file:///C:%5CUsers%5Cmcm%5CAppData%5CLocal%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:"MS Mincho"; panose-1:2 2 6 9 4 2 5 8 3 4; mso-font-alt:"ＭＳ 明朝"; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"\@MS Mincho"; panose-1:2 2 6 9 4 2 5 8 3 4; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"MS Mincho";} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> First of all apologies that this is rather a complicated question (even if the answer may be simple!)
<o
> </o>I have an extremely large data set (>560,000 rows).
<o
> </o>The first column contains sample data, which I require to calculate the average of (every nth number of samples).
See example below.
The range for the average calculation is dependent on the data in the second column, that is marked by a 1 or a 2 every few rows (however this spacing is not constant).
<o
> </o>I require the row number where the 1 or 2 is in the second column to be the mid-point of the average calculation of the data in the first column (with no overlap). Therefore the range for average calculation changes. Because of the massive data set, I require a formula that I can just fill down to make this dynamic calculation.
<o
> </o>I would be most grateful to anyone who can help.
Thanks,
Mike
<o
> </o>e.g. highly simplified example!
the first average calculation would be rows (1:5)
second rows (6:8)
third (9:15)
<o
> </o><table class="MsoNormalTable" style="width: 144pt; margin-left: 4.65pt; border-collapse: collapse;" width="192" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
Row<o></o>
></o>Data<o></o>
></o>Marker<o></o>
></o>1<o></o>
></o>0.492842<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
2<o></o>
></o>0.070835<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
3<o></o>
></o>0.377864<o></o>
></o>1<o></o>
></o>4<o></o>
></o>0.854413<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
5<o></o>
></o>0.68555<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
6<o></o>
></o>0.839349<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
7<o></o>
></o>0.509461<o></o>
></o>2<o></o>
></o>8<o></o>
></o>0.15362<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
9<o></o>
></o>0.893461<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
10<o></o>
></o>0.553331<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
11<o></o>
></o>0.764691<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
12<o></o>
></o>0.892556<o></o>
></o>1<o></o>
></o>13<o></o>
></o>0.621487<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
14<o></o>
></o>0.657257<o></o>
></o>></o></td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 5.4pt; width: 48pt; height: 12.75pt;" valign="bottom" width="64" nowrap="nowrap">
15<o></o>
></o>0.727103<o></o>
></o>></o></td> </tr> </tbody></table> <o
> </o>
