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

{"sheet":"Shifts","index":0,"n_rows":7,"n_cols":4,"rows_kept":7}
["Code","Début","Fin","Durée (h)"]
["M","08:00:00","16:00:00",{"$f":"IF(C2>=B2,(C2-B2)*24,(1-(B2-C2))*24)","v":0}]
["J","09:00:00","17:00:00",{"$f":"IF(C3>=B3,(C3-B3)*24,(1-(B3-C3))*24)","v":0}]
["S","12:00:00","20:00:00",{"$f":"IF(C4>=B4,(C4-B4)*24,(1-(B4-C4))*24)","v":0}]
["E","10:00:00","18:00:00",{"$f":"IF(C5>=B5,(C5-B5)*24,(1-(B5-C5))*24)","v":0}]
["N","20:00:00","04:00:00",{"$f":"IF(C6>=B6,(C6-B6)*24,(1-(B6-C6))*24)","v":0}]
["OFF",null,null,{"$f":"IF(C7>=B7,(C7-B7)*24,(1-(B7-C7))*24)","v":0}]

{"sheet":"Planning_CallCenter","index":1,"n_rows":23,"n_cols":11,"rows_kept":23}
["Planning hebdomadaire — Call Center (shifts + couverture + synthèse)"]
[]
["Semaine débutant le","2025-10-27"]
["Saisir les codes de shifts (liste) par jour et agent ; heures hebdo et couverture se calculent."]
[]
[]
["ID","Agent","Rôle","Lun","Mar","Mer","Jeu","Ven","Sam","Dim","Heures hebdo"]
[1,"Amine L.","Conseiller","M","M","J","J","S","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I8,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J8,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[2,"Sophie D.","Conseillère","J","J","S","S","M","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I9,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J9,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[3,"Karim B.","Conseiller","E","E","M","M","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I10,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J10,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[4,"Julie P.","Superviseure","S","S","E","E","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I11,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J11,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[5,"Hassan R.","Conseiller","M","M","J","J","S","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I12,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J12,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[6,"Nadia T.","Conseillère","J","J","S","S","M","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I13,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J13,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[7,"Yanis C.","Conseiller","E","E","M","M","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I14,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J14,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[8,"Chloé M.","Conseillère","S","S","E","E","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I15,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J15,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[9,"Mohamed N.","Conseiller","M","M","J","J","S","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I16,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J16,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[10,"Lina S.","Conseillère","J","J","S","S","M","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I17,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J17,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[11,"Rachid A.","Conseiller","E","E","M","M","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I18,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J18,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[12,"Élodie K.","Conseillère","S","S","E","E","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I19,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J19,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[13,"Omar T.","Conseiller","M","M","J","J","S","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I20,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J20,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[14,"Salma F.","Conseillère","J","J","S","S","M","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I21,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J21,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[15,"Noa G.","Conseiller","E","E","M","M","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I22,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J22,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]
[16,"Maya R.","Conseillère","S","S","E","E","J","OFF","OFF",{"$f":"IFERROR(VLOOKUP(D23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(E23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(F23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(G23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(H23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(I23,Shifts!$A$2:$D$10,4,FALSE),0)+IFERROR(VLOOKUP(J23,Shifts!$A$2:$D$10,4,FALSE),0)","v":0}]

{"sheet":"Heures_Shifts","index":2,"n_rows":29,"n_cols":37,"rows_kept":29,"hidden":true}
["Helper: heures par agent issues des 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"}]
["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"}]
["Lun Durée (h)",{"$f":"IF(B4>=B3,(B4-B3)*24,(1-(B3-B4))*24)","v":0},{"$f":"IF(C4>=C3,(C4-C3)*24,(1-(C3-C4))*24)","v":0},{"$f":"IF(D4>=D3,(D4-D3)*24,(1-(D3-D4))*24)","v":0},{"$f":"IF(E4>=E3,(E4-E3)*24,(1-(E3-E4))*24)","v":0},{"$f":"IF(F4>=F3,(F4-F3)*24,(1-(F3-F4))*24)","v":0},{"$f":"IF(G4>=G3,(G4-G3)*24,(1-(G3-G4))*24)","v":0},{"$f":"IF(H4>=H3,(H4-H3)*24,(1-(H3-H4))*24)","v":0},{"$f":"IF(I4>=I3,(I4-I3)*24,(1-(I3-I4))*24)","v":0},{"$f":"IF(J4>=J3,(J4-J3)*24,(1-(J3-J4))*24)","v":0},{"$f":"IF(K4>=K3,(K4-K3)*24,(1-(K3-K4))*24)","v":0},{"$f":"IF(L4>=L3,(L4-L3)*24,(1-(L3-L4))*24)","v":0},{"$f":"IF(M4>=M3,(M4-M3)*24,(1-(M3-M4))*24)","v":0},{"$f":"IF(N4>=N3,(N4-N3)*24,(1-(N3-N4))*24)","v":0},{"$f":"IF(O4>=O3,(O4-O3)*24,(1-(O3-O4))*24)","v":0},{"$f":"IF(P4>=P3,(P4-P3)*24,(1-(P3-P4))*24)","v":0},{"$f":"IF(Q4>=Q3,(Q4-Q3)*24,(1-(Q3-Q4))*24)","v":0},{"$f":"IF(R4>=R3,(R4-R3)*24,(1-(R3-R4))*24)","v":0},{"$f":"IF(S4>=S3,(S4-S3)*24,(1-(S3-S4))*24)","v":0},{"$f":"IF(T4>=T3,(T4-T3)*24,(1-(T3-T4))*24)","v":0},{"$f":"IF(U4>=U3,(U4-U3)*24,(1-(U3-U4))*24)","v":0},{"$f":"IF(V4>=V3,(V4-V3)*24,(1-(V3-V4))*24)","v":0},{"$f":"IF(W4>=W3,(W4-W3)*24,(1-(W3-W4))*24)","v":0},{"$f":"IF(X4>=X3,(X4-X3)*24,(1-(X3-X4))*24)","v":0},{"$f":"IF(Y4>=Y3,(Y4-Y3)*24,(1-(Y3-Y4))*24)","v":0},{"$f":"IF(Z4>=Z3,(Z4-Z3)*24,(1-(Z3-Z4))*24)","v":0},{"$f":"IF(AA4>=AA3,(AA4-AA3)*24,(1-(AA3-AA4))*24)","v":0},{"$f":"IF(AB4>=AB3,(AB4-AB3)*24,(1-(AB3-AB4))*24)","v":0},{"$f":"IF(AC4>=AC3,(AC4-AC3)*24,(1-(AC3-AC4))*24)","v":0},{"$f":"IF(AD4>=AD3,(AD4-AD3)*24,(1-(AD3-AD4))*24)","v":0},{"$f":"IF(AE4>=AE3,(AE4-AE3)*24,(1-(AE3-AE4))*24)","v":0},{"$f":"IF(AF4>=AF3,(AF4-AF3)*24,(1-(AF3-AF4))*24)","v":0},{"$f":"IF(AG4>=AG3,(AG4-AG3)*24,(1-(AG3-AG4))*24)","v":0},{"$f":"IF(AH4>=AH3,(AH4-AH3)*24,(1-(AH3-AH4))*24)","v":0},{"$f":"IF(AI4>=AI3,(AI4-AI3)*24,(1-(AI3-AI4))*24)","v":0},{"$f":"IF(AJ4>=AJ3,(AJ4-AJ3)*24,(1-(AJ3-AJ4))*24)","v":0},{"$f":"IF(AK4>=AK3,(AK4-AK3)*24,(1-(AK3-AK4))*24)","v":0}]
[]
["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"}]
["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"}]
["Mar Durée (h)",{"$f":"IF(B8>=B7,(B8-B7)*24,(1-(B7-B8))*24)","v":0},{"$f":"IF(C8>=C7,(C8-C7)*24,(1-(C7-C8))*24)","v":0},{"$f":"IF(D8>=D7,(D8-D7)*24,(1-(D7-D8))*24)","v":0},{"$f":"IF(E8>=E7,(E8-E7)*24,(1-(E7-E8))*24)","v":0},{"$f":"IF(F8>=F7,(F8-F7)*24,(1-(F7-F8))*24)","v":0},{"$f":"IF(G8>=G7,(G8-G7)*24,(1-(G7-G8))*24)","v":0},{"$f":"IF(H8>=H7,(H8-H7)*24,(1-(H7-H8))*24)","v":0},{"$f":"IF(I8>=I7,(I8-I7)*24,(1-(I7-I8))*24)","v":0},{"$f":"IF(J8>=J7,(J8-J7)*24,(1-(J7-J8))*24)","v":0},{"$f":"IF(K8>=K7,(K8-K7)*24,(1-(K7-K8))*24)","v":0},{"$f":"IF(L8>=L7,(L8-L7)*24,(1-(L7-L8))*24)","v":0},{"$f":"IF(M8>=M7,(M8-M7)*24,(1-(M7-M8))*24)","v":0},{"$f":"IF(N8>=N7,(N8-N7)*24,(1-(N7-N8))*24)","v":0},{"$f":"IF(O8>=O7,(O8-O7)*24,(1-(O7-O8))*24)","v":0},{"$f":"IF(P8>=P7,(P8-P7)*24,(1-(P7-P8))*24)","v":0},{"$f":"IF(Q8>=Q7,(Q8-Q7)*24,(1-(Q7-Q8))*24)","v":0},{"$f":"IF(R8>=R7,(R8-R7)*24,(1-(R7-R8))*24)","v":0},{"$f":"IF(S8>=S7,(S8-S7)*24,(1-(S7-S8))*24)","v":0},{"$f":"IF(T8>=T7,(T8-T7)*24,(1-(T7-T8))*24)","v":0},{"$f":"IF(U8>=U7,(U8-U7)*24,(1-(U7-U8))*24)","v":0},{"$f":"IF(V8>=V7,(V8-V7)*24,(1-(V7-V8))*24)","v":0},{"$f":"IF(W8>=W7,(W8-W7)*24,(1-(W7-W8))*24)","v":0},{"$f":"IF(X8>=X7,(X8-X7)*24,(1-(X7-X8))*24)","v":0},{"$f":"IF(Y8>=Y7,(Y8-Y7)*24,(1-(Y7-Y8))*24)","v":0},{"$f":"IF(Z8>=Z7,(Z8-Z7)*24,(1-(Z7-Z8))*24)","v":0},{"$f":"IF(AA8>=AA7,(AA8-AA7)*24,(1-(AA7-AA8))*24)","v":0},{"$f":"IF(AB8>=AB7,(AB8-AB7)*24,(1-(AB7-AB8))*24)","v":0},{"$f":"IF(AC8>=AC7,(AC8-AC7)*24,(1-(AC7-AC8))*24)","v":0},{"$f":"IF(AD8>=AD7,(AD8-AD7)*24,(1-(AD7-AD8))*24)","v":0},{"$f":"IF(AE8>=AE7,(AE8-AE7)*24,(1-(AE7-AE8))*24)","v":0},{"$f":"IF(AF8>=AF7,(AF8-AF7)*24,(1-(AF7-AF8))*24)","v":0},{"$f":"IF(AG8>=AG7,(AG8-AG7)*24,(1-(AG7-AG8))*24)","v":0},{"$f":"IF(AH8>=AH7,(AH8-AH7)*24,(1-(AH7-AH8))*24)","v":0},{"$f":"IF(AI8>=AI7,(AI8-AI7)*24,(1-(AI7-AI8))*24)","v":0},{"$f":"IF(AJ8>=AJ7,(AJ8-AJ7)*24,(1-(AJ7-AJ8))*24)","v":0},{"$f":"IF(AK8>=AK7,(AK8-AK7)*24,(1-(AK7-AK8))*24)","v":0}]
[]
["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"}]
["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"}]
["Mer Durée (h)",{"$f":"IF(B12>=B11,(B12-B11)*24,(1-(B11-B12))*24)","v":0},{"$f":"IF(C12>=C11,(C12-C11)*24,(1-(C11-C12))*24)","v":0},{"$f":"IF(D12>=D11,(D12-D11)*24,(1-(D11-D12))*24)","v":0},{"$f":"IF(E12>=E11,(E12-E11)*24,(1-(E11-E12))*24)","v":0},{"$f":"IF(F12>=F11,(F12-F11)*24,(1-(F11-F12))*24)","v":0},{"$f":"IF(G12>=G11,(G12-G11)*24,(1-(G11-G12))*24)","v":0},{"$f":"IF(H12>=H11,(H12-H11)*24,(1-(H11-H12))*24)","v":0},{"$f":"IF(I12>=I11,(I12-I11)*24,(1-(I11-I12))*24)","v":0},{"$f":"IF(J12>=J11,(J12-J11)*24,(1-(J11-J12))*24)","v":0},{"$f":"IF(K12>=K11,(K12-K11)*24,(1-(K11-K12))*24)","v":0},{"$f":"IF(L12>=L11,(L12-L11)*24,(1-(L11-L12))*24)","v":0},{"$f":"IF(M12>=M11,(M12-M11)*24,(1-(M11-M12))*24)","v":0},{"$f":"IF(N12>=N11,(N12-N11)*24,(1-(N11-N12))*24)","v":0},{"$f":"IF(O12>=O11,(O12-O11)*24,(1-(O11-O12))*24)","v":0},{"$f":"IF(P12>=P11,(P12-P11)*24,(1-(P11-P12))*24)","v":0},{"$f":"IF(Q12>=Q11,(Q12-Q11)*24,(1-(Q11-Q12))*24)","v":0},{"$f":"IF(R12>=R11,(R12-R11)*24,(1-(R11-R12))*24)","v":0},{"$f":"IF(S12>=S11,(S12-S11)*24,(1-(S11-S12))*24)","v":0},{"$f":"IF(T12>=T11,(T12-T11)*24,(1-(T11-T12))*24)","v":0},{"$f":"IF(U12>=U11,(U12-U11)*24,(1-(U11-U12))*24)","v":0},{"$f":"IF(V12>=V11,(V12-V11)*24,(1-(V11-V12))*24)","v":0},{"$f":"IF(W12>=W11,(W12-W11)*24,(1-(W11-W12))*24)","v":0},{"$f":"IF(X12>=X11,(X12-X11)*24,(1-(X11-X12))*24)","v":0},{"$f":"IF(Y12>=Y11,(Y12-Y11)*24,(1-(Y11-Y12))*24)","v":0},{"$f":"IF(Z12>=Z11,(Z12-Z11)*24,(1-(Z11-Z12))*24)","v":0},{"$f":"IF(AA12>=AA11,(AA12-AA11)*24,(1-(AA11-AA12))*24)","v":0},{"$f":"IF(AB12>=AB11,(AB12-AB11)*24,(1-(AB11-AB12))*24)","v":0},{"$f":"IF(AC12>=AC11,(AC12-AC11)*24,(1-(AC11-AC12))*24)","v":0},{"$f":"IF(AD12>=AD11,(AD12-AD11)*24,(1-(AD11-AD12))*24)","v":0},{"$f":"IF(AE12>=AE11,(AE12-AE11)*24,(1-(AE11-AE12))*24)","v":0},{"$f":"IF(AF12>=AF11,(AF12-AF11)*24,(1-(AF11-AF12))*24)","v":0},{"$f":"IF(AG12>=AG11,(AG12-AG11)*24,(1-(AG11-AG12))*24)","v":0},{"$f":"IF(AH12>=AH11,(AH12-AH11)*24,(1-(AH11-AH12))*24)","v":0},{"$f":"IF(AI12>=AI11,(AI12-AI11)*24,(1-(AI11-AI12))*24)","v":0},{"$f":"IF(AJ12>=AJ11,(AJ12-AJ11)*24,(1-(AJ11-AJ12))*24)","v":0},{"$f":"IF(AK12>=AK11,(AK12-AK11)*24,(1-(AK11-AK12))*24)","v":0}]
[]
["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"}]
["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"}]
["Jeu Durée (h)",{"$f":"IF(B16>=B15,(B16-B15)*24,(1-(B15-B16))*24)","v":0},{"$f":"IF(C16>=C15,(C16-C15)*24,(1-(C15-C16))*24)","v":0},{"$f":"IF(D16>=D15,(D16-D15)*24,(1-(D15-D16))*24)","v":0},{"$f":"IF(E16>=E15,(E16-E15)*24,(1-(E15-E16))*24)","v":0},{"$f":"IF(F16>=F15,(F16-F15)*24,(1-(F15-F16))*24)","v":0},{"$f":"IF(G16>=G15,(G16-G15)*24,(1-(G15-G16))*24)","v":0},{"$f":"IF(H16>=H15,(H16-H15)*24,(1-(H15-H16))*24)","v":0},{"$f":"IF(I16>=I15,(I16-I15)*24,(1-(I15-I16))*24)","v":0},{"$f":"IF(J16>=J15,(J16-J15)*24,(1-(J15-J16))*24)","v":0},{"$f":"IF(K16>=K15,(K16-K15)*24,(1-(K15-K16))*24)","v":0},{"$f":"IF(L16>=L15,(L16-L15)*24,(1-(L15-L16))*24)","v":0},{"$f":"IF(M16>=M15,(M16-M15)*24,(1-(M15-M16))*24)","v":0},{"$f":"IF(N16>=N15,(N16-N15)*24,(1-(N15-N16))*24)","v":0},{"$f":"IF(O16>=O15,(O16-O15)*24,(1-(O15-O16))*24)","v":0},{"$f":"IF(P16>=P15,(P16-P15)*24,(1-(P15-P16))*24)","v":0},{"$f":"IF(Q16>=Q15,(Q16-Q15)*24,(1-(Q15-Q16))*24)","v":0},{"$f":"IF(R16>=R15,(R16-R15)*24,(1-(R15-R16))*24)","v":0},{"$f":"IF(S16>=S15,(S16-S15)*24,(1-(S15-S16))*24)","v":0},{"$f":"IF(T16>=T15,(T16-T15)*24,(1-(T15-T16))*24)","v":0},{"$f":"IF(U16>=U15,(U16-U15)*24,(1-(U15-U16))*24)","v":0},{"$f":"IF(V16>=V15,(V16-V15)*24,(1-(V15-V16))*24)","v":0},{"$f":"IF(W16>=W15,(W16-W15)*24,(1-(W15-W16))*24)","v":0},{"$f":"IF(X16>=X15,(X16-X15)*24,(1-(X15-X16))*24)","v":0},{"$f":"IF(Y16>=Y15,(Y16-Y15)*24,(1-(Y15-Y16))*24)","v":0},{"$f":"IF(Z16>=Z15,(Z16-Z15)*24,(1-(Z15-Z16))*24)","v":0},{"$f":"IF(AA16>=AA15,(AA16-AA15)*24,(1-(AA15-AA16))*24)","v":0},{"$f":"IF(AB16>=AB15,(AB16-AB15)*24,(1-(AB15-AB16))*24)","v":0},{"$f":"IF(AC16>=AC15,(AC16-AC15)*24,(1-(AC15-AC16))*24)","v":0},{"$f":"IF(AD16>=AD15,(AD16-AD15)*24,(1-(AD15-AD16))*24)","v":0},{"$f":"IF(AE16>=AE15,(AE16-AE15)*24,(1-(AE15-AE16))*24)","v":0},{"$f":"IF(AF16>=AF15,(AF16-AF15)*24,(1-(AF15-AF16))*24)","v":0},{"$f":"IF(AG16>=AG15,(AG16-AG15)*24,(1-(AG15-AG16))*24)","v":0},{"$f":"IF(AH16>=AH15,(AH16-AH15)*24,(1-(AH15-AH16))*24)","v":0},{"$f":"IF(AI16>=AI15,(AI16-AI15)*24,(1-(AI15-AI16))*24)","v":0},{"$f":"IF(AJ16>=AJ15,(AJ16-AJ15)*24,(1-(AJ15-AJ16))*24)","v":0},{"$f":"IF(AK16>=AK15,(AK16-AK15)*24,(1-(AK15-AK16))*24)","v":0}]
[]
["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"}]
["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"}]
["Ven Durée (h)",{"$f":"IF(B20>=B19,(B20-B19)*24,(1-(B19-B20))*24)","v":0},{"$f":"IF(C20>=C19,(C20-C19)*24,(1-(C19-C20))*24)","v":0},{"$f":"IF(D20>=D19,(D20-D19)*24,(1-(D19-D20))*24)","v":0},{"$f":"IF(E20>=E19,(E20-E19)*24,(1-(E19-E20))*24)","v":0},{"$f":"IF(F20>=F19,(F20-F19)*24,(1-(F19-F20))*24)","v":0},{"$f":"IF(G20>=G19,(G20-G19)*24,(1-(G19-G20))*24)","v":0},{"$f":"IF(H20>=H19,(H20-H19)*24,(1-(H19-H20))*24)","v":0},{"$f":"IF(I20>=I19,(I20-I19)*24,(1-(I19-I20))*24)","v":0},{"$f":"IF(J20>=J19,(J20-J19)*24,(1-(J19-J20))*24)","v":0},{"$f":"IF(K20>=K19,(K20-K19)*24,(1-(K19-K20))*24)","v":0},{"$f":"IF(L20>=L19,(L20-L19)*24,(1-(L19-L20))*24)","v":0},{"$f":"IF(M20>=M19,(M20-M19)*24,(1-(M19-M20))*24)","v":0},{"$f":"IF(N20>=N19,(N20-N19)*24,(1-(N19-N20))*24)","v":0},{"$f":"IF(O20>=O19,(O20-O19)*24,(1-(O19-O20))*24)","v":0},{"$f":"IF(P20>=P19,(P20-P19)*24,(1-(P19-P20))*24)","v":0},{"$f":"IF(Q20>=Q19,(Q20-Q19)*24,(1-(Q19-Q20))*24)","v":0},{"$f":"IF(R20>=R19,(R20-R19)*24,(1-(R19-R20))*24)","v":0},{"$f":"IF(S20>=S19,(S20-S19)*24,(1-(S19-S20))*24)","v":0},{"$f":"IF(T20>=T19,(T20-T19)*24,(1-(T19-T20))*24)","v":0},{"$f":"IF(U20>=U19,(U20-U19)*24,(1-(U19-U20))*24)","v":0},{"$f":"IF(V20>=V19,(V20-V19)*24,(1-(V19-V20))*24)","v":0},{"$f":"IF(W20>=W19,(W20-W19)*24,(1-(W19-W20))*24)","v":0},{"$f":"IF(X20>=X19,(X20-X19)*24,(1-(X19-X20))*24)","v":0},{"$f":"IF(Y20>=Y19,(Y20-Y19)*24,(1-(Y19-Y20))*24)","v":0},{"$f":"IF(Z20>=Z19,(Z20-Z19)*24,(1-(Z19-Z20))*24)","v":0},{"$f":"IF(AA20>=AA19,(AA20-AA19)*24,(1-(AA19-AA20))*24)","v":0},{"$f":"IF(AB20>=AB19,(AB20-AB19)*24,(1-(AB19-AB20))*24)","v":0},{"$f":"IF(AC20>=AC19,(AC20-AC19)*24,(1-(AC19-AC20))*24)","v":0},{"$f":"IF(AD20>=AD19,(AD20-AD19)*24,(1-(AD19-AD20))*24)","v":0},{"$f":"IF(AE20>=AE19,(AE20-AE19)*24,(1-(AE19-AE20))*24)","v":0},{"$f":"IF(AF20>=AF19,(AF20-AF19)*24,(1-(AF19-AF20))*24)","v":0},{"$f":"IF(AG20>=AG19,(AG20-AG19)*24,(1-(AG19-AG20))*24)","v":0},{"$f":"IF(AH20>=AH19,(AH20-AH19)*24,(1-(AH19-AH20))*24)","v":0},{"$f":"IF(AI20>=AI19,(AI20-AI19)*24,(1-(AI19-AI20))*24)","v":0},{"$f":"IF(AJ20>=AJ19,(AJ20-AJ19)*24,(1-(AJ19-AJ20))*24)","v":0},{"$f":"IF(AK20>=AK19,(AK20-AK19)*24,(1-(AK19-AK20))*24)","v":0}]
[]
["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"}]
["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"}]
["Sam Durée (h)",{"$f":"IF(B24>=B23,(B24-B23)*24,(1-(B23-B24))*24)","v":0},{"$f":"IF(C24>=C23,(C24-C23)*24,(1-(C23-C24))*24)","v":0},{"$f":"IF(D24>=D23,(D24-D23)*24,(1-(D23-D24))*24)","v":0},{"$f":"IF(E24>=E23,(E24-E23)*24,(1-(E23-E24))*24)","v":0},{"$f":"IF(F24>=F23,(F24-F23)*24,(1-(F23-F24))*24)","v":0},{"$f":"IF(G24>=G23,(G24-G23)*24,(1-(G23-G24))*24)","v":0},{"$f":"IF(H24>=H23,(H24-H23)*24,(1-(H23-H24))*24)","v":0},{"$f":"IF(I24>=I23,(I24-I23)*24,(1-(I23-I24))*24)","v":0},{"$f":"IF(J24>=J23,(J24-J23)*24,(1-(J23-J24))*24)","v":0},{"$f":"IF(K24>=K23,(K24-K23)*24,(1-(K23-K24))*24)","v":0},{"$f":"IF(L24>=L23,(L24-L23)*24,(1-(L23-L24))*24)","v":0},{"$f":"IF(M24>=M23,(M24-M23)*24,(1-(M23-M24))*24)","v":0},{"$f":"IF(N24>=N23,(N24-N23)*24,(1-(N23-N24))*24)","v":0},{"$f":"IF(O24>=O23,(O24-O23)*24,(1-(O23-O24))*24)","v":0},{"$f":"IF(P24>=P23,(P24-P23)*24,(1-(P23-P24))*24)","v":0},{"$f":"IF(Q24>=Q23,(Q24-Q23)*24,(1-(Q23-Q24))*24)","v":0},{"$f":"IF(R24>=R23,(R24-R23)*24,(1-(R23-R24))*24)","v":0},{"$f":"IF(S24>=S23,(S24-S23)*24,(1-(S23-S24))*24)","v":0},{"$f":"IF(T24>=T23,(T24-T23)*24,(1-(T23-T24))*24)","v":0},{"$f":"IF(U24>=U23,(U24-U23)*24,(1-(U23-U24))*24)","v":0},{"$f":"IF(V24>=V23,(V24-V23)*24,(1-(V23-V24))*24)","v":0},{"$f":"IF(W24>=W23,(W24-W23)*24,(1-(W23-W24))*24)","v":0},{"$f":"IF(X24>=X23,(X24-X23)*24,(1-(X23-X24))*24)","v":0},{"$f":"IF(Y24>=Y23,(Y24-Y23)*24,(1-(Y23-Y24))*24)","v":0},{"$f":"IF(Z24>=Z23,(Z24-Z23)*24,(1-(Z23-Z24))*24)","v":0},{"$f":"IF(AA24>=AA23,(AA24-AA23)*24,(1-(AA23-AA24))*24)","v":0},{"$f":"IF(AB24>=AB23,(AB24-AB23)*24,(1-(AB23-AB24))*24)","v":0},{"$f":"IF(AC24>=AC23,(AC24-AC23)*24,(1-(AC23-AC24))*24)","v":0},{"$f":"IF(AD24>=AD23,(AD24-AD23)*24,(1-(AD23-AD24))*24)","v":0},{"$f":"IF(AE24>=AE23,(AE24-AE23)*24,(1-(AE23-AE24))*24)","v":0},{"$f":"IF(AF24>=AF23,(AF24-AF23)*24,(1-(AF23-AF24))*24)","v":0},{"$f":"IF(AG24>=AG23,(AG24-AG23)*24,(1-(AG23-AG24))*24)","v":0},{"$f":"IF(AH24>=AH23,(AH24-AH23)*24,(1-(AH23-AH24))*24)","v":0},{"$f":"IF(AI24>=AI23,(AI24-AI23)*24,(1-(AI23-AI24))*24)","v":0},{"$f":"IF(AJ24>=AJ23,(AJ24-AJ23)*24,(1-(AJ23-AJ24))*24)","v":0},{"$f":"IF(AK24>=AK23,(AK24-AK23)*24,(1-(AK23-AK24))*24)","v":0}]
[]
["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"}]
["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"}]
["Dim Durée (h)",{"$f":"IF(B28>=B27,(B28-B27)*24,(1-(B27-B28))*24)","v":0},{"$f":"IF(C28>=C27,(C28-C27)*24,(1-(C27-C28))*24)","v":0},{"$f":"IF(D28>=D27,(D28-D27)*24,(1-(D27-D28))*24)","v":0},{"$f":"IF(E28>=E27,(E28-E27)*24,(1-(E27-E28))*24)","v":0},{"$f":"IF(F28>=F27,(F28-F27)*24,(1-(F27-F28))*24)","v":0},{"$f":"IF(G28>=G27,(G28-G27)*24,(1-(G27-G28))*24)","v":0},{"$f":"IF(H28>=H27,(H28-H27)*24,(1-(H27-H28))*24)","v":0},{"$f":"IF(I28>=I27,(I28-I27)*24,(1-(I27-I28))*24)","v":0},{"$f":"IF(J28>=J27,(J28-J27)*24,(1-(J27-J28))*24)","v":0},{"$f":"IF(K28>=K27,(K28-K27)*24,(1-(K27-K28))*24)","v":0},{"$f":"IF(L28>=L27,(L28-L27)*24,(1-(L27-L28))*24)","v":0},{"$f":"IF(M28>=M27,(M28-M27)*24,(1-(M27-M28))*24)","v":0},{"$f":"IF(N28>=N27,(N28-N27)*24,(1-(N27-N28))*24)","v":0},{"$f":"IF(O28>=O27,(O28-O27)*24,(1-(O27-O28))*24)","v":0},{"$f":"IF(P28>=P27,(P28-P27)*24,(1-(P27-P28))*24)","v":0},{"$f":"IF(Q28>=Q27,(Q28-Q27)*24,(1-(Q27-Q28))*24)","v":0},{"$f":"IF(R28>=R27,(R28-R27)*24,(1-(R27-R28))*24)","v":0},{"$f":"IF(S28>=S27,(S28-S27)*24,(1-(S27-S28))*24)","v":0},{"$f":"IF(T28>=T27,(T28-T27)*24,(1-(T27-T28))*24)","v":0},{"$f":"IF(U28>=U27,(U28-U27)*24,(1-(U27-U28))*24)","v":0},{"$f":"IF(V28>=V27,(V28-V27)*24,(1-(V27-V28))*24)","v":0},{"$f":"IF(W28>=W27,(W28-W27)*24,(1-(W27-W28))*24)","v":0},{"$f":"IF(X28>=X27,(X28-X27)*24,(1-(X27-X28))*24)","v":0},{"$f":"IF(Y28>=Y27,(Y28-Y27)*24,(1-(Y27-Y28))*24)","v":0},{"$f":"IF(Z28>=Z27,(Z28-Z27)*24,(1-(Z27-Z28))*24)","v":0},{"$f":"IF(AA28>=AA27,(AA28-AA27)*24,(1-(AA27-AA28))*24)","v":0},{"$f":"IF(AB28>=AB27,(AB28-AB27)*24,(1-(AB27-AB28))*24)","v":0},{"$f":"IF(AC28>=AC27,(AC28-AC27)*24,(1-(AC27-AC28))*24)","v":0},{"$f":"IF(AD28>=AD27,(AD28-AD27)*24,(1-(AD27-AD28))*24)","v":0},{"$f":"IF(AE28>=AE27,(AE28-AE27)*24,(1-(AE27-AE28))*24)","v":0},{"$f":"IF(AF28>=AF27,(AF28-AF27)*24,(1-(AF27-AF28))*24)","v":0},{"$f":"IF(AG28>=AG27,(AG28-AG27)*24,(1-(AG27-AG28))*24)","v":0},{"$f":"IF(AH28>=AH27,(AH28-AH27)*24,(1-(AH27-AH28))*24)","v":0},{"$f":"IF(AI28>=AI27,(AI28-AI27)*24,(1-(AI27-AI28))*24)","v":0},{"$f":"IF(AJ28>=AJ27,(AJ28-AJ27)*24,(1-(AJ27-AJ28))*24)","v":0},{"$f":"IF(AK28>=AK27,(AK28-AK27)*24,(1-(AK27-AK28))*24)","v":0}]

{"sheet":"Couverture","index":3,"n_rows":129,"n_cols":5,"rows_kept":129}
["Couverture horaire vs besoin (07:00 → 22:00)"]
[]
["Renseigner 'Besoin' par heure. 'Planifié' suit les shifts ; 'Écart' met en évidence les manques."]
[]
["Lun","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B6)*(Heures_Shifts!$B$4:$AK$4>B6))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B6)+(Heures_Shifts!$B$4:$AK$4>B6))))","v":0},{"$f":"D6-C6","v":0}]
[null,"08:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B7)*(Heures_Shifts!$B$4:$AK$4>B7))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B7)+(Heures_Shifts!$B$4:$AK$4>B7))))","v":0},{"$f":"D7-C7","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B8)*(Heures_Shifts!$B$4:$AK$4>B8))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B8)+(Heures_Shifts!$B$4:$AK$4>B8))))","v":0},{"$f":"D8-C8","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B9)*(Heures_Shifts!$B$4:$AK$4>B9))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B9)+(Heures_Shifts!$B$4:$AK$4>B9))))","v":0},{"$f":"D9-C9","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B10)*(Heures_Shifts!$B$4:$AK$4>B10))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B10)+(Heures_Shifts!$B$4:$AK$4>B10))))","v":0},{"$f":"D10-C10","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B11)*(Heures_Shifts!$B$4:$AK$4>B11))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B11)+(Heures_Shifts!$B$4:$AK$4>B11))))","v":0},{"$f":"D11-C11","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B12)*(Heures_Shifts!$B$4:$AK$4>B12))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B12)+(Heures_Shifts!$B$4:$AK$4>B12))))","v":0},{"$f":"D12-C12","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B13)*(Heures_Shifts!$B$4:$AK$4>B13))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B13)+(Heures_Shifts!$B$4:$AK$4>B13))))","v":0},{"$f":"D13-C13","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B14)*(Heures_Shifts!$B$4:$AK$4>B14))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B14)+(Heures_Shifts!$B$4:$AK$4>B14))))","v":0},{"$f":"D14-C14","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B15)*(Heures_Shifts!$B$4:$AK$4>B15))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B15)+(Heures_Shifts!$B$4:$AK$4>B15))))","v":0},{"$f":"D15-C15","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B16)*(Heures_Shifts!$B$4:$AK$4>B16))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B16)+(Heures_Shifts!$B$4:$AK$4>B16))))","v":0},{"$f":"D16-C16","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B17)*(Heures_Shifts!$B$4:$AK$4>B17))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B17)+(Heures_Shifts!$B$4:$AK$4>B17))))","v":0},{"$f":"D17-C17","v":0}]
[null,"19:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B18)*(Heures_Shifts!$B$4:$AK$4>B18))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B18)+(Heures_Shifts!$B$4:$AK$4>B18))))","v":0},{"$f":"D18-C18","v":0}]
[null,"20:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B19)*(Heures_Shifts!$B$4:$AK$4>B19))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B19)+(Heures_Shifts!$B$4:$AK$4>B19))))","v":0},{"$f":"D19-C19","v":0}]
[null,"21:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B20)*(Heures_Shifts!$B$4:$AK$4>B20))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B20)+(Heures_Shifts!$B$4:$AK$4>B20))))","v":0},{"$f":"D20-C20","v":0}]
[null,"22:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$3:$AK$3<=B21)*(Heures_Shifts!$B$4:$AK$4>B21))+((Heures_Shifts!$B$4:$AK$4<Heures_Shifts!$B$3:$AK$3)*((Heures_Shifts!$B$3:$AK$3<=B21)+(Heures_Shifts!$B$4:$AK$4>B21))))","v":0},{"$f":"D21-C21","v":0}]
[]
["Mar","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B24)*(Heures_Shifts!$B$8:$AK$8>B24))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B24)+(Heures_Shifts!$B$8:$AK$8>B24))))","v":0},{"$f":"D24-C24","v":0}]
[null,"08:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B25)*(Heures_Shifts!$B$8:$AK$8>B25))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B25)+(Heures_Shifts!$B$8:$AK$8>B25))))","v":0},{"$f":"D25-C25","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B26)*(Heures_Shifts!$B$8:$AK$8>B26))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B26)+(Heures_Shifts!$B$8:$AK$8>B26))))","v":0},{"$f":"D26-C26","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B27)*(Heures_Shifts!$B$8:$AK$8>B27))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B27)+(Heures_Shifts!$B$8:$AK$8>B27))))","v":0},{"$f":"D27-C27","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B28)*(Heures_Shifts!$B$8:$AK$8>B28))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B28)+(Heures_Shifts!$B$8:$AK$8>B28))))","v":0},{"$f":"D28-C28","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B29)*(Heures_Shifts!$B$8:$AK$8>B29))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B29)+(Heures_Shifts!$B$8:$AK$8>B29))))","v":0},{"$f":"D29-C29","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B30)*(Heures_Shifts!$B$8:$AK$8>B30))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B30)+(Heures_Shifts!$B$8:$AK$8>B30))))","v":0},{"$f":"D30-C30","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B31)*(Heures_Shifts!$B$8:$AK$8>B31))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B31)+(Heures_Shifts!$B$8:$AK$8>B31))))","v":0},{"$f":"D31-C31","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B32)*(Heures_Shifts!$B$8:$AK$8>B32))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B32)+(Heures_Shifts!$B$8:$AK$8>B32))))","v":0},{"$f":"D32-C32","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B33)*(Heures_Shifts!$B$8:$AK$8>B33))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B33)+(Heures_Shifts!$B$8:$AK$8>B33))))","v":0},{"$f":"D33-C33","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B34)*(Heures_Shifts!$B$8:$AK$8>B34))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B34)+(Heures_Shifts!$B$8:$AK$8>B34))))","v":0},{"$f":"D34-C34","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B35)*(Heures_Shifts!$B$8:$AK$8>B35))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B35)+(Heures_Shifts!$B$8:$AK$8>B35))))","v":0},{"$f":"D35-C35","v":0}]
[null,"19:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B36)*(Heures_Shifts!$B$8:$AK$8>B36))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B36)+(Heures_Shifts!$B$8:$AK$8>B36))))","v":0},{"$f":"D36-C36","v":0}]
[null,"20:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B37)*(Heures_Shifts!$B$8:$AK$8>B37))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B37)+(Heures_Shifts!$B$8:$AK$8>B37))))","v":0},{"$f":"D37-C37","v":0}]
[null,"21:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B38)*(Heures_Shifts!$B$8:$AK$8>B38))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B38)+(Heures_Shifts!$B$8:$AK$8>B38))))","v":0},{"$f":"D38-C38","v":0}]
[null,"22:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$7:$AK$7<=B39)*(Heures_Shifts!$B$8:$AK$8>B39))+((Heures_Shifts!$B$8:$AK$8<Heures_Shifts!$B$7:$AK$7)*((Heures_Shifts!$B$7:$AK$7<=B39)+(Heures_Shifts!$B$8:$AK$8>B39))))","v":0},{"$f":"D39-C39","v":0}]
[]
["Mer","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B42)*(Heures_Shifts!$B$12:$AK$12>B42))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B42)+(Heures_Shifts!$B$12:$AK$12>B42))))","v":0},{"$f":"D42-C42","v":0}]
[null,"08:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B43)*(Heures_Shifts!$B$12:$AK$12>B43))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B43)+(Heures_Shifts!$B$12:$AK$12>B43))))","v":0},{"$f":"D43-C43","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B44)*(Heures_Shifts!$B$12:$AK$12>B44))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B44)+(Heures_Shifts!$B$12:$AK$12>B44))))","v":0},{"$f":"D44-C44","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B45)*(Heures_Shifts!$B$12:$AK$12>B45))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B45)+(Heures_Shifts!$B$12:$AK$12>B45))))","v":0},{"$f":"D45-C45","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B46)*(Heures_Shifts!$B$12:$AK$12>B46))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B46)+(Heures_Shifts!$B$12:$AK$12>B46))))","v":0},{"$f":"D46-C46","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B47)*(Heures_Shifts!$B$12:$AK$12>B47))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B47)+(Heures_Shifts!$B$12:$AK$12>B47))))","v":0},{"$f":"D47-C47","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B48)*(Heures_Shifts!$B$12:$AK$12>B48))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B48)+(Heures_Shifts!$B$12:$AK$12>B48))))","v":0},{"$f":"D48-C48","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B49)*(Heures_Shifts!$B$12:$AK$12>B49))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B49)+(Heures_Shifts!$B$12:$AK$12>B49))))","v":0},{"$f":"D49-C49","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B50)*(Heures_Shifts!$B$12:$AK$12>B50))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B50)+(Heures_Shifts!$B$12:$AK$12>B50))))","v":0},{"$f":"D50-C50","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B51)*(Heures_Shifts!$B$12:$AK$12>B51))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B51)+(Heures_Shifts!$B$12:$AK$12>B51))))","v":0},{"$f":"D51-C51","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B52)*(Heures_Shifts!$B$12:$AK$12>B52))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B52)+(Heures_Shifts!$B$12:$AK$12>B52))))","v":0},{"$f":"D52-C52","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B53)*(Heures_Shifts!$B$12:$AK$12>B53))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B53)+(Heures_Shifts!$B$12:$AK$12>B53))))","v":0},{"$f":"D53-C53","v":0}]
[null,"19:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B54)*(Heures_Shifts!$B$12:$AK$12>B54))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B54)+(Heures_Shifts!$B$12:$AK$12>B54))))","v":0},{"$f":"D54-C54","v":0}]
[null,"20:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B55)*(Heures_Shifts!$B$12:$AK$12>B55))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B55)+(Heures_Shifts!$B$12:$AK$12>B55))))","v":0},{"$f":"D55-C55","v":0}]
[null,"21:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B56)*(Heures_Shifts!$B$12:$AK$12>B56))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B56)+(Heures_Shifts!$B$12:$AK$12>B56))))","v":0},{"$f":"D56-C56","v":0}]
[null,"22:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$11:$AK$11<=B57)*(Heures_Shifts!$B$12:$AK$12>B57))+((Heures_Shifts!$B$12:$AK$12<Heures_Shifts!$B$11:$AK$11)*((Heures_Shifts!$B$11:$AK$11<=B57)+(Heures_Shifts!$B$12:$AK$12>B57))))","v":0},{"$f":"D57-C57","v":0}]
[]
["Jeu","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B60)*(Heures_Shifts!$B$16:$AK$16>B60))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B60)+(Heures_Shifts!$B$16:$AK$16>B60))))","v":0},{"$f":"D60-C60","v":0}]
[null,"08:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B61)*(Heures_Shifts!$B$16:$AK$16>B61))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B61)+(Heures_Shifts!$B$16:$AK$16>B61))))","v":0},{"$f":"D61-C61","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B62)*(Heures_Shifts!$B$16:$AK$16>B62))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B62)+(Heures_Shifts!$B$16:$AK$16>B62))))","v":0},{"$f":"D62-C62","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B63)*(Heures_Shifts!$B$16:$AK$16>B63))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B63)+(Heures_Shifts!$B$16:$AK$16>B63))))","v":0},{"$f":"D63-C63","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B64)*(Heures_Shifts!$B$16:$AK$16>B64))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B64)+(Heures_Shifts!$B$16:$AK$16>B64))))","v":0},{"$f":"D64-C64","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B65)*(Heures_Shifts!$B$16:$AK$16>B65))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B65)+(Heures_Shifts!$B$16:$AK$16>B65))))","v":0},{"$f":"D65-C65","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B66)*(Heures_Shifts!$B$16:$AK$16>B66))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B66)+(Heures_Shifts!$B$16:$AK$16>B66))))","v":0},{"$f":"D66-C66","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B67)*(Heures_Shifts!$B$16:$AK$16>B67))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B67)+(Heures_Shifts!$B$16:$AK$16>B67))))","v":0},{"$f":"D67-C67","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B68)*(Heures_Shifts!$B$16:$AK$16>B68))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B68)+(Heures_Shifts!$B$16:$AK$16>B68))))","v":0},{"$f":"D68-C68","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B69)*(Heures_Shifts!$B$16:$AK$16>B69))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B69)+(Heures_Shifts!$B$16:$AK$16>B69))))","v":0},{"$f":"D69-C69","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B70)*(Heures_Shifts!$B$16:$AK$16>B70))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B70)+(Heures_Shifts!$B$16:$AK$16>B70))))","v":0},{"$f":"D70-C70","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B71)*(Heures_Shifts!$B$16:$AK$16>B71))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B71)+(Heures_Shifts!$B$16:$AK$16>B71))))","v":0},{"$f":"D71-C71","v":0}]
[null,"19:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B72)*(Heures_Shifts!$B$16:$AK$16>B72))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B72)+(Heures_Shifts!$B$16:$AK$16>B72))))","v":0},{"$f":"D72-C72","v":0}]
[null,"20:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B73)*(Heures_Shifts!$B$16:$AK$16>B73))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B73)+(Heures_Shifts!$B$16:$AK$16>B73))))","v":0},{"$f":"D73-C73","v":0}]
[null,"21:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B74)*(Heures_Shifts!$B$16:$AK$16>B74))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B74)+(Heures_Shifts!$B$16:$AK$16>B74))))","v":0},{"$f":"D74-C74","v":0}]
[null,"22:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$15:$AK$15<=B75)*(Heures_Shifts!$B$16:$AK$16>B75))+((Heures_Shifts!$B$16:$AK$16<Heures_Shifts!$B$15:$AK$15)*((Heures_Shifts!$B$15:$AK$15<=B75)+(Heures_Shifts!$B$16:$AK$16>B75))))","v":0},{"$f":"D75-C75","v":0}]
[]
["Ven","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B78)*(Heures_Shifts!$B$20:$AK$20>B78))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B78)+(Heures_Shifts!$B$20:$AK$20>B78))))","v":0},{"$f":"D78-C78","v":0}]
[null,"08:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B79)*(Heures_Shifts!$B$20:$AK$20>B79))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B79)+(Heures_Shifts!$B$20:$AK$20>B79))))","v":0},{"$f":"D79-C79","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B80)*(Heures_Shifts!$B$20:$AK$20>B80))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B80)+(Heures_Shifts!$B$20:$AK$20>B80))))","v":0},{"$f":"D80-C80","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B81)*(Heures_Shifts!$B$20:$AK$20>B81))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B81)+(Heures_Shifts!$B$20:$AK$20>B81))))","v":0},{"$f":"D81-C81","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B82)*(Heures_Shifts!$B$20:$AK$20>B82))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B82)+(Heures_Shifts!$B$20:$AK$20>B82))))","v":0},{"$f":"D82-C82","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B83)*(Heures_Shifts!$B$20:$AK$20>B83))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B83)+(Heures_Shifts!$B$20:$AK$20>B83))))","v":0},{"$f":"D83-C83","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B84)*(Heures_Shifts!$B$20:$AK$20>B84))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B84)+(Heures_Shifts!$B$20:$AK$20>B84))))","v":0},{"$f":"D84-C84","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B85)*(Heures_Shifts!$B$20:$AK$20>B85))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B85)+(Heures_Shifts!$B$20:$AK$20>B85))))","v":0},{"$f":"D85-C85","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B86)*(Heures_Shifts!$B$20:$AK$20>B86))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B86)+(Heures_Shifts!$B$20:$AK$20>B86))))","v":0},{"$f":"D86-C86","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B87)*(Heures_Shifts!$B$20:$AK$20>B87))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B87)+(Heures_Shifts!$B$20:$AK$20>B87))))","v":0},{"$f":"D87-C87","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B88)*(Heures_Shifts!$B$20:$AK$20>B88))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B88)+(Heures_Shifts!$B$20:$AK$20>B88))))","v":0},{"$f":"D88-C88","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B89)*(Heures_Shifts!$B$20:$AK$20>B89))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B89)+(Heures_Shifts!$B$20:$AK$20>B89))))","v":0},{"$f":"D89-C89","v":0}]
[null,"19:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B90)*(Heures_Shifts!$B$20:$AK$20>B90))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B90)+(Heures_Shifts!$B$20:$AK$20>B90))))","v":0},{"$f":"D90-C90","v":0}]
[null,"20:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B91)*(Heures_Shifts!$B$20:$AK$20>B91))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B91)+(Heures_Shifts!$B$20:$AK$20>B91))))","v":0},{"$f":"D91-C91","v":0}]
[null,"21:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B92)*(Heures_Shifts!$B$20:$AK$20>B92))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B92)+(Heures_Shifts!$B$20:$AK$20>B92))))","v":0},{"$f":"D92-C92","v":0}]
[null,"22:00:00",4,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$19:$AK$19<=B93)*(Heures_Shifts!$B$20:$AK$20>B93))+((Heures_Shifts!$B$20:$AK$20<Heures_Shifts!$B$19:$AK$19)*((Heures_Shifts!$B$19:$AK$19<=B93)+(Heures_Shifts!$B$20:$AK$20>B93))))","v":0},{"$f":"D93-C93","v":0}]
[]
["Sam","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B96)*(Heures_Shifts!$B$24:$AK$24>B96))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B96)+(Heures_Shifts!$B$24:$AK$24>B96))))","v":0},{"$f":"D96-C96","v":0}]
[null,"08:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B97)*(Heures_Shifts!$B$24:$AK$24>B97))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B97)+(Heures_Shifts!$B$24:$AK$24>B97))))","v":0},{"$f":"D97-C97","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B98)*(Heures_Shifts!$B$24:$AK$24>B98))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B98)+(Heures_Shifts!$B$24:$AK$24>B98))))","v":0},{"$f":"D98-C98","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B99)*(Heures_Shifts!$B$24:$AK$24>B99))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B99)+(Heures_Shifts!$B$24:$AK$24>B99))))","v":0},{"$f":"D99-C99","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B100)*(Heures_Shifts!$B$24:$AK$24>B100))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B100)+(Heures_Shifts!$B$24:$AK$24>B100))))","v":0},{"$f":"D100-C100","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B101)*(Heures_Shifts!$B$24:$AK$24>B101))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B101)+(Heures_Shifts!$B$24:$AK$24>B101))))","v":0},{"$f":"D101-C101","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B102)*(Heures_Shifts!$B$24:$AK$24>B102))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B102)+(Heures_Shifts!$B$24:$AK$24>B102))))","v":0},{"$f":"D102-C102","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B103)*(Heures_Shifts!$B$24:$AK$24>B103))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B103)+(Heures_Shifts!$B$24:$AK$24>B103))))","v":0},{"$f":"D103-C103","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B104)*(Heures_Shifts!$B$24:$AK$24>B104))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B104)+(Heures_Shifts!$B$24:$AK$24>B104))))","v":0},{"$f":"D104-C104","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B105)*(Heures_Shifts!$B$24:$AK$24>B105))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B105)+(Heures_Shifts!$B$24:$AK$24>B105))))","v":0},{"$f":"D105-C105","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B106)*(Heures_Shifts!$B$24:$AK$24>B106))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B106)+(Heures_Shifts!$B$24:$AK$24>B106))))","v":0},{"$f":"D106-C106","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B107)*(Heures_Shifts!$B$24:$AK$24>B107))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B107)+(Heures_Shifts!$B$24:$AK$24>B107))))","v":0},{"$f":"D107-C107","v":0}]
[null,"19:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B108)*(Heures_Shifts!$B$24:$AK$24>B108))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B108)+(Heures_Shifts!$B$24:$AK$24>B108))))","v":0},{"$f":"D108-C108","v":0}]
[null,"20:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B109)*(Heures_Shifts!$B$24:$AK$24>B109))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B109)+(Heures_Shifts!$B$24:$AK$24>B109))))","v":0},{"$f":"D109-C109","v":0}]
[null,"21:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B110)*(Heures_Shifts!$B$24:$AK$24>B110))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B110)+(Heures_Shifts!$B$24:$AK$24>B110))))","v":0},{"$f":"D110-C110","v":0}]
[null,"22:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$23:$AK$23<=B111)*(Heures_Shifts!$B$24:$AK$24>B111))+((Heures_Shifts!$B$24:$AK$24<Heures_Shifts!$B$23:$AK$23)*((Heures_Shifts!$B$23:$AK$23<=B111)+(Heures_Shifts!$B$24:$AK$24>B111))))","v":0},{"$f":"D111-C111","v":0}]
[]
["Dim","Heure","Besoin","Planifié","Écart"]
[null,"07:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B114)*(Heures_Shifts!$B$28:$AK$28>B114))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B114)+(Heures_Shifts!$B$28:$AK$28>B114))))","v":0},{"$f":"D114-C114","v":0}]
[null,"08:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B115)*(Heures_Shifts!$B$28:$AK$28>B115))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B115)+(Heures_Shifts!$B$28:$AK$28>B115))))","v":0},{"$f":"D115-C115","v":0}]
[null,"09:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B116)*(Heures_Shifts!$B$28:$AK$28>B116))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B116)+(Heures_Shifts!$B$28:$AK$28>B116))))","v":0},{"$f":"D116-C116","v":0}]
[null,"10:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B117)*(Heures_Shifts!$B$28:$AK$28>B117))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B117)+(Heures_Shifts!$B$28:$AK$28>B117))))","v":0},{"$f":"D117-C117","v":0}]
[null,"11:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B118)*(Heures_Shifts!$B$28:$AK$28>B118))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B118)+(Heures_Shifts!$B$28:$AK$28>B118))))","v":0},{"$f":"D118-C118","v":0}]
[null,"12:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B119)*(Heures_Shifts!$B$28:$AK$28>B119))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B119)+(Heures_Shifts!$B$28:$AK$28>B119))))","v":0},{"$f":"D119-C119","v":0}]
[null,"13:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B120)*(Heures_Shifts!$B$28:$AK$28>B120))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B120)+(Heures_Shifts!$B$28:$AK$28>B120))))","v":0},{"$f":"D120-C120","v":0}]
[null,"14:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B121)*(Heures_Shifts!$B$28:$AK$28>B121))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B121)+(Heures_Shifts!$B$28:$AK$28>B121))))","v":0},{"$f":"D121-C121","v":0}]
[null,"15:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B122)*(Heures_Shifts!$B$28:$AK$28>B122))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B122)+(Heures_Shifts!$B$28:$AK$28>B122))))","v":0},{"$f":"D122-C122","v":0}]
[null,"16:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B123)*(Heures_Shifts!$B$28:$AK$28>B123))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B123)+(Heures_Shifts!$B$28:$AK$28>B123))))","v":0},{"$f":"D123-C123","v":0}]
[null,"17:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B124)*(Heures_Shifts!$B$28:$AK$28>B124))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B124)+(Heures_Shifts!$B$28:$AK$28>B124))))","v":0},{"$f":"D124-C124","v":0}]
[null,"18:00:00",8,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B125)*(Heures_Shifts!$B$28:$AK$28>B125))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B125)+(Heures_Shifts!$B$28:$AK$28>B125))))","v":0},{"$f":"D125-C125","v":0}]
[null,"19:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B126)*(Heures_Shifts!$B$28:$AK$28>B126))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B126)+(Heures_Shifts!$B$28:$AK$28>B126))))","v":0},{"$f":"D126-C126","v":0}]
[null,"20:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B127)*(Heures_Shifts!$B$28:$AK$28>B127))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B127)+(Heures_Shifts!$B$28:$AK$28>B127))))","v":0},{"$f":"D127-C127","v":0}]
[null,"21:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B128)*(Heures_Shifts!$B$28:$AK$28>B128))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B128)+(Heures_Shifts!$B$28:$AK$28>B128))))","v":0},{"$f":"D128-C128","v":0}]
[null,"22:00:00",3,{"$f":"SUMPRODUCT(((Heures_Shifts!$B$27:$AK$27<=B129)*(Heures_Shifts!$B$28:$AK$28>B129))+((Heures_Shifts!$B$28:$AK$28<Heures_Shifts!$B$27:$AK$27)*((Heures_Shifts!$B$27:$AK$27<=B129)+(Heures_Shifts!$B$28:$AK$28>B129))))","v":0},{"$f":"D129-C129","v":0}]

{"sheet":"Synthèse_Impression","index":4,"n_rows":34,"n_cols":4,"rows_kept":34}
["Synthèse hebdomadaire — Call Center"]
["Semaine du :",{"$f":"Planning_CallCenter!B3","v":"00:00:00"}]
[]
["Heures hebdo par agent"]
["Agent","Heures"]
["Amine L.",{"$f":"Planning_CallCenter!K8","v":0}]
["Sophie D.",{"$f":"Planning_CallCenter!K9","v":0}]
["Karim B.",{"$f":"Planning_CallCenter!K10","v":0}]
["Julie P.",{"$f":"Planning_CallCenter!K11","v":0}]
["Hassan R.",{"$f":"Planning_CallCenter!K12","v":0}]
["Nadia T.",{"$f":"Planning_CallCenter!K13","v":0}]
["Yanis C.",{"$f":"Planning_CallCenter!K14","v":0}]
["Chloé M.",{"$f":"Planning_CallCenter!K15","v":0}]
["Mohamed N.",{"$f":"Planning_CallCenter!K16","v":0}]
["Lina S.",{"$f":"Planning_CallCenter!K17","v":0}]
["Rachid A.",{"$f":"Planning_CallCenter!K18","v":0}]
["Élodie K.",{"$f":"Planning_CallCenter!K19","v":0}]
["Omar T.",{"$f":"Planning_CallCenter!K20","v":0}]
["Salma F.",{"$f":"Planning_CallCenter!K21","v":0}]
["Noa G.",{"$f":"Planning_CallCenter!K22","v":0}]
["Maya R.",{"$f":"Planning_CallCenter!K23","v":0}]
["Total",{"$f":"SUM(B6:B21)","v":0}]
[]
[]
["Récapitulatif Couverture (07:00→22:00)"]
["Jour","Besoin total","Planifié total","Écart"]
["Lun",{"$f":"SUM(Couverture!C6:C21)","v":0},{"$f":"SUM(Couverture!D6:D21)","v":0},{"$f":"C27-B27","v":0}]
["Mar",{"$f":"SUM(Couverture!C24:C39)","v":0},{"$f":"SUM(Couverture!D24:D39)","v":0},{"$f":"C28-B28","v":0}]
["Mer",{"$f":"SUM(Couverture!C42:C57)","v":0},{"$f":"SUM(Couverture!D42:D57)","v":0},{"$f":"C29-B29","v":0}]
["Jeu",{"$f":"SUM(Couverture!C60:C75)","v":0},{"$f":"SUM(Couverture!D60:D75)","v":0},{"$f":"C30-B30","v":0}]
["Ven",{"$f":"SUM(Couverture!C78:C93)","v":0},{"$f":"SUM(Couverture!D78:D93)","v":0},{"$f":"C31-B31","v":0}]
["Sam",{"$f":"SUM(Couverture!C96:C111)","v":0},{"$f":"SUM(Couverture!D96:D111)","v":0},{"$f":"C32-B32","v":0}]
["Dim",{"$f":"SUM(Couverture!C114:C129)","v":0},{"$f":"SUM(Couverture!D114:D129)","v":0},{"$f":"C33-B33","v":0}]
["Total",{"$f":"SUM(B27:B33)","v":0},{"$f":"SUM(C27:C33)","v":0},{"$f":"C34-B34","v":0}]