{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Singelfund","Tabelle2"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":30,"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":"Singelfund","index":0,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[18,11,18,12],[2,2,2,6],[19,11,19,12],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[10,11,10,12],[11,11,11,12],[12,11,12,12],[1,10,1,12],[2,10,2,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[13,11,13,12],[14,11,14,12]]}
[]
[null,"Fincancial year end:",null,{"$f":"IF(C2=\"\",\"\",\"Please enter all following data as per financial year end\")","v":""},null,null,null,null,null,"Contact person:"]
[null,"Umbrella - Fund name:",null,null,null,null,null,null,null,"E-mail:"]
[null,"Fund currency:"]
[null,{"$f":"\"Exchange CHF / \"&C4","v":"Exchange CHF / "}]
[]
[null,"Net assets:",{"$f":"IF(CURR=\"\",\"Value\",\"Value in \"&CURR)","v":"Value"}]
[]
[]
[null,"Income","Position",null,"Value","Expenses","Position",null,null,"Value","Fees","Position",null,"Value","Total income",{"$f":"E21","v":0}]
[null,1,null,null,null,1,null,null,null,null,1]
[null,2,null,null,null,2,null,null,null,null,2]
[null,3,null,null,null,3,null,null,null,null,3,null,null,null,"Total expenses",{"$f":"J21","v":0}]
[null,4,null,null,null,4,null,null,null,null,4]
[null,5,null,null,null,5,null,null,null,null,5]
[null,6,null,null,null,6,null,null,null,null,6,null,null,null,"Total fees",{"$f":"N21","v":0}]
[null,7,null,null,null,7,null,null,null,null,7,null,null,null,"1.5 % of the NAV",{"$f":"C8*0.015","v":0}]
[null,8,null,null,null,8,null,null,null,null,8,null,null,null,"Deductible fees",{"$f":"MIN(P16:P17)","v":0}]
[null,9,null,null,null,9,null,null,null,null,9]
[null,10,null,null,null,10,null,null,null,null,10]
[null,null,null,"Total income",{"$f":"SUMIF(C11:C20,\"<>\",eingIncome)","v":0},null,null,"Total expenses",null,{"$f":"SUMIF(G11:G20,\"<>\",eingExpenses)","v":0},null,null,"Total fees",{"$f":"SUMIF(L11:L20,\"<>\",eingFees)","v":0},"Taxable income",{"$f":"MAX(P10-P18-P13,0)","v":0}]
[]
[null,"Number of unit classes"]
[]
[]
[null,"Valor number","ISIN","Unit class\nname","Unit class\ncurrency","Accumulating or \nDistributing","Number of\noutstanding units","NAV / Units","NAV in share class currency","Unit class \\ \nfund currency","Exchange rate",{"$f":"\"NAV in fund currency \" & CURR","v":"NAV in fund currency "},"Unit class income",{"$f":"\"Income per unit in \"&C4","v":"Income per unit in "},"Exchange rate","Income per unit in CHF"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E28<>\"\",COUNT(G28,H28)=2,F28<>\"\",COUNTA(B28,C28)>0),G28*H28,\"\")","v":""},{"$f":"IF(AND(E28<>\"\",CURR<>\"\"),E28& \" \\ \" &CURR,\"\")","v":""},null,{"$f":"IF(AND(I28<>\"\",J28<>\"\",K28<>\"\",D28<>\"\"),I28*K28,\"\")","v":""},{"$f":"IF(L28<>\"\",TXINC/SUM(L$28:L$51)*L28,\"\")","v":""},{"$f":"IF(L28<>\"\",M28/G28,\"\")","v":""},{"$f":"IF(AND(L28<>\"\",EXCH<>\"\"),EXCH,\"\")","v":""},{"$f":"IF(O28<>\"\",N28*O28,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E29<>\"\",COUNT(G29,H29)=2,F29<>\"\",COUNTA(B29,C29)>0),G29*H29,\"\")","v":""},{"$f":"IF(AND(E29<>\"\",CURR<>\"\"),E29& \" \\ \" &CURR,\"\")","v":""},null,{"$f":"IF(AND(I29<>\"\",J29<>\"\",K29<>\"\",D29<>\"\"),I29*K29,\"\")","v":""},{"$f":"IF(L29<>\"\",TXINC/SUM(L$28:L$51)*L29,\"\")","v":""},{"$f":"IF(L29<>\"\",M29/G29,\"\")","v":""},"",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E30<>\"\",COUNT(G30,H30)=2,F30<>\"\",COUNTA(B30,C30)>0),G30*H30,\"\")","v":""},{"$f":"IF(AND(E30<>\"\",CURR<>\"\"),E30& \" \\ \" &CURR,\"\")","v":""},null,{"$f":"IF(AND(I30<>\"\",J30<>\"\",K30<>\"\",D30<>\"\"),I30*K30,\"\")","v":""},{"$f":"IF(L30<>\"\",TXINC/SUM(L$28:L$51)*L30,\"\")","v":""},{"$f":"IF(L30<>\"\",M30/G30,\"\")","v":""},"",""]
[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,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,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,"","","","",""]
[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,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,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,"","","","",""]
[null,null,null,null,null,null,null,null,"","",null,"","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,"Total NAV",{"$f":"IF(COUNT(L28:L51)=ANZKLS,SUM(L28:L51),\"\")","v":0}]
[]
[null,{"$f":"IF(COUNT(C56:C67)>0,\"Unit class name\",\"\")","v":""},{"$f":"IF(COUNT(C56:C67)>0,\"Proportion\",\"\")","v":""},null,{"$f":"IF(COUNT(F56:F67)>1,\"Unit class name\",\"\")","v":""},{"$f":"IF(COUNT(F56:F67)>1,\"Proportion\",\"\")","v":""}]

{"sheet":"Tabelle2","index":1,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Währung","Accumulating / Distributing"]
["CHF","Accumulating"]
["USD","Distributing"]
["JPY"]
["CAD"]
["GBP"]
["AUD"]
["EUR"]
["SEK"]
["DKK"]
["NOK"]
["NZD"]
["HKD"]
["SGD"]
["MYR"]
["PLN"]
["RUB"]
["BRL"]
["ILS"]
["HUF"]
["THB"]
["PHP"]
["TWD"]
["ZAR"]
["MXN"]
["IDR"]
["KRW"]
["AED"]
["CNY"]
["CZK"]
["ARS"]
["QAR"]
["BMD"]
["INR"]
["PGK"]
["KZT"]
["HNL"]
["PEN"]
["ISK"]
["CNH"]