{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil1","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,1,9,2],[9,3,9,4],[21,1,24,2],[22,4,23,4],[1,1,1,4],[2,1,2,2],[2,3,2,4],[8,1,8,4]]}
[]
[null,"Bilan"]
[null,"Actif",null,"Passif"]
[null," 10 - 13","Actifs circulants"," 20 - 23","Dettes court terme"]
[null," 14 - 17","Actifs immobilisés"," 24 - 26","Dettes à long terme"]
[null,null,null,28,"Capitaux propres"]
[]
[]
[null,"Résultat"]
[null,"Charges",null,"Produits"]
[null,40,"Charges de matière",30,"Chiffre d'affaires production"]
[null,42,"Charges de marchandises",32,"Ventes de marchandises"]
[null,44,"Charges pour prestation ",34,"Ventes de prestations services"]
[null,null,null,36,"Autres produits"]
[null,49,"Déductions obtenues ",39,"Déductions accordées"]
[null,50,"Charges de personnel",74,"Résultat des titres"]
[null,"  60 - 67","Autres charges d'exploitation",75,"Résultat d'immeuble"]
[null,69,"Amortissements",80,"Résultat exceptionnel"]
[]
[null,null,null,null,null,"0 / 6"]
[]
[null,{"$f":"VLOOKUP(A23,Table,3)","v":"Frais expédition"}]
[87,null,null,60,{"$f":"IF(D23=0,\"\",IF(D23=VLOOKUP(A23,Table,5),\"J U S T E\", \"N o n !\"))","v":"J U S T E"}]
[false]
[]
[]
[]
[]
[]
[{"$f":"IF(A24=TRUE, \"  Cliquer dans le rectangle bleu ou autour des tableaux pour afficher un nouveau nom de compte\",\"\")","v":""}]
[{"$f":"IF(A24=TRUE,\"  Cliquer  sur le groupe qui correspond au compte affiché. Une seule réponse par question !.\",\"\")","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":109,"n_cols":6,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[null,"Table"]
[null,1,1000,"Caisse",{"$f":"LEFT(C2,2)","v":"10"},10]
[null,2,1010,"Poste","10",10]
[null,3,1020,"Banque","10",10]
[null,4,1040,"Effets à recevoir","10",10]
[null,5,1060,"Titres","10",10]
[null,6,1100,"Créances clients","11",10]
[null,7,1108,"Créances douteuses","11",10]
[null,8,1109," + Prov. s/créances -","11",10]
[null,9,1110,"Autres créances","11",10]
[null,10,1140,"Avances salaires","11",10]
[null,11,1170,"Impôt préalable I","11",10]
[null,12,1171,"Impôt préalable II","11",10]
[null,13,1172,"Solde TVA","11",10]
[null,14,1176,"Créance AFC","11",10]
[null,15,1192,"Acomptes aux fournis.","11",10]
[null,16,1193,"Effets protestés","11",10]
[null,17,1200,"Stock ","12",10]
[null,18,1210,"Stock matière","12",10]
[null,19,1420,"Participations","14",14]
[null,20,1440,"Prêts accordés","14",14]
[null,21,1450,"Crédit long terme","14",14]
[null,22,1500,"Machines","15",14]
[null,23,1509,"Amor. s/machines","15",69]
[null,24,1510,"Mobilier","15",14]
[null,25,1519,"Amor. s/mobilier","15",69]
[null,26,1520,"Informatique","15",14]
[null,27,1526,"Logiciels","15",14]
[null,28,1530,"Véhicules","15",14]
[null,29,1539,"Amor. s/véhicules","15",69]
[null,30,1540,"Outillage","15",14]
[null,31,1549,"Amor. s/outillage","15",69]
[null,32,1550,"Installation de stockage","15",14]
[null,33,1570,"Equipement lourd","15",14]
[null,34,1600,"Immeubles","16",14]
[null,35,1630,"Entrepôts","16",14]
[null,36,1700,"Brevets","17",14]
[null,37,1709,"Amor. s/brevets","17",69]
[null,38,1770,"Goodwill","17",14]
[null,39,1779,"Amor. s/goodwill","17",69]
[null,40,2000,"Fournisseurs","20",20]
[null,41,2010,"Dettes à 6 mois","20",20]
[null,42,2030,"Acomptes clients","20",20]
[null,43,2100,"Dettes bancaires","21",20]
[null,44,2110,"Visa Corner Banque","21",20]
[null,45,2150,"Dettes financières","21",20]
[null,46,2170,"Dettes AVS","21",20]
[null,47,2175,"Dettes LPP","21",20]
[null,48,2180,"Dettes Caisse AF","21",20]
[null,49,2200,"TVA due","22",20]
[null,50,2201,"TVA à décaisser","22",20]
[null,51,2230,"Dividendes à verser","22",20]
[null,52,2235,"Tantièmes à verser","22",20]
[null,53,2270,"AVS","22",20]
[null,54,2271,"Caisse pension","22",20]
[null,55,2272,"Caisse compensation","22",20]
[null,56,2300,"Passif transitoire","23",20]
[null,57,2301,"Charges à payer","23",20]
[null,58,2302,"Prod. consta. d'avance","23",20]
[null,59,2440,"Dettes hypoth.","24",24]
[null,60,2500,"Prêt obtenu","25",24]
[null,61,2600,"Fonds de rénovation",{"$f":"LEFT(C62,2)","v":"26"},24]
[null,62,2800,"Capital",{"$f":"LEFT(C63,2)","v":"28"},28]
[null,63,2850,"Privé",{"$f":"LEFT(C64,2)","v":"28"},28]
[null,64,3000,"Production",{"$f":"LEFT(C65,2)","v":"30"},30]
[null,65,3200,"Ventes",{"$f":"LEFT(C66,2)","v":"32"},32]
[null,66,3293,"Commis. versées","32",32]
[null,67,3295," - Pertes /créances +","32",32]
[null,68,3400,"Honoraires","34",34]
[null,69,3600,"Produits  travaux","36",36]
[null,70,3620,"Produits divers","36",36]
[null,71,3660,"Cotisations encaissées","36",36]
[null,72,3900,"Escomptes accordées","39",39]
[null,73,4000,"Achats matière","40",40]
[null,74,4200,"Achats marchandises","42",42]
[null,75,4270,"Frais d'achats","42",42]
[null,76,4400,"Sous-traitance","44",44]
[null,77,4900,"Rabais obtenues","49",49]
[null,78,5000,"Salaires production","50",50]
[null,79,5200,"Salaires","52",50]
[null,80,5270,"Charges sociales","52",50]
[null,81,5280,"Charges de personnel","52",50]
[null,82,6000,"Loyer payé","60",60]
[null,83,6100,"Entretien & répar.","61",60]
[null,84,6110,"Réparations","61",60]
[null,85,6160,"Leasing","61",60]
[null,86,6200,"Frais véhicules","62",60]
[null,87,6280,"Frais expédition","62",60]
[null,88,6300,"Assurances","63",60]
[null,89,6302,"Taxes","63",60]
[null,90,6400,"Electricité","64",60]
[null,91,6500,"Frais adminis.","65",60]
[null,92,6510,"Téléphones","65",60]
[null,93,6520,"Abonnements","65",60]
[null,94,6570,"Frais informatique","65",60]
[null,95,6600,"Publicité","66",60]
[null,96,6700,"ACE","67",60]
[null,97,6710,"Différence de caisse","67",60]
[null,98,6900,"Dépréciations ","69",69]
[null,99,7400,"Produits financiers","74",74]
[null,100,7410,"Charges s/placements","74",74]
[null,101,7500,"Produits d'immeubles","75",75]
[null,102,7502,"Loyers encaissés",{"$f":"LEFT(C103,2)","v":"75"},76]
[null,103,7510,"Charges  s/ immeubles","75",75]
[null,104,7520,"Chauffage de l'immeuble","75",75]
[null,105,8000,"Produits exception.","80",80]
[null,106,8005,"Subventions","80",80]
[null,107,8010,"Charges exceptionnelles","80",80]
[null,108,8015,"Dons obtenus","80",80]