{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Macros","Regulation 28 calculator (%)","Limits","Regulation 28 calculator (rand)","Allocation","Allocation (rand)","Unit trust asset class limits","Fund list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macros","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[[37,2,44,4],[46,2,47,4],[1,2,1,5],[27,2,27,3],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[33,2,34,4],[24,2,24,4],[5,11,6,11],[10,6,12,11],[14,6,19,10],[14,11,19,11],[22,2,22,4],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10]]}
[]
[null,null,"Please enable macros"]
[]
[null,null,"1.  Excel 2007:  Click the Microsoft Office Button            , and then click Excel Options."]
[null,null,"1.  Excel 2010:  Click the File tab, and then click Options."]
[]
[null,null,"2. In the Trust Centre category, click Trust Centre Settings, and then click the Macro Settings category."]
[]
[null,null,"3. Select Enable all macros and click OK."]
[]
[null,null,"4. Close the Excel Options window."]
[]
[null,null,"5. Close and re-open the Regulation 28 Calculator."]

{"sheet":"Regulation 28 calculator (%)","index":1,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[14,11,19,11],[3,3,3,4],[5,11,6,11],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[10,6,12,11],[14,6,19,10],[21,2,21,4],[23,2,23,4],[24,2,24,4],[27,2,27,3],[37,2,44,4],[46,2,47,4],[33,2,34,4],[28,2,28,4],[30,2,30,4],[31,2,31,4],[29,2,29,4]]}
[]
[null,null,"Regulation 28 investment compliance calculator "]
[]
[null,null,"Total amount"]
[]
[null,null,"Unit trust name","Amount","%",null,"Exposure","Regulation 28 limit","Investment exposure","Regulation 28 compliant","% over limit","Rand amount over limit"]
[null,{"$f":"IF(C7<>\"\",_xlfn.IFNA(VLOOKUP(C7,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,{"$f":"IF(AND(E7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(E7)),E7*Total,\"\")","v":""}]
[null,{"$f":"IF(C8<>\"\",_xlfn.IFNA(VLOOKUP(C8,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Equity",0.75,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G8,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,I8-H8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,K8*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C9<>\"\",_xlfn.IFNA(VLOOKUP(C9,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Foreign",0.45,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G9,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,I9-H9,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,K9*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C10<>\"\",_xlfn.IFNA(VLOOKUP(C10,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G10,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,I10-H10,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,K10*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C11<>\"\",_xlfn.IFNA(VLOOKUP(C11,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C12<>\"\",_xlfn.IFNA(VLOOKUP(C12,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C13<>\"\",_xlfn.IFNA(VLOOKUP(C13,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C14<>\"\",_xlfn.IFNA(VLOOKUP(C14,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C15<>\"\",_xlfn.IFNA(VLOOKUP(C15,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Is the portfolio compliant with Regulation 28 of the Pension Funds Act?",null,null,null,null,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,C23=\"\"),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,{"$f":"IF(C16<>\"\",_xlfn.IFNA(VLOOKUP(C16,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C17<>\"\",_xlfn.IFNA(VLOOKUP(C17,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C18<>\"\",_xlfn.IFNA(VLOOKUP(C18,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C19<>\"\",_xlfn.IFNA(VLOOKUP(C19,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C20<>\"\",_xlfn.IFNA(VLOOKUP(C20,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,null,"Total",{"$f":"IF(ISERROR(SUM(AmountColumn)),\"Error\",SUM(AmountColumn))","v":0},{"$f":"IF(ISERROR(SUM(PercentColumn)),\"Error\",SUM(PercentColumn))","v":0}]
[]
[null,null,{"$f":"IF(AND(AND($E$21<>1,$D$4>0),OR(B7:B20)),\"Please ensure that your fund selection sums to 100% and only includes funds from the fund list.\",IF(OR(B7:B20),\"Please ensure that your fund selection only includes funds from the fund list.\",IF(AND($E$21<>1,$D$4>0),\"Please ensure that your fund selection sums to 100%.\",\"\")))","v":""}]
[]
[null,null,"If you would like to enter a rand amount instead of a percentage amount, please click the ‘Regulation 28 calculator (rand)’ tab at the bottom of the page."]
[]
[null,null,"How to use the Regulation 28 calculator"]
[null,null,"(Please ensure that your Calculation Options are set to Automatic)"]
[null,"• ","Enter the total rand amount of your investment in the ‘total amount’ section."]
[null,"• ","Choose your unit trust selection from the drop-down box in the ‘unit trust name’ column."]
[null,"• ","Enter the percentage of the total amount that you would like to allocate to each unit trust in the ‘%’ column."]
[null,"• ","The ‘amount’ column will automatically update based on the information entered in the ‘total amount’ and ‘%’ columns."]
[]
[null,null,"Click on the 'Unit trust asset class limits' tab at the bottom to view the Regulation 28 asset class limits of your selected unit trusts."]
[]
[]
[null,null,"Regulation 28 limits "]
[null,null,"Once your investment total adds up to 100%, your investment’s exposure to each asset class (asset allocation) will be shown under the ‘asset class’ section on the \nright-hand side of the page.\n\nYour asset allocation will then be compared to the prescribed limits of Regulation 28. If your asset allocation meets these limits, the calculator will indicate this with a ‘Yes’ on the right-hand side of the page. If your investment does not meet the prescribed limits, the calculator will indicate this with a ‘No’, and display the areas where your investment does not comply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2024-07-02T12:14:21"]

{"sheet":"Limits","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Code","ReportingDescription","Limit",null,"Last update notice","2022-02-28"]
["equity","Equity",0.75]
["offshore","Offshore",0.45]
["prop","Property",0.25]

{"sheet":"Regulation 28 calculator (rand)","index":3,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[31,2,31,4],[33,2,34,4],[46,2,47,4],[37,2,44,4],[5,7,6,7],[29,2,29,4],[30,2,30,4],[28,2,28,4],[24,2,24,4],[27,2,27,3],[3,3,3,4],[5,6,6,6],[5,11,6,11],[10,6,12,11],[14,6,19,10],[14,11,19,11],[5,9,6,9],[5,10,6,10],[5,8,6,8]]}
[]
[null,null,"Regulation 28 investment compliance calculator ",null,null,null,null,null,null,null,null,{"$f":"'Regulation 28 calculator (%)'!L2","v":0}]
[]
[null,null,"Total amount"]
[]
[null,null,"Unit trust name","Amount","%",null,"Exposure","Regulation 28 limit","Investment exposure","Regulation 28 compliant","% over limit","Rand amount over limit"]
[null,{"$f":"IF(C7<>\"\",_xlfn.IFNA(VLOOKUP(C7,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,{"$f":"IF(AND(D7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(D7)),D7/Total,\"\")","v":""}]
[null,{"$f":"IF(C8<>\"\",_xlfn.IFNA(VLOOKUP(C8,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,{"$f":"IF(AND(D8>0,C8<>\"\",ISNUMBER(Total),ISNUMBER(D8)),D8/Total,\"\")","v":""},null,"Equity",0.75,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G8,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,I8-H8,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,K8*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C9<>\"\",_xlfn.IFNA(VLOOKUP(C9,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Foreign",0.45,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G9,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,I9-H9,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,K9*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C10<>\"\",_xlfn.IFNA(VLOOKUP(C10,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G10,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,I10-H10,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,K10*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C11<>\"\",_xlfn.IFNA(VLOOKUP(C11,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C12<>\"\",_xlfn.IFNA(VLOOKUP(C12,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C13<>\"\",_xlfn.IFNA(VLOOKUP(C13,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C14<>\"\",_xlfn.IFNA(VLOOKUP(C14,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C15<>\"\",_xlfn.IFNA(VLOOKUP(C15,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Is the portfolio compliant with Regulation 28 of the Pension Funds Act?",null,null,null,null,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,C23=\"\"),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,{"$f":"IF(C16<>\"\",_xlfn.IFNA(VLOOKUP(C16,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C17<>\"\",_xlfn.IFNA(VLOOKUP(C17,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C18<>\"\",_xlfn.IFNA(VLOOKUP(C18,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C19<>\"\",_xlfn.IFNA(VLOOKUP(C19,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C20<>\"\",_xlfn.IFNA(VLOOKUP(C20,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,null,"Total",{"$f":"IF(ISERROR(SUM(AmountColumn)),\"Error\",SUM(AmountColumn))","v":0},{"$f":"IF(ISERROR(SUM(PercentColumn)),\"Error\",SUM(PercentColumn))","v":0}]
[]
[null,null,{"$f":"IF(AND(AND($E$21<>1,$D$4>0),OR(B7:B20)),\"Please ensure that your fund selection sums to 100% and only includes funds from the fund list.\",IF(OR(B7:B20),\"Please ensure that your fund selection only includes funds from the fund list.\",IF(AND($E$21<>1,$D$4>0),\"Please ensure that your fund selection sums to 100%.\",\"\")))","v":""}]
[]
[null,null,"If you would like to enter a percentage amount instead of a rand amount, please click the ‘Regulation 28 calculator (%)’ tab at the bottom of the page."]
[]
[null,null,"How to use the Regulation 28 calculator"]
[null,null,"(Please ensure that your Calculation Options are set to Automatic)"]
[null,"• ","Enter the total rand amount of your investment in the ‘total amount’ section."]
[null,"• ","Choose your unit trust selection from the drop-down box in the ‘unit trust name’ column."]
[null,"• ","Enter the rand value that you would like to allocate to each unit trust in the ‘amount’ column."]
[null,"• ","The ‘%’ column will automatically update based on the information entered in the ‘total amount’ and ‘amount’ columns."]
[]
[null,null,"Click on the 'Unit trust asset class limits' tab at the bottom to view the Regulation 28 asset class limits of your selected unit trusts."]
[]
[]
[null,null,"Regulation 28 limits "]
[null,null,"Once your investment total adds up to 100%, your investment’s exposure to each asset class (asset allocation) will be shown under the ‘asset class’ section on the \nright-hand side of the page.\n\nYour asset allocation will then be compared to the prescribed limits of Regulation 28. If your asset allocation meets these limits, the calculator will indicate this with a ‘Yes’ on the right-hand side of the page. If your investment does not meet the prescribed limits, the calculator will indicate this with a ‘No’, and display the areas where your investment does not comply.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2024-07-02T12:14:21"]

{"sheet":"Allocation","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Display name","Equity","Foreign","Property"]
["fund","equity","offshore","prop"]
[{"$f":"IF('Regulation 28 calculator (%)'!C7>\"\",'Regulation 28 calculator (%)'!C7,\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C8>\"\",'Regulation 28 calculator (%)'!C8,\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C9>\"\",'Regulation 28 calculator (%)'!C9,\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C10>\"\",'Regulation 28 calculator (%)'!C10,\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C11>\"\",'Regulation 28 calculator (%)'!C11,\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C12>\"\",'Regulation 28 calculator (%)'!C12,\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C13>\"\",'Regulation 28 calculator (%)'!C13,\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C14>\"\",'Regulation 28 calculator (%)'!C14,\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C15>\"\",'Regulation 28 calculator (%)'!C15,\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C16>\"\",'Regulation 28 calculator (%)'!C16,\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C17>\"\",'Regulation 28 calculator (%)'!C17,\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C18>\"\",'Regulation 28 calculator (%)'!C18,\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C19>\"\",'Regulation 28 calculator (%)'!C19,\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C20>\"\",'Regulation 28 calculator (%)'!C20,\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""}]
["Total",{"$f":"SUM(B3:B16)","v":0},{"$f":"SUM(C3:C16)","v":0},{"$f":"SUM(D3:D16)","v":0}]

{"sheet":"Allocation (rand)","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Display name","Equity","Foreign","Property"]
["fund","equity","offshore","prop"]
[{"$f":"IF('Regulation 28 calculator (rand)'!C7>\"\",'Regulation 28 calculator (rand)'!C7,\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C8>\"\",'Regulation 28 calculator (rand)'!C8,\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C9>\"\",'Regulation 28 calculator (rand)'!C9,\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C10>\"\",'Regulation 28 calculator (rand)'!C10,\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C11>\"\",'Regulation 28 calculator (rand)'!C11,\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C12>\"\",'Regulation 28 calculator (rand)'!C12,\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C13>\"\",'Regulation 28 calculator (rand)'!C13,\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C14>\"\",'Regulation 28 calculator (rand)'!C14,\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C15>\"\",'Regulation 28 calculator (rand)'!C15,\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C16>\"\",'Regulation 28 calculator (rand)'!C16,\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C17>\"\",'Regulation 28 calculator (rand)'!C17,\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C18>\"\",'Regulation 28 calculator (rand)'!C18,\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C19>\"\",'Regulation 28 calculator (rand)'!C19,\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C20>\"\",'Regulation 28 calculator (rand)'!C20,\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""}]
["Total",{"$f":"SUM(B3:B16)","v":0},{"$f":"SUM(C3:C16)","v":0},{"$f":"SUM(D3:D16)","v":0}]

{"sheet":"Unit trust asset class limits","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,4,2,6],[24,2,24,5],[19,2,20,4]]}
[]
[null,null,"Regulation 28 asset class limits",{"$f":"IF(CONCATENATE('Regulation 28 calculator (%)'!C7,'Regulation 28 calculator (%)'!C8,'Regulation 28 calculator (%)'!C9,'Regulation 28 calculator (%)'!C10,'Regulation 28 calculator (%)'!C11,'Regulation 28 calculator (%)'!C12,'Regulation 28 calculator (%)'!C13,'Regulation 28 calculator (%)'!C14,'Regulation 28 calculator (%)'!C15,'Regulation 28 calculator (%)'!C16,'Regulation 28 calculator (%)'!C17,'Regulation 28 calculator (%)'!C18,'Regulation 28 calculator (%)'!C19,'Regulation 28 calculator (%)'!C20)>\"\",\"percent\",IF(CONCATENATE('Regulation 28 calculator (rand)'!C7,'Regulation 28 calculator (rand)'!C8,'Regulation 28 calculator (rand)'!C9,'Regulation 28 calculator (rand)'!C10,'Regulation 28 calculator (rand)'!C11,'Regulation 28 calculator (rand)'!C12,'Regulation 28 calculator (rand)'!C13,'Regulation 28 calculator (rand)'!C14,'Regulation 28 calculator (rand)'!C15,'Regulation 28 calculator (rand)'!C16,'Regulation 28 calculator (rand)'!C17,'Regulation 28 calculator (rand)'!C18,'Regulation 28 calculator (rand)'!C19,'Regulation 28 calculator (rand)'!C20)>\"\",\"rand\",\"none\"))","v":"none"}]
[]
[null,null,"Unit trust name","Regulation 28 compliant","Equity","Property","Foreign"]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C7,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C7,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C7,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C7,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C5<>\"\",IF(VLOOKUP($C5,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C8,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C8,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C8,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C8,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C6<>\"\",IF(VLOOKUP($C6,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C9,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C9,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C9,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C9,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C7<>\"\",IF(VLOOKUP($C7,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C10,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C10,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C10,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C10,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C8<>\"\",IF(VLOOKUP($C8,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C11,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C11,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C11,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C11,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C9<>\"\",IF(VLOOKUP($C9,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C12,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C12,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C12,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C12,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C10<>\"\",IF(VLOOKUP($C10,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C13,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C13,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C13,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C13,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C11<>\"\",IF(VLOOKUP($C11,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C14,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C14,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C14,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C14,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C12<>\"\",IF(VLOOKUP($C12,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C15,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C15,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C15,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C15,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C13<>\"\",IF(VLOOKUP($C13,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C16,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C16,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C16,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C16,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C14<>\"\",IF(VLOOKUP($C14,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C17,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C17,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C17,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C17,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C15<>\"\",IF(VLOOKUP($C15,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C18,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C18,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C18,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C18,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C16<>\"\",IF(VLOOKUP($C16,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C19,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C19,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C19,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C19,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C17<>\"\",IF(VLOOKUP($C17,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C20,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C20,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C20,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C20,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C18<>\"\",IF(VLOOKUP($C18,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2024-07-02T12:14:21"]
[null,null,{"$f":"\"The above funds are those chosen in the \"&IF(D2=\"percent\",\"'Regulation 28 calculator (%)'\",\"'Regulation 28 calculator (rand)'\")&\" tab.\"","v":"The above funds are those chosen in the 'Regulation 28 calculator (rand)' tab."}]
[]
[null,null,{"$f":"\"Click on the \"&IF(D2=\"percent\",\"'Regulation 28 calculator (%)'\",\"'Regulation 28 calculator (rand)'\")&\" tab at the bottom to go back to the Regulation 28 calculator.\"","v":"Click on the 'Regulation 28 calculator (rand)' tab at the bottom to go back to the Regulation 28 calculator."}]

{"sheet":"Fund list","index":7,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[4,6,4,8]]}
[]
[]
[]
["Public Funds - Intended Maximum Limits"]
["Fund name","Fund code","Regulation 28 compliant","Equity","Property","Foreign"]
["Allan Gray Equity Fund","AGEF","No",0.96819999999999995,6.7000000000000002E-3,0.43730000000000002]
["Allan Gray Balanced Fund","AGBF","Yes",0.69299999999999995,7.0000000000000001E-3,0.38400000000000001]
["Allan Gray Stable Fund","AGSF","Yes",0.28489999999999999,9.1000000000000004E-3,0.3221,null,null,null,null," "]
["Allan Gray Money Market Fund","AGMF","Yes",0,0,0]
["Allan Gray - Orbis Global Equity Feeder Fund","AGOE","No",0.97309999999999997,0,0.99719999999999998]
["Allan Gray - Orbis Global Balanced Feeder Fund","AGGF","No",0.63849999999999996,4.7999999999999996E-3,0.99719999999999998]
["Allan Gray - Orbis Global Optimal Fund of Funds","AGOO","No",3.9399999999999998E-2,2.3400000000000001E-2,0.99809999999999999]
["Allan Gray SA Equity Fund","AGDA","No",0.97599999999999998,1.2E-2,0]
["Allan Gray Optimal Fund","AGOF","No",2.2800000000000001E-2,7.7000000000000002E-3,0]
["Allan Gray Bond Fund","AGBD","Yes",0,0,0]
["BCI Fundsmith Equity Feeder Fund (Class A)","BFEFA","No",0.99670000000000003,0,0.99909999999999999]
["Coronation Strategic Income Fund (Class P)","CSIB4","Yes",1.4E-3,2.7699999999999999E-2,0.1154]
["Coronation Balanced Defensive Fund (Class P)","CBDB4","Yes",0.41399999999999998,1.37E-2,0.36919999999999997]
["Coronation Global Equity Select [ZAR] Feeder Fund (Class P)","CGEFP","No",0.98709999999999998,0,0.99209999999999998]
["Coronation Global Managed [ZAR] Feeder Fund (Class P)","CGMB4","No",0.65749999999999997,2.4199999999999999E-2,0.99460000000000004]
["Camissa Stable Fund (Class B)","KASCB","Yes",0.316,4.4999999999999998E-2,0.13500000000000001]
["Coronation Global Optimum Growth [ZAR] Feeder Fund (Class P)","COGFB4","No",0.81399999999999995,5.0000000000000001E-3,0.99250000000000005]
["Coronation Market Plus Fund (Class P)","CMPL4","No",0.69350000000000001,6.5600000000000006E-2,0.44840000000000002]
["Camissa Balanced Fund (Class B)","KABCB","Yes",0.71699999999999997,1.4E-2,0.34699999999999998]
["Coronation Global Emerging Markets Flexible [ZAR] Fund (Class P)","CGEMB4","No",0.98419999999999996,8.9999999999999998E-4,0.97840000000000005]
["Coronation Global Strategic USD Income [ZAR] Feeder Fund (Class P)","CGSIF","No",0,1.2999999999999999E-2,0.98229999999999995]
["Ninety One Cautious Managed Fund (Class H)","CMFH","Yes",0.35299999999999998,4.0000000000000001E-3,0.23899999999999999]
["Prescient Income Provider Fund (Class A2)","PIPFB5","Yes",1.8700000000000001E-2,2.3999999999999998E-3,1.95E-2]
["27four Shari'ah Balanced Fund of Funds (Class A4)","SBPA4","Yes",0.70109999999999995,0,0.32850000000000001]
["Camissa Equity Alpha Fund (Class B1)","KEAB1","No",0.98170000000000002,1.6799999999999999E-2,0.1027]
["Camissa Islamic Equity Fund (Class B)","KIECB","No",0.89500000000000002,2E-3,0.34]
["Catalyst SCI Global Real Estate Feeder Fund (Class B)","CGRE","No",0,0.99458500000000005,0.99462899999999999]
["Fairtree Equity Prescient Fund (Class P1)","FEPP1","No",0.97189999999999999,1.7899999999999999E-2,0]
["Nedgroup Investments Opportunity Fund (Class B2)","NIOB","Yes",0.53200000000000003,4.5999999999999999E-2,0.248]
["Foord Balanced Fund (Class B2)","FBCB2","Yes",0.6865,3.85E-2,0.44040000000000001]
["Nedgroup Investments Core Global Feeder Fund (Class A)","NIGFCA","No",0.68210000000000004,6.4000000000000001E-2,0.998]
["Ninety One Global Strategic Managed Feeder Fund (Class H)","GBFH","No",0.66900000000000004,5.0000000000000001E-3,0.99]
["Prescient Balanced Fund (Class A2)","PRBA2","Yes",0.57399999999999995,4.9299999999999997E-2,0.44069999999999998]
["Foord Flexible Fund of Funds (Class B2)","FFCB2","No",0.76519999999999999,2.4299999999999999E-2,0.62860000000000005]
["Foord International Feeder Fund (Class B2)","FIFB2","No",0.56779999999999997,3.9899999999999998E-2,1]
["M&G Balanced Fund (Class B)","PRAB","Yes",0.66700000000000004,1.7999999999999999E-2,0.36699999999999999]
["Nedgroup Investments Flexible Income Fund (Class B1)","NEIFB","Yes",2.1000000000000001E-2,1.6E-2,0.14799999999999999]
["Nedgroup Investments Global Flexible Feeder Fund (Class B2)","NEIG","No",0.59450000000000003,9.2999999999999992E-3,1]
["Ninety One Diversified Income Fund (Class H)","IDICH","Yes",0,2.5999999999999999E-2,9.2999999999999999E-2]
["Ninety One Global Franchise Feeder Fund (Class H)","GLOH","No",0.98,0,0.99299999999999999]
["Ninety One Opportunity Fund (Class E)","OPPE","Yes",0.66800000000000004,1.4999999999999999E-2,0.38]
["Coronation Balanced Plus Fund (Class P)","CBFB4","Yes",0.70569999999999999,3.7900000000000003E-2,0.45]
["Coronation Capital Plus Fund (Class P)","CCPB5","Yes",0.60499999999999998,1.34E-2,0.40710000000000002]
["Coronation Top 20 Fund (Class P)","CTTB4","No",0.99819999999999998,0,0]
["Rezco Value Trend Fund (Class C1)","RVTC1","Yes",0.43580000000000002,0,0.45]
["BCI Lindsell Train Global Equity Feeder Fund (Class A)","BLTGFA","No",0.98799999999999999,0,0.99950000000000006]
["PSG Equity Fund (Class E)","PEFE","No",0.97699999999999998,1.9E-2,0.31]
["Satrix ALSI Index Fund (Class B2)","SLIB2","No",0.98909999999999998,0,0]
["Sesfikile BCI Property Fund (Class B2)","SSPB2","No",0,0.97019999999999995,0]
["Camissa Islamic Balanced Fund (Class B)","KAICB","Yes",0.63070000000000004,3.2000000000000002E-3,0.32800000000000001]
["Coronation Global Capital Plus [ZAR] Feeder Fund (Class P)","CGCB4","No",0.22889999999999999,2.81E-2,0.99609999999999999]
["M&G Inflation Plus Fund (Class B)","PRCB","Yes",0.37,0.02,0.24299999999999999]
["Nedgroup Investments Core Diversified Fund (Class B2)","NICDF","Yes",0.67589999999999995,7.2999999999999995E-2,0.39290000000000003]
["Nedgroup Investments Global Cautious Feeder Fund (Class B2)","NEGC","No",0.2,0,1]
["Nedgroup Investments Stable Fund (Class A2)","NISA","Yes",0.42799999999999999,0.05,0.45]
["Nedgroup Investments Balanced Fund (Class G)","TMBFG","Yes",0.70599999999999996,2.8000000000000001E-2,0.32300000000000001]
["Nedgroup Investments Core Guarded Fund (Class B2)","NICGF","Yes",0.35310000000000002,6.9000000000000006E-2,0.27139999999999997]
["Nedgroup Investments Global Equity Feeder Fund (Class B2)","GEFF","No",0.99370000000000003,0,1]
["Ninety One Equity Fund (Class E)","EQTE","No",0.97799999999999998,1.4999999999999999E-2,0.313]
["M&G Equity Fund (Class B)","PEFB","No",0.96399999999999997,2.1000000000000001E-2,0.23499999999999999]
["Mazi Asset Management Prime Equity Fund (Class B2)","MCEFB2","No",0.93785799999999997,6.2128999999999997E-2,1.2999999999999999E-5]
["Ninety One Managed Fund (Class E)","MTBTE","Yes",0.57799999999999996,0,0.45]
["Old Mutual Global Equity Fund (Class B1)","OMGB1","No",0.95089999999999997,0,0.95850000000000002]
["Perpetua SCI Equity Fund (Class E)","PMECE","No",0.96619999999999995,0,0]
["PSG Balanced Fund (Class E)","PBFE","Yes",0.74,3.6999999999999998E-2,0.33300000000000002]
["PSG Flexible Fund (Class E)","PFFE","No",0.91900000000000004,2.1999999999999999E-2,0.35899999999999999]
["Satrix MSCI World Index Fund (Class B2)","SWEB2","No",0.98419999999999996,8.3000000000000001E-3,0.99719999999999998]