Spreadsheet: 50946d1250533324-multiple-if-fuction-i-guess-sample
Sheet: Sheet1

 |  | [NAME]
 |  | Quarterly: 01/1978 - 06/2009; Default Currency: USD
 |  |  |  |  |  | 0.05
 |  |  |  |  |  | -0.05
 |  | Date | 30/70 | 80/20 | Tactical Allocation | S&P 500 Index
 |  | 1978-03-01 00:00:00 | 0.01932 | 0.03576 |  | -0.0492
 |  | 1978-06-01 00:00:00 | 0.03265 | 0.08157 |  | 0.08504
 |  | 1978-09-01 00:00:00 | 0.05584 | 0.10995 |  | 0.08666
 |  | 1978-12-01 00:00:00 | -0.02405 | -0.05269 |  | -0.04934
 |  | 1979-03-01 00:00:00 | 0.04896 | 0.09219 |  | 0.07072
 |  | 1979-06-01 00:00:00 | 0.03498 | 0.03152 |  | 0.0272
 |  | 1979-09-01 00:00:00 | 0.02326 | 0.06771 |  | 0.07535
 |  | 1979-12-01 00:00:00 | -0.01476 | -0.02185 |  | 0.00129
 |  | 1980-03-01 00:00:00 | -0.05873 | -0.06015 |  | -0.04076
 |  | 1980-06-01 00:00:00 | 0.15988 | 0.16285 |  | 0.13412
 |  | 1980-09-01 00:00:00 | 0.0045 | 0.07949 |  | 0.11198
 |  | 1980-12-01 00:00:00 | 0.0206 | 0.03697 |  | 0.09454
 |  | 1981-03-01 00:00:00 | 0.03375 | 0.06616 |  | 0.01318
 |  | 1981-06-01 00:00:00 | 0.00992 | 0.01657 |  | -0.02311
 |  | 1981-09-01 00:00:00 | -0.04625 | -0.08974 |  | -0.10219
 |  | 1981-12-01 00:00:00 | 0.09225 | 0.08956 |  | 0.0701
 |  | 1982-03-01 00:00:00 | 0.00131 | -0.04422 |  | -0.07227
 |  | 1982-06-01 00:00:00 | 0.01598 | -0.01034 |  | -0.00619
 |  | 1982-09-01 00:00:00 | 0.10463 | 0.08123 |  | 0.1146
 |  | 1982-12-01 00:00:00 | 0.10803 | 0.16636 |  | 0.18142
 |  | 1983-03-01 00:00:00 | 0.06206 | 0.11096 |  | 0.10046
 |  | 1983-06-01 00:00:00 | 0.05135 | 0.10311 |  | 0.11109
 |  | 1983-09-01 00:00:00 | 0.01804 | 0.01738 |  | -0.00143
 |  | 1983-12-01 00:00:00 | 0.02151 | 0.02346 |  | 0.00343
 |  | 1984-03-01 00:00:00 | 0.02141 | 0.03151 |  | -0.02266
 |  | 1984-06-01 00:00:00 | -0.02607 | -0.04909 |  | -0.0258
 |  | 1984-09-01 00:00:00 | 0.06645 | 0.06463 |  | 0.09681
 |  | 1984-12-01 00:00:00 | 0.05588 | 0.03514 |  | 0.01758
 |  | 1985-03-01 00:00:00 | 0.04812 | 0.08889 |  | 0.09352
 |  | 1985-06-01 00:00:00 | 0.06827 | 0.06288 |  | 0.07493
 |  | 1985-09-01 00:00:00 | 0.0243 | 0.02567 |  | -0.04051
 |  | 1985-12-01 00:00:00 | 0.08165 | 0.12714 |  | 0.17189
 |  | 1986-03-01 00:00:00 | 0.09091 | 0.14913 |  | 0.14071
 |  | 1986-06-01 00:00:00 | 0.03708 | 0.06484 |  | 0.05911
 |  | 1986-09-01 00:00:00 | 0.01218 | -0.00813 |  | -0.06968
 |  | 1986-12-01 00:00:00 | 0.03028 | 0.03393 |  | 0.05404
 |  | 1987-03-01 00:00:00 | 0.07006 | 0.15955 |  | 0.21327
 |  | 1987-06-01 00:00:00 | 0.01619 | 0.05219 |  | 0.05138
 |  | 1987-09-01 00:00:00 | 0.01715 | 0.05586 |  | 0.06623
 |  | 1987-12-01 00:00:00 | -0.04315 | -0.15639 |  | -0.2263
 |  | 1988-03-01 00:00:00 | 0.06319 | 0.10846 |  | 0.05874
 |  | 1988-06-01 00:00:00 | 0.02218 | 0.04177 |  | 0.06595
 |  | 1988-09-01 00:00:00 | 0.01279 | 0.00598 |  | 0.00386
 |  | 1988-12-01 00:00:00 | 0.01899 | 0.03947 |  | 0.03104
 |  | 1989-03-01 00:00:00 | 0.0284 | 0.05603 |  | 0.07028
 |  | 1989-06-01 00:00:00 | 0.06005 | 0.05129 |  | 0.08797
 |  | 1989-09-01 00:00:00 | 0.04044 | 0.08603 |  | 0.1065
 |  | 1989-12-01 00:00:00 | 0.01832 | -0.00172 |  | 0.02054
 |  | 1990-03-01 00:00:00 | -0.01887 | -0.04672 |  | -0.03008
 |  | 1990-06-01 00:00:00 | 0.03554 | 0.03977 |  | 0.06289
 |  | 1990-09-01 00:00:00 | -0.0473 | -0.15635 |  | -0.13743
 |  | 1990-12-01 00:00:00 | 0.0403 | 0.04335 |  | 0.08964
 |  | 1991-03-01 00:00:00 | 0.07731 | 0.1608 |  | 0.14525
 |  | 1991-06-01 00:00:00 | 0.01002 | -0.00297 |  | -0.00229
 |  | 1991-09-01 00:00:00 | 0.04896 | 0.04826 |  | 0.05348
 |  | 1991-12-01 00:00:00 | 0.04246 | 0.03584 |  | 0.08384
 |  | 1992-03-01 00:00:00 | 0.00242 | 0.02266 |  | -0.02526
 |  | 1992-06-01 00:00:00 | 0.03319 | 0.01904 |  | 0.01907
 |  | 1992-09-01 00:00:00 | 0.03012 | 0.00306 |  | 0.03153
 |  | 1992-12-01 00:00:00 | 0.0094 | 0.03593 |  | 0.05036
 |  | 1993-03-01 00:00:00 | 0.06456 | 0.09646 |  | 0.04362
 |  | 1993-06-01 00:00:00 | 0.02943 | 0.03591 |  | 0.00486
 |  | 1993-09-01 00:00:00 | 0.03582 | 0.05226 |  | 0.02584
 |  | 1993-12-01 00:00:00 | 0.00681 | 0.0167 |  | 0.02317
 |  | 1994-03-01 00:00:00 | -0.01303 | 0.00681 |  | -0.03793
 |  | 1994-06-01 00:00:00 | 0.00251 | 0.01839 |  | 0.00421
 |  | 1994-09-01 00:00:00 | 0.01279 | 0.02081 |  | 0.04889
 |  | 1994-12-01 00:00:00 | -0.00783 | -0.0167 |  | -0.00015
 |  | 1995-03-01 00:00:00 | 0.05036 | 0.05959 |  | 0.09737
 |  | 1995-06-01 00:00:00 | 0.06078 | 0.06987 |  | 0.09545
 |  | 1995-09-01 00:00:00 | 0.03567 | 0.0663 |  | 0.07948
 |  | 1995-12-01 00:00:00 | 0.03445 | 0.0313 |  | 0.0602
 |  | 1996-03-01 00:00:00 | 0.00786 | 0.04376 |  | 0.05367
 |  | 1996-06-01 00:00:00 | 0.01662 | 0.03377 |  | 0.04489
 |  | 1996-09-01 00:00:00 | 0.01498 | 0.01049 |  | 0.03092
 |  | 1996-12-01 00:00:00 | 0.03702 | 0.05526 |  | 0.08335
 |  | 1997-03-01 00:00:00 | -0.00201 | 0.00035 |  | 0.02681
 |  | 1997-06-01 00:00:00 | 0.05605 | 0.11289 |  | 0.17458
 |  | 1997-09-01 00:00:00 | 0.03916 | 0.07204 |  | 0.0749
 |  | 1997-12-01 00:00:00 | 0.0006 | -0.01927 |  | 0.02872
 |  | 1998-03-01 00:00:00 | 0.05503 | 0.11886 |  | 0.1395
 |  | 1998-06-01 00:00:00 | 0.00755 | -0.00953 |  | 0.03302
 |  | 1998-09-01 00:00:00 | -0.01574 | -0.1141 |  | -0.09947
 |  | 1998-12-01 00:00:00 | 0.04814 | 0.12512 |  | 0.21297
 |  | 1999-03-01 00:00:00 | 0.00412 | 0.01741 |  | 0.04982
 |  | 1999-06-01 00:00:00 | 0.03893 | 0.10771 |  | 0.07048
 |  | 1999-09-01 00:00:00 | -0.00243 | -0.03446 |  | -0.06244
 |  | 1999-12-01 00:00:00 | 0.02566 | 0.07195 |  | 0.14879
 |  | 2000-03-01 00:00:00 | 0.01278 | 0.0096 |  | 0.02293
 |  | 2000-06-01 00:00:00 | 0.0068 | -0.00905 |  | -0.02656
 |  | 2000-09-01 00:00:00 | 0.01211 | 0.00925 |  | -0.00969
 |  | 2000-12-01 00:00:00 | 0.00872 | -0.0369 |  | -0.07824
 |  | 2001-03-01 00:00:00 | 0.00625 | -0.01677 |  | -0.11855
 |  | 2001-06-01 00:00:00 | 0.02444 | 0.05762 |  | 0.05853
 |  | 2001-09-01 00:00:00 | -0.01986 | -0.11851 |  | -0.14678
 |  | 2001-12-01 00:00:00 | 0.0338 | 0.11001 |  | 0.10685
 |  | 2002-03-01 00:00:00 | 0.00421 | 0.01495 |  | 0.00275
 |  | 2002-06-01 00:00:00 | 0.00745 | -0.06327 |  | -0.13398
 |  | 2002-09-01 00:00:00 | -0.02108 | -0.13319 |  | -0.17276
 |  | 2002-12-01 00:00:00 | 0.03265 | 0.07265 |  | 0.08436
 |  | 2003-03-01 00:00:00 | 0.00108 | -0.02672 |  | -0.03149
 |  | 2003-06-01 00:00:00 | 0.08385 | 0.19093 |  | 0.15398
 |  | 2003-09-01 00:00:00 | 0.03603 | 0.07642 |  | 0.02646
 |  | 2003-12-01 00:00:00 | 0.06591 | 0.13777 |  | 0.12176
 |  | 2004-03-01 00:00:00 | 0.0352 | 0.05256 |  | 0.01693
 |  | 2004-06-01 00:00:00 | -0.01113 | 0.00144 |  | 0.0172
 |  | 2004-09-01 00:00:00 | 0.01185 | 0.00107 |  | -0.01869
 |  | 2004-12-01 00:00:00 | 0.05576 | 0.11646 |  | 0.09231
 |  | 2005-03-01 00:00:00 | -0.01019 | -0.01499 |  | -0.02149
 |  | 2005-06-01 00:00:00 | 0.01266 | 0.01572 |  | 0.01368
 |  | 2005-09-01 00:00:00 | 0.01861 | 0.05456 |  | 0.03607
 |  | 2005-12-01 00:00:00 | 0.01099 | 0.02708 |  | 0.02088
 |  | 2006-03-01 00:00:00 | 0.02725 | 0.07058 |  | 0.04208
 |  | 2006-06-01 00:00:00 | 0.00481 | -0.00747 |  | -0.0144
 |  | 2006-09-01 00:00:00 | 0.02681 | 0.03781 |  | 0.05666
 |  | 2006-12-01 00:00:00 | 0.03553 | 0.08193 |  | 0.06699
 |  | 2007-03-01 00:00:00 | 0.01948 | 0.02382 |  | 0.0064
 |  | 2007-06-01 00:00:00 | 0.0169 | 0.0452 |  | 0.06278
 |  | 2007-09-01 00:00:00 | 0.019 | -0.00987 |  | 0.0203
 |  | 2007-12-01 00:00:00 | -0.00014 | -0.0512 |  | -0.03332
 |  | 2008-03-01 00:00:00 | 0.0088 | -0.06345 |  | -0.09447
 |  | 2008-06-01 00:00:00 | -0.031 | -0.05596 |  | -0.02722
 |  | 2008-09-01 00:00:00 | -0.02201 | -0.06063 |  | -0.08371
 |  | 2008-12-01 00:00:00 | -0.05184 | -0.21847 |  | -0.21943
 |  | 2009-03-01 00:00:00 | -0.04368 | -0.11621 |  | -0.11012
 |  | 2009-06-01 00:00:00 | 0.08592 | 0.24074 |  | 0.15928
 |  | 2009-09-09 00:00:00 | 0.03436580448495878 | 0.07205763392632536 |  | 0.08117934269418742
 |  |  | 0.02406531746031745 | 0.03108730158730159 |  | 0.02921341269841271