{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Récapitulatif","Actifs","Passifs, Équité du Propriétaire"],"not_rendered":{"charts":2,"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Récapitulatif","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
[{"$nulls":4}," "]
[null,null,{"$f":"\"Année \" & YEAR(TODAY())-1","v":"Année 2018"},{"$f":"\"Année \" & YEAR(TODAY())","v":"Année 2019"}]
[]
[null,"Résumé du solde","Année 1","Année 2"]
[null,"Total de l’actif",{"$f":"Tableau_ActifsEnCours[[#Totals],[Année 1]]+Tableau_ActifsFixes[[#Totals],[Année 1]]+Tableau_AutresActifs[[#Totals],[Année 1]]","v":{"v":9545,"d":"9,545.00 $"}},{"$f":"Tableau_ActifsEnCours[[#Totals],[Année 2]]+Tableau_ActifsFixes[[#Totals],[Année 2]]+Tableau_AutresActifs[[#Totals],[Année 2]]","v":{"v":12735,"d":"12,735.00 $"}}]
[null,"Total Passifs et Équité du Propriétaire",{"$f":"Tableau_PassifsEnCours[[#Totals],[Année 1]]+Tableau_PassifsàLongTerme[[#Totals],[Année 1]]+Tableau_ÉquitéPropriétaire[[#Totals],[Année 1]]","v":{"v":8540,"d":"8,540.00 $"}},{"$f":"Tableau_PassifsEnCours[[#Totals],[Année 2]]+Tableau_PassifsàLongTerme[[#Totals],[Année 2]]+Tableau_ÉquitéPropriétaire[[#Totals],[Année 2]]","v":{"v":6227,"d":"6,227.00 $"}}]
[null,"Solde",{"$f":"C5-C6","v":{"v":1005,"d":"1,005.00 $"}},{"$f":"D5-D6","v":{"v":6508,"d":"6,508.00 $"}}]

{"sheet":"Actifs","index":1,"n_rows":21,"n_cols":5,"rows_kept":21}
[{"$nulls":4}," "]
[null,null,{"$f":"_xlfn.SINGLE(Année_Précédente)","v":{"$error":"#NAME?"}},{"$f":"_xlfn.SINGLE(Année_EnCours)","v":{"$error":"#NAME?"}}]
[null,"Actif courant","Année 1","Année 2"]
[null,"Liquidités",{"v":1000,"d":"1,000.00 $"},{"v":1700,"d":"1,700.00 $"}]
[null,"Investissements",{"v":1500,"d":"1,500.00 $"},{"v":2550,"d":"2,550.00 $"}]
[null,"Stocks",{"v":650,"d":"650.00 $"},{"v":1250,"d":"1,250.00 $"}]
[null,"Ventes",{"v":150,"d":"150.00 $"},{"v":230,"d":"230.00 $"}]
[null,"Charges prépayées",{"v":1230,"d":"1,230.00 $"},{"v":950,"d":"950.00 $"}]
[null,"Autres",{"v":120,"d":"120.00 $"},{"v":120,"d":"120.00 $"}]
[null,"Total Actifs courants",{"$f":"SUBTOTAL(109,Tableau_ActifsEnCours[Année 1])","v":{"v":4650,"d":"4,650.00 $"}},{"$f":"SUBTOTAL(109,Tableau_ActifsEnCours[Année 2])","v":{"v":6800,"d":"6,800.00 $"}}]
[]
[null,"Actif immobilisé","Année 1","Année 2"]
[null,"Biens immobiliers et équipements",{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"}]
[null,"Améliorations locatives",{"v":450,"d":"450.00 $"},{"v":350,"d":"350.00 $"}]
[null,"Équité et autres investissements",{"v":1250,"d":"1,250.00 $"},{"v":1600,"d":"1,600.00 $"}]
[null,"Moins l’amortissement cumulé",{"v":545,"d":"545.00 $"},{"v":1295,"d":"1,295.00 $"}]
[null,"Total Actifs immobilisés",{"$f":"SUBTOTAL(109,Tableau_ActifsFixes[Année 1])","v":{"v":4745,"d":"4,745.00 $"}},{"$f":"SUBTOTAL(109,Tableau_ActifsFixes[Année 2])","v":{"v":5745,"d":"5,745.00 $"}}]
[]
[null,"Autre actifs","Année 1","Année 2"]
[null,"Fonds commercial",{"v":150,"d":"150.00 $"},{"v":190,"d":"190.00 $"}]
[null,"Total Autres actifs",{"$f":"SUBTOTAL(109,Tableau_AutresActifs[Année 1])","v":{"v":150,"d":"150.00 $"}},{"$f":"SUBTOTAL(109,Tableau_AutresActifs[Année 2])","v":{"v":190,"d":"190.00 $"}}]

{"sheet":"Passifs, Équité du Propriétaire","index":2,"n_rows":19,"n_cols":5,"rows_kept":19}
[{"$nulls":4}," "]
[null,null,{"$f":"_xlfn.SINGLE(Année_Précédente)","v":{"$error":"#NAME?"}},{"$f":"_xlfn.SINGLE(Année_EnCours)","v":{"$error":"#NAME?"}}]
[null,"Passifs courants","Année 1","Année 2"]
[null,"Achats",{"v":180,"d":"180.00 $"},{"v":252,"d":"252.00 $"}]
[null,"Traitements échus",{"v":250,"d":"250.00 $"},{"v":370,"d":"370.00 $"}]
[null,"Rémunérations",{"v":240,"d":"240.00 $"},{"v":190,"d":"190.00 $"}]
[null,"Impôts sur le revenu à payer",{"v":120,"d":"120.00 $"},{"v":130,"d":"130.00 $"}]
[null,"Revenus reportés",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"}]
[null,"Autres",{"v":250,"d":"250.00 $"},{"v":235,"d":"235.00 $"}]
[null,"Total Passifs Courants",{"$f":"SUBTOTAL(109,Tableau_PassifsEnCours[Année 1])","v":{"v":1040,"d":"1,040.00 $"}},{"$f":"SUBTOTAL(109,Tableau_PassifsEnCours[Année 2])","v":{"v":1177,"d":"1,177.00 $"}}]
[]
[null,"Passif à long terme","Année 1","Année 2"]
[null,"Emprunt hypothécaire",{"v":1500,"d":"1,500.00 $"},{"v":1900,"d":"1,900.00 $"}]
[null,"Total Passif à long terme",{"$f":"SUBTOTAL(109,Tableau_PassifsàLongTerme[Année 1])","v":{"v":1500,"d":"1,500.00 $"}},{"$f":"SUBTOTAL(109,Tableau_PassifsàLongTerme[Année 2])","v":{"v":1900,"d":"1,900.00 $"}}]
[]
[null,"Équité du propriétaire","Année 1","Année 2"]
[null,"Capital d’investissement",{"v":5500,"d":"5,500.00 $"},{"v":2500,"d":"2,500.00 $"}]
[null,"Bénéfices non répartis cumulés",{"v":500,"d":"500.00 $"},{"v":650,"d":"650.00 $"}]
[null,"Nombre total d’équité du propriétaire",{"$f":"SUBTOTAL(109,Tableau_ÉquitéPropriétaire[Année 1])","v":{"v":6000,"d":"6,000.00 $"}},{"$f":"SUBTOTAL(109,Tableau_ÉquitéPropriétaire[Année 2])","v":{"v":3150,"d":"3,150.00 $"}}]