{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Accueil","Liste CDPF","Taux horaire","synthèse","720661 essilor","723806 urgence med","723314 médiathèque","723315 mission pénitentiaire","723775 EPIN"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Accueil","index":0,"n_rows":58,"n_cols":1,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["BIENVENUE DANS LA MOB"]
[]
[]
["Pour faciliter le travail des opérationnels, il a été convenu que certains éléments seront alimentés par les assistantes : "]
[]
["-        Maladies,"]
["-        Entrées et sorties des CDD : Nom, prénom, dates du CDD, motif, répartition."]
[]
["Pour le reste, à vous de l’alimenter en fonction des éléments connus :"]
[]
["-        Absences (CP, ABI…)"]
["-        Heures complémentaires, avpp,  supplémentaires (avec motif), "]
["-        Primes : avec motif."]
[]
[]
["La mob permettra d’avoir un visu sur la vie des sites et en cas d’absence inopinée d’avoir une base de travail pour la paye."]
[]
[]
["Utilisation"]
["Vous êtes actuellement sur TEAMS et certaines fonctionnalités ne vont pas apparaître, pour y remédier veuillez ouvrir le fichier dans excel en cliquant sur le bouton Edition"]
["Vous devrez ensuite activer les modifications"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["pensez à enregistrer régulièrement votre travail en cliquant simplement sur la disquette enregistrer"]
[]
[]
[]
["une fois votre mob remplie, enregistrez une nouvelle fois et fermer le fichier excel: toutes les modifications seront automatiquement mises sur teams."]
[]
["NE JAMAIS FAIRE \"ENREGISTRER SOUS\""]
[]
[]
["ETAPE 1"]
[]
["vérifier que vous avez l'ensemble de vos salariés sur chaque site"]
["les salariés en AVPP et venant d'un autre site seront indiqués sur fond bleu, il est donc indispensable que vous transmettiez les matrices de ces contrats aux assistantes pour ajout"]
["les salariés en cdd seront indiqués sur fond vert"]
[]
["ETAPE 2"]
[]
["indiquer les absences et heures en plus pour chacun des salariés quand il y a lieu, uniquement dans le pointage en ajoutant le motif dans la 4ème ligne (choix déroulant)"]
["ne toucher pas aux colonnes en dehors, les calculs sont faits automatiquement"]
[]
["ETAPE 3"]
[]
["en cas d'indication O au niveau de la colonne AVPP, vous devez réaliser et transmettre un contrat avpp signé aux assistantes pour archivage"]
[]
["ETAPE 4"]
[]
["toutes les heures en plus et les primes exceptionnelles doivent être justifées au niveau de la colonne BD"]
["cela ne vous dispensera pas de transmettre les tableaux de primes et rappels chaque mois pour signature"]

{"sheet":"Liste CDPF","index":1,"n_rows":103,"n_cols":3,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[{"$f":"{\"Accueil\",\"Liste CDPF\",\"720661 essilor\",\"723806 urgence med\",\"723314 médiathèque\",\"723315 mission pénit\",\"723775 EPIN\",\"Taux horaire\",\"synthèse\"}","v":"Accueil"}]
["faire F9 sur cellule A pour actualiser liste ci-dessous"]
[]
[]
[]
[]
[1,{"$f":"IFERROR(INDEX(ListeCDPF,,A7+1),\"\")","v":"Liste CDPF"}]
[2,{"$f":"IFERROR(INDEX(ListeCDPF,,A8+1),\"\")","v":"Taux horaire"},"Taux horaire'!A1"]
[3,"synthèse","synthèse!A1"]
[4,"720661 essilor","720661 essilor'!A1"]
[5,"723806 urgence med","723806 urgence med'!A1"]
[6,"723314 médiathèque","723314 médiathèque'!A1"]
[7,"723315 mission pénitentiaire","723315 mission pénitentiaire'!A1"]
[8,"723775 EPIN","723775 EPIN'!A1"]
[9,""]
[10,""]
[11,""]
[12,""]
[13,""]
[14,""]
[15,""]
[16,""]
[17,""]
[18,""]
[19,""]
[20,""]
[21,""]
[22,""]
[23,""]
[24,""]
[25,""]
[26,""]
[27,""]
[28,""]
[29,""]
[30,""]
[31,""]
[32,""]
[33,""]
[34,""]
[35,""]
[36,""]
[37,""]
[38,""]
[39,""]
[40,""]
[41,""]
[42,""]
[43,""]
[44,""]
[45,""]
[46,""]
[47,""]
[48,""]
[49,""]
[50,""]
[51,""]
[52,""]
[53,""]
[54,""]
[55,""]
[56,""]
[57,""]
[58,""]
[59,""]
[60,""]
[61,""]
[62,""]
[63,""]
[64,""]
[65,""]
[66,{"$f":"IFERROR(INDEX(ListeCDPF,,A72+1),\"\")","v":""}]
[67,""]
[68,""]
[69,""]
[70,""]
[71,""]
[72,""]
[73,""]
[74,""]
[75,""]
[76,""]
[77,""]
[78,""]
[79,""]
[80,""]
[81,""]
[82,""]
[83,""]
[84,""]
[85,""]
[86,""]
[87,""]
[88,""]
[89,""]
[90,""]
[91,""]
[92,""]
[93,""]
[94,""]
[95,""]
[96,""]
[97,""]

{"sheet":"Taux horaire","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["FEP 01/07/2023"]
["FILIERE EXPLOITATION"]
["NIVEAU ","TX/H"]
["APP1",0]
["APP2",0]
["ASPA",11.75,"AS1A"]
["ASPB",11.93,"AS1B"]
["ASCA",11.79,"AS2A"]
["ASCB",12.01,"AS2B"]
["ASCSA",11.86,"AS3A"]
["ASCSB",12.07,"AS3B"]
["AQS1A",11.92]
["AQS1B",12.12]
["AQS2A",12.03]
["AQS2B",12.25]
["AQS3A",12.13]
["AQS3B",12.35]
["ATQS1A",12.36]
["ATQS1B",12.57]
["ATQS2A",13.06]
["ATQS2B",13.29]
["ATQS3A",14.04]
["ATQS3B",14.33]
["CE1",13.55]
["CE2",14.33]
["CE3",14.5]
["MP1",14.56]
["MP2",15.39]
["MP3",17.059999999999999]
["MP4",19.010000000000002]
["MP5",20.55]
[null,0]

{"sheet":"synthèse","index":3,"n_rows":115,"n_cols":5,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Synthèse","v":"Accueil"}]
[]
[null,null,"Budget","Coût total mois","delta"]
[3,{"$f":"IFERROR(INDEX(ListeCDPF,,A5+1),\"\")","v":"720661 essilor"},{"$f":"IFERROR(INDIRECT(\"'\"&$B4&\"'!$Az$2\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&$B4&\"'!$BA$2\"),\"\")","v":17229.773333333334},{"$f":"D4-C4","v":17229.773333333334}]
[4,{"$f":"IFERROR(INDEX(ListeCDPF,,A6+1),\"\")","v":"723806 urgence med"},{"$f":"IFERROR(INDIRECT(\"'\"&$B5&\"'!$Az$2\"),\"\")","v":0},534.625,{"$f":"D5-C5","v":534.625}]
[5,"723314 médiathèque",0,2303.6,2303.6]
[6,"723315 mission pénitentiaire",0,894.07499999999993,894.07499999999993]
[7,"723775 EPIN",0,{"$f":"IFERROR(INDIRECT(\"'\"&$B8&\"'!$BA$2\"),\"\")","v":2214.9959666666668},2214.9959666666668]
[8,"",{"$f":"IFERROR(INDIRECT(\"'\"&$B9&\"'!$Az$2\"),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&$B9&\"'!$BA$2\"),0)","v":0},0]
[9,"",{"$f":"IFERROR(INDIRECT(\"'\"&$B10&\"'!$Az$2\"),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&$B10&\"'!$BA$2\"),0)","v":0},0]
[10,"",0,0,0]
[11,"",0,0,0]
[12,"",0,0,0]
[13,"",0,0,0]
[14,"",0,0,0]
[15,"",0,0,0]
[16,"",0,0,0]
[17,"",0,0,0]
[18,"",0,0,0]
[19,"",0,0,0]
[20,"",0,0,0]
[21,"",0,0,0]
[22,null,0,0,0]
[23,null,0,0,0]
[24,null,0,0,0]
[25,null,0,0,0]
[26,null,0,0,0]
[27,null,0,0,0]
[28,null,0,0,0]
[29,null,0,0,0]
[30,null,0,0,0]
[31,null,0,0,0]
[32,null,0,0,0]
[33,null,0,0,0]
[34,null,0,0,0]
[35,null,0,0,0]
[36,null,0,0,0]
[37,null,0,0,0]
[38,null,0,0,0]
[39,null,0,0,0]
[40,null,0,0,0]
[41,null,0,0,0]
[42,null,0,0,0]
[43,null,0,0,0]
[44,null,0,0,0]
[45,null,0,0,0]
[46,null,0,0,0]
[47,null,0,0,0]
[48,null,0,0,0]
[49,null,0,0,0]
[50,null,0,0,0]
[51,null,0,0,0]
[52,null,0,0,0]
[53,null,0,0,0]
[54,null,0,0,0]
[55,null,0,0,0]
[56,null,0,0,0]
[57,null,0,0,0]
[58,null,0,0,0]
[59,null,0,0,0]
[60,null,0,0,0]
[61,null,0,0,0]
[62,null,0,0,0]
[63,null,0,0,0]
[64,null,0,0,0]
[65,null,0,0,0]
[66,null,0,0,0]
[67,null,0,0,0]
[68,null,0,0,{"$f":"D69-C69","v":0}]
[69,null,0,0,0]
[70,null,0,0,0]
[71,null,0,0,0]
[72,null,0,0,0]
[73,null,{"$f":"IFERROR(INDIRECT(\"'\"&$B74&\"'!$Az$2\"),0)","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&$B74&\"'!$BA$2\"),0)","v":0},0]
[74,null,0,0,0]
[75,null,0,0,0]
[76,null,0,0,0]
[77,null,0,0,0]
[78,null,0,0,0]
[79,null,0,0,0]
[80,null,0,0,0]
[81,null,0,0,0]
[82,null,0,0,0]
[83,null,0,0,0]
[84,null,0,0,0]
[85,null,0,0,0]
[86,null,0,0,0]
[87,null,0,0,0]
[88,null,0,0,0]
[89,null,0,0,0]
[90,null,0,0,0]
[91,null,0,0,0]
[92,null,0,0,0]
[93,null,0,0,0]
[94,null,0,0,0]
[95,null,0,0,0]
[96,null,0,0,0]
[97,null,0,0,0]
[98,null,0,0,0]
[99,null,0,0,0]
[100,null,0,0,0]
[101,null,0,0,0]
[102,null,0,0,0]
[103,null,0,0,0]
[104,null,0,0,0]
[105,null,0,0,0]
[106,null,0,0,0]
[107,null,0,0,0]
[108,null,0,0,0]
[109,null,0,0,0]
[110,null,0,0,0]
[111,null,0,0,0]
[112,null,0,0,0]
[113,null,0,0,0]
[114,null,0,0,0]

{"sheet":"720661 essilor","index":4,"n_rows":115,"n_cols":56,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"²"]
[720661,"ESSILOR",null,null,null,null,null,null,"2019-08-05","2019-08-06","2019-08-07","2019-08-01","2019-08-02","2019-08-03","2019-08-04",null,null,{"$f":"H1","v":"2023-09-01"},{"$f":"R2+1","v":"2023-09-02"},{"$f":"S2+1","v":"2023-09-03"},"2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",{"$f":"#REF!+1","v":{"$error":"#REF!"}},{"$f":"AW2+1","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(BA115,BA111,BA107,BA103,BA91,BA87,BA83,BA79,BA75,BA71,BA67,BA63,BA59,BA55,BA51,BA47,BA43,BA39,BA35,BA31,BA27,BA23,BA19,BA15,BA11,BA7)+SUM(BC4:BC115)","v":17229.773333333334}]
["Nom","Prénom","CDD \n- \nCDI","QUALIFICATION","Taux Horaire","Commentaire","Libellé",{"$f":"+H1","v":"2023-09-01"},1,2,3,4,5,6,7,null,null,{"$f":"+R2","v":"2023-09-01"},{"$f":"+S2","v":"2023-09-02"},"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",null,"H travaillées mois","Libellé","Total heures mois","Coût total mois","AVPP","Primes","justification H Plus et Primes"]
["OULAI GOUALI","BOUDOU PAULINE","CDI","ASCA",{"$f":"VLOOKUP(D4,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",65,2.5,2.5,2.5,2.5,2.5,"R","R",null,null,3,{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},3,3,3,3,3,{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},3,3,3,3,3,{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},3,3,3,3,3,{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},3,3,3,3,3,{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},"h contrat",{"$f":"H4","v":65},"HEURE CAT",{"$f":"+H4","v":65},{"$f":"AZ4*E4","v":766.34999999999991}]
[null,null,{"$f":"+C4","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R4:AV4)","v":63},"H. ABS",{"$f":"SUM(R5:AV5)","v":0},{"$f":"AZ5*E5","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX5-AZ5+AZ6","v":63},"H. SUP / COMP",{"$f":"SUM(R6:AV6)","v":0},{"$f":"IF(H4<35*52/12,IF(BB6=\"O\",AZ6*1.1*E6,AZ6*1.11*E6),AZ6*1.25*E6)","v":0},{"$f":"IF(C4=\"CDI\",IF(AZ6<AZ4*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX6","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX6=0,0,BA4-BA5+BA6)","v":766.34999999999991}]
["BA","MAHAMADOU","CDI","AQS1A",{"$f":"VLOOKUP(D8,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.92},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I8:O8))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},"h contrat",{"$f":"H8","v":65},"HEURE CAT",{"$f":"+H8","v":65},{"$f":"AZ8*E8","v":774.8}]
[null,null,{"$f":"+C8","v":"CDI"},"AQS1A",11.92,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R8:AV8)","v":63},"H. ABS",{"$f":"SUM(R9:AV9)","v":0},{"$f":"AZ9*E9","v":0}]
[null,null,"CDI","AQS1A",11.92,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX9-AZ9+AZ10","v":63},"H. SUP",{"$f":"SUM(R10:AV10)","v":0},{"$f":"IF(H8<35*52/12,IF(BB10=\"O\",AZ10*1.1*E10,AZ10*1.11*E10),AZ10*1.25*E10)","v":0},{"$f":"IF(C8=\"CDI\",IF(AZ10<AZ8*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","AQS1A",11.92,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX10","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX10=0,0,BA8-BA9+BA10)","v":774.8}]
["BERRAHEL","ZAHIA","CDI","ASCA",{"$f":"VLOOKUP(D12,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I12:O12))*52/12","v":130},6,6,6,6,6,"R","R",null,null,{"$f":"+$M12","v":6},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":6},{"$f":"+$J12","v":6},{"$f":"+$K12","v":6},{"$f":"+$L12","v":6},{"$f":"+$M12","v":6},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":6},{"$f":"+$J12","v":6},{"$f":"+$K12","v":6},{"$f":"+$L12","v":6},{"$f":"+$M12","v":6},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":6},{"$f":"+$J12","v":6},{"$f":"+$K12","v":6},{"$f":"+$L12","v":6},{"$f":"+$M12","v":6},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":6},{"$f":"+$J12","v":6},{"$f":"+$K12","v":6},{"$f":"+$L12","v":6},{"$f":"+$M12","v":6},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},"h contrat",{"$f":"H12","v":130},"HEURE CAT",{"$f":"+H12","v":130},{"$f":"AZ12*E12","v":1532.6999999999998}]
[null,null,{"$f":"+C12","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R12:AV12)","v":126},"H. ABS",{"$f":"SUM(R13:AV13)","v":0},{"$f":"AZ13*E13","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX13-AZ13+AZ14","v":126},"H. SUP",{"$f":"SUM(R14:AV14)","v":0},{"$f":"IF(H12<35*52/12,IF(BB14=\"O\",AZ14*1.1*E14,AZ14*1.11*E14),AZ14*1.25*E14)","v":0},{"$f":"IF(C12=\"CDI\",IF(AZ14<AZ12*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX14","v":126},"MOTIF/TOT MOB",null,{"$f":"IF(AX14=0,0,BA12-BA13+BA14)","v":1532.6999999999998}]
["CHACHOUA","MEBROUK","CDI","ASCA",{"$f":"VLOOKUP(D16,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I16:O16))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},"h contrat",{"$f":"H16","v":65},null,{"$f":"+H16","v":65},{"$f":"AZ16*E16","v":766.34999999999991}]
[null,null,{"$f":"+C16","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R16:AV16)","v":63},"H. ABS",{"$f":"SUM(R17:AV17)","v":0},{"$f":"AZ17*E17","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX17-AZ17+AZ18","v":63},"H. SUP",{"$f":"SUM(R18:AV18)","v":0},{"$f":"IF(H16<35*52/12,IF(BB18=\"O\",AZ18*1.1*E18,AZ18*1.11*E18),AZ18*1.25*E18)","v":0},{"$f":"IF(C16=\"CDI\",IF(AZ18<AZ16*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX18","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX18=0,0,BA16-BA17+BA18)","v":766.34999999999991}]
["CHIFOR","MOHAMED","CDI","CE1",{"$f":"VLOOKUP(D20,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":13.55},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I20:O20))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M20","v":3},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":3},{"$f":"+$J20","v":3},{"$f":"+$K20","v":3},{"$f":"+$L20","v":3},{"$f":"+$M20","v":3},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":3},{"$f":"+$J20","v":3},{"$f":"+$K20","v":3},{"$f":"+$L20","v":3},{"$f":"+$M20","v":3},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":3},{"$f":"+$J20","v":3},{"$f":"+$K20","v":3},{"$f":"+$L20","v":3},{"$f":"+$M20","v":3},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":3},{"$f":"+$J20","v":3},{"$f":"+$K20","v":3},{"$f":"+$L20","v":3},{"$f":"+$M20","v":3},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},"h contrat",{"$f":"H20","v":65},"HEURE CAT",{"$f":"+H20","v":65},{"$f":"AZ20*E20","v":880.75}]
[null,null,{"$f":"+C20","v":"CDI"},"CE1",13.55,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,3,null,null,3,3,3,3,3,null,null,3,3,3,3,3,null,null,3,3,3,3,3,null,null,3,3,3,3,3,null,null,"h travaillable",{"$f":"SUM(R20:AV20)","v":63},"H. ABS",{"$f":"SUM(R21:AV21)","v":63},{"$f":"AZ21*E21","v":853.65000000000009}]
[null,null,"CDI","CE1",13.55,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX21-AZ21+AZ22","v":0},"H. SUP",{"$f":"SUM(R22:AV22)","v":0},{"$f":"IF(H20<35*52/12,IF(BB22=\"O\",AZ22*1.1*E22,AZ22*1.11*E22),AZ22*1.25*E22)","v":0},{"$f":"IF(C20=\"CDI\",IF(AZ22<AZ20*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","CE1",13.55,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,"CP",null,null,"CP","CP","CP","CP","CP",null,null,"AANP","AANP","AANP","AANP","AANP",null,null,"AANP","AANP","AANP","AANP","AANP",null,null,"AANP","AANP","AANP","AANP","AANP",null,null,"h du mois",{"$f":"AX22","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX22=0,0,BA20-BA21+BA22)","v":0}]
["DA SILVA SEMEDO","JULIANA","CDI","ASCA",{"$f":"VLOOKUP(D24,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I24:O24))*52/12","v":65},3,3,3,3,3,"R","R",null,null,3,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},3,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},3,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},3,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},3,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},"h contrat",{"$f":"H24","v":65},"HEURE CAT",{"$f":"+H24","v":65},{"$f":"AZ24*E24","v":766.34999999999991}]
[null,null,{"$f":"+C24","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R24:AV24)","v":63},"H. ABS",{"$f":"SUM(R25:AV25)","v":0},{"$f":"AZ25*E25","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX25-AZ25+AZ26","v":63},"H. SUP",{"$f":"SUM(R26:AV26)","v":0},{"$f":"IF(H24<35*52/12,IF(BB26=\"O\",AZ26*1.1*E26,AZ26*1.11*E26),AZ26*1.25*E26)","v":0},{"$f":"IF(C24=\"CDI\",IF(AZ26<AZ24*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX26","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX26=0,0,BA24-BA25+BA26)","v":766.34999999999991}]
["DASH","NITHYA","CDI","ASCA",{"$f":"VLOOKUP(D28,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I28:O28))*52/12","v":130},6,6,6,6,6,"R","R",null,null,{"$f":"+$M28","v":6},{"$f":"+$N28","v":"R"},{"$f":"+$O28","v":"R"},{"$f":"+$I28","v":6},{"$f":"+$J28","v":6},{"$f":"+$K28","v":6},{"$f":"+$L28","v":6},{"$f":"+$M28","v":6},{"$f":"+$N28","v":"R"},{"$f":"+$O28","v":"R"},{"$f":"+$I28","v":6},{"$f":"+$J28","v":6},{"$f":"+$K28","v":6},{"$f":"+$L28","v":6},{"$f":"+$M28","v":6},{"$f":"+$N28","v":"R"},{"$f":"+$O28","v":"R"},{"$f":"+$I28","v":6},{"$f":"+$J28","v":6},{"$f":"+$K28","v":6},{"$f":"+$L28","v":6},{"$f":"+$M28","v":6},{"$f":"+$N28","v":"R"},{"$f":"+$O28","v":"R"},{"$f":"+$I28","v":6},{"$f":"+$J28","v":6},{"$f":"+$K28","v":6},{"$f":"+$L28","v":6},{"$f":"+$M28","v":6},{"$f":"+$N28","v":"R"},{"$f":"+$O28","v":"R"},"h contrat",{"$f":"H28","v":130},"HEURE CAT",{"$f":"+H28","v":130},{"$f":"AZ28*E28","v":1532.6999999999998}]
[null,null,{"$f":"+C28","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R28:AV28)","v":126},"H. ABS",{"$f":"SUM(R29:AV29)","v":0},{"$f":"AZ29*E29","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX29-AZ29+AZ30","v":126},"H. SUP",{"$f":"SUM(R30:AV30)","v":0},{"$f":"IF(H28<35*52/12,IF(BB30=\"O\",AZ30*1.1*E30,AZ30*1.11*E30),AZ30*1.25*E30)","v":0},{"$f":"IF(C28=\"CDI\",IF(AZ30<AZ28*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX30","v":126},"MOTIF/TOT MOB",null,{"$f":"IF(AX30=0,0,BA28-BA29+BA30)","v":1532.6999999999998}]
["DOS SANTOS CARVALHERO","MARIA HELENA","CDI","ASCA",{"$f":"VLOOKUP(D32,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I32:O32))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M32","v":3},{"$f":"+$N32","v":"R"},{"$f":"+$O32","v":"R"},{"$f":"+$I32","v":3},{"$f":"+$J32","v":3},{"$f":"+$K32","v":3},{"$f":"+$L32","v":3},{"$f":"+$M32","v":3},{"$f":"+$N32","v":"R"},{"$f":"+$O32","v":"R"},{"$f":"+$I32","v":3},{"$f":"+$J32","v":3},{"$f":"+$K32","v":3},{"$f":"+$L32","v":3},{"$f":"+$M32","v":3},{"$f":"+$N32","v":"R"},{"$f":"+$O32","v":"R"},{"$f":"+$I32","v":3},{"$f":"+$J32","v":3},{"$f":"+$K32","v":3},{"$f":"+$L32","v":3},{"$f":"+$M32","v":3},{"$f":"+$N32","v":"R"},{"$f":"+$O32","v":"R"},{"$f":"+$I32","v":3},{"$f":"+$J32","v":3},{"$f":"+$K32","v":3},{"$f":"+$L32","v":3},{"$f":"+$M32","v":3},{"$f":"+$N32","v":"R"},{"$f":"+$O32","v":"R"},"h contrat",{"$f":"H32","v":65},"HEURE CAT",{"$f":"+H32","v":65},{"$f":"AZ32*E32","v":766.34999999999991}]
[null,null,{"$f":"+C32","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R32:AV32)","v":63},"H. ABS",{"$f":"SUM(R33:AV33)","v":0},{"$f":"AZ33*E33","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX33-AZ33+AZ34","v":63},"H. SUP",{"$f":"SUM(R34:AV34)","v":0},{"$f":"IF(H32<35*52/12,IF(BB34=\"O\",AZ34*1.1*E34,AZ34*1.11*E34),AZ34*1.25*E34)","v":0},{"$f":"IF(C32=\"CDI\",IF(AZ34<AZ32*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX34","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX34=0,0,BA32-BA33+BA34)","v":766.34999999999991}]
["GOZUKARA","FIDAN","CDI","ASCA",{"$f":"VLOOKUP(D36,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},"MALADIE PRO ","HEURE CAT",{"$f":"(SUBTOTAL(9,I36:O36))*52/12","v":54.166666666666664},2.5,2.5,2.5,2.5,2.5,"R","R",null,null,{"$f":"+$M36","v":2.5},{"$f":"+$N36","v":"R"},{"$f":"+$O36","v":"R"},{"$f":"+$I36","v":2.5},{"$f":"+$J36","v":2.5},{"$f":"+$K36","v":2.5},{"$f":"+$L36","v":2.5},{"$f":"+$M36","v":2.5},{"$f":"+$N36","v":"R"},{"$f":"+$O36","v":"R"},{"$f":"+$I36","v":2.5},{"$f":"+$J36","v":2.5},{"$f":"+$K36","v":2.5},{"$f":"+$L36","v":2.5},{"$f":"+$M36","v":2.5},{"$f":"+$N36","v":"R"},{"$f":"+$O36","v":"R"},{"$f":"+$I36","v":2.5},{"$f":"+$J36","v":2.5},{"$f":"+$K36","v":2.5},{"$f":"+$L36","v":2.5},{"$f":"+$M36","v":2.5},{"$f":"+$N36","v":"R"},{"$f":"+$O36","v":"R"},{"$f":"+$I36","v":2.5},{"$f":"+$J36","v":2.5},{"$f":"+$K36","v":2.5},{"$f":"+$L36","v":2.5},{"$f":"+$M36","v":2.5},{"$f":"+$N36","v":"R"},{"$f":"+$O36","v":"R"},"h contrat",{"$f":"H36","v":54.166666666666664},"HEURE CAT",{"$f":"+H36","v":54.166666666666664},{"$f":"AZ36*E36","v":638.62499999999989}]
[null,null,{"$f":"+C36","v":"CDI"},"ASCA",11.79,"jusqua'au 30/09","H. ABS",null,null,null,null,null,null,null,null,null,null,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,"h travaillable",{"$f":"SUM(R36:AV36)","v":52.5},"H. ABS",{"$f":"SUM(R37:AV37)","v":52.5},{"$f":"AZ37*E37","v":618.97499999999991}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX37-AZ37+AZ38","v":0},"H. SUP",{"$f":"SUM(R38:AV38)","v":0},{"$f":"IF(H36<35*52/12,IF(BB38=\"O\",AZ38*1.1*E38,AZ38*1.11*E38),AZ38*1.25*E38)","v":0},{"$f":"IF(C36=\"CDI\",IF(AZ38<AZ36*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,"MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"h du mois",{"$f":"AX38","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX38=0,0,BA36-BA37+BA38)","v":0}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D40,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I40:O40))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M40","v":0},{"$f":"+$N40","v":"R"},{"$f":"+$O40","v":"R"},{"$f":"+$I40","v":0},{"$f":"+$J40","v":0},{"$f":"+$K40","v":0},{"$f":"+$L40","v":0},{"$f":"+$M40","v":0},{"$f":"+$N40","v":"R"},{"$f":"+$O40","v":"R"},3,3,3,3,3,{"$f":"+$N40","v":"R"},{"$f":"+$O40","v":"R"},3,3,3,3,3,{"$f":"+$N40","v":"R"},{"$f":"+$O40","v":"R"},3,3,3,3,3,{"$f":"+$N40","v":"R"},{"$f":"+$O40","v":"R"},"h contrat",{"$f":"H40","v":0},"HEURE CAT",{"$f":"+H40","v":0},{"$f":"AZ40*E40","v":0}]
[null,null,{"$f":"+C40","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R40:AV40)","v":45},"H. ABS",{"$f":"SUM(R41:AV41)","v":0},{"$f":"AZ41*E41","v":0}]
[null,null,0,"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX41-AZ41+AZ42","v":45},"H. SUP",{"$f":"SUM(R42:AV42)","v":0},{"$f":"IF(H40<35*52/12,IF(BB42=\"O\",AZ42*1.1*E42,AZ42*1.11*E42),AZ42*1.25*E42)","v":0},{"$f":"IF(C40=\"CDI\",IF(AZ42<AZ40*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,0,"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX42","v":45},"MOTIF/TOT MOB",null,{"$f":"IF(AX42=0,0,BA40-BA41+BA42)","v":0}]
["LOPES DA MOURA","GRACINDA","CDI","ASCA",{"$f":"VLOOKUP(D44,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I44:O44))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M44","v":3},{"$f":"+$N44","v":"R"},{"$f":"+$O44","v":"R"},{"$f":"+$I44","v":3},{"$f":"+$J44","v":3},{"$f":"+$K44","v":3},{"$f":"+$L44","v":3},{"$f":"+$M44","v":3},{"$f":"+$N44","v":"R"},{"$f":"+$O44","v":"R"},{"$f":"+$I44","v":3},{"$f":"+$J44","v":3},{"$f":"+$K44","v":3},{"$f":"+$L44","v":3},{"$f":"+$M44","v":3},{"$f":"+$N44","v":"R"},{"$f":"+$O44","v":"R"},{"$f":"+$I44","v":3},{"$f":"+$J44","v":3},{"$f":"+$K44","v":3},{"$f":"+$L44","v":3},{"$f":"+$M44","v":3},{"$f":"+$N44","v":"R"},{"$f":"+$O44","v":"R"},{"$f":"+$I44","v":3},{"$f":"+$J44","v":3},{"$f":"+$K44","v":3},{"$f":"+$L44","v":3},{"$f":"+$M44","v":3},{"$f":"+$N44","v":"R"},{"$f":"+$O44","v":"R"},"h contrat",{"$f":"H44","v":65},"HEURE CAT",{"$f":"+H44","v":65},{"$f":"AZ44*E44","v":766.34999999999991}]
[null,null,{"$f":"+C44","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R44:AV44)","v":63},"H. ABS",{"$f":"SUM(R45:AV45)","v":0},{"$f":"AZ45*E45","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX45-AZ45+AZ46","v":63},"H. SUP",{"$f":"SUM(R46:AV46)","v":0},{"$f":"IF(H44<35*52/12,IF(BB46=\"O\",AZ46*1.1*E46,AZ46*1.11*E46),AZ46*1.25*E46)","v":0},{"$f":"IF(C44=\"CDI\",IF(AZ46<AZ44*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX46","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX46=0,0,BA44-BA45+BA46)","v":766.34999999999991}]
["MAALAOUI","FADHILA","CDI","ASCA",{"$f":"VLOOKUP(D48,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I48:O48))*52/12","v":75.833333333333329},3.5,3.5,3.5,3.5,3.5,"R","R",null,null,{"$f":"+$M48","v":3.5},{"$f":"+$N48","v":"R"},{"$f":"+$O48","v":"R"},{"$f":"+$I48","v":3.5},{"$f":"+$J48","v":3.5},{"$f":"+$K48","v":3.5},{"$f":"+$L48","v":3.5},{"$f":"+$M48","v":3.5},{"$f":"+$N48","v":"R"},{"$f":"+$O48","v":"R"},{"$f":"+$I48","v":3.5},{"$f":"+$J48","v":3.5},{"$f":"+$K48","v":3.5},{"$f":"+$L48","v":3.5},{"$f":"+$M48","v":3.5},{"$f":"+$N48","v":"R"},{"$f":"+$O48","v":"R"},{"$f":"+$I48","v":3.5},{"$f":"+$J48","v":3.5},{"$f":"+$K48","v":3.5},{"$f":"+$L48","v":3.5},{"$f":"+$M48","v":3.5},{"$f":"+$N48","v":"R"},{"$f":"+$O48","v":"R"},{"$f":"+$I48","v":3.5},{"$f":"+$J48","v":3.5},{"$f":"+$K48","v":3.5},{"$f":"+$L48","v":3.5},{"$f":"+$M48","v":3.5},{"$f":"+$N48","v":"R"},{"$f":"+$O48","v":"R"},"h contrat",{"$f":"H48","v":75.833333333333329},"HEURE CAT",{"$f":"+H48","v":75.833333333333329},{"$f":"AZ48*E48","v":894.07499999999993}]
[null,null,{"$f":"+C48","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R48:AV48)","v":73.5},"H. ABS",{"$f":"SUM(R49:AV49)","v":0},{"$f":"AZ49*E49","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX49-AZ49+AZ50","v":73.5},"H. SUP",{"$f":"SUM(R50:AV50)","v":0},{"$f":"IF(H48<35*52/12,IF(BB50=\"O\",AZ50*1.1*E50,AZ50*1.11*E50),AZ50*1.25*E50)","v":0},{"$f":"IF(C48=\"CDI\",IF(AZ50<AZ48*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX50","v":73.5},"MOTIF/TOT MOB",null,{"$f":"IF(AX50=0,0,BA48-BA49+BA50)","v":894.07499999999993}]
["NOUALI","SAIDA","CDI","ASCA",{"$f":"VLOOKUP(D52,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I52:O52))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M52","v":3},{"$f":"+$N52","v":"R"},{"$f":"+$O52","v":"R"},{"$f":"+$I52","v":3},{"$f":"+$J52","v":3},{"$f":"+$K52","v":3},{"$f":"+$L52","v":3},{"$f":"+$M52","v":3},{"$f":"+$N52","v":"R"},{"$f":"+$O52","v":"R"},{"$f":"+$I52","v":3},{"$f":"+$J52","v":3},{"$f":"+$K52","v":3},{"$f":"+$L52","v":3},{"$f":"+$M52","v":3},{"$f":"+$N52","v":"R"},{"$f":"+$O52","v":"R"},{"$f":"+$I52","v":3},{"$f":"+$J52","v":3},{"$f":"+$K52","v":3},{"$f":"+$L52","v":3},{"$f":"+$M52","v":3},{"$f":"+$N52","v":"R"},{"$f":"+$O52","v":"R"},{"$f":"+$I52","v":3},{"$f":"+$J52","v":3},{"$f":"+$K52","v":3},{"$f":"+$L52","v":3},{"$f":"+$M52","v":3},{"$f":"+$N52","v":"R"},{"$f":"+$O52","v":"R"},"h contrat",{"$f":"H52","v":65},"HEURE CAT",{"$f":"+H52","v":65},{"$f":"AZ52*E52","v":766.34999999999991}]
[null,null,{"$f":"+C52","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R52:AV52)","v":63},"H. ABS",{"$f":"SUM(R53:AV53)","v":0},{"$f":"AZ53*E53","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX53-AZ53+AZ54","v":63},"H. SUP",{"$f":"SUM(R54:AV54)","v":0},{"$f":"IF(H52<35*52/12,IF(BB54=\"O\",AZ54*1.1*E54,AZ54*1.11*E54),AZ54*1.25*E54)","v":0},{"$f":"IF(C52=\"CDI\",IF(AZ54<AZ52*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX54","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX54=0,0,BA52-BA53+BA54)","v":766.34999999999991}]
["MESSI","NATHALIE","CDI","MP1",13.18,null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I56:O56))*52/12","v":151.66666666666666},7,7,7,7,7,"R","R",null,null,{"$f":"+$M56","v":7},{"$f":"+$N56","v":"R"},{"$f":"+$O56","v":"R"},{"$f":"+$I56","v":7},{"$f":"+$J56","v":7},{"$f":"+$K56","v":7},{"$f":"+$L56","v":7},{"$f":"+$M56","v":7},{"$f":"+$N56","v":"R"},{"$f":"+$O56","v":"R"},{"$f":"+$I56","v":7},{"$f":"+$J56","v":7},{"$f":"+$K56","v":7},{"$f":"+$L56","v":7},{"$f":"+$M56","v":7},{"$f":"+$N56","v":"R"},{"$f":"+$O56","v":"R"},{"$f":"+$I56","v":7},{"$f":"+$J56","v":7},{"$f":"+$K56","v":7},{"$f":"+$L56","v":7},{"$f":"+$M56","v":7},{"$f":"+$N56","v":"R"},{"$f":"+$O56","v":"R"},{"$f":"+$I56","v":7},{"$f":"+$J56","v":7},{"$f":"+$K56","v":7},{"$f":"+$L56","v":7},{"$f":"+$M56","v":7},{"$f":"+$N56","v":"R"},{"$f":"+$O56","v":"R"},"h contrat",{"$f":"H56","v":151.66666666666666},"HEURE CAT",{"$f":"+H56","v":151.66666666666666},{"$f":"AZ56*E56","v":1998.9666666666665}]
[null,null,{"$f":"+C56","v":"CDI"},"MP1",13.18,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R56:AV56)","v":147},"H. ABS",{"$f":"SUM(R57:AV57)","v":0},{"$f":"AZ57*E57","v":0}]
[null,null,"CDI","MP1",13.18,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX57-AZ57+AZ58","v":147},"H. SUP",{"$f":"SUM(R58:AV58)","v":0},{"$f":"IF(H56<35*52/12,IF(BB58=\"O\",AZ58*1.1*E58,AZ58*1.11*E58),AZ58*1.25*E58)","v":0},{"$f":"IF(C56=\"CDI\",IF(AZ58<AZ56*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","MP1",13.18,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX58","v":147},"MOTIF/TOT MOB",null,{"$f":"IF(AX58=0,0,BA56-BA57+BA58)","v":1998.9666666666665}]
["MLADENOVIC","BRANKA","CDI","CE1",{"$f":"VLOOKUP(D60,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":13.55},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I60:O60))*52/12","v":151.66666666666666},7,7,7,7,7,"R","R",null,null,{"$f":"+$M60","v":7},{"$f":"+$N60","v":"R"},{"$f":"+$O60","v":"R"},{"$f":"+$I60","v":7},{"$f":"+$J60","v":7},{"$f":"+$K60","v":7},{"$f":"+$L60","v":7},{"$f":"+$M60","v":7},{"$f":"+$N60","v":"R"},{"$f":"+$O60","v":"R"},{"$f":"+$I60","v":7},{"$f":"+$J60","v":7},{"$f":"+$K60","v":7},{"$f":"+$L60","v":7},{"$f":"+$M60","v":7},{"$f":"+$N60","v":"R"},{"$f":"+$O60","v":"R"},{"$f":"+$I60","v":7},{"$f":"+$J60","v":7},{"$f":"+$K60","v":7},{"$f":"+$L60","v":7},{"$f":"+$M60","v":7},{"$f":"+$N60","v":"R"},{"$f":"+$O60","v":"R"},{"$f":"+$I60","v":7},{"$f":"+$J60","v":7},{"$f":"+$K60","v":7},{"$f":"+$L60","v":7},{"$f":"+$M60","v":7},{"$f":"+$N60","v":"R"},{"$f":"+$O60","v":"R"},"h contrat",{"$f":"H60","v":151.66666666666666},"HEURE CAT",{"$f":"+H60","v":151.66666666666666},{"$f":"AZ60*E60","v":2055.0833333333335}]
[null,null,{"$f":"+C60","v":"CDI"},"CE1",13.55,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R60:AV60)","v":147},"H. ABS",{"$f":"SUM(R61:AV61)","v":0},{"$f":"AZ61*E61","v":0}]
[null,null,"CDI","CE1",13.55,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX61-AZ61+AZ62","v":147},"H. SUP",{"$f":"SUM(R62:AV62)","v":0},{"$f":"IF(H60<35*52/12,IF(BB62=\"O\",AZ62*1.1*E62,AZ62*1.11*E62),AZ62*1.25*E62)","v":0},{"$f":"IF(C60=\"CDI\",IF(AZ62<AZ60*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","CE1",13.55,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX62","v":147},"MOTIF/TOT MOB",null,{"$f":"IF(AX62=0,0,BA60-BA61+BA62)","v":2055.0833333333335}]
["SACKO","MAHAMADOU","CDI","ASCA",{"$f":"VLOOKUP(D64,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I64:O64))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M64","v":3},{"$f":"+$N64","v":"R"},{"$f":"+$O64","v":"R"},{"$f":"+$I64","v":3},{"$f":"+$J64","v":3},{"$f":"+$K64","v":3},{"$f":"+$L64","v":3},{"$f":"+$M64","v":3},{"$f":"+$N64","v":"R"},{"$f":"+$O64","v":"R"},{"$f":"+$I64","v":3},{"$f":"+$J64","v":3},{"$f":"+$K64","v":3},{"$f":"+$L64","v":3},{"$f":"+$M64","v":3},{"$f":"+$N64","v":"R"},{"$f":"+$O64","v":"R"},{"$f":"+$I64","v":3},{"$f":"+$J64","v":3},{"$f":"+$K64","v":3},{"$f":"+$L64","v":3},{"$f":"+$M64","v":3},{"$f":"+$N64","v":"R"},{"$f":"+$O64","v":"R"},{"$f":"+$I64","v":3},{"$f":"+$J64","v":3},{"$f":"+$K64","v":3},{"$f":"+$L64","v":3},{"$f":"+$M64","v":3},{"$f":"+$N64","v":"R"},{"$f":"+$O64","v":"R"},"h contrat",{"$f":"H64","v":65},"HEURE CAT",{"$f":"+H64","v":65},{"$f":"AZ64*E64","v":766.34999999999991}]
[null,null,{"$f":"+C64","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R64:AV64)","v":63},"H. ABS",{"$f":"SUM(R65:AV65)","v":0},{"$f":"AZ65*E65","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX65-AZ65+AZ66","v":63},"H. SUP",{"$f":"SUM(R66:AV66)","v":0},{"$f":"IF(H64<35*52/12,IF(BB66=\"O\",AZ66*1.1*E66,AZ66*1.11*E66),AZ66*1.25*E66)","v":0},{"$f":"IF(C64=\"CDI\",IF(AZ66<AZ64*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX66","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX66=0,0,BA64-BA65+BA66)","v":766.34999999999991}]
["SIMAGA","ANSOUMANY","CDI","ASCA",{"$f":"VLOOKUP(D68,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I68:O68))*52/12","v":69.333333333333329},3,3,3,3,4,"R","R",null,null,{"$f":"+$M68","v":4},{"$f":"+$N68","v":"R"},{"$f":"+$O68","v":"R"},{"$f":"+$I68","v":3},{"$f":"+$J68","v":3},{"$f":"+$K68","v":3},{"$f":"+$L68","v":3},{"$f":"+$M68","v":4},{"$f":"+$N68","v":"R"},{"$f":"+$O68","v":"R"},{"$f":"+$I68","v":3},{"$f":"+$J68","v":3},{"$f":"+$K68","v":3},{"$f":"+$L68","v":3},{"$f":"+$M68","v":4},{"$f":"+$N68","v":"R"},{"$f":"+$O68","v":"R"},{"$f":"+$I68","v":3},{"$f":"+$J68","v":3},{"$f":"+$K68","v":3},{"$f":"+$L68","v":3},{"$f":"+$M68","v":4},{"$f":"+$N68","v":"R"},{"$f":"+$O68","v":"R"},{"$f":"+$I68","v":3},{"$f":"+$J68","v":3},{"$f":"+$K68","v":3},{"$f":"+$L68","v":3},{"$f":"+$M68","v":4},{"$f":"+$N68","v":"R"},{"$f":"+$O68","v":"R"},"h contrat",{"$f":"H68","v":69.333333333333329},"HEURE CAT",{"$f":"+H68","v":69.333333333333329},{"$f":"AZ68*E68","v":817.43999999999994}]
[null,null,{"$f":"+C68","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,"h travaillable",{"$f":"SUM(R68:AV68)","v":68},"H. ABS",{"$f":"SUM(R69:AV69)","v":5},{"$f":"AZ69*E69","v":58.949999999999996}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX69-AZ69+AZ70","v":63},"H. SUP",{"$f":"SUM(R70:AV70)","v":0},{"$f":"IF(H68<35*52/12,IF(BB70=\"O\",AZ70*1.1*E70,AZ70*1.11*E70),AZ70*1.25*E70)","v":0},{"$f":"IF(C68=\"CDI\",IF(AZ70<AZ68*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C70","v":"CDI"},{"$f":"+D70","v":"ASCA"},{"$f":"+E70","v":11.79},null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,"ABI",null,null,null,null,null,null,"ABI",null,null,null,null,null,null,"ABI",null,null,null,null,null,null,"ABI",null,null,null,null,null,null,"ABI",null,null,"h du mois",{"$f":"AX70","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX70=0,0,BA68-BA69+BA70)","v":758.4899999999999}]
["TANDIA","MAMEDY","CDI","ASCA",{"$f":"VLOOKUP(D72,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I72:O72))*52/12","v":54.166666666666664},2.5,2.5,2.5,2.5,2.5,"R","R",null,null,{"$f":"+$M72","v":2.5},{"$f":"+$N72","v":"R"},{"$f":"+$O72","v":"R"},{"$f":"+$I72","v":2.5},{"$f":"+$J72","v":2.5},{"$f":"+$K72","v":2.5},{"$f":"+$L72","v":2.5},{"$f":"+$M72","v":2.5},{"$f":"+$N72","v":"R"},{"$f":"+$O72","v":"R"},{"$f":"+$I72","v":2.5},{"$f":"+$J72","v":2.5},{"$f":"+$K72","v":2.5},{"$f":"+$L72","v":2.5},{"$f":"+$M72","v":2.5},{"$f":"+$N72","v":"R"},{"$f":"+$O72","v":"R"},{"$f":"+$I72","v":2.5},{"$f":"+$J72","v":2.5},{"$f":"+$K72","v":2.5},{"$f":"+$L72","v":2.5},{"$f":"+$M72","v":2.5},{"$f":"+$N72","v":"R"},{"$f":"+$O72","v":"R"},{"$f":"+$I72","v":2.5},{"$f":"+$J72","v":2.5},{"$f":"+$K72","v":2.5},{"$f":"+$L72","v":2.5},{"$f":"+$M72","v":2.5},{"$f":"+$N72","v":"R"},{"$f":"+$O72","v":"R"},"h contrat",{"$f":"H72","v":54.166666666666664},"HEURE CAT",{"$f":"+H72","v":54.166666666666664},{"$f":"AZ72*E72","v":638.62499999999989}]
[null,null,{"$f":"+C72","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R72:AV72)","v":52.5},"H. ABS",{"$f":"SUM(R73:AV73)","v":0},{"$f":"AZ73*E73","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX73-AZ73+AZ74","v":52.5},"H. SUP",{"$f":"SUM(R74:AV74)","v":0},{"$f":"IF(H72<35*52/12,IF(BB74=\"O\",AZ74*1.1*E74,AZ74*1.11*E74),AZ74*1.25*E74)","v":0},{"$f":"IF(C72=\"CDI\",IF(AZ74<AZ72*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX74","v":52.5},"MOTIF/TOT MOB",null,{"$f":"IF(AX74=0,0,BA72-BA73+BA74)","v":638.62499999999989}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D76,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",null,null,null,null,null,null,"R","R",null,null,{"$f":"+$M76","v":0},{"$f":"+$N76","v":"R"},{"$f":"+$O76","v":"R"},{"$f":"+$I76","v":0},{"$f":"+$J76","v":0},{"$f":"+$K76","v":0},{"$f":"+$L76","v":0},{"$f":"+$M76","v":0},{"$f":"+$N76","v":"R"},{"$f":"+$O76","v":"R"},{"$f":"+$I76","v":0},{"$f":"+$J76","v":0},{"$f":"+$K76","v":0},{"$f":"+$L76","v":0},{"$f":"+$M76","v":0},{"$f":"+$N76","v":"R"},{"$f":"+$O76","v":"R"},{"$f":"+$I76","v":0},{"$f":"+$J76","v":0},{"$f":"+$K76","v":0},3,3,{"$f":"+$N76","v":"R"},{"$f":"+$O76","v":"R"},{"$f":"+$I76","v":0},{"$f":"+$J76","v":0},{"$f":"+$K76","v":0},3,3,{"$f":"+$N76","v":"R"},{"$f":"+$O76","v":"R"},"h contrat",{"$f":"H76","v":0},"HEURE CAT",{"$f":"+H76","v":0},{"$f":"AZ76*E76","v":0}]
[null,null,{"$f":"+C76","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R76:AV76)","v":12},"H. ABS",{"$f":"SUM(R77:AV77)","v":0},{"$f":"AZ77*E77","v":0}]
[null,null,0,"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX77-AZ77+AZ78","v":12},"H. SUP",{"$f":"SUM(R78:AV78)","v":0},{"$f":"IF(H76<35*52/12,IF(BB78=\"O\",AZ78*1.1*E78,AZ78*1.11*E78),AZ78*1.25*E78)","v":0},{"$f":"IF(C76=\"CDI\",IF(AZ78<AZ76*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,0,"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX78","v":12},"MOTIF/TOT MOB",null,{"$f":"IF(AX78=0,0,BA76-BA77+BA78)","v":0}]
["VIJAYAKUMARAN","NADARAJAH","CDI","ASCA",{"$f":"VLOOKUP(D80,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},"MALADIE PRO ","HEURE CAT",{"$f":"(SUBTOTAL(9,I80:O80))*52/12","v":54.166666666666664},2.5,2.5,2.5,2.5,2.5,"R","R",null,null,{"$f":"+$M80","v":2.5},{"$f":"+$N80","v":"R"},{"$f":"+$O80","v":"R"},{"$f":"+$I80","v":2.5},{"$f":"+$J80","v":2.5},{"$f":"+$K80","v":2.5},{"$f":"+$L80","v":2.5},{"$f":"+$M80","v":2.5},{"$f":"+$N80","v":"R"},{"$f":"+$O80","v":"R"},{"$f":"+$I80","v":2.5},{"$f":"+$J80","v":2.5},{"$f":"+$K80","v":2.5},{"$f":"+$L80","v":2.5},{"$f":"+$M80","v":2.5},{"$f":"+$N80","v":"R"},{"$f":"+$O80","v":"R"},{"$f":"+$I80","v":2.5},{"$f":"+$J80","v":2.5},{"$f":"+$K80","v":2.5},{"$f":"+$L80","v":2.5},{"$f":"+$M80","v":2.5},{"$f":"+$N80","v":"R"},{"$f":"+$O80","v":"R"},{"$f":"+$I80","v":2.5},{"$f":"+$J80","v":2.5},{"$f":"+$K80","v":2.5},{"$f":"+$L80","v":2.5},{"$f":"+$M80","v":2.5},{"$f":"+$N80","v":"R"},{"$f":"+$O80","v":"R"},"h contrat",{"$f":"H80","v":54.166666666666664},"HEURE CAT",{"$f":"+H80","v":54.166666666666664},{"$f":"AZ80*E80","v":638.62499999999989}]
[null,null,{"$f":"+C80","v":"CDI"},"ASCA",11.79,"jusqu'au 31/08","H. ABS",null,null,null,null,null,null,null,null,null,null,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,2.5,2.5,2.5,2.5,2.5,null,null,"h travaillable",{"$f":"SUM(R80:AV80)","v":52.5},"H. ABS",{"$f":"SUM(R81:AV81)","v":52.5},{"$f":"AZ81*E81","v":618.97499999999991}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX81-AZ81+AZ82","v":0},"H. SUP",{"$f":"SUM(R82:AV82)","v":0},{"$f":"IF(H80<35*52/12,IF(BB82=\"O\",AZ82*1.1*E82,AZ82*1.11*E82),AZ82*1.25*E82)","v":0},{"$f":"IF(C80=\"CDI\",IF(AZ82<AZ80*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,"MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"MAL","MAL","MAL","MAL","MAL",null,null,"h du mois",{"$f":"AX82","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX82=0,0,BA80-BA81+BA82)","v":0}]
["ZENATI","HADJIRA","CDI","CE2",{"$f":"VLOOKUP(D84,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":14.33},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I84:O84))*52/12","v":151.66666666666666},7,7,7,7,7,"R","R",null,null,{"$f":"+$M84","v":7},{"$f":"+$N84","v":"R"},{"$f":"+$O84","v":"R"},{"$f":"+$I84","v":7},{"$f":"+$J84","v":7},{"$f":"+$K84","v":7},{"$f":"+$L84","v":7},{"$f":"+$M84","v":7},{"$f":"+$N84","v":"R"},{"$f":"+$O84","v":"R"},{"$f":"+$I84","v":7},{"$f":"+$J84","v":7},{"$f":"+$K84","v":7},{"$f":"+$L84","v":7},{"$f":"+$M84","v":7},{"$f":"+$N84","v":"R"},{"$f":"+$O84","v":"R"},{"$f":"+$I84","v":7},{"$f":"+$J84","v":7},{"$f":"+$K84","v":7},{"$f":"+$L84","v":7},{"$f":"+$M84","v":7},{"$f":"+$N84","v":"R"},{"$f":"+$O84","v":"R"},{"$f":"+$I84","v":7},{"$f":"+$J84","v":7},{"$f":"+$K84","v":7},{"$f":"+$L84","v":7},{"$f":"+$M84","v":7},{"$f":"+$N84","v":"R"},{"$f":"+$O84","v":"R"},"h contrat",{"$f":"H84","v":151.66666666666666},"HEURE CAT",{"$f":"+H84","v":151.66666666666666},{"$f":"AZ84*E84","v":2173.3833333333332}]
[null,null,{"$f":"+C84","v":"CDI"},"CE2",14.33,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R84:AV84)","v":147},"H. ABS",{"$f":"SUM(R85:AV85)","v":0},{"$f":"AZ85*E85","v":0}]
[null,null,"CDI","CE2",14.33,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX85-AZ85+AZ86","v":147},"H. SUP",{"$f":"SUM(R86:AV86)","v":0},{"$f":"IF(H84<35*52/12,IF(BB86=\"O\",AZ86*1.1*E86,AZ86*1.11*E86),AZ86*1.25*E86)","v":0},{"$f":"IF(C84=\"CDI\",IF(AZ86<AZ84*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","CE2",14.33,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX86","v":147},"MOTIF/TOT MOB",null,{"$f":"IF(AX86=0,0,BA84-BA85+BA86)","v":2173.3833333333332}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D88,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I88:O88))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M88","v":0},{"$f":"+$N88","v":"R"},{"$f":"+$O88","v":"R"},{"$f":"+$I88","v":0},{"$f":"+$J88","v":0},{"$f":"+$K88","v":0},{"$f":"+$L88","v":0},{"$f":"+$M88","v":0},{"$f":"+$N88","v":"R"},{"$f":"+$O88","v":"R"},{"$f":"+$I88","v":0},{"$f":"+$J88","v":0},{"$f":"+$K88","v":0},{"$f":"+$L88","v":0},{"$f":"+$M88","v":0},{"$f":"+$N88","v":"R"},{"$f":"+$O88","v":"R"},{"$f":"+$I88","v":0},{"$f":"+$J88","v":0},{"$f":"+$K88","v":0},{"$f":"+$L88","v":0},{"$f":"+$M88","v":0},{"$f":"+$N88","v":"R"},{"$f":"+$O88","v":"R"},{"$f":"+$I88","v":0},{"$f":"+$J88","v":0},{"$f":"+$K88","v":0},{"$f":"+$L88","v":0},{"$f":"+$M88","v":0},{"$f":"+$N88","v":"R"},{"$f":"+$O88","v":"R"},"h contrat",{"$f":"H88","v":0},"HEURE CAT",{"$f":"+H88","v":0},{"$f":"AZ88*E88","v":0}]
[null,null,{"$f":"+C88","v":"CDD"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R88:AV88)","v":0},"H. ABS",{"$f":"SUM(R89:AV89)","v":0},{"$f":"AZ89*E89","v":0}]
[null,null,{"$f":"+C89","v":"CDD"},"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX89-AZ89+AZ90","v":0},"H. SUP",{"$f":"SUM(R90:AV90)","v":0},{"$f":"IF(H88<35*52/12,IF(BB90=\"O\",AZ90*1.1*E90,AZ90*1.11*E90),AZ90*1.25*E90)","v":0},{"$f":"IF(C88=\"CDI\",IF(AZ90<AZ88*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C90","v":"CDD"},"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX90","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX90=0,0,BA88-BA89+BA90)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D92,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I92:O92))*52/12","v":0},null,null,null,null,null,"R","R",null,null,2,{"$f":"+$N92","v":"R"},{"$f":"+$O92","v":"R"},2,2,2,2,2,{"$f":"+$N92","v":"R"},{"$f":"+$O92","v":"R"},2,2,2,2,2,{"$f":"+$N92","v":"R"},{"$f":"+$O92","v":"R"},2,2,2,2,2,{"$f":"+$N92","v":"R"},{"$f":"+$O92","v":"R"},2,2,2,2,2,{"$f":"+$N92","v":"R"},{"$f":"+$O92","v":"R"},"h contrat",{"$f":"H92","v":0},"HEURE CAT",{"$f":"+H92","v":0},{"$f":"AZ92*E92","v":0}]
[null,null,{"$f":"+C92","v":"CDD"},"ASPA",10.56,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R92:AV92)","v":42},"H. ABS",{"$f":"SUM(R93:AV93)","v":0},{"$f":"AZ93*E93","v":0}]
[null,null,{"$f":"+C93","v":"CDD"},"ASPA",{"$f":"+E92","v":11.75},null,"H.SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"AX93-AZ93+AZ94","v":42},"H. SUP",{"$f":"SUM(R94:AV94)","v":0},{"$f":"IF(H92<35*52/12,IF(BB94=\"O\",AZ94*1.1*E94,AZ94*1.11*E94),AZ94*1.25*E94)","v":0},{"$f":"IF(C92=\"CDI\",IF(AZ94<AZ92*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C94","v":"CDD"},"ASPA",10.56,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX94","v":42},"MOTIF/TOT MOB",null,{"$f":"IF(AX94=0,0,BA92-BA93+BA94)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D96,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I96:O96))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M96","v":0},{"$f":"+$N96","v":"R"},{"$f":"+$O96","v":"R"},{"$f":"+$I96","v":0},{"$f":"+$J96","v":0},{"$f":"+$K96","v":0},{"$f":"+$L96","v":0},{"$f":"+$M96","v":0},{"$f":"+$N96","v":"R"},{"$f":"+$O96","v":"R"},{"$f":"+$I96","v":0},{"$f":"+$J96","v":0},{"$f":"+$K96","v":0},{"$f":"+$L96","v":0},{"$f":"+$M96","v":0},{"$f":"+$N96","v":"R"},{"$f":"+$O96","v":"R"},{"$f":"+$I96","v":0},{"$f":"+$J96","v":0},{"$f":"+$K96","v":0},{"$f":"+$L96","v":0},{"$f":"+$M96","v":0},{"$f":"+$N96","v":"R"},{"$f":"+$O96","v":"R"},{"$f":"+$I96","v":0},{"$f":"+$J96","v":0},{"$f":"+$K96","v":0},{"$f":"+$L96","v":0},{"$f":"+$M96","v":0},{"$f":"+$N96","v":"R"},{"$f":"+$O96","v":"R"},"h contrat",{"$f":"H96","v":0},"HEURE CAT",{"$f":"+H96","v":0},{"$f":"AZ96*E96","v":0}]
[null,null,{"$f":"+C96","v":"CDD"},"ASPA",10.56,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R96:AV96)","v":0},"H. ABS",{"$f":"SUM(R97:AV97)","v":0},{"$f":"AZ97*E97","v":0}]
[null,null,{"$f":"+C97","v":"CDD"},"ASPA",{"$f":"+E96","v":11.75},null,"H.SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"AX97-AZ97+AZ98","v":0},"H. SUP",{"$f":"SUM(R98:AV98)","v":0},{"$f":"IF(H96<35*52/12,IF(BB98=\"O\",AZ98*1.1*E98,AZ98*1.11*E98),AZ98*1.25*E98)","v":0},{"$f":"IF(C96=\"CDI\",IF(AZ98<AZ96*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C98","v":"CDD"},"ASPA",10.56,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX98","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX98=0,0,BA96-BA97+BA98)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D100,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I100:O100))*52/12","v":0},null,null,null,null,null,"R","R",null,null,2,{"$f":"+$N100","v":"R"},{"$f":"+$O100","v":"R"},2,2,2,2,2,{"$f":"+$N100","v":"R"},{"$f":"+$O100","v":"R"},2,2,2,2,2,{"$f":"+$N100","v":"R"},{"$f":"+$O100","v":"R"},2,2,2,2,2,{"$f":"+$N100","v":"R"},{"$f":"+$O100","v":"R"},2,2,2,2,2,{"$f":"+$N100","v":"R"},{"$f":"+$O100","v":"R"},"h contrat",{"$f":"H100","v":0},"HEURE CAT",{"$f":"+H100","v":0},{"$f":"AZ100*E100","v":0}]
[null,null,{"$f":"+C100","v":"CDD"},"ASPA",10.56,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R100:AV100)","v":42},"H. ABS",{"$f":"SUM(R101:AV101)","v":0},{"$f":"AZ101*E101","v":0}]
[null,null,{"$f":"+C101","v":"CDD"},"ASPA",{"$f":"+E100","v":11.75},null,"H.SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"AX101-AZ101+AZ102","v":42},"H. SUP",{"$f":"SUM(R102:AV102)","v":0},{"$f":"IF(H100<35*52/12,IF(BB102=\"O\",AZ102*1.1*E102,AZ102*1.11*E102),AZ102*1.25*E102)","v":0},{"$f":"IF(C100=\"CDI\",IF(AZ102<AZ100*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C102","v":"CDD"},"ASPA",10.56,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX102","v":42},"MOTIF/TOT MOB",null,{"$f":"IF(AX102=0,0,BA100-BA101+BA102)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D104,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I104:O104))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M104","v":0},{"$f":"+$N104","v":"R"},{"$f":"+$O104","v":"R"},{"$f":"+$I104","v":0},{"$f":"+$J104","v":0},{"$f":"+$K104","v":0},{"$f":"+$L104","v":0},{"$f":"+$M104","v":0},{"$f":"+$N104","v":"R"},{"$f":"+$O104","v":"R"},{"$f":"+$I104","v":0},{"$f":"+$J104","v":0},{"$f":"+$K104","v":0},{"$f":"+$L104","v":0},{"$f":"+$M104","v":0},{"$f":"+$N104","v":"R"},{"$f":"+$O104","v":"R"},{"$f":"+$I104","v":0},{"$f":"+$J104","v":0},{"$f":"+$K104","v":0},{"$f":"+$L104","v":0},{"$f":"+$M104","v":0},{"$f":"+$N104","v":"R"},{"$f":"+$O104","v":"R"},{"$f":"+$I104","v":0},{"$f":"+$J104","v":0},{"$f":"+$K104","v":0},{"$f":"+$L104","v":0},{"$f":"+$M104","v":0},{"$f":"+$N104","v":"R"},{"$f":"+$O104","v":"R"},"h contrat",{"$f":"H104","v":0},"HEURE CAT",{"$f":"+H104","v":0},{"$f":"AZ104*E104","v":0}]
[null,null,{"$f":"+C104","v":"CDD"},"ASPA",10.56,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R104:AV104)","v":0},"H. ABS",{"$f":"SUM(R105:AV105)","v":0},{"$f":"AZ105*E105","v":0}]
[null,null,{"$f":"+C105","v":"CDD"},"ASPA",{"$f":"+E104","v":11.75},null,"H.SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"AX105-AZ105+AZ106","v":0},"H. SUP",{"$f":"SUM(R106:AV106)","v":0},{"$f":"IF(H104<35*52/12,IF(BB106=\"O\",AZ106*1.1*E106,AZ106*1.11*E106),AZ106*1.25*E106)","v":0},{"$f":"IF(C104=\"CDI\",IF(AZ106<AZ104*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C106","v":"CDD"},"ASPA",10.56,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX106","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX106=0,0,BA104-BA105+BA106)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D108,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I108:O108))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M108","v":0},{"$f":"+$N108","v":"R"},{"$f":"+$O108","v":"R"},{"$f":"+$I108","v":0},{"$f":"+$J108","v":0},{"$f":"+$K108","v":0},{"$f":"+$L108","v":0},{"$f":"+$M108","v":0},{"$f":"+$N108","v":"R"},{"$f":"+$O108","v":"R"},{"$f":"+$I108","v":0},{"$f":"+$J108","v":0},{"$f":"+$K108","v":0},{"$f":"+$L108","v":0},{"$f":"+$M108","v":0},{"$f":"+$N108","v":"R"},{"$f":"+$O108","v":"R"},{"$f":"+$I108","v":0},{"$f":"+$J108","v":0},{"$f":"+$K108","v":0},{"$f":"+$L108","v":0},{"$f":"+$M108","v":0},{"$f":"+$N108","v":"R"},{"$f":"+$O108","v":"R"},{"$f":"+$I108","v":0},{"$f":"+$J108","v":0},{"$f":"+$K108","v":0},{"$f":"+$L108","v":0},{"$f":"+$M108","v":0},{"$f":"+$N108","v":"R"},{"$f":"+$O108","v":"R"},"h contrat",{"$f":"H108","v":0},"HEURE CAT",{"$f":"+H108","v":0},{"$f":"AZ108*E108","v":0}]
[null,null,{"$f":"+C108","v":"CDD"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,null,null,null,null,7,7,7,null,null,"h travaillable",{"$f":"SUM(R108:AV108)","v":0},"H. ABS",{"$f":"SUM(R109:AV109)","v":42},{"$f":"AZ109*E109","v":493.5}]
[null,null,"CDD","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX109-AZ109+AZ110","v":-42},"H. SUP",{"$f":"SUM(R110:AV110)","v":0},{"$f":"IF(H108<35*52/12,IF(BB110=\"O\",AZ110*1.1*E110,AZ110*1.11*E110),AZ110*1.25*E110)","v":0},{"$f":"IF(C108=\"CDI\",IF(AZ110<AZ108*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDD","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AANP","AANP","AANP",null,null,null,null,"AANP","AANP","AANP",null,null,"h du mois",{"$f":"AX110","v":-42},"MOTIF/TOT MOB",null,{"$f":"IF(AX110=0,0,BA108-BA109+BA110)","v":-493.5}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D112,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I112:O112))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M112","v":0},{"$f":"+$N112","v":"R"},{"$f":"+$O112","v":"R"},{"$f":"+$I112","v":0},{"$f":"+$J112","v":0},{"$f":"+$K112","v":0},{"$f":"+$L112","v":0},{"$f":"+$M112","v":0},{"$f":"+$N112","v":"R"},{"$f":"+$O112","v":"R"},{"$f":"+$I112","v":0},{"$f":"+$J112","v":0},{"$f":"+$K112","v":0},{"$f":"+$L112","v":0},{"$f":"+$M112","v":0},{"$f":"+$N112","v":"R"},{"$f":"+$O112","v":"R"},{"$f":"+$I112","v":0},{"$f":"+$J112","v":0},{"$f":"+$K112","v":0},2,2,{"$f":"+$N112","v":"R"},{"$f":"+$O112","v":"R"},{"$f":"+$I112","v":0},{"$f":"+$J112","v":0},{"$f":"+$K112","v":0},2,2,{"$f":"+$N112","v":"R"},{"$f":"+$O112","v":"R"},"h contrat",{"$f":"H112","v":0},"HEURE CAT",{"$f":"+H112","v":0},{"$f":"AZ112*E112","v":0}]
[null,null,{"$f":"+C112","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R112:AV112)","v":8},"H. ABS",{"$f":"SUM(R113:AV113)","v":0},{"$f":"AZ113*E113","v":0}]
[null,null,{"$f":"+C113","v":0},"ASPA",11.75,null,"H.SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"AX113-AZ113+AZ114","v":8},"H. SUP",{"$f":"SUM(R114:AV114)","v":0},{"$f":"IF(H112<35*52/12,IF(BB114=\"O\",AZ114*1.1*E114,AZ114*1.11*E114),AZ114*1.25*E114)","v":0},{"$f":"IF(C112=\"CDI\",IF(AZ114<AZ112*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C114","v":0},"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX114","v":8},"MOTIF/TOT MOB",null,{"$f":"IF(AX114=0,0,BA112-BA113+BA114)","v":0}]

{"sheet":"723806 urgence med","index":5,"n_rows":15,"n_cols":56,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"²"]
[723806,"URGENCE MED",null,null,null,null,null,null,"2019-08-05","2019-08-06","2019-08-07","2019-08-01","2019-08-02","2019-08-03","2019-08-04",null,null,{"$f":"H1","v":"2023-09-01"},{"$f":"R2+1","v":"2023-09-02"},"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",{"$f":"#REF!+1","v":{"$error":"#REF!"}},{"$f":"AW2+1","v":{"$error":"#REF!"}},null,0,{"$f":"SUM(BA15,BA11,BA7,BC4:BC15)","v":534.625}]
["Nom","Prénom","CDD \n- \nCDI","QUALIFICATION","Taux Horaire","Commentaire","Libellé",{"$f":"H1","v":"2023-09-01"},1,2,3,4,5,6,7,null,null,{"$f":"+R2","v":"2023-09-01"},"2023-09-02","2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",null,"H travaillées mois","Libellé","Total heures mois","Coût total mois","AVPP","Primes","justification H Plus et Primes"]
["BAMBOU","KARIMA","CDI","ASPA",{"$f":"VLOOKUP(D4,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},"avpp essilor","HEURE CAT",{"$f":"(SUBTOTAL(9,I4:O4))*52/12","v":39},1.5,1.5,1.5,1.5,1.5,1.5,"R",null,null,{"$f":"$M$4","v":1.5},{"$f":"$N$4","v":1.5},{"$f":"$O$4","v":"R"},{"$f":"$I$4","v":1.5},{"$f":"$J$4","v":1.5},{"$f":"$K$4","v":1.5},{"$f":"$L$4","v":1.5},{"$f":"$M$4","v":1.5},{"$f":"$N$4","v":1.5},{"$f":"$O$4","v":"R"},{"$f":"$I$4","v":1.5},{"$f":"$J$4","v":1.5},{"$f":"$K$4","v":1.5},{"$f":"$L$4","v":1.5},{"$f":"$M$4","v":1.5},{"$f":"$N$4","v":1.5},{"$f":"$O$4","v":"R"},{"$f":"$I$4","v":1.5},{"$f":"$J$4","v":1.5},{"$f":"$K$4","v":1.5},{"$f":"$L$4","v":1.5},{"$f":"$M$4","v":1.5},{"$f":"$N$4","v":1.5},{"$f":"$O$4","v":"R"},{"$f":"$I$4","v":1.5},{"$f":"$J$4","v":1.5},{"$f":"$K$4","v":1.5},{"$f":"$L$4","v":1.5},{"$f":"$M$4","v":1.5},{"$f":"$N$4","v":1.5},{"$f":"$O$4","v":"R"},"h contrat",{"$f":"H4","v":39},"HEURE CAT",{"$f":"+H4","v":39},{"$f":"AZ4*E4","v":458.25}]
[null,null,{"$f":"+C4","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R4:AV4)","v":39},"H. ABS",{"$f":"SUM(R5:AV5)","v":0},{"$f":"AZ5*E5","v":0}]
[null,null,"CDI","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX5-AZ5+AZ6","v":39},"H. SUP",{"$f":"SUM(R6:AV6)","v":0},{"$f":"IF(H4<35*52/12,IF(BB6=\"O\",AZ6*1.1*E6,AZ6*1.11*E6),AZ6*1.25*E6)","v":0},{"$f":"IF(C4=\"CDI\",IF(AZ6<AZ4*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX6","v":39},"MOTIF/TOT MOB",null,{"$f":"IF(AX6=0,0,BA4-BA5+BA6)","v":458.25}]
["CHIJI","FATIHA","CDI","ASPA",{"$f":"VLOOKUP(D8,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},"avpp essilor","HEURE CAT",{"$f":"(SUBTOTAL(9,I8:O8))*52/12","v":6.5},"R","R","R","R","R","R",1.5,null,null,{"$f":"+$M8","v":"R"},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":1.5},{"$f":"+$I8","v":"R"},{"$f":"+$J8","v":"R"},{"$f":"+$K8","v":"R"},{"$f":"+$L8","v":"R"},{"$f":"+$M8","v":"R"},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":1.5},{"$f":"+$I8","v":"R"},{"$f":"+$J8","v":"R"},{"$f":"+$K8","v":"R"},{"$f":"+$L8","v":"R"},{"$f":"+$M8","v":"R"},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":1.5},{"$f":"+$I8","v":"R"},{"$f":"+$J8","v":"R"},{"$f":"+$K8","v":"R"},{"$f":"+$L8","v":"R"},{"$f":"+$M8","v":"R"},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":1.5},{"$f":"+$I8","v":"R"},{"$f":"+$J8","v":"R"},{"$f":"+$K8","v":"R"},{"$f":"+$L8","v":"R"},{"$f":"+$M8","v":"R"},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":1.5},"h contrat",{"$f":"H8","v":6.5},"HEURE CAT",{"$f":"+H8","v":6.5},{"$f":"AZ8*E8","v":76.375}]
[null,null,{"$f":"+C8","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R8:AV8)","v":7.5},"H. ABS",{"$f":"SUM(R9:AV9)","v":0},{"$f":"AZ9*E9","v":0}]
[null,null,"CDI","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX9-AZ9+AZ10","v":7.5},"H. SUP",{"$f":"SUM(R10:AV10)","v":0},{"$f":"IF(H8<35*52/12,IF(BB10=\"O\",AZ10*1.1*E10,AZ10*1.11*E10),AZ10*1.25*E10)","v":0},{"$f":"IF(C8=\"CDI\",IF(AZ10<AZ8*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX10","v":7.5},"MOTIF/TOT MOB",null,{"$f":"IF(AX10=0,0,BA8-BA9+BA10)","v":76.375}]
[null,null,"CDI","ASPA",{"$f":"VLOOKUP(D12,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I12:O12))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},"h contrat",{"$f":"H12","v":0},"HEURE CAT",{"$f":"+H12","v":0},{"$f":"AZ12*E12","v":0}]
[null,null,{"$f":"+C12","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R12:AV12)","v":0},"H. ABS",{"$f":"SUM(R13:AV13)","v":0},{"$f":"AZ13*E13","v":0}]
[null,null,"CDI","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX13-AZ13+AZ14","v":0},"H. SUP",{"$f":"SUM(R14:AV14)","v":0},{"$f":"IF(H12<35*52/12,IF(BB14=\"O\",AZ14*1.1*E14,AZ14*1.11*E14),AZ14*1.25*E14)","v":0},{"$f":"IF(C12=\"CDI\",IF(AZ14<AZ12*0.1,\"N\",\"O\"),\"N\")","v":"O"}]
[null,null,"CDI","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX14","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX14=0,0,BA12-BA13+BA14)","v":0}]

{"sheet":"723314 médiathèque","index":6,"n_rows":27,"n_cols":56,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"²"]
[723314,"MEDIATHEQUE CHARENTON",null,null,null,null,null,null,"2019-08-05","2019-08-06","2019-08-07","2019-08-01","2019-08-02","2019-08-03","2019-08-04",null,null,{"$f":"H1","v":"2023-09-01"},{"$f":"R2+1","v":"2023-09-02"},"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",{"$f":"#REF!+1","v":{"$error":"#REF!"}},{"$f":"AW2+1","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(BA27,BA23,BA15,BA11,BA7,BC4:BC27)","v":2303.6}]
["Nom","Prénom","CDD \n- \nCDI","QUALIFICATION","Taux Horaire","Commentaire","Libellé",{"$f":"H1","v":"2023-09-01"},1,2,3,4,5,6,7,null,null,{"$f":"+R2","v":"2023-09-01"},"2023-09-02","2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",null,"H travaillées mois","Libellé","Total heures mois","Coût total mois","AVPP","Primes","justification H Plus et Primes"]
["MARTINS PIMENTA","MAGDA VALERIA","CDI","ASCA",{"$f":"VLOOKUP(D4,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I4:O4))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M4","v":3},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3},{"$f":"+$J4","v":3},{"$f":"+$K4","v":3},{"$f":"+$L4","v":3},{"$f":"+$M4","v":3},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3},{"$f":"+$J4","v":3},{"$f":"+$K4","v":3},{"$f":"+$L4","v":3},{"$f":"+$M4","v":3},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3},{"$f":"+$J4","v":3},{"$f":"+$K4","v":3},{"$f":"+$L4","v":3},{"$f":"+$M4","v":3},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3},{"$f":"+$J4","v":3},{"$f":"+$K4","v":3},{"$f":"+$L4","v":3},{"$f":"+$M4","v":3},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},"h contrat",{"$f":"H4","v":65},"HEURE CAT",{"$f":"+H4","v":65},{"$f":"AZ4*E4","v":766.34999999999991}]
[null,null,{"$f":"+C4","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R4:AV4)","v":63},"H. ABS",{"$f":"SUM(R5:AV5)","v":0},{"$f":"AZ5*E5","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX5-AZ5+AZ6","v":63},"H. SUP",{"$f":"SUM(R6:AV6)","v":0},{"$f":"IF(H4<35*52/12,IF(BB6=\"O\",AZ6*1.1*E6,AZ6*1.11*E6),AZ6*1.25*E6)","v":0},{"$f":"IF(C4=\"CDI\",IF(AZ6<AZ4*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX6","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX6=0,0,BA4-BA5+BA6)","v":766.34999999999991}]
["NIAKATE","SADIO","CDI","ASCA",{"$f":"VLOOKUP(D8,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I8:O8))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":"R"},{"$f":"+$O8","v":"R"},"h contrat",{"$f":"H8","v":65},"HEURE CAT",{"$f":"+H8","v":65},{"$f":"AZ8*E8","v":766.34999999999991}]
[null,null,{"$f":"+C8","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R8:AV8)","v":63},"H. ABS",{"$f":"SUM(R9:AV9)","v":0},{"$f":"AZ9*E9","v":0}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX9-AZ9+AZ10","v":63},"H. SUP",{"$f":"SUM(R10:AV10)","v":0},{"$f":"IF(H8<35*52/12,IF(BB10=\"O\",AZ10*1.1*E10,AZ10*1.11*E10),AZ10*1.25*E10)","v":0},{"$f":"IF(C8=\"CDI\",IF(AZ10<AZ8*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX10","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX10=0,0,BA8-BA9+BA10)","v":766.34999999999991}]
["OSIAS PHILIPPE","ELISSAINE","CDI","ASCSA",{"$f":"VLOOKUP(D12,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.86},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I12:O12))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M12","v":3},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":3},{"$f":"+$J12","v":3},{"$f":"+$K12","v":3},{"$f":"+$L12","v":3},{"$f":"+$M12","v":3},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":3},{"$f":"+$J12","v":3},{"$f":"+$K12","v":3},{"$f":"+$L12","v":3},{"$f":"+$M12","v":3},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":3},{"$f":"+$J12","v":3},{"$f":"+$K12","v":3},{"$f":"+$L12","v":3},{"$f":"+$M12","v":3},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":3},{"$f":"+$J12","v":3},{"$f":"+$K12","v":3},{"$f":"+$L12","v":3},{"$f":"+$M12","v":3},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},"h contrat",{"$f":"H12","v":65},"HEURE CAT",{"$f":"+H12","v":65},{"$f":"AZ12*E12","v":770.9}]
[null,null,{"$f":"+C12","v":"CDI"},"ASCSA",11.86,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R12:AV12)","v":63},"H. ABS",{"$f":"SUM(R13:AV13)","v":0},{"$f":"AZ13*E13","v":0}]
[null,null,"CDI","ASCSA",11.86,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX13-AZ13+AZ14","v":63},"H. SUP",{"$f":"SUM(R14:AV14)","v":0},{"$f":"IF(H12<35*52/12,IF(BB14=\"O\",AZ14*1.1*E14,AZ14*1.11*E14),AZ14*1.25*E14)","v":0},{"$f":"IF(C12=\"CDI\",IF(AZ14<AZ12*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCSA",11.86,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX14","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX14=0,0,BA12-BA13+BA14)","v":770.9}]
["ZRIF","ILHAM","CDI","ASCSA",{"$f":"VLOOKUP(D16,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.86},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I16:O16))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":3},{"$f":"+$J16","v":3},{"$f":"+$K16","v":3},{"$f":"+$L16","v":3},{"$f":"+$M16","v":3},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},"h contrat",{"$f":"H16","v":65},"HEURE CAT",{"$f":"+H16","v":65},{"$f":"AZ16*E16","v":770.9}]
[null,null,{"$f":"+C16","v":"CDI"},"ASCSA",11.86,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R16:AV16)","v":63},"H. ABS",{"$f":"SUM(R17:AV17)","v":0},{"$f":"AZ17*E17","v":0}]
[null,null,{"$f":"+C17","v":"CDI"},"ASCSA",11.86,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX17-AZ17+AZ18","v":63},"H. SUP",{"$f":"SUM(R18:AV18)","v":0},{"$f":"IF(H16<35*52/12,IF(BB18=\"O\",AZ18*1.1*E18,AZ18*1.11*E18),AZ18*1.25*E18)","v":0},{"$f":"IF(C16=\"CDI\",IF(AZ18<AZ16*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,{"$f":"+C18","v":"CDI"},"ASCSA",11.86,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX18","v":63},"MOTIF/TOT MOB",null,{"$f":"IF(AX18=0,0,BA16-BA17+BA18)","v":770.9}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D20,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I20:O20))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M20","v":0},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":0},{"$f":"+$J20","v":0},{"$f":"+$K20","v":0},{"$f":"+$L20","v":0},{"$f":"+$M20","v":0},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":0},{"$f":"+$J20","v":0},{"$f":"+$K20","v":0},{"$f":"+$L20","v":0},{"$f":"+$M20","v":0},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":0},{"$f":"+$J20","v":0},{"$f":"+$K20","v":0},{"$f":"+$L20","v":0},{"$f":"+$M20","v":0},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":0},{"$f":"+$J20","v":0},{"$f":"+$K20","v":0},{"$f":"+$L20","v":0},{"$f":"+$M20","v":0},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},"h contrat",{"$f":"H20","v":0},"HEURE CAT",{"$f":"+H20","v":0},{"$f":"AZ20*E20","v":0}]
[null,null,{"$f":"+C20","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R20:AV20)","v":0},"H. ABS",{"$f":"SUM(R21:AV21)","v":0},{"$f":"AZ21*E21","v":0}]
[null,null,0,"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX21-AZ21+AZ22","v":0},"H. SUP",{"$f":"SUM(R22:AV22)","v":0},{"$f":"IF(H20<35*52/12,IF(BB22=\"O\",AZ22*1.1*E22,AZ22*1.11*E22),AZ22*1.25*E22)","v":0},{"$f":"IF(C20=\"CDI\",IF(AZ22<AZ20*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,0,"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX22","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX22=0,0,BA20-BA21+BA22)","v":0}]
[null,null,"CDD","ASPA",{"$f":"VLOOKUP(D24,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I24:O24))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M24","v":0},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":0},{"$f":"+$J24","v":0},{"$f":"+$K24","v":0},{"$f":"+$L24","v":0},{"$f":"+$M24","v":0},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":0},{"$f":"+$J24","v":0},{"$f":"+$K24","v":0},{"$f":"+$L24","v":0},{"$f":"+$M24","v":0},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":0},{"$f":"+$J24","v":0},{"$f":"+$K24","v":0},{"$f":"+$L24","v":0},{"$f":"+$M24","v":0},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":0},{"$f":"+$J24","v":0},{"$f":"+$K24","v":0},{"$f":"+$L24","v":0},{"$f":"+$M24","v":0},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},"h contrat",{"$f":"H24","v":0},"HEURE CAT",{"$f":"+H24","v":0},{"$f":"AZ24*E24","v":0}]
[null,null,{"$f":"+C24","v":"CDD"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R24:AV24)","v":0},"H. ABS",{"$f":"SUM(R25:AV25)","v":0},{"$f":"AZ25*E25","v":0}]
[null,null,"CDD","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX25-AZ25+AZ26","v":0},"H. SUP",{"$f":"SUM(R26:AV26)","v":0},{"$f":"IF(H24<35*52/12,IF(BB26=\"O\",AZ26*1.1*E26,AZ26*1.11*E26),AZ26*1.25*E26)","v":0},{"$f":"IF(C24=\"CDI\",IF(AZ26<AZ24*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDD","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX26","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX26=0,0,BA24-BA25+BA26)","v":0}]

{"sheet":"723315 mission pénitentiaire","index":7,"n_rows":19,"n_cols":81,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[9,1,null,null,null,null,null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JF",null,null,null,null,null,null,"JANVIER",2023]
[723315,"UGAP MISSION PENITENTIAIRE",null,null,null,null,null,null,"lun","mar","mer","jeu","ven","sam","dim",null,null,{"$f":"DATE(B1+2022,A1,1)","v":"2023-09-01"},{"$f":"R2+1","v":"2023-09-02"},"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",{"$f":"#REF!+1","v":{"$error":"#REF!"}},{"$f":"AW2+1","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(BA7,BA11,BC4:BC19,BA15,BA19)","v":894.07499999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FÉVRIER",2024]
["Nom","Prénom","CDD \n- \nCDI","QUALIFICATION","Taux Horaire","Commentaire","Libellé",{"$f":"H1","v":"2023-09-01"},1,2,3,4,5,6,7,null,null,{"$f":"+R2","v":"2023-09-01"},"2023-09-02","2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",null,"H travaillées mois","Libellé","Total heures mois","Coût total mois","AVPP","Primes","justification H Plus et Primes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARS",2025]
["MOUGAMADOU TAMBIRE","HASINA","CDI","ASCA",{"$f":"VLOOKUP(D4,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I4:O4))*52/12","v":75.833333333333329},3.5,3.5,3.5,3.5,3.5,"R","R",null,null,{"$f":"IF(TEXT(R2,\"jjj\")=\"lun\",$I$4,IF(TEXT(R2,\"jjj\")=\"mar\", $J$4,IF(TEXT(R2,\"jjj\")=\"mer\", $K$4,IF(TEXT(R2,\"jjj\")=\"jeu\", $L$4,IF(TEXT(R2,\"jjj\")=\"ven\", $M$4,IF(TEXT(R2,\"jjj\")=\"sam\", $N$4,$O$4))))))","v":3.5},{"$f":"IF(TEXT(S2,\"jjj\")=\"lun\",$I$4,IF(TEXT(S2,\"jjj\")=\"mar\", $J$4,IF(TEXT(S2,\"jjj\")=\"mer\", $K$4,IF(TEXT(S2,\"jjj\")=\"jeu\", $L$4,IF(TEXT(S2,\"jjj\")=\"ven\", $M$4,IF(TEXT(S2,\"jjj\")=\"sam\", $N$4,$O$4))))))","v":"R"},{"$f":"IF(TEXT(T2,\"jjj\")=\"lun\",$I$4,IF(TEXT(T2,\"jjj\")=\"mar\", $J$4,IF(TEXT(T2,\"jjj\")=\"mer\", $K$4,IF(TEXT(T2,\"jjj\")=\"jeu\", $L$4,IF(TEXT(T2,\"jjj\")=\"ven\", $M$4,IF(TEXT(T2,\"jjj\")=\"sam\", $N$4,$O$4))))))","v":"R"},{"$f":"IF(TEXT(U2,\"jjj\")=\"lun\",$I$4,IF(TEXT(U2,\"jjj\")=\"mar\", $J$4,IF(TEXT(U2,\"jjj\")=\"mer\", $K$4,IF(TEXT(U2,\"jjj\")=\"jeu\", $L$4,IF(TEXT(U2,\"jjj\")=\"ven\", $M$4,IF(TEXT(U2,\"jjj\")=\"sam\", $N$4,$O$4))))))","v":3.5},{"$f":"IF(TEXT(V2,\"jjj\")=\"lun\",$I$4,IF(TEXT(V2,\"jjj\")=\"mar\", $J$4,IF(TEXT(V2,\"jjj\")=\"mer\", $K$4,IF(TEXT(V2,\"jjj\")=\"jeu\", $L$4,IF(TEXT(V2,\"jjj\")=\"ven\", $M$4,IF(TEXT(V2,\"jjj\")=\"sam\", $N$4,$O$4))))))","v":3.5},3.5,3.5,3.5,"R","R",3.5,3.5,3.5,3.5,3.5,"R","R",3.5,3.5,3.5,3.5,3.5,"R","R",3.5,3.5,3.5,3.5,3.5,"R","R","h contrat",{"$f":"H4","v":75.833333333333329},"HEURE CAT",{"$f":"+H4","v":75.833333333333329},{"$f":"AZ4*E4","v":894.07499999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVRIL",2026]
[null,null,{"$f":"+C4","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R4:AV4)","v":73.5},"H. ABS",{"$f":"SUM(R5:AV5)","v":0},{"$f":"AZ5*E5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAI",2027]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX5-AZ5+AZ6","v":73.5},"H. SUP",{"$f":"SUM(R6:AV6)","v":0},{"$f":"IF(H4<35*52/12,IF(BB6=\"O\",AZ6*1.1*E6,AZ6*1.11*E6),AZ6*1.25*E6)","v":0},{"$f":"IF(C4=\"CDI\",IF(AZ6<AZ4*0.1,\"N\",\"O\"),\"N\")","v":"N"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUIN",2028]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX6","v":73.5},"MOTIF/TOT MOB",null,{"$f":"IF(AX6=0,0,BA4-BA5+BA6)","v":894.07499999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUILLET",2029]
[null,null,"CDI","ASPA",{"$f":"VLOOKUP(D8,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I8:O8))*52/12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+$M8","v":0},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},{"$f":"+$I8","v":0},{"$f":"+$J8","v":0},{"$f":"+$K8","v":0},{"$f":"+$L8","v":0},{"$f":"+$M8","v":0},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},3,3,3,3,3,{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},3,3,3,3,3,{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},3,3,3,3,3,{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},"h contrat",{"$f":"H8","v":0},"HEURE CAT",{"$f":"+H8","v":0},{"$f":"AZ8*E8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AOÛT",2030]
[null,null,{"$f":"+C8","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R8:AV8)","v":45},"H. ABS",{"$f":"SUM(R9:AV9)","v":0},{"$f":"AZ9*E9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEPTEMBRE",2031]
[null,null,"CDI","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX9-AZ9+AZ10","v":45},"H. SUP",{"$f":"SUM(R10:AV10)","v":0},{"$f":"IF(H8<35*52/12,IF(BB10=\"O\",AZ10*1.1*E10,AZ10*1.11*E10),AZ10*1.25*E10)","v":0},{"$f":"IF(C8=\"CDI\",IF(AZ10<AZ8*0.1,\"N\",\"O\"),\"N\")","v":"O"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCTOBRE",2032]
[null,null,"CDI","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX10","v":45},"MOTIF/TOT MOB",null,{"$f":"IF(AX10=0,0,BA8-BA9+BA10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOVEMBRE",2033]
[null,null,"CDI","ASPA",{"$f":"VLOOKUP(D12,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I12:O12))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},"h contrat",{"$f":"H12","v":0},"HEURE CAT",{"$f":"+H12","v":0},{"$f":"AZ12*E12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DÉCEMBRE",2034]
[null,null,{"$f":"+C12","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R12:AV12)","v":0},"H. ABS",{"$f":"SUM(R13:AV13)","v":0},{"$f":"AZ13*E13","v":0}]
[null,null,{"$f":"+C13","v":"CDI"},"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX13-AZ13+AZ14","v":0},"H. SUP",{"$f":"SUM(R14:AV14)","v":0},{"$f":"IF(H12<35*52/12,IF(BB14=\"O\",AZ14*1.1*E14,AZ14*1.11*E14),AZ14*1.25*E14)","v":0},{"$f":"IF(C12=\"CDI\",IF(AZ14<AZ12*0.1,\"N\",\"O\"),\"N\")","v":"O"}]
[null,null,{"$f":"+C14","v":"CDI"},"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX14","v":0},"MOTIF/TOT MOB",null,{"$f":"IF(AX14=0,0,BA12-BA13+BA14)","v":0}]
[null,null,"CDI","ASPA",{"$f":"VLOOKUP(D16,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I16:O16))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},3,{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},"h contrat",{"$f":"H16","v":0},"HEURE CAT",{"$f":"+H16","v":0},{"$f":"AZ16*E16","v":0}]
[null,null,{"$f":"+C16","v":"CDI"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R16:AV16)","v":3},"H. ABS",{"$f":"SUM(R17:AV17)","v":0},{"$f":"AZ17*E17","v":0}]
[null,null,{"$f":"+C17","v":"CDI"},"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX17-AZ17+AZ18","v":3},"H. SUP",{"$f":"SUM(R18:AV18)","v":0},{"$f":"IF(H16<35*52/12,IF(BB18=\"O\",AZ18*1.1*E18,AZ18*1.11*E18),AZ18*1.25*E18)","v":0},{"$f":"IF(C16=\"CDI\",IF(AZ18<AZ16*0.1,\"N\",\"O\"),\"N\")","v":"O"}]
[null,null,{"$f":"+C18","v":"CDI"},"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX18","v":3},"MOTIF/TOT MOB",null,{"$f":"IF(AX18=0,0,BA16-BA17+BA18)","v":0}]

{"sheet":"723775 EPIN","index":8,"n_rows":27,"n_cols":56,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"2023-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"²"]
[723775,"ECOLE EPIN",null,null,null,"INTERMITTENT",null,null,"2019-08-05","2019-08-06","2019-08-07","2019-08-01","2019-08-02","2019-08-03","2019-08-04",null,null,{"$f":"H1","v":"2023-09-01"},{"$f":"R2+1","v":"2023-09-02"},"2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",{"$f":"#REF!+1","v":{"$error":"#REF!"}},{"$f":"AW2+1","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(BA27,BA23,BA19,BA15,BA11,BA7,BC4:BC27)","v":2214.9959666666668}]
["Nom","Prénom","CDD \n- \nCDI","QUALIFICATION","Taux Horaire","Commentaire","Libellé",{"$f":"H1","v":"2023-09-01"},1,2,3,4,5,6,7,null,null,{"$f":"+R2","v":"2023-09-01"},"2023-09-02","2023-09-03","2023-09-04","2023-09-05","2023-09-06","2023-09-07","2023-09-08","2023-09-09","2023-09-10","2023-09-11","2023-09-12","2023-09-13","2023-09-14","2023-09-15","2023-09-16","2023-09-17","2023-09-18","2023-09-19","2023-09-20","2023-09-21","2023-09-22","2023-09-23","2023-09-24","2023-09-25","2023-09-26","2023-09-27","2023-09-28","2023-09-29","2023-09-30","2023-10-01",null,"H travaillées mois","Libellé","Total heures mois","Coût total mois","AVPP","Primes","justification H Plus et Primes"]
["ALCINE","GRESELINE","CDI","ASCA",{"$f":"VLOOKUP(D4,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.79},null,"HEURE CAT",54.17,3.5,3.5,3.5,3.5,2.75,"R","R",null,null,{"$f":"+$M4","v":2.75},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3.5},{"$f":"+$J4","v":3.5},{"$f":"+$K4","v":3.5},{"$f":"+$L4","v":3.5},{"$f":"+$M4","v":2.75},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3.5},{"$f":"+$J4","v":3.5},{"$f":"+$K4","v":3.5},{"$f":"+$L4","v":3.5},{"$f":"+$M4","v":2.75},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3.5},{"$f":"+$J4","v":3.5},{"$f":"+$K4","v":3.5},{"$f":"+$L4","v":3.5},{"$f":"+$M4","v":2.75},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},{"$f":"+$I4","v":3.5},{"$f":"+$J4","v":3.5},{"$f":"+$K4","v":3.5},{"$f":"+$L4","v":3.5},{"$f":"+$M4","v":2.75},{"$f":"+$N4","v":"R"},{"$f":"+$O4","v":"R"},"h contrat",{"$f":"H4","v":54.17},"HEURE CAT",{"$f":"+H4","v":54.17},{"$f":"AZ4*E4","v":638.66430000000003}]
[null,null,{"$f":"+C4","v":"CDI"},"ASCA",11.79,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,3.5,3.5,3.5,2.75,null,null,3.5,3.5,3.5,3.5,2.75,null,null,3.5,3.5,3.5,3.5,2.75,null,null,"h travaillable",{"$f":"SUM(R4:AV4)","v":69.75},"H. ABS",{"$f":"SUM(R5:AV5)","v":50.25},{"$f":"AZ5*E5","v":592.44749999999999}]
[null,null,"CDI","ASCA",11.79,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX5-AZ5+AZ6","v":19.5},"H. SUP",{"$f":"SUM(R6:AV6)","v":0},{"$f":"IF(H4<35*52/12,IF(BB6=\"O\",AZ6*1.1*E6,AZ6*1.11*E6),AZ6*1.25*E6)","v":0},{"$f":"IF(C4=\"CDI\",IF(AZ6<AZ4*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","ASCA",11.79,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP","CP","CP","CP","CP",null,null,"CP","CP","CP","CP","CP",null,null,"CP","CP","CP","CP","CP",null,null,"h du mois",{"$f":"AX6","v":19.5},"MOTIF/TOT MOB",{"$f":"AX7","v":19.5},{"$f":"IF(AX6=0,0,BA4-BA5+BA6)","v":46.216800000000035}]
["BOUYA","JILAL","CDI","CE1",{"$f":"VLOOKUP(D8,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":13.55},null,"HEURE CAT",54.75,3,3,3,3,3,null,null,null,null,{"$f":"+$M8","v":3},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},{"$f":"+$I8","v":3},{"$f":"+$J8","v":3},{"$f":"+$K8","v":3},{"$f":"+$L8","v":3},{"$f":"+$M8","v":3},{"$f":"+$N8","v":0},{"$f":"+$O8","v":0},"h contrat",{"$f":"H8","v":54.75},"HEURE CAT",{"$f":"+H8","v":54.75},{"$f":"AZ8*E8","v":741.86250000000007}]
[null,null,{"$f":"+C8","v":"CDI"},"CE1",13.55,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,null,null,3,3,3,3,3,null,null,3,3,3,3,3,null,null,"h travaillable",{"$f":"SUM(R8:AV8)","v":63},"H. ABS",{"$f":"SUM(R9:AV9)","v":45},{"$f":"AZ9*E9","v":609.75}]
[null,null,"CDI","CE1",13.55,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX9-AZ9+AZ10","v":18},"H. SUP",{"$f":"SUM(R10:AV10)","v":0},{"$f":"IF(H8<35*52/12,IF(BB10=\"O\",AZ10*1.1*E10,AZ10*1.11*E10),AZ10*1.25*E10)","v":0},{"$f":"IF(C8=\"CDI\",IF(AZ10<AZ8*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDI","CE1",13.55,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP","CP","CP","CP","CP",null,null,"CP","CP","CP","CP","CP",null,null,"CP","CP","CP","CP","CP",null,null,"h du mois",{"$f":"AX10","v":18},"MOTIF/TOT MOB",{"$f":"AX11","v":18},{"$f":"IF(AX10=0,0,BA8-BA9+BA10)","v":132.11250000000007}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D12,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I12:O12))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},{"$f":"+$I12","v":0},{"$f":"+$J12","v":0},{"$f":"+$K12","v":0},{"$f":"+$L12","v":0},{"$f":"+$M12","v":0},{"$f":"+$N12","v":"R"},{"$f":"+$O12","v":"R"},"h contrat",{"$f":"H12","v":0},"HEURE CAT",{"$f":"+H12","v":0},{"$f":"AZ12*E12","v":0}]
[null,null,{"$f":"+C12","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R12:AV12)","v":0},"H. ABS",{"$f":"SUM(R13:AV13)","v":0},{"$f":"AZ13*E13","v":0}]
[null,null,0,"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX13-AZ13+AZ14","v":0},"H. SUP",{"$f":"SUM(R14:AV14)","v":0},{"$f":"IF(H12<35*52/12,IF(BB14=\"O\",AZ14*1.1*E14,AZ14*1.11*E14),AZ14*1.25*E14)","v":0},{"$f":"IF(C12=\"CDI\",IF(AZ14<AZ12*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,0,"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX14","v":0},"MOTIF/TOT MOB",{"$f":"AX15","v":0},{"$f":"IF(AX14=0,0,BA12-BA13+BA14)","v":0}]
[null,null,null,"ASPA",{"$f":"VLOOKUP(D16,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},null,"HEURE CAT",{"$f":"(SUBTOTAL(9,I16:O16))*52/12","v":0},null,null,null,null,null,"R","R",null,null,{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},{"$f":"+$I16","v":0},{"$f":"+$J16","v":0},{"$f":"+$K16","v":0},{"$f":"+$L16","v":0},{"$f":"+$M16","v":0},{"$f":"+$N16","v":"R"},{"$f":"+$O16","v":"R"},"h contrat",{"$f":"H16","v":0},"HEURE CAT",{"$f":"+H16","v":0},{"$f":"AZ16*E16","v":0}]
[null,null,{"$f":"+C16","v":0},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R16:AV16)","v":0},"H. ABS",{"$f":"SUM(R17:AV17)","v":0},{"$f":"AZ17*E17","v":0}]
[null,null,0,"ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX17-AZ17+AZ18","v":0},"H. SUP",{"$f":"SUM(R18:AV18)","v":0},{"$f":"IF(H16<35*52/12,IF(BB18=\"O\",AZ18*1.1*E18,AZ18*1.11*E18),AZ18*1.25*E18)","v":0},{"$f":"IF(C16=\"CDI\",IF(AZ18<AZ16*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,0,"ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX18","v":0},"MOTIF/TOT MOB",{"$f":"AX19","v":0},{"$f":"IF(AX18=0,0,BA16-BA17+BA18)","v":0}]
["BADIAGA","ALAHSSANE","CDD","ASPA",{"$f":"VLOOKUP(D20,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},"nettoyage annuel","HEURE CAT",{"$f":"(SUBTOTAL(9,I20:O20))*52/12","v":108.33333333333333},5,5,5,5,5,"R","R",null,null,{"$f":"+$M20","v":5},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":5},{"$f":"+$J20","v":5},{"$f":"+$K20","v":5},{"$f":"+$L20","v":5},{"$f":"+$M20","v":5},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},{"$f":"+$I20","v":5},{"$f":"+$J20","v":5},{"$f":"+$K20","v":5},{"$f":"+$L20","v":5},{"$f":"+$M20","v":5},{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},0,0,0,0,0,{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},0,0,0,0,0,{"$f":"+$N20","v":"R"},{"$f":"+$O20","v":"R"},"h contrat",{"$f":"H20","v":108.33333333333333},"HEURE CAT",{"$f":"+H20","v":108.33333333333333},{"$f":"AZ20*E20","v":1272.9166666666665}]
[null,null,{"$f":"+C20","v":"CDD"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R20:AV20)","v":55},"H. ABS",{"$f":"SUM(R21:AV21)","v":0},{"$f":"AZ21*E21","v":0}]
[null,null,"CDD","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX21-AZ21+AZ22","v":55},"H. SUP",{"$f":"SUM(R22:AV22)","v":0},{"$f":"IF(H20<35*52/12,IF(BB22=\"O\",AZ22*1.1*E22,AZ22*1.11*E22),AZ22*1.25*E22)","v":0},{"$f":"IF(C20=\"CDI\",IF(AZ22<AZ20*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDD","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX22","v":55},"MOTIF/TOT MOB",{"$f":"AX23","v":55},{"$f":"IF(AX22=0,0,BA20-BA21+BA22)","v":1272.9166666666665}]
["GORY","OUSMANE","CDD","ASPA",{"$f":"VLOOKUP(D24,'Taux horaire'!$A$4:$B$31,2,FALSE)","v":11.75},"nettoyage annuel","HEURE CAT",{"$f":"(SUBTOTAL(9,I24:O24))*52/12","v":65},3,3,3,3,3,"R","R",null,null,{"$f":"+$M24","v":3},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},{"$f":"+$M24","v":3},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},{"$f":"+$I24","v":3},{"$f":"+$J24","v":3},{"$f":"+$K24","v":3},{"$f":"+$L24","v":3},{"$f":"+$M24","v":3},{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},0,0,0,0,0,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},0,0,0,0,0,{"$f":"+$N24","v":"R"},{"$f":"+$O24","v":"R"},"h contrat",{"$f":"H24","v":65},"HEURE CAT",{"$f":"+H24","v":65},{"$f":"AZ24*E24","v":763.75}]
[null,null,{"$f":"+C24","v":"CDD"},"ASPA",11.75,null,"H. ABS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillable",{"$f":"SUM(R24:AV24)","v":33},"H. ABS",{"$f":"SUM(R25:AV25)","v":0},{"$f":"AZ25*E25","v":0}]
[null,null,"CDD","ASPA",11.75,null,"H. SUP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h travaillées",{"$f":"AX25-AZ25+AZ26","v":33},"H. SUP",{"$f":"SUM(R26:AV26)","v":0},{"$f":"IF(H24<35*52/12,IF(BB26=\"O\",AZ26*1.1*E26,AZ26*1.11*E26),AZ26*1.25*E26)","v":0},{"$f":"IF(C24=\"CDI\",IF(AZ26<AZ24*0.1,\"N\",\"O\"),\"N\")","v":"N"}]
[null,null,"CDD","ASPA",11.75,null,"MOTIFS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"h du mois",{"$f":"AX26","v":33},"MOTIF/TOT MOB",{"$f":"AX27","v":33},{"$f":"IF(AX26=0,0,BA24-BA25+BA26)","v":763.75}]