{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Macros","Home page","Transaction details","Fund list","Limit"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":64,"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":"Home page","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,6,2,6]]}
["2024-05-07"]
[null,null,null,null,null,null,"Offshore allocation calculator"]

{"sheet":"Transaction details","index":2,"n_rows":203,"n_cols":31,"rows_kept":203,"cut":false,"hidden":true,"merged":[[177,1,177,4],[9,6,11,6],[59,6,61,6],[84,6,86,6],[79,1,79,4],[13,6,14,6],[103,1,103,4],[104,1,104,3],[1,6,3,9],[182,6,184,6],[80,6,81,6],[129,6,130,6],[128,1,128,4],[152,1,152,4],[7,1,7,3],[153,1,153,3],[6,1,6,4],[31,1,31,3],[31,6,31,8],[55,1,55,4],[157,6,159,6],[105,6,107,6],[133,6,135,6],[178,2,178,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Error management wording:"]
[null,null,null,null,null,null,"Offshore allocation calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No funds have been selected in your current holdings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fund not found"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please input your current holdings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input incomplete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total does not add up to 100%"]
[null,"Current holdings",null,null,null,null,{"$f":"IF(N31=1,$AE$33,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total amount does not equal the amount given"]
[null,"Total amount",null,null,null,null,{"$f":"IF(N31=1,E30,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The fund you have selected is not in your account's current holdings"]
[null,"Fund name","Amount","Per cent","% Offshore",null,null,null,null,null,"Row started","Row complete check","Error check","Row acceptable","Fund number","Fund list","Fund to be removed after switch","Fund number after switch out",null,null,null,null,null,null,null,null,null,null,null,null,"Please input your fund selection"]
[1,null,null,null,{"$f":"IF(B10<>\"\",IFERROR(VLOOKUP(B10,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,{"$f":"IF(G7<>\"\",IF(E30>Offshore_exp_limit,$AE$13,$AE$14),IF(K30=0,$AE$4,$AE$5))","v":"Please input your current holdings"},null,null,null,{"$f":"IF(OR(C10<>\"\",D10<>\"\"),1,0)","v":0},{"$f":"IF(AND(B10<>\"\",C10<>\"\",D10<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C10),ISNUMBER(D10),ISNUMBER(E10)),1,0)","v":0},{"$f":"MIN(L10,M10)","v":0},{"$f":"IF(B10<>\"\",1,0)","v":0},{"$f":"IF($A10<=O$30,INDEX(B$10:B$29,MATCH($A10,O$10:O$29,0)),\"\")","v":""},{"$f":"IF(SUMIF($B$34:$B$53,P10,$D$34:$D$53)=1,1,0)","v":0},{"$f":"O10-Q10","v":0}]
[2,null,null,null,"",null,null,null,null,null,{"$f":"IF(OR(C11<>\"\",D11<>\"\"),1,0)","v":0},0,0,0,{"$f":"IF(B11<>\"\",IF(COUNTIF(B$10:B10,B11)=0,O10+1,O10),O10)","v":0},"",0,{"$f":"O11-SUM(Q$10:Q11)","v":0}]
[3,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B12<>\"\",IF(COUNTIF(B$10:B11,B12)=0,O11+1,O11),O11)","v":0},"",0,{"$f":"O12-SUM(Q$10:Q12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Limit descriptions:"]
[4,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B13<>\"\",IF(COUNTIF(B$10:B12,B13)=0,O12+1,O12),O12)","v":0},"",0,{"$f":"O13-SUM(Q$10:Q13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your account's current holdings are above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")&\", this means that your transaction cannot increase your offshore exposure\"","v":"Your account's current holdings are above the limit of 45%, this means that your transaction cannot increase your offshore exposure"}]
[5,null,null,null,"",null,{"$f":"IF($N$31=1,$AE$41,\"\")","v":""},null,null,null,0,0,0,0,{"$f":"IF(B14<>\"\",IF(COUNTIF(B$10:B13,B14)=0,O13+1,O13),O13)","v":0},"",0,{"$f":"O14-SUM(Q$10:Q14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your account's current holdings are below the limit of \"&TEXT(Offshore_exp_limit,\"0%\")&\", this means that you can increase your offshore exposure up to the limit\"","v":"Your account's current holdings are below the limit of 45%, this means that you can increase your offshore exposure up to the limit"}]
[6,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B15<>\"\",IF(COUNTIF(B$10:B14,B15)=0,O14+1,O14),O14)","v":0},"",0,{"$f":"O15-SUM(Q$10:Q15)","v":0}]
[7,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B16<>\"\",IF(COUNTIF(B$10:B15,B16)=0,O15+1,O15),O15)","v":0},"",0,{"$f":"O16-SUM(Q$10:Q16)","v":0}]
[8,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B17<>\"\",IF(COUNTIF(B$10:B16,B17)=0,O16+1,O16),O16)","v":0},"",0,{"$f":"O17-SUM(Q$10:Q17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Switch checked wording:"]
[9,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B18<>\"\",IF(COUNTIF(B$10:B17,B18)=0,O17+1,O17),O17)","v":0},"",0,{"$f":"O18-SUM(Q$10:Q18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Your switch is allowed"]
[10,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B19<>\"\",IF(COUNTIF(B$10:B18,B19)=0,O18+1,O18),O18)","v":0},"",0,{"$f":"O19-SUM(Q$10:Q19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your switch is not allowed because you are increasing your account's offshore exposure to \"&ROUND((G58-Offshore_exp_limit)*100,2)&\"% above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")","v":{"$error":"#VALUE!"}}]
[11,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B20<>\"\",IF(COUNTIF(B$10:B19,B20)=0,O19+1,O19),O19)","v":0},"",0,{"$f":"O20-SUM(Q$10:Q20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your switch is not allowed because you are increasing your account's offshore exposure by \"&ROUND((G58-G8)*100,2)&\"%\"","v":{"$error":"#VALUE!"}}]
[12,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B21<>\"\",IF(COUNTIF(B$10:B20,B21)=0,O20+1,O20),O20)","v":0},"",0,{"$f":"O21-SUM(Q$10:Q21)","v":0}]
[13,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B22<>\"\",IF(COUNTIF(B$10:B21,B22)=0,O21+1,O21),O21)","v":0},"",0,{"$f":"O22-SUM(Q$10:Q22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Rebalance checked wording:"]
[14,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B23<>\"\",IF(COUNTIF(B$10:B22,B23)=0,O22+1,O22),O22)","v":0},"",0,{"$f":"O23-SUM(Q$10:Q23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Your rebalance is allowed"]
[15,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B24<>\"\",IF(COUNTIF(B$10:B23,B24)=0,O23+1,O23),O23)","v":0},"",0,{"$f":"O24-SUM(Q$10:Q24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your rebalance is not allowed because you are increasing your account's offshore exposure to \"&ROUND((G83-Offshore_exp_limit)*100,2)&\"% above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")","v":{"$error":"#VALUE!"}}]
[16,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B25<>\"\",IF(COUNTIF(B$10:B24,B25)=0,O24+1,O24),O24)","v":0},"",0,{"$f":"O25-SUM(Q$10:Q25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your rebalance is not allowed because you are increasing your account's offshore exposure by \"&ROUND((G83-G8)*100,2)&\"%\"","v":{"$error":"#VALUE!"}}]
[17,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B26<>\"\",IF(COUNTIF(B$10:B25,B26)=0,O25+1,O25),O25)","v":0},"",0,{"$f":"O26-SUM(Q$10:Q26)","v":0}]
[18,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B27<>\"\",IF(COUNTIF(B$10:B26,B27)=0,O26+1,O26),O26)","v":0},"",0,{"$f":"O27-SUM(Q$10:Q27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Additional contribution checked wording:"]
[19,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B28<>\"\",IF(COUNTIF(B$10:B27,B28)=0,O27+1,O27),O27)","v":0},"",0,{"$f":"O28-SUM(Q$10:Q28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Your additional contribution is allowed"]
[20,null,null,null,"",null,null,null,null,null,0,0,0,0,{"$f":"IF(B29<>\"\",IF(COUNTIF(B$10:B28,B29)=0,O28+1,O28),O28)","v":0},"",0,{"$f":"O29-SUM(Q$10:Q29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your additional contribution is not allowed because you are increasing your account's offshore exposure to \"&ROUND((G132-Offshore_exp_limit)*100,2)&\"% above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")","v":{"$error":"#VALUE!"}}]
[null,"Total",{"$f":"SUM(C10:C29)","v":0},{"$f":"SUM(D10:D29)","v":0},{"$f":"SUMPRODUCT(E10:E29,D10:D29)","v":0},null,null,null,null,null,{"$f":"SUM(K10:K29)","v":0},{"$f":"SUM(L10:L29)","v":0},{"$f":"SUM(M10:M29)","v":0},{"$f":"SUM(N10:N29)","v":0},{"$f":"MAX(O10:O29)","v":0},null,{"$f":"SUM(Q10:Q29)","v":0},{"$f":"MAX(R10:R29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Your additional contribution is not allowed because you are increasing your account's offshore exposure by \"&ROUND((G132-G8)*100,2)&\"%\"","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Current holdings inputted correctly",null,null,{"$f":"IF(AND(K30=L30,L30=M30,M30=N30,MIN(K30,L30,M30,N30)<>0,D30=1,C30=E8),1,0)","v":0}]
[null,"Switch out",null,null,null,null,"Switch in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Information wording:"]
[null,"Fund name","Amount","Per cent",null,null,"Fund name","Amount","Per cent",null,"Row started","Row complete check","Error check","Row acceptable","Switch amount = 100%","More than 100% switched","Fund list after switch out","Amount in current holdings",null,"Row started","Row complete check","Error check","Row acceptable","New fund","New fund number","Fund list after switch in",null,null,null,null,"Your account's current offshore exposure is "]
[1,null,null,null,null,1,null,null,null,null,{"$f":"IF(OR(C34<>\"\",D34<>\"\"),1,0)","v":0},{"$f":"IF(AND(B34<>\"\",C34<>\"\",D34<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C34),ISNUMBER(D34)),1,0)","v":0},{"$f":"MIN(L34,M34)","v":0},{"$f":"IF(SUMIF($B$34:$B$53,B34,$D$34:$D$53)=1,1,0)","v":0},{"$f":"IF(SUMIF($B$34:$B$53,B34,$D$34:$D$53)>1,1,0)","v":0},{"$f":"IF($A10<=R$30,INDEX(B$10:B$29,MATCH($A10,R$10:R$29,0)),\"\")","v":""},{"$f":"SUMIF(Current_holdings_funds,B34,Current_holdings_amount)","v":0},null,{"$f":"IF(OR(H34<>\"\",I34<>\"\"),1,0)","v":0},{"$f":"IF(AND(G34<>\"\",H34<>\"\",I34<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(H34),ISNUMBER(I34)),1,0)","v":0},{"$f":"MIN(U34,V34)","v":0},{"$f":"IF(G34<>\"\",IF(COUNTIF($Q$34:$Q$53,G34)=0,1,0),0)","v":0},{"$f":"IF(G34<>\"\",IF(X34=1,1,0),0)","v":0},{"$f":"IF(F34<=$R$30,Q34,IF(F34-$R$30<=$Y$54,INDEX($G$34:$G$53,MATCH(F34-$R$30,$Y$34:$Y$53,0)),\"\"))","v":""},null,null,null,null,"Your account's offshore exposure after the switch is "]
[2,null,null,null,null,2,null,null,null,null,{"$f":"IF(OR(C35<>\"\",D35<>\"\"),1,0)","v":0},{"$f":"IF(AND(B35<>\"\",C35<>\"\",D35<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C35),ISNUMBER(D35)),1,0)","v":0},{"$f":"MIN(L35,M35)","v":0},{"$f":"IF(SUMIF($B$34:$B$53,B35,$D$34:$D$53)=1,1,0)","v":0},{"$f":"IF(SUMIF($B$34:$B$53,B35,$D$34:$D$53)>1,1,0)","v":0},{"$f":"IF($A11<=R$30,INDEX(B$10:B$29,MATCH($A11,R$10:R$29,0)),\"\")","v":""},0,null,{"$f":"IF(OR(H35<>\"\",I35<>\"\"),1,0)","v":0},0,{"$f":"IF(AND(ISNUMBER(H35),ISNUMBER(I35)),1,0)","v":0},{"$f":"MIN(U35,V35)","v":0},0,{"$f":"IF(G35<>\"\",IF(X35=1,Y34+1,Y34),Y34)","v":0},{"$f":"IF(F35<=$R$30,Q35,IF(F35-$R$30<=$Y$54,INDEX($G$34:$G$53,MATCH(F35-$R$30,$Y$34:$Y$53,0)),\"\"))","v":""},null,null,null,null,"Your account's offshore exposure after the rebalance is "]
[3,null,null,null,null,3,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,{"$f":"IF(F36<=$R$30,Q36,IF(F36-$R$30<=$Y$54,INDEX($G$34:$G$53,MATCH(F36-$R$30,$Y$34:$Y$53,0)),\"\"))","v":""},null,null,null,null,"Your account's offshore exposure after the additional contribution is "]
[4,null,null,null,null,4,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Your new investment's offshore exposure is"]
[5,null,null,null,null,5,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Your debit order's offshore exposure is"]
[6,null,null,null,null,6,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,""]
[7,null,null,null,null,7,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Prompt to continue:"]
[8,null,null,null,null,8,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Please scroll down to fill in the outstanding details to evaluate if the transaction is allowed"]
[9,null,null,null,null,9,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Please scroll down to fill in the switch-in details"]
[10,null,null,null,null,10,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Please scroll down to see the results of the switch"]
[11,null,null,null,null,11,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Please scroll down to see the results for the additional contribution"]
[12,null,null,null,null,12,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,""]
[13,null,null,null,null,13,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"New investment checked wording:"]
[14,null,null,null,null,14,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Your investment is allowed"]
[15,null,null,null,null,15,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,{"$f":"\"Your investment is not allowed because the offshore exposure is \"&ROUND((G156-Offshore_exp_limit)*100,2)&\"% above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")","v":{"$error":"#VALUE!"}}]
[16,null,null,null,null,16,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,""]
[17,null,null,null,null,17,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"New investment checked wording:"]
[18,null,null,null,null,18,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,"Your debit order is allowed"]
[19,null,null,null,null,19,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,"",null,null,null,null,{"$f":"\"Your debit order is not allowed because the offshore exposure is \"&ROUND((G181-Offshore_exp_limit)*100,2)&\"% above the limit of \"&TEXT(Offshore_exp_limit,\"0%\")","v":{"$error":"#VALUE!"}}]
[20,null,null,null,null,20,null,null,null,null,0,0,0,0,0,0,"",0,null,0,0,0,0,0,0,""]
[null,"Total",{"$f":"SUM(C34:C53)","v":0},{"$f":"IF(C30<>0,C54/C30,0)","v":0},null,null,"Total",{"$f":"SUM(H34:H53)","v":0},{"$f":"SUM(I34:I53)","v":0},null,{"$f":"SUM(K34:K53)","v":0},0,0,0,0,0,null,null,null,{"$f":"SUM(T34:T53)","v":0},{"$f":"SUM(U34:U53)","v":0},{"$f":"SUM(V34:V53)","v":0},{"$f":"SUM(W34:W53)","v":0},{"$f":"SUM(X34:X53)","v":0},{"$f":"MAX(Y34:Y53)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Switch in inputted correctly",null,null,{"$f":"IF(AND(K54=L54,L54=M54,M54=N54,MIN(K54,L54,M54,N54)<>0,Switch_out_total_amount<=Current_holdings_total_amount),1,0)","v":0},null,null,null,null,null,"Switch out inputted correctly",null,null,{"$f":"IF(AND(T54=U54,U54=V54,V54=W54,MIN(T54,U54,V54,W54)<>0,I54=1,H54=Switch_out_total_amount),1,0)","v":0}]
[null,"Holdings after switch"]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF(N57=1,$AE$34,\"\")","v":""},null,null,null,"Current holdings and both switch legs inputted correctly",null,null,{"$f":"IF(AND(N31=1,N55=1,P54=0,W55=1),1,0)","v":0}]
[1,{"$f":"IF(Z34=\"\",\"\",Z34)","v":""},{"$f":"IF($B58<>\"\",SUMIF($B$10:$B$29,$B58,C$10:C$29)-SUMIF($B$34:$B$53,$B58,C$34:C$53)+SUMIF($G$34:$G$53,$B58,H$34:H$53),\"\")","v":""},{"$f":"IF(B58<>\"\",IF($C$78<>0,C58/$C$78,\"\"),\"\")","v":""},{"$f":"IF(B58<>\"\",IFERROR(VLOOKUP(B58,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,{"$f":"IF(N57=1,E78,\"\")","v":""},null,null,null,"Switch allowed",null,null,{"$f":"IF($G$8>Offshore_exp_limit,IF($G$58<=$G$8,1,0),IF($G$58>Offshore_exp_limit,0,1))","v":1}]
[2,"",{"$f":"IF(B59<>\"\",SUMIF($B$10:$B$29,B59,$C$10:$C$29)-SUMIF($B$34:$B$53,B59,$C$34:$C$53)+SUMIF($G$34:$G$53,B59,$H$34:$H$53),\"\")","v":""},{"$f":"IF(B59<>\"\",IF($C$78<>0,C59/$C$78,\"\"),\"\")","v":""},""]
[3,"","","","",null,{"$f":"IF(G57<>\"\",IF($G$8>Offshore_exp_limit,IF($G$58<=$G$8,$AE$18,$AE$20),IF($G$58>Offshore_exp_limit,$AE$19,$AE$18)),$AE$5)","v":"Input incomplete"}]
[4,"","","",""]
[5,"","","",""]
[6,"","","",""]
[7,"","","",""]
[8,"","","",""]
[9,"","","",""]
[10,"","","",""]
[11,"","","",""]
[12,"","","",""]
[13,"","","",""]
[14,"","","",""]
[15,"","","",""]
[16,"","","",""]
[17,"","","",""]
[18,"","","",""]
[19,"","","",""]
[20,"","","",""]
[null,"Total",{"$f":"SUM(C58:C77)","v":0},{"$f":"SUM(D58:D77)","v":0},{"$f":"SUMPRODUCT(E58:E77,D58:D77)","v":0}]
[]
[null,"Rebalance"]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF(N103=1,$AE$35,\"\")","v":""},null,null,null,"Row started","Row complete check","Error check","Row acceptable"]
[1,null,null,null,{"$f":"IF(B82<>\"\",IFERROR(VLOOKUP(B82,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,null,null,null,null,{"$f":"IF(OR(C82<>\"\",D82<>\"\"),1,0)","v":0},{"$f":"IF(AND(B82<>\"\",C82<>\"\",D82<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C82),ISNUMBER(D82),ISNUMBER(E82)),1,0)","v":0},{"$f":"MIN(L82,M82)","v":0}]
[2,null,null,null,"",null,{"$f":"IF(N103=1,E102,\"\")","v":""},null,null,null,{"$f":"IF(OR(C83<>\"\",D83<>\"\"),1,0)","v":0},0,{"$f":"IF(AND(ISNUMBER(C83),ISNUMBER(D83),ISNUMBER(E83)),1,0)","v":0},{"$f":"MIN(L83,M83)","v":0}]
[3,null,null,null,"",null,null,null,null,null,0,0,0,0]
[4,null,null,null,"",null,{"$f":"IF(G81<>\"\",IF($G$8>Offshore_exp_limit,IF($G$83<=$G$8,$AE$23,$AE$25),IF($G$83>Offshore_exp_limit,$AE$24,$AE$23)),$AE$5)","v":"Input incomplete"},null,null,null,0,0,0,0]
[5,null,null,null,"",null,null,null,null,null,0,0,0,0]
[6,null,null,null,"",null,null,null,null,null,0,0,0,0]
[7,null,null,null,"",null,null,null,null,null,0,0,0,0]
[8,null,null,null,"",null,null,null,null,null,0,0,0,0]
[9,null,null,null,"",null,null,null,null,null,0,0,0,0]
[10,null,null,null,"",null,null,null,null,null,0,0,0,0]
[11,null,null,null,"",null,null,null,null,null,0,0,0,0]
[12,null,null,null,"",null,null,null,null,null,0,0,0,0]
[13,null,null,null,"",null,null,null,null,null,0,0,0,0]
[14,null,null,null,"",null,null,null,null,null,0,0,0,0]
[15,null,null,null,"",null,null,null,null,null,0,0,0,0]
[16,null,null,null,"",null,null,null,null,null,0,0,0,0]
[17,null,null,null,"",null,null,null,null,null,0,{"$f":"IF(AND(B98<>\"\",C98<>\"\",D98<>\"\"),1,0)","v":0},0,0]
[18,null,null,null,"",null,null,null,null,null,0,0,0,0]
[19,null,null,null,"",null,null,null,null,null,0,0,0,0]
[20,null,null,null,"",null,null,null,null,null,0,0,0,0]
[null,"Total",{"$f":"SUM(C82:C101)","v":0},{"$f":"SUM(D82:D101)","v":0},{"$f":"SUMPRODUCT(E82:E101,D82:D101)","v":0},null,null,null,null,null,{"$f":"SUM(K82:K101)","v":0},{"$f":"SUM(L82:L101)","v":0},{"$f":"SUM(M82:M101)","v":0},{"$f":"SUM(N82:N101)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Rebalance inputted correctly",null,null,{"$f":"IF(AND(K102=L102,L102=M102,M102=N102,MIN(K102,L102,M102,N102)<>0,N31=1,D102=1,C102=Current_holdings_total_amount),1,0)","v":0}]
[null,"Additional contribution",null,null,null,null,null,null,null,null,"Rebalance allowed",null,null,{"$f":"IF($G$8>Offshore_exp_limit,IF($G$83<=$G$8,1,0),IF($G$83>Offshore_exp_limit,0,1))","v":1}]
[null,"Total amount"]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF($N$128=1,$AE$44,\"\")","v":""},null,null,null,"Row started","Row complete check","Error check","Row acceptable","New fund","New fund number","Fund list after switch in"]
[1,null,null,null,{"$f":"IF(B107<>\"\",IFERROR(VLOOKUP(B107,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,null,null,null,null,{"$f":"IF(OR(C107<>\"\",D107<>\"\"),1,0)","v":0},{"$f":"IF(AND(B107<>\"\",C107<>\"\",D107<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C107),ISNUMBER(D107),ISNUMBER(E107)),1,0)","v":0},{"$f":"MIN(L107,M107)","v":0},{"$f":"IF(B107<>\"\",IF(COUNTIF($P$10:$P$29,B107)=0,1,0),0)","v":0},{"$f":"IF(B107<>\"\",IF(O107=1,1,0),0)","v":0},{"$f":"IF(A107<=$O$30,P10,IF(A107-$O$30<=$P$127,INDEX($B$107:$B$126,MATCH(A107-$O$30,$P$107:$P$126,0)),\"\"))","v":""}]
[2,null,null,null,"",null,null,null,null,null,{"$f":"IF(OR(C108<>\"\",D108<>\"\"),1,0)","v":0},0,{"$f":"IF(AND(ISNUMBER(C108),ISNUMBER(D108),ISNUMBER(E108)),1,0)","v":0},0,0,{"$f":"IF(B108<>\"\",IF(O108=1,P107+1,P107),P107)","v":0},""]
[3,null,null,null,"",null,null,null,null,null,0,0,0,0,0,{"$f":"IF(B109<>\"\",IF(O109=1,P108+1,P108),P108)","v":0},""]
[4,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[5,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[6,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[7,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[8,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[9,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[10,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[11,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[12,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[13,null,null,null,"",null,null,null,null,null,0,0,0,{"$f":"MIN(L119,M119)","v":0},0,0,""]
[14,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[15,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[16,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[17,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[18,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[19,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[20,null,null,null,"",null,null,null,null,null,0,0,0,0,0,0,""]
[null,"Total",{"$f":"SUM(C107:C126)","v":0},{"$f":"SUM(D107:D126)","v":0},{"$f":"SUMPRODUCT(E107:E126,D107:D126)","v":0},null,null,null,null,null,{"$f":"SUM(K107:K126)","v":0},{"$f":"SUM(L107:L126)","v":0},{"$f":"SUM(M107:M126)","v":0},{"$f":"SUM(N107:N126)","v":0},{"$f":"SUM(O107:O126)","v":0},{"$f":"MAX(P107:P126)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"New investment inputted correctly",null,null,{"$f":"IF(AND(K127=L127,L127=M127,M127=N127,MIN(K127,L127,M127,N127)<>0,D127=1,C127=E105),1,0)","v":0}]
[null,"Holdings after additional contribution",null,null,null,null,null,{"$f":"IF(N151=1,$AE$35,\"\")","v":""}]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF(N130=1,$AE$36,\"\")","v":""},null,null,null,"Current holdings and additional contribution inputted correctly",null,null,{"$f":"IF(AND(N31=1,N128=1),1,0)","v":0}]
[1,{"$f":"IF(Q107<>\"\",Q107,\"\")","v":""},{"$f":"IF($B131<>\"\",SUMIF($B$10:$B$29,$B131,C$10:C$29)+SUMIF($B$107:$B$126,$B131,C$107:C$126),\"\")","v":""},{"$f":"IF(B131<>\"\",IF($C$151<>0,C131/$C$151,\"\"),\"\")","v":""},{"$f":"IF(B131<>\"\",IFERROR(VLOOKUP(B131,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,null,null,null,null,"Additional contribution allowed",null,null,{"$f":"IF($G$8>Offshore_exp_limit,IF($G$132<=$G$8,1,0),IF($G$132>Offshore_exp_limit,0,1))","v":1}]
[2,{"$f":"IF(Q108<>\"\",Q108,\"\")","v":""},"",{"$f":"IF(B132<>\"\",IF($C$151<>0,C132/$C$151,\"\"),\"\")","v":""},"",null,{"$f":"IF(N130=1,E151,\"\")","v":""}]
[3,"","","",""]
[4,"","","","",null,{"$f":"IF(G130<>\"\",IF($G$8>Offshore_exp_limit,IF($G$132<=$G$8,$AE$28,$AE$30),IF($G$132>Offshore_exp_limit,$AE$29,$AE$28)),$AE$5)","v":"Input incomplete"}]
[5,"","","",""]
[6,"","","",""]
[7,"","","",""]
[8,"","","",""]
[9,"","","",""]
[10,"","","",""]
[11,"","","",""]
[12,"","","",""]
[13,"","","",""]
[14,"","","",""]
[15,"","","",""]
[16,"","","",""]
[17,"","","",""]
[18,"","","",""]
[19,"","","",""]
[20,"","","",""]
[null,"Total",{"$f":"SUM(C131:C150)","v":0},{"$f":"SUM(D131:D150)","v":0},{"$f":"SUMPRODUCT(E131:E150,D131:D150)","v":0}]
[]
[null,"New investment"]
[null,"Total amount"]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF(N177=1,$AE$37,\"\")","v":""},null,null,null,"Row started","Row complete check","Error check","Row acceptable"]
[1,null,null,null,{"$f":"IF(B156<>\"\",IFERROR(VLOOKUP(B156,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,{"$f":"IF(N177=1,E176,\"\")","v":""},null,null,null,{"$f":"IF(OR(C156<>\"\",D156<>\"\"),1,0)","v":0},{"$f":"IF(AND(B156<>\"\",C156<>\"\",D156<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C156),ISNUMBER(D156),ISNUMBER(E156)),1,0)","v":0},{"$f":"MIN(L156,M156)","v":0}]
[2,null,null,null,"",null,null,null,null,null,{"$f":"IF(OR(C157<>\"\",D157<>\"\"),1,0)","v":0},0,0,0]
[3,null,null,null,"",null,{"$f":"IF(G155<>\"\",IF(E176>Offshore_exp_limit,$AE$48,$AE$47),IF(K176=0,$AE$9,$AE$5))","v":"Please input your fund selection"},null,null,null,0,0,0,0]
[4,null,null,null,"",null,null,null,null,null,0,0,0,0]
[5,null,null,null,"",null,null,null,null,null,0,0,0,0]
[6,null,null,null,"",null,null,null,null,null,0,0,0,0]
[7,null,null,null,"",null,null,null,null,null,0,0,0,0]
[8,null,null,null,"",null,null,null,null,null,0,0,0,0]
[9,null,null,null,"",null,null,null,null,null,0,0,0,0]
[10,null,null,null,"",null,null,null,null,null,0,0,0,0]
[11,null,null,null,"",null,null,null,null,null,0,0,0,0]
[12,null,null,null,"",null,null,null,null,null,0,0,0,0]
[13,null,null,null,"",null,null,null,null,null,0,0,0,{"$f":"MIN(L168,M168)","v":0}]
[14,null,null,null,"",null,null,null,null,null,0,0,0,0]
[15,null,null,null,"",null,null,null,null,null,0,0,0,0]
[16,null,null,null,"",null,null,null,null,null,0,0,0,0]
[17,null,null,null,"",null,null,null,null,null,0,0,0,0]
[18,null,null,null,"",null,null,null,null,null,0,0,0,0]
[19,null,null,null,"",null,null,null,null,null,0,0,0,0]
[20,null,null,null,"",null,null,null,null,null,0,0,0,0]
[null,"Total",{"$f":"SUM(C156:C175)","v":0},{"$f":"SUM(D156:D175)","v":0},{"$f":"SUMPRODUCT(E156:E175,D156:D175)","v":0},null,null,null,null,null,{"$f":"SUM(K156:K175)","v":0},{"$f":"SUM(L156:L175)","v":0},{"$f":"SUM(M156:M175)","v":0},{"$f":"SUM(N156:N175)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"New investment inputted correctly",null,null,{"$f":"IF(AND(K176=L176,L176=M176,M176=N176,MIN(K176,L176,M176,N176)<>0,D176=1,C176=E154),1,0)","v":0}]
[null,"Debit order",null,null,null,null,null,null,null,null,"New investment allowed",null,null,{"$f":"IF(E176>Offshore_exp_limit,0,1)","v":1}]
[null,"Please enter the full debit order amount.","Total amount"]
[null,"Fund name","Amount","Per cent","% Offshore",null,{"$f":"IF(N202=1,$AE$38,\"\")","v":""},null,null,null,"Row started","Row complete check","Error check","Row acceptable"]
[1,null,null,null,{"$f":"IF(B181<>\"\",IFERROR(VLOOKUP(B181,Fund_exposure_table,6,FALSE),$AE$3),\"\")","v":""},null,{"$f":"IF(N202=1,E201,\"\")","v":""},null,null,null,{"$f":"IF(OR(C181<>\"\",D181<>\"\"),1,0)","v":0},{"$f":"IF(AND(B181<>\"\",C181<>\"\",D181<>\"\"),1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C181),ISNUMBER(D181),ISNUMBER(E181)),1,0)","v":0},{"$f":"MIN(L181,M181)","v":0}]
[2,null,null,null,"",null,null,null,null,null,{"$f":"IF(OR(C182<>\"\",D182<>\"\"),1,0)","v":0},0,0,0]
[3,null,null,null,"",null,{"$f":"IF(G180<>\"\",IF(E201>Offshore_exp_limit,$AE$52,$AE$51),IF(K201=0,$AE$9,$AE$5))","v":"Please input your fund selection"},null,null,null,0,0,0,0]
[4,null,null,null,"",null,null,null,null,null,0,0,0,0]
[5,null,null,null,"",null,null,null,null,null,0,0,0,0]
[6,null,null,null,"",null,null,null,null,null,0,0,0,0]
[7,null,null,null,"",null,null,null,null,null,0,0,0,0]
[8,null,null,null,"",null,null,null,null,null,0,0,0,0]
[9,null,null,null,"",null,null,null,null,null,0,0,0,0]
[10,null,null,null,"",null,null,null,null,null,0,0,0,0]
[11,null,null,null,"",null,null,null,null,null,0,0,0,0]
[12,null,null,null,"",null,null,null,null,null,0,0,0,0]
[13,null,null,null,"",null,null,null,null,null,0,0,0,0]
[14,null,null,null,"",null,null,null,null,null,0,0,0,0]
[15,null,null,null,"",null,null,null,null,null,0,0,0,0]
[16,null,null,null,"",null,null,null,null,null,0,0,0,0]
[17,null,null,null,"",null,null,null,null,null,0,0,0,0]
[18,null,null,null,"",null,null,null,null,null,0,0,0,0]
[19,null,null,null,"",null,null,null,null,null,0,0,0,0]
[20,null,null,null,"",null,null,null,null,null,0,0,0,0]
[null,"Total",{"$f":"SUM(C181:C200)","v":0},{"$f":"SUM(D181:D200)","v":0},{"$f":"SUMPRODUCT(E181:E200,D181:D200)","v":0},null,null,null,null,null,{"$f":"SUM(K181:K200)","v":0},{"$f":"SUM(L181:L200)","v":0},{"$f":"SUM(M181:M200)","v":0},{"$f":"SUM(N181:N200)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Debit order inputted correctly",null,null,{"$f":"IF(AND(K201=L201,L201=M201,M201=N201,MIN(K201,L201,M201,N201)<>0,D201=1,C201=E179),1,0)","v":0}]
[null,"This content is based on the latest information as provided by the relevant unit trust management companies, and may therefore be subject to change.",null,null,null,null,null,null,null,null,"Debit order allowed",null,null,{"$f":"IF(E201>Offshore_exp_limit,0,1)","v":1}]

{"sheet":"Fund list","index":3,"n_rows":89,"n_cols":6,"rows_kept":89,"cut":false,"hidden":true,"merged":[[4,6,4,8]]}
[]
[]
[]
["Public Funds - Intended Maximum Limits"]
["Fund name","Fund code","Regulation 28 compliant","Equity","Property","Foreign"]
["27four Shari'ah Balanced Fund of Funds (Class A4)","SBPA4",null,null,null,0.33850000000000002]
["27four Shari'ah Wealth Builder Fund","274SWBB2",null,null,null,0.34910000000000002]
["Allan Gray - Orbis Global Balanced Feeder Fund","AGGF",null,null,null,0.99280000000000002]
["Allan Gray - Orbis Global Equity Feeder Fund","AGOE",null,null,null,0.99419999999999997]
["Allan Gray - Orbis Global Optimal Fund of Funds","AGOO",null,null,null,0.99609999999999999]
["Allan Gray Balanced Fund","AGBF",null,null,null,0.36]
["Allan Gray Bond Fund","AGBD",null,null,null,0]
["Allan Gray Equity Fund","AGEF",null,null,null,0.439]
["Allan Gray Money Market Fund","AGMF",null,null,null,0]
["Allan Gray Optimal Fund","AGOF",null,null,null,0]
["Allan Gray SA Equity Fund","AGDA",null,null,null,0]
["Allan Gray Stable Fund","AGSF",null,null,null,0.28899999999999998]
["Allan Gray Tax-Free Balanced Fund","AGTBA",null,null,null,0.36]
["BCI Fundsmith Equity Feeder Fund (Class A)","BFEFA",null,null,null,0.99919999999999998]
["BCI Lindsell Train Global Equity Feeder Fund (Class A)","BLTGFA",null,null,null,0.99929999999999997]
["Camissa Balanced Fund (Class B)","KABCB",null,null,null,0.35599999999999998]
["Camissa Balanced Fund (Class C)","KABCC",null,null,null,0.35599999999999998]
["Camissa Equity Alpha Fund (Class B1)","KEAB1",null,null,null,0.1143]
["Camissa Islamic Balanced Fund (Class B)","KAICB",null,null,null,0.31059999999999999]
["Camissa Islamic Equity Fund (Class B)","KIECB",null,null,null,0.32629999999999998]
["Camissa Stable Fund (Class B)","KASCB",null,null,null,0.1358]
["Catalyst SCI Global Real Estate Feeder Fund (Class B)","CGRE",null,null,null,0.99929999999999997]
["Coronation Balanced Defensive Fund (Class P)","CBDB4",null,null,null,0.37509999999999999]
["Coronation Balanced Plus Fund (Class P)","CBFB4",null,null,null,0.45]
["Coronation Capital Plus Fund (Class P)","CCPB5",null,null,null,0.41889999999999999]
["Coronation Global Absolute Portfolio","HABS02",null,null,null,0.44940000000000002]
["Coronation Global Capital Plus [ZAR] Feeder Fund (Class P)","CGCB4",null,null,null,0.996]
["Coronation Global Emerging Markets Flexible [ZAR] Fund (Class P)","CGEMB4",null,null,null,0.97829999999999995]
["Coronation Global Emerging Markets Flexible [ZAR] Fund (Class Q)","CGEMQ",null,null,null,0.97829999999999995]
["Coronation Global Equity Select [ZAR] Feeder Fund (Class P)","CGEFP",null,null,null,0.98850000000000005]
["Coronation Global Houseview Portfolio","HOUS02",null,null,null,0.45]
["Coronation Global Managed [ZAR] Feeder Fund (Class P)","CGMB4",null,null,null,0.99550000000000005]
["Coronation Global Optimum Growth [ZAR] Feeder Fund (Class P)","COGFB4",null,null,null,0.99370000000000003]
["Coronation Global Optimum Growth [ZAR] Feeder Fund (Class Q)","COGFQ",null,null,null,0.99370000000000003]
["Coronation Global Strategic USD Income [ZAR] Feeder Fund (Class P)","CGSIF",null,null,null,0.97970000000000002]
["Coronation Inflation Plus Portfolio","INFL02",null,null,null,0.4078]
["Coronation Market Plus Fund (Class P)","CMPL4",null,null,null,0.47910000000000003]
["Coronation Strategic Income Fund (Class P)","CSIB4",null,null,null,0.1087]
["Coronation Top 20 Fund (Class P)","CTTB4",null,null,null,0]
["Coronation Top 20 Fund (Class Q)","CTTQ",null,null,null,0]
["Fairtree Equity Prescient Fund (Class P1)","FEPP1",null,null,null,0]
["Fairtree Equity Prescient Fund (Class P2)","FEFP2",null,null,null,0]
["Foord Balanced Fund (Class B2)","FBCB2",null,null,null,0.41909999999999997]
["Foord Balanced Fund (Class B3)","FBCB3",null,null,null,0.41909999999999997]
["Foord Balanced Fund (Class B4)","FOCB4",null,null,null,0.41909999999999997]
["Foord Conservative Fund (Class B3)","FCFB3",null,null,null,0.37319999999999998]
["Foord Flexible Fund of Funds (Class B2)","FFCB2",null,null,null,0.54120000000000001]
["Foord Flexible Fund of Funds (Class B4)","FUFB4",null,null,null,0.54120000000000001]
["Foord International Feeder Fund (Class B2)","FIFB2",null,null,null,1]
["M&G Balanced Fund (Class B)","PRAB",null,null,null,0.33100000000000002]
["M&G Balanced Fund (Pension)","AGUBAL",null,null,null,0.33750000000000002]
["M&G Balanced Fund (Provident)","APRBAL",null,null,null,0.33750000000000002]
["M&G Equity Fund (Class B)","PEFB",null,null,null,0.216]
["M&G Equity Fund (Class F)","PEFCF",null,null,null,0.224]
["M&G Inflation Plus Fund (Class B)","PRCB",null,null,null,0.22700000000000001]
["Mazi Asset Management Prime Equity Fund (Class B2)","MCEFB2",null,null,null,0]
["Nedgroup Investments Balanced Fund (Class G)","TMBFG",null,null,null,0.2833]
["Nedgroup Investments Core Diversified Fund (Class B2)","NICDF",null,null,null,0.41210000000000002]
["Nedgroup Investments Core Global Feeder Fund (Class A)","NIGFCA",null,null,null,0.98719999999999997]
["Nedgroup Investments Core Guarded Fund (Class B2)","NICGF",null,null,null,0.28670000000000001]
["Nedgroup Investments Flexible Income Fund (Class B1)","NEIFB",null,null,null,0.17380000000000001]
["Nedgroup Investments Global Cautious Feeder Fund (Class B2)","NEGC",null,null,null,1]
["Nedgroup Investments Global Equity Feeder Fund (Class B2)","GEFF",null,null,null,1]
["Nedgroup Investments Global Flexible Feeder Fund (Class B2)","NEIG",null,null,null,1]
["Nedgroup Investments Opportunity Fund (Class B2)","NIOB",null,null,null,0.2356]
["Nedgroup Investments Stable Fund (Class A2)","NISA",null,null,null,0.45]
["Ninety One Cautious Managed Fund (Class H)","CMFH",null,null,null,0.254]
["Ninety One Diversified Income Fund (Class H)","IDICH",null,null,null,0.123]
["Ninety One Equity Fund (Class E)","EQTE",null,null,null,0.40500000000000003]
["Ninety One Global Franchise Feeder Fund (Class H)","GLOH",null,null,null,0.99299999999999999]
["Ninety One Global Strategic Managed Feeder Fund (Class H)","GBFH",null,null,null,0.98399999999999999]
["Ninety One Managed Fund (Class E)","MTBTE",null,null,null,0.45]
["Ninety One Opportunity Fund (Class E)","OPPE",null,null,null,0.39400000000000002]
["Old Mutual Global Equity Fund (Class B1)","OMGB1",null,null,null,0.9768]
["Perpetua SCI Equity Fund (Class E)","PMECE",null,null,null,0]
["Prescient Balanced Fund (Class A2)","PRBA2",null,null,null,0.44829999999999998]
["Prescient Income Provider Fund (Class A2)","PIPFB5",null,null,null,1.95E-2]
["PSG Balanced Fund (Class E)","PBFE",null,null,null,0.32200000000000001]
["PSG Equity Fund (Class E)","PEFE",null,null,null,0.32400000000000001]
["PSG Flexible Fund (Class E)","PFFE",null,null,null,0.36599999999999999]
["Rezco Value Trend Fund (Class C1)","RVTC1",null,null,null,0.45]
["Satrix ALSI Index Fund (Class B2)","SLIB2",null,null,null,0]
["Satrix MSCI World Index Fund (Class B2)","SWEB2",null,null,null,0.996]
["Sesfikile BCI Property Fund (Class B2)","SSPB2",null,null,null,0]

{"sheet":"Limit","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Offshore exposure limit",0.45]