{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["fiche","32","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"fiche","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DOSSIER TECHNO : ",90155]
["CLIENT : ","AFF"]
["DOSSIER JB :  ",90189]
["DATE DE DEPART :","2021-09-23"]
["REFERENCE DE LA SERIE","serie 1","serie 2","serie 3","serie 4","serie 5","serie 6"]
[]
[]
[]
["Quantité commandée",125402,100250,158300,125750,205750,69750]
["Quantité par paquet",200,100,125,150,200,100]
["Nombre paquets/carton",10,20,12,15,20,10]

{"sheet":"32","index":1,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[{"$f":"fiche!A1","v":"DOSSIER TECHNO : "},{"$f":"fiche!B1","v":90155},{"$f":"fiche!A2","v":"CLIENT : "},{"$f":"fiche!B2","v":"AFF"},{"$f":"fiche!A3","v":"DOSSIER JB :  "},{"$f":"fiche!B3","v":90189},{"$f":"fiche!A4","v":"DATE DE DEPART :"},{"$f":"fiche!B4","v":"2021-09-23"},null,null,null,{"$f":"A6","v":"DOSSIER TECHNO : "},90155,"CLIENT : ","AFF","DOSSIER JB :  ",90189,"DATE DE DEPART :","2021-09-23"]
[]
[]
["REF DE LA SERIE","QUANTITE PAR PAQUETS","NOMBRE DE PAQUETS AU CARTON ","QUANTITE PAR CARTON ","NOMBRE DE CARTON","QUANTITE ","NOMBRE DE PALETTE","QUANTITE TOTAL",null,null,null,{"$f":"A9","v":"REF DE LA SERIE"},"QUANTITE PAR PAQUETS","NOMBRE DE PAQUETS AU CARTON ","QUANTITE PAR CARTON ","NOMBRE DE CARTON","QUANTITE ","NOMBRE DE PALETTE","QUANTITE TOTAL"]
[{"$f":"fiche!B5","v":"serie 1"},{"$f":"fiche!B10","v":200},{"$f":"fiche!B11","v":10},{"$f":"IFERROR(B10*C10,\"\")","v":2000},{"$f":"IFERROR(IF(fiche!B9>32*D10,32,ROUNDDOWN(fiche!B9/D10,0)),\"\")","v":32},{"$f":"IFERROR(E10*D10,\"\")","v":64000},{"$f":"IF(E10<>\"\",IF(E10<32,INT(1),INT(fiche!$B$9/D10/32)),\"\")","v":1},{"$f":"IFERROR(E10*D10*G10,\"\")","v":64000},null,null,null,"serie 1",200,10,2000,32,64000,1,64000]
[null,{"$f":"IF(MAX(H9:H10)>=fiche!$B$9,\"\",B10)","v":200},{"$f":"IF(MAX(H10:H10)>=fiche!$B$9,\"\",C10)","v":10},{"$f":"IFERROR(B11*C11,\"\")","v":2000},{"$f":"IFERROR(IF((fiche!$B$9-H10)>32*D11,32,MAX(INT((fiche!$B$9-H10)/D11),1)),\"\")","v":30},{"$f":"IFERROR(IF(fiche!B9-'32'!H10>'32'!D11*'32'!E11,'32'!D11*'32'!E11,fiche!B9-'32'!H10),\"\")","v":60000},{"$f":"IF($F11=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$9:H10)>=fiche!$B$9,\"\",H10+F11)","v":124000},{"$f":"IFERROR(ROUNDUP(F11/E11,-2),\"\")","v":2000},{"$f":"IFERROR(I11/M11,\"\")","v":10},null,null,{"$f":"B11","v":200},{"$f":"IFERROR(ROUNDUP(J11,-0.5), \"\")","v":10},{"$f":"IFERROR(M11*N11,\"\")","v":2000},{"$f":"E11","v":30},{"$f":"IFERROR(P11*O11,\"\")","v":60000},{"$f":"IFERROR(G11,\"\")","v":1},{"$f":"IFERROR(S10+Q11,\"\")","v":124000}]
[null,{"$f":"IF(MAX(H10:H11)>=fiche!$B$9,\"\",B11)","v":200},{"$f":"IF(MAX(H10:H11)>=fiche!$B$9,\"\",C11)","v":10},2000,{"$f":"IFERROR(IF((fiche!$B$9-H11)>32*D12,32,MAX(INT((fiche!$B$9-H11)/D12),1)),\"\")","v":1},{"$f":"IFERROR(IF(E12*D12>D12,E12*D12,MAX(fiche!$B$9-H11,100)),\"\")","v":1402},{"$f":"IF($F12=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$9:H11)>=fiche!$B$9,\"\",H11+F12)","v":125402},{"$f":"IFERROR(ROUNDUP(F12,-2),\"\")","v":1500},{"$f":"IFERROR(I12/M12,\"\")","v":7.5},null,null,{"$f":"B12","v":200},{"$f":"IFERROR(ROUNDUP(J12,-0.5), \"\")","v":8},{"$f":"IF(ISERROR(N12*M12),\"\", N12*M12)","v":1600},{"$f":"E12","v":1},{"$f":"IFERROR(P12*O12,\"\")","v":1600},{"$f":"G12","v":1},{"$f":"IFERROR(S11+Q12,\"\")","v":125600}]
[]
[{"$f":"fiche!C5","v":"serie 2"},{"$f":"fiche!C10","v":100},{"$f":"fiche!C11","v":20},{"$f":"IFERROR(B14*C14,\"\")","v":2000},{"$f":"IFERROR(IF(fiche!C9>32*D14,32,ROUNDDOWN(fiche!C9/D14,0)),\"\")","v":32},{"$f":"IFERROR(E14*D14,\"\")","v":64000},{"$f":"IF(E14<>\"\",IF(E14<32,INT(1),INT(fiche!$C$9/D14/32)),\"\")","v":1},{"$f":"IFERROR(E14*D14*G14,\"\")","v":64000},null,null,null,{"$f":"A14","v":"serie 2"},100,20,2000,32,64000,1,64000]
[null,{"$f":"IF(MAX(H14:H14)>=fiche!$C$9,\"\",B14)","v":100},{"$f":"IF(MAX(H14:H14)>=fiche!$C$9,\"\",C14)","v":20},{"$f":"IFERROR(B15*C15,\"\")","v":2000},{"$f":"IFERROR(IF((fiche!$C$9-H14)>32*D15,32,MAX(INT((fiche!$C$9-H14)/D15),1)),\"\")","v":18},{"$f":"IFERROR(IF(fiche!C9-'32'!H14>'32'!D15*'32'!E15,'32'!D15*'32'!E15,fiche!C9-'32'!H14),\"\")","v":36000},{"$f":"IF($F15=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$14:H14)>=fiche!$C$9,\"\",H14+F15)","v":100000},{"$f":"IFERROR(ROUNDUP(F15/E15,-2),\"\")","v":2000},{"$f":"IFERROR(I15/M15,\"\")","v":20},null,null,{"$f":"B15","v":100},{"$f":"IFERROR(ROUNDUP(J15,-0.5), \"\")","v":20},{"$f":"IFERROR(M15*N15,\"\")","v":2000},{"$f":"E15","v":18},{"$f":"IFERROR(ROUNDUP(F15,-2),\"\")","v":36000},{"$f":"IFERROR(G15,\"\")","v":1},{"$f":"H15","v":100000}]
[null,{"$f":"IF(MAX(H14:H15)>=fiche!$C$9,\"\",B15)","v":100},{"$f":"IF(MAX(H14:H15)>=fiche!$C$9,\"\",C15)","v":20},{"$f":"IFERROR(B16*C16,\"\")","v":2000},{"$f":"IFERROR(IF((fiche!$B$9-H15)>32*D16,32,MAX(INT((fiche!$B$9-H15)/D16),1)),\"\")","v":12},{"$f":"IFERROR(IF(E16*D16>D16,E16*D16,MAX(fiche!$C$9-H15,100)),\"\")","v":24000},1,{"$f":"IF(MAX($H$14:H15)>=fiche!$C$9,\"\",H15+F16)","v":124000},{"$f":"IFERROR(ROUNDUP(F16,-2),\"\")","v":24000},{"$f":"IFERROR(I16/M16,\"\")","v":240},null,null,100,{"$f":"IFERROR(ROUNDUP(J16,-0.5), \"\")","v":240},{"$f":"IF(ISERROR(N16*M16),\"\", N16*M16)","v":24000},12,{"$f":"IFERROR(P16*O16,\"\")","v":288000},{"$f":"G16","v":1},{"$f":"IFERROR(ROUNDUP(H16,-2),\"\")","v":124000}]
[]
[{"$f":"fiche!D5","v":"serie 3"},{"$f":"fiche!D10","v":125},{"$f":"fiche!D11","v":12},{"$f":"IFERROR(B18*C18,\"\")","v":1500},{"$f":"IFERROR(IF(fiche!D9>32*D18,32,ROUNDDOWN(fiche!D9/D18,0)),\"\")","v":32},{"$f":"IFERROR(E18*D18,\"\")","v":48000},{"$f":"IF(E18<>\"\",IF(E18<32,INT(1),INT(fiche!$D$9/D18/32)),\"\")","v":3},{"$f":"IFERROR(E18*D18*G18,\"\")","v":144000},null,null,null,{"$f":"A18","v":"serie 3"},125,12,1500,32,48000,3,144000]
[null,{"$f":"IF(MAX(H18:H18)>=fiche!$D$9,\"\",B18)","v":125},{"$f":"IF(MAX(H18:H18)>=fiche!$D$9,\"\",C18)","v":12},{"$f":"IFERROR(B19*C19,\"\")","v":1500},{"$f":"IFERROR(IF((fiche!$C$9-H18)>32*D19,32,MAX(INT((fiche!$D$9-H18)/D19),1)),\"\")","v":9},{"$f":"IFERROR(IF(fiche!D9-'32'!H18>'32'!D19*'32'!E19,'32'!D19*'32'!E19,fiche!D9-'32'!H18),\"\")","v":13500},{"$f":"IF($F19=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$18:H18)>=fiche!$D$9,\"\",H18+F19)","v":157500},{"$f":"IFERROR(ROUNDUP(F19/E19,-2),\"\")","v":1500},{"$f":"IFERROR(I19/M19,\"\")","v":12},null,null,{"$f":"B19","v":125},{"$f":"IFERROR(ROUNDUP(J19,-0.5), \"\")","v":12},{"$f":"IFERROR(M19*N19,\"\")","v":1500},{"$f":"E19","v":9},{"$f":"IFERROR(ROUNDUP(F19,-2),\"\")","v":13500},{"$f":"IFERROR(G19,\"\")","v":1},{"$f":"H19","v":157500}]
[null,{"$f":"IF(MAX(H18:H19)>=fiche!$D$9,\"\",B19)","v":125},{"$f":"IF(MAX(H18:H19)>=fiche!$D$9,\"\",C19)","v":12},{"$f":"IFERROR(B20*C20,\"\")","v":1500},{"$f":"IFERROR(IF((fiche!$D$9-H19)>32*D20,32,MAX(INT((fiche!$D$9-H19)/D20),1)),\"\")","v":1},{"$f":"IFERROR(IF(E20*D20>D20,E20*D20,MAX(fiche!$D$9-H19,100)),\"\")","v":800},{"$f":"IF($F20=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$18:H19)>=fiche!$D$9,\"\",H19+F20)","v":158300},800,{"$f":"IFERROR(I20/M20,\"\")","v":6.4},null,null,125,{"$f":"IFERROR(ROUNDUP(J20,-0.5), \"\")","v":7},{"$f":"IF(ISERROR(N20*M20),\"\", N20*M20)","v":875},1,{"$f":"IFERROR(P20*O20,\"\")","v":875},{"$f":"G20","v":1},{"$f":"IFERROR(ROUNDUP(H20,-2),\"\")","v":158300}]
[]
[{"$f":"fiche!E5","v":"serie 4"},{"$f":"fiche!E10","v":150},{"$f":"fiche!E11","v":15},{"$f":"IFERROR(B22*C22,\"\")","v":2250},{"$f":"IFERROR(IF(fiche!E9>32*D22,32,ROUNDDOWN(fiche!E9/D22,0)),\"\")","v":32},{"$f":"IFERROR(E22*D22,\"\")","v":72000},{"$f":"IF(E22<>\"\",IF(E22<32,INT(1),INT(fiche!$E$9/D22/32)),\"\")","v":1},{"$f":"IFERROR(E22*D22*G22,\"\")","v":72000},null,null,null,{"$f":"A22","v":"serie 4"},150,15,2250,32,72000,1,72000]
[null,{"$f":"IF(MAX(H21:H22)>=fiche!$E$9,\"\",B22)","v":150},{"$f":"IF(MAX(H21:H22)>=fiche!$E$9,\"\",C22)","v":15},{"$f":"IFERROR(B23*C23,\"\")","v":2250},{"$f":"IFERROR(IF((fiche!$E$9-H22)>32*D23,32,MAX(INT((fiche!$E$9-H22)/D23),1)),\"\")","v":23},{"$f":"IFERROR(IF(fiche!E9-'32'!H22>'32'!D23*'32'!E23,'32'!D23*'32'!E23,fiche!E9-'32'!H22),\"\")","v":51750},{"$f":"IF($F23=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$22:H22)>=fiche!$E$9,\"\",H22+F23)","v":123750},{"$f":"IFERROR(ROUNDUP(F23/E23,-2),\"\")","v":2300},{"$f":"IFERROR(I23/M23,\"\")","v":15.333333333333334},null,null,{"$f":"B23","v":150},{"$f":"IFERROR(ROUNDUP(J23,-0.5), \"\")","v":16},{"$f":"IFERROR(M23*N23,\"\")","v":2400},{"$f":"E23","v":23},{"$f":"IFERROR(ROUNDUP(F23,-2),\"\")","v":51800},{"$f":"IFERROR(G23,\"\")","v":1},{"$f":"H23","v":123750}]
[null,{"$f":"IF(MAX(H22:H23)>=fiche!$E$9,\"\",B23)","v":150},{"$f":"IF(MAX(H22:H23)>=fiche!$E$9,\"\",C23)","v":15},2250,{"$f":"IFERROR(IF((fiche!$E$9-H23)>32*D24,32,MAX(INT((fiche!$E$9-H23)/D24),1)),\"\")","v":1},{"$f":"IFERROR(IF(E24*D24>D24,E24*D24,MAX(fiche!$E$9-H23,100)),\"\")","v":2000},{"$f":"IF($F24=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$22:H23)>=fiche!$E$9,\"\",H23+F24)","v":125750},2000,{"$f":"IFERROR(I24/M24,\"\")","v":13.333333333333334},null,null,150,{"$f":"IFERROR(ROUNDUP(J24,-0.5), \"\")","v":14},{"$f":"IF(ISERROR(N24*M24),\"\", N24*M24)","v":2100},1,{"$f":"IFERROR(P24*O24,\"\")","v":2100},{"$f":"G24","v":1},{"$f":"IFERROR(ROUNDUP(H24,-2),\"\")","v":125800}]
[]
[{"$f":"fiche!F5","v":"serie 5"},{"$f":"fiche!F10","v":200},{"$f":"fiche!F11","v":20},{"$f":"IFERROR(B26*C26,\"\")","v":4000},{"$f":"IFERROR(IF(fiche!F9>32*D26,32,ROUNDDOWN(fiche!F9/D26,0)),\"\")","v":32},{"$f":"IFERROR(E26*D26,\"\")","v":128000},{"$f":"IF(E26<>\"\",IF(E26<32,INT(1),INT(fiche!$F$9/D26/32)),\"\")","v":1},{"$f":"IFERROR(E26*D26*G26,\"\")","v":128000},{"$f":"IFERROR(ROUNDUP(F26/E26,-2),\"\")","v":4000},{"$f":"IFERROR(I26/M26,\"\")","v":20},null,{"$f":"A26","v":"serie 5"},200,{"$f":"C26","v":20},{"$f":"D26","v":4000},32,{"$f":"F26","v":128000},1,128000]
[null,{"$f":"IF(MAX(H25:H26)>=fiche!$F$9,\"\",B26)","v":200},{"$f":"IF(MAX(H25:H26)>=fiche!$F$9,\"\",C26)","v":20},{"$f":"IFERROR(B27*C27,\"\")","v":4000},{"$f":"IFERROR(IF((fiche!$F$9-H26)>32*D27,32,MAX(INT((fiche!$F$9-H26)/D27),1)),\"\")","v":19},{"$f":"IFERROR(IF(fiche!F9-'32'!H26>'32'!D27*'32'!E27,'32'!D27*'32'!E27,fiche!F9-'32'!H26),\"\")","v":76000},{"$f":"IF($F27=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$26:H26)>=fiche!$F$9,\"\",H26+F27)","v":204000},76000,{"$f":"IFERROR(I27/M27,\"\")","v":380},null,null,200,{"$f":"IFERROR(ROUNDUP(J27,-0.5), \"\")","v":380},{"$f":"IFERROR(M27*N27,\"\")","v":76000},19,{"$f":"IFERROR(ROUNDUP(F27,-2),\"\")","v":76000},{"$f":"IFERROR(G27,\"\")","v":1},204000]
[null,{"$f":"IF(MAX(H26:H27)>=fiche!$F$9,\"\",B27)","v":200},{"$f":"IF(MAX(H26:H27)>=fiche!$F$9,\"\",C27)","v":20},4000,{"$f":"IFERROR(IF((fiche!$F$9-H27)>32*D28,32,MAX(INT((fiche!$F$9-H27)/D28),1)),\"\")","v":1},{"$f":"IFERROR(IF(E28*D28>D28,E28*D28,MAX(fiche!$F$9-H27,100)),\"\")","v":1750},{"$f":"IF($F28=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$26:H27)>=fiche!$F$9,\"\",H27+F28)","v":205750},1800,{"$f":"IFERROR(I28/M28,\"\")","v":9},null,null,200,{"$f":"IFERROR(ROUNDUP(J28,-0.5), \"\")","v":9},{"$f":"IF(ISERROR(N28*M28),\"\", N28*M28)","v":1800},1,{"$f":"IFERROR(P28*O28,\"\")","v":1800},1,{"$f":"IFERROR(ROUNDUP(H28,-2),\"\")","v":205800}]
[]
[{"$f":"fiche!G5","v":"serie 6"},{"$f":"fiche!G10","v":100},{"$f":"fiche!G11","v":10},{"$f":"IFERROR(B30*C30,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$G$9-H29)>32*D30,32,MAX(INT((fiche!$G$9-H29)/D30),1)),\"\")","v":32},{"$f":"IFERROR(E30*D30,\"\")","v":32000},{"$f":"IF(E30<>\"\",IF(E30<32,INT(1),INT(fiche!$G$9/D30/32)),\"\")","v":2},{"$f":"IFERROR(E30*D30*G30,\"\")","v":64000},null,null,null,{"$f":"A30","v":"serie 6"},{"$f":"B30","v":100},{"$f":"C30","v":10},{"$f":"D30","v":1000},{"$f":"E30","v":32},{"$f":"IFERROR(ROUNDUP(F30,-2),\"\")","v":32000},{"$f":"IFERROR(G30,\"\")","v":2},{"$f":"H30","v":64000}]
[null,{"$f":"IF(MAX(H29:H30)>=fiche!$G$9,\"\",B30)","v":100},{"$f":"IF(MAX(H29:H30)>=fiche!$G$9,\"\",C30)","v":10},1000,{"$f":"IFERROR(IF((fiche!$G$9-H30)>32*D31,32,MAX(INT((fiche!$G$9-H30)/D31),1)),\"\")","v":5},{"$f":"IFERROR(IF(fiche!G9-'32'!H30>'32'!D31*'32'!E31,'32'!D31*'32'!E31,fiche!G9-'32'!H30),\"\")","v":5000},{"$f":"IF($F31=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$30:H30)>=fiche!$G$9,\"\",H30+F31)","v":69000},{"$f":"IFERROR(ROUNDUP(F31/E31,-2),\"\")","v":1000},{"$f":"IFERROR(I31/M31,\"\")","v":10},null,null,100,{"$f":"IFERROR(ROUNDUP(J31,-0.5), \"\")","v":10},{"$f":"IF(ISERROR(N31*M31),\"\", N31*M31)","v":1000},5,{"$f":"IFERROR(P31*O31,\"\")","v":5000},{"$f":"G31","v":1},{"$f":"IFERROR(ROUNDUP(H31,-2),\"\")","v":69000}]
[null,{"$f":"IF(MAX(H30:H31)>=fiche!$G$9,\"\",B31)","v":100},{"$f":"IF(MAX(H30:H31)>=fiche!$G$9,\"\",C31)","v":10},1000,{"$f":"IFERROR(IF((fiche!$G$9-H31)>32*D32,32,MAX(INT((fiche!$G$9-H31)/D32),1)),\"\")","v":1},{"$f":"IFERROR(IF(E32*D32>D32,E32*D32,MAX(fiche!$G$9-H31,100)),\"\")","v":750},{"$f":"IF($F32=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$30:H31)>=fiche!$G$9,\"\",H31+F32)","v":69750},{"$f":"IFERROR(ROUNDUP(F32,-2),\"\")","v":800},8,null,null,100,{"$f":"IFERROR(ROUNDUP(J32,-0.5), \"\")","v":8},{"$f":"IF(ISERROR(N32*M32),\"\", N32*M32)","v":800},1,{"$f":"IFERROR(P32*O32,\"\")","v":800},1,{"$f":"H32","v":69750}]

{"sheet":"Feuil1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}