Spreadsheet: 345830d1410938066-large-function-adjusted-for-filtered-subtotals-excel-problem-1
Sheet: Sheet1

 | General Information | Metrics | Past Year Ret.
Company Name | Data Year - Fiscal | Market [NAME] | Returns |  | Rank
AAR CORP | 1988 | 500.28125 | NA
AAR CORP | 1989 | 341.7425 | -0.32
AAR CORP | 1990 | 224.460375 | -0.3352941176470588
AAR CORP | 1991 | 204.699625 | -0.08849557522123894
AAR CORP | 1992 | 214.6635 | 0.04854368932038835
AAR CORP | 1993 | 228.64875 | 0.06481481481481481
AAR CORP | 1994 | 243.40525 | 0.06086956521739131
AAR CORP | 1995 | 353.95575 | 0.4508196721311475
AAR CORP | 1996 | 564.3240000000001 | 0.4011299435028249
AAR CORP | 1997 | 732.4245 | -0.1471774193548387
AAR CORP | 1998 | 540.77475 | -0.2529550827423168
AAR CORP | 1999 | 372.751875 | -0.2974683544303797
AAR CORP | 2000 | 377.118 | 0.009009009009009009
AAR CORP | 2001 | 364.5928 | -0.1828571428571429
AAR CORP | 2002 | 143.3295 | -0.6066433566433567
AAR CORP | 2003 | 308.9071 | 1.128888888888889
AAR CORP | 2004 | 522.67944 | 0.674321503131524
AAR CORP | 2005 | 882.62832 | 0.5012468827930174
AAR CORP | 2006 | 1226.1925 | 0.3496677740863788
AAR CORP | 2007 | 747.5434400000001 | -0.4067692307692307
AAR CORP | 2008 | 571.5948 | -0.2375518672199171
AAR CORP | 2009 | 777.8348 | 0.3401360544217687
AAR CORP | 2010 | 1049.82059 | 0.3395939086294417
AAR CORP | 2011 | 485.2896500000001 | -0.5433876468359227
AAR CORP | 2012 | 790.0029199999999 | 0.6647302904564313
AAR CORP | 2013 | 961.3080000000001 | 0.2113659022931207
ASA GOLD AND PRECIOUS METALS | 1989 | 540 | NA
ASA GOLD AND PRECIOUS METALS | 1990 | 398.4 | -0.2622222222222222
ASA GOLD AND PRECIOUS METALS | 1991 | 482.4 | 0.2108433734939759
ASA GOLD AND PRECIOUS METALS | 1992 | 310.8 | -0.3557213930348259
ASA GOLD AND PRECIOUS METALS | 1993 | 439.2 | 0.4131274131274131
ASA GOLD AND PRECIOUS METALS | 1994 | 418.8 | -0.04644808743169399
ASA GOLD AND PRECIOUS METALS | 1995 | 374.4 | -0.1060171919770774
ASA GOLD AND PRECIOUS METALS | 1996 | 361.2 | -0.03525641025641026
ASA GOLD AND PRECIOUS METALS | 1997 | 199.2 | -0.4485049833887043
ASA GOLD AND PRECIOUS METALS | 1998 | 183.6 | -0.0783132530120482
ASA GOLD AND PRECIOUS METALS | 1999 | 183.6 | 0
ASA GOLD AND PRECIOUS METALS | 2000 | 139.8 | -0.238562091503268
ASA GOLD AND PRECIOUS METALS | 2001 | 190.368 | 0.3617167381974248
ASA GOLD AND PRECIOUS METALS | 2002 | 288.576 | 0.5158850226928896
ASA GOLD AND PRECIOUS METALS | 2003 | 452.7359999999999 | 0.5688622754491017
ASA GOLD AND PRECIOUS METALS | 2004 | 430.272 | -0.04961832061068695
ASA GOLD AND PRECIOUS METALS | 2005 | 476.64 | 0.107764390896921
ASA GOLD AND PRECIOUS METALS | 2006 | 616.4159999999999 | 0.2932527693856998
ASA GOLD AND PRECIOUS METALS | 2007 | 703.1999999999999 | 0.1407880392462234
ASA GOLD AND PRECIOUS METALS | 2008 | 304.2 | -0.4232081911262799
ASA GOLD AND PRECIOUS METALS | 2009 | 515.484 | 0.8828402366863904
ASA GOLD AND PRECIOUS METALS | 2010 | 657.8496000000001 | -0.5746071653048397
ASA GOLD AND PRECIOUS METALS | 2011 | 556.7094 | -0.147163120567376
ASA GOLD AND PRECIOUS METALS | 2012 | 424.38 | -0.2376992376992377
ASA GOLD AND PRECIOUS METALS | 2013 | 246.5262 | -0.4190909090909091
AVX CORP | 1989 | 406.669375 | NA
AVX CORP | 1995 | 1925 | NA
AVX CORP | 1996 | 1837 | -0.04571428571428571
AVX CORP | 1997 | 1774.703 | -0.03592814371257485
AVX CORP | 1998 | 1380.08 | -0.2049689440993789
AVX CORP | 1999 | 6614.337375 | 3.73828125
AVX CORP | 2000 | 3015.35652 | -0.7723330585325638
AVX CORP | 2001 | 3657.77826 | 0.2132097334878331
AVX CORP | 2002 | 1563.849 | -0.5702005730659025
AVX CORP | 2003 | 2863.45552 | 0.8322222222222221
AVX CORP | 2004 | 2118.69875 | -0.2571255306246209
AVX CORP | 2005 | 3048.2232 | 0.4448979591836734
AVX CORP | 2006 | 2609.4448 | -0.1412429378531073
AVX CORP | 2007 | 2191.35546 | -0.1572368421052631
AVX CORP | 2008 | 1547.08672 | -0.2911787665886027
AVX CORP | 2009 | 2415.0508 | 0.5638766519823788
AVX CORP | 2010 | 2536.81722 | 0.05000000000000007
AVX CORP | 2011 | 2248.90926 | -0.1106639839034205
AVX CORP | 2012 | 2006.7327 | -0.1025641025641025
AVX CORP | 2013 | 2217.15278 | 0.107563025210084
PINNACLE WEST CAPITAL CORP | 1989 | 964.8045000000001 | NA
PINNACLE WEST CAPITAL CORP | 1990 | 868.73 | -0.101123595505618
PINNACLE WEST CAPITAL CORP | 1991 | 1511.79875 | 0.7375
PINNACLE WEST CAPITAL CORP | 1992 | 1775.92575 | 0.1726618705035971
PINNACLE WEST CAPITAL CORP | 1993 | 1956.112 | 0.09815950920245399
PINNACLE WEST CAPITAL CORP | 1994 | 1715.81375 | -0.1229050279329609
PINNACLE WEST CAPITAL CORP | 1995 | 2516.085 | 0.464968152866242
PINNACLE WEST CAPITAL CORP | 1996 | 2778.633 | 0.1043478260869565
PINNACLE WEST CAPITAL CORP | 1997 | 3594.459375 | 0.3346456692913386
PINNACLE WEST CAPITAL CORP | 1998 | 3594.459375 | 0
PINNACLE WEST CAPITAL CORP | 1999 | 2592.4640625 | -0.2787610619469026
PINNACLE WEST CAPITAL CORP | 2000 | 4039.790625 | 0.558282208588957
PINNACLE WEST CAPITAL CORP | 2001 | 3549.92625 | -0.121259842519685
PINNACLE WEST CAPITAL CORP | 2002 | 3110.88295 | -0.1854241338112305
PINNACLE WEST CAPITAL CORP | 2003 | 3653.34576 | 0.1739513053681431
PINNACLE WEST CAPITAL CORP | 2004 | 4076.52713 | 0.1096951524237879
PINNACLE WEST CAPITAL CORP | 2005 | 4096.00695 | -0.0689034001351046
PINNACLE WEST CAPITAL CORP | 2006 | 5066.92171 | 0.2258766626360338
PINNACLE WEST CAPITAL CORP | 2007 | 4261.61126 | -0.1633458275794042
PINNACLE WEST CAPITAL CORP | 2008 | 3241.53144 | -0.2423956614006129
PINNACLE WEST CAPITAL CORP | 2009 | 3710.4923 | 0.1384998443821972
PINNACLE WEST CAPITAL CORP | 2010 | 4508.5165 | 0.1331328594860581
PINNACLE WEST CAPITAL CORP | 2011 | 5263.47228 | 0.1623642943305186
PINNACLE WEST CAPITAL CORP | 2012 | 5594.69814 | 0.05811540058115395
PINNACLE WEST CAPITAL CORP | 2013 | 5830.83144 | 0.03805413887799147
AARON'S INC | 1988 | 49.0455 | NA
AARON'S INC | 1989 | 53.7445 | 0.119047619047619
AARON'S INC | 1990 | 40.1565 | -0.1914893617021277
AARON'S INC | 1991 | 58.16250000000001 | 0.4473684210526316
AARON'S INC | 1992 | 84.47 | -0.2727272727272727
AARON'S INC | 1993 | 105.4625 | 0.25
AARON'S INC | 1994 | 135.025 | 0.1
AARON'S INC | 1995 | 173.484 | 0.3090909090909091
AARON'S INC | 1996 | 233.91375 | -0.3402777777777778
AARON'S INC | 1997 | 367.136875 | 0.631578947368421
AARON'S INC | 1998 | 310.803625 | -0.2193548387096774
AARON'S INC | 1999 | 353.63325 | 0.1735537190082645
AARON'S INC | 2000 | 279.421875 | -0.2077464788732394
AARON'S INC | 2001 | 325.511 | 0.1591111111111112
AARON'S INC | 2002 | 475.1242 | 0.3423312883435581
AARON'S INC | 2003 | 659.7607499999999 | -0.07998171846435101
AARON'S INC | 2004 | 1244.025 | 0.2419274714356682
AARON'S INC | 2005 | 1054.56916 | -0.1568000000000001
AARON'S INC | 2006 | 1558.12042 | 0.3652751423149907
AARON'S INC | 2007 | 1031.39868 | -0.3314801945795692
AARON'S INC | 2008 | 1428.163 | 0.3835758835758837
AARON'S INC | 2009 | 1504.01974 | 0.04169797145003754
AARON'S INC | 2010 | 1632.97393 | -0.2646952758745041
AARON'S INC | 2011 | 2018.0752 | 0.308484551250613