{"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":[[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],[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]]}
[]
[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":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[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],[14,11,19,11],[3,3,3,4],[5,11,6,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],[10,6,12,11],[14,6,19,10]]}
[]
[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,null,null,{"$f":"IF(AND(E7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(E7)),E7*Total,\"\")","v":""}]
[null,null,null,"",null,null,"Equity",0.75,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),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),IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I8-H8>0.00004999,I8-H8,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I8-H8>0.00004999,K8*Total,\"\"),\"\")","v":""}]
[null,null,null,"",null,null,"Foreign",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),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),IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I9-H9>0.00004999,I9-H9,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I9-H9>0.00004999,K9*Total,\"\"),\"\")","v":""}]
[null,null,null,"",null,null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),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),IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I10-H10>0.00004999,I10-H10,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I10-H10>0.00004999,K10*Total,\"\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,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),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,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,"The total percentage amount does not add up to 100%"]
[]
[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. "]

{"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","2015-06-17"]
["equity","Equity",0.75]
["offshore","Offshore",0.25]
["prop","Property",0.25]

{"sheet":"Regulation 28 calculator (rand)","index":3,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[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],[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],[22,2,22,4]]}
[]
[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,null,null,null,{"$f":"IF(AND(D7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(D7)),D7/Total,\"\")","v":""}]
[null,null,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),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),IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I8-H8>0.00004999,I8-H8,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I8-H8>0.00004999,K8*Total,\"\"),\"\")","v":""}]
[null,null,null,null,"",null,"Foreign",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),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),IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I9-H9>0.00004999,I9-H9,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I9-H9>0.00004999,K9*Total,\"\"),\"\")","v":""}]
[null,null,null,null,"",null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),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),IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I10-H10>0.00004999,I10-H10,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IF(I10-H10>0.00004999,K10*Total,\"\"),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,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),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,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,"The total percentage amount does not add up to 100%"]
[]
[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. "]

{"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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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(ISERROR(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)),\"\",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,21,6]]}
[]
[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,{"$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":71,"n_cols":6,"rows_kept":71,"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.94,0.02,0.12]
["Allan Gray Balanced Fund","AGBF","Yes",0.61,0.02,0.24]
["Allan Gray Stable Fund","AGSF","Yes",0.28000000000000003,0.03,0.24]
["Allan Gray Optimal Fund","AGOF","No",0.04,0.01,0]
["Allan Gray Bond Fund","AGBD","Yes",0,0,0]
["Allan Gray Money Market Fund","AGMF","Yes",0,0,0]
["Allan Gray - Orbis Global Equity Feeder Fund","AGOE","No",0.95,0.03,1]
["Allan Gray - Orbis Global Fund of Funds","AGGF","No",0.48,0.04,1]
["Allan Gray - Orbis Global Optimal Fund of Funds","AGOO","No",7.0000000000000007E-2,0.03,1]
["27four Shari'ah Balanced Prescient Fund of Funds (Class A1)","27SA1","Yes",0.5,0,0.13]
["36ONE MET Equity Fund (Class A)","MNTR","No",1,0.1,0.25]
["Coronation Balanced Defensive Fund (Class A)","COBA","Yes",0.32,0.08,0.25]
["Coronation Balanced Plus Fund (Class A)","CORB","Yes",0.7,0.14000000000000001,0.25]
["Coronation Capital Plus Fund (Class A)","CCPF","Yes",0.48,0.12,0.25]
["Coronation Global Capital Plus [ZAR] Feeder Fund (Class A)","COLA","No",0.37,0.1,1]
["Coronation Global Emerging Markets Flexible [ZAR] Fund (Class A)","CGEM","No",0.98,0.01,0.91]
["Coronation Global Managed [ZAR] Feeder Fund (Class A)","COGM","No",0.67,0.09,1]
["Coronation Optimum Growth Fund (Class A)","CNOG","No",0.84,0.02,0.94]
["Coronation Strategic Income Fund (Class A)","CSIF","Yes",0.04,0.08,0.1]
["Coronation Top 20 Fund (Class A)","CNTF","No",0.95,0.06,0]
["Coronation Global Opportunities Equity [ZAR] Feeder Fund (Class A)","CNIG","No",1,0.01,1]
["Foord Balanced Fund (Class B2)","FBCB2","Yes",0.6,0.04,0.25]
["Foord Balanced Fund (Class B4)","FOCB4","Yes",0.61,0.03,0.25]
["Foord Conservative Fund (Class B2)","FCFB2","Yes",0.42,0.04,0.25]
["Foord Equity Fund (Class B2)","FECB2","No",0.89,0.02,0]
["Foord Equity Fund (Class B4)","FECB4","No",0.9,0.01,0]
["Foord Flexible Fund of Funds (Class B2)","FFCB2","No",0.69,0.03,0.66]
["Foord Flexible Fund of Funds  (Class B4)","FUFB4","No",0.9,0.2,0.7]
["Foord International Feeder Fund (Class B2)","FIFB2","No",0.64,0.04,1]
["Investec Cautious Managed Fund (Class H)","CMFH","Yes",0.33,0.04,0.25]
["Investec Diversified Income Fund (Class H)","IDICH","Yes",0.03,0.03,0.14000000000000001]
["Investec Equity Fund (Class H)","EQTH","No",0.83,0.03,0]
["Investec Equity Fund (Class E)","EQTE","No",1,0.1,0.05]
["Investec Global Franchise Feeder Fund (Class H)","GLOH","No",0.92,0,1]
["Investec Global Strategic Managed Feeder Fund (Class H)","GBFH","No",0.63,0.05,1]
["Investec Managed Fund (Class H)","MANH","Yes",0.49,0.01,0.25]
["Investec Opportunity Fund (Class E)","OPPE","Yes",0.62,0.05,0.25]
["Investec Value Fund (Class H)","VALH","No",0.86,0,0.18]
["Investec Value Fund (Class E)","VALE","No",1,0.1,0.25]
["Kagiso Islamic Balanced Fund (Class A)","KAIB","Yes",0.57999999999999996,0.08,0.25]
["Kagiso Islamic Equity Fund (Class A)","KAIE","No",0.85,0.03,0.25]
["Marriott Dividend Growth Fund (Class R)","HLMK","No",0.97,0,0.21]
["Nedgroup Investments Flexible Income Fund (Class A2)","NIFA","No",0.08,0.04,7.0000000000000007E-2]
["Nedgroup Investments Global Cautious Feeder Fund (Class B2)","NEGC","No",0.24,0,0.99]
["Nedgroup Investments Global Flexible Feeder Fund (Class R)","BOEB","No",0.52,0,0.99]
["Nedgroup Investments Global Equity Feeder Fund (Class A)","AHGV","No",0.85,0,1]
["Nedgroup Investments Opportunity Fund (Class B2)","NIOB","Yes",0.46,0.08,0.23]
["Nedgroup Investments Property Fund (Class A)","NIPCA","No",0,0.99,0]
["Nedgroup Investments Stable Fund (Class C)","NISCC","Yes",0.34,0.05,0.25]
["Nedgroup Investments Core Diversified Fund (Class B)","NIDCB","Yes",0.66,0.08,0.22]
["Nedgroup Investments Core Guarded Fund (Class B)","NICCB","Yes",0.36,0.08,0.23]
["Old Mutual Global Equity Fund (Class B1)","OMGB1","No",0.97,0,0.96]
["Prescient Income Provider Fund (Class A1)","PIPF","Yes",0,0.02,0.19]
["Prudential Balanced Fund (Class X)","PRBCX","Yes",0.66,0.02,0.23]
["Prudential Dividend Maximiser Fund (Class A)","PRUM","No",0.98,0.01,0.28999999999999998]
["Prudential Enhanced SA Property Tracker Fund (Class A)","PEPI","No",0,1,0]
["Prudential Equity Fund (Class A)","PRUO","No",0.98,0.01,0.16]
["Prudential Inflation Plus Fund (Class X)","PIPCX","Yes",0.5,0.06,0.22]
["PSG Balanced Fund (Class E)","PBFE","Yes",0.63,0,0.25]
["PSG Flexible Fund (Class A)","PSGO","No",0.7,0,0.25]
["Prescient RECM Global Feeder Fund (Class D)","PRGFD","No",0.69,0,0.94]
["Rezco Managed Plus Fund (Class C)","RPFCC","Yes",0.33,7.0000000000000007E-2,0.23]
["Rezco Value Trend Fund (Class C)","RVTCC","Yes",0.27,0.06,0.19]
["Satrix ALSI Index Fund (Class B2)","SLIB2","No",0.92,0.06,0]
["Satrix MSCI World Equity Index Feeder Fund (Class B2)","SWEB2","No",0.99,0,0.99]
["Truffle MET Flexible Fund (Class C)","TRFCC","No",0.63,0.1,0.24]