{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Descriptif","Récap Comptes","Listes","Extraits","Extraits_Solutions","Extraits_Tableau","Extraits_Tableau_Solution","Filtres","Filtres_Solution","TCD","TCD_Solution"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":37,"comments":0,"pivot_tables":2},"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":"Descriptif","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ce classeur a été créé afin de permettre au régisseur d'un théâtre de tenir d'une façon simple le relevé de ses entrées et ses sorties (recettes et dépenses)"]
[]
[null,"Afin de rendre les choses automatiques, quelques macros ont été créées :"]
[]
[null,"NB : Le mot de passe qui permet d'afficher le code VBA est 'TEST'"]
[]
[]
[]
[]
[]
[]
[null,"Différentes macros sont disponibles sur certaines feuilles du classeur :"]
[]
[null,"Sur la feuille :",null,"Vous pourrez utiliser les macros suivantes :"]
[]
[null,"'Extraits'",null,"Insérer : ",null,"Permet l'insertion de 2 lignes et la recopie des formules dans le bas du tableau d'encodage des mouvements financiers"]
[]
[null,null,null,"RenommerSourceTCD :",null,"Permet de rédéfinir la zone qui contient les données source du TCD"]
[]
[null,null,null,"NB : Ceci est un exercice. En réalité, il aurait été plus simple de créer un tableau de données structuré et de l'utiliser en tant que source du TCD (CF Ci-dessous)"]
[]
[null,"Extraits_Tableau structué",null,"InsererDansTableau :",null,"Permet l'insertion d'une ligne dans un tableau de données et positionne le curseur en première position de la ligne créée (afin de pouvoir encoder un nouvel enregistrement)"]
[]
[null,"'Filtres'",null,"Filtrer : ",null,"Permet de filtrer les lignes encodées correspondant à un type (libelllé) de recette ou dépense"]
[]
[null,"'TCD'",null,"ActualiserTCD : ",null,"Exécute plusieurs actions et une autre macro :"]
[]
[null,null,null,null,null,"1- Se placer sur le TCD et l'actualiser"]
[null,null,null,null,null,"2- Filtres les éventuelles lignes qui contiennent des vides"]
[null,null,null,null,null,"3- Exécute la macro MiseEnFormeTCD Macro (enregistrée à part, CF ci-dessous)"]
[]
[null,null,null,"MiseEnFormeTCD :",null,"1- Donne une largeur de 15 à toutes les colonnes du TCD, regroupe les dates par année et centre les années"]
[null,null,null,null,null,"2- Ajuste la colonne C à son contenu le plus long"]

{"sheet":"Récap Comptes","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,"I - RECETTES"]
[]
[]
[null,null,"NATURE DES RECETTES ","Compte de l'année"]
[null,null,null,2016]
[]
[]
["R1","R1","Entrées",{"$f":"SUMIF(Codes,B8,Montants)","v":2100}]
["R2","R2","Sponsors",{"$f":"SUMIF(Codes,B9,Montants)","v":2300}]
["R3","R3","Dons",{"$f":"SUMIF(Codes,B10,Montants)","v":0}]
["R4","R4","Subsides",{"$f":"SUMIF(Codes,B11,Montants)","v":0}]
[null,"R5","Autres recettes",{"$f":"SUMIF(Codes,B12,Montants)","v":0}]
[]
[null,null,"Total des recettes",{"$f":"SUM(D8:D12)","v":4400}]
[]
[null,null,"II - DEPENSES"]
[]
[]
[null,null,"NATURE DES DEPENSES"]
[]
[]
["D1","D1","Nourriture  ",{"$f":"SUMIF(Codes,B22,Montants)","v":0}]
["D2","D2","Boissons",-100]
["D3","D3","Chauffage",-1500]
["D4","D4","Eclairage",0]
["D16","D5","Traitement du metteur en scène  ",0]
["D17","D6","Traitement des acteurs",0]
["D20","D7","Traitement du souffleur",0]
["D18","D8","Traitement des employés d'entretien",1000]
[]
[null,null,"Total des dépenses",{"$f":"SUM(D22:D29)","v":-600}]
[]
[null,null,"III  - RECAPITULATION"]
[]
[]
[null,null,"                                    Recettes",{"$f":"D14","v":4400}]
[null,null,"Balance"]
[null,null,"                                    Dépenses",{"$f":"D31","v":-600}]
[null,null,"Excédent  ",{"$f":"D36+D38","v":3800}]
[]
[null,null,"Le présent compte, dressé et déclaré sincère par le trésorier soussigné, est arrêté par le conseil "]
[null,null," d'administration, sous les réserves et observations consignées en tête."]
[]
[]
[null,null,"Ainsi fait en conseil d'administration …               le"]
[]
[null,null,"Le Secrétaire                           Le Président                              Les Membres                                     Le Membre-Trésorier"]

{"sheet":"Listes","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Catégories",null,null,null,null,null,null,null,null,"RETOUR"]
[]
[null,{"$f":"'Récap Comptes'!C8","v":"Entrées"},{"$f":"'Récap Comptes'!B8","v":"R1"}]
[null,{"$f":"'Récap Comptes'!C9","v":"Sponsors"},{"$f":"'Récap Comptes'!B9","v":"R2"}]
[null,{"$f":"'Récap Comptes'!C10","v":"Dons"},{"$f":"'Récap Comptes'!B10","v":"R3"}]
[null,{"$f":"'Récap Comptes'!C11","v":"Subsides"},{"$f":"'Récap Comptes'!B11","v":"R4"}]
[null,{"$f":"'Récap Comptes'!C12","v":"Autres recettes"},{"$f":"'Récap Comptes'!B12","v":"R5"}]
[null,{"$f":"'Récap Comptes'!C22","v":"Nourriture  "},{"$f":"'Récap Comptes'!B22","v":"D1"}]
[null,{"$f":"'Récap Comptes'!C23","v":"Boissons"},{"$f":"'Récap Comptes'!B23","v":"D2"}]
[null,{"$f":"'Récap Comptes'!C24","v":"Chauffage"},{"$f":"'Récap Comptes'!B24","v":"D3"}]
[null,{"$f":"'Récap Comptes'!C25","v":"Eclairage"},{"$f":"'Récap Comptes'!B25","v":"D4"}]
[null,{"$f":"'Récap Comptes'!C26","v":"Traitement du metteur en scène  "},{"$f":"'Récap Comptes'!B26","v":"D5"}]
[null,{"$f":"'Récap Comptes'!C27","v":"Traitement des acteurs"},{"$f":"'Récap Comptes'!B27","v":"D6"}]
[null,{"$f":"'Récap Comptes'!C28","v":"Traitement du souffleur"},{"$f":"'Récap Comptes'!B28","v":"D7"}]
[null,{"$f":"'Récap Comptes'!C29","v":"Traitement des employés d'entretien"},{"$f":"'Récap Comptes'!B29","v":"D8"}]

{"sheet":"Extraits","index":3,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Extraits - Dépenses",null,null,"Filtrer les données",null,null,null,null,null,"RETOUR"]
[]
["Associez aux boutons ci-dessous :"]
[null,"- La macro 'Insérer' :","Permet d'insérer 2 lignes au-dessus de la ligne du total"]
[null,"- La macro 'RenommerSourceTCD' :","Permet de redéfinir une zone nommée qui va de la ligne des titres jusqu'à la ligne avant le total général"]
[]
["N°","Date","Libellé","Code catégorie","Montant","Totaux"]
[8,"2003-08-05","Boissons",{"$f":"_xlfn.XLOOKUP(C8,Catégories,Listes!$C$3:$C$15,\"\")","v":"D2"},-100,{"$f":"IF(E8=\"\",\"\",SUM($E$8:E8))","v":-100}]
[9,"2003-08-06","Sponsors",{"$f":"_xlfn.XLOOKUP(C9,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},1000,{"$f":"IF(E9=\"\",\"\",SUM($E$8:E9))","v":900}]
[11,"2003-08-12","Entrées",{"$f":"_xlfn.XLOOKUP(C10,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E10=\"\",\"\",SUM($E$8:E10))","v":1100}]
[12,"2012-11-11","Sponsors",{"$f":"_xlfn.XLOOKUP(C11,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},500,{"$f":"IF(E11=\"\",\"\",SUM($E$8:E11))","v":1600}]
[13,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C12,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E12=\"\",\"\",SUM($E$8:E12))","v":1100}]
[14,"2016-03-10","Traitement des employés d'entretien",{"$f":"_xlfn.XLOOKUP(C13,Catégories,Listes!$C$3:$C$15,\"\")","v":"D8"},1000,{"$f":"IF(E13=\"\",\"\",SUM($E$8:E13))","v":2100}]
[15,"2016-03-10","Sponsors",{"$f":"_xlfn.XLOOKUP(C14,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},800,{"$f":"IF(E14=\"\",\"\",SUM($E$8:E14))","v":2900}]
[16,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C15,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},1200,{"$f":"IF(E15=\"\",\"\",SUM($E$8:E15))","v":4100}]
[17,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C16,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E16=\"\",\"\",SUM($E$8:E16))","v":4300}]
[18,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C17,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E17=\"\",\"\",SUM($E$8:E17))","v":3800}]
[19,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C18,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E18=\"\",\"\",SUM($E$8:E18))","v":3300}]
[20,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C19,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},500,{"$f":"IF(E19=\"\",\"\",SUM($E$8:E19))","v":3800}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(C20,Catégories,Listes!$C$3:$C$15,\"\")","v":""},"Total général",{"$f":"IF(E20=\"\",\"\",SUM($E$8:E20))","v":3800}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total général"]

{"sheet":"Extraits_Solutions","index":4,"n_rows":118,"n_cols":10,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
["Extraits - Dépenses",null,null,"Filtrer les données",null,null,null,null,null,"RETOUR"]
[]
["Associez aux boutons ci-dessous :"]
[null,"- La macro 'Insérer' :","Permet d'insérer 2 lignes au-dessus de la ligne du total"]
[null,"- La macro 'RenommerSourceTCD' :","Permet de redéfinir une zone nommée qui va de la ligne des titres jusqu'à la ligne avant le total général"]
[]
["N°","Date","Libellé","Code catégorie","Montant","Totaux"]
[8,"2003-08-05","Boissons",{"$f":"_xlfn.XLOOKUP(C8,Catégories,Listes!$C$3:$C$15,\"\")","v":"D2"},-100,{"$f":"IF(E8=\"\",\"\",SUM($E$8:E8))","v":-100}]
[9,"2003-08-06","Sponsors",{"$f":"_xlfn.XLOOKUP(C9,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},1000,{"$f":"IF(E9=\"\",\"\",SUM($E$8:E9))","v":900}]
[11,"2003-08-12","Entrées",{"$f":"_xlfn.XLOOKUP(C10,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E10=\"\",\"\",SUM($E$8:E10))","v":1100}]
[12,"2012-11-11","Sponsors",{"$f":"_xlfn.XLOOKUP(C11,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},500,{"$f":"IF(E11=\"\",\"\",SUM($E$8:E11))","v":1600}]
[13,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C12,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E12=\"\",\"\",SUM($E$8:E12))","v":1100}]
[14,"2016-03-10","Traitement des employés d'entretien",{"$f":"_xlfn.XLOOKUP(C13,Catégories,Listes!$C$3:$C$15,\"\")","v":"D8"},1000,{"$f":"IF(E13=\"\",\"\",SUM($E$8:E13))","v":2100}]
[15,"2016-03-10","Sponsors",{"$f":"_xlfn.XLOOKUP(C14,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},800,{"$f":"IF(E14=\"\",\"\",SUM($E$8:E14))","v":2900}]
[16,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C15,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},1200,{"$f":"IF(E15=\"\",\"\",SUM($E$8:E15))","v":4100}]
[17,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C16,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E16=\"\",\"\",SUM($E$8:E16))","v":4300}]
[18,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C17,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E17=\"\",\"\",SUM($E$8:E17))","v":3800}]
[19,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C18,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E18=\"\",\"\",SUM($E$8:E18))","v":3300}]
[20,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C19,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},500,{"$f":"IF(E19=\"\",\"\",SUM($E$8:E19))","v":3800}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(C20,Catégories,Listes!$C$3:$C$15,\"\")","v":""},null,{"$f":"IF(E20=\"\",\"\",SUM($E$8:E20))","v":""}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(C21,Catégories,Listes!$C$3:$C$15,\"\")","v":""},null,{"$f":"IF(E21=\"\",\"\",SUM($E$8:E21))","v":""}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(C22,Catégories,Listes!$C$3:$C$15,\"\")","v":""},"Total général",{"$f":"IF(E22=\"\",\"\",SUM($E$8:E22))","v":3800}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total général"]

{"sheet":"Extraits_Tableau","index":5,"n_rows":119,"n_cols":10,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
["Extraits - Dépenses",null,null,"Filtrer les données",null,null,null,null,null,"RETOUR"]
[]
["Transformez la plage ci-dessous en tableau de données"]
["Associez au bouton une macro qui permet d'insérer 2 lignes au-dessus de la ligne du total"]
[]
[]
["N°","Date","Libellé","Code catégorie","Montant","Totaux"]
[8,"2003-08-05","Boissons",{"$f":"_xlfn.XLOOKUP(C8,Catégories,Listes!$C$3:$C$15,\"\")","v":"D2"},-100,{"$f":"IF(E8=\"\",\"\",SUM($E$8:E8))","v":-100}]
[9,"2003-08-06","Sponsors",{"$f":"_xlfn.XLOOKUP(C9,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},1000,{"$f":"IF(E9=\"\",\"\",SUM($E$8:E9))","v":900}]
[11,"2003-08-12","Entrées",{"$f":"_xlfn.XLOOKUP(C10,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E10=\"\",\"\",SUM($E$8:E10))","v":1100}]
[12,"2012-11-11","Sponsors",{"$f":"_xlfn.XLOOKUP(C11,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},500,{"$f":"IF(E11=\"\",\"\",SUM($E$8:E11))","v":1600}]
[13,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C12,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E12=\"\",\"\",SUM($E$8:E12))","v":1100}]
[14,"2016-03-10","Traitement des employés d'entretien",{"$f":"_xlfn.XLOOKUP(C13,Catégories,Listes!$C$3:$C$15,\"\")","v":"D8"},-100,{"$f":"IF(E13=\"\",\"\",SUM($E$8:E13))","v":1000}]
[15,"2016-03-10","Sponsors",{"$f":"_xlfn.XLOOKUP(C14,Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},800,{"$f":"IF(E14=\"\",\"\",SUM($E$8:E14))","v":1800}]
[16,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C15,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},1200,{"$f":"IF(E15=\"\",\"\",SUM($E$8:E15))","v":3000}]
[17,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C16,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E16=\"\",\"\",SUM($E$8:E16))","v":3200}]
[18,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C17,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E17=\"\",\"\",SUM($E$8:E17))","v":2700}]
[19,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(C18,Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E18=\"\",\"\",SUM($E$8:E18))","v":2200}]
[20,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(C19,Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},500,{"$f":"IF(E19=\"\",\"\",SUM($E$8:E19))","v":2700}]
["Total",null,null,null,null,{"$f":"IF(Extraits_Tableau!$A20=\"\",\"\",SUM($E$8:E20))","v":2700}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total général"]

{"sheet":"Extraits_Tableau_Solution","index":6,"n_rows":124,"n_cols":10,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["Extraits - Dépenses",null,null,"Filtrer les données",null,null,null,null,null,"RETOUR"]
[]
["Transformez la plage ci-dessous en tableau de données"]
["Associez au bouton une macro qui permet d'insérer 2 lignes au-dessus de la ligne du total"]
[]
[]
["N°","Date","Libellé","Code catégorie","Montant","Totaux"]
[8,"2003-08-05","Boissons",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"D2"},-100,{"$f":"IF(E8=\"\",\"\",SUM($E$8:E8))","v":-100}]
[9,"2003-08-06","Sponsors",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},1000,{"$f":"IF(E9=\"\",\"\",SUM($E$8:E9))","v":900}]
[11,"2003-08-12","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E10=\"\",\"\",SUM($E$8:E10))","v":1100}]
[12,"2012-11-11","Sponsors",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},500,{"$f":"IF(E11=\"\",\"\",SUM($E$8:E11))","v":1600}]
[13,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E12=\"\",\"\",SUM($E$8:E12))","v":1100}]
[14,"2016-03-10","Traitement des employés d'entretien",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"D8"},-100,{"$f":"IF(E13=\"\",\"\",SUM($E$8:E13))","v":1000}]
[15,"2016-03-10","Sponsors",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R2"},800,{"$f":"IF(E14=\"\",\"\",SUM($E$8:E14))","v":1800}]
[16,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},1200,{"$f":"IF(E15=\"\",\"\",SUM($E$8:E15))","v":3000}]
[17,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E16=\"\",\"\",SUM($E$8:E16))","v":3200}]
[18,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E17=\"\",\"\",SUM($E$8:E17))","v":2700}]
[19,"2016-03-10","Chauffage",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"D3"},-500,{"$f":"IF(E18=\"\",\"\",SUM($E$8:E18))","v":2200}]
[20,"2016-03-10","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},500,{"$f":"IF(E19=\"\",\"\",SUM($E$8:E19))","v":2700}]
[21,"2024-11-17","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},200,{"$f":"IF(E20=\"\",\"\",SUM($E$8:E20))","v":2900}]
[22,"2024-11-17","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},300,{"$f":"IF(E21=\"\",\"\",SUM($E$8:E21))","v":3200}]
[23,"2024-11-17","Entrées",{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":"R1"},1500,{"$f":"IF(E22=\"\",\"\",SUM($E$8:E22))","v":4700}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":""},null,{"$f":"IF(E23=\"\",\"\",SUM($E$8:E23))","v":""}]
[null,null,null,{"$f":"_xlfn.XLOOKUP(Tableau1[[#This Row],[Libellé]],Catégories,Listes!$C$3:$C$15,\"\")","v":""},null,{"$f":"IF(E24=\"\",\"\",SUM($E$8:E24))","v":""}]
["Total",null,null,null,null,{"$f":"IF(Tableau1[[#Totals],[N°]]=\"\",\"\",SUM($E$8:E25))","v":4700}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total général"]

{"sheet":"Filtres","index":7,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Retour",null,null,null,null,null,null,null,"RETOUR"]
[]
["Le bouton filtrer permet de filtrer les données de la feuille 'Extraits_Tableau' selon le libellé choisi en A9 via une macro nommée 'Filtrer' "]
["Lorsque la macro est créée, activer la protection de la feuille et exécuter à nouveau la macro"]
["Modifier le code de la macro de façon à éviter le bug"]
[]
[]
["Libellé",null,null,null,null,null,"Les filtres avancés :"]
["Dons"]
[null,null,null,null,null,null,"1- Mise en place",null,"Créer la zone de critère qui sera utilisée",null,null,null,"Libellé"]
["Libellé","Date","Montant",null,null,null,null,null,null,null,null,null,"Dons"]
[]
[null,null,null,null,null,null,null,null,"Créer la zone d'extraction (les colonnes que nous voulons en résultat) qui sera utilisée"]
[]
[null,null,null,null,null,null,null,null,null,"Libellé","Date","Montant"]
[]
[null,null,null,null,null,null,"2- Exécuter le filtre via le ruban 'Données .. Trier et filtrer .. Filtre avancé'"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"NB : Le filtre avancé n'est pas actualisable => il faut le recommencer à chaque ajout / modification des données"]

{"sheet":"Filtres_Solution","index":8,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Retour",null,null,null,null,null,null,null,"RETOUR"]
[]
["Le bouton filtrer permet de filtrer les données de la feuille 'Extraits_Tableau' selon le libellé choisi en A9 via une macro nommée 'Filtrer' "]
["Lorsque la macro est créée, activer la protection de la feuille "]
["Modifier le code de la macro de façon à éviter le bug"]
[]
[]
["Libellé"]
["Entrées"]
[]
["Libellé","Date","Montant"]
["Entrées","2003-08-12",200]
["Entrées","2016-03-10",1200]
["Entrées","2016-03-10",200]
["Entrées","2016-03-10",500]
["Entrées","2024-11-17",200]
["Entrées","2024-11-17",300]
["Entrées","2024-11-17",1500]

{"sheet":"TCD","index":9,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"RETOUR"]
["Le tableau croisé dynamique suivant a été créé : regroupement par type et par année, avec addition des montants en données de synthèse. "]
["Un bouton 'Actualiser TCD' permet d'exécuter une macro 'ActualiserTCD' qui  actualise les données et filtre les 'non-vides' "]
["Une seconde macro 'MiseEnFormeTCD' sera créée pour définir la largeur des colonnes à 15 et la colonne C à son contenu le plus long"]
["Cette seconde macro sera ajoutée à la première"]
[]
[]
[null,null,"Somme des Montants","Années (Date)"]
[null,null,"Libellé","<05/08/2003","2003","2012","2016","2024","Total général"]
[null,null,"Boissons",null,-100,null,null,null,-100]
[null,null,"Chauffage",null,null,null,-1500,null,-1500]
[null,null,"Entrées",null,200,null,1900,2000,4100]
[null,null,"Sponsors",null,1000,500,800,null,2300]
[null,null,"Traitement des employés d'entretien",null,null,null,-100,null,-100]
[null,null,"(vide)"]
[null,null,"Total général",null,1100,500,1100,2000,4700]

{"sheet":"TCD_Solution","index":10,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"RETOUR"]
["Le tableau croisé dynamique suivant a été créé : regroupement par type et par année, avec addition des montants en données de synthèse. "]
["Un bouton 'Actualiser TCD' permet d'exécuter une macro 'ActualiserTCD' qui  actualise les données et filtre les 'non-vides' "]
["Une seconde macro 'MiseEnFormeTCD' sera créée pour définir la largeur des colonnes à 15 et la colonne C à son contenu le plus long"]
["Cette seconde macro sera ajoutée à la première"]
[]
[]
[]
[null,null,"Somme des montants","Années (Date)"]
[null,null,"Libellé","2003","2012","2016","2024","Total général"]
[null,null,"Chauffage",null,null,-1500,null,-1500]
[null,null,"Entrées",200,null,1900,2000,4100]
[null,null,"Sponsors",1000,500,800,null,2300]
[null,null,"Boissons",-100,null,null,null,-100]
[null,null,"Traitement des employés d'entretien",null,null,-100,null,-100]
[null,null,"Total général",1100,500,1100,2000,4700]