{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["SEM","Modèle","1","2","3","4","5","6","7","8","9","10"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"SEM","index":0,"n_rows":39,"n_cols":40,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,30,1,31],[2,30,3,31],[1,37,1,38],[2,37,3,38],[1,9,1,10],[2,9,3,10],[1,16,1,17],[2,16,3,17],[1,23,1,24],[2,23,3,24],[5,39,8,39],[5,0,8,1],[5,4,5,38],[6,4,7,10],[6,11,7,17],[6,18,7,24],[6,25,7,31],[6,32,7,38],[5,2,8,2],[5,3,8,3]]}
["XXXX"]
["XXX",null,null,null,"Heure","Début","Fin","Repas",null,"Horaires",null,"Heure","Début","Fin","Repas",null,"Horaires",null,"Heure","Début","Fin","Repas",null,"Horaires",null,"Heure","Début","Fin","Repas",null,"Horaires",null,"Heure","Début","Fin","Repas",null,"Horaires"]
[null,null,null,null,"Prévue",null,null,null,null,"10h00 - 19h00",null,"Prévue",null,null,null,null,"10h00 - 19h00",null,"Prévue",null,null,null,null,"10h00 - 19h00",null,"Prévue",null,null,null,null,"10h00 - 19h00",null,"Prévue",null,null,null,null,"10h00 - 19h00"]
[null,null,null,null,"Réelle","10:00:00","19:00:00","01:00:00",null,null,null,"Réelle","10:00:00","19:00:00","01:00:00",null,null,null,"Réelle","10:00:00","19:00:00","01:00:00",null,null,null,"Réelle","10:00:00","19:00:00","01:00:00",null,null,null,"Réelle","10:00:00","19:00:00","01:00:00"]
[]
["SEMAINE DU 01/01/2000 AU 05/01/2000",null,1,"Remballe\nREF","SEMAINE 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUMUL HEURES SEMAINE"]
[null,null,null,null,"Lundi 01/01",null,null,null,null,null,null,"Mardi 02/01",null,null,null,null,null,null,"Mercredi 03/01",null,null,null,null,null,null,"Jeudi 04/01",null,null,null,null,null,null,"Vendredi 05/01"]
[]
[null,null,null,null,"Prépa"," H Début","H Fin","Repas","Temps tour","Remballe","Total jour","Prépa"," H Début","H Fin","Repas","Temps tour","Remballe","Total jour","Prépa"," H Début","H Fin","Repas","Temps tour","Remballe","Total jour","Prépa"," H Début","H Fin","Repas","Temps tour","Remballe","Total jour","Prépa"," H Début","H Fin","Repas","Temps tour","Remballe","Total jour"]
["INTITULÉ DU POSTE"]
["RÉEL",1,"01:00:00","00:30:00",{"$f":"$C11","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G11-F11-H11,1)","v":"00:00:00"},{"$f":"$D11","v":"00:30:00"},{"$f":"E11+I11+J11","v":"01:30:00"},{"$f":"$C11","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N11-M11-O11,1)","v":"00:00:00"},{"$f":"$D11","v":"00:30:00"},{"$f":"L11+P11+Q11","v":"01:30:00"},{"$f":"$C11","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U11-T11-V11,1)","v":"00:00:00"},{"$f":"$D11","v":"00:30:00"},{"$f":"S11+W11+X11","v":"01:30:00"},{"$f":"$C11","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB11-AA11-AC11,1)","v":"00:00:00"},{"$f":"$D11","v":"00:30:00"},{"$f":"Z11+AD11+AE11","v":"01:30:00"},{"$f":"$C11","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI11-AH11-AJ11,1)","v":"00:00:00"},{"$f":"$D11","v":"00:30:00"},{"$f":"AG11+AK11+AL11","v":"01:30:00"},{"$f":"K11+R11+Y11+AF11+AM11","v":0.3125}]
["MODIFIÉ",null,"01:00:00","00:30:00",{"$f":"$C12","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G12-F12-H12,1)","v":"08:00:00"},{"$f":"$D12","v":"00:30:00"},{"$f":"E12+I12+J12","v":"09:30:00"},{"$f":"$C12","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N12-M12-O12,1)","v":"08:00:00"},{"$f":"$D12","v":"00:30:00"},{"$f":"L12+P12+Q12","v":"09:30:00"},{"$f":"C12","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U12-T12-V12,1)","v":"08:00:00"},{"$f":"$D12","v":"00:30:00"},{"$f":"S12+W12+X12","v":"09:30:00"},{"$f":"C12","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB12-AA12-AC12,1)","v":"08:00:00"},{"$f":"$D12","v":"00:30:00"},{"$f":"Z12+AD12+AE12","v":"09:30:00"},{"$f":"$C12","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI12-AH12-AJ12,1)","v":"08:00:00"},{"$f":"$D12","v":"00:30:00"},{"$f":"AG12+AK12+AL12","v":"09:30:00"},{"$f":"AM12+AF12+Y12+R12+K12","v":1.9791666666666663}]
["INTITULÉ DU POSTE"]
["RÉEL",2,"01:00:00","00:00:00",{"$f":"$C14","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G14-F14-H14,1)","v":"00:00:00"},{"$f":"$D14","v":"00:00:00"},{"$f":"E14+I14+J14","v":"01:00:00"},{"$f":"$C14","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N14-M14-O14,1)","v":"00:00:00"},{"$f":"$D14","v":"00:00:00"},{"$f":"L14+P14+Q14","v":"01:00:00"},{"$f":"$C14","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U14-T14-V14,1)","v":"00:00:00"},{"$f":"$D14","v":"00:00:00"},{"$f":"S14+W14+X14","v":"01:00:00"},{"$f":"$C14","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB14-AA14-AC14,1)","v":"00:00:00"},{"$f":"$D14","v":"00:00:00"},{"$f":"Z14+AD14+AE14","v":"01:00:00"},{"$f":"$C14","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI14-AH14-AJ14,1)","v":"00:00:00"},{"$f":"$D14","v":"00:00:00"},{"$f":"AG14+AK14+AL14","v":"01:00:00"},{"$f":"AM14+AF14+Y14+R14+K14","v":0.20833333333333348}]
["MODIFIÉ",null,"01:00:00","00:30:00",{"$f":"$C15","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G15-F15-H15,1)","v":"08:00:00"},{"$f":"$D15","v":"00:30:00"},{"$f":"E15+I15+J15","v":"09:30:00"},{"$f":"$C15","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N15-M15-O15,1)","v":"08:00:00"},{"$f":"$D15","v":"00:30:00"},{"$f":"L15+P15+Q15","v":"09:30:00"},{"$f":"C15","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U15-T15-V15,1)","v":"08:00:00"},{"$f":"$D15","v":"00:30:00"},{"$f":"S15+W15+X15","v":"09:30:00"},{"$f":"C15","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB15-AA15-AC15,1)","v":"08:00:00"},{"$f":"$D15","v":"00:30:00"},{"$f":"Z15+AD15+AE15","v":"09:30:00"},{"$f":"$C15","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI15-AH15-AJ15,1)","v":"08:00:00"},{"$f":"$D15","v":"00:30:00"},{"$f":"AG15+AK15+AL15","v":"09:30:00"},{"$f":"AM15+AF15+Y15+R15+K15","v":1.9791666666666663}]
["INTITULÉ DU POSTE"]
["RÉEL",3,"00:00:00","00:00:00",{"$f":"$C17","v":"00:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G17-F17-H17,1)","v":"00:00:00"},{"$f":"$D17","v":"00:00:00"},{"$f":"E17+I17+J17","v":"00:00:00"},{"$f":"$C17","v":"00:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N17-M17-O17,1)","v":"00:00:00"},{"$f":"$D17","v":"00:00:00"},{"$f":"L17+P17+Q17","v":"00:00:00"},{"$f":"$C17","v":"00:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U17-T17-V17,1)","v":"00:00:00"},{"$f":"$D17","v":"00:00:00"},{"$f":"S17+W17+X17","v":"00:00:00"},{"$f":"$C17","v":"00:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB17-AA17-AC17,1)","v":"00:00:00"},{"$f":"$D17","v":"00:00:00"},{"$f":"Z17+AD17+AE17","v":"00:00:00"},{"$f":"$C17","v":"00:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI17-AH17-AJ17,1)","v":"00:00:00"},{"$f":"$D17","v":"00:00:00"},{"$f":"AG17+AK17+AL17","v":"00:00:00"},{"$f":"AM17+AF17+Y17+R17+K17","v":0}]
["MODIFIÉ",null,"00:00:00","00:00:00",{"$f":"$C18","v":"00:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G18-F18-H18,1)","v":"08:00:00"},{"$f":"$D18","v":"00:00:00"},{"$f":"E18+I18+J18","v":"08:00:00"},{"$f":"$C18","v":"00:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N18-M18-O18,1)","v":"08:00:00"},{"$f":"$D18","v":"00:00:00"},{"$f":"L18+P18+Q18","v":"08:00:00"},{"$f":"C18","v":"00:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U18-T18-V18,1)","v":"08:00:00"},{"$f":"$D18","v":"00:00:00"},{"$f":"S18+W18+X18","v":"08:00:00"},{"$f":"C18","v":"00:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB18-AA18-AC18,1)","v":"08:00:00"},{"$f":"$D18","v":"00:00:00"},{"$f":"Z18+AD18+AE18","v":"08:00:00"},{"$f":"$C18","v":"00:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI18-AH18-AJ18,1)","v":"08:00:00"},{"$f":"$D18","v":"00:00:00"},{"$f":"AG18+AK18+AL18","v":"08:00:00"},{"$f":"AM18+AF18+Y18+R18+K18","v":1.6666666666666663}]
["INTITULÉ DU POSTE"]
["RÉEL",4,"01:00:00","00:00:00",{"$f":"$C20","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G20-F20-H20,1)","v":"00:00:00"},{"$f":"$D20","v":"00:00:00"},{"$f":"E20+I20+J20","v":"01:00:00"},{"$f":"$C20","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N20-M20-O20,1)","v":"00:00:00"},{"$f":"$D20","v":"00:00:00"},{"$f":"L20+P20+Q20","v":"01:00:00"},{"$f":"$C20","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U20-T20-V20,1)","v":"00:00:00"},{"$f":"$D20","v":"00:00:00"},{"$f":"S20+W20+X20","v":"01:00:00"},{"$f":"$C20","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB20-AA20-AC20,1)","v":"00:00:00"},{"$f":"$D20","v":"00:00:00"},{"$f":"Z20+AD20+AE20","v":"01:00:00"},{"$f":"$C20","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI20-AH20-AJ20,1)","v":"00:00:00"},{"$f":"$D20","v":"00:00:00"},{"$f":"AG20+AK20+AL20","v":"01:00:00"},{"$f":"AM20+AF20+Y20+R20+K20","v":0.20833333333333348}]
["MODIFIÉ",null,"01:00:00","00:30:00",{"$f":"$C21","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G21-F21-H21,1)","v":"08:00:00"},{"$f":"$D21","v":"00:30:00"},{"$f":"E21+I21+J21","v":"09:30:00"},{"$f":"$C21","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N21-M21-O21,1)","v":"08:00:00"},{"$f":"$D21","v":"00:30:00"},{"$f":"L21+P21+Q21","v":"09:30:00"},{"$f":"C21","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U21-T21-V21,1)","v":"08:00:00"},{"$f":"$D21","v":"00:30:00"},{"$f":"S21+W21+X21","v":"09:30:00"},{"$f":"C21","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB21-AA21-AC21,1)","v":"08:00:00"},{"$f":"$D21","v":"00:30:00"},{"$f":"Z21+AD21+AE21","v":"09:30:00"},{"$f":"$C21","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI21-AH21-AJ21,1)","v":"08:00:00"},{"$f":"$D21","v":"00:30:00"},{"$f":"AG21+AK21+AL21","v":"09:30:00"},{"$f":"AM21+AF21+Y21+R21+K21","v":1.9791666666666663}]
["INTITULÉ DU POSTE"]
["RÉEL",5,"01:00:00","01:00:00",{"$f":"$C23","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G23-F23-H23,1)","v":"00:00:00"},{"$f":"$D23","v":"01:00:00"},{"$f":"E23+I23+J23","v":"02:00:00"},{"$f":"$C23","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N23-M23-O23,1)","v":"00:00:00"},{"$f":"$D23","v":"01:00:00"},{"$f":"L23+P23+Q23","v":"02:00:00"},{"$f":"$C23","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U23-T23-V23,1)","v":"00:00:00"},{"$f":"$D23","v":"01:00:00"},{"$f":"S23+W23+X23","v":"02:00:00"},{"$f":"$C23","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB23-AA23-AC23,1)","v":"00:00:00"},{"$f":"$D23","v":"01:00:00"},{"$f":"Z23+AD23+AE23","v":"02:00:00"},{"$f":"$C23","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI23-AH23-AJ23,1)","v":"00:00:00"},{"$f":"$D23","v":"01:00:00"},{"$f":"AG23+AK23+AL23","v":"02:00:00"},{"$f":"AM23+AF23+Y23+R23+K23","v":0.41666666666666696}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C24","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G24-F24-H24,1)","v":"08:00:00"},{"$f":"$D24","v":"01:00:00"},{"$f":"E24+I24+J24","v":"10:00:00"},{"$f":"$C24","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N24-M24-O24,1)","v":"08:00:00"},{"$f":"$D24","v":"01:00:00"},{"$f":"L24+P24+Q24","v":"10:00:00"},{"$f":"C24","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U24-T24-V24,1)","v":"08:00:00"},{"$f":"$D24","v":"01:00:00"},{"$f":"S24+W24+X24","v":"10:00:00"},{"$f":"C24","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB24-AA24-AC24,1)","v":"08:00:00"},{"$f":"$D24","v":"01:00:00"},{"$f":"Z24+AD24+AE24","v":"10:00:00"},{"$f":"$C24","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI24-AH24-AJ24,1)","v":"08:00:00"},{"$f":"$D24","v":"01:00:00"},{"$f":"AG24+AK24+AL24","v":"10:00:00"},{"$f":"AM24+AF24+Y24+R24+K24","v":2.083333333333333}]
["INTITULÉ DU POSTE"]
["RÉEL",6,"01:00:00","01:00:00",{"$f":"$C26","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G26-F26-H26,1)","v":"00:00:00"},{"$f":"$D26","v":"01:00:00"},{"$f":"E26+I26+J26","v":"02:00:00"},{"$f":"$C26","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N26-M26-O26,1)","v":"00:00:00"},{"$f":"$D26","v":"01:00:00"},{"$f":"L26+P26+Q26","v":"02:00:00"},{"$f":"$C26","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U26-T26-V26,1)","v":"00:00:00"},{"$f":"$D26","v":"01:00:00"},{"$f":"S26+W26+X26","v":"02:00:00"},{"$f":"$C26","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB26-AA26-AC26,1)","v":"00:00:00"},{"$f":"$D26","v":"01:00:00"},{"$f":"Z26+AD26+AE26","v":"02:00:00"},{"$f":"$C26","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI26-AH26-AJ26,1)","v":"00:00:00"},{"$f":"$D26","v":"01:00:00"},{"$f":"AG26+AK26+AL26","v":"02:00:00"},{"$f":"AM26+AF26+Y26+R26+K26","v":0.41666666666666696}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C27","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G27-F27-H27,1)","v":"08:00:00"},{"$f":"$D27","v":"01:00:00"},{"$f":"E27+I27+J27","v":"10:00:00"},{"$f":"$C27","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N27-M27-O27,1)","v":"08:00:00"},{"$f":"$D27","v":"01:00:00"},{"$f":"L27+P27+Q27","v":"10:00:00"},{"$f":"C27","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U27-T27-V27,1)","v":"08:00:00"},{"$f":"$D27","v":"01:00:00"},{"$f":"S27+W27+X27","v":"10:00:00"},{"$f":"C27","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB27-AA27-AC27,1)","v":"08:00:00"},{"$f":"$D27","v":"01:00:00"},{"$f":"Z27+AD27+AE27","v":"10:00:00"},{"$f":"$C27","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI27-AH27-AJ27,1)","v":"08:00:00"},{"$f":"$D27","v":"01:00:00"},{"$f":"AG27+AK27+AL27","v":"10:00:00"},{"$f":"AM27+AF27+Y27+R27+K27","v":2.083333333333333}]
["INTITULÉ DU POSTE"]
["RÉEL",7,"01:00:00","01:00:00",{"$f":"$C29","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G29-F29-H29,1)","v":"00:00:00"},{"$f":"$D29","v":"01:00:00"},{"$f":"E29+I29+J29","v":"02:00:00"},{"$f":"$C29","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N29-M29-O29,1)","v":"00:00:00"},{"$f":"$D29","v":"01:00:00"},{"$f":"L29+P29+Q29","v":"02:00:00"},{"$f":"$C29","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U29-T29-V29,1)","v":"00:00:00"},{"$f":"$D29","v":"01:00:00"},{"$f":"S29+W29+X29","v":"02:00:00"},{"$f":"$C29","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB29-AA29-AC29,1)","v":"00:00:00"},{"$f":"$D29","v":"01:00:00"},{"$f":"Z29+AD29+AE29","v":"02:00:00"},{"$f":"$C29","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI29-AH29-AJ29,1)","v":"00:00:00"},{"$f":"$D29","v":"01:00:00"},{"$f":"AG29+AK29+AL29","v":"02:00:00"},{"$f":"AM29+AF29+Y29+R29+K29","v":0.41666666666666696}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C30","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G30-F30-H30,1)","v":"08:00:00"},{"$f":"$D30","v":"01:00:00"},{"$f":"E30+I30+J30","v":"10:00:00"},{"$f":"$C30","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N30-M30-O30,1)","v":"08:00:00"},{"$f":"$D30","v":"01:00:00"},{"$f":"L30+P30+Q30","v":"10:00:00"},{"$f":"C30","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U30-T30-V30,1)","v":"08:00:00"},{"$f":"$D30","v":"01:00:00"},{"$f":"S30+W30+X30","v":"10:00:00"},{"$f":"C30","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB30-AA30-AC30,1)","v":"08:00:00"},{"$f":"$D30","v":"01:00:00"},{"$f":"Z30+AD30+AE30","v":"10:00:00"},{"$f":"$C30","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI30-AH30-AJ30,1)","v":"08:00:00"},{"$f":"$D30","v":"01:00:00"},{"$f":"AG30+AK30+AL30","v":"10:00:00"},{"$f":"AM30+AF30+Y30+R30+K30","v":2.083333333333333}]
["INTITULÉ DU POSTE"]
["RÉEL",8,"01:00:00","01:00:00",{"$f":"$C32","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G32-F32-H32,1)","v":"00:00:00"},{"$f":"$D32","v":"01:00:00"},{"$f":"E32+I32+J32","v":"02:00:00"},{"$f":"$C32","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N32-M32-O32,1)","v":"00:00:00"},{"$f":"$D32","v":"01:00:00"},{"$f":"L32+P32+Q32","v":"02:00:00"},{"$f":"$C32","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U32-T32-V32,1)","v":"00:00:00"},{"$f":"$D32","v":"01:00:00"},{"$f":"S32+W32+X32","v":"02:00:00"},{"$f":"$C32","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB32-AA32-AC32,1)","v":"00:00:00"},{"$f":"$D32","v":"01:00:00"},{"$f":"Z32+AD32+AE32","v":"02:00:00"},{"$f":"$C32","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI32-AH32-AJ32,1)","v":"00:00:00"},{"$f":"$D32","v":"01:00:00"},{"$f":"AG32+AK32+AL32","v":"02:00:00"},{"$f":"AM32+AF32+Y32+R32+K32","v":0.41666666666666696}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C33","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G33-F33-H33,1)","v":"08:00:00"},{"$f":"$D33","v":"01:00:00"},{"$f":"E33+I33+J33","v":"10:00:00"},{"$f":"$C33","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N33-M33-O33,1)","v":"08:00:00"},{"$f":"$D33","v":"01:00:00"},{"$f":"L33+P33+Q33","v":"10:00:00"},{"$f":"C33","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U33-T33-V33,1)","v":"08:00:00"},{"$f":"$D33","v":"01:00:00"},{"$f":"S33+W33+X33","v":"10:00:00"},{"$f":"C33","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB33-AA33-AC33,1)","v":"08:00:00"},{"$f":"$D33","v":"01:00:00"},{"$f":"Z33+AD33+AE33","v":"10:00:00"},{"$f":"$C33","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI33-AH33-AJ33,1)","v":"08:00:00"},{"$f":"$D33","v":"01:00:00"},{"$f":"AG33+AK33+AL33","v":"10:00:00"},{"$f":"AM33+AF33+Y33+R33+K33","v":2.083333333333333}]
["INTITULÉ DU POSTE"]
["RÉEL",9,"01:00:00","01:00:00",{"$f":"$C35","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G35-F35-H35,1)","v":"00:00:00"},{"$f":"$D35","v":"01:00:00"},{"$f":"E35+I35+J35","v":"02:00:00"},{"$f":"$C35","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N35-M35-O35,1)","v":"00:00:00"},{"$f":"$D35","v":"01:00:00"},{"$f":"L35+P35+Q35","v":"02:00:00"},{"$f":"$C35","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U35-T35-V35,1)","v":"00:00:00"},{"$f":"$D35","v":"01:00:00"},{"$f":"S35+W35+X35","v":"02:00:00"},{"$f":"$C35","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB35-AA35-AC35,1)","v":"00:00:00"},{"$f":"$D35","v":"01:00:00"},{"$f":"Z35+AD35+AE35","v":"02:00:00"},{"$f":"$C35","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI35-AH35-AJ35,1)","v":"00:00:00"},{"$f":"$D35","v":"01:00:00"},{"$f":"AG35+AK35+AL35","v":"02:00:00"},{"$f":"AM35+AF35+Y35+R35+K35","v":0.41666666666666696}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C36","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G36-F36-H36,1)","v":"08:00:00"},{"$f":"$D36","v":"01:00:00"},{"$f":"E36+I36+J36","v":"10:00:00"},{"$f":"$C36","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N36-M36-O36,1)","v":"08:00:00"},{"$f":"$D36","v":"01:00:00"},{"$f":"L36+P36+Q36","v":"10:00:00"},{"$f":"C36","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U36-T36-V36,1)","v":"08:00:00"},{"$f":"$D36","v":"01:00:00"},{"$f":"S36+W36+X36","v":"10:00:00"},{"$f":"C36","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB36-AA36-AC36,1)","v":"08:00:00"},{"$f":"$D36","v":"01:00:00"},{"$f":"Z36+AD36+AE36","v":"10:00:00"},{"$f":"$C36","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI36-AH36-AJ36,1)","v":"08:00:00"},{"$f":"$D36","v":"01:00:00"},{"$f":"AG36+AK36+AL36","v":"10:00:00"},{"$f":"AM36+AF36+Y36+R36+K36","v":2.083333333333333}]
["INTITULÉ DU POSTE"]
["RÉEL",10,"01:00:00","01:00:00",{"$f":"$C38","v":"01:00:00"},{"$f":"F$3","v":"00:00:00"},{"$f":"G$3","v":"00:00:00"},{"$f":"$H$3","v":"00:00:00"},{"$f":"MOD(G38-F38-H38,1)","v":"00:00:00"},{"$f":"$D38","v":"01:00:00"},{"$f":"E38+I38+J38","v":"02:00:00"},{"$f":"$C38","v":"01:00:00"},{"$f":"M$3","v":"00:00:00"},{"$f":"N$3","v":"00:00:00"},{"$f":"$O$3","v":"00:00:00"},{"$f":"MOD(N38-M38-O38,1)","v":"00:00:00"},{"$f":"$D38","v":"01:00:00"},{"$f":"L38+P38+Q38","v":"02:00:00"},{"$f":"$C38","v":"01:00:00"},{"$f":"T$3","v":"00:00:00"},{"$f":"U$3","v":"00:00:00"},{"$f":"$V$3","v":"00:00:00"},{"$f":"MOD(U38-T38-V38,1)","v":"00:00:00"},{"$f":"$D38","v":"01:00:00"},{"$f":"S38+W38+X38","v":"02:00:00"},{"$f":"$C38","v":"01:00:00"},{"$f":"AA$3","v":"00:00:00"},{"$f":"AB$3","v":"00:00:00"},{"$f":"$AC$3","v":"00:00:00"},{"$f":"MOD(AB38-AA38-AC38,1)","v":"00:00:00"},{"$f":"$D38","v":"01:00:00"},{"$f":"Z38+AD38+AE38","v":"02:00:00"},{"$f":"$C38","v":"01:00:00"},{"$f":"AH$3","v":"00:00:00"},{"$f":"AI$3","v":"00:00:00"},{"$f":"$AJ$3","v":"00:00:00"},{"$f":"MOD(AI38-AH38-AJ38,1)","v":"00:00:00"},{"$f":"$D38","v":"01:00:00"},{"$f":"AG38+AK38+AL38","v":"02:00:00"},{"$f":"AM38+AF38+Y38+R38+K38","v":0.41666666666666685}]
["MODIFIÉ",null,"01:00:00","01:00:00",{"$f":"$C39","v":"01:00:00"},{"$f":"F$4","v":"10:00:00"},{"$f":"$G$4","v":"19:00:00"},{"$f":"$H$4","v":"01:00:00"},{"$f":"MOD(G39-F39-H39,1)","v":"08:00:00"},{"$f":"$D39","v":"01:00:00"},{"$f":"E39+I39+J39","v":"10:00:00"},{"$f":"$C39","v":"01:00:00"},{"$f":"M$4","v":"10:00:00"},{"$f":"N$4","v":"19:00:00"},{"$f":"$O$4","v":"01:00:00"},{"$f":"MOD(N39-M39-O39,1)","v":"08:00:00"},{"$f":"$D39","v":"01:00:00"},{"$f":"L39+P39+Q39","v":"10:00:00"},{"$f":"C39","v":"01:00:00"},{"$f":"T$4","v":"10:00:00"},{"$f":"U$4","v":"19:00:00"},{"$f":"$V$4","v":"01:00:00"},{"$f":"MOD(U39-T39-V39,1)","v":"08:00:00"},{"$f":"$D39","v":"01:00:00"},{"$f":"S39+W39+X39","v":"10:00:00"},{"$f":"C39","v":"01:00:00"},{"$f":"AA$4","v":"10:00:00"},{"$f":"AB$4","v":"19:00:00"},{"$f":"$AC$4","v":"01:00:00"},{"$f":"MOD(AB39-AA39-AC39,1)","v":"08:00:00"},{"$f":"$D39","v":"01:00:00"},{"$f":"Z39+AD39+AE39","v":"10:00:00"},{"$f":"$C39","v":"01:00:00"},{"$f":"AH$4","v":"10:00:00"},{"$f":"AI$4","v":"19:00:00"},{"$f":"$AJ$4","v":"01:00:00"},{"$f":"MOD(AI39-AH39-AJ39,1)","v":"08:00:00"},{"$f":"$D39","v":"01:00:00"},{"$f":"AG39+AK39+AL39","v":"10:00:00"},{"$f":"AM39+AF39+Y39+R39+K39","v":2.083333333333333}]

{"sheet":"Modèle","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,4,28,8],[29,4,34,8],[10,0,10,8],[1,0,1,1],[18,3,18,6],[18,8,19,8],[18,7,19,7],[18,1,19,1],[14,0,14,8],[4,0,4,1],[18,2,19,2],[27,0,28,3],[29,0,34,3]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,2,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":14}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"09:30:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F22-D22-E22,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"09:30:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":1.9791666666666663}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"1","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,1,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":11}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"09:30:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"09:30:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":1.9791666666666663}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"2","index":3,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,2,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":14}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"09:30:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"09:30:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":1.9791666666666663}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"3","index":4,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,3,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":17}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"00:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"08:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"00:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"08:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"00:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:00:00","08:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"00:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:00:00","08:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"00:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:00:00","08:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":1.6666666666666663}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"4","index":5,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,4,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":20}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"09:30:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"00:30:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"09:30:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","00:30:00","09:30:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":1.9791666666666663}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"5","index":6,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,5,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":23}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"6","index":7,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,6,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":26}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"7","index":8,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,7,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":29}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"8","index":9,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,8,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":32}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"9","index":10,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,9,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":35}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]

{"sheet":"10","index":11,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,28,3],[27,4,28,8],[29,0,34,3],[29,4,34,8],[1,0,1,1],[4,0,4,1],[10,0,10,8],[14,0,14,8],[18,1,19,1],[18,2,19,2],[18,3,18,6],[18,7,19,7],[18,8,19,8]]}
[]
["PRODUCTION : ",null,{"$f":"SEM!A1","v":"XXXX"}]
[]
["FILM :",null,{"$f":"SEM!A2","v":"XXX"}]
[]
["NOM :",null,10,null,null,"LIGNE",{"$f":"9+(MATCH(C6,SEM!B10:B39,0))","v":38}]
["EMPLOI :",null,{"$f":"INDIRECT(\"SEM!A\" & (G6-1))","v":"INTITULÉ DU POSTE"}]
[]
[]
[]
[{"$f":"SEM!E6","v":"SEMAINE 1"}]
[]
[]
[]
[{"$f":"SEM!A6","v":"SEMAINE DU 01/01/2000 AU 05/01/2000"}]
[]
[]
[]
[null,"Horaires de tournage","Heures de préparation","Horaires effectifs de tournage",null,null,null,"Heures de rangement ","Total heures effectuées"]
[null,null,null,"Début","Repas","Fin","Temps de tournage"]
[{"$f":"SEM!E7","v":"Lundi 01/01"},{"$f":"IF($H21+$G21+$C21>0,SEM!J3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+6,,,\"SEM\"))","v":"10:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},{"$f":"MOD(F21-D21-E21,1)","v":"08:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H21+$G21+$C21>0,$H21+$G21+$C21,\"\")","v":"10:00:00"}]
[{"$f":"SEM!L7","v":"Mardi 02/01"},{"$f":"IF($H22+$G22+$C22>0,SEM!Q3,\"\")","v":"10h00 - 19h00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+5,,,\"SEM\"))","v":"01:00:00"},"10:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+8,,,\"SEM\"))","v":"01:00:00"},{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+7,,,\"SEM\"))","v":"19:00:00"},"08:00:00",{"$f":"INDIRECT(ADDRESS($G$6+1,7*(ROW()-21)+10,,,\"SEM\"))","v":"01:00:00"},{"$f":"IF($H22+$G22+$C22>0,$H22+$G22+$C22,\"\")","v":"10:00:00"}]
[{"$f":"SEM!S7","v":"Mercredi 03/01"},{"$f":"IF($H23+$G23+$C23>0,SEM!X3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!Z7","v":"Jeudi 04/01"},{"$f":"IF($H24+$G24+$C24>0,SEM!AE3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[{"$f":"SEM!AG7","v":"Vendredi 05/01"},{"$f":"IF($H25+$G25+$C25>0,SEM!AL3,\"\")","v":"10h00 - 19h00"},"01:00:00","10:00:00","01:00:00","19:00:00","08:00:00","01:00:00","10:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I25)","v":2.083333333333333}]
[]
["Signature",null,null,null,"Signature"]