{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Listes","Fiche_CLEAN","Bon_Mouvement_CLEAN"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Listes","index":0,"n_rows":7,"n_cols":5,"rows_kept":7}
["Unités","Statut","Type","Méthode","Magasins (ex.)"]
["PIECE","Libre","BE","FIFO","MG01"]
["KG","Quarantaine","BS","FEFO","MG02"]
["L","Bloqué",null,"LIFO","MG03"]
["M"]
["PACK"]
["PAL"]

{"sheet":"Fiche_CLEAN","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[0,0,0,10]]}
["FICHE DE STOCK — CONCEPTION CLEAN"]
[]
["Code article","Désignation","Famille","Unité","Code-barres","Statut","Méthode","Magasin","Emplacement","Seuil Mini","Seuil Maxi"]
[]
[]
["Stock initial","Conso/j","LT (j)","SS","ROP","PMP","Stock actuel","Valeur stock","Couverture (j)","Sous ROP ?","QR (texte)"]
[0,0,1,{"$f":"ROUNDUP(0.30*$B$7*SQRT($C$7),0)","v":null},{"$f":"ROUNDUP($B$7*$C$7+$D$7,0)","v":null},0,{"$f":"MAX(0,$A$7+SUM($D$12:$D$33))","v":null},{"$f":"IF($F$7<>\"\",$F$7*$G$7,\"\")","v":null},{"$f":"IFERROR($G$7/$B$7,\"\")","v":null},{"$f":"IF(AND($G$7<>\"\",$E$7<>\"\"),IF($G$7<=$E$7,\"OUI\",\"NON\"),\"\")","v":null},"LCG|TYPE=FICHE|ART={A4}|V=CLEAN"]
[]
[]
["Date","Type","Qté","Signed","Empl.","Lot/Série","DLC/DPF","Observation","Valeur (PMP)","Mvt#"]
[{"$nulls":3},{"$f":"IF(B11=\"BE\",C11,-C11)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D11<>\"\"),D11*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B12=\"BE\",C12,-C12)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D12<>\"\"),D12*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B13=\"BE\",C13,-C13)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D13<>\"\"),D13*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B14=\"BE\",C14,-C14)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D14<>\"\"),D14*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B15=\"BE\",C15,-C15)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D15<>\"\"),D15*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B16=\"BE\",C16,-C16)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D16<>\"\"),D16*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B17=\"BE\",C17,-C17)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D17<>\"\"),D17*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B18=\"BE\",C18,-C18)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D18<>\"\"),D18*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B19=\"BE\",C19,-C19)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D19<>\"\"),D19*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B20=\"BE\",C20,-C20)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D20<>\"\"),D20*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B21=\"BE\",C21,-C21)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D21<>\"\"),D21*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B22=\"BE\",C22,-C22)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D22<>\"\"),D22*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B23=\"BE\",C23,-C23)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D23<>\"\"),D23*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B24=\"BE\",C24,-C24)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D24<>\"\"),D24*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B25=\"BE\",C25,-C25)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D25<>\"\"),D25*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B26=\"BE\",C26,-C26)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D26<>\"\"),D26*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B27=\"BE\",C27,-C27)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D27<>\"\"),D27*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B28=\"BE\",C28,-C28)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D28<>\"\"),D28*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B29=\"BE\",C29,-C29)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D29<>\"\"),D29*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B30=\"BE\",C30,-C30)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D30<>\"\"),D30*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B31=\"BE\",C31,-C31)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D31<>\"\"),D31*$F$7,\"\")","v":null}]
[{"$nulls":3},{"$f":"IF(B32=\"BE\",C32,-C32)","v":null},{"$nulls":4},{"$f":"IF(AND($F$7<>\"\",D32<>\"\"),D32*$F$7,\"\")","v":null}]
["Σ",null,null,{"$f":"SUM(D11:D32)","v":null},{"$nulls":4},{"$f":"SUM(I11:I32)","v":null}]

{"sheet":"Bon_Mouvement_CLEAN","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"merged":[[0,0,0,10],[30,0,30,2],[30,3,30,5],[30,6,30,8],[30,9,30,10]]}
["BON DE MOUVEMENT — CONCEPTION CLEAN (Imprimable)"]
[]
["Type (BE/BS)","N° Bon","Date & heure","Magasin","Emplacement","Rédacteur","Motif","Statut","QR (texte)","—","—"]
[{"$nulls":8},"LCG|TYPE=BM|DOC={A4}-{B4}|V=CLEAN"]
[]
["Code article","Désignation","Lot/Série","DLC/DPF","Empl.","Qté","Unité","Prix PMP","Valeur","Observation"]
[{"$nulls":8},{"$f":"IF(AND(F7<>\"\",H7<>\"\"),F7*H7,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F8<>\"\",H8<>\"\"),F8*H8,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F9<>\"\",H9<>\"\"),F9*H9,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F10<>\"\",H10<>\"\"),F10*H10,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F11<>\"\",H11<>\"\"),F11*H11,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F12<>\"\",H12<>\"\"),F12*H12,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F13<>\"\",H13<>\"\"),F13*H13,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F14<>\"\",H14<>\"\"),F14*H14,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F15<>\"\",H15<>\"\"),F15*H15,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F16<>\"\",H16<>\"\"),F16*H16,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F17<>\"\",H17<>\"\"),F17*H17,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F18<>\"\",H18<>\"\"),F18*H18,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F19<>\"\",H19<>\"\"),F19*H19,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F20<>\"\",H20<>\"\"),F20*H20,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F21<>\"\",H21<>\"\"),F21*H21,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F22<>\"\",H22<>\"\"),F22*H22,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F23<>\"\",H23<>\"\"),F23*H23,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F24<>\"\",H24<>\"\"),F24*H24,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F25<>\"\",H25<>\"\"),F25*H25,\"\")","v":null}]
[{"$nulls":8},{"$f":"IF(AND(F26<>\"\",H26<>\"\"),F26*H26,\"\")","v":null}]
[]
[{"$nulls":7},"Total valeur :",{"$f":"SUM(I7:I26)","v":null}]
[]
[]
["Émetteur",null,null,"Qualité",null,null,"Magasin",null,null,"Client/Transport"]