{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Gestion Mdp Admin","Indicateurs - 2020 -","Menu","Journal de Formation","Listing Formations","Informations salariés","GestionLISTE","Contacts"],"not_rendered":{"charts":1,"images":36,"macros":1,"external_links":0,"defined_names":108,"comments":1,"pivot_tables":1},"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":"Gestion Mdp Admin","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Users","Passworld","Niveau","Date"]
["Users","Passworld","Niveau","Date"]
["Admin","Admin",1,"2020-04-09"]

{"sheet":"Indicateurs - 2020 -","index":1,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Étiquettes de lignes","Somme de Quantité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(vide)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECHLINE ADDITIF MOUILLANT 20L",322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECHLINE JAVEL PASTILLES 500g",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",334]

{"sheet":"Menu","index":2,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,8,2,11],[1,8,1,11],[7,23,8,23],[7,24,8,24],[1,12,1,14],[2,12,2,14],[3,8,3,11],[3,12,3,14]]}
[]
[null,null,null,null,null,null,null,null,"Suivi Commande",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Suivi Produit à Commander",null,null,null,{"$f":"'Journal de Formation'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Suivi Date de Péremption",null,null,null,{"$f":"'Listing Formations'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Journal de Formation","index":3,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2020-04-22"}]
[]
["Matricule","Nom / Prénom","ID Session","Formation","Type de Formation","Lieu de la formation","Date Début","Date Fin","Durée de la formation","Coût de la formation","Coût frais du salarié","Coût Global ","Formation Acquise","Date fin de validité","Nombre de Jours Restants","Etat de validité"]

{"sheet":"Listing Formations","index":4,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Listing Formations"]
[]
["Id Session","Formation","Type de formation","Lieu de formation","Date Début","Date Fin","Durée","Coût de la formation"]
["S001","SST","Qualifiante","LV 1","2020-05-11","2020-05-13",{"$f":"Listing_Formations[[#This Row],[Date Fin]]-Listing_Formations[[#This Row],[Date Début]]+1","v":3},1100]

{"sheet":"Informations salariés","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Informations Salariés"]
[]
["Matricule","Nom / Prénom","Fonction","Date de prise de fonction","Ancienneté","Site","Adresse Mail","Lien Photo"]
[123456,"Gégé","AMP","2020-03-02",null,"BQV","yyyyyyyyyyyyyyyyyyyy"]

{"sheet":"GestionLISTE","index":6,"n_rows":34,"n_cols":43,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,3],[5,19,10,19],[11,19,21,19],[14,22,14,23],[22,19,30,19]]}
[]
["Paramètre GMAO",null,null,null,null,"Matricule",null,"Liste Salarié",null,"Fonction",null,"Domaine Habilitation HT",null,"Domaine Habilitation BT",null,"Liste Site",null,"Type Formation",null,null,null,"Chemin pour Archivage Bon de Commande",null,"Chemin pour sauvegarde Image PhotosProduits",null,"Chemin pour sauvegarde Image interventions",null,"RechercheFournisseur","Ncol","Liste",null,"RechercheProduits","Ncol","Liste",null,"RechercheEntreSortie","Ncol","Liste",null,null,"RechercheCommande","Ncol","Liste"]
["Couleur de fond des userform Valeurs RGB",96,138,195,null,123456,null,"Gégé",null,"AMP",null,"HT1",null,"BT1",null,"BQV",null,"Qualifiante",null,null,null,"Q:\\Commun\\partage plan de maintenance\\Gestion Stock Lingerie\\Archivage Bon de Commandes",null,"Q:\\",null,"C:\\",null,"Entreprise",1,1,null,"Référence produit",1,7,null,"Référence interne",1,1,null,null,"N°Commande",1,7]
["MDP Admin",null,null,null,null,123457,null,"Gérard",null,"AS",null,"HT2",null,"BT2",null,"PDS",null,"Non Qualifiante",null,null,null,null,null,"\\\\Commun\\partage plan de maintenance\\Gestion Stock Lingerie\\Photos Produits Lingerie",null,null,null,"activités",2,1,null,"Conditionnement",2,1,null,"Désignation",2,1,null,null,"Saisi Par",2,7]
["Sauvegarde pour multi utilisateur 1=Yes 2=No",1,null,null,null,123458,null,"René",null,"ASI",null,"FIN",null,"FIN",null,"FIN",null,"Habilitation",null,"A LIRE",null,null,null,null,null,null,null,"Adresse",3,3,null,"Dosage ",3,1,null,"Type",3,1,null,null,"Réf Produit",3,1]
["MDP Affichage feuille Parc",null,null,null,null,123459,null,"FIN",null,"IDE",null,null,null,null,null,null,null,"FIN",null,"Les données Verte peuvent etre supprimer et modifier ou ajouter meme si les Base de Données sont rempli ",null,null,null,null,null,"Chemin pour sauvegarde Image preventif",null,"Code postal",4,1,null,"Descriptif",4,3,null,"Date E/S",4,4,null,null,"Conditionnement ",4,1]
["Liste intervenant",3,null,null,null,123460,null,null,null,"CHEF DE SERVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C:\\",null,"Boite postale",5,1,null,"Péremption",5,1,null,"Qté",5,5,null,null,"Dosage",5,1]
["Selection ligne sur BD, 1= ok , autres = noOk",1,null,null,null,123461,null,null,null,"DIRECTEUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ville",6,1,null,"Lieux",6,1,null,"Lieux",6,1,null,null,"Fournisseur",6,1]
["blocage des touches 1= ok , autres = noOk","noOK",null,null,null,"FIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pays",7,1,null,"Fournisseur1",7,1,null,null,null,null,null,null,"Réf Fournisseur",7,1]
["mot de passe pour supression interventions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formation",null,null,null,null,null,null,null,null,null,"Contact",8,3,null,"Reference F1",8,1,null,null,null,null,null,null,"Prix Unitaire",8,5]
["mot de passe pour supression preventif",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SST",null,null,null,null,null,null,null,null,null,"Email",9,3,null,"Delais F1",9,1,null,null,null,null,null,null,"Quantité",9,5]
["mot de passe pour supression fournisseur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSIAP",null,"Les données ORANGE sont des listes utilisées dans tout le classeur .\nVous pouvez ajouter et ou modifier les valeurs,\nCependant ne pas les suprimmer une fois les Base de Données rempli car des problèmes risque d'arrivé",null,null,null,null,null,null,null,"Tel.",10,3,null,"Prix unitaire F1",10,5,null,null,null,null,null,null,"Date de commande",10,4]
["mot de passe pour supression produit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hablitation électrique",null,null,null,null,null,null,null,null,null,"Fax",11,3,null,"Fournisseur 2",11,1,null,null,null,null,null,null,"Date de livraison prévue",11,4]
["mot de passe pour supression commande",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS",null,null,null,null,null,null,null,null,null,"Site",12,3,null,"Reference F2",12,1,null,null,null,null,null,null,"Date de réception",12,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMP",null,null,null,null,"Permet de définir les type de recherche (col N3)",null,null,null,null,"Nom C1",13,3,null,"Delais F2",13,1,null,null,null,null,null,null,"Etat",13,7]
["Modif Désignation des pièces 1= ok , autres = noOk",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gestion de la douleur",null,null,null,null,"N°","Liste Recherche",null,null,null,"Fonction C1",14,3,null,"Prix unitaire F2",14,5]
["Choix référence interne  1= ok , autres = noOk",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hygiène dentaire",null,null,null,null,1,"Liste suivant feuille",null,null,null,"Tel C1",15,3,null,"Stock",15,5]
["Coéfficient multiplicateur  Stock Mini pour Commande",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN",null,null,null,null,2,"ListeRange",null,null,null,"Email C1",16,3,null,"Stock Min",16,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"SansListe",null,null,null,"Nom C2",17,3,null,"Produit à commander",17,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lieux",null,null,null,null,null,null,4,"Date",null,null,null,"Fonction C2",18,3,null,"Coût stock",18,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 1",null,null,null,null,null,null,5,"Numerique",null,null,null,"Tel C2",19,3,null,"Lieu de stockage",19,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 2",null,null,null,null,null,null,6,"Lieux",null,null,null,"Email C2",20,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 3",null,null,null,"Les données Bleu corresponde à des listes qui sont utilisées pour la fonction recherche (Voir collone T , cela explique les types de listes)",null,null,7,"Liste case à cocher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 4",null,null,null,null,null,null,null,"MEMO VBAListe de recherche définit :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 5",null,null,null,null,null,null,null,"RechercheFournisseur X2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Séjour",null,null,null,null,null,null,null,"RecherchePieces AB2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infirmerie",null,null,null,null,null,null,null,"RechercheEntreSortie AF2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piscine",null,null,null,null,null,null,null,"Recherche Preventif P AJ2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Snoezelen",null,null,null,null,null,null,null,"RechercheCommande AN2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secrétariat",null,null,null,null,null,null,null,"Recherche Interventions AR3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuisine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lingerie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN"]

{"sheet":"Contacts","index":7,"n_rows":176,"n_cols":20,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[]
["Entreprise","activités","Adresse","Code postal","Boite postale","Ville","Pays","Contact","Email","Tel.","Fax","Site","Nom C1","Fonction C1","Tel C1","Email C1","Nom C2","Fonction C2","Tel C2","Email C2"]
["GROUPE PIERRE LE GOFF-SUD-OUEST","Produits d'entretien","22,rue Saint Exupéry\r\nParc d'activités des Lacs","33295","","BLANQUEFORT","FRANCE","ALVES JEAN-CLAUDE","","","","https://www.groupeplg.com","NATHALIE J","","05 57 10 61 07","","","","",""]
["STANDARD TEXTILE","Lingeire Collective","85, Avenue de l'industrie","69142","CS 90230","RILLIEUX LA PAPE ","FRANCE","04 72 47 17 55","","","","www.standard-textile.fr","Nadine Marquez","Conseiller commercial sédentaire ","","nmarquez@standardtextile.com","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,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,"",null,null,null,null,"","",""]