{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Saisie","Dashboard_Allocation","DashBoard_Evol_Brut","DashBoard_Evol_Net","LOV"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":4},"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":"Saisie","index":0,"n_rows":36,"n_cols":53,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Saisissez vos investissements et vos crédits"]
[null,null,null,null,"Crédits & droits",null,null,null,"www.grainedinvestisseur.com"]
[null,"⇩ TIPS : cacher les lignes qui ne sont plus actives"]
[null,"Type","Classe d'actif","Support / type de crédit","Elément","Risque","Rendement espéré / Taux","Déblocage (liquidité)","Lien","01/01/2021","01/04/2021","01/07/2021","01/04/2022","01/07/2022","01/04/2023","01/07/2023","01/04/2024","01/07/2024","01/04/2025","01/07/2025","01/04/2026","01/07/2026","01/04/2027","01/07/2027","01/04/2028","01/07/2028","01/04/2029","01/07/2029","01/04/2030","01/07/2030","01/04/2031","01/07/2031","01/04/2032","01/07/2032","01/04/2033","01/07/2033","01/04/2034","01/07/2034","01/04/2035","01/07/2035","01/04/2036","01/07/2036","01/04/2037","01/07/2037","01/04/2038","01/07/2038","01/04/2039","01/07/2039","01/04/2040","01/07/2040","01/04/2041","01/07/2041","01/04/2042"]
[null,"Actif","Classe d'actifs","Nom du support","Le produit lui-même","4 / 7",0.05,"immédiat","lieninternet.com",30000,33000]
[null,"Actif","Cash","Compte-courant","Boursorama","1 / 7",0,"immédiat","boursorama.com",3000,3000]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Actif"]
[null,"Passif","Immobilier","Crédit immobilier, crédit à la consommation, etc.","Nom de la banque","-",0.01,"-","lieninternet.com",-20000,-18000]
[null,"Passif"]
[null,"Passif"]
[null,"Passif"]
[null,"Total","Total",null,null,null,null,null,null,{"$f":"SUM(TableSaisie[01/01/2021])","v":13000},{"$f":"SUM(TableSaisie[01/04/2021])","v":18000},{"$f":"SUM(TableSaisie[01/07/2021])","v":0},{"$f":"SUM(TableSaisie[01/04/2022])","v":0},{"$f":"SUM(TableSaisie[01/07/2022])","v":0},{"$f":"SUM(TableSaisie[01/04/2023])","v":0},{"$f":"SUM(TableSaisie[01/07/2023])","v":0},{"$f":"SUM(TableSaisie[01/04/2024])","v":0},{"$f":"SUM(TableSaisie[01/07/2024])","v":0},{"$f":"SUM(TableSaisie[01/04/2025])","v":0},{"$f":"SUM(TableSaisie[01/07/2025])","v":0},{"$f":"SUM(TableSaisie[01/04/2026])","v":0},{"$f":"SUM(TableSaisie[01/07/2026])","v":0},{"$f":"SUM(TableSaisie[01/04/2027])","v":0},{"$f":"SUM(TableSaisie[01/07/2027])","v":0},{"$f":"SUM(TableSaisie[01/04/2028])","v":0},{"$f":"SUM(TableSaisie[01/07/2028])","v":0},{"$f":"SUM(TableSaisie[01/04/2029])","v":0},{"$f":"SUM(TableSaisie[01/07/2029])","v":0},{"$f":"SUM(TableSaisie[01/04/2030])","v":0},{"$f":"SUM(TableSaisie[01/07/2030])","v":0},{"$f":"SUM(TableSaisie[01/04/2031])","v":0},{"$f":"SUM(TableSaisie[01/07/2031])","v":0},{"$f":"SUM(TableSaisie[01/04/2032])","v":0},{"$f":"SUM(TableSaisie[01/07/2032])","v":0},{"$f":"SUM(TableSaisie[01/04/2033])","v":0},{"$f":"SUM(TableSaisie[01/07/2033])","v":0},{"$f":"SUM(TableSaisie[01/04/2034])","v":0},{"$f":"SUM(TableSaisie[01/07/2034])","v":0},{"$f":"SUM(TableSaisie[01/04/2035])","v":0},{"$f":"SUM(TableSaisie[01/07/2035])","v":0},{"$f":"SUM(TableSaisie[01/04/2036])","v":0},{"$f":"SUM(TableSaisie[01/07/2036])","v":0},{"$f":"SUM(TableSaisie[01/04/2037])","v":0},{"$f":"SUM(TableSaisie[01/07/2037])","v":0},{"$f":"SUM(TableSaisie[01/04/2038])","v":0},{"$f":"SUM(TableSaisie[01/07/2038])","v":0},{"$f":"SUM(TableSaisie[01/04/2039])","v":0},{"$f":"SUM(TableSaisie[01/07/2039])","v":0},{"$f":"SUM(TableSaisie[01/04/2040])","v":0},{"$f":"SUM(TableSaisie[01/07/2040])","v":0},{"$f":"SUM(TableSaisie[01/04/2041])","v":0},{"$f":"SUM(TableSaisie[01/07/2041])","v":0},{"$f":"SUM(TableSaisie[01/04/2042])","v":0}]
[null,"Total Actif","Total Actif",null,null,null,null,null,null,{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/01/2021])","v":33000},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2021])","v":36000},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2021])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2022])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2022])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2023])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2023])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2024])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2024])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2025])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2025])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2026])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2026])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2027])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2027])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2028])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2028])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2029])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2029])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2030])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2030])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2031])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2031])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2032])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2032])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2033])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2033])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2034])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2034])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2035])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2035])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2036])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2036])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2037])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2037])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2038])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2038])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2039])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2039])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2040])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2040])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2041])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/07/2041])","v":0},{"$f":"SUMIF(TableSaisie[Type],\"Actif\",TableSaisie[01/04/2042])","v":0}]

{"sheet":"Dashboard_Allocation","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Choisissez une date de consultation d'allocation"]
[]
[null,"Date consultation","01/01/2021"]
[]
[null,"Patrimoine Brut",null,null,null,null,"Patrimoine Net"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","Actif"]
[]
[null,"Row Labels","Sum of 01/01/2021",null,null,null,"Row Labels","Sum of 01/01/2021"]
[null,"Cash",3000,null,null,null,"Cash",3000]
[null,"(blank)",null,null,null,null,"Immobilier",-20000]
[null,"Classe d'actifs",30000,null,null,null,"(blank)"]
[null,"Grand Total",33000,null,null,null,"Classe d'actifs",30000]
[null,null,null,null,null,null,"Grand Total",13000]

{"sheet":"DashBoard_Evol_Brut","index":2,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,"Ci-dessous l'évolution de votre Patrimoine Brut"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","(Multiple Items)"]
[]
[null,null,"Column Labels"]
[null,"Values","Cash","Total Actif","(blank)","Classe d'actifs","Grand Total"]
[null,"Sum of 01/01/2021",3000,33000,null,30000,66000]
[null,"Sum of 01/04/2021",3000,36000,null,33000,72000]

{"sheet":"DashBoard_Evol_Net","index":3,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"Ci-dessous l'évolution de votre Patrimoine Net"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","(Multiple Items)"]
[]
[null,null,"Column Labels"]
[null,"Values","Cash","Immobilier","Total","(blank)","Classe d'actifs","Grand Total"]
[null,"Sum of 01/01/2021",3000,-20000,13000,null,30000,26000]
[null,"Sum of 01/04/2021",3000,-18000,18000,null,33000,36000]

{"sheet":"LOV","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Type","Classe d'actif","Risque","Rendement / Taux","Rendement / Taux"]
[null,"Actif"]
[null,"Passif","Entrez une valeur ou sélectionnez dans la liste","Entrez une valeur ou sélectionnez dans la liste","Entrez une valeur ou sélectionnez dans la liste","Entrez une valeur ou sélectionnez dans la liste"]
[null,null,"-","-","-","-"]
[null,null,"Cash","1 / 7","?"]
[null,null,"Immobilier","2 / 7",0,"imédiat"]
[null,null,"Actions/obligations","3 / 7",0.01,"non"]
[null,null,"P2P Lending","4 / 7",0.02,"sous-condition"]
[null,null,"Private Equity","5 / 7",0.03,"glissant"]
[null,null,"Crypto-monnaie","6 / 7",0.04,"7/8 ans"]
[null,null,"CatégoriePerso1","7 / 7",0.05]
[null,null,"CatégoriePerso2",null,0.06]
[null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,0.08]
[null,null,null,null,0.09]
[null,null,null,null,0.1]
[null,null,null,null,0.11]
[null,null,null,null,0.12]
[null,null,null,null,0.13]
[null,null,null,null,0.14000000000000001]
[null,null,null,null,0.15]