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:\Users\CHRIS~1.CAR\AppData\Local\Temp\Engine_12312_47a78ea8feba416c8555f9ce3f4f384e_\Engine_11852_dfe8903d498f4b7d84f54a4bccb214f9_.yxdb
Single
Profile
C:\Users\CHRIS~1.CAR\AppData\Local\Temp\Engine_12312_47a78ea8feba416c8555f9ce3f4f384e_\Engine_11852_c37dc24541a14308aef90b4f44c6ec44_.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
A - FBLI
32
47.5
9.5
8
6
6868.3
A - TVG
10
54.5
20
13.5
44
48.5
39
48
48
10874.3
A - AFBI
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
1757.5
A - FMFA
71.5
71.5
54.5
26.5
42.5
15
28378.5
A - AFB
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
4728.1000000000004
A - FBTS
38.5
74
53
53.5
52
68
70.5
12831.3
A - FBW
43
51
57
59.5
60.5
60
52
55.5
31
18396.2
A - TIHA
94.5
90.5
93
91
82
80.5
81
69.5
48
Taxable - R6 shares
6868.3
6R - TVG
8
49
8.5
3.5
24
22.5
22.5
1110.0999999999999
6R - FBLI
33
49.5
3.5
6
5.5
10874.3
6R - AFBI
7.5
11.5
3.5
9
11.5
44.5
48
1757.5
6R - FMFA
27
55
29
11.5
16
5
28378.5
6R - AFB
29
32.5
22.5
22.5
28
34.5
40
4728.1000000000004
6R - FBTS
33.5
69
40
29
35
52.5
59
12831.3
6R - FBW
21.5
48.5
52
53
54.5
55.5
44.5
18396.2
6R - TIHA
94
90
92
89
78.5
69
69.5
Tax-Exempt - A shares
10475.1
A - FBET
79
26.5
28.5
20.5
26
18
22.5
23.5
22
726.2
A - XETS
60
19.5
38
34
64
46.5
51.5
3601.6
A - MIHA
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
3183.1
A - XETL
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
1661.9
A - ACFET
59.5
64
61
43
56
33
32.5
32.5
37
155.69999999999999
A - YNFET
16.5
38
78
60.5
65
44
314.39999999999998
A - DMFET
77
48
65.5
64
61.5
34
36
60
54.5
468
A - AVFET
86
48.5
72.5
71.5
54
43
42
45.5
44
Tax-Exempt - F2 shares
10475.1
2F - FBET
79
25.5
25.5
16
21.5
13
17.5
726.2
2F - XETS
60
18.5
35.5
30.5
59
43.5
48.5
3183.1
2F - XETL
82
84
53
31.5
80
64.5
71
3601.6
2F - MIHA
33.5
35.5
42.5
33.5
46
8
11.5
1661.9
2F - ACFET
58.5
61
58
34.5
49.5
28
29.5
155.69999999999999
2F - YNFET
15.5
36
73.5
51
50.5
41
314.39999999999998
2F - DMFET
75.5
45
61
58
55.5
29.5
26.5
468
2F - AVFET
84
46
69
66.5
48.5
34.5
35.5
AFIS - Class 1
3218.1
1 - TVGIV
344.8
1 - FMIV
2528.5
1 - FBGIV
9957.7999999999993
1 - FBIV
1987.9
1 - BIHIV
Internally launched
28.311739679999999
FOSGC
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
50.452931479999997
FBC
65
28.5
31.5
16.000000000000004
13.999999999999996
44.678267649999995
IHG
91
97
96
93.5
99
August 11, 2015
Taxable - A shares
A - FBLI
1110.0999999999999
32
47.5
9.5
8
6
August 11, 2015
Taxable - A shares
A - TVG
6868.3
10
54.5
20
13.5
44
48.5
39
48
48
August 11, 2015
Taxable - A shares
A - AFBI
10874.3
10
13.5
6.5
20.5
27
63.5
63
68.5
69.5
August 11, 2015
Taxable - A shares
A - FMFA
1757.5
71.5
71.5
54.5
26.5
42.5
15
August 11, 2015
Taxable - A shares
A - AFB
28378.5
30.5
38.5
30.5
40.5
44
52
56.5
83
75.5
August 11, 2015
Taxable - A shares
A - FBTS
4728.1000000000004
38.5
74
53
53.5
52
68
70.5
August 11, 2015
Taxable - A shares
A - FBW
12831.3
43
51
57
59.5
60.5
60
52
55.5
31
August 11, 2015
Taxable - A shares
A - TIHA
18396.2
94.5
90.5
93
91
82
80.5
81
69.5
48
August 11, 2015
Taxable - R6 shares
6R - TVG
6868.3
8
49
8.5
3.5
24
22.5
22.5
August 11, 2015
Taxable - R6 shares
6R - FBLI
1110.0999999999999
33
49.5
3.5
6
5.5
August 11, 2015
Taxable - R6 shares
6R - AFBI
10874.3
7.5
11.5
3.5
9
11.5
44.5
48
August 11, 2015
Taxable - R6 shares
6R - FMFA
1757.5
27
55
29
11.5
16
5
August 11, 2015
Taxable - R6 shares
6R - AFB
28378.5
29
32.5
22.5
22.5
28
34.5
40
August 11, 2015
Taxable - R6 shares
6R - FBTS
4728.1000000000004
33.5
69
40
29
35
52.5
59
August 11, 2015
Taxable - R6 shares
6R - FBW
12831.3
21.5
48.5
52
53
54.5
55.5
44.5
August 11, 2015
Taxable - R6 shares
6R - TIHA
18396.2
94
90
92
89
78.5
69
69.5
August 11, 2015
Tax-Exempt - A shares
A - FBET
10475.1
79
26.5
28.5
20.5
26
18
22.5
23.5
22
August 11, 2015
Tax-Exempt - A shares
A - XETS
726.2
60
19.5
38
34
64
46.5
51.5
August 11, 2015
Tax-Exempt - A shares
A - MIHA
3601.6
34
39
45.5
39.5
51.5
12
16.5
20.5
27.5
August 11, 2015
Tax-Exempt - A shares
A - XETL
3183.1
83
85.5
58.5
40.5
85.5
72
75.5
74.5
82
August 11, 2015
Tax-Exempt - A shares
A - ACFET
1661.9
59.5
64
61
43
56
33
32.5
32.5
37
August 11, 2015
Tax-Exempt - A shares
A - YNFET
155.69999999999999
16.5
38
78
60.5
65
44
August 11, 2015
Tax-Exempt - A shares
A - DMFET
314.39999999999998
77
48
65.5
64
61.5
34
36
60
54.5
August 11, 2015
Tax-Exempt - A shares
A - AVFET
468
86
48.5
72.5
71.5
54
43
42
45.5
44
August 11, 2015
Tax-Exempt - F2 shares
2F - FBET
10475.1
79
25.5
25.5
16
21.5
13
17.5
August 11, 2015
Tax-Exempt - F2 shares
2F - XETS
726.2
60
18.5
35.5
30.5
59
43.5
48.5
August 11, 2015
Tax-Exempt - F2 shares
2F - XETL
3183.1
82
84
53
31.5
80
64.5
71
August 11, 2015
Tax-Exempt - F2 shares
2F - MIHA
3601.6
33.5
35.5
42.5
33.5
46
8
11.5
August 11, 2015
Tax-Exempt - F2 shares
2F - ACFET
1661.9
58.5
61
58
34.5
49.5
28
29.5
August 11, 2015
Tax-Exempt - F2 shares
2F - YNFET
155.69999999999999
15.5
36
73.5
51
50.5
41
August 11, 2015
Tax-Exempt - F2 shares
2F - DMFET
314.39999999999998
75.5
45
61
58
55.5
29.5
26.5
August 11, 2015
Tax-Exempt - F2 shares
2F - AVFET
468
84
46
69
66.5
48.5
34.5
35.5
August 11, 2015
AFIS - Class 1
1 - TVGIV
3218.1
August 11, 2015
AFIS - Class 1
1 - FMIV
344.8
August 11, 2015
AFIS - Class 1
1 - FBGIV
2528.5
August 11, 2015
AFIS - Class 1
1 - FBIV
9957.7999999999993
August 11, 2015
AFIS - Class 1
1 - BIHIV
1987.9
August 11, 2015
Internally launched
FOSGC
28.311739679999999
6
16.500000000000004
1.5000000000000013
2.0000000000000018
1.0000000000000009
August 11, 2015
Internally launched
FBC
50.452931479999997
65
28.5
31.5
16.000000000000004
13.999999999999996
August 11, 2015
Internally launched
IHG
44.678267649999995
91
97
96
93.5
99
C:\Users\CHRIS~1.CAR\AppData\Local\Temp\Engine_12312_47a78ea8feba416c8555f9ce3f4f384e_\Engine_11852_e1d7689f9c904c7e9f2bd71d4808ac35_.yxdb
Single
Profile
Append ShareClasses blank rows and exclude rows without figures
ShareClass
New Field
Int32
4
Empty
IF IsNull([ShareClass])
THEN [Row-1:ShareClass]
ELSE [ShareClass]
ENDIF
IF IsNull([ShareClass])
THEN [Row-1:ShareClass]
ELSE [ShareCl...
Simple
IsNotNull
Fund
True
fixed
2020-05-05 13:28:01
0
2020-05-05 13:28:01
2020-05-05 13:28:01
!IsNull([Fund])
Append date to rows
Error
Split out ShareClass headings and rename TNA field
ShareClass = IF IsNull([Fund]) THEN [TNA Latest
month-end ($mil)] ELSE Null() E...
Skip first 2 rows and take headings from first row & remove unwanted columns
Skip
2
Skip 1st 2
FirstRow
Warn
Extract Date
1
Date = Substring([American Funds Fixed Income Funds Daily Mstar/Lipper Blended P...
Horizontal
challenge_28_WIP_CC