Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #28
C:\ProgramData\Alteryx\Engine\Engine_8808_12313ffb4455491c9a0e185fbe8507df_\Engine_3516_3d68f340578c4c09a6461587fffb9eb3_.yxdb
Single
Profile
August 11, 2015
Taxable - A shares
ILBF - A
1110.0999999999999
32
47.5
9.5
8
6
August 11, 2015
Taxable - A shares
GVT - A
6868.3
10
54.5
20
13.5
44
48.5
39
48
48
August 11, 2015
Taxable - A shares
IBFA - A
10874.3
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
August 11, 2015
Taxable - A shares
AFMF - A
1757.5
71.5
71.5
54.5
26.5
42.5
15
August 11, 2015
Taxable - A shares
BFA - A
28378.5
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
August 11, 2015
Taxable - A shares
STBF - A
4728.1000000000004
38.5
74
53
53.5
52
68
70.5
August 11, 2015
Taxable - A shares
WBF - A
12831.3
43
51
57
59.5
60.5
60
52
55.5
31
August 11, 2015
Taxable - A shares
AHIT - A
18396.2
94.5
90.5
93
91
82
80.5
81
69.5
48
August 11, 2015
Taxable - R6 shares
GVT - R6
6868.3
8
49
8.5
3.5
24
22.5
22.5
August 11, 2015
Taxable - R6 shares
ILBF - R6
1110.0999999999999
33
49.5
3.5
6
5.5
August 11, 2015
Taxable - R6 shares
IBFA - R6
10874.3
7.5
11.5
3.5
9
11.5
44.5
48
August 11, 2015
Taxable - R6 shares
AFMF - R6
1757.5
27
55
29
11.5
16
5
August 11, 2015
Taxable - R6 shares
BFA - R6
28378.5
29
32.5
22.5
22.5
28
34.5
40
August 11, 2015
Taxable - R6 shares
STBF - R6
4728.1000000000004
33.5
69
40
29
35
52.5
59
August 11, 2015
Taxable - R6 shares
WBF - R6
12831.3
21.5
48.5
52
53
54.5
55.5
44.5
August 11, 2015
Taxable - R6 shares
AHIT - R6
18396.2
94
90
92
89
78.5
69
69.5
August 11, 2015
Tax-Exempt - A shares
TEBF - A
10475.1
79
26.5
28.5
20.5
26
18
22.5
23.5
22
August 11, 2015
Tax-Exempt - A shares
STEX - A
726.2
60
19.5
38
34
64
46.5
51.5
August 11, 2015
Tax-Exempt - A shares
AHIM - A
3601.6
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
August 11, 2015
Tax-Exempt - A shares
LTEX - A
3183.1
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
August 11, 2015
Tax-Exempt - A shares
TEFCA - A
1661.9
59.5
64
61
43
56
33
32.5
32.5
37
August 11, 2015
Tax-Exempt - A shares
TEFNY - A
155.69999999999999
16.5
38
78
60.5
65
44
August 11, 2015
Tax-Exempt - A shares
TEFMD - A
314.39999999999998
77
48
65.5
64
61.5
34
36
60
54.5
August 11, 2015
Tax-Exempt - A shares
TEFVA - A
468
86
48.5
72.5
71.5
54
43
42
45.5
44
August 11, 2015
Tax-Exempt - F2 shares
TEBF - F2
10475.1
79
25.5
25.5
16
21.5
13
17.5
August 11, 2015
Tax-Exempt - F2 shares
STEX - F2
726.2
60
18.5
35.5
30.5
59
43.5
48.5
August 11, 2015
Tax-Exempt - F2 shares
LTEX - F2
3183.1
82
84
53
31.5
80
64.5
71
August 11, 2015
Tax-Exempt - F2 shares
AHIM - F2
3601.6
33.5
35.5
42.5
33.5
46
8
11.5
August 11, 2015
Tax-Exempt - F2 shares
TEFCA - F2
1661.9
58.5
61
58
34.5
49.5
28
29.5
August 11, 2015
Tax-Exempt - F2 shares
TEFNY - F2
155.69999999999999
15.5
36
73.5
51
50.5
41
August 11, 2015
Tax-Exempt - F2 shares
TEFMD - F2
314.39999999999998
75.5
45
61
58
55.5
29.5
26.5
August 11, 2015
Tax-Exempt - F2 shares
TEFVA - F2
468
84
46
69
66.5
48.5
34.5
35.5
August 11, 2015
AFIS - Class 1
VIGVT - 1
3218.1
August 11, 2015
AFIS - Class 1
VIMF - 1
344.8
August 11, 2015
AFIS - Class 1
VIGBF - 1
2528.5
August 11, 2015
AFIS - Class 1
VIBF - 1
9957.7999999999993
August 11, 2015
AFIS - Class 1
VIHIB - 1
1987.9
August 11, 2015
Internally launched
CGSOF
28.311739679999999
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
August 11, 2015
Internally launched
CBF
50.452931479999997
65
28.5
31.5
16.000000000000004
13.999999999999996
August 11, 2015
Internally launched
GHI
44.678267649999995
91
97
96
93.5
99
C:\ProgramData\Alteryx\Engine\Engine_8808_12313ffb4455491c9a0e185fbe8507df_\Engine_3516_fa5e768c5e334efa94e1e606212038a7_.yxdb
Single
Profile
Ranks as of August 11, 2015
TNA Latest
month-end ($mil)
Fund
1 day
1 month
3 month
Y-T-D
1 yr
3 yrs
5 yrs
10 yrs
15 yrs
Taxable - A shares
1110.0999999999999
ILBF - A
32
47.5
9.5
8
6
6868.3
GVT - A
10
54.5
20
13.5
44
48.5
39
48
48
10874.3
IBFA - A
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
1757.5
AFMF - A
71.5
71.5
54.5
26.5
42.5
15
28378.5
BFA - A
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
4728.1000000000004
STBF - A
38.5
74
53
53.5
52
68
70.5
12831.3
WBF - A
43
51
57
59.5
60.5
60
52
55.5
31
18396.2
AHIT - A
94.5
90.5
93
91
82
80.5
81
69.5
48
Taxable - R6 shares
6868.3
GVT - R6
8
49
8.5
3.5
24
22.5
22.5
1110.0999999999999
ILBF - R6
33
49.5
3.5
6
5.5
10874.3
IBFA - R6
7.5
11.5
3.5
9
11.5
44.5
48
1757.5
AFMF - R6
27
55
29
11.5
16
5
28378.5
BFA - R6
29
32.5
22.5
22.5
28
34.5
40
4728.1000000000004
STBF - R6
33.5
69
40
29
35
52.5
59
12831.3
WBF - R6
21.5
48.5
52
53
54.5
55.5
44.5
18396.2
AHIT - R6
94
90
92
89
78.5
69
69.5
Tax-Exempt - A shares
10475.1
TEBF - A
79
26.5
28.5
20.5
26
18
22.5
23.5
22
726.2
STEX - A
60
19.5
38
34
64
46.5
51.5
3601.6
AHIM - A
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
3183.1
LTEX - A
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
1661.9
TEFCA - A
59.5
64
61
43
56
33
32.5
32.5
37
155.69999999999999
TEFNY - A
16.5
38
78
60.5
65
44
314.39999999999998
TEFMD - A
77
48
65.5
64
61.5
34
36
60
54.5
468
TEFVA - A
86
48.5
72.5
71.5
54
43
42
45.5
44
Tax-Exempt - F2 shares
10475.1
TEBF - F2
79
25.5
25.5
16
21.5
13
17.5
726.2
STEX - F2
60
18.5
35.5
30.5
59
43.5
48.5
3183.1
LTEX - F2
82
84
53
31.5
80
64.5
71
3601.6
AHIM - F2
33.5
35.5
42.5
33.5
46
8
11.5
1661.9
TEFCA - F2
58.5
61
58
34.5
49.5
28
29.5
155.69999999999999
TEFNY - F2
15.5
36
73.5
51
50.5
41
314.39999999999998
TEFMD - F2
75.5
45
61
58
55.5
29.5
26.5
468
TEFVA - F2
84
46
69
66.5
48.5
34.5
35.5
AFIS - Class 1
3218.1
VIGVT - 1
344.8
VIMF - 1
2528.5
VIGBF - 1
9957.7999999999993
VIBF - 1
1987.9
VIHIB - 1
Internally launched
28.311739679999999
CGSOF
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
50.452931479999997
CBF
65
28.5
31.5
16.000000000000004
13.999999999999996
44.678267649999995
GHI
91
97
96
93.5
99
1
American Funds Fixed Income Funds Daily Mstar/Lipper Blended Percent Ranks = Rep...
American Funds Fixed Income Funds Daily Mstar/Lipper Blended Percent Ranks
Month dd, yyyy
Ranks as of
Convert American Funds Fixed Income Funds Daily Mstar/Lipper Blended Percent Ranks From:
Month dd, yyyy
3+
test TNA = if IsNull([F2]) then Null() else [test TNA] endif
TNA2 = if IsNull([t...
TNA
ShareClass
V_WString
42
NULL
if IsNull([TNA2]) then [Row-1:ShareClass] else [TNA2] endif
if IsNull([TNA2]) then [Row-1:ShareClass] else [TNA2] endif
FirstRow
Warn
Simple
Fund
IsNotNull
!IsNull([Fund])
Error
C:\ProgramData\Alteryx\Engine\Engine_8808_12313ffb4455491c9a0e185fbe8507df_\Engine_3516_ff2d770c8734458f88538cac42dccf78_.yxdb
Single
Profile
Horizontal
challenge_28_start_file - RWvL