Spreadsheet: 113443d1309353488-dynamic-ranking-formula-w-multiple-criteria-sample-file
Sheet: Net Book Value Data

Dollars
 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00
16 | 817.7685962499999 | 812.3810864999998 | 806.9935767499996
27.85185185185185 | 793.4901164999998 | 789.4950247499997 | 785.4999329999996
67.85185185185185 | 229.03499175 | 228.0573982499999 | 227.07980475
82.66666666666667 | 269.3037504999999 | 266.7116147499999 | 264.1194789999998
116.4444444444444 | 260.221987 | 258.854881 | 257.487775
122.6666666666667 | 262.8567704999999 | 261.5619192499998 | 260.2670679999999
126.8148148148148 | 174.53119675 | 174.4791075 | 174.42701825
132.1481481481482 | 337.376127 | 331.2818482499999 | 325.1875694999999
165.037037037037 | 460.03135875 | 457.5933945 | 455.1554302499999
176.8888888888889 | 458.3161517499998 | 455.9219997499998 | 453.5278477499998
3426.37037037037 | 100.17152425 | 99.003607 | 97.83568975000001
3426.666666666667 | 86.13673174999995 | 85.43230199999995 | 84.72787224999993
3427.851851851852 | 109.7142527499999 | 108.4519737499999 | 107.1896947499999
7003.259259259259 | 121.3709694999999 | 120.1305859999999 | 118.8902024999999
7048.296296296297 | 123.5438720000001 | 123.5425485000001 | 123.5412250000001
7055.111111111111 | 160.111106673913 | 155.9415962173913 | 151.7720857608695
7118.518518518518 | 0 | 0 | 0
7118.814814814815 | 14.49242950000002 | 13.01174575000002 | 11.53106200000002
7119.111111111111 | 0 | 0 | 0
7120 | 112.72506475 | 112.09284 | 111.46061525
7138.666666666667 | 134.8727400000001 | 133.3064695000001 | 131.7401990000001
7139.851851851852 | 129.32441275 | 127.8600524999999 | 126.3956922499999
7180.444444444444 | 159.7012382500001 | 156.1444235000001 | 152.5876087500001
7197.62962962963 | 216.5004149999998 | 215.5369187499998 | 214.5734224999998
7199.703703703703 | 145.8871645000001 | 145.2630317500001 | 144.6388990000001
7244.148148148148 | 175.72676375 | 173.59364175 | 171.46051975
7246.222222222223 | 433.7883867334779 | 431.6129834779707 | 429.4375802224634
7247.407407407408 | 97.32302674687797 | 97.26105605859746 | 97.19908537031696
7278.814814814815 | 471.9801864999997 | 470.0133097499997 | 468.0464329999997
7279.111111111111 | 420.3324692499999 | 418.6992077499999 | 417.0659462499999
7320.592592592592 | 208.23072375 | 206.65889225 | 205.08706075
7323.259259259259 | 0 | 0 | 0
7330.962962962963 | 152.4425454999999 | 151.0289242499999 | 149.6153029999999
7343.703703703703 | 154.1330380000001 | 152.9191337500001 | 151.7052295000001
7344 | 98.27274175000007 | 97.95636175000007 | 97.63998175000008
7344.296296296297 | 48.09285750000002 | 47.59990250000003 | 47.10694750000003
7345.185185185185 | 190.3087930000001 | 187.5162142500001 | 184.7236355000001
7345.481481481482 | 0 | 0 | 0
7347.555555555556 | 0 | 0 | 0
7368.296296296297 | 553.6537994788133 | 550.0178340550844 | 546.3818686313555
7370.37037037037 | 0 | 0 | 0
7372.148148148148 | 32.21613575000002 | 32.07455175000002 | 31.93296775000002
7384 | 155.87852725 | 154.617876 | 153.35722475
7384.296296296297 | -6.750000000000001e-06 | -6.750000000000001e-06 | -6.750000000000001e-06
7394.074074074074 | 422.2629832499999 | 421.0777054999999 | 419.8924277499999
7410.37037037037 | 160.3826024999999 | 159.7960577499999 | 159.2095129999999
7410.666666666667 | 136.5888305 | 135.885261 | 135.1816915
7416.888888888889 | 175.54560775 | 174.9134745 | 174.28134125
7424.296296296297 | 176.5689957500001 | 175.3731115000001 | 174.1772272500001
7438.222222222223 | 214.0812725000001 | 212.9116345000001 | 211.7419965000001
7438.518518518518 | 217.9768807500001 | 215.9139317500001 | 213.8509827500001
7442.666666666667 | 133.02551175 | 132.4703027500001 | 131.9150937500001
7455.111111111111 | 164.7015835 | 162.452128 | 160.2026725
7456.296296296297 | 115.1160080000001 | 114.8239587500001 | 114.5319095000001
7517.333333333333 | 250.2603017500001 | 248.2943915000001 | 246.3284812500001
7533.333333333333 | 146.30564775 | 144.3287835 | 142.35191925
7533.62962962963 | 130.6655032499999 | 130.5740667499999 | 130.4826302499999
7565.925925925926 | 650.8779443789194 | 752.5553238668736 | 746.1523621048276
7627.555555555556 | 142.40787425 | 138.6977914999999 | 134.9877087499999
7780.740740740741 | 817.9448205462135 | 841.3337839130229 | 864.8754380716364
7786.37037037037 | 235.3435902499999 | 232.5242985 | 229.7050067499999
7789.925925925926 | 277.0240250000001 | 275.1774482500001 | 273.3308715000001
7791.111111111111 | 211.1136310000001 | 209.0279165000001 | 206.9422020000001
7793.777777777777 | 199.22443675 | 198.19270875 | 197.16098075
7794.962962962963 | 286.5265782500002 | 283.4786672500002 | 280.4307562500002
7795.259259259259 | 259.5775425 | 256.61438875 | 253.651235
7828.740740740741 | 98.18250575 | 98.18021425 | 98.17792275000001
8079.111111111111 | 169.35237975 | 168.1937365 | 167.03509325
8079.407407407408 | 106.6336887499999 | 106.5442034999999 | 106.4547182499999
8084.444444444444 | 268.0523854999999 | 265.3331789999999 | 265.6278379352691
8091.851851851852 | 735.0642574999996 | 729.5548847499995 | 724.0455119999993
8111.407407407408 | 648.5280827499997 | 644.2377837499997 | 639.9474847499996
8111.703703703703 | 656.28670875 | 651.7452482499999 | 647.20378775
8134.814814814815 | 220.994862 | 219.8790682499999 | 218.7632744999999
8135.407407407408 | 224.1184982112625 | 222.9572228655568 | 221.7959475198511
8135.703703703703 | 260.8980334999999 | 259.7209029999999 | 342.4355273499999
8136 | 330.14319975 | 328.477454 | 326.81170825
8136.296296296297 | 317.7291177500001 | 316.1750402500001 | 314.62096275
8137.185185185185 | 266.7059457500001 | 265.3698747500001 | 264.0338037500001
8138.666666666667 | 684.77286575 | 679.891767 | 675.01066825
8141.037037037037 | 684.6467207261459 | 681.0998675951823 | 677.5530144642188
8141.333333333333 | 879.6830891310536 | 875.7067579188029 | 871.7304267065521
8188.148148148148 | 248.6829225 | 247.30599475 | 245.929067
8269.333333333334 | 733.30797975 | 726.0460122499999 | 718.7840447499999
8280.592592592593 | 1430.2534605 | 1425.021807 | 1419.7901535
8309.037037037036 | 855.4219802499997 | 851.4500609999996 | 847.4781417499995
8343.407407407407 | 0 | 0 | 0
8442.962962962964 | 822.8115132499996 | 817.3955849999995 | 811.9796567499997
8443.555555555555 | 577.7964150945546 | 574.9706452769803 | 572.1448754594062
8443.851851851852 | 534.74491275 | 532.805825 | 530.86673725
8444.148148148148 | 618.2959600000002 | 614.4492960000002 | 610.6026320000002
8444.444444444445 | 619.6532592500004 | 615.8261577500004 | 611.9990562500005
9902.518518518518 | 1078.13018725 | 1073.93348525 | 1069.73678325
9902.814814814816 | 1098.78230825 | 1094.53054925 | 1090.27879025
9903.111111111111 | 1066.363272316666 | 1062.191268725 | 1058.019265133333
9903.407407407407 | 1075.30214325 | 1071.1905115 | 1067.07887975
14713.18518518518 | 40.10912400000002 | 39.58056350000002 | 39.05200300000002
14762.07407407407 | 0 | 0 | 0
14762.66666666667 | 42.93579949999999 | 42.50547999999999 | 42.07516049999999
14762.96296296296 | 43.09798699999999 | 42.62759599999999 | 42.15720499999998
15718.51851851852 | 0 | 0 | 0
15757.62962962963 | -8.25e-06 | -8.25e-06 | -8.25e-06
15757.92592592593 | -5.999999999999999e-06 | -5.999999999999999e-06 | -5.999999999999999e-06
15759.11111111111 | 97.78404324999997 | 97.35847324999996 | 96.93290324999995
15759.40740740741 | 126.21128225 | 125.53115125 | 124.85102025
15759.7037037037 | 119.223274 | 118.61516525 | 118.0070565