{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Descriptif","Récap Comptes","Listes","Extraits","Filtres","TCD"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":"Descriptif","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"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,"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,"'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 autres macros :"]
[null,null,null,null,null,"1- Redéfinit la zone nommée des données du tableau croisé dynamique : RenommerSourceTCD"]
[null,null,null,null,null,"2- Se replacer sur la feuille TCD et actualiser le TCD"]
[null,null,null,null,null,"3- Exécute la macro MiseEnFormeTCD"]
[]
[]
[null,null,null,"MiseEnFormeTCD :",null,"1- Donne une largeur de 12 à 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":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Catégories"]
[]
[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":112,"n_cols":6,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Extraits - Dépenses",null,null,"Filtrer les données"]
[]
["N°","Date","Libellé","Code catégorie","Montant","Totaux"]
[8,"2003-08-05","Boissons",{"$f":"IF(ISNA(VLOOKUP(C4,Catégories_codes,2,FALSE)),\"\",VLOOKUP(C4,Catégories_codes,2,FALSE))","v":"D2"},-100,{"$f":"IF(ISBLANK(E4),\"\",SUM($E$4:E4))","v":-100}]
[9,"2003-08-06","Sponsors","R2",1000,{"$f":"IF(ISBLANK(E5),\"\",SUM($E$4:E5))","v":900}]
[11,"2003-08-12","Entrées","R1",200,{"$f":"IF(ISBLANK(E6),\"\",SUM($E$4:E6))","v":1100}]
[12,"2012-11-11","Sponsors","R2",500,{"$f":"IF(ISBLANK(E7),\"\",SUM($E$4:E7))","v":1600}]
[13,"2016-03-10","Chauffage","D3",-500,{"$f":"IF(ISBLANK(E8),\"\",SUM($E$4:E8))","v":1100}]
[14,"2016-03-10","Traitement des employés d'entretien","D8",1000,{"$f":"IF(ISBLANK(E9),\"\",SUM($E$4:E9))","v":2100}]
[15,"2016-03-10","Sponsors","R2",800,{"$f":"IF(ISBLANK(E10),\"\",SUM($E$4:E10))","v":2900}]
[16,"2016-03-10","Entrées","R1",1200,{"$f":"IF(ISBLANK(E11),\"\",SUM($E$4:E11))","v":4100}]
[17,"2016-03-10","Entrées","R1",200,{"$f":"IF(ISBLANK(E12),\"\",SUM($E$4:E12))","v":4300}]
[18,"2016-03-10","Chauffage","D3",-500,{"$f":"IF(ISBLANK(E13),\"\",SUM($E$4:E13))","v":3800}]
[19,"2016-03-10","Chauffage","D3",-500,{"$f":"IF(ISBLANK(E14),\"\",SUM($E$4:E14))","v":3300}]
[20,"2016-03-10","Entrées","R1",500,{"$f":"IF(ISBLANK(E15),\"\",SUM($E$4:E15))","v":3800}]
[null,null,null,"","Total général",{"$f":"IF(ISBLANK(E16),\"\",SUM($E$4:E16))","v":3800}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total général"]

{"sheet":"Filtres","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Retour"]
[]
["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]

{"sheet":"TCD","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["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 de redéfinir la zone source du TCD et d'actualiser les données (avec redimension des colonnes à 12)"]
[]
[]
[]
[null,null,"Somme","Date"]
[null,null,"Libellé","2003","2012","2016","Total général"]
[null,null,"Chauffage",null,null,-1500,-1500]
[null,null,"Entrées",200,null,1900,2100]
[null,null,"Sponsors",1000,500,800,2300]
[null,null,"Boissons",-100,null,null,-100]
[null,null,"Traitement des employés d'entretien",null,null,1000,1000]
[null,null,"Total général",1100,500,2200,3800]