{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["A LIRE","Récapitulatif","Juin 2010","Juillet 2010","Août 2010","Septembre 2010","Octobre 2010","Novembre 2010","Décembre 2010"],"not_rendered":{"defined_names":22,"comments":7},"read":"whole","date_system":"1904"}

{"sheet":"A LIRE","index":0,"n_rows":13,"n_cols":1,"rows_kept":13}
["Ces feuilles calculent les heures supplémentaires hebdomadaire. "]
[]
["Inscrivez votre total d'heure journalier (format 00:00) :"]
[]
["Inscrivez votre taux horaire brut majoré de 25% (format 0,00€)  :"]
[]
["Inscrivez votre taux horaire brut majoré de 50%: "]
[]
["Inscrivez votre solde d'heures supplémentaires :"]
[]
["si vous n'avez pas d'heures sup, écrire : 00:00"]
[]
["Si vous êtes en négatif pour les heures sup, écrire     =-\"00:00\""]

{"sheet":"Récapitulatif","index":1,"n_rows":34,"n_cols":11,"rows_kept":34}
["RECAPITULATIF",null,{"$f":"'A LIRE'!G9","v":0}]
["Juin",{"$nulls":6},0.25,0.4166666666666667,0.5416666666666666,0.625]
[{"v":0.25,"d":"25%"},{"$f":"'Juin 2010'!P31","v":0},{"$f":"'Juin 2010'!L31","v":0},null,{"$f":"C1+B3+B4+C3","v":0},null,null,0.2604166666666667,0.4270833333333333,0.5520833333333334,0.6354166666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Juin 2010'!Q31","v":0},{"$nulls":5},0.270833333333333,0.4375,0.5625,0.645833333333333]
["Juillet",{"$nulls":6},0.28125,0.447916666666667,0.572916666666667,0.65625]
[{"v":0.25,"d":"25%"},{"$f":"'Juillet 2010'!P30","v":0},{"$f":"JUILLET","v":0},null,{"$f":"E3+B6+B7+C6","v":0},null,null,0.291666666666667,0.458333333333333,0.583333333333334,0.666666666666667]
[{"v":0.5,"d":"50%"},{"$f":"'Juillet 2010'!Q30","v":0},{"$nulls":5},0.302083333333333,0.46875,0.59375,0.677083333333333]
["Aôut",{"$nulls":6},0.3125,0.479166666666666,0.604166666666667,0.6875]
[{"v":0.25,"d":"25%"},{"$f":"'Août 2010'!P31","v":0},{"$f":"'Août 2010'!L31","v":0},null,{"$f":"E6+B9+B10+C9","v":0},null,null,0.322916666666667,0.489583333333333,0.614583333333334,0.697916666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Août 2010'!Q31","v":0},{"$nulls":5},0.333333333333333,0.5,0.625000000000001,0.708333333333333]
["Septembre",{"$nulls":6},0.34375,0.510416666666666,null,0.71875]
[{"v":0.25,"d":"25%"},{"$f":"'Septembre 2010'!P30","v":0},{"$f":"'Septembre 2010'!L30","v":0},null,{"$f":"E9+B12+B13+C12","v":0},null,null,0.354166666666667,0.520833333333333,null,0.729166666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Septembre 2010'!Q30","v":0},{"$nulls":5},0.364583333333334,0.53125,null,0.739583333333333]
["Octobre",{"$nulls":6},0.375,0.541666666666667,null,0.75]
[{"v":0.25,"d":"25%"},{"$f":"'Octobre 2010'!P29","v":0},{"$f":"'Octobre 2010'!L29","v":0},null,{"$f":"E12+B15+B16+C15","v":0},null,null,0.385416666666667,0.552083333333333,null,0.760416666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Octobre 2010'!Q29","v":0},{"$nulls":5},0.395833333333334,0.5625,null,0.770833333333333]
["Novembre",{"$nulls":6},0.40625,0.572916666666666,null,0.781249999999999]
[{"v":0.25,"d":"25%"},{"$f":"'Novembre 2010'!P31","v":0},{"$f":"'Novembre 2010'!L31","v":0},null,{"$f":"E15+B18+B19+C18","v":0},null,null,0.416666666666667,0.583333333333333,null,0.791666666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Novembre 2010'!Q31","v":0},{"$nulls":8},0.802083333333333]
["Decembre",{"$nulls":9},0.812499999999999]
[{"v":0.25,"d":"25%"},{"$f":"'Décembre 2010'!P31","v":0},{"$f":"'Décembre 2010'!L31","v":0},null,{"$f":"E18+B21+B22+C21","v":0},{"$nulls":5},0.822916666666666]
[{"v":0.5,"d":"50%"},{"$f":"'Décembre 2010'!Q31","v":0},{"$nulls":8},0.833333333333333]
[{"$nulls":10},0.843749999999999]
[{"$nulls":10},0.854166666666666]
[{"$nulls":10},0.864583333333332]
[{"$nulls":10},0.874999999999999]
[{"$nulls":10},0.885416666666666]
[{"$nulls":10},0.895833333333332]
[{"$nulls":10},0.906249999999999]
[{"$nulls":10},0.916666666666666]
[{"$nulls":10},0.927083333333332]
[{"$nulls":10},0.937499999999999]
[{"$nulls":10},0.947916666666666]
[{"$nulls":10},0.958333333333332]

{"sheet":"Juin 2010","index":2,"n_rows":31,"n_cols":18,"rows_kept":31}
["2010-06-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo",null,null,"Total",null,null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
[]
["Mardi",1,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},null,{"$f":"I5-I2","v":0}]
["Mercredi",2,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},null,{"$f":"I6-I2","v":0}]
["Jeudi",3,null,null,{"$f":"D7-C7","v":"00:00:00"},null,null,{"$f":"G7-F7","v":"00:00:00"},{"$f":"SUM(H7,E7)","v":"00:00:00"},null,{"$f":"I7-I2","v":0}]
["Vendredi",4,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},{"$f":"I8+I7+I6+I5","v":0},{"$f":"I8-I2","v":0},{"$f":"K8+K7+K6+K5","v":0},{"$f":"IF(L8<K2,\"0,00\",IF(L8<L2,L8*M3*24,IF(L8>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L8>L2,(L8-L2)*N3*24,IF(L8<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M8+N8","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L8<K2,\"00\",IF(L8<L2,L8*P2*24,IF(L8>L2,L2*P2*24)))","v":0},{"$f":"IF(L8>L2,(L8-L2)*Q2*24,IF(L8<L2,0))","v":0},{"$f":"P8+Q8","v":0}]
[]
["Lundi",7,null,null,{"$f":"D10-C10","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"},{"$f":"SUM(H10,E10)","v":"00:00:00"},null,{"$f":"I10-I2","v":0}]
["Mardi",8,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},null,{"$f":"I11-I2","v":0}]
["Mercredi",9,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},null,{"$f":"I12-I2","v":0}]
["Jeudi",10,null,null,{"$f":"D13-C13","v":"00:00:00"},null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"SUM(H13,E13)","v":"00:00:00"},null,{"$f":"I13-I2","v":0}]
["Vendredi",11,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},{"$f":"I14+I13+I12+I11+I10","v":0},{"$f":"I14-I2","v":0},{"$f":"K14+K13+K12+K11+K10","v":0},{"$f":"IF(L14<K2,\"0,00\",IF(L14<L2,L14*M3*24,IF(L14>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L14>L2,(L14-L2)*N3*24,IF(L14<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M14+N14","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L14<K2,\"00\",IF(L14<L2,L14*P2*24,IF(L14>L2,L2*P2*24)))","v":0},{"$f":"IF(L14>L2,(L14-L2)*Q2*24,IF(L14<L2,0))","v":0},{"$f":"P14+Q14*24","v":0}]
[]
["Lundi",14,null,null,{"$f":"D16-C16","v":"00:00:00"},null,null,{"$f":"G16-F16","v":"00:00:00"},{"$f":"SUM(H16,E16)","v":"00:00:00"},null,{"$f":"I16-I2","v":0}]
["Mardi",15,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},null,{"$f":"I17-I2","v":0}]
["Mercredi",16,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},null,{"$f":"I18-I2","v":0}]
["Jeudi",17,null,null,{"$f":"D19-C19","v":"00:00:00"},null,null,{"$f":"G19-F19","v":"00:00:00"},{"$f":"SUM(H19,E19)","v":"00:00:00"},null,{"$f":"I19-I2","v":0}]
["Vendredi",18,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},{"$f":"I20+I19+I18+I17+I16","v":0},{"$f":"I20-I2","v":0},{"$f":"K16+K17+K18+K19+K20","v":0},{"$f":"IF(L20<K2,\"0,00\",IF(L20<L2,L20*M3*24,IF(L20>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L20>L2,(L20-L2)*N3*24,IF(L20<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M20+N20","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L20<K2,\"00\",IF(L20<L2,L20*P2*24,IF(L20>L2,L2*P2*24)))","v":0},{"$f":"IF(L20>L2,(L20-L2)*Q2*24,IF(L20<L2,0))","v":0},{"$f":"P20+Q20","v":0}]
[]
["Lundi",21,null,null,{"$f":"D22-C22","v":"00:00:00"},null,null,{"$f":"G22-F22","v":"00:00:00"},{"$f":"SUM(H22,E22)","v":"00:00:00"},null,{"$f":"I22-I2","v":0}]
["Mardi",22,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},null,{"$f":"I23-I2","v":0}]
["Mercredi",23,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},null,{"$f":"I24-I2","v":0}]
["Jeudi",24,null,null,{"$f":"D25-C25","v":0},null,null,{"$f":"G25-F25","v":0},{"$f":"SUM(H25,E25)","v":0},null,{"$f":"I25-I2","v":0}]
["Vendredi",25,null,null,{"$f":"D26-C26","v":0},null,null,{"$f":"G26-F26","v":0},{"$f":"E26+H26","v":0},{"$f":"I26+I25+I24+I23+I22","v":0},{"$f":"I26-I2","v":0},{"$f":"K26+K25+K24+K23+K22","v":0},{"$f":"IF(L26<K2,\"0,00\",IF(L26<L2,L26*M3*24,IF(L26>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L26>L2,(L26-L2)*N3*24,IF(L26<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M26+N26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L26<K2,\"00\",IF(L26<L2,L26*P2*24,IF(L26>L2,L2*P2*24)))","v":0},{"$f":"IF(L26>L2,(L26-L2)*Q2*24,IF(L26<L2,0))","v":0},{"$f":"P26+Q26","v":0}]
[]
["Lundi",28,null,null,{"$f":"D28-C28","v":0},null,null,{"$f":"G28-F28","v":0},{"$f":"H28+E28","v":0},null,{"$f":"I28-I2","v":0}]
["Mardi",29,null,null,{"$f":"D29-C29","v":0},null,null,{"$f":"G29-F29","v":0},{"$f":"H29+E29","v":0},null,{"$f":"I29-I2","v":0}]
["Mercredi",30,null,null,0,null,null,0,0,{"$f":"I28+I29+I30","v":0},{"$f":"I30-I2","v":0},{"$f":"K28+K29+K30","v":0},{"$f":"IF(L30<K2,\"0,00\",IF(L30<L2,L30*M3*24,IF(L30>L2,L2*M6*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30>L2,(L30-L2)*N3*24,IF(L30<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M30+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30<K2,\"00\",IF(L30<L2,L30*P2*24,IF(L30>L2,L2*P2*24)))","v":0},{"$f":"IF(L30>L2,(L30-L2)*Q2*24,IF(L30<L2,0))","v":0},{"$f":"P30+Q30","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L8:L30,\"<00:00\")","v":0},{"$f":"M26+M20+M14+M8","v":{"v":0,"d":"0.00 €"}},{"$f":"N26+N20+N14+N8","v":{"v":0,"d":"0.00 €"}},{"$f":"O26+O20+O14+O8","v":{"v":0,"d":"0.00 €"}},{"$f":"P8+P14+P20+P26","v":0},{"$f":"Q8+Q14+Q20+Q26","v":0},{"$f":"R26+R20+R14+R8","v":0}]

{"sheet":"Juillet 2010","index":3,"n_rows":30,"n_cols":18,"rows_kept":30}
["2010-07-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo",null,null,"Total",null,null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
["Jeudi",1,null,null,{"$f":"D4-C4","v":"00:00:00"},null,null,{"$f":"G4-F4","v":"00:00:00"},{"$f":"SUM(H4,E4)","v":"00:00:00"},null,{"$f":"I4-I2","v":0}]
["Vendredi",2,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},{"$f":"I5+I4","v":0},{"$f":"I5-I2","v":0},{"$f":"K5+K4","v":0},{"$f":"IF(L5<K2,\"0,00\",IF(L5<L2,L5*M3*24,IF(L5>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L5>L2,(L5-L2)*N3*24,IF(L5<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M5+N5","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L5<K2,\"00\",IF(L5<L2,L5*P2*24,IF(L5>L2,L2*P2*24)))","v":0},{"$f":"IF(L5>L2,(L5-L2)*Q2*24,IF(L5<L2,0))","v":0},{"$f":"P5+Q5","v":0}]
[]
["Lundi",5,null,null,{"$f":"D7-C7","v":"00:00:00"},null,null,{"$f":"G7-F7","v":"00:00:00"},{"$f":"SUM(H7,E7)","v":"00:00:00"},null,{"$f":"I7-I2","v":0}]
["Mardi",6,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Mercredi",7,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},null,{"$f":"I9-I2","v":0}]
["Jeudi",8,null,null,{"$f":"D10-C10","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"},{"$f":"SUM(H10,E10)","v":"00:00:00"},null,{"$f":"I10-I2","v":0}]
["Vendredi",9,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},{"$f":"I11+I10+I9+I8+I7","v":0},{"$f":"I11-I2","v":0},{"$f":"K11+K10+K9+K8+K7","v":0},{"$f":"IF(L11<K2,\"0,00\",IF(L11<L2,L11*M3*24,IF(L11>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L11>L2,(L11-L2)*N3*24,IF(L11<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M11+N11","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L11<K2,\"00\",IF(L11<L2,L11*P2*24,IF(L11>L2,L2*P2*24)))","v":0},{"$f":"IF(L11>L2,(L11-L2)*Q2*24,IF(L11<L2,0))","v":0},{"$f":"P11+Q11","v":0}]
[]
["Lundi",12,null,null,{"$f":"D13-C13","v":"00:00:00"},null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"SUM(H13,E13)","v":"00:00:00"},null,{"$f":"I13-I2","v":0}]
["Mardi",13,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Mercredi",14,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},null,{"$f":"I15-I2","v":0}]
["Jeudi",15,null,null,{"$f":"D16-C16","v":"00:00:00"},null,null,{"$f":"G16-F16","v":"00:00:00"},{"$f":"SUM(H16,E16)","v":"00:00:00"},null,{"$f":"I16-I2","v":0}]
["Vendredi",16,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},{"$f":"I17+I16+I15+I14+I13","v":0},{"$f":"I17-I2","v":0},{"$f":"K17+K16+K15+K14+K13","v":0},{"$f":"IF(L17<K2,\"0,00\",IF(L17<L2,L17*M3*24,IF(L17>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L17>L2,(L17-L2)*N3*24,IF(L17<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M17+N17","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L17<K2,\"00\",IF(L17<L2,L17*P2*24,IF(L17>L2,L2*P2*24)))","v":0},{"$f":"IF(L17>L2,(L17-L2)*Q2*24,IF(L17<L2,0))","v":0},{"$f":"P17+Q17*24","v":0}]
[]
["Lundi",19,null,null,{"$f":"D19-C19","v":"00:00:00"},null,null,{"$f":"G19-F19","v":"00:00:00"},{"$f":"SUM(H19,E19)","v":"00:00:00"},null,{"$f":"I19-I2","v":0}]
["Mardi",20,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Mercredi",21,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},null,{"$f":"I21-I2","v":0}]
["Jeudi",22,null,null,{"$f":"D22-C22","v":"00:00:00"},null,null,{"$f":"G22-F22","v":"00:00:00"},{"$f":"SUM(H22,E22)","v":"00:00:00"},null,{"$f":"I22-I2","v":0}]
["Vendredi",23,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},{"$f":"I23+I22+I21+I20+I19","v":0},{"$f":"I23-I2","v":0},{"$f":"K19+K20+K21+K22+K23","v":0},{"$f":"IF(L23<K2,\"0,00\",IF(L23<L2,L23*M3*24,IF(L23>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L23>L2,(L23-L2)*N3*24,IF(L23<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M23+N23","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L23<K2,\"00\",IF(L23<L2,L23*P2*24,IF(L23>L2,L2*P2*24)))","v":0},{"$f":"IF(L23>L2,(L23-L2)*Q2*24,IF(L23<L2,0))","v":0},{"$f":"P23+Q23","v":0}]
[]
["Lundi",26,null,null,{"$f":"D25-C25","v":"00:00:00"},null,null,{"$f":"G25-F25","v":"00:00:00"},{"$f":"SUM(H25,E25)","v":"00:00:00"},null,{"$f":"I25-I2","v":0}]
["Mardi",27,null,null,{"$f":"D26-C26","v":"00:00:00"},null,null,{"$f":"G26-F26","v":"00:00:00"},{"$f":"SUM(H26,E26)","v":"00:00:00"},null,{"$f":"I26-I2","v":0}]
["Mercredi",28,null,null,{"$f":"D27-C27","v":"00:00:00"},null,null,{"$f":"G27-F27","v":"00:00:00"},{"$f":"SUM(H27,E27)","v":"00:00:00"},null,{"$f":"I27-I2","v":0}]
["Jeudi",29,null,null,{"$f":"D28-C28","v":0},null,null,{"$f":"G28-F28","v":0},{"$f":"SUM(H28,E28)","v":0},null,{"$f":"I28-I2","v":0}]
["Vendredi",30,null,null,{"$f":"D29-C29","v":0},null,null,{"$f":"G29-F29","v":0},{"$f":"E29+H29","v":0},{"$f":"I29+I28+I27+I26+I25","v":0},{"$f":"I29-I2","v":0},{"$f":"K29+K28+K27+K26+K25","v":0},{"$f":"IF(L29<K2,\"0,00\",IF(L29<L2,L29*M3*24,IF(L29>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L29>L2,(L29-L2)*N3*24,IF(L29<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M29+N29","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L29<K2,\"00\",IF(L29<L2,L29*P2*24,IF(L29>L2,L2*P2*24)))","v":0},{"$f":"IF(L29>L2,(L29-L2)*Q2*24,IF(L29<L2,0))","v":0},{"$f":"P29+Q29","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L5:L29,\"<00:00\")","v":0},{"$f":"M29+M23+M17+M11+M5","v":{"v":0,"d":"0.00 €"}},{"$f":"N29+N23+N17+N11+N5","v":{"v":0,"d":"0.00 €"}},{"$f":"O29+O23+O17+O11+O5","v":{"v":0,"d":"0.00 €"}},{"$f":"P5+P11+P17+P23+P29","v":0},{"$f":"Q5+Q11+Q17+Q23+Q29","v":0},{"$f":"R29+R23+R17+R11+R5","v":0}]

{"sheet":"Août 2010","index":4,"n_rows":31,"n_cols":18,"rows_kept":31}
["2010-08-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo","Heures majorées 25%/50%",null,"Total","Heures récupérées25/50%",null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
[]
["Lundi",2,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},null,{"$f":"I5-I2","v":0}]
["Mardi",3,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},null,{"$f":"I6-I2","v":0}]
["Mercredi",4,null,null,{"$f":"D7-C7","v":"00:00:00"},null,null,{"$f":"G7-F7","v":"00:00:00"},{"$f":"SUM(H7,E7)","v":"00:00:00"},null,{"$f":"I7-I2","v":0}]
["Jeudi",5,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Vendredi",6,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},{"$f":"I9+I8+I7+I6+I5","v":0},{"$f":"I9-I2","v":0},{"$f":"K9+K8+K7+K6+K5","v":0},{"$f":"IF(L9<K2,\"0,00\",IF(L9<L2,L9*M3*24,IF(L9>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L9>L2,(L9-L2)*N3*24,IF(L9<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M9+N9","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L9<K2,\"00\",IF(L9<L2,L9*P2*24,IF(L9>L2,L2*P2*24)))","v":0},{"$f":"IF(L9>L2,(L9-L2)*Q2*24,IF(L9<L2,0))","v":0},{"$f":"P9+Q9","v":0}]
[]
["Lundi",9,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},null,{"$f":"I11-I2","v":0}]
["Mardi",10,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},null,{"$f":"I12-I2","v":0}]
["Mercredi",11,null,null,{"$f":"D13-C13","v":"00:00:00"},null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"SUM(H13,E13)","v":"00:00:00"},null,{"$f":"I13-I2","v":0}]
["Jeudi",12,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Vendredi",13,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},{"$f":"I15+I14+I13+I12+I11","v":0},{"$f":"I15-I2","v":0},{"$f":"K15+K14+K13+K12+K11","v":0},{"$f":"IF(L15<K2,\"0,00\",IF(L15<L2,L15*M3*24,IF(L15>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L15>L2,(L15-L2)*N3*24,IF(L15<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M15+N15","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L15<K2,\"00\",IF(L15<L2,L15*P2*24,IF(L15>L2,L2*P2*24)))","v":0},{"$f":"IF(L15>L2,(L15-L2)*Q2*24,IF(L15<L2,0))","v":0},{"$f":"P15+Q15*24","v":0}]
[]
["Lundi",16,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},null,{"$f":"I17-I2","v":0}]
["Mardi",17,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},null,{"$f":"I18-I2","v":0}]
["Mercredi",18,null,null,{"$f":"D19-C19","v":"00:00:00"},null,null,{"$f":"G19-F19","v":"00:00:00"},{"$f":"SUM(H19,E19)","v":"00:00:00"},null,{"$f":"I19-I2","v":0}]
["Jeudi",19,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Vendredi",20,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},{"$f":"I21+I20+I19+I18+I17","v":0},{"$f":"I21-I2","v":0},{"$f":"K17+K18+K19+K20+K21","v":0},{"$f":"IF(L21<K2,\"0,00\",IF(L21<L2,L21*M3*24,IF(L21>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L21>L2,(L21-L2)*N3*24,IF(L21<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M21+N21","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L21<K2,\"00\",IF(L21<L2,L21*P2*24,IF(L21>L2,L2*P2*24)))","v":0},{"$f":"IF(L21>L2,(L21-L2)*Q2*24,IF(L21<L2,0))","v":0},{"$f":"P21+Q21","v":0}]
[]
["Lundi",23,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},null,{"$f":"I23-I2","v":0}]
["Mardi",24,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},null,{"$f":"I24-I2","v":0}]
["Mercredi",25,null,null,{"$f":"D25-C25","v":"00:00:00"},null,null,{"$f":"G25-F25","v":"00:00:00"},{"$f":"SUM(H25,E25)","v":"00:00:00"},null,{"$f":"I25-I2","v":0}]
["Jeudi",26,null,null,{"$f":"D26-C26","v":0},null,null,{"$f":"G26-F26","v":0},{"$f":"SUM(H26,E26)","v":0},null,{"$f":"I26-I2","v":0}]
["Vendredi",27,null,null,{"$f":"D27-C27","v":0},null,null,{"$f":"G27-F27","v":0},{"$f":"E27+H27","v":0},{"$f":"I27+I26+I25+I24+I23","v":0},{"$f":"I27-I2","v":0},{"$f":"K27+K26+K25+K24+K23","v":0},{"$f":"IF(L27<K2,\"0,00\",IF(L27<L2,L27*M3*24,IF(L27>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L27>L2,(L27-L2)*N3*24,IF(L27<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M27+N27","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L27<K2,\"00\",IF(L27<L2,L27*P2*24,IF(L27>L2,L2*P2*24)))","v":0},{"$f":"IF(L27>L2,(L27-L2)*Q2*24,IF(L27<L2,0))","v":0},{"$f":"P27+Q27","v":0}]
[]
["Lundi",30,null,null,{"$f":"D29-C29","v":"00:00:00"},null,null,{"$f":"G29-F29","v":"00:00:00"},{"$f":"SUM(H29,E29)","v":"00:00:00"},null,{"$f":"I29-I2","v":0}]
["Mardi",31,null,null,{"$f":"D30-C30","v":"00:00:00"},null,null,{"$f":"G30-F30","v":"00:00:00"},{"$f":"SUM(H30,E30)","v":"00:00:00"},{"$f":"I30+I29","v":0},{"$f":"I30-I2","v":0},{"$f":"K30+K29","v":0},{"$f":"IF(L30<K2,\"0,00\",IF(L30<L2,L30*M3*24,IF(L30>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30>L2,(L30-L2)*N3*24,IF(L30<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M30+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30<K2,\"00\",IF(L30<L2,L30*P2*24,IF(L30>L2,L2*P2*24)))","v":0},{"$f":"IF(L30>L2,(L30-L2)*Q2*24,IF(L30<L2,0))","v":0},{"$f":"P30+Q30","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L6:L30,\"<00:00\")","v":0},{"$f":"M27+M21+M15+M9+M30","v":{"v":0,"d":"0.00 €"}},{"$f":"N27+N21+N15+N9+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"O27+O21+O15+O9+O30","v":{"v":0,"d":"0.00 €"}},{"$f":"P30+P9+P15+P21+P27","v":0},{"$f":"Q30+Q9+Q15+Q21+Q27","v":0},{"$f":"R27+R21+R15+R9+R30","v":0}]

{"sheet":"Septembre 2010","index":5,"n_rows":30,"n_cols":18,"rows_kept":30}
["2010-09-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo","Heures majorées 25%/50%",null,"Total","Heures récupérées25/50%",null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
["Mercredi",1,null,null,{"$f":"D4-C4","v":"00:00:00"},null,null,{"$f":"G4-F4","v":"00:00:00"},{"$f":"SUM(H4,E4)","v":"00:00:00"},null,{"$f":"I4-I2","v":0}]
["Jeudi",2,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},null,{"$f":"I5-I2","v":0}]
["Vendredi",3,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},{"$f":"I6+I4","v":0},{"$f":"I6-I2","v":0},{"$f":"K6+K4+K5","v":0},{"$f":"IF(L6<K2,\"0,00\",IF(L6<L2,L6*M3*24,IF(L6>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L6>L2,(L6-L2)*N3*24,IF(L6<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M6+N6","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L6<K2,\"00\",IF(L6<L2,L6*P2*24,IF(L6>L2,L2*P2*24)))","v":0},{"$f":"IF(L6>L2,(L6-L2)*Q2*24,IF(L6<L2,0))","v":0},{"$f":"P6+Q6","v":0}]
[]
["Lundi",6,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Mardi",7,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},null,{"$f":"I9-I2","v":0}]
["Mercredi",8,null,null,{"$f":"D10-C10","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"},{"$f":"SUM(H10,E10)","v":"00:00:00"},null,{"$f":"I10-I2","v":0}]
["Jeudi",9,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},null,{"$f":"I11-I2","v":0}]
["Vendredi",10,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},{"$f":"I12+I11+I10+I9+I8","v":0},{"$f":"I12-I2","v":0},{"$f":"K12+K11+K10+K9+K8","v":0},{"$f":"IF(L12<K2,\"0,00\",IF(L12<L2,L12*M3*24,IF(L12>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L12>L2,(L12-L2)*N3*24,IF(L12<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M12+N12","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L12<K2,\"00\",IF(L12<L2,L12*P2*24,IF(L12>L2,L2*P2*24)))","v":0},{"$f":"IF(L12>L2,(L12-L2)*Q2*24,IF(L12<L2,0))","v":0},{"$f":"P12+Q12","v":0}]
[]
["Lundi",13,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Mardi",14,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},null,{"$f":"I15-I2","v":0}]
["Mercredi",15,null,null,{"$f":"D16-C16","v":"00:00:00"},null,null,{"$f":"G16-F16","v":"00:00:00"},{"$f":"SUM(H16,E16)","v":"00:00:00"},null,{"$f":"I16-I2","v":0}]
["Jeudi",16,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},null,{"$f":"I17-I2","v":0}]
["Vendredi",17,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},{"$f":"I18+I17+I16+I15+I14","v":0},{"$f":"I18-I2","v":0},{"$f":"K18+K17+K16+K15+K14","v":0},{"$f":"IF(L18<K2,\"0,00\",IF(L18<L2,L18*M3*24,IF(L18>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L18>L2,(L18-L2)*N3*24,IF(L18<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M18+N18","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L18<K2,\"00\",IF(L18<L2,L18*P2*24,IF(L18>L2,L2*P2*24)))","v":0},{"$f":"IF(L18>L2,(L18-L2)*Q2*24,IF(L18<L2,0))","v":0},{"$f":"P18+Q18*24","v":0}]
[]
["Lundi",20,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Mardi",21,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},null,{"$f":"I21-I2","v":0}]
["Mercredi",22,null,null,{"$f":"D22-C22","v":"00:00:00"},null,null,{"$f":"G22-F22","v":"00:00:00"},{"$f":"SUM(H22,E22)","v":"00:00:00"},null,{"$f":"I22-I2","v":0}]
["Jeudi",23,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},null,{"$f":"I23-I2","v":0}]
["Vendredi",24,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},{"$f":"I24+I23+I22+I21+I20","v":0},{"$f":"I24-I2","v":0},{"$f":"K20+K21+K22+K23+K24","v":0},{"$f":"IF(L24<K2,\"0,00\",IF(L24<L2,L24*M3*24,IF(L24>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L24>L2,(L24-L2)*N3*24,IF(L24<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M24+N24","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L24<K2,\"00\",IF(L24<L2,L24*P2*24,IF(L24>L2,L2*P2*24)))","v":0},{"$f":"IF(L24>L2,(L24-L2)*Q2*24,IF(L24<L2,0))","v":0},{"$f":"P24+Q24","v":0}]
[]
["Lundi",27,null,null,{"$f":"D26-C26","v":"00:00:00"},null,null,{"$f":"G26-F26","v":"00:00:00"},{"$f":"SUM(H26,E26)","v":"00:00:00"},null,{"$f":"I26-I2","v":0}]
["Mardi",28,null,null,{"$f":"D27-C27","v":"00:00:00"},null,null,{"$f":"G27-F27","v":"00:00:00"},{"$f":"SUM(H27,E27)","v":"00:00:00"},null,{"$f":"I27-I2","v":0}]
["Mercredi",29,null,null,{"$f":"D28-C28","v":0},null,null,{"$f":"G28-F28","v":0},{"$f":"SUM(H28,E28)","v":0},null,{"$f":"I28-I2","v":0}]
["Jeudi",30,null,null,{"$f":"D29-C29","v":0},null,null,{"$f":"G29-F29","v":0},{"$f":"E29+H29","v":0},{"$f":"I29+I28+I27+I5+I26","v":0},{"$f":"I29-I2","v":0},{"$f":"K29+K28+K27+K26","v":0},{"$f":"IF(L29<K2,\"0,00\",IF(L29<L2,L29*M3*24,IF(L29>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L29>L2,(L29-L2)*N3*24,IF(L29<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M29+N29","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L29<K2,\"00\",IF(L29<L2,L29*P2*24,IF(L29>L2,L2*P2*24)))","v":0},{"$f":"IF(L29>L2,(L29-L2)*Q2*24,IF(L29<L2,0))","v":0},{"$f":"P29+Q29","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L6:L29,\"<00:00\")","v":0},{"$f":"M29+M24+M18+M12+M6","v":{"v":0,"d":"0.00 €"}},{"$f":"N29+N24+N18+N12+N6","v":{"v":0,"d":"0.00 €"}},{"$f":"O29+O24+O18+O12+O6","v":{"v":0,"d":"0.00 €"}},{"$f":"P6+P12+P18+P24+P29","v":0},{"$f":"Q6+Q12+Q18+Q24+Q29","v":0},{"$f":"R29+R24+R18+R12+R6","v":0}]

{"sheet":"Octobre 2010","index":6,"n_rows":29,"n_cols":18,"rows_kept":29}
["2010-10-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo","Heures majorées 25%/50%",null,"Total","Heures récupérées25/50%",null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
["Vendredi",1,null,null,{"$f":"D4-C4","v":"00:00:00"},null,null,{"$f":"G4-F4","v":"00:00:00"},{"$f":"SUM(H4,E4)","v":"00:00:00"},{"$f":"I4","v":0},{"$f":"I4-I2","v":0},{"$f":"K4","v":0},{"$f":"IF(L4<K2,\"0,00\",IF(L4<L2,L4*M3*24,IF(L4>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L4>L2,(L4-L2)*N3*24,IF(L4<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M4+N4","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L4<K2,\"00\",IF(L4<L2,L4*P2*24,IF(L4>L2,L2*P2*24)))","v":0},{"$f":"IF(L4>L2,(L4-L2)*Q2*24,IF(L4<L2,0))","v":0},{"$f":"P4+Q4","v":0}]
[]
["Lundi",4,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},null,{"$f":"I6-I2","v":0}]
["Mardi",5,null,null,{"$f":"D7-C7","v":"00:00:00"},null,null,{"$f":"G7-F7","v":"00:00:00"},{"$f":"SUM(H7,E7)","v":"00:00:00"},null,{"$f":"I7-I2","v":0}]
["Mercredi",6,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Jeudi",7,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},null,{"$f":"I9-I2","v":0}]
["Vendredi",8,null,null,{"$f":"D10-C10","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"},{"$f":"SUM(H10,E10)","v":"00:00:00"},{"$f":"I10+I9+I8+I7+I6","v":0},{"$f":"I10-I2","v":0},{"$f":"K10+K9+K8+K7+K6","v":0},{"$f":"IF(L10<K2,\"0,00\",IF(L10<L2,L10*M3*24,IF(L10>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L10>L2,(L10-L2)*N3*24,IF(L10<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M10+N10","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L10<K2,\"00\",IF(L10<L2,L10*P2*24,IF(L10>L2,L2*P2*24)))","v":0},{"$f":"IF(L10>L2,(L10-L2)*Q2*24,IF(L10<L2,0))","v":0},{"$f":"P10+Q10","v":0}]
[]
["Lundi",11,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},null,{"$f":"I12-I2","v":0}]
["Mardi",12,null,null,{"$f":"D13-C13","v":"00:00:00"},null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"SUM(H13,E13)","v":"00:00:00"},null,{"$f":"I13-I2","v":0}]
["Mercredi",13,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Jeudi",14,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},null,{"$f":"I15-I2","v":0}]
["Vendredi",15,null,null,{"$f":"D16-C16","v":"00:00:00"},null,null,{"$f":"G16-F16","v":"00:00:00"},{"$f":"SUM(H16,E16)","v":"00:00:00"},{"$f":"I16+I15+I14+I13+I12","v":0},{"$f":"I16-I2","v":0},{"$f":"K16+K15+K14+K13+K12","v":0},{"$f":"IF(L16<K2,\"0,00\",IF(L16<L2,L16*M3*24,IF(L16>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L16>L2,(L16-L2)*N3*24,IF(L16<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M16+N16","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L16<K2,\"00\",IF(L16<L2,L16*P2*24,IF(L16>L2,L2*P2*24)))","v":0},{"$f":"IF(L16>L2,(L16-L2)*Q2*24,IF(L16<L2,0))","v":0},{"$f":"P16+Q16*24","v":0}]
[]
["Lundi",18,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},null,{"$f":"I18-I2","v":0}]
["Mardi",19,null,null,{"$f":"D19-C19","v":"00:00:00"},null,null,{"$f":"G19-F19","v":"00:00:00"},{"$f":"SUM(H19,E19)","v":"00:00:00"},null,{"$f":"I19-I2","v":0}]
["Mercredi",20,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Jeudi",21,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},null,{"$f":"I21-I2","v":0}]
["Vendredi",22,null,null,{"$f":"D22-C22","v":"00:00:00"},null,null,{"$f":"G22-F22","v":"00:00:00"},{"$f":"SUM(H22,E22)","v":"00:00:00"},{"$f":"I22+I21+I20+I19+I18","v":0},{"$f":"I22-I2","v":0},{"$f":"K18+K19+K20+K21+K22","v":0},{"$f":"IF(L22<K2,\"0,00\",IF(L22<L2,L22*M3*24,IF(L22>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L22>L2,(L22-L2)*N3*24,IF(L22<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M22+N22","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L22<K2,\"00\",IF(L22<L2,L22*P2*24,IF(L22>L2,L2*P2*24)))","v":0},{"$f":"IF(L22>L2,(L22-L2)*Q2*24,IF(L22<L2,0))","v":0},{"$f":"P22+Q22","v":0}]
[]
["Lundi",25,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},null,{"$f":"I24-I2","v":0}]
["Mardi",26,null,null,{"$f":"D25-C25","v":"00:00:00"},null,null,{"$f":"G25-F25","v":"00:00:00"},{"$f":"SUM(H25,E25)","v":"00:00:00"},null,{"$f":"I25-I2","v":0}]
["Mercredi",27,null,null,{"$f":"D26-C26","v":"00:00:00"},null,null,{"$f":"G26-F26","v":"00:00:00"},{"$f":"SUM(H26,E26)","v":"00:00:00"},null,{"$f":"I26-I2","v":0}]
["Jeudi",28,null,null,{"$f":"D27-C27","v":0},null,null,{"$f":"G27-F27","v":0},{"$f":"SUM(H27,E27)","v":0},null,{"$f":"I27-I2","v":0}]
["Vendredi",29,null,null,{"$f":"D28-C28","v":0},null,null,{"$f":"G28-F28","v":0},{"$f":"E28+H28","v":0},{"$f":"I28+I27+I26+I25+I24","v":0},{"$f":"I28-I2","v":0},{"$f":"K28+K27+K26+K25+K24","v":0},{"$f":"IF(L28<K2,\"0,00\",IF(L28<L2,L28*M3*24,IF(L28>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L28>L2,(L28-L2)*N3*24,IF(L28<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M28+N28","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L28<K2,\"00\",IF(L28<L2,L28*P2*24,IF(L28>L2,L2*P2*24)))","v":0},{"$f":"IF(L28>L2,(L28-L2)*Q2*24,IF(L28<L2,0))","v":0},{"$f":"P28+Q28","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L4:L28,\"<00:00\")","v":0},{"$f":"M28+M22+M16+M10+M4","v":{"v":0,"d":"0.00 €"}},{"$f":"N28+N22+N16+N10+N4","v":{"v":0,"d":"0.00 €"}},{"$f":"O28+O22+O16+O10+O4","v":{"v":0,"d":"0.00 €"}},{"$f":"P4+P10+P16+P22+P28","v":0},{"$f":"Q4+Q10+Q16+Q22+Q28","v":0},{"$f":"R28+R22+R16+R10+R4","v":0}]

{"sheet":"Novembre 2010","index":7,"n_rows":31,"n_cols":18,"rows_kept":31}
["2010-11-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo","Heures majorées 25%/50%",null,"Total","Heures récupérées25/50%",null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
[]
["Lundi",1,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},null,{"$f":"I5-I2","v":0}]
["Mardi",2,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},null,{"$f":"I6-I2","v":0}]
["Mercredi",3,null,null,{"$f":"D7-C7","v":"00:00:00"},null,null,{"$f":"G7-F7","v":"00:00:00"},{"$f":"SUM(H7,E7)","v":"00:00:00"},null,{"$f":"I7-I2","v":0}]
["Jeudi",4,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Vendredi",5,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},{"$f":"I9+I8+I7+I6+I5","v":0},{"$f":"I9-I2","v":0},{"$f":"K9+K8+K7+K6+K5","v":0},{"$f":"IF(L9<K2,\"0,00\",IF(L9<L2,L9*M3*24,IF(L9>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L9>L2,(L9-L2)*N3*24,IF(L9<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M9+N9","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L9<K2,\"00\",IF(L9<L2,L9*P2*24,IF(L9>L2,L2*P2*24)))","v":0},{"$f":"IF(L9>L2,(L9-L2)*Q2*24,IF(L9<L2,0))","v":0},{"$f":"P9+Q9","v":0}]
[]
["Lundi",8,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},null,{"$f":"I11-I2","v":0}]
["Mardi",9,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},null,{"$f":"I12-I2","v":0}]
["Mercredi",10,null,null,{"$f":"D13-C13","v":"00:00:00"},null,null,{"$f":"G13-F13","v":"00:00:00"},{"$f":"SUM(H13,E13)","v":"00:00:00"},null,{"$f":"I13-I2","v":0}]
["Jeudi",11,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Vendredi",12,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},{"$f":"I15+I14+I13+I12+I11","v":0},{"$f":"I15-I2","v":0},{"$f":"K15+K14+K13+K12+K11","v":0},{"$f":"IF(L15<K2,\"0,00\",IF(L15<L2,L15*M3*24,IF(L15>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L15>L2,(L15-L2)*N3*24,IF(L15<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M15+N15","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L15<K2,\"00\",IF(L15<L2,L15*P2*24,IF(L15>L2,L2*P2*24)))","v":0},{"$f":"IF(L15>L2,(L15-L2)*Q2*24,IF(L15<L2,0))","v":0},{"$f":"P15+Q15*24","v":0}]
[]
["Lundi",15,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},null,{"$f":"I17-I2","v":0}]
["Mardi",16,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},null,{"$f":"I18-I2","v":0}]
["Mercredi",17,null,null,{"$f":"D19-C19","v":"00:00:00"},null,null,{"$f":"G19-F19","v":"00:00:00"},{"$f":"SUM(H19,E19)","v":"00:00:00"},null,{"$f":"I19-I2","v":0}]
["Jeudi",18,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Vendredi",19,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},{"$f":"I21+I20+I19+I18+I17","v":0},{"$f":"I21-I2","v":0},{"$f":"K17+K18+K19+K20+K21","v":0},{"$f":"IF(L21<K2,\"0,00\",IF(L21<L2,L21*M3*24,IF(L21>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L21>L2,(L21-L2)*N3*24,IF(L21<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M21+N21","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L21<K2,\"00\",IF(L21<L2,L21*P2*24,IF(L21>L2,L2*P2*24)))","v":0},{"$f":"IF(L21>L2,(L21-L2)*Q2*24,IF(L21<L2,0))","v":0},{"$f":"P21+Q21","v":0}]
[]
["Lundi",22,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},null,{"$f":"I23-I2","v":0}]
["Mardi",23,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},null,{"$f":"I24-I2","v":0}]
["Mercredi",24,null,null,{"$f":"D25-C25","v":"00:00:00"},null,null,{"$f":"G25-F25","v":"00:00:00"},{"$f":"SUM(H25,E25)","v":"00:00:00"},null,{"$f":"I25-I2","v":0}]
["Jeudi",25,null,null,{"$f":"D26-C26","v":0},null,null,{"$f":"G26-F26","v":0},{"$f":"SUM(H26,E26)","v":0},null,{"$f":"I26-I2","v":0}]
["Vendredi",26,null,null,{"$f":"D27-C27","v":0},null,null,{"$f":"G27-F27","v":0},{"$f":"E27+H27","v":0},{"$f":"I27+I26+I25+I24+I23","v":0},{"$f":"I27-I2","v":0},{"$f":"K27+K26+K25+K24+K23","v":0},{"$f":"IF(L27<K2,\"0,00\",IF(L27<L2,L27*M3*24,IF(L27>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L27>L2,(L27-L2)*N3*24,IF(L27<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M27+N27","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L27<K2,\"00\",IF(L27<L2,L27*P2*24,IF(L27>L2,L2*P2*24)))","v":0},{"$f":"IF(L27>L2,(L27-L2)*Q2*24,IF(L27<L2,0))","v":0},{"$f":"P27+Q27","v":0}]
[]
["Lundi",29,null,null,{"$f":"D29-C29","v":"00:00:00"},null,null,{"$f":"G29-F29","v":"00:00:00"},{"$f":"SUM(H29,E29)","v":"00:00:00"},null,{"$f":"I29-I2","v":0}]
["Mardi",30,null,null,{"$f":"D30-C30","v":"00:00:00"},null,null,{"$f":"G30-F30","v":"00:00:00"},{"$f":"SUM(H30,E30)","v":"00:00:00"},{"$f":"I30+I29","v":0},{"$f":"I30-I2","v":0},{"$f":"K30+K29","v":0},{"$f":"IF(L30<K2,\"0,00\",IF(L30<L2,L30*M3*24,IF(L30>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30>L2,(L30-L2)*N3*24,IF(L30<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M30+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30<K2,\"00\",IF(L30<L2,L30*P2*24,IF(L30>L2,L2*P2*24)))","v":0},{"$f":"IF(L30>L2,(L30-L2)*Q2*24,IF(L30<L2,0))","v":0},{"$f":"P30+Q30","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L9:L30,\"<00:00\")","v":0},{"$f":"M27+M21+M15+M9+M30","v":{"v":0,"d":"0.00 €"}},{"$f":"N27+N21+N15+N9+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"O27+O21+O15+O9+O30","v":{"v":0,"d":"0.00 €"}},{"$f":"P30+P9+P15+P21+P27","v":0},{"$f":"Q30+Q9+Q15+Q21+Q27","v":0},{"$f":"R27+R21+R15+R9+R30","v":0}]

{"sheet":"Décembre 2010","index":8,"n_rows":31,"n_cols":18,"rows_kept":31}
["2010-12-01",null,"Arrivée","Départ","Total am","Arrivée","Départ","Total pm","Tot.jour","Tot.hebdo","H.s/jour","H.s/hebdo","Heures majorées 25%/50%",null,"Total","Heures récupérées25/50%",null,"Total"]
[{"$nulls":8},{"$f":"'A LIRE'!G3","v":"00:00:00"},null,0,0.3333333333333333,{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},null,"01:15:00","01:30:00"]
[{"$nulls":12},{"$f":"'A LIRE'!G5","v":0},{"$f":"'A LIRE'!G7","v":0}]
["Mercredi",1,null,null,{"$f":"D4-C4","v":"00:00:00"},null,null,{"$f":"G4-F4","v":"00:00:00"},{"$f":"SUM(H4,E4)","v":"00:00:00"},null,{"$f":"I4-I2","v":0}]
["Jeudi",2,null,null,{"$f":"D5-C5","v":"00:00:00"},null,null,{"$f":"G5-F5","v":"00:00:00"},{"$f":"SUM(H5,E5)","v":"00:00:00"},null,{"$f":"I5-I2","v":0}]
["Vendredi",3,null,null,{"$f":"D6-C6","v":"00:00:00"},null,null,{"$f":"G6-F6","v":"00:00:00"},{"$f":"SUM(H6,E6)","v":"00:00:00"},{"$f":"I6+I4","v":0},{"$f":"I6-I2","v":0},{"$f":"K6+K4+K5","v":0},{"$f":"IF(L6<K2,\"0,00\",IF(L6<L2,L6*M3*24,IF(L6>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L6>L2,(L6-L2)*N3*24,IF(L6<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M6+N6","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L6<K2,\"00\",IF(L6<L2,L6*P2*24,IF(L6>L2,L2*P2*24)))","v":0},{"$f":"IF(L6>L2,(L6-L2)*Q2*24,IF(L6<L2,0))","v":0},{"$f":"P6+Q6","v":0}]
[]
["Lundi",6,null,null,{"$f":"D8-C8","v":"00:00:00"},null,null,{"$f":"G8-F8","v":"00:00:00"},{"$f":"SUM(H8,E8)","v":"00:00:00"},null,{"$f":"I8-I2","v":0}]
["Mardi",7,null,null,{"$f":"D9-C9","v":"00:00:00"},null,null,{"$f":"G9-F9","v":"00:00:00"},{"$f":"SUM(H9,E9)","v":"00:00:00"},null,{"$f":"I9-I2","v":0}]
["Mercredi",8,null,null,{"$f":"D10-C10","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"},{"$f":"SUM(H10,E10)","v":"00:00:00"},null,{"$f":"I10-I2","v":0}]
["Jeudi",9,null,null,{"$f":"D11-C11","v":"00:00:00"},null,null,{"$f":"G11-F11","v":"00:00:00"},{"$f":"SUM(H11,E11)","v":"00:00:00"},null,{"$f":"I11-I2","v":0}]
["Vendredi",10,null,null,{"$f":"D12-C12","v":"00:00:00"},null,null,{"$f":"G12-F12","v":"00:00:00"},{"$f":"SUM(H12,E12)","v":"00:00:00"},{"$f":"I12+I11+I10+I9+I8","v":0},{"$f":"I12-I2","v":0},{"$f":"K12+K11+K10+K9+K8","v":0},{"$f":"IF(L12<K2,\"0,00\",IF(L12<L2,L12*M3*24,IF(L12>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L12>L2,(L12-L2)*N3*24,IF(L12<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M12+N12","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L12<K2,\"00\",IF(L12<L2,L12*P2*24,IF(L12>L2,L2*P2*24)))","v":0},{"$f":"IF(L12>L2,(L12-L2)*Q2*24,IF(L12<L2,0))","v":0},{"$f":"P12+Q12","v":0}]
[]
["Lundi",13,null,null,{"$f":"D14-C14","v":"00:00:00"},null,null,{"$f":"G14-F14","v":"00:00:00"},{"$f":"SUM(H14,E14)","v":"00:00:00"},null,{"$f":"I14-I2","v":0}]
["Mardi",14,null,null,{"$f":"D15-C15","v":"00:00:00"},null,null,{"$f":"G15-F15","v":"00:00:00"},{"$f":"SUM(H15,E15)","v":"00:00:00"},null,{"$f":"I15-I2","v":0}]
["Mercredi",15,null,null,{"$f":"D16-C16","v":"00:00:00"},null,null,{"$f":"G16-F16","v":"00:00:00"},{"$f":"SUM(H16,E16)","v":"00:00:00"},null,{"$f":"I16-I2","v":0}]
["Jeudi",16,null,null,{"$f":"D17-C17","v":"00:00:00"},null,null,{"$f":"G17-F17","v":"00:00:00"},{"$f":"SUM(H17,E17)","v":"00:00:00"},null,{"$f":"I17-I2","v":0}]
["Vendredi",17,null,null,{"$f":"D18-C18","v":"00:00:00"},null,null,{"$f":"G18-F18","v":"00:00:00"},{"$f":"SUM(H18,E18)","v":"00:00:00"},{"$f":"I18+I17+I16+I15+I14","v":0},{"$f":"I18-I2","v":0},{"$f":"K18+K17+K16+K15+K14","v":0},{"$f":"IF(L18<K2,\"0,00\",IF(L18<L2,L18*M3*24,IF(L18>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L18>L2,(L18-L2)*N3*24,IF(L18<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M18+N18","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L18<K2,\"00\",IF(L18<L2,L18*P2*24,IF(L18>L2,L2*P2*24)))","v":0},{"$f":"IF(L18>L2,(L18-L2)*Q2*24,IF(L18<L2,0))","v":0},{"$f":"P18+Q18*24","v":0}]
[]
["Lundi",20,null,null,{"$f":"D20-C20","v":"00:00:00"},null,null,{"$f":"G20-F20","v":"00:00:00"},{"$f":"SUM(H20,E20)","v":"00:00:00"},null,{"$f":"I20-I2","v":0}]
["Mardi",21,null,null,{"$f":"D21-C21","v":"00:00:00"},null,null,{"$f":"G21-F21","v":"00:00:00"},{"$f":"SUM(H21,E21)","v":"00:00:00"},null,{"$f":"I21-I2","v":0}]
["Mercredi",22,null,null,{"$f":"D22-C22","v":"00:00:00"},null,null,{"$f":"G22-F22","v":"00:00:00"},{"$f":"SUM(H22,E22)","v":"00:00:00"},null,{"$f":"I22-I2","v":0}]
["Jeudi",23,null,null,{"$f":"D23-C23","v":"00:00:00"},null,null,{"$f":"G23-F23","v":"00:00:00"},{"$f":"SUM(H23,E23)","v":"00:00:00"},null,{"$f":"I23-I2","v":0}]
["Vendredi",24,null,null,{"$f":"D24-C24","v":"00:00:00"},null,null,{"$f":"G24-F24","v":"00:00:00"},{"$f":"SUM(H24,E24)","v":"00:00:00"},{"$f":"I24+I23+I22+I21+I20","v":0},{"$f":"I24-I2","v":0},{"$f":"K20+K21+K22+K23+K24","v":0},{"$f":"IF(L24<K2,\"0,00\",IF(L24<L2,L24*M3*24,IF(L24>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L24>L2,(L24-L2)*N3*24,IF(L24<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M24+N24","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L24<K2,\"00\",IF(L24<L2,L24*P2*24,IF(L24>L2,L2*P2*24)))","v":0},{"$f":"IF(L24>L2,(L24-L2)*Q2*24,IF(L24<L2,0))","v":0},{"$f":"P24+Q24","v":0}]
[]
["Lundi",27,null,null,{"$f":"D26-C26","v":"00:00:00"},null,null,{"$f":"G26-F26","v":"00:00:00"},{"$f":"SUM(H26,E26)","v":"00:00:00"},null,{"$f":"I26-I2","v":0}]
["Mardi",28,null,null,{"$f":"D27-C27","v":"00:00:00"},null,null,{"$f":"G27-F27","v":"00:00:00"},{"$f":"SUM(H27,E27)","v":"00:00:00"},null,{"$f":"I27-I2","v":0}]
["Mercredi",29,null,null,{"$f":"D28-C28","v":"00:00:00"},null,null,{"$f":"G28-F28","v":"00:00:00"},{"$f":"SUM(H28,E28)","v":"00:00:00"},null,{"$f":"I28-I2","v":0}]
["Jeudi",30,null,null,{"$f":"D29-C29","v":0},null,null,{"$f":"G29-F29","v":0},{"$f":"SUM(H29,E29)","v":0},null,{"$f":"I29-I2","v":0}]
["Vendredi",31,null,null,{"$f":"D30-C30","v":0},null,null,{"$f":"G30-F30","v":0},{"$f":"E30+H30","v":0},{"$f":"I30+I29+I28+I27+I26","v":0},{"$f":"I30-I2","v":0},{"$f":"K30+K29+K28+K27+K26","v":0},{"$f":"IF(L30<K2,\"0,00\",IF(L30<L2,L30*M3*24,IF(L30>L2,L2*M3*24)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30>L2,(L30-L2)*N3*24,IF(L30<L2,0))","v":{"v":0,"d":"0.00 €"}},{"$f":"M30+N30","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(L30<K2,\"00\",IF(L30<L2,L30*P2*24,IF(L30>L2,L2*P2*24)))","v":0},{"$f":"IF(L30>L2,(L30-L2)*Q2*24,IF(L30<L2,0))","v":0},{"$f":"P30+Q30","v":0}]
["TOTAUX",{"$nulls":10},{"$f":"SUMIF(L6:L30,\"<00:00\")","v":0},{"$f":"M30+M24+M18+M12+M6","v":{"v":0,"d":"0.00 €"}},{"$f":"N30+N24+N18+N12+N6","v":{"v":0,"d":"0.00 €"}},{"$f":"O30+O24+O18+O12+O6","v":{"v":0,"d":"0.00 €"}},{"$f":"P6+P12+P18+P24+P30","v":0},{"$f":"Q6+Q12+Q18+Q24+Q30","v":0},{"$f":"R30+R24+R18+R12+R6","v":0}]