{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["var","journaldepense","journalrecette","Plan comptable","accueil","journalbord"],"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":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"Label","Moyen versement","Annee","Mois","Catégories","Numero de Colonne","Textbox","Intitulé","Manifestations","Catégorie Dépenses",100]
[null,"Essai compta","Chèque","2016/2017","JANVIER","CAI",5,"Textbox1","Fonction","Divers","Produits financiers",101]
[null,"Exercice","Espèce","2016/2018","FEVRIER","CM",6,"Textbox2","Manif","St Sylvestre","Virements internes",102]
[null,"Code comptable","Virement","2016/2019","MARS","LIV",8,"Textbox3","Transp","Manif1","Dépenses fonctionnement",103]
["Dummy","Nr chèque","Autre","2016/2020","AVRIL","CA",7,"Textbox4","Autres","Manif2","Dépenses pour manif",104]
[null,"Montant",null,"2016/2021","MAI",null,6,"Textbox5","Virement interne","Manif3","Frais transport et réunions",105]
[null,"Date",null,"2016/2022","JUIN",null,9,"Textbox6","Caisse","Manif4","Autres dépenses",106]
[null,"Nr Pièce",null,"2016/2023","JUILLET",null,5,"Textbox7","Banque","Manif5","Caisse",107]
[null,"Libellé de la pièce",null,"2016/2024","AOUT",null,6,"Textbox8",null,"Manif6","Banque",108]
[null,"Catégorie de la pièce",null,"2016/2025","SEPTEMBRE",null,7,"Textbox9",null,"Manif7",null,109]
[null,"Plan Comptable",null,"2016/2026","OCTOBRE",null,8,"Textbox10",null,"Manif8",null,110]
[null,"Rubriques",null,null,"NOVEMBRE",null,10,"Textbox11",null,"Manif9",null,111]
[null,"Date activité",null,null,"DECEMBRE",null,11,"Textbox12",null,"Manif10",null,112]
[null,"Date chèque",null,null,null,null,12,"Textbox13",null,"Manif11",null,113]
[null,null,null,null,null,null,null,"Textbox14",null,null,null,114]
[null,null,null,null,null,null,null,"Textbox15",null,null,null,115]
[null,null,null,null,null,null,null,"Textbox16",null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,121]
[null,null,null,null,null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,null,null,null,null,123]
[null,null,null,null,null,null,null,null,null,null,null,124]
[null,null,null,null,null,null,null,null,null,null,null,125]
[null,null,null,null,null,null,null,null,null,null,null,126]
[null,null,null,null,null,null,null,null,null,null,null,127]
[null,null,null,null,null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,null,null,null,null,129]
[null,null,null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,null,null,null,null,131]
[null,null,null,null,null,null,null,null,null,null,null,132]
[null,null,null,null,null,null,null,null,null,null,null,133]
[null,null,null,null,null,null,null,null,null,null,null,134]
[null,null,null,null,null,null,null,null,null,null,null,135]
[null,null,null,null,null,null,null,null,null,null,null,136]
[null,null,null,null,null,null,null,null,null,null,null,137]
[null,null,null,null,null,null,null,null,null,null,null,138]
[null,null,null,null,null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,null,null,null,null,140]
[null,null,null,null,null,null,null,null,null,null,null,141]
[null,null,null,null,null,null,null,null,null,null,null,142]
[null,null,null,null,null,null,null,null,null,null,null,143]
[null,null,null,null,null,null,null,null,null,null,null,144]
[null,null,null,null,null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,null,null,null,null,146]
[null,null,null,null,null,null,null,null,null,null,null,147]
[null,null,null,null,null,null,null,null,null,null,null,148]
[null,null,null,null,null,null,null,null,null,null,null,149]
[null,null,null,null,null,null,null,null,null,null,null,150]

{"sheet":"journaldepense","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"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"]
["Date","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":{"$error":"#REF!"}},{"$f":"SUM(INDEX(maplage,,2))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(maplage,,3))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(maplage,,4))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(maplage,,5))","v":{"$error":"#REF!"}},1000,{"$f":"SUM(INDEX(maplage,,7))","v":{"$error":"#REF!"}}]

{"sheet":"journalrecette","index":2,"n_rows":4,"n_cols":11,"rows_kept":4,"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":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,2))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,3))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,4))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,5))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,6))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(plageValeur,,7))","v":{"$error":"#REF!"}}]

{"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,"Musique",{"$f":"LEFT(A2,2)","v":"60"},{"$f":"LEFT(C2,2)","v":"70"},""]
[60600,"Musique",70001,null,{"$f":"LEFT(A3,2)","v":"60"},{"$f":"LEFT(C3,2)","v":"70"},""]
[60620,null,70002,null,"60","70",""]
[60622,null,70003,"Autres services extérieurs","60","70",""]
[60630,null,70004,"Cartouches encre","60","70",""]
[60640,null,70005,"Ramettes papier","60","70",""]
[60650,null,70006,"Papier photo","60","70",""]
[60660,null,70007,"Affranchissement","60","70",""]
[60670,null,70008,"Location chauffage","60","70",""]
[60700,null,70009,"Location autre","60","70"]
[60720,null,70010,"Téléphone","60","70",""]
[60721,null,70011,"Honoraires","60","70",""]
[60722,null,70012,"Dons et cadeaux","60","70",""]
[60730,null,70013,"Divers","60","70",""]
[60740,null,70014,"Charges diverses gestion","60","70",""]
[60800,null,70016,"Assurances","60","70",""]
[60820,null,70017,"Autres charges financières","60","70",""]
[60821,null,70018,"Divers","60","70",""]
[60822,null,70019,"Charges exceptionnelles","60","70",""]
[60830,null,70020,"Dotation investissement","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":4,"n_cols":11,"rows_kept":4,"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"]
["Date","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":{"$error":"#REF!"}},{"$f":"SUM(INDEX(jbplage,,2))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(jbplage,,3))","v":{"$error":"#REF!"}},{"$f":"SUM(INDEX(jbplage,,4))","v":{"$error":"#REF!"}}]