Divide Numbers into Deciles

[Bobaree]

Column D contains decimal numbers which are the summation of 6 other columns. (The 6 other columns are percent rank calculations.) Does anyone know how to divide the numbers in column D into deciles and show the results in column C?

I found the information below which looks like it would do the trick, but I don't know how to incorporate it into my project. In addition to not knowing how to incorporate the code, I have reservations about using it since the results in column D are already percentranks. In other words, I'm not sure about applying the percentrank formula against those numbers that are already percentranks.

Can anyone help? I will be glad to post my current spreadsheet if that will help.


This is the information I found:
I have written a user defined function that will look down a range and calculate which decilerank for a number within the range sits.<o></o>
Copy the code to a module in your spreadsheet and call it as you normally would a function.<o></o>
' This User Defined Function can be called to calculate which Decile a single cell
' falls within a larger range of cells<o></o>
Function PERCENTILE_TO_DECILE(DataRange, RefCell)<o></o>
'DECILE_RANK(The Range of data you are interested in, The data cell that you want to know the decile of)
'Declares the function that can be called in the spreadsheet cell - enter '=DECILE_RANK(A5:A50,A5)'
'to use regularly paste it to your PERSONAL.xls workbook and reference it via =PERSONAL.XLS!decile_rank(A5:A50,A5)<o></o>

'Remove quote on line below if you want to Automatically update the function when the worksheet is recalculated
'Application.Volatile True<o></o>
'Using the percentile worksheet function calculate where the 10th, 20th etc percentile of the reference range are<o></o>
DEC1 = Application.WorksheetFunction.Percentile(DataRange, 0.1)
DEC2 = Application.WorksheetFunction.Percentile(DataRange, 0.2)
DEC3 = Application.WorksheetFunction.Percentile(DataRange, 0.3)
DEC4 = Application.WorksheetFunction.Percentile(DataRange, 0.4)
DEC5 = Application.WorksheetFunction.Percentile(DataRange, 0.5)
DEC6 = Application.WorksheetFunction.Percentile(DataRange, 0.6)
DEC7 = Application.WorksheetFunction.Percentile(DataRange, 0.7)
DEC8 = Application.WorksheetFunction.Percentile(DataRange, 0.8)
DEC9 = Application.WorksheetFunction.Percentile(DataRange, 0.9)<o></o>

' Calculate the Decile rank that the reference cell value sits within<o></o>
If (RefCell <= DEC1) Then DECILE_RANK = 1
If (RefCell > DEC1) And (RefCell <= DEC2) Then DECILE_RANK = 2
If (RefCell > DEC2) And (RefCell <= DEC3) Then DECILE_RANK = 3
If (RefCell > DEC3) And (RefCell <= DEC4) Then DECILE_RANK = 4
If (RefCell > DEC4) And (RefCell <= DEC5) Then DECILE_RANK = 5
If (RefCell > DEC5) And (RefCell <= DEC6) Then DECILE_RANK = 6
If (RefCell > DEC6) And (RefCell <= DEC7) Then DECILE_RANK = 7
If (RefCell > DEC7) And (RefCell <= DEC8) Then DECILE_RANK = 8
If (RefCell > DEC8) And (RefCell <= DEC9) Then DECILE_RANK = 9
If (RefCell > DEC9) Then DECILE_RANK = 10<o></o>

'If you want to check that there is an empty cell value in the 'Ref Cell" reference cell then remove the quotes from the 6 lines below<o></o>
'ErrorSum = 0
'If Len(RefCell) = 0 Then ErrorSum = ErrorSum + 1
'For Each Cell In DataRange
'If Len(Cell) = 0 Then ErrorSum = ErrorSum + 1
'Next
'If ErrorSum > 0 Then MsgBox ("There is an empty cell in the lookup ranges for the decile function")<o></o>
End Function<o></o>

 

[Andrew Poulsom]

What do you mean by "divide the numbers in column D into deciles" exactly?

 

[Bobaree]

If column D was 100 cells from the first number to the last, I would expect 10 groups of 10 numbers each. If 200 cells, I would expect 10 groups with 20 numbers each, etc. There would be some variation since the number of cells would not normally fall into increments of 10 (i.e. 163 cells, etc.) I'm glad to see you again; Thanks for your interest.

 

[Andrew Poulsom]

Can you post some sample data with the expected results please?

 

[Bobaree]

[TABLE="width: 1131"]
<COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6802" width=186><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=2 width=64><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=8 width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=6 width=64><COL style="WIDTH: 170pt; mso-width-source: userset; mso-width-alt: 8301" width=227><TBODY>[TR]
[TD="class: xl70, width: 186, bgcolor: #92d050"]Company[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]Ticker[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Decile[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Sum[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Yield[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Payout Ratio 12m[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Percentile P/Book[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Percentile P/EPS[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Percentile P/Sales[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Percentile EV/EBITDA[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Percentile P/CFPS[/TD]
[TD="class: xl68, width: 71, bgcolor: transparent"]Shareholder Yield[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Price/Book[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]P/EPS[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]P/Sales[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]EV/EBITDA[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]P/CFPS[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Shrhld Yld[/TD]
[TD="class: xl68, width: 227, bgcolor: transparent"]Industry[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]AbbVie Inc[/TD]
[TD="class: xl65, bgcolor: transparent"]ABBV[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.084[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]61.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.021[/TD]
[TD="class: xl69, bgcolor: transparent"]0.324[/TD]
[TD="class: xl69, bgcolor: transparent"]0.132[/TD]
[TD="class: xl69, bgcolor: transparent"]0.172[/TD]
[TD="class: xl69, bgcolor: transparent"]0.132[/TD]
[TD="class: xl69, bgcolor: transparent"]0.303[/TD]
[TD="class: xl69, bgcolor: transparent"]16.88[/TD]
[TD="class: xl69, bgcolor: transparent"]21.3[/TD]
[TD="class: xl69, bgcolor: transparent"]4.57[/TD]
[TD="class: xl69, bgcolor: transparent"]14.6[/TD]
[TD="class: xl69, bgcolor: transparent"]250.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.7[/TD]
[TD="class: xl65, bgcolor: transparent"]0803 - Biotechnology & Drugs[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Agilent Technologies Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]A[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.347[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl69, bgcolor: transparent"]24[/TD]
[TD="class: xl69, bgcolor: transparent"]0.405[/TD]
[TD="class: xl69, bgcolor: transparent"]0.081[/TD]
[TD="class: xl69, bgcolor: transparent"]0.314[/TD]
[TD="class: xl69, bgcolor: transparent"]0.203[/TD]
[TD="class: xl69, bgcolor: transparent"]0.102[/TD]
[TD="class: xl69, bgcolor: transparent"]0.242[/TD]
[TD="class: xl69, bgcolor: transparent"]3.41[/TD]
[TD="class: xl69, bgcolor: transparent"]28.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.79[/TD]
[TD="class: xl69, bgcolor: transparent"]14.1[/TD]
[TD="class: xl69, bgcolor: transparent"]288.2[/TD]
[TD="class: xl69, bgcolor: transparent"]2.4[/TD]
[TD="class: xl65, bgcolor: transparent"]1024 - Electronic Instruments & Controls[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Allstate Corporation, The[/TD]
[TD="class: xl65, bgcolor: transparent"]ALL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.667[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl69, bgcolor: transparent"]20.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.899[/TD]
[TD="class: xl69, bgcolor: transparent"]0.859[/TD]
[TD="class: xl69, bgcolor: transparent"]0.738[/TD]
[TD="class: xl69, bgcolor: transparent"]0.384[/TD]
[TD="class: xl69, bgcolor: transparent"]0.898[/TD]
[TD="class: xl69, bgcolor: transparent"]1.26[/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]0.76[/TD]
[TD="class: xl69, bgcolor: transparent"]7.8[/TD]
[TD="class: xl69, bgcolor: transparent"]117.7[/TD]
[TD="class: xl69, bgcolor: transparent"]9.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0715 - Insurance (Property & Casualty)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Aon PLC[/TD]
[TD="class: xl65, bgcolor: transparent"]AON[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.214[/TD]
[TD="class: xl69, bgcolor: transparent"]1.2[/TD]
[TD="class: xl69, bgcolor: transparent"]18.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.415[/TD]
[TD="class: xl69, bgcolor: transparent"]0.293[/TD]
[TD="class: xl69, bgcolor: transparent"]0.455[/TD]
[TD="class: xl69, bgcolor: transparent"]0.081[/TD]
[TD="class: xl69, bgcolor: transparent"]0.263[/TD]
[TD="class: xl69, bgcolor: transparent"]0.707[/TD]
[TD="class: xl69, bgcolor: transparent"]3.36[/TD]
[TD="class: xl69, bgcolor: transparent"]21.6[/TD]
[TD="class: xl69, bgcolor: transparent"]2.18[/TD]
[TD="class: xl69, bgcolor: transparent"]17.6[/TD]
[TD="class: xl69, bgcolor: transparent"]173.4[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl65, bgcolor: transparent"]0712 - Insurance (Miscellaneous)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Apache Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]APA[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.013[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]27.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.91[/TD]
[TD="class: xl69, bgcolor: transparent"]0.233[/TD]
[TD="class: xl69, bgcolor: transparent"]0.344[/TD]
[TD="class: xl69, bgcolor: transparent"]0.97[/TD]
[TD="class: xl69, bgcolor: transparent"]0.344[/TD]
[TD="class: xl69, bgcolor: transparent"]0.212[/TD]
[TD="class: xl69, bgcolor: transparent"]1.17[/TD]
[TD="class: xl69, bgcolor: transparent"]22.7[/TD]
[TD="class: xl69, bgcolor: transparent"]2.6[/TD]
[TD="class: xl69, bgcolor: transparent"]4.9[/TD]
[TD="class: xl69, bgcolor: transparent"]134.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl65, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Apple Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]AAPL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.619[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl69, bgcolor: transparent"]28.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.213[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.223[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.051[/TD]
[TD="class: xl69, bgcolor: transparent"]0.878[/TD]
[TD="class: xl69, bgcolor: transparent"]5.04[/TD]
[TD="class: xl69, bgcolor: transparent"]16.4[/TD]
[TD="class: xl69, bgcolor: transparent"]3.42[/TD]
[TD="class: xl69, bgcolor: transparent"]9.6[/TD]
[TD="class: xl69, bgcolor: transparent"]422.2[/TD]
[TD="class: xl69, bgcolor: transparent"]8.4[/TD]
[TD="class: xl65, bgcolor: transparent"]1003 - Communications Equipment[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Applied Materials, Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]AMAT[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.708[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl69, bgcolor: transparent"]55.6[/TD]
[TD="class: xl69, bgcolor: transparent"]0.364[/TD]
[TD="class: xl69, bgcolor: transparent"]0.061[/TD]
[TD="class: xl69, bgcolor: transparent"]0.283[/TD]
[TD="class: xl69, bgcolor: transparent"]0.192[/TD]
[TD="class: xl69, bgcolor: transparent"]0.768[/TD]
[TD="class: xl69, bgcolor: transparent"]0.04[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl69, bgcolor: transparent"]31.2[/TD]
[TD="class: xl69, bgcolor: transparent"]3.17[/TD]
[TD="class: xl69, bgcolor: transparent"]14.3[/TD]
[TD="class: xl69, bgcolor: transparent"]30.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.6[/TD]
[TD="class: xl65, bgcolor: transparent"]1033 - Semiconductors[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]AT&T Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]T[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]5.042[/TD]
[TD="class: xl69, bgcolor: transparent"]5.3[/TD]
[TD="class: xl69, bgcolor: transparent"]53.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.728[/TD]
[TD="class: xl69, bgcolor: transparent"]0.97[/TD]
[TD="class: xl69, bgcolor: transparent"]0.677[/TD]
[TD="class: xl69, bgcolor: transparent"]0.96[/TD]
[TD="class: xl69, bgcolor: transparent"]0.819[/TD]
[TD="class: xl69, bgcolor: transparent"]0.888[/TD]
[TD="class: xl69, bgcolor: transparent"]1.95[/TD]
[TD="class: xl69, bgcolor: transparent"]10.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.38[/TD]
[TD="class: xl69, bgcolor: transparent"]5.1[/TD]
[TD="class: xl69, bgcolor: transparent"]26.7[/TD]
[TD="class: xl69, bgcolor: transparent"]8.6[/TD]
[TD="class: xl65, bgcolor: transparent"]0915 - Communications Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Automatic Data Processing[/TD]
[TD="class: xl65, bgcolor: transparent"]ADP[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.548[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl69, bgcolor: transparent"]47.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.152[/TD]
[TD="class: xl69, bgcolor: transparent"]0.132[/TD]
[TD="class: xl69, bgcolor: transparent"]0.263[/TD]
[TD="class: xl69, bgcolor: transparent"]0.334[/TD]
[TD="class: xl69, bgcolor: transparent"]0.324[/TD]
[TD="class: xl69, bgcolor: transparent"]0.343[/TD]
[TD="class: xl69, bgcolor: transparent"]5.98[/TD]
[TD="class: xl69, bgcolor: transparent"]26.8[/TD]
[TD="class: xl69, bgcolor: transparent"]3.27[/TD]
[TD="class: xl69, bgcolor: transparent"]12.2[/TD]
[TD="class: xl69, bgcolor: transparent"]141.5[/TD]
[TD="class: xl69, bgcolor: transparent"]3.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0909 - Business Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Baker Hughes Incorporated[/TD]
[TD="class: xl65, bgcolor: transparent"]BHI[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.557[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]20.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.768[/TD]
[TD="class: xl69, bgcolor: transparent"]0.192[/TD]
[TD="class: xl69, bgcolor: transparent"]0.697[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.031[/TD]
[TD="class: xl69, bgcolor: transparent"]0.242[/TD]
[TD="class: xl69, bgcolor: transparent"]1.65[/TD]
[TD="class: xl69, bgcolor: transparent"]23.7[/TD]
[TD="class: xl69, bgcolor: transparent"]1.28[/TD]
[TD="class: xl69, bgcolor: transparent"]9.6[/TD]
[TD="class: xl69, bgcolor: transparent"]756.4[/TD]
[TD="class: xl69, bgcolor: transparent"]2.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0612 - Oil Well Services & Equipment[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Bank of America Corp[/TD]
[TD="class: xl65, bgcolor: transparent"]BAC[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.84[/TD]
[TD="class: xl69, bgcolor: transparent"]1.2[/TD]
[TD="class: xl69, bgcolor: transparent"]6.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.99[/TD]
[TD="class: xl69, bgcolor: transparent"]0.142[/TD]
[TD="class: xl69, bgcolor: transparent"]0.273[/TD]
[TD="class: xl69, bgcolor: transparent"]0.011[/TD]
[TD="class: xl69, bgcolor: transparent"]0.99[/TD]
[TD="class: xl69, bgcolor: transparent"]0.434[/TD]
[TD="class: xl69, bgcolor: transparent"]0.76[/TD]
[TD="class: xl69, bgcolor: transparent"]26[/TD]
[TD="class: xl69, bgcolor: transparent"]3.2[/TD]
[TD="class: xl69, bgcolor: transparent"]53[/TD]
[TD="class: xl69, bgcolor: transparent"]3.3[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl65, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Bank of Nova Scotia (USA), The[/TD]
[TD="class: xl65, bgcolor: transparent"]BNS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.487[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl69, bgcolor: transparent"]46.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.708[/TD]
[TD="class: xl69, bgcolor: transparent"]0.788[/TD]
[TD="class: xl69, bgcolor: transparent"]0.112[/TD]
[TD="class: xl69, bgcolor: transparent"]0.576[/TD]
[TD="class: xl69, bgcolor: transparent"]0.162[/TD]
[TD="class: xl69, bgcolor: transparent"]0.141[/TD]
[TD="class: xl69, bgcolor: transparent"]2.07[/TD]
[TD="class: xl69, bgcolor: transparent"]13.7[/TD]
[TD="class: xl69, bgcolor: transparent"]4.66[/TD]
[TD="class: xl69, bgcolor: transparent"]10.1[/TD]
[TD="class: xl69, bgcolor: transparent"]223.8[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl65, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Blackstone Group L.P., The[/TD]
[TD="class: xl65, bgcolor: transparent"]BX[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.284[/TD]
[TD="class: xl69, bgcolor: transparent"]5.3[/TD]
[TD="class: xl69, bgcolor: transparent"]52.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.495[/TD]
[TD="class: xl69, bgcolor: transparent"]0.879[/TD]
[TD="class: xl69, bgcolor: transparent"]0.364[/TD]
[TD="class: xl69, bgcolor: transparent"]0.728[/TD]
[TD="class: xl69, bgcolor: transparent"]0.728[/TD]
[TD="class: xl69, bgcolor: transparent"]0.09[/TD]
[TD="class: xl69, bgcolor: transparent"]2.92[/TD]
[TD="class: xl69, bgcolor: transparent"]12.4[/TD]
[TD="class: xl69, bgcolor: transparent"]2.55[/TD]
[TD="class: xl69, bgcolor: transparent"]8.5[/TD]
[TD="class: xl69, bgcolor: transparent"]35.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0718 - Investment Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Bristol-Myers Squibb Co[/TD]
[TD="class: xl65, bgcolor: transparent"]BMY[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.294[/TD]
[TD="class: xl69, bgcolor: transparent"]2.9[/TD]
[TD="class: xl69, bgcolor: transparent"]87.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.182[/TD]
[TD="class: xl69, bgcolor: transparent"]0.061[/TD]
[TD="class: xl69, bgcolor: transparent"]0.071[/TD]
[TD="class: xl69, bgcolor: transparent"]0.051[/TD]
[TD="class: xl69, bgcolor: transparent"]0.738[/TD]
[TD="class: xl69, bgcolor: transparent"]0.191[/TD]
[TD="class: xl69, bgcolor: transparent"]5.42[/TD]
[TD="class: xl69, bgcolor: transparent"]31.2[/TD]
[TD="class: xl69, bgcolor: transparent"]5.13[/TD]
[TD="class: xl69, bgcolor: transparent"]21.3[/TD]
[TD="class: xl69, bgcolor: transparent"]34.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0803 - Biotechnology & Drugs[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Brookfield Asset Management In[/TD]
[TD="class: xl65, bgcolor: transparent"]BAM[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.255[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]15.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.778[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.637[/TD]
[TD="class: xl69, bgcolor: transparent"]0.213[/TD]
[TD="class: xl69, bgcolor: transparent"]0.637[/TD]
[TD="class: xl69, bgcolor: transparent"]0.07[/TD]
[TD="class: xl69, bgcolor: transparent"]1.59[/TD]
[TD="class: xl69, bgcolor: transparent"]11.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.49[/TD]
[TD="class: xl69, bgcolor: transparent"]14[/TD]
[TD="class: xl69, bgcolor: transparent"]46.3[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl65, bgcolor: transparent"]0718 - Investment Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Canadian Imperial Bank of Comm[/TD]
[TD="class: xl65, bgcolor: transparent"]CM[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.236[/TD]
[TD="class: xl69, bgcolor: transparent"]3.9[/TD]
[TD="class: xl69, bgcolor: transparent"]49.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.607[/TD]
[TD="class: xl69, bgcolor: transparent"]0.809[/TD]
[TD="class: xl69, bgcolor: transparent"]0.213[/TD]
[TD="class: xl69, bgcolor: transparent"]0.708[/TD]
[TD="class: xl69, bgcolor: transparent"]0.314[/TD]
[TD="class: xl69, bgcolor: transparent"]0.585[/TD]
[TD="class: xl69, bgcolor: transparent"]2.49[/TD]
[TD="class: xl69, bgcolor: transparent"]13.4[/TD]
[TD="class: xl69, bgcolor: transparent"]3.58[/TD]
[TD="class: xl69, bgcolor: transparent"]8.8[/TD]
[TD="class: xl69, bgcolor: transparent"]142.9[/TD]
[TD="class: xl69, bgcolor: transparent"]4.6[/TD]
[TD="class: xl65, bgcolor: transparent"]0724 - Money Center Banks[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Capital One Financial Corp.[/TD]
[TD="class: xl65, bgcolor: transparent"]COF[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.981[/TD]
[TD="class: xl69, bgcolor: transparent"]1.5[/TD]
[TD="class: xl69, bgcolor: transparent"]16.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.93[/TD]
[TD="class: xl69, bgcolor: transparent"]0.394[/TD]
[TD="class: xl69, bgcolor: transparent"]0.364[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.484[/TD]
[TD="class: xl69, bgcolor: transparent"]1.05[/TD]
[TD="class: xl69, bgcolor: transparent"]11.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.45[/TD]
[TD="class: xl69, bgcolor: transparent"]11.8[/TD]
[TD="class: xl69, bgcolor: transparent"]22.8[/TD]
[TD="class: xl69, bgcolor: transparent"]3.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Cardinal Health Inc[/TD]
[TD="class: xl65, bgcolor: transparent"]CAH[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.082[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl69, bgcolor: transparent"]36.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.324[/TD]
[TD="class: xl69, bgcolor: transparent"]0.293[/TD]
[TD="class: xl69, bgcolor: transparent"]0.97[/TD]
[TD="class: xl69, bgcolor: transparent"]0.485[/TD]
[TD="class: xl69, bgcolor: transparent"]0.839[/TD]
[TD="class: xl69, bgcolor: transparent"]0.171[/TD]
[TD="class: xl69, bgcolor: transparent"]3.89[/TD]
[TD="class: xl69, bgcolor: transparent"]21.6[/TD]
[TD="class: xl69, bgcolor: transparent"]0.27[/TD]
[TD="class: xl69, bgcolor: transparent"]10.8[/TD]
[TD="class: xl69, bgcolor: transparent"]26.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0803 - Biotechnology & Drugs[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Caterpillar Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]CAT[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.559[/TD]
[TD="class: xl69, bgcolor: transparent"]2.6[/TD]
[TD="class: xl69, bgcolor: transparent"]40.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.455[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.728[/TD]
[TD="class: xl69, bgcolor: transparent"]0.435[/TD]
[TD="class: xl69, bgcolor: transparent"]0.708[/TD]
[TD="class: xl69, bgcolor: transparent"]0.717[/TD]
[TD="class: xl69, bgcolor: transparent"]3.22[/TD]
[TD="class: xl69, bgcolor: transparent"]17.9[/TD]
[TD="class: xl69, bgcolor: transparent"]1.22[/TD]
[TD="class: xl69, bgcolor: transparent"]11.1[/TD]
[TD="class: xl69, bgcolor: transparent"]37.5[/TD]
[TD="class: xl69, bgcolor: transparent"]6.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0206 - Construction & Agricultural Machinery[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]CBS Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]CBS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.537[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]15[/TD]
[TD="class: xl69, bgcolor: transparent"]0.334[/TD]
[TD="class: xl69, bgcolor: transparent"]0.394[/TD]
[TD="class: xl69, bgcolor: transparent"]0.405[/TD]
[TD="class: xl69, bgcolor: transparent"]0.364[/TD]
[TD="class: xl69, bgcolor: transparent"]0.253[/TD]
[TD="class: xl69, bgcolor: transparent"]0.787[/TD]
[TD="class: xl69, bgcolor: transparent"]3.83[/TD]
[TD="class: xl69, bgcolor: transparent"]20[/TD]
[TD="class: xl69, bgcolor: transparent"]2.41[/TD]
[TD="class: xl69, bgcolor: transparent"]11.8[/TD]
[TD="class: xl69, bgcolor: transparent"]177.9[/TD]
[TD="class: xl69, bgcolor: transparent"]7.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0906 - Broadcasting & Cable TV[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Chesapeake Energy Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]CHK[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.488[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]44.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.849[/TD]
[TD="class: xl69, bgcolor: transparent"]0.041[/TD]
[TD="class: xl69, bgcolor: transparent"]0.809[/TD]
[TD="class: xl69, bgcolor: transparent"]0.829[/TD]
[TD="class: xl69, bgcolor: transparent"]0.91[/TD]
[TD="class: xl69, bgcolor: transparent"]0.05[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]34.7[/TD]
[TD="class: xl69, bgcolor: transparent"]0.87[/TD]
[TD="class: xl69, bgcolor: transparent"]6.7[/TD]
[TD="class: xl69, bgcolor: transparent"]22.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.7[/TD]
[TD="class: xl65, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Citigroup Inc[/TD]
[TD="class: xl65, bgcolor: transparent"]C[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.709[/TD]
[TD="class: xl69, bgcolor: transparent"]0.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.99[/TD]
[TD="class: xl69, bgcolor: transparent"]0.536[/TD]
[TD="class: xl69, bgcolor: transparent"]0.384[/TD]
[TD="class: xl69, bgcolor: transparent"]0.061[/TD]
[TD="class: xl69, bgcolor: transparent"]0.718[/TD]
[TD="class: xl69, bgcolor: transparent"]0.02[/TD]
[TD="class: xl69, bgcolor: transparent"]0.76[/TD]
[TD="class: xl69, bgcolor: transparent"]17.3[/TD]
[TD="class: xl69, bgcolor: transparent"]2.49[/TD]
[TD="class: xl69, bgcolor: transparent"]18[/TD]
[TD="class: xl69, bgcolor: transparent"]37.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.3[/TD]
[TD="class: xl65, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Cna Financial Corp[/TD]
[TD="class: xl65, bgcolor: transparent"]CNA[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.032[/TD]
[TD="class: xl69, bgcolor: transparent"]2.6[/TD]
[TD="class: xl69, bgcolor: transparent"]66.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.97[/TD]
[TD="class: xl69, bgcolor: transparent"]0.94[/TD]
[TD="class: xl69, bgcolor: transparent"]0.758[/TD]
[TD="class: xl69, bgcolor: transparent"]0.718[/TD]
[TD="class: xl69, bgcolor: transparent"]0.374[/TD]
[TD="class: xl69, bgcolor: transparent"]0.272[/TD]
[TD="class: xl69, bgcolor: transparent"]0.79[/TD]
[TD="class: xl69, bgcolor: transparent"]10.6[/TD]
[TD="class: xl69, bgcolor: transparent"]1.03[/TD]
[TD="class: xl69, bgcolor: transparent"]8.7[/TD]
[TD="class: xl69, bgcolor: transparent"]123.4[/TD]
[TD="class: xl69, bgcolor: transparent"]2.5[/TD]
[TD="class: xl65, bgcolor: transparent"]0715 - Insurance (Property & Casualty)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Coca-Cola Company, The[/TD]
[TD="class: xl65, bgcolor: transparent"]KO[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.739[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]60.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.192[/TD]
[TD="class: xl69, bgcolor: transparent"]0.243[/TD]
[TD="class: xl69, bgcolor: transparent"]0.172[/TD]
[TD="class: xl69, bgcolor: transparent"]0.132[/TD]
[TD="class: xl69, bgcolor: transparent"]0.475[/TD]
[TD="class: xl69, bgcolor: transparent"]0.525[/TD]
[TD="class: xl69, bgcolor: transparent"]5.3[/TD]
[TD="class: xl69, bgcolor: transparent"]22[/TD]
[TD="class: xl69, bgcolor: transparent"]3.91[/TD]
[TD="class: xl69, bgcolor: transparent"]15.7[/TD]
[TD="class: xl69, bgcolor: transparent"]83.9[/TD]
[TD="class: xl69, bgcolor: transparent"]4.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0506 - Beverages (Non-Alcoholic)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Colgate-Palmolive Company[/TD]
[TD="class: xl65, bgcolor: transparent"]CL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.143[/TD]
[TD="class: xl69, bgcolor: transparent"]2.2[/TD]
[TD="class: xl69, bgcolor: transparent"]57.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.011[/TD]
[TD="class: xl69, bgcolor: transparent"]0.122[/TD]
[TD="class: xl69, bgcolor: transparent"]0.233[/TD]
[TD="class: xl69, bgcolor: transparent"]0.091[/TD]
[TD="class: xl69, bgcolor: transparent"]0.192[/TD]
[TD="class: xl69, bgcolor: transparent"]0.494[/TD]
[TD="class: xl69, bgcolor: transparent"]33.28[/TD]
[TD="class: xl69, bgcolor: transparent"]27[/TD]
[TD="class: xl69, bgcolor: transparent"]3.39[/TD]
[TD="class: xl69, bgcolor: transparent"]17.2[/TD]
[TD="class: xl69, bgcolor: transparent"]208.3[/TD]
[TD="class: xl69, bgcolor: transparent"]4[/TD]
[TD="class: xl65, bgcolor: transparent"]0521 - Personal & Household Products[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]ConocoPhillips[/TD]
[TD="class: xl65, bgcolor: transparent"]COP[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.113[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl69, bgcolor: transparent"]37.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.738[/TD]
[TD="class: xl69, bgcolor: transparent"]0.879[/TD]
[TD="class: xl69, bgcolor: transparent"]0.566[/TD]
[TD="class: xl69, bgcolor: transparent"]0.93[/TD]
[TD="class: xl69, bgcolor: transparent"]0.657[/TD]
[TD="class: xl69, bgcolor: transparent"]0.343[/TD]
[TD="class: xl69, bgcolor: transparent"]1.79[/TD]
[TD="class: xl69, bgcolor: transparent"]12.4[/TD]
[TD="class: xl69, bgcolor: transparent"]1.74[/TD]
[TD="class: xl69, bgcolor: transparent"]5.4[/TD]
[TD="class: xl69, bgcolor: transparent"]44.6[/TD]
[TD="class: xl69, bgcolor: transparent"]3.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Costco Wholesale Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]COST[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.922[/TD]
[TD="class: xl69, bgcolor: transparent"]1.2[/TD]
[TD="class: xl69, bgcolor: transparent"]28.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.253[/TD]
[TD="class: xl69, bgcolor: transparent"]0.112[/TD]
[TD="class: xl69, bgcolor: transparent"]0.94[/TD]
[TD="class: xl69, bgcolor: transparent"]0.344[/TD]
[TD="class: xl69, bgcolor: transparent"]0.243[/TD]
[TD="class: xl69, bgcolor: transparent"]0.03[/TD]
[TD="class: xl69, bgcolor: transparent"]4.51[/TD]
[TD="class: xl69, bgcolor: transparent"]27.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.49[/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]189.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.5[/TD]
[TD="class: xl65, bgcolor: transparent"]0963 - Retail (Specialty Non-Apparel)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]CVS Caremark Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]CVS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.224[/TD]
[TD="class: xl69, bgcolor: transparent"]1.4[/TD]
[TD="class: xl69, bgcolor: transparent"]24.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.435[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.384[/TD]
[TD="class: xl69, bgcolor: transparent"]0.142[/TD]
[TD="class: xl69, bgcolor: transparent"]0.747[/TD]
[TD="class: xl69, bgcolor: transparent"]2.42[/TD]
[TD="class: xl69, bgcolor: transparent"]19.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.7[/TD]
[TD="class: xl69, bgcolor: transparent"]11.6[/TD]
[TD="class: xl69, bgcolor: transparent"]240.1[/TD]
[TD="class: xl69, bgcolor: transparent"]6.5[/TD]
[TD="class: xl65, bgcolor: transparent"]0954 - Retail (Drugs)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Delta Air Lines, Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]DAL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.739[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.99[/TD]
[TD="class: xl69, bgcolor: transparent"]0.809[/TD]
[TD="class: xl69, bgcolor: transparent"]0.788[/TD]
[TD="class: xl69, bgcolor: transparent"]0.455[/TD]
[TD="class: xl69, bgcolor: transparent"]0.181[/TD]
[TD="class: xl69, bgcolor: transparent"]2.78[/TD]
[TD="class: xl69, bgcolor: transparent"]3.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.87[/TD]
[TD="class: xl69, bgcolor: transparent"]7.4[/TD]
[TD="class: xl69, bgcolor: transparent"]86[/TD]
[TD="class: xl69, bgcolor: transparent"]2[/TD]
[TD="class: xl65, bgcolor: transparent"]1106 - Airline[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Discover Financial Services[/TD]
[TD="class: xl65, bgcolor: transparent"]DFS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.689[/TD]
[TD="class: xl69, bgcolor: transparent"]1.5[/TD]
[TD="class: xl69, bgcolor: transparent"]16.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.556[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.162[/TD]
[TD="class: xl69, bgcolor: transparent"]0.536[/TD]
[TD="class: xl69, bgcolor: transparent"]0.829[/TD]
[TD="class: xl69, bgcolor: transparent"]0.717[/TD]
[TD="class: xl69, bgcolor: transparent"]2.67[/TD]
[TD="class: xl69, bgcolor: transparent"]12.2[/TD]
[TD="class: xl69, bgcolor: transparent"]3.95[/TD]
[TD="class: xl69, bgcolor: transparent"]10.6[/TD]
[TD="class: xl69, bgcolor: transparent"]26.5[/TD]
[TD="class: xl69, bgcolor: transparent"]6.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0703 - Consumer Financial Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Emerson Electric Co.[/TD]
[TD="class: xl65, bgcolor: transparent"]EMR[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.71[/TD]
[TD="class: xl69, bgcolor: transparent"]2.7[/TD]
[TD="class: xl69, bgcolor: transparent"]47.2[/TD]
[TD="class: xl69, bgcolor: transparent"]0.273[/TD]
[TD="class: xl69, bgcolor: transparent"]0.506[/TD]
[TD="class: xl69, bgcolor: transparent"]0.546[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.213[/TD]
[TD="class: xl69, bgcolor: transparent"]0.656[/TD]
[TD="class: xl69, bgcolor: transparent"]4.18[/TD]
[TD="class: xl69, bgcolor: transparent"]18.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.84[/TD]
[TD="class: xl69, bgcolor: transparent"]10.7[/TD]
[TD="class: xl69, bgcolor: transparent"]195.8[/TD]
[TD="class: xl69, bgcolor: transparent"]5.1[/TD]
[TD="class: xl65, bgcolor: transparent"]1030 - Scientific & Technical Instruments[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Estee Lauder Companies Inc[/TD]
[TD="class: xl65, bgcolor: transparent"]EL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.235[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]25.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.112[/TD]
[TD="class: xl69, bgcolor: transparent"]0.162[/TD]
[TD="class: xl69, bgcolor: transparent"]0.334[/TD]
[TD="class: xl69, bgcolor: transparent"]0.263[/TD]
[TD="class: xl69, bgcolor: transparent"]0.152[/TD]
[TD="class: xl69, bgcolor: transparent"]0.212[/TD]
[TD="class: xl69, bgcolor: transparent"]7.58[/TD]
[TD="class: xl69, bgcolor: transparent"]24.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.66[/TD]
[TD="class: xl69, bgcolor: transparent"]13[/TD]
[TD="class: xl69, bgcolor: transparent"]231.2[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl65, bgcolor: transparent"]0521 - Personal & Household Products[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Exxon Mobil Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]XOM[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.96[/TD]
[TD="class: xl69, bgcolor: transparent"]2.8[/TD]
[TD="class: xl69, bgcolor: transparent"]32.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.657[/TD]
[TD="class: xl69, bgcolor: transparent"]0.859[/TD]
[TD="class: xl69, bgcolor: transparent"]0.778[/TD]
[TD="class: xl69, bgcolor: transparent"]0.879[/TD]
[TD="class: xl69, bgcolor: transparent"]0.091[/TD]
[TD="class: xl69, bgcolor: transparent"]0.696[/TD]
[TD="class: xl69, bgcolor: transparent"]2.34[/TD]
[TD="class: xl69, bgcolor: transparent"]12.5[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]289.7[/TD]
[TD="class: xl69, bgcolor: transparent"]5.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Franklin Resources, Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]BEN[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.931[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl69, bgcolor: transparent"]12.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.465[/TD]
[TD="class: xl69, bgcolor: transparent"]0.637[/TD]
[TD="class: xl69, bgcolor: transparent"]0.152[/TD]
[TD="class: xl69, bgcolor: transparent"]0.637[/TD]
[TD="class: xl69, bgcolor: transparent"]0.849[/TD]
[TD="class: xl69, bgcolor: transparent"]0.191[/TD]
[TD="class: xl69, bgcolor: transparent"]3.21[/TD]
[TD="class: xl69, bgcolor: transparent"]15.9[/TD]
[TD="class: xl69, bgcolor: transparent"]4.21[/TD]
[TD="class: xl69, bgcolor: transparent"]9.3[/TD]
[TD="class: xl69, bgcolor: transparent"]25.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0718 - Investment Services[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]General Mills, Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]GIS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.306[/TD]
[TD="class: xl69, bgcolor: transparent"]3.1[/TD]
[TD="class: xl69, bgcolor: transparent"]53.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.223[/TD]
[TD="class: xl69, bgcolor: transparent"]0.465[/TD]
[TD="class: xl69, bgcolor: transparent"]0.556[/TD]
[TD="class: xl69, bgcolor: transparent"]0.122[/TD]
[TD="class: xl69, bgcolor: transparent"]0.112[/TD]
[TD="class: xl69, bgcolor: transparent"]0.828[/TD]
[TD="class: xl69, bgcolor: transparent"]4.96[/TD]
[TD="class: xl69, bgcolor: transparent"]18.7[/TD]
[TD="class: xl69, bgcolor: transparent"]1.81[/TD]
[TD="class: xl69, bgcolor: transparent"]15.9[/TD]
[TD="class: xl69, bgcolor: transparent"]277.4[/TD]
[TD="class: xl69, bgcolor: transparent"]8.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0515 - Food Processing[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Halliburton Company[/TD]
[TD="class: xl65, bgcolor: transparent"]HAL[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.285[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl69, bgcolor: transparent"]17.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.314[/TD]
[TD="class: xl69, bgcolor: transparent"]0.384[/TD]
[TD="class: xl69, bgcolor: transparent"]0.526[/TD]
[TD="class: xl69, bgcolor: transparent"]0.566[/TD]
[TD="class: xl69, bgcolor: transparent"]0.576[/TD]
[TD="class: xl69, bgcolor: transparent"]0.919[/TD]
[TD="class: xl69, bgcolor: transparent"]3.92[/TD]
[TD="class: xl69, bgcolor: transparent"]20.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.87[/TD]
[TD="class: xl69, bgcolor: transparent"]10.3[/TD]
[TD="class: xl69, bgcolor: transparent"]60.2[/TD]
[TD="class: xl69, bgcolor: transparent"]9.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0612 - Oil Well Services & Equipment[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Hess Corp.[/TD]
[TD="class: xl65, bgcolor: transparent"]HES[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]5.174[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]8.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.849[/TD]
[TD="class: xl69, bgcolor: transparent"]0.667[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.929[/TD]
[TD="class: xl69, bgcolor: transparent"]1.26[/TD]
[TD="class: xl69, bgcolor: transparent"]12.6[/TD]
[TD="class: xl69, bgcolor: transparent"]1.43[/TD]
[TD="class: xl69, bgcolor: transparent"]5.8[/TD]
[TD="class: xl69, bgcolor: transparent"]21.7[/TD]
[TD="class: xl69, bgcolor: transparent"]9.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Hewlett-Packard Company[/TD]
[TD="class: xl65, bgcolor: transparent"]HPQ[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.386[/TD]
[TD="class: xl69, bgcolor: transparent"]1.7[/TD]
[TD="class: xl69, bgcolor: transparent"]27.7[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.778[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.859[/TD]
[TD="class: xl69, bgcolor: transparent"]0.586[/TD]
[TD="class: xl69, bgcolor: transparent"]0.616[/TD]
[TD="class: xl69, bgcolor: transparent"]2.42[/TD]
[TD="class: xl69, bgcolor: transparent"]13.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.61[/TD]
[TD="class: xl69, bgcolor: transparent"]6.5[/TD]
[TD="class: xl69, bgcolor: transparent"]59.4[/TD]
[TD="class: xl69, bgcolor: transparent"]4.8[/TD]
[TD="class: xl65, bgcolor: transparent"]1006 - Computer Hardware[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Home Depot, Inc., The[/TD]
[TD="class: xl65, bgcolor: transparent"]HD[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.668[/TD]
[TD="class: xl69, bgcolor: transparent"]2.1[/TD]
[TD="class: xl69, bgcolor: transparent"]40.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.061[/TD]
[TD="class: xl69, bgcolor: transparent"]0.273[/TD]
[TD="class: xl69, bgcolor: transparent"]0.627[/TD]
[TD="class: xl69, bgcolor: transparent"]0.556[/TD]
[TD="class: xl69, bgcolor: transparent"]0.293[/TD]
[TD="class: xl69, bgcolor: transparent"]0.858[/TD]
[TD="class: xl69, bgcolor: transparent"]10.7[/TD]
[TD="class: xl69, bgcolor: transparent"]21.7[/TD]
[TD="class: xl69, bgcolor: transparent"]1.52[/TD]
[TD="class: xl69, bgcolor: transparent"]10.5[/TD]
[TD="class: xl69, bgcolor: transparent"]154.3[/TD]
[TD="class: xl69, bgcolor: transparent"]8.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0960 - Retail (Home Improvement)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Honeywell International Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]HON[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.588[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl69, bgcolor: transparent"]34[/TD]
[TD="class: xl69, bgcolor: transparent"]0.293[/TD]
[TD="class: xl69, bgcolor: transparent"]0.455[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.415[/TD]
[TD="class: xl69, bgcolor: transparent"]0.697[/TD]
[TD="class: xl69, bgcolor: transparent"]0.212[/TD]
[TD="class: xl69, bgcolor: transparent"]4.01[/TD]
[TD="class: xl69, bgcolor: transparent"]18.8[/TD]
[TD="class: xl69, bgcolor: transparent"]1.88[/TD]
[TD="class: xl69, bgcolor: transparent"]11.3[/TD]
[TD="class: xl69, bgcolor: transparent"]37.8[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl65, bgcolor: transparent"]1030 - Scientific & Technical Instruments[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Huntsman Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]HUN[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.022[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl69, bgcolor: transparent"]43.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.475[/TD]
[TD="class: xl69, bgcolor: transparent"]0.213[/TD]
[TD="class: xl69, bgcolor: transparent"]0.93[/TD]
[TD="class: xl69, bgcolor: transparent"]0.556[/TD]
[TD="class: xl69, bgcolor: transparent"]0.788[/TD]
[TD="class: xl69, bgcolor: transparent"]0.06[/TD]
[TD="class: xl69, bgcolor: transparent"]3.05[/TD]
[TD="class: xl69, bgcolor: transparent"]23[/TD]
[TD="class: xl69, bgcolor: transparent"]0.58[/TD]
[TD="class: xl69, bgcolor: transparent"]10.5[/TD]
[TD="class: xl69, bgcolor: transparent"]28.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0106 - Chemicals - Plastics and Rubbers[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Illinois Tool Works Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]ITW[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.325[/TD]
[TD="class: xl69, bgcolor: transparent"]2.2[/TD]
[TD="class: xl69, bgcolor: transparent"]24.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.263[/TD]
[TD="class: xl69, bgcolor: transparent"]0.263[/TD]
[TD="class: xl69, bgcolor: transparent"]0.384[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.93[/TD]
[TD="class: xl69, bgcolor: transparent"]0.969[/TD]
[TD="class: xl69, bgcolor: transparent"]4.25[/TD]
[TD="class: xl69, bgcolor: transparent"]21.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.49[/TD]
[TD="class: xl69, bgcolor: transparent"]10.7[/TD]
[TD="class: xl69, bgcolor: transparent"]14.7[/TD]
[TD="class: xl69, bgcolor: transparent"]12.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0415 - Auto & Truck Parts[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]International Paper Co[/TD]
[TD="class: xl65, bgcolor: transparent"]IP[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.749[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]66.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.526[/TD]
[TD="class: xl69, bgcolor: transparent"]0.203[/TD]
[TD="class: xl69, bgcolor: transparent"]0.889[/TD]
[TD="class: xl69, bgcolor: transparent"]0.293[/TD]
[TD="class: xl69, bgcolor: transparent"]0.081[/TD]
[TD="class: xl69, bgcolor: transparent"]0.757[/TD]
[TD="class: xl69, bgcolor: transparent"]2.71[/TD]
[TD="class: xl69, bgcolor: transparent"]23.6[/TD]
[TD="class: xl69, bgcolor: transparent"]0.7[/TD]
[TD="class: xl69, bgcolor: transparent"]12.7[/TD]
[TD="class: xl69, bgcolor: transparent"]294.5[/TD]
[TD="class: xl69, bgcolor: transparent"]6.8[/TD]
[TD="class: xl65, bgcolor: transparent"]0133 - Paper & Paper Products[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Kellogg Company[/TD]
[TD="class: xl65, bgcolor: transparent"]K[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.83[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]36.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.142[/TD]
[TD="class: xl69, bgcolor: transparent"]0.849[/TD]
[TD="class: xl69, bgcolor: transparent"]0.576[/TD]
[TD="class: xl69, bgcolor: transparent"]0.677[/TD]
[TD="class: xl69, bgcolor: transparent"]0.021[/TD]
[TD="class: xl69, bgcolor: transparent"]0.565[/TD]
[TD="class: xl69, bgcolor: transparent"]6.15[/TD]
[TD="class: xl69, bgcolor: transparent"]12.6[/TD]
[TD="class: xl69, bgcolor: transparent"]1.58[/TD]
[TD="class: xl69, bgcolor: transparent"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]803.8[/TD]
[TD="class: xl69, bgcolor: transparent"]4.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0515 - Food Processing[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Kimberly Clark Corp[/TD]
[TD="class: xl65, bgcolor: transparent"]KMB[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.274[/TD]
[TD="class: xl69, bgcolor: transparent"]3.1[/TD]
[TD="class: xl69, bgcolor: transparent"]58.8[/TD]
[TD="class: xl69, bgcolor: transparent"]0.081[/TD]
[TD="class: xl69, bgcolor: transparent"]0.425[/TD]
[TD="class: xl69, bgcolor: transparent"]0.495[/TD]
[TD="class: xl69, bgcolor: transparent"]0.374[/TD]
[TD="class: xl69, bgcolor: transparent"]0.223[/TD]
[TD="class: xl69, bgcolor: transparent"]0.676[/TD]
[TD="class: xl69, bgcolor: transparent"]8.86[/TD]
[TD="class: xl69, bgcolor: transparent"]19.5[/TD]
[TD="class: xl69, bgcolor: transparent"]1.93[/TD]
[TD="class: xl69, bgcolor: transparent"]11.7[/TD]
[TD="class: xl69, bgcolor: transparent"]194.2[/TD]
[TD="class: xl69, bgcolor: transparent"]5.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0521 - Personal & Household Products[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Kohl's Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]KSS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.538[/TD]
[TD="class: xl69, bgcolor: transparent"]2.6[/TD]
[TD="class: xl69, bgcolor: transparent"]35.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.697[/TD]
[TD="class: xl69, bgcolor: transparent"]0.718[/TD]
[TD="class: xl69, bgcolor: transparent"]0.91[/TD]
[TD="class: xl69, bgcolor: transparent"]0.839[/TD]
[TD="class: xl69, bgcolor: transparent"]0.445[/TD]
[TD="class: xl69, bgcolor: transparent"]0.929[/TD]
[TD="class: xl69, bgcolor: transparent"]2.09[/TD]
[TD="class: xl69, bgcolor: transparent"]14.6[/TD]
[TD="class: xl69, bgcolor: transparent"]0.64[/TD]
[TD="class: xl69, bgcolor: transparent"]6.6[/TD]
[TD="class: xl69, bgcolor: transparent"]88.7[/TD]
[TD="class: xl69, bgcolor: transparent"]9.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0951 - Retail (Department & Discount)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Kraft Foods Group Inc[/TD]
[TD="class: xl65, bgcolor: transparent"]KRFT[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.548[/TD]
[TD="class: xl69, bgcolor: transparent"]3.7[/TD]
[TD="class: xl69, bgcolor: transparent"]38.7[/TD]
[TD="class: xl69, bgcolor: transparent"]0.132[/TD]
[TD="class: xl69, bgcolor: transparent"]0.738[/TD]
[TD="class: xl69, bgcolor: transparent"]0.516[/TD]
[TD="class: xl69, bgcolor: transparent"]0.465[/TD]
[TD="class: xl69, bgcolor: transparent"]0.273[/TD]
[TD="class: xl69, bgcolor: transparent"]0.424[/TD]
[TD="class: xl69, bgcolor: transparent"]6.23[/TD]
[TD="class: xl69, bgcolor: transparent"]14.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.88[/TD]
[TD="class: xl69, bgcolor: transparent"]11[/TD]
[TD="class: xl69, bgcolor: transparent"]168.3[/TD]
[TD="class: xl69, bgcolor: transparent"]3.5[/TD]
[TD="class: xl65, bgcolor: transparent"]0515 - Food Processing[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Las Vegas Sands Corp.[/TD]
[TD="class: xl65, bgcolor: transparent"]LVS[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]1.922[/TD]
[TD="class: xl69, bgcolor: transparent"]2.9[/TD]
[TD="class: xl69, bgcolor: transparent"]52.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.102[/TD]
[TD="class: xl69, bgcolor: transparent"]0.304[/TD]
[TD="class: xl69, bgcolor: transparent"]0.182[/TD]
[TD="class: xl69, bgcolor: transparent"]0.142[/TD]
[TD="class: xl69, bgcolor: transparent"]0.546[/TD]
[TD="class: xl69, bgcolor: transparent"]0.646[/TD]
[TD="class: xl69, bgcolor: transparent"]7.67[/TD]
[TD="class: xl69, bgcolor: transparent"]21.4[/TD]
[TD="class: xl69, bgcolor: transparent"]3.76[/TD]
[TD="class: xl69, bgcolor: transparent"]15[/TD]
[TD="class: xl69, bgcolor: transparent"]72.9[/TD]
[TD="class: xl69, bgcolor: transparent"]5[/TD]
[TD="class: xl65, bgcolor: transparent"]0912 - Casinos & Gaming[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Lockheed Martin Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]LMT[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.882[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]51.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.051[/TD]
[TD="class: xl69, bgcolor: transparent"]0.506[/TD]
[TD="class: xl69, bgcolor: transparent"]0.708[/TD]
[TD="class: xl69, bgcolor: transparent"]0.677[/TD]
[TD="class: xl69, bgcolor: transparent"]0.415[/TD]
[TD="class: xl69, bgcolor: transparent"]0.525[/TD]
[TD="class: xl69, bgcolor: transparent"]12.85[/TD]
[TD="class: xl69, bgcolor: transparent"]18.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.24[/TD]
[TD="class: xl69, bgcolor: transparent"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]95.7[/TD]
[TD="class: xl69, bgcolor: transparent"]4.2[/TD]
[TD="class: xl65, bgcolor: transparent"]0203 - Aerospace and Defense[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Loews Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]L[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]2.325[/TD]
[TD="class: xl69, bgcolor: transparent"]0.6[/TD]
[TD="class: xl69, bgcolor: transparent"]37.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.96[/TD]
[TD="class: xl69, bgcolor: transparent"]0.152[/TD]
[TD="class: xl69, bgcolor: transparent"]0.748[/TD]
[TD="class: xl69, bgcolor: transparent"]0.071[/TD]
[TD="class: xl69, bgcolor: transparent"]0.304[/TD]
[TD="class: xl69, bgcolor: transparent"]0.09[/TD]
[TD="class: xl69, bgcolor: transparent"]0.84[/TD]
[TD="class: xl69, bgcolor: transparent"]25.6[/TD]
[TD="class: xl69, bgcolor: transparent"]1.11[/TD]
[TD="class: xl69, bgcolor: transparent"]17.7[/TD]
[TD="class: xl69, bgcolor: transparent"]143.5[/TD]
[TD="class: xl69, bgcolor: transparent"]1.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0715 - Insurance (Property & Casualty)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Macy's, Inc.[/TD]
[TD="class: xl65, bgcolor: transparent"]M[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]3.871[/TD]
[TD="class: xl69, bgcolor: transparent"]2[/TD]
[TD="class: xl69, bgcolor: transparent"]25.9[/TD]
[TD="class: xl69, bgcolor: transparent"]0.344[/TD]
[TD="class: xl69, bgcolor: transparent"]0.647[/TD]
[TD="class: xl69, bgcolor: transparent"]0.849[/TD]
[TD="class: xl69, bgcolor: transparent"]0.809[/TD]
[TD="class: xl69, bgcolor: transparent"]0.394[/TD]
[TD="class: xl69, bgcolor: transparent"]0.828[/TD]
[TD="class: xl69, bgcolor: transparent"]3.82[/TD]
[TD="class: xl69, bgcolor: transparent"]15.3[/TD]
[TD="class: xl69, bgcolor: transparent"]0.79[/TD]
[TD="class: xl69, bgcolor: transparent"]7.2[/TD]
[TD="class: xl69, bgcolor: transparent"]116.5[/TD]
[TD="class: xl69, bgcolor: transparent"]8.1[/TD]
[TD="class: xl65, bgcolor: transparent"]0951 - Retail (Department & Discount)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Magna International Inc. (USA)[/TD]
[TD="class: xl65, bgcolor: transparent"]MGA[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.334[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]18.5[/TD]
[TD="class: xl69, bgcolor: transparent"]0.586[/TD]
[TD="class: xl69, bgcolor: transparent"]0.677[/TD]
[TD="class: xl69, bgcolor: transparent"]0.899[/TD]
[TD="class: xl69, bgcolor: transparent"]0.768[/TD]
[TD="class: xl69, bgcolor: transparent"]0.617[/TD]
[TD="class: xl69, bgcolor: transparent"]0.787[/TD]
[TD="class: xl69, bgcolor: transparent"]2.55[/TD]
[TD="class: xl69, bgcolor: transparent"]15.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.68[/TD]
[TD="class: xl69, bgcolor: transparent"]7.7[/TD]
[TD="class: xl69, bgcolor: transparent"]53[/TD]
[TD="class: xl69, bgcolor: transparent"]7.4[/TD]
[TD="class: xl65, bgcolor: transparent"]0415 - Auto & Truck Parts[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Manulife Financial Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]MFC[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.033[/TD]
[TD="class: xl69, bgcolor: transparent"]2.8[/TD]
[TD="class: xl69, bgcolor: transparent"]24.1[/TD]
[TD="class: xl69, bgcolor: transparent"]0.809[/TD]
[TD="class: xl69, bgcolor: transparent"]0.95[/TD]
[TD="class: xl69, bgcolor: transparent"]0.768[/TD]
[TD="class: xl69, bgcolor: transparent"]0.92[/TD]
[TD="class: xl69, bgcolor: transparent"]0.465[/TD]
[TD="class: xl69, bgcolor: transparent"]0.121[/TD]
[TD="class: xl69, bgcolor: transparent"]1.47[/TD]
[TD="class: xl69, bgcolor: transparent"]10.5[/TD]
[TD="class: xl69, bgcolor: transparent"]1.02[/TD]
[TD="class: xl69, bgcolor: transparent"]5.8[/TD]
[TD="class: xl69, bgcolor: transparent"]84.5[/TD]
[TD="class: xl69, bgcolor: transparent"]1.7[/TD]
[TD="class: xl65, bgcolor: transparent"]0709 - Insurance (Life)[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Marathon Oil Corporation[/TD]
[TD="class: xl65, bgcolor: transparent"]MRO[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]4.406[/TD]
[TD="class: xl69, bgcolor: transparent"]2.1[/TD]
[TD="class: xl69, bgcolor: transparent"]20[/TD]
[TD="class: xl69, bgcolor: transparent"]0.839[/TD]
[TD="class: xl69, bgcolor: transparent"]0.617[/TD]
[TD="class: xl69, bgcolor: transparent"]0.465[/TD]
[TD="class: xl69, bgcolor: transparent"]0.96[/TD]
[TD="class: xl69, bgcolor: transparent"]0.748[/TD]
[TD="class: xl69, bgcolor: transparent"]0.777[/TD]
[TD="class: xl69, bgcolor: transparent"]1.36[/TD]
[TD="class: xl69, bgcolor: transparent"]16.6[/TD]
[TD="class: xl69, bgcolor: transparent"]2.01[/TD]
[TD="class: xl69, bgcolor: transparent"]5.1[/TD]
[TD="class: xl69, bgcolor: transparent"]31[/TD]
[TD="class: xl69, bgcolor: transparent"]6.9[/TD]
[TD="class: xl65, bgcolor: transparent"]0606 - Oil & Gas - Integrated[/TD]
[/TR]
</TBODY>[/TABLE]
Let me know if you want to see the formulas. Bobaree

 

[Andrew Poulsom]

Where's the result of the PERCENTRANK formula there?

 

[Bobaree]

Column A contains "Company". Columns G-L contain the percentranks of the 6 columns to their right. Those 6 columns to the right contain the "hard" numbers that are converted into percentranks in G-L. Then, G-L are summed in Column D. Column D contains the data that I would hope to divide up into deciles.

[TABLE="width: 1591"]
<COLGROUP><COL style="WIDTH: 138pt; mso-width-source: userset; mso-width-alt: 3364" width=184><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 804" width=44><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 950" width=52><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 1572" width=86><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 621" width=34><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 731" width=40><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 3766" width=206><COL style="WIDTH: 146pt; mso-width-source: userset; mso-width-alt: 3547" span=2 width=194><COL style="WIDTH: 150pt; mso-width-source: userset; mso-width-alt: 3657" width=200><COL style="WIDTH: 152pt; mso-width-source: userset; mso-width-alt: 3693" width=202><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 3510" width=192><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 914" width=50><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 768" width=42><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 841" width=46><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 768" width=42><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 950" width=52><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 987" width=54><COL style="WIDTH: 150pt; mso-width-source: userset; mso-width-alt: 3657" width=200><TBODY>[TR]
[TD="class: xl68, width: 184, bgcolor: #92d050"]Company[/TD]
[TD="class: xl65, width: 44, bgcolor: transparent"]Ticker[/TD]
[TD="class: xl66, width: 52, bgcolor: transparent"]Decile[/TD]
[TD="class: xl66, width: 86, bgcolor: transparent"]Sum[/TD]
[TD="class: xl66, width: 34, bgcolor: transparent"]Yield[/TD]
[TD="class: xl66, width: 40, bgcolor: transparent"]Payout Ratio 12m[/TD]
[TD="class: xl66, width: 206, bgcolor: transparent"]Percentile P/Book[/TD]
[TD="class: xl66, width: 194, bgcolor: transparent"]Percentile P/EPS[/TD]
[TD="class: xl66, width: 194, bgcolor: transparent"]Percentile P/Sales[/TD]
[TD="class: xl66, width: 200, bgcolor: transparent"]Percentile EV/EBITDA[/TD]
[TD="class: xl66, width: 202, bgcolor: transparent"]Percentile P/CFPS[/TD]
[TD="class: xl66, width: 192, bgcolor: transparent"]Shareholder Yield[/TD]
[TD="class: xl66, width: 50, bgcolor: transparent"]Price/Book[/TD]
[TD="class: xl66, width: 42, bgcolor: transparent"]P/EPS[/TD]
[TD="class: xl66, width: 46, bgcolor: transparent"]P/Sales[/TD]
[TD="class: xl66, width: 42, bgcolor: transparent"]EV/EBITDA[/TD]
[TD="class: xl66, width: 52, bgcolor: transparent"]P/CFPS[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Shrhld Yld[/TD]
[TD="class: xl66, width: 200, bgcolor: transparent"]Industry[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]AbbVie Inc[/TD]
[TD="class: xl63, bgcolor: transparent"]ABBV[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G3:L3)[/TD]
[TD="class: xl69, bgcolor: transparent"]3[/TD]
[TD="class: xl69, bgcolor: transparent"]61.8[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M3)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N3)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O3)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P3)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q3)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R3)[/TD]
[TD="class: xl69, bgcolor: transparent"]16.88[/TD]
[TD="class: xl69, bgcolor: transparent"]21.3[/TD]
[TD="class: xl69, bgcolor: transparent"]4.57[/TD]
[TD="class: xl69, bgcolor: transparent"]14.6[/TD]
[TD="class: xl69, bgcolor: transparent"]250.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.7[/TD]
[TD="class: xl70, bgcolor: transparent"]0803 - Biotechnology & Drugs[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Agilent Technologies Inc.[/TD]
[TD="class: xl63, bgcolor: transparent"]A[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G4:L4)[/TD]
[TD="class: xl69, bgcolor: transparent"]0.9[/TD]
[TD="class: xl69, bgcolor: transparent"]24[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M4)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N4)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O4)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P4)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q4)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R4)[/TD]
[TD="class: xl69, bgcolor: transparent"]3.41[/TD]
[TD="class: xl69, bgcolor: transparent"]28.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.79[/TD]
[TD="class: xl69, bgcolor: transparent"]14.1[/TD]
[TD="class: xl69, bgcolor: transparent"]288.2[/TD]
[TD="class: xl69, bgcolor: transparent"]2.4[/TD]
[TD="class: xl70, bgcolor: transparent"]1024 - Electronic Instruments & Controls[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Allstate Corporation, The[/TD]
[TD="class: xl63, bgcolor: transparent"]ALL[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G5:L5)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl69, bgcolor: transparent"]20.5[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M5)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N5)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O5)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P5)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q5)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R5)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.26[/TD]
[TD="class: xl69, bgcolor: transparent"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]0.76[/TD]
[TD="class: xl69, bgcolor: transparent"]7.8[/TD]
[TD="class: xl69, bgcolor: transparent"]117.7[/TD]
[TD="class: xl69, bgcolor: transparent"]9.1[/TD]
[TD="class: xl70, bgcolor: transparent"]0715 - Insurance (Property & Casualty)[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Aon PLC[/TD]
[TD="class: xl63, bgcolor: transparent"]AON[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G6:L6)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.2[/TD]
[TD="class: xl69, bgcolor: transparent"]18.8[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M6)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N6)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O6)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P6)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q6)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R6)[/TD]
[TD="class: xl69, bgcolor: transparent"]3.36[/TD]
[TD="class: xl69, bgcolor: transparent"]21.6[/TD]
[TD="class: xl69, bgcolor: transparent"]2.18[/TD]
[TD="class: xl69, bgcolor: transparent"]17.6[/TD]
[TD="class: xl69, bgcolor: transparent"]173.4[/TD]
[TD="class: xl69, bgcolor: transparent"]6[/TD]
[TD="class: xl70, bgcolor: transparent"]0712 - Insurance (Miscellaneous)[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Apache Corporation[/TD]
[TD="class: xl63, bgcolor: transparent"]APA[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G7:L7)[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]27.4[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M7)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N7)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O7)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P7)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q7)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R7)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.17[/TD]
[TD="class: xl69, bgcolor: transparent"]22.7[/TD]
[TD="class: xl69, bgcolor: transparent"]2.6[/TD]
[TD="class: xl69, bgcolor: transparent"]4.9[/TD]
[TD="class: xl69, bgcolor: transparent"]134.9[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl70, bgcolor: transparent"]0609 - Oil & Gas Operations[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Apple Inc.[/TD]
[TD="class: xl63, bgcolor: transparent"]AAPL[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G8:L8)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.9[/TD]
[TD="class: xl69, bgcolor: transparent"]28.5[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M8)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N8)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O8)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P8)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q8)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R8)[/TD]
[TD="class: xl69, bgcolor: transparent"]5.04[/TD]
[TD="class: xl69, bgcolor: transparent"]16.4[/TD]
[TD="class: xl69, bgcolor: transparent"]3.42[/TD]
[TD="class: xl69, bgcolor: transparent"]9.6[/TD]
[TD="class: xl69, bgcolor: transparent"]422.2[/TD]
[TD="class: xl69, bgcolor: transparent"]8.4[/TD]
[TD="class: xl70, bgcolor: transparent"]1003 - Communications Equipment[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Applied Materials, Inc.[/TD]
[TD="class: xl63, bgcolor: transparent"]AMAT[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G9:L9)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl69, bgcolor: transparent"]55.6[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M9)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N9)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O9)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P9)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q9)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R9)[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl69, bgcolor: transparent"]31.2[/TD]
[TD="class: xl69, bgcolor: transparent"]3.17[/TD]
[TD="class: xl69, bgcolor: transparent"]14.3[/TD]
[TD="class: xl69, bgcolor: transparent"]30.4[/TD]
[TD="class: xl69, bgcolor: transparent"]0.6[/TD]
[TD="class: xl70, bgcolor: transparent"]1033 - Semiconductors[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]AT&T Inc.[/TD]
[TD="class: xl63, bgcolor: transparent"]T[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G10:L10)[/TD]
[TD="class: xl69, bgcolor: transparent"]5.3[/TD]
[TD="class: xl69, bgcolor: transparent"]53.4[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M10)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N10)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O10)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P10)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q10)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R10)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.95[/TD]
[TD="class: xl69, bgcolor: transparent"]10.1[/TD]
[TD="class: xl69, bgcolor: transparent"]1.38[/TD]
[TD="class: xl69, bgcolor: transparent"]5.1[/TD]
[TD="class: xl69, bgcolor: transparent"]26.7[/TD]
[TD="class: xl69, bgcolor: transparent"]8.6[/TD]
[TD="class: xl70, bgcolor: transparent"]0915 - Communications Services[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Automatic Data Processing[/TD]
[TD="class: xl63, bgcolor: transparent"]ADP[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G11:L11)[/TD]
[TD="class: xl69, bgcolor: transparent"]2.3[/TD]
[TD="class: xl69, bgcolor: transparent"]47.5[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M11)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N11)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O11)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P11)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q11)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R11)[/TD]
[TD="class: xl69, bgcolor: transparent"]5.98[/TD]
[TD="class: xl69, bgcolor: transparent"]26.8[/TD]
[TD="class: xl69, bgcolor: transparent"]3.27[/TD]
[TD="class: xl69, bgcolor: transparent"]12.2[/TD]
[TD="class: xl69, bgcolor: transparent"]141.5[/TD]
[TD="class: xl69, bgcolor: transparent"]3.1[/TD]
[TD="class: xl70, bgcolor: transparent"]0909 - Business Services[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Baker Hughes Incorporated[/TD]
[TD="class: xl63, bgcolor: transparent"]BHI[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G12:L12)[/TD]
[TD="class: xl69, bgcolor: transparent"]1[/TD]
[TD="class: xl69, bgcolor: transparent"]20.8[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M12)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N12)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O12)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P12)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q12)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R12)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.65[/TD]
[TD="class: xl69, bgcolor: transparent"]23.7[/TD]
[TD="class: xl69, bgcolor: transparent"]1.28[/TD]
[TD="class: xl69, bgcolor: transparent"]9.6[/TD]
[TD="class: xl69, bgcolor: transparent"]756.4[/TD]
[TD="class: xl69, bgcolor: transparent"]2.4[/TD]
[TD="class: xl70, bgcolor: transparent"]0612 - Oil Well Services & Equipment[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Bank of America Corp[/TD]
[TD="class: xl63, bgcolor: transparent"]BAC[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G13:L13)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.2[/TD]
[TD="class: xl69, bgcolor: transparent"]6.2[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M13)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N13)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O13)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P13)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q13)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R13)[/TD]
[TD="class: xl69, bgcolor: transparent"]0.76[/TD]
[TD="class: xl69, bgcolor: transparent"]26[/TD]
[TD="class: xl69, bgcolor: transparent"]3.2[/TD]
[TD="class: xl69, bgcolor: transparent"]53[/TD]
[TD="class: xl69, bgcolor: transparent"]3.3[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl70, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Bank of Nova Scotia (USA), The[/TD]
[TD="class: xl63, bgcolor: transparent"]BNS[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G14:L14)[/TD]
[TD="class: xl69, bgcolor: transparent"]3.6[/TD]
[TD="class: xl69, bgcolor: transparent"]46.1[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M14)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N14)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O14)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P14)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q14)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R14)[/TD]
[TD="class: xl69, bgcolor: transparent"]2.07[/TD]
[TD="class: xl69, bgcolor: transparent"]13.7[/TD]
[TD="class: xl69, bgcolor: transparent"]4.66[/TD]
[TD="class: xl69, bgcolor: transparent"]10.1[/TD]
[TD="class: xl69, bgcolor: transparent"]223.8[/TD]
[TD="class: xl69, bgcolor: transparent"]1.8[/TD]
[TD="class: xl70, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Blackstone Group L.P., The[/TD]
[TD="class: xl63, bgcolor: transparent"]BX[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G15:L15)[/TD]
[TD="class: xl69, bgcolor: transparent"]5.3[/TD]
[TD="class: xl69, bgcolor: transparent"]52.9[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M15)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N15)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O15)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P15)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q15)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R15)[/TD]
[TD="class: xl69, bgcolor: transparent"]2.92[/TD]
[TD="class: xl69, bgcolor: transparent"]12.4[/TD]
[TD="class: xl69, bgcolor: transparent"]2.55[/TD]
[TD="class: xl69, bgcolor: transparent"]8.5[/TD]
[TD="class: xl69, bgcolor: transparent"]35.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.4[/TD]
[TD="class: xl70, bgcolor: transparent"]0718 - Investment Services[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Bristol-Myers Squibb Co[/TD]
[TD="class: xl63, bgcolor: transparent"]BMY[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G16:L16)[/TD]
[TD="class: xl69, bgcolor: transparent"]2.9[/TD]
[TD="class: xl69, bgcolor: transparent"]87.1[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M16)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N16)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O16)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P16)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q16)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R16)[/TD]
[TD="class: xl69, bgcolor: transparent"]5.42[/TD]
[TD="class: xl69, bgcolor: transparent"]31.2[/TD]
[TD="class: xl69, bgcolor: transparent"]5.13[/TD]
[TD="class: xl69, bgcolor: transparent"]21.3[/TD]
[TD="class: xl69, bgcolor: transparent"]34.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.1[/TD]
[TD="class: xl70, bgcolor: transparent"]0803 - Biotechnology & Drugs[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Brookfield Asset Management In[/TD]
[TD="class: xl63, bgcolor: transparent"]BAM[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G17:L17)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl69, bgcolor: transparent"]15.1[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M17)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N17)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O17)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P17)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q17)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R17)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.59[/TD]
[TD="class: xl69, bgcolor: transparent"]11.2[/TD]
[TD="class: xl69, bgcolor: transparent"]1.49[/TD]
[TD="class: xl69, bgcolor: transparent"]14[/TD]
[TD="class: xl69, bgcolor: transparent"]46.3[/TD]
[TD="class: xl69, bgcolor: transparent"]1.3[/TD]
[TD="class: xl70, bgcolor: transparent"]0718 - Investment Services[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Canadian Imperial Bank of Comm[/TD]
[TD="class: xl63, bgcolor: transparent"]CM[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G18:L18)[/TD]
[TD="class: xl69, bgcolor: transparent"]3.9[/TD]
[TD="class: xl69, bgcolor: transparent"]49.4[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M18)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N18)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O18)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P18)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q18)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R18)[/TD]
[TD="class: xl69, bgcolor: transparent"]2.49[/TD]
[TD="class: xl69, bgcolor: transparent"]13.4[/TD]
[TD="class: xl69, bgcolor: transparent"]3.58[/TD]
[TD="class: xl69, bgcolor: transparent"]8.8[/TD]
[TD="class: xl69, bgcolor: transparent"]142.9[/TD]
[TD="class: xl69, bgcolor: transparent"]4.6[/TD]
[TD="class: xl70, bgcolor: transparent"]0724 - Money Center Banks[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Capital One Financial Corp.[/TD]
[TD="class: xl63, bgcolor: transparent"]COF[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"]=SUM(G19:L19)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.5[/TD]
[TD="class: xl69, bgcolor: transparent"]16.2[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($M$3:$M$100,M19)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($N$3:$N$100,N19)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($O$3:$O$100,O19)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($P$3:$P$100,P19)[/TD]
[TD="class: xl69, bgcolor: transparent"]=1-PERCENTRANK.EXC($Q$3:$Q$100,Q19)[/TD]
[TD="class: xl69, bgcolor: transparent"]=PERCENTRANK.EXC($R$3:$R$100,R19)[/TD]
[TD="class: xl69, bgcolor: transparent"]1.05[/TD]
[TD="class: xl69, bgcolor: transparent"]11.1[/TD]
[TD="class: xl69, bgcolor: transparent"]2.45[/TD]
[TD="class: xl69, bgcolor: transparent"]11.8[/TD]
[TD="class: xl69, bgcolor: transparent"]22.8[/TD]
[TD="class: xl69, bgcolor: transparent"]3.9[/TD]
[TD="class: xl70, bgcolor: transparent"]0727 - Regional Banks[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Andrew Poulsom]

Does this return what you would expect?

=MAX(1,CEILING(PERCENTRANK(D$2:D$55,D2)*10,1))

 

[Bobaree]

I think it does or is getting very close. Can it be written to do the ranking to the last row rather than a set number, and can it be set so that the highest numbers go into decile 1? Thanks for your help. The formula seems so much simpler than what I was trying to work with. Bobaree

By the way, when I try to sort the decile column from high to low or low to high, the numbers don't seem to be sorting the entire spreadsheet, but rather jumping around. Can that be fixed?

 

[Andrew Poulsom]

To reverse the order and use the last row:

=11-MAX(1,CEILING(PERCENTRANK(D$2:INDEX(D:D,MATCH(9.99999999999999E+307,D:D)),D2)*10,1))

I had no problem sorting by the column containing that formula. Make sure that you select all the data.