{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil2 (2)","Feuil1 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil2 (2)","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Nom Région","CIA","Référence Article","Stock Actuel","Catégorie Comptable","Catégorie Achat","Nom Transaction Type","Date de Mouvement","Consommation sortie","Consommation entrée","Filtrage 1","Filtrage 2","Filtrage 3"]
["REGION T8 NORD","2252","AEL542407",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-03-06T07:11:29.999",{"$f":"VLOOKUP(G2,'Feuil1 (2)'!A:B,2,0)","v":"N"},{"$f":"VLOOKUP(G2,'Feuil1 (2)'!A:C,3,0)","v":"N"},{"$f":"IF(I2=\"N\",IF(J2=\"N\",\"A supprimer\",CONCATENATE(B2,C2,I2)),CONCATENATE(B2,C2,I2))","v":"A supprimer"},{"$f":"IF(CONCATENATE(B2,C2)=CONCATENATE(B3,C3),IF(H2<TODAY()-550,IF(H3<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(CONCATENATE(B2,C2)=CONCATENATE(B1,C1),IF(H2<TODAY()-550,IF(H1<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(H2<TODAY()-550,\"\",\"A supprimer\")))","v":"A supprimer"},{"$f":"CONCATENATE(B2,C2)","v":"2252AEL542407"}]
["REGION T8 NORD","2252","AEL542407",1,"APPAREIL -","APPAREIL - RADIATEUR","Réception OA","2022-02-15",{"$f":"VLOOKUP(G3,'Feuil1 (2)'!A:B,2,0)","v":"N"},{"$f":"VLOOKUP(G3,'Feuil1 (2)'!A:C,3,0)","v":"O"},{"$f":"IF(I3=\"N\",IF(J3=\"N\",\"A supprimer\",CONCATENATE(B3,C3,I3)),CONCATENATE(B3,C3,I3))","v":"2252AEL542407N"},{"$f":"IF(CONCATENATE(B3,C3)=CONCATENATE(B4,C4),IF(H3<TODAY()-550,IF(H4<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(CONCATENATE(B3,C3)=CONCATENATE(B2,C2),IF(H3<TODAY()-550,IF(H2<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(H3<TODAY()-550,\"\",\"A supprimer\")))","v":"A supprimer"},{"$f":"CONCATENATE(B3,C3)","v":"2252AEL542407"}]
["REGION T8 NORD","2252","AEL542407",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-04-10T07:11:17.999",{"$f":"VLOOKUP(G4,'Feuil1 (2)'!A:B,2,0)","v":"N"},{"$f":"VLOOKUP(G4,'Feuil1 (2)'!A:C,3,0)","v":"N"},{"$f":"IF(I4=\"N\",IF(J4=\"N\",\"A supprimer\",CONCATENATE(B4,C4,I4)),CONCATENATE(B4,C4,I4))","v":"A supprimer"},{"$f":"IF(CONCATENATE(B4,C4)=CONCATENATE(B5,C5),IF(H4<TODAY()-550,IF(H5<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(CONCATENATE(B4,C4)=CONCATENATE(B3,C3),IF(H4<TODAY()-550,IF(H3<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(H4<TODAY()-550,\"\",\"A supprimer\")))","v":"A supprimer"},{"$f":"CONCATENATE(B4,C4)","v":"2252AEL542407"}]
["REGION T8 NORD","2252","AEL542407",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-08-07T07:11:21",{"$f":"VLOOKUP(G5,'Feuil1 (2)'!A:B,2,0)","v":"N"},{"$f":"VLOOKUP(G5,'Feuil1 (2)'!A:C,3,0)","v":"N"},{"$f":"IF(I5=\"N\",IF(J5=\"N\",\"A supprimer\",CONCATENATE(B5,C5,I5)),CONCATENATE(B5,C5,I5))","v":"A supprimer"},{"$f":"IF(CONCATENATE(B5,C5)=CONCATENATE(B6,C6),IF(H5<TODAY()-550,IF(H6<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(CONCATENATE(B5,C5)=CONCATENATE(B4,C4),IF(H5<TODAY()-550,IF(H4<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(H5<TODAY()-550,\"\",\"A supprimer\")))","v":"A supprimer"},{"$f":"CONCATENATE(B5,C5)","v":"2252AEL542407"}]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-08-07T07:11:21",{"$f":"VLOOKUP(G6,'Feuil1 (2)'!A:B,2,0)","v":"N"},{"$f":"VLOOKUP(G6,'Feuil1 (2)'!A:C,3,0)","v":"N"},{"$f":"IF(I6=\"N\",IF(J6=\"N\",\"A supprimer\",CONCATENATE(B6,C6,I6)),CONCATENATE(B6,C6,I6))","v":"A supprimer"},{"$f":"IF(CONCATENATE(B6,C6)=CONCATENATE(B7,C7),IF(H6<TODAY()-550,IF(H7<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(CONCATENATE(B6,C6)=CONCATENATE(B5,C5),IF(H6<TODAY()-550,IF(H5<TODAY()-550,\"\",\"A supprimer\"),\"A supprimer\"),IF(H6<TODAY()-550,\"\",\"A supprimer\")))","v":"A supprimer"},{"$f":"CONCATENATE(B6,C6)","v":"2252AEL542410"}]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2022-01-13T14:30:24.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Retour BI","2020-05-07T12:30:00"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Retour BI","2022-02-07T10:13:59.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-04-10T07:11:17.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2021-04-16T08:25:56.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2021-02-07T12:20:35"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2021-04-19T11:08:35"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2020-04-10T14:30:09.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2021-11-07T07:11:49"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2021-03-07T07:10:42"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2020-10-22T11:37:43.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Retour BI","2020-10-26T11:32:00"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2021-12-05T07:11:34.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2022-02-02T10:01:20"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2021-09-05T07:10:50"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Réception OA","2020-10-22"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2022-02-06T07:13:37.999"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Mise à jour du coût standard","2020-11-08T07:10:52"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Retour BI","2020-10-26T15:16:00"]
["REGION T8 NORD","2252","AEL542410",1,"APPAREIL -","APPAREIL - RADIATEUR","Transfert du magasin au véhic.","2020-04-30T17:06:11"]

{"sheet":"Feuil1 (2)","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Nom Transaction Type","Consommation sortie","Consommation entrée"]
["Réception OA","N","O"]
["Mise à jour du coût standard","N","N"]
["Transfert du magasin au véhic.","N","N"]
["Retour BI","O","N"]
["Retour BI poste clôture","O","N"]
["Sortie Régul. Inventaire","O","N"]
["Ajustement inventaire physique","O","N"]
["Transfert entre magasins","N","N"]
["Ajustement réception OA","O","N"]
["Sortie Motif Divers","O","N"]
["Réception en transit","N","O"]
["Annulation Retour BI","N","O"]
["Retour BI sous garantie","O","N"]
["Entrée Motif Divers","N","O"]
["Entrée Régul. Inventaire","N","O"]
["Sortie Transfert Inter-agence","O","N"]
["Entrée Transfert Inter-agence","N","O"]
["Livraison en transit","O","N"]
["Sortie Transfert Atelier","O","N"]