{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Demandes","Salariés","Sessions","Stages","Thèmes","Types de contrat","Services","Directions","Paramètres"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"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":"Demandes","index":0,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des demandes\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des demandes"}]
[]
[null,null,{"$f":"SUBTOTAL(9,C5:C12)","v":11}]
[]
["Salarié","Session","Durée","Début","Fin","Déroulement","Observations","Indicateur","Etat","Service","Direction","Type de contrat","Stage","Thème"]
["LOUIS Eric","Convaincre avec les mains-04/05/2015",{"$f":"IF(ISNUMBER(VLOOKUP(B6,Sessions,3,FALSE)),VLOOKUP(B6,Sessions,3,FALSE),\"\")","v":5},{"$f":"IF(ISNUMBER(VLOOKUP(B6,Sessions,4,FALSE)),VLOOKUP(B6,Sessions,4,FALSE),\"\")","v":"2015-05-04"},{"$f":"IF(ISNUMBER(VLOOKUP(B6,Sessions,5,FALSE)),VLOOKUP(B6,Sessions,5,FALSE),\"\")","v":"2015-08-04"},{"$f":"IF(ISTEXT(VLOOKUP(B6,Sessions,6,FALSE)),VLOOKUP(B6,Sessions,6,FALSE),\"\")","v":"Les 04/05, 05/06,10/07 et 04/08"},"Génération du 14/8/2015",null,{"$f":"IF(ISTEXT(VLOOKUP(H6,Indicateurs,2,FALSE)),VLOOKUP(H6,Indicateurs,2,FALSE),\"\")","v":""},{"$f":"IF(ISTEXT(VLOOKUP(A6,Salariés,5,FALSE)),VLOOKUP(A6,Salariés,5,FALSE),\"\")","v":"Ventes"},{"$f":"IF(ISTEXT(VLOOKUP(A6,Salariés,16,FALSE)),VLOOKUP(A6,Salariés,16,FALSE),\"\")","v":"Commerce"},{"$f":"IF(ISTEXT(VLOOKUP(A6,Salariés,6,FALSE)),VLOOKUP(A6,Salariés,6,FALSE),\"\")","v":"CDD"},{"$f":"IF(ISTEXT(VLOOKUP(B6,Sessions,2,FALSE)),VLOOKUP(B6,Sessions,2,FALSE),\"\")","v":"Convaincre avec les mains"},{"$f":"IF(ISTEXT(VLOOKUP(B6,Sessions,9,FALSE)),VLOOKUP(B6,Sessions,9,FALSE),\"\")","v":"Commerce"}]
["JACQUES Pierre","Laveuses ProDerma - Initiation-04/05/2014","","2014-05-04","2014-05-04","",null,null,"","Production","Production","CDI","Laveuses ProDerma - Initiation",""]
["JEAN Sylvain","Laveuses ProDerma - Initiation-04/05/2014","","2014-05-04","2014-05-04","",null,"Réalisé","Oui","Production","Production","CDD","Laveuses ProDerma - Initiation",""]
["JEAN Sylvain","Laveuses ProDerma - Initiation-04/05/2014","","2014-05-04","2014-05-04","",null,null,"","Production","Production","CDD","Laveuses ProDerma - Initiation",""]
["GILBERT Pierre","Excel initiation-06/06/2015",3,"2015-06-06","2015-06-08","",null,"Réalisé","Oui","Finances","Administrative","Interim","Excel initiation","Bureautique"]
["JACQUES Pierre","Excel initiation-06/06/2015",3,"2015-06-06","2015-06-08","",null,null,"","Production","Production","CDI","Excel initiation","Bureautique"]

{"sheet":"Salariés","index":1,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des salariés\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des salariés"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,N5:N12)","v":11},{"$f":"SUBTOTAL(9,O5:O12)","v":3}]
[]
["Identité","Civilité","Nom","Prénom","Service","Type de contrat","Date naissance","Date embauche","Adresse","CP","Ville","Mail","Observations","Journées demandées","Journées suivies","Direction"]
[{"$f":"C6&\" \"&D6","v":"JEAN Sylvain"},"Monsieur","JEAN","Sylvain","Production","CDD","1964-05-12",null,null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":0},{"$f":"IF(ISTEXT(VLOOKUP(E6,Services,2,FALSE)),VLOOKUP(E6,Services,2,FALSE),\"\")","v":"Production"}]
["JACQUES Pierre","Monsieur","JACQUES","Pierre","Production","CDI","1978-12-16","2004-03-03",null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":0},"Production"]
["PAUL Louis","Monsieur","PAUL","Louis","Achats","CDD","1976-05-05","1998-06-06",null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":0},"Commerce"]
["LOUIS Eric","Monsieur","LOUIS","Eric","Ventes","CDD","1978-04-04","1999-05-05",null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":0},"Commerce"]
["ERIC Paul","Monsieur","ERIC","Paul","Contrôle de gestion","CDD","1995-03-03","2002-03-03",null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":0},"Administrative"]
["GILBERT Pierre","Monsieur","GILBERT","Pierre","Finances","Interim","1992-06-06","1999-01-01",null,null,null,null,null,{"$f":"SUMIF(Demandes!A:A,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!A:A,A:A,Demandes!I:I,\"Oui\")","v":3},"Administrative"]

{"sheet":"Sessions","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des sessions\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des sessions"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J5:J9)","v":11},{"$f":"SUBTOTAL(9,K5:K9)","v":3}]
[]
["Clé","Stage","Durée","Début","Fin","Déroulement","Observations","Lieu","Thème","Journées demandées","Journées suivies"]
[{"$f":"IF(AND(LEN(B6)>0,D6>0),B6&\"-\"&TEXT(D6,\"jj/mm/aaaa\"),\"\")","v":"Laveuses ProDerma - Initiation-04/05/2014"},"Laveuses ProDerma - Initiation",{"$f":"IF(ISNUMBER(VLOOKUP(B6,Stages,4,FALSE)),VLOOKUP(B6,Stages,4,FALSE),\"\")","v":""},"2014-05-04","2014-05-04",null,null,{"$f":"IF(ISTEXT(VLOOKUP(B6,Stages,3,FALSE)),VLOOKUP(B6,Stages,3,FALSE),\"\")","v":""},{"$f":"IF(ISTEXT(VLOOKUP(B6,Stages,2,FALSE)),VLOOKUP(B6,Stages,2,FALSE),\"\")","v":""},{"$f":"SUMIF(Demandes!B:B,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!B:B,A:A,Demandes!I:I,\"Oui\")","v":0}]
[{"$f":"IF(AND(LEN(B7)>0,D7>0),B7&\"-\"&TEXT(D7,\"jj/mm/aaaa\"),\"\")","v":"Convaincre avec les mains-04/05/2015"},"Convaincre avec les mains",{"$f":"IF(ISNUMBER(VLOOKUP(B7,Stages,4,FALSE)),VLOOKUP(B7,Stages,4,FALSE),\"\")","v":5},"2015-05-04","2015-08-04","Les 04/05, 05/06,10/07 et 04/08",null,{"$f":"IF(ISTEXT(VLOOKUP(B7,Stages,3,FALSE)),VLOOKUP(B7,Stages,3,FALSE),\"\")","v":"Agence de Milan"},{"$f":"IF(ISTEXT(VLOOKUP(B7,Stages,2,FALSE)),VLOOKUP(B7,Stages,2,FALSE),\"\")","v":"Commerce"},{"$f":"SUMIF(Demandes!B:B,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!B:B,A:A,Demandes!I:I,\"Oui\")","v":0}]
[{"$f":"IF(AND(LEN(B8)>0,D8>0),B8&\"-\"&TEXT(D8,\"jj/mm/aaaa\"),\"\")","v":"Excel initiation-06/06/2015"},"Excel initiation",{"$f":"IF(ISNUMBER(VLOOKUP(B8,Stages,4,FALSE)),VLOOKUP(B8,Stages,4,FALSE),\"\")","v":3},"2015-06-06","2015-06-08",null,null,{"$f":"IF(ISTEXT(VLOOKUP(B8,Stages,3,FALSE)),VLOOKUP(B8,Stages,3,FALSE),\"\")","v":"Siège"},{"$f":"IF(ISTEXT(VLOOKUP(B8,Stages,2,FALSE)),VLOOKUP(B8,Stages,2,FALSE),\"\")","v":"Bureautique"},{"$f":"SUMIF(Demandes!B:B,A:A,Demandes!C:C)","v":6},{"$f":"SUMIFS(Demandes!C:C,Demandes!B:B,A:A,Demandes!I:I,\"Oui\")","v":3}]

{"sheet":"Stages","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des stages\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des stages"}]
[]
[null,null,null,null,null,{"$f":"SUBTOTAL(9,F5:F10)","v":11},{"$f":"SUBTOTAL(9,G5:G10)","v":3}]
[]
["Libellé","Thème","Lieu","Durée","Observations","Journées demandées","Journées suivies"]
["Laveuses - Initiation","Production","Siège",1,null,{"$f":"SUMIF(Demandes!M:M,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!M:M,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Tableaux de bord de pilotage - Niveau 1","Management","Siège",2,null,{"$f":"SUMIF(Demandes!M:M,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!M:M,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Convaincre avec les mains","Commerce","Agence de Milan",5,null,{"$f":"SUMIF(Demandes!M:M,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!M:M,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Excel initiation","Bureautique","Siège",3,null,{"$f":"SUMIF(Demandes!M:M,A:A,Demandes!C:C)","v":6},{"$f":"SUMIFS(Demandes!C:C,Demandes!M:M,A:A,Demandes!I:I,\"Oui\")","v":3}]

{"sheet":"Thèmes","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des thèmes\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des thèmes"}]
[]
[null,{"$f":"SUBTOTAL(9,B5:B10)","v":11},{"$f":"SUBTOTAL(9,C5:C10)","v":3}]
[]
["Libellé","Journées demandées","Journées suivies","Observations"]
["Production",{"$f":"SUMIF(Demandes!N:N,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!N:N,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Commerce",{"$f":"SUMIF(Demandes!N:N,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!N:N,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Bureautique",{"$f":"SUMIF(Demandes!N:N,A:A,Demandes!C:C)","v":6},{"$f":"SUMIFS(Demandes!C:C,Demandes!N:N,A:A,Demandes!I:I,\"Oui\")","v":3}]
["Management",{"$f":"SUMIF(Demandes!N:N,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!N:N,A:A,Demandes!I:I,\"Oui\")","v":0}]

{"sheet":"Types de contrat","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Types de contrat\"","v":"Société Exemple - Gestion des inscriptions en formation - Types de contrat"}]
[]
[null,null,{"$f":"SUBTOTAL(9,C5:C10)","v":6},{"$f":"SUBTOTAL(9,D5:D10)","v":11},{"$f":"SUBTOTAL(9,E5:E10)","v":3}]
[]
["Libellé","Observations","Effectif","Journées demandées","Journées suivies"]
["CDD",null,{"$f":"COUNTIF(Salariés!F:F,A:A)","v":4},{"$f":"SUMIF(Demandes!L:L,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!L:L,A:A,Demandes!I:I,\"Oui\")","v":0}]
["CDI",null,{"$f":"COUNTIF(Salariés!F:F,A:A)","v":1},{"$f":"SUMIF(Demandes!L:L,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!L:L,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Interim",null,{"$f":"COUNTIF(Salariés!F:F,A:A)","v":1},{"$f":"SUMIF(Demandes!L:L,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!L:L,A:A,Demandes!I:I,\"Oui\")","v":3}]
["Apprenti",null,{"$f":"COUNTIF(Salariés!F:F,A:A)","v":0},{"$f":"SUMIF(Demandes!L:L,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!L:L,A:A,Demandes!I:I,\"Oui\")","v":0}]

{"sheet":"Services","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Fichier des services\"","v":"Société Exemple - Gestion des inscriptions en formation - Fichier des services"}]
[]
[null,null,null,{"$f":"SUBTOTAL(9,D5:D12)","v":6},{"$f":"SUBTOTAL(9,E5:E12)","v":11},{"$f":"SUBTOTAL(9,F5:F12)","v":3}]
[]
["Libellé","Direction","Observations","Effectif","Journées demandées","Journées suivies"]
["Secrétariat","Administrative",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":0},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Production","Production",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":2},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Achats","Commerce",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":1},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Finances","Administrative",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":1},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":3}]
["Contrôle de gestion","Administrative",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":1},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":0},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Ventes","Commerce",null,{"$f":"COUNTIF(Salariés!E:E,A:A)","v":1},{"$f":"SUMIF(Demandes!J:J,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!J:J,A:A,Demandes!I:I,\"Oui\")","v":0}]

{"sheet":"Directions","index":7,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Raison_Sociale&\" - \"&Titre&\" - Directions\"","v":"Société Exemple - Gestion des inscriptions en formation - Directions"}]
[]
[null,null,{"$f":"SUBTOTAL(9,C5:C9)","v":6},{"$f":"SUBTOTAL(9,D5:D9)","v":6},{"$f":"SUBTOTAL(9,E5:E9)","v":11},{"$f":"SUBTOTAL(9,F5:F9)","v":3}]
[]
["Libellé","Observations","Services","Effectif","Journées demandées","Journées suivies"]
["Administrative",null,{"$f":"COUNTIF(Services!B:B,Directions!A:A)","v":3},{"$f":"COUNTIF(Salariés!P:P,A:A)","v":2},{"$f":"SUMIF(Demandes!K:K,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!K:K,A:A,Demandes!I:I,\"Oui\")","v":3}]
["Production",null,{"$f":"COUNTIF(Services!B:B,Directions!A:A)","v":1},{"$f":"COUNTIF(Salariés!P:P,A:A)","v":2},{"$f":"SUMIF(Demandes!K:K,A:A,Demandes!C:C)","v":3},{"$f":"SUMIFS(Demandes!C:C,Demandes!K:K,A:A,Demandes!I:I,\"Oui\")","v":0}]
["Commerce",null,{"$f":"COUNTIF(Services!B:B,Directions!A:A)","v":2},{"$f":"COUNTIF(Salariés!P:P,A:A)","v":2},{"$f":"SUMIF(Demandes!K:K,A:A,Demandes!C:C)","v":5},{"$f":"SUMIFS(Demandes!C:C,Demandes!K:K,A:A,Demandes!I:I,\"Oui\")","v":0}]

{"sheet":"Paramètres","index":8,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Titre","Gestion des inscriptions en formation"]
["Raison  sociale","Société Exemple"]
[]
[]
[]
["Indicateurs de suivi"]
["Libellé","Réalisé"]
["Réalisé","Oui"]
["Annulé par DRH","Non"]
["Annulé par Organisme","Non"]
["Annulé par le salarié","Non"]