{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["PQP_Grandes_Lignes","Timeline_Pro","KPI_Dashboard"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"PQP_Grandes_Lignes","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
["Plan Qualité Projet — Grandes Lignes (Pro)"]
[]
["Champ","Valeur"]
["Titre Projet","PROJET X – Plan Qualité Projet (PQP)"]
["Client","Client ABC"]
["Référence","PQP-2025-001"]
["Version","v1.1 (Pro)"]
["Chef de Projet"]
["Objectifs","PPM<500, FPY≥98%, 100% traçabilité, CE obtenu"]

{"sheet":"Timeline_Pro","index":1,"n_rows":302,"n_cols":16,"rows_kept":302}
["Timeline avancée (plan vs réel, statut auto, Gantt)"]
[]
["ID Tâche","Tâche","Pilote","Début prévu","Fin prévue","Début réel","Fin réelle","% Avancement","Dépendances","Début_num_prev","Durée_prev","Début_num_reel","Durée_reel","Jours_restants","Statut_auto","Critique?"]
["T-001","Rédaction PQP","Resp Qualité","2025-08-01","2025-08-05","2025-08-01","2025-08-05",100,null,{"$f":"IF($D4=\"\",\"\",$D4)","v":0},{"$f":"IF(OR($D4=\"\",$E4=\"\"),\"\", $E4-$D4+1)","v":0},{"$f":"IF($F4=\"\",\"\",$F4)","v":0},{"$f":"IF(OR($F4=\"\",$G4=\"\"),\"\", $G4-$F4+1)","v":0},{"$f":"IF($E4=\"\", \"\", MAX(0, $E4-TODAY()+1))","v":0},{"$f":"IF($G4<>\"\", IF($G4<=$E4, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E4, \"En retard\", IF(TODAY()+7>=$E4, \"À risque (J-7)\", IF($H4=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H4<100, $E4<>\"\" , $E4<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
["T-002","Procédures Traçabilité","Resp Méthodes","2025-08-06","2025-08-18","2025-08-07",null,40,"T-001",{"$f":"IF($D5=\"\",\"\",$D5)","v":0},{"$f":"IF(OR($D5=\"\",$E5=\"\"),\"\", $E5-$D5+1)","v":0},{"$f":"IF($F5=\"\",\"\",$F5)","v":0},{"$f":"IF(OR($F5=\"\",$G5=\"\"),\"\", $G5-$F5+1)","v":0},{"$f":"IF($E5=\"\", \"\", MAX(0, $E5-TODAY()+1))","v":0},{"$f":"IF($G5<>\"\", IF($G5<=$E5, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E5, \"En retard\", IF(TODAY()+7>=$E5, \"À risque (J-7)\", IF($H5=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H5<100, $E5<>\"\" , $E5<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
["T-003","Plan de Contrôle Ligne A","Resp Méthodes","2025-08-08","2025-08-12",null,null,0,"T-001",{"$f":"IF($D6=\"\",\"\",$D6)","v":0},{"$f":"IF(OR($D6=\"\",$E6=\"\"),\"\", $E6-$D6+1)","v":0},{"$f":"IF($F6=\"\",\"\",$F6)","v":0},{"$f":"IF(OR($F6=\"\",$G6=\"\"),\"\", $G6-$F6+1)","v":0},{"$f":"IF($E6=\"\", \"\", MAX(0, $E6-TODAY()+1))","v":0},{"$f":"IF($G6<>\"\", IF($G6<=$E6, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E6, \"En retard\", IF(TODAY()+7>=$E6, \"À risque (J-7)\", IF($H6=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H6<100, $E6<>\"\" , $E6<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
["T-004","Essais FPY","Resp Prod","2025-08-20","2025-09-05",null,null,15,"T-002;T-003",{"$f":"IF($D7=\"\",\"\",$D7)","v":0},{"$f":"IF(OR($D7=\"\",$E7=\"\"),\"\", $E7-$D7+1)","v":0},{"$f":"IF($F7=\"\",\"\",$F7)","v":0},{"$f":"IF(OR($F7=\"\",$G7=\"\"),\"\", $G7-$F7+1)","v":0},{"$f":"IF($E7=\"\", \"\", MAX(0, $E7-TODAY()+1))","v":0},{"$f":"IF($G7<>\"\", IF($G7<=$E7, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E7, \"En retard\", IF(TODAY()+7>=$E7, \"À risque (J-7)\", IF($H7=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H7<100, $E7<>\"\" , $E7<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
["T-005","Certification CE","HSE","2025-09-06","2025-09-20",null,null,0,"T-004",{"$f":"IF($D8=\"\",\"\",$D8)","v":0},{"$f":"IF(OR($D8=\"\",$E8=\"\"),\"\", $E8-$D8+1)","v":0},{"$f":"IF($F8=\"\",\"\",$F8)","v":0},{"$f":"IF(OR($F8=\"\",$G8=\"\"),\"\", $G8-$F8+1)","v":0},{"$f":"IF($E8=\"\", \"\", MAX(0, $E8-TODAY()+1))","v":0},{"$f":"IF($G8<>\"\", IF($G8<=$E8, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E8, \"En retard\", IF(TODAY()+7>=$E8, \"À risque (J-7)\", IF($H8=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H8<100, $E8<>\"\" , $E8<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D9=\"\",\"\",$D9)","v":0},{"$f":"IF(OR($D9=\"\",$E9=\"\"),\"\", $E9-$D9+1)","v":0},{"$f":"IF($F9=\"\",\"\",$F9)","v":0},{"$f":"IF(OR($F9=\"\",$G9=\"\"),\"\", $G9-$F9+1)","v":0},{"$f":"IF($E9=\"\", \"\", MAX(0, $E9-TODAY()+1))","v":0},{"$f":"IF($G9<>\"\", IF($G9<=$E9, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E9, \"En retard\", IF(TODAY()+7>=$E9, \"À risque (J-7)\", IF($H9=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H9<100, $E9<>\"\" , $E9<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D10=\"\",\"\",$D10)","v":0},{"$f":"IF(OR($D10=\"\",$E10=\"\"),\"\", $E10-$D10+1)","v":0},{"$f":"IF($F10=\"\",\"\",$F10)","v":0},{"$f":"IF(OR($F10=\"\",$G10=\"\"),\"\", $G10-$F10+1)","v":0},{"$f":"IF($E10=\"\", \"\", MAX(0, $E10-TODAY()+1))","v":0},{"$f":"IF($G10<>\"\", IF($G10<=$E10, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E10, \"En retard\", IF(TODAY()+7>=$E10, \"À risque (J-7)\", IF($H10=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H10<100, $E10<>\"\" , $E10<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D11=\"\",\"\",$D11)","v":0},{"$f":"IF(OR($D11=\"\",$E11=\"\"),\"\", $E11-$D11+1)","v":0},{"$f":"IF($F11=\"\",\"\",$F11)","v":0},{"$f":"IF(OR($F11=\"\",$G11=\"\"),\"\", $G11-$F11+1)","v":0},{"$f":"IF($E11=\"\", \"\", MAX(0, $E11-TODAY()+1))","v":0},{"$f":"IF($G11<>\"\", IF($G11<=$E11, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E11, \"En retard\", IF(TODAY()+7>=$E11, \"À risque (J-7)\", IF($H11=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H11<100, $E11<>\"\" , $E11<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D12=\"\",\"\",$D12)","v":0},{"$f":"IF(OR($D12=\"\",$E12=\"\"),\"\", $E12-$D12+1)","v":0},{"$f":"IF($F12=\"\",\"\",$F12)","v":0},{"$f":"IF(OR($F12=\"\",$G12=\"\"),\"\", $G12-$F12+1)","v":0},{"$f":"IF($E12=\"\", \"\", MAX(0, $E12-TODAY()+1))","v":0},{"$f":"IF($G12<>\"\", IF($G12<=$E12, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E12, \"En retard\", IF(TODAY()+7>=$E12, \"À risque (J-7)\", IF($H12=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H12<100, $E12<>\"\" , $E12<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D13=\"\",\"\",$D13)","v":0},{"$f":"IF(OR($D13=\"\",$E13=\"\"),\"\", $E13-$D13+1)","v":0},{"$f":"IF($F13=\"\",\"\",$F13)","v":0},{"$f":"IF(OR($F13=\"\",$G13=\"\"),\"\", $G13-$F13+1)","v":0},{"$f":"IF($E13=\"\", \"\", MAX(0, $E13-TODAY()+1))","v":0},{"$f":"IF($G13<>\"\", IF($G13<=$E13, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E13, \"En retard\", IF(TODAY()+7>=$E13, \"À risque (J-7)\", IF($H13=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H13<100, $E13<>\"\" , $E13<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D14=\"\",\"\",$D14)","v":0},{"$f":"IF(OR($D14=\"\",$E14=\"\"),\"\", $E14-$D14+1)","v":0},{"$f":"IF($F14=\"\",\"\",$F14)","v":0},{"$f":"IF(OR($F14=\"\",$G14=\"\"),\"\", $G14-$F14+1)","v":0},{"$f":"IF($E14=\"\", \"\", MAX(0, $E14-TODAY()+1))","v":0},{"$f":"IF($G14<>\"\", IF($G14<=$E14, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E14, \"En retard\", IF(TODAY()+7>=$E14, \"À risque (J-7)\", IF($H14=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H14<100, $E14<>\"\" , $E14<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D15=\"\",\"\",$D15)","v":0},{"$f":"IF(OR($D15=\"\",$E15=\"\"),\"\", $E15-$D15+1)","v":0},{"$f":"IF($F15=\"\",\"\",$F15)","v":0},{"$f":"IF(OR($F15=\"\",$G15=\"\"),\"\", $G15-$F15+1)","v":0},{"$f":"IF($E15=\"\", \"\", MAX(0, $E15-TODAY()+1))","v":0},{"$f":"IF($G15<>\"\", IF($G15<=$E15, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E15, \"En retard\", IF(TODAY()+7>=$E15, \"À risque (J-7)\", IF($H15=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H15<100, $E15<>\"\" , $E15<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D16=\"\",\"\",$D16)","v":0},{"$f":"IF(OR($D16=\"\",$E16=\"\"),\"\", $E16-$D16+1)","v":0},{"$f":"IF($F16=\"\",\"\",$F16)","v":0},{"$f":"IF(OR($F16=\"\",$G16=\"\"),\"\", $G16-$F16+1)","v":0},{"$f":"IF($E16=\"\", \"\", MAX(0, $E16-TODAY()+1))","v":0},{"$f":"IF($G16<>\"\", IF($G16<=$E16, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E16, \"En retard\", IF(TODAY()+7>=$E16, \"À risque (J-7)\", IF($H16=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H16<100, $E16<>\"\" , $E16<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D17=\"\",\"\",$D17)","v":0},{"$f":"IF(OR($D17=\"\",$E17=\"\"),\"\", $E17-$D17+1)","v":0},{"$f":"IF($F17=\"\",\"\",$F17)","v":0},{"$f":"IF(OR($F17=\"\",$G17=\"\"),\"\", $G17-$F17+1)","v":0},{"$f":"IF($E17=\"\", \"\", MAX(0, $E17-TODAY()+1))","v":0},{"$f":"IF($G17<>\"\", IF($G17<=$E17, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E17, \"En retard\", IF(TODAY()+7>=$E17, \"À risque (J-7)\", IF($H17=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H17<100, $E17<>\"\" , $E17<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D18=\"\",\"\",$D18)","v":0},{"$f":"IF(OR($D18=\"\",$E18=\"\"),\"\", $E18-$D18+1)","v":0},{"$f":"IF($F18=\"\",\"\",$F18)","v":0},{"$f":"IF(OR($F18=\"\",$G18=\"\"),\"\", $G18-$F18+1)","v":0},{"$f":"IF($E18=\"\", \"\", MAX(0, $E18-TODAY()+1))","v":0},{"$f":"IF($G18<>\"\", IF($G18<=$E18, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E18, \"En retard\", IF(TODAY()+7>=$E18, \"À risque (J-7)\", IF($H18=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H18<100, $E18<>\"\" , $E18<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D19=\"\",\"\",$D19)","v":0},{"$f":"IF(OR($D19=\"\",$E19=\"\"),\"\", $E19-$D19+1)","v":0},{"$f":"IF($F19=\"\",\"\",$F19)","v":0},{"$f":"IF(OR($F19=\"\",$G19=\"\"),\"\", $G19-$F19+1)","v":0},{"$f":"IF($E19=\"\", \"\", MAX(0, $E19-TODAY()+1))","v":0},{"$f":"IF($G19<>\"\", IF($G19<=$E19, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E19, \"En retard\", IF(TODAY()+7>=$E19, \"À risque (J-7)\", IF($H19=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H19<100, $E19<>\"\" , $E19<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D20=\"\",\"\",$D20)","v":0},{"$f":"IF(OR($D20=\"\",$E20=\"\"),\"\", $E20-$D20+1)","v":0},{"$f":"IF($F20=\"\",\"\",$F20)","v":0},{"$f":"IF(OR($F20=\"\",$G20=\"\"),\"\", $G20-$F20+1)","v":0},{"$f":"IF($E20=\"\", \"\", MAX(0, $E20-TODAY()+1))","v":0},{"$f":"IF($G20<>\"\", IF($G20<=$E20, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E20, \"En retard\", IF(TODAY()+7>=$E20, \"À risque (J-7)\", IF($H20=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H20<100, $E20<>\"\" , $E20<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D21=\"\",\"\",$D21)","v":0},{"$f":"IF(OR($D21=\"\",$E21=\"\"),\"\", $E21-$D21+1)","v":0},{"$f":"IF($F21=\"\",\"\",$F21)","v":0},{"$f":"IF(OR($F21=\"\",$G21=\"\"),\"\", $G21-$F21+1)","v":0},{"$f":"IF($E21=\"\", \"\", MAX(0, $E21-TODAY()+1))","v":0},{"$f":"IF($G21<>\"\", IF($G21<=$E21, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E21, \"En retard\", IF(TODAY()+7>=$E21, \"À risque (J-7)\", IF($H21=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H21<100, $E21<>\"\" , $E21<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D22=\"\",\"\",$D22)","v":0},{"$f":"IF(OR($D22=\"\",$E22=\"\"),\"\", $E22-$D22+1)","v":0},{"$f":"IF($F22=\"\",\"\",$F22)","v":0},{"$f":"IF(OR($F22=\"\",$G22=\"\"),\"\", $G22-$F22+1)","v":0},{"$f":"IF($E22=\"\", \"\", MAX(0, $E22-TODAY()+1))","v":0},{"$f":"IF($G22<>\"\", IF($G22<=$E22, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E22, \"En retard\", IF(TODAY()+7>=$E22, \"À risque (J-7)\", IF($H22=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H22<100, $E22<>\"\" , $E22<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D23=\"\",\"\",$D23)","v":0},{"$f":"IF(OR($D23=\"\",$E23=\"\"),\"\", $E23-$D23+1)","v":0},{"$f":"IF($F23=\"\",\"\",$F23)","v":0},{"$f":"IF(OR($F23=\"\",$G23=\"\"),\"\", $G23-$F23+1)","v":0},{"$f":"IF($E23=\"\", \"\", MAX(0, $E23-TODAY()+1))","v":0},{"$f":"IF($G23<>\"\", IF($G23<=$E23, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E23, \"En retard\", IF(TODAY()+7>=$E23, \"À risque (J-7)\", IF($H23=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H23<100, $E23<>\"\" , $E23<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D24=\"\",\"\",$D24)","v":0},{"$f":"IF(OR($D24=\"\",$E24=\"\"),\"\", $E24-$D24+1)","v":0},{"$f":"IF($F24=\"\",\"\",$F24)","v":0},{"$f":"IF(OR($F24=\"\",$G24=\"\"),\"\", $G24-$F24+1)","v":0},{"$f":"IF($E24=\"\", \"\", MAX(0, $E24-TODAY()+1))","v":0},{"$f":"IF($G24<>\"\", IF($G24<=$E24, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E24, \"En retard\", IF(TODAY()+7>=$E24, \"À risque (J-7)\", IF($H24=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H24<100, $E24<>\"\" , $E24<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D25=\"\",\"\",$D25)","v":0},{"$f":"IF(OR($D25=\"\",$E25=\"\"),\"\", $E25-$D25+1)","v":0},{"$f":"IF($F25=\"\",\"\",$F25)","v":0},{"$f":"IF(OR($F25=\"\",$G25=\"\"),\"\", $G25-$F25+1)","v":0},{"$f":"IF($E25=\"\", \"\", MAX(0, $E25-TODAY()+1))","v":0},{"$f":"IF($G25<>\"\", IF($G25<=$E25, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E25, \"En retard\", IF(TODAY()+7>=$E25, \"À risque (J-7)\", IF($H25=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H25<100, $E25<>\"\" , $E25<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D26=\"\",\"\",$D26)","v":0},{"$f":"IF(OR($D26=\"\",$E26=\"\"),\"\", $E26-$D26+1)","v":0},{"$f":"IF($F26=\"\",\"\",$F26)","v":0},{"$f":"IF(OR($F26=\"\",$G26=\"\"),\"\", $G26-$F26+1)","v":0},{"$f":"IF($E26=\"\", \"\", MAX(0, $E26-TODAY()+1))","v":0},{"$f":"IF($G26<>\"\", IF($G26<=$E26, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E26, \"En retard\", IF(TODAY()+7>=$E26, \"À risque (J-7)\", IF($H26=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H26<100, $E26<>\"\" , $E26<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D27=\"\",\"\",$D27)","v":0},{"$f":"IF(OR($D27=\"\",$E27=\"\"),\"\", $E27-$D27+1)","v":0},{"$f":"IF($F27=\"\",\"\",$F27)","v":0},{"$f":"IF(OR($F27=\"\",$G27=\"\"),\"\", $G27-$F27+1)","v":0},{"$f":"IF($E27=\"\", \"\", MAX(0, $E27-TODAY()+1))","v":0},{"$f":"IF($G27<>\"\", IF($G27<=$E27, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E27, \"En retard\", IF(TODAY()+7>=$E27, \"À risque (J-7)\", IF($H27=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H27<100, $E27<>\"\" , $E27<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D28=\"\",\"\",$D28)","v":0},{"$f":"IF(OR($D28=\"\",$E28=\"\"),\"\", $E28-$D28+1)","v":0},{"$f":"IF($F28=\"\",\"\",$F28)","v":0},{"$f":"IF(OR($F28=\"\",$G28=\"\"),\"\", $G28-$F28+1)","v":0},{"$f":"IF($E28=\"\", \"\", MAX(0, $E28-TODAY()+1))","v":0},{"$f":"IF($G28<>\"\", IF($G28<=$E28, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E28, \"En retard\", IF(TODAY()+7>=$E28, \"À risque (J-7)\", IF($H28=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H28<100, $E28<>\"\" , $E28<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D29=\"\",\"\",$D29)","v":0},{"$f":"IF(OR($D29=\"\",$E29=\"\"),\"\", $E29-$D29+1)","v":0},{"$f":"IF($F29=\"\",\"\",$F29)","v":0},{"$f":"IF(OR($F29=\"\",$G29=\"\"),\"\", $G29-$F29+1)","v":0},{"$f":"IF($E29=\"\", \"\", MAX(0, $E29-TODAY()+1))","v":0},{"$f":"IF($G29<>\"\", IF($G29<=$E29, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E29, \"En retard\", IF(TODAY()+7>=$E29, \"À risque (J-7)\", IF($H29=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H29<100, $E29<>\"\" , $E29<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D30=\"\",\"\",$D30)","v":0},{"$f":"IF(OR($D30=\"\",$E30=\"\"),\"\", $E30-$D30+1)","v":0},{"$f":"IF($F30=\"\",\"\",$F30)","v":0},{"$f":"IF(OR($F30=\"\",$G30=\"\"),\"\", $G30-$F30+1)","v":0},{"$f":"IF($E30=\"\", \"\", MAX(0, $E30-TODAY()+1))","v":0},{"$f":"IF($G30<>\"\", IF($G30<=$E30, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E30, \"En retard\", IF(TODAY()+7>=$E30, \"À risque (J-7)\", IF($H30=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H30<100, $E30<>\"\" , $E30<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D31=\"\",\"\",$D31)","v":0},{"$f":"IF(OR($D31=\"\",$E31=\"\"),\"\", $E31-$D31+1)","v":0},{"$f":"IF($F31=\"\",\"\",$F31)","v":0},{"$f":"IF(OR($F31=\"\",$G31=\"\"),\"\", $G31-$F31+1)","v":0},{"$f":"IF($E31=\"\", \"\", MAX(0, $E31-TODAY()+1))","v":0},{"$f":"IF($G31<>\"\", IF($G31<=$E31, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E31, \"En retard\", IF(TODAY()+7>=$E31, \"À risque (J-7)\", IF($H31=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H31<100, $E31<>\"\" , $E31<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D32=\"\",\"\",$D32)","v":0},{"$f":"IF(OR($D32=\"\",$E32=\"\"),\"\", $E32-$D32+1)","v":0},{"$f":"IF($F32=\"\",\"\",$F32)","v":0},{"$f":"IF(OR($F32=\"\",$G32=\"\"),\"\", $G32-$F32+1)","v":0},{"$f":"IF($E32=\"\", \"\", MAX(0, $E32-TODAY()+1))","v":0},{"$f":"IF($G32<>\"\", IF($G32<=$E32, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E32, \"En retard\", IF(TODAY()+7>=$E32, \"À risque (J-7)\", IF($H32=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H32<100, $E32<>\"\" , $E32<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D33=\"\",\"\",$D33)","v":0},{"$f":"IF(OR($D33=\"\",$E33=\"\"),\"\", $E33-$D33+1)","v":0},{"$f":"IF($F33=\"\",\"\",$F33)","v":0},{"$f":"IF(OR($F33=\"\",$G33=\"\"),\"\", $G33-$F33+1)","v":0},{"$f":"IF($E33=\"\", \"\", MAX(0, $E33-TODAY()+1))","v":0},{"$f":"IF($G33<>\"\", IF($G33<=$E33, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E33, \"En retard\", IF(TODAY()+7>=$E33, \"À risque (J-7)\", IF($H33=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H33<100, $E33<>\"\" , $E33<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D34=\"\",\"\",$D34)","v":0},{"$f":"IF(OR($D34=\"\",$E34=\"\"),\"\", $E34-$D34+1)","v":0},{"$f":"IF($F34=\"\",\"\",$F34)","v":0},{"$f":"IF(OR($F34=\"\",$G34=\"\"),\"\", $G34-$F34+1)","v":0},{"$f":"IF($E34=\"\", \"\", MAX(0, $E34-TODAY()+1))","v":0},{"$f":"IF($G34<>\"\", IF($G34<=$E34, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E34, \"En retard\", IF(TODAY()+7>=$E34, \"À risque (J-7)\", IF($H34=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H34<100, $E34<>\"\" , $E34<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D35=\"\",\"\",$D35)","v":0},{"$f":"IF(OR($D35=\"\",$E35=\"\"),\"\", $E35-$D35+1)","v":0},{"$f":"IF($F35=\"\",\"\",$F35)","v":0},{"$f":"IF(OR($F35=\"\",$G35=\"\"),\"\", $G35-$F35+1)","v":0},{"$f":"IF($E35=\"\", \"\", MAX(0, $E35-TODAY()+1))","v":0},{"$f":"IF($G35<>\"\", IF($G35<=$E35, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E35, \"En retard\", IF(TODAY()+7>=$E35, \"À risque (J-7)\", IF($H35=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H35<100, $E35<>\"\" , $E35<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D36=\"\",\"\",$D36)","v":0},{"$f":"IF(OR($D36=\"\",$E36=\"\"),\"\", $E36-$D36+1)","v":0},{"$f":"IF($F36=\"\",\"\",$F36)","v":0},{"$f":"IF(OR($F36=\"\",$G36=\"\"),\"\", $G36-$F36+1)","v":0},{"$f":"IF($E36=\"\", \"\", MAX(0, $E36-TODAY()+1))","v":0},{"$f":"IF($G36<>\"\", IF($G36<=$E36, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E36, \"En retard\", IF(TODAY()+7>=$E36, \"À risque (J-7)\", IF($H36=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H36<100, $E36<>\"\" , $E36<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D37=\"\",\"\",$D37)","v":0},{"$f":"IF(OR($D37=\"\",$E37=\"\"),\"\", $E37-$D37+1)","v":0},{"$f":"IF($F37=\"\",\"\",$F37)","v":0},{"$f":"IF(OR($F37=\"\",$G37=\"\"),\"\", $G37-$F37+1)","v":0},{"$f":"IF($E37=\"\", \"\", MAX(0, $E37-TODAY()+1))","v":0},{"$f":"IF($G37<>\"\", IF($G37<=$E37, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E37, \"En retard\", IF(TODAY()+7>=$E37, \"À risque (J-7)\", IF($H37=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H37<100, $E37<>\"\" , $E37<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D38=\"\",\"\",$D38)","v":0},{"$f":"IF(OR($D38=\"\",$E38=\"\"),\"\", $E38-$D38+1)","v":0},{"$f":"IF($F38=\"\",\"\",$F38)","v":0},{"$f":"IF(OR($F38=\"\",$G38=\"\"),\"\", $G38-$F38+1)","v":0},{"$f":"IF($E38=\"\", \"\", MAX(0, $E38-TODAY()+1))","v":0},{"$f":"IF($G38<>\"\", IF($G38<=$E38, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E38, \"En retard\", IF(TODAY()+7>=$E38, \"À risque (J-7)\", IF($H38=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H38<100, $E38<>\"\" , $E38<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D39=\"\",\"\",$D39)","v":0},{"$f":"IF(OR($D39=\"\",$E39=\"\"),\"\", $E39-$D39+1)","v":0},{"$f":"IF($F39=\"\",\"\",$F39)","v":0},{"$f":"IF(OR($F39=\"\",$G39=\"\"),\"\", $G39-$F39+1)","v":0},{"$f":"IF($E39=\"\", \"\", MAX(0, $E39-TODAY()+1))","v":0},{"$f":"IF($G39<>\"\", IF($G39<=$E39, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E39, \"En retard\", IF(TODAY()+7>=$E39, \"À risque (J-7)\", IF($H39=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H39<100, $E39<>\"\" , $E39<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D40=\"\",\"\",$D40)","v":0},{"$f":"IF(OR($D40=\"\",$E40=\"\"),\"\", $E40-$D40+1)","v":0},{"$f":"IF($F40=\"\",\"\",$F40)","v":0},{"$f":"IF(OR($F40=\"\",$G40=\"\"),\"\", $G40-$F40+1)","v":0},{"$f":"IF($E40=\"\", \"\", MAX(0, $E40-TODAY()+1))","v":0},{"$f":"IF($G40<>\"\", IF($G40<=$E40, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E40, \"En retard\", IF(TODAY()+7>=$E40, \"À risque (J-7)\", IF($H40=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H40<100, $E40<>\"\" , $E40<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D41=\"\",\"\",$D41)","v":0},{"$f":"IF(OR($D41=\"\",$E41=\"\"),\"\", $E41-$D41+1)","v":0},{"$f":"IF($F41=\"\",\"\",$F41)","v":0},{"$f":"IF(OR($F41=\"\",$G41=\"\"),\"\", $G41-$F41+1)","v":0},{"$f":"IF($E41=\"\", \"\", MAX(0, $E41-TODAY()+1))","v":0},{"$f":"IF($G41<>\"\", IF($G41<=$E41, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E41, \"En retard\", IF(TODAY()+7>=$E41, \"À risque (J-7)\", IF($H41=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H41<100, $E41<>\"\" , $E41<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D42=\"\",\"\",$D42)","v":0},{"$f":"IF(OR($D42=\"\",$E42=\"\"),\"\", $E42-$D42+1)","v":0},{"$f":"IF($F42=\"\",\"\",$F42)","v":0},{"$f":"IF(OR($F42=\"\",$G42=\"\"),\"\", $G42-$F42+1)","v":0},{"$f":"IF($E42=\"\", \"\", MAX(0, $E42-TODAY()+1))","v":0},{"$f":"IF($G42<>\"\", IF($G42<=$E42, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E42, \"En retard\", IF(TODAY()+7>=$E42, \"À risque (J-7)\", IF($H42=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H42<100, $E42<>\"\" , $E42<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D43=\"\",\"\",$D43)","v":0},{"$f":"IF(OR($D43=\"\",$E43=\"\"),\"\", $E43-$D43+1)","v":0},{"$f":"IF($F43=\"\",\"\",$F43)","v":0},{"$f":"IF(OR($F43=\"\",$G43=\"\"),\"\", $G43-$F43+1)","v":0},{"$f":"IF($E43=\"\", \"\", MAX(0, $E43-TODAY()+1))","v":0},{"$f":"IF($G43<>\"\", IF($G43<=$E43, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E43, \"En retard\", IF(TODAY()+7>=$E43, \"À risque (J-7)\", IF($H43=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H43<100, $E43<>\"\" , $E43<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D44=\"\",\"\",$D44)","v":0},{"$f":"IF(OR($D44=\"\",$E44=\"\"),\"\", $E44-$D44+1)","v":0},{"$f":"IF($F44=\"\",\"\",$F44)","v":0},{"$f":"IF(OR($F44=\"\",$G44=\"\"),\"\", $G44-$F44+1)","v":0},{"$f":"IF($E44=\"\", \"\", MAX(0, $E44-TODAY()+1))","v":0},{"$f":"IF($G44<>\"\", IF($G44<=$E44, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E44, \"En retard\", IF(TODAY()+7>=$E44, \"À risque (J-7)\", IF($H44=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H44<100, $E44<>\"\" , $E44<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D45=\"\",\"\",$D45)","v":0},{"$f":"IF(OR($D45=\"\",$E45=\"\"),\"\", $E45-$D45+1)","v":0},{"$f":"IF($F45=\"\",\"\",$F45)","v":0},{"$f":"IF(OR($F45=\"\",$G45=\"\"),\"\", $G45-$F45+1)","v":0},{"$f":"IF($E45=\"\", \"\", MAX(0, $E45-TODAY()+1))","v":0},{"$f":"IF($G45<>\"\", IF($G45<=$E45, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E45, \"En retard\", IF(TODAY()+7>=$E45, \"À risque (J-7)\", IF($H45=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H45<100, $E45<>\"\" , $E45<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D46=\"\",\"\",$D46)","v":0},{"$f":"IF(OR($D46=\"\",$E46=\"\"),\"\", $E46-$D46+1)","v":0},{"$f":"IF($F46=\"\",\"\",$F46)","v":0},{"$f":"IF(OR($F46=\"\",$G46=\"\"),\"\", $G46-$F46+1)","v":0},{"$f":"IF($E46=\"\", \"\", MAX(0, $E46-TODAY()+1))","v":0},{"$f":"IF($G46<>\"\", IF($G46<=$E46, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E46, \"En retard\", IF(TODAY()+7>=$E46, \"À risque (J-7)\", IF($H46=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H46<100, $E46<>\"\" , $E46<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D47=\"\",\"\",$D47)","v":0},{"$f":"IF(OR($D47=\"\",$E47=\"\"),\"\", $E47-$D47+1)","v":0},{"$f":"IF($F47=\"\",\"\",$F47)","v":0},{"$f":"IF(OR($F47=\"\",$G47=\"\"),\"\", $G47-$F47+1)","v":0},{"$f":"IF($E47=\"\", \"\", MAX(0, $E47-TODAY()+1))","v":0},{"$f":"IF($G47<>\"\", IF($G47<=$E47, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E47, \"En retard\", IF(TODAY()+7>=$E47, \"À risque (J-7)\", IF($H47=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H47<100, $E47<>\"\" , $E47<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D48=\"\",\"\",$D48)","v":0},{"$f":"IF(OR($D48=\"\",$E48=\"\"),\"\", $E48-$D48+1)","v":0},{"$f":"IF($F48=\"\",\"\",$F48)","v":0},{"$f":"IF(OR($F48=\"\",$G48=\"\"),\"\", $G48-$F48+1)","v":0},{"$f":"IF($E48=\"\", \"\", MAX(0, $E48-TODAY()+1))","v":0},{"$f":"IF($G48<>\"\", IF($G48<=$E48, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E48, \"En retard\", IF(TODAY()+7>=$E48, \"À risque (J-7)\", IF($H48=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H48<100, $E48<>\"\" , $E48<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D49=\"\",\"\",$D49)","v":0},{"$f":"IF(OR($D49=\"\",$E49=\"\"),\"\", $E49-$D49+1)","v":0},{"$f":"IF($F49=\"\",\"\",$F49)","v":0},{"$f":"IF(OR($F49=\"\",$G49=\"\"),\"\", $G49-$F49+1)","v":0},{"$f":"IF($E49=\"\", \"\", MAX(0, $E49-TODAY()+1))","v":0},{"$f":"IF($G49<>\"\", IF($G49<=$E49, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E49, \"En retard\", IF(TODAY()+7>=$E49, \"À risque (J-7)\", IF($H49=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H49<100, $E49<>\"\" , $E49<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D50=\"\",\"\",$D50)","v":0},{"$f":"IF(OR($D50=\"\",$E50=\"\"),\"\", $E50-$D50+1)","v":0},{"$f":"IF($F50=\"\",\"\",$F50)","v":0},{"$f":"IF(OR($F50=\"\",$G50=\"\"),\"\", $G50-$F50+1)","v":0},{"$f":"IF($E50=\"\", \"\", MAX(0, $E50-TODAY()+1))","v":0},{"$f":"IF($G50<>\"\", IF($G50<=$E50, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E50, \"En retard\", IF(TODAY()+7>=$E50, \"À risque (J-7)\", IF($H50=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H50<100, $E50<>\"\" , $E50<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D51=\"\",\"\",$D51)","v":0},{"$f":"IF(OR($D51=\"\",$E51=\"\"),\"\", $E51-$D51+1)","v":0},{"$f":"IF($F51=\"\",\"\",$F51)","v":0},{"$f":"IF(OR($F51=\"\",$G51=\"\"),\"\", $G51-$F51+1)","v":0},{"$f":"IF($E51=\"\", \"\", MAX(0, $E51-TODAY()+1))","v":0},{"$f":"IF($G51<>\"\", IF($G51<=$E51, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E51, \"En retard\", IF(TODAY()+7>=$E51, \"À risque (J-7)\", IF($H51=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H51<100, $E51<>\"\" , $E51<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D52=\"\",\"\",$D52)","v":0},{"$f":"IF(OR($D52=\"\",$E52=\"\"),\"\", $E52-$D52+1)","v":0},{"$f":"IF($F52=\"\",\"\",$F52)","v":0},{"$f":"IF(OR($F52=\"\",$G52=\"\"),\"\", $G52-$F52+1)","v":0},{"$f":"IF($E52=\"\", \"\", MAX(0, $E52-TODAY()+1))","v":0},{"$f":"IF($G52<>\"\", IF($G52<=$E52, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E52, \"En retard\", IF(TODAY()+7>=$E52, \"À risque (J-7)\", IF($H52=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H52<100, $E52<>\"\" , $E52<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D53=\"\",\"\",$D53)","v":0},{"$f":"IF(OR($D53=\"\",$E53=\"\"),\"\", $E53-$D53+1)","v":0},{"$f":"IF($F53=\"\",\"\",$F53)","v":0},{"$f":"IF(OR($F53=\"\",$G53=\"\"),\"\", $G53-$F53+1)","v":0},{"$f":"IF($E53=\"\", \"\", MAX(0, $E53-TODAY()+1))","v":0},{"$f":"IF($G53<>\"\", IF($G53<=$E53, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E53, \"En retard\", IF(TODAY()+7>=$E53, \"À risque (J-7)\", IF($H53=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H53<100, $E53<>\"\" , $E53<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D54=\"\",\"\",$D54)","v":0},{"$f":"IF(OR($D54=\"\",$E54=\"\"),\"\", $E54-$D54+1)","v":0},{"$f":"IF($F54=\"\",\"\",$F54)","v":0},{"$f":"IF(OR($F54=\"\",$G54=\"\"),\"\", $G54-$F54+1)","v":0},{"$f":"IF($E54=\"\", \"\", MAX(0, $E54-TODAY()+1))","v":0},{"$f":"IF($G54<>\"\", IF($G54<=$E54, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E54, \"En retard\", IF(TODAY()+7>=$E54, \"À risque (J-7)\", IF($H54=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H54<100, $E54<>\"\" , $E54<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D55=\"\",\"\",$D55)","v":0},{"$f":"IF(OR($D55=\"\",$E55=\"\"),\"\", $E55-$D55+1)","v":0},{"$f":"IF($F55=\"\",\"\",$F55)","v":0},{"$f":"IF(OR($F55=\"\",$G55=\"\"),\"\", $G55-$F55+1)","v":0},{"$f":"IF($E55=\"\", \"\", MAX(0, $E55-TODAY()+1))","v":0},{"$f":"IF($G55<>\"\", IF($G55<=$E55, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E55, \"En retard\", IF(TODAY()+7>=$E55, \"À risque (J-7)\", IF($H55=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H55<100, $E55<>\"\" , $E55<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D56=\"\",\"\",$D56)","v":0},{"$f":"IF(OR($D56=\"\",$E56=\"\"),\"\", $E56-$D56+1)","v":0},{"$f":"IF($F56=\"\",\"\",$F56)","v":0},{"$f":"IF(OR($F56=\"\",$G56=\"\"),\"\", $G56-$F56+1)","v":0},{"$f":"IF($E56=\"\", \"\", MAX(0, $E56-TODAY()+1))","v":0},{"$f":"IF($G56<>\"\", IF($G56<=$E56, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E56, \"En retard\", IF(TODAY()+7>=$E56, \"À risque (J-7)\", IF($H56=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H56<100, $E56<>\"\" , $E56<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D57=\"\",\"\",$D57)","v":0},{"$f":"IF(OR($D57=\"\",$E57=\"\"),\"\", $E57-$D57+1)","v":0},{"$f":"IF($F57=\"\",\"\",$F57)","v":0},{"$f":"IF(OR($F57=\"\",$G57=\"\"),\"\", $G57-$F57+1)","v":0},{"$f":"IF($E57=\"\", \"\", MAX(0, $E57-TODAY()+1))","v":0},{"$f":"IF($G57<>\"\", IF($G57<=$E57, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E57, \"En retard\", IF(TODAY()+7>=$E57, \"À risque (J-7)\", IF($H57=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H57<100, $E57<>\"\" , $E57<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D58=\"\",\"\",$D58)","v":0},{"$f":"IF(OR($D58=\"\",$E58=\"\"),\"\", $E58-$D58+1)","v":0},{"$f":"IF($F58=\"\",\"\",$F58)","v":0},{"$f":"IF(OR($F58=\"\",$G58=\"\"),\"\", $G58-$F58+1)","v":0},{"$f":"IF($E58=\"\", \"\", MAX(0, $E58-TODAY()+1))","v":0},{"$f":"IF($G58<>\"\", IF($G58<=$E58, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E58, \"En retard\", IF(TODAY()+7>=$E58, \"À risque (J-7)\", IF($H58=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H58<100, $E58<>\"\" , $E58<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D59=\"\",\"\",$D59)","v":0},{"$f":"IF(OR($D59=\"\",$E59=\"\"),\"\", $E59-$D59+1)","v":0},{"$f":"IF($F59=\"\",\"\",$F59)","v":0},{"$f":"IF(OR($F59=\"\",$G59=\"\"),\"\", $G59-$F59+1)","v":0},{"$f":"IF($E59=\"\", \"\", MAX(0, $E59-TODAY()+1))","v":0},{"$f":"IF($G59<>\"\", IF($G59<=$E59, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E59, \"En retard\", IF(TODAY()+7>=$E59, \"À risque (J-7)\", IF($H59=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H59<100, $E59<>\"\" , $E59<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D60=\"\",\"\",$D60)","v":0},{"$f":"IF(OR($D60=\"\",$E60=\"\"),\"\", $E60-$D60+1)","v":0},{"$f":"IF($F60=\"\",\"\",$F60)","v":0},{"$f":"IF(OR($F60=\"\",$G60=\"\"),\"\", $G60-$F60+1)","v":0},{"$f":"IF($E60=\"\", \"\", MAX(0, $E60-TODAY()+1))","v":0},{"$f":"IF($G60<>\"\", IF($G60<=$E60, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E60, \"En retard\", IF(TODAY()+7>=$E60, \"À risque (J-7)\", IF($H60=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H60<100, $E60<>\"\" , $E60<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D61=\"\",\"\",$D61)","v":0},{"$f":"IF(OR($D61=\"\",$E61=\"\"),\"\", $E61-$D61+1)","v":0},{"$f":"IF($F61=\"\",\"\",$F61)","v":0},{"$f":"IF(OR($F61=\"\",$G61=\"\"),\"\", $G61-$F61+1)","v":0},{"$f":"IF($E61=\"\", \"\", MAX(0, $E61-TODAY()+1))","v":0},{"$f":"IF($G61<>\"\", IF($G61<=$E61, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E61, \"En retard\", IF(TODAY()+7>=$E61, \"À risque (J-7)\", IF($H61=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H61<100, $E61<>\"\" , $E61<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D62=\"\",\"\",$D62)","v":0},{"$f":"IF(OR($D62=\"\",$E62=\"\"),\"\", $E62-$D62+1)","v":0},{"$f":"IF($F62=\"\",\"\",$F62)","v":0},{"$f":"IF(OR($F62=\"\",$G62=\"\"),\"\", $G62-$F62+1)","v":0},{"$f":"IF($E62=\"\", \"\", MAX(0, $E62-TODAY()+1))","v":0},{"$f":"IF($G62<>\"\", IF($G62<=$E62, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E62, \"En retard\", IF(TODAY()+7>=$E62, \"À risque (J-7)\", IF($H62=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H62<100, $E62<>\"\" , $E62<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D63=\"\",\"\",$D63)","v":0},{"$f":"IF(OR($D63=\"\",$E63=\"\"),\"\", $E63-$D63+1)","v":0},{"$f":"IF($F63=\"\",\"\",$F63)","v":0},{"$f":"IF(OR($F63=\"\",$G63=\"\"),\"\", $G63-$F63+1)","v":0},{"$f":"IF($E63=\"\", \"\", MAX(0, $E63-TODAY()+1))","v":0},{"$f":"IF($G63<>\"\", IF($G63<=$E63, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E63, \"En retard\", IF(TODAY()+7>=$E63, \"À risque (J-7)\", IF($H63=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H63<100, $E63<>\"\" , $E63<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D64=\"\",\"\",$D64)","v":0},{"$f":"IF(OR($D64=\"\",$E64=\"\"),\"\", $E64-$D64+1)","v":0},{"$f":"IF($F64=\"\",\"\",$F64)","v":0},{"$f":"IF(OR($F64=\"\",$G64=\"\"),\"\", $G64-$F64+1)","v":0},{"$f":"IF($E64=\"\", \"\", MAX(0, $E64-TODAY()+1))","v":0},{"$f":"IF($G64<>\"\", IF($G64<=$E64, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E64, \"En retard\", IF(TODAY()+7>=$E64, \"À risque (J-7)\", IF($H64=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H64<100, $E64<>\"\" , $E64<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D65=\"\",\"\",$D65)","v":0},{"$f":"IF(OR($D65=\"\",$E65=\"\"),\"\", $E65-$D65+1)","v":0},{"$f":"IF($F65=\"\",\"\",$F65)","v":0},{"$f":"IF(OR($F65=\"\",$G65=\"\"),\"\", $G65-$F65+1)","v":0},{"$f":"IF($E65=\"\", \"\", MAX(0, $E65-TODAY()+1))","v":0},{"$f":"IF($G65<>\"\", IF($G65<=$E65, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E65, \"En retard\", IF(TODAY()+7>=$E65, \"À risque (J-7)\", IF($H65=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H65<100, $E65<>\"\" , $E65<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D66=\"\",\"\",$D66)","v":0},{"$f":"IF(OR($D66=\"\",$E66=\"\"),\"\", $E66-$D66+1)","v":0},{"$f":"IF($F66=\"\",\"\",$F66)","v":0},{"$f":"IF(OR($F66=\"\",$G66=\"\"),\"\", $G66-$F66+1)","v":0},{"$f":"IF($E66=\"\", \"\", MAX(0, $E66-TODAY()+1))","v":0},{"$f":"IF($G66<>\"\", IF($G66<=$E66, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E66, \"En retard\", IF(TODAY()+7>=$E66, \"À risque (J-7)\", IF($H66=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H66<100, $E66<>\"\" , $E66<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D67=\"\",\"\",$D67)","v":0},{"$f":"IF(OR($D67=\"\",$E67=\"\"),\"\", $E67-$D67+1)","v":0},{"$f":"IF($F67=\"\",\"\",$F67)","v":0},{"$f":"IF(OR($F67=\"\",$G67=\"\"),\"\", $G67-$F67+1)","v":0},{"$f":"IF($E67=\"\", \"\", MAX(0, $E67-TODAY()+1))","v":0},{"$f":"IF($G67<>\"\", IF($G67<=$E67, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E67, \"En retard\", IF(TODAY()+7>=$E67, \"À risque (J-7)\", IF($H67=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H67<100, $E67<>\"\" , $E67<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D68=\"\",\"\",$D68)","v":0},{"$f":"IF(OR($D68=\"\",$E68=\"\"),\"\", $E68-$D68+1)","v":0},{"$f":"IF($F68=\"\",\"\",$F68)","v":0},{"$f":"IF(OR($F68=\"\",$G68=\"\"),\"\", $G68-$F68+1)","v":0},{"$f":"IF($E68=\"\", \"\", MAX(0, $E68-TODAY()+1))","v":0},{"$f":"IF($G68<>\"\", IF($G68<=$E68, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E68, \"En retard\", IF(TODAY()+7>=$E68, \"À risque (J-7)\", IF($H68=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H68<100, $E68<>\"\" , $E68<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D69=\"\",\"\",$D69)","v":0},{"$f":"IF(OR($D69=\"\",$E69=\"\"),\"\", $E69-$D69+1)","v":0},{"$f":"IF($F69=\"\",\"\",$F69)","v":0},{"$f":"IF(OR($F69=\"\",$G69=\"\"),\"\", $G69-$F69+1)","v":0},{"$f":"IF($E69=\"\", \"\", MAX(0, $E69-TODAY()+1))","v":0},{"$f":"IF($G69<>\"\", IF($G69<=$E69, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E69, \"En retard\", IF(TODAY()+7>=$E69, \"À risque (J-7)\", IF($H69=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H69<100, $E69<>\"\" , $E69<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D70=\"\",\"\",$D70)","v":0},{"$f":"IF(OR($D70=\"\",$E70=\"\"),\"\", $E70-$D70+1)","v":0},{"$f":"IF($F70=\"\",\"\",$F70)","v":0},{"$f":"IF(OR($F70=\"\",$G70=\"\"),\"\", $G70-$F70+1)","v":0},{"$f":"IF($E70=\"\", \"\", MAX(0, $E70-TODAY()+1))","v":0},{"$f":"IF($G70<>\"\", IF($G70<=$E70, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E70, \"En retard\", IF(TODAY()+7>=$E70, \"À risque (J-7)\", IF($H70=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H70<100, $E70<>\"\" , $E70<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D71=\"\",\"\",$D71)","v":0},{"$f":"IF(OR($D71=\"\",$E71=\"\"),\"\", $E71-$D71+1)","v":0},{"$f":"IF($F71=\"\",\"\",$F71)","v":0},{"$f":"IF(OR($F71=\"\",$G71=\"\"),\"\", $G71-$F71+1)","v":0},{"$f":"IF($E71=\"\", \"\", MAX(0, $E71-TODAY()+1))","v":0},{"$f":"IF($G71<>\"\", IF($G71<=$E71, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E71, \"En retard\", IF(TODAY()+7>=$E71, \"À risque (J-7)\", IF($H71=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H71<100, $E71<>\"\" , $E71<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D72=\"\",\"\",$D72)","v":0},{"$f":"IF(OR($D72=\"\",$E72=\"\"),\"\", $E72-$D72+1)","v":0},{"$f":"IF($F72=\"\",\"\",$F72)","v":0},{"$f":"IF(OR($F72=\"\",$G72=\"\"),\"\", $G72-$F72+1)","v":0},{"$f":"IF($E72=\"\", \"\", MAX(0, $E72-TODAY()+1))","v":0},{"$f":"IF($G72<>\"\", IF($G72<=$E72, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E72, \"En retard\", IF(TODAY()+7>=$E72, \"À risque (J-7)\", IF($H72=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H72<100, $E72<>\"\" , $E72<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D73=\"\",\"\",$D73)","v":0},{"$f":"IF(OR($D73=\"\",$E73=\"\"),\"\", $E73-$D73+1)","v":0},{"$f":"IF($F73=\"\",\"\",$F73)","v":0},{"$f":"IF(OR($F73=\"\",$G73=\"\"),\"\", $G73-$F73+1)","v":0},{"$f":"IF($E73=\"\", \"\", MAX(0, $E73-TODAY()+1))","v":0},{"$f":"IF($G73<>\"\", IF($G73<=$E73, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E73, \"En retard\", IF(TODAY()+7>=$E73, \"À risque (J-7)\", IF($H73=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H73<100, $E73<>\"\" , $E73<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D74=\"\",\"\",$D74)","v":0},{"$f":"IF(OR($D74=\"\",$E74=\"\"),\"\", $E74-$D74+1)","v":0},{"$f":"IF($F74=\"\",\"\",$F74)","v":0},{"$f":"IF(OR($F74=\"\",$G74=\"\"),\"\", $G74-$F74+1)","v":0},{"$f":"IF($E74=\"\", \"\", MAX(0, $E74-TODAY()+1))","v":0},{"$f":"IF($G74<>\"\", IF($G74<=$E74, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E74, \"En retard\", IF(TODAY()+7>=$E74, \"À risque (J-7)\", IF($H74=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H74<100, $E74<>\"\" , $E74<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D75=\"\",\"\",$D75)","v":0},{"$f":"IF(OR($D75=\"\",$E75=\"\"),\"\", $E75-$D75+1)","v":0},{"$f":"IF($F75=\"\",\"\",$F75)","v":0},{"$f":"IF(OR($F75=\"\",$G75=\"\"),\"\", $G75-$F75+1)","v":0},{"$f":"IF($E75=\"\", \"\", MAX(0, $E75-TODAY()+1))","v":0},{"$f":"IF($G75<>\"\", IF($G75<=$E75, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E75, \"En retard\", IF(TODAY()+7>=$E75, \"À risque (J-7)\", IF($H75=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H75<100, $E75<>\"\" , $E75<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D76=\"\",\"\",$D76)","v":0},{"$f":"IF(OR($D76=\"\",$E76=\"\"),\"\", $E76-$D76+1)","v":0},{"$f":"IF($F76=\"\",\"\",$F76)","v":0},{"$f":"IF(OR($F76=\"\",$G76=\"\"),\"\", $G76-$F76+1)","v":0},{"$f":"IF($E76=\"\", \"\", MAX(0, $E76-TODAY()+1))","v":0},{"$f":"IF($G76<>\"\", IF($G76<=$E76, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E76, \"En retard\", IF(TODAY()+7>=$E76, \"À risque (J-7)\", IF($H76=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H76<100, $E76<>\"\" , $E76<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D77=\"\",\"\",$D77)","v":0},{"$f":"IF(OR($D77=\"\",$E77=\"\"),\"\", $E77-$D77+1)","v":0},{"$f":"IF($F77=\"\",\"\",$F77)","v":0},{"$f":"IF(OR($F77=\"\",$G77=\"\"),\"\", $G77-$F77+1)","v":0},{"$f":"IF($E77=\"\", \"\", MAX(0, $E77-TODAY()+1))","v":0},{"$f":"IF($G77<>\"\", IF($G77<=$E77, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E77, \"En retard\", IF(TODAY()+7>=$E77, \"À risque (J-7)\", IF($H77=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H77<100, $E77<>\"\" , $E77<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D78=\"\",\"\",$D78)","v":0},{"$f":"IF(OR($D78=\"\",$E78=\"\"),\"\", $E78-$D78+1)","v":0},{"$f":"IF($F78=\"\",\"\",$F78)","v":0},{"$f":"IF(OR($F78=\"\",$G78=\"\"),\"\", $G78-$F78+1)","v":0},{"$f":"IF($E78=\"\", \"\", MAX(0, $E78-TODAY()+1))","v":0},{"$f":"IF($G78<>\"\", IF($G78<=$E78, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E78, \"En retard\", IF(TODAY()+7>=$E78, \"À risque (J-7)\", IF($H78=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H78<100, $E78<>\"\" , $E78<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D79=\"\",\"\",$D79)","v":0},{"$f":"IF(OR($D79=\"\",$E79=\"\"),\"\", $E79-$D79+1)","v":0},{"$f":"IF($F79=\"\",\"\",$F79)","v":0},{"$f":"IF(OR($F79=\"\",$G79=\"\"),\"\", $G79-$F79+1)","v":0},{"$f":"IF($E79=\"\", \"\", MAX(0, $E79-TODAY()+1))","v":0},{"$f":"IF($G79<>\"\", IF($G79<=$E79, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E79, \"En retard\", IF(TODAY()+7>=$E79, \"À risque (J-7)\", IF($H79=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H79<100, $E79<>\"\" , $E79<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D80=\"\",\"\",$D80)","v":0},{"$f":"IF(OR($D80=\"\",$E80=\"\"),\"\", $E80-$D80+1)","v":0},{"$f":"IF($F80=\"\",\"\",$F80)","v":0},{"$f":"IF(OR($F80=\"\",$G80=\"\"),\"\", $G80-$F80+1)","v":0},{"$f":"IF($E80=\"\", \"\", MAX(0, $E80-TODAY()+1))","v":0},{"$f":"IF($G80<>\"\", IF($G80<=$E80, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E80, \"En retard\", IF(TODAY()+7>=$E80, \"À risque (J-7)\", IF($H80=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H80<100, $E80<>\"\" , $E80<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D81=\"\",\"\",$D81)","v":0},{"$f":"IF(OR($D81=\"\",$E81=\"\"),\"\", $E81-$D81+1)","v":0},{"$f":"IF($F81=\"\",\"\",$F81)","v":0},{"$f":"IF(OR($F81=\"\",$G81=\"\"),\"\", $G81-$F81+1)","v":0},{"$f":"IF($E81=\"\", \"\", MAX(0, $E81-TODAY()+1))","v":0},{"$f":"IF($G81<>\"\", IF($G81<=$E81, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E81, \"En retard\", IF(TODAY()+7>=$E81, \"À risque (J-7)\", IF($H81=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H81<100, $E81<>\"\" , $E81<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D82=\"\",\"\",$D82)","v":0},{"$f":"IF(OR($D82=\"\",$E82=\"\"),\"\", $E82-$D82+1)","v":0},{"$f":"IF($F82=\"\",\"\",$F82)","v":0},{"$f":"IF(OR($F82=\"\",$G82=\"\"),\"\", $G82-$F82+1)","v":0},{"$f":"IF($E82=\"\", \"\", MAX(0, $E82-TODAY()+1))","v":0},{"$f":"IF($G82<>\"\", IF($G82<=$E82, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E82, \"En retard\", IF(TODAY()+7>=$E82, \"À risque (J-7)\", IF($H82=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H82<100, $E82<>\"\" , $E82<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D83=\"\",\"\",$D83)","v":0},{"$f":"IF(OR($D83=\"\",$E83=\"\"),\"\", $E83-$D83+1)","v":0},{"$f":"IF($F83=\"\",\"\",$F83)","v":0},{"$f":"IF(OR($F83=\"\",$G83=\"\"),\"\", $G83-$F83+1)","v":0},{"$f":"IF($E83=\"\", \"\", MAX(0, $E83-TODAY()+1))","v":0},{"$f":"IF($G83<>\"\", IF($G83<=$E83, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E83, \"En retard\", IF(TODAY()+7>=$E83, \"À risque (J-7)\", IF($H83=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H83<100, $E83<>\"\" , $E83<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D84=\"\",\"\",$D84)","v":0},{"$f":"IF(OR($D84=\"\",$E84=\"\"),\"\", $E84-$D84+1)","v":0},{"$f":"IF($F84=\"\",\"\",$F84)","v":0},{"$f":"IF(OR($F84=\"\",$G84=\"\"),\"\", $G84-$F84+1)","v":0},{"$f":"IF($E84=\"\", \"\", MAX(0, $E84-TODAY()+1))","v":0},{"$f":"IF($G84<>\"\", IF($G84<=$E84, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E84, \"En retard\", IF(TODAY()+7>=$E84, \"À risque (J-7)\", IF($H84=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H84<100, $E84<>\"\" , $E84<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D85=\"\",\"\",$D85)","v":0},{"$f":"IF(OR($D85=\"\",$E85=\"\"),\"\", $E85-$D85+1)","v":0},{"$f":"IF($F85=\"\",\"\",$F85)","v":0},{"$f":"IF(OR($F85=\"\",$G85=\"\"),\"\", $G85-$F85+1)","v":0},{"$f":"IF($E85=\"\", \"\", MAX(0, $E85-TODAY()+1))","v":0},{"$f":"IF($G85<>\"\", IF($G85<=$E85, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E85, \"En retard\", IF(TODAY()+7>=$E85, \"À risque (J-7)\", IF($H85=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H85<100, $E85<>\"\" , $E85<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D86=\"\",\"\",$D86)","v":0},{"$f":"IF(OR($D86=\"\",$E86=\"\"),\"\", $E86-$D86+1)","v":0},{"$f":"IF($F86=\"\",\"\",$F86)","v":0},{"$f":"IF(OR($F86=\"\",$G86=\"\"),\"\", $G86-$F86+1)","v":0},{"$f":"IF($E86=\"\", \"\", MAX(0, $E86-TODAY()+1))","v":0},{"$f":"IF($G86<>\"\", IF($G86<=$E86, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E86, \"En retard\", IF(TODAY()+7>=$E86, \"À risque (J-7)\", IF($H86=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H86<100, $E86<>\"\" , $E86<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D87=\"\",\"\",$D87)","v":0},{"$f":"IF(OR($D87=\"\",$E87=\"\"),\"\", $E87-$D87+1)","v":0},{"$f":"IF($F87=\"\",\"\",$F87)","v":0},{"$f":"IF(OR($F87=\"\",$G87=\"\"),\"\", $G87-$F87+1)","v":0},{"$f":"IF($E87=\"\", \"\", MAX(0, $E87-TODAY()+1))","v":0},{"$f":"IF($G87<>\"\", IF($G87<=$E87, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E87, \"En retard\", IF(TODAY()+7>=$E87, \"À risque (J-7)\", IF($H87=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H87<100, $E87<>\"\" , $E87<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D88=\"\",\"\",$D88)","v":0},{"$f":"IF(OR($D88=\"\",$E88=\"\"),\"\", $E88-$D88+1)","v":0},{"$f":"IF($F88=\"\",\"\",$F88)","v":0},{"$f":"IF(OR($F88=\"\",$G88=\"\"),\"\", $G88-$F88+1)","v":0},{"$f":"IF($E88=\"\", \"\", MAX(0, $E88-TODAY()+1))","v":0},{"$f":"IF($G88<>\"\", IF($G88<=$E88, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E88, \"En retard\", IF(TODAY()+7>=$E88, \"À risque (J-7)\", IF($H88=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H88<100, $E88<>\"\" , $E88<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D89=\"\",\"\",$D89)","v":0},{"$f":"IF(OR($D89=\"\",$E89=\"\"),\"\", $E89-$D89+1)","v":0},{"$f":"IF($F89=\"\",\"\",$F89)","v":0},{"$f":"IF(OR($F89=\"\",$G89=\"\"),\"\", $G89-$F89+1)","v":0},{"$f":"IF($E89=\"\", \"\", MAX(0, $E89-TODAY()+1))","v":0},{"$f":"IF($G89<>\"\", IF($G89<=$E89, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E89, \"En retard\", IF(TODAY()+7>=$E89, \"À risque (J-7)\", IF($H89=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H89<100, $E89<>\"\" , $E89<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D90=\"\",\"\",$D90)","v":0},{"$f":"IF(OR($D90=\"\",$E90=\"\"),\"\", $E90-$D90+1)","v":0},{"$f":"IF($F90=\"\",\"\",$F90)","v":0},{"$f":"IF(OR($F90=\"\",$G90=\"\"),\"\", $G90-$F90+1)","v":0},{"$f":"IF($E90=\"\", \"\", MAX(0, $E90-TODAY()+1))","v":0},{"$f":"IF($G90<>\"\", IF($G90<=$E90, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E90, \"En retard\", IF(TODAY()+7>=$E90, \"À risque (J-7)\", IF($H90=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H90<100, $E90<>\"\" , $E90<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D91=\"\",\"\",$D91)","v":0},{"$f":"IF(OR($D91=\"\",$E91=\"\"),\"\", $E91-$D91+1)","v":0},{"$f":"IF($F91=\"\",\"\",$F91)","v":0},{"$f":"IF(OR($F91=\"\",$G91=\"\"),\"\", $G91-$F91+1)","v":0},{"$f":"IF($E91=\"\", \"\", MAX(0, $E91-TODAY()+1))","v":0},{"$f":"IF($G91<>\"\", IF($G91<=$E91, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E91, \"En retard\", IF(TODAY()+7>=$E91, \"À risque (J-7)\", IF($H91=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H91<100, $E91<>\"\" , $E91<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D92=\"\",\"\",$D92)","v":0},{"$f":"IF(OR($D92=\"\",$E92=\"\"),\"\", $E92-$D92+1)","v":0},{"$f":"IF($F92=\"\",\"\",$F92)","v":0},{"$f":"IF(OR($F92=\"\",$G92=\"\"),\"\", $G92-$F92+1)","v":0},{"$f":"IF($E92=\"\", \"\", MAX(0, $E92-TODAY()+1))","v":0},{"$f":"IF($G92<>\"\", IF($G92<=$E92, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E92, \"En retard\", IF(TODAY()+7>=$E92, \"À risque (J-7)\", IF($H92=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H92<100, $E92<>\"\" , $E92<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D93=\"\",\"\",$D93)","v":0},{"$f":"IF(OR($D93=\"\",$E93=\"\"),\"\", $E93-$D93+1)","v":0},{"$f":"IF($F93=\"\",\"\",$F93)","v":0},{"$f":"IF(OR($F93=\"\",$G93=\"\"),\"\", $G93-$F93+1)","v":0},{"$f":"IF($E93=\"\", \"\", MAX(0, $E93-TODAY()+1))","v":0},{"$f":"IF($G93<>\"\", IF($G93<=$E93, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E93, \"En retard\", IF(TODAY()+7>=$E93, \"À risque (J-7)\", IF($H93=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H93<100, $E93<>\"\" , $E93<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D94=\"\",\"\",$D94)","v":0},{"$f":"IF(OR($D94=\"\",$E94=\"\"),\"\", $E94-$D94+1)","v":0},{"$f":"IF($F94=\"\",\"\",$F94)","v":0},{"$f":"IF(OR($F94=\"\",$G94=\"\"),\"\", $G94-$F94+1)","v":0},{"$f":"IF($E94=\"\", \"\", MAX(0, $E94-TODAY()+1))","v":0},{"$f":"IF($G94<>\"\", IF($G94<=$E94, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E94, \"En retard\", IF(TODAY()+7>=$E94, \"À risque (J-7)\", IF($H94=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H94<100, $E94<>\"\" , $E94<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D95=\"\",\"\",$D95)","v":0},{"$f":"IF(OR($D95=\"\",$E95=\"\"),\"\", $E95-$D95+1)","v":0},{"$f":"IF($F95=\"\",\"\",$F95)","v":0},{"$f":"IF(OR($F95=\"\",$G95=\"\"),\"\", $G95-$F95+1)","v":0},{"$f":"IF($E95=\"\", \"\", MAX(0, $E95-TODAY()+1))","v":0},{"$f":"IF($G95<>\"\", IF($G95<=$E95, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E95, \"En retard\", IF(TODAY()+7>=$E95, \"À risque (J-7)\", IF($H95=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H95<100, $E95<>\"\" , $E95<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D96=\"\",\"\",$D96)","v":0},{"$f":"IF(OR($D96=\"\",$E96=\"\"),\"\", $E96-$D96+1)","v":0},{"$f":"IF($F96=\"\",\"\",$F96)","v":0},{"$f":"IF(OR($F96=\"\",$G96=\"\"),\"\", $G96-$F96+1)","v":0},{"$f":"IF($E96=\"\", \"\", MAX(0, $E96-TODAY()+1))","v":0},{"$f":"IF($G96<>\"\", IF($G96<=$E96, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E96, \"En retard\", IF(TODAY()+7>=$E96, \"À risque (J-7)\", IF($H96=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H96<100, $E96<>\"\" , $E96<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D97=\"\",\"\",$D97)","v":0},{"$f":"IF(OR($D97=\"\",$E97=\"\"),\"\", $E97-$D97+1)","v":0},{"$f":"IF($F97=\"\",\"\",$F97)","v":0},{"$f":"IF(OR($F97=\"\",$G97=\"\"),\"\", $G97-$F97+1)","v":0},{"$f":"IF($E97=\"\", \"\", MAX(0, $E97-TODAY()+1))","v":0},{"$f":"IF($G97<>\"\", IF($G97<=$E97, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E97, \"En retard\", IF(TODAY()+7>=$E97, \"À risque (J-7)\", IF($H97=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H97<100, $E97<>\"\" , $E97<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D98=\"\",\"\",$D98)","v":0},{"$f":"IF(OR($D98=\"\",$E98=\"\"),\"\", $E98-$D98+1)","v":0},{"$f":"IF($F98=\"\",\"\",$F98)","v":0},{"$f":"IF(OR($F98=\"\",$G98=\"\"),\"\", $G98-$F98+1)","v":0},{"$f":"IF($E98=\"\", \"\", MAX(0, $E98-TODAY()+1))","v":0},{"$f":"IF($G98<>\"\", IF($G98<=$E98, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E98, \"En retard\", IF(TODAY()+7>=$E98, \"À risque (J-7)\", IF($H98=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H98<100, $E98<>\"\" , $E98<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D99=\"\",\"\",$D99)","v":0},{"$f":"IF(OR($D99=\"\",$E99=\"\"),\"\", $E99-$D99+1)","v":0},{"$f":"IF($F99=\"\",\"\",$F99)","v":0},{"$f":"IF(OR($F99=\"\",$G99=\"\"),\"\", $G99-$F99+1)","v":0},{"$f":"IF($E99=\"\", \"\", MAX(0, $E99-TODAY()+1))","v":0},{"$f":"IF($G99<>\"\", IF($G99<=$E99, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E99, \"En retard\", IF(TODAY()+7>=$E99, \"À risque (J-7)\", IF($H99=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H99<100, $E99<>\"\" , $E99<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D100=\"\",\"\",$D100)","v":0},{"$f":"IF(OR($D100=\"\",$E100=\"\"),\"\", $E100-$D100+1)","v":0},{"$f":"IF($F100=\"\",\"\",$F100)","v":0},{"$f":"IF(OR($F100=\"\",$G100=\"\"),\"\", $G100-$F100+1)","v":0},{"$f":"IF($E100=\"\", \"\", MAX(0, $E100-TODAY()+1))","v":0},{"$f":"IF($G100<>\"\", IF($G100<=$E100, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E100, \"En retard\", IF(TODAY()+7>=$E100, \"À risque (J-7)\", IF($H100=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H100<100, $E100<>\"\" , $E100<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D101=\"\",\"\",$D101)","v":0},{"$f":"IF(OR($D101=\"\",$E101=\"\"),\"\", $E101-$D101+1)","v":0},{"$f":"IF($F101=\"\",\"\",$F101)","v":0},{"$f":"IF(OR($F101=\"\",$G101=\"\"),\"\", $G101-$F101+1)","v":0},{"$f":"IF($E101=\"\", \"\", MAX(0, $E101-TODAY()+1))","v":0},{"$f":"IF($G101<>\"\", IF($G101<=$E101, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E101, \"En retard\", IF(TODAY()+7>=$E101, \"À risque (J-7)\", IF($H101=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H101<100, $E101<>\"\" , $E101<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D102=\"\",\"\",$D102)","v":0},{"$f":"IF(OR($D102=\"\",$E102=\"\"),\"\", $E102-$D102+1)","v":0},{"$f":"IF($F102=\"\",\"\",$F102)","v":0},{"$f":"IF(OR($F102=\"\",$G102=\"\"),\"\", $G102-$F102+1)","v":0},{"$f":"IF($E102=\"\", \"\", MAX(0, $E102-TODAY()+1))","v":0},{"$f":"IF($G102<>\"\", IF($G102<=$E102, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E102, \"En retard\", IF(TODAY()+7>=$E102, \"À risque (J-7)\", IF($H102=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H102<100, $E102<>\"\" , $E102<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D103=\"\",\"\",$D103)","v":0},{"$f":"IF(OR($D103=\"\",$E103=\"\"),\"\", $E103-$D103+1)","v":0},{"$f":"IF($F103=\"\",\"\",$F103)","v":0},{"$f":"IF(OR($F103=\"\",$G103=\"\"),\"\", $G103-$F103+1)","v":0},{"$f":"IF($E103=\"\", \"\", MAX(0, $E103-TODAY()+1))","v":0},{"$f":"IF($G103<>\"\", IF($G103<=$E103, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E103, \"En retard\", IF(TODAY()+7>=$E103, \"À risque (J-7)\", IF($H103=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H103<100, $E103<>\"\" , $E103<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D104=\"\",\"\",$D104)","v":0},{"$f":"IF(OR($D104=\"\",$E104=\"\"),\"\", $E104-$D104+1)","v":0},{"$f":"IF($F104=\"\",\"\",$F104)","v":0},{"$f":"IF(OR($F104=\"\",$G104=\"\"),\"\", $G104-$F104+1)","v":0},{"$f":"IF($E104=\"\", \"\", MAX(0, $E104-TODAY()+1))","v":0},{"$f":"IF($G104<>\"\", IF($G104<=$E104, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E104, \"En retard\", IF(TODAY()+7>=$E104, \"À risque (J-7)\", IF($H104=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H104<100, $E104<>\"\" , $E104<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D105=\"\",\"\",$D105)","v":0},{"$f":"IF(OR($D105=\"\",$E105=\"\"),\"\", $E105-$D105+1)","v":0},{"$f":"IF($F105=\"\",\"\",$F105)","v":0},{"$f":"IF(OR($F105=\"\",$G105=\"\"),\"\", $G105-$F105+1)","v":0},{"$f":"IF($E105=\"\", \"\", MAX(0, $E105-TODAY()+1))","v":0},{"$f":"IF($G105<>\"\", IF($G105<=$E105, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E105, \"En retard\", IF(TODAY()+7>=$E105, \"À risque (J-7)\", IF($H105=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H105<100, $E105<>\"\" , $E105<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D106=\"\",\"\",$D106)","v":0},{"$f":"IF(OR($D106=\"\",$E106=\"\"),\"\", $E106-$D106+1)","v":0},{"$f":"IF($F106=\"\",\"\",$F106)","v":0},{"$f":"IF(OR($F106=\"\",$G106=\"\"),\"\", $G106-$F106+1)","v":0},{"$f":"IF($E106=\"\", \"\", MAX(0, $E106-TODAY()+1))","v":0},{"$f":"IF($G106<>\"\", IF($G106<=$E106, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E106, \"En retard\", IF(TODAY()+7>=$E106, \"À risque (J-7)\", IF($H106=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H106<100, $E106<>\"\" , $E106<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D107=\"\",\"\",$D107)","v":0},{"$f":"IF(OR($D107=\"\",$E107=\"\"),\"\", $E107-$D107+1)","v":0},{"$f":"IF($F107=\"\",\"\",$F107)","v":0},{"$f":"IF(OR($F107=\"\",$G107=\"\"),\"\", $G107-$F107+1)","v":0},{"$f":"IF($E107=\"\", \"\", MAX(0, $E107-TODAY()+1))","v":0},{"$f":"IF($G107<>\"\", IF($G107<=$E107, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E107, \"En retard\", IF(TODAY()+7>=$E107, \"À risque (J-7)\", IF($H107=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H107<100, $E107<>\"\" , $E107<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D108=\"\",\"\",$D108)","v":0},{"$f":"IF(OR($D108=\"\",$E108=\"\"),\"\", $E108-$D108+1)","v":0},{"$f":"IF($F108=\"\",\"\",$F108)","v":0},{"$f":"IF(OR($F108=\"\",$G108=\"\"),\"\", $G108-$F108+1)","v":0},{"$f":"IF($E108=\"\", \"\", MAX(0, $E108-TODAY()+1))","v":0},{"$f":"IF($G108<>\"\", IF($G108<=$E108, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E108, \"En retard\", IF(TODAY()+7>=$E108, \"À risque (J-7)\", IF($H108=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H108<100, $E108<>\"\" , $E108<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D109=\"\",\"\",$D109)","v":0},{"$f":"IF(OR($D109=\"\",$E109=\"\"),\"\", $E109-$D109+1)","v":0},{"$f":"IF($F109=\"\",\"\",$F109)","v":0},{"$f":"IF(OR($F109=\"\",$G109=\"\"),\"\", $G109-$F109+1)","v":0},{"$f":"IF($E109=\"\", \"\", MAX(0, $E109-TODAY()+1))","v":0},{"$f":"IF($G109<>\"\", IF($G109<=$E109, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E109, \"En retard\", IF(TODAY()+7>=$E109, \"À risque (J-7)\", IF($H109=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H109<100, $E109<>\"\" , $E109<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D110=\"\",\"\",$D110)","v":0},{"$f":"IF(OR($D110=\"\",$E110=\"\"),\"\", $E110-$D110+1)","v":0},{"$f":"IF($F110=\"\",\"\",$F110)","v":0},{"$f":"IF(OR($F110=\"\",$G110=\"\"),\"\", $G110-$F110+1)","v":0},{"$f":"IF($E110=\"\", \"\", MAX(0, $E110-TODAY()+1))","v":0},{"$f":"IF($G110<>\"\", IF($G110<=$E110, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E110, \"En retard\", IF(TODAY()+7>=$E110, \"À risque (J-7)\", IF($H110=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H110<100, $E110<>\"\" , $E110<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D111=\"\",\"\",$D111)","v":0},{"$f":"IF(OR($D111=\"\",$E111=\"\"),\"\", $E111-$D111+1)","v":0},{"$f":"IF($F111=\"\",\"\",$F111)","v":0},{"$f":"IF(OR($F111=\"\",$G111=\"\"),\"\", $G111-$F111+1)","v":0},{"$f":"IF($E111=\"\", \"\", MAX(0, $E111-TODAY()+1))","v":0},{"$f":"IF($G111<>\"\", IF($G111<=$E111, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E111, \"En retard\", IF(TODAY()+7>=$E111, \"À risque (J-7)\", IF($H111=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H111<100, $E111<>\"\" , $E111<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D112=\"\",\"\",$D112)","v":0},{"$f":"IF(OR($D112=\"\",$E112=\"\"),\"\", $E112-$D112+1)","v":0},{"$f":"IF($F112=\"\",\"\",$F112)","v":0},{"$f":"IF(OR($F112=\"\",$G112=\"\"),\"\", $G112-$F112+1)","v":0},{"$f":"IF($E112=\"\", \"\", MAX(0, $E112-TODAY()+1))","v":0},{"$f":"IF($G112<>\"\", IF($G112<=$E112, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E112, \"En retard\", IF(TODAY()+7>=$E112, \"À risque (J-7)\", IF($H112=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H112<100, $E112<>\"\" , $E112<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D113=\"\",\"\",$D113)","v":0},{"$f":"IF(OR($D113=\"\",$E113=\"\"),\"\", $E113-$D113+1)","v":0},{"$f":"IF($F113=\"\",\"\",$F113)","v":0},{"$f":"IF(OR($F113=\"\",$G113=\"\"),\"\", $G113-$F113+1)","v":0},{"$f":"IF($E113=\"\", \"\", MAX(0, $E113-TODAY()+1))","v":0},{"$f":"IF($G113<>\"\", IF($G113<=$E113, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E113, \"En retard\", IF(TODAY()+7>=$E113, \"À risque (J-7)\", IF($H113=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H113<100, $E113<>\"\" , $E113<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D114=\"\",\"\",$D114)","v":0},{"$f":"IF(OR($D114=\"\",$E114=\"\"),\"\", $E114-$D114+1)","v":0},{"$f":"IF($F114=\"\",\"\",$F114)","v":0},{"$f":"IF(OR($F114=\"\",$G114=\"\"),\"\", $G114-$F114+1)","v":0},{"$f":"IF($E114=\"\", \"\", MAX(0, $E114-TODAY()+1))","v":0},{"$f":"IF($G114<>\"\", IF($G114<=$E114, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E114, \"En retard\", IF(TODAY()+7>=$E114, \"À risque (J-7)\", IF($H114=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H114<100, $E114<>\"\" , $E114<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D115=\"\",\"\",$D115)","v":0},{"$f":"IF(OR($D115=\"\",$E115=\"\"),\"\", $E115-$D115+1)","v":0},{"$f":"IF($F115=\"\",\"\",$F115)","v":0},{"$f":"IF(OR($F115=\"\",$G115=\"\"),\"\", $G115-$F115+1)","v":0},{"$f":"IF($E115=\"\", \"\", MAX(0, $E115-TODAY()+1))","v":0},{"$f":"IF($G115<>\"\", IF($G115<=$E115, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E115, \"En retard\", IF(TODAY()+7>=$E115, \"À risque (J-7)\", IF($H115=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H115<100, $E115<>\"\" , $E115<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D116=\"\",\"\",$D116)","v":0},{"$f":"IF(OR($D116=\"\",$E116=\"\"),\"\", $E116-$D116+1)","v":0},{"$f":"IF($F116=\"\",\"\",$F116)","v":0},{"$f":"IF(OR($F116=\"\",$G116=\"\"),\"\", $G116-$F116+1)","v":0},{"$f":"IF($E116=\"\", \"\", MAX(0, $E116-TODAY()+1))","v":0},{"$f":"IF($G116<>\"\", IF($G116<=$E116, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E116, \"En retard\", IF(TODAY()+7>=$E116, \"À risque (J-7)\", IF($H116=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H116<100, $E116<>\"\" , $E116<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D117=\"\",\"\",$D117)","v":0},{"$f":"IF(OR($D117=\"\",$E117=\"\"),\"\", $E117-$D117+1)","v":0},{"$f":"IF($F117=\"\",\"\",$F117)","v":0},{"$f":"IF(OR($F117=\"\",$G117=\"\"),\"\", $G117-$F117+1)","v":0},{"$f":"IF($E117=\"\", \"\", MAX(0, $E117-TODAY()+1))","v":0},{"$f":"IF($G117<>\"\", IF($G117<=$E117, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E117, \"En retard\", IF(TODAY()+7>=$E117, \"À risque (J-7)\", IF($H117=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H117<100, $E117<>\"\" , $E117<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D118=\"\",\"\",$D118)","v":0},{"$f":"IF(OR($D118=\"\",$E118=\"\"),\"\", $E118-$D118+1)","v":0},{"$f":"IF($F118=\"\",\"\",$F118)","v":0},{"$f":"IF(OR($F118=\"\",$G118=\"\"),\"\", $G118-$F118+1)","v":0},{"$f":"IF($E118=\"\", \"\", MAX(0, $E118-TODAY()+1))","v":0},{"$f":"IF($G118<>\"\", IF($G118<=$E118, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E118, \"En retard\", IF(TODAY()+7>=$E118, \"À risque (J-7)\", IF($H118=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H118<100, $E118<>\"\" , $E118<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D119=\"\",\"\",$D119)","v":0},{"$f":"IF(OR($D119=\"\",$E119=\"\"),\"\", $E119-$D119+1)","v":0},{"$f":"IF($F119=\"\",\"\",$F119)","v":0},{"$f":"IF(OR($F119=\"\",$G119=\"\"),\"\", $G119-$F119+1)","v":0},{"$f":"IF($E119=\"\", \"\", MAX(0, $E119-TODAY()+1))","v":0},{"$f":"IF($G119<>\"\", IF($G119<=$E119, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E119, \"En retard\", IF(TODAY()+7>=$E119, \"À risque (J-7)\", IF($H119=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H119<100, $E119<>\"\" , $E119<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D120=\"\",\"\",$D120)","v":0},{"$f":"IF(OR($D120=\"\",$E120=\"\"),\"\", $E120-$D120+1)","v":0},{"$f":"IF($F120=\"\",\"\",$F120)","v":0},{"$f":"IF(OR($F120=\"\",$G120=\"\"),\"\", $G120-$F120+1)","v":0},{"$f":"IF($E120=\"\", \"\", MAX(0, $E120-TODAY()+1))","v":0},{"$f":"IF($G120<>\"\", IF($G120<=$E120, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E120, \"En retard\", IF(TODAY()+7>=$E120, \"À risque (J-7)\", IF($H120=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H120<100, $E120<>\"\" , $E120<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D121=\"\",\"\",$D121)","v":0},{"$f":"IF(OR($D121=\"\",$E121=\"\"),\"\", $E121-$D121+1)","v":0},{"$f":"IF($F121=\"\",\"\",$F121)","v":0},{"$f":"IF(OR($F121=\"\",$G121=\"\"),\"\", $G121-$F121+1)","v":0},{"$f":"IF($E121=\"\", \"\", MAX(0, $E121-TODAY()+1))","v":0},{"$f":"IF($G121<>\"\", IF($G121<=$E121, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E121, \"En retard\", IF(TODAY()+7>=$E121, \"À risque (J-7)\", IF($H121=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H121<100, $E121<>\"\" , $E121<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D122=\"\",\"\",$D122)","v":0},{"$f":"IF(OR($D122=\"\",$E122=\"\"),\"\", $E122-$D122+1)","v":0},{"$f":"IF($F122=\"\",\"\",$F122)","v":0},{"$f":"IF(OR($F122=\"\",$G122=\"\"),\"\", $G122-$F122+1)","v":0},{"$f":"IF($E122=\"\", \"\", MAX(0, $E122-TODAY()+1))","v":0},{"$f":"IF($G122<>\"\", IF($G122<=$E122, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E122, \"En retard\", IF(TODAY()+7>=$E122, \"À risque (J-7)\", IF($H122=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H122<100, $E122<>\"\" , $E122<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D123=\"\",\"\",$D123)","v":0},{"$f":"IF(OR($D123=\"\",$E123=\"\"),\"\", $E123-$D123+1)","v":0},{"$f":"IF($F123=\"\",\"\",$F123)","v":0},{"$f":"IF(OR($F123=\"\",$G123=\"\"),\"\", $G123-$F123+1)","v":0},{"$f":"IF($E123=\"\", \"\", MAX(0, $E123-TODAY()+1))","v":0},{"$f":"IF($G123<>\"\", IF($G123<=$E123, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E123, \"En retard\", IF(TODAY()+7>=$E123, \"À risque (J-7)\", IF($H123=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H123<100, $E123<>\"\" , $E123<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D124=\"\",\"\",$D124)","v":0},{"$f":"IF(OR($D124=\"\",$E124=\"\"),\"\", $E124-$D124+1)","v":0},{"$f":"IF($F124=\"\",\"\",$F124)","v":0},{"$f":"IF(OR($F124=\"\",$G124=\"\"),\"\", $G124-$F124+1)","v":0},{"$f":"IF($E124=\"\", \"\", MAX(0, $E124-TODAY()+1))","v":0},{"$f":"IF($G124<>\"\", IF($G124<=$E124, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E124, \"En retard\", IF(TODAY()+7>=$E124, \"À risque (J-7)\", IF($H124=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H124<100, $E124<>\"\" , $E124<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D125=\"\",\"\",$D125)","v":0},{"$f":"IF(OR($D125=\"\",$E125=\"\"),\"\", $E125-$D125+1)","v":0},{"$f":"IF($F125=\"\",\"\",$F125)","v":0},{"$f":"IF(OR($F125=\"\",$G125=\"\"),\"\", $G125-$F125+1)","v":0},{"$f":"IF($E125=\"\", \"\", MAX(0, $E125-TODAY()+1))","v":0},{"$f":"IF($G125<>\"\", IF($G125<=$E125, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E125, \"En retard\", IF(TODAY()+7>=$E125, \"À risque (J-7)\", IF($H125=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H125<100, $E125<>\"\" , $E125<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D126=\"\",\"\",$D126)","v":0},{"$f":"IF(OR($D126=\"\",$E126=\"\"),\"\", $E126-$D126+1)","v":0},{"$f":"IF($F126=\"\",\"\",$F126)","v":0},{"$f":"IF(OR($F126=\"\",$G126=\"\"),\"\", $G126-$F126+1)","v":0},{"$f":"IF($E126=\"\", \"\", MAX(0, $E126-TODAY()+1))","v":0},{"$f":"IF($G126<>\"\", IF($G126<=$E126, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E126, \"En retard\", IF(TODAY()+7>=$E126, \"À risque (J-7)\", IF($H126=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H126<100, $E126<>\"\" , $E126<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D127=\"\",\"\",$D127)","v":0},{"$f":"IF(OR($D127=\"\",$E127=\"\"),\"\", $E127-$D127+1)","v":0},{"$f":"IF($F127=\"\",\"\",$F127)","v":0},{"$f":"IF(OR($F127=\"\",$G127=\"\"),\"\", $G127-$F127+1)","v":0},{"$f":"IF($E127=\"\", \"\", MAX(0, $E127-TODAY()+1))","v":0},{"$f":"IF($G127<>\"\", IF($G127<=$E127, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E127, \"En retard\", IF(TODAY()+7>=$E127, \"À risque (J-7)\", IF($H127=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H127<100, $E127<>\"\" , $E127<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D128=\"\",\"\",$D128)","v":0},{"$f":"IF(OR($D128=\"\",$E128=\"\"),\"\", $E128-$D128+1)","v":0},{"$f":"IF($F128=\"\",\"\",$F128)","v":0},{"$f":"IF(OR($F128=\"\",$G128=\"\"),\"\", $G128-$F128+1)","v":0},{"$f":"IF($E128=\"\", \"\", MAX(0, $E128-TODAY()+1))","v":0},{"$f":"IF($G128<>\"\", IF($G128<=$E128, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E128, \"En retard\", IF(TODAY()+7>=$E128, \"À risque (J-7)\", IF($H128=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H128<100, $E128<>\"\" , $E128<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D129=\"\",\"\",$D129)","v":0},{"$f":"IF(OR($D129=\"\",$E129=\"\"),\"\", $E129-$D129+1)","v":0},{"$f":"IF($F129=\"\",\"\",$F129)","v":0},{"$f":"IF(OR($F129=\"\",$G129=\"\"),\"\", $G129-$F129+1)","v":0},{"$f":"IF($E129=\"\", \"\", MAX(0, $E129-TODAY()+1))","v":0},{"$f":"IF($G129<>\"\", IF($G129<=$E129, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E129, \"En retard\", IF(TODAY()+7>=$E129, \"À risque (J-7)\", IF($H129=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H129<100, $E129<>\"\" , $E129<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D130=\"\",\"\",$D130)","v":0},{"$f":"IF(OR($D130=\"\",$E130=\"\"),\"\", $E130-$D130+1)","v":0},{"$f":"IF($F130=\"\",\"\",$F130)","v":0},{"$f":"IF(OR($F130=\"\",$G130=\"\"),\"\", $G130-$F130+1)","v":0},{"$f":"IF($E130=\"\", \"\", MAX(0, $E130-TODAY()+1))","v":0},{"$f":"IF($G130<>\"\", IF($G130<=$E130, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E130, \"En retard\", IF(TODAY()+7>=$E130, \"À risque (J-7)\", IF($H130=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H130<100, $E130<>\"\" , $E130<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D131=\"\",\"\",$D131)","v":0},{"$f":"IF(OR($D131=\"\",$E131=\"\"),\"\", $E131-$D131+1)","v":0},{"$f":"IF($F131=\"\",\"\",$F131)","v":0},{"$f":"IF(OR($F131=\"\",$G131=\"\"),\"\", $G131-$F131+1)","v":0},{"$f":"IF($E131=\"\", \"\", MAX(0, $E131-TODAY()+1))","v":0},{"$f":"IF($G131<>\"\", IF($G131<=$E131, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E131, \"En retard\", IF(TODAY()+7>=$E131, \"À risque (J-7)\", IF($H131=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H131<100, $E131<>\"\" , $E131<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D132=\"\",\"\",$D132)","v":0},{"$f":"IF(OR($D132=\"\",$E132=\"\"),\"\", $E132-$D132+1)","v":0},{"$f":"IF($F132=\"\",\"\",$F132)","v":0},{"$f":"IF(OR($F132=\"\",$G132=\"\"),\"\", $G132-$F132+1)","v":0},{"$f":"IF($E132=\"\", \"\", MAX(0, $E132-TODAY()+1))","v":0},{"$f":"IF($G132<>\"\", IF($G132<=$E132, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E132, \"En retard\", IF(TODAY()+7>=$E132, \"À risque (J-7)\", IF($H132=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H132<100, $E132<>\"\" , $E132<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D133=\"\",\"\",$D133)","v":0},{"$f":"IF(OR($D133=\"\",$E133=\"\"),\"\", $E133-$D133+1)","v":0},{"$f":"IF($F133=\"\",\"\",$F133)","v":0},{"$f":"IF(OR($F133=\"\",$G133=\"\"),\"\", $G133-$F133+1)","v":0},{"$f":"IF($E133=\"\", \"\", MAX(0, $E133-TODAY()+1))","v":0},{"$f":"IF($G133<>\"\", IF($G133<=$E133, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E133, \"En retard\", IF(TODAY()+7>=$E133, \"À risque (J-7)\", IF($H133=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H133<100, $E133<>\"\" , $E133<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D134=\"\",\"\",$D134)","v":0},{"$f":"IF(OR($D134=\"\",$E134=\"\"),\"\", $E134-$D134+1)","v":0},{"$f":"IF($F134=\"\",\"\",$F134)","v":0},{"$f":"IF(OR($F134=\"\",$G134=\"\"),\"\", $G134-$F134+1)","v":0},{"$f":"IF($E134=\"\", \"\", MAX(0, $E134-TODAY()+1))","v":0},{"$f":"IF($G134<>\"\", IF($G134<=$E134, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E134, \"En retard\", IF(TODAY()+7>=$E134, \"À risque (J-7)\", IF($H134=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H134<100, $E134<>\"\" , $E134<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D135=\"\",\"\",$D135)","v":0},{"$f":"IF(OR($D135=\"\",$E135=\"\"),\"\", $E135-$D135+1)","v":0},{"$f":"IF($F135=\"\",\"\",$F135)","v":0},{"$f":"IF(OR($F135=\"\",$G135=\"\"),\"\", $G135-$F135+1)","v":0},{"$f":"IF($E135=\"\", \"\", MAX(0, $E135-TODAY()+1))","v":0},{"$f":"IF($G135<>\"\", IF($G135<=$E135, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E135, \"En retard\", IF(TODAY()+7>=$E135, \"À risque (J-7)\", IF($H135=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H135<100, $E135<>\"\" , $E135<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D136=\"\",\"\",$D136)","v":0},{"$f":"IF(OR($D136=\"\",$E136=\"\"),\"\", $E136-$D136+1)","v":0},{"$f":"IF($F136=\"\",\"\",$F136)","v":0},{"$f":"IF(OR($F136=\"\",$G136=\"\"),\"\", $G136-$F136+1)","v":0},{"$f":"IF($E136=\"\", \"\", MAX(0, $E136-TODAY()+1))","v":0},{"$f":"IF($G136<>\"\", IF($G136<=$E136, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E136, \"En retard\", IF(TODAY()+7>=$E136, \"À risque (J-7)\", IF($H136=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H136<100, $E136<>\"\" , $E136<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D137=\"\",\"\",$D137)","v":0},{"$f":"IF(OR($D137=\"\",$E137=\"\"),\"\", $E137-$D137+1)","v":0},{"$f":"IF($F137=\"\",\"\",$F137)","v":0},{"$f":"IF(OR($F137=\"\",$G137=\"\"),\"\", $G137-$F137+1)","v":0},{"$f":"IF($E137=\"\", \"\", MAX(0, $E137-TODAY()+1))","v":0},{"$f":"IF($G137<>\"\", IF($G137<=$E137, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E137, \"En retard\", IF(TODAY()+7>=$E137, \"À risque (J-7)\", IF($H137=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H137<100, $E137<>\"\" , $E137<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D138=\"\",\"\",$D138)","v":0},{"$f":"IF(OR($D138=\"\",$E138=\"\"),\"\", $E138-$D138+1)","v":0},{"$f":"IF($F138=\"\",\"\",$F138)","v":0},{"$f":"IF(OR($F138=\"\",$G138=\"\"),\"\", $G138-$F138+1)","v":0},{"$f":"IF($E138=\"\", \"\", MAX(0, $E138-TODAY()+1))","v":0},{"$f":"IF($G138<>\"\", IF($G138<=$E138, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E138, \"En retard\", IF(TODAY()+7>=$E138, \"À risque (J-7)\", IF($H138=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H138<100, $E138<>\"\" , $E138<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D139=\"\",\"\",$D139)","v":0},{"$f":"IF(OR($D139=\"\",$E139=\"\"),\"\", $E139-$D139+1)","v":0},{"$f":"IF($F139=\"\",\"\",$F139)","v":0},{"$f":"IF(OR($F139=\"\",$G139=\"\"),\"\", $G139-$F139+1)","v":0},{"$f":"IF($E139=\"\", \"\", MAX(0, $E139-TODAY()+1))","v":0},{"$f":"IF($G139<>\"\", IF($G139<=$E139, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E139, \"En retard\", IF(TODAY()+7>=$E139, \"À risque (J-7)\", IF($H139=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H139<100, $E139<>\"\" , $E139<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D140=\"\",\"\",$D140)","v":0},{"$f":"IF(OR($D140=\"\",$E140=\"\"),\"\", $E140-$D140+1)","v":0},{"$f":"IF($F140=\"\",\"\",$F140)","v":0},{"$f":"IF(OR($F140=\"\",$G140=\"\"),\"\", $G140-$F140+1)","v":0},{"$f":"IF($E140=\"\", \"\", MAX(0, $E140-TODAY()+1))","v":0},{"$f":"IF($G140<>\"\", IF($G140<=$E140, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E140, \"En retard\", IF(TODAY()+7>=$E140, \"À risque (J-7)\", IF($H140=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H140<100, $E140<>\"\" , $E140<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D141=\"\",\"\",$D141)","v":0},{"$f":"IF(OR($D141=\"\",$E141=\"\"),\"\", $E141-$D141+1)","v":0},{"$f":"IF($F141=\"\",\"\",$F141)","v":0},{"$f":"IF(OR($F141=\"\",$G141=\"\"),\"\", $G141-$F141+1)","v":0},{"$f":"IF($E141=\"\", \"\", MAX(0, $E141-TODAY()+1))","v":0},{"$f":"IF($G141<>\"\", IF($G141<=$E141, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E141, \"En retard\", IF(TODAY()+7>=$E141, \"À risque (J-7)\", IF($H141=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H141<100, $E141<>\"\" , $E141<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D142=\"\",\"\",$D142)","v":0},{"$f":"IF(OR($D142=\"\",$E142=\"\"),\"\", $E142-$D142+1)","v":0},{"$f":"IF($F142=\"\",\"\",$F142)","v":0},{"$f":"IF(OR($F142=\"\",$G142=\"\"),\"\", $G142-$F142+1)","v":0},{"$f":"IF($E142=\"\", \"\", MAX(0, $E142-TODAY()+1))","v":0},{"$f":"IF($G142<>\"\", IF($G142<=$E142, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E142, \"En retard\", IF(TODAY()+7>=$E142, \"À risque (J-7)\", IF($H142=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H142<100, $E142<>\"\" , $E142<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D143=\"\",\"\",$D143)","v":0},{"$f":"IF(OR($D143=\"\",$E143=\"\"),\"\", $E143-$D143+1)","v":0},{"$f":"IF($F143=\"\",\"\",$F143)","v":0},{"$f":"IF(OR($F143=\"\",$G143=\"\"),\"\", $G143-$F143+1)","v":0},{"$f":"IF($E143=\"\", \"\", MAX(0, $E143-TODAY()+1))","v":0},{"$f":"IF($G143<>\"\", IF($G143<=$E143, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E143, \"En retard\", IF(TODAY()+7>=$E143, \"À risque (J-7)\", IF($H143=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H143<100, $E143<>\"\" , $E143<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D144=\"\",\"\",$D144)","v":0},{"$f":"IF(OR($D144=\"\",$E144=\"\"),\"\", $E144-$D144+1)","v":0},{"$f":"IF($F144=\"\",\"\",$F144)","v":0},{"$f":"IF(OR($F144=\"\",$G144=\"\"),\"\", $G144-$F144+1)","v":0},{"$f":"IF($E144=\"\", \"\", MAX(0, $E144-TODAY()+1))","v":0},{"$f":"IF($G144<>\"\", IF($G144<=$E144, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E144, \"En retard\", IF(TODAY()+7>=$E144, \"À risque (J-7)\", IF($H144=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H144<100, $E144<>\"\" , $E144<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D145=\"\",\"\",$D145)","v":0},{"$f":"IF(OR($D145=\"\",$E145=\"\"),\"\", $E145-$D145+1)","v":0},{"$f":"IF($F145=\"\",\"\",$F145)","v":0},{"$f":"IF(OR($F145=\"\",$G145=\"\"),\"\", $G145-$F145+1)","v":0},{"$f":"IF($E145=\"\", \"\", MAX(0, $E145-TODAY()+1))","v":0},{"$f":"IF($G145<>\"\", IF($G145<=$E145, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E145, \"En retard\", IF(TODAY()+7>=$E145, \"À risque (J-7)\", IF($H145=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H145<100, $E145<>\"\" , $E145<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D146=\"\",\"\",$D146)","v":0},{"$f":"IF(OR($D146=\"\",$E146=\"\"),\"\", $E146-$D146+1)","v":0},{"$f":"IF($F146=\"\",\"\",$F146)","v":0},{"$f":"IF(OR($F146=\"\",$G146=\"\"),\"\", $G146-$F146+1)","v":0},{"$f":"IF($E146=\"\", \"\", MAX(0, $E146-TODAY()+1))","v":0},{"$f":"IF($G146<>\"\", IF($G146<=$E146, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E146, \"En retard\", IF(TODAY()+7>=$E146, \"À risque (J-7)\", IF($H146=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H146<100, $E146<>\"\" , $E146<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D147=\"\",\"\",$D147)","v":0},{"$f":"IF(OR($D147=\"\",$E147=\"\"),\"\", $E147-$D147+1)","v":0},{"$f":"IF($F147=\"\",\"\",$F147)","v":0},{"$f":"IF(OR($F147=\"\",$G147=\"\"),\"\", $G147-$F147+1)","v":0},{"$f":"IF($E147=\"\", \"\", MAX(0, $E147-TODAY()+1))","v":0},{"$f":"IF($G147<>\"\", IF($G147<=$E147, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E147, \"En retard\", IF(TODAY()+7>=$E147, \"À risque (J-7)\", IF($H147=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H147<100, $E147<>\"\" , $E147<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D148=\"\",\"\",$D148)","v":0},{"$f":"IF(OR($D148=\"\",$E148=\"\"),\"\", $E148-$D148+1)","v":0},{"$f":"IF($F148=\"\",\"\",$F148)","v":0},{"$f":"IF(OR($F148=\"\",$G148=\"\"),\"\", $G148-$F148+1)","v":0},{"$f":"IF($E148=\"\", \"\", MAX(0, $E148-TODAY()+1))","v":0},{"$f":"IF($G148<>\"\", IF($G148<=$E148, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E148, \"En retard\", IF(TODAY()+7>=$E148, \"À risque (J-7)\", IF($H148=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H148<100, $E148<>\"\" , $E148<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D149=\"\",\"\",$D149)","v":0},{"$f":"IF(OR($D149=\"\",$E149=\"\"),\"\", $E149-$D149+1)","v":0},{"$f":"IF($F149=\"\",\"\",$F149)","v":0},{"$f":"IF(OR($F149=\"\",$G149=\"\"),\"\", $G149-$F149+1)","v":0},{"$f":"IF($E149=\"\", \"\", MAX(0, $E149-TODAY()+1))","v":0},{"$f":"IF($G149<>\"\", IF($G149<=$E149, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E149, \"En retard\", IF(TODAY()+7>=$E149, \"À risque (J-7)\", IF($H149=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H149<100, $E149<>\"\" , $E149<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D150=\"\",\"\",$D150)","v":0},{"$f":"IF(OR($D150=\"\",$E150=\"\"),\"\", $E150-$D150+1)","v":0},{"$f":"IF($F150=\"\",\"\",$F150)","v":0},{"$f":"IF(OR($F150=\"\",$G150=\"\"),\"\", $G150-$F150+1)","v":0},{"$f":"IF($E150=\"\", \"\", MAX(0, $E150-TODAY()+1))","v":0},{"$f":"IF($G150<>\"\", IF($G150<=$E150, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E150, \"En retard\", IF(TODAY()+7>=$E150, \"À risque (J-7)\", IF($H150=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H150<100, $E150<>\"\" , $E150<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D151=\"\",\"\",$D151)","v":0},{"$f":"IF(OR($D151=\"\",$E151=\"\"),\"\", $E151-$D151+1)","v":0},{"$f":"IF($F151=\"\",\"\",$F151)","v":0},{"$f":"IF(OR($F151=\"\",$G151=\"\"),\"\", $G151-$F151+1)","v":0},{"$f":"IF($E151=\"\", \"\", MAX(0, $E151-TODAY()+1))","v":0},{"$f":"IF($G151<>\"\", IF($G151<=$E151, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E151, \"En retard\", IF(TODAY()+7>=$E151, \"À risque (J-7)\", IF($H151=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H151<100, $E151<>\"\" , $E151<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D152=\"\",\"\",$D152)","v":0},{"$f":"IF(OR($D152=\"\",$E152=\"\"),\"\", $E152-$D152+1)","v":0},{"$f":"IF($F152=\"\",\"\",$F152)","v":0},{"$f":"IF(OR($F152=\"\",$G152=\"\"),\"\", $G152-$F152+1)","v":0},{"$f":"IF($E152=\"\", \"\", MAX(0, $E152-TODAY()+1))","v":0},{"$f":"IF($G152<>\"\", IF($G152<=$E152, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E152, \"En retard\", IF(TODAY()+7>=$E152, \"À risque (J-7)\", IF($H152=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H152<100, $E152<>\"\" , $E152<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D153=\"\",\"\",$D153)","v":0},{"$f":"IF(OR($D153=\"\",$E153=\"\"),\"\", $E153-$D153+1)","v":0},{"$f":"IF($F153=\"\",\"\",$F153)","v":0},{"$f":"IF(OR($F153=\"\",$G153=\"\"),\"\", $G153-$F153+1)","v":0},{"$f":"IF($E153=\"\", \"\", MAX(0, $E153-TODAY()+1))","v":0},{"$f":"IF($G153<>\"\", IF($G153<=$E153, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E153, \"En retard\", IF(TODAY()+7>=$E153, \"À risque (J-7)\", IF($H153=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H153<100, $E153<>\"\" , $E153<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D154=\"\",\"\",$D154)","v":0},{"$f":"IF(OR($D154=\"\",$E154=\"\"),\"\", $E154-$D154+1)","v":0},{"$f":"IF($F154=\"\",\"\",$F154)","v":0},{"$f":"IF(OR($F154=\"\",$G154=\"\"),\"\", $G154-$F154+1)","v":0},{"$f":"IF($E154=\"\", \"\", MAX(0, $E154-TODAY()+1))","v":0},{"$f":"IF($G154<>\"\", IF($G154<=$E154, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E154, \"En retard\", IF(TODAY()+7>=$E154, \"À risque (J-7)\", IF($H154=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H154<100, $E154<>\"\" , $E154<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D155=\"\",\"\",$D155)","v":0},{"$f":"IF(OR($D155=\"\",$E155=\"\"),\"\", $E155-$D155+1)","v":0},{"$f":"IF($F155=\"\",\"\",$F155)","v":0},{"$f":"IF(OR($F155=\"\",$G155=\"\"),\"\", $G155-$F155+1)","v":0},{"$f":"IF($E155=\"\", \"\", MAX(0, $E155-TODAY()+1))","v":0},{"$f":"IF($G155<>\"\", IF($G155<=$E155, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E155, \"En retard\", IF(TODAY()+7>=$E155, \"À risque (J-7)\", IF($H155=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H155<100, $E155<>\"\" , $E155<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D156=\"\",\"\",$D156)","v":0},{"$f":"IF(OR($D156=\"\",$E156=\"\"),\"\", $E156-$D156+1)","v":0},{"$f":"IF($F156=\"\",\"\",$F156)","v":0},{"$f":"IF(OR($F156=\"\",$G156=\"\"),\"\", $G156-$F156+1)","v":0},{"$f":"IF($E156=\"\", \"\", MAX(0, $E156-TODAY()+1))","v":0},{"$f":"IF($G156<>\"\", IF($G156<=$E156, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E156, \"En retard\", IF(TODAY()+7>=$E156, \"À risque (J-7)\", IF($H156=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H156<100, $E156<>\"\" , $E156<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D157=\"\",\"\",$D157)","v":0},{"$f":"IF(OR($D157=\"\",$E157=\"\"),\"\", $E157-$D157+1)","v":0},{"$f":"IF($F157=\"\",\"\",$F157)","v":0},{"$f":"IF(OR($F157=\"\",$G157=\"\"),\"\", $G157-$F157+1)","v":0},{"$f":"IF($E157=\"\", \"\", MAX(0, $E157-TODAY()+1))","v":0},{"$f":"IF($G157<>\"\", IF($G157<=$E157, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E157, \"En retard\", IF(TODAY()+7>=$E157, \"À risque (J-7)\", IF($H157=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H157<100, $E157<>\"\" , $E157<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D158=\"\",\"\",$D158)","v":0},{"$f":"IF(OR($D158=\"\",$E158=\"\"),\"\", $E158-$D158+1)","v":0},{"$f":"IF($F158=\"\",\"\",$F158)","v":0},{"$f":"IF(OR($F158=\"\",$G158=\"\"),\"\", $G158-$F158+1)","v":0},{"$f":"IF($E158=\"\", \"\", MAX(0, $E158-TODAY()+1))","v":0},{"$f":"IF($G158<>\"\", IF($G158<=$E158, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E158, \"En retard\", IF(TODAY()+7>=$E158, \"À risque (J-7)\", IF($H158=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H158<100, $E158<>\"\" , $E158<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D159=\"\",\"\",$D159)","v":0},{"$f":"IF(OR($D159=\"\",$E159=\"\"),\"\", $E159-$D159+1)","v":0},{"$f":"IF($F159=\"\",\"\",$F159)","v":0},{"$f":"IF(OR($F159=\"\",$G159=\"\"),\"\", $G159-$F159+1)","v":0},{"$f":"IF($E159=\"\", \"\", MAX(0, $E159-TODAY()+1))","v":0},{"$f":"IF($G159<>\"\", IF($G159<=$E159, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E159, \"En retard\", IF(TODAY()+7>=$E159, \"À risque (J-7)\", IF($H159=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H159<100, $E159<>\"\" , $E159<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D160=\"\",\"\",$D160)","v":0},{"$f":"IF(OR($D160=\"\",$E160=\"\"),\"\", $E160-$D160+1)","v":0},{"$f":"IF($F160=\"\",\"\",$F160)","v":0},{"$f":"IF(OR($F160=\"\",$G160=\"\"),\"\", $G160-$F160+1)","v":0},{"$f":"IF($E160=\"\", \"\", MAX(0, $E160-TODAY()+1))","v":0},{"$f":"IF($G160<>\"\", IF($G160<=$E160, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E160, \"En retard\", IF(TODAY()+7>=$E160, \"À risque (J-7)\", IF($H160=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H160<100, $E160<>\"\" , $E160<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D161=\"\",\"\",$D161)","v":0},{"$f":"IF(OR($D161=\"\",$E161=\"\"),\"\", $E161-$D161+1)","v":0},{"$f":"IF($F161=\"\",\"\",$F161)","v":0},{"$f":"IF(OR($F161=\"\",$G161=\"\"),\"\", $G161-$F161+1)","v":0},{"$f":"IF($E161=\"\", \"\", MAX(0, $E161-TODAY()+1))","v":0},{"$f":"IF($G161<>\"\", IF($G161<=$E161, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E161, \"En retard\", IF(TODAY()+7>=$E161, \"À risque (J-7)\", IF($H161=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H161<100, $E161<>\"\" , $E161<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D162=\"\",\"\",$D162)","v":0},{"$f":"IF(OR($D162=\"\",$E162=\"\"),\"\", $E162-$D162+1)","v":0},{"$f":"IF($F162=\"\",\"\",$F162)","v":0},{"$f":"IF(OR($F162=\"\",$G162=\"\"),\"\", $G162-$F162+1)","v":0},{"$f":"IF($E162=\"\", \"\", MAX(0, $E162-TODAY()+1))","v":0},{"$f":"IF($G162<>\"\", IF($G162<=$E162, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E162, \"En retard\", IF(TODAY()+7>=$E162, \"À risque (J-7)\", IF($H162=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H162<100, $E162<>\"\" , $E162<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D163=\"\",\"\",$D163)","v":0},{"$f":"IF(OR($D163=\"\",$E163=\"\"),\"\", $E163-$D163+1)","v":0},{"$f":"IF($F163=\"\",\"\",$F163)","v":0},{"$f":"IF(OR($F163=\"\",$G163=\"\"),\"\", $G163-$F163+1)","v":0},{"$f":"IF($E163=\"\", \"\", MAX(0, $E163-TODAY()+1))","v":0},{"$f":"IF($G163<>\"\", IF($G163<=$E163, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E163, \"En retard\", IF(TODAY()+7>=$E163, \"À risque (J-7)\", IF($H163=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H163<100, $E163<>\"\" , $E163<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D164=\"\",\"\",$D164)","v":0},{"$f":"IF(OR($D164=\"\",$E164=\"\"),\"\", $E164-$D164+1)","v":0},{"$f":"IF($F164=\"\",\"\",$F164)","v":0},{"$f":"IF(OR($F164=\"\",$G164=\"\"),\"\", $G164-$F164+1)","v":0},{"$f":"IF($E164=\"\", \"\", MAX(0, $E164-TODAY()+1))","v":0},{"$f":"IF($G164<>\"\", IF($G164<=$E164, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E164, \"En retard\", IF(TODAY()+7>=$E164, \"À risque (J-7)\", IF($H164=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H164<100, $E164<>\"\" , $E164<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D165=\"\",\"\",$D165)","v":0},{"$f":"IF(OR($D165=\"\",$E165=\"\"),\"\", $E165-$D165+1)","v":0},{"$f":"IF($F165=\"\",\"\",$F165)","v":0},{"$f":"IF(OR($F165=\"\",$G165=\"\"),\"\", $G165-$F165+1)","v":0},{"$f":"IF($E165=\"\", \"\", MAX(0, $E165-TODAY()+1))","v":0},{"$f":"IF($G165<>\"\", IF($G165<=$E165, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E165, \"En retard\", IF(TODAY()+7>=$E165, \"À risque (J-7)\", IF($H165=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H165<100, $E165<>\"\" , $E165<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D166=\"\",\"\",$D166)","v":0},{"$f":"IF(OR($D166=\"\",$E166=\"\"),\"\", $E166-$D166+1)","v":0},{"$f":"IF($F166=\"\",\"\",$F166)","v":0},{"$f":"IF(OR($F166=\"\",$G166=\"\"),\"\", $G166-$F166+1)","v":0},{"$f":"IF($E166=\"\", \"\", MAX(0, $E166-TODAY()+1))","v":0},{"$f":"IF($G166<>\"\", IF($G166<=$E166, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E166, \"En retard\", IF(TODAY()+7>=$E166, \"À risque (J-7)\", IF($H166=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H166<100, $E166<>\"\" , $E166<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D167=\"\",\"\",$D167)","v":0},{"$f":"IF(OR($D167=\"\",$E167=\"\"),\"\", $E167-$D167+1)","v":0},{"$f":"IF($F167=\"\",\"\",$F167)","v":0},{"$f":"IF(OR($F167=\"\",$G167=\"\"),\"\", $G167-$F167+1)","v":0},{"$f":"IF($E167=\"\", \"\", MAX(0, $E167-TODAY()+1))","v":0},{"$f":"IF($G167<>\"\", IF($G167<=$E167, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E167, \"En retard\", IF(TODAY()+7>=$E167, \"À risque (J-7)\", IF($H167=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H167<100, $E167<>\"\" , $E167<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D168=\"\",\"\",$D168)","v":0},{"$f":"IF(OR($D168=\"\",$E168=\"\"),\"\", $E168-$D168+1)","v":0},{"$f":"IF($F168=\"\",\"\",$F168)","v":0},{"$f":"IF(OR($F168=\"\",$G168=\"\"),\"\", $G168-$F168+1)","v":0},{"$f":"IF($E168=\"\", \"\", MAX(0, $E168-TODAY()+1))","v":0},{"$f":"IF($G168<>\"\", IF($G168<=$E168, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E168, \"En retard\", IF(TODAY()+7>=$E168, \"À risque (J-7)\", IF($H168=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H168<100, $E168<>\"\" , $E168<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D169=\"\",\"\",$D169)","v":0},{"$f":"IF(OR($D169=\"\",$E169=\"\"),\"\", $E169-$D169+1)","v":0},{"$f":"IF($F169=\"\",\"\",$F169)","v":0},{"$f":"IF(OR($F169=\"\",$G169=\"\"),\"\", $G169-$F169+1)","v":0},{"$f":"IF($E169=\"\", \"\", MAX(0, $E169-TODAY()+1))","v":0},{"$f":"IF($G169<>\"\", IF($G169<=$E169, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E169, \"En retard\", IF(TODAY()+7>=$E169, \"À risque (J-7)\", IF($H169=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H169<100, $E169<>\"\" , $E169<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D170=\"\",\"\",$D170)","v":0},{"$f":"IF(OR($D170=\"\",$E170=\"\"),\"\", $E170-$D170+1)","v":0},{"$f":"IF($F170=\"\",\"\",$F170)","v":0},{"$f":"IF(OR($F170=\"\",$G170=\"\"),\"\", $G170-$F170+1)","v":0},{"$f":"IF($E170=\"\", \"\", MAX(0, $E170-TODAY()+1))","v":0},{"$f":"IF($G170<>\"\", IF($G170<=$E170, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E170, \"En retard\", IF(TODAY()+7>=$E170, \"À risque (J-7)\", IF($H170=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H170<100, $E170<>\"\" , $E170<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D171=\"\",\"\",$D171)","v":0},{"$f":"IF(OR($D171=\"\",$E171=\"\"),\"\", $E171-$D171+1)","v":0},{"$f":"IF($F171=\"\",\"\",$F171)","v":0},{"$f":"IF(OR($F171=\"\",$G171=\"\"),\"\", $G171-$F171+1)","v":0},{"$f":"IF($E171=\"\", \"\", MAX(0, $E171-TODAY()+1))","v":0},{"$f":"IF($G171<>\"\", IF($G171<=$E171, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E171, \"En retard\", IF(TODAY()+7>=$E171, \"À risque (J-7)\", IF($H171=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H171<100, $E171<>\"\" , $E171<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D172=\"\",\"\",$D172)","v":0},{"$f":"IF(OR($D172=\"\",$E172=\"\"),\"\", $E172-$D172+1)","v":0},{"$f":"IF($F172=\"\",\"\",$F172)","v":0},{"$f":"IF(OR($F172=\"\",$G172=\"\"),\"\", $G172-$F172+1)","v":0},{"$f":"IF($E172=\"\", \"\", MAX(0, $E172-TODAY()+1))","v":0},{"$f":"IF($G172<>\"\", IF($G172<=$E172, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E172, \"En retard\", IF(TODAY()+7>=$E172, \"À risque (J-7)\", IF($H172=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H172<100, $E172<>\"\" , $E172<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D173=\"\",\"\",$D173)","v":0},{"$f":"IF(OR($D173=\"\",$E173=\"\"),\"\", $E173-$D173+1)","v":0},{"$f":"IF($F173=\"\",\"\",$F173)","v":0},{"$f":"IF(OR($F173=\"\",$G173=\"\"),\"\", $G173-$F173+1)","v":0},{"$f":"IF($E173=\"\", \"\", MAX(0, $E173-TODAY()+1))","v":0},{"$f":"IF($G173<>\"\", IF($G173<=$E173, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E173, \"En retard\", IF(TODAY()+7>=$E173, \"À risque (J-7)\", IF($H173=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H173<100, $E173<>\"\" , $E173<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D174=\"\",\"\",$D174)","v":0},{"$f":"IF(OR($D174=\"\",$E174=\"\"),\"\", $E174-$D174+1)","v":0},{"$f":"IF($F174=\"\",\"\",$F174)","v":0},{"$f":"IF(OR($F174=\"\",$G174=\"\"),\"\", $G174-$F174+1)","v":0},{"$f":"IF($E174=\"\", \"\", MAX(0, $E174-TODAY()+1))","v":0},{"$f":"IF($G174<>\"\", IF($G174<=$E174, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E174, \"En retard\", IF(TODAY()+7>=$E174, \"À risque (J-7)\", IF($H174=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H174<100, $E174<>\"\" , $E174<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D175=\"\",\"\",$D175)","v":0},{"$f":"IF(OR($D175=\"\",$E175=\"\"),\"\", $E175-$D175+1)","v":0},{"$f":"IF($F175=\"\",\"\",$F175)","v":0},{"$f":"IF(OR($F175=\"\",$G175=\"\"),\"\", $G175-$F175+1)","v":0},{"$f":"IF($E175=\"\", \"\", MAX(0, $E175-TODAY()+1))","v":0},{"$f":"IF($G175<>\"\", IF($G175<=$E175, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E175, \"En retard\", IF(TODAY()+7>=$E175, \"À risque (J-7)\", IF($H175=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H175<100, $E175<>\"\" , $E175<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D176=\"\",\"\",$D176)","v":0},{"$f":"IF(OR($D176=\"\",$E176=\"\"),\"\", $E176-$D176+1)","v":0},{"$f":"IF($F176=\"\",\"\",$F176)","v":0},{"$f":"IF(OR($F176=\"\",$G176=\"\"),\"\", $G176-$F176+1)","v":0},{"$f":"IF($E176=\"\", \"\", MAX(0, $E176-TODAY()+1))","v":0},{"$f":"IF($G176<>\"\", IF($G176<=$E176, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E176, \"En retard\", IF(TODAY()+7>=$E176, \"À risque (J-7)\", IF($H176=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H176<100, $E176<>\"\" , $E176<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D177=\"\",\"\",$D177)","v":0},{"$f":"IF(OR($D177=\"\",$E177=\"\"),\"\", $E177-$D177+1)","v":0},{"$f":"IF($F177=\"\",\"\",$F177)","v":0},{"$f":"IF(OR($F177=\"\",$G177=\"\"),\"\", $G177-$F177+1)","v":0},{"$f":"IF($E177=\"\", \"\", MAX(0, $E177-TODAY()+1))","v":0},{"$f":"IF($G177<>\"\", IF($G177<=$E177, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E177, \"En retard\", IF(TODAY()+7>=$E177, \"À risque (J-7)\", IF($H177=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H177<100, $E177<>\"\" , $E177<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D178=\"\",\"\",$D178)","v":0},{"$f":"IF(OR($D178=\"\",$E178=\"\"),\"\", $E178-$D178+1)","v":0},{"$f":"IF($F178=\"\",\"\",$F178)","v":0},{"$f":"IF(OR($F178=\"\",$G178=\"\"),\"\", $G178-$F178+1)","v":0},{"$f":"IF($E178=\"\", \"\", MAX(0, $E178-TODAY()+1))","v":0},{"$f":"IF($G178<>\"\", IF($G178<=$E178, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E178, \"En retard\", IF(TODAY()+7>=$E178, \"À risque (J-7)\", IF($H178=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H178<100, $E178<>\"\" , $E178<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D179=\"\",\"\",$D179)","v":0},{"$f":"IF(OR($D179=\"\",$E179=\"\"),\"\", $E179-$D179+1)","v":0},{"$f":"IF($F179=\"\",\"\",$F179)","v":0},{"$f":"IF(OR($F179=\"\",$G179=\"\"),\"\", $G179-$F179+1)","v":0},{"$f":"IF($E179=\"\", \"\", MAX(0, $E179-TODAY()+1))","v":0},{"$f":"IF($G179<>\"\", IF($G179<=$E179, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E179, \"En retard\", IF(TODAY()+7>=$E179, \"À risque (J-7)\", IF($H179=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H179<100, $E179<>\"\" , $E179<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D180=\"\",\"\",$D180)","v":0},{"$f":"IF(OR($D180=\"\",$E180=\"\"),\"\", $E180-$D180+1)","v":0},{"$f":"IF($F180=\"\",\"\",$F180)","v":0},{"$f":"IF(OR($F180=\"\",$G180=\"\"),\"\", $G180-$F180+1)","v":0},{"$f":"IF($E180=\"\", \"\", MAX(0, $E180-TODAY()+1))","v":0},{"$f":"IF($G180<>\"\", IF($G180<=$E180, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E180, \"En retard\", IF(TODAY()+7>=$E180, \"À risque (J-7)\", IF($H180=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H180<100, $E180<>\"\" , $E180<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D181=\"\",\"\",$D181)","v":0},{"$f":"IF(OR($D181=\"\",$E181=\"\"),\"\", $E181-$D181+1)","v":0},{"$f":"IF($F181=\"\",\"\",$F181)","v":0},{"$f":"IF(OR($F181=\"\",$G181=\"\"),\"\", $G181-$F181+1)","v":0},{"$f":"IF($E181=\"\", \"\", MAX(0, $E181-TODAY()+1))","v":0},{"$f":"IF($G181<>\"\", IF($G181<=$E181, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E181, \"En retard\", IF(TODAY()+7>=$E181, \"À risque (J-7)\", IF($H181=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H181<100, $E181<>\"\" , $E181<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D182=\"\",\"\",$D182)","v":0},{"$f":"IF(OR($D182=\"\",$E182=\"\"),\"\", $E182-$D182+1)","v":0},{"$f":"IF($F182=\"\",\"\",$F182)","v":0},{"$f":"IF(OR($F182=\"\",$G182=\"\"),\"\", $G182-$F182+1)","v":0},{"$f":"IF($E182=\"\", \"\", MAX(0, $E182-TODAY()+1))","v":0},{"$f":"IF($G182<>\"\", IF($G182<=$E182, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E182, \"En retard\", IF(TODAY()+7>=$E182, \"À risque (J-7)\", IF($H182=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H182<100, $E182<>\"\" , $E182<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D183=\"\",\"\",$D183)","v":0},{"$f":"IF(OR($D183=\"\",$E183=\"\"),\"\", $E183-$D183+1)","v":0},{"$f":"IF($F183=\"\",\"\",$F183)","v":0},{"$f":"IF(OR($F183=\"\",$G183=\"\"),\"\", $G183-$F183+1)","v":0},{"$f":"IF($E183=\"\", \"\", MAX(0, $E183-TODAY()+1))","v":0},{"$f":"IF($G183<>\"\", IF($G183<=$E183, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E183, \"En retard\", IF(TODAY()+7>=$E183, \"À risque (J-7)\", IF($H183=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H183<100, $E183<>\"\" , $E183<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D184=\"\",\"\",$D184)","v":0},{"$f":"IF(OR($D184=\"\",$E184=\"\"),\"\", $E184-$D184+1)","v":0},{"$f":"IF($F184=\"\",\"\",$F184)","v":0},{"$f":"IF(OR($F184=\"\",$G184=\"\"),\"\", $G184-$F184+1)","v":0},{"$f":"IF($E184=\"\", \"\", MAX(0, $E184-TODAY()+1))","v":0},{"$f":"IF($G184<>\"\", IF($G184<=$E184, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E184, \"En retard\", IF(TODAY()+7>=$E184, \"À risque (J-7)\", IF($H184=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H184<100, $E184<>\"\" , $E184<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D185=\"\",\"\",$D185)","v":0},{"$f":"IF(OR($D185=\"\",$E185=\"\"),\"\", $E185-$D185+1)","v":0},{"$f":"IF($F185=\"\",\"\",$F185)","v":0},{"$f":"IF(OR($F185=\"\",$G185=\"\"),\"\", $G185-$F185+1)","v":0},{"$f":"IF($E185=\"\", \"\", MAX(0, $E185-TODAY()+1))","v":0},{"$f":"IF($G185<>\"\", IF($G185<=$E185, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E185, \"En retard\", IF(TODAY()+7>=$E185, \"À risque (J-7)\", IF($H185=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H185<100, $E185<>\"\" , $E185<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D186=\"\",\"\",$D186)","v":0},{"$f":"IF(OR($D186=\"\",$E186=\"\"),\"\", $E186-$D186+1)","v":0},{"$f":"IF($F186=\"\",\"\",$F186)","v":0},{"$f":"IF(OR($F186=\"\",$G186=\"\"),\"\", $G186-$F186+1)","v":0},{"$f":"IF($E186=\"\", \"\", MAX(0, $E186-TODAY()+1))","v":0},{"$f":"IF($G186<>\"\", IF($G186<=$E186, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E186, \"En retard\", IF(TODAY()+7>=$E186, \"À risque (J-7)\", IF($H186=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H186<100, $E186<>\"\" , $E186<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D187=\"\",\"\",$D187)","v":0},{"$f":"IF(OR($D187=\"\",$E187=\"\"),\"\", $E187-$D187+1)","v":0},{"$f":"IF($F187=\"\",\"\",$F187)","v":0},{"$f":"IF(OR($F187=\"\",$G187=\"\"),\"\", $G187-$F187+1)","v":0},{"$f":"IF($E187=\"\", \"\", MAX(0, $E187-TODAY()+1))","v":0},{"$f":"IF($G187<>\"\", IF($G187<=$E187, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E187, \"En retard\", IF(TODAY()+7>=$E187, \"À risque (J-7)\", IF($H187=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H187<100, $E187<>\"\" , $E187<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D188=\"\",\"\",$D188)","v":0},{"$f":"IF(OR($D188=\"\",$E188=\"\"),\"\", $E188-$D188+1)","v":0},{"$f":"IF($F188=\"\",\"\",$F188)","v":0},{"$f":"IF(OR($F188=\"\",$G188=\"\"),\"\", $G188-$F188+1)","v":0},{"$f":"IF($E188=\"\", \"\", MAX(0, $E188-TODAY()+1))","v":0},{"$f":"IF($G188<>\"\", IF($G188<=$E188, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E188, \"En retard\", IF(TODAY()+7>=$E188, \"À risque (J-7)\", IF($H188=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H188<100, $E188<>\"\" , $E188<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D189=\"\",\"\",$D189)","v":0},{"$f":"IF(OR($D189=\"\",$E189=\"\"),\"\", $E189-$D189+1)","v":0},{"$f":"IF($F189=\"\",\"\",$F189)","v":0},{"$f":"IF(OR($F189=\"\",$G189=\"\"),\"\", $G189-$F189+1)","v":0},{"$f":"IF($E189=\"\", \"\", MAX(0, $E189-TODAY()+1))","v":0},{"$f":"IF($G189<>\"\", IF($G189<=$E189, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E189, \"En retard\", IF(TODAY()+7>=$E189, \"À risque (J-7)\", IF($H189=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H189<100, $E189<>\"\" , $E189<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D190=\"\",\"\",$D190)","v":0},{"$f":"IF(OR($D190=\"\",$E190=\"\"),\"\", $E190-$D190+1)","v":0},{"$f":"IF($F190=\"\",\"\",$F190)","v":0},{"$f":"IF(OR($F190=\"\",$G190=\"\"),\"\", $G190-$F190+1)","v":0},{"$f":"IF($E190=\"\", \"\", MAX(0, $E190-TODAY()+1))","v":0},{"$f":"IF($G190<>\"\", IF($G190<=$E190, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E190, \"En retard\", IF(TODAY()+7>=$E190, \"À risque (J-7)\", IF($H190=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H190<100, $E190<>\"\" , $E190<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D191=\"\",\"\",$D191)","v":0},{"$f":"IF(OR($D191=\"\",$E191=\"\"),\"\", $E191-$D191+1)","v":0},{"$f":"IF($F191=\"\",\"\",$F191)","v":0},{"$f":"IF(OR($F191=\"\",$G191=\"\"),\"\", $G191-$F191+1)","v":0},{"$f":"IF($E191=\"\", \"\", MAX(0, $E191-TODAY()+1))","v":0},{"$f":"IF($G191<>\"\", IF($G191<=$E191, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E191, \"En retard\", IF(TODAY()+7>=$E191, \"À risque (J-7)\", IF($H191=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H191<100, $E191<>\"\" , $E191<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D192=\"\",\"\",$D192)","v":0},{"$f":"IF(OR($D192=\"\",$E192=\"\"),\"\", $E192-$D192+1)","v":0},{"$f":"IF($F192=\"\",\"\",$F192)","v":0},{"$f":"IF(OR($F192=\"\",$G192=\"\"),\"\", $G192-$F192+1)","v":0},{"$f":"IF($E192=\"\", \"\", MAX(0, $E192-TODAY()+1))","v":0},{"$f":"IF($G192<>\"\", IF($G192<=$E192, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E192, \"En retard\", IF(TODAY()+7>=$E192, \"À risque (J-7)\", IF($H192=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H192<100, $E192<>\"\" , $E192<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D193=\"\",\"\",$D193)","v":0},{"$f":"IF(OR($D193=\"\",$E193=\"\"),\"\", $E193-$D193+1)","v":0},{"$f":"IF($F193=\"\",\"\",$F193)","v":0},{"$f":"IF(OR($F193=\"\",$G193=\"\"),\"\", $G193-$F193+1)","v":0},{"$f":"IF($E193=\"\", \"\", MAX(0, $E193-TODAY()+1))","v":0},{"$f":"IF($G193<>\"\", IF($G193<=$E193, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E193, \"En retard\", IF(TODAY()+7>=$E193, \"À risque (J-7)\", IF($H193=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H193<100, $E193<>\"\" , $E193<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D194=\"\",\"\",$D194)","v":0},{"$f":"IF(OR($D194=\"\",$E194=\"\"),\"\", $E194-$D194+1)","v":0},{"$f":"IF($F194=\"\",\"\",$F194)","v":0},{"$f":"IF(OR($F194=\"\",$G194=\"\"),\"\", $G194-$F194+1)","v":0},{"$f":"IF($E194=\"\", \"\", MAX(0, $E194-TODAY()+1))","v":0},{"$f":"IF($G194<>\"\", IF($G194<=$E194, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E194, \"En retard\", IF(TODAY()+7>=$E194, \"À risque (J-7)\", IF($H194=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H194<100, $E194<>\"\" , $E194<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D195=\"\",\"\",$D195)","v":0},{"$f":"IF(OR($D195=\"\",$E195=\"\"),\"\", $E195-$D195+1)","v":0},{"$f":"IF($F195=\"\",\"\",$F195)","v":0},{"$f":"IF(OR($F195=\"\",$G195=\"\"),\"\", $G195-$F195+1)","v":0},{"$f":"IF($E195=\"\", \"\", MAX(0, $E195-TODAY()+1))","v":0},{"$f":"IF($G195<>\"\", IF($G195<=$E195, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E195, \"En retard\", IF(TODAY()+7>=$E195, \"À risque (J-7)\", IF($H195=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H195<100, $E195<>\"\" , $E195<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D196=\"\",\"\",$D196)","v":0},{"$f":"IF(OR($D196=\"\",$E196=\"\"),\"\", $E196-$D196+1)","v":0},{"$f":"IF($F196=\"\",\"\",$F196)","v":0},{"$f":"IF(OR($F196=\"\",$G196=\"\"),\"\", $G196-$F196+1)","v":0},{"$f":"IF($E196=\"\", \"\", MAX(0, $E196-TODAY()+1))","v":0},{"$f":"IF($G196<>\"\", IF($G196<=$E196, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E196, \"En retard\", IF(TODAY()+7>=$E196, \"À risque (J-7)\", IF($H196=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H196<100, $E196<>\"\" , $E196<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D197=\"\",\"\",$D197)","v":0},{"$f":"IF(OR($D197=\"\",$E197=\"\"),\"\", $E197-$D197+1)","v":0},{"$f":"IF($F197=\"\",\"\",$F197)","v":0},{"$f":"IF(OR($F197=\"\",$G197=\"\"),\"\", $G197-$F197+1)","v":0},{"$f":"IF($E197=\"\", \"\", MAX(0, $E197-TODAY()+1))","v":0},{"$f":"IF($G197<>\"\", IF($G197<=$E197, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E197, \"En retard\", IF(TODAY()+7>=$E197, \"À risque (J-7)\", IF($H197=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H197<100, $E197<>\"\" , $E197<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D198=\"\",\"\",$D198)","v":0},{"$f":"IF(OR($D198=\"\",$E198=\"\"),\"\", $E198-$D198+1)","v":0},{"$f":"IF($F198=\"\",\"\",$F198)","v":0},{"$f":"IF(OR($F198=\"\",$G198=\"\"),\"\", $G198-$F198+1)","v":0},{"$f":"IF($E198=\"\", \"\", MAX(0, $E198-TODAY()+1))","v":0},{"$f":"IF($G198<>\"\", IF($G198<=$E198, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E198, \"En retard\", IF(TODAY()+7>=$E198, \"À risque (J-7)\", IF($H198=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H198<100, $E198<>\"\" , $E198<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D199=\"\",\"\",$D199)","v":0},{"$f":"IF(OR($D199=\"\",$E199=\"\"),\"\", $E199-$D199+1)","v":0},{"$f":"IF($F199=\"\",\"\",$F199)","v":0},{"$f":"IF(OR($F199=\"\",$G199=\"\"),\"\", $G199-$F199+1)","v":0},{"$f":"IF($E199=\"\", \"\", MAX(0, $E199-TODAY()+1))","v":0},{"$f":"IF($G199<>\"\", IF($G199<=$E199, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E199, \"En retard\", IF(TODAY()+7>=$E199, \"À risque (J-7)\", IF($H199=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H199<100, $E199<>\"\" , $E199<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D200=\"\",\"\",$D200)","v":0},{"$f":"IF(OR($D200=\"\",$E200=\"\"),\"\", $E200-$D200+1)","v":0},{"$f":"IF($F200=\"\",\"\",$F200)","v":0},{"$f":"IF(OR($F200=\"\",$G200=\"\"),\"\", $G200-$F200+1)","v":0},{"$f":"IF($E200=\"\", \"\", MAX(0, $E200-TODAY()+1))","v":0},{"$f":"IF($G200<>\"\", IF($G200<=$E200, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E200, \"En retard\", IF(TODAY()+7>=$E200, \"À risque (J-7)\", IF($H200=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H200<100, $E200<>\"\" , $E200<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D201=\"\",\"\",$D201)","v":0},{"$f":"IF(OR($D201=\"\",$E201=\"\"),\"\", $E201-$D201+1)","v":0},{"$f":"IF($F201=\"\",\"\",$F201)","v":0},{"$f":"IF(OR($F201=\"\",$G201=\"\"),\"\", $G201-$F201+1)","v":0},{"$f":"IF($E201=\"\", \"\", MAX(0, $E201-TODAY()+1))","v":0},{"$f":"IF($G201<>\"\", IF($G201<=$E201, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E201, \"En retard\", IF(TODAY()+7>=$E201, \"À risque (J-7)\", IF($H201=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H201<100, $E201<>\"\" , $E201<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D202=\"\",\"\",$D202)","v":0},{"$f":"IF(OR($D202=\"\",$E202=\"\"),\"\", $E202-$D202+1)","v":0},{"$f":"IF($F202=\"\",\"\",$F202)","v":0},{"$f":"IF(OR($F202=\"\",$G202=\"\"),\"\", $G202-$F202+1)","v":0},{"$f":"IF($E202=\"\", \"\", MAX(0, $E202-TODAY()+1))","v":0},{"$f":"IF($G202<>\"\", IF($G202<=$E202, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E202, \"En retard\", IF(TODAY()+7>=$E202, \"À risque (J-7)\", IF($H202=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H202<100, $E202<>\"\" , $E202<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D203=\"\",\"\",$D203)","v":0},{"$f":"IF(OR($D203=\"\",$E203=\"\"),\"\", $E203-$D203+1)","v":0},{"$f":"IF($F203=\"\",\"\",$F203)","v":0},{"$f":"IF(OR($F203=\"\",$G203=\"\"),\"\", $G203-$F203+1)","v":0},{"$f":"IF($E203=\"\", \"\", MAX(0, $E203-TODAY()+1))","v":0},{"$f":"IF($G203<>\"\", IF($G203<=$E203, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E203, \"En retard\", IF(TODAY()+7>=$E203, \"À risque (J-7)\", IF($H203=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H203<100, $E203<>\"\" , $E203<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D204=\"\",\"\",$D204)","v":0},{"$f":"IF(OR($D204=\"\",$E204=\"\"),\"\", $E204-$D204+1)","v":0},{"$f":"IF($F204=\"\",\"\",$F204)","v":0},{"$f":"IF(OR($F204=\"\",$G204=\"\"),\"\", $G204-$F204+1)","v":0},{"$f":"IF($E204=\"\", \"\", MAX(0, $E204-TODAY()+1))","v":0},{"$f":"IF($G204<>\"\", IF($G204<=$E204, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E204, \"En retard\", IF(TODAY()+7>=$E204, \"À risque (J-7)\", IF($H204=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H204<100, $E204<>\"\" , $E204<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D205=\"\",\"\",$D205)","v":0},{"$f":"IF(OR($D205=\"\",$E205=\"\"),\"\", $E205-$D205+1)","v":0},{"$f":"IF($F205=\"\",\"\",$F205)","v":0},{"$f":"IF(OR($F205=\"\",$G205=\"\"),\"\", $G205-$F205+1)","v":0},{"$f":"IF($E205=\"\", \"\", MAX(0, $E205-TODAY()+1))","v":0},{"$f":"IF($G205<>\"\", IF($G205<=$E205, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E205, \"En retard\", IF(TODAY()+7>=$E205, \"À risque (J-7)\", IF($H205=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H205<100, $E205<>\"\" , $E205<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D206=\"\",\"\",$D206)","v":0},{"$f":"IF(OR($D206=\"\",$E206=\"\"),\"\", $E206-$D206+1)","v":0},{"$f":"IF($F206=\"\",\"\",$F206)","v":0},{"$f":"IF(OR($F206=\"\",$G206=\"\"),\"\", $G206-$F206+1)","v":0},{"$f":"IF($E206=\"\", \"\", MAX(0, $E206-TODAY()+1))","v":0},{"$f":"IF($G206<>\"\", IF($G206<=$E206, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E206, \"En retard\", IF(TODAY()+7>=$E206, \"À risque (J-7)\", IF($H206=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H206<100, $E206<>\"\" , $E206<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D207=\"\",\"\",$D207)","v":0},{"$f":"IF(OR($D207=\"\",$E207=\"\"),\"\", $E207-$D207+1)","v":0},{"$f":"IF($F207=\"\",\"\",$F207)","v":0},{"$f":"IF(OR($F207=\"\",$G207=\"\"),\"\", $G207-$F207+1)","v":0},{"$f":"IF($E207=\"\", \"\", MAX(0, $E207-TODAY()+1))","v":0},{"$f":"IF($G207<>\"\", IF($G207<=$E207, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E207, \"En retard\", IF(TODAY()+7>=$E207, \"À risque (J-7)\", IF($H207=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H207<100, $E207<>\"\" , $E207<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D208=\"\",\"\",$D208)","v":0},{"$f":"IF(OR($D208=\"\",$E208=\"\"),\"\", $E208-$D208+1)","v":0},{"$f":"IF($F208=\"\",\"\",$F208)","v":0},{"$f":"IF(OR($F208=\"\",$G208=\"\"),\"\", $G208-$F208+1)","v":0},{"$f":"IF($E208=\"\", \"\", MAX(0, $E208-TODAY()+1))","v":0},{"$f":"IF($G208<>\"\", IF($G208<=$E208, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E208, \"En retard\", IF(TODAY()+7>=$E208, \"À risque (J-7)\", IF($H208=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H208<100, $E208<>\"\" , $E208<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D209=\"\",\"\",$D209)","v":0},{"$f":"IF(OR($D209=\"\",$E209=\"\"),\"\", $E209-$D209+1)","v":0},{"$f":"IF($F209=\"\",\"\",$F209)","v":0},{"$f":"IF(OR($F209=\"\",$G209=\"\"),\"\", $G209-$F209+1)","v":0},{"$f":"IF($E209=\"\", \"\", MAX(0, $E209-TODAY()+1))","v":0},{"$f":"IF($G209<>\"\", IF($G209<=$E209, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E209, \"En retard\", IF(TODAY()+7>=$E209, \"À risque (J-7)\", IF($H209=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H209<100, $E209<>\"\" , $E209<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D210=\"\",\"\",$D210)","v":0},{"$f":"IF(OR($D210=\"\",$E210=\"\"),\"\", $E210-$D210+1)","v":0},{"$f":"IF($F210=\"\",\"\",$F210)","v":0},{"$f":"IF(OR($F210=\"\",$G210=\"\"),\"\", $G210-$F210+1)","v":0},{"$f":"IF($E210=\"\", \"\", MAX(0, $E210-TODAY()+1))","v":0},{"$f":"IF($G210<>\"\", IF($G210<=$E210, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E210, \"En retard\", IF(TODAY()+7>=$E210, \"À risque (J-7)\", IF($H210=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H210<100, $E210<>\"\" , $E210<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D211=\"\",\"\",$D211)","v":0},{"$f":"IF(OR($D211=\"\",$E211=\"\"),\"\", $E211-$D211+1)","v":0},{"$f":"IF($F211=\"\",\"\",$F211)","v":0},{"$f":"IF(OR($F211=\"\",$G211=\"\"),\"\", $G211-$F211+1)","v":0},{"$f":"IF($E211=\"\", \"\", MAX(0, $E211-TODAY()+1))","v":0},{"$f":"IF($G211<>\"\", IF($G211<=$E211, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E211, \"En retard\", IF(TODAY()+7>=$E211, \"À risque (J-7)\", IF($H211=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H211<100, $E211<>\"\" , $E211<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D212=\"\",\"\",$D212)","v":0},{"$f":"IF(OR($D212=\"\",$E212=\"\"),\"\", $E212-$D212+1)","v":0},{"$f":"IF($F212=\"\",\"\",$F212)","v":0},{"$f":"IF(OR($F212=\"\",$G212=\"\"),\"\", $G212-$F212+1)","v":0},{"$f":"IF($E212=\"\", \"\", MAX(0, $E212-TODAY()+1))","v":0},{"$f":"IF($G212<>\"\", IF($G212<=$E212, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E212, \"En retard\", IF(TODAY()+7>=$E212, \"À risque (J-7)\", IF($H212=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H212<100, $E212<>\"\" , $E212<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D213=\"\",\"\",$D213)","v":0},{"$f":"IF(OR($D213=\"\",$E213=\"\"),\"\", $E213-$D213+1)","v":0},{"$f":"IF($F213=\"\",\"\",$F213)","v":0},{"$f":"IF(OR($F213=\"\",$G213=\"\"),\"\", $G213-$F213+1)","v":0},{"$f":"IF($E213=\"\", \"\", MAX(0, $E213-TODAY()+1))","v":0},{"$f":"IF($G213<>\"\", IF($G213<=$E213, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E213, \"En retard\", IF(TODAY()+7>=$E213, \"À risque (J-7)\", IF($H213=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H213<100, $E213<>\"\" , $E213<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D214=\"\",\"\",$D214)","v":0},{"$f":"IF(OR($D214=\"\",$E214=\"\"),\"\", $E214-$D214+1)","v":0},{"$f":"IF($F214=\"\",\"\",$F214)","v":0},{"$f":"IF(OR($F214=\"\",$G214=\"\"),\"\", $G214-$F214+1)","v":0},{"$f":"IF($E214=\"\", \"\", MAX(0, $E214-TODAY()+1))","v":0},{"$f":"IF($G214<>\"\", IF($G214<=$E214, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E214, \"En retard\", IF(TODAY()+7>=$E214, \"À risque (J-7)\", IF($H214=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H214<100, $E214<>\"\" , $E214<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D215=\"\",\"\",$D215)","v":0},{"$f":"IF(OR($D215=\"\",$E215=\"\"),\"\", $E215-$D215+1)","v":0},{"$f":"IF($F215=\"\",\"\",$F215)","v":0},{"$f":"IF(OR($F215=\"\",$G215=\"\"),\"\", $G215-$F215+1)","v":0},{"$f":"IF($E215=\"\", \"\", MAX(0, $E215-TODAY()+1))","v":0},{"$f":"IF($G215<>\"\", IF($G215<=$E215, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E215, \"En retard\", IF(TODAY()+7>=$E215, \"À risque (J-7)\", IF($H215=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H215<100, $E215<>\"\" , $E215<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D216=\"\",\"\",$D216)","v":0},{"$f":"IF(OR($D216=\"\",$E216=\"\"),\"\", $E216-$D216+1)","v":0},{"$f":"IF($F216=\"\",\"\",$F216)","v":0},{"$f":"IF(OR($F216=\"\",$G216=\"\"),\"\", $G216-$F216+1)","v":0},{"$f":"IF($E216=\"\", \"\", MAX(0, $E216-TODAY()+1))","v":0},{"$f":"IF($G216<>\"\", IF($G216<=$E216, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E216, \"En retard\", IF(TODAY()+7>=$E216, \"À risque (J-7)\", IF($H216=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H216<100, $E216<>\"\" , $E216<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D217=\"\",\"\",$D217)","v":0},{"$f":"IF(OR($D217=\"\",$E217=\"\"),\"\", $E217-$D217+1)","v":0},{"$f":"IF($F217=\"\",\"\",$F217)","v":0},{"$f":"IF(OR($F217=\"\",$G217=\"\"),\"\", $G217-$F217+1)","v":0},{"$f":"IF($E217=\"\", \"\", MAX(0, $E217-TODAY()+1))","v":0},{"$f":"IF($G217<>\"\", IF($G217<=$E217, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E217, \"En retard\", IF(TODAY()+7>=$E217, \"À risque (J-7)\", IF($H217=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H217<100, $E217<>\"\" , $E217<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D218=\"\",\"\",$D218)","v":0},{"$f":"IF(OR($D218=\"\",$E218=\"\"),\"\", $E218-$D218+1)","v":0},{"$f":"IF($F218=\"\",\"\",$F218)","v":0},{"$f":"IF(OR($F218=\"\",$G218=\"\"),\"\", $G218-$F218+1)","v":0},{"$f":"IF($E218=\"\", \"\", MAX(0, $E218-TODAY()+1))","v":0},{"$f":"IF($G218<>\"\", IF($G218<=$E218, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E218, \"En retard\", IF(TODAY()+7>=$E218, \"À risque (J-7)\", IF($H218=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H218<100, $E218<>\"\" , $E218<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D219=\"\",\"\",$D219)","v":0},{"$f":"IF(OR($D219=\"\",$E219=\"\"),\"\", $E219-$D219+1)","v":0},{"$f":"IF($F219=\"\",\"\",$F219)","v":0},{"$f":"IF(OR($F219=\"\",$G219=\"\"),\"\", $G219-$F219+1)","v":0},{"$f":"IF($E219=\"\", \"\", MAX(0, $E219-TODAY()+1))","v":0},{"$f":"IF($G219<>\"\", IF($G219<=$E219, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E219, \"En retard\", IF(TODAY()+7>=$E219, \"À risque (J-7)\", IF($H219=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H219<100, $E219<>\"\" , $E219<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D220=\"\",\"\",$D220)","v":0},{"$f":"IF(OR($D220=\"\",$E220=\"\"),\"\", $E220-$D220+1)","v":0},{"$f":"IF($F220=\"\",\"\",$F220)","v":0},{"$f":"IF(OR($F220=\"\",$G220=\"\"),\"\", $G220-$F220+1)","v":0},{"$f":"IF($E220=\"\", \"\", MAX(0, $E220-TODAY()+1))","v":0},{"$f":"IF($G220<>\"\", IF($G220<=$E220, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E220, \"En retard\", IF(TODAY()+7>=$E220, \"À risque (J-7)\", IF($H220=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H220<100, $E220<>\"\" , $E220<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D221=\"\",\"\",$D221)","v":0},{"$f":"IF(OR($D221=\"\",$E221=\"\"),\"\", $E221-$D221+1)","v":0},{"$f":"IF($F221=\"\",\"\",$F221)","v":0},{"$f":"IF(OR($F221=\"\",$G221=\"\"),\"\", $G221-$F221+1)","v":0},{"$f":"IF($E221=\"\", \"\", MAX(0, $E221-TODAY()+1))","v":0},{"$f":"IF($G221<>\"\", IF($G221<=$E221, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E221, \"En retard\", IF(TODAY()+7>=$E221, \"À risque (J-7)\", IF($H221=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H221<100, $E221<>\"\" , $E221<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D222=\"\",\"\",$D222)","v":0},{"$f":"IF(OR($D222=\"\",$E222=\"\"),\"\", $E222-$D222+1)","v":0},{"$f":"IF($F222=\"\",\"\",$F222)","v":0},{"$f":"IF(OR($F222=\"\",$G222=\"\"),\"\", $G222-$F222+1)","v":0},{"$f":"IF($E222=\"\", \"\", MAX(0, $E222-TODAY()+1))","v":0},{"$f":"IF($G222<>\"\", IF($G222<=$E222, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E222, \"En retard\", IF(TODAY()+7>=$E222, \"À risque (J-7)\", IF($H222=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H222<100, $E222<>\"\" , $E222<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D223=\"\",\"\",$D223)","v":0},{"$f":"IF(OR($D223=\"\",$E223=\"\"),\"\", $E223-$D223+1)","v":0},{"$f":"IF($F223=\"\",\"\",$F223)","v":0},{"$f":"IF(OR($F223=\"\",$G223=\"\"),\"\", $G223-$F223+1)","v":0},{"$f":"IF($E223=\"\", \"\", MAX(0, $E223-TODAY()+1))","v":0},{"$f":"IF($G223<>\"\", IF($G223<=$E223, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E223, \"En retard\", IF(TODAY()+7>=$E223, \"À risque (J-7)\", IF($H223=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H223<100, $E223<>\"\" , $E223<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D224=\"\",\"\",$D224)","v":0},{"$f":"IF(OR($D224=\"\",$E224=\"\"),\"\", $E224-$D224+1)","v":0},{"$f":"IF($F224=\"\",\"\",$F224)","v":0},{"$f":"IF(OR($F224=\"\",$G224=\"\"),\"\", $G224-$F224+1)","v":0},{"$f":"IF($E224=\"\", \"\", MAX(0, $E224-TODAY()+1))","v":0},{"$f":"IF($G224<>\"\", IF($G224<=$E224, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E224, \"En retard\", IF(TODAY()+7>=$E224, \"À risque (J-7)\", IF($H224=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H224<100, $E224<>\"\" , $E224<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D225=\"\",\"\",$D225)","v":0},{"$f":"IF(OR($D225=\"\",$E225=\"\"),\"\", $E225-$D225+1)","v":0},{"$f":"IF($F225=\"\",\"\",$F225)","v":0},{"$f":"IF(OR($F225=\"\",$G225=\"\"),\"\", $G225-$F225+1)","v":0},{"$f":"IF($E225=\"\", \"\", MAX(0, $E225-TODAY()+1))","v":0},{"$f":"IF($G225<>\"\", IF($G225<=$E225, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E225, \"En retard\", IF(TODAY()+7>=$E225, \"À risque (J-7)\", IF($H225=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H225<100, $E225<>\"\" , $E225<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D226=\"\",\"\",$D226)","v":0},{"$f":"IF(OR($D226=\"\",$E226=\"\"),\"\", $E226-$D226+1)","v":0},{"$f":"IF($F226=\"\",\"\",$F226)","v":0},{"$f":"IF(OR($F226=\"\",$G226=\"\"),\"\", $G226-$F226+1)","v":0},{"$f":"IF($E226=\"\", \"\", MAX(0, $E226-TODAY()+1))","v":0},{"$f":"IF($G226<>\"\", IF($G226<=$E226, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E226, \"En retard\", IF(TODAY()+7>=$E226, \"À risque (J-7)\", IF($H226=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H226<100, $E226<>\"\" , $E226<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D227=\"\",\"\",$D227)","v":0},{"$f":"IF(OR($D227=\"\",$E227=\"\"),\"\", $E227-$D227+1)","v":0},{"$f":"IF($F227=\"\",\"\",$F227)","v":0},{"$f":"IF(OR($F227=\"\",$G227=\"\"),\"\", $G227-$F227+1)","v":0},{"$f":"IF($E227=\"\", \"\", MAX(0, $E227-TODAY()+1))","v":0},{"$f":"IF($G227<>\"\", IF($G227<=$E227, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E227, \"En retard\", IF(TODAY()+7>=$E227, \"À risque (J-7)\", IF($H227=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H227<100, $E227<>\"\" , $E227<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D228=\"\",\"\",$D228)","v":0},{"$f":"IF(OR($D228=\"\",$E228=\"\"),\"\", $E228-$D228+1)","v":0},{"$f":"IF($F228=\"\",\"\",$F228)","v":0},{"$f":"IF(OR($F228=\"\",$G228=\"\"),\"\", $G228-$F228+1)","v":0},{"$f":"IF($E228=\"\", \"\", MAX(0, $E228-TODAY()+1))","v":0},{"$f":"IF($G228<>\"\", IF($G228<=$E228, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E228, \"En retard\", IF(TODAY()+7>=$E228, \"À risque (J-7)\", IF($H228=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H228<100, $E228<>\"\" , $E228<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D229=\"\",\"\",$D229)","v":0},{"$f":"IF(OR($D229=\"\",$E229=\"\"),\"\", $E229-$D229+1)","v":0},{"$f":"IF($F229=\"\",\"\",$F229)","v":0},{"$f":"IF(OR($F229=\"\",$G229=\"\"),\"\", $G229-$F229+1)","v":0},{"$f":"IF($E229=\"\", \"\", MAX(0, $E229-TODAY()+1))","v":0},{"$f":"IF($G229<>\"\", IF($G229<=$E229, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E229, \"En retard\", IF(TODAY()+7>=$E229, \"À risque (J-7)\", IF($H229=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H229<100, $E229<>\"\" , $E229<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D230=\"\",\"\",$D230)","v":0},{"$f":"IF(OR($D230=\"\",$E230=\"\"),\"\", $E230-$D230+1)","v":0},{"$f":"IF($F230=\"\",\"\",$F230)","v":0},{"$f":"IF(OR($F230=\"\",$G230=\"\"),\"\", $G230-$F230+1)","v":0},{"$f":"IF($E230=\"\", \"\", MAX(0, $E230-TODAY()+1))","v":0},{"$f":"IF($G230<>\"\", IF($G230<=$E230, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E230, \"En retard\", IF(TODAY()+7>=$E230, \"À risque (J-7)\", IF($H230=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H230<100, $E230<>\"\" , $E230<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D231=\"\",\"\",$D231)","v":0},{"$f":"IF(OR($D231=\"\",$E231=\"\"),\"\", $E231-$D231+1)","v":0},{"$f":"IF($F231=\"\",\"\",$F231)","v":0},{"$f":"IF(OR($F231=\"\",$G231=\"\"),\"\", $G231-$F231+1)","v":0},{"$f":"IF($E231=\"\", \"\", MAX(0, $E231-TODAY()+1))","v":0},{"$f":"IF($G231<>\"\", IF($G231<=$E231, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E231, \"En retard\", IF(TODAY()+7>=$E231, \"À risque (J-7)\", IF($H231=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H231<100, $E231<>\"\" , $E231<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D232=\"\",\"\",$D232)","v":0},{"$f":"IF(OR($D232=\"\",$E232=\"\"),\"\", $E232-$D232+1)","v":0},{"$f":"IF($F232=\"\",\"\",$F232)","v":0},{"$f":"IF(OR($F232=\"\",$G232=\"\"),\"\", $G232-$F232+1)","v":0},{"$f":"IF($E232=\"\", \"\", MAX(0, $E232-TODAY()+1))","v":0},{"$f":"IF($G232<>\"\", IF($G232<=$E232, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E232, \"En retard\", IF(TODAY()+7>=$E232, \"À risque (J-7)\", IF($H232=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H232<100, $E232<>\"\" , $E232<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D233=\"\",\"\",$D233)","v":0},{"$f":"IF(OR($D233=\"\",$E233=\"\"),\"\", $E233-$D233+1)","v":0},{"$f":"IF($F233=\"\",\"\",$F233)","v":0},{"$f":"IF(OR($F233=\"\",$G233=\"\"),\"\", $G233-$F233+1)","v":0},{"$f":"IF($E233=\"\", \"\", MAX(0, $E233-TODAY()+1))","v":0},{"$f":"IF($G233<>\"\", IF($G233<=$E233, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E233, \"En retard\", IF(TODAY()+7>=$E233, \"À risque (J-7)\", IF($H233=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H233<100, $E233<>\"\" , $E233<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D234=\"\",\"\",$D234)","v":0},{"$f":"IF(OR($D234=\"\",$E234=\"\"),\"\", $E234-$D234+1)","v":0},{"$f":"IF($F234=\"\",\"\",$F234)","v":0},{"$f":"IF(OR($F234=\"\",$G234=\"\"),\"\", $G234-$F234+1)","v":0},{"$f":"IF($E234=\"\", \"\", MAX(0, $E234-TODAY()+1))","v":0},{"$f":"IF($G234<>\"\", IF($G234<=$E234, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E234, \"En retard\", IF(TODAY()+7>=$E234, \"À risque (J-7)\", IF($H234=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H234<100, $E234<>\"\" , $E234<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D235=\"\",\"\",$D235)","v":0},{"$f":"IF(OR($D235=\"\",$E235=\"\"),\"\", $E235-$D235+1)","v":0},{"$f":"IF($F235=\"\",\"\",$F235)","v":0},{"$f":"IF(OR($F235=\"\",$G235=\"\"),\"\", $G235-$F235+1)","v":0},{"$f":"IF($E235=\"\", \"\", MAX(0, $E235-TODAY()+1))","v":0},{"$f":"IF($G235<>\"\", IF($G235<=$E235, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E235, \"En retard\", IF(TODAY()+7>=$E235, \"À risque (J-7)\", IF($H235=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H235<100, $E235<>\"\" , $E235<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D236=\"\",\"\",$D236)","v":0},{"$f":"IF(OR($D236=\"\",$E236=\"\"),\"\", $E236-$D236+1)","v":0},{"$f":"IF($F236=\"\",\"\",$F236)","v":0},{"$f":"IF(OR($F236=\"\",$G236=\"\"),\"\", $G236-$F236+1)","v":0},{"$f":"IF($E236=\"\", \"\", MAX(0, $E236-TODAY()+1))","v":0},{"$f":"IF($G236<>\"\", IF($G236<=$E236, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E236, \"En retard\", IF(TODAY()+7>=$E236, \"À risque (J-7)\", IF($H236=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H236<100, $E236<>\"\" , $E236<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D237=\"\",\"\",$D237)","v":0},{"$f":"IF(OR($D237=\"\",$E237=\"\"),\"\", $E237-$D237+1)","v":0},{"$f":"IF($F237=\"\",\"\",$F237)","v":0},{"$f":"IF(OR($F237=\"\",$G237=\"\"),\"\", $G237-$F237+1)","v":0},{"$f":"IF($E237=\"\", \"\", MAX(0, $E237-TODAY()+1))","v":0},{"$f":"IF($G237<>\"\", IF($G237<=$E237, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E237, \"En retard\", IF(TODAY()+7>=$E237, \"À risque (J-7)\", IF($H237=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H237<100, $E237<>\"\" , $E237<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D238=\"\",\"\",$D238)","v":0},{"$f":"IF(OR($D238=\"\",$E238=\"\"),\"\", $E238-$D238+1)","v":0},{"$f":"IF($F238=\"\",\"\",$F238)","v":0},{"$f":"IF(OR($F238=\"\",$G238=\"\"),\"\", $G238-$F238+1)","v":0},{"$f":"IF($E238=\"\", \"\", MAX(0, $E238-TODAY()+1))","v":0},{"$f":"IF($G238<>\"\", IF($G238<=$E238, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E238, \"En retard\", IF(TODAY()+7>=$E238, \"À risque (J-7)\", IF($H238=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H238<100, $E238<>\"\" , $E238<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D239=\"\",\"\",$D239)","v":0},{"$f":"IF(OR($D239=\"\",$E239=\"\"),\"\", $E239-$D239+1)","v":0},{"$f":"IF($F239=\"\",\"\",$F239)","v":0},{"$f":"IF(OR($F239=\"\",$G239=\"\"),\"\", $G239-$F239+1)","v":0},{"$f":"IF($E239=\"\", \"\", MAX(0, $E239-TODAY()+1))","v":0},{"$f":"IF($G239<>\"\", IF($G239<=$E239, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E239, \"En retard\", IF(TODAY()+7>=$E239, \"À risque (J-7)\", IF($H239=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H239<100, $E239<>\"\" , $E239<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D240=\"\",\"\",$D240)","v":0},{"$f":"IF(OR($D240=\"\",$E240=\"\"),\"\", $E240-$D240+1)","v":0},{"$f":"IF($F240=\"\",\"\",$F240)","v":0},{"$f":"IF(OR($F240=\"\",$G240=\"\"),\"\", $G240-$F240+1)","v":0},{"$f":"IF($E240=\"\", \"\", MAX(0, $E240-TODAY()+1))","v":0},{"$f":"IF($G240<>\"\", IF($G240<=$E240, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E240, \"En retard\", IF(TODAY()+7>=$E240, \"À risque (J-7)\", IF($H240=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H240<100, $E240<>\"\" , $E240<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D241=\"\",\"\",$D241)","v":0},{"$f":"IF(OR($D241=\"\",$E241=\"\"),\"\", $E241-$D241+1)","v":0},{"$f":"IF($F241=\"\",\"\",$F241)","v":0},{"$f":"IF(OR($F241=\"\",$G241=\"\"),\"\", $G241-$F241+1)","v":0},{"$f":"IF($E241=\"\", \"\", MAX(0, $E241-TODAY()+1))","v":0},{"$f":"IF($G241<>\"\", IF($G241<=$E241, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E241, \"En retard\", IF(TODAY()+7>=$E241, \"À risque (J-7)\", IF($H241=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H241<100, $E241<>\"\" , $E241<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D242=\"\",\"\",$D242)","v":0},{"$f":"IF(OR($D242=\"\",$E242=\"\"),\"\", $E242-$D242+1)","v":0},{"$f":"IF($F242=\"\",\"\",$F242)","v":0},{"$f":"IF(OR($F242=\"\",$G242=\"\"),\"\", $G242-$F242+1)","v":0},{"$f":"IF($E242=\"\", \"\", MAX(0, $E242-TODAY()+1))","v":0},{"$f":"IF($G242<>\"\", IF($G242<=$E242, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E242, \"En retard\", IF(TODAY()+7>=$E242, \"À risque (J-7)\", IF($H242=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H242<100, $E242<>\"\" , $E242<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D243=\"\",\"\",$D243)","v":0},{"$f":"IF(OR($D243=\"\",$E243=\"\"),\"\", $E243-$D243+1)","v":0},{"$f":"IF($F243=\"\",\"\",$F243)","v":0},{"$f":"IF(OR($F243=\"\",$G243=\"\"),\"\", $G243-$F243+1)","v":0},{"$f":"IF($E243=\"\", \"\", MAX(0, $E243-TODAY()+1))","v":0},{"$f":"IF($G243<>\"\", IF($G243<=$E243, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E243, \"En retard\", IF(TODAY()+7>=$E243, \"À risque (J-7)\", IF($H243=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H243<100, $E243<>\"\" , $E243<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D244=\"\",\"\",$D244)","v":0},{"$f":"IF(OR($D244=\"\",$E244=\"\"),\"\", $E244-$D244+1)","v":0},{"$f":"IF($F244=\"\",\"\",$F244)","v":0},{"$f":"IF(OR($F244=\"\",$G244=\"\"),\"\", $G244-$F244+1)","v":0},{"$f":"IF($E244=\"\", \"\", MAX(0, $E244-TODAY()+1))","v":0},{"$f":"IF($G244<>\"\", IF($G244<=$E244, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E244, \"En retard\", IF(TODAY()+7>=$E244, \"À risque (J-7)\", IF($H244=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H244<100, $E244<>\"\" , $E244<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D245=\"\",\"\",$D245)","v":0},{"$f":"IF(OR($D245=\"\",$E245=\"\"),\"\", $E245-$D245+1)","v":0},{"$f":"IF($F245=\"\",\"\",$F245)","v":0},{"$f":"IF(OR($F245=\"\",$G245=\"\"),\"\", $G245-$F245+1)","v":0},{"$f":"IF($E245=\"\", \"\", MAX(0, $E245-TODAY()+1))","v":0},{"$f":"IF($G245<>\"\", IF($G245<=$E245, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E245, \"En retard\", IF(TODAY()+7>=$E245, \"À risque (J-7)\", IF($H245=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H245<100, $E245<>\"\" , $E245<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D246=\"\",\"\",$D246)","v":0},{"$f":"IF(OR($D246=\"\",$E246=\"\"),\"\", $E246-$D246+1)","v":0},{"$f":"IF($F246=\"\",\"\",$F246)","v":0},{"$f":"IF(OR($F246=\"\",$G246=\"\"),\"\", $G246-$F246+1)","v":0},{"$f":"IF($E246=\"\", \"\", MAX(0, $E246-TODAY()+1))","v":0},{"$f":"IF($G246<>\"\", IF($G246<=$E246, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E246, \"En retard\", IF(TODAY()+7>=$E246, \"À risque (J-7)\", IF($H246=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H246<100, $E246<>\"\" , $E246<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D247=\"\",\"\",$D247)","v":0},{"$f":"IF(OR($D247=\"\",$E247=\"\"),\"\", $E247-$D247+1)","v":0},{"$f":"IF($F247=\"\",\"\",$F247)","v":0},{"$f":"IF(OR($F247=\"\",$G247=\"\"),\"\", $G247-$F247+1)","v":0},{"$f":"IF($E247=\"\", \"\", MAX(0, $E247-TODAY()+1))","v":0},{"$f":"IF($G247<>\"\", IF($G247<=$E247, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E247, \"En retard\", IF(TODAY()+7>=$E247, \"À risque (J-7)\", IF($H247=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H247<100, $E247<>\"\" , $E247<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D248=\"\",\"\",$D248)","v":0},{"$f":"IF(OR($D248=\"\",$E248=\"\"),\"\", $E248-$D248+1)","v":0},{"$f":"IF($F248=\"\",\"\",$F248)","v":0},{"$f":"IF(OR($F248=\"\",$G248=\"\"),\"\", $G248-$F248+1)","v":0},{"$f":"IF($E248=\"\", \"\", MAX(0, $E248-TODAY()+1))","v":0},{"$f":"IF($G248<>\"\", IF($G248<=$E248, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E248, \"En retard\", IF(TODAY()+7>=$E248, \"À risque (J-7)\", IF($H248=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H248<100, $E248<>\"\" , $E248<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D249=\"\",\"\",$D249)","v":0},{"$f":"IF(OR($D249=\"\",$E249=\"\"),\"\", $E249-$D249+1)","v":0},{"$f":"IF($F249=\"\",\"\",$F249)","v":0},{"$f":"IF(OR($F249=\"\",$G249=\"\"),\"\", $G249-$F249+1)","v":0},{"$f":"IF($E249=\"\", \"\", MAX(0, $E249-TODAY()+1))","v":0},{"$f":"IF($G249<>\"\", IF($G249<=$E249, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E249, \"En retard\", IF(TODAY()+7>=$E249, \"À risque (J-7)\", IF($H249=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H249<100, $E249<>\"\" , $E249<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D250=\"\",\"\",$D250)","v":0},{"$f":"IF(OR($D250=\"\",$E250=\"\"),\"\", $E250-$D250+1)","v":0},{"$f":"IF($F250=\"\",\"\",$F250)","v":0},{"$f":"IF(OR($F250=\"\",$G250=\"\"),\"\", $G250-$F250+1)","v":0},{"$f":"IF($E250=\"\", \"\", MAX(0, $E250-TODAY()+1))","v":0},{"$f":"IF($G250<>\"\", IF($G250<=$E250, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E250, \"En retard\", IF(TODAY()+7>=$E250, \"À risque (J-7)\", IF($H250=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H250<100, $E250<>\"\" , $E250<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D251=\"\",\"\",$D251)","v":0},{"$f":"IF(OR($D251=\"\",$E251=\"\"),\"\", $E251-$D251+1)","v":0},{"$f":"IF($F251=\"\",\"\",$F251)","v":0},{"$f":"IF(OR($F251=\"\",$G251=\"\"),\"\", $G251-$F251+1)","v":0},{"$f":"IF($E251=\"\", \"\", MAX(0, $E251-TODAY()+1))","v":0},{"$f":"IF($G251<>\"\", IF($G251<=$E251, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E251, \"En retard\", IF(TODAY()+7>=$E251, \"À risque (J-7)\", IF($H251=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H251<100, $E251<>\"\" , $E251<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D252=\"\",\"\",$D252)","v":0},{"$f":"IF(OR($D252=\"\",$E252=\"\"),\"\", $E252-$D252+1)","v":0},{"$f":"IF($F252=\"\",\"\",$F252)","v":0},{"$f":"IF(OR($F252=\"\",$G252=\"\"),\"\", $G252-$F252+1)","v":0},{"$f":"IF($E252=\"\", \"\", MAX(0, $E252-TODAY()+1))","v":0},{"$f":"IF($G252<>\"\", IF($G252<=$E252, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E252, \"En retard\", IF(TODAY()+7>=$E252, \"À risque (J-7)\", IF($H252=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H252<100, $E252<>\"\" , $E252<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D253=\"\",\"\",$D253)","v":0},{"$f":"IF(OR($D253=\"\",$E253=\"\"),\"\", $E253-$D253+1)","v":0},{"$f":"IF($F253=\"\",\"\",$F253)","v":0},{"$f":"IF(OR($F253=\"\",$G253=\"\"),\"\", $G253-$F253+1)","v":0},{"$f":"IF($E253=\"\", \"\", MAX(0, $E253-TODAY()+1))","v":0},{"$f":"IF($G253<>\"\", IF($G253<=$E253, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E253, \"En retard\", IF(TODAY()+7>=$E253, \"À risque (J-7)\", IF($H253=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H253<100, $E253<>\"\" , $E253<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D254=\"\",\"\",$D254)","v":0},{"$f":"IF(OR($D254=\"\",$E254=\"\"),\"\", $E254-$D254+1)","v":0},{"$f":"IF($F254=\"\",\"\",$F254)","v":0},{"$f":"IF(OR($F254=\"\",$G254=\"\"),\"\", $G254-$F254+1)","v":0},{"$f":"IF($E254=\"\", \"\", MAX(0, $E254-TODAY()+1))","v":0},{"$f":"IF($G254<>\"\", IF($G254<=$E254, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E254, \"En retard\", IF(TODAY()+7>=$E254, \"À risque (J-7)\", IF($H254=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H254<100, $E254<>\"\" , $E254<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D255=\"\",\"\",$D255)","v":0},{"$f":"IF(OR($D255=\"\",$E255=\"\"),\"\", $E255-$D255+1)","v":0},{"$f":"IF($F255=\"\",\"\",$F255)","v":0},{"$f":"IF(OR($F255=\"\",$G255=\"\"),\"\", $G255-$F255+1)","v":0},{"$f":"IF($E255=\"\", \"\", MAX(0, $E255-TODAY()+1))","v":0},{"$f":"IF($G255<>\"\", IF($G255<=$E255, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E255, \"En retard\", IF(TODAY()+7>=$E255, \"À risque (J-7)\", IF($H255=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H255<100, $E255<>\"\" , $E255<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D256=\"\",\"\",$D256)","v":0},{"$f":"IF(OR($D256=\"\",$E256=\"\"),\"\", $E256-$D256+1)","v":0},{"$f":"IF($F256=\"\",\"\",$F256)","v":0},{"$f":"IF(OR($F256=\"\",$G256=\"\"),\"\", $G256-$F256+1)","v":0},{"$f":"IF($E256=\"\", \"\", MAX(0, $E256-TODAY()+1))","v":0},{"$f":"IF($G256<>\"\", IF($G256<=$E256, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E256, \"En retard\", IF(TODAY()+7>=$E256, \"À risque (J-7)\", IF($H256=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H256<100, $E256<>\"\" , $E256<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D257=\"\",\"\",$D257)","v":0},{"$f":"IF(OR($D257=\"\",$E257=\"\"),\"\", $E257-$D257+1)","v":0},{"$f":"IF($F257=\"\",\"\",$F257)","v":0},{"$f":"IF(OR($F257=\"\",$G257=\"\"),\"\", $G257-$F257+1)","v":0},{"$f":"IF($E257=\"\", \"\", MAX(0, $E257-TODAY()+1))","v":0},{"$f":"IF($G257<>\"\", IF($G257<=$E257, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E257, \"En retard\", IF(TODAY()+7>=$E257, \"À risque (J-7)\", IF($H257=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H257<100, $E257<>\"\" , $E257<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D258=\"\",\"\",$D258)","v":0},{"$f":"IF(OR($D258=\"\",$E258=\"\"),\"\", $E258-$D258+1)","v":0},{"$f":"IF($F258=\"\",\"\",$F258)","v":0},{"$f":"IF(OR($F258=\"\",$G258=\"\"),\"\", $G258-$F258+1)","v":0},{"$f":"IF($E258=\"\", \"\", MAX(0, $E258-TODAY()+1))","v":0},{"$f":"IF($G258<>\"\", IF($G258<=$E258, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E258, \"En retard\", IF(TODAY()+7>=$E258, \"À risque (J-7)\", IF($H258=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H258<100, $E258<>\"\" , $E258<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D259=\"\",\"\",$D259)","v":0},{"$f":"IF(OR($D259=\"\",$E259=\"\"),\"\", $E259-$D259+1)","v":0},{"$f":"IF($F259=\"\",\"\",$F259)","v":0},{"$f":"IF(OR($F259=\"\",$G259=\"\"),\"\", $G259-$F259+1)","v":0},{"$f":"IF($E259=\"\", \"\", MAX(0, $E259-TODAY()+1))","v":0},{"$f":"IF($G259<>\"\", IF($G259<=$E259, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E259, \"En retard\", IF(TODAY()+7>=$E259, \"À risque (J-7)\", IF($H259=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H259<100, $E259<>\"\" , $E259<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D260=\"\",\"\",$D260)","v":0},{"$f":"IF(OR($D260=\"\",$E260=\"\"),\"\", $E260-$D260+1)","v":0},{"$f":"IF($F260=\"\",\"\",$F260)","v":0},{"$f":"IF(OR($F260=\"\",$G260=\"\"),\"\", $G260-$F260+1)","v":0},{"$f":"IF($E260=\"\", \"\", MAX(0, $E260-TODAY()+1))","v":0},{"$f":"IF($G260<>\"\", IF($G260<=$E260, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E260, \"En retard\", IF(TODAY()+7>=$E260, \"À risque (J-7)\", IF($H260=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H260<100, $E260<>\"\" , $E260<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D261=\"\",\"\",$D261)","v":0},{"$f":"IF(OR($D261=\"\",$E261=\"\"),\"\", $E261-$D261+1)","v":0},{"$f":"IF($F261=\"\",\"\",$F261)","v":0},{"$f":"IF(OR($F261=\"\",$G261=\"\"),\"\", $G261-$F261+1)","v":0},{"$f":"IF($E261=\"\", \"\", MAX(0, $E261-TODAY()+1))","v":0},{"$f":"IF($G261<>\"\", IF($G261<=$E261, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E261, \"En retard\", IF(TODAY()+7>=$E261, \"À risque (J-7)\", IF($H261=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H261<100, $E261<>\"\" , $E261<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D262=\"\",\"\",$D262)","v":0},{"$f":"IF(OR($D262=\"\",$E262=\"\"),\"\", $E262-$D262+1)","v":0},{"$f":"IF($F262=\"\",\"\",$F262)","v":0},{"$f":"IF(OR($F262=\"\",$G262=\"\"),\"\", $G262-$F262+1)","v":0},{"$f":"IF($E262=\"\", \"\", MAX(0, $E262-TODAY()+1))","v":0},{"$f":"IF($G262<>\"\", IF($G262<=$E262, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E262, \"En retard\", IF(TODAY()+7>=$E262, \"À risque (J-7)\", IF($H262=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H262<100, $E262<>\"\" , $E262<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D263=\"\",\"\",$D263)","v":0},{"$f":"IF(OR($D263=\"\",$E263=\"\"),\"\", $E263-$D263+1)","v":0},{"$f":"IF($F263=\"\",\"\",$F263)","v":0},{"$f":"IF(OR($F263=\"\",$G263=\"\"),\"\", $G263-$F263+1)","v":0},{"$f":"IF($E263=\"\", \"\", MAX(0, $E263-TODAY()+1))","v":0},{"$f":"IF($G263<>\"\", IF($G263<=$E263, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E263, \"En retard\", IF(TODAY()+7>=$E263, \"À risque (J-7)\", IF($H263=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H263<100, $E263<>\"\" , $E263<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D264=\"\",\"\",$D264)","v":0},{"$f":"IF(OR($D264=\"\",$E264=\"\"),\"\", $E264-$D264+1)","v":0},{"$f":"IF($F264=\"\",\"\",$F264)","v":0},{"$f":"IF(OR($F264=\"\",$G264=\"\"),\"\", $G264-$F264+1)","v":0},{"$f":"IF($E264=\"\", \"\", MAX(0, $E264-TODAY()+1))","v":0},{"$f":"IF($G264<>\"\", IF($G264<=$E264, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E264, \"En retard\", IF(TODAY()+7>=$E264, \"À risque (J-7)\", IF($H264=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H264<100, $E264<>\"\" , $E264<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D265=\"\",\"\",$D265)","v":0},{"$f":"IF(OR($D265=\"\",$E265=\"\"),\"\", $E265-$D265+1)","v":0},{"$f":"IF($F265=\"\",\"\",$F265)","v":0},{"$f":"IF(OR($F265=\"\",$G265=\"\"),\"\", $G265-$F265+1)","v":0},{"$f":"IF($E265=\"\", \"\", MAX(0, $E265-TODAY()+1))","v":0},{"$f":"IF($G265<>\"\", IF($G265<=$E265, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E265, \"En retard\", IF(TODAY()+7>=$E265, \"À risque (J-7)\", IF($H265=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H265<100, $E265<>\"\" , $E265<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D266=\"\",\"\",$D266)","v":0},{"$f":"IF(OR($D266=\"\",$E266=\"\"),\"\", $E266-$D266+1)","v":0},{"$f":"IF($F266=\"\",\"\",$F266)","v":0},{"$f":"IF(OR($F266=\"\",$G266=\"\"),\"\", $G266-$F266+1)","v":0},{"$f":"IF($E266=\"\", \"\", MAX(0, $E266-TODAY()+1))","v":0},{"$f":"IF($G266<>\"\", IF($G266<=$E266, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E266, \"En retard\", IF(TODAY()+7>=$E266, \"À risque (J-7)\", IF($H266=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H266<100, $E266<>\"\" , $E266<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D267=\"\",\"\",$D267)","v":0},{"$f":"IF(OR($D267=\"\",$E267=\"\"),\"\", $E267-$D267+1)","v":0},{"$f":"IF($F267=\"\",\"\",$F267)","v":0},{"$f":"IF(OR($F267=\"\",$G267=\"\"),\"\", $G267-$F267+1)","v":0},{"$f":"IF($E267=\"\", \"\", MAX(0, $E267-TODAY()+1))","v":0},{"$f":"IF($G267<>\"\", IF($G267<=$E267, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E267, \"En retard\", IF(TODAY()+7>=$E267, \"À risque (J-7)\", IF($H267=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H267<100, $E267<>\"\" , $E267<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D268=\"\",\"\",$D268)","v":0},{"$f":"IF(OR($D268=\"\",$E268=\"\"),\"\", $E268-$D268+1)","v":0},{"$f":"IF($F268=\"\",\"\",$F268)","v":0},{"$f":"IF(OR($F268=\"\",$G268=\"\"),\"\", $G268-$F268+1)","v":0},{"$f":"IF($E268=\"\", \"\", MAX(0, $E268-TODAY()+1))","v":0},{"$f":"IF($G268<>\"\", IF($G268<=$E268, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E268, \"En retard\", IF(TODAY()+7>=$E268, \"À risque (J-7)\", IF($H268=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H268<100, $E268<>\"\" , $E268<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D269=\"\",\"\",$D269)","v":0},{"$f":"IF(OR($D269=\"\",$E269=\"\"),\"\", $E269-$D269+1)","v":0},{"$f":"IF($F269=\"\",\"\",$F269)","v":0},{"$f":"IF(OR($F269=\"\",$G269=\"\"),\"\", $G269-$F269+1)","v":0},{"$f":"IF($E269=\"\", \"\", MAX(0, $E269-TODAY()+1))","v":0},{"$f":"IF($G269<>\"\", IF($G269<=$E269, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E269, \"En retard\", IF(TODAY()+7>=$E269, \"À risque (J-7)\", IF($H269=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H269<100, $E269<>\"\" , $E269<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D270=\"\",\"\",$D270)","v":0},{"$f":"IF(OR($D270=\"\",$E270=\"\"),\"\", $E270-$D270+1)","v":0},{"$f":"IF($F270=\"\",\"\",$F270)","v":0},{"$f":"IF(OR($F270=\"\",$G270=\"\"),\"\", $G270-$F270+1)","v":0},{"$f":"IF($E270=\"\", \"\", MAX(0, $E270-TODAY()+1))","v":0},{"$f":"IF($G270<>\"\", IF($G270<=$E270, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E270, \"En retard\", IF(TODAY()+7>=$E270, \"À risque (J-7)\", IF($H270=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H270<100, $E270<>\"\" , $E270<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D271=\"\",\"\",$D271)","v":0},{"$f":"IF(OR($D271=\"\",$E271=\"\"),\"\", $E271-$D271+1)","v":0},{"$f":"IF($F271=\"\",\"\",$F271)","v":0},{"$f":"IF(OR($F271=\"\",$G271=\"\"),\"\", $G271-$F271+1)","v":0},{"$f":"IF($E271=\"\", \"\", MAX(0, $E271-TODAY()+1))","v":0},{"$f":"IF($G271<>\"\", IF($G271<=$E271, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E271, \"En retard\", IF(TODAY()+7>=$E271, \"À risque (J-7)\", IF($H271=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H271<100, $E271<>\"\" , $E271<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D272=\"\",\"\",$D272)","v":0},{"$f":"IF(OR($D272=\"\",$E272=\"\"),\"\", $E272-$D272+1)","v":0},{"$f":"IF($F272=\"\",\"\",$F272)","v":0},{"$f":"IF(OR($F272=\"\",$G272=\"\"),\"\", $G272-$F272+1)","v":0},{"$f":"IF($E272=\"\", \"\", MAX(0, $E272-TODAY()+1))","v":0},{"$f":"IF($G272<>\"\", IF($G272<=$E272, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E272, \"En retard\", IF(TODAY()+7>=$E272, \"À risque (J-7)\", IF($H272=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H272<100, $E272<>\"\" , $E272<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D273=\"\",\"\",$D273)","v":0},{"$f":"IF(OR($D273=\"\",$E273=\"\"),\"\", $E273-$D273+1)","v":0},{"$f":"IF($F273=\"\",\"\",$F273)","v":0},{"$f":"IF(OR($F273=\"\",$G273=\"\"),\"\", $G273-$F273+1)","v":0},{"$f":"IF($E273=\"\", \"\", MAX(0, $E273-TODAY()+1))","v":0},{"$f":"IF($G273<>\"\", IF($G273<=$E273, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E273, \"En retard\", IF(TODAY()+7>=$E273, \"À risque (J-7)\", IF($H273=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H273<100, $E273<>\"\" , $E273<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D274=\"\",\"\",$D274)","v":0},{"$f":"IF(OR($D274=\"\",$E274=\"\"),\"\", $E274-$D274+1)","v":0},{"$f":"IF($F274=\"\",\"\",$F274)","v":0},{"$f":"IF(OR($F274=\"\",$G274=\"\"),\"\", $G274-$F274+1)","v":0},{"$f":"IF($E274=\"\", \"\", MAX(0, $E274-TODAY()+1))","v":0},{"$f":"IF($G274<>\"\", IF($G274<=$E274, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E274, \"En retard\", IF(TODAY()+7>=$E274, \"À risque (J-7)\", IF($H274=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H274<100, $E274<>\"\" , $E274<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D275=\"\",\"\",$D275)","v":0},{"$f":"IF(OR($D275=\"\",$E275=\"\"),\"\", $E275-$D275+1)","v":0},{"$f":"IF($F275=\"\",\"\",$F275)","v":0},{"$f":"IF(OR($F275=\"\",$G275=\"\"),\"\", $G275-$F275+1)","v":0},{"$f":"IF($E275=\"\", \"\", MAX(0, $E275-TODAY()+1))","v":0},{"$f":"IF($G275<>\"\", IF($G275<=$E275, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E275, \"En retard\", IF(TODAY()+7>=$E275, \"À risque (J-7)\", IF($H275=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H275<100, $E275<>\"\" , $E275<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D276=\"\",\"\",$D276)","v":0},{"$f":"IF(OR($D276=\"\",$E276=\"\"),\"\", $E276-$D276+1)","v":0},{"$f":"IF($F276=\"\",\"\",$F276)","v":0},{"$f":"IF(OR($F276=\"\",$G276=\"\"),\"\", $G276-$F276+1)","v":0},{"$f":"IF($E276=\"\", \"\", MAX(0, $E276-TODAY()+1))","v":0},{"$f":"IF($G276<>\"\", IF($G276<=$E276, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E276, \"En retard\", IF(TODAY()+7>=$E276, \"À risque (J-7)\", IF($H276=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H276<100, $E276<>\"\" , $E276<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D277=\"\",\"\",$D277)","v":0},{"$f":"IF(OR($D277=\"\",$E277=\"\"),\"\", $E277-$D277+1)","v":0},{"$f":"IF($F277=\"\",\"\",$F277)","v":0},{"$f":"IF(OR($F277=\"\",$G277=\"\"),\"\", $G277-$F277+1)","v":0},{"$f":"IF($E277=\"\", \"\", MAX(0, $E277-TODAY()+1))","v":0},{"$f":"IF($G277<>\"\", IF($G277<=$E277, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E277, \"En retard\", IF(TODAY()+7>=$E277, \"À risque (J-7)\", IF($H277=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H277<100, $E277<>\"\" , $E277<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D278=\"\",\"\",$D278)","v":0},{"$f":"IF(OR($D278=\"\",$E278=\"\"),\"\", $E278-$D278+1)","v":0},{"$f":"IF($F278=\"\",\"\",$F278)","v":0},{"$f":"IF(OR($F278=\"\",$G278=\"\"),\"\", $G278-$F278+1)","v":0},{"$f":"IF($E278=\"\", \"\", MAX(0, $E278-TODAY()+1))","v":0},{"$f":"IF($G278<>\"\", IF($G278<=$E278, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E278, \"En retard\", IF(TODAY()+7>=$E278, \"À risque (J-7)\", IF($H278=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H278<100, $E278<>\"\" , $E278<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D279=\"\",\"\",$D279)","v":0},{"$f":"IF(OR($D279=\"\",$E279=\"\"),\"\", $E279-$D279+1)","v":0},{"$f":"IF($F279=\"\",\"\",$F279)","v":0},{"$f":"IF(OR($F279=\"\",$G279=\"\"),\"\", $G279-$F279+1)","v":0},{"$f":"IF($E279=\"\", \"\", MAX(0, $E279-TODAY()+1))","v":0},{"$f":"IF($G279<>\"\", IF($G279<=$E279, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E279, \"En retard\", IF(TODAY()+7>=$E279, \"À risque (J-7)\", IF($H279=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H279<100, $E279<>\"\" , $E279<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D280=\"\",\"\",$D280)","v":0},{"$f":"IF(OR($D280=\"\",$E280=\"\"),\"\", $E280-$D280+1)","v":0},{"$f":"IF($F280=\"\",\"\",$F280)","v":0},{"$f":"IF(OR($F280=\"\",$G280=\"\"),\"\", $G280-$F280+1)","v":0},{"$f":"IF($E280=\"\", \"\", MAX(0, $E280-TODAY()+1))","v":0},{"$f":"IF($G280<>\"\", IF($G280<=$E280, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E280, \"En retard\", IF(TODAY()+7>=$E280, \"À risque (J-7)\", IF($H280=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H280<100, $E280<>\"\" , $E280<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D281=\"\",\"\",$D281)","v":0},{"$f":"IF(OR($D281=\"\",$E281=\"\"),\"\", $E281-$D281+1)","v":0},{"$f":"IF($F281=\"\",\"\",$F281)","v":0},{"$f":"IF(OR($F281=\"\",$G281=\"\"),\"\", $G281-$F281+1)","v":0},{"$f":"IF($E281=\"\", \"\", MAX(0, $E281-TODAY()+1))","v":0},{"$f":"IF($G281<>\"\", IF($G281<=$E281, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E281, \"En retard\", IF(TODAY()+7>=$E281, \"À risque (J-7)\", IF($H281=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H281<100, $E281<>\"\" , $E281<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D282=\"\",\"\",$D282)","v":0},{"$f":"IF(OR($D282=\"\",$E282=\"\"),\"\", $E282-$D282+1)","v":0},{"$f":"IF($F282=\"\",\"\",$F282)","v":0},{"$f":"IF(OR($F282=\"\",$G282=\"\"),\"\", $G282-$F282+1)","v":0},{"$f":"IF($E282=\"\", \"\", MAX(0, $E282-TODAY()+1))","v":0},{"$f":"IF($G282<>\"\", IF($G282<=$E282, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E282, \"En retard\", IF(TODAY()+7>=$E282, \"À risque (J-7)\", IF($H282=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H282<100, $E282<>\"\" , $E282<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D283=\"\",\"\",$D283)","v":0},{"$f":"IF(OR($D283=\"\",$E283=\"\"),\"\", $E283-$D283+1)","v":0},{"$f":"IF($F283=\"\",\"\",$F283)","v":0},{"$f":"IF(OR($F283=\"\",$G283=\"\"),\"\", $G283-$F283+1)","v":0},{"$f":"IF($E283=\"\", \"\", MAX(0, $E283-TODAY()+1))","v":0},{"$f":"IF($G283<>\"\", IF($G283<=$E283, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E283, \"En retard\", IF(TODAY()+7>=$E283, \"À risque (J-7)\", IF($H283=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H283<100, $E283<>\"\" , $E283<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D284=\"\",\"\",$D284)","v":0},{"$f":"IF(OR($D284=\"\",$E284=\"\"),\"\", $E284-$D284+1)","v":0},{"$f":"IF($F284=\"\",\"\",$F284)","v":0},{"$f":"IF(OR($F284=\"\",$G284=\"\"),\"\", $G284-$F284+1)","v":0},{"$f":"IF($E284=\"\", \"\", MAX(0, $E284-TODAY()+1))","v":0},{"$f":"IF($G284<>\"\", IF($G284<=$E284, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E284, \"En retard\", IF(TODAY()+7>=$E284, \"À risque (J-7)\", IF($H284=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H284<100, $E284<>\"\" , $E284<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D285=\"\",\"\",$D285)","v":0},{"$f":"IF(OR($D285=\"\",$E285=\"\"),\"\", $E285-$D285+1)","v":0},{"$f":"IF($F285=\"\",\"\",$F285)","v":0},{"$f":"IF(OR($F285=\"\",$G285=\"\"),\"\", $G285-$F285+1)","v":0},{"$f":"IF($E285=\"\", \"\", MAX(0, $E285-TODAY()+1))","v":0},{"$f":"IF($G285<>\"\", IF($G285<=$E285, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E285, \"En retard\", IF(TODAY()+7>=$E285, \"À risque (J-7)\", IF($H285=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H285<100, $E285<>\"\" , $E285<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D286=\"\",\"\",$D286)","v":0},{"$f":"IF(OR($D286=\"\",$E286=\"\"),\"\", $E286-$D286+1)","v":0},{"$f":"IF($F286=\"\",\"\",$F286)","v":0},{"$f":"IF(OR($F286=\"\",$G286=\"\"),\"\", $G286-$F286+1)","v":0},{"$f":"IF($E286=\"\", \"\", MAX(0, $E286-TODAY()+1))","v":0},{"$f":"IF($G286<>\"\", IF($G286<=$E286, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E286, \"En retard\", IF(TODAY()+7>=$E286, \"À risque (J-7)\", IF($H286=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H286<100, $E286<>\"\" , $E286<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D287=\"\",\"\",$D287)","v":0},{"$f":"IF(OR($D287=\"\",$E287=\"\"),\"\", $E287-$D287+1)","v":0},{"$f":"IF($F287=\"\",\"\",$F287)","v":0},{"$f":"IF(OR($F287=\"\",$G287=\"\"),\"\", $G287-$F287+1)","v":0},{"$f":"IF($E287=\"\", \"\", MAX(0, $E287-TODAY()+1))","v":0},{"$f":"IF($G287<>\"\", IF($G287<=$E287, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E287, \"En retard\", IF(TODAY()+7>=$E287, \"À risque (J-7)\", IF($H287=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H287<100, $E287<>\"\" , $E287<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D288=\"\",\"\",$D288)","v":0},{"$f":"IF(OR($D288=\"\",$E288=\"\"),\"\", $E288-$D288+1)","v":0},{"$f":"IF($F288=\"\",\"\",$F288)","v":0},{"$f":"IF(OR($F288=\"\",$G288=\"\"),\"\", $G288-$F288+1)","v":0},{"$f":"IF($E288=\"\", \"\", MAX(0, $E288-TODAY()+1))","v":0},{"$f":"IF($G288<>\"\", IF($G288<=$E288, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E288, \"En retard\", IF(TODAY()+7>=$E288, \"À risque (J-7)\", IF($H288=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H288<100, $E288<>\"\" , $E288<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D289=\"\",\"\",$D289)","v":0},{"$f":"IF(OR($D289=\"\",$E289=\"\"),\"\", $E289-$D289+1)","v":0},{"$f":"IF($F289=\"\",\"\",$F289)","v":0},{"$f":"IF(OR($F289=\"\",$G289=\"\"),\"\", $G289-$F289+1)","v":0},{"$f":"IF($E289=\"\", \"\", MAX(0, $E289-TODAY()+1))","v":0},{"$f":"IF($G289<>\"\", IF($G289<=$E289, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E289, \"En retard\", IF(TODAY()+7>=$E289, \"À risque (J-7)\", IF($H289=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H289<100, $E289<>\"\" , $E289<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D290=\"\",\"\",$D290)","v":0},{"$f":"IF(OR($D290=\"\",$E290=\"\"),\"\", $E290-$D290+1)","v":0},{"$f":"IF($F290=\"\",\"\",$F290)","v":0},{"$f":"IF(OR($F290=\"\",$G290=\"\"),\"\", $G290-$F290+1)","v":0},{"$f":"IF($E290=\"\", \"\", MAX(0, $E290-TODAY()+1))","v":0},{"$f":"IF($G290<>\"\", IF($G290<=$E290, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E290, \"En retard\", IF(TODAY()+7>=$E290, \"À risque (J-7)\", IF($H290=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H290<100, $E290<>\"\" , $E290<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D291=\"\",\"\",$D291)","v":0},{"$f":"IF(OR($D291=\"\",$E291=\"\"),\"\", $E291-$D291+1)","v":0},{"$f":"IF($F291=\"\",\"\",$F291)","v":0},{"$f":"IF(OR($F291=\"\",$G291=\"\"),\"\", $G291-$F291+1)","v":0},{"$f":"IF($E291=\"\", \"\", MAX(0, $E291-TODAY()+1))","v":0},{"$f":"IF($G291<>\"\", IF($G291<=$E291, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E291, \"En retard\", IF(TODAY()+7>=$E291, \"À risque (J-7)\", IF($H291=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H291<100, $E291<>\"\" , $E291<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D292=\"\",\"\",$D292)","v":0},{"$f":"IF(OR($D292=\"\",$E292=\"\"),\"\", $E292-$D292+1)","v":0},{"$f":"IF($F292=\"\",\"\",$F292)","v":0},{"$f":"IF(OR($F292=\"\",$G292=\"\"),\"\", $G292-$F292+1)","v":0},{"$f":"IF($E292=\"\", \"\", MAX(0, $E292-TODAY()+1))","v":0},{"$f":"IF($G292<>\"\", IF($G292<=$E292, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E292, \"En retard\", IF(TODAY()+7>=$E292, \"À risque (J-7)\", IF($H292=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H292<100, $E292<>\"\" , $E292<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D293=\"\",\"\",$D293)","v":0},{"$f":"IF(OR($D293=\"\",$E293=\"\"),\"\", $E293-$D293+1)","v":0},{"$f":"IF($F293=\"\",\"\",$F293)","v":0},{"$f":"IF(OR($F293=\"\",$G293=\"\"),\"\", $G293-$F293+1)","v":0},{"$f":"IF($E293=\"\", \"\", MAX(0, $E293-TODAY()+1))","v":0},{"$f":"IF($G293<>\"\", IF($G293<=$E293, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E293, \"En retard\", IF(TODAY()+7>=$E293, \"À risque (J-7)\", IF($H293=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H293<100, $E293<>\"\" , $E293<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D294=\"\",\"\",$D294)","v":0},{"$f":"IF(OR($D294=\"\",$E294=\"\"),\"\", $E294-$D294+1)","v":0},{"$f":"IF($F294=\"\",\"\",$F294)","v":0},{"$f":"IF(OR($F294=\"\",$G294=\"\"),\"\", $G294-$F294+1)","v":0},{"$f":"IF($E294=\"\", \"\", MAX(0, $E294-TODAY()+1))","v":0},{"$f":"IF($G294<>\"\", IF($G294<=$E294, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E294, \"En retard\", IF(TODAY()+7>=$E294, \"À risque (J-7)\", IF($H294=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H294<100, $E294<>\"\" , $E294<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D295=\"\",\"\",$D295)","v":0},{"$f":"IF(OR($D295=\"\",$E295=\"\"),\"\", $E295-$D295+1)","v":0},{"$f":"IF($F295=\"\",\"\",$F295)","v":0},{"$f":"IF(OR($F295=\"\",$G295=\"\"),\"\", $G295-$F295+1)","v":0},{"$f":"IF($E295=\"\", \"\", MAX(0, $E295-TODAY()+1))","v":0},{"$f":"IF($G295<>\"\", IF($G295<=$E295, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E295, \"En retard\", IF(TODAY()+7>=$E295, \"À risque (J-7)\", IF($H295=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H295<100, $E295<>\"\" , $E295<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D296=\"\",\"\",$D296)","v":0},{"$f":"IF(OR($D296=\"\",$E296=\"\"),\"\", $E296-$D296+1)","v":0},{"$f":"IF($F296=\"\",\"\",$F296)","v":0},{"$f":"IF(OR($F296=\"\",$G296=\"\"),\"\", $G296-$F296+1)","v":0},{"$f":"IF($E296=\"\", \"\", MAX(0, $E296-TODAY()+1))","v":0},{"$f":"IF($G296<>\"\", IF($G296<=$E296, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E296, \"En retard\", IF(TODAY()+7>=$E296, \"À risque (J-7)\", IF($H296=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H296<100, $E296<>\"\" , $E296<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D297=\"\",\"\",$D297)","v":0},{"$f":"IF(OR($D297=\"\",$E297=\"\"),\"\", $E297-$D297+1)","v":0},{"$f":"IF($F297=\"\",\"\",$F297)","v":0},{"$f":"IF(OR($F297=\"\",$G297=\"\"),\"\", $G297-$F297+1)","v":0},{"$f":"IF($E297=\"\", \"\", MAX(0, $E297-TODAY()+1))","v":0},{"$f":"IF($G297<>\"\", IF($G297<=$E297, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E297, \"En retard\", IF(TODAY()+7>=$E297, \"À risque (J-7)\", IF($H297=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H297<100, $E297<>\"\" , $E297<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D298=\"\",\"\",$D298)","v":0},{"$f":"IF(OR($D298=\"\",$E298=\"\"),\"\", $E298-$D298+1)","v":0},{"$f":"IF($F298=\"\",\"\",$F298)","v":0},{"$f":"IF(OR($F298=\"\",$G298=\"\"),\"\", $G298-$F298+1)","v":0},{"$f":"IF($E298=\"\", \"\", MAX(0, $E298-TODAY()+1))","v":0},{"$f":"IF($G298<>\"\", IF($G298<=$E298, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E298, \"En retard\", IF(TODAY()+7>=$E298, \"À risque (J-7)\", IF($H298=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H298<100, $E298<>\"\" , $E298<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D299=\"\",\"\",$D299)","v":0},{"$f":"IF(OR($D299=\"\",$E299=\"\"),\"\", $E299-$D299+1)","v":0},{"$f":"IF($F299=\"\",\"\",$F299)","v":0},{"$f":"IF(OR($F299=\"\",$G299=\"\"),\"\", $G299-$F299+1)","v":0},{"$f":"IF($E299=\"\", \"\", MAX(0, $E299-TODAY()+1))","v":0},{"$f":"IF($G299<>\"\", IF($G299<=$E299, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E299, \"En retard\", IF(TODAY()+7>=$E299, \"À risque (J-7)\", IF($H299=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H299<100, $E299<>\"\" , $E299<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D300=\"\",\"\",$D300)","v":0},{"$f":"IF(OR($D300=\"\",$E300=\"\"),\"\", $E300-$D300+1)","v":0},{"$f":"IF($F300=\"\",\"\",$F300)","v":0},{"$f":"IF(OR($F300=\"\",$G300=\"\"),\"\", $G300-$F300+1)","v":0},{"$f":"IF($E300=\"\", \"\", MAX(0, $E300-TODAY()+1))","v":0},{"$f":"IF($G300<>\"\", IF($G300<=$E300, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E300, \"En retard\", IF(TODAY()+7>=$E300, \"À risque (J-7)\", IF($H300=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H300<100, $E300<>\"\" , $E300<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D301=\"\",\"\",$D301)","v":0},{"$f":"IF(OR($D301=\"\",$E301=\"\"),\"\", $E301-$D301+1)","v":0},{"$f":"IF($F301=\"\",\"\",$F301)","v":0},{"$f":"IF(OR($F301=\"\",$G301=\"\"),\"\", $G301-$F301+1)","v":0},{"$f":"IF($E301=\"\", \"\", MAX(0, $E301-TODAY()+1))","v":0},{"$f":"IF($G301<>\"\", IF($G301<=$E301, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E301, \"En retard\", IF(TODAY()+7>=$E301, \"À risque (J-7)\", IF($H301=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H301<100, $E301<>\"\" , $E301<=TODAY()+14), \"Oui\", \"Non\")","v":0}]
[{"$nulls":9},{"$f":"IF($D302=\"\",\"\",$D302)","v":0},{"$f":"IF(OR($D302=\"\",$E302=\"\"),\"\", $E302-$D302+1)","v":0},{"$f":"IF($F302=\"\",\"\",$F302)","v":0},{"$f":"IF(OR($F302=\"\",$G302=\"\"),\"\", $G302-$F302+1)","v":0},{"$f":"IF($E302=\"\", \"\", MAX(0, $E302-TODAY()+1))","v":0},{"$f":"IF($G302<>\"\", IF($G302<=$E302, \"Livré à l'heure\", \"Livré en retard\"), IF(TODAY()>$E302, \"En retard\", IF(TODAY()+7>=$E302, \"À risque (J-7)\", IF($H302=0, \"Planifié\", \"En cours\"))))","v":0},{"$f":"IF(AND($H302<100, $E302<>\"\" , $E302<=TODAY()+14), \"Oui\", \"Non\")","v":0}]

{"sheet":"KPI_Dashboard","index":2,"n_rows":22,"n_cols":3,"rows_kept":22}
["KPI Projet — Tableau de bord (étendu)"]
[]
["KPI calculés automatiquement depuis Timeline_Pro (modifier les seuils si besoin).","Valeur"]
[]
["Indicateur","Valeur","Note"]
["Tâches totales",{"$f":"COUNTA(Timeline_Pro!$A$4:$A$302)","v":0}]
["Tâches livrées",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,\"Livré à l'heure\")+COUNTIF(Timeline_Pro!$O$4:$O$302,\"Livré en retard\")","v":0}]
["On-time delivery (%)",{"$f":"IF(B7=0,\"\", COUNTIF(Timeline_Pro!$O$4:$O$302,\"Livré à l'heure\")/B7)","v":{"v":0,"d":"0%"}}]
["Tâches en retard (#)",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,\"En retard\")","v":0}]
["Tâches à risque J-7 (#)",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,\"À risque (J-7)\")","v":0}]
["Tâches critiques (14j) (#)",{"$f":"COUNTIF(Timeline_Pro!$P$4:$P$302,\"Oui\")","v":0}]
["% d’avancement moyen",{"$f":"IF(B6=0,\"\",AVERAGE(Timeline_Pro!$H$4:$H$302))","v":{"v":0,"d":"0%"}}]
[]
[]
["Répartition des tâches par statut"]
["Statut","Comptage"]
["Planifié",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A17)","v":0}]
["En cours",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A18)","v":0}]
["À risque (J-7)",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A19)","v":0}]
["En retard",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A20)","v":0}]
["Livré à l'heure",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A21)","v":0}]
["Livré en retard",{"$f":"COUNTIF(Timeline_Pro!$O$4:$O$302,A22)","v":0}]