{"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":1,"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":true,"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":3},"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":5},null,null,null,"Retard",{"$f":"'Visite médicale'!AB2","v":1},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":0},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":0},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":3},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":0},null,null,null,"RDV confirmé",{"$f":"SPPA!AC2","v":0},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":19,"n_cols":16,"rows_kept":19,"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","Service AZ","Fonction AZ","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"]
[null,16,"Mr","AAA Aaa","SSLIA","Pompier D'Aéroport","CDI","2012-01-01","1980-01-01",35]
[null,17,"Mr","AAA Aaaa","SERVICE AZ","Pompier D'Aéroport"]

{"sheet":"Formation","index":4,"n_rows":33,"n_cols":46,"rows_kept":33,"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":3},{"$f":"SUMPRODUCT(N(ColAlerteForm=0)-(ColAlerteForm=\"\"))","v":5},{"$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":0},{"$f":"(SUMPRODUCT((ColAlerteForm<=AO2)*(ColAlerteForm>=AP2)*(ColThèmeForm=AO1)))","v":1},{"$f":"(SUMPRODUCT((ColAlerteForm<=AQ2)*(ColAlerteForm>=AR2)*(ColThèmeForm=AQ1)))","v":0},{"$f":"(SUMPRODUCT((ColAlerteForm<=AS2)*(ColAlerteForm>=AT2)*(ColThèmeForm=AS1)))","v":2},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,"ok",1,"Mr","AFONSO Julien","2014-02-18","Aire de manœuvre",null,"Apte","2015-02-18","V"]
[null,"ok",2,"Mr","AUDIÉ Anthony","2014-02-18","Aire de manœuvre",null,"Apte","2015-02-18","V"]
[null,"ok",3,"Mr","BÉNAZET Jean-René","2015-02-19","Aire de manœuvre",null,"Apte","2015-02-19","V"]
[null,"ok",4,"Mr","CUENCA Ludovic","2014-02-20","Aire de manœuvre",null,"Apte","2015-02-20","V"]
[null,"ok",6,"Mr","KOSEL Franck","2014-02-21","Aire de manœuvre",null,"Apte","2015-02-21","V"]
[null,"ok",7,"Mr","LEROY France","2014-02-22","Aire de manœuvre",null,"Apte","2015-02-22","V"]
[null,"ok",10,"Mr","PONS Thierry","2014-02-23","Aire de manœuvre",null,"Apte","2015-02-23","V"]
[null,"ok",12,"Mr","SCHWEITZER Jean-Michel","2014-02-25","Aire de manœuvre",null,"Apte","2015-02-25","V"]
[null,"ok",14,"Mme","AZERTY Mlkjhgf","2014-02-27","Aire de manœuvre",null,"Apte","2015-02-27","V"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","2014-02-28","Aire de manœuvre",null,"Apte","2015-02-28","V"]
[null,0,1,"Mr","AFONSO Julien","2014-03-05","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-03-05"]
[null,0,4,"Mr","CUENCA Ludovic","2014-03-08","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-03-08"]
[null,0,6,"Mr","KOSEL Franck","2014-03-10","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-03-10"]
[null,0,7,"Mr","LEROY France","2014-03-12","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-03-12"]
[null,0,12,"Mr","SCHWEITZER Jean-Michel","2014-03-14","Ensemble de l'aérodrome (ZA)",null,"Apte","2015-03-14"]
[null,111,1,"Mr","AFONSO Julien","2015-02-18","Equipements de protection individuels",null,"Apte","2016-02-18"]
[null,113,4,"Mr","CUENCA Ludovic","2015-02-20","Equipements de protection individuels",null,"Apte","2016-02-20"]
[null,114,6,"Mr","KOSEL Franck","2015-02-21","Equipements de protection individuels",null,"Apte","2016-02-21"]
[null,115,7,"Mr","LEROY France","2015-02-22","Equipements de protection individuels",null,"Apte","2016-02-22"]
[null,118,12,"Mr","SCHWEITZER Jean-Michel","2015-02-25","Equipements de protection individuels",null,"Apte","2016-02-25"]
[null,120,14,"Mme","AZERTY Mlkjhgf","2015-02-27","Equipements de protection individuels",null,"Apte","2016-02-27"]
[null,121,15,"Mlle","SDFGH Jhgfd","2015-02-28","Equipements de protection individuels",null,"Apte","2016-02-28"]
[null,11,1,"Mr","AFONSO Julien","2014-11-10","Abord de l'aérodrome (ZVA)",null,"Apte","2015-11-10"]
[null,16,4,"Mr","CUENCA Ludovic","2014-11-15","Abord de l'aérodrome (ZVA)",null,"Apte","2015-11-15"]
[null,19,6,"Mr","KOSEL Franck","2014-11-18","Abord de l'aérodrome (ZVA)",null,"Apte","2015-11-18"]
[null,21,7,"Mr","LEROY France","2014-11-20","Abord de l'aérodrome (ZVA)",null,"Apte","2015-11-20"]
[null,23,12,"Mr","SCHWEITZER Jean-Michel","2014-11-22","Abord de l'aérodrome (ZVA)",null,"Apte","2015-11-22"]
[null,16,1,"Mr","AFONSO Julien","2014-11-15","Stage de recyclage 35h",null,"Apte","2015-11-15"]
[null,16,4,"Mr","CUENCA Ludovic","2014-11-15","Stage de recyclage 35h",null,"Apte","2015-11-15"]

{"sheet":"Visite médicale","index":5,"n_rows":16,"n_cols":38,"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,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":1},{"$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",1,"Mr","AFONSO Julien","2014-02-02",null,"2014-02-10","Lieu 1","Apte","2015-02-10","V"]
[null,"ok",4,"Mr","CUENCA Ludovic","2014-02-10",null,"2014-02-18","Lieu 2","Apte","2015-02-18","V"]
[null,"ok",6,"Mr","KOSEL Franck","2014-03-05",null,"2014-03-10","Lieu 1","Apte","2015-03-10","V"]
[null,"ok",7,"Mr","LEROY France","2014-03-10",null,"2014-03-15","Lieu 2","Apte","2015-03-15","V"]
[null,"ok",12,"Mr","SCHWEITZER Jean-Michel","2014-03-15",null,"2014-03-20","Lieu 1","Apte","2015-03-20","V"]
[null,0,14,"Mme","AZERTY Mlkjhgf","2014-03-20",null,"2014-03-25","Lieu 2","Apte","2015-03-25"]
[null,"ok",15,"Mlle","SDFGH Jhgfd","2014-03-21",null,"2014-03-28","Lieu 1","Apte","2015-03-28","V"]
[null,103,1,"Mr","AFONSO Julien","2015-02-05",null,"2015-02-10","Lieu 2","Apte","2016-02-10"]
[null,111,4,"Mr","CUENCA Ludovic","2015-02-10",null,"2015-02-18","Lieu 1","Apte","2016-02-18"]
[null,132,6,"Mr","KOSEL Franck","2015-03-05",null,"2015-03-10","Lieu 2","Apte","2016-03-10"]
[null,137,7,"Mr","LEROY France","2015-03-10",null,"2015-03-15","Lieu 1","Apte","2016-03-15"]
[null,142,12,"Mr","SCHWEITZER Jean-Michel","2015-03-15",null,"2015-03-20","Lieu 2","Apte","2016-03-20"]
[null,150,15,"Mlle","SDFGH Jhgfd","2015-03-15",null,"2015-03-28","Lieu 2","Apte","2016-03-28"]

{"sheet":"Badge","index":6,"n_rows":10,"n_cols":33,"rows_kept":10,"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":0},{"$f":"SUMPRODUCT(N(ColAlerteBadge=\"\"))","v":0},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,1044,1,"Mr","AFONSO Julien","2015-08-07","SDFGH Jhgfd","2015-09-10",null,"2018-09-08",null,null,"000 00 000000"]
[null,1061,4,"Mr","CUENCA Ludovic","2015-08-25","SDFGH Jhgfd","2015-09-30",null,"2018-09-25"]
[null,1115,6,"Mr","KOSEL Franck","2015-10-10","SDFGH Jhgfd","2015-11-25",null,"2018-11-18"]
[null,1124,7,"Mr","LEROY France","2015-11-02","SDFGH Jhgfd","2015-12-05",null,"2018-11-27"]

{"sheet":"Permis civil","index":7,"n_rows":12,"n_cols":40,"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,{"$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":0},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",1,"Mr","AFONSO Julien","Poids lourd","2014-03-04","SDFGH Jhgfd","2014-03-20",null,"Apte","2015-03-20","V"]
[null,"ok",1,"Mr","AFONSO Julien","Piste","2014-03-22","SDFGH Jhgfd","2014-04-02",null,"Apte","2015-04-02","V"]
[null,"ok",1,"Mr","AFONSO Julien","Bâteau","2014-04-05","SDFGH Jhgfd","2014-04-15",null,"Apte","2015-04-15","V"]
[null,142,1,"Mr","AFONSO Julien","Poids lourd","2015-03-10","SDFGH Jhgfd","2015-03-20",null,"Apte","2016-03-20"]
[null,155,1,"Mr","AFONSO Julien","Piste","2015-03-25","SDFGH Jhgfd","2015-04-02",null,"Apte","2016-04-02"]
[null,168,1,"Mr","AFONSO Julien","Bâteau","2015-04-02","SDFGH Jhgfd","2015-04-15",null,"Apte","2016-04-15"]
[null,63,14,"Mme","AZERTY Mlkjhgf","Poids lourd","2015-01-01","CUENCA Ludovic","2015-02-01","Lieu RDV","Apte","2016-01-01"]

{"sheet":"Sureté","index":8,"n_rows":10,"n_cols":33,"rows_kept":10,"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",1,"Mr","AFONSO Julien","Site 1","2014-05-05",null,"2014-05-15",null,"Apte","2015-05-15","V"]
[null,198,1,"Mr","AFONSO Julien","Site 1","2015-03-30",null,"2015-05-15",null,"Apte","2016-05-15"]
[null,"ok",4,"Mr","CUENCA Ludovic","Site 1","2014-03-06",null,"2014-03-20",null,"Apte","2015-03-20","V"]
[null,142,4,"Mr","CUENCA Ludovic","Site 1","2015-03-08",null,"2015-03-20",null,"Apte","2016-03-20"]
[null,21,14,"Mme","AZERTY Mlkjhgf","Site 1","2015-11-15",null,"2014-11-20",null,"Apte","2015-11-20"]

{"sheet":"SPPA","index":9,"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!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":3},{"$f":"SUMPRODUCT(N(ColAlerteSppa=0)-(ColAlerteSppa=\"\"))","v":0},{"$f":"SUMPRODUCT(N(ColAlerteSppa=\"\"))","v":0},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":1},{"$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,46,14,"Mme","AZERTY Mlkjhgf","2014-12-15","Maniment des armes",null,"SDFGH Jhgfd","Apte","2015-12-15"]
[null,"ok",1,"Mr","AFONSO Julien","2014-10-06","Maniment des armes",null,"SDFGH Jhgfd","Apte","2015-10-06","V"]
[null,"ok",1,"Mr","AFONSO Julien","2014-10-08","Réglementation",null,"SDFGH Jhgfd","Apte","2015-10-08","V"]
[null,"ok",1,"Mr","AFONSO Julien","2014-10-10","Connaissance des animaux",null,"SDFGH Jhgfd","Apte","2015-10-10","V"]
[null,342,1,"Mr","AFONSO Julien","2015-10-06","Maniment des armes",null,"SDFGH Jhgfd","Apte","2016-10-06"]
[null,344,1,"Mr","AFONSO Julien","2015-10-08","Réglementation",null,"SDFGH Jhgfd","Apte","2016-10-08"]
[null,346,1,"Mr","AFONSO Julien","2015-10-10","Connaissance des animaux",null,"SDFGH Jhgfd","Apte","2016-10-10"]

{"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":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"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","2014-03-05","Ensemble de l'aérodrome (ZA)","2015-03-05",0,"2015-02-10","Lieu 2","2016-02-10",103,"2018-09-08",1044,"2015-05-15","2016-05-15",198,"Poids lourd","2015-03-20","2016-03-20",142,"2015-10-06","Maniment des armes","2016-10-06",342]
[null,null,null,"2015-02-18","Equipements de protection individuels","2016-02-18",111,null,null,null,null,null,null,null,null,null,"Piste","2015-04-02","2016-04-02",155,"2015-10-08","Réglementation","2016-10-08",344]
[null,null,null,"2014-11-10","Abord de l'aérodrome (ZVA)","2015-11-10",11,null,null,null,null,null,null,null,null,null,"Bâteau","2015-04-15","2016-04-15",168,"2015-10-10","Connaissance des animaux","2016-10-10",346]
[null,null,null,"2014-11-15","Stage de recyclage 35h","2015-11-15",16]
["AUDIÉ Anthony","SSLIA","Pompier D'Aéroport"]
["BÉNAZET Jean-René","SSLIA","Chef De Manoeuvre"]
["CUENCA Ludovic","SSLIA","Pompier D'Aéroport","2014-03-08","Ensemble de l'aérodrome (ZA)","2015-03-08",0,"2015-02-18","Lieu 1","2016-02-18",111,"2018-09-25",1061,"2015-03-20","2016-03-20",142]
[null,null,null,"2015-02-20","Equipements de protection individuels","2016-02-20",113]
[null,null,null,"2014-11-15","Abord de l'aérodrome (ZVA)","2015-11-15",16]
[null,null,null,"2014-11-15","Stage de recyclage 35h","2015-11-15",16]
["DISTÉFANO Alexis","SSLIA","Pompier D'Aéroport"]
["KOSEL Franck","SSLIA","Responsable De Service","2014-03-10","Ensemble de l'aérodrome (ZA)","2015-03-10",0,"2015-03-10","Lieu 2","2016-03-10",132,"2018-11-18",1115]
[null,null,null,"2015-02-21","Equipements de protection individuels","2016-02-21",114]
[null,null,null,"2014-11-18","Abord de l'aérodrome (ZVA)","2015-11-18",19]
["LEROY France","SSLIA","Pompier D'Aéroport","2014-03-12","Ensemble de l'aérodrome (ZA)","2015-03-12",0,"2015-03-15","Lieu 1","2016-03-15",137,"2018-11-27",1124]
[null,null,null,"2015-02-22","Equipements de protection individuels","2016-02-22",115]
[null,null,null,"2014-11-20","Abord de l'aérodrome (ZVA)","2015-11-20",21]
["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","2014-03-14","Ensemble de l'aérodrome (ZA)","2015-03-14",0,"2015-03-20","Lieu 2","2016-03-20",142]
[null,null,null,"2015-02-25","Equipements de protection individuels","2016-02-25",118]
[null,null,null,"2014-11-22","Abord de l'aérodrome (ZVA)","2015-11-22",23]
["ZARAGOZA Didier","SSLIA","Chef De Manoeuvre"]
["AZERTY Mlkjhgf","Service","Fonction","2015-02-27","Equipements de protection individuels","2016-02-27",120,"2014-03-25","Lieu 2","2015-03-25",0,"2018-02-15",841,"2014-11-20","2015-11-20",21,"Poids lourd","2015-02-01","2016-01-01",63,"2015-04-05","Réglementation","2016-04-05",160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-14","Connaissance des animaux","2015-12-14",47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-15","Maniment des armes","2015-12-15",46]
["SDFGH Jhgfd","DFGH","Kjhgf","2015-02-28","Equipements de protection individuels","2016-02-28",121,"2015-03-28","Lieu 2","2016-03-28",150,"2015-11-27",30,null,null,null,null,null,null,null,"2014-11-19","Réglementation","2015-11-19",22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-02","Connaissance des animaux","2015-11-22",25]

{"sheet":"Fiche indiv","index":12,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[null,"* Coordonnées"]
["Nom - Prénom","AZERTY Mlkjhgf"]
["Service","Service AZ"]
["Fonction","Fonction AZ"]
[]
[]
["* Formation",null,null,null,null,"* Sûreté"]
["Date formation","Thème","Date à revoir","Alerte",null,"Date recyclage","Date à revoir","Alerte"]
["2015-02-27","Equipements de protection individuels","2016-02-27",120,null,"2014-11-20","2015-11-20",21]
[]
[]
[]
[]
[]
[]
[]
["* Visite médicale",null,null,null,null,"* Badge"]
["Date RDV","Lieu RDV","Date à revoir","Alerte",null,"Date réception","Date à revoir","Alerte"]
["2014-03-25","Lieu 2","2015-03-25",0,null,"2015-02-18","2018-02-15",841]
[]
[]
[]
[]
["* Permis"]
["Date RDV","Type permis","Date à revoir","Alerte"]
["2015-02-01","Poids lourd","2016-01-01",63]
[]
[]
[]
[]
["Bâteau"]
["Date formation","Thème","Date à revoir","Alerte"]
["2015-04-05","Réglementation","2016-04-05",160]
["2014-12-14","Connaissance des animaux","2015-12-14",47]
["2014-12-15","Maniment des armes","2015-12-15",46]

{"sheet":"Parametrage","index":13,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["* Coordonnées","Nom - Prénom","A","Coordonnées","D","B3"]
[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 réception",null,"Badge","H","F20"]
[null,"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","B27"]
[null,"Date RDV","R","Permis civil","I","A27"]
[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"]