{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["01","02","03","04","05","heures"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"01","index":0,"n_rows":34,"n_cols":60,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,19,32,19],[8,1,8,7],[9,8,9,9],[10,0,13,0],[11,2,11,6],[14,0,17,0],[15,2,15,6],[19,1,19,2],[19,3,19,4]]}
[null,null,null,null,null,null,null,null,null,null,"FICHE DE GESTION D'ACTIVITE ET DU TEMPS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null," "," ","CP   ","C2   ","RU   ","RT   ","JF   ","F2   ","FP   ","AE   ","AH   ","AJ   ","AN   ","AP   ","AQ   ","AR   ","AT   ","BB   ","CA   ","CN   ","CT   ","DC   ","DE   ","DF   ","FG   ","GP   ","JA   ","JS   ","MA   ","ME   ","MS   ","MT   ","NE   ","PA   ","R2   ","RE   ","SD   ","SE   "]
[null,null,null,null,null,null,null,null,null,null,null,"Non cadre forfait heure / cadre forfait heure",null,null,null,null,null,null,null,null,null,"Congés Payés 1 journée","CP   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Journée Congés Payés","C2   "]
[null,"Nom :","NICOLAS VADEE",null,null,null,null,null,null,"N° Collaborateur :",455781,null,"Visa Chef de Service :",null,null,null,null,null,null,"Semaine :",null,"Jour de RTT","RU   ",null,17.899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Jour de RTT","RT   "]
[null,"CB :","003100",null,null,null,null,null,null,"AG :","020",null,null,null,null,null,null,{"$f":"S6","v":1},1,2017,null,"Jour Férié","JF   "]
[null,null,null,null,null,null,null,null,null,null,"- Le temps de repos quotidien à respecter est d’une durée minimale de 11 heures consécutives ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1/2 journée","F2   "]
[null,null,null,null,null,null,null,null,null,null,"- Toute intervention comprise entre  21 h et 6 h doit être mentionnée distinctement ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1 Jour","FP   "]
[null,"Déclaration du temps de travail            et de trajet (en H et centièmes d'H)",null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(N11:N34)","v":0},{"$f":"SUM(O11:O34)","v":0},{"$f":"SUM(P11:P34)","v":89.5},null,{"$f":"SUM(R11:R34)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S34)","v":{"$error":"#REF!"}},null,null,"Absence Autorisée payée 1 journée","AE   "]
[null,null,"Lun","Mar","Mer","Jeu","Ven","Sam","Date    jj / mm",null,"CB - affaire - prestation","Client","Lieu d'intervention","UO     prév.","UO     pas.","Montant frais","Nature frais","KM","Km",null,null,"Absence Autorisée payée (saisie Heures)","AH   ","KM / 5","KM / JOUR"]
["M A T  I  N","TE",4,2,4,4,5,null,null,{"$f":"IF(I11=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I11,\" jj mmm\"))","v":""},null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11)","v":""},{"$f":"IF(Q11=\"RM\",$Y$4,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",\"RM\")","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$X$11,IF(I11=1,$X$12,IF(I11=2,$X$13,IF(I11=3,$X$14,IF(I11=4,$X$15))))))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$Y$11,IF(I11=1,$Y$12,IF(I11=2,$Y$13,IF(I11=3,$Y$14,IF(I11=4,$Y$15))))))","v":""},"B       Fourniture bureau\nDO     Documenta., livres",null,"Accident de Trajet","AJ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,0," 02 janv",null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""},{"$f":"IF(Q12=\"RM\",$Y$4,\"\")","v":17.899999999999999},"RM",{"$f":"IF(I12=\"\",\"\",IF(I12=0,$X$11,IF(I12=1,$X$12,IF(I12=2,$X$13,IF(I12=3,$X$14,IF(I12=4,$X$15))))))","v":{"$error":"#REF!"}},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$Y$11,IF(I12=1,$Y$12,IF(I12=2,$Y$13,IF(I12=3,$Y$14,IF(I12=4,$Y$15))))))","v":{"$error":"#REF!"}},"IE       Invitation Externe\nII         Invitation Interne",null,"Absence Autorisée non payée","AN   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,{"$f":"IF(N13=\"\",\"\",N13)","v":""},"","","","","RM     Déjeuner forfait\nRS       Diner justifié",null,"Absence Autorisée payée 1/2 J.","AP   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,1," 03 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"TR       Ticket Restaurant",null,"Régul. Forfait annuel (JOUR)","AQ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["A. MI D I","TE",3.88,3.27,4,3.88,3.22,null,null,"",null,null,null,null,"","","","","","HF       Hôtel nuit + petit\n           déjeuner province",null,"Régul. Forfait annuel (1/2 Journée)","AR   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,2," 04 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"HP       Hôtel nuit + petit\n             déjeuner IdF",null,"Accident de Travail","AT   "]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","FM       Frais médicaux",null,"Maternité","BB   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","G1     Entretien VS (2p)",null,"Congé Adoption","CA   "]
[null,"Total J",{"$f":"(C11+C15)","v":7.88},{"$f":"IF(D12+D16<1.5,D11+D15,D11+D12+D15+D16-1.5)","v":5.27},{"$f":"IF(E12+E16<1.5,E11+E15,E11+E12+E15+E16-1.5)","v":8},{"$f":"IF(F12+F16<1.5,F11+F15,F11+F12+F15+F16-1.5)","v":7.88},{"$f":"IF(G12+G16<1.5,G11+G15,G11+G12+G15+G16-1.5)","v":8.2200000000000006},{"$f":"IF(H12+H16<1.5,H11+H15,H11+H12+H15+H16-1.5)","v":0},null,"",null,null,null,null,"","","","","","G2    Entretien VT (4p)\n          ou VP (perso.)",null,"Congé Naissance","CN   "]
[null,"=",null,{"$f":"SUM(C19:H19)","v":37.25},null,null,null,null,null,"",null,null,null,null,"","","","","","FA    Consommables/aff. \nPO    Frais de poste",null,"Cure Thermale","CT   "]
[null,null,null,null,null,null,null,null,3,{"$f":"IF(I21=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I21,\" jj mmm\"))","v":" 05 janv"},null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"MC    Mat. Contrôle < 500€\nMS    Mat. Sécurité < 500€",null,"Décès Conjoint","DC   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","ES     Carburant hors\n          TOTAL",null,"Décès Enfant","DE   "]
[null,null,null,null,null,null,null,null,4," 06 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"PP  Péage/park hors\n          TOTAL",null,"Décès Famille","DF   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PT     Péage/park carte\n       TOTAL non remboursé",null,"Fongecif","FG   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","K      Kilomètres",null,"Congé patho. avant maternité","GP   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","T      Voyage(avion/train/\n            taxi/métro/bateau/…)",null,"Juré d'Assises","JA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PV    Passeport/Visa\nTL     Téléphonie internet",null,"Jour Supplémentaire","JS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Maladie","MA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"","","","",null,null,"Mariage Enfant","ME   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","KC =",null,"Mariage Collaborateur","MS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",{"$f":"IF(Q31=\"RM\",$Y$4,\"\")","v":""},"","","",null,null,"Mi temps thérapeutique","MT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",{"$f":"IF(Q32=\"RM\",$Y$4,\"\")","v":""},"","",{"$f":"IF(I32=\"\",\"\",IF(I32=0,$Y$11,IF(I32=1,$Y$12,IF(I32=2,$Y$13,IF(I32=3,$Y$14,IF(I32=4,$Y$15))))))","v":""},"Indiquer chaque fin de mois la différence de Km compteur entre M et M-1",null,"Jour Sans Solde (1 jour)","NE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",{"$f":"IF(Q33=\"RM\",$Y$4,\"\")","v":""},"","",{"$f":"IF(I33=\"\",\"\",IF(I33=0,$Y$11,IF(I33=1,$Y$12,IF(I33=2,$Y$13,IF(I33=3,$Y$14,IF(I33=4,$Y$15))))))","v":""},null,null,"Paternité","PA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",{"$f":"IF(Q34=\"RM\",$Y$4,\"\")","v":""},"","",{"$f":"IF(I34=\"\",\"\",IF(I34=0,$Y$11,IF(I34=1,$Y$12,IF(I34=2,$Y$13,IF(I34=3,$Y$14,IF(I34=4,$Y$15))))))","v":""},null,null,"Récupération 1/2 journée","R2   "]

{"sheet":"02","index":1,"n_rows":34,"n_cols":60,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,19,32,19],[8,1,8,7],[9,8,9,9],[10,0,13,0],[11,2,11,6],[14,0,17,0],[15,2,15,6],[19,1,19,2],[19,3,19,4]]}
[null,null,null,null,null,null,null,null,null,null,"FICHE DE GESTION D'ACTIVITE ET DU TEMPS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null," "," ","CP   ","C2   ","RU   ","RT   ","JF   ","F2   ","FP   ","AE   ","AH   ","AJ   ","AN   ","AP   ","AQ   ","AR   ","AT   ","BB   ","CA   ","CN   ","CT   ","DC   ","DE   ","DF   ","FG   ","GP   ","JA   ","JS   ","MA   ","ME   ","MS   ","MT   ","NE   ","PA   ","R2   ","RE   ","SD   ","SE   "]
[null,null,null,null,null,null,null,null,null,null,null,"Non cadre forfait heure / cadre forfait heure",null,null,null,null,null,null,null,null,null,"Congés Payés 1 journée","CP   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Journée Congés Payés","C2   "]
[null,"Nom :","NICOLAS VADEE",null,null,null,null,null,null,"N° Collaborateur :",455781,null,"Visa Chef de Service :",null,null,null,null,null,null,"Semaine :",null,"Jour de RTT","RU   ",null,17.899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Jour de RTT","RT   "]
[null,"CB :","003100",null,null,null,null,null,null,"AG :","020",null,null,null,null,null,null,{"$f":"S6","v":2},2,2017,null,"Jour Férié","JF   "]
[null,null,null,null,null,null,null,null,null,null,"- Le temps de repos quotidien à respecter est d’une durée minimale de 11 heures consécutives ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1/2 journée","F2   "]
[null,null,null,null,null,null,null,null,null,null,"- Toute intervention comprise entre  21 h et 6 h doit être mentionnée distinctement ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1 Jour","FP   "]
[null,"Déclaration du temps de travail            et de trajet (en H et centièmes d'H)",null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(N11:N34)","v":0},{"$f":"SUM(O11:O34)","v":0},{"$f":"SUM(P11:P34)","v":89.5},null,{"$f":"SUM(R11:R34)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S34)","v":{"$error":"#REF!"}},null,null,"Absence Autorisée payée 1 journée","AE   "]
[null,null,"Lun","Mar","Mer","Jeu","Ven","Sam","Date    jj / mm",null,"CB - affaire - prestation","Client","Lieu d'intervention","UO     prév.","UO     pas.","Montant frais","Nature frais","KM","Km",null,null,"Absence Autorisée payée (saisie Heures)","AH   ","KM / 5","KM / JOUR"]
["M A T  I  N","TE","RTT","CP",4,4,3,null,null,{"$f":"IF(I11=\"\",\"\",DATEVALUE(TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I11,\" jj/mm/aa\")))","v":""},null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11)","v":""},{"$f":"IF(Q11=\"RM\",$Y$4,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",\"RM\")","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$X$11,IF(I11=1,$X$12,IF(I11=2,$X$13,IF(I11=3,$X$14,IF(I11=4,$X$15))))))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$Y$11,IF(I11=1,$Y$12,IF(I11=2,$Y$13,IF(I11=3,$Y$14,IF(I11=4,$Y$15))))))","v":""},"B       Fourniture bureau\nDO     Documenta., livres",null,"Accident de Trajet","AJ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,0,"2017-01-09",null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""},{"$f":"IF(Q12=\"RM\",$Y$4,\"\")","v":17.899999999999999},{"$f":"IF(I12=\"\",\"\",\"RM\")","v":"RM"},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$X$11,IF(I12=1,$X$12,IF(I12=2,$X$13,IF(I12=3,$X$14,IF(I12=4,$X$15))))))","v":{"$error":"#REF!"}},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$Y$11,IF(I12=1,$Y$12,IF(I12=2,$Y$13,IF(I12=3,$Y$14,IF(I12=4,$Y$15))))))","v":{"$error":"#REF!"}},"IE       Invitation Externe\nII         Invitation Interne",null,"Absence Autorisée non payée","AN   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","RM     Déjeuner forfait\nRS       Diner justifié",null,"Absence Autorisée payée 1/2 J.","AP   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,1,"2017-01-10",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"TR       Ticket Restaurant",null,"Régul. Forfait annuel (JOUR)","AQ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["A. MI D I","TE","RTT","CP",3.88,4,5,null,null,"",null,null,null,null,"","","","","","HF       Hôtel nuit + petit\n           déjeuner province",null,"Régul. Forfait annuel (1/2 Journée)","AR   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,2,"2017-01-11",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"HP       Hôtel nuit + petit\n             déjeuner IdF",null,"Accident de Travail","AT   "]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","FM       Frais médicaux",null,"Maternité","BB   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","G1     Entretien VS (2p)",null,"Congé Adoption","CA   "]
[null,"Total J",{"$f":"(C11+C15)","v":{"$error":"#VALUE!"}},{"$f":"IF(D12+D16<1.5,D11+D15,D11+D12+D15+D16-1.5)","v":{"$error":"#VALUE!"}},{"$f":"IF(E12+E16<1.5,E11+E15,E11+E12+E15+E16-1.5)","v":7.88},{"$f":"IF(F12+F16<1.5,F11+F15,F11+F12+F15+F16-1.5)","v":8},{"$f":"IF(G12+G16<1.5,G11+G15,G11+G12+G15+G16-1.5)","v":8},{"$f":"IF(H12+H16<1.5,H11+H15,H11+H12+H15+H16-1.5)","v":0},null,"",null,null,null,null,"","","","","","G2    Entretien VT (4p)\n          ou VP (perso.)",null,"Congé Naissance","CN   "]
[null,"=",null,{"$f":"SUM(C19:H19)","v":{"$error":"#VALUE!"}},null,null,null,null,3,"2017-01-12",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"FA    Consommables/aff. \nPO    Frais de poste",null,"Cure Thermale","CT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","MC    Mat. Contrôle < 500€\nMS    Mat. Sécurité < 500€",null,"Décès Conjoint","DC   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","ES     Carburant hors\n          TOTAL",null,"Décès Enfant","DE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PP  Péage/park hors\n          TOTAL",null,"Décès Famille","DF   "]
[null,null,null,null,null,null,null,null,4,"2017-01-13",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"PT     Péage/park carte\n       TOTAL non remboursé",null,"Fongecif","FG   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","K      Kilomètres",null,"Congé patho. avant maternité","GP   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","T      Voyage(avion/train/\n            taxi/métro/bateau/…)",null,"Juré d'Assises","JA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PV    Passeport/Visa\nTL     Téléphonie internet",null,"Jour Supplémentaire","JS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Maladie","MA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mariage Enfant","ME   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","KC =",null,"Mariage Collaborateur","MS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mi temps thérapeutique","MT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","Indiquer chaque fin de mois la différence de Km compteur entre M et M-1",null,"Jour Sans Solde (1 jour)","NE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Paternité","PA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Récupération 1/2 journée","R2   "]

{"sheet":"03","index":2,"n_rows":34,"n_cols":60,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,19,32,19],[8,1,8,7],[9,8,9,9],[10,0,13,0],[11,2,11,6],[14,0,17,0],[15,2,15,6],[19,1,19,2],[19,3,19,4]]}
[null,null,null,null,null,null,null,null,null,null,"FICHE DE GESTION D'ACTIVITE ET DU TEMPS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null," "," ","CP   ","C2   ","RU   ","RT   ","JF   ","F2   ","FP   ","AE   ","AH   ","AJ   ","AN   ","AP   ","AQ   ","AR   ","AT   ","BB   ","CA   ","CN   ","CT   ","DC   ","DE   ","DF   ","FG   ","GP   ","JA   ","JS   ","MA   ","ME   ","MS   ","MT   ","NE   ","PA   ","R2   ","RE   ","SD   ","SE   "]
[null,null,null,null,null,null,null,null,null,null,null,"Non cadre forfait heure / cadre forfait heure",null,null,null,null,null,null,null,null,null,"Congés Payés 1 journée","CP   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Journée Congés Payés","C2   "]
[null,"Nom :","NICOLAS VADEE",null,null,null,null,null,null,"N° Collaborateur :",455781,null,"Visa Chef de Service :",null,null,null,null,null,null,"Semaine :",null,"Jour de RTT","RU   ",null,17.899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Jour de RTT","RT   "]
[null,"CB :","003100",null,null,null,null,null,null,"AG :","020",null,null,null,null,null,null,{"$f":"S6","v":3},3,2017,null,"Jour Férié","JF   "]
[null,null,null,null,null,null,null,null,null,null,"- Le temps de repos quotidien à respecter est d’une durée minimale de 11 heures consécutives ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1/2 journée","F2   "]
[null,null,null,null,null,null,null,null,null,null,"- Toute intervention comprise entre  21 h et 6 h doit être mentionnée distinctement ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1 Jour","FP   "]
[null,"Déclaration du temps de travail            et de trajet (en H et centièmes d'H)",null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(N11:N34)","v":0},{"$f":"SUM(O11:O34)","v":0},{"$f":"SUM(P11:P34)","v":89.5},null,{"$f":"SUM(R11:R34)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S34)","v":{"$error":"#REF!"}},null,null,"Absence Autorisée payée 1 journée","AE   "]
[null,null,"Lun","Mar","Mer","Jeu","Ven","Sam","Date    jj / mm",null,"CB - affaire - prestation","Client","Lieu d'intervention","UO     prév.","UO     pas.","Montant frais","Nature frais","KM","Km",null,null,"Absence Autorisée payée (saisie Heures)","AH   ","KM / 5","KM / JOUR"]
["M A T  I  N","TE",4,4,4,4,4,null,null,{"$f":"IF(I11=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I11,\" jj mmm\"))","v":""},null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11)","v":""},{"$f":"IF(Q11=\"RM\",$Y$4,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",\"RM\")","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$X$11,IF(I11=1,$X$12,IF(I11=2,$X$13,IF(I11=3,$X$14,IF(I11=4,$X$15))))))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$Y$11,IF(I11=1,$Y$12,IF(I11=2,$Y$13,IF(I11=3,$Y$14,IF(I11=4,$Y$15))))))","v":""},"B       Fourniture bureau\nDO     Documenta., livres",null,"Accident de Trajet","AJ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,0,{"$f":"IF(I12=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I12,\" jj mmm\"))","v":" 16 janv"},null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""},{"$f":"IF(Q12=\"RM\",$Y$4,\"\")","v":17.899999999999999},{"$f":"IF(I12=\"\",\"\",\"RM\")","v":"RM"},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$X$11,IF(I12=1,$X$12,IF(I12=2,$X$13,IF(I12=3,$X$14,IF(I12=4,$X$15))))))","v":{"$error":"#REF!"}},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$Y$11,IF(I12=1,$Y$12,IF(I12=2,$Y$13,IF(I12=3,$Y$14,IF(I12=4,$Y$15))))))","v":{"$error":"#REF!"}},"IE       Invitation Externe\nII         Invitation Interne",null,"Absence Autorisée non payée","AN   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","RM     Déjeuner forfait\nRS       Diner justifié",null,"Absence Autorisée payée 1/2 J.","AP   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,1," 17 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"TR       Ticket Restaurant",null,"Régul. Forfait annuel (JOUR)","AQ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["A. MI D I","TE",3.88,3.88,3.88,3.88,3.88,null,null,"",null,null,null,null,"","","","","","HF       Hôtel nuit + petit\n           déjeuner province",null,"Régul. Forfait annuel (1/2 Journée)","AR   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,2," 18 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"HP       Hôtel nuit + petit\n             déjeuner IdF",null,"Accident de Travail","AT   "]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","FM       Frais médicaux",null,"Maternité","BB   "]
[null,null,null,null,null,null,null,null,3," 19 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"G1     Entretien VS (2p)",null,"Congé Adoption","CA   "]
[null,"Total J",{"$f":"(C11+C15)","v":7.88},{"$f":"IF(D12+D16<1.5,D11+D15,D11+D12+D15+D16-1.5)","v":7.88},{"$f":"IF(E12+E16<1.5,E11+E15,E11+E12+E15+E16-1.5)","v":7.88},{"$f":"IF(F12+F16<1.5,F11+F15,F11+F12+F15+F16-1.5)","v":7.88},{"$f":"IF(G12+G16<1.5,G11+G15,G11+G12+G15+G16-1.5)","v":7.88},{"$f":"IF(H12+H16<1.5,H11+H15,H11+H12+H15+H16-1.5)","v":0},null,"",null,null,null,null,"","","","","","G2    Entretien VT (4p)\n          ou VP (perso.)",null,"Congé Naissance","CN   "]
[null,"=",null,{"$f":"SUM(C19:H19)","v":39.4},null,null,null,null,4," 20 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"FA    Consommables/aff. \nPO    Frais de poste",null,"Cure Thermale","CT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","MC    Mat. Contrôle < 500€\nMS    Mat. Sécurité < 500€",null,"Décès Conjoint","DC   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","ES     Carburant hors\n          TOTAL",null,"Décès Enfant","DE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PP  Péage/park hors\n          TOTAL",null,"Décès Famille","DF   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PT     Péage/park carte\n       TOTAL non remboursé",null,"Fongecif","FG   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","K      Kilomètres",null,"Congé patho. avant maternité","GP   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","T      Voyage(avion/train/\n            taxi/métro/bateau/…)",null,"Juré d'Assises","JA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PV    Passeport/Visa\nTL     Téléphonie internet",null,"Jour Supplémentaire","JS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Maladie","MA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mariage Enfant","ME   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","KC =",null,"Mariage Collaborateur","MS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mi temps thérapeutique","MT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","Indiquer chaque fin de mois la différence de Km compteur entre M et M-1",null,"Jour Sans Solde (1 jour)","NE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Paternité","PA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Récupération 1/2 journée","R2   "]

{"sheet":"04","index":3,"n_rows":34,"n_cols":60,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,19,32,19],[8,1,8,7],[9,8,9,9],[10,0,13,0],[11,2,11,6],[14,0,17,0],[15,2,15,6],[19,1,19,2],[19,3,19,4]]}
[null,null,null,null,null,null,null,null,null,null,"FICHE DE GESTION D'ACTIVITE ET DU TEMPS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null," "," ","CP   ","C2   ","RU   ","RT   ","JF   ","F2   ","FP   ","AE   ","AH   ","AJ   ","AN   ","AP   ","AQ   ","AR   ","AT   ","BB   ","CA   ","CN   ","CT   ","DC   ","DE   ","DF   ","FG   ","GP   ","JA   ","JS   ","MA   ","ME   ","MS   ","MT   ","NE   ","PA   ","R2   ","RE   ","SD   ","SE   "]
[null,null,null,null,null,null,null,null,null,null,null,"Non cadre forfait heure / cadre forfait heure",null,null,null,null,null,null,null,null,null,"Congés Payés 1 journée","CP   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Journée Congés Payés","C2   "]
[null,"Nom :","NICOLAS VADEE",null,null,null,null,null,null,"N° Collaborateur :",455781,null,"Visa Chef de Service :",null,null,null,null,null,null,"Semaine :",null,"Jour de RTT","RU   ",null,17.899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Jour de RTT","RT   "]
[null,"CB :","003100",null,null,null,null,null,null,"AG :","020",null,null,null,null,null,null,{"$f":"S6","v":4},4,2017,null,"Jour Férié","JF   "]
[null,null,null,null,null,null,null,null,null,null,"- Le temps de repos quotidien à respecter est d’une durée minimale de 11 heures consécutives ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1/2 journée","F2   "]
[null,null,null,null,null,null,null,null,null,null,"- Toute intervention comprise entre  21 h et 6 h doit être mentionnée distinctement ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1 Jour","FP   "]
[null,"Déclaration du temps de travail            et de trajet (en H et centièmes d'H)",null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(N11:N34)","v":0},{"$f":"SUM(O11:O34)","v":0},{"$f":"SUM(P11:P34)","v":89.5},null,{"$f":"SUM(R11:R34)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S34)","v":{"$error":"#REF!"}},null,null,"Absence Autorisée payée 1 journée","AE   "]
[null,null,"Lun","Mar","Mer","Jeu","Ven","Sam","Date    jj / mm",null,"CB - affaire - prestation","Client","Lieu d'intervention","UO     prév.","UO     pas.","Montant frais","Nature frais","KM","Km",null,null,"Absence Autorisée payée (saisie Heures)","AH   ","KM / 5","KM / JOUR"]
["M A T  I  N","TE",4,4,4,4,4,null,null,{"$f":"IF(I11=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I11,\" jj mmm\"))","v":""},null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11)","v":""},{"$f":"IF(Q11=\"RM\",$Y$4,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",\"RM\")","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$X$11,IF(I11=1,$X$12,IF(I11=2,$X$13,IF(I11=3,$X$14,IF(I11=4,$X$15))))))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$Y$11,IF(I11=1,$Y$12,IF(I11=2,$Y$13,IF(I11=3,$Y$14,IF(I11=4,$Y$15))))))","v":""},"B       Fourniture bureau\nDO     Documenta., livres",null,"Accident de Trajet","AJ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,0,{"$f":"IF(I12=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I12,\" jj mmm\"))","v":" 23 janv"},null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""},{"$f":"IF(Q12=\"RM\",$Y$4,\"\")","v":17.899999999999999},{"$f":"IF(I12=\"\",\"\",\"RM\")","v":"RM"},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$X$11,IF(I12=1,$X$12,IF(I12=2,$X$13,IF(I12=3,$X$14,IF(I12=4,$X$15))))))","v":{"$error":"#REF!"}},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$Y$11,IF(I12=1,$Y$12,IF(I12=2,$Y$13,IF(I12=3,$Y$14,IF(I12=4,$Y$15))))))","v":{"$error":"#REF!"}},"IE       Invitation Externe\nII         Invitation Interne",null,"Absence Autorisée non payée","AN   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","RM     Déjeuner forfait\nRS       Diner justifié",null,"Absence Autorisée payée 1/2 J.","AP   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","TR       Ticket Restaurant",null,"Régul. Forfait annuel (JOUR)","AQ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["A. MI D I","TE",3.88,3.88,3.88,3.88,3.88,null,null,"",null,null,null,null,"","","","","","HF       Hôtel nuit + petit\n           déjeuner province",null,"Régul. Forfait annuel (1/2 Journée)","AR   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,null,"",null,null,null,null,"","","","","","HP       Hôtel nuit + petit\n             déjeuner IdF",null,"Accident de Travail","AT   "]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","FM       Frais médicaux",null,"Maternité","BB   "]
[null,null,null,null,null,null,null,null,1," 24 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"G1     Entretien VS (2p)",null,"Congé Adoption","CA   "]
[null,"Total J",{"$f":"(C11+C15)","v":7.88},{"$f":"IF(D12+D16<1.5,D11+D15,D11+D12+D15+D16-1.5)","v":7.88},{"$f":"IF(E12+E16<1.5,E11+E15,E11+E12+E15+E16-1.5)","v":7.88},{"$f":"IF(F12+F16<1.5,F11+F15,F11+F12+F15+F16-1.5)","v":7.88},{"$f":"IF(G12+G16<1.5,G11+G15,G11+G12+G15+G16-1.5)","v":7.88},{"$f":"IF(H12+H16<1.5,H11+H15,H11+H12+H15+H16-1.5)","v":0},null,"",null,null,null,null,"","","","","","G2    Entretien VT (4p)\n          ou VP (perso.)",null,null,"CN   "]
[null,"=",null,{"$f":"SUM(C19:H19)","v":39.4},null,null,null,null,null,"",null,null,null,null,"","","","","","FA    Consommables/aff. \nPO    Frais de poste",null,"Cure Thermale","CT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","MC    Mat. Contrôle < 500€\nMS    Mat. Sécurité < 500€",null,"Décès Conjoint","DC   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","ES     Carburant hors\n          TOTAL",null,"Décès Enfant","DE   "]
[null,null,null,null,null,null,null,null,2," 25 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"PP  Péage/park hors\n          TOTAL",null,"Décès Famille","DF   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PT     Péage/park carte\n       TOTAL non remboursé",null,"Fongecif","FG   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","K      Kilomètres",null,"Congé patho. avant maternité","GP   "]
[null,null,null,null,null,null,null,null,3," 26 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"T      Voyage(avion/train/\n            taxi/métro/bateau/…)",null,"Juré d'Assises","JA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PV    Passeport/Visa\nTL     Téléphonie internet",null,"Jour Supplémentaire","JS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Maladie","MA   "]
[null,null,null,null,null,null,null,null,4," 27 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},null,null,"Mariage Enfant","ME   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","KC =",null,"Mariage Collaborateur","MS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mi temps thérapeutique","MT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","Indiquer chaque fin de mois la différence de Km compteur entre M et M-1",null,"Jour Sans Solde (1 jour)","NE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Paternité","PA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Récupération 1/2 journée","R2   "]

{"sheet":"05","index":4,"n_rows":34,"n_cols":60,"rows_kept":34,"cut":false,"hidden":false,"merged":[[19,1,19,2],[19,3,19,4],[31,19,32,19],[8,1,8,7],[9,8,9,9],[10,0,13,0],[11,2,11,6],[14,0,17,0],[15,2,15,6]]}
[null,null,null,null,null,null,null,null,null,null,"FICHE DE GESTION D'ACTIVITE ET DU TEMPS DE TRAVAIL",null,null,null,null,null,null,null,null,null,null,null," "," ","CP   ","C2   ","RU   ","RT   ","JF   ","F2   ","FP   ","AE   ","AH   ","AJ   ","AN   ","AP   ","AQ   ","AR   ","AT   ","BB   ","CA   ","CN   ","CT   ","DC   ","DE   ","DF   ","FG   ","GP   ","JA   ","JS   ","MA   ","ME   ","MS   ","MT   ","NE   ","PA   ","R2   ","RE   ","SD   ","SE   "]
[null,null,null,null,null,null,null,null,null,null,null,"Non cadre forfait heure / cadre forfait heure",null,null,null,null,null,null,null,null,null,"Congés Payés 1 journée","CP   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Journée Congés Payés","C2   "]
[null,"Nom :","NICOLAS VADEE",null,null,null,null,null,null,"N° Collaborateur :",455781,null,"Visa Chef de Service :",null,null,null,null,null,null,"Semaine :",null,"Jour de RTT","RU   ",null,17.899999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2 Jour de RTT","RT   "]
[null,"CB :","003100",null,null,null,null,null,null,"AG :","020",null,null,null,null,null,null,{"$f":"S6","v":4},4,2017,null,"Jour Férié","JF   "]
[null,null,null,null,null,null,null,null,null,null,"- Le temps de repos quotidien à respecter est d’une durée minimale de 11 heures consécutives ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1/2 journée","F2   "]
[null,null,null,null,null,null,null,null,null,null,"- Toute intervention comprise entre  21 h et 6 h doit être mentionnée distinctement ",null,null,null,null,null,null,null,null,null,null,"Formation Professionnelle 1 Jour","FP   "]
[null,"Déclaration du temps de travail            et de trajet (en H et centièmes d'H)",null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(N11:N34)","v":0},{"$f":"SUM(O11:O34)","v":0},{"$f":"SUM(P11:P34)","v":89.5},null,{"$f":"SUM(R11:R34)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S34)","v":{"$error":"#REF!"}},null,null,"Absence Autorisée payée 1 journée","AE   "]
[null,null,"Lun","Mar","Mer","Jeu","Ven","Sam","Date    jj / mm",null,"CB - affaire - prestation","Client","Lieu d'intervention","UO     prév.","UO     pas.","Montant frais","Nature frais","KM","Km",null,null,"Absence Autorisée payée (saisie Heures)","AH   ","KM / 5","KM / JOUR"]
["M A T  I  N","TE",2.5,2.5,2.5,2.5,2.5,null,null,{"$f":"IF(I11=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I11,\" jj mmm\"))","v":""},null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11)","v":""},{"$f":"IF(Q11=\"RM\",$Y$4,\"\")","v":""},{"$f":"IF(I11=\"\",\"\",\"RM\")","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$X$11,IF(I11=1,$X$12,IF(I11=2,$X$13,IF(I11=3,$X$14,IF(I11=4,$X$15))))))","v":""},{"$f":"IF(I11=\"\",\"\",IF(I11=0,$Y$11,IF(I11=1,$Y$12,IF(I11=2,$Y$13,IF(I11=3,$Y$14,IF(I11=4,$Y$15))))))","v":""},"B       Fourniture bureau\nDO     Documenta., livres",null,"Accident de Trajet","AJ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,0,{"$f":"IF(I12=\"\",\"\",TEXT(DATE($T$6,1,3)-WEEKDAY(DATE($T$6,1,3))-5+(7*$S$6)+I12,\" jj mmm\"))","v":" 23 janv"},null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""},{"$f":"IF(Q12=\"RM\",$Y$4,\"\")","v":17.899999999999999},{"$f":"IF(I12=\"\",\"\",\"RM\")","v":"RM"},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$X$11,IF(I12=1,$X$12,IF(I12=2,$X$13,IF(I12=3,$X$14,IF(I12=4,$X$15))))))","v":{"$error":"#REF!"}},{"$f":"IF(I12=\"\",\"\",IF(I12=0,$Y$11,IF(I12=1,$Y$12,IF(I12=2,$Y$13,IF(I12=3,$Y$14,IF(I12=4,$Y$15))))))","v":{"$error":"#REF!"}},"IE       Invitation Externe\nII         Invitation Interne",null,"Absence Autorisée non payée","AN   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","RM     Déjeuner forfait\nRS       Diner justifié",null,"Absence Autorisée payée 1/2 J.","AP   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","TR       Ticket Restaurant",null,"Régul. Forfait annuel (JOUR)","AQ   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["A. MI D I","TE",5,5,5,5,5,null,null,"",null,null,null,null,"","","","","","HF       Hôtel nuit + petit\n           déjeuner province",null,"Régul. Forfait annuel (1/2 Journée)","AR   ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"TJ","inclus dans le temps de contrôle",null,null,null,null,null,null,"",null,null,null,null,"","","","","","HP       Hôtel nuit + petit\n             déjeuner IdF",null,"Accident de Travail","AT   "]
[null,"Absence",null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","FM       Frais médicaux",null,"Maternité","BB   "]
[null,null,null,null,null,null,null,null,1," 24 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"G1     Entretien VS (2p)",null,"Congé Adoption","CA   "]
[null,"Total J",{"$f":"(C11+C15)","v":7.5},{"$f":"IF(D12+D16<1.5,D11+D15,D11+D12+D15+D16-1.5)","v":7.5},{"$f":"IF(E12+E16<1.5,E11+E15,E11+E12+E15+E16-1.5)","v":7.5},{"$f":"IF(F12+F16<1.5,F11+F15,F11+F12+F15+F16-1.5)","v":7.5},{"$f":"IF(G12+G16<1.5,G11+G15,G11+G12+G15+G16-1.5)","v":7.5},{"$f":"IF(H12+H16<1.5,H11+H15,H11+H12+H15+H16-1.5)","v":0},null,"",null,null,null,null,"","","","","","G2    Entretien VT (4p)\n          ou VP (perso.)",null,null,"CN   "]
[null,"=",null,{"$f":"SUM(C19:H19)","v":37.5},null,null,null,null,null,"",null,null,null,null,"","","","","","FA    Consommables/aff. \nPO    Frais de poste",null,"Cure Thermale","CT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","MC    Mat. Contrôle < 500€\nMS    Mat. Sécurité < 500€",null,"Décès Conjoint","DC   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","ES     Carburant hors\n          TOTAL",null,"Décès Enfant","DE   "]
[null,null,null,null,null,null,null,null,2," 25 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"PP  Péage/park hors\n          TOTAL",null,"Décès Famille","DF   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PT     Péage/park carte\n       TOTAL non remboursé",null,"Fongecif","FG   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","K      Kilomètres",null,"Congé patho. avant maternité","GP   "]
[null,null,null,null,null,null,null,null,3," 26 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},"T      Voyage(avion/train/\n            taxi/métro/bateau/…)",null,"Juré d'Assises","JA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","PV    Passeport/Visa\nTL     Téléphonie internet",null,"Jour Supplémentaire","JS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Maladie","MA   "]
[null,null,null,null,null,null,null,null,4," 27 janv",null,null,null,null,"",17.899999999999999,"RM",{"$error":"#REF!"},{"$error":"#REF!"},null,null,"Mariage Enfant","ME   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","KC =",null,"Mariage Collaborateur","MS   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Mi temps thérapeutique","MT   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","","Indiquer chaque fin de mois la différence de Km compteur entre M et M-1",null,"Jour Sans Solde (1 jour)","NE   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Paternité","PA   "]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","","",null,null,"Récupération 1/2 journée","R2   "]

{"sheet":"heures","index":5,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,24,0,25],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11],[0,12,0,13],[0,14,0,15],[0,16,0,17],[0,18,0,19],[0,20,0,21],[0,22,0,23]]}
[2017,null,"2016-01-01",null,"2016-02-01",null,"2016-03-01",null,"2016-04-01",null,"2016-05-01",null,"2016-06-01",null,"2016-07-01",null,"2016-08-01",null,"2016-09-01",null,"2016-10-01",null,"2016-11-01",null,"2016-12-01"]
[null,1,{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B2),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>1),ADDRESS(11,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B2)),7)-2),\"\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B2),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>1),ADDRESS(15,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B2)),7)-2),\"\")),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B2),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>1),ADDRESS(11,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B2)),7)-2),\"\")),\"\")","v":2.5},{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B2),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B2))<>1),ADDRESS(15,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B2)),7)-2),\"\")),\"\")","v":5}]
[null,2,{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B3),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B3))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B3))<>1),ADDRESS(11,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B3)),7)-2),\"\")),\"\")","v":5},{"$f":"IFERROR(INDIRECT(\"'0\"&WEEKNUM(DATE($A$1,(COLUMN()-1)/2,$B3),2)-1&\"'!\"&IF(AND(WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B3))<>7,WEEKDAY(DATE($A$1,(COLUMN()-1)/2,$B3))<>1),ADDRESS(15,3+MOD(_xlfn.DAYS(DATE($A$1,1,1),DATE($A$1,(COLUMN()-1)/2,$B3)),7)-2),\"\")),\"\")","v":3.22},2.5,5]
[null,3,4,3.88,2.5,5]
[null,4,4,4,"",""]
[null,5,2,3.27,"",""]
[null,6,4,3.88,"",""]
[null,7,"","","",""]
[null,8,"","","",""]
[null,9,3,5,"",""]
[null,10,4,4,"",""]
[null,11,4,3.88,"",""]
[null,12,"CP","CP","",""]
[null,13,"RTT","RTT","",""]
[null,14,"","","",""]
[null,15,"","","",""]
[null,16,4,3.88,"",""]
[null,17,4,3.88,"",""]
[null,18,4,3.88,"",""]
[null,19,4,3.88,"",""]
[null,20,4,3.88,"",""]
[null,21,"","","",""]
[null,22,"","","",""]
[null,23,4,3.88,"",""]
[null,24,4,3.88,"",""]
[null,25,4,3.88,"",""]
[null,26,4,3.88,"",""]
[null,27,4,3.88,"",""]
[null,28,"","","",""]
[null,29,"","","",""]
[null,30,2.5,5,"",""]
[null,31,2.5,5,"",""]