{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Liste déroulante","nouveaux élèves","exercice"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Liste déroulante","index":0,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["GRADES Néérlandais",null,"GRADES Français",null,"Catégorie"]
["CIV",null,"BURG",null,"Vol"]
["Sdt",null,"Sdt",null,"Vrij"]
["Mat",null,"Mat",null,"SOffr"]
["1Sdt",null,"1Sdt",null,"OOffr"]
["1MT",null,"1MT",null,"Offr"]
["Kpl",null,"Cpl"]
["KMT",null,"QMT"]
["KplChef",null,"CplChef",null,"RL"]
["KMC",null,"QMC",null,"F"]
["1KplChef",null,"1CplChef",null,"N"]
["1KC",null,"1QC"]
["Sgt",null,"Sgt"]
["MDL",null,"MDL"]
["2MR",null,"2MR"]
["1Sgt",null,"1Sgt"]
["1MDL",null,"1MDL"]
["MTR",null,"MTR"]
["1SgtChef",null,"1SgtChef"]
["MTC",null,"MTC"]
["1SgtMaj",null,"1SgtMaj"]
["1MR",null,"1MR"]
["Adjt",null,"Adjt"]
["1MC",null,"1MC"]
["AdjtChef",null,"AdjtChef"]
["1OM",null,"1MP"]
["AdjtMaj",null,"AdjtMaj"]
["OMC",null,"MPC"]
["OLt",null,"SLt"]
["2VZ",null,"2EV"]
["Lt",null,"Lt"]
["VTZ",null,"EDV"]
["Kapt",null,"Capt"]
["Cdt",null,"Cdt"]
["Maj",null,"Maj"]
[]
["ENGIN version néérlandaise",null,"ENGIN version française"]
["Aanhangwagen BROSHUIS AVLB",null,"Aanhangwagen BROSHUIS AVLB"]
["Aanhangwagen BROSHUIS Gn tuigen",null,"Aanhangwagen BROSHUIS Gn tuigen"]
["Aanhangwagen met losse dissel MOL 22T",null,"Aanhangwagen met losse dissel MOL 22T"]
["Bulldozer CATERPILLAR D6H SL II",null,"Bulldozer CATERPILLAR D6H SL II"]
["Bulldozer FIAT HITACHI FD 145",null,"Bulldozer FIAT HITACHI FD 145"]
["Ca track MERCEDES ACTROS + AhW BROSHUIS",null,"Ca track MERCEDES ACTROS + AhW BROSHUIS"]
["Ca track SCANIA P 124 NZ 420 + AhW BROSHUIS",null,"Ca track SCANIA P 124 NZ 420 + AhW BROSHUIS"]
["Ca VOLVO N10 kipwagen 12/18T",null,"Ca VOLVO N10 kipwagen 12/18T"]
["Compacte graafmachine KUBOTA KX 61.2",null,"Compacte graafmachine KUBOTA KX 61.2"]
["Compacte laadschop BOBCAT 773",null,"Compacte laadschop BOBCAT 773"]
["Elevator op wielen MANITOU MT 1337 SL",null,"Elevator op wielen MANITOU MT 1337 SL"]
["Gemengde groep op aanhangwagen ATLAS COPCO XAS 6",null,"Gemengde groep op aanhangwagen ATLAS COPCO XAS 6"]
["Gemengde groep op aanhangwagen COMPAIR DS40",null,"Gemengde groep op aanhangwagen COMPAIR DS40"]
["Graafmachine CASE 9013",null,"Graafmachine CASE 9013"]
["Graafmachine LIEBHERR R912L",null,"Graafmachine LIEBHERR R912L"]
["Graafmachine op wielen FIAT HITACHI FH150 W.3",null,"Graafmachine op wielen FIAT HITACHI FH150 W.3"]
["Hijskraan GROVE GMK 3050",null,"Hijskraan GROVE GMK 3050"]
["Kettingzaag STIHL MS 200",null,"Kettingzaag STIHL MS 200"]
["Kettingzaag STIHL MS 460",null,"Kettingzaag STIHL MS 460"]
["Kraanarm PALFINGER 3500 C",null,"Kraanarm PALFINGER 3500 C"]
["Kraanarm PALFINGER PK 36002",null,"Kraanarm PALFINGER PK 36002"]
["Laadschop FIAT HITACHI W170",null,"Laadschop FIAT HITACHI W170"]
["Nivelleermachine HMB BG 160 TA",null,"Nivelleermachine HMB BG 160 TA"]
["Nivelleermachine KOMATSU GALION 830",null,"Nivelleermachine KOMATSU GALION 830"]
["Polyvalent tuig CASE 9013",null,"Polyvalent tuig CASE 9013"]
["Polyvalent tuig JCB 3CX-4/E",null,"Polyvalent tuig JCB 3CX-4/E"]
["Trilplaat AMMANN AVH 6020",null,"Trilplaat AMMANN AVH 6020"]
["Trilplaat AMMANN AVP 2910",null,"Trilplaat AMMANN AVP 2910"]
["Trilstamper AMMANN AVS 68 E",null,"Trilstamper AMMANN AVS 68 E"]
["Trilstamper DYNAPAC LC 50",null,"Trilstamper DYNAPAC LC 50"]
["Trilwals AMMANN AC 110",null,"Trilwals AMMANN AC 110"]
["Trilwals AMMANN AV 32",null,"Trilwals AMMANN AV 32"]
["Trilwals AMMANN AV 95 N",null,"Trilwals AMMANN AV 95 N"]
["Trilwals DYNAPAC CA 151 A",null,"Trilwals DYNAPAC CA 151 A"]
["Trilwals DYNAPAC CA 151 D",null,"Trilwals DYNAPAC CA 151 D"]
["Tuig aanleg en afwerking GOMACO COMMANDER",null,"Tuig aanleg en afwerking GOMACO COMMANDER"]
["Tuig aanleg en afwerking POWER CURBER 8700",null,"Tuig aanleg en afwerking POWER CURBER 8700"]

{"sheet":"nouveaux élèves","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,9,5],[11,2,11,7]]}
["N° Matricule","Nom","Prénom","RL","Grade","Cat","Lieu naissance","Date naissance","Unité"]
["1001","ARTICHAUD","Simon","F","CIV","Vol","GAND","1987-03-10","CCLand-Dept Gn"]
["1002","BERGERAC","Salvatore","N","BURG","Vrij","LIEGE","1989-03-15","CCLand-Dept Gn"]
["1003","CHEMINOT","Frédéric","F","CIV","Vol","NAMUR","1970-01-23","CCLand-Dept Gn"]
["1004","BOQUET","Jonathan","N","BURG","Vrij","BRUXELLES","1987-11-03","CCLand-Dept Gn"]
["1005","CAQUELET","Yves","F","CIV","Vol","GENK","1985-10-06","CCLand-Dept Gn"]
["1006","DEROUTE","Winter","N","BURG","Vrij","HASSELT","1990-05-27","CCLand-Dept Gn"]
["1007","FARMIGNOUL","Alexandre","F","CIV","Vol",null,null,"CCLand-Dept Gn"]
[]
[null,"La colonne \"RL\" est une liste déroulante se trouvant dans la feuille \"liste déroulante\" nommée \"RL\""]
[]
[null,null,"La colonne \"Grade\" est une liste déroulante avec la fonction \"INDIRECT\" par rapport à la colonne \"RL\"\nc’est-à-dire que suivant le régime linguistique F pour français et N pour néerlandais, propose une liste déroulante des différents grades soit en F ou soit en N se trouvant dans la feuille \"liste déroulante\""]
[null,null,null,null,null,null,null,null,{"$f":"INDIRECT($D2)","v":"Sgt"}]
[null,null,null,null,null,null,null,null,{"$f":"INDIRECT($D3)","v":"MDL"}]

{"sheet":"exercice","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,8],[10,9,10,10]]}
["MATRICULE","NOM","PRENOM","RL","GRADE","CATEGORIE","LIEU DE NAISSANCE","DATE DE\nNAISSANCE","UNITE","TYPE ENGIN1","TYPE ENGIN2"]
["1001",{"$f":"IFERROR(VLOOKUP($A2,tab,COLUMN(),FALSE),\"\")","v":"ARTICHAUD"},"Simon","F","CIV","Vol","GAND","1987-03-10","CCLand-Dept Gn"]
["1002","BERGERAC","Salvatore","N","BURG","Vrij","LIEGE","1989-03-15","CCLand-Dept Gn"]
["1003","CHEMINOT","Frédéric","F","CIV","Vol","NAMUR","1970-01-23","CCLand-Dept Gn"]
["1004","BOQUET","Jonathan","N","BURG","Vrij","BRUXELLES","1987-11-03","CCLand-Dept Gn"]
["1005","CAQUELET","Yves","F","CIV","Vol","GENK","1985-10-06","CCLand-Dept Gn"]
["1006","DEROUTE","Winter","N","BURG","Vrij","HASSELT","1990-05-27","CCLand-Dept Gn"]
["1007","FARMIGNOUL","Alexandre","F","CIV","Vol",0,"00:00:00","CCLand-Dept Gn"]
[]
["Colonne\nréférence","Les cellules jaunes sont automatiquement remplies par rapport à la cellule \"MATRICULE\" via la fonction RECHERCHEV,\n le tableau référence, nommé \"tab\" se trouvant dans la feuille \"nouveaux élèves\""]
[null,null,null,null,null,null,null,null,null,"Voici mon soucis, j'aimerais que ces 2 colonnes me proposent un menu déroulant\n en néérlandais ou en français selon le régime linguistique \"RL\" choisi dans la feuille \"nouveaux élèves\" mais comme je me sers déjà de la fonction \"INDIRECT\" pour les grades, je ne peux nommer les listes de choix engins avec le même nom que pour le choix des grades dans la feuille \"nouveaux élèves\""]