{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["board","Ressources humaine","fonctions","Contrat","Gestion ABS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":"board","index":0,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,13,6,17],[7,7,7,12],[8,7,8,12],[15,7,15,8],[15,9,15,10],[16,6,16,12],[20,8,20,9],[20,10,20,12],[21,8,21,9],[21,10,21,12],[17,8,17,9],[17,10,17,12],[18,8,18,9],[18,10,18,12],[19,8,19,9],[19,10,19,12]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PARAMATRES"]
[null,null,null,null,null,null,"Nom de l'entreprise","OPGI",null,null,null,null,null,"Legend  Absences","Abrv(abs)","CAT/ SOCIO","Type de contrat","sexe"]
[null,null,null,null,null,null,"Adresse","jijel ,180000",null,null,null,null,null,"ABS AUTORISE","AA","CAD/DIR","CDI","Male"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ABS NON AUTORISE","AN","CAD","CDD","Femal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMATION","FO","MAI","ANEM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CONGE PAYER","CP","EXE","CTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CONGE SANS SOLDE","CSS",null,"STAGAIR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MISE A PIED","MP",null,"STAGAIR PROF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ABS PAYER","AP"]
[null,null,null,null,null,null,null,"code",null,3]
[null,null,null,null,null,null,"ETAT CEVIL"]
[null,null,null,null,null,null,"Nom et prenom",{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],2,FALSE),\" \")","v":"marks overmars"},"Date de naissance",null,{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],3,FALSE),\" \")","v":"1982-02-17"}]
[null,null,null,null,null,null,"Leiu de naissance",{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],4,FALSE),\" \")","v":"jijel"},"Adresse",null,{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],5,FALSE),\" \")","v":"jijel 18003"}]
[null,null,null,null,null,null,"Age",{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],7,FALSE),\" \")","v":32},"Date de recrutement",null,{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],9,FALSE),\" \")","v":"2012-03-06"}]
[null,null,null,null,null,null,"type de contrat",{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],13,FALSE),\" \")","v":"CTA"},"N° SS",null,{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],8,FALSE),\" \")","v":4245434}]
[null,null,null,null,null,null,"Date de sorite",{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],10,FALSE),\" \")","v":"00:00:00"},"motife",null,{"$f":"IFERROR(VLOOKUP(board!$J$16,Tableau2[],11,FALSE),\"-\")","v":0}]

{"sheet":"Ressources humaine","index":1,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[3,0,3,13],[4,0,4,13]]}
[]
[]
[]
[{"$f":"board!H8","v":"OPGI"}]
[{"$f":"board!H9","v":"jijel ,180000"}]
["N°","Nom et prenom","date de naissance","lieu de naissannce","Adresse","SEXE","Age","N° SS","Date de recrutement","Date de sortie","Motif","Experience interne","type de contrat"]
[1,"messahel messaoud","1982-02-14","jijel","jijel 18000","Male",{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":32},254524,"2012-03-03","2021-07-21","rien",{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CTA"]
[1,"bonar abdelslam","1987-02-15","jijel","jijel 18001",null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":27},4242,"2012-03-04",null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CDD"]
[1,"bouchouia amar","1974-07-14","texenna","jijel 18004",null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":40},11111111111,"2012-03-03",null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CTA"]
[2,"ferdi f","1982-02-16","jijel","jijel 18002",null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":32},24524,"2012-03-05",null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CTA"]
[3,"marks overmars","1982-02-17","jijel","jijel 18003",null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":32},4245434,"2012-03-06",null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CTA"]
[5,"hadji kamel","1986-05-18","elaouna","texenna",null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":28},55415415415,"2012-03-03",null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":2},"CTA"]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]
[null,null,null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[date de naissance]],TODAY(),\"y\")","v":114},null,null,null,null,{"$f":"DATEDIF(Tableau2[[#This Row],[Date de recrutement]],TODAY(),\"y\")","v":114}]

{"sheet":"fonctions","index":2,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"poste","description de poste"]
[null,null,null,null,"CAD CHARGE DE LA PAIE         ","il est charge de planifier recrute gere le RH-la gestion est la stratigier de la formatio-plas de carrier-rem"]
[null,null,null,null,"DIRECTEUR GENERAL             "]
[null,null,null,null,"DIRECTEUR DE MAINTENANCE      "]
[null,null,null,null,"DIRECTEUR D EXPLOITATION      "]
[null,null,null,null,"DIRECTEUR D'ADMIN & FINANCES  "]
[null,null,null,null,"ASSIST/CHARGE/MARKETING       "]
[null,null,null,null,"ASSIST/CHARGE/AUDIT           "]
[null,null,null,null,"CHEF SERVICE RESSOURCES HUMAIN"]
[null,null,null,null,"MECANICIEN DE BUS             "]
[null,null,null,null,"ELECTRIECIEN BUS              "]
[null,null,null,null,"CAD CHARGE DE LA GRH          "]
[null,null,null,null,"CAD CHARGE DE LA PAIE         "]
[null,null,null,null,"CHEF DE SERVICE GRH           "]
[null,null,null,null,"CAD CHARGE DE CONTENTIEUX     "]
[null,null,null,null,"CHEF SRVC FININCE ET COMPTA   "]
[null,null,null,null,"REGISSEUR                     "]
[null,null,null,null,"CAD COMPTABLE                 "]
[null,null,null,null,"CAD FINANCIER                 "]
[null,null,null,null,"AGENT DE SECURITE             "]
[null,null,null,null,"CHAUFFEUR                     "]
[null,null,null,null,"RECEVEUR                      "]
[null,null,null,null,"ACHETEUR DEMARCHEUR           "]
[null,null,null,null,"CHEF D ATELIER/ BUS           "]
[null,null,null,null,"DIRECTION GENERAL             "]
[null,null,null,null,"AGENT ADMINISTRATIF           "]
[null,null,null,null,"CHEF DE PARC                  "]
[null,null,null,null,"LAVEUR/POMPISTE               "]
[null,null,null,null,"CONTROLEUR DE LIGNE           "]
[null,null,null,null,"TOLIER                        "]
[null,null,null,null,"SERVICE MAINTENANACE          "]
[null,null,null,null,"MAGASINIER                    "]
[null,null,null,null,"CADRE CHARGE D'ACHAT          "]
[null,null,null,null,"CADRE CHARGE /STOCK           "]
[null,null,null,null,"REGISSEUR                     "]
[null,null,null,null,"REGULATEUR/BUS                "]
[null,null,null,null,"COMPTABLE                     "]
[null,null,null,null,"CAD CHARGE /PROGRMMATION/BUS  "]

{"sheet":"Contrat","index":3,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,0,5,9],[1,0,1,2],[6,0,6,9]]}
[]
["Recherche:"]
["Type",null,"NB mois"]
["Mot de recherche",null,"1900-01-01"]
[]
[{"$f":"board!H8","v":"OPGI"}]
[{"$f":"board!H9","v":"jijel ,180000"}]
[null,null,"Recherche par:",null,{"$f":"C3","v":"NB mois"},{"$f":"C4","v":1}]
[]
["N°","Nom et prenom","Fonction","NB mois","Date de debut","Date de transmission d'evaluation 10 J ","Date de fin","Aujourdhui","Alarme evaluation"," Alarme contrat"]
[2,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",21,"2009-01-01",{"$f":"IFERROR(DATE(YEAR(E11),MONTH(E11)+D11,DAY(E11)-10),\" \")","v":"2010-09-21"},{"$f":"IFERROR(DATE(YEAR(E11),MONTH(E11)+D11,DAY(E11-1)),\" \")","v":"2010-10-31"},{"$f":"TODAY()","v":"2014-07-16"},{"$f":"IF(H11>=F11,\" Rest 10 j \",\"\")","v":" Rest 10 j "},{"$f":"IF(H11>=G11,\"Info:fin de contrat \",\" \")","v":"Info:fin de contrat "}]
[5,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"hadji kamel"},"CAD CHARGE DE LA PAIE         ",1,null,"1900-01-21","","2014-07-16"," Rest 10 j "," "]
[2,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",6,"2017-03-05","2017-08-26","2017-09-04","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",1,"2018-03-05","2018-03-26",{"$f":"IFERROR(DATE(YEAR(E14),MONTH(E14)+D14,DAY(E14-1)),\" \")","v":"2018-04-04"},"2014-07-16",""," "]
[2,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",6,"2024-03-05","2024-08-26","2024-09-04","2014-07-16",""," "]
[1,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"messahel messaoud"},"CAD CHARGE DE LA PAIE         ",null,null,{"$f":"IFERROR(DATE(YEAR(E16),MONTH(E16)+D16,DAY(E16)-10),\" \")","v":""},{"$f":"IFERROR(DATE(YEAR(E16),MONTH(E16)+D16,DAY(E16-1)),\" \")","v":""},{"$f":"TODAY()","v":"2014-07-16"},{"$f":"IF(H16>=F16,\" Rest 10 j \",\"\")","v":""},{"$f":"IF(H16>=G16,\"Info:fin de contrat \",\" \")","v":" "}]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[5,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"hadji kamel"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[2,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[3,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(DATE(YEAR(E31),MONTH(E31)+D31,DAY(E31)-10),\" \")","v":""},{"$f":"IFERROR(DATE(YEAR(E31),MONTH(E31)+D31,DAY(E31-1)),\" \")","v":""},{"$f":"TODAY()","v":"2014-07-16"},{"$f":"IF(H31>=F31,\" Rest 10 j \",\"\")","v":""},{"$f":"IF(H31>=G31,\"Info:fin de contrat \",\" \")","v":" "}]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]
[null,{"$f":"IFERROR(VLOOKUP(Tableau7[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,"","","2014-07-16",""," "]

{"sheet":"Gestion ABS","index":4,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,0,1,2],[5,0,5,9],[6,0,6,9],[2,0,2,1],[3,0,3,1]]}
[]
["Recherche:"]
["Type",null,"Type d'ABS"]
["Mot de recherche",null,"formation"]
[]
[{"$f":"board!H8","v":"OPGI"}]
[{"$f":"board!H9","v":"jijel ,180000"}]
[null,null,"Recherche par:",null,null,null,{"$f":"C3","v":"Type d'ABS"},{"$f":"C4","v":"formation"}]
[]
["N°","Nom et prenom","Fonction","Cat/Socio","Type d'ABS","NBR J","Date de debut","date de fin","Aujourdhui","Observation"]
[2,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ","CAD","FORMATION",21,"2014-03-05",{"$f":"IFERROR(DATE(YEAR(G11),MONTH(G11),DAY(G11)-10)+F11,\" \")","v":"2014-03-16"},{"$f":"TODAY()","v":"2014-07-16"},{"$f":"IF(I11>=H11,\" Abbsence consommé \",\"\")","v":" Abbsence consommé "}]
[5,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"hadji kamel"},"CAD CHARGE DE LA PAIE         ","MAI","FORMATION",1,null," ","2014-07-16",""]
[2,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",null,null,6,"2017-03-05","2017-03-01","2014-07-16",""]
[1,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"messahel messaoud"},"CAD CHARGE DE LA PAIE         ",null,null,1,"2018-03-05","2018-02-24","2014-07-16",""]
[2,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",null,null,6,"2024-03-05","2024-03-01","2014-07-16",""]
[1,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"messahel messaoud"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[5,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"hadji kamel"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[2,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"ferdi f"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[3,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":"marks overmars"},"CAD CHARGE DE LA PAIE         ",null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]
[null,{"$f":"IFERROR(VLOOKUP(Tableau77[[#This Row],[N°]],Tableau2[#All],2,FALSE),\"\")","v":""},null,null,null,null,null," ","2014-07-16",""]