Help with averages!

S

sarah_l92

New Member
Joined
Sep 26, 2013
Messages
2
Hello, I have a list of numbers in the one column like so:

[TABLE="width: 48"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.21[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.29[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.32[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.29[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.18[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.29[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.21[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.29[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.31[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.31[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.92[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.96[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.92[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.83[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.84[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.83[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.84[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.93[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.54[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.09[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.17[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.17[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.09[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.07[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.36[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.37[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.36[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.35[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.99[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.81[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.78[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.83[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.85[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.84[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.78[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.73[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.74[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.81[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.84[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.81[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.78[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.74[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.74[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.18[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.34[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.32[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.21[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.21[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.19[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.21[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.27[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.31[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.24[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.18[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.31[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.28[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.25[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.26[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.17[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.41[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.38[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.66[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.63[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.64[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.63[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.63[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.66[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.64[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.66[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.64[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.66[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.63[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.62[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.65[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.63[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.58[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.59[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.54[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.61[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.54[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.39[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.55[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.46[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.52[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.51[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.42[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.53[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.43[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.47[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.54[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.57[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.48[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.97[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.08[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.97[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.86[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.98[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.94[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.04[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.76[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.96[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.93[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.01[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.01[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.82[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.95[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.98[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.98[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.95[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.93[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.92[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.93[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.01[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.04[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.01[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.02[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.09[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.91[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.96[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.03[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.03[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.07[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.97[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.88[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.94[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.92[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.06[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.89[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.84[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.79[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.77[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.97[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.94[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9.87[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10.01[/TD]
[/TR]
</TBODY>[/TABLE]
how can I find the average of each of the set of numbers when theres a gap? Is there a formula i can enter that will calculate the average of the first set of numbers before the blank cells and then a second average will be calculated from the first set of blank cells to the second and so forth?

thanks for any help x
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
assuming your first data element is in cell A2 then:

in cell B2 enter: =IF(A2 <> "",IF(B1="",0,B1)+A2,IF(C1 <> 0,B1/C1,""))
in cell C2 enter: =IF(A2<>"",C1+1,0)

Then copy those 2 cells down the list of data. At the first cell to the right of the blank in you column will be the that segments average.

Hope this makes sense.

Peter
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Help!
Replies
3
Views
2K
63falcondude
63falcondude
R
  • Question Question
lookup on calculated value not exact in list
Replies
5
Views
919
starkc69
S
S
  • Question Question
Ranking numbers using an array?
2
Replies
11
Views
2K
Peter_SSs
Peter_SSs
S
  • Question Question
Vlookup, match, interpolation help reqd.
2
Replies
10
Views
3K
Sandeep Warrier
Sandeep Warrier

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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