{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Début","Portefeuille","Répartition des actifs"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Début","index":0,"n_rows":26,"n_cols":2,"rows_kept":26}
[null,"Suivi des investissements"]
[]
[]
[]
[null,"Portefeuille"]
{"$rows_empty":20}
[null,"Répartition des actifs"]

{"sheet":"Portefeuille","index":1,"n_rows":12,"n_cols":9,"rows_kept":12}
[null,"Suivi des investissements"]
[]
[null,"Portefeuille"]
[]
[null,"Société","Catégorie","Parts","Cours","Change","Change (%)","% du portefeuille","Valeur"]
[null,{"$error":"#VALUE!"},"Actions France",{"v":1200,"d":"1,200"},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":303.33,"d":"303.33 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":{"v":0.68,"d":"0.68 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":2.2470000000000003E-3,"d":"0.22%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.7826520261825781,"d":"78%"}},{"$f":"D6 * E6","v":{"v":363996,"d":"363,996.00 $"}}]
[null,{"$error":"#VALUE!"},"Obligations",{"v":1300,"d":"1,300"},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":10.95,"d":"10.95 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":{"v":0.03,"d":"0.03 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":0.002747,"d":"0.27%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.03060762094283728,"d":"3%"}},{"v":14234.999999999998,"d":"14,235.00 $"}]
[null,{"$error":"#VALUE!"},"Actions internationales",{"v":1200,"d":"1,200"},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":33.92,"d":"33.92 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":{"v":-0.03,"d":"(0.03) $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":-8.8370000000000007E-4,"d":"-0.09%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.08752037954740069,"d":"9%"}},{"v":40704,"d":"40,704.00 $"}]
[null,{"$error":"#VALUE!"},"Trésorerie",{"v":10000,"d":"10,000"},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":1,"d":"1.00 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":0},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.021501665572769432,"d":"2%"}},{"v":10000,"d":"10,000.00 $"}]
[null,{"$error":"#VALUE!"},"Immobilier",125,{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":151.49,"d":"151.49 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":{"v":-2.05,"d":"(2.05) $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":-0.013352,"d":"-1.34%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.04071609147023551,"d":"4%"}},{"v":18936.25,"d":"18,936.25 $"}]
[null,{"$error":"#VALUE!"},"Produits de base",100,{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"price\")","v":{"v":172.09,"d":"172.09 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change\")","v":{"v":2.7,"d":"2.70 $"}},{"$f":"_FV(TableauPortefeuille[[#This Row],[Société]],\"Change (%)\",TRUE)","v":{"v":0.01594,"d":"1.59%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TableauPortefeuille[Valeur]),\"\")","v":{"v":0.037002216284178914,"d":"4%"}},{"v":17209,"d":"17,209.00 $"}]
[null,"Total",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TableauPortefeuille[Valeur]), \"\")","v":{"v":465080.25,"d":"465,080.25 $"}}]

{"sheet":"Répartition des actifs","index":2,"n_rows":25,"n_cols":7,"rows_kept":25}
[null,"Suivi des investissements"]
[]
[null,"Répartition des actifs"]
{"$rows_empty":15}
[null,"Catégorie","Mon objectif","Réel","Écart","Seuil","Valeur"]
[null,"Actions France",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.7826520261825781,"d":"78%"}},{"$f":"D20 - C20","v":{"v":0.23265202618257808,"d":"23.3%"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B20, TableauPortefeuille[Valeur])","v":{"v":363996,"d":"363,996.00 $"}}]
[null,"Actions internationales",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.08752037954740069,"d":"9%"}},{"v":-0.11247962045259932,"d":"-11.2%"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B21, TableauPortefeuille[Valeur])","v":{"v":40704,"d":"40,704.00 $"}}]
[null,"Obligations",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.03060762094283728,"d":"3%"}},{"v":-0.06939237905716272,"d":"-6.9%"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B22, TableauPortefeuille[Valeur])","v":{"v":14234.999999999998,"d":"14,235.00 $"}}]
[null,"Trésorerie",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.021501665572769432,"d":"2%"}},{"v":-0.02849833442723057,"d":"-2.8%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B23, TableauPortefeuille[Valeur])","v":{"v":10000,"d":"10,000.00 $"}}]
[null,"Immobilier",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.04071609147023551,"d":"4%"}},{"v":-0.00928390852976449,"d":"-0.9%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B24, TableauPortefeuille[Valeur])","v":{"v":18936.25,"d":"18,936.25 $"}}]
[null,"Produits de base",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TableauRépartitionActifs[Valeur]),\"\")","v":{"v":0.037002216284178914,"d":"4%"}},{"v":-0.012997783715821089,"d":"-1.3%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TableauPortefeuille[Catégorie], B25, TableauPortefeuille[Valeur])","v":{"v":17209,"d":"17,209.00 $"}}]