{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inventaire","Transfert","Compte magasin","Compte magasin1"],"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":"Inventaire","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["جرد المخزون",{"$f":"NOW()","v":"2024-04-09T11:41:37.540"},{"$f":"SUBTOTAL(9,C3:C12)","v":292},{"$f":"SUBTOTAL(9,D3:D12)","v":329},null,null,null,null,null,{"$f":"SUBTOTAL(9,J3:J12)","v":193},{"$f":"SUBTOTAL(9,K3:K12)","v":186}]
[]
["Code article","Catégorie","Stock initial","Stock actuel","Seuil d'alerte","Descriptif","Référence","Unité \nde mesure","Observations","Entrées","Sorties","Magasin"]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE",5,20,10,"ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg","KG","Transfert",15,49,"OA01"]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE",22,31,10,"ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg","KG","Transfert",53,25,"KH01"]
["EL001.0144","MATERIELS ELECTRIQUES",20,{"$f":"C6+J6-K6","v":20},2,"BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A","PE","Transfert",null,null,"OA01"]
["EL001.0144","MATERIELS ELECTRIQUES",15,{"$f":"C7+J7-K7","v":20},2,"BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A","PE","Transfert",5,null,"SA01"]
["EL001.0144","MATERIELS ELECTRIQUES",20,{"$f":"C8+J8-K8","v":45},2,"BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A","PE","Transfert",25,null,"TE01"]
["EL001.0144","MATERIELS ELECTRIQUES",45,{"$f":"C9+J9-K9","v":20},2,"BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A","PE","Transfert",45,70,"KH01"]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE",162,{"$f":"C10+J10-K10","v":155},10,"ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg","KG","Transfert",35,42,"TE01"]
["EL001.0144","MATERIELS ELECTRIQUES",3,18,2,"BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A","PE","Transfert",15,null,"JO01"]

{"sheet":"Transfert","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,8]]}
[]
[null,null,"Transfert entre magasins"]
["Code article ","Catégories","Désignation","Référence","Stock actuel","Unité","Date","Provenance","Destination","Quantité transférée","STOCK PR","STOCK DES","number","Data time"]
["CS010.1630","CONSOMMABLES","PLAQUETTE TPKN ","16-03-PP-R SM30 P30 M30 ",null,"PE","2020-12-15","TE01","OA01",7,null,null,1]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2020-12-15","TE01","OA01",5,null,null,2]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2020-12-22","TE01","SA01",33,null,null,3]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","TE01",10,null,null,4]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","TE01",3,null,null,5]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","TE01",10,null,null,6]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","TE01",7,null,null,7]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","JO01",3,null,null,8]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","TE01",5,null,null,9]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","JO01",15,null,null,10]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","SA01",15,null,null,11]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","SA01",5,null,null,12]
["EL001.0144","MATERIELS ELECTRIQUES","BALLAST INDECLAIR","TYPE : BS 1X40W 220V 50HZ 0,47A",null,"PE","2020-12-22","KH01","OA01",20,null,null,13]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2020-12-22","TE01","KH01",22,null,null,14]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2020-12-22","TE01","KH01",20,null,null,15]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",5,null,null,16]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",2,null,null,17]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",2,null,null,18]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",22,null,null,19]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",5,null,null,20]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","OA01",5,null,null,21]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","OA01","TE01",5,null,null,22]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","OA01","TE01",8,null,null,23]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","OA01","TE01",5,null,null,24]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","TE01",5,null,null,25]
["SM004.0032","6013 DIAM3,2   PAQUET=5kg","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","JO01",2,null,null,26]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","OA01",5,null,null,27]
["SM004.0032","MATERIELS DE SOUDAGE ET DE MEULAGE","ELECTRODE RUTILE 6013 DIAM3,2 ","6013 DIAM3,2   PAQUET=5kg",null,"KG","2024-02-06","KH01","OA01",15,null,null,28]

{"sheet":"Compte magasin","index":2,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Code article ","Catégories","Désignation","Référence","Stock actuel","Unité","Date","Provenance","Destination","Quantité transférée","STOCK PR","STOCK DES","number"]
["CS010.1630","CONSOMMABLES","PLAQUETTE TPKN ","16-03-PP-R SM30 P30 M30 ",null,"PE","2020-12-15","TE01","OA01",7,null,null,1]

{"sheet":"Compte magasin1","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Compte","Identifiant","Type de facture"]
["TEMARA","TE01","Acte de vente"]
["KHOURIBGA","KH01","reçu"]
["OULAD AYED","OA01","Transferts"]
["JORF","JO01","Retours de vente"]
["SAFI","SA01","Retour d'achat"]