{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["fiche","32"],"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":6,"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"]
[]
[]
[]
["Quantité commandée",33500,64500,99000,125800,92500]
["Quantité par paquet",100,100,100,100,100]
["Nombre paquets/carton",10,10,10,10,10]

{"sheet":"32","index":1,"n_rows":28,"n_cols":17,"rows_kept":28,"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,{"$f":"A6","v":"DOSSIER TECHNO : "},{"$f":"B6","v":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,{"$f":"A9","v":"REF DE LA SERIE"},{"$f":"B9","v":"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":100},{"$f":"fiche!B11","v":10},{"$f":"IFERROR(B10*C10,\"\")","v":1000},{"$f":"IF(fiche!B9>32*D10,32,ROUNDDOWN(fiche!B9/D10,0))","v":32},{"$f":"E10*D10","v":32000},{"$f":"IF(E10<>\"\",IF(E10<32,INT(1),INT(fiche!$B$9/D10/32)))","v":1},{"$f":"E10*D10*G10","v":32000},null,{"$f":"A10","v":"serie 1"},{"$f":"B10","v":100},{"$f":"C10","v":10},1000,32,32000,1,32000]
[null,{"$f":"IF(MAX(H9:H10)>=fiche!$B$9,\"\",B10)","v":100},{"$f":"IF(MAX(H10:H10)>=fiche!$B$9,\"\",C10)","v":10},{"$f":"IFERROR(B11*C11,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$B$9-H10)>32*D11,32,MAX(INT((fiche!$B$9-H10)/D11),1)),\"\")","v":1},{"$f":"IFERROR(IF(E11*D11>D11,E11*D11,MAX(fiche!$B$9-H10,100)),\"\")","v":1500},{"$f":"IF($F11=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$9:H10)>=fiche!$B$9,\"\",H10+F11)","v":33500},null,null,{"$f":"B11","v":100},{"$f":"IFERROR(M11/K11,\"\")","v":15},{"$f":"IFERROR(O11/N11,\"\")","v":1500},1,{"$f":"IFERROR(ROUNDUP(F11,-2),\"\")","v":1500},1,33500]
[null,{"$f":"IF(MAX(H10:H11)>=fiche!$B$9,\"\",B11)","v":""},{"$f":"IF(MAX(H10:H11)>=fiche!$B$9,\"\",C11)","v":""},"",{"$f":"IFERROR(IF((fiche!$B$9-H11)>32*D12,32,MAX(INT((fiche!$B$9-H11)/D12),1)),\"\")","v":""},{"$f":"IFERROR(IF(E12*D12>D12,E12*D12,MAX(fiche!$B$9-H11,100)),\"\")","v":""},{"$f":"IF($F12=\"\",\"\",1)","v":""},{"$f":"IF(MAX($H$9:H11)>=fiche!$B$9,\"\",H11+F12)","v":""},null,null,{"$f":"B12","v":""},{"$f":"IF(ISERROR(O12/K12),\"\", O12/K12)","v":""},{"$f":"IF(ISERROR(L12*K12),\"\", L12*K12)","v":""},{"$f":"E12","v":""},{"$f":"IFERROR(ROUNDUP(F12,-2),\"\")","v":""},"",{"$f":"IFERROR(ROUNDUP(H12,-2),\"\")","v":""}]
[]
[{"$f":"fiche!C5","v":"serie 2"},{"$f":"fiche!C10","v":100},{"$f":"fiche!C11","v":10},{"$f":"IFERROR(B14*C14,\"\")","v":1000},{"$f":"IF(fiche!C9>32*D14,32,ROUNDDOWN(fiche!C9/D14,0))","v":32},{"$f":"E14*D14","v":32000},{"$f":"IF(E14<>\"\",IF(E14<32,INT(1),INT(fiche!$C$9/D14/32)))","v":2},{"$f":"E14*D14*G14","v":64000},null,{"$f":"A14","v":"serie 2"},{"$f":"B14","v":100},10,1000,32,32000,2,64000]
[null,{"$f":"IF(MAX(H14:H14)>=fiche!$C$9,\"\",B14)","v":100},{"$f":"IF(MAX(H14:H14)>=fiche!$C$9,\"\",C14)","v":10},{"$f":"IFERROR(B15*C15,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$C$9-H14)>32*D15,32,MAX(INT((fiche!$C$9-H14)/D15),1)),\"\")","v":1},{"$f":"IFERROR(IF(E15*D15>D15,E15*D15,MAX(fiche!$C$9-H14,100)),\"\")","v":500},{"$f":"IF($F15=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$14:H14)>=fiche!$C$9,\"\",H14+F15)","v":64500},null,null,{"$f":"B15","v":100},{"$f":"IFERROR(M15/K15,\"\")","v":5},{"$f":"IFERROR(O15/N15,\"\")","v":500},{"$f":"E15","v":1},{"$f":"F15","v":500},{"$f":"G15","v":1},{"$f":"H15","v":64500}]
[null,{"$f":"IF(MAX(H14:H15)>=fiche!$C$9,\"\",B15)","v":""},{"$f":"IF(MAX(H14:H15)>=fiche!$C$9,\"\",C15)","v":""},{"$f":"IFERROR(B16*C16,\"\")","v":""},{"$f":"IFERROR(IF((fiche!$B$9-H15)>32*D16,32,MAX(INT((fiche!$B$9-H15)/D16),1)),\"\")","v":""},{"$f":"IFERROR(IF(E16*D16>D16,E16*D16,MAX(fiche!$C$9-H15,100)),\"\")","v":""},"",{"$f":"IF(MAX($H$14:H15)>=fiche!$C$9,\"\",H15+F16)","v":""},null,null,"",{"$f":"IF(ISERROR(O16/K16),\"\", O16/K16)","v":""},{"$f":"IF(ISERROR(L16*K16),\"\", L16*K16)","v":""},"",{"$f":"IFERROR(ROUNDUP(F16,-2),\"\")","v":""},"",{"$f":"IFERROR(ROUNDUP(H16,-2),\"\")","v":""}]
[]
[{"$f":"fiche!D5","v":"serie 3"},{"$f":"fiche!D10","v":100},{"$f":"fiche!D11","v":10},{"$f":"IFERROR(B18*C18,\"\")","v":1000},{"$f":"IF(fiche!D9>32*D18,32,ROUNDDOWN(fiche!D9/D18,0))","v":32},{"$f":"E18*D18","v":32000},{"$f":"IF(E18<>\"\",IF(E18<32,INT(1),INT(fiche!$D$9/D18/32)))","v":3},{"$f":"E18*D18*G18","v":96000},null,{"$f":"A18","v":"serie 3"},{"$f":"B18","v":100},10,1000,32,32000,3,96000]
[null,{"$f":"IF(MAX(H18:H18)>=fiche!$D$9,\"\",B18)","v":100},{"$f":"IF(MAX(H18:H18)>=fiche!$D$9,\"\",C18)","v":10},{"$f":"IFERROR(B19*C19,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$C$9-H18)>32*D19,32,MAX(INT((fiche!$D$9-H18)/D19),1)),\"\")","v":3},{"$f":"IFERROR(IF(E19*D19>D19,E19*D19,MAX(fiche!$C$9-H18,100)),\"\")","v":3000},{"$f":"IF($F19=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$18:H18)>=fiche!$D$9,\"\",H18+F19)","v":99000},null,null,{"$f":"B19","v":100},{"$f":"IFERROR(M19/K19,\"\")","v":10},{"$f":"IFERROR(O19/N19,\"\")","v":1000},{"$f":"E19","v":3},{"$f":"F19","v":3000},{"$f":"G19","v":1},{"$f":"H19","v":99000}]
[null,{"$f":"IF(MAX(H18:H19)>=fiche!$D$9,\"\",B19)","v":""},{"$f":"IF(MAX(H18:H19)>=fiche!$D$9,\"\",C19)","v":""},{"$f":"IFERROR(B20*C20,\"\")","v":""},{"$f":"IFERROR(IF((fiche!$D$9-H19)>32*D20,32,MAX(INT((fiche!$D$9-H19)/D20),1)),\"\")","v":""},{"$f":"IFERROR(IF(E20*D20>D20,E20*D20,MAX(fiche!$D$9-H19,100)),\"\")","v":""},{"$f":"IF($F20=\"\",\"\",1)","v":""},{"$f":"IF(MAX($H$18:H19)>=fiche!$D$9,\"\",H19+F20)","v":""},null,null,"",{"$f":"IF(ISERROR(O20/K20),\"\", O20/K20)","v":""},{"$f":"IF(ISERROR(L20*K20),\"\", L20*K20)","v":""},"",{"$f":"IFERROR(ROUNDUP(F20,-2),\"\")","v":""},"",{"$f":"IFERROR(ROUNDUP(H20,-2),\"\")","v":""}]
[]
[{"$f":"fiche!E5","v":"serie 4"},{"$f":"fiche!E10","v":100},{"$f":"fiche!E11","v":10},{"$f":"IFERROR(B22*C22,\"\")","v":1000},{"$f":"IF(fiche!E9>32*D22,32,ROUNDDOWN(fiche!E9/D22,0))","v":32},{"$f":"E22*D22","v":32000},{"$f":"IF(E22<>\"\",IF(E22<32,INT(1),INT(fiche!$E$9/D22/32)))","v":3},{"$f":"E22*D22*G22","v":96000},null,{"$f":"A22","v":"serie 4"},{"$f":"B22","v":100},10,1000,32,32000,3,96000]
[null,{"$f":"IF(MAX(H21:H22)>=fiche!$E$9,\"\",B22)","v":100},{"$f":"IF(MAX(H21:H22)>=fiche!$E$9,\"\",C22)","v":10},{"$f":"IFERROR(B23*C23,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$E$9-H22)>32*D23,32,MAX(INT((fiche!$E$9-H22)/D23),1)),\"\")","v":29},{"$f":"IFERROR(IF(E23*D23>D23,E23*D23,MAX(fiche!$E$9-H22,100)),\"\")","v":29000},{"$f":"IF($F23=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$22:H22)>=fiche!$E$9,\"\",H22+F23)","v":125000},null,null,{"$f":"B23","v":100},{"$f":"IFERROR(M23/K23,\"\")","v":10},{"$f":"IFERROR(O23/N23,\"\")","v":1000},{"$f":"E23","v":29},{"$f":"F23","v":29000},{"$f":"G23","v":1},{"$f":"H23","v":125000}]
[null,{"$f":"IF(MAX(H22:H23)>=fiche!$E$9,\"\",B23)","v":100},{"$f":"IF(MAX(H22:H23)>=fiche!$E$9,\"\",C23)","v":10},1000,{"$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":800},{"$f":"IF($F24=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$22:H23)>=fiche!$E$9,\"\",H23+F24)","v":125800},null,null,100,{"$f":"IF(ISERROR(O24/K24),\"\", O24/K24)","v":8},{"$f":"IF(ISERROR(L24*K24),\"\", L24*K24)","v":800},1,{"$f":"IFERROR(ROUNDUP(F24,-2),\"\")","v":800},1,{"$f":"IFERROR(ROUNDUP(H24,-2),\"\")","v":125800}]
[]
[{"$f":"fiche!F5","v":"serie 5"},{"$f":"fiche!F10","v":100},{"$f":"fiche!F11","v":10},{"$f":"IFERROR(B26*C26,\"\")","v":1000},{"$f":"IF(fiche!F9>32*D26,32,ROUNDDOWN(fiche!F9/D26,0))","v":32},{"$f":"E26*D26","v":32000},{"$f":"IF(E26<>\"\",IF(E26<32,INT(1),INT(fiche!$F$9/D26/32)))","v":2},{"$f":"E26*D26*G26","v":64000},null,{"$f":"A26","v":"serie 5"},100,{"$f":"C26","v":10},{"$f":"D26","v":1000},32,32000,2,64000]
[null,{"$f":"IF(MAX(H25:H26)>=fiche!$F$9,\"\",B26)","v":100},{"$f":"IF(MAX(H25:H26)>=fiche!$F$9,\"\",C26)","v":10},{"$f":"IFERROR(B27*C27,\"\")","v":1000},{"$f":"IFERROR(IF((fiche!$F$9-H26)>32*D27,32,MAX(INT((fiche!$F$9-H26)/D27),1)),\"\")","v":28},{"$f":"IFERROR(IF(E27*D27>D27,E27*D27,MAX(fiche!$F$9-H26,100)),\"\")","v":28000},{"$f":"IF($F27=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$26:H26)>=fiche!$F$9,\"\",H26+F27)","v":92000},null,null,100,{"$f":"IFERROR(M27/K27,\"\")","v":10},{"$f":"IFERROR(O27/N27,\"\")","v":1000},28,28000,1,92000]
[null,{"$f":"IF(MAX(H26:H27)>=fiche!$F$9,\"\",B27)","v":100},{"$f":"IF(MAX(H26:H27)>=fiche!$F$9,\"\",C27)","v":10},1000,{"$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":500},{"$f":"IF($F28=\"\",\"\",1)","v":1},{"$f":"IF(MAX($H$26:H27)>=fiche!$F$9,\"\",H27+F28)","v":92500},null,null,100,{"$f":"IF(ISERROR(O28/K28),\"\", O28/K28)","v":5},{"$f":"IF(ISERROR(L28*K28),\"\", L28*K28)","v":500},1,{"$f":"IFERROR(ROUNDUP(F28,-2),\"\")","v":500},1,{"$f":"IFERROR(ROUNDUP(H28,-2),\"\")","v":92500}]