{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Déc 21","Janvier 22","Février 22","Mars 22","Avril 22","Mai 22","Juin 22","Juillet 22","Config"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Déc 21","index":0,"n_rows":194,"n_cols":23,"rows_kept":194,"cut":false,"hidden":false,"merged":[[188,14,189,14],[188,15,189,15],[190,14,191,14],[190,15,191,15],[192,14,193,14],[192,15,193,15],[182,14,185,14],[182,15,183,15],[184,15,185,15],[186,14,187,14],[186,15,187,15],[174,14,177,14],[174,15,175,15],[176,15,177,15],[178,14,181,14],[178,15,179,15],[180,15,181,15],[166,14,169,14],[166,15,167,15],[168,15,169,15],[170,14,173,14],[170,15,171,15],[172,15,173,15],[158,14,161,14],[158,15,159,15],[160,15,161,15],[162,14,165,14],[162,15,163,15],[164,15,165,15],[152,5,152,6],[152,15,153,15],[154,14,157,14],[154,15,155,15],[156,15,157,15],[144,14,145,14],[144,15,145,15],[149,14,149,15],[150,14,153,14],[150,15,151,15],[138,14,139,14],[138,15,139,15],[140,14,141,14],[140,15,141,15],[142,14,143,14],[142,15,143,15],[130,14,133,14],[130,15,131,15],[132,15,133,15],[134,14,137,14],[134,15,135,15],[136,15,137,15],[122,14,125,14],[122,15,123,15],[124,15,125,15],[126,14,129,14],[126,15,127,15],[128,15,129,15],[114,14,117,14],[114,15,115,15],[116,15,117,15],[118,14,121,14],[118,15,119,15],[120,15,121,15],[106,14,109,14],[106,15,107,15],[108,15,109,15],[110,14,113,14],[110,15,111,15],[112,15,113,15],[101,14,101,15],[102,14,105,14],[102,15,103,15],[104,5,104,6],[104,15,105,15],[5,14,5,15],[14,15,15,15],[16,15,17,15],[18,15,19,15],[20,15,21,15],[48,15,49,15],[6,14,9,14],[14,14,17,14],[18,14,21,14],[8,15,9,15],[6,15,7,15],[10,14,13,14],[10,15,11,15],[12,15,13,15],[38,14,41,14],[34,14,37,14],[42,14,43,14],[44,14,45,14],[46,14,47,14],[14,5,14,6],[86,14,89,14],[86,15,87,15],[88,15,89,15],[24,15,25,15],[22,15,23,15],[22,14,25,14],[30,14,33,14],[26,14,29,14],[48,14,49,14],[36,15,37,15],[40,15,41,15],[38,15,39,15],[42,15,43,15],[44,15,45,15],[46,15,47,15],[28,15,29,15],[78,15,79,15],[80,15,81,15],[82,14,85,14],[53,14,53,15],[54,14,57,14],[54,15,55,15],[56,15,57,15],[26,15,27,15],[32,15,33,15],[30,15,31,15],[34,15,35,15],[96,14,97,14],[96,15,97,15],[78,14,81,14],[90,14,91,14],[90,15,91,15],[92,14,93,14],[92,15,93,15],[94,14,95,14],[94,15,95,15],[82,15,83,15],[84,15,85,15],[56,5,56,6],[66,14,69,14],[66,15,67,15],[68,15,69,15],[70,14,73,14],[70,15,71,15],[72,15,73,15],[74,14,77,14],[74,15,75,15],[76,15,77,15],[62,14,65,14],[62,15,63,15],[64,15,65,15],[58,14,61,14],[58,15,59,15],[60,15,61,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]!NO_COULEUR(O6)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,null,null,null,null,null,null,null,{"$f":"[1]!NO_COULEUR(U10)","v":{"$error":"#NAME?"}}]
["PREVISIONNEL DE PRODUCTION",null,null,{"$f":"H15+H57+H105+H153","v":25},null,"PREVISIONNEL DE FACTURATION MENSUEL HT",null,null,{"$f":"SUM(K15+K57+K105+K153)","v":3302},null,null,null,"PRÉ-PLANIFIÉ","RDV VALIDÉ"]
["CAPACITE DE PRODUCTION MENSUELLE (EN JOURS)",null,null,{"$f":"SUM(H16+H58+H106+H154)","v":{"$error":"#NAME?"}},null,"PREVISIONNEL D'ENTREE DE TRESORERIE",null,null,{"$f":"SUM(L15+L57+L105+L153)","v":0}]
[{"$f":" \"CHANTIERS A REALISER \" & \"S\" & P5","v":"CHANTIERS A REALISER S49"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMAINE",49]
["NOM CLIENT","VILLE","DEPT","N° TEL","PRODUIT","SEM LIVRAISON","DISPO","TPS TOTAL DE POSE (EN JOURS)","NB DE \nPOSEURS","TPS DE POSE\n/POSEUR","FACTURATION \nHT","SOLDE TTC","AU \nPLANNING","CONTACT \nCLIENT","EQUIPES",null,{"$f":"7*P5+DATE($O$2,1,1)-WEEKDAY(DATE($O$2,1,3))-3","v":"2021-12-06"},{"$f":"Q6+1","v":"2021-12-07"},{"$f":"R6+1","v":"2021-12-08"},"2021-12-09","2021-12-10",null,"VERIF PLANNING"]
["SERVICE FACTURIER","LA SEGUINIERE",49,251806953,"VOLETS ROULANTS","S46","OK",4,2,{"$f":"H7/I7","v":2},3302,null,{"$f":"IF(W7>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W7<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":2},"RDV VALIDÉ","OLIVER","MATIN","SERVICE FACTURIER","SERVICE FACTURIER","SAV","SAV","VACANCES",null,{"$f":"COUNTIF(ZP_49[],TC_49[NOM CLIENT])/2","v":4}]
["VANNIER","CHOLET",49,651716146,"FEN COUL + VR","S45","OK",6,2,{"$f":"H8/I8","v":3},null,null,{"$f":"IF(W8>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W8<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(Q7,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q7,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(R7,TC_49[],2,FALSE)&\" \"&VLOOKUP(R7,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(S7,TC_49[],2,FALSE)&\" \"&VLOOKUP(S7,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T7,TC_49[],2,FALSE)&\" \"&VLOOKUP(T7,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U7,TC_49[],2,FALSE)&\" \"&VLOOKUP(U7,TC_49[],3,FALSE),0)","v":0},null,0]
["GLOBE TROTTER","ST MACAIRE",49,662895965,"PERGOLA","S40",null,2,2,1,null,null,{"$f":"IF(W9>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W9<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":2},null,null,"APRES MIDI","SERVICE FACTURIER","SERVICE FACTURIER","SAV","SAV",null,null,2]
["PASQUIER","CHOLET",49,620600059,"RENO MENUISERIE","S42","OK",2,2,1,null,null,{"$f":"IF(W10>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W10<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":2},"RDV VALIDÉ",null,null,{"$f":"IFERROR(VLOOKUP(Q9,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q9,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(R9,TC_49[],2,FALSE)&\" \"&VLOOKUP(R9,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(S9,TC_49[],2,FALSE)&\" \"&VLOOKUP(S9,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T9,TC_49[],2,FALSE)&\" \"&VLOOKUP(T9,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U9,TC_49[],2,FALSE)&\" \"&VLOOKUP(U9,TC_49[],3,FALSE),0)","v":0},null,8]
["MBMO LE BAILLIF","ST LAURENT NOUAN",85,null,"FINITIONS MBMO",null,null,2,2,1,null,null,{"$f":"IF(W11>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W11<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":2},"RDV VALIDÉ","KILLIAN","MATIN","SERVICE FACTURIER","SERVICE FACTURIER","SAV","SAV",null,null,2]
["LEMAITRE","CHOLET",49,null,"RE-ENTOILAGE",null,"OK",0.5,2,0.25,null,null,{"$f":"IF(W13>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W13<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(Q11,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q11,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(R11,TC_49[],2,FALSE)&\" \"&VLOOKUP(R11,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(S11,TC_49[],2,FALSE)&\" \"&VLOOKUP(S11,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T11,TC_49[],2,FALSE)&\" \"&VLOOKUP(T11,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U11,TC_49[],2,FALSE)&\" \"&VLOOKUP(U11,TC_49[],3,FALSE),0)","v":0},null,0]
["GABORIEAU","SAINT GERMAIN",49,610400402,"REMPL DOUBLE VITRAGE",null,"OK",0.5,2,0.25,null,null,{"$f":"IF(W14>=TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W14<TC_49[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":{"$error":"#N/A"}},null,null,"APRES MIDI","SERVICE FACTURIER","SERVICE FACTURIER","SAV","SAV",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q13,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q13,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(R13,TC_49[],2,FALSE)&\" \"&VLOOKUP(R13,TC_49[],3,FALSE),0)","v":"LA SEGUINIERE 49"},{"$f":"IFERROR(VLOOKUP(S13,TC_49[],2,FALSE)&\" \"&VLOOKUP(S13,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T13,TC_49[],2,FALSE)&\" \"&VLOOKUP(T13,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U13,TC_49[],2,FALSE)&\" \"&VLOOKUP(U13,TC_49[],3,FALSE),0)","v":0},null,{"$error":"#N/A"}]
[null,null,null,null,null,"Prévisionnel de production",null,{"$f":"SUBTOTAL(109,TC_49[TPS TOTAL DE POSE (EN JOURS)])","v":17},null,"TOTAL",{"$f":"SUM(TC_49[FACTURATION \nHT])","v":3302},{"$f":"SUM(TC_49[SOLDE TTC])","v":0},null,null,"STEPHANE","MATIN","MONNIER","KESSELS / CAILLEAUD","GLOBE TROTTER","MBMO LE BAILLIF",null,null,{"$error":"#N/A"}]
[null,null,null,null,null,"Capacité de production",null,{"$f":"(COUNTBLANK(ZP_49[])+COUNTA(ZP_49[])-[1]!NB_SI_COULEUR(ZP_49[],$W$1))/4","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q15,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q15,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R15,TC_49[],2,FALSE)&\" \"&VLOOKUP(R15,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S15,TC_49[],2,FALSE)&\" \"&VLOOKUP(S15,TC_49[],3,FALSE),0)","v":"ST MACAIRE 49"},{"$f":"IFERROR(VLOOKUP(T15,TC_49[],2,FALSE)&\" \"&VLOOKUP(T15,TC_49[],3,FALSE),0)","v":"ST LAURENT NOUAN 85"},{"$f":"IFERROR(VLOOKUP(U15,TC_49[],2,FALSE)&\" \"&VLOOKUP(U15,TC_49[],3,FALSE),0)","v":0},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","MONNIER","FERRAND (SAV)","GLOBE TROTTER","MBMO LE BAILLIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q17,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q17,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R17,TC_49[],2,FALSE)&\" \"&VLOOKUP(R17,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S17,TC_49[],2,FALSE)&\" \"&VLOOKUP(S17,TC_49[],3,FALSE),0)","v":"ST MACAIRE 49"},{"$f":"IFERROR(VLOOKUP(T17,TC_49[],2,FALSE)&\" \"&VLOOKUP(T17,TC_49[],3,FALSE),0)","v":"ST LAURENT NOUAN 85"},{"$f":"IFERROR(VLOOKUP(U17,TC_49[],2,FALSE)&\" \"&VLOOKUP(U17,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORIAN","MATIN","MONNIER","KESSELS / CAILLEAUD","GLOBE TROTTER","MBMO LE BAILLIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q19,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q19,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R19,TC_49[],2,FALSE)&\" \"&VLOOKUP(R19,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S19,TC_49[],2,FALSE)&\" \"&VLOOKUP(S19,TC_49[],3,FALSE),0)","v":"ST MACAIRE 49"},{"$f":"IFERROR(VLOOKUP(T19,TC_49[],2,FALSE)&\" \"&VLOOKUP(T19,TC_49[],3,FALSE),0)","v":"ST LAURENT NOUAN 85"},{"$f":"IFERROR(VLOOKUP(U19,TC_49[],2,FALSE)&\" \"&VLOOKUP(U19,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","MONNIER","FERRAND (SAV)","GLOBE TROTTER","MBMO LE BAILLIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q21,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q21,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R21,TC_49[],2,FALSE)&\" \"&VLOOKUP(R21,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S21,TC_49[],2,FALSE)&\" \"&VLOOKUP(S21,TC_49[],3,FALSE),0)","v":"ST MACAIRE 49"},{"$f":"IFERROR(VLOOKUP(T21,TC_49[],2,FALSE)&\" \"&VLOOKUP(T21,TC_49[],3,FALSE),0)","v":"ST LAURENT NOUAN 85"},{"$f":"IFERROR(VLOOKUP(U21,TC_49[],2,FALSE)&\" \"&VLOOKUP(U21,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURENT","MATIN","PASQUIER","PASQUIER","PASQUIER","PASQUIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q23,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q23,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(R23,TC_49[],2,FALSE)&\" \"&VLOOKUP(R23,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(S23,TC_49[],2,FALSE)&\" \"&VLOOKUP(S23,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(T23,TC_49[],2,FALSE)&\" \"&VLOOKUP(T23,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(U23,TC_49[],2,FALSE)&\" \"&VLOOKUP(U23,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","PASQUIER","PASQUIER","PASQUIER","PASQUIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q25,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q25,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(R25,TC_49[],2,FALSE)&\" \"&VLOOKUP(R25,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(S25,TC_49[],2,FALSE)&\" \"&VLOOKUP(S25,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(T25,TC_49[],2,FALSE)&\" \"&VLOOKUP(T25,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(U25,TC_49[],2,FALSE)&\" \"&VLOOKUP(U25,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U27,TC_49[],2,FALSE)&\" \"&VLOOKUP(U27,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U29,TC_49[],2,FALSE)&\" \"&VLOOKUP(U29,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTOPHE","MATIN","PASQUIER","PASQUIER","PASQUIER","PASQUIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q31,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q31,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(R31,TC_49[],2,FALSE)&\" \"&VLOOKUP(R31,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(S31,TC_49[],2,FALSE)&\" \"&VLOOKUP(S31,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(T31,TC_49[],2,FALSE)&\" \"&VLOOKUP(T31,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(U31,TC_49[],2,FALSE)&\" \"&VLOOKUP(U31,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","PASQUIER","PASQUIER","PASQUIER","PASQUIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q33,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q33,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(R33,TC_49[],2,FALSE)&\" \"&VLOOKUP(R33,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(S33,TC_49[],2,FALSE)&\" \"&VLOOKUP(S33,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(T33,TC_49[],2,FALSE)&\" \"&VLOOKUP(T33,TC_49[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(U33,TC_49[],2,FALSE)&\" \"&VLOOKUP(U33,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FABIEN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q35,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q35,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R35,TC_49[],2,FALSE)&\" \"&VLOOKUP(R35,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S35,TC_49[],2,FALSE)&\" \"&VLOOKUP(S35,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T35,TC_49[],2,FALSE)&\" \"&VLOOKUP(T35,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U35,TC_49[],2,FALSE)&\" \"&VLOOKUP(U35,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q37,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q37,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R37,TC_49[],2,FALSE)&\" \"&VLOOKUP(R37,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S37,TC_49[],2,FALSE)&\" \"&VLOOKUP(S37,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T37,TC_49[],2,FALSE)&\" \"&VLOOKUP(T37,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U37,TC_49[],2,FALSE)&\" \"&VLOOKUP(U37,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUENTIN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q39,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q39,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R39,TC_49[],2,FALSE)&\" \"&VLOOKUP(R39,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S39,TC_49[],2,FALSE)&\" \"&VLOOKUP(S39,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T39,TC_49[],2,FALSE)&\" \"&VLOOKUP(T39,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U39,TC_49[],2,FALSE)&\" \"&VLOOKUP(U39,TC_49[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q41,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q41,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R41,TC_49[],2,FALSE)&\" \"&VLOOKUP(R41,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S41,TC_49[],2,FALSE)&\" \"&VLOOKUP(S41,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T41,TC_49[],2,FALSE)&\" \"&VLOOKUP(T41,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U41,TC_49[],2,FALSE)&\" \"&VLOOKUP(U41,TC_49[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q43,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q43,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R43,TC_49[],2,FALSE)&\" \"&VLOOKUP(R43,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S43,TC_49[],2,FALSE)&\" \"&VLOOKUP(S43,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T43,TC_49[],2,FALSE)&\" \"&VLOOKUP(T43,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U43,TC_49[],2,FALSE)&\" \"&VLOOKUP(U43,TC_49[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q45,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q45,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R45,TC_49[],2,FALSE)&\" \"&VLOOKUP(R45,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S45,TC_49[],2,FALSE)&\" \"&VLOOKUP(S45,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T45,TC_49[],2,FALSE)&\" \"&VLOOKUP(T45,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U45,TC_49[],2,FALSE)&\" \"&VLOOKUP(U45,TC_49[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q47,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q47,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R47,TC_49[],2,FALSE)&\" \"&VLOOKUP(R47,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S47,TC_49[],2,FALSE)&\" \"&VLOOKUP(S47,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T47,TC_49[],2,FALSE)&\" \"&VLOOKUP(T47,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U47,TC_49[],2,FALSE)&\" \"&VLOOKUP(U47,TC_49[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q49,TC_49[],2,FALSE)&\" \"&VLOOKUP(Q49,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R49,TC_49[],2,FALSE)&\" \"&VLOOKUP(R49,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S49,TC_49[],2,FALSE)&\" \"&VLOOKUP(S49,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T49,TC_49[],2,FALSE)&\" \"&VLOOKUP(T49,TC_49[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U49,TC_49[],2,FALSE)&\" \"&VLOOKUP(U49,TC_49[],3,FALSE),0)","v":0}]
[]
[]
[{"$f":" \"CHANTIERS A REALISER \" & \"S\" & P53","v":"CHANTIERS A REALISER S50"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"P5+1","v":50}]
["NOM CLIENT","VILLE","DEPT","N° TEL","PRODUIT","SEM LIVRAISON","DISPO","TPS TOTAL DE POSE (EN JOURS)","NB DE \nPOSEURS","TPS DE POSE\n/POSEUR","FACTURATION \nHT","SOLDE TTC","AU \nPLANNING","CONTACT \nCLIENT","EQUIPES",null,{"$f":"7*P53+DATE($O$2,1,1)-WEEKDAY(DATE($O$2,1,3))-3","v":"2021-12-13"},{"$f":"Q54+1","v":"2021-12-14"},{"$f":"R54+1","v":"2021-12-15"},{"$f":"S54+1","v":"2021-12-16"},{"$f":"T54+1","v":"2021-12-17"}]
["VANNIER","CHOLET",49,651716146,"FEN COUL + VR","S45","OK",4,2,{"$f":"H55/I55","v":2},null,null,{"$f":"IF(W56>=TC_50[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W56<TC_50[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":1},null,"OLIVER","MATIN","LEMAITRE","VACANCES",null,null,null,null,{"$f":"COUNTIF($Q$7:$T$250,TC_50[NOM CLIENT])/2","v":0}]
["LEMAITRE","CHOLET",49,null,"RE-ENTOILAGE",null,"OK",1,2,0.5,null,null,{"$f":"IF(W57>=TC_50[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W57<TC_50[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":1},null,null,null,{"$f":"IFERROR(VLOOKUP(Q55,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q55,TC_50[],3,FALSE),0)","v":"CHOLET 49"},{"$f":"IFERROR(VLOOKUP(R55,TC_50[],2,FALSE)&\" \"&VLOOKUP(R55,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S55,TC_50[],2,FALSE)&\" \"&VLOOKUP(S55,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T55,TC_50[],2,FALSE)&\" \"&VLOOKUP(T55,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U55,TC_50[],2,FALSE)&\" \"&VLOOKUP(U55,TC_50[],3,FALSE),0)","v":0},null,0.5]
[null,null,null,null,null,"Prévisionnel de production",null,{"$f":"SUBTOTAL(109,TC_50[TPS TOTAL DE POSE (EN JOURS)])","v":5},null,"TOTAL",{"$f":"SUM(TC_50[FACTURATION \nHT])","v":0},{"$f":"SUM(TC_50[SOLDE TTC])","v":0},null,null,null,"APRES MIDI"]
[null,null,null,null,null,"Capacité de production",null,{"$f":"(COUNTBLANK(Q55:T90)+COUNTA(Q55:T90)-[1]!NB_SI_COULEUR(Q55:T90,$W$1))/4","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q57,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q57,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R57,TC_50[],2,FALSE)&\" \"&VLOOKUP(R57,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S57,TC_50[],2,FALSE)&\" \"&VLOOKUP(S57,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T57,TC_50[],2,FALSE)&\" \"&VLOOKUP(T57,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U57,TC_50[],2,FALSE)&\" \"&VLOOKUP(U57,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KILLIAN","MATIN","ECOLE","ECOLE","ECOLE","ECOLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q59,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q59,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R59,TC_50[],2,FALSE)&\" \"&VLOOKUP(R59,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S59,TC_50[],2,FALSE)&\" \"&VLOOKUP(S59,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T59,TC_50[],2,FALSE)&\" \"&VLOOKUP(T59,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U59,TC_50[],2,FALSE)&\" \"&VLOOKUP(U59,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","ECOLE","ECOLE","ECOLE","ECOLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q61,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q61,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R61,TC_50[],2,FALSE)&\" \"&VLOOKUP(R61,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S61,TC_50[],2,FALSE)&\" \"&VLOOKUP(S61,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T61,TC_50[],2,FALSE)&\" \"&VLOOKUP(T61,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U61,TC_50[],2,FALSE)&\" \"&VLOOKUP(U61,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEPHANE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q63,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q63,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R63,TC_50[],2,FALSE)&\" \"&VLOOKUP(R63,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S63,TC_50[],2,FALSE)&\" \"&VLOOKUP(S63,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T63,TC_50[],2,FALSE)&\" \"&VLOOKUP(T63,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U63,TC_50[],2,FALSE)&\" \"&VLOOKUP(U63,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q65,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q65,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R65,TC_50[],2,FALSE)&\" \"&VLOOKUP(R65,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S65,TC_50[],2,FALSE)&\" \"&VLOOKUP(S65,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T65,TC_50[],2,FALSE)&\" \"&VLOOKUP(T65,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U65,TC_50[],2,FALSE)&\" \"&VLOOKUP(U65,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORIAN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q67,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q67,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R67,TC_50[],2,FALSE)&\" \"&VLOOKUP(R67,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S67,TC_50[],2,FALSE)&\" \"&VLOOKUP(S67,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T67,TC_50[],2,FALSE)&\" \"&VLOOKUP(T67,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U67,TC_50[],2,FALSE)&\" \"&VLOOKUP(U67,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q69,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q69,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R69,TC_50[],2,FALSE)&\" \"&VLOOKUP(R69,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S69,TC_50[],2,FALSE)&\" \"&VLOOKUP(S69,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T69,TC_50[],2,FALSE)&\" \"&VLOOKUP(T69,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U69,TC_50[],2,FALSE)&\" \"&VLOOKUP(U69,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURENT","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q71,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q71,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R71,TC_50[],2,FALSE)&\" \"&VLOOKUP(R71,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S71,TC_50[],2,FALSE)&\" \"&VLOOKUP(S71,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T71,TC_50[],2,FALSE)&\" \"&VLOOKUP(T71,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U71,TC_50[],2,FALSE)&\" \"&VLOOKUP(U71,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q73,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q73,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R73,TC_50[],2,FALSE)&\" \"&VLOOKUP(R73,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S73,TC_50[],2,FALSE)&\" \"&VLOOKUP(S73,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T73,TC_50[],2,FALSE)&\" \"&VLOOKUP(T73,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U73,TC_50[],2,FALSE)&\" \"&VLOOKUP(U73,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","MATIN","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U75,TC_50[],2,FALSE)&\" \"&VLOOKUP(U75,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTOPHE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q79,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q79,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R79,TC_50[],2,FALSE)&\" \"&VLOOKUP(R79,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S79,TC_50[],2,FALSE)&\" \"&VLOOKUP(S79,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T79,TC_50[],2,FALSE)&\" \"&VLOOKUP(T79,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U79,TC_50[],2,FALSE)&\" \"&VLOOKUP(U79,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q81,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q81,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R81,TC_50[],2,FALSE)&\" \"&VLOOKUP(R81,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S81,TC_50[],2,FALSE)&\" \"&VLOOKUP(S81,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T81,TC_50[],2,FALSE)&\" \"&VLOOKUP(T81,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U81,TC_50[],2,FALSE)&\" \"&VLOOKUP(U81,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FABIEN","MATIN","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q83,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q83,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R83,TC_50[],2,FALSE)&\" \"&VLOOKUP(R83,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S83,TC_50[],2,FALSE)&\" \"&VLOOKUP(S83,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T83,TC_50[],2,FALSE)&\" \"&VLOOKUP(T83,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U83,TC_50[],2,FALSE)&\" \"&VLOOKUP(U83,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q85,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q85,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R85,TC_50[],2,FALSE)&\" \"&VLOOKUP(R85,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S85,TC_50[],2,FALSE)&\" \"&VLOOKUP(S85,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T85,TC_50[],2,FALSE)&\" \"&VLOOKUP(T85,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U85,TC_50[],2,FALSE)&\" \"&VLOOKUP(U85,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUENTIN","MATIN","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,{"$f":"IFERROR(VLOOKUP(Q87,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q87,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R87,TC_50[],2,FALSE)&\" \"&VLOOKUP(R87,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S87,TC_50[],2,FALSE)&\" \"&VLOOKUP(S87,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T87,TC_50[],2,FALSE)&\" \"&VLOOKUP(T87,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U87,TC_50[],2,FALSE)&\" \"&VLOOKUP(U87,TC_50[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI","NON DISPO","NON DISPO","NON DISPO","NON DISPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q89,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q89,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R89,TC_50[],2,FALSE)&\" \"&VLOOKUP(R89,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S89,TC_50[],2,FALSE)&\" \"&VLOOKUP(S89,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T89,TC_50[],2,FALSE)&\" \"&VLOOKUP(T89,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U89,TC_50[],2,FALSE)&\" \"&VLOOKUP(U89,TC_50[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q91,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q91,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R91,TC_50[],2,FALSE)&\" \"&VLOOKUP(R91,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S91,TC_50[],2,FALSE)&\" \"&VLOOKUP(S91,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T91,TC_50[],2,FALSE)&\" \"&VLOOKUP(T91,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U91,TC_50[],2,FALSE)&\" \"&VLOOKUP(U91,TC_50[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q93,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q93,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R93,TC_50[],2,FALSE)&\" \"&VLOOKUP(R93,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S93,TC_50[],2,FALSE)&\" \"&VLOOKUP(S93,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T93,TC_50[],2,FALSE)&\" \"&VLOOKUP(T93,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U93,TC_50[],2,FALSE)&\" \"&VLOOKUP(U93,TC_50[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q95,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q95,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R95,TC_50[],2,FALSE)&\" \"&VLOOKUP(R95,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S95,TC_50[],2,FALSE)&\" \"&VLOOKUP(S95,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T95,TC_50[],2,FALSE)&\" \"&VLOOKUP(T95,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U95,TC_50[],2,FALSE)&\" \"&VLOOKUP(U95,TC_50[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q97,TC_50[],2,FALSE)&\" \"&VLOOKUP(Q97,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R97,TC_50[],2,FALSE)&\" \"&VLOOKUP(R97,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S97,TC_50[],2,FALSE)&\" \"&VLOOKUP(S97,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T97,TC_50[],2,FALSE)&\" \"&VLOOKUP(T97,TC_50[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U97,TC_50[],2,FALSE)&\" \"&VLOOKUP(U97,TC_50[],3,FALSE),0)","v":0}]
[]
[]
[{"$f":" \"CHANTIERS A REALISER \" & \"S\" & P101","v":"CHANTIERS A REALISER S51"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"P53+1","v":51}]
["NOM CLIENT","VILLE","DEPT","N° TEL","PRODUIT","SEM LIVRAISON","DISPO","TPS TOTAL DE POSE (EN JOURS)","NB DE \nPOSEURS","TPS DE POSE\n/POSEUR","FACTURATION \nHT","SOLDE TTC","AU \nPLANNING","CONTACT \nCLIENT","EQUIPES",null,{"$f":"7*P101+DATE($O$2,1,1)-WEEKDAY(DATE($O$2,1,3))-3","v":"2021-12-20"},{"$f":"Q102+1","v":"2021-12-21"},{"$f":"R102+1","v":"2021-12-22"},{"$f":"S102+1","v":"2021-12-23"},{"$f":"T102+1","v":"2021-12-24"}]
["arhdk","CHOLET",49,2,"PORA",null,null,3,2,{"$f":"H103/I103","v":1.5},null,null,{"$f":"IF(W103>=TC_51[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W103<TC_51[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":1},null,"OLIVER","MATIN",null,null,null,null,null,null,{"$f":"COUNTIF($Q$7:$T$250,TC_51[NOM CLIENT])/2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q103,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q103,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R103,TC_51[],2,FALSE)&\" \"&VLOOKUP(R103,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S103,TC_51[],2,FALSE)&\" \"&VLOOKUP(S103,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T103,TC_51[],2,FALSE)&\" \"&VLOOKUP(T103,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U103,TC_51[],2,FALSE)&\" \"&VLOOKUP(U103,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,"Prévisionnel de production",null,{"$f":"SUBTOTAL(109,TC_51[TPS TOTAL DE POSE (EN JOURS)])","v":3},null,"TOTAL",{"$f":"SUM(TC_51[FACTURATION \nHT])","v":0},{"$f":"SUM(TC_51[SOLDE TTC])","v":0},null,null,null,"APRES MIDI"]
[null,null,null,null,null,"Capacité de production",null,{"$f":"(COUNTBLANK(Q103:T138)+COUNTA(Q103:T138)-[1]!NB_SI_COULEUR(Q103:T138,$W$1))/4","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q105,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q105,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R105,TC_51[],2,FALSE)&\" \"&VLOOKUP(R105,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S105,TC_51[],2,FALSE)&\" \"&VLOOKUP(S105,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T105,TC_51[],2,FALSE)&\" \"&VLOOKUP(T105,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U105,TC_51[],2,FALSE)&\" \"&VLOOKUP(U105,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KILLIAN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q107,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q107,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R107,TC_51[],2,FALSE)&\" \"&VLOOKUP(R107,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S107,TC_51[],2,FALSE)&\" \"&VLOOKUP(S107,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T107,TC_51[],2,FALSE)&\" \"&VLOOKUP(T107,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U107,TC_51[],2,FALSE)&\" \"&VLOOKUP(U107,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q109,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q109,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R109,TC_51[],2,FALSE)&\" \"&VLOOKUP(R109,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S109,TC_51[],2,FALSE)&\" \"&VLOOKUP(S109,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T109,TC_51[],2,FALSE)&\" \"&VLOOKUP(T109,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U109,TC_51[],2,FALSE)&\" \"&VLOOKUP(U109,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEPHANE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q111,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q111,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R111,TC_51[],2,FALSE)&\" \"&VLOOKUP(R111,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S111,TC_51[],2,FALSE)&\" \"&VLOOKUP(S111,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T111,TC_51[],2,FALSE)&\" \"&VLOOKUP(T111,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U111,TC_51[],2,FALSE)&\" \"&VLOOKUP(U111,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q113,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q113,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R113,TC_51[],2,FALSE)&\" \"&VLOOKUP(R113,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S113,TC_51[],2,FALSE)&\" \"&VLOOKUP(S113,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T113,TC_51[],2,FALSE)&\" \"&VLOOKUP(T113,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U113,TC_51[],2,FALSE)&\" \"&VLOOKUP(U113,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORIAN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q115,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q115,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R115,TC_51[],2,FALSE)&\" \"&VLOOKUP(R115,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S115,TC_51[],2,FALSE)&\" \"&VLOOKUP(S115,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T115,TC_51[],2,FALSE)&\" \"&VLOOKUP(T115,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U115,TC_51[],2,FALSE)&\" \"&VLOOKUP(U115,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q117,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q117,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R117,TC_51[],2,FALSE)&\" \"&VLOOKUP(R117,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S117,TC_51[],2,FALSE)&\" \"&VLOOKUP(S117,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T117,TC_51[],2,FALSE)&\" \"&VLOOKUP(T117,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U117,TC_51[],2,FALSE)&\" \"&VLOOKUP(U117,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURENT","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q119,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q119,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R119,TC_51[],2,FALSE)&\" \"&VLOOKUP(R119,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S119,TC_51[],2,FALSE)&\" \"&VLOOKUP(S119,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T119,TC_51[],2,FALSE)&\" \"&VLOOKUP(T119,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U119,TC_51[],2,FALSE)&\" \"&VLOOKUP(U119,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q121,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q121,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R121,TC_51[],2,FALSE)&\" \"&VLOOKUP(R121,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S121,TC_51[],2,FALSE)&\" \"&VLOOKUP(S121,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T121,TC_51[],2,FALSE)&\" \"&VLOOKUP(T121,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U121,TC_51[],2,FALSE)&\" \"&VLOOKUP(U121,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U123,TC_51[],2,FALSE)&\" \"&VLOOKUP(U123,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTOPHE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q127,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q127,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R127,TC_51[],2,FALSE)&\" \"&VLOOKUP(R127,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S127,TC_51[],2,FALSE)&\" \"&VLOOKUP(S127,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T127,TC_51[],2,FALSE)&\" \"&VLOOKUP(T127,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U127,TC_51[],2,FALSE)&\" \"&VLOOKUP(U127,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q129,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q129,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R129,TC_51[],2,FALSE)&\" \"&VLOOKUP(R129,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S129,TC_51[],2,FALSE)&\" \"&VLOOKUP(S129,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T129,TC_51[],2,FALSE)&\" \"&VLOOKUP(T129,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U129,TC_51[],2,FALSE)&\" \"&VLOOKUP(U129,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FABIEN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q131,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q131,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R131,TC_51[],2,FALSE)&\" \"&VLOOKUP(R131,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S131,TC_51[],2,FALSE)&\" \"&VLOOKUP(S131,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T131,TC_51[],2,FALSE)&\" \"&VLOOKUP(T131,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U131,TC_51[],2,FALSE)&\" \"&VLOOKUP(U131,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q133,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q133,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R133,TC_51[],2,FALSE)&\" \"&VLOOKUP(R133,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S133,TC_51[],2,FALSE)&\" \"&VLOOKUP(S133,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T133,TC_51[],2,FALSE)&\" \"&VLOOKUP(T133,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U133,TC_51[],2,FALSE)&\" \"&VLOOKUP(U133,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUENTIN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,{"$f":"IFERROR(VLOOKUP(Q135,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q135,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R135,TC_51[],2,FALSE)&\" \"&VLOOKUP(R135,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S135,TC_51[],2,FALSE)&\" \"&VLOOKUP(S135,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T135,TC_51[],2,FALSE)&\" \"&VLOOKUP(T135,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U135,TC_51[],2,FALSE)&\" \"&VLOOKUP(U135,TC_51[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q137,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q137,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R137,TC_51[],2,FALSE)&\" \"&VLOOKUP(R137,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S137,TC_51[],2,FALSE)&\" \"&VLOOKUP(S137,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T137,TC_51[],2,FALSE)&\" \"&VLOOKUP(T137,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U137,TC_51[],2,FALSE)&\" \"&VLOOKUP(U137,TC_51[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q139,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q139,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R139,TC_51[],2,FALSE)&\" \"&VLOOKUP(R139,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S139,TC_51[],2,FALSE)&\" \"&VLOOKUP(S139,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T139,TC_51[],2,FALSE)&\" \"&VLOOKUP(T139,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U139,TC_51[],2,FALSE)&\" \"&VLOOKUP(U139,TC_51[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q141,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q141,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R141,TC_51[],2,FALSE)&\" \"&VLOOKUP(R141,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S141,TC_51[],2,FALSE)&\" \"&VLOOKUP(S141,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T141,TC_51[],2,FALSE)&\" \"&VLOOKUP(T141,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U141,TC_51[],2,FALSE)&\" \"&VLOOKUP(U141,TC_51[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q143,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q143,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R143,TC_51[],2,FALSE)&\" \"&VLOOKUP(R143,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S143,TC_51[],2,FALSE)&\" \"&VLOOKUP(S143,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T143,TC_51[],2,FALSE)&\" \"&VLOOKUP(T143,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U143,TC_51[],2,FALSE)&\" \"&VLOOKUP(U143,TC_51[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q145,TC_51[],2,FALSE)&\" \"&VLOOKUP(Q145,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R145,TC_51[],2,FALSE)&\" \"&VLOOKUP(R145,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S145,TC_51[],2,FALSE)&\" \"&VLOOKUP(S145,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T145,TC_51[],2,FALSE)&\" \"&VLOOKUP(T145,TC_51[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U145,TC_51[],2,FALSE)&\" \"&VLOOKUP(U145,TC_51[],3,FALSE),0)","v":0}]
[]
[]
[{"$f":" \"CHANTIERS A REALISER \" & \"S\" & P149","v":"CHANTIERS A REALISER S52"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"P101+1","v":52}]
["NOM CLIENT","VILLE","DEPT","N° TEL","PRODUIT","SEM LIVRAISON","DISPO","TPS TOTAL DE POSE (EN JOURS)","NB DE \nPOSEURS","TPS DE POSE\n/POSEUR","FACTURATION \nHT","SOLDE TTC","AU \nPLANNING","CONTACT \nCLIENT","EQUIPES",null,{"$f":"7*P149+DATE($O$2,1,1)-WEEKDAY(DATE($O$2,1,3))-3","v":"2021-12-27"},{"$f":"Q150+1","v":"2021-12-28"},{"$f":"R150+1","v":"2021-12-29"},{"$f":"S150+1","v":"2021-12-30"},{"$f":"T150+1","v":"2021-12-31"}]
[null,null,null,null,null,null,null,null,null,{"$f":"H151/I151","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(W152>=TC_52[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],2,IF(W152<TC_52[[#This Row],[TPS TOTAL DE POSE (EN JOURS)]],1))","v":2},null,"OLIVER","MATIN",null,null,null,null,null,null,{"$f":"COUNTIF($Q$7:$T$250,TC_52[NOM CLIENT])/2","v":143.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q151,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q151,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R151,TC_52[],2,FALSE)&\" \"&VLOOKUP(R151,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S151,TC_52[],2,FALSE)&\" \"&VLOOKUP(S151,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T151,TC_52[],2,FALSE)&\" \"&VLOOKUP(T151,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U151,TC_52[],2,FALSE)&\" \"&VLOOKUP(U151,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,"Prévisionnel de production",null,{"$f":"SUBTOTAL(109,TC_52[TPS TOTAL DE POSE (EN JOURS)])","v":0},null,"TOTAL",{"$f":"SUM(TC_52[FACTURATION \nHT])","v":0},{"$f":"SUM(TC_52[SOLDE TTC])","v":0},null,null,null,"APRES MIDI"]
[null,null,null,null,null,"Capacité de production",null,{"$f":"(COUNTBLANK(Q151:T186)+COUNTA(Q151:T186)-[1]!NB_SI_COULEUR(Q151:T186,$W$1))/4","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q153,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q153,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R153,TC_52[],2,FALSE)&\" \"&VLOOKUP(R153,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S153,TC_52[],2,FALSE)&\" \"&VLOOKUP(S153,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T153,TC_52[],2,FALSE)&\" \"&VLOOKUP(T153,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U153,TC_52[],2,FALSE)&\" \"&VLOOKUP(U153,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KILLIAN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q155,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q155,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R155,TC_52[],2,FALSE)&\" \"&VLOOKUP(R155,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S155,TC_52[],2,FALSE)&\" \"&VLOOKUP(S155,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T155,TC_52[],2,FALSE)&\" \"&VLOOKUP(T155,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U155,TC_52[],2,FALSE)&\" \"&VLOOKUP(U155,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q157,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q157,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R157,TC_52[],2,FALSE)&\" \"&VLOOKUP(R157,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S157,TC_52[],2,FALSE)&\" \"&VLOOKUP(S157,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T157,TC_52[],2,FALSE)&\" \"&VLOOKUP(T157,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U157,TC_52[],2,FALSE)&\" \"&VLOOKUP(U157,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEPHANE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q159,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q159,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R159,TC_52[],2,FALSE)&\" \"&VLOOKUP(R159,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S159,TC_52[],2,FALSE)&\" \"&VLOOKUP(S159,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T159,TC_52[],2,FALSE)&\" \"&VLOOKUP(T159,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U159,TC_52[],2,FALSE)&\" \"&VLOOKUP(U159,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q161,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q161,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R161,TC_52[],2,FALSE)&\" \"&VLOOKUP(R161,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S161,TC_52[],2,FALSE)&\" \"&VLOOKUP(S161,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T161,TC_52[],2,FALSE)&\" \"&VLOOKUP(T161,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U161,TC_52[],2,FALSE)&\" \"&VLOOKUP(U161,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORIAN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q163,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q163,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R163,TC_52[],2,FALSE)&\" \"&VLOOKUP(R163,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S163,TC_52[],2,FALSE)&\" \"&VLOOKUP(S163,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T163,TC_52[],2,FALSE)&\" \"&VLOOKUP(T163,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U163,TC_52[],2,FALSE)&\" \"&VLOOKUP(U163,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q165,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q165,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R165,TC_52[],2,FALSE)&\" \"&VLOOKUP(R165,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S165,TC_52[],2,FALSE)&\" \"&VLOOKUP(S165,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T165,TC_52[],2,FALSE)&\" \"&VLOOKUP(T165,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U165,TC_52[],2,FALSE)&\" \"&VLOOKUP(U165,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURENT","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q167,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q167,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R167,TC_52[],2,FALSE)&\" \"&VLOOKUP(R167,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S167,TC_52[],2,FALSE)&\" \"&VLOOKUP(S167,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T167,TC_52[],2,FALSE)&\" \"&VLOOKUP(T167,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U167,TC_52[],2,FALSE)&\" \"&VLOOKUP(U167,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q169,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q169,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R169,TC_52[],2,FALSE)&\" \"&VLOOKUP(R169,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S169,TC_52[],2,FALSE)&\" \"&VLOOKUP(S169,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T169,TC_52[],2,FALSE)&\" \"&VLOOKUP(T169,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U169,TC_52[],2,FALSE)&\" \"&VLOOKUP(U169,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U171,TC_52[],2,FALSE)&\" \"&VLOOKUP(U171,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTOPHE","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q175,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q175,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R175,TC_52[],2,FALSE)&\" \"&VLOOKUP(R175,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S175,TC_52[],2,FALSE)&\" \"&VLOOKUP(S175,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T175,TC_52[],2,FALSE)&\" \"&VLOOKUP(T175,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U175,TC_52[],2,FALSE)&\" \"&VLOOKUP(U175,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q177,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q177,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R177,TC_52[],2,FALSE)&\" \"&VLOOKUP(R177,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S177,TC_52[],2,FALSE)&\" \"&VLOOKUP(S177,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T177,TC_52[],2,FALSE)&\" \"&VLOOKUP(T177,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U177,TC_52[],2,FALSE)&\" \"&VLOOKUP(U177,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FABIEN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q179,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q179,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R179,TC_52[],2,FALSE)&\" \"&VLOOKUP(R179,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S179,TC_52[],2,FALSE)&\" \"&VLOOKUP(S179,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T179,TC_52[],2,FALSE)&\" \"&VLOOKUP(T179,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U179,TC_52[],2,FALSE)&\" \"&VLOOKUP(U179,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q181,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q181,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R181,TC_52[],2,FALSE)&\" \"&VLOOKUP(R181,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S181,TC_52[],2,FALSE)&\" \"&VLOOKUP(S181,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T181,TC_52[],2,FALSE)&\" \"&VLOOKUP(T181,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U181,TC_52[],2,FALSE)&\" \"&VLOOKUP(U181,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUENTIN","MATIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,{"$f":"IFERROR(VLOOKUP(Q183,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q183,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R183,TC_52[],2,FALSE)&\" \"&VLOOKUP(R183,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S183,TC_52[],2,FALSE)&\" \"&VLOOKUP(S183,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T183,TC_52[],2,FALSE)&\" \"&VLOOKUP(T183,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U183,TC_52[],2,FALSE)&\" \"&VLOOKUP(U183,TC_52[],3,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APRES MIDI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q185,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q185,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R185,TC_52[],2,FALSE)&\" \"&VLOOKUP(R185,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S185,TC_52[],2,FALSE)&\" \"&VLOOKUP(S185,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T185,TC_52[],2,FALSE)&\" \"&VLOOKUP(T185,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U185,TC_52[],2,FALSE)&\" \"&VLOOKUP(U185,TC_52[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q187,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q187,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R187,TC_52[],2,FALSE)&\" \"&VLOOKUP(R187,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S187,TC_52[],2,FALSE)&\" \"&VLOOKUP(S187,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T187,TC_52[],2,FALSE)&\" \"&VLOOKUP(T187,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U187,TC_52[],2,FALSE)&\" \"&VLOOKUP(U187,TC_52[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q189,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q189,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R189,TC_52[],2,FALSE)&\" \"&VLOOKUP(R189,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S189,TC_52[],2,FALSE)&\" \"&VLOOKUP(S189,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T189,TC_52[],2,FALSE)&\" \"&VLOOKUP(T189,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U189,TC_52[],2,FALSE)&\" \"&VLOOKUP(U189,TC_52[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q191,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q191,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R191,TC_52[],2,FALSE)&\" \"&VLOOKUP(R191,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S191,TC_52[],2,FALSE)&\" \"&VLOOKUP(S191,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T191,TC_52[],2,FALSE)&\" \"&VLOOKUP(T191,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U191,TC_52[],2,FALSE)&\" \"&VLOOKUP(U191,TC_52[],3,FALSE),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Q193,TC_52[],2,FALSE)&\" \"&VLOOKUP(Q193,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(R193,TC_52[],2,FALSE)&\" \"&VLOOKUP(R193,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(S193,TC_52[],2,FALSE)&\" \"&VLOOKUP(S193,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(T193,TC_52[],2,FALSE)&\" \"&VLOOKUP(T193,TC_52[],3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(U193,TC_52[],2,FALSE)&\" \"&VLOOKUP(U193,TC_52[],3,FALSE),0)","v":0}]

{"sheet":"Janvier 22","index":1,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[73,0,73,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[]
[{"$f":"'Déc 21'!O2+1","v":2022}]
[]
["SEMAINE",1]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-01-03"},null,{"$f":"C6+1","v":"2022-01-04"},null,{"$f":"E6+1","v":"2022-01-05"},null,{"$f":"G6+1","v":"2022-01-06"},null,{"$f":"I6+1","v":"2022-01-07"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["STEPHANE"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":2}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-01-10"},null,{"$f":"C25+1","v":"2022-01-11"},null,{"$f":"E25+1","v":"2022-01-12"},null,{"$f":"G25+1","v":"2022-01-13"},null,{"$f":"I25+1","v":"2022-01-14"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":3}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-01-17"},null,{"$f":"C44+1","v":"2022-01-18"},null,{"$f":"E44+1","v":"2022-01-19"},null,{"$f":"G44+1","v":"2022-01-20"},null,{"$f":"I44+1","v":"2022-01-21"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":4}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-01-24"},null,{"$f":"C63+1","v":"2022-01-25"},null,{"$f":"E63+1","v":"2022-01-26"},null,{"$f":"G63+1","v":"2022-01-27"},null,{"$f":"I63+1","v":"2022-01-28"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Février 22","index":2,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[]
[2022]
[]
["SEMAINE",5]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-01-31"},null,{"$f":"C6+1","v":"2022-02-01"},null,{"$f":"E6+1","v":"2022-02-02"},null,{"$f":"G6+1","v":"2022-02-03"},null,{"$f":"I6+1","v":"2022-02-04"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":6}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-02-07"},null,{"$f":"C25+1","v":"2022-02-08"},null,{"$f":"E25+1","v":"2022-02-09"},null,{"$f":"G25+1","v":"2022-02-10"},null,{"$f":"I25+1","v":"2022-02-11"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":7}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-02-14"},null,{"$f":"C44+1","v":"2022-02-15"},null,{"$f":"E44+1","v":"2022-02-16"},null,{"$f":"G44+1","v":"2022-02-17"},null,{"$f":"I44+1","v":"2022-02-18"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":8}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-02-21"},null,{"$f":"C63+1","v":"2022-02-22"},null,{"$f":"E63+1","v":"2022-02-23"},null,{"$f":"G63+1","v":"2022-02-24"},null,{"$f":"I63+1","v":"2022-02-25"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Mars 22","index":3,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[[95,0,95,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[81,2,81,3],[81,4,81,5],[81,6,81,7],[81,8,81,9],[81,10,81,11],[83,0,83,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[81,0,82,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[5,6,5,7],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[0,0,0,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5]]}
[]
[2022]
[]
["SEMAINE",9]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-02-28"},null,{"$f":"C6+1","v":"2022-03-01"},null,{"$f":"E6+1","v":"2022-03-02"},null,{"$f":"G6+1","v":"2022-03-03"},null,{"$f":"I6+1","v":"2022-03-04"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":10}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-03-07"},null,{"$f":"C25+1","v":"2022-03-08"},null,{"$f":"E25+1","v":"2022-03-09"},null,{"$f":"G25+1","v":"2022-03-10"},null,{"$f":"I25+1","v":"2022-03-11"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":11}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-03-14"},null,{"$f":"C44+1","v":"2022-03-15"},null,{"$f":"E44+1","v":"2022-03-16"},null,{"$f":"G44+1","v":"2022-03-17"},null,{"$f":"I44+1","v":"2022-03-18"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":12}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-03-21"},null,{"$f":"C63+1","v":"2022-03-22"},null,{"$f":"E63+1","v":"2022-03-23"},null,{"$f":"G63+1","v":"2022-03-24"},null,{"$f":"I63+1","v":"2022-03-25"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B61+1","v":13}]
[]
["EQUIPES",null,{"$f":"7*B80+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-03-28"},null,{"$f":"C82+1","v":"2022-03-29"},null,{"$f":"E82+1","v":"2022-03-30"},null,{"$f":"G82+1","v":"2022-03-31"},null,{"$f":"I82+1","v":"2022-04-01"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Avril 22","index":4,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[]
[2022]
[]
["SEMAINE",14]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-04-04"},null,{"$f":"C6+1","v":"2022-04-05"},null,{"$f":"E6+1","v":"2022-04-06"},null,{"$f":"G6+1","v":"2022-04-07"},null,{"$f":"I6+1","v":"2022-04-08"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":15}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-04-11"},null,{"$f":"C25+1","v":"2022-04-12"},null,{"$f":"E25+1","v":"2022-04-13"},null,{"$f":"G25+1","v":"2022-04-14"},null,{"$f":"I25+1","v":"2022-04-15"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":16}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-04-18"},null,{"$f":"C44+1","v":"2022-04-19"},null,{"$f":"E44+1","v":"2022-04-20"},null,{"$f":"G44+1","v":"2022-04-21"},null,{"$f":"I44+1","v":"2022-04-22"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":17}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-04-25"},null,{"$f":"C63+1","v":"2022-04-26"},null,{"$f":"E63+1","v":"2022-04-27"},null,{"$f":"G63+1","v":"2022-04-28"},null,{"$f":"I63+1","v":"2022-04-29"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Mai 22","index":5,"n_rows":92,"n_cols":20,"rows_kept":92,"cut":false,"hidden":false,"merged":[[95,8,95,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[93,8,93,9],[94,8,94,9],[81,10,81,11],[81,12,81,13],[81,14,81,15],[81,16,81,17],[81,18,81,19],[83,8,83,9],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[81,8,82,9],[71,8,71,9],[62,12,62,13],[62,14,62,15],[62,16,62,17],[62,18,62,19],[64,8,64,9],[65,8,65,9],[62,10,62,11],[66,8,66,9],[67,8,67,9],[68,8,68,9],[69,8,69,9],[70,8,70,9],[54,8,54,9],[55,8,55,9],[56,8,56,9],[57,8,57,9],[62,8,63,9],[53,8,53,9],[43,14,43,15],[43,16,43,17],[43,18,43,19],[45,8,45,9],[46,8,46,9],[47,8,47,9],[43,12,43,13],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[43,8,44,9],[43,10,43,11],[35,8,35,9],[24,16,24,17],[24,18,24,19],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[24,14,24,15],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[18,8,18,9],[19,8,19,9],[24,8,25,9],[24,10,24,11],[24,12,24,13],[17,8,17,9],[5,18,5,19],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[5,16,5,17],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[1,8,1,9],[5,8,6,9],[5,10,5,11],[5,12,5,13],[5,14,5,15]]}
[]
[null,null,null,null,null,null,null,null,2022]
[]
[null,null,null,null,null,null,null,null,"SEMAINE",18]
[]
[null,null,null,null,null,null,null,null,"EQUIPES",null,{"$f":"7*J4+DATE(I2,1,1)-WEEKDAY(DATE(I2,1,3))-3","v":"2022-05-02"},null,{"$f":"K6+1","v":"2022-05-03"},null,{"$f":"M6+1","v":"2022-05-04"},null,{"$f":"O6+1","v":"2022-05-05"},null,{"$f":"Q6+1","v":"2022-05-06"}]
[null,null,null,null,null,null,null,null,null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
[null,null,null,null,null,null,null,null,"OLIVER"]
[null,null,null,null,null,null,null,null,"KILLIAN"]
[null,null,null,null,null,null,null,null,"STEPHANE"]
[null,null,null,null,null,null,null,null,"FLORIAN"]
[null,null,null,null,null,null,null,null,"LAURENT"]
[null,null,null,null,null,null,null,null,"MATHIEU"]
[null,null,null,null,null,null,null,null,"CHRISTOPHE"]
[null,null,null,null,null,null,null,null,"FABIEN"]
[null,null,null,null,null,null,null,null,"QUENTIN"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"J4+1","v":19}]
[]
[null,null,null,null,null,null,null,null,"EQUIPES",null,{"$f":"7*J23+DATE(I2,1,1)-WEEKDAY(DATE(I2,1,3))-3","v":"2022-05-09"},null,{"$f":"K25+1","v":"2022-05-10"},null,{"$f":"M25+1","v":"2022-05-11"},null,{"$f":"O25+1","v":"2022-05-12"},null,{"$f":"Q25+1","v":"2022-05-13"}]
[null,null,null,null,null,null,null,null,null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
[null,null,null,null,null,null,null,null,"OLIVER"]
[null,null,null,null,null,null,null,null,"KILLIAN"]
[null,null,null,null,null,null,null,null,"STEPHANE"]
[null,null,null,null,null,null,null,null,"FLORIAN"]
[null,null,null,null,null,null,null,null,"LAURENT"]
[null,null,null,null,null,null,null,null,"MATHIEU"]
[null,null,null,null,null,null,null,null,"CHRISTOPHE"]
[null,null,null,null,null,null,null,null,"FABIEN"]
[null,null,null,null,null,null,null,null,"QUENTIN"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"J23+1","v":20}]
[]
[null,null,null,null,null,null,null,null,"EQUIPES",null,{"$f":"7*J42+DATE(I2,1,1)-WEEKDAY(DATE(I2,1,3))-3","v":"2022-05-16"},null,{"$f":"K44+1","v":"2022-05-17"},null,{"$f":"M44+1","v":"2022-05-18"},null,{"$f":"O44+1","v":"2022-05-19"},null,{"$f":"Q44+1","v":"2022-05-20"}]
[null,null,null,null,null,null,null,null,null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
[null,null,null,null,null,null,null,null,"OLIVER"]
[null,null,null,null,null,null,null,null,"KILLIAN"]
[null,null,null,null,null,null,null,null,"STEPHANE"]
[null,null,null,null,null,null,null,null,"FLORIAN"]
[null,null,null,null,null,null,null,null,"LAURENT"]
[null,null,null,null,null,null,null,null,"MATHIEU"]
[null,null,null,null,null,null,null,null,"CHRISTOPHE"]
[null,null,null,null,null,null,null,null,"FABIEN"]
[null,null,null,null,null,null,null,null,"QUENTIN"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"J42+1","v":21}]
[]
[null,null,null,null,null,null,null,null,"EQUIPES",null,{"$f":"7*J61+DATE(I2,1,1)-WEEKDAY(DATE(I2,1,3))-3","v":"2022-05-23"},null,{"$f":"K63+1","v":"2022-05-24"},null,{"$f":"M63+1","v":"2022-05-25"},null,{"$f":"O63+1","v":"2022-05-26"},null,{"$f":"Q63+1","v":"2022-05-27"}]
[null,null,null,null,null,null,null,null,null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
[null,null,null,null,null,null,null,null,"OLIVER"]
[null,null,null,null,null,null,null,null,"KILLIAN"]
[null,null,null,null,null,null,null,null,"STEPHANE"]
[null,null,null,null,null,null,null,null,"FLORIAN"]
[null,null,null,null,null,null,null,null,"LAURENT"]
[null,null,null,null,null,null,null,null,"MATHIEU"]
[null,null,null,null,null,null,null,null,"CHRISTOPHE"]
[null,null,null,null,null,null,null,null,"FABIEN"]
[null,null,null,null,null,null,null,null,"QUENTIN"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SEMAINE",{"$f":"J61+1","v":22}]
[]
[null,null,null,null,null,null,null,null,"EQUIPES",null,{"$f":"7*J80+DATE(I2,1,1)-WEEKDAY(DATE(I2,1,3))-3","v":"2022-05-30"},null,{"$f":"K82+1","v":"2022-05-31"},null,{"$f":"M82+1","v":"2022-06-01"},null,{"$f":"O82+1","v":"2022-06-02"},null,{"$f":"Q82+1","v":"2022-06-03"}]
[null,null,null,null,null,null,null,null,null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
[null,null,null,null,null,null,null,null,"OLIVER"]
[null,null,null,null,null,null,null,null,"KILLIAN"]
[null,null,null,null,null,null,null,null,"STEPHANE"]
[null,null,null,null,null,null,null,null,"FLORIAN"]
[null,null,null,null,null,null,null,null,"LAURENT"]
[null,null,null,null,null,null,null,null,"MATHIEU"]
[null,null,null,null,null,null,null,null,"CHRISTOPHE"]
[null,null,null,null,null,null,null,null,"FABIEN"]
[null,null,null,null,null,null,null,null,"QUENTIN"]

{"sheet":"Juin 22","index":6,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[]
[2022]
[]
["SEMAINE",23]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-06-06"},null,{"$f":"C6+1","v":"2022-06-07"},null,{"$f":"E6+1","v":"2022-06-08"},null,{"$f":"G6+1","v":"2022-06-09"},null,{"$f":"I6+1","v":"2022-06-10"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":24}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-06-13"},null,{"$f":"C25+1","v":"2022-06-14"},null,{"$f":"E25+1","v":"2022-06-15"},null,{"$f":"G25+1","v":"2022-06-16"},null,{"$f":"I25+1","v":"2022-06-17"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":25}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-06-20"},null,{"$f":"C44+1","v":"2022-06-21"},null,{"$f":"E44+1","v":"2022-06-22"},null,{"$f":"G44+1","v":"2022-06-23"},null,{"$f":"I44+1","v":"2022-06-24"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":26}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-06-27"},null,{"$f":"C63+1","v":"2022-06-28"},null,{"$f":"E63+1","v":"2022-06-29"},null,{"$f":"G63+1","v":"2022-06-30"},null,{"$f":"I63+1","v":"2022-07-01"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Juillet 22","index":7,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[71,0,71,1],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[64,0,64,1],[65,0,65,1],[62,2,62,3],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[62,0,63,1],[53,0,53,1],[43,6,43,7],[43,8,43,9],[43,10,43,11],[45,0,45,1],[46,0,46,1],[47,0,47,1],[43,4,43,5],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[43,0,44,1],[43,2,43,3],[35,0,35,1],[24,8,24,9],[24,10,24,11],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[24,6,24,7],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[18,0,18,1],[19,0,19,1],[24,0,25,1],[24,2,24,3],[24,4,24,5],[17,0,17,1],[5,10,5,11],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,8,5,9],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[1,0,1,1],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[]
[2022]
[]
["SEMAINE",27]
[]
["EQUIPES",null,{"$f":"7*B4+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-07-04"},null,{"$f":"C6+1","v":"2022-07-05"},null,{"$f":"E6+1","v":"2022-07-06"},null,{"$f":"G6+1","v":"2022-07-07"},null,{"$f":"I6+1","v":"2022-07-08"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B4+1","v":28}]
[]
["EQUIPES",null,{"$f":"7*B23+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-07-11"},null,{"$f":"C25+1","v":"2022-07-12"},null,{"$f":"E25+1","v":"2022-07-13"},null,{"$f":"G25+1","v":"2022-07-14"},null,{"$f":"I25+1","v":"2022-07-15"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B23+1","v":29}]
[]
["EQUIPES",null,{"$f":"7*B42+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-07-18"},null,{"$f":"C44+1","v":"2022-07-19"},null,{"$f":"E44+1","v":"2022-07-20"},null,{"$f":"G44+1","v":"2022-07-21"},null,{"$f":"I44+1","v":"2022-07-22"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]
[]
[]
[]
[]
[]
[]
["SEMAINE",{"$f":"B42+1","v":30}]
[]
["EQUIPES",null,{"$f":"7*B61+DATE(A2,1,1)-WEEKDAY(DATE(A2,1,3))-3","v":"2022-07-25"},null,{"$f":"C63+1","v":"2022-07-26"},null,{"$f":"E63+1","v":"2022-07-27"},null,{"$f":"G63+1","v":"2022-07-28"},null,{"$f":"I63+1","v":"2022-07-29"}]
[null,null,"MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI","MATIN","APRES-MIDI"]
["OLIVER"]
["KILLIAN"]
["STEPHANE"]
["FLORIAN"]
["LAURENT"]
["MATHIEU"]
["CHRISTOPHE"]
["FABIEN"]
["QUENTIN"]

{"sheet":"Config","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Motifs"]
["POSEURS",null,null,"VACANCES"]
["Florian",null,null,"ECOLE"]
["Killian",null,null,"FORMATION"]
["Laurent",null,null,"SAV"]
["Oliver",null,null,"NON DISPO"]
["Stéphane"]
[]
["Christophe"]
["Fabien"]
["Quentin"]