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

{"sheet":"Listes","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
["Unités","Types"]
["PIECE","BE"]
["KG","BS"]
["L"]
["M"]
["PACK"]
["PAL"]

{"sheet":"KARDEX","index":1,"n_rows":45,"n_cols":16,"rows_kept":45,"merged":[[0,0,0,15]]}
["FICHE KARDEX — Ledger continu (PMP en moyenne pondérée)"]
[]
["Code article","Désignation","Famille","Unité","Magasin","Emplacement","Seuil mini","Seuil maxi","Conso/j","LT (j)","z","σ/μ","SS","ROP","PMP init.","Qté init."]
[{"$nulls":12},{"$f":"ROUNDUP($L$4*$I$4*SQRT($J$4),0)","v":null},{"$f":"ROUNDUP($I$4*$J$4+$M$4,0)","v":null},null,{"$f":"IF($O$4<>\"\",$O$4*$M$4*0+ $P$4*0,\"\")","v":null}]
["(SS = z×σ/μ×Conso×√LT ; ROP = Conso×LT + SS)"]
[]
[]
[]
[]
[]
[]
[{"$nulls":12},"Solde initial",{"$f":"IF($P$4<>\"\",$P$4,0)","v":null},{"$f":"IF($O$4<>\"\",$O$4,0)","v":null},{"$f":"N12*O12","v":null}]
["Date","Type","N° Bon","Tiers","Empl.","Lot/Série","DLC/DPF","Entrée","Sortie","U","PMP (Entrée)","Valeur Entrée","Valeur Sortie","Solde Qté","PMP courant","Solde Valeur"]
[{"$nulls":11},{"$f":"IF(AND(H14<>\"\",K14<>\"\"),H14*K14,\"\")","v":null},{"$f":"IF(I14<>\"\",I14*$O$12,\"\")","v":null},{"$f":"IF(OR(H14<>\"\",I14<>\"\"),$N$12+H14-I14,$N$12)","v":null},{"$f":"IF(H14>0,IF(($N$12+H14)=0,$O$12,($P$12+L14)/($N$12+H14)),$O$12)","v":null},{"$f":"N14*O14","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H15<>\"\",K15<>\"\"),H15*K15,\"\")","v":null},{"$f":"IF(I15<>\"\",I15*O14,\"\")","v":null},{"$f":"IF(OR(H15<>\"\",I15<>\"\"),N14+H15-I15,N14)","v":null},{"$f":"IF(H15>0,IF((N14+H15)=0,O14,(P14+L15)/(N14+H15)),O14)","v":null},{"$f":"N15*O15","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H16<>\"\",K16<>\"\"),H16*K16,\"\")","v":null},{"$f":"IF(I16<>\"\",I16*O15,\"\")","v":null},{"$f":"IF(OR(H16<>\"\",I16<>\"\"),N15+H16-I16,N15)","v":null},{"$f":"IF(H16>0,IF((N15+H16)=0,O15,(P15+L16)/(N15+H16)),O15)","v":null},{"$f":"N16*O16","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H17<>\"\",K17<>\"\"),H17*K17,\"\")","v":null},{"$f":"IF(I17<>\"\",I17*O16,\"\")","v":null},{"$f":"IF(OR(H17<>\"\",I17<>\"\"),N16+H17-I17,N16)","v":null},{"$f":"IF(H17>0,IF((N16+H17)=0,O16,(P16+L17)/(N16+H17)),O16)","v":null},{"$f":"N17*O17","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H18<>\"\",K18<>\"\"),H18*K18,\"\")","v":null},{"$f":"IF(I18<>\"\",I18*O17,\"\")","v":null},{"$f":"IF(OR(H18<>\"\",I18<>\"\"),N17+H18-I18,N17)","v":null},{"$f":"IF(H18>0,IF((N17+H18)=0,O17,(P17+L18)/(N17+H18)),O17)","v":null},{"$f":"N18*O18","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H19<>\"\",K19<>\"\"),H19*K19,\"\")","v":null},{"$f":"IF(I19<>\"\",I19*O18,\"\")","v":null},{"$f":"IF(OR(H19<>\"\",I19<>\"\"),N18+H19-I19,N18)","v":null},{"$f":"IF(H19>0,IF((N18+H19)=0,O18,(P18+L19)/(N18+H19)),O18)","v":null},{"$f":"N19*O19","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H20<>\"\",K20<>\"\"),H20*K20,\"\")","v":null},{"$f":"IF(I20<>\"\",I20*O19,\"\")","v":null},{"$f":"IF(OR(H20<>\"\",I20<>\"\"),N19+H20-I20,N19)","v":null},{"$f":"IF(H20>0,IF((N19+H20)=0,O19,(P19+L20)/(N19+H20)),O19)","v":null},{"$f":"N20*O20","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H21<>\"\",K21<>\"\"),H21*K21,\"\")","v":null},{"$f":"IF(I21<>\"\",I21*O20,\"\")","v":null},{"$f":"IF(OR(H21<>\"\",I21<>\"\"),N20+H21-I21,N20)","v":null},{"$f":"IF(H21>0,IF((N20+H21)=0,O20,(P20+L21)/(N20+H21)),O20)","v":null},{"$f":"N21*O21","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H22<>\"\",K22<>\"\"),H22*K22,\"\")","v":null},{"$f":"IF(I22<>\"\",I22*O21,\"\")","v":null},{"$f":"IF(OR(H22<>\"\",I22<>\"\"),N21+H22-I22,N21)","v":null},{"$f":"IF(H22>0,IF((N21+H22)=0,O21,(P21+L22)/(N21+H22)),O21)","v":null},{"$f":"N22*O22","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H23<>\"\",K23<>\"\"),H23*K23,\"\")","v":null},{"$f":"IF(I23<>\"\",I23*O22,\"\")","v":null},{"$f":"IF(OR(H23<>\"\",I23<>\"\"),N22+H23-I23,N22)","v":null},{"$f":"IF(H23>0,IF((N22+H23)=0,O22,(P22+L23)/(N22+H23)),O22)","v":null},{"$f":"N23*O23","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H24<>\"\",K24<>\"\"),H24*K24,\"\")","v":null},{"$f":"IF(I24<>\"\",I24*O23,\"\")","v":null},{"$f":"IF(OR(H24<>\"\",I24<>\"\"),N23+H24-I24,N23)","v":null},{"$f":"IF(H24>0,IF((N23+H24)=0,O23,(P23+L24)/(N23+H24)),O23)","v":null},{"$f":"N24*O24","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H25<>\"\",K25<>\"\"),H25*K25,\"\")","v":null},{"$f":"IF(I25<>\"\",I25*O24,\"\")","v":null},{"$f":"IF(OR(H25<>\"\",I25<>\"\"),N24+H25-I25,N24)","v":null},{"$f":"IF(H25>0,IF((N24+H25)=0,O24,(P24+L25)/(N24+H25)),O24)","v":null},{"$f":"N25*O25","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H26<>\"\",K26<>\"\"),H26*K26,\"\")","v":null},{"$f":"IF(I26<>\"\",I26*O25,\"\")","v":null},{"$f":"IF(OR(H26<>\"\",I26<>\"\"),N25+H26-I26,N25)","v":null},{"$f":"IF(H26>0,IF((N25+H26)=0,O25,(P25+L26)/(N25+H26)),O25)","v":null},{"$f":"N26*O26","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H27<>\"\",K27<>\"\"),H27*K27,\"\")","v":null},{"$f":"IF(I27<>\"\",I27*O26,\"\")","v":null},{"$f":"IF(OR(H27<>\"\",I27<>\"\"),N26+H27-I27,N26)","v":null},{"$f":"IF(H27>0,IF((N26+H27)=0,O26,(P26+L27)/(N26+H27)),O26)","v":null},{"$f":"N27*O27","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H28<>\"\",K28<>\"\"),H28*K28,\"\")","v":null},{"$f":"IF(I28<>\"\",I28*O27,\"\")","v":null},{"$f":"IF(OR(H28<>\"\",I28<>\"\"),N27+H28-I28,N27)","v":null},{"$f":"IF(H28>0,IF((N27+H28)=0,O27,(P27+L28)/(N27+H28)),O27)","v":null},{"$f":"N28*O28","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H29<>\"\",K29<>\"\"),H29*K29,\"\")","v":null},{"$f":"IF(I29<>\"\",I29*O28,\"\")","v":null},{"$f":"IF(OR(H29<>\"\",I29<>\"\"),N28+H29-I29,N28)","v":null},{"$f":"IF(H29>0,IF((N28+H29)=0,O28,(P28+L29)/(N28+H29)),O28)","v":null},{"$f":"N29*O29","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H30<>\"\",K30<>\"\"),H30*K30,\"\")","v":null},{"$f":"IF(I30<>\"\",I30*O29,\"\")","v":null},{"$f":"IF(OR(H30<>\"\",I30<>\"\"),N29+H30-I30,N29)","v":null},{"$f":"IF(H30>0,IF((N29+H30)=0,O29,(P29+L30)/(N29+H30)),O29)","v":null},{"$f":"N30*O30","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H31<>\"\",K31<>\"\"),H31*K31,\"\")","v":null},{"$f":"IF(I31<>\"\",I31*O30,\"\")","v":null},{"$f":"IF(OR(H31<>\"\",I31<>\"\"),N30+H31-I31,N30)","v":null},{"$f":"IF(H31>0,IF((N30+H31)=0,O30,(P30+L31)/(N30+H31)),O30)","v":null},{"$f":"N31*O31","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H32<>\"\",K32<>\"\"),H32*K32,\"\")","v":null},{"$f":"IF(I32<>\"\",I32*O31,\"\")","v":null},{"$f":"IF(OR(H32<>\"\",I32<>\"\"),N31+H32-I32,N31)","v":null},{"$f":"IF(H32>0,IF((N31+H32)=0,O31,(P31+L32)/(N31+H32)),O31)","v":null},{"$f":"N32*O32","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H33<>\"\",K33<>\"\"),H33*K33,\"\")","v":null},{"$f":"IF(I33<>\"\",I33*O32,\"\")","v":null},{"$f":"IF(OR(H33<>\"\",I33<>\"\"),N32+H33-I33,N32)","v":null},{"$f":"IF(H33>0,IF((N32+H33)=0,O32,(P32+L33)/(N32+H33)),O32)","v":null},{"$f":"N33*O33","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H34<>\"\",K34<>\"\"),H34*K34,\"\")","v":null},{"$f":"IF(I34<>\"\",I34*O33,\"\")","v":null},{"$f":"IF(OR(H34<>\"\",I34<>\"\"),N33+H34-I34,N33)","v":null},{"$f":"IF(H34>0,IF((N33+H34)=0,O33,(P33+L34)/(N33+H34)),O33)","v":null},{"$f":"N34*O34","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H35<>\"\",K35<>\"\"),H35*K35,\"\")","v":null},{"$f":"IF(I35<>\"\",I35*O34,\"\")","v":null},{"$f":"IF(OR(H35<>\"\",I35<>\"\"),N34+H35-I35,N34)","v":null},{"$f":"IF(H35>0,IF((N34+H35)=0,O34,(P34+L35)/(N34+H35)),O34)","v":null},{"$f":"N35*O35","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H36<>\"\",K36<>\"\"),H36*K36,\"\")","v":null},{"$f":"IF(I36<>\"\",I36*O35,\"\")","v":null},{"$f":"IF(OR(H36<>\"\",I36<>\"\"),N35+H36-I36,N35)","v":null},{"$f":"IF(H36>0,IF((N35+H36)=0,O35,(P35+L36)/(N35+H36)),O35)","v":null},{"$f":"N36*O36","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H37<>\"\",K37<>\"\"),H37*K37,\"\")","v":null},{"$f":"IF(I37<>\"\",I37*O36,\"\")","v":null},{"$f":"IF(OR(H37<>\"\",I37<>\"\"),N36+H37-I37,N36)","v":null},{"$f":"IF(H37>0,IF((N36+H37)=0,O36,(P36+L37)/(N36+H37)),O36)","v":null},{"$f":"N37*O37","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H38<>\"\",K38<>\"\"),H38*K38,\"\")","v":null},{"$f":"IF(I38<>\"\",I38*O37,\"\")","v":null},{"$f":"IF(OR(H38<>\"\",I38<>\"\"),N37+H38-I38,N37)","v":null},{"$f":"IF(H38>0,IF((N37+H38)=0,O37,(P37+L38)/(N37+H38)),O37)","v":null},{"$f":"N38*O38","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H39<>\"\",K39<>\"\"),H39*K39,\"\")","v":null},{"$f":"IF(I39<>\"\",I39*O38,\"\")","v":null},{"$f":"IF(OR(H39<>\"\",I39<>\"\"),N38+H39-I39,N38)","v":null},{"$f":"IF(H39>0,IF((N38+H39)=0,O38,(P38+L39)/(N38+H39)),O38)","v":null},{"$f":"N39*O39","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H40<>\"\",K40<>\"\"),H40*K40,\"\")","v":null},{"$f":"IF(I40<>\"\",I40*O39,\"\")","v":null},{"$f":"IF(OR(H40<>\"\",I40<>\"\"),N39+H40-I40,N39)","v":null},{"$f":"IF(H40>0,IF((N39+H40)=0,O39,(P39+L40)/(N39+H40)),O39)","v":null},{"$f":"N40*O40","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H41<>\"\",K41<>\"\"),H41*K41,\"\")","v":null},{"$f":"IF(I41<>\"\",I41*O40,\"\")","v":null},{"$f":"IF(OR(H41<>\"\",I41<>\"\"),N40+H41-I41,N40)","v":null},{"$f":"IF(H41>0,IF((N40+H41)=0,O40,(P40+L41)/(N40+H41)),O40)","v":null},{"$f":"N41*O41","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H42<>\"\",K42<>\"\"),H42*K42,\"\")","v":null},{"$f":"IF(I42<>\"\",I42*O41,\"\")","v":null},{"$f":"IF(OR(H42<>\"\",I42<>\"\"),N41+H42-I42,N41)","v":null},{"$f":"IF(H42>0,IF((N41+H42)=0,O41,(P41+L42)/(N41+H42)),O41)","v":null},{"$f":"N42*O42","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H43<>\"\",K43<>\"\"),H43*K43,\"\")","v":null},{"$f":"IF(I43<>\"\",I43*O42,\"\")","v":null},{"$f":"IF(OR(H43<>\"\",I43<>\"\"),N42+H43-I43,N42)","v":null},{"$f":"IF(H43>0,IF((N42+H43)=0,O42,(P42+L43)/(N42+H43)),O42)","v":null},{"$f":"N43*O43","v":null}]
[{"$nulls":11},{"$f":"IF(AND(H44<>\"\",K44<>\"\"),H44*K44,\"\")","v":null},{"$f":"IF(I44<>\"\",I44*O43,\"\")","v":null},{"$f":"IF(OR(H44<>\"\",I44<>\"\"),N43+H44-I44,N43)","v":null},{"$f":"IF(H44>0,IF((N43+H44)=0,O43,(P43+L44)/(N43+H44)),O43)","v":null},{"$f":"N44*O44","v":null}]
["Σ",{"$nulls":6},{"$f":"SUM(H14:H44)","v":null},{"$f":"SUM(I14:I44)","v":null},null,null,{"$f":"SUM(L14:L44)","v":null},{"$f":"SUM(M14:M44)","v":null}]