{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Gestion de caisse","BDArticle","Ventes et Analyse"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":6,"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":"Gestion de caisse","index":0,"n_rows":36,"n_cols":39,"rows_kept":36,"cut":false,"hidden":false,"merged":[[37,31,37,32],[22,8,22,9],[26,8,26,9],[7,2,7,5],[8,2,8,5],[6,14,8,22],[11,16,12,21]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"K19","v":1900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remise",{"$f":"K21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net à payer",{"$f":"K23","v":1900}]
[null,null,null,null,null,null,null,null,null,null,"GESTION DE CAISSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versement",10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rendu",{"$f":"K29","v":-1900}]
[]
[null,null," Adresse : Abidjan Cocody ( Riviera 2)"]
[null,null,"Tel : +225 0564912196"]
[]
[null,null,null,null,null,null,null,null,null,"Article","Dentifrice"]
["Ligne Article ",null,null,"Ticket : ",10006]
[{"$f":"IFERROR(MATCH(Q12,BDArticle!J:J,0),\"\")","v":""},null,null,"Caissier :","Admin",null,null,null,null,"Prix",350]
[null,null,null,"Date :",{"$f":"NOW()","v":"2025-06-10T15:45:52.280"}]
[null,null,null,null,null,null,null,null,null,"Quantité",1]
["Ligne Ticket",null,"Libelé","Quantité","P.U","Total"]
[20,null,"Dentifrice",1,350,{"$f":"D17*E17","v":350}]
[null,null,"Démaquillant",1,750,{"$f":"D18*E18","v":750}]
[null,null,"Savon",1,450,{"$f":"D19*E19","v":450},null,null,null,"Total",{"$f":"SUMIF(C17:C500,\"<>\",F17:F500)","v":1900}]
["Nr Reçu Suivant",null,"Dentifrice",1,350,{"$f":"D20*E20","v":350}]
[{"$f":"IFERROR(MAX('Ventes et Analyse'!P2:P998)+1,1000)","v":10006},null,null,null,null,null,null,null,null,"Remise"]
[]
[null,null,null,null,null,null,null,null,"Net à Payer",null,{"$f":"K19-K21","v":1900}]
[]
[null,null,null,null,null,null,null,null,"Type de payement",null,"Mobile money"]
[]
[null,null,null,null,null,null,null,null,"Versement"]
[]
[null,null,null,null,null,null,null,null,null,"Rendu",{"$f":"K27-K23","v":-1900}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,",,,",null,null,null,",,,,,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(\"&$E$12&\")\"","v":"(10006)"}]

{"sheet":"BDArticle","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"ARTICLES"]
["Num  ARTICLE","NOM D'ARTICLE","Prix"]
[1000,"Shampooing",600]
[1001,"Savon",450]
[1002,"Dentifrice",350]
[1003,"Savon Liquide",200,null,null,null,null,null,null,"Num  ARTICLE","NOM D'ARTICLE","Prix"]
[1004,"Masque visage",500,null,null,null,null,null,null,{"$f":"OFFSET(A2,1,0,COUNTA($A$2:$A$998)-1,1)","v":1000},{"$f":"OFFSET(A2,1,1,COUNTA($B$2:$B$998)-1,1)","v":"Shampooing"},{"$f":"OFFSET(A2,1,2,COUNTA($C$2:$C$1048576)-1,1)","v":600}]
[1005,"Parfum dame",1500,null,null,null,null,null,null,1001,"Savon",450]
[1006,"Démaquillant",750,null,null,null,null,null,null,1002,"Dentifrice",350]
[1007,"Gel douche",900,null,null,null,null,null,null,1003,"Savon Liquide",200]
[null,null,null,null,null,null,null,null,null,1004,"Masque visage",500]
[null,null,null,null,null,null,null,null,null,1005,"Parfum dame",1500]
[null,null,null,null,null,null,null,null,null,1006,"Démaquillant",750]
[null,null,null,null,null,null,null,null,null,1007,"Gel douche",900]

{"sheet":"Ventes et Analyse","index":2,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["HISTORIQUE DES VENTES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num de Recu"]
["Num de Recu","Date","Caissier","Article","Quantité","Prix","Total",null,null,null,null,null,null,null,null,{"$f":"OFFSET($A$2,1,0,COUNTA(A3:A998),1)","v":10000}]
[10000,"2025-06-08T14:39:13","Admin","Shampooing",1,600,600,null,"Jours","Quantités","Total Vendu",null,null,null,null,10005]
[10005,"2025-06-09T15:44:02","Admin","Savon",1,450,450,null,"08-juin",1,600,null,null,null,null,10005]
[10005,"2025-06-09T15:44:02","Admin","Masque visage",2,500,1000,null,"09-juin",8,3200,null,null,null,null,10005]
[10005,"2025-06-09T15:44:02","Admin","Dentifrice",1,350,350,null,"Total général",9,3800,null,null,null,null,10005]
[10005,"2025-06-09T15:44:02","Admin","Dentifrice",4,350,1400]