{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["01","Formules Compte Suivi","Dépenses fixes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":28,"comments":0,"pivot_tables":1},"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":"01","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,9,8,11],[4,11,5,11],[2,1,4,5],[0,0,122,0],[0,1,1,5],[0,9,1,15],[0,8,1,8],[0,6,1,7],[2,11,3,11],[3,7,4,7],[3,6,4,6],[4,10,5,10],[4,9,5,9],[2,10,3,10],[2,9,3,9]]}
[null,"Synthèse mois en cours",null,null,null,null,"Solde",null,null,"Synthèse fin de mois"]
[]
[null,"JANVIER",null,null,null,null,{"$f":"TODAY()","v":"2018-06-22"},"Fin de mois",null,"Recette","Dépense","Solde restant"]
[null,null,null,null,null,null,{"$f":"'Formules Compte Suivi'!H3","v":1898.65},{"$f":"'Formules Compte Suivi'!H5","v":905.7}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(G8:G123)","v":2250},{"$f":"SUM(H7:H123)","v":1344.3},{"$f":"J5-K5","v":905.7}]
[null,null,"Date Opération","Date Crédit/Débit","Intitulé","Précision","Créditeur","Débiteur"]
[null,{"$f":"IF(B8=\"X\",\"X\",\"\")","v":"X"},null,null,"Restant mois précèdent",null,null,null,null,"DETAILS OPERATION MENSUELLES"]
[null,"X",null,null,"Paie Sam","Revenus fixes",1000]
[null,"X",null,null,"Paie Marion","Revenus fixes",1000]
[null,"X",null,null,"C.A.F","Revenus fixes",250,null,null,null,"Valeurs"]
[null,"X",null,null,"Assurance habitation ","Dépenses fixes",null,28.9,null,"INTITULES","Crédit","Débit"]
[null,"X",null,null,"Assurance prêt habitation","Dépenses fixes",null,62.66,null,"Assurance clio",null,34]
[null,"X",null,null,"Assurance clio","Dépenses fixes",null,34,null,"Assurance habitation ",null,28.9]
[null,"X",null,null,"Assurance scénic","Dépenses fixes",null,55.48,null,"Assurance prêt habitation",null,62.66]
[null,"X",null,null,"Compte à composer","Dépenses fixes",null,6.12,null,"Assurance scénic",null,55.48]
[null,"X",null,null,"Electricité + Gaz","Dépenses fixes",null,164.19,null,"C.A.F",250]
[null,null,null,null,"Prêt habitation","Dépenses fixes",null,828.67,null,"Compte à composer",null,6.12]
[null,null,null,null,"Prêt scénic","Dépenses fixes",null,112.83,null,"Electricité + Gaz",null,164.19]
[null,null,null,null,"Téléphone portable Marion","Dépenses fixes",null,21.45,null,"Paie Marion",1400]
[null,null,null,null,"Téléphone portable Sam + Internet","Dépenses fixes",null,30,null,"Paie Sam",1850]
[null,null,null,null,null,null,null,null,null,"Prêt habitation",null,828.67]
[null,null,null,null,null,null,null,null,null,"Prêt scénic",null,112.83]
[null,null,null,null,null,null,null,null,null,"Restant mois précèdent"]
[null,null,null,null,null,null,null,null,null,"Téléphone portable Marion",null,21.45]
[null,null,null,null,null,null,null,null,null,"Téléphone portable Sam + Internet",null,30]
[null,null,null,null,null,null,null,null,null,"(vide)"]

{"sheet":"Formules Compte Suivi","index":1,"n_rows":73,"n_cols":20,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,0,7],[3,5,3,6],[6,5,6,7],[10,5,10,6],[9,5,9,6]]}
["LISTE Fixe","CROIX","FORMULE restant mois",null,"mois terminé","JANVIER solde au et solde théorique",null,null,null,null,null,null,null,null,null,null,null,null,"Assurance habitation",28.9]
["Achat internet",null,{"$f":"IF(COUNTIF('01'!$E$7:$E$122,'01'!E8)>1,\"Paie Sam\",\"\")","v":""},"janvier => février","NON","Solde au:",null,"Total",null,null,null,null,null,null,null,null,null,null,"Assurance prêt habitation",62.66]
["Assurance clio","X",null,null,"OUI",{"$f":"SUMIF('01'!B7:B121,\"X\",'01'!G7:G121)","v":2250},{"$f":"SUMIF('01'!B7:B121,\"X\",'01'!H7:H121)","v":351.35},{"$f":"F3-G3","v":1898.65},null,null,null,null,null,null,null,null,null,null,"Assurance voiture clio",34]
["Assurance habitation ",null,null,null,null,"Solde après dépense",null,"Total",null,null,null,null,null,null,null,null,null,null,"Assurance voiture scénic",55.48]
["Assurance prêt habitation",null,null,null,null,{"$f":"SUMIF('01'!B7:B121,\"X\",'01'!G7:G121)","v":2250},{"$f":"SUM('01'!$H$7:$H$122)","v":1344.3},{"$f":"F5-G5","v":905.7},null,null,null,null,null,null,null,null,null,null,"Compte à composer",6.12]
["Assurance scénic",null,null,null,null,null,{"$f":"-G5","v":-1344.3},null,null,null,null,null,null,null,null,null,null,null,"Electricité + Gaz",164.19]
["C.A.F",null,null,null,null,"Janvier Solde recette et dépense fin de mois",null,null,null,null,null,null,null,null,null,null,null,null,"Prêt habitation",828.67]
["Chèque (Dépôt)",null,null,null,null,"Recette","Dépense",null,null,null,null,null,null,null,null,null,null,null,"Prêt scénic",112.83]
["Compte à composer",null,null,null,null,{"$f":"SUM('01'!G8:G121)","v":2250},{"$f":"SUM('01'!H7:H121)","v":1344.3},null,null,null,null,null,null,null,null,null,null,null,"Téléphone portable Marion",21.45]
["Course",null,null,null,null,"Recette sans nouvelle paie",null,null,null,null,null,null,null,null,null,null,null,null,"Téléphone portable Sam + Internet",30]
["Divers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(T1:T10)","v":1344.3}]
["Eau",null,null,null,null,"Restant fin de mois"]
["Electricité + Gaz"]
["Entretien voiture"]
["Espèces (dépôt)"]
["Espèces (retrait)"]
["Essence"]
["Médecin"]
["Naya (croquette)"]
["Naya (divers)"]
["Paie Marion"]
["Paie Sam"]
["Paie Sam (nouvelle)"]
["Péage"]
["Pharmacie"]
["Prêt habitation"]
["Prêt scénic"]
["Remboursement CPAM"]
["Remboursement Mutuelle"]
["Restaurant"]
["Rugby"]
["Téléphone portable Marion"]
["Téléphone portable Sam + Internet"]
["Vêtement"]
["Virement"]
[]
[]
[]
[]
[]
["Achat internet"]
["Assurance clio"]
["Assurance habitation "]
["Assurance prêt habitation"]
["Assurance scénic"]
["C.A.F"]
["Chèque (Dépôt)"]
["Compte à composer"]
["Course"]
["Divers"]
["Eau"]
["Electricité + Gaz"]
["Entretien voiture"]
["Espèces (dépôt)"]
["Espèces (retrait)"]
["Essence"]
["Médecin"]
["Naya (croquette)"]
["Naya (divers)"]
["Paie Marion"]
["Paie Sam"]
["Péage"]
["Pharmacie"]
["Prêt habitation"]
["Prêt scénic"]
["Remboursement CPAM"]
["Remboursement Mutuelle"]
["Restaurant"]
["Rugby"]
["Téléphone portable Marion"]
["Téléphone portable Sam + Internet"]
["Vêtement"]
["Virement"]

{"sheet":"Dépenses fixes","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["Dépenses fixes 2018"]
[]
["Désignation","Montant","Jour de\nprélèvement"]
["Assurance habitation",28.9,27]
["Assurance prêt habitation",62.66,3]
["Assurance voiture clio",34,2]
["Assurance voiture scénic",55.48,2]
["Compte à composer",6.12,3]
["Electricité + Gaz",164.19,25]
["Prêt habitation",828.67,5]
["Prêt scénic",112.83,5]
["Téléphone portable Marion",21.45,20]
["Téléphone portable Sam + Internet",30,20]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B4:B17)","v":1344.3}]