{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Shifts","Planning_CallCenter","Heures_Shifts","Couverture"],"read":"whole","date_system":"1900"}

{"sheet":"Shifts","index":0,"n_rows":7,"n_cols":3,"rows_kept":7}
["Code","Début","Fin"]
["M","08:00:00","16:00:00"]
["J","09:00:00","17:00:00"]
["S","12:00:00","20:00:00"]
["E","10:00:00","18:00:00"]
["N","20:00:00","04:00:00"]
["OFF"]

{"sheet":"Planning_CallCenter","index":1,"n_rows":15,"n_cols":10,"rows_kept":15}
["Planning hebdomadaire — Call Center (shifts)"]
[]
["Saisir les codes de shifts (liste) par jour et agent. Couverture horaire calculée par jour."]
["Semaine débutant le","2025-10-27"]
[]
[]
["ID","Agent","Rôle","Lun","Mar","Mer","Jeu","Ven","Sam","Dim"]
[1,"Amine L.","Conseiller","M","M","J","J","S","OFF","OFF"]
[2,"Sophie D.","Conseillère","J","J","S","S","M","OFF","OFF"]
[3,"Karim B.","Conseiller","M","M","J","J","S","OFF","OFF"]
[4,"Julie P.","Superviseure","J","J","S","S","M","OFF","OFF"]
[5,"Hassan R.","Conseiller","M","M","J","J","S","OFF","OFF"]
[6,"Nadia T.","Conseillère","J","J","S","S","M","OFF","OFF"]
[7,"Yanis C.","Conseiller","M","M","J","J","S","OFF","OFF"]
[8,"Chloé M.","Conseillère","J","J","S","S","M","OFF","OFF"]

{"sheet":"Heures_Shifts","index":2,"n_rows":22,"n_cols":41,"rows_kept":22,"hidden":true}
["Helper: start/end times per day from codes"]
[]
["Lun Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Lun Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!D47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Mar Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Mar Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!E47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Mer Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Mer Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!F47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Jeu Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Jeu Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!G47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Ven Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Ven Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!H47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Sam Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Sam Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!I47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]
[]
["Dim Débuts",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J8,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J9,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J10,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J11,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J12,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J13,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J14,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J15,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J16,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J17,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J18,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J19,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J20,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J21,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J22,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J23,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J24,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J25,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J26,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J27,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J28,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J29,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J30,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J31,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J32,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J33,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J34,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J35,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J36,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J37,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J38,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J39,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J40,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J41,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J42,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J43,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J44,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J45,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J46,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J47,Shifts!$A$2:$C$10,2,FALSE),)","v":"00:00:00"}]
["Dim Fins",{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J8,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J9,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J10,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J11,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J12,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J13,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J14,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J15,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J16,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J17,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J18,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J19,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J20,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J21,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J22,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J23,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J24,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J25,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J26,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J27,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J28,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J29,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J30,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J31,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J32,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J33,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J34,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J35,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J36,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J37,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J38,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J39,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J40,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J41,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J42,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J43,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J44,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J45,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J46,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"},{"$f":"IFERROR(VLOOKUP(Planning_CallCenter!J47,Shifts!$A$2:$C$10,3,FALSE),)","v":"00:00:00"}]

{"sheet":"Couverture","index":3,"n_rows":108,"n_cols":5,"rows_kept":108}
["Couverture horaire vs besoin (08:00 → 20:00)"]
[]
["Renseigner 'Besoin' par heure. 'Planifié' s’actualise selon les shifts."]
[]
["Lun","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B6,Heures_Shifts!$B$4:$AO$4,\">\"&B6)","v":0},{"$f":"D6-C6","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B7,Heures_Shifts!$B$4:$AO$4,\">\"&B7)","v":0},{"$f":"D7-C7","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B8,Heures_Shifts!$B$4:$AO$4,\">\"&B8)","v":0},{"$f":"D8-C8","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B9,Heures_Shifts!$B$4:$AO$4,\">\"&B9)","v":0},{"$f":"D9-C9","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B10,Heures_Shifts!$B$4:$AO$4,\">\"&B10)","v":0},{"$f":"D10-C10","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B11,Heures_Shifts!$B$4:$AO$4,\">\"&B11)","v":0},{"$f":"D11-C11","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B12,Heures_Shifts!$B$4:$AO$4,\">\"&B12)","v":0},{"$f":"D12-C12","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B13,Heures_Shifts!$B$4:$AO$4,\">\"&B13)","v":0},{"$f":"D13-C13","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B14,Heures_Shifts!$B$4:$AO$4,\">\"&B14)","v":0},{"$f":"D14-C14","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B15,Heures_Shifts!$B$4:$AO$4,\">\"&B15)","v":0},{"$f":"D15-C15","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B16,Heures_Shifts!$B$4:$AO$4,\">\"&B16)","v":0},{"$f":"D16-C16","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B17,Heures_Shifts!$B$4:$AO$4,\">\"&B17)","v":0},{"$f":"D17-C17","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$3:$AO$3,\"<=\"&B18,Heures_Shifts!$B$4:$AO$4,\">\"&B18)","v":0},{"$f":"D18-C18","v":0}]
[]
["Mar","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B21,Heures_Shifts!$B$7:$AO$7,\">\"&B21)","v":0},{"$f":"D21-C21","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B22,Heures_Shifts!$B$7:$AO$7,\">\"&B22)","v":0},{"$f":"D22-C22","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B23,Heures_Shifts!$B$7:$AO$7,\">\"&B23)","v":0},{"$f":"D23-C23","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B24,Heures_Shifts!$B$7:$AO$7,\">\"&B24)","v":0},{"$f":"D24-C24","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B25,Heures_Shifts!$B$7:$AO$7,\">\"&B25)","v":0},{"$f":"D25-C25","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B26,Heures_Shifts!$B$7:$AO$7,\">\"&B26)","v":0},{"$f":"D26-C26","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B27,Heures_Shifts!$B$7:$AO$7,\">\"&B27)","v":0},{"$f":"D27-C27","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B28,Heures_Shifts!$B$7:$AO$7,\">\"&B28)","v":0},{"$f":"D28-C28","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B29,Heures_Shifts!$B$7:$AO$7,\">\"&B29)","v":0},{"$f":"D29-C29","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B30,Heures_Shifts!$B$7:$AO$7,\">\"&B30)","v":0},{"$f":"D30-C30","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B31,Heures_Shifts!$B$7:$AO$7,\">\"&B31)","v":0},{"$f":"D31-C31","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B32,Heures_Shifts!$B$7:$AO$7,\">\"&B32)","v":0},{"$f":"D32-C32","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$6:$AO$6,\"<=\"&B33,Heures_Shifts!$B$7:$AO$7,\">\"&B33)","v":0},{"$f":"D33-C33","v":0}]
[]
["Mer","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B36,Heures_Shifts!$B$10:$AO$10,\">\"&B36)","v":0},{"$f":"D36-C36","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B37,Heures_Shifts!$B$10:$AO$10,\">\"&B37)","v":0},{"$f":"D37-C37","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B38,Heures_Shifts!$B$10:$AO$10,\">\"&B38)","v":0},{"$f":"D38-C38","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B39,Heures_Shifts!$B$10:$AO$10,\">\"&B39)","v":0},{"$f":"D39-C39","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B40,Heures_Shifts!$B$10:$AO$10,\">\"&B40)","v":0},{"$f":"D40-C40","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B41,Heures_Shifts!$B$10:$AO$10,\">\"&B41)","v":0},{"$f":"D41-C41","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B42,Heures_Shifts!$B$10:$AO$10,\">\"&B42)","v":0},{"$f":"D42-C42","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B43,Heures_Shifts!$B$10:$AO$10,\">\"&B43)","v":0},{"$f":"D43-C43","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B44,Heures_Shifts!$B$10:$AO$10,\">\"&B44)","v":0},{"$f":"D44-C44","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B45,Heures_Shifts!$B$10:$AO$10,\">\"&B45)","v":0},{"$f":"D45-C45","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B46,Heures_Shifts!$B$10:$AO$10,\">\"&B46)","v":0},{"$f":"D46-C46","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B47,Heures_Shifts!$B$10:$AO$10,\">\"&B47)","v":0},{"$f":"D47-C47","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$9:$AO$9,\"<=\"&B48,Heures_Shifts!$B$10:$AO$10,\">\"&B48)","v":0},{"$f":"D48-C48","v":0}]
[]
["Jeu","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B51,Heures_Shifts!$B$13:$AO$13,\">\"&B51)","v":0},{"$f":"D51-C51","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B52,Heures_Shifts!$B$13:$AO$13,\">\"&B52)","v":0},{"$f":"D52-C52","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B53,Heures_Shifts!$B$13:$AO$13,\">\"&B53)","v":0},{"$f":"D53-C53","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B54,Heures_Shifts!$B$13:$AO$13,\">\"&B54)","v":0},{"$f":"D54-C54","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B55,Heures_Shifts!$B$13:$AO$13,\">\"&B55)","v":0},{"$f":"D55-C55","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B56,Heures_Shifts!$B$13:$AO$13,\">\"&B56)","v":0},{"$f":"D56-C56","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B57,Heures_Shifts!$B$13:$AO$13,\">\"&B57)","v":0},{"$f":"D57-C57","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B58,Heures_Shifts!$B$13:$AO$13,\">\"&B58)","v":0},{"$f":"D58-C58","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B59,Heures_Shifts!$B$13:$AO$13,\">\"&B59)","v":0},{"$f":"D59-C59","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B60,Heures_Shifts!$B$13:$AO$13,\">\"&B60)","v":0},{"$f":"D60-C60","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B61,Heures_Shifts!$B$13:$AO$13,\">\"&B61)","v":0},{"$f":"D61-C61","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B62,Heures_Shifts!$B$13:$AO$13,\">\"&B62)","v":0},{"$f":"D62-C62","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$12:$AO$12,\"<=\"&B63,Heures_Shifts!$B$13:$AO$13,\">\"&B63)","v":0},{"$f":"D63-C63","v":0}]
[]
["Ven","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B66,Heures_Shifts!$B$16:$AO$16,\">\"&B66)","v":0},{"$f":"D66-C66","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B67,Heures_Shifts!$B$16:$AO$16,\">\"&B67)","v":0},{"$f":"D67-C67","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B68,Heures_Shifts!$B$16:$AO$16,\">\"&B68)","v":0},{"$f":"D68-C68","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B69,Heures_Shifts!$B$16:$AO$16,\">\"&B69)","v":0},{"$f":"D69-C69","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B70,Heures_Shifts!$B$16:$AO$16,\">\"&B70)","v":0},{"$f":"D70-C70","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B71,Heures_Shifts!$B$16:$AO$16,\">\"&B71)","v":0},{"$f":"D71-C71","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B72,Heures_Shifts!$B$16:$AO$16,\">\"&B72)","v":0},{"$f":"D72-C72","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B73,Heures_Shifts!$B$16:$AO$16,\">\"&B73)","v":0},{"$f":"D73-C73","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B74,Heures_Shifts!$B$16:$AO$16,\">\"&B74)","v":0},{"$f":"D74-C74","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B75,Heures_Shifts!$B$16:$AO$16,\">\"&B75)","v":0},{"$f":"D75-C75","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B76,Heures_Shifts!$B$16:$AO$16,\">\"&B76)","v":0},{"$f":"D76-C76","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B77,Heures_Shifts!$B$16:$AO$16,\">\"&B77)","v":0},{"$f":"D77-C77","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$15:$AO$15,\"<=\"&B78,Heures_Shifts!$B$16:$AO$16,\">\"&B78)","v":0},{"$f":"D78-C78","v":0}]
[]
["Sam","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B81,Heures_Shifts!$B$19:$AO$19,\">\"&B81)","v":0},{"$f":"D81-C81","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B82,Heures_Shifts!$B$19:$AO$19,\">\"&B82)","v":0},{"$f":"D82-C82","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B83,Heures_Shifts!$B$19:$AO$19,\">\"&B83)","v":0},{"$f":"D83-C83","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B84,Heures_Shifts!$B$19:$AO$19,\">\"&B84)","v":0},{"$f":"D84-C84","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B85,Heures_Shifts!$B$19:$AO$19,\">\"&B85)","v":0},{"$f":"D85-C85","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B86,Heures_Shifts!$B$19:$AO$19,\">\"&B86)","v":0},{"$f":"D86-C86","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B87,Heures_Shifts!$B$19:$AO$19,\">\"&B87)","v":0},{"$f":"D87-C87","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B88,Heures_Shifts!$B$19:$AO$19,\">\"&B88)","v":0},{"$f":"D88-C88","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B89,Heures_Shifts!$B$19:$AO$19,\">\"&B89)","v":0},{"$f":"D89-C89","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B90,Heures_Shifts!$B$19:$AO$19,\">\"&B90)","v":0},{"$f":"D90-C90","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B91,Heures_Shifts!$B$19:$AO$19,\">\"&B91)","v":0},{"$f":"D91-C91","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B92,Heures_Shifts!$B$19:$AO$19,\">\"&B92)","v":0},{"$f":"D92-C92","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$18:$AO$18,\"<=\"&B93,Heures_Shifts!$B$19:$AO$19,\">\"&B93)","v":0},{"$f":"D93-C93","v":0}]
[]
["Dim","Heure","Besoin","Planifié","Écart"]
[null,"08:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B96,Heures_Shifts!$B$22:$AO$22,\">\"&B96)","v":0},{"$f":"D96-C96","v":0}]
[null,"09:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B97,Heures_Shifts!$B$22:$AO$22,\">\"&B97)","v":0},{"$f":"D97-C97","v":0}]
[null,"10:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B98,Heures_Shifts!$B$22:$AO$22,\">\"&B98)","v":0},{"$f":"D98-C98","v":0}]
[null,"11:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B99,Heures_Shifts!$B$22:$AO$22,\">\"&B99)","v":0},{"$f":"D99-C99","v":0}]
[null,"12:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B100,Heures_Shifts!$B$22:$AO$22,\">\"&B100)","v":0},{"$f":"D100-C100","v":0}]
[null,"13:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B101,Heures_Shifts!$B$22:$AO$22,\">\"&B101)","v":0},{"$f":"D101-C101","v":0}]
[null,"14:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B102,Heures_Shifts!$B$22:$AO$22,\">\"&B102)","v":0},{"$f":"D102-C102","v":0}]
[null,"15:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B103,Heures_Shifts!$B$22:$AO$22,\">\"&B103)","v":0},{"$f":"D103-C103","v":0}]
[null,"16:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B104,Heures_Shifts!$B$22:$AO$22,\">\"&B104)","v":0},{"$f":"D104-C104","v":0}]
[null,"17:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B105,Heures_Shifts!$B$22:$AO$22,\">\"&B105)","v":0},{"$f":"D105-C105","v":0}]
[null,"18:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B106,Heures_Shifts!$B$22:$AO$22,\">\"&B106)","v":0},{"$f":"D106-C106","v":0}]
[null,"19:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B107,Heures_Shifts!$B$22:$AO$22,\">\"&B107)","v":0},{"$f":"D107-C107","v":0}]
[null,"20:00:00",null,{"$f":"COUNTIFS(Heures_Shifts!$B$21:$AO$21,\"<=\"&B108,Heures_Shifts!$B$22:$AO$22,\">\"&B108)","v":0},{"$f":"D108-C108","v":0}]