{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Paramètres","Lots","BS_FEFO_Pick"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Paramètres","index":0,"n_rows":5,"n_cols":2,"rows_kept":5}
["Paramètres FEFO"]
[]
["Seuil alerte Jours restants",30]
["Unités (liste)","PIECE,KG,L,M,PACK,PAL"]
["Statuts qualité","Libre,Quarantaine,Bloqué"]

{"sheet":"Lots","index":1,"n_rows":103,"n_cols":17,"rows_kept":103,"merged":[[0,0,0,16]]}
["FEFO GUARD — Référentiel des lots & vieillissement"]
[]
["Code article","Désignation","Lot/Série","DLC/DPF","Magasin","Empl.","Statut","Qté","Unité","PMP","Valeur","Jours restants","Alerte?","Candidat (Pick)","Rang FEFO","Cum. avant","À PRÉLEVER"]
[{"$nulls":10},{"$f":"IF(AND(H4<>\"\",J4<>\"\"),H4*J4,\"\")","v":null},{"$f":"IF(D4<>\"\",D4-TODAY(),\"\")","v":null},{"$f":"IF(AND(L4<>\"\",L4<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A4=BS_FEFO_Pick!$B$3,G4=\"Libre\",H4>0),1,0)","v":null},{"$f":"IF(N4=1,COUNTIFS($A:$A,A4,$N:$N,1,$D:$D,\"<=\"&D4),\"\")","v":null},{"$f":"IF(N4=1,SUMIFS($H:$H,$A:$A,A4,$N:$N,1,$O:$O,\"<\"&O4),\"\")","v":null},{"$f":"IF(N4=1,MAX(0,MIN(H4,BS_FEFO_Pick!$B$4-P4)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H5<>\"\",J5<>\"\"),H5*J5,\"\")","v":null},{"$f":"IF(D5<>\"\",D5-TODAY(),\"\")","v":null},{"$f":"IF(AND(L5<>\"\",L5<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A5=BS_FEFO_Pick!$B$3,G5=\"Libre\",H5>0),1,0)","v":null},{"$f":"IF(N5=1,COUNTIFS($A:$A,A5,$N:$N,1,$D:$D,\"<=\"&D5),\"\")","v":null},{"$f":"IF(N5=1,SUMIFS($H:$H,$A:$A,A5,$N:$N,1,$O:$O,\"<\"&O5),\"\")","v":null},{"$f":"IF(N5=1,MAX(0,MIN(H5,BS_FEFO_Pick!$B$4-P5)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H6<>\"\",J6<>\"\"),H6*J6,\"\")","v":null},{"$f":"IF(D6<>\"\",D6-TODAY(),\"\")","v":null},{"$f":"IF(AND(L6<>\"\",L6<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A6=BS_FEFO_Pick!$B$3,G6=\"Libre\",H6>0),1,0)","v":null},{"$f":"IF(N6=1,COUNTIFS($A:$A,A6,$N:$N,1,$D:$D,\"<=\"&D6),\"\")","v":null},{"$f":"IF(N6=1,SUMIFS($H:$H,$A:$A,A6,$N:$N,1,$O:$O,\"<\"&O6),\"\")","v":null},{"$f":"IF(N6=1,MAX(0,MIN(H6,BS_FEFO_Pick!$B$4-P6)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H7<>\"\",J7<>\"\"),H7*J7,\"\")","v":null},{"$f":"IF(D7<>\"\",D7-TODAY(),\"\")","v":null},{"$f":"IF(AND(L7<>\"\",L7<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A7=BS_FEFO_Pick!$B$3,G7=\"Libre\",H7>0),1,0)","v":null},{"$f":"IF(N7=1,COUNTIFS($A:$A,A7,$N:$N,1,$D:$D,\"<=\"&D7),\"\")","v":null},{"$f":"IF(N7=1,SUMIFS($H:$H,$A:$A,A7,$N:$N,1,$O:$O,\"<\"&O7),\"\")","v":null},{"$f":"IF(N7=1,MAX(0,MIN(H7,BS_FEFO_Pick!$B$4-P7)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H8<>\"\",J8<>\"\"),H8*J8,\"\")","v":null},{"$f":"IF(D8<>\"\",D8-TODAY(),\"\")","v":null},{"$f":"IF(AND(L8<>\"\",L8<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A8=BS_FEFO_Pick!$B$3,G8=\"Libre\",H8>0),1,0)","v":null},{"$f":"IF(N8=1,COUNTIFS($A:$A,A8,$N:$N,1,$D:$D,\"<=\"&D8),\"\")","v":null},{"$f":"IF(N8=1,SUMIFS($H:$H,$A:$A,A8,$N:$N,1,$O:$O,\"<\"&O8),\"\")","v":null},{"$f":"IF(N8=1,MAX(0,MIN(H8,BS_FEFO_Pick!$B$4-P8)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H9<>\"\",J9<>\"\"),H9*J9,\"\")","v":null},{"$f":"IF(D9<>\"\",D9-TODAY(),\"\")","v":null},{"$f":"IF(AND(L9<>\"\",L9<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A9=BS_FEFO_Pick!$B$3,G9=\"Libre\",H9>0),1,0)","v":null},{"$f":"IF(N9=1,COUNTIFS($A:$A,A9,$N:$N,1,$D:$D,\"<=\"&D9),\"\")","v":null},{"$f":"IF(N9=1,SUMIFS($H:$H,$A:$A,A9,$N:$N,1,$O:$O,\"<\"&O9),\"\")","v":null},{"$f":"IF(N9=1,MAX(0,MIN(H9,BS_FEFO_Pick!$B$4-P9)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H10<>\"\",J10<>\"\"),H10*J10,\"\")","v":null},{"$f":"IF(D10<>\"\",D10-TODAY(),\"\")","v":null},{"$f":"IF(AND(L10<>\"\",L10<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A10=BS_FEFO_Pick!$B$3,G10=\"Libre\",H10>0),1,0)","v":null},{"$f":"IF(N10=1,COUNTIFS($A:$A,A10,$N:$N,1,$D:$D,\"<=\"&D10),\"\")","v":null},{"$f":"IF(N10=1,SUMIFS($H:$H,$A:$A,A10,$N:$N,1,$O:$O,\"<\"&O10),\"\")","v":null},{"$f":"IF(N10=1,MAX(0,MIN(H10,BS_FEFO_Pick!$B$4-P10)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H11<>\"\",J11<>\"\"),H11*J11,\"\")","v":null},{"$f":"IF(D11<>\"\",D11-TODAY(),\"\")","v":null},{"$f":"IF(AND(L11<>\"\",L11<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A11=BS_FEFO_Pick!$B$3,G11=\"Libre\",H11>0),1,0)","v":null},{"$f":"IF(N11=1,COUNTIFS($A:$A,A11,$N:$N,1,$D:$D,\"<=\"&D11),\"\")","v":null},{"$f":"IF(N11=1,SUMIFS($H:$H,$A:$A,A11,$N:$N,1,$O:$O,\"<\"&O11),\"\")","v":null},{"$f":"IF(N11=1,MAX(0,MIN(H11,BS_FEFO_Pick!$B$4-P11)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H12<>\"\",J12<>\"\"),H12*J12,\"\")","v":null},{"$f":"IF(D12<>\"\",D12-TODAY(),\"\")","v":null},{"$f":"IF(AND(L12<>\"\",L12<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A12=BS_FEFO_Pick!$B$3,G12=\"Libre\",H12>0),1,0)","v":null},{"$f":"IF(N12=1,COUNTIFS($A:$A,A12,$N:$N,1,$D:$D,\"<=\"&D12),\"\")","v":null},{"$f":"IF(N12=1,SUMIFS($H:$H,$A:$A,A12,$N:$N,1,$O:$O,\"<\"&O12),\"\")","v":null},{"$f":"IF(N12=1,MAX(0,MIN(H12,BS_FEFO_Pick!$B$4-P12)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H13<>\"\",J13<>\"\"),H13*J13,\"\")","v":null},{"$f":"IF(D13<>\"\",D13-TODAY(),\"\")","v":null},{"$f":"IF(AND(L13<>\"\",L13<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A13=BS_FEFO_Pick!$B$3,G13=\"Libre\",H13>0),1,0)","v":null},{"$f":"IF(N13=1,COUNTIFS($A:$A,A13,$N:$N,1,$D:$D,\"<=\"&D13),\"\")","v":null},{"$f":"IF(N13=1,SUMIFS($H:$H,$A:$A,A13,$N:$N,1,$O:$O,\"<\"&O13),\"\")","v":null},{"$f":"IF(N13=1,MAX(0,MIN(H13,BS_FEFO_Pick!$B$4-P13)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H14<>\"\",J14<>\"\"),H14*J14,\"\")","v":null},{"$f":"IF(D14<>\"\",D14-TODAY(),\"\")","v":null},{"$f":"IF(AND(L14<>\"\",L14<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A14=BS_FEFO_Pick!$B$3,G14=\"Libre\",H14>0),1,0)","v":null},{"$f":"IF(N14=1,COUNTIFS($A:$A,A14,$N:$N,1,$D:$D,\"<=\"&D14),\"\")","v":null},{"$f":"IF(N14=1,SUMIFS($H:$H,$A:$A,A14,$N:$N,1,$O:$O,\"<\"&O14),\"\")","v":null},{"$f":"IF(N14=1,MAX(0,MIN(H14,BS_FEFO_Pick!$B$4-P14)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H15<>\"\",J15<>\"\"),H15*J15,\"\")","v":null},{"$f":"IF(D15<>\"\",D15-TODAY(),\"\")","v":null},{"$f":"IF(AND(L15<>\"\",L15<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A15=BS_FEFO_Pick!$B$3,G15=\"Libre\",H15>0),1,0)","v":null},{"$f":"IF(N15=1,COUNTIFS($A:$A,A15,$N:$N,1,$D:$D,\"<=\"&D15),\"\")","v":null},{"$f":"IF(N15=1,SUMIFS($H:$H,$A:$A,A15,$N:$N,1,$O:$O,\"<\"&O15),\"\")","v":null},{"$f":"IF(N15=1,MAX(0,MIN(H15,BS_FEFO_Pick!$B$4-P15)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H16<>\"\",J16<>\"\"),H16*J16,\"\")","v":null},{"$f":"IF(D16<>\"\",D16-TODAY(),\"\")","v":null},{"$f":"IF(AND(L16<>\"\",L16<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A16=BS_FEFO_Pick!$B$3,G16=\"Libre\",H16>0),1,0)","v":null},{"$f":"IF(N16=1,COUNTIFS($A:$A,A16,$N:$N,1,$D:$D,\"<=\"&D16),\"\")","v":null},{"$f":"IF(N16=1,SUMIFS($H:$H,$A:$A,A16,$N:$N,1,$O:$O,\"<\"&O16),\"\")","v":null},{"$f":"IF(N16=1,MAX(0,MIN(H16,BS_FEFO_Pick!$B$4-P16)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H17<>\"\",J17<>\"\"),H17*J17,\"\")","v":null},{"$f":"IF(D17<>\"\",D17-TODAY(),\"\")","v":null},{"$f":"IF(AND(L17<>\"\",L17<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A17=BS_FEFO_Pick!$B$3,G17=\"Libre\",H17>0),1,0)","v":null},{"$f":"IF(N17=1,COUNTIFS($A:$A,A17,$N:$N,1,$D:$D,\"<=\"&D17),\"\")","v":null},{"$f":"IF(N17=1,SUMIFS($H:$H,$A:$A,A17,$N:$N,1,$O:$O,\"<\"&O17),\"\")","v":null},{"$f":"IF(N17=1,MAX(0,MIN(H17,BS_FEFO_Pick!$B$4-P17)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H18<>\"\",J18<>\"\"),H18*J18,\"\")","v":null},{"$f":"IF(D18<>\"\",D18-TODAY(),\"\")","v":null},{"$f":"IF(AND(L18<>\"\",L18<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A18=BS_FEFO_Pick!$B$3,G18=\"Libre\",H18>0),1,0)","v":null},{"$f":"IF(N18=1,COUNTIFS($A:$A,A18,$N:$N,1,$D:$D,\"<=\"&D18),\"\")","v":null},{"$f":"IF(N18=1,SUMIFS($H:$H,$A:$A,A18,$N:$N,1,$O:$O,\"<\"&O18),\"\")","v":null},{"$f":"IF(N18=1,MAX(0,MIN(H18,BS_FEFO_Pick!$B$4-P18)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H19<>\"\",J19<>\"\"),H19*J19,\"\")","v":null},{"$f":"IF(D19<>\"\",D19-TODAY(),\"\")","v":null},{"$f":"IF(AND(L19<>\"\",L19<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A19=BS_FEFO_Pick!$B$3,G19=\"Libre\",H19>0),1,0)","v":null},{"$f":"IF(N19=1,COUNTIFS($A:$A,A19,$N:$N,1,$D:$D,\"<=\"&D19),\"\")","v":null},{"$f":"IF(N19=1,SUMIFS($H:$H,$A:$A,A19,$N:$N,1,$O:$O,\"<\"&O19),\"\")","v":null},{"$f":"IF(N19=1,MAX(0,MIN(H19,BS_FEFO_Pick!$B$4-P19)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H20<>\"\",J20<>\"\"),H20*J20,\"\")","v":null},{"$f":"IF(D20<>\"\",D20-TODAY(),\"\")","v":null},{"$f":"IF(AND(L20<>\"\",L20<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A20=BS_FEFO_Pick!$B$3,G20=\"Libre\",H20>0),1,0)","v":null},{"$f":"IF(N20=1,COUNTIFS($A:$A,A20,$N:$N,1,$D:$D,\"<=\"&D20),\"\")","v":null},{"$f":"IF(N20=1,SUMIFS($H:$H,$A:$A,A20,$N:$N,1,$O:$O,\"<\"&O20),\"\")","v":null},{"$f":"IF(N20=1,MAX(0,MIN(H20,BS_FEFO_Pick!$B$4-P20)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H21<>\"\",J21<>\"\"),H21*J21,\"\")","v":null},{"$f":"IF(D21<>\"\",D21-TODAY(),\"\")","v":null},{"$f":"IF(AND(L21<>\"\",L21<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A21=BS_FEFO_Pick!$B$3,G21=\"Libre\",H21>0),1,0)","v":null},{"$f":"IF(N21=1,COUNTIFS($A:$A,A21,$N:$N,1,$D:$D,\"<=\"&D21),\"\")","v":null},{"$f":"IF(N21=1,SUMIFS($H:$H,$A:$A,A21,$N:$N,1,$O:$O,\"<\"&O21),\"\")","v":null},{"$f":"IF(N21=1,MAX(0,MIN(H21,BS_FEFO_Pick!$B$4-P21)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H22<>\"\",J22<>\"\"),H22*J22,\"\")","v":null},{"$f":"IF(D22<>\"\",D22-TODAY(),\"\")","v":null},{"$f":"IF(AND(L22<>\"\",L22<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A22=BS_FEFO_Pick!$B$3,G22=\"Libre\",H22>0),1,0)","v":null},{"$f":"IF(N22=1,COUNTIFS($A:$A,A22,$N:$N,1,$D:$D,\"<=\"&D22),\"\")","v":null},{"$f":"IF(N22=1,SUMIFS($H:$H,$A:$A,A22,$N:$N,1,$O:$O,\"<\"&O22),\"\")","v":null},{"$f":"IF(N22=1,MAX(0,MIN(H22,BS_FEFO_Pick!$B$4-P22)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H23<>\"\",J23<>\"\"),H23*J23,\"\")","v":null},{"$f":"IF(D23<>\"\",D23-TODAY(),\"\")","v":null},{"$f":"IF(AND(L23<>\"\",L23<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A23=BS_FEFO_Pick!$B$3,G23=\"Libre\",H23>0),1,0)","v":null},{"$f":"IF(N23=1,COUNTIFS($A:$A,A23,$N:$N,1,$D:$D,\"<=\"&D23),\"\")","v":null},{"$f":"IF(N23=1,SUMIFS($H:$H,$A:$A,A23,$N:$N,1,$O:$O,\"<\"&O23),\"\")","v":null},{"$f":"IF(N23=1,MAX(0,MIN(H23,BS_FEFO_Pick!$B$4-P23)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H24<>\"\",J24<>\"\"),H24*J24,\"\")","v":null},{"$f":"IF(D24<>\"\",D24-TODAY(),\"\")","v":null},{"$f":"IF(AND(L24<>\"\",L24<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A24=BS_FEFO_Pick!$B$3,G24=\"Libre\",H24>0),1,0)","v":null},{"$f":"IF(N24=1,COUNTIFS($A:$A,A24,$N:$N,1,$D:$D,\"<=\"&D24),\"\")","v":null},{"$f":"IF(N24=1,SUMIFS($H:$H,$A:$A,A24,$N:$N,1,$O:$O,\"<\"&O24),\"\")","v":null},{"$f":"IF(N24=1,MAX(0,MIN(H24,BS_FEFO_Pick!$B$4-P24)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H25<>\"\",J25<>\"\"),H25*J25,\"\")","v":null},{"$f":"IF(D25<>\"\",D25-TODAY(),\"\")","v":null},{"$f":"IF(AND(L25<>\"\",L25<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A25=BS_FEFO_Pick!$B$3,G25=\"Libre\",H25>0),1,0)","v":null},{"$f":"IF(N25=1,COUNTIFS($A:$A,A25,$N:$N,1,$D:$D,\"<=\"&D25),\"\")","v":null},{"$f":"IF(N25=1,SUMIFS($H:$H,$A:$A,A25,$N:$N,1,$O:$O,\"<\"&O25),\"\")","v":null},{"$f":"IF(N25=1,MAX(0,MIN(H25,BS_FEFO_Pick!$B$4-P25)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H26<>\"\",J26<>\"\"),H26*J26,\"\")","v":null},{"$f":"IF(D26<>\"\",D26-TODAY(),\"\")","v":null},{"$f":"IF(AND(L26<>\"\",L26<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A26=BS_FEFO_Pick!$B$3,G26=\"Libre\",H26>0),1,0)","v":null},{"$f":"IF(N26=1,COUNTIFS($A:$A,A26,$N:$N,1,$D:$D,\"<=\"&D26),\"\")","v":null},{"$f":"IF(N26=1,SUMIFS($H:$H,$A:$A,A26,$N:$N,1,$O:$O,\"<\"&O26),\"\")","v":null},{"$f":"IF(N26=1,MAX(0,MIN(H26,BS_FEFO_Pick!$B$4-P26)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H27<>\"\",J27<>\"\"),H27*J27,\"\")","v":null},{"$f":"IF(D27<>\"\",D27-TODAY(),\"\")","v":null},{"$f":"IF(AND(L27<>\"\",L27<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A27=BS_FEFO_Pick!$B$3,G27=\"Libre\",H27>0),1,0)","v":null},{"$f":"IF(N27=1,COUNTIFS($A:$A,A27,$N:$N,1,$D:$D,\"<=\"&D27),\"\")","v":null},{"$f":"IF(N27=1,SUMIFS($H:$H,$A:$A,A27,$N:$N,1,$O:$O,\"<\"&O27),\"\")","v":null},{"$f":"IF(N27=1,MAX(0,MIN(H27,BS_FEFO_Pick!$B$4-P27)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H28<>\"\",J28<>\"\"),H28*J28,\"\")","v":null},{"$f":"IF(D28<>\"\",D28-TODAY(),\"\")","v":null},{"$f":"IF(AND(L28<>\"\",L28<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A28=BS_FEFO_Pick!$B$3,G28=\"Libre\",H28>0),1,0)","v":null},{"$f":"IF(N28=1,COUNTIFS($A:$A,A28,$N:$N,1,$D:$D,\"<=\"&D28),\"\")","v":null},{"$f":"IF(N28=1,SUMIFS($H:$H,$A:$A,A28,$N:$N,1,$O:$O,\"<\"&O28),\"\")","v":null},{"$f":"IF(N28=1,MAX(0,MIN(H28,BS_FEFO_Pick!$B$4-P28)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H29<>\"\",J29<>\"\"),H29*J29,\"\")","v":null},{"$f":"IF(D29<>\"\",D29-TODAY(),\"\")","v":null},{"$f":"IF(AND(L29<>\"\",L29<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A29=BS_FEFO_Pick!$B$3,G29=\"Libre\",H29>0),1,0)","v":null},{"$f":"IF(N29=1,COUNTIFS($A:$A,A29,$N:$N,1,$D:$D,\"<=\"&D29),\"\")","v":null},{"$f":"IF(N29=1,SUMIFS($H:$H,$A:$A,A29,$N:$N,1,$O:$O,\"<\"&O29),\"\")","v":null},{"$f":"IF(N29=1,MAX(0,MIN(H29,BS_FEFO_Pick!$B$4-P29)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H30<>\"\",J30<>\"\"),H30*J30,\"\")","v":null},{"$f":"IF(D30<>\"\",D30-TODAY(),\"\")","v":null},{"$f":"IF(AND(L30<>\"\",L30<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A30=BS_FEFO_Pick!$B$3,G30=\"Libre\",H30>0),1,0)","v":null},{"$f":"IF(N30=1,COUNTIFS($A:$A,A30,$N:$N,1,$D:$D,\"<=\"&D30),\"\")","v":null},{"$f":"IF(N30=1,SUMIFS($H:$H,$A:$A,A30,$N:$N,1,$O:$O,\"<\"&O30),\"\")","v":null},{"$f":"IF(N30=1,MAX(0,MIN(H30,BS_FEFO_Pick!$B$4-P30)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H31<>\"\",J31<>\"\"),H31*J31,\"\")","v":null},{"$f":"IF(D31<>\"\",D31-TODAY(),\"\")","v":null},{"$f":"IF(AND(L31<>\"\",L31<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A31=BS_FEFO_Pick!$B$3,G31=\"Libre\",H31>0),1,0)","v":null},{"$f":"IF(N31=1,COUNTIFS($A:$A,A31,$N:$N,1,$D:$D,\"<=\"&D31),\"\")","v":null},{"$f":"IF(N31=1,SUMIFS($H:$H,$A:$A,A31,$N:$N,1,$O:$O,\"<\"&O31),\"\")","v":null},{"$f":"IF(N31=1,MAX(0,MIN(H31,BS_FEFO_Pick!$B$4-P31)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H32<>\"\",J32<>\"\"),H32*J32,\"\")","v":null},{"$f":"IF(D32<>\"\",D32-TODAY(),\"\")","v":null},{"$f":"IF(AND(L32<>\"\",L32<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A32=BS_FEFO_Pick!$B$3,G32=\"Libre\",H32>0),1,0)","v":null},{"$f":"IF(N32=1,COUNTIFS($A:$A,A32,$N:$N,1,$D:$D,\"<=\"&D32),\"\")","v":null},{"$f":"IF(N32=1,SUMIFS($H:$H,$A:$A,A32,$N:$N,1,$O:$O,\"<\"&O32),\"\")","v":null},{"$f":"IF(N32=1,MAX(0,MIN(H32,BS_FEFO_Pick!$B$4-P32)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H33<>\"\",J33<>\"\"),H33*J33,\"\")","v":null},{"$f":"IF(D33<>\"\",D33-TODAY(),\"\")","v":null},{"$f":"IF(AND(L33<>\"\",L33<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A33=BS_FEFO_Pick!$B$3,G33=\"Libre\",H33>0),1,0)","v":null},{"$f":"IF(N33=1,COUNTIFS($A:$A,A33,$N:$N,1,$D:$D,\"<=\"&D33),\"\")","v":null},{"$f":"IF(N33=1,SUMIFS($H:$H,$A:$A,A33,$N:$N,1,$O:$O,\"<\"&O33),\"\")","v":null},{"$f":"IF(N33=1,MAX(0,MIN(H33,BS_FEFO_Pick!$B$4-P33)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H34<>\"\",J34<>\"\"),H34*J34,\"\")","v":null},{"$f":"IF(D34<>\"\",D34-TODAY(),\"\")","v":null},{"$f":"IF(AND(L34<>\"\",L34<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A34=BS_FEFO_Pick!$B$3,G34=\"Libre\",H34>0),1,0)","v":null},{"$f":"IF(N34=1,COUNTIFS($A:$A,A34,$N:$N,1,$D:$D,\"<=\"&D34),\"\")","v":null},{"$f":"IF(N34=1,SUMIFS($H:$H,$A:$A,A34,$N:$N,1,$O:$O,\"<\"&O34),\"\")","v":null},{"$f":"IF(N34=1,MAX(0,MIN(H34,BS_FEFO_Pick!$B$4-P34)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H35<>\"\",J35<>\"\"),H35*J35,\"\")","v":null},{"$f":"IF(D35<>\"\",D35-TODAY(),\"\")","v":null},{"$f":"IF(AND(L35<>\"\",L35<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A35=BS_FEFO_Pick!$B$3,G35=\"Libre\",H35>0),1,0)","v":null},{"$f":"IF(N35=1,COUNTIFS($A:$A,A35,$N:$N,1,$D:$D,\"<=\"&D35),\"\")","v":null},{"$f":"IF(N35=1,SUMIFS($H:$H,$A:$A,A35,$N:$N,1,$O:$O,\"<\"&O35),\"\")","v":null},{"$f":"IF(N35=1,MAX(0,MIN(H35,BS_FEFO_Pick!$B$4-P35)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H36<>\"\",J36<>\"\"),H36*J36,\"\")","v":null},{"$f":"IF(D36<>\"\",D36-TODAY(),\"\")","v":null},{"$f":"IF(AND(L36<>\"\",L36<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A36=BS_FEFO_Pick!$B$3,G36=\"Libre\",H36>0),1,0)","v":null},{"$f":"IF(N36=1,COUNTIFS($A:$A,A36,$N:$N,1,$D:$D,\"<=\"&D36),\"\")","v":null},{"$f":"IF(N36=1,SUMIFS($H:$H,$A:$A,A36,$N:$N,1,$O:$O,\"<\"&O36),\"\")","v":null},{"$f":"IF(N36=1,MAX(0,MIN(H36,BS_FEFO_Pick!$B$4-P36)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H37<>\"\",J37<>\"\"),H37*J37,\"\")","v":null},{"$f":"IF(D37<>\"\",D37-TODAY(),\"\")","v":null},{"$f":"IF(AND(L37<>\"\",L37<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A37=BS_FEFO_Pick!$B$3,G37=\"Libre\",H37>0),1,0)","v":null},{"$f":"IF(N37=1,COUNTIFS($A:$A,A37,$N:$N,1,$D:$D,\"<=\"&D37),\"\")","v":null},{"$f":"IF(N37=1,SUMIFS($H:$H,$A:$A,A37,$N:$N,1,$O:$O,\"<\"&O37),\"\")","v":null},{"$f":"IF(N37=1,MAX(0,MIN(H37,BS_FEFO_Pick!$B$4-P37)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H38<>\"\",J38<>\"\"),H38*J38,\"\")","v":null},{"$f":"IF(D38<>\"\",D38-TODAY(),\"\")","v":null},{"$f":"IF(AND(L38<>\"\",L38<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A38=BS_FEFO_Pick!$B$3,G38=\"Libre\",H38>0),1,0)","v":null},{"$f":"IF(N38=1,COUNTIFS($A:$A,A38,$N:$N,1,$D:$D,\"<=\"&D38),\"\")","v":null},{"$f":"IF(N38=1,SUMIFS($H:$H,$A:$A,A38,$N:$N,1,$O:$O,\"<\"&O38),\"\")","v":null},{"$f":"IF(N38=1,MAX(0,MIN(H38,BS_FEFO_Pick!$B$4-P38)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H39<>\"\",J39<>\"\"),H39*J39,\"\")","v":null},{"$f":"IF(D39<>\"\",D39-TODAY(),\"\")","v":null},{"$f":"IF(AND(L39<>\"\",L39<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A39=BS_FEFO_Pick!$B$3,G39=\"Libre\",H39>0),1,0)","v":null},{"$f":"IF(N39=1,COUNTIFS($A:$A,A39,$N:$N,1,$D:$D,\"<=\"&D39),\"\")","v":null},{"$f":"IF(N39=1,SUMIFS($H:$H,$A:$A,A39,$N:$N,1,$O:$O,\"<\"&O39),\"\")","v":null},{"$f":"IF(N39=1,MAX(0,MIN(H39,BS_FEFO_Pick!$B$4-P39)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H40<>\"\",J40<>\"\"),H40*J40,\"\")","v":null},{"$f":"IF(D40<>\"\",D40-TODAY(),\"\")","v":null},{"$f":"IF(AND(L40<>\"\",L40<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A40=BS_FEFO_Pick!$B$3,G40=\"Libre\",H40>0),1,0)","v":null},{"$f":"IF(N40=1,COUNTIFS($A:$A,A40,$N:$N,1,$D:$D,\"<=\"&D40),\"\")","v":null},{"$f":"IF(N40=1,SUMIFS($H:$H,$A:$A,A40,$N:$N,1,$O:$O,\"<\"&O40),\"\")","v":null},{"$f":"IF(N40=1,MAX(0,MIN(H40,BS_FEFO_Pick!$B$4-P40)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H41<>\"\",J41<>\"\"),H41*J41,\"\")","v":null},{"$f":"IF(D41<>\"\",D41-TODAY(),\"\")","v":null},{"$f":"IF(AND(L41<>\"\",L41<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A41=BS_FEFO_Pick!$B$3,G41=\"Libre\",H41>0),1,0)","v":null},{"$f":"IF(N41=1,COUNTIFS($A:$A,A41,$N:$N,1,$D:$D,\"<=\"&D41),\"\")","v":null},{"$f":"IF(N41=1,SUMIFS($H:$H,$A:$A,A41,$N:$N,1,$O:$O,\"<\"&O41),\"\")","v":null},{"$f":"IF(N41=1,MAX(0,MIN(H41,BS_FEFO_Pick!$B$4-P41)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H42<>\"\",J42<>\"\"),H42*J42,\"\")","v":null},{"$f":"IF(D42<>\"\",D42-TODAY(),\"\")","v":null},{"$f":"IF(AND(L42<>\"\",L42<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A42=BS_FEFO_Pick!$B$3,G42=\"Libre\",H42>0),1,0)","v":null},{"$f":"IF(N42=1,COUNTIFS($A:$A,A42,$N:$N,1,$D:$D,\"<=\"&D42),\"\")","v":null},{"$f":"IF(N42=1,SUMIFS($H:$H,$A:$A,A42,$N:$N,1,$O:$O,\"<\"&O42),\"\")","v":null},{"$f":"IF(N42=1,MAX(0,MIN(H42,BS_FEFO_Pick!$B$4-P42)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H43<>\"\",J43<>\"\"),H43*J43,\"\")","v":null},{"$f":"IF(D43<>\"\",D43-TODAY(),\"\")","v":null},{"$f":"IF(AND(L43<>\"\",L43<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A43=BS_FEFO_Pick!$B$3,G43=\"Libre\",H43>0),1,0)","v":null},{"$f":"IF(N43=1,COUNTIFS($A:$A,A43,$N:$N,1,$D:$D,\"<=\"&D43),\"\")","v":null},{"$f":"IF(N43=1,SUMIFS($H:$H,$A:$A,A43,$N:$N,1,$O:$O,\"<\"&O43),\"\")","v":null},{"$f":"IF(N43=1,MAX(0,MIN(H43,BS_FEFO_Pick!$B$4-P43)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H44<>\"\",J44<>\"\"),H44*J44,\"\")","v":null},{"$f":"IF(D44<>\"\",D44-TODAY(),\"\")","v":null},{"$f":"IF(AND(L44<>\"\",L44<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A44=BS_FEFO_Pick!$B$3,G44=\"Libre\",H44>0),1,0)","v":null},{"$f":"IF(N44=1,COUNTIFS($A:$A,A44,$N:$N,1,$D:$D,\"<=\"&D44),\"\")","v":null},{"$f":"IF(N44=1,SUMIFS($H:$H,$A:$A,A44,$N:$N,1,$O:$O,\"<\"&O44),\"\")","v":null},{"$f":"IF(N44=1,MAX(0,MIN(H44,BS_FEFO_Pick!$B$4-P44)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H45<>\"\",J45<>\"\"),H45*J45,\"\")","v":null},{"$f":"IF(D45<>\"\",D45-TODAY(),\"\")","v":null},{"$f":"IF(AND(L45<>\"\",L45<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A45=BS_FEFO_Pick!$B$3,G45=\"Libre\",H45>0),1,0)","v":null},{"$f":"IF(N45=1,COUNTIFS($A:$A,A45,$N:$N,1,$D:$D,\"<=\"&D45),\"\")","v":null},{"$f":"IF(N45=1,SUMIFS($H:$H,$A:$A,A45,$N:$N,1,$O:$O,\"<\"&O45),\"\")","v":null},{"$f":"IF(N45=1,MAX(0,MIN(H45,BS_FEFO_Pick!$B$4-P45)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H46<>\"\",J46<>\"\"),H46*J46,\"\")","v":null},{"$f":"IF(D46<>\"\",D46-TODAY(),\"\")","v":null},{"$f":"IF(AND(L46<>\"\",L46<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A46=BS_FEFO_Pick!$B$3,G46=\"Libre\",H46>0),1,0)","v":null},{"$f":"IF(N46=1,COUNTIFS($A:$A,A46,$N:$N,1,$D:$D,\"<=\"&D46),\"\")","v":null},{"$f":"IF(N46=1,SUMIFS($H:$H,$A:$A,A46,$N:$N,1,$O:$O,\"<\"&O46),\"\")","v":null},{"$f":"IF(N46=1,MAX(0,MIN(H46,BS_FEFO_Pick!$B$4-P46)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H47<>\"\",J47<>\"\"),H47*J47,\"\")","v":null},{"$f":"IF(D47<>\"\",D47-TODAY(),\"\")","v":null},{"$f":"IF(AND(L47<>\"\",L47<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A47=BS_FEFO_Pick!$B$3,G47=\"Libre\",H47>0),1,0)","v":null},{"$f":"IF(N47=1,COUNTIFS($A:$A,A47,$N:$N,1,$D:$D,\"<=\"&D47),\"\")","v":null},{"$f":"IF(N47=1,SUMIFS($H:$H,$A:$A,A47,$N:$N,1,$O:$O,\"<\"&O47),\"\")","v":null},{"$f":"IF(N47=1,MAX(0,MIN(H47,BS_FEFO_Pick!$B$4-P47)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H48<>\"\",J48<>\"\"),H48*J48,\"\")","v":null},{"$f":"IF(D48<>\"\",D48-TODAY(),\"\")","v":null},{"$f":"IF(AND(L48<>\"\",L48<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A48=BS_FEFO_Pick!$B$3,G48=\"Libre\",H48>0),1,0)","v":null},{"$f":"IF(N48=1,COUNTIFS($A:$A,A48,$N:$N,1,$D:$D,\"<=\"&D48),\"\")","v":null},{"$f":"IF(N48=1,SUMIFS($H:$H,$A:$A,A48,$N:$N,1,$O:$O,\"<\"&O48),\"\")","v":null},{"$f":"IF(N48=1,MAX(0,MIN(H48,BS_FEFO_Pick!$B$4-P48)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H49<>\"\",J49<>\"\"),H49*J49,\"\")","v":null},{"$f":"IF(D49<>\"\",D49-TODAY(),\"\")","v":null},{"$f":"IF(AND(L49<>\"\",L49<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A49=BS_FEFO_Pick!$B$3,G49=\"Libre\",H49>0),1,0)","v":null},{"$f":"IF(N49=1,COUNTIFS($A:$A,A49,$N:$N,1,$D:$D,\"<=\"&D49),\"\")","v":null},{"$f":"IF(N49=1,SUMIFS($H:$H,$A:$A,A49,$N:$N,1,$O:$O,\"<\"&O49),\"\")","v":null},{"$f":"IF(N49=1,MAX(0,MIN(H49,BS_FEFO_Pick!$B$4-P49)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H50<>\"\",J50<>\"\"),H50*J50,\"\")","v":null},{"$f":"IF(D50<>\"\",D50-TODAY(),\"\")","v":null},{"$f":"IF(AND(L50<>\"\",L50<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A50=BS_FEFO_Pick!$B$3,G50=\"Libre\",H50>0),1,0)","v":null},{"$f":"IF(N50=1,COUNTIFS($A:$A,A50,$N:$N,1,$D:$D,\"<=\"&D50),\"\")","v":null},{"$f":"IF(N50=1,SUMIFS($H:$H,$A:$A,A50,$N:$N,1,$O:$O,\"<\"&O50),\"\")","v":null},{"$f":"IF(N50=1,MAX(0,MIN(H50,BS_FEFO_Pick!$B$4-P50)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H51<>\"\",J51<>\"\"),H51*J51,\"\")","v":null},{"$f":"IF(D51<>\"\",D51-TODAY(),\"\")","v":null},{"$f":"IF(AND(L51<>\"\",L51<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A51=BS_FEFO_Pick!$B$3,G51=\"Libre\",H51>0),1,0)","v":null},{"$f":"IF(N51=1,COUNTIFS($A:$A,A51,$N:$N,1,$D:$D,\"<=\"&D51),\"\")","v":null},{"$f":"IF(N51=1,SUMIFS($H:$H,$A:$A,A51,$N:$N,1,$O:$O,\"<\"&O51),\"\")","v":null},{"$f":"IF(N51=1,MAX(0,MIN(H51,BS_FEFO_Pick!$B$4-P51)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H52<>\"\",J52<>\"\"),H52*J52,\"\")","v":null},{"$f":"IF(D52<>\"\",D52-TODAY(),\"\")","v":null},{"$f":"IF(AND(L52<>\"\",L52<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A52=BS_FEFO_Pick!$B$3,G52=\"Libre\",H52>0),1,0)","v":null},{"$f":"IF(N52=1,COUNTIFS($A:$A,A52,$N:$N,1,$D:$D,\"<=\"&D52),\"\")","v":null},{"$f":"IF(N52=1,SUMIFS($H:$H,$A:$A,A52,$N:$N,1,$O:$O,\"<\"&O52),\"\")","v":null},{"$f":"IF(N52=1,MAX(0,MIN(H52,BS_FEFO_Pick!$B$4-P52)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H53<>\"\",J53<>\"\"),H53*J53,\"\")","v":null},{"$f":"IF(D53<>\"\",D53-TODAY(),\"\")","v":null},{"$f":"IF(AND(L53<>\"\",L53<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A53=BS_FEFO_Pick!$B$3,G53=\"Libre\",H53>0),1,0)","v":null},{"$f":"IF(N53=1,COUNTIFS($A:$A,A53,$N:$N,1,$D:$D,\"<=\"&D53),\"\")","v":null},{"$f":"IF(N53=1,SUMIFS($H:$H,$A:$A,A53,$N:$N,1,$O:$O,\"<\"&O53),\"\")","v":null},{"$f":"IF(N53=1,MAX(0,MIN(H53,BS_FEFO_Pick!$B$4-P53)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H54<>\"\",J54<>\"\"),H54*J54,\"\")","v":null},{"$f":"IF(D54<>\"\",D54-TODAY(),\"\")","v":null},{"$f":"IF(AND(L54<>\"\",L54<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A54=BS_FEFO_Pick!$B$3,G54=\"Libre\",H54>0),1,0)","v":null},{"$f":"IF(N54=1,COUNTIFS($A:$A,A54,$N:$N,1,$D:$D,\"<=\"&D54),\"\")","v":null},{"$f":"IF(N54=1,SUMIFS($H:$H,$A:$A,A54,$N:$N,1,$O:$O,\"<\"&O54),\"\")","v":null},{"$f":"IF(N54=1,MAX(0,MIN(H54,BS_FEFO_Pick!$B$4-P54)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H55<>\"\",J55<>\"\"),H55*J55,\"\")","v":null},{"$f":"IF(D55<>\"\",D55-TODAY(),\"\")","v":null},{"$f":"IF(AND(L55<>\"\",L55<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A55=BS_FEFO_Pick!$B$3,G55=\"Libre\",H55>0),1,0)","v":null},{"$f":"IF(N55=1,COUNTIFS($A:$A,A55,$N:$N,1,$D:$D,\"<=\"&D55),\"\")","v":null},{"$f":"IF(N55=1,SUMIFS($H:$H,$A:$A,A55,$N:$N,1,$O:$O,\"<\"&O55),\"\")","v":null},{"$f":"IF(N55=1,MAX(0,MIN(H55,BS_FEFO_Pick!$B$4-P55)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H56<>\"\",J56<>\"\"),H56*J56,\"\")","v":null},{"$f":"IF(D56<>\"\",D56-TODAY(),\"\")","v":null},{"$f":"IF(AND(L56<>\"\",L56<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A56=BS_FEFO_Pick!$B$3,G56=\"Libre\",H56>0),1,0)","v":null},{"$f":"IF(N56=1,COUNTIFS($A:$A,A56,$N:$N,1,$D:$D,\"<=\"&D56),\"\")","v":null},{"$f":"IF(N56=1,SUMIFS($H:$H,$A:$A,A56,$N:$N,1,$O:$O,\"<\"&O56),\"\")","v":null},{"$f":"IF(N56=1,MAX(0,MIN(H56,BS_FEFO_Pick!$B$4-P56)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H57<>\"\",J57<>\"\"),H57*J57,\"\")","v":null},{"$f":"IF(D57<>\"\",D57-TODAY(),\"\")","v":null},{"$f":"IF(AND(L57<>\"\",L57<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A57=BS_FEFO_Pick!$B$3,G57=\"Libre\",H57>0),1,0)","v":null},{"$f":"IF(N57=1,COUNTIFS($A:$A,A57,$N:$N,1,$D:$D,\"<=\"&D57),\"\")","v":null},{"$f":"IF(N57=1,SUMIFS($H:$H,$A:$A,A57,$N:$N,1,$O:$O,\"<\"&O57),\"\")","v":null},{"$f":"IF(N57=1,MAX(0,MIN(H57,BS_FEFO_Pick!$B$4-P57)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H58<>\"\",J58<>\"\"),H58*J58,\"\")","v":null},{"$f":"IF(D58<>\"\",D58-TODAY(),\"\")","v":null},{"$f":"IF(AND(L58<>\"\",L58<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A58=BS_FEFO_Pick!$B$3,G58=\"Libre\",H58>0),1,0)","v":null},{"$f":"IF(N58=1,COUNTIFS($A:$A,A58,$N:$N,1,$D:$D,\"<=\"&D58),\"\")","v":null},{"$f":"IF(N58=1,SUMIFS($H:$H,$A:$A,A58,$N:$N,1,$O:$O,\"<\"&O58),\"\")","v":null},{"$f":"IF(N58=1,MAX(0,MIN(H58,BS_FEFO_Pick!$B$4-P58)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H59<>\"\",J59<>\"\"),H59*J59,\"\")","v":null},{"$f":"IF(D59<>\"\",D59-TODAY(),\"\")","v":null},{"$f":"IF(AND(L59<>\"\",L59<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A59=BS_FEFO_Pick!$B$3,G59=\"Libre\",H59>0),1,0)","v":null},{"$f":"IF(N59=1,COUNTIFS($A:$A,A59,$N:$N,1,$D:$D,\"<=\"&D59),\"\")","v":null},{"$f":"IF(N59=1,SUMIFS($H:$H,$A:$A,A59,$N:$N,1,$O:$O,\"<\"&O59),\"\")","v":null},{"$f":"IF(N59=1,MAX(0,MIN(H59,BS_FEFO_Pick!$B$4-P59)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H60<>\"\",J60<>\"\"),H60*J60,\"\")","v":null},{"$f":"IF(D60<>\"\",D60-TODAY(),\"\")","v":null},{"$f":"IF(AND(L60<>\"\",L60<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A60=BS_FEFO_Pick!$B$3,G60=\"Libre\",H60>0),1,0)","v":null},{"$f":"IF(N60=1,COUNTIFS($A:$A,A60,$N:$N,1,$D:$D,\"<=\"&D60),\"\")","v":null},{"$f":"IF(N60=1,SUMIFS($H:$H,$A:$A,A60,$N:$N,1,$O:$O,\"<\"&O60),\"\")","v":null},{"$f":"IF(N60=1,MAX(0,MIN(H60,BS_FEFO_Pick!$B$4-P60)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H61<>\"\",J61<>\"\"),H61*J61,\"\")","v":null},{"$f":"IF(D61<>\"\",D61-TODAY(),\"\")","v":null},{"$f":"IF(AND(L61<>\"\",L61<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A61=BS_FEFO_Pick!$B$3,G61=\"Libre\",H61>0),1,0)","v":null},{"$f":"IF(N61=1,COUNTIFS($A:$A,A61,$N:$N,1,$D:$D,\"<=\"&D61),\"\")","v":null},{"$f":"IF(N61=1,SUMIFS($H:$H,$A:$A,A61,$N:$N,1,$O:$O,\"<\"&O61),\"\")","v":null},{"$f":"IF(N61=1,MAX(0,MIN(H61,BS_FEFO_Pick!$B$4-P61)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H62<>\"\",J62<>\"\"),H62*J62,\"\")","v":null},{"$f":"IF(D62<>\"\",D62-TODAY(),\"\")","v":null},{"$f":"IF(AND(L62<>\"\",L62<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A62=BS_FEFO_Pick!$B$3,G62=\"Libre\",H62>0),1,0)","v":null},{"$f":"IF(N62=1,COUNTIFS($A:$A,A62,$N:$N,1,$D:$D,\"<=\"&D62),\"\")","v":null},{"$f":"IF(N62=1,SUMIFS($H:$H,$A:$A,A62,$N:$N,1,$O:$O,\"<\"&O62),\"\")","v":null},{"$f":"IF(N62=1,MAX(0,MIN(H62,BS_FEFO_Pick!$B$4-P62)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H63<>\"\",J63<>\"\"),H63*J63,\"\")","v":null},{"$f":"IF(D63<>\"\",D63-TODAY(),\"\")","v":null},{"$f":"IF(AND(L63<>\"\",L63<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A63=BS_FEFO_Pick!$B$3,G63=\"Libre\",H63>0),1,0)","v":null},{"$f":"IF(N63=1,COUNTIFS($A:$A,A63,$N:$N,1,$D:$D,\"<=\"&D63),\"\")","v":null},{"$f":"IF(N63=1,SUMIFS($H:$H,$A:$A,A63,$N:$N,1,$O:$O,\"<\"&O63),\"\")","v":null},{"$f":"IF(N63=1,MAX(0,MIN(H63,BS_FEFO_Pick!$B$4-P63)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H64<>\"\",J64<>\"\"),H64*J64,\"\")","v":null},{"$f":"IF(D64<>\"\",D64-TODAY(),\"\")","v":null},{"$f":"IF(AND(L64<>\"\",L64<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A64=BS_FEFO_Pick!$B$3,G64=\"Libre\",H64>0),1,0)","v":null},{"$f":"IF(N64=1,COUNTIFS($A:$A,A64,$N:$N,1,$D:$D,\"<=\"&D64),\"\")","v":null},{"$f":"IF(N64=1,SUMIFS($H:$H,$A:$A,A64,$N:$N,1,$O:$O,\"<\"&O64),\"\")","v":null},{"$f":"IF(N64=1,MAX(0,MIN(H64,BS_FEFO_Pick!$B$4-P64)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H65<>\"\",J65<>\"\"),H65*J65,\"\")","v":null},{"$f":"IF(D65<>\"\",D65-TODAY(),\"\")","v":null},{"$f":"IF(AND(L65<>\"\",L65<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A65=BS_FEFO_Pick!$B$3,G65=\"Libre\",H65>0),1,0)","v":null},{"$f":"IF(N65=1,COUNTIFS($A:$A,A65,$N:$N,1,$D:$D,\"<=\"&D65),\"\")","v":null},{"$f":"IF(N65=1,SUMIFS($H:$H,$A:$A,A65,$N:$N,1,$O:$O,\"<\"&O65),\"\")","v":null},{"$f":"IF(N65=1,MAX(0,MIN(H65,BS_FEFO_Pick!$B$4-P65)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H66<>\"\",J66<>\"\"),H66*J66,\"\")","v":null},{"$f":"IF(D66<>\"\",D66-TODAY(),\"\")","v":null},{"$f":"IF(AND(L66<>\"\",L66<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A66=BS_FEFO_Pick!$B$3,G66=\"Libre\",H66>0),1,0)","v":null},{"$f":"IF(N66=1,COUNTIFS($A:$A,A66,$N:$N,1,$D:$D,\"<=\"&D66),\"\")","v":null},{"$f":"IF(N66=1,SUMIFS($H:$H,$A:$A,A66,$N:$N,1,$O:$O,\"<\"&O66),\"\")","v":null},{"$f":"IF(N66=1,MAX(0,MIN(H66,BS_FEFO_Pick!$B$4-P66)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H67<>\"\",J67<>\"\"),H67*J67,\"\")","v":null},{"$f":"IF(D67<>\"\",D67-TODAY(),\"\")","v":null},{"$f":"IF(AND(L67<>\"\",L67<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A67=BS_FEFO_Pick!$B$3,G67=\"Libre\",H67>0),1,0)","v":null},{"$f":"IF(N67=1,COUNTIFS($A:$A,A67,$N:$N,1,$D:$D,\"<=\"&D67),\"\")","v":null},{"$f":"IF(N67=1,SUMIFS($H:$H,$A:$A,A67,$N:$N,1,$O:$O,\"<\"&O67),\"\")","v":null},{"$f":"IF(N67=1,MAX(0,MIN(H67,BS_FEFO_Pick!$B$4-P67)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H68<>\"\",J68<>\"\"),H68*J68,\"\")","v":null},{"$f":"IF(D68<>\"\",D68-TODAY(),\"\")","v":null},{"$f":"IF(AND(L68<>\"\",L68<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A68=BS_FEFO_Pick!$B$3,G68=\"Libre\",H68>0),1,0)","v":null},{"$f":"IF(N68=1,COUNTIFS($A:$A,A68,$N:$N,1,$D:$D,\"<=\"&D68),\"\")","v":null},{"$f":"IF(N68=1,SUMIFS($H:$H,$A:$A,A68,$N:$N,1,$O:$O,\"<\"&O68),\"\")","v":null},{"$f":"IF(N68=1,MAX(0,MIN(H68,BS_FEFO_Pick!$B$4-P68)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H69<>\"\",J69<>\"\"),H69*J69,\"\")","v":null},{"$f":"IF(D69<>\"\",D69-TODAY(),\"\")","v":null},{"$f":"IF(AND(L69<>\"\",L69<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A69=BS_FEFO_Pick!$B$3,G69=\"Libre\",H69>0),1,0)","v":null},{"$f":"IF(N69=1,COUNTIFS($A:$A,A69,$N:$N,1,$D:$D,\"<=\"&D69),\"\")","v":null},{"$f":"IF(N69=1,SUMIFS($H:$H,$A:$A,A69,$N:$N,1,$O:$O,\"<\"&O69),\"\")","v":null},{"$f":"IF(N69=1,MAX(0,MIN(H69,BS_FEFO_Pick!$B$4-P69)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H70<>\"\",J70<>\"\"),H70*J70,\"\")","v":null},{"$f":"IF(D70<>\"\",D70-TODAY(),\"\")","v":null},{"$f":"IF(AND(L70<>\"\",L70<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A70=BS_FEFO_Pick!$B$3,G70=\"Libre\",H70>0),1,0)","v":null},{"$f":"IF(N70=1,COUNTIFS($A:$A,A70,$N:$N,1,$D:$D,\"<=\"&D70),\"\")","v":null},{"$f":"IF(N70=1,SUMIFS($H:$H,$A:$A,A70,$N:$N,1,$O:$O,\"<\"&O70),\"\")","v":null},{"$f":"IF(N70=1,MAX(0,MIN(H70,BS_FEFO_Pick!$B$4-P70)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H71<>\"\",J71<>\"\"),H71*J71,\"\")","v":null},{"$f":"IF(D71<>\"\",D71-TODAY(),\"\")","v":null},{"$f":"IF(AND(L71<>\"\",L71<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A71=BS_FEFO_Pick!$B$3,G71=\"Libre\",H71>0),1,0)","v":null},{"$f":"IF(N71=1,COUNTIFS($A:$A,A71,$N:$N,1,$D:$D,\"<=\"&D71),\"\")","v":null},{"$f":"IF(N71=1,SUMIFS($H:$H,$A:$A,A71,$N:$N,1,$O:$O,\"<\"&O71),\"\")","v":null},{"$f":"IF(N71=1,MAX(0,MIN(H71,BS_FEFO_Pick!$B$4-P71)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H72<>\"\",J72<>\"\"),H72*J72,\"\")","v":null},{"$f":"IF(D72<>\"\",D72-TODAY(),\"\")","v":null},{"$f":"IF(AND(L72<>\"\",L72<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A72=BS_FEFO_Pick!$B$3,G72=\"Libre\",H72>0),1,0)","v":null},{"$f":"IF(N72=1,COUNTIFS($A:$A,A72,$N:$N,1,$D:$D,\"<=\"&D72),\"\")","v":null},{"$f":"IF(N72=1,SUMIFS($H:$H,$A:$A,A72,$N:$N,1,$O:$O,\"<\"&O72),\"\")","v":null},{"$f":"IF(N72=1,MAX(0,MIN(H72,BS_FEFO_Pick!$B$4-P72)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H73<>\"\",J73<>\"\"),H73*J73,\"\")","v":null},{"$f":"IF(D73<>\"\",D73-TODAY(),\"\")","v":null},{"$f":"IF(AND(L73<>\"\",L73<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A73=BS_FEFO_Pick!$B$3,G73=\"Libre\",H73>0),1,0)","v":null},{"$f":"IF(N73=1,COUNTIFS($A:$A,A73,$N:$N,1,$D:$D,\"<=\"&D73),\"\")","v":null},{"$f":"IF(N73=1,SUMIFS($H:$H,$A:$A,A73,$N:$N,1,$O:$O,\"<\"&O73),\"\")","v":null},{"$f":"IF(N73=1,MAX(0,MIN(H73,BS_FEFO_Pick!$B$4-P73)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H74<>\"\",J74<>\"\"),H74*J74,\"\")","v":null},{"$f":"IF(D74<>\"\",D74-TODAY(),\"\")","v":null},{"$f":"IF(AND(L74<>\"\",L74<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A74=BS_FEFO_Pick!$B$3,G74=\"Libre\",H74>0),1,0)","v":null},{"$f":"IF(N74=1,COUNTIFS($A:$A,A74,$N:$N,1,$D:$D,\"<=\"&D74),\"\")","v":null},{"$f":"IF(N74=1,SUMIFS($H:$H,$A:$A,A74,$N:$N,1,$O:$O,\"<\"&O74),\"\")","v":null},{"$f":"IF(N74=1,MAX(0,MIN(H74,BS_FEFO_Pick!$B$4-P74)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H75<>\"\",J75<>\"\"),H75*J75,\"\")","v":null},{"$f":"IF(D75<>\"\",D75-TODAY(),\"\")","v":null},{"$f":"IF(AND(L75<>\"\",L75<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A75=BS_FEFO_Pick!$B$3,G75=\"Libre\",H75>0),1,0)","v":null},{"$f":"IF(N75=1,COUNTIFS($A:$A,A75,$N:$N,1,$D:$D,\"<=\"&D75),\"\")","v":null},{"$f":"IF(N75=1,SUMIFS($H:$H,$A:$A,A75,$N:$N,1,$O:$O,\"<\"&O75),\"\")","v":null},{"$f":"IF(N75=1,MAX(0,MIN(H75,BS_FEFO_Pick!$B$4-P75)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H76<>\"\",J76<>\"\"),H76*J76,\"\")","v":null},{"$f":"IF(D76<>\"\",D76-TODAY(),\"\")","v":null},{"$f":"IF(AND(L76<>\"\",L76<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A76=BS_FEFO_Pick!$B$3,G76=\"Libre\",H76>0),1,0)","v":null},{"$f":"IF(N76=1,COUNTIFS($A:$A,A76,$N:$N,1,$D:$D,\"<=\"&D76),\"\")","v":null},{"$f":"IF(N76=1,SUMIFS($H:$H,$A:$A,A76,$N:$N,1,$O:$O,\"<\"&O76),\"\")","v":null},{"$f":"IF(N76=1,MAX(0,MIN(H76,BS_FEFO_Pick!$B$4-P76)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H77<>\"\",J77<>\"\"),H77*J77,\"\")","v":null},{"$f":"IF(D77<>\"\",D77-TODAY(),\"\")","v":null},{"$f":"IF(AND(L77<>\"\",L77<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A77=BS_FEFO_Pick!$B$3,G77=\"Libre\",H77>0),1,0)","v":null},{"$f":"IF(N77=1,COUNTIFS($A:$A,A77,$N:$N,1,$D:$D,\"<=\"&D77),\"\")","v":null},{"$f":"IF(N77=1,SUMIFS($H:$H,$A:$A,A77,$N:$N,1,$O:$O,\"<\"&O77),\"\")","v":null},{"$f":"IF(N77=1,MAX(0,MIN(H77,BS_FEFO_Pick!$B$4-P77)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H78<>\"\",J78<>\"\"),H78*J78,\"\")","v":null},{"$f":"IF(D78<>\"\",D78-TODAY(),\"\")","v":null},{"$f":"IF(AND(L78<>\"\",L78<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A78=BS_FEFO_Pick!$B$3,G78=\"Libre\",H78>0),1,0)","v":null},{"$f":"IF(N78=1,COUNTIFS($A:$A,A78,$N:$N,1,$D:$D,\"<=\"&D78),\"\")","v":null},{"$f":"IF(N78=1,SUMIFS($H:$H,$A:$A,A78,$N:$N,1,$O:$O,\"<\"&O78),\"\")","v":null},{"$f":"IF(N78=1,MAX(0,MIN(H78,BS_FEFO_Pick!$B$4-P78)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H79<>\"\",J79<>\"\"),H79*J79,\"\")","v":null},{"$f":"IF(D79<>\"\",D79-TODAY(),\"\")","v":null},{"$f":"IF(AND(L79<>\"\",L79<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A79=BS_FEFO_Pick!$B$3,G79=\"Libre\",H79>0),1,0)","v":null},{"$f":"IF(N79=1,COUNTIFS($A:$A,A79,$N:$N,1,$D:$D,\"<=\"&D79),\"\")","v":null},{"$f":"IF(N79=1,SUMIFS($H:$H,$A:$A,A79,$N:$N,1,$O:$O,\"<\"&O79),\"\")","v":null},{"$f":"IF(N79=1,MAX(0,MIN(H79,BS_FEFO_Pick!$B$4-P79)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H80<>\"\",J80<>\"\"),H80*J80,\"\")","v":null},{"$f":"IF(D80<>\"\",D80-TODAY(),\"\")","v":null},{"$f":"IF(AND(L80<>\"\",L80<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A80=BS_FEFO_Pick!$B$3,G80=\"Libre\",H80>0),1,0)","v":null},{"$f":"IF(N80=1,COUNTIFS($A:$A,A80,$N:$N,1,$D:$D,\"<=\"&D80),\"\")","v":null},{"$f":"IF(N80=1,SUMIFS($H:$H,$A:$A,A80,$N:$N,1,$O:$O,\"<\"&O80),\"\")","v":null},{"$f":"IF(N80=1,MAX(0,MIN(H80,BS_FEFO_Pick!$B$4-P80)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H81<>\"\",J81<>\"\"),H81*J81,\"\")","v":null},{"$f":"IF(D81<>\"\",D81-TODAY(),\"\")","v":null},{"$f":"IF(AND(L81<>\"\",L81<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A81=BS_FEFO_Pick!$B$3,G81=\"Libre\",H81>0),1,0)","v":null},{"$f":"IF(N81=1,COUNTIFS($A:$A,A81,$N:$N,1,$D:$D,\"<=\"&D81),\"\")","v":null},{"$f":"IF(N81=1,SUMIFS($H:$H,$A:$A,A81,$N:$N,1,$O:$O,\"<\"&O81),\"\")","v":null},{"$f":"IF(N81=1,MAX(0,MIN(H81,BS_FEFO_Pick!$B$4-P81)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H82<>\"\",J82<>\"\"),H82*J82,\"\")","v":null},{"$f":"IF(D82<>\"\",D82-TODAY(),\"\")","v":null},{"$f":"IF(AND(L82<>\"\",L82<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A82=BS_FEFO_Pick!$B$3,G82=\"Libre\",H82>0),1,0)","v":null},{"$f":"IF(N82=1,COUNTIFS($A:$A,A82,$N:$N,1,$D:$D,\"<=\"&D82),\"\")","v":null},{"$f":"IF(N82=1,SUMIFS($H:$H,$A:$A,A82,$N:$N,1,$O:$O,\"<\"&O82),\"\")","v":null},{"$f":"IF(N82=1,MAX(0,MIN(H82,BS_FEFO_Pick!$B$4-P82)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H83<>\"\",J83<>\"\"),H83*J83,\"\")","v":null},{"$f":"IF(D83<>\"\",D83-TODAY(),\"\")","v":null},{"$f":"IF(AND(L83<>\"\",L83<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A83=BS_FEFO_Pick!$B$3,G83=\"Libre\",H83>0),1,0)","v":null},{"$f":"IF(N83=1,COUNTIFS($A:$A,A83,$N:$N,1,$D:$D,\"<=\"&D83),\"\")","v":null},{"$f":"IF(N83=1,SUMIFS($H:$H,$A:$A,A83,$N:$N,1,$O:$O,\"<\"&O83),\"\")","v":null},{"$f":"IF(N83=1,MAX(0,MIN(H83,BS_FEFO_Pick!$B$4-P83)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H84<>\"\",J84<>\"\"),H84*J84,\"\")","v":null},{"$f":"IF(D84<>\"\",D84-TODAY(),\"\")","v":null},{"$f":"IF(AND(L84<>\"\",L84<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A84=BS_FEFO_Pick!$B$3,G84=\"Libre\",H84>0),1,0)","v":null},{"$f":"IF(N84=1,COUNTIFS($A:$A,A84,$N:$N,1,$D:$D,\"<=\"&D84),\"\")","v":null},{"$f":"IF(N84=1,SUMIFS($H:$H,$A:$A,A84,$N:$N,1,$O:$O,\"<\"&O84),\"\")","v":null},{"$f":"IF(N84=1,MAX(0,MIN(H84,BS_FEFO_Pick!$B$4-P84)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H85<>\"\",J85<>\"\"),H85*J85,\"\")","v":null},{"$f":"IF(D85<>\"\",D85-TODAY(),\"\")","v":null},{"$f":"IF(AND(L85<>\"\",L85<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A85=BS_FEFO_Pick!$B$3,G85=\"Libre\",H85>0),1,0)","v":null},{"$f":"IF(N85=1,COUNTIFS($A:$A,A85,$N:$N,1,$D:$D,\"<=\"&D85),\"\")","v":null},{"$f":"IF(N85=1,SUMIFS($H:$H,$A:$A,A85,$N:$N,1,$O:$O,\"<\"&O85),\"\")","v":null},{"$f":"IF(N85=1,MAX(0,MIN(H85,BS_FEFO_Pick!$B$4-P85)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H86<>\"\",J86<>\"\"),H86*J86,\"\")","v":null},{"$f":"IF(D86<>\"\",D86-TODAY(),\"\")","v":null},{"$f":"IF(AND(L86<>\"\",L86<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A86=BS_FEFO_Pick!$B$3,G86=\"Libre\",H86>0),1,0)","v":null},{"$f":"IF(N86=1,COUNTIFS($A:$A,A86,$N:$N,1,$D:$D,\"<=\"&D86),\"\")","v":null},{"$f":"IF(N86=1,SUMIFS($H:$H,$A:$A,A86,$N:$N,1,$O:$O,\"<\"&O86),\"\")","v":null},{"$f":"IF(N86=1,MAX(0,MIN(H86,BS_FEFO_Pick!$B$4-P86)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H87<>\"\",J87<>\"\"),H87*J87,\"\")","v":null},{"$f":"IF(D87<>\"\",D87-TODAY(),\"\")","v":null},{"$f":"IF(AND(L87<>\"\",L87<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A87=BS_FEFO_Pick!$B$3,G87=\"Libre\",H87>0),1,0)","v":null},{"$f":"IF(N87=1,COUNTIFS($A:$A,A87,$N:$N,1,$D:$D,\"<=\"&D87),\"\")","v":null},{"$f":"IF(N87=1,SUMIFS($H:$H,$A:$A,A87,$N:$N,1,$O:$O,\"<\"&O87),\"\")","v":null},{"$f":"IF(N87=1,MAX(0,MIN(H87,BS_FEFO_Pick!$B$4-P87)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H88<>\"\",J88<>\"\"),H88*J88,\"\")","v":null},{"$f":"IF(D88<>\"\",D88-TODAY(),\"\")","v":null},{"$f":"IF(AND(L88<>\"\",L88<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A88=BS_FEFO_Pick!$B$3,G88=\"Libre\",H88>0),1,0)","v":null},{"$f":"IF(N88=1,COUNTIFS($A:$A,A88,$N:$N,1,$D:$D,\"<=\"&D88),\"\")","v":null},{"$f":"IF(N88=1,SUMIFS($H:$H,$A:$A,A88,$N:$N,1,$O:$O,\"<\"&O88),\"\")","v":null},{"$f":"IF(N88=1,MAX(0,MIN(H88,BS_FEFO_Pick!$B$4-P88)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H89<>\"\",J89<>\"\"),H89*J89,\"\")","v":null},{"$f":"IF(D89<>\"\",D89-TODAY(),\"\")","v":null},{"$f":"IF(AND(L89<>\"\",L89<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A89=BS_FEFO_Pick!$B$3,G89=\"Libre\",H89>0),1,0)","v":null},{"$f":"IF(N89=1,COUNTIFS($A:$A,A89,$N:$N,1,$D:$D,\"<=\"&D89),\"\")","v":null},{"$f":"IF(N89=1,SUMIFS($H:$H,$A:$A,A89,$N:$N,1,$O:$O,\"<\"&O89),\"\")","v":null},{"$f":"IF(N89=1,MAX(0,MIN(H89,BS_FEFO_Pick!$B$4-P89)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H90<>\"\",J90<>\"\"),H90*J90,\"\")","v":null},{"$f":"IF(D90<>\"\",D90-TODAY(),\"\")","v":null},{"$f":"IF(AND(L90<>\"\",L90<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A90=BS_FEFO_Pick!$B$3,G90=\"Libre\",H90>0),1,0)","v":null},{"$f":"IF(N90=1,COUNTIFS($A:$A,A90,$N:$N,1,$D:$D,\"<=\"&D90),\"\")","v":null},{"$f":"IF(N90=1,SUMIFS($H:$H,$A:$A,A90,$N:$N,1,$O:$O,\"<\"&O90),\"\")","v":null},{"$f":"IF(N90=1,MAX(0,MIN(H90,BS_FEFO_Pick!$B$4-P90)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H91<>\"\",J91<>\"\"),H91*J91,\"\")","v":null},{"$f":"IF(D91<>\"\",D91-TODAY(),\"\")","v":null},{"$f":"IF(AND(L91<>\"\",L91<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A91=BS_FEFO_Pick!$B$3,G91=\"Libre\",H91>0),1,0)","v":null},{"$f":"IF(N91=1,COUNTIFS($A:$A,A91,$N:$N,1,$D:$D,\"<=\"&D91),\"\")","v":null},{"$f":"IF(N91=1,SUMIFS($H:$H,$A:$A,A91,$N:$N,1,$O:$O,\"<\"&O91),\"\")","v":null},{"$f":"IF(N91=1,MAX(0,MIN(H91,BS_FEFO_Pick!$B$4-P91)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H92<>\"\",J92<>\"\"),H92*J92,\"\")","v":null},{"$f":"IF(D92<>\"\",D92-TODAY(),\"\")","v":null},{"$f":"IF(AND(L92<>\"\",L92<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A92=BS_FEFO_Pick!$B$3,G92=\"Libre\",H92>0),1,0)","v":null},{"$f":"IF(N92=1,COUNTIFS($A:$A,A92,$N:$N,1,$D:$D,\"<=\"&D92),\"\")","v":null},{"$f":"IF(N92=1,SUMIFS($H:$H,$A:$A,A92,$N:$N,1,$O:$O,\"<\"&O92),\"\")","v":null},{"$f":"IF(N92=1,MAX(0,MIN(H92,BS_FEFO_Pick!$B$4-P92)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H93<>\"\",J93<>\"\"),H93*J93,\"\")","v":null},{"$f":"IF(D93<>\"\",D93-TODAY(),\"\")","v":null},{"$f":"IF(AND(L93<>\"\",L93<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A93=BS_FEFO_Pick!$B$3,G93=\"Libre\",H93>0),1,0)","v":null},{"$f":"IF(N93=1,COUNTIFS($A:$A,A93,$N:$N,1,$D:$D,\"<=\"&D93),\"\")","v":null},{"$f":"IF(N93=1,SUMIFS($H:$H,$A:$A,A93,$N:$N,1,$O:$O,\"<\"&O93),\"\")","v":null},{"$f":"IF(N93=1,MAX(0,MIN(H93,BS_FEFO_Pick!$B$4-P93)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H94<>\"\",J94<>\"\"),H94*J94,\"\")","v":null},{"$f":"IF(D94<>\"\",D94-TODAY(),\"\")","v":null},{"$f":"IF(AND(L94<>\"\",L94<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A94=BS_FEFO_Pick!$B$3,G94=\"Libre\",H94>0),1,0)","v":null},{"$f":"IF(N94=1,COUNTIFS($A:$A,A94,$N:$N,1,$D:$D,\"<=\"&D94),\"\")","v":null},{"$f":"IF(N94=1,SUMIFS($H:$H,$A:$A,A94,$N:$N,1,$O:$O,\"<\"&O94),\"\")","v":null},{"$f":"IF(N94=1,MAX(0,MIN(H94,BS_FEFO_Pick!$B$4-P94)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H95<>\"\",J95<>\"\"),H95*J95,\"\")","v":null},{"$f":"IF(D95<>\"\",D95-TODAY(),\"\")","v":null},{"$f":"IF(AND(L95<>\"\",L95<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A95=BS_FEFO_Pick!$B$3,G95=\"Libre\",H95>0),1,0)","v":null},{"$f":"IF(N95=1,COUNTIFS($A:$A,A95,$N:$N,1,$D:$D,\"<=\"&D95),\"\")","v":null},{"$f":"IF(N95=1,SUMIFS($H:$H,$A:$A,A95,$N:$N,1,$O:$O,\"<\"&O95),\"\")","v":null},{"$f":"IF(N95=1,MAX(0,MIN(H95,BS_FEFO_Pick!$B$4-P95)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H96<>\"\",J96<>\"\"),H96*J96,\"\")","v":null},{"$f":"IF(D96<>\"\",D96-TODAY(),\"\")","v":null},{"$f":"IF(AND(L96<>\"\",L96<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A96=BS_FEFO_Pick!$B$3,G96=\"Libre\",H96>0),1,0)","v":null},{"$f":"IF(N96=1,COUNTIFS($A:$A,A96,$N:$N,1,$D:$D,\"<=\"&D96),\"\")","v":null},{"$f":"IF(N96=1,SUMIFS($H:$H,$A:$A,A96,$N:$N,1,$O:$O,\"<\"&O96),\"\")","v":null},{"$f":"IF(N96=1,MAX(0,MIN(H96,BS_FEFO_Pick!$B$4-P96)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H97<>\"\",J97<>\"\"),H97*J97,\"\")","v":null},{"$f":"IF(D97<>\"\",D97-TODAY(),\"\")","v":null},{"$f":"IF(AND(L97<>\"\",L97<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A97=BS_FEFO_Pick!$B$3,G97=\"Libre\",H97>0),1,0)","v":null},{"$f":"IF(N97=1,COUNTIFS($A:$A,A97,$N:$N,1,$D:$D,\"<=\"&D97),\"\")","v":null},{"$f":"IF(N97=1,SUMIFS($H:$H,$A:$A,A97,$N:$N,1,$O:$O,\"<\"&O97),\"\")","v":null},{"$f":"IF(N97=1,MAX(0,MIN(H97,BS_FEFO_Pick!$B$4-P97)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H98<>\"\",J98<>\"\"),H98*J98,\"\")","v":null},{"$f":"IF(D98<>\"\",D98-TODAY(),\"\")","v":null},{"$f":"IF(AND(L98<>\"\",L98<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A98=BS_FEFO_Pick!$B$3,G98=\"Libre\",H98>0),1,0)","v":null},{"$f":"IF(N98=1,COUNTIFS($A:$A,A98,$N:$N,1,$D:$D,\"<=\"&D98),\"\")","v":null},{"$f":"IF(N98=1,SUMIFS($H:$H,$A:$A,A98,$N:$N,1,$O:$O,\"<\"&O98),\"\")","v":null},{"$f":"IF(N98=1,MAX(0,MIN(H98,BS_FEFO_Pick!$B$4-P98)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H99<>\"\",J99<>\"\"),H99*J99,\"\")","v":null},{"$f":"IF(D99<>\"\",D99-TODAY(),\"\")","v":null},{"$f":"IF(AND(L99<>\"\",L99<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A99=BS_FEFO_Pick!$B$3,G99=\"Libre\",H99>0),1,0)","v":null},{"$f":"IF(N99=1,COUNTIFS($A:$A,A99,$N:$N,1,$D:$D,\"<=\"&D99),\"\")","v":null},{"$f":"IF(N99=1,SUMIFS($H:$H,$A:$A,A99,$N:$N,1,$O:$O,\"<\"&O99),\"\")","v":null},{"$f":"IF(N99=1,MAX(0,MIN(H99,BS_FEFO_Pick!$B$4-P99)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H100<>\"\",J100<>\"\"),H100*J100,\"\")","v":null},{"$f":"IF(D100<>\"\",D100-TODAY(),\"\")","v":null},{"$f":"IF(AND(L100<>\"\",L100<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A100=BS_FEFO_Pick!$B$3,G100=\"Libre\",H100>0),1,0)","v":null},{"$f":"IF(N100=1,COUNTIFS($A:$A,A100,$N:$N,1,$D:$D,\"<=\"&D100),\"\")","v":null},{"$f":"IF(N100=1,SUMIFS($H:$H,$A:$A,A100,$N:$N,1,$O:$O,\"<\"&O100),\"\")","v":null},{"$f":"IF(N100=1,MAX(0,MIN(H100,BS_FEFO_Pick!$B$4-P100)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H101<>\"\",J101<>\"\"),H101*J101,\"\")","v":null},{"$f":"IF(D101<>\"\",D101-TODAY(),\"\")","v":null},{"$f":"IF(AND(L101<>\"\",L101<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A101=BS_FEFO_Pick!$B$3,G101=\"Libre\",H101>0),1,0)","v":null},{"$f":"IF(N101=1,COUNTIFS($A:$A,A101,$N:$N,1,$D:$D,\"<=\"&D101),\"\")","v":null},{"$f":"IF(N101=1,SUMIFS($H:$H,$A:$A,A101,$N:$N,1,$O:$O,\"<\"&O101),\"\")","v":null},{"$f":"IF(N101=1,MAX(0,MIN(H101,BS_FEFO_Pick!$B$4-P101)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H102<>\"\",J102<>\"\"),H102*J102,\"\")","v":null},{"$f":"IF(D102<>\"\",D102-TODAY(),\"\")","v":null},{"$f":"IF(AND(L102<>\"\",L102<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A102=BS_FEFO_Pick!$B$3,G102=\"Libre\",H102>0),1,0)","v":null},{"$f":"IF(N102=1,COUNTIFS($A:$A,A102,$N:$N,1,$D:$D,\"<=\"&D102),\"\")","v":null},{"$f":"IF(N102=1,SUMIFS($H:$H,$A:$A,A102,$N:$N,1,$O:$O,\"<\"&O102),\"\")","v":null},{"$f":"IF(N102=1,MAX(0,MIN(H102,BS_FEFO_Pick!$B$4-P102)),\"\")","v":null}]
[{"$nulls":10},{"$f":"IF(AND(H103<>\"\",J103<>\"\"),H103*J103,\"\")","v":null},{"$f":"IF(D103<>\"\",D103-TODAY(),\"\")","v":null},{"$f":"IF(AND(L103<>\"\",L103<=Paramètres!B3),\"OUI\",\"NON\")","v":null},{"$f":"IF(AND(A103=BS_FEFO_Pick!$B$3,G103=\"Libre\",H103>0),1,0)","v":null},{"$f":"IF(N103=1,COUNTIFS($A:$A,A103,$N:$N,1,$D:$D,\"<=\"&D103),\"\")","v":null},{"$f":"IF(N103=1,SUMIFS($H:$H,$A:$A,A103,$N:$N,1,$O:$O,\"<\"&O103),\"\")","v":null},{"$f":"IF(N103=1,MAX(0,MIN(H103,BS_FEFO_Pick!$B$4-P103)),\"\")","v":null}]

{"sheet":"BS_FEFO_Pick","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"merged":[[0,0,0,11],[28,0,28,2],[28,3,28,5],[28,6,28,8],[28,9,28,11]]}
["BON DE SORTIE — Ordre de prélèvement FEFO"]
[]
["Code article","Qté demandée","Date & heure","Magasin","Emplacement","Rédacteur","Motif","Statut qualité","QR (texte)","—","—","—"]
[{"$nulls":8},"LCG|TYPE=BS|ART={B3}|Q={B4}|V=FEFO"]
[]
["Rang","Lot/Série","DLC/DPF","Jours restants","Empl.","Qté lot","À prélever","Unité","PMP","Valeur","Observation"]
[1,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(1,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I7*$G7,\"\")","v":null}]
[2,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(2,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I8*$G8,\"\")","v":null}]
[3,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(3,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I9*$G9,\"\")","v":null}]
[4,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(4,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I10*$G10,\"\")","v":null}]
[5,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(5,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I11*$G11,\"\")","v":null}]
[6,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(6,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I12*$G12,\"\")","v":null}]
[7,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(7,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I13*$G13,\"\")","v":null}]
[8,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(8,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I14*$G14,\"\")","v":null}]
[9,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(9,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I15*$G15,\"\")","v":null}]
[10,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(10,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I16*$G16,\"\")","v":null}]
[11,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(11,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I17*$G17,\"\")","v":null}]
[12,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(12,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I18*$G18,\"\")","v":null}]
[13,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(13,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I19*$G19,\"\")","v":null}]
[14,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(14,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I20*$G20,\"\")","v":null}]
[15,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(15,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I21*$G21,\"\")","v":null}]
[16,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(16,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I22*$G22,\"\")","v":null}]
[17,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(17,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I23*$G23,\"\")","v":null}]
[18,{"$f":"IFERROR(INDEX(Lots!$C:$C,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$D:$D,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$L:$L,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$F:$F,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$H:$H,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$Q:$Q,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$I:$I,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR(INDEX(Lots!$J:$J,=IFERROR(MATCH(18,Lots!$O:$O,0),\"\")),\"\")","v":null},{"$f":"IFERROR($I24*$G24,\"\")","v":null}]
[]
[{"$nulls":8},"Total valeur :",{"$f":"SUM(J7:J24)","v":null}]
[]
[]
["Émetteur",null,null,"Qualité",null,null,"Magasin",null,null,"Client/Transport"]