{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["var","journaldepense","journalrecette","Plan comptable","accueil","journalbord","Feuil2","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"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":"var","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Label","Moyen versement","Annee","Mois","Catégories","Textbox","Intitulé","Manifestations","Catégorie Dépenses",193]
[null,"Essai compta","Chèque","2016/2017","JANVIER","BQUE","Textbox1","Fonction","Divers","Produits financiers"]
[null,"Exercice","Espèce","2016/2018","FÉVRIER","CAIS","Textbox2","Manif","Location","Virements internes"]
[null,"Code comptable","Virement","2016/2019","MARS","LOC","Textbox3","Transp","St Sylvestre","Dépenses fonctionnement"]
["Dummy","Nr chèque","Autre","2016/2020","AVRIL","LIV","Textbox4","Autres","Manif1","Dépenses pour manif"]
[null,"Montant",null,"2016/2021","MAI",null,"Textbox5","Virement interne","Manif2","Frais transport et réunions"]
[null,"Date",null,"2016/2022","JUIN",null,"Textbox6","Caisse","Manif3","Autres dépenses"]
[null,"Nr Pièce",null,"2016/2023","JUILLET",null,"Textbox7","Banque","Manif4","Caisse"]
[null,"Libellé de la pièce",null,"2016/2024","AOÛT",null,"Textbox8",null,"Manif5","Banque"]
[null,"Catégorie de la pièce",null,"2016/2025","SEPTEMBRE",null,"Textbox9",null,"Manif6"]
[null,"Plan Comptable",null,"2016/2026","OCTOBRE",null,"Textbox10",null,"Manif7"]
[null,"Rubriques",null,null,"NOVEMBRE",null,"Textbox11",null,"Manif8"]
[null,"Date activité",null,null,"DÉCEMBRE",null,"Textbox12",null,"Manif9"]
[null,"Date chèque",null,null,null,null,"Textbox13",null,"Manif10"]
[null,null,null,null,null,null,"Textbox14"]
[null,null,null,null,null,null,"Textbox15"]
[null,null,null,null,null,null,"Textbox16"]

{"sheet":"journaldepense","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[1,0,1,10]]}
["COMPTA"]
["Journal Dépenses"]
["Location","N°\n pièce","Code\ncompte","Libellé opération","Dépenses\nfonction","Dépenses\nManif","Dépenses\ntransports","Autres\ndépenses","Virement\ninterne","Caisse","Banque"]
[null,null,null,"Report",{"$f":"SUM(INDEX(maplage,,1))","v":0},{"$f":"SUM(INDEX(maplage,,2))","v":0},{"$f":"SUM(INDEX(maplage,,3))","v":0},{"$f":"SUM(INDEX(maplage,,4))","v":0},{"$f":"SUM(INDEX(maplage,,5))","v":0},{"$f":"SUM(INDEX(maplage,,6))","v":1000},{"$f":"SUM(INDEX(maplage,,7))","v":3000}]
["Dummy"]
["3/6/2017","CAI192",60600,"ESSAI",null,null,null,null,null,1000]
["3/6/2017","BQE193",60622,"ESSAI1",null,null,null,null,null,null,3000]

{"sheet":"journalrecette","index":2,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[0,0,0,10],[1,0,1,10]]}
["Compta - "]
["Journal recettes"]
["Date","N° pièce","Code\ncompte","Libellé opération","Recettes\nlocations","Recettes\nManif","Sub/dons","Autres","Virement\ninterne","Caisse","Banque"]
[null,null,null,"Report",{"$f":"SUM(INDEX(plageValeur,,1))","v":0},{"$f":"SUM(INDEX(plageValeur,,2))","v":0},{"$f":"SUM(INDEX(plageValeur,,3))","v":0},{"$f":"SUM(INDEX(plageValeur,,4))","v":0},{"$f":"SUM(INDEX(plageValeur,,5))","v":0},{"$f":"SUM(INDEX(plageValeur,,6))","v":0},{"$f":"SUM(INDEX(plageValeur,,7))","v":0}]
["Dummy"]

{"sheet":"Plan comptable","index":3,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Code","Libellé","code","libellé","extraitdep","extraitrec",""]
[60000,"Sacem",70000,"Subventions",{"$f":"LEFT(A2,2)","v":"60"},{"$f":"LEFT(C2,2)","v":"70"},""]
[60600,"Musique",70001,"Inscriptions",{"$f":"LEFT(A3,2)","v":"60"},{"$f":"LEFT(C3,2)","v":"70"},""]
[60620,"Autres services extérieurs",70002,null,"60","70",""]
[60622,"Cartouches encre",70003,null,"60","70",""]
[60630,"Ramettes papier",70004,null,"60","70",""]
[60640,"Papier photo",70005,null,"60","70",""]
[60650,"Affranchissement",70006,null,"60","70",""]
[60660,"Location chauffage",70007,null,"60","70",""]
[60670,"Location autre",70008,null,"60","70",""]
[60700,"Téléphone",70009,null,"60","70"]
[60720,"Honoraires",70010,null,"60","70",""]
[60721,"Dons et cadeaux",70011,null,"60","70",""]
[60722,"Divers",70012,null,"60","70",""]
[60730,"Charges diverses gestion",70013,null,"60","70",""]
[60740,"Assurances",70014,null,"60","70",""]
[60800,"Autres charges financières",70016,null,"60","70",""]
[60820,"Divers",70017,null,"60","70",""]
[60821,"Charges exceptionnelles",70018,null,"60","70",""]
[60822,"Dotation investissement",70019,null,"60","70",""]
[60830,null,70020,null,"60","70",""]
[60840,null,null,null,"60","",""]
[60850,null,null,null,"60"]
[61622,null,null,null,{"$f":"LEFT(A24,2)","v":"61"}]
[61630,null,null,null,{"$f":"LEFT(A25,2)","v":"61"}]
[61640,null,null,null,{"$f":"LEFT(A26,2)","v":"61"}]
[62000,null,null,null,{"$f":"LEFT(A27,2)","v":"62"}]
[62100,null,null,null,{"$f":"LEFT(A28,2)","v":"62"}]
[62101,null,null,null,"62"]
[62102,null,null,null,"62"]
[62200,null,null,null,"62"]
[62300,null,null,null,"62"]
[62400,null,null,null,"62"]
[62500,null,null,null,"62"]
[62600,null,null,null,"62"]
[62700,null,null,null,"62"]
[62800,null,null,null,"62"]
[65000,null,null,null,{"$f":"LEFT(A38,2)","v":"65"}]
[66000,null,null,null,"66"]
[66100,null,null,null,"66"]
[66200,null,null,null,"66"]
[66300,null,null,null,"66"]
[67000,null,null,null,"67"]
[68000,null,null,null,"68"]

{"sheet":"accueil","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"journalbord","index":5,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[0,0,0,10]]}
["COMPTA"]
["Journal de bord opérations"]
["Divers","N°\n pièce","Code\ncompte","Intitulé","Libellé","Activité","Débit C.M.","Crédit C.M.","Débit\n Caisse","Crédit\n Caisse","Solde\n livret C.M."]
[null,null,null,null,null,"Report",{"$f":"SUM(INDEX(jbplage,,1))","v":3000},{"$f":"SUM(INDEX(jbplage,,2))","v":0},{"$f":"SUM(INDEX(jbplage,,3))","v":1000},{"$f":"SUM(INDEX(jbplage,,4))","v":0}]
["Dummy"]
["06/03/2017","CAI192",60600,"Musique","ESSAI","Divers",null,null,1000]
["2017-06-03","BQE193",60622,"Cartouches encre","ESSAI1","St Sylvestre",3000]

{"sheet":"Feuil2","index":6,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,9]]}
["Synthèse journal "]
[]
["Location","Code\nDépenses","Libellé","Dépenses\nBanque","Dépense\nCaisse","Code\nRecettes","Libellé","Recette\nBanque","Recette\nCaisse","Résultat"]
[null,null,"Total",{"$f":"SUM(D5:D500)","v":3030},{"$f":"SUM(E5:E500)","v":0},null,"Total",{"$f":"SUM(H5:H500)","v":20},{"$f":"SUM(I5:I500)","v":0},{"$f":"SUM(H4+I4) - (D4+E4)","v":-3010}]
["Dummy",null,null,30,null,70000,"Subventions",20]
[null,60622,"Cartouches encre",3000]

{"sheet":"Feuil1","index":7,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Compta -Bilan Activité"]
["Activité","Date activité","Date opération","Bilan"]
["Divers"]
["Numéro compte","Intitulé","Libellé","Recettes","Dépenses"]