{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Param","PériodeAlerte","Accueil","Coordonnées","Formation","Visite médicale","Badge","Permis civil","Sureté","SPPA","Aide","Visue générale","Fiche indiv","Parametrage"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":50,"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":"Param","index":0,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Titre","Aéroport Béziers Cap-d'Agde",null,null,null,null,null,"MdP  gg","*sslia*"]
["Service","SSLIA",null,null,null,null,null,"NE PAS EFFACER  h"]
[]
["Aptitude","RDV pris","Thème form","Permis",null,"Thème sppa","Liste Visue générale"]
["Apte","V","Aire de manœuvre","Poids lourd",null,"Maniment des armes","Poids lourd"]
["Inapte temporaire",null,"Ensemble de l'aérodrome (ZA)","Piste",null,"Réglementation","Piste"]
["Inapte",null,"Abord de l'aérodrome (ZVA)","Bâteau",null,"Connaissance des animaux","Bâteau"]
[null,null,"Equipements de protection individuels"]
[null,null,"Stage de recyclage 35h"]

{"sheet":"PériodeAlerte","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Tableau Formation",null,null,null,null,"Tableau Permis"]
[]
["Thème","Délai","début alerte (en jour)","fin alerte (en jour)",null,"Thème","Délai","début alerte (en jour)","fin alerte (en jour)"]
["Aire de manœuvre","toutes les 2 semaines",7,1,null,"Poids lourd","tous les 5 ans",60,1]
["Ensemble de l'aérodrome (ZA)","1 fois par mois",7,1,null,"Piste","1 fois par an",30,1]
["Abord de l'aérodrome (ZVA)","tous les 3 mois",15,1,null,"Bâteau","néan",2,1]
["Equipements de protection individuels","tous les 3 mois",7,1]
["Stage de recyclage 35h","tous les 3 ans",150,1]
[]
[]
[]
["Tableau Visite médicale",null,null,null,null,"Tableau Sûreté"]
[]
["Thème","Délai","début alerte (en jour)","fin alerte (en jour)",null,"Thème","Délai","début alerte (en jour)","fin alerte (en jour)"]
["Visite médicale","1 fois par an",60,1,null,"Recyclage sûreté","1 fois par an",30,1]
["Vide","Vide"]
[]
[]
[]
[]
[]
[]
["Tableau Badge",null,null,null,null,"Tableau SPPA"]
[]
["Thème","Délai","début alerte (en jour)","fin alerte (en jour)",null,"Thème","Délai","début alerte (en jour)","fin alerte (en jour)"]
["Renouvellement badge","tous les 3 ans",60,1,null,"Maniment des armes",null,60,1]
[null,null,null,null,null,"Réglementation",null,30,1]
[null,null,null,null,null,"Connaissance des animaux",null,25,1]

{"sheet":"Accueil","index":2,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,13,1,15],[23,12,23,13],[23,17,23,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Suivi Rappel de Date"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"v Objectif"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Avoir une coordination précise entre les rappels de date et les prises de RDV, puis dans le cadre de pourvoir faire"]
[null,null,null,null,null,null,null,null,null,null,null,null,"évoluer au mieux notre outil de travail grâce à la traçabilité de ce suivi administratif pour les futurs certifications."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"A","1er Echelon :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Concerne les personnels du service administratif."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Dédier à la surveillance des alertes et le renseignement des suivis des RDV."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Assurer la liaison entre le service administratif et le responsable de service."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Assure le suivi des dates et prise de RDV après accord du responsable de service."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Accès à l'ensemble des fonctionnalitées inscrit \"Avertissement\"."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"A","2ème Echelon :"]
[null,"n",null,null,"Alerte",{"$f":"Formation!AA2","v":4},"n",null,null,"Alerte",{"$f":"'Visite médicale'!AA2","v":0},null,null,"Concerne le responsable de service."]
[null,null,null,null,"Retard",{"$f":"Formation!AB2","v":0},null,null,null,"Retard",{"$f":"'Visite médicale'!AB2","v":0},null,null,"Accès à l'ensemble des fonctionnalitées :"]
[null,null,null,null,"RDV confirmé",{"$f":"Formation!AC2","v":0},null,null,null,"RDV confirmé",{"$f":"'Visite médicale'!AC2","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"v Information période"]
[]
[null,"n",null,null,"Alerte",{"$f":"Badge!AA2","v":1},"n",null,null,"Alerte",{"$f":"Sureté!AA2","v":1},null,"Thèmes",null,null,"Délai",null,"Thèmes",null,null,"Délai"]
[null,null,null,null,"Retard",{"$f":"Badge!AB2","v":2},null,null,null,"Retard",{"$f":"Sureté!AB2","v":0},null,{"$f":"PériodeAlerte!A1","v":"Tableau Formation"}]
[null,null,null,null,"RDV confirme",{"$f":"Badge!AC2","v":6},null,null,null,"RDV confirmé",{"$f":"Sureté!AC2","v":0},null,{"$f":"PériodeAlerte!A4","v":"Aire de manœuvre"},null,null,{"$f":"PériodeAlerte!B4","v":"toutes les 2 semaines"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A5","v":"Ensemble de l'aérodrome (ZA)"},null,null,{"$f":"PériodeAlerte!B5","v":"1 fois par mois"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A6","v":"Abord de l'aérodrome (ZVA)"},null,null,{"$f":"PériodeAlerte!B6","v":"tous les 3 mois"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A7","v":"Equipements de protection individuels"},null,null,{"$f":"PériodeAlerte!B7","v":"tous les 3 mois"}]
[null,"n",null,null,"Alerte",{"$f":"'Permis civil'!AA2","v":0},"n",null,null,"Alerte",{"$f":"SPPA!AA2","v":2},null,{"$f":"PériodeAlerte!A8","v":"Stage de recyclage 35h"},null,null,{"$f":"PériodeAlerte!B8","v":"tous les 3 ans"}]
[null,null,null,null,"Retard",{"$f":"'Permis civil'!AB2","v":0},null,null,null,"Retard",{"$f":"SPPA!AB2","v":0}]
[null,null,null,null,"RDV confirmé",{"$f":"'Permis civil'!AC2","v":5},null,null,null,"RDV confirmé",{"$f":"SPPA!AC2","v":6},null,{"$f":"PériodeAlerte!A12","v":"Tableau Visite médicale"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A15","v":"Visite médicale"},null,null,{"$f":"PériodeAlerte!B15","v":"1 fois par an"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A16","v":"Vide"},null,null,{"$f":"PériodeAlerte!B16","v":"Vide"}]
[]
[null,"n",null,null,"Vide",null,"n",null,null,"Vide",null,null,{"$f":"PériodeAlerte!A23","v":"Tableau Badge"}]
[null,null,null,null,"Vide",null,null,null,null,"Vide",null,null,{"$f":"PériodeAlerte!A26","v":"Renouvellement badge"},null,null,{"$f":"PériodeAlerte!B26","v":"tous les 3 ans"}]
[null,null,null,null,"Vide",null,null,null,null,"Vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!F12","v":"Tableau Sûreté"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!F15","v":"Recyclage sûreté"},null,null,{"$f":"PériodeAlerte!G15","v":"1 fois par an"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!F1","v":"Tableau Permis"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!F4","v":"Poids lourd"},null,null,{"$f":"PériodeAlerte!G4","v":"tous les 5 ans"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PériodeAlerte!F5","v":"Piste"},null,null,{"$f":"PériodeAlerte!G5","v":"1 fois par an"}]

{"sheet":"Coordonnées","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Clé","Civil","Nom - Prénom","Service","Fonction","Type contrat","Date embauche","Date de naissance","Age","Adresse","CP","Ville","Mobile","Mail","Observations"]
[null,1,"Mr","AFONSO Julien","SSLIA","Pompier D'Aéroport","CDI","2010-09-01","1981-04-12",34,null,null,"NGDRT"]
[null,2,"Mr","AUDIÉ Anthony","SSLIA","Pompier D'Aéroport","CDI","2005-06-05","1984-06-10",31,null,null,"VENHGFD"]
[null,3,"Mr","BÉNAZET Jean-René","SSLIA","Chef De Manoeuvre","CDI","1985-03-05","1959-09-11",56,null,null,"NISSAN"]
[null,4,"Mr","CUENCA Ludovic","SSLIA","Pompier D'Aéroport","CDI"]
[null,5,"Mr","DISTÉFANO Alexis","SSLIA","Pompier D'Aéroport","CDI"]
[null,6,"Mr","KOSEL Franck","SSLIA","Responsable De Service","CDI"]
[null,7,"Mr","LEROY France","SSLIA","Pompier D'Aéroport","CDI","2011-07-07","1968-02-03",47]
[null,8,"Mr","NAVARRO Christophe","SSLIA","Chef De Manoeuvre","CDI","1998-02-02","1970-11-13",45,null,null,"KJHGF"]
[null,9,"Mr","PIERRAIN Didier","SSLIA","Pompier D'Aéroport","CDI","2002-09-10","1950-11-10",65]
[null,10,"Mr","PONS Thierry","SSLIA","Pompier D'Aéroport","CDI"]
[null,11,"Mr","SANTOS Jean-François","SSLIA","Chef De Manoeuvre","CDI"]
[null,12,"Mr","SCHWEITZER Jean-Michel","SSLIA","Chef De Manoeuvre","CDI"]
[null,13,"Mr","ZARAGOZA Didier","SSLIA","Chef De Manoeuvre","CDI","1988-05-26","1955-06-11",60,null,null,null,null,null,"azerty"]
[null,14,"Mme","AZERTY Mlkjhgf","QSDFGH","Nbvcxwqsd","CDD","2001-09-22","1970-04-16",45,"qsdfg",12354,"NBVC","02.01.03.05.04","qsdf","jhg ertyu"]
[null,15,"Mlle","SDFGH Jhgfd","DFGH","Kjhgf","HGF","1997-03-25","1998-01-09",17,"sdfg",12542,"SDF","01.02.01.02.03","sdfghj","mlkjhgf"]

{"sheet":"Formation","index":4,"n_rows":12,"n_cols":46,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,"Aire de manœuvre","Z.A","Z.V.A","E.P.I","C2FPA",null,{"$f":"PériodeAlerte!A4","v":"Aire de manœuvre"},null,{"$f":"PériodeAlerte!A5","v":"Ensemble de l'aérodrome (ZA)"},null,{"$f":"PériodeAlerte!A6","v":"Abord de l'aérodrome (ZVA)"},null,{"$f":"PériodeAlerte!A7","v":"Equipements de protection individuels"},null,{"$f":"PériodeAlerte!A8","v":"Stage de recyclage 35h"}]
[null,"Alerte","Clé","Civil","Nom - Prénom","Date formation","Thème","Lieu","Aptitude","Date à revoir","Valider","Observation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE2:AI2)","v":4},{"$f":"SUMPRODUCT(N(ColAlerteForm=0)-(ColAlerteForm=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteForm=\"\"))","v":0},null,{"$f":"(SUMPRODUCT((ColAlerteForm<=AK2)*(ColAlerteForm>=AL2)*(ColThèmeForm=AK1)))","v":0},{"$f":"(SUMPRODUCT((ColAlerteForm<=AM2)*(ColAlerteForm>=AN2)*(ColThèmeForm=AM1)))","v":1},{"$f":"(SUMPRODUCT((ColAlerteForm<=AO2)*(ColAlerteForm>=AP2)*(ColThèmeForm=AO1)))","v":1},{"$f":"(SUMPRODUCT((ColAlerteForm<=AQ2)*(ColAlerteForm>=AR2)*(ColThèmeForm=AQ1)))","v":1},{"$f":"(SUMPRODUCT((ColAlerteForm<=AS2)*(ColAlerteForm>=AT2)*(ColThèmeForm=AS1)))","v":1},null,{"$f":"PériodeAlerte!C4","v":7},{"$f":"PériodeAlerte!D4","v":1},{"$f":"PériodeAlerte!C5","v":7},{"$f":"PériodeAlerte!D5","v":1},{"$f":"PériodeAlerte!C6","v":15},{"$f":"PériodeAlerte!D6","v":1},{"$f":"PériodeAlerte!C7","v":7},{"$f":"PériodeAlerte!D7","v":1},{"$f":"PériodeAlerte!C8","v":150},{"$f":"PériodeAlerte!D8","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2014-09-22","Aire de manœuvre",null,"Apte","2015-10-07","V"]
[null,5,15,"Mlle","SDFGH Jhgfd","2015-10-02","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-11-02"]
[null,61,14,"Mme","AZERTY Mlkjhgf","2015-09-28","Abord de l'aérodrome (ZVA)",null,"Apte","2015-12-28"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2015-10-07","Aire de manœuvre",null,"Apte","2015-10-22","V"]
[null,79,15,"Mlle","SDFGH Jhgfd","2015-10-15","Equipements de protection individuels",null,"Apte","2016-01-15"]
[null,9,14,"Mme","AZERTY Mlkjhgf","2015-10-22","Aire de manœuvre",null,"Apte","2015-11-06"]
[null,3,1,"Mr","AFONSO Julien","2015-11-01","Abord de l'aérodrome (ZVA)",null,null,"2015-12-06"]
[null,5,6,"Mr","KOSEL Franck","2015-11-11","Equipements de protection individuels",null,null,"2016-01-05"]
[null,50,1,"Mr","AFONSO Julien","2015-11-21","Stage de recyclage 35h",null,null,"2016-02-04"]

{"sheet":"Visite médicale","index":5,"n_rows":9,"n_cols":38,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,null,null,null,null,null,null,{"$f":"PériodeAlerte!A15","v":"Visite médicale"}]
[null,"Alerte","Clé","Civil","Nom - Prénom","Date contact","Par qui","Date RDV","Lieu RDV","Aptitude","Date à revoir","RDV pris","Observation",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUMPRODUCT((ColAlerteVisMed<=AK2)*(ColAlerteVisMed>=AL2)))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteVisMed=0)-(ColAlerteVisMed=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteVisMed=\"\"))","v":0},null,null,null,null,null,null,null,{"$f":"PériodeAlerte!C15","v":60},{"$f":"PériodeAlerte!D15","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2014-07-31","SDFGH Jhgfd","2014-08-31",null,"Apte","2015-08-31","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","2014-09-25","SDFGH Jhgfd","2014-10-10",null,"Apte","2015-10-10","V"]
[null,308,14,"Mme","AZERTY Mlkjhgf","2015-08-10","SDFGH Jhgfd","2015-08-31",null,"Apte","2016-08-31"]
[null,348,15,"Mlle","SDFGH Jhgfd","2015-09-29","SDFGH Jhgfd","2015-10-10",null,"Apte","2016-10-10"]
[null,222,1,"Mr","AFONSO Julien",null,null,"2015-01-01","lieu",null,"2015-12-31"]
[null,3333,1,"Mr","AFONSO Julien",null,null,"2016-03-03","aaaaa",null,"2016-12-31"]

{"sheet":"Badge","index":6,"n_rows":16,"n_cols":33,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,null,{"$f":"PériodeAlerte!A26","v":"Renouvellement badge"}]
[null,"Alerte","Clé","Civil","Nom - Prénom","Date demande","Par qui","Date réception","Délivré par","Date à  revoir","RDV pris","Site","N°","Société","Secteur fonctionnel NAV - TRV - MAN - ENE","Secteur de Sûreté A - B - F - P","Observation",null,null,null,null,null,null,null,null,null,{"$f":"(SUMPRODUCT((ColAlerteBadge<=AF2)*(ColAlerteBadge>=AG2)))","v":1},{"$f":"SUMPRODUCT(N(ColAlerteBadge=0)-(ColAlerteBadge=\"\"))","v":2},{"$f":"SUMPRODUCT(N(ColAlerteBadge=\"\"))","v":6},null,null,{"$f":"PériodeAlerte!C26","v":60},{"$f":"PériodeAlerte!D26","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2012-02-05","SDFGH Jhgfd","2012-02-28",null,"2015-02-25","V",null,"000 00 000000"]
[null,30,15,"Mlle","SDFGH Jhgfd","2012-11-05","SDFGH Jhgfd","2013-01-02",null,"2015-11-27",null,null,"000 00 000000"]
[null,841,14,"Mme","AZERTY Mlkjhgf","2015-01-15","SDFGH Jhgfd","2015-02-18",null,"2018-02-15",null,null,"000 00 000000"]
[null,null,15,"Mlle","SDFGH Jhgfd","2015-10-28","SDFGH Jhgfd",null,null,{"$f":"J6+10","v":"2018-02-25"}]
[null,null,1,"Mr","AFONSO Julien",{"$f":"F7+10","v":"2015-11-07"},null,null,null,{"$f":"J7+10","v":"2018-03-07"}]
[null,null,1,"Mr","AFONSO Julien",{"$f":"F8+10","v":"2015-11-17"},null,null,null,"2018-03-17"]
[null,null,2,"Mr","AUDIÉ Anthony",{"$f":"F9+10","v":"2015-11-27"},null,null,null,"2018-03-27"]
[null,null,7,"Mr","LEROY France",{"$f":"F10+10","v":"2015-12-07"},null,null,null,"2018-04-06"]
[null,null,4,"Mr","CUENCA Ludovic",{"$f":"F11+10","v":"2015-12-17"},null,null,null,"2018-04-16"]
[null,0,3,"Mr","BÉNAZET Jean-René","2012-01-01","CUENCA Ludovic",null,null,"2012-12-31"]
[null,0,7,"Mr","LEROY France","2013-01-01",null,null,null,"2013-12-31"]
[null,63,5,"Mr","DISTÉFANO Alexis","2015-01-01","KOSEL Franck",null,null,"2015-12-31"]
[null,429,3,"Mr","BÉNAZET Jean-René","2016-01-01",null,null,null,"2016-12-31"]

{"sheet":"Permis civil","index":7,"n_rows":15,"n_cols":40,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,{"$f":"PériodeAlerte!F4","v":"Poids lourd"},{"$f":"PériodeAlerte!F5","v":"Piste"},{"$f":"PériodeAlerte!F6","v":"Bâteau"},null,{"$f":"PériodeAlerte!F4","v":"Poids lourd"},null,{"$f":"PériodeAlerte!F5","v":"Piste"},null,{"$f":"PériodeAlerte!F6","v":"Bâteau"}]
[null,"Alerte","Clé","Civil","Nom - Prénom","Type permis","Date   contact","Par qui","Date RDV","Lieu RDV","Aptitude","Date à  revoir","RDV pris","Observation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE2:AG2)","v":0},{"$f":"SUMPRODUCT(N(ColAlertePermisCiv=0)-(ColAlertePermisCiv=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlertePermisCiv=\"\"))","v":5},null,{"$f":"(SUMPRODUCT((ColAlertePermisCiv<=AI2)*(ColAlertePermisCiv>=AJ2)*(ColThemePermis=AI1)))","v":0},{"$f":"(SUMPRODUCT((ColAlertePermisCiv<=AK2)*(ColAlertePermisCiv>=AL2)*(ColThemePermis=AK1)))","v":0},{"$f":"(SUMPRODUCT((ColAlertePermisCiv<=AM2)*(ColAlertePermisCiv>=AN2)*(ColThemePermis=AM1)))","v":0},null,{"$f":"PériodeAlerte!H4","v":60},{"$f":"PériodeAlerte!I4","v":1},{"$f":"PériodeAlerte!H5","v":30},{"$f":"PériodeAlerte!I5","v":1},{"$f":"PériodeAlerte!H6","v":2},{"$f":"PériodeAlerte!I6","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","Poids lourd","2010-03-05","SDFGH Jhgfd","2010-03-20",null,"Apte","2015-03-20","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","Bâteau","2012-06-05","SDFGH Jhgfd","2012-06-28",null,"Apte","2014-06-28","V"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","Bâteau","2012-08-10","SDFGH Jhgfd","2012-08-18",null,"Apte","2014-08-18","V"]
[null,703,15,"Mlle","SDFGH Jhgfd","Poids lourd","2012-09-20","SDFGH Jhgfd","2012-09-30",null,"Apte","2017-09-30"]
[null,246,15,"Mlle","SDFGH Jhgfd","Bâteau","2014-05-25","SDFGH Jhgfd","2014-06-30",null,"Apte","2016-06-30"]
[null,276,14,"Mme","AZERTY Mlkjhgf","Bâteau","2014-06-21","SDFGH Jhgfd","2014-07-30",null,"Apte","2016-07-30"]
[null,1605,14,"Mme","AZERTY Mlkjhgf","Poids lourd","2015-03-05","SDFGH Jhgfd","2015-03-20",null,"Apte","2020-03-20"]
[null,null,7,"Mr","LEROY France",null,"2015-03-15",null,"2015-03-30",null,null,"2020-03-30"]
[null,null,1,"Mr","AFONSO Julien",null,"2015-03-25",null,"2015-04-09",null,null,"2020-04-09"]
[null,null,5,"Mr","DISTÉFANO Alexis",null,"2015-04-04",null,"2015-04-19",null,null,"2020-04-19"]
[null,null,2,"Mr","AUDIÉ Anthony",null,"2015-04-14",null,"2015-04-29",null,null,"2020-04-29"]
[null,null,1,"Mr","AFONSO Julien",null,"2015-04-24",null,"2015-05-09",null,null,"2020-05-09"]

{"sheet":"Sureté","index":8,"n_rows":12,"n_cols":33,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,null,{"$f":"PériodeAlerte!F15","v":"Recyclage sûreté"}]
[null,"Alerte","Clé","Civil","Nom - Prénom","Site","Date   contact","Par qui","Date recyclage","Lieu recyclage","Aptitude","Date à   revoir","RDV pris","Observation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUMPRODUCT((ColAlerteSurete<=AF2)*(ColAlerteSurete>=AG2)))","v":1},{"$f":"SUMPRODUCT(N(ColAlerteSurete=0)-(ColAlerteSurete=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteSurete=\"\"))","v":0},null,null,{"$f":"PériodeAlerte!H15","v":30},{"$f":"PériodeAlerte!I15","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","Site 1","2012-05-12",null,"2012-05-20",null,"Apte","2012-11-20","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","Site 1","2012-08-25",null,"2012-06-05",null,"Apte","2012-12-05","V"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","Site","2012-11-05",null,"2012-11-20",null,"Apte","2013-05-20","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd",null,"2012-11-15",null,"2012-12-05",null,"Apte","2013-06-05","V"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf",null,"2013-04-28",null,"2013-05-20",null,"Apte","2013-11-20","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","Site 1","2013-05-20",null,"2014-06-05",null,"Apte","2015-06-05","V"]
[null,389,14,"Mme","AZERTY Mlkjhgf","Site 1","2015-11-02",null,"2015-11-20",null,"Apte","2016-11-20"]
[null,8,15,"Mlle","SDFGH Jhgfd",null,"2014-10-22",null,"2014-11-05",null,"Apte","2015-11-05"]
[null,300,1,"Mr","AFONSO Julien",null,"2015-01-01",null,"2015-12-31",null,null,"2016-12-31"]

{"sheet":"SPPA","index":9,"n_rows":14,"n_cols":40,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"g Alerte     g Retard     g RDV confirmé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alerte","retard","RDV",null,{"$f":"PériodeAlerte!F26","v":"Maniment des armes"},null,{"$f":"PériodeAlerte!F27","v":"Réglementation"},null,{"$f":"PériodeAlerte!F28","v":"Connaissance des animaux"},null,null,"Maniment des armes","Rappel des textes","Connaissance des animaux"]
[null,"Alerte","Clé","Civil","Nom - Prénom","Date formation","Thème","Site","Par qui","Aptitude","Date à revoir","RDV pris","Observation",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AL2:AN2)","v":2},{"$f":"SUMPRODUCT(N(ColAlerteSppa=0)-(ColAlerteSppa=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteSppa=\"\"))","v":6},null,{"$f":"PériodeAlerte!H26","v":60},{"$f":"PériodeAlerte!I26","v":1},{"$f":"PériodeAlerte!H27","v":30},{"$f":"PériodeAlerte!I27","v":1},{"$f":"PériodeAlerte!H28","v":25},{"$f":"PériodeAlerte!I28","v":1},null,{"$f":"(SUMPRODUCT((ColAlerteSppa<=AE2)*(ColAlerteSppa>=AF2)*(ColThèmeSPPA=AE1)))","v":0},{"$f":"(SUMPRODUCT((ColAlerteSppa<=AG2)*(ColAlerteSppa>=AH2)*(ColThèmeSPPA=AG1)))","v":1},{"$f":"(SUMPRODUCT((ColAlerteSppa<=AI2)*(ColAlerteSppa>=AJ2)*(ColThèmeSPPA=AI1)))","v":1}]
[null,"ok",null,null,"Ne pas effacer cette ligne"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2014-04-05","Réglementation",null,"SDFGH Jhgfd","Apte","2015-04-05","V"]
[null,22,15,"Mlle","SDFGH Jhgfd","2014-11-19","Réglementation",null,"SDFGH Jhgfd","Apte","2015-11-19"]
[null,160,14,"Mme","AZERTY Mlkjhgf","2015-04-05","Réglementation",null,"SDFGH Jhgfd","Apte","2016-04-05"]
[null,25,15,"Mlle","SDFGH Jhgfd","2014-12-02","Connaissance des animaux",null,"SDFGH Jhgfd","Apte","2015-11-22"]
[null,47,14,"Mme","AZERTY Mlkjhgf","2014-12-14","Connaissance des animaux",null,"SDFGH Jhgfd","Apte","2015-12-14"]
[null,null,1,"Mr","AFONSO Julien"]
[null,null,2,"Mr","AUDIÉ Anthony"]
[null,null,7,"Mr","LEROY France"]
[null,null,1,"Mr","AFONSO Julien"]
[null,null,5,"Mr","DISTÉFANO Alexis"]
[null,null,1,"Mr","AFONSO Julien"]

{"sheet":"Aide","index":10,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,0,0,17]]}
["AIDE AU FONCTIONNEMENT"]
[]
[]
[null,null,null,null,null,null,null,null,"L'utilisation en générale reste identique pour chaque thème et"]
[null,null,null,null,null,null,null,null,"reste simple."]
[]
[null,null,null,null,null,null,null,null,"Afin d'avoir un visuel global de la situation un avertissement est"]
[null,null,null,null,null,null,null,null,"créé au dessus de chaque bouton de thème avec un repère de"]
[null,null,null,null,null,null,null,null,"couleur,",null,"n aucun avertissement"]
[null,null,null,null,null,null,null,null,null,null,"n un avertissement au moins"]
[]
[null,null,null,null,null,null,null,null,"Le déclenchement des avertissements est paramétré en nombre "]
[null,null,null,null,null,null,null,null,"de jours et sont repèrés par couleur"]
[null,null,null,null,null,null,null,null,"Alerte",null,null,"Retard",null,null,"RDV confirmé"]
[]
[]
[null,null,null,null,null,null,null,null,"Sélectionnez en cliquant sur le bouton un thème de votre choix "]
[]
[]
[]
[]
["Une fois le tableau de votre choix effectué cliquez sur le bouton de couleur rouge en haut à gauche, une liste des personnes"]
["s'affiche."]
["Sélectionnez un nom puis valider."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Le nom s'inscrit sur la dernière ligne qui passe en couleur vert, ensuite renseigner les colonnes une à une."]
["La colonne aptitude et date à revoir est renseigné suite à la formation ou au rendez-vous effectué."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Une fois le RDV confirmé, annuler l'alerte de la personne concerné à l'aide d'une liste déroulante dans la colonne RDV pris."]

{"sheet":"Visue générale","index":11,"n_rows":28,"n_cols":24,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
["* Coordonnées",null,null,"* Formation",null,null,null,"* Visite médicale",null,null,null,"* Badge",null,"* Sûreté",null,null,"* Permis",null,null,null,"* PPA"]
["Nom - Prénom","Service","Fonction","Date formation","Thème","Date à revoir","Alerte","Date RDV","Lieu RDV","Date à revoir","Alerte","Date à revoir","Alerte","Date recyclage","Date à revoir","Alerte","Type permis","Date RDV","Date à revoir","Alerte","Date formation","Thème","Date à revoir","Alerte"]
["AFONSO Julien","SSLIA","Pompier D'Aéroport","2015-11-01","Abord de l'aérodrome (ZVA)","2015-12-06",3,"2015-01-01","lieu","2015-12-31",222,"2018-03-07",null,"2015-12-31","2016-12-31",300,null,"2015-04-09","2020-04-09"]
[null,null,null,"2015-11-21","Stage de recyclage 35h","2016-02-04",50,"2016-03-03","aaaaa","2016-12-31",3333,"2018-03-17",null,null,null,null,null,"2015-05-09","2020-05-09"]
[]
["AUDIÉ Anthony","SSLIA","Pompier D'Aéroport",null,null,null,null,null,null,null,null,"2018-03-27",null,null,null,null,null,"2015-04-29","2020-04-29"]
["BÉNAZET Jean-René","SSLIA","Chef De Manoeuvre",null,null,null,null,null,null,null,null,"2012-12-31",0]
[null,null,null,null,null,null,null,null,null,null,null,"2016-12-31",429]
["CUENCA Ludovic","SSLIA","Pompier D'Aéroport",null,null,null,null,null,null,null,null,"2018-04-16"]
["DISTÉFANO Alexis","SSLIA","Pompier D'Aéroport",null,null,null,null,null,null,null,null,"2015-12-31",63,null,null,null,null,"2015-04-19","2020-04-19"]
["KOSEL Franck","SSLIA","Responsable De Service","2015-11-11","Equipements de protection individuels","2016-01-05",5]
["LEROY France","SSLIA","Pompier D'Aéroport",null,null,null,null,null,null,null,null,"2018-04-06",null,null,null,null,null,"2015-03-30","2020-03-30"]
[null,null,null,null,null,null,null,null,null,null,null,"2013-12-31",0]
["NAVARRO Christophe","SSLIA","Chef De Manoeuvre"]
["PIERRAIN Didier","SSLIA","Pompier D'Aéroport"]
["PONS Thierry","SSLIA","Pompier D'Aéroport"]
["SANTOS Jean-François","SSLIA","Chef De Manoeuvre"]
["SCHWEITZER Jean-Michel","SSLIA","Chef De Manoeuvre"]
["ZARAGOZA Didier","SSLIA","Chef De Manoeuvre"]
["AZERTY Mlkjhgf","QSDFGH","Nbvcxwqsd","2014-09-22","Aire de manœuvre","2015-10-07","ok","2014-08-31",null,"2015-08-31","ok","2015-02-25","ok","2012-05-20","2012-11-20","ok","Poids lourd","2010-03-20","2015-03-20","ok","2014-04-05","Réglementation","2015-04-05","ok"]
[null,null,null,"2015-09-28","Abord de l'aérodrome (ZVA)","2015-12-28",61,"2015-08-31",null,"2016-08-31",308,"2018-02-15",841,"2012-11-20","2013-05-20","ok","Bâteau","2012-08-18","2014-08-18","ok","2015-04-05","Réglementation","2016-04-05",160]
[null,null,null,"2015-10-07","Aire de manœuvre","2015-10-22","ok",null,null,null,null,null,null,"2013-05-20","2013-11-20","ok","Bâteau","2014-07-30","2016-07-30",276,"2014-12-14","Connaissance des animaux","2015-12-14",47]
[null,null,null,"2015-10-22","Aire de manœuvre","2015-11-06",9,null,null,null,null,null,null,"2015-11-20","2016-11-20",389,"Poids lourd","2015-03-20","2020-03-20",1605]
["SDFGH Jhgfd","DFGH","Kjhgf","2015-10-02","Ensemble de l'aérodrome (ZA)","2015-11-02",5,"2014-10-10",null,"2015-10-10","ok","2015-11-27",30,"2012-06-05","2012-12-05","ok","Bâteau","2012-06-28","2014-06-28","ok","2014-11-19","Réglementation","2015-11-19",22]
[null,null,null,"2015-10-15","Equipements de protection individuels","2016-01-15",79,"2015-10-10",null,"2016-10-10",348,"2018-02-25",null,"2012-12-05","2013-06-05","ok","Poids lourd","2012-09-30","2017-09-30",703,"2014-12-02","Connaissance des animaux","2015-11-22",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-05","2015-06-05","ok","Bâteau","2014-06-30","2016-06-30",246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-05","2015-11-05",8]

{"sheet":"Fiche indiv","index":12,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"* Coordonnées"]
["Nom - Prénom","KOSEL Franck"]
["Service","SSLIA"]
["Fonction","Chef De Manœuvre"]
[]
[]
["* Formation",null,null,null,null,"* Sûreté"]
["Date formation","Thème","Date à revoir","Alerte",null,"Date recyclage","Date à revoir","Alerte"]
["2015-11-11","Equipements de protection individuels","2016-01-05",5]
[]
[]
[]
[]
[]
[]
[]
["* Visite médicale",null,null,null,null,"* Badge"]
["Date RDV","Lieu RDV","Date à revoir","Alerte",null,"Date réception","Date à revoir","Alerte"]
[]
[]
[]
[]
[]
["* Permis"]
["Type permis","Date RDV","Date à revoir","Alerte"]
[]
[]
[]
[]
[]
["* PPA"]
["Date formation","Thème","Date à revoir","Alerte"]

{"sheet":"Parametrage","index":13,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["* Coordonnées","Nom - Prénom","A","Coordonnées","D"]
[null,"Service","B","Coordonnées","E","B4"]
[null,"Fonction","C","Coordonnées","F","B5"]
["* Formation","Date formation","D","Formation","F","A10"]
[null,"Thème","E","Formation","G","B10"]
[null,"Date à revoir","F","Formation","J","C10"]
[null,"Alerte","G","Formation","B","D10"]
["* Visite médicale","Date RDV","H","Visite médicale","H","A20"]
[null,"Lieu RDV","I","Visite médicale","I","B20"]
[null,"Date à revoir","J","Visite médicale","K","C20"]
[null,"Alerte","K","Visite médicale","B","D20"]
["* Badge","Date à revoir","L","Badge","J","G20"]
[null,"Alerte","M","Badge","B","H20"]
["* Sûreté","Date recyclage","N","Sureté","I","F10"]
[null,"Date à revoir","O","Sureté","L","G10"]
[null,"Alerte","P","Sureté","B","H10"]
["* Permis","Type permis","Q","Permis civil","F","A27"]
[null,"Date RDV","R","Permis civil","I","B27"]
[null,"Date à revoir","S","Permis civil","L","C27"]
[null,"Alerte","T","Permis civil","B","D27"]
["* PPA","Date formation","U","SPPA","F","A34"]
[null,"Thème","V","SPPA","G","B34"]
[null,"Date à revoir","W","SPPA","K","C34"]
[null,"Alerte","X","SPPA","B","D34"]