{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Acceuil","Compte Courant","Paramètres","Filtre","L.A Paul","L.A Pauline","LEP Paul","LEP Pauline","Feuille de travail","Ass.Vie Paul","Ass.Vie Pauline"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":22,"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":"Acceuil","index":0,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,6,1,10],[2,6,2,8],[2,9,2,10]]}
[]
[null,null,null,null,null,null,"COMPTE COURANT"]
[null,null,null,null,null,null,"Opérations non-pointées à la date du :",null,null,{"$f":"TODAY()","v":"2024-02-14"}]
[]
[null,null,null,null,null,null,"Date","Libellés","Tiers","Débit","Crédit"]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C26<>\"\",Filtre!$C26,\"\")","v":"2019-01-16"},{"$f":"IF(Filtre!$D26<>\"\",Filtre!$D26,\"\")","v":"Impôts fonciers"},{"$f":"IF(Filtre!$F26<>\"\",Filtre!$F26,\"\")","v":"Trésor Public"},{"$f":"IF(Filtre!G26<>\"\",Filtre!$G26,\"\")","v":45},{"$f":"IF(Filtre!$H26<>\"\",Filtre!$H26,\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C27<>\"\",Filtre!$C27,\"\")","v":"2019-01-18"},{"$f":"IF(Filtre!$D27<>\"\",Filtre!$D27,\"\")","v":"Mobile Facture EDF"},{"$f":"IF(Filtre!$F27<>\"\",Filtre!$F27,\"\")","v":"Orange"},{"$f":"IF(Filtre!G27<>\"\",Filtre!$G27,\"\")","v":15.98},{"$f":"IF(Filtre!$H27<>\"\",Filtre!$H27,\"\")","v":0},null,null,null,"Mois","(Tous)"]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C28<>\"\",Filtre!$C28,\"\")","v":"2019-01-20"},{"$f":"IF(Filtre!$D28<>\"\",Filtre!$D28,\"\")","v":"Mobile Facture EDF"},{"$f":"IF(Filtre!$F28<>\"\",Filtre!$F28,\"\")","v":"Engie"},{"$f":"IF(Filtre!G28<>\"\",Filtre!$G28,\"\")","v":165.1},{"$f":"IF(Filtre!$H28<>\"\",Filtre!$H28,\"\")","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C29<>\"\",Filtre!$C29,\"\")","v":"2019-01-25"},{"$f":"IF(Filtre!$D29<>\"\",Filtre!$D29,\"\")","v":"Imprimante"},{"$f":"IF(Filtre!$F29<>\"\",Filtre!$F29,\"\")","v":"Aldi"},{"$f":"IF(Filtre!G29<>\"\",Filtre!$G29,\"\")","v":79.989999999999995},{"$f":"IF(Filtre!$H29<>\"\",Filtre!$H29,\"\")","v":0},null,null,null,"Étiquettes de lignes","Somme de Montant"]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C30<>\"\",Filtre!$C30,\"\")","v":"2019-01-30"},{"$f":"IF(Filtre!$D30<>\"\",Filtre!$D30,\"\")","v":"Salaire Janvier 2019"},{"$f":"IF(Filtre!$F30<>\"\",Filtre!$F30,\"\")","v":"Caisse d'Epargne"},{"$f":"IF(Filtre!G30<>\"\",Filtre!$G30,\"\")","v":0},{"$f":"IF(Filtre!$H30<>\"\",Filtre!$H30,\"\")","v":1224.27},null,null,null,"Assurance",-81.510000000000005]
[null,"Compte courant",null,291.39999999999998,null,null,{"$f":"IF(Filtre!$C31<>\"\",Filtre!$C31,\"\")","v":"2019-02-11"},{"$f":"IF(Filtre!$D31<>\"\",Filtre!$D31,\"\")","v":"Epargne mensuelle"},{"$f":"IF(Filtre!$F31<>\"\",Filtre!$F31,\"\")","v":"Caisse d'Epargne"},{"$f":"IF(Filtre!G31<>\"\",Filtre!$G31,\"\")","v":84.34},{"$f":"IF(Filtre!$H31<>\"\",Filtre!$H31,\"\")","v":0},null,null,null,"Banque",-50]
[null,"Solde livret A Paul",null,2090,null,null,{"$f":"IF(Filtre!$C32<>\"\",Filtre!$C32,\"\")","v":""},{"$f":"IF(Filtre!$D32<>\"\",Filtre!$D32,\"\")","v":""},{"$f":"IF(Filtre!$F32<>\"\",Filtre!$F32,\"\")","v":""},{"$f":"IF(Filtre!G32<>\"\",Filtre!$G32,\"\")","v":""},{"$f":"IF(Filtre!$H32<>\"\",Filtre!$H32,\"\")","v":""},null,null,null,"Impôts",-45]
[null,"Solde livret A Pauline",null,null,null,null,{"$f":"IF(Filtre!$C33<>\"\",Filtre!$C33,\"\")","v":""},{"$f":"IF(Filtre!$D33<>\"\",Filtre!$D33,\"\")","v":""},{"$f":"IF(Filtre!$F33<>\"\",Filtre!$F33,\"\")","v":""},{"$f":"IF(Filtre!G33<>\"\",Filtre!$G33,\"\")","v":""},{"$f":"IF(Filtre!$H33<>\"\",Filtre!$H33,\"\")","v":""},null,null,null,"Journalières",-561.91999999999996]
[null,"Solde L.E.P Paul",null,null,null,null,{"$f":"IF(Filtre!$C34<>\"\",Filtre!$C34,\"\")","v":""},{"$f":"IF(Filtre!$D34<>\"\",Filtre!$D34,\"\")","v":""},{"$f":"IF(Filtre!$F34<>\"\",Filtre!$F34,\"\")","v":""},{"$f":"IF(Filtre!G34<>\"\",Filtre!$G34,\"\")","v":""},{"$f":"IF(Filtre!$H34<>\"\",Filtre!$H34,\"\")","v":""},null,null,null,"Revenus",1372.97]
[null,"SoldeL.E.P Pauline",null,null,null,null,{"$f":"IF(Filtre!$C35<>\"\",Filtre!$C35,\"\")","v":""},{"$f":"IF(Filtre!$D35<>\"\",Filtre!$D35,\"\")","v":""},{"$f":"IF(Filtre!$F35<>\"\",Filtre!$F35,\"\")","v":""},{"$f":"IF(Filtre!G35<>\"\",Filtre!$G35,\"\")","v":""},{"$f":"IF(Filtre!$H35<>\"\",Filtre!$H35,\"\")","v":""},null,null,null,"Santé",-50]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C36<>\"\",Filtre!$C36,\"\")","v":""},{"$f":"IF(Filtre!$D36<>\"\",Filtre!$D36,\"\")","v":""},{"$f":"IF(Filtre!$F36<>\"\",Filtre!$F36,\"\")","v":""},{"$f":"IF(Filtre!G36<>\"\",Filtre!$G36,\"\")","v":""},{"$f":"IF(Filtre!$H36<>\"\",Filtre!$H36,\"\")","v":""},null,null,null,"Transports",-50]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C37<>\"\",Filtre!$C37,\"\")","v":""},{"$f":"IF(Filtre!$D37<>\"\",Filtre!$D37,\"\")","v":""},{"$f":"IF(Filtre!$F37<>\"\",Filtre!$F37,\"\")","v":""},{"$f":"IF(Filtre!G37<>\"\",Filtre!$G37,\"\")","v":""},{"$f":"IF(Filtre!$H37<>\"\",Filtre!$H37,\"\")","v":""},null,null,null,"Total général",534.54]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C38<>\"\",Filtre!$C38,\"\")","v":""},{"$f":"IF(Filtre!$D38<>\"\",Filtre!$D38,\"\")","v":""},{"$f":"IF(Filtre!$F38<>\"\",Filtre!$F38,\"\")","v":""},{"$f":"IF(Filtre!G38<>\"\",Filtre!$G38,\"\")","v":""},{"$f":"IF(Filtre!$H38<>\"\",Filtre!$H38,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C39<>\"\",Filtre!$C39,\"\")","v":""},{"$f":"IF(Filtre!$D39<>\"\",Filtre!$D39,\"\")","v":""},{"$f":"IF(Filtre!$F39<>\"\",Filtre!$F39,\"\")","v":""},{"$f":"IF(Filtre!G39<>\"\",Filtre!$G39,\"\")","v":""},{"$f":"IF(Filtre!$H39<>\"\",Filtre!$H39,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C40<>\"\",Filtre!$C40,\"\")","v":""},{"$f":"IF(Filtre!$D40<>\"\",Filtre!$D40,\"\")","v":""},{"$f":"IF(Filtre!$F40<>\"\",Filtre!$F40,\"\")","v":""},{"$f":"IF(Filtre!G40<>\"\",Filtre!$G40,\"\")","v":""},{"$f":"IF(Filtre!$H40<>\"\",Filtre!$H40,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C41<>\"\",Filtre!$C41,\"\")","v":""},{"$f":"IF(Filtre!$D41<>\"\",Filtre!$D41,\"\")","v":""},{"$f":"IF(Filtre!$F41<>\"\",Filtre!$F41,\"\")","v":""},{"$f":"IF(Filtre!G41<>\"\",Filtre!$G41,\"\")","v":""},{"$f":"IF(Filtre!$H41<>\"\",Filtre!$H41,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C42<>\"\",Filtre!$C42,\"\")","v":""},{"$f":"IF(Filtre!$D42<>\"\",Filtre!$D42,\"\")","v":""},{"$f":"IF(Filtre!$F42<>\"\",Filtre!$F42,\"\")","v":""},{"$f":"IF(Filtre!G42<>\"\",Filtre!$G42,\"\")","v":""},{"$f":"IF(Filtre!$H42<>\"\",Filtre!$H42,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C43<>\"\",Filtre!$C43,\"\")","v":""},{"$f":"IF(Filtre!$D43<>\"\",Filtre!$D43,\"\")","v":""},{"$f":"IF(Filtre!$F43<>\"\",Filtre!$F43,\"\")","v":""},{"$f":"IF(Filtre!G43<>\"\",Filtre!$G43,\"\")","v":""},{"$f":"IF(Filtre!$H43<>\"\",Filtre!$H43,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C44<>\"\",Filtre!$C44,\"\")","v":""},{"$f":"IF(Filtre!$D44<>\"\",Filtre!$D44,\"\")","v":""},{"$f":"IF(Filtre!$F44<>\"\",Filtre!$F44,\"\")","v":""},{"$f":"IF(Filtre!G44<>\"\",Filtre!$G44,\"\")","v":""},{"$f":"IF(Filtre!$H44<>\"\",Filtre!$H44,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C45<>\"\",Filtre!$C45,\"\")","v":""},{"$f":"IF(Filtre!$D45<>\"\",Filtre!$D45,\"\")","v":""},{"$f":"IF(Filtre!$F45<>\"\",Filtre!$F45,\"\")","v":""},{"$f":"IF(Filtre!G45<>\"\",Filtre!$G45,\"\")","v":""},{"$f":"IF(Filtre!$H45<>\"\",Filtre!$H45,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C46<>\"\",Filtre!$C46,\"\")","v":""},{"$f":"IF(Filtre!$D46<>\"\",Filtre!$D46,\"\")","v":""},{"$f":"IF(Filtre!$F46<>\"\",Filtre!$F46,\"\")","v":""},{"$f":"IF(Filtre!G46<>\"\",Filtre!$G46,\"\")","v":""},{"$f":"IF(Filtre!$H46<>\"\",Filtre!$H46,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C47<>\"\",Filtre!$C47,\"\")","v":""},{"$f":"IF(Filtre!$D47<>\"\",Filtre!$D47,\"\")","v":""},{"$f":"IF(Filtre!$F47<>\"\",Filtre!$F47,\"\")","v":""},{"$f":"IF(Filtre!G47<>\"\",Filtre!$G47,\"\")","v":""},{"$f":"IF(Filtre!$H47<>\"\",Filtre!$H47,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C48<>\"\",Filtre!$C48,\"\")","v":""},{"$f":"IF(Filtre!$D48<>\"\",Filtre!$D48,\"\")","v":""},{"$f":"IF(Filtre!$F48<>\"\",Filtre!$F48,\"\")","v":""},{"$f":"IF(Filtre!G48<>\"\",Filtre!$G48,\"\")","v":""},{"$f":"IF(Filtre!$H48<>\"\",Filtre!$H48,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C49<>\"\",Filtre!$C49,\"\")","v":""},{"$f":"IF(Filtre!$D49<>\"\",Filtre!$D49,\"\")","v":""},{"$f":"IF(Filtre!$F49<>\"\",Filtre!$F49,\"\")","v":""},{"$f":"IF(Filtre!G49<>\"\",Filtre!$G49,\"\")","v":""},{"$f":"IF(Filtre!$H49<>\"\",Filtre!$H49,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C50<>\"\",Filtre!$C50,\"\")","v":""},{"$f":"IF(Filtre!$D50<>\"\",Filtre!$D50,\"\")","v":""},{"$f":"IF(Filtre!$F50<>\"\",Filtre!$F50,\"\")","v":""},{"$f":"IF(Filtre!G50<>\"\",Filtre!$G50,\"\")","v":""},{"$f":"IF(Filtre!$H50<>\"\",Filtre!$H50,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C51<>\"\",Filtre!$C51,\"\")","v":""},{"$f":"IF(Filtre!$D51<>\"\",Filtre!$D51,\"\")","v":""},{"$f":"IF(Filtre!$F51<>\"\",Filtre!$F51,\"\")","v":""},{"$f":"IF(Filtre!G51<>\"\",Filtre!$G51,\"\")","v":""},{"$f":"IF(Filtre!$H51<>\"\",Filtre!$H51,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C52<>\"\",Filtre!$C52,\"\")","v":""},{"$f":"IF(Filtre!$D52<>\"\",Filtre!$D52,\"\")","v":""},{"$f":"IF(Filtre!$F52<>\"\",Filtre!$F52,\"\")","v":""},{"$f":"IF(Filtre!G52<>\"\",Filtre!$G52,\"\")","v":""},{"$f":"IF(Filtre!$H52<>\"\",Filtre!$H52,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C53<>\"\",Filtre!$C53,\"\")","v":""},{"$f":"IF(Filtre!$D53<>\"\",Filtre!$D53,\"\")","v":""},{"$f":"IF(Filtre!$F53<>\"\",Filtre!$F53,\"\")","v":""},{"$f":"IF(Filtre!G53<>\"\",Filtre!$G53,\"\")","v":""},{"$f":"IF(Filtre!$H53<>\"\",Filtre!$H53,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Filtre!$C54<>\"\",Filtre!$C54,\"\")","v":""},{"$f":"IF(Filtre!$D54<>\"\",Filtre!$D54,\"\")","v":""},{"$f":"IF(Filtre!$F54<>\"\",Filtre!$F54,\"\")","v":""},{"$f":"IF(Filtre!G54<>\"\",Filtre!$G54,\"\")","v":""},{"$f":"IF(Filtre!$H54<>\"\",Filtre!$H54,\"\")","v":""}]

{"sheet":"Compte Courant","index":1,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,26,21,34],[22,26,22,30],[8,6,10,6],[1,3,2,10]]}
[null,null,null,null,null,null,null,null,null,null,null,"P"]
[null,null,null,"*****     OPERATION  SUR  LE  COMPTE  COURANT     *****"]
[]
[]
[null,null,null,"Date du rapprochement","2019-02-03"]
[]
[null,null,null,"Solde du dernier relevé",1166.1400000000001,null,"Rapprochement bancaire"]
[]
[null,null,null,"Solde Excel",2000,null,{"$f":"Filtre!I11","v":"OK"}]
[]
[null,null,null,"Débit non pointé",{"$f":"Filtre!$F$13","v":390.40999999999997}]
[]
[null,null,null,"Crédit non pointé",{"$f":"Filtre!$F$15","v":1224.27},null,null,null,null,null,null,null,null,"Formule pour le mois",null,"=SIERREUR(NOMPROPRE(TEXTE(C20;\"mmmm\"));\"\")"]
[]
[null,null,null,"Nombre de non pointé",{"$f":"COUNTA(Filtre!C26:C44)","v":6},null,null,null,null,null,null,null,null,"Formule pour la catégorie",null,"=SI(O20<>\"\";Tbl_Saisie[@Catégorie];\"\")"]
[]
[null,null,null,null,null,null,null,"Solde de départ : ==>",null,1500,1500,null,null,"Formule pour le montant",null,"=SI(O20<>\"\";Tbl_Saisie[@Crédit]-Tbl_Saisie[@Débit];\"\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mode","Débit","Crédit","Solde","P"]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","P",null,"Mois","Catégorie","Montant"]
[null,null,"2019-01-02","Prise de sang","Santé","Laboratoire","Laboratoire","Carte bancaire",50,null,1450,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N20<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Santé"},{"$f":"IF(N20<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-50}]
[null,null,"2019-01-03","Course de la semaine","Journalières","Nourriture","Aldi","Carte bancaire",97.83,null,1352.17,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N21<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N21<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-97.83}]
[null,null,"2019-01-07","Prime d'activité","Revenus","Retraite S.S Nadine","Caisse d'Epargne","Versement",null,148.69999999999999,1500.8700000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N22<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Revenus"},{"$f":"IF(N22<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":148.69999999999999},null,null,null,null,null,null,null,null,null,null,"Modeles de tableaux"]
[null,null,"2019-01-08","Prévoyance assurance","Assurance","Mutuelle santé","Caisse d'Epargne","Prélèvement",10,null,1490.8700000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N23<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Assurance"},{"$f":"IF(N23<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-10},null,null,null,null,null,null,null,null,null,null,"Sous-Catégorie",null,null,null,null,null,"Mode&Tiers",null,"Saisie"]
[null,null,"2019-01-09","Internet","Journalières","Téléphone/Internet","Orange","Prélèvement",39.799999999999997,null,1451.0700000000002,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N24<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N24<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-39.799999999999997},null,null,null,null,null,null,null,null,null,null,"Compta1",null,"Compta2",null,"Compta3",null,"Compta4",null,"Compta5"]
[null,null,"2019-01-10","Ravitaillement","Journalières","Course","Super U","Carte bancaire",123.42,null,1327.65,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N25<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N25<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-123.42},null,null,null,null,null,null,null,null,null,null,"Titre",null,"Titre",null,"Titre",null,"Titre",null,"Titre"]
[null,null,"2019-01-14","Virement epargne","Banque","Épargne","Caisse d'Epargne","Virement",50,null,1277.6500000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N26<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Banque"},{"$f":"IF(N26<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-50},null,null,null,null,null,null,null,null,null,null,"AA",null,"AA",null,"AA",null,"AA",null,"AA"]
[null,null,"2019-01-15","Cotisation annuelle santé","Assurance","Mutuelle Santé","Agir/Arco","Prélèvement",8.24,null,1269.4100000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N27<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Assurance"},{"$f":"IF(N27<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-8.24},null,null,null,null,null,null,null,null,null,null,"BB",null,"BB",null,"BB",null,"BB",null,"BB"]
[null,null,"2019-01-16","Impôts fonciers","Impôts","Taxe Foncière","Trésor Public","Chèque",45,null,1224.4100000000001,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N28<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Impôts"},{"$f":"IF(N28<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-45},null,null,null,null,null,null,null,null,null,null,"CC",null,"CC",null,"CC",null,"CC",null,"CC"]
[null,null,"2019-01-16","Assur' Auto","Assurance","Voiture 208","Matmut","Prélèvement",53.27,null,1171.1400000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N29<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Assurance"},{"$f":"IF(N29<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-53.27},null,null,null,null,null,null,null,null,null,null,"DD",null,"DD",null,"DD",null,"DD",null,"DD"]
[null,null,"2019-01-16","Gas Oil","Transports","Carburant","Intermarché","Carte bancaire",50,null,1121.1400000000001,"P",null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N30<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Transports"},{"$f":"IF(N30<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-50}]
[null,null,"2019-01-18","Mobile Facture EDF","Journalières","Téléphone/Internet","Orange","Prélèvement",15.98,null,1105.1600000000001,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N31<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N31<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-15.98}]
[null,null,"2019-01-20","Mobile Facture EDF","Journalières","Abonnement","Engie","Chèque",165.1,null,940.06000000000006,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N32<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N32<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-165.1}]
[null,null,"2019-01-25","Imprimante","Journalières","Course","Aldi","Carte bancaire",79.989999999999995,null,860.07,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N33<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Journalières"},{"$f":"IF(N33<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-79.989999999999995}]
[null,null,"2019-01-30","Salaire Janvier 2019","Revenus","Retraite S.S Paul","Caisse d'Epargne","Virement",null,1224.27,2084.34,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Janvier"},{"$f":"IF(N34<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Revenus"},{"$f":"IF(N34<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":1224.27}]
[null,null,"2019-02-11","Epargne mensuelle","Banque","Épargne","Caisse d'Epargne","Virement",84.34,null,2000,null,null,{"$f":"IFERROR(PROPER(TEXT(Tbl_Saisie[[#This Row],[Dates]],\"mmmm\")),\"\")","v":"Février"},{"$f":"IF(N35<>\"\",Tbl_Saisie[[#This Row],[Catégorie]],\"\")","v":"Banque"},{"$f":"IF(N35<>\"\",Tbl_Saisie[[#This Row],[Crédit]]-Tbl_Saisie[[#This Row],[Débit]],\"\")","v":-84.34}]

{"sheet":"Paramètres","index":2,"n_rows":27,"n_cols":46,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,3,23],[2,27,3,31],[0,0,0,31],[14,37,14,45]]}
["*****     PARAMETRES DES COMPTES     *****     PARAMETRES DES COMPTES     *****     PARAMETRES DES COMPTS     *****"]
[]
["*****     COMPTE COURANT     *****     COMPTE COURANT     *****     COMPTE COURANT     *****     COMPTE COURANT     *****",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPARGNE"]
[]
[]
["Catégorie",null,"Assurance","Banque","Bricolage","Charges","Crédit","Équipement","Habillement","Impôts","Journalières","Loisirs","Remboursement","Revenus","Santé","Transports","Voiture",null,null,null,null,"Mode",null,"Tiers",null,null,null,"Mode",null,"Tiers",null,"Comptes",null,null,null,null,1]
["Assurance",null,"Maison","Agios","Brico marché","Électricité","Ameublement","Electro ménager","Vêtement Paul","Amende P.V","Abonnement","Cinéma","Banque","Retraite complémentaire Paul","Dentiste","Avion","Carburant 2008",null,null,null,null,"Carte bancaire",null,"ACCM eau",null,null,null,null,null,null,null,"Compte Courant",null,null,null,null,2]
["Banque",null,"Dépendance Paul","Épargne","Entrepôt du bricolage","Gaz","Crédit voiture","Informatique","Vêtement Pauline","Impôts revenus","Cadeaux","Restaurant","Mutuelle","Retraite complémentaire Pauline","Généraliste","Carburant","Carburant 208",null,null,null,null,"Chèque",null,"Agir/Arco",null,null,null,null,null,null,null,"L.A Paul",null,null,null,null,3]
["Bricolage",null,"Dépendance Pauline","Frais tenu Cpt","Leroy Merlin","Eau","Équipement",null,"Chaussure Paul","Taxe Foncière","Charges","Musée","Sécu.Sociale","Retraite S.S Paul","Hôpital","Péage","Ctrl_Tch 2008",null,null,null,null,"Cpte à Cpte",null,"Aldi",null,null,null,null,null,null,null,"L.A Pauline",null,null,null,null,4]
["Charges",null,"Mutuelle santé","Intérêts",null,"Téléphone/Internet","Travaux",null,"Chaussure Pauline",null,"Course","Visite",null,"Retraite S.S Pauline","Imagerie Radio","Train","Ctrl_Tch 208",null,null,null,null,"Dépôt chèque",null,"Autre",null,null,null,null,null,null,null,"LEP Paul",null,null,null,null,5]
["Crédit",null,"Voiture 2008",null,null,null,null,null,null,null,"Divers",null,null,null,"Laboratoire",null,"Entretien 2008",null,null,null,null,"Dépôt liquide",null,"Brico marché",null,null,null,null,null,null,null,"LEP Pauline",null,null,null,null,6]
["Équipement",null,"Voiture 208",null,null,null,null,null,null,null,"Habillement",null,null,null,"Pharmacie",null,"Entretien 208",null,null,null,null,"Prélèvement",null,"Caisse d'Epargne",null,null,null,null,null,null,null,null,null,null,null,null,7]
["Habillement",null,"Vie",null,null,null,null,null,null,null,"Loisir",null,null,null,"Spécialiste",null,"Pneus 2008",null,null,null,null,"Remboursement",null,"Darty",null,null,null,null,null,null,null,null,null,null,null,null,8]
["Impôts",null,null,null,null,null,null,null,null,null,"Nourriture",null,null,null,null,null,"Pneus 208",null,null,null,null,"Versement",null,"Dentiste",null,null,null,null,null,null,null,null,null,null,null,null,9]
["Journalières",null,null,null,null,null,null,null,null,null,"Téléphone/Internet",null,null,null,null,null,"Réparation 2008",null,null,null,null,"Virement",null,"Engie",null,null,null,null,null,null,null,null,null,null,null,null,10,"Mise en forme perso de tableau"]
["Loisirs",null,null,null,null,null,null,null,null,null,"Restaurant",null,null,null,null,null,"Réparation 208",null,null,null,null,null,null,"Entrepôt du bricolage",null,null,null,null,null,null,null,null,null,null,null,null,11]
["Remboursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garage",null,null,null,null,null,null,null,null,null,null,null,null,12,"Compta1",null,"Compta1",null,"Compta1",null,"Compta1",null,"Compta1"]
["Revenus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermarché",null,null,null,null,null,null,null,null,null,null,null,null,13]
["Santé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laboratoire",null,null,null,null,null,null,null,null,null,null,null,null,14,"Titre",null,"Titre",null,"Titre",null,"Titre",null,"Titre"]
["Transports",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leroy Merlin",null,null,null,null,null,null,null,null,null,null,null,null,15,"AA",null,"AA",null,"AA",null,"AA",null,"AA"]
["Voiture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lidl",null,null,null,null,null,null,null,null,null,null,null,null,16,"BB",null,"BB",null,"BB",null,"BB",null,"BB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matmut",null,null,null,null,null,null,null,null,null,null,null,null,17,"CC",null,"CC",null,"CC",null,"CC",null,"CC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Médecin généraliste",null,null,null,null,null,null,null,null,null,null,null,null,18,"DD",null,"DD",null,"DD",null,"DD",null,"DD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Médecin spécialiste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Super U"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trésor Public"]

{"sheet":"Filtre","index":3,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,2,11],[17,10,17,11],[10,3,10,4],[8,3,8,4],[14,3,14,4],[12,3,12,4],[10,8,14,10]]}
[]
[null,null,"Filtre pour opérations non-pointées"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"F11+F13-F15","v":1166.1399999999999}]
[]
[]
[null,null,null,"Solde du dernier relevé :",null,{"$f":"'Compte Courant'!E7","v":1166.1400000000001},null,null,null,"Rapprochement bancaire"]
[]
[null,null,null,"Solde Excel :",null,{"$f":"'Compte Courant'!E9","v":2000},null,null,{"$f":"IF(F9=(F11+F13-F15),\"OK\",\"OUPS !!!\")","v":"OK"}]
[]
[null,null,null,"Opérations de Débit non-pointées :",null,{"$f":"SUM($G$26:$G$502)","v":390.40999999999997}]
[]
[null,null,null,"Opérations de Crédit non-pointées :",null,{"$f":"SUM($H$26:$H$502)","v":1224.27}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Critère de sélection"]
[]
[null,null,null,null,null,null,null,null,null,null,"R.B",0]
[]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","R.B"]
[null,null,1,1,1,null,1,null,1,1,null,1]
[]
[null,null,{"$f":"_xlfn._xlws.FILTER(C22:L22,C23:L23)","v":"Dates"},"Libellés","Catégorie","Bénéficiaire","Débit","Crédit","R.B"]
[null,{"$f":"IF(C26<>\"\",ROW(C26)-25,\"\")","v":1},{"$f":"_xlfn._xlws.FILTER(_xlfn._xlws.FILTER(Tbl_Saisie[],C23:L23),Tbl_Saisie[P]=Filtre!$L$20,\"\")","v":"2019-01-16"},"Impôts fonciers","Impôts","Trésor Public",45,0,0]
[null,{"$f":"IF(C27<>\"\",ROW(C27)-25,\"\")","v":2},"2019-01-18","Mobile Facture EDF","Journalières","Orange",15.98,0,0]
[null,3,"2019-01-20","Mobile Facture EDF","Journalières","Engie",165.1,0,0,null,null,null,null,null,"Formule Cellule C13","=FILTRE(C15:L15;C16:L16)"]
[null,4,"2019-01-25","Imprimante","Journalières","Aldi",79.989999999999995,0,0]
[null,5,"2019-01-30","Salaire Janvier 2019","Revenus","Caisse d'Epargne",0,1224.27,0,null,null,null,null,null,"Formule Cellule C14","=FILTRE(FILTRE(Tbl_Saisie;C11:L11);Tbl_Saisie[R.B]=Filtre!$L$8;\"\")"]
[null,6,"2019-02-11","Epargne mensuelle","Banque","Caisse d'Epargne",84.34,0,0]
[null,""]
[]
[]
[]
[]
[]
[]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C50<>\"\",ROW(C50)-13,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"L.A Paul","index":4,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,6,5,7]]}
[]
[null,null,null,"Dates :"]
[]
[null,null,null,"Libellés :",null,null,"Revoir les catégorie et sous-catégorie\npour les livrets d'épargne"]
[]
[null,null,null,"Catégorie :"]
[]
[null,null,null,"Sous-catégorie :"]
[]
[null,null,null,"Bénéficiaire :"]
[]
[null,null,null,"Mode :"]
[]
[null,null,null,"Débit :"]
[]
[null,null,null,"Crédit :"]
[]
[]
[]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","R.B"]
[null,null,"2019-01-01","Solde de départ",null,null,null,null,null,null,100]
[null,null,"2018-01-01","Interets 2018","Banque","Caisse d'Epargne","Moi","Virement",null,55.55,{"$f":"K21-I22+J22","v":155.55000000000001}]
[null,null,"2020-01-01","Interets 2019","Banque","Caisse d'Epargne","Moi","Virement",null,51.51,{"$f":"K22-Tbl_LA_Paul[[#This Row],[Débit]]+Tbl_LA_Paul[[#This Row],[Crédit]]","v":207.06}]
[null,null,"2019-11-02","Epargne mensuelle","Banque","Épargne","Caisse d'Epargne","Cpte à Cpte",null,84.34,{"$f":"K23-Tbl_LA_Paul[[#This Row],[Débit]]+Tbl_LA_Paul[[#This Row],[Crédit]]","v":291.39999999999998}]

{"sheet":"L.A Pauline","index":5,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,6,5,7]]}
[]
[null,null,null,"Dates :"]
[]
[null,null,null,"Libellés :",null,null,"Revoir les catégorie et sous-catégorie\npour les livrets d'épargne"]
[]
[null,null,null,"Catégorie :"]
[]
[null,null,null,"Sous-catégorie :"]
[]
[null,null,null,"Bénéficiaire :"]
[]
[null,null,null,"Mode :"]
[]
[null,null,null,"Débit :"]
[]
[null,null,null,"Crédit :"]
[]
[]
[]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","R.B"]
[null,null,"2019-01-01","Solde de départ",null,null,null,null,null,null,100]
[null,null,"2018-01-01","Interets 2018","Banque","Caisse d'Epargne","Moi","Virement",null,55.55,155.55000000000001]
[null,null,"2020-01-01","Interets 2019","Banque","Caisse d'Epargne","Moi","Virement",null,51.51,207.06]
[null,null,"2019-11-02","Epargne mensuelle","Banque","Épargne","Caisse d'Epargne","Cpte à Cpte",null,84.34,291.39999999999998]

{"sheet":"LEP Paul","index":6,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,6,5,7]]}
[]
[null,null,null,"Dates :"]
[]
[null,null,null,"Libellés :",null,null,"Revoir les catégorie et sous-catégorie\npour les livrets d'épargne"]
[]
[null,null,null,"Catégorie :"]
[]
[null,null,null,"Sous-catégorie :"]
[]
[null,null,null,"Bénéficiaire :"]
[]
[null,null,null,"Mode :"]
[]
[null,null,null,"Débit :"]
[]
[null,null,null,"Crédit :"]
[]
[]
[]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","R.B"]
[null,null,"2019-01-01","Solde de départ",null,null,null,null,null,null,100]
[null,null,"2018-01-01","Interets 2018","Banque","Caisse d'Epargne","Moi","Virement",null,55.55,155.55000000000001]
[null,null,"2020-01-01","Interets 2019","Banque","Caisse d'Epargne","Moi","Virement",null,51.51,207.06]
[null,null,"2019-11-02","Epargne mensuelle","Banque","Épargne","Caisse d'Epargne","Cpte à Cpte",null,84.34,291.39999999999998]

{"sheet":"LEP Pauline","index":7,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,6,5,7]]}
[]
[null,null,null,"Dates :"]
[]
[null,null,null,"Libellés :",null,null,"Revoir les catégorie et sous-catégorie\npour les livrets d'épargne"]
[]
[null,null,null,"Catégorie :"]
[]
[null,null,null,"Sous-catégorie :"]
[]
[null,null,null,"Bénéficiaire :"]
[]
[null,null,null,"Mode :"]
[]
[null,null,null,"Débit :"]
[]
[null,null,null,"Crédit :"]
[]
[]
[]
[null,null,"Dates","Libellés","Catégorie","Sous-catégorie","Bénéficiaire","Mode","Débit","Crédit","Solde","R.B"]
[null,null,"2019-01-01","Solde de départ",null,null,null,null,null,null,100]
[null,null,"2018-01-01","Interets 2018","Banque","Caisse d'Epargne","Moi","Virement",null,55.55,155.55000000000001]
[null,null,"2020-01-01","Interets 2019","Banque","Caisse d'Epargne","Moi","Virement",null,51.51,207.06]
[null,null,"2019-11-02","Epargne mensuelle","Banque","Épargne","Caisse d'Epargne","Cpte à Cpte",null,84.34,291.39999999999998]

{"sheet":"Feuille de travail","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,1,"Date","Label_Date","TextBox_Date"]
[null,null,null,2,"Libellé","Label_Libelle","textBox_Libelle"]
[null,null,null,3,"Catégorie","Label_Categorie","ComboBox_Categorie"]
[null,null,null,4,"Sous-Catégorie","Label_SousCategorie","ListBox_SousCategorie","TextBox_SousCategorie"]
[null,null,null,5,"Mode de paiement","Label_Mode","ComboBox_Mode"]
[null,null,null,6,"Vers quel compte","Label_CptaCpt","ComboBox_CptaCpt"]
[null,null,null,7,"Tiers/Bénéficiere","Label_Tiers","ComboBox_Tiers"]
[null,null,null,8,"Débit","Label-Debit","TextBox_Debit"]
[null,null,null,9,"Crédit","Label_Credit","TextBox_Credit"]
[null,null,null,10,"Annuler","CommandButton_Annuler"]
[null,null,null,11,"Valider","CommandButton_Valider"]

{"sheet":"Ass.Vie Paul","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ass.Vie Pauline","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}