{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["HOME","Specs","Legal docs listing","Data base Entreprise","Identification","REPORTING","Feuil1"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":29,"comments":2,"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":"HOME","index":0,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"PURCHASING CONTRACT DATABASE"]

{"sheet":"Specs","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,34,0],[14,3,15,3],[1,2,2,2]]}
["UF","CHAMP","STATUT","COMMENTAIRES","Remplissage \nobligatoire","Message d'erreur, si applicable"]
["ADDITION > AMENDMENT, CONTRACTS, NDA, ROLLING CONTRACTS, SQA, T&C","Date of creation","Textbox supprimés, inutiles la macro gère FAIT\n","Date du jour, champ invisible. Ok pour le supprimer, mais j'aurai quand meme besoin de savoir a quelle date ce document a ete enregistre... A quoi penses-tu ?","oui"]
[null,"Document number",null,"Formule à trouver (concaténation de plusieurs champs, à voir plus tard), champ invisible","oui"]
[null,"Purchasing division","OK","Choix restreint à la liste déroulante","oui"]
[null,"Purchasing Category","OK","Choix restreint à la liste déroulante","oui"]
[null,"Cpy Site","OK","Choix restreint à la liste déroulante","oui"]
[null,"BU involved","OK","Choix restreint à la liste déroulante","oui"]
[null,"Department","OK","Choix restreint à la liste déroulante","oui"]
[null,"Add a new department","OK","Lien vers UF NEW DEPARTMENT. > OK\nLe nouvel département renseigné doit venir compléter la liste déroulante \"DPTMT\"","non"]
[null,"Supplier name","OK","Choix restreint à la liste déroulante","oui"]
[null,"Add a new supplier","OK","Si le remplissage est fait, meme contrainte du @ stp\nLe nouveau supplier renseigné doit venir compléter la data base Supplier","non"]
[null,"Supplier segmentation","OK","Choix restreint à la liste déroulante","oui"]
[null,"Supplier e-mail","OK","Réponse doit contenir un @","non","Message d'erreur : \"Your entry is incorrect. Please try again\""]
[null,"Description","OK","Texte libre, avec limite de 1'000 caractères","oui"]
[null,"Starting date","In progress","Desole, ca ne marche toujours pas... Peu importe la date que tu rentres (ex : 15/12/2016), ca ne marche pas.","oui","Message d'erreur : \"Please complete the date as follow : DD/MM/YYYY\". Thanks !"]
[null,"Ending date","In progress",null,"oui","Message d'erreur : \"Please complete the date as follow : DD/MM/YYYY\". Thanks !"]
[null,"Tacite renewal","OK","Choix restreint à la liste déroulante","oui"]
[null,"Payment terms","OK","Choix restreint à la liste déroulante","oui"]
[null,"Add a new payment term","OK","Lien vers UF NEW payment term. > OK\nLe nouveau payment term renseigné devra venir compléter la liste déroulante créé à cet effet."]
[null,"Termination notice","OK","Choix restreint à la liste déroulante","oui"]
[null,"Add a new termination notice","OK","Lien vers UF NEW termination notice. > OK\nLe nouveau termination notice renseigné devra venir compléter la liste déroulante créé à cet effet (en cours de création)."]
[null,"Shipping conditions","OK","Choix restreint à la liste déroulante","oui"]
[null,"Add a new shipping condition","OK","Lien vers UF NEW shipping condition.> OK\n Le nouveau shipping condition renseigné devra venir compléter la liste déroulante créé à cet effet (en cours de création)."]
[null,"Currency","OK","Choix restreint à la liste déroulante","oui"]
[null,"Validity of the pricing","In progress","Idem que pour Starting et Ending date","oui","Message d'erreur : \"Please complete the date as follow : DD/MM/YYYY\". Thanks !"]
[null,"Document owner","OK","Texte libre","oui"]
[null,"E-mail document owner","OK","Réponse doit contenir un @","oui","Message d'erreur : \"Your entry is incorrect. Please try again\""]
[null,"E-mail purchasing document supervisor","OK","Réponse doit contenir un @","oui","Message d'erreur : \"Your entry is incorrect. Please try again\""]
[null,"Date of 1st notification","In progress","Idem que pour Starting et Ending date","oui","Message d'erreur : \"Please complete the date as follow : DD/MM/YYYY\". Thanks !"]
[null,"Date of 2nd notification","In progress","Idem que pour Starting et Ending date","oui","Message d'erreur : \"Please complete the date as follow : DD/MM/YYYY\". Thanks !"]
[null,"Document value","OK","Chiffres seulement","oui","Peux-tu faire apparaître le sigle de la devise à côté du montant, comme pour l'ancien fichier, et seulement sur les devises suivantes (CHF, EUR, USD, GBP)"]
[null,"Physical place of the amendment","OK","Texte libre","oui"]
[null,"Comments","OK","Texte libre, avec limite de 500 caractères","non"]
[null,"Save","FAIT sauf macro associée au bouton Quit qui doit enregister et fermer (à voir plus tard avec enregistrement du classeur)","Apres l’enregistrement des donnees, pourrais-tu créer une macro pour demander \ns’il souhaite ajouter un autre document, revenir a la page Home, ou quitter le fichier ?\nSi ajout d’un nouveau doc, il faudrait que l’UF qui s’affiche soit vide, et n’affiche pas les donnees enregistrees juste avant.","oui"]
[null,"Cancel","OK","Retour vers \"Home\"","oui"]
["MODIFICATION","Password","In progress","Texte libre mais doit matcher le password qui leur sera communiqué (liste dans data base enterprise)","oui","Message d'erreur : \"Your entry for the password is incorrect. Please try again\" "]
["SEARCH","Password","In progress","Texte libre mais doit matcher le password qui leur sera communiqué (liste dans data base enterprise)","oui","Message d'erreur : \"Your entry for the password is incorrect. Please try again\" "]
[]
[]
["FONCTIONNALITES GLOBALES DU FICHIER"]
[]
["A l'ouverture, le fichier doit s'ouvrir en plein écran"]
["Seul l'onglet \"Home\" doit être visible, tous les autres doivent êtres cachés, et ce tout le temps."]
["A la fin de chaque opération, le fichier doit s'enregistrer automatiquement"]
["A la fin de remplissage d'un UF, les champs obligatoires non renseignés doivent apparaître en surlignés."]
["Fichier doit rester ouvert pas plus de 5 minutes si aucune action dessus"]
["Fichier et macros à protéger par password"]

{"sheet":"Legal docs listing","index":2,"n_rows":183,"n_cols":50,"rows_kept":183,"cut":false,"hidden":false,"merged":[]}
["Date of creation","Document number","Type of legal document","Purchasing division","Purchasing sub-category","Cpy Site","BU involved","Department","Supplier name","Supplier segmentation","Supplier e-mail (if applicable)","Description of the document","Starting date of the document","Ending date of the document","Tacit renewal","Payment terms","Termination notice","Shipping conditions","Currency of the document","Validity of the pricing","Document owner","E-mail document owner","E-mail purchasing document supervisor","Date of the 1st reminder to send","Date of the 2nd reminder to send","Document value, yearly basis","Physical place of the document","Comments",null,"Type of legal document","Purchasing division","Purchasing sub-category","Cpy Site","BU involved","Department",null,"Supplier segmentation","Supplier e-mail (if applicable)","Description of the document","Starting date of the document","Ending date of the document","Tacit renewal","Payment terms","Termination notice","Shipping conditions","Currency of the document",null,"Supplier Name","Supplier Segmentation"]
["2016-06-16","C-I-ASI-01-16-1","Contract","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","description contrat 1","2016-09-19","2023-01-01","YES",50,1,"DDP","CHF","2016-12-31","Nicolas","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-09-01","2017-02-01",1230,"place 1","commentaire 1",null,"Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office",null,"Strategic",null,null,null,null,"YES",10,0.5,"","CHF","CHF","APPLE","Strategic",2]
["2016-06-16","C-I-ASI-05-15-2","Contract","Indirect","Belts","ASI-Switzerland","Sheet Fed","Back Office","APPLE","Strategic","","description contrat 2 - TEST modif","2015-05-01","2018-01-01","YES","30 DAYS","5","DDP","CHF","02.02.2016","owner 2","nicolas.delarbre@bobst.com","bernadette.yakan@bobst.com","01.08.2016","01.05.2017","2222","place2","commentaire 2",null,"NDA","Direct","Cast iron ","BSA-Switzerland","Sheet Fed","Communication",null,"Preferred",null,null,null,null,"NO",20,1,"ASDWE","EUR","€","AUCHAN","Preferred",2]
["2016-06-16","A-I-ASI-01-16-1-1","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","Avenant - Ending date repoussée du 31/12/2017 au 31/12/2018","2016-01-01","2018-12-31","YES",50,1,"DDP","CHF","2016-12-31","owner 1","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-09-01","2017-02-01",1230,"place 1","commentaire 1",null,"Amendment","Project","Chains","SAM-France","Web Fed","Facility Management",null,"Tactical",null,null,null,null,"Unknown",30,2,"DDP","USD","$","BABY GO","Preferred",1]
["2016-06-17","A-I-ASI-01-16-1-2","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","Avenant - description contrat 1","01/01/2016","31/12/2020","YES",50,1,"DDP","CHF","31/12/2016","owner 1","owner1@","supervisor1@","01/09/2016","01/02/2017","1230","place 1","commentaire 1",null,"Rolling contract",null,"Communication","BAM-Tunisia","Services","Finance",null,null,null,null,null,null,null,45,3,"DDU","GBP","£","CARREFOUR","Preferred",1]
["2016-06-21","A-I-ASI-05-15-2-3","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","Back Office","APPLE","Strategic","","Avenant - description contrat 2","01/01/2016","31/12/2020","YES",50,1,"DDP","CHF","31/12/2016","owner 1","owner1@","supervisor1@","01/09/2016","01/02/2017","1230","place 1","commentaire 1",null,"SQA",null,"Connectors","BFA-France","Sheet Fed & Web Fed","HR",null,null,null,null,null,null,null,50,4,"EXW","  -------",null,"COCA","Tactical",1]
["2016-06-28","C-I-ASI-01-16-3","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","AUCHAN","Preferred","","Test avec email","2016-09-19","2017-01-01","YES",10,1,"DDP","CHF","2016-12-31","Brandon","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-08-01","2016-10-01",222,",kkk","",null,"T&C",null,"Consulting","ROT-Italy","Sheet Fed & Services","IP / Legal",null,null,null,null,null,null,null,70,5,"FCA","AED",null,"CONRAD","Preferred",2]
["2016-06-28","C-D-ASI-01-16-4","Contract","Direct","Belts","ASI-Switzerland","All of them","Back Office","CARREFOUR","Preferred","","essr","2016-01-01","2018-01-01","YES",30,1,"DDU","CHF","2016-12-31","zer","nicolas.delarbre@bobst.com","bernadette.yakan@bobst.com","2016-08-01","2017-01-01",2232,"hdf","",null,null,null,"Cylindrical Turning","SCH-Italy","Web Fed & Services","IT",null,null,null,null,null,null,null,90,6,"FOB","AFN",null,"DANONE","Strategic",1]
["2016-08-17","C-I-ASI-01-16-5","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","AUCHAN","Preferred","","d","2016-01-01","2017-01-01","YES",70,1,"DDP","CHF","2016-12-31","ee","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-09-01","2016-10-01",2333,"eee","",null,null,null,"DP","BFL-Italy","Services & Sheet Fed","Logistic",null,null,null,null,null,null,null,110,7,"QWD","ALL",null,"EVIAN","Tactical",2]
["2016-08-17","C-I-ASI-01-16-6","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","BABY GO","Preferred","","e","2016-01-01","2017-01-01","YES",50,1,"DDP","CHF","2017-01-01","e","nicolas.delarbre@bobst.com","bernadette.yakan@bobst.com","2016-09-01","2016-10-01",2132,"ee","",null,null,null,"Drives","BES-Spain","Unknown","Marketing",null,null,null,null,null,null,null,130,8,null,"AMD",null,"INTERMARCHE","Strategic",2]
["2016-08-24","C-I-ASI-01-16-7","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","APPLE","Strategic","","essai quit","2016-09-19","2017-01-01","YES","10 DAYS","0,5","DDP","CHF","2017-01-01","JC","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-09-01","2016-10-10",21332,"aaa","",null,null,null,"Electrical modules","FKG-Germany",null,"Planning",null,null,null,null,null,null,null,150,9,null,"ANG",null,"LECLERC","Tactical",2]
["2016-08-29","A-I-ASI-01-16-1-4","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","Avenant - description contrat 3","2016-01-01","2020-12-31","YES","50 DAYS","1","DDP","CHF","2016-12-31","owner 1","nicolas.delarbre@bobst.com","bernadette.yakan@bobst.com","2016-09-01","2017-02-01",1230,"place 1","commentaire 1",null,null,null,"Electrical switch cabinet ","BOG-Germany",null,"Procurement",null,null,null,null,null,null,null,170,10,null,"AOA",null,"LEOMAT","Preferred",1]
["2016-08-29","A-I-ASI-05-15-2-5","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","Back Office","APPLE","Strategic","","Avenant - description contrat 4","2015-05-01","2018-01-01","YES","70 DAYS","5","DDP","CHF","2016-02-02","owner 2","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-08-01","2017-05-01",2222,"place2","commentaire 2",null,null,null,"Electronic","STE-Germany",null,"Production",null,null,null,null,null,null,null,190,11,null,"ARS",null,"MONDIDO","Strategic",1]
["2016-08-30","C-I-BSA-01-17-8","Contract","Indirect","IT & Telecoms","BSA-Switzerland","Sheet Fed","Communication","DANONE","Strategic","","Achat test DAnone","2017-01-01","2020-01-01","NO","10 DAYS",1,"DDP","CHF","2018-01-01","dsffds","fdsfsd@","fdsfds21@","2019-01-01","2020-01-01",7852,"fds","",null,null,null,"Enclosure","GEN-United Kingdom",null,"Purchasing",null,null,null,null,null,null,null,210,12,null,"AUD",null,"NESTEA","Preferred",2]
["2016-08-30","C-I-BSA-01-17-9","Contract","Indirect","Human Resources","BSA-Switzerland","Sheet Fed","Communication","BABY GO","Preferred","","Achat test Baby Go","2017-01-01","2020-01-01","NO","10 DAYS",1,"DDP","CHF","2019-01-01","fdsds","fds@","fdsdfs@","2018-01-01","2019-01-01",4500,"fdss","",null,null,null,"Facilities Management","BGL-United Kingdom",null,"Quality",null,null,null,null,null,null,null,230,"13",null,"AWG",null,"NESTLE","Preferred",2]
["2016-08-31","C-I-BSA-05-17-10","Contract","Indirect","IT & Telecoms","BSA-Switzerland","All of them","Back Office","SONY","Tactical","","Achat test Sony","2017-05-01","2021-01-01","YES","110 DAYS",1,"DDP","CHF","2018-01-01","fds","fssds@","fdds@","2018-01-01","2019-01-01",45785,"ici","",null,null,null,"Factory Supplies","BGS-Denmark",null,"R&D",null,null,null,null,null,null,null,250,"58",null,"AZN",null,"NVO","Preferred",2]
["2016-08-31","A-I-BSA-05-17-10-6","Amendment","Indirect","IT & Telecoms","BSA-Switzerland","All of them","Back Office","SONY","Tactical","","Achat test Sony - modification","2017-01-05","2021-01-01","YES","10 DAYS",1,"DDP","CHF","2018-01-01","fds","fssds@","fdds@","2018-01-01","2019-01-01",10000,"ici","",null,null,null,"Fans","BGV-Russia",null,"Travel",null,null,null,null,null,null,null,270,null,null,"BAM",null,"SAMSUNG","Strategic",1]
["2016-08-31","C-I-BSA-02-17-11","Contract","Indirect","IT & Telecoms","BSA-Switzerland","All of them","Back Office","SONY","Tactical","","Achat test Sony V2","2017-02-01","2020-01-01","NO","10 DAYS",1,"DDP","CHF","2018-01-01","dsffds","fdss@","fdsds@","2018-01-01","2019-01-01",785699,"ffds","",null,null,null,"Fluidics","BBN-Belgium",null,null,null,null,null,null,null,null,null,290,null,null,"BBD",null,"SONY","Tactical",2]
["2016-08-31","C-I-BSA-02-17-12","Contract","Indirect","Consulting","BSA-Switzerland","Sheet Fed","Communication","WESTHOUSE","Preferred","","Achat Westhouse","2017-02-01","02.01.2020","NO","20 DAYS","1","DDU","EUR","01.02.2018","fds","fdsds@","oim@","01.03.2018","01.05.2018","458","fg","",null,null,null,"Gears manufacturing","BIS-Turkey",null,null,null,null,null,null,null,null,null,null,null,null,"BDT",null,"SQUALITY","Tactical",2]
["2016-08-31","A-I-BSA-02-17-12-7","Amendment","Indirect","Consulting","BSA-Switzerland","Sheet Fed","Communication","WESTHOUSE","Preferred","","Achat Westhouse - avenant sans changer les dates.","2017-01-02","2020-01-02","NO","20 DAYS","1","DDU","EUR","2018-01-02","fds","fdsds@","oim@","2018-01-03","2018-01-05",458,"fg","",null,null,null,"Heating elements","BPL-Poland",null,null,null,null,null,null,null,null,null,null,null,null,"BGN",null,"TRY","Preferred",1]
["2016-08-31","C-I-BSA-02-17-13","Contract","Indirect","Consulting","BSA-Switzerland","Sheet Fed","Communication","UBER","Tactical","","Tets","2017-02-01","2019-03-01","NO","20 DAYS","1","DDU","CHF","2018-02-01","dfsdfs","fdsdfs@","fdsqw@","2018-02-05","2018-09-05",7896,"fdss","",null,null,null,"Human Resources","BEE-Czech Republic",null,null,null,null,null,null,null,null,null,null,null,null,"BHD",null,"UBER","Tactical",2]
["2016-08-31","C-I-BSA-02-17-14","Contract","Indirect","Paint","BSA-Switzerland","Sheet Fed","Facility Management","NVO","Preferred","","Test NVO","2017-02-01","2020-02-01","NO","290 DAYS","13","QWD","CHF","2018-05-01","moi","moi@","lui@","2018-05-01","2018-06-01",963,"fds","",null,null,null,"IT & Telecoms","BGU-United States",null,null,null,null,null,null,null,null,null,null,null,null,"BIF",null,"WESTHOUSE","Preferred",2]
["2016-08-31","C-D-BSA-02-17-15","Contract","Direct","Chains","BSA-Switzerland","Sheet Fed","Communication","COCA","Tactical","","Test","2017-02-01","2019-02-06","NO","20 DAYS","1","FCA","USD","2018-05-01","fdsds","fdsdsf@","fdsfds@","2018-06-01","2018-09-01",5000,"fdsdfs","",null,null,null,"Kinematics","BBR-Brazil",null,null,null,null,null,null,null,null,null,null,null,null,"BMD",null,null,null,2]
["2016-08-31","A-D-BSA-02-17-15-8","Amendment","Direct","Chains","BSA-Switzerland","Sheet Fed","Communication","COCA","Tactical","","Test- modification-V2 est-ce que ca a créé une ligne ?","2/1/2017","2/6/2019","NO","20 DAYS","1","FCA","USD","5/1/2018","fdsds","fdsdsf@","fdsfds@","6/1/2018","9/1/2018","5000","fdsdfs","",null,null,null,"Labels","BLN-Mexico",null,null,null,null,null,null,null,null,null,null,null,null,"BND",null,null,null,1]
["2016-08-31","A-I-ASI-01-16-1-9","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","description contrat 1 - avenant 1","2016-01-01","2021-01-01","YES","50 DAYS","1","DDP","CHF","2020-02-01","owner 1","owner1@","supervisor1@","2020-02-01","2020-03-01",5000,"place 1","commentaire 1",null,null,null,"Logistics & Transport","BSL-China",null,null,null,null,null,null,null,null,null,null,null,null,"BOB",null,null,null,1]
["2016-08-31","A-I-ASI-01-16-1-10","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","description contrat 1 - avenant 2","2016-01-01","2022-01-01","YES","50 DAYS","1","DDP","CHF","2021-02-01","owner 1","owner1@","supervisor1@","2021-02-01","2021-05-01",70000,"place 1","commentaire 1",null,null,null,"Machine tooling","BTH-Thailand ",null,null,null,null,null,null,null,null,null,null,null,null,"BOV",null,null,null,1]
["2016-08-31","A-I-ASI-01-16-1-11","Amendment","Indirect","Belts","ASI-Switzerland","Sheet Fed","HR","APPLE","Strategic","","description contrat 1 - avenant 3","2016-01-01","2023-01-01","YES","50 DAYS","1","DDP","CHF","2022-02-01","owner 1","owner1@","supervisor1@","2022-04-01","2022-06-01",10000,"place 1","commentaire 1",null,null,null,"Motors","BIN-India",null,null,null,null,null,null,null,null,null,null,null,null,"BRL",null,null,null,1]
["2016-08-31","C-I-BSA-02-17-16","Contract","Indirect","Facilities Management","BSA-Switzerland","All of them","Facility Management","LEOMAT","Preferred","","Test contrat leomat V1","2017-02-01","2020-02-01","NO","10 DAYS",1,"DDP","CHF","2018-05-01","fdsds","fdsfsd@","fdsfsd@","2018-06-01","2018-08-01",5000,"fdsfs","",null,null,null,"Multitechnology modules","BJL-Japan",null,null,null,null,null,null,null,null,null,null,null,null,"BSD",null,null,null,2]
["2016-08-31","A-I-BSA-02-17-16-12","Amendment","Indirect","Facilities Management","BSA-Switzerland","All of them","Facility Management","LEOMAT","Preferred","","Avenant 1 - TEST MODIF","1/2/2017","1/2/2020","NO","10 DAYS",1,"DDP","CHF","1/5/2018","fdsds","fdsfsd@","fdsfsd@","1/6/2018","1/8/2018","5000","fdsfs","",null,null,null,"Optical ","BIA-Indonesia",null,null,null,null,null,null,null,null,null,null,null,null,"BTN",null,null,null,1]
["2016-08-31","A-I-BSA-02-17-16-13","Amendment","Indirect","Facilities Management","BSA-Switzerland","All of them","Facility Management","LEOMAT","Preferred","","Test contrat leomat V1 - 2EME MODIF","2/1/2017","2/1/2020","NO","10 DAYS",1,"DDP","CHF","5/1/2018","fdsds","fdsfsd@","fdsfsd@","6/1/2018","8/1/2018","5000","fdsfs","",null,null,null,"Other electrical components","BMA-Malaysia",null,null,null,null,null,null,null,null,null,null,null,null,"BWP",null,null,null,1]
["2016-08-31","C-I-ASI-02-17-17","Contract","Indirect","Travel","ASI-Switzerland","All of them","Back Office","CONRAD","Preferred","","Test contrat Conrad","2017-02-01","2020-01-02","YES","10 DAYS",1,"DDP","CHF","2018-03-01","fdsfs","fdsfds@","ffds@","2018-04-01","2019-05-01",458,"fdss","",null,null,null,"Other mechanical components","All of them",null,null,null,null,null,null,null,null,null,null,null,null,"BYR",null,null,null,2]
["2016-08-31","A-I-ASI-02-17-17-14","Amendment","Indirect","Travel","ASI-Switzerland","All of them","Back Office","CONRAD","Preferred","","Avenant 1","2017-01-02","2020-01-02","YES","10 DAYS",1,"DDP","CHF","2018-01-03","fdsfs","fdsfds@","ffds@","2018-01-04","2019-01-05",458,"fdss","",null,null,null,"Paint",null,null,null,null,null,null,null,null,null,null,null,null,null,"BZD",null,null,null,1]
["2016-08-31","A-I-ASI-02-17-17-15","Amendment","Indirect","Travel","ASI-Switzerland","All of them","Back Office","CONRAD","Preferred","","Avenant 2","2017-01-02","2020-02-01","YES","10 DAYS",1,"DDP","CHF","2018-01-03","fdsfs","fdsfds@","ffds@","2018-01-04","2019-01-05",458,"fdss","",null,null,null,"PCB",null,null,null,null,null,null,null,null,null,null,null,null,null,"CAD",null,null,null,1]
["2016-08-31","A-I-ASI-02-17-17-16","Amendment","Indirect","Travel","ASI-Switzerland","All of them","Back Office","CONRAD","Preferred","","Test contrat Conrad-test modif","2/1/2017","1/2/2020","YES","10 DAYS",1,"DDP","CHF","3/1/2018","fdsfs","fdsfds@","ffds@","4/1/2018","5/1/2019","458","fdss","",null,null,null,"Peripherical machines",null,null,null,null,null,null,null,null,null,null,null,null,null,"CDF",null,null,null,1]
["2016-08-31","S-D-SAM-05-17-1","SQA","Direct","Communication","SAM-France","Web Fed & Services","IT","SQUALITY","Tactical","contact@squality.fr","Test SQA _ Squality","2017-05-01","2019-05-01","NO","20 DAYS","1","DDU","EUR","2018-02-02","fds","fdsfds@","fdsfds@","2018-10-15","2019-02-01",5000,"ici","",null,null,null,"Plastics and synthetics",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHE"]
["2016-09-05","C-I-BSA-02-17-18","Contract","Indirect","Belts","BSA-Switzerland","Sheet Fed","Communication","COCA","Tactical","","Test lundi 05/09, 11.40","2017-02-01","2019-03-01","YES","10 DAYS",1,"DDP","CHF","2017-05-01","fdsfs","fdsfsd@","fdsfsd@#","2017-06-01","2017-07-01",52,"fsd","",null,null,null,"Pneumatic",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHW",null,null,null,2]
["2016-09-06","C-I-All-02-17-19","Contract","Indirect","Belts","All of them","All of them","Back Office","APPLE","Strategic","","Test CCM","2017-02-01","2020-02-01","YES","10 DAYS",1,"DDP","EUR","2018-02-01","fsdfds","fdsfds@","ffdsfds@","2019-09-01","2019-10-01",4,"fdsfdds","",null,null,null,"Podium",null,null,null,null,null,null,null,null,null,null,null,null,null,"CLF",null,null,null,2]
["2016-09-06","C-I-ASI-05-17-20","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","APPLE","Strategic","","Test F89","2017-05-01","2018-06-01","YES","10 DAYS","2","DDU","EUR","2017-08-01","01092017","fdsdfs@","fdsfds@","2018-02-01","2018-03-01",45,"fds","",null,null,null,"Podiums ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CLP",null,null,null,2]
["2016-09-16","R-I-BAM-05-17-1","Rolling contract","Indirect","Chains","BAM-Tunisia","Web Fed","IP / Legal","EVIAN","Tactical","contact@evian.com","test rolling contract Evian - MODIF DATE DE FIN ET VALEUR","2017-05-01","2027-12-01","NO","20 DAYS","3","FCA","EUR","05.09.2017","luigi","luigi@hotmail.com","mario.bross@nintendo.com","01.10.2018","01.12.2018","50000","ici","",null,null,null,"Power",null,null,null,null,null,null,null,null,null,null,null,null,null,"CNH",null,null,null,2]
["2016-09-07","A-I-BSA-02-15-21-17","Amendment","Indirect","IT & Telecoms","BSA-Switzerland","Sheet Fed","Communication","UBER","Tactical","","Test nouveau contrat UBER - MODIF ending date + doc value","2015-02-01","2020-05-01","NO","30 DAYS","2","EXW","USD","2018-02-01","moi","moi@","lui@","2017-10-01","2017-12-01",5000,"La bas","",null,null,null,"Prismatic",null,null,null,null,null,null,null,null,null,null,null,null,null,"CNY",null,null,null,1]
["2016-09-07","C-I-BSA-02-17-22","Contract","Indirect","Communication","BSA-Switzerland","Sheet Fed","Communication","COCA","Tactical","","Test com coca","2017-02-01","2020-05-05","NO","30 DAYS","2","EXW","EUR","2018-01-01","fdsds","fdsfds@","gdsfs@","2019-10-01","2019-12-01",5000,"fdsfs","",null,null,null,"Prismatic Milling",null,null,null,null,null,null,null,null,null,null,null,null,null,"COP",null,null,null,2]
["2016-09-07","A-I-BSA-02-17-22-18","Amendment","Indirect","Communication","BSA-Switzerland","Sheet Fed","Communication","COCA","Tactical","","Test com coca - modif date fin","2017-02-01","2020-05-05","NO","30 DAYS","2","EXW","EUR","2018-01-01","fdsds","fdsfds@","gdsfs@","2019-10-01","2019-12-01",5000,"fdsfs","",null,null,null,"R&D Projects",null,null,null,null,null,null,null,null,null,null,null,null,null,"COU",null,null,null,1]
["2016-09-12","A-I-BSA-02-17-12-19","Amendment","Indirect","Consulting","BSA-Switzerland","Sheet Fed","Communication","WESTHOUSE","Preferred","","Achat Westhouse - avenant 1","2017-02-01","2020-01-02","NO","20 DAYS","1","DDU","EUR","2018-02-01","fds","fdsds@","oim@","2018-03-01","2018-05-01",458,"fg","",null,null,null,"Raw cables and accessories ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CRC",null,null,null,1]
["2016-09-12","A-I-BSA-02-17-12-20","Amendment","Indirect","Consulting","BSA-Switzerland","Sheet Fed","Communication","WESTHOUSE","Preferred","","Achat Westhouse - avenant 2","2017-02-01","2020-01-02","NO","20 DAYS","1","DDU","EUR","2018-02-01","fds","fdsds@","oim@","2018-03-01","2018-05-01",458,"fg","",null,null,null,"Raw material",null,null,null,null,null,null,null,null,null,null,null,null,null,"CUC",null,null,null,1]
["2016-09-21","R-P-BSA-05-17-2","Rolling contract","Project","Kinematics","BSA-Switzerland","Sheet Fed","Production","MONDIDO","Strategic","","Test nouveau contrat envoi e-mail - MODIF","2017-05-05","2020-05-05","NO","20 DAYS","3","EXW","CHF","05.05.2020","luigi","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2016-09-20","2016-09-21","8500","ici","",null,null,null,"Safety ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CUP"]
["2016-09-23",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,"Screws",null,null,null,null,null,null,null,null,null,null,null,null,null,"CVE"]
["2016-09-23",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,"Sheet metal work",null,null,null,null,null,null,null,null,null,null,null,null,null,"CZK"]
["2016-09-23",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,"Springs",null,null,null,null,null,null,null,null,null,null,null,null,null,"DJF"]
["2016-09-26","C-I-BSA-10-16-22","Contract","Indirect","IT & Telecoms","BSA-Switzerland","Sheet Fed","IT","CARREFOUR","Preferred","","Test ajout contrat Carrefour pour voir si date d'ajout de doc correcte","2016-10-01","2019-10-01","NO","30 DAYS","2","EXW","EUR","2019-10-01","Nicolas Delarbre","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com","2019-05-01","2019-08-01",5000,"Bureau Nicolas Morales","No comment",null,null,null,"Steel casting ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DKK",null,null,null,2]
["2016-09-26",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,"Sub-categ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DOP"]
["2016-09-26",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,"Synthetic",null,null,null,null,null,null,null,null,null,null,null,null,null,"DZD"]
["2016-09-27",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,"Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,"EGP"]
["2016-09-27","C-D-FKG-05-15-23","Contract","Direct","DP","FKG-Germany","Sheet Fed","Facility Management","WESTHOUSE","Preferred","fdafds@","Please specify the object & scope of the CONTRACT, articles number or services purchased","2015-05-01","2019-06-01","YES","30 DAYS","0.5","DDU","USD",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,"ERN",null,null,null,1]
["2016-09-27","C-D-BSA-05-16-24","Contract","Direct","Cast iron ","BSA-Switzerland","Sheet Fed","Back Office","APPLE","Strategic","","essai","2016-05-01","2018-12-20","NO","20 DAYS","1","DDP","EUR","2018-01-01","fsdfsd","fdsfds@","fdsfsd@","2018-01-01","2018-02-02",52,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETB",null,null,null,1]
["2016-09-27","S-D-SAM-01-16-2","SQA","Direct","Communication","SAM-France","Web Fed","Communication","COCA","Tactical","","Test SQA","2016-01-01","2019-01-01","NO","30 DAYS","1","DDP","CHF","2019-01-01","lui","lui@","elle@","2018-01-01","2018-06-01",5000,"ici","no comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FJD"]
["2016-09-27",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,"FKP"]
["2016-09-27",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,"GEL"]
["2016-09-27",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,"GHS"]
["2016-09-27",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,"GIP"]
["2016-09-27",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,"GMD"]
["2016-09-27",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,"GNF"]
["2016-09-27",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,"GTQ"]
["2016-09-27","C-I-ASI-09-16-25","Contract","Indirect","Cast iron ","ASI-Switzerland","All of them","Back Office","APPLE","Strategic","","Please specify the object & scope of the CONTRACT, articles number or services purchased","2016-09-01","2018-10-01","YES","10 DAYS","2","DDU","USD","2018-10-01","lui","lui@","elle@","2018-09-01","2018-10-01",5000,"ici","fsd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GYD",null,null,null,2]
["2016-09-27","C-I-BAM-09-16-26","Contract","Indirect","Drives","BAM-Tunisia","Services","Communication","NESTEA","Preferred","","test 27/09 avec e-mail","2016-09-01","2018-12-01","NO","45 DAYS","3","DDP","EUR","2018-12-01","Nicolas Delarbre","nicolas.delarbre@bobst.com","bernadette.yakan@bobst.com","2016-09-26","2018-10-01",6000,"Ici","no comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HKD",null,null,null,2]
["2016-09-27",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,"HNL"]
["2016-09-28","C-P-BSA-02-17-27","Contract","Project","Cast iron ","BSA-Switzerland","Sheet Fed","Communication","BABY GO","Preferred","","Test ajout contrat pour ajout NDA et avenant","2017-02-01","2020-02-01","NO","30 DAYS","1","DDP","EUR","2020-02-01","moi","moi @","lui@","2019-01-01","2019-05-01",5000,"ici","no comment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HRK",null,null,null,1]
["2016-09-28","C-I-SAM-01-15-28","Contract","Indirect","Cast iron ","SAM-France","Sheet Fed & Web Fed","Finance","EVIAN","Tactical","","Test ajout contrat pour ajout avenant 2 - TEST MODIF","2015-01-01","2019-01-01","NO","50 DAYS","6","DDP","EUR","01.01.2018","lui","dfs@","fsxsf@","01.05.2017","01.09.2017","4500","ici","pourquoi pas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTG",null,null,null,2]
["2016-09-28","C-D-BAM-05-17-29","Contract","Direct","Cylindrical Turning","BAM-Tunisia","Web Fed","Communication","BABY GO","Preferred","","dajl dajéda jél das","2017-05-05","2019-02-02","NO","45 DAYS","5","DDU","USD","2019-01-01","fds","fdsyx@","rewcf@","2017-09-01","2017-10-01",78562,"fdsa","fksdlékàé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUF",null,null,null,1]
["2016-09-28","C-I-ASI-02-16-30","Contract","Indirect","Belts","ASI-Switzerland","All of them","Back Office","APPLE","Strategic","","Please specify the object & scope of the CONTRACT, articles number or services purchased","2016-02-01","2017-06-01","NO","20 DAYS","1","DDP","CHF","2017-02-01","fds","df@","fwx@","2017-02-01","2017-03-01",50,"fd","fdss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDR",null,null,null,2]
["2016-09-28",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,"ILS"]
["2016-09-30","C-I-BAM-05-16-31","Contract","Indirect","Chains","BAM-Tunisia","Web Fed","Communication","AUCHAN","Preferred","","Test ajout contrat puis NDA juste après","2016-05-01","2018-05-01","NO","45 DAYS","4","DDU","EUR","2017-06-01","moi","moi@","lui@","2018-02-01","2018-03-01",15000,"so","j",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INR",null,null,null,3]
["2016-10-03",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,"IQD"]
[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,"IRR"]
[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,"ISK"]
[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,"JMD"]
[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,"JOD"]
[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,"JPY"]
[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,"KES"]
[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,"KGS"]
[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,"KHR"]
[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,"KMF"]
[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,"KPW"]
[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,"KRW"]
[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,"KWD"]
[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,"KYD"]
[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,"KZT"]
[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,"LAK"]
[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,"LBP"]
[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,"LKR"]
[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,"LRD"]
[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,"LSL"]
[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,"LTL"]
[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,"LYD"]
[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,"MAD"]
[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,"MDL"]
[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,"MGA"]
[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,"MKD"]
[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,"MMK"]
[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,"MNT"]
[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,"MOP"]
[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,"MRO"]
[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,"MUR"]
[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,"MVR"]
[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,"MWK"]
[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,"MXN"]
[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,"MXV"]
[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,"MYR"]
[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,"MZN"]
[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,"NAD"]
[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,"NGN"]
[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,"NIO"]
[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,"NOK"]
[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,"NPR"]
[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,"NZD"]
[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,"OMR"]
[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,"PAB"]
[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,"PEN"]
[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,"PGK"]
[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,"PHP"]
[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,"PKR"]
[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,"PLN"]
[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,"PYG"]
[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,"QAR"]
[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,"RON"]
[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,"RSD"]
[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,"RUB"]
[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,"RWF"]
[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,"SAR"]
[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,"SBD"]
[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,"SCR"]
[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,"SDG"]
[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,"SEK"]
[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,"SGD"]
[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,"SHP"]
[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,"SLL"]
[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,"SOS"]
[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,"SRD"]
[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,"SSP"]
[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,"STD"]
[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,"SYP"]
[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,"SZL"]
[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,"THB"]
[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,"TJS"]
[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,"TMT"]
[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,"TND"]
[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,"TOP"]
[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,"TRY"]
[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,"TTD"]
[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,"TWD"]
[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,"TZS"]
[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,"UAH"]
[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,"UGX"]
[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,"USN"]
[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,"USS"]
[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,"UYI"]
[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,"UYU"]
[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,"UZS"]
[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,"VEF"]
[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,"VND"]
[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,"VUV"]
[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,"WST"]
[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,"XAF"]
[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,"XAG"]
[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,"XAU"]
[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,"XBA"]
[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,"XBB"]
[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,"XBC"]
[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,"XBD"]
[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,"XCD"]
[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,"XDR"]
[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,"XFU"]
[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,"XOF"]
[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,"XPD"]
[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,"XPF"]
[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,"XPT"]
[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,"XSU"]
[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,"XTS"]
[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,"XUA"]
[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,"XXX"]
[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,"YER"]
[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,"ZAR"]
[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,"ZMW"]
[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,"ZWD"]

{"sheet":"Data base Entreprise","index":3,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Data Base entreprise"]
["First Name","Last Name","Cpy site","Business Unit","Department","E-mail of your manager","E-mail","Password",null,"Department","Password"]
["Anne","T","BSA-Switzerland","Sheet Fed","HR","sylvain.biraben@travail.com","Anne.t@travail.com",{"$f":"VLOOKUP(E3,J:K,2,0)","v":"R3HC22"},null,{"$f":"INDIRECT(\"'Legal docs listing'!AI\"&ROW()-1)","v":"Back Office"},{"$f":"LEFT( UPPER(RIGHT(J3,1))&LEN(J3)*2-1 & LEFT(J3,1) &CHAR(65+MOD(LEN(J3),26))&LEN(J3)&LEN(J3),6)","v":"E21BL1"}]
["Julie","B","BSA-Switzerland","Web Fed","IT","michel.troie@travail.ocm","julie.b@travail.com","T3IC22",null,{"$f":"INDIRECT(\"'Legal docs listing'!AI\"&ROW()-1)","v":"Communication"},{"$f":"LEFT( UPPER(RIGHT(J4,1))&LEN(J4)*2-1 & LEFT(J4,1) &CHAR(65+MOD(LEN(J4),26))&LEN(J4)&LEN(J4),6)","v":"N25CN1"}]
["Karen","M","BSA-Switzerland","Services","Marketing","catherine.jones@travail.com","karen.m@travail.com","G17MJ9",null,"Facility Management","T37FT1"]
["Berny","Y","BSA-Switzerland","Sheet Fed","Procurement","nicolas.momo@travail.com","berny.k@travail.com","T21PL1",null,"Finance","E13FH7"]
["Mallaury","M","BSA-Switzerland","Web Fed","Procurement","nicolas.momo@travail.com","mallaury.m@travail.com","T21PL1",null,"HR","R3HC22"]
["Christophe","Deloitte","ASI-Switzerland","Sheet Fed","Back Office","m@","y@","E21BL1",null,"IP / Legal","L19IK1"]
["Nic","A","ASI-Switzerland","Services","Purchasing",null,null,"G19PK1",null,"IT","T3IC22"]
["Bob","DUPONT","BSA-Switzerland","Web Fed","HR","jean.ferra@test.com","bob.dupont@test.com",{"$f":"VLOOKUP(E10,J:K,2,0)","v":"R3HC22"},null,"Logistic","C15LI8"]
["Christophe","DELOITTE","BSA-Switzerland","Services","Back Office","test@manager.com","christophe.deloitte@test.com",{"$f":"VLOOKUP(E11,J:K,2,0)","v":"E21BL1"},null,"Marketing","G17MJ9"]
["Jc","VANDAM","BAM-Tunisia","Services","Communication","rockk.balboa@boxe.fr","jc.vandam@test.com",{"$f":"VLOOKUP(E12,J:K,2,0)","v":"N25CN1"},null,"Planning","G15PI8"]
["Bertrand","DUPUIS","SAM-France","Web Fed","Communication","nicolas.delarbre@bobst.com","nicolas.delarbre@bobst.com",{"$f":"VLOOKUP(E13,J:K,2,0)","v":"N25CN1"},null,"Procurement","T21PL1"]
[null,null,null,null,null,null,null,null,null,"Production","N19PK1"]
[null,null,null,null,null,null,null,null,null,"Purchasing","G19PK1"]
[null,null,null,null,null,null,null,null,null,"Quality","Y13QH7"]
[null,null,null,null,null,null,null,null,null,"R&D","D5RD33"]
[null,null,null,null,null,null,null,null,null,"Travel","L11TG6"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]
[null,null,null,null,null,null,null,null,null,0,"010B11"]

{"sheet":"Identification","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"REPORTING","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil1","index":6,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Voici par ordre d'importance mes coquilles :"]
[]
[null,null,"1- UF identification inutile "]
[]
[null,null,"L’UF Identification ne joue pas son rôle à fond. "]
[null,null,"En effet, après ouverture du fichier, tu peux fermer cet UF et cliquer sur les boutons « Addition, modification, search, et reporting », et remplir les UFs en conséquence et tout marche très bien. "]
[]
[null,null,"Ainsi, l’UF identification fait plus office de figurant que de garde-fous… "]
[]
[null,null,"Avez-vous moyen de faire en sorte que tous les autres boutons soient verrouillés tant que la personne ne s’est pas identifié ?, et qu'un message d'erreur s'affiche si on cherche à fermer l'UF ?"]
[]
[]
[null,null,"2- Affichage de l’onglet « Data base Entreprise » (ou un autre) après avoir créé un reporting "]
[]
[null,null,"Après avoir fait tourné la machine pour un reporting, j’ai noté que dans certains cas, il affichait le contenu de l’onglet « Data base Entreprise », ou un autre… "]
[null,null,"J'ai essayé de changer la propriété \"Visible\" de ces onglets, voire de tripatouiller en déverrouillant le fichier via le mdp, et cacher les onglets, et re-verrouiller, et essayer de modifier la propriété, mais rien ne marche…"]
[null,null,"Une idée ?"]
[]
[null,null,"Par défaut, il faudrait que le seul onglet visible, et ce pendant tout le temps que le fichier est ouvert, soit \"Home\"."]
[null,null,"Tous les autres doivent être cachés et non visible sans entrer le mdp."]
[]
[]
[null,null,"3- UF New identification"]
[]
[null,null,"- Est-il possible de ne pas permettre que l'UF soit fermé, ou si on clique sur Fermeture, tout le fichier se ferme ?"]
[null,null,"- Champ \"Your e-mail\" : après avoir rentré l'adresse e-mail, le message d'erreur (comme quoi le @ est manquant) s'affiche, alors que l'adresse e-mail est renseignée correctement."]
[]
[]
[null,null,"4- Ajout d'un doc (n'importe lequel) : Bouton Addition"]
[]
[null,null,"- si un des champs de l'UF n'est pas rempli, j'ai un message d'erreur \"Run time error 13\", et la ligne qui bug est"]
[null,null,"ref = Left(Me.PURCH_DIV, 1) & \"-\" & Left(Me.CPY_SITE, 3) & \"-\" & Format(Month(START_DATE), \"00\") & \"-\" & Right(Year(START_DATE), 2), de l'UF Addition_Doc > qui correspond au code pour la fabrication n° de reference du doc"]
[null,null,"Je ne comprends pas pourquoi cette ligne bug, car elle a marché jusqu'à présent, et je ne l'ai pas changé depuis nos dernières versions."]
[]
[]
[null,null,"- Réinitialisation nécessaire à chaque type de documents à ajouter : si je sélectionne \"NDA\" comme type de documents à ajouter à ma DBB, il m'affiche le formulaire à remplir en conséquence, pour lequel certains champs sont grisés (tout à fait normal et voulu, car pour un NDA, tous les champs ne sont pas à remplir, à contrario de tous les autres docs)."]
[null,null,"Par contre, si j'ai sélectionné NDA par erreur, et que je voulais en fait ajouter un contrat, il va maintenant m'afficher le formulaire avec les mêmes champs grisés que pour le NDA, alors qu'il ne le devrait pas."]
[null,null,"J'ai l'impression que les macros gardent en mémoire le dernier type de document qui a permis l'ouverture de l'UF en conséquence, et que lorsque on cherche à ajouter un autre document, il affiche le dernier UF ouvert, sans réinitialiser le tout avant."]
[null,null,"Suis-je assez clair ?"]