Spreadsheet: 63156d1264096900-excel-2007-conditional-formatting-with-subtotals-subtotals
Sheet: Summary

 |  | Contribution
Sector | Security | ACCT | BNCH | Diff
Grand Total |  | 1.464763305559357 | 0.8624383159850268 | 0.6023249895743306
B Total |  | 0.1099363892428036 | 0 | 0.1099363892428036
B | A | 0.0008401455891419426 | 0 | 0.0008401455891419426
B | A | 0.005971825923658629 | 0 | 0.005971825923658629
B | A | 7.59672976675182e-05 | 0 | 7.59672976675182e-05
B | A | 0.008758441471967516 | 0 | 0.008758441471967516
B | A | 0.0926551470057371 | 0 | 0.0926551470057371
B | A | 0.000815156957376548 | 0 | 0.000815156957376548
B | A | 0.0008197049972543989 | 0 | 0.0008197049972543989
C Total |  | 0.09121832468204921 | 0.04506330529469595 | 0.04615501938735327
C | A | 0 | 0.0006241470486235645 | -0.0006241470486235645
C | A | -0.02565361843863131 | 0.02800758794443934 | -0.05366120638307065
C | A | 0.1168719431206805 | 0 | 0.1168719431206805
C | A | 0 | 0.0001426404749248364 | -0.0001426404749248364
C | A | 0 | 0.008733044857343183 | -0.008733044857343183
C | A | 0 | 0.001757235340975839 | -0.001757235340975839
C | A | 0 | -0.0020237603583165 | 0.0020237603583165
C | A | 0 | 0.007822409986705681 | -0.007822409986705681
D Total |  | 0.01513673805747824 | 0.1094461649237902 | -0.09430942686631193
D | A | 0 | 0.0007415009540025651 | -0.0007415009540025651
D | A | 0 | 0.003441183300774898 | -0.003441183300774898
D | A | 0.01306114969931696 | 0 | 0.01306114969931696
D | A | 0 | 0.02303134032355772 | -0.02303134032355772
D | A | 0.00207558835816128 | 0.00645951221847711 | -0.00438392386031583
D | A | 0 | 0.01199302102785703 | -0.01199302102785703
D | A | 0 | 0.003412499747603171 | -0.003412499747603171
D | A | 0 | 0.02983029247369437 | -0.02983029247369437
D | A | 0 | 0.0305368148778233 | -0.0305368148778233
E Total |  | 0.1906719835494157 | 0.1827810511745496 | 0.00789093237486617
E | A | 0 | 0.003716943832796703 | -0.003716943832796703
E | A | 0 | 0.02300575892292902 | -0.02300575892292902
E | A | 0 | 0.005418467783372642 | -0.005418467783372642
E | A | 0.1906719835494157 | 0.114148867235774 | 0.07652311631364173
E | A | 0 | 0.03649101339967719 | -0.03649101339967719
F Total |  | 0.5729084346484203 | 0.2589437582207434 | 0.3139646764276769
F | A | 0 | 0.0007355975592498396 | -0.0007355975592498396
F | A | 0 | 0.004916135681138063 | -0.004916135681138063
F | A | 0 | 0.002709575464788526 | -0.002709575464788526
F | A | 0 | 0.0003763742411423282 | -0.0003763742411423282
F | A | 0.1717380940756594 | 0.06224559769728088 | 0.1094924963783785
F | A | -0.007917687333718438 | -0.00178707355291907 | -0.006130613780799368
F | A | 0.1503035618712211 | 0.1027717695790682 | 0.0475317922921529
F | A | 0.02626170072583611 | 0.06656729267637787 | -0.04030559195054177
F | A | 0.001400186108369993 | 0 | 0.001400186108369993
F | A | 0 | 0.01428995625336653 | -0.01428995625336653
F | A | 0.2311225792010523 | 0.005877030233622742 | 0.2252455489674295
F | A | 0 | 0.000241502387627579 | -0.000241502387627579
G Total |  | 0.4848914353791904 | 0.2662040363712478 | 0.2186873990079424
G | A | 0.1266271875766286 | 0.03771206023057361 | 0.088915127346055
G | A | 0.02401472228671643 | 0.06743303936859175 | -0.04341831708187532
G | A | 0 | 0.0120806297812223 | -0.0120806297812223
G | A | 0.329443987873772 | 0.06479294438377053 | 0.2646510434900015
G | A | 0 | 0.009961100603239162 | -0.009961100603239162
G | A | 0 | 0.01737817361017266 | -0.01737817361017266
G | A | 0 | 0.01269371559927424 | -0.01269371559927424
G | A | 0.004805537642073305 | 0 | 0.004805537642073305
G | A | 0 | 0.00555807956431168 | -0.00555807956431168
G | A | 0 | 0.01458551661021361 | -0.01458551661021361
G | A | 0 | 0.003277937061197085 | -0.003277937061197085
G | A | 0 | 0.0186560390254913 | -0.0186560390254913
G | A | 0 | 0.002074800533189947 | -0.002074800533189947