{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Images"],"not_rendered":{"charts":0,"images":14,"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":37,"n_cols":26,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,23,3,24],[11,4,11,5],[4,16,4,17],[1,1,1,5],[8,4,8,5],[2,3,6,6]]}
[]
[]
[null,"Entraînement"]
[null,null,{"$f":"VLOOKUP(B10,M6:T37,8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse :"]
[null,null,null,null,null,null,null,null,null,9,{"$f":"VLOOKUP(J5,V5:W13,2)","v":"?"},null,{"$f":"COUNT(M6:M37)-2","v":30},null,"débit","crédit","solution",null,"Total","Evaluation","Acquis",1,"Caisse",{"$f":"J5","v":9},{"$f":"K5","v":"?"},"Image"]
[null,null,null,null,null,null,null,null,null,9,{"$f":"VLOOKUP(J6,V5:W13,2)","v":"?"},null,0,"Nouvelle série",null,null,null,null,{"$f":"SUM(Q6:R6)","v":0},{"$f":"IF($E$9=\"?\",\"\",IF(S6=0,\"Non acquis\",IF(S6=1,\"En voie d'acquisition\",\"Acquis\")))","v":""},{"$f":"IF(S6=2,1,0)","v":0},2,"Poste",{"$f":"J6","v":9},{"$f":"K6","v":"?"},10]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Envoyé un chèque postal à un fournisseur qui l'encaisse","Créanciers","Poste",null,null,{"$f":"SUM(Q7:R7)","v":0},"",{"$f":"IF(S7=2,1,0)","v":0},3,"Banque",null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Un client paie au comptant","Caisse","Débiteurs",null,null,{"$f":"SUM(Q8:R8)","v":0},"",0,4,"Débiteurs",null,null,7]
[null,null,null,null,{"$f":"IF(B10=M5+1,\"?\",K5)","v":"?"},null,null,null,null,null,null,null,3,"Un  débiteur nous règle par chèque bancaire barré","Banque","Débiteurs",null,null,{"$f":"SUM(Q9:R9)","v":0},"",0,5,"Mobilier","Image Q",{"$f":"INDEX(Z6:Z37,B10+1,0)","v":10},6]
[null,0,{"$f":"VLOOKUP(B10,M6:P37,2)","v":"Nouvelle série"},null,{"$f":"IF(E9=\"?\",\"\",\"Débit\")","v":""},null,null,null,null,null,null,null,4,"Payé un fournisseur par bulletin de versement rose (BV)","Créanciers","Caisse",null,null,{"$f":"SUM(Q10:R10)","v":0},"",0,6,"Créanciers",null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Un débiteur paie par bulletin de versement rose","Poste","Débiteurs",null,null,{"$f":"SUM(Q11:R11)","v":0},"",0,7,"Frais généraux",null,null,11]
[null,null,null,null,{"$f":"IF(B10=M5+1,\"?\",K6)","v":"?"},null,null,null,null,null,null,null,6,"Reçu un avis de débit pour les taxes postales","Frais généraux","Poste",null,null,0,"",0,8,"Rien",null,null,10]
[null,null,null,null,null,{"$f":"IF(E12=\"?\",\"\",\"Crédit\")","v":""},null,null,null,null,null,null,7,"Payé un créancier par mandat de paiement","Créanciers","Poste",null,null,0,"",0,9,"?",null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"Reçu et encaissé un chèque postal d'un client","Caisse","Débiteurs",null,null,0,"",0,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,9,"Un client paie par mandat de paiement","Caisse","Débiteurs",null,null,0,"",0,null,null,null,null,4]
[null,null,null,null,null,0,null,null,null,null,null,null,10,"Payé un créancier par mandat postal","Créanciers","Caisse",null,null,0,"",0,null,null,null,null,3]
[null,null,"Acquis :",{"$f":"SUM($U$6:$U$37)","v":0},null,null,null,null,null,null,null,null,11,"Un débiteur  règle notre BVR par avis de virement","Poste","Débiteurs",null,null,0,"",0,null,null,null,null,12]
[null,null,"Questions posées :",0,"Départ :","00:28:05",null,null,null,null,null,null,12,"Un client paie par mandat de poste interne","Caisse","Débiteurs",null,null,0,"",0,null,null,null,null,3]
[null,null,"Evaluations :",0,"Durée :",{"$f":"NOW()-F18","v":42251.000009837968},null,null,null,null,null,null,13,"Remboursé un prêt par avis de virement.","Créanciers","Poste",null,null,0,"",0,null,null,null,null,2]
[null,120,null,null,null,null,null,null,null,null,null,null,14,"Encaissé un chèque postal tiré sur nous","Caisse","Poste",null,null,0,"",0,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,15,"Un client paie par bulletin de versement orange (BVR)","Poste","Débiteurs",null,null,0,"",0,null,null,null,null,1]
[null,"zoom",null,null,null,null,null,null,null,null,null,null,16,"Reçu du mobilier contre remboursement","Mobilier","Caisse",null,null,0,"",0,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,17,"Nous versons à notre CP par mandat de paiement","Rien","Rien",null,null,0,"",0,null,null,null,null,4]
[null,"© Yvan Péguiron - HEPL 2008",null,null,null,null,null,null,null,null,null,null,18,"Payé un créancier par bulletin de versement orange (BVR)","Créanciers","Caisse",null,null,0,"",0,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,19,"Reçu d'un client un chèque postal barré","Poste","Débiteurs",null,null,0,"",0,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,20,"Payé le loyer par yellow net","Frais généraux","Poste",null,null,0,"",0,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,21,"Vendu un meuble au comptant","Caisse","Mobilier",null,null,0,"",0,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,22,"Payé le téléphone par débit direct du CP","Frais généraux","Poste",null,null,0,"",0,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,23,"Reçu l'avis de crédit de la poste pour notre versement","Poste","Caisse",null,null,0,"",0,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,24,"Reçu l'avis de crédit de la banque pour un virement postal","Banque","Poste",null,null,0,"",0,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,25,"Acheté un bureau à crédit","Mobilier","Créanciers",null,null,0,"",0,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,26,"Payé par virement postal un BVR reçu pour une amende","Frais généraux","Poste",null,null,0,"",0,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,27,"Envoyé un mandat postal à Tante Clara pour l'armoire","Mobilier","Caisse",null,null,0,"",0,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,28,"Un débiteur paie au guichet de la poste notre facture avec BVR","Poste","Débiteurs",null,null,0,"",0,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,29,"Reçu la facture du téléphone, paiement à 30 jours","Rien","Rien",null,null,0,"",0,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,30,"Retrait au distributeur Postomat","Caisse","Poste",null,null,0,"",0,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,31,"Fin de série",null,null,null,null,0,"",0]

{"sheet":"Images","index":1,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[1,2,3,4,5,6,7,8,9,10,11,12]
[]
["BVR orange","Virement rose","Mandat postal","Mandat de paiement","Chèque postal","Chèque bancaire barré","Cash - Liquide - Comptant","Yellownet","Facture","Divers","BV rose","Virement BVR"]