{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Tableau de bord","Actif","Passif","calculs"],"not_rendered":{"charts":4,"images":6,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Tableau de bord","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"TABLEAU DE BORD",{"$nulls":4},"SYNTHÈSE VALEUR NETTE"," "]
{"$rows_empty":8}
[null,{"$f":"SituationNette","v":{"v":166600,"d":"166,600 €"}},null,{"$f":"TotalActif","v":{"v":387800,"d":"387,800 €"}},null,null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"221,200 €"}}]
[null,"SITUATION NETTE",null,"TOTAL DE L’ACTIF",null,null,"TOTAL DU PASSIF"]
[{"$nulls":3}," LIQUIDITÉS",null,null," NON GARANTI"]
[{"$nulls":3}," INVESTISSEMENTS",null,null," GARANTI"]
[{"$nulls":3}," RETRAITE"]
[{"$nulls":3}," PERSONNEL"]
[]
[{"$nulls":3},"AFFICHER L’ACTIF >",null,null,"AFFICHER LE PASSIF >"]

{"sheet":"Actif","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"ACTIF",{"$nulls":6},"SYNTHÈSE VALEUR NETTE",null," "]
[]
[{"$nulls":3}," ","LIQUIDITÉS","VALEUR",null," ","PERSONNEL","VALEUR"]
[{"$nulls":4},"ENCAISSE",{"v":2000,"d":"2,000"},null,null,"RÉSIDENCE PRINCIPALE",{"v":233000,"d":"233,000"}]
[{"$nulls":4},"COMPTES COURANTS",{"v":2500,"d":"2,500"},null,null,"RÉSIDENCE SECONDAIRE"]
[{"$nulls":4},"COMPTES D’ÉPARGNE",{"v":4000,"d":"4,000"},null,null,"PIÈCES DE COLLECTION"]
[{"$nulls":4},"COMPTES DU MARCHÉ MONÉTAIRE",{"v":3300,"d":"3,300"},null,null,"AUTOMOBILES",{"v":32000,"d":"32,000"}]
[{"$nulls":4},"CERTIFICATS DE DÉPÔT",{"v":14000,"d":"14,000"},null,null,"MOBILIER",{"v":10000,"d":"10,000"}]
[{"$nulls":4},"BONS DU TRÉSOR",{"$nulls":3},"FOURRURES ET BIJOUX"]
[{"$nulls":4},"VALEUR DE RACHAT DES CONTRATS D’ASSURANCE VIE",{"v":24500,"d":"24,500"},null,null,"AUTRES ACTIFS 1",{"v":1500,"d":"1,500"}]
[null,{"$f":"TotalActif","v":{"v":387800,"d":"387,800 €"}},null,null,"AUTRES LIQUIDITÉS",{"$nulls":3},"AUTRES ACTIFS 2"]
[{"$nulls":4},"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblCash[VALEUR])","v":{"v":50300,"d":"50,300"}},null,null,"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblPersonal[VALEUR])","v":{"v":276500,"d":"276,500"}}]
[null,"TOTAL DE L’ACTIF"]
[]
[{"$nulls":3}," ","INVESTISSEMENTS","VALEUR",null," ","RETRAITE","VALEUR"]
[null,"AFFICHER LE PASSIF >",null,null,"ACTIONS",{"v":15000,"d":"15,000"},null,null,"PENSION"]
[null,"< AFFICHER LE TABLEAU DE BORD",null,null,"OBLIGATIONS",{"$nulls":3},"COMPTES DE RETRAITE INDIVIDUELS"]
[{"$nulls":4},"FONDS COMMUNS DE PLACEMENT",{"$nulls":3},"COMPTES DE RETRAITE"]
[{"$nulls":4},"PARTICIPATIONS DANS LA SOCIÉTÉ",{"$nulls":3},"ÉPARGNE RETRAITE PAR CAPITALISATION",{"v":46000,"d":"46,000"}]
[{"$nulls":4},"AUTRES INVESTISSEMENTS 1",{"$nulls":3},"SEP"]
[{"$nulls":4},"AUTRES INVESTISSEMENTS 2",{"$nulls":3},"AUTRE PENSION"]
[{"$nulls":4},"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblInvestments[VALEUR])","v":{"v":15000,"d":"15,000"}},null,null,"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblRetirement[VALEUR])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Passif","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"PASSIF",{"$nulls":6},"SYNTHÈSE VALEUR NETTE",null," "]
[]
[{"$nulls":3}," ","NON GARANTI","OWE",null," ","GARANTIS","OWE"]
[{"$nulls":4},"CARTES DE CRÉDIT",{"v":1200,"d":"1,200"},null,null,"PRÊTS AUTO",{"v":14500,"d":"14,500"}]
[{"$nulls":4},"COMPTES DE CHARGES",{"v":3000,"d":"3,000"},null,null,"CRÉDITS AUTO"]
[{"$nulls":4},"PRÊTS ÉTUDIANT",{"v":17500,"d":"17,500"},null,null,"CRÉDITS CONSO"]
[{"$nulls":4},"PENSION ALIMENTAIRE",{"$nulls":3},"CRÉDITS IMMOBILIERS",{"v":144000,"d":"144,000"}]
[{"$nulls":4},"PENSION ALIMENTAIRE (ENFANTS)",{"$nulls":3},"PRÊTS SUR VALEUR DOMICILIAIRE",{"v":21000,"d":"21,000"}]
[{"$nulls":4},"PASSIF D’IMPÔTS",{"v":8000,"d":"8,000"},null,null,"PASSIF D’IMPÔTS"]
[{"$nulls":4},"AUTRES NON GARANTIS 1",{"v":6000,"d":"6,000"},null,null,"AUTRES GARANTIS 1",{"v":4000,"d":"4,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"221,200 €"}},null,null,"AUTRES NON GARANTIS 2",{"$nulls":3},"AUTRES GARANTIS 2",{"v":2000,"d":"2,000"}]
[{"$nulls":4},"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblUnsecured[OWE])","v":{"v":35700,"d":"35,700"}},null,null,"SOUS-TOTAL",{"$f":"SUBTOTAL(109,tblSecured[OWE])","v":{"v":185500,"d":"185,500"}}]
[null,"TOTAL DU PASSIF"]
[]
[]
[null,"< AFFICHER L’ACTIF"]
[null,"< AFFICHER LE TABLEAU DE BORD"]

{"sheet":"calculs","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** Cette feuille doit rester masquée ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[LIQUIDITÉS]]","v":"LIQUIDITÉS"},{"$f":"SUM(tblCash[VALEUR])","v":{"v":50300,"d":"50,300 €"}}]
[null,{"$f":"tblInvestments[[#Headers],[INVESTISSEMENTS]]","v":"INVESTISSEMENTS"},{"$f":"SUM(tblInvestments[VALEUR])","v":{"v":15000,"d":"15,000 €"}}]
[null,{"$f":"tblRetirement[[#Headers],[RETRAITE]]","v":"RETRAITE"},{"$f":"SUM(tblRetirement[VALEUR])","v":{"v":46000,"d":"46,000 €"}}]
[null,{"$f":"tblPersonal[[#Headers],[PERSONNEL]]","v":"PERSONNEL"},{"$f":"SUM(tblPersonal[VALEUR])","v":{"v":276500,"d":"276,500 €"}}]
[null,"Total de l’actif",{"$f":"SUM(tblCash[VALEUR],tblInvestments[VALEUR],tblRetirement[VALEUR],tblPersonal[VALEUR])","v":{"v":387800,"d":"387,800 €"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[NON GARANTI]]","v":"NON GARANTI"},{"$f":"SUM(tblUnsecured[OWE])","v":{"v":35700,"d":"35,700 €"}}]
[null,{"$f":"tblSecured[[#Headers],[GARANTIS]]","v":"GARANTIS"},{"$f":"SUM(tblSecured[OWE])","v":{"v":185500,"d":"185,500 €"}}]
[null,"Total du passif",{"$f":"SUM(tblUnsecured[OWE],tblSecured[OWE])","v":{"v":221200,"d":"221,200 €"}}]
[]
[]
[null,"Valeur Nette",{"$f":"C15-C20","v":{"v":166600,"d":"166,600 €"}}]