{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Menu","Base","Base prev","Extract ADP","Liste","Salle"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":"Menu","index":0,"n_rows":7,"n_cols":42,"rows_kept":7,"cut":false,"hidden":false,"merged":[[16,3,16,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,666.67,263.20999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,666.67,342.51]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Base","index":1,"n_rows":15,"n_cols":72,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["N° de la session","N° Axe","Libellé Axe","Domaine générique","Domaine","Libellé stage","Organisme Dispensateur","Numéro d'agrément","Type d'action","Formation Qualifiante/Certifiante","Interne","Type de formation","Imputable","Stage prévu","Stage plannifié","Date de début","Date de fin","Durée de la formation","Nb stagiaires inscrits","Présence","Matricule","C Etablissement","BUEC","Département","centre de coût","Nom Prénom","Sexe","Age Années","CSP","Emploi repère","Priorité","Nombre d'heure suivi","Niveau de langue","Niveau fin stage","Objectif niveau langue","Etat","Manager Non Prénom","Formateur","Nombre d'heure dispensée","SDB","Coût pédagogique ind","Coût salarial ind.","Coût hébergement ind.","Coût transport ind.","Coût total ind.","Coût formateur","Nbr d'heure de formation total","Nbr d'heure de formation total (Formateur interne)","Budget action","Coût pédagogique total","Coût salarial total","Coût hébergement total","Coût transport total","Coût hébergement affécté au stage","Coût de transport affécté au stage","Heure de début","Heure de fin","Site","Salle","lieu déjeuner","Plage déjeuner","Type déjeuner","Adresse réstaurant","Lieu éxtérieure","Programme","Convention","Facture","Attestation","Besoin réservation plateau repas","Besoin réservation salle","Commentaires","Date de saisie"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Confirmer","1052","Site 1","Buec 1","Dpt 1","00C10111","Nom 1 Prénom 1","F","25","AM",null,"1",20,"","","","Présent","",null,null,"2000",666.67,263.73,166.67,66.67,1163.74,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Confirmer","1859","Site 3","Buec 2","Dpt 3","00C20333","Nom 3 Prénom 3","F","36","CADRE",null,"2","20","","","","Présent","",null,null,2150,666.67,283.51,166.67,66.67,1183.52,null,"120","","8000","4000","342,85","0","0","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Indisponible","2987","Site 3","Buec 3","Dpt 5","00C10555","Nom 5 Prénom 5","F","29","AM",null,"1",20,"","","","Abscent","",null,null,"2050",0,0,0,0,0,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Confirmer","3214","Site 4","Buec 4","Dpt 7","00C10777","Nom 7 Prénom 7","M","50","AM",null,"2",20,"","","","Présent","",null,null,"2150",666.67,283.51,166.67,66.67,1183.52,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Indisponible","4756","Site 4","Buec 5","Dpt 8","00C20866","Nom 8 Prénom 8","F","30","CADRE",null,"1",20,"","","","Abscent","",null,null,"2000",0,0,0,0,0,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Confirmer","124","Site 5","Buec 6","Dpt 3","00C403910","Nom 11 Prénom 11","F","42","CADRE",null,"1",20,"","","","Demandé","",null,null,"4900",666.67,0,166.67,66.67,1546.15,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Indisponible","158","Site 3","Buec 7","Dpt5","00C205311","Nom 12 Prénom 12","M","55","CADRE",null,"1",20,"","","","Abscent","",null,null,"4100",0,0,0,0,0,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Rajouter","654","Site 4","Buec 8","Dpt 10","00C201066","Nom 13 Prénom 13","F","55","AM",null,"2",20,"","","","Demandé","",null,null,"2150",666.67,283.51,166.67,66.67,1183.52,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
["1","1","Libéllé axe 1","Domaines génriques 1","Domaines 1","Libellé 2","","","Adaptation au poste","Oui","Non","Intra","Non","Oui","Oui","03/11/2014","05/11/2014","20","6","Rajouter","2104","Site 3","Buec 9","Dpt 9","00C209311","Nom 14 Prénom 14","F","40","AM",null,"1",20,"","","","Demandé","",null,null,"1900",666.67,250.54,166.67,66.67,1150.52,null,"120","","8000","4000","2070,28","1000,02","333,35","1000","400","08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
[2,2,"Libéllé axe 2","Domaines génriques 2","Domaines 2","Libellé 2","","","Adaptation au poste","Non","Oui","Inter","Non","Non","Oui","03/11/2014","05/11/2014",10,3,"Confirmer","4756","Site 4","Buec 10","Dpt 8","00C20866","Nom 8 Prénom 8","F","30","CADRE",null,"1",20,"","","","Demandé","","O",10,"2000",0,0,166.67,66.67,0,2233.25,30,10,6000,2233.35,null,null,null,null,null,"08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
[2,2,"Libéllé axe 2","Domaines génriques 2","Domaines 2","Libellé 2","","","Adaptation au poste","Non","Oui","Inter","Non","Non","Oui","03/11/2014","05/11/2014",10,3,"Confirmer","124","Site 5","Buec 11","Dpt 3","00C403910","Nom 11 Prénom 11","F","42","CADRE",null,"1",10,"","","","Demandé","",null,null,"4900",666.67,646.14,166.67,66.67,1546.15,null,30,"",6000,2233.35,null,null,null,null,null,"08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
[2,2,"Libéllé axe 2","Domaines génriques 2","Domaines 2","Libellé 2","","","Adaptation au poste","Non","Oui","Inter","Non","Non","Oui","03/11/2014","05/11/2014",10,3,"Indisponible","158","Site 3","Buec 12","Dpt5","00C205311","Nom 12 Prénom 12","M","55","CADRE",null,"1",10,"","","","Abscent","",null,null,"4100",0,0,0,0,"0",null,30,"",6000,2233.35,null,null,null,null,null,"08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
[3,2,"Libéllé axe 2","Domaines génriques 2","Domaines 2","Libellé 2","","","Adaptation au poste","Non","Oui","Inter","Non","Non","Oui","03/11/2014","05/11/2014",10,3,"Confirmer","654","Site 4","Buec 13","Dpt 10","00C201066","Nom 13 Prénom 13","F","55","AM",null,"2",10,"","","","Demandé","",null,null,"2150",666.67,283.51,166.67,66.67,1183.52,null,30,"",6000,2233.35,null,null,null,null,null,"08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]
[4,2,"Libéllé axe 3","Domaines génriques 2","Domaines 2","Libellé 2","","","Adaptation au poste","Non","Oui","Inter","Non","Non","Oui","03/11/2014","05/11/2014",10,3,"Rajouter","2104","Site 3","Buec 14","Dpt 9","00C209311","Nom 14 Prénom 14","F","40","AM",null,"1",10,"","","","Demandé","",null,null,"1900",666.67,250.54,166.67,66.67,1150.55,null,30,"",6000,2233.35,null,null,null,null,null,"08H00","17H00","Site 1","Salle 3","Salle 4","12H30 - 14H00","Restaurant","rue test","","Oui","Non","Non","Néant","Oui","Non","","25/11/2014"]

{"sheet":"Base prev","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Extract ADP","index":3,"n_rows":15,"n_cols":25,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Site","C","DPT","Bud","Res","Centre","Affect","Mat","Nom","Prénom","Nom prénom","Sexe","Age","L","Contrat","Coef","Anc","Entrée","Coef","Sal","ANCIENNETE","13E","L Emploi","L Emploi repère","Manager"]
["Site 1","C1","Dpt 1","Bud 1","Res 1","00C10111",{"$f":"CONCATENATE(B2,C2,D2,E2,F2)","v":"C1Dpt 1Bud 1Res 100C10111"},1052,"Nom 1","Prénom 1",{"$f":"CONCATENATE(I2,\" \",J2)","v":"Nom 1 Prénom 1"},"F",25,"AM","CDI",47,2,"2012-04-02",1,2000,0,2166.6666666666665,"TECH 1","TECH 1","Manag 1"]
["Site 2","C1","Dpt 2","Bud 2","Res 2","00C10222",{"$f":"CONCATENATE(B3,C3,D3,E3,F3)","v":"C1Dpt 2Bud 2Res 200C10222"},1746,"Nom 2","Prénom 2","Nom 2 Prénom 2","M",25,"AM","CDI",47,4,"2010-07-12",1,2050,0,2220.8333333333335,"TECH LABO NIV 1","TECH LABO NIV 1","Manag 2"]
["Site 3","C2","Dpt 3","Bud 3","Res 3","00C20333","C2Dpt 3Bud 3Res 300C20333",1859,"Nom 3","Prénom 3","Nom 3 Prénom 3","F",36,"CADRE","CDI",51,2,"2012-04-02",1,2600,0,2816.6666666666665,"RESP 6","RESP 6","Manag 3"]
["Site 1","C1","Dpt 4","Bud 4","Res 4","00C10444","C1Dpt 4Bud 4Res 400C10444",2354,"Nom 4","Prénom 4","Nom 4 Prénom 4","M",28,"AM","CDI",47,3,"2011-07-04",1,2100,0,2275,"TECH 4","TECH 4","Manag 4"]
["Site 3","C3","Dpt 5","Bud 5","Res 5","00C10555","C3Dpt 5Bud 5Res 500C10555",2987,"Nom 5","Prénom 5","Nom 5 Prénom 5","F",29,"AM","CDI",47,4,"2010-06-07",1,2050,0,2220.8333333333335,"ASSIST 1","ASSIST 1","Manag 5"]
["Site 3","C2","Dpt 6","Bud 6","Res 6","00C20666","C2Dpt 6Bud 6Res 600C20666",3654,"Nom 6","Prénom 6","Nom 6 Prénom 6","F",20,"EMPLOYE","CDD",44,0,"2014-09-08",1,1100,0,1191.6666666666667,"ASSIST 1","ASSIST 1","Manag 6"]
["Site 4","C1","Dpt 7","Bud 7","Res 7","00C10777","C1Dpt 7Bud 7Res 700C10777",3214,"Nom 7","Prénom 7","Nom 7 Prénom 7","M",50,"AM","CDI",49,1,"2013-10-03",1,2150,0,2329.1666666666665,"TECH 2","TECH 2","Manag 7"]
["Site 4","C2","Dpt 8","Bud 6","Res 6","00C20866","C2Dpt 8Bud 6Res 600C20866",4756,"Nom 8","Prénom 8","Nom 8 Prénom 8","F",30,"CADRE","CDI",50,8,"2006-03-20",1,2000,0,2166.6666666666665,"TECH 1","TECH 1","Manag 8"]
["Site 3","C3","Dpt 1","Bud 8","Res 8","00C30188","C3Dpt 1Bud 8Res 800C30188",5,"Nom 9","Prénom 9","Nom 9 Prénom 9","F",26,"EMPLOYE","CDI",46,11,"2003-07-30",1,2050,150,2220.8333333333335,"ANALYSTE 1","ANALYSTE 1","Manag 9"]
["Site 1","C1","Dpt 4","Bud 6","Res 9","00C10469","C1Dpt 4Bud 6Res 900C10469",9,"Nom 10","Prénom 10","Nom 10 Prénom 10","M",40,"EMPLOYE","CDI",46,24,"1992-07-01",1,2100,250,2275,"EMPLOYE 1","EMPLOYE 1","Manag 10"]
["Site 5","C4","Dpt 3","Bud 9","Res 10","00C403910","C4Dpt 3Bud 9Res 1000C403910",124,"Nom 11","Prénom 11","Nom 11 Prénom 11","F",42,"CADRE","CDI",55,4,"2010-03-01",1,4900,0,5308.333333333333,"RESP 1","RESP 1","Manag 11"]
["Site 3","C2","Dpt5","Bud 3","Res 11","00C205311","C2Dpt5Bud 3Res 1100C205311",158,"Nom 12","Prénom 12","Nom 12 Prénom 12","M",55,"CADRE","CDI",52,29,"1985-09-02",1,4100,0,4441.666666666667,"RESP 2","RESP 2","Manag 3"]
["Site 4","C2","Dpt 10","Bud 6","Res 6","00C201066","C2Dpt 10Bud 6Res 600C201066",654,"Nom 13","Prénom 13","Nom 13 Prénom 13","F",55,"AM","CDI",47,5,"2009-02-02",1,2150,0,2329.1666666666665,"TECH 2","TECH 2","Manag 12"]
["Site 3","C2","Dpt 9","Bud 3","Res 11","00C209311","C2Dpt 9Bud 3Res 1100C209311",2104,"Nom 14","Prénom 14","Nom 14 Prénom 14","F",40,"AM","CDI",47,3,"2010-10-18",1,1900,0,2058.3333333333335,"ASSIST 2","ASSIST 2","Manag 13"]

{"sheet":"Liste","index":4,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Libellés (Liste non exhaustive)","Domaines Génériques","Domaines","Libellé de l'Axe","N° de l'axe","Organisme","N° Agrément"]
["Libellé 1","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 2","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 3","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 4","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 5","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 6","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 7","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 8","Domaines génriques 1","Domaines 1","Libéllé axe 1",1]
["Libellé 9","Domaines génriques 1","Domaines 2","Libéllé axe 1",1]
["Libellé 10","Domaines génriques 1","Domaines 2","Libéllé axe 1",1]
["Libellé 11","Domaines génriques 1","Domaines 2","Libéllé axe 1",1]
["Libellé 12","Domaines génriques 1","Domaines 2","Libéllé axe 1",1]
["Libellé 13","Domaines génriques 1","Domaines 3","Libéllé axe 1",1]
["Libellé 14","Domaines génriques 1","Domaines 3","Libéllé axe 1",1]
["Libellé 15","Domaines génriques 1","Domaines 3","Libéllé axe 1",1]
["Libellé 16","Domaines génriques 2","Domaines 4","Libéllé axe 1",1]
["Libellé 17","Domaines génriques 2","Domaines 5","Libéllé axe 1",1]
["Libellé 18","Domaines génriques 2","Domaines 6","Libéllé axe 1",1]
["Libellé 19","Domaines génriques 2","Domaines 7","Libéllé axe 1",1]
["Libellé 20","Domaines génriques 2","Domaines 8","Libéllé axe 1",1]
["Libellé 21","Domaines génriques 3","Domaines 5","Libéllé axe 1",1]
["Libellé 22","Domaines génriques 3","Domaines 6","Libéllé axe 1",1]
["Libellé 23","Domaines génriques 3","Domaines 7","Libéllé axe 1",1]
["Libellé 24","Domaines génriques 3","Domaines 8","Libéllé axe 1",1]
["Libellé 25","Domaines génriques 4","Domaines 8","Libéllé axe 1",1]
["Libellé 26","Domaines génriques 4","Domaines 5","Libéllé axe 1",1]
["Libellé 27","Domaines génriques 4","Domaines 6","Libéllé axe 1",1]
["Libellé 28","Domaines génriques 4","Domaines 7","Libéllé axe 1",1]
["Libellé 29","Domaines génriques 5","Domaines 9","Libéllé axe 1",1]
["Libellé 30","Domaines génriques 6","Domaines 5","Libéllé axe 2",2]
["Libellé 31","Domaines génriques 7","Domaines 6","Libéllé axe 2",2]
["Libellé 32","Domaines génriques 8","Domaines 7","Libéllé axe 2",2]
["Libellé 33","Domaines génriques 9","Domaines 10","Libéllé axe 3",3]
["Libellé 34","Domaines génriques 10","Domaines 11","Libéllé axe 3",3]

{"sheet":"Salle","index":5,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Site","Nom salle","Lieu repas","Nom Messagerie","Capacité","Vidéo?"]
["Site 1","Salle 1","Salle 1","Nom messagerie 1",12,"Non"]
["Site 1","Salle 2","Salle 2","Nom messagerie 2",10,"Non"]
["Site 1","Salle 3","Salle 3","Nom messagerie 3",4,"Non"]
["Site 1","Salle 4","Salle 4","Nom messagerie 4",8,"Non"]
["Site 1","Salle 5","Salle 5","Nom messagerie 5",8,"Non"]
["Site 1","Salle 6","Salle 6","Nom messagerie 6",20,"Oui"]
["Site 1","Salle 7","Salle 7","Nom messagerie 7",12,"Non"]
["Site 1","Salle 8","Salle 8","Nom messagerie 8",10,"Non"]
["Site 1","Salle 9","Salle 9",null,12,"Non"]
["Site 1","Salle 10","Salle 10",null,null,"Non"]
["Site 1","Salle 11","Salle 11",null,null,"Non"]
["Site 1","Salle 12","Salle 12",null,null,"Non"]
["Site 1","Salle 13","Salle 13",null,null,"Non"]
["Site 2","Salle 14","Salle 14","Nom messagerie 9",12,"Non"]
["Site 2","Salle 15","Salle 15","Nom messagerie 10",12,"Oui"]
["Site 3","Salle 16","Salle 16","Nom messagerie 11",20,"Non"]
["Site 3","Salle 17","Salle 17","Nom messagerie 12",10,"Non"]
["Site 3","Salle 18","Salle 18",null,null,"Non"]
["Site 4","Salle 19","Salle 19",null,14,"Non"]
["Site 4","Salle 20","Salle 20",null,10,"Non"]
["Site 4","Salle 21","Salle 21",null,null,"Non"]
["Site 5","Salle 22","Salle 22",null,null,"Non"]
["Site 6","Salle 23","Salle 23",null,null,"Non"]
["Site 7","Salle 24","Salle 24","Nom messagerie 13",15,"Oui"]
["Site 7","Salle 25","Salle 25","Nom messagerie 14",10,"Non"]
["Site 7","Salle 26","Salle 26","Nom messagerie 15",12,"Non"]
["Site 7","Salle 27","Salle 27","Nom messagerie 16",10,"Non"]