{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["WksMesSportifs","WksUtlisationDeBdSomme","WksTirageAuSort","WksErreurDeConception","WksRedondanceDeDonnees","WksFontionsTexte","WksPasRechercheV","WksCheckList","WksUniquementTitre","WksAdministration","WksLangageTableaux","WksAjoutClePrimaire","WksMiseEnFormePourVide","WksEquivIndex","WksListesConditionnelles"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":101,"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":"WksMesSportifs","index":0,"n_rows":143,"n_cols":16,"rows_kept":143,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7]]}
[null,"Somme des points du champ \"Score maximum=3800 en fonction du choix du pauys en \"I2\"",null,null,null,null,null,null,"Liste des pays","Aujourd'hui",null,"Juniors",null,"Seniors"]
[null,{"$f":"SUMIF(TblSportifs[[#All],[Country]],ZnMonChoix,TblSportifs[[#All],[Score max=3800]])","v":26240},null,null,null,null,null,null,"Italy",{"$f":"TODAY()","v":"2017-12-28"},null,{"$f":"COUNTIF(TblSportifs[Category],\"Junior\")","v":32},null,{"$f":"COUNTIF(TblSportifs[[#All],[Category]],\"Senior\")","v":106}]
[null,"=SOMME.SI(TblSportifs[[#Tout];[Country]];ZnMonChoix;TblSportifs[[#Tout];[Score max=3800]])",null,null,null,null,null,null,null,"=AUJOURDHUI()",null,"=NB.SI(TblSportifs[Category];\"Junior\")",null,"=NB.SI(TblSportifs[[#Tout];[Category]];\"Senior\")"]
[]
["NAME","FIRST NAME","Country","Club","Sex","Birthday","Age","Category","Score max=3800","Score1 max=100","COMMENTS","Score max=1500","Score2 max=100","COMMENTS2","AVERAGE SCORE max=100","DECISION"]
["AGE","Marie","Belgium","Atleco","F","1995-09-26",{"$f":"DATEDIF(F6,TODAY(),\"y\")","v":22},{"$f":"IF(G6<18,\"Junior\",\"Senior\")","v":"Senior"},3590,{"$f":"ROUND(I6/38,0)","v":94},{"$f":"IF(AND(J6>=80,H6=\"Junior\"),\"High Potential\",IF(AND(J6>=60,H6=\"Senior\"),\"OK\",IF(J6>=60,\"More training needed\",\"To be improved\")))","v":"OK"},1208,{"$f":"ROUND(L6/15,0)","v":81},{"$f":"IF(AND(M6>=80,H6=\"Junior\"),\"High Potential\",IF(AND(M6>=60,H6=\"Senior\"),\"OK\",IF(M6>=60,\"More training needed\",\"To be improved\")))","v":"OK"},{"$f":"(M6+J6)/2","v":87.5},{"$f":"IF(AND(J6>=60,M6>=60),\"Accepted\",IF(M6>J6,\"New test needed\",\"Not accepted\"))","v":"Accepted"}]
["ALGRAIN","Michel","Belgium","Atleco","M","1997-06-11",20,"Senior",2432,64,"OK",870,58,"To be improved",61,"Not accepted"]
["ALLER-LOPEZ","Miguel","Spain","Asturial","M","2001-01-28",16,"Junior",2512,66,"More training needed",780,52,"To be improved",59,"Not accepted"]
["ANDCLYDE","Bonnie","Netherlands","Extrasportief","F","2000-05-22",17,"Junior",2140,56,"To be improved",1001,67,"More training needed",61.5,"New test needed"]
["ARICKX","Josiane","France","Olympic","F","1994-10-07",23,"Senior",2154,57,"To be improved",520,35,"To be improved",46,"Not accepted"]
["ATTEND","Charles","Belgium","Atleco","M","1994-06-19",23,"Senior",2784,73,"OK",988,66,"OK",69.5,"Accepted"]
["AUGRANDPIED","Berthe","Switzerland","Sporteo","F","1996-01-18",21,"Senior",3601,95,"OK",1223,82,"OK",88.5,"Accepted"]
["BELGUENANI","Mimoun","Algeria","USMA","M","2001-05-03",16,"Junior",1941,51,"To be improved",915,61,"More training needed",56,"New test needed"]
["BEN SLIMANE","Jamal","Algeria","JSK","M","1994-04-30",23,"Senior",2154,57,"To be improved",1200,80,"OK",68.5,"New test needed"]
["BENTHAMI-KHIBI","Hafida","Algeria","JSK","F","1995-03-30",22,"Senior",2897,76,"OK",897,60,"OK",68,"Accepted"]
["BERWETTE","Andrée","Switzerland","Sporteo","F","1995-04-06",22,"Senior",2858,75,"OK",858,57,"To be improved",66,"Not accepted"]
["BERY","Georges","France","Olympic","M","1993-09-28",24,"Senior",3156,83,"OK",1156,77,"OK",80,"Accepted"]
["BILLEN","Bernard","Belgium","Atleco","M","1997-05-09",20,"Senior",2841,75,"OK",841,56,"To be improved",65.5,"Not accepted"]
["BOLLE","Maggy","Belgium","Atleco","F","1999-06-12",18,"Senior",2969,78,"OK",343,23,"To be improved",50.5,"Not accepted"]
["BONNEWYN","Ariane","Belgium","Atleco","F","1995-08-19",22,"Senior",3086,81,"OK",1086,72,"OK",76.5,"Accepted"]
["BOVY","Michèle","Belgium","Atleco","F","1998-11-06",19,"Senior",1953,51,"To be improved",1280,85,"OK",68,"New test needed"]
["CALATAYUD","Mercedes","Spain","Asturial","F","1996-02-18",21,"Senior",3207,84,"OK",1207,80,"OK",82,"Accepted"]
["CAMBY","Thierry","Switzerland","Sporteo","M","1998-07-01",19,"Senior",2261,60,"OK",261,17,"To be improved",38.5,"Not accepted"]
["CARLIER","Luc","Belgium","Atleco","M","1997-06-24",20,"Senior",2420,64,"OK",420,28,"To be improved",46,"Not accepted"]
["CELY","Peter","Netherlands","Extrasportief","M","1996-12-26",21,"Senior",3541,93,"OK",776,52,"To be improved",72.5,"Not accepted"]
["CINCINATIS","Yves","Belgium","Atleco","M","1995-08-31",22,"Senior",3144,83,"OK",1144,76,"OK",79.5,"Accepted"]
["CLETTE","Lara","Switzerland","Sporteo","F","1994-07-17",23,"Senior",2813,74,"OK",244,16,"To be improved",45,"Not accepted"]
["COBLANT","Harry","Switzerland","Sporteo","M","2000-08-25",17,"Junior",2153,57,"To be improved",774,52,"To be improved",54.5,"Not accepted"]
["COLOGNE","Aude","Switzerland","Sporteo","F","2000-08-04",17,"Junior",1964,52,"To be improved",224,15,"To be improved",33.5,"Not accepted"]
["COSSE","Michèle","Switzerland","Sporteo","F","1996-10-16",21,"Senior",2003,53,"To be improved",800,53,"To be improved",53,"Not accepted"]
["COVAIR","Harry","Belgium","Atleco","M","1999-10-28",18,"Senior",2998,79,"OK",231,15,"To be improved",47,"Not accepted"]
["DAO","Phung Nam","Korea","Sporteo","M","1998-09-07",19,"Senior",3196,84,"OK",1196,80,"OK",82,"Accepted"]
["DE BACKER","Patrick","Belgium","Atleco","M","1999-05-10",18,"Senior",3410,90,"OK",1410,94,"OK",92,"Accepted"]
["de GHELDERE","Jean-Benoît","Switzerland","Sporteo","M","1997-11-04",20,"Senior",3255,86,"OK",1255,84,"OK",85,"Accepted"]
["DE LEEUW","Philippe","Belgium","Atleco","M","1995-09-27",22,"Senior",2535,67,"OK",535,36,"To be improved",51.5,"Not accepted"]
["DEBAST","Frédéric","Belgium","Atleco","M","1995-05-11",22,"Senior",2547,67,"OK",547,36,"To be improved",51.5,"Not accepted"]
["DECAMPS","Lucienne","France","Olympic","F","1997-04-02",20,"Senior",3240,85,"OK",1240,83,"OK",84,"Accepted"]
["DEQUENNE","Philippe","Belgium","Atleco","M","1994-08-08",{"$f":"DATEDIF(F38,TODAY(),\"y\")","v":23},{"$f":"IF(G38<18,\"Junior\",\"Senior\")","v":"Senior"},2547,{"$f":"ROUND(I38/38,0)","v":67},{"$f":"IF(AND(J38>=80,H38=\"Junior\"),\"High Potential\",IF(AND(J38>=60,H38=\"Senior\"),\"OK\",IF(J38>=60,\"More training needed\",\"To be improved\")))","v":"OK"},547,{"$f":"ROUND(L38/15,0)","v":36},{"$f":"IF(AND(M38>=80,H38=\"Junior\"),\"High Potential\",IF(AND(M38>=60,H38=\"Senior\"),\"OK\",IF(M38>=60,\"More training needed\",\"To be improved\")))","v":"To be improved"},{"$f":"(M38+J38)/2","v":51.5},{"$f":"IF(AND(J38>=60,M38>=60),\"Accepted\",IF(M38>J38,\"New test needed\",\"Not accepted\"))","v":"Not accepted"}]
["DETOUSSE","Aimée","France","Olympic","F","1999-08-28",18,"Senior",3732,98,"OK",1272,85,"OK",91.5,"Accepted"]
["DUHOUX","Marc","Switzerland","Sporteo","M","1999-09-08",18,"Senior",2688,71,"OK",688,46,"To be improved",58.5,"Not accepted"]
["DUMONT","Christophe","Belgium","Atleco","M","1995-09-17",22,"Senior",3219,85,"OK",1219,81,"OK",83,"Accepted"]
["DUPONT","Marie","Belgium","Atleco","F","1999-03-09",18,"Senior",2500,66,"OK",500,33,"To be improved",49.5,"Not accepted"]
["EAUDURANUS","Anne","Belgium","Atleco","F","1999-07-05",18,"Senior",2289,60,"OK",450,30,"To be improved",45,"Not accepted"]
["EL ALAMI","Brahim","Morocco","RAJA","M","1995-02-21",22,"Senior",2990,79,"OK",711,47,"To be improved",63,"Not accepted"]
["EL BARAKA","Mohammed","Morocco","WYDAD","M","2000-11-08",17,"Junior",3239,85,"High Potential",1239,83,"High Potential",84,"Accepted"]
["EL MALEH","Gad","Morocco","WYDAD","M","1993-11-04",24,"Senior",2504,66,"OK",1250,83,"OK",74.5,"Accepted"]
["EL MALEH","Arié","Morocco","WYDAD","M","2000-12-12",17,"Junior",3318,87,"High Potential",396,26,"To be improved",56.5,"Not accepted"]
["FONTAINE","Robert","Switzerland","Sporteo","M","1998-01-05",19,"Senior",3156,83,"OK",1156,77,"OK",80,"Accepted"]
["GARCIA Y ARENAS","José","Spain","Asturial","M","1994-03-14",23,"Senior",3133,82,"OK",1133,76,"OK",79,"Accepted"]
["GERGES","Antoinette","France","Olympic","F","1993-12-06",24,"Senior",3145,83,"OK",1145,76,"OK",79.5,"Accepted"]
["GOUDESEUNE","Marc","Belgium","Atleco","M","1996-07-07",21,"Senior",3238,85,"OK",1238,83,"OK",84,"Accepted"]
["GOZZI","Sergio","Italy","Atletico","M","1999-09-01",18,"Senior",3204,84,"OK",1204,80,"OK",82,"Accepted"]
["GUIGUI","Joëlle","Morocco","RAJA","F","1997-09-17",20,"Senior",3167,83,"OK",1386,92,"OK",87.5,"Accepted"]
["GUION","Jean-Luc","Belgium","Atleco","M","1994-04-23",23,"Senior",2886,76,"OK",1200,80,"OK",78,"Accepted"]
["GUZZARDI","Francesca","Italy","Atletico","F","1998-01-16",19,"Senior",2953,78,"OK",953,64,"OK",71,"Accepted"]
["HADJI","Lahoussine","Algeria","JSK","M","1994-05-07",23,"Senior",2862,75,"OK",862,57,"To be improved",66,"Not accepted"]
["HAMDAOUIYA","Hajja","Morocco","RAJA","F","1997-12-28",20,"Senior",3250,86,"OK",750,50,"To be improved",68,"Not accepted"]
["HASSOUN","Shada","Morocco","WYDAD","F","1998-01-03",19,"Senior",2396,63,"OK",885,59,"To be improved",61,"Not accepted"]
["HENRY de GENERET","Louis","France","Olympic","M","1995-03-27",22,"Senior",1980,52,"To be improved",1230,82,"OK",67,"New test needed"]
["HERVERT","Hubert","France","Olympic","M","1998-12-04",19,"Senior",2372,62,"OK",1248,83,"OK",72.5,"Accepted"]
["HONETTE","Marie","Belgium","Atleco","F","1995-06-18",22,"Senior",3505,92,"OK",711,47,"To be improved",69.5,"Not accepted"]
["HUSSIN","Louis","France","Olympic","M","1996-08-22",21,"Senior",2412,63,"OK",1430,95,"OK",79,"Accepted"]
["JANSSENS","Paul","Netherlands","Extrasportief","M","2001-02-08",16,"Junior",3398,89,"High Potential",1398,93,"High Potential",91,"Accepted"]
["JANSSENS","Ed","Netherlands","Extrasportief","M","1995-02-22",22,"Senior",2097,55,"To be improved",1200,80,"OK",67.5,"New test needed"]
["KINNAER","Thierry","Belgium","Atleco","M","2000-08-13",17,"Junior",2965,78,"More training needed",1400,93,"High Potential",85.5,"Accepted"]
["KOC","Ali","Morocco","WYDAD","M","1996-08-20",21,"Senior",2876,76,"OK",870,58,"To be improved",67,"Not accepted"]
["LAHBIB","Hadja","Morocco","WYDAD","F","1994-01-15",23,"Senior",2512,66,"OK",1167,78,"OK",72,"Accepted"]
["LESSIRE","Jeanne","Belgium","Atleco","F","2000-04-06",17,"Junior",1941,51,"To be improved",920,61,"More training needed",56,"New test needed"]
["LUQUE RODRIGEZ","Enrique","Spain","Asturial","M","1995-07-12",22,"Senior",3063,81,"OK",1063,71,"OK",76,"Accepted"]
["MAGNE","Charles","Switzerland","Sporteo","M","1994-04-09",{"$f":"DATEDIF(F70,TODAY(),\"y\")","v":23},{"$f":"IF(G70<18,\"Junior\",\"Senior\")","v":"Senior"},1972,{"$f":"ROUND(I70/38,0)","v":52},{"$f":"IF(AND(J70>=80,H70=\"Junior\"),\"High Potential\",IF(AND(J70>=60,H70=\"Senior\"),\"OK\",IF(J70>=60,\"More training needed\",\"To be improved\")))","v":"To be improved"},644,{"$f":"ROUND(L70/15,0)","v":43},{"$f":"IF(AND(M70>=80,H70=\"Junior\"),\"High Potential\",IF(AND(M70>=60,H70=\"Senior\"),\"OK\",IF(M70>=60,\"More training needed\",\"To be improved\")))","v":"To be improved"},{"$f":"(M70+J70)/2","v":47.5},{"$f":"IF(AND(J70>=60,M70>=60),\"Accepted\",IF(M70>J70,\"New test needed\",\"Not accepted\"))","v":"Not accepted"}]
["MAHAR","Hadja","Algeria","USMA","F","1999-04-11",18,"Senior",2749,72,"OK",1114,74,"OK",73,"Accepted"]
["MAHY","Jean-Marc","Switzerland","Sporteo","M","1995-07-19",22,"Senior",3121,82,"OK",1121,75,"OK",78.5,"Accepted"]
["MANFROY","Gérard","Belgium","Atleco","M","1997-06-18",20,"Senior",2674,70,"OK",493,33,"To be improved",51.5,"Not accepted"]
["MARIN PEREZ","Rafael","Spain","Asturial","M","1994-03-01",23,"Senior",3251,86,"OK",1251,83,"OK",84.5,"Accepted"]
["MAROT","Bernard","Switzerland","Sporteo","M","1994-12-23",23,"Senior",2536,67,"OK",536,36,"To be improved",51.5,"Not accepted"]
["MARTINEZ GREVESSE","Arturo","Italy","Atletico","M","1999-10-17",18,"Senior",2964,78,"OK",964,64,"OK",71,"Accepted"]
["MARTINEZ GREVESSE","Emilio","Italy","Atletico","M","2000-03-09",17,"Junior",2524,66,"More training needed",524,35,"To be improved",50.5,"Not accepted"]
["MARZOUKI","Mohamed","Algeria","JSK","M","2001-08-08",16,"Junior",2941,77,"More training needed",941,63,"More training needed",70,"Accepted"]
["MAUVE","Maggy","France","Olympic","F","1998-07-07",19,"Senior",2837,75,"OK",914,61,"OK",68,"Accepted"]
["MENVUSSA","Gérard","France","Olympic","M","1996-08-12",21,"Senior",2625,69,"OK",882,59,"To be improved",64,"Not accepted"]
["MIFTAH","Mohamed","Morocco","RAJA","M","2001-03-27",16,"Junior",3208,84,"High Potential",512,34,"To be improved",59,"Not accepted"]
["MISSAOUI","Hanane","Algeria","USMA","F","1996-12-13",21,"Senior",2165,57,"To be improved",670,45,"To be improved",51,"Not accepted"]
["MOERS","Serge","Belgium","Atleco","M","2001-01-11",16,"Junior",2853,75,"More training needed",853,57,"To be improved",66,"Not accepted"]
["MUDA","Albert","France","Olympic","M","1994-09-26",23,"Senior",3554,94,"OK",950,63,"OK",78.5,"Accepted"]
["NEUSY","Philippe","France","Olympic","M","2000-10-07",17,"Junior",2524,66,"More training needed",524,35,"To be improved",50.5,"Not accepted"]
["NGUYEN","Trong-Thao","Korea","Sporteo","M","2000-02-08",17,"Junior",3184,84,"High Potential",1184,79,"More training needed",81.5,"Accepted"]
["NICAISE","Véronique","Switzerland","Sporteo","F","1997-12-22",20,"Senior",3421,90,"OK",1421,95,"OK",92.5,"Accepted"]
["NONYME","Anne","Belgium","Atleco","F","1996-09-01",21,"Senior",2799,74,"OK",865,58,"To be improved",66,"Not accepted"]
["NOTE","Pia","Italy","Atletico","F","2001-09-02",16,"Junior",3333,88,"High Potential",1150,77,"More training needed",82.5,"Accepted"]
["ORTIZ VALLEJO","Rafaël","Spain","Asturial","M","1999-05-07",18,"Senior",3228,85,"OK",1228,82,"OK",83.5,"Accepted"]
["OULED CHAIB","Mohammed","Algeria","MCA","M","1997-05-16",20,"Senior",2423,64,"OK",423,28,"To be improved",46,"Not accepted"]
["OURIAGHLI","Hafida","Algeria","USMA","F","2001-04-08",16,"Junior",1917,50,"To be improved",580,39,"To be improved",44.5,"Not accepted"]
["PAUDE","Anne","Switzerland","Sporteo","F","1998-09-16",19,"Senior",3254,86,"OK",138,9,"To be improved",47.5,"Not accepted"]
["PECORARO","Roberto","Italy","Atletico","M","1993-10-05",24,"Senior",2443,64,"OK",443,30,"To be improved",47,"Not accepted"]
["PINCHART","Marc","Belgium","Atleco","M","1999-08-27",18,"Senior",2154,57,"To be improved",154,10,"To be improved",33.5,"Not accepted"]
["POLLAK","Bernard","France","Olympic","M","2000-10-02",17,"Junior",2142,56,"To be improved",142,9,"To be improved",32.5,"Not accepted"]
["PONNEN","Radhakrishnan","France","Sporteo","M","2001-08-21",16,"Junior",2929,77,"More training needed",929,62,"More training needed",69.5,"Accepted"]
["POON","Kwok Shing","Korea","Sporteo","M","1997-09-27",20,"Senior",3051,80,"OK",1051,70,"OK",75,"Accepted"]
["POTE","Jacques","France","MCA","M","1997-11-27",20,"Senior",3688,97,"OK",1075,72,"OK",84.5,"Accepted"]
["POURCENT","Vincent","France","Olympic","M","1995-12-25",22,"Senior",3710,98,"OK",1076,72,"OK",85,"Accepted"]
["PREVOST","Nathalie","Switzerland","Sporteo","F","2000-09-06",17,"Junior",2535,67,"More training needed",535,36,"To be improved",51.5,"Not accepted"]
["PROCHAIN","Edmond","France","Olympic","M","2001-09-16",{"$f":"DATEDIF(F102,TODAY(),\"y\")","v":16},{"$f":"IF(G102<18,\"Junior\",\"Senior\")","v":"Junior"},3075,{"$f":"ROUND(I102/38,0)","v":81},{"$f":"IF(AND(J102>=80,H102=\"Junior\"),\"High Potential\",IF(AND(J102>=60,H102=\"Senior\"),\"OK\",IF(J102>=60,\"More training needed\",\"To be improved\")))","v":"High Potential"},1075,{"$f":"ROUND(L102/15,0)","v":72},{"$f":"IF(AND(M102>=80,H102=\"Junior\"),\"High Potential\",IF(AND(M102>=60,H102=\"Senior\"),\"OK\",IF(M102>=60,\"More training needed\",\"To be improved\")))","v":"More training needed"},{"$f":"(M102+J102)/2","v":76.5},{"$f":"IF(AND(J102>=60,M102>=60),\"Accepted\",IF(M102>J102,\"New test needed\",\"Not accepted\"))","v":"Accepted"}]
["QUETTING","Marc","Italy","Atletico","M","1995-08-12",22,"Senior",3010,79,"OK",1150,77,"OK",78,"Accepted"]
["RAMDOUNI","Maria","Morocco","WYDAD","F","1996-09-12",21,"Senior",3216,85,"OK",676,45,"To be improved",65,"Not accepted"]
["RAYA VILCHEZ","Carla","Spain","Asturial","F","1997-07-02",20,"Senior",1941,51,"To be improved",670,45,"To be improved",48,"Not accepted"]
["RIAIRE","Claire","Switzerland","Sporteo","F","1996-02-28",21,"Senior",2035,54,"To be improved",230,15,"To be improved",34.5,"Not accepted"]
["RINDONE","Giuseppe","Italy","Atletico","M","1993-10-19",24,"Senior",3273,86,"OK",1273,85,"OK",85.5,"Accepted"]
["RISO","Adriano","Italy","Atletico","M","1998-12-05",19,"Senior",2536,67,"OK",536,36,"To be improved",51.5,"Not accepted"]
["RONT","Claire","France","Olympic","F","1999-09-23",18,"Senior",3255,86,"OK",677,45,"To be improved",65.5,"Not accepted"]
["SPLINGART","Pascal","Belgium","Atleco","M","1994-01-24",23,"Senior",2874,76,"OK",874,58,"To be improved",67,"Not accepted"]
["STIQUÉE","Sophie","Belgium","Atleco","F","2000-07-10",17,"Junior",3785,100,"High Potential",715,48,"To be improved",74,"Not accepted"]
["SWERTS","André","Belgium","Atleco","M","2001-07-07",16,"Junior",2154,57,"To be improved",940,63,"More training needed",60,"New test needed"]
["TATOUILLE","Lara","Belgium","Atleco","F","2000-02-13",17,"Junior",3775,99,"High Potential",830,55,"To be improved",77,"Not accepted"]
["TERIEUR","Alain","Belgium","Atleco","M","1998-12-08",19,"Senior",3557,94,"OK",441,29,"To be improved",61.5,"Not accepted"]
["TERIEUR","Alex","Switzerland","Sporteo","M","2000-03-07",17,"Junior",2609,69,"More training needed",933,62,"More training needed",65.5,"Accepted"]
["THARE","Maggy","France","Olympic","F","1996-09-09",21,"Senior",3701,97,"OK",918,61,"OK",79,"Accepted"]
["THELEF","Eric","Switzerland","Sporteo","M","1997-10-07",20,"Senior",3734,98,"OK",1157,77,"OK",87.5,"Accepted"]
["THON","Dick","Netherlands","Extrasportief","M","1997-07-03",20,"Senior",2053,54,"To be improved",1017,68,"OK",61,"New test needed"]
["TORISAEN","Michel","Switzerland","Sporteo","M","1994-04-12",23,"Senior",2431,64,"OK",431,29,"To be improved",46.5,"Not accepted"]
["TOUDROIT","Alphonse","Switzerland","Sporteo","M","1995-04-06",22,"Senior",2858,75,"OK",858,57,"To be improved",66,"Not accepted"]
["TOUMI","Abderrahim","Morocco","RAJA","M","1995-08-09",22,"Senior",2711,71,"OK",1216,81,"OK",76,"Accepted"]
["VAN BELLE","Philippe","Belgium","Atleco","M","1994-09-30",23,"Senior",1964,52,"To be improved",670,45,"To be improved",48.5,"Not accepted"]
["VAN DE PUTTE","Michel","Netherlands","Extrasportief","M","1999-07-03",18,"Senior",3232,85,"OK",1232,82,"OK",83.5,"Accepted"]
["VAN DE WOESTYNE","Gertjan","Netherlands","Extrasportief","M","1997-09-17",20,"Senior",2935,77,"OK",935,62,"OK",69.5,"Accepted"]
["VAN DEN ENDE","Eefje","Netherlands","Extrasportief","F","1996-09-12",21,"Senior",1929,51,"To be improved",950,63,"OK",57,"New test needed"]
["VAN RO","Michael","Belgium","Atleco","M","1997-12-28",20,"Senior",2130,56,"To be improved",130,9,"To be improved",32.5,"Not accepted"]
["VANDAMME","Pascal","Belgium","Atleco","M","1998-01-03",19,"Senior",3074,81,"OK",1074,72,"OK",76.5,"Accepted"]
["VANDEKERCKHOVE","Saskja","Netherlands","Extrasportief","F","1994-01-15",23,"Senior",3386,89,"OK",1386,92,"OK",90.5,"Accepted"]
["VANDEKERCKOVE","Philippe","Belgium","Atleco","M","1995-08-09",22,"Senior",2676,70,"OK",676,45,"To be improved",57.5,"Not accepted"]
["VANDROMME","Alain","Belgium","Atleco","M","1993-11-04",24,"Senior",2153,57,"To be improved",750,50,"To be improved",53.5,"Not accepted"]
["VANTUYKOM","Hilde","Netherlands","Extrasportief","f","2000-12-12",17,"Junior",2885,76,"More training needed",885,59,"To be improved",67.5,"Not accepted"]
["VELA HERNANDEZ","José","Spain","Asturial","M","2001-03-27",16,"Junior",3167,83,"High Potential",1167,78,"More training needed",80.5,"Accepted"]
["VERDOODT","Karel","Netherlands","Extrasportief","M","1995-02-21",22,"Senior",3216,85,"OK",1216,81,"OK",83,"Accepted"]
["VERHEUGEN","Jean","Belgium","Atleco","M","2001-04-04",{"$f":"DATEDIF(F134,TODAY(),\"y\")","v":16},{"$f":"IF(G134<18,\"Junior\",\"Senior\")","v":"Junior"},3250,{"$f":"ROUND(I134/38,0)","v":86},{"$f":"IF(AND(J134>=80,H134=\"Junior\"),\"High Potential\",IF(AND(J134>=60,H134=\"Senior\"),\"OK\",IF(J134>=60,\"More training needed\",\"To be improved\")))","v":"High Potential"},1250,{"$f":"ROUND(L134/15,0)","v":83},{"$f":"IF(AND(M134>=80,H134=\"Junior\"),\"High Potential\",IF(AND(M134>=60,H134=\"Senior\"),\"OK\",IF(M134>=60,\"More training needed\",\"To be improved\")))","v":"High Potential"},{"$f":"(M134+J134)/2","v":84.5},{"$f":"IF(AND(J134>=60,M134>=60),\"Accepted\",IF(M134>J134,\"New test needed\",\"Not accepted\"))","v":"Accepted"}]
["VERSTAPPEN","Didier","Belgium","Atleco","M","2000-05-21",17,"Junior",2396,63,"More training needed",396,26,"To be improved",44.5,"Not accepted"]
["VERSTRAETE","Piet","Netherlands","Extrasportief","M","1994-03-25",23,"Senior",2512,66,"OK",512,34,"To be improved",50,"Not accepted"]
["VERVISCH","Didier","Belgium","Atleco","M","2000-08-24",17,"Junior",2711,71,"More training needed",711,47,"To be improved",59,"Not accepted"]
["VOYANCE","Claire","France","Olympic","F","1996-11-04",21,"Senior",2504,66,"OK",882,59,"To be improved",62.5,"Not accepted"]
["VOYANTE","Claire","Belgium","Atleco","M","1999-02-14",18,"Senior",3318,87,"OK",715,48,"To be improved",67.5,"Not accepted"]
["WAUQUIER","Françoise","Belgium","Atleco","F","2000-05-11",17,"Junior",3208,84,"High Potential",1208,81,"High Potential",82.5,"Accepted"]
["WIJMMERSCH","Willy","Belgium","Atleco","M","1994-06-22",23,"Senior",2865,75,"OK",865,58,"To be improved",66.5,"Not accepted"]
["YAHIAOUI","Mohamed","Algeria","MCA","M","1997-09-07",20,"Senior",3075,81,"OK",130,9,"To be improved",45,"Not accepted"]
["ZIANE","Louis","France","Olympic","M","1993-11-03",24,"Senior",2885,76,"OK",1074,72,"OK",74,"Accepted"]

{"sheet":"WksUtlisationDeBdSomme","index":1,"n_rows":114,"n_cols":11,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,0,7,10]]}
["Somme en fonction des critères ci-dessous"]
["BdSomme",{"$f":"DSUM(TblDonneesPourUtiliserBdSomme[#All],TblDonneesPourUtiliserBdSomme[[#Headers],[Net Sales 2011]],A5:K6)","v":23461.899999999998},null,null,null,null,null,"Vérification avec Sous.Total :",{"$f":"SUBTOTAL(9,TblDonneesPourUtiliserBdSomme[Net Sales 2011])","v":182662.7}]
[]
[]
[{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Date]]","v":"Date"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Article]]","v":"Article"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Customer]]","v":"Customer"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Sales Rep]]","v":"Sales Rep"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Net Sales 2011]]","v":"Net Sales 2011"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Usage]]","v":"Usage"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Office supplies]]","v":"Office supplies"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Presentation]]","v":"Presentation"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Replacement]]","v":"Replacement"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Service]]","v":"Service"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Net Sales 2011]]","v":"Net Sales 2011"}]
[null,null,null,"<>Tom",">1000",null,null,"x",null,null,"<10000"]
[]
["Pour les listes déroulantes ci-dessus"]
[{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Date]]","v":"Date"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Article]]","v":"Article"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Customer]]","v":"Customer"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Sales Rep]]","v":"Sales Rep"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Net Sales 2011]]","v":"Net Sales 2011"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Usage]]","v":"Usage"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Office supplies]]","v":"Office supplies"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Presentation]]","v":"Presentation"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Replacement]]","v":"Replacement"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Service]]","v":"Service"},{"$f":"TblDonneesPourUtiliserBdSomme[[#Headers],[Net Sales 2011]]","v":"Net Sales 2011"}]
[]
[null,"Flowers","Electronics","Alex",">1000",null,null,null,null,null,"<10000"]
[null,"Flow","Elektronics","Amy",">=1000"]
[null,"Pa","Ele?tronics","Philip"]
[null,"Pa*","Henschel","Tom"]
[null,"*pa*","Life Art","<>Tom"]
[null,"Boxes","Meyers"]
[null,"Cables","Office Shop"]
[null,"Cables en plugs","Post Services"]
[null,"Calendars","Print Service"]
[null,"Cartridge","Quick Menu"]
[null,"CD's","Saubermann"]
[null,"Cleaner for copier","Team Select"]
[null,"Coffee can","Time"]
[null,"Coffee, milk","TNT"]
[null,"Decoration material"]
[null,"Excel update"]
[null,"Filters"]
[null,"Flowers"]
[null,"Flowers + plants"]
[null,"Folio"]
[null,"Folio and labels"]
[null,"Lists"]
[null,"Markers"]
[null,"Office cleaner"]
[null,"Ordners"]
[null,"Paper for copier"]
[null,"Paper recycled"]
[null,"Papers"]
[null,"Posters"]
[null,"Quick Menus"]
[null,"Stamps and enveloppes"]
[null,"Switch # ports"]
[null,"Taxi"]
[null,"Toilet paper"]
[null,"Toner"]
[null,"Transporter"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Date","Article","Customer","Sales Rep","Net Sales 2011","Usage","Office supplies","Presentation","Replacement","Service"]
["2011-05-02","Flowers","Henschel","Amy",1000,null,null,"x"]
["2011-05-03","Paper for copier","Office Shop","Philip",1391.5,null,"x"]
["2011-05-03","Quick Menus","Quick Menu","Philip",19360]
["2011-05-04","Coffee, milk","Team Select","Amy",2783,null,null,"x"]
["2011-05-05","Cables","Electronics","Tom",290.39999999999998,null,null,null,"x"]
["2011-05-05","Toner","Electronics","Alex",2238.5,"x"]
["2011-05-06","Calendars","Time","Amy",1161.5999999999999,null,"x"]
["2011-05-06","Calendars","Time","Amy",1270.5,null,"x"]
["2011-05-06","Folio and labels","Office Shop","Alex",5239.3,null,"x"]
["2011-05-06","Calendars","Time","Alex",12705,null,"x"]
["2011-05-09","Cleaner for copier","Electronics","Philip",1936,null,null,null,null,"x"]
["2011-05-09","Flowers + plants","Henschel","Amy",3182.3,null,null,"x"]
["2011-05-11","Coffee can","Team Select","Alex",774.4,null,null,"x"]
["2011-05-12","Taxi","TNT","Amy",1270.5,null,null,null,null,"x"]
["2011-05-13","CD's","Electronics","Tom",1197.9000000000001,null,null,null,"x"]
["2011-05-16","Flowers + plants","Henschel","Amy",1076.9000000000001,null,null,"x"]
["2011-05-17","Ordners","Office Shop","Philip",544.5,null,"x"]
["2011-05-17","Lists","Life Art","Amy",16335,null,null,"x"]
["2011-05-18","Markers","Office Shop","Philip",3097.6,null,"x"]
["2011-05-18","Switch # ports","Electronics","Philip",4428.6000000000004,null,null,null,"x"]
["2011-05-19","Flowers","Henschel","Amy",677.6,null,null,"x"]
["2011-05-19","Toilet paper","Meyers","Philip",1754.5,"x"]
["2011-05-20","Boxes","Electronics","Tom",1076.9000000000001,null,null,null,"x"]
["2011-05-23","Ordners","Office Shop","Alex",689.7,null,"x"]
["2011-05-23","Cables en plugs","Electronics","Tom",3315.4,null,null,null,"x"]
["2011-05-24","Cartridge","Office Shop","Philip",701.8,null,"x"]
["2011-05-24","Filters","Electronics","Tom",6921.2,null,null,null,"x"]
["2011-05-24","Lists","Life Art","Alex",10000,null,null,"x"]
["2011-05-26","CD's","Electronics","Tom",1197.9000000000001,null,null,null,"x"]
["2011-05-26","Office cleaner","Saubermann","Philip",7865,null,null,null,null,"x"]
["2011-05-27","Decoration material","Henschel","Alex",6824.4,null,null,"x"]
["2011-05-27","Posters","Print Service","Alex",10648,null,null,"x"]
["2011-05-27","Stamps and enveloppes","Post Services","Philip",30250,"x"]
["2011-05-30","Flowers","Henschel","Amy",798.6,null,null,"x"]
["2011-05-30","Toner","Electronics","Alex",2238.5,"x"]
["2011-06-04","Toner","Electronics","Amy",1512.5,"x"]
["2011-06-10","Transporter","TNT","Alex",532.4,null,null,null,null,"x"]
["2011-08-02","Excel update","Electronics","Tom",2420,null,null,null,"x"]
["2011-08-13","Papers à kiki","Office Shop","Philip",1633.5,"x"]
["2011-10-27","Decoration material","Henschel","Amy",4235,null,null,"x"]
["2011-10-31","Paper recycled","Print Service","Philip",726,null,null,null,null,"x"]
["2011-06-30","Folio","Office Shop","Alex",5360.3,null,null,"x"]

{"sheet":"WksTirageAuSort","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Identifiant","Nom",null,"Candidat élu","Colonne1"]
[{"$f":"ROW(A2)-1","v":1},"Daniel",null,{"$f":"OFFSET(ZnTirageAuSort,RANDBETWEEN(1,COUNTA(ZnColonneDeParticipants)-1),0,1,1)","v":"Domithilde"}]
[2,"Erika",null,"'=DECALER(ZnTirageAuSort;ALEA.ENTRE.BORNES(1;NBVAL(ZnColonneDeParticipants)-1);0;1;1)"]
[3,"Amaryllis"]
[4,"Denis"]
[5,"Damien"]
[6,"Domithilde"]
[7,"Philippe"]
[8,"Guy"]
[9,"Jean-Louis"]
[10,"Léandre"]
[11,"Harold"]
[12,"Paul"]

{"sheet":"WksErreurDeConception","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Une seule colonne pour une même caractéristique"]
[]
["Un exemple classique est la création de nouvelles colonnes pour"]
["chaque nouveau mois. Ceci est un problème majeur de conception"]
[]
["Id","Nom","Janvier","Février"]
[1,"DEVEAUX",67000,45200]
[2,"MOURMANT",125000,200000]
[]
["Id","Nom","Mois","Montant"]
[1,"DEVEAUX","Janvier",67000]
[2,"MOURMANT","Janvier",125000]
[null,"DEVEAUX","Février",45200]
[null,"MOURMANT","Février",200000]

{"sheet":"WksRedondanceDeDonnees","index":4,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,3,4],[5,0,5,4],[8,0,8,4],[16,0,16,3]]}
[]
["Structurer vos tables - Redondance des données"]
[" "]
["La normalisation, dénormalisation d'un ensemble de tables permet de réduire la redondance des données en créant plusieurs plus petites tables au lieu d'une seule très grosse. Par exemple, si dans une table de factures, on répète les informations d'un même client (société, nom, prénom) pour chacune de ses factures, on prend le risque d'avoir des informations fausses au bout d'un moment. \nDe fait, on va choisir d'avoir une table TblFactures, une table TblClients, et une clef unique IdClient que l'on réutilisera dans la table TblFactures pour identifier le client.  Ainsi, l'information n'est stockée qu'à un seul endroit, ce qui réduit les risques d'erreur et la taille du fichier. "]
["Cependant, ceci complexifiera la maintenance de l'application. "]
["Il y a donc une analyse à faire sur la structure de la table et sur la manière d'agencer ces informations : "]
["·        dans une seule table"]
["·        dans des tables séparées."]
["Dans le second cas, et en fonction de la taille et de la complexité de l'application, vous aurez besoin :"]
["·        d’Excel et de connaissances plus avancées concernant :"]
["o   INDEX/EQUIV "]
["o   Tableau croisé dynamique "]
["o   PowerPivot"]
["o   Récupérer et transformer des données"]
["o   Power Query"]
["o   Power BI (Business Intelligence)"]
["·        soit d'envisager l'utilisation d'un logiciel de gestion de bases de données (type Access ou Oracle)."]

{"sheet":"WksFontionsTexte","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Quelques Fonctions Texte"]
["Remarque : Le texte de la cellule \"A3\" commence et se termine par 2 espaces"]
["  jEAn-lOUiS  ",{"$f":"UPPER(A3)","v":"  JEAN-LOUIS  "},"=MAJUSCULE(A3) - Attention à la remarque (*)"]
[null,{"$f":"LOWER(A3)","v":"  jean-louis  "},"=MINUSCULE(A3) - Attention à la remarque (*)"]
[null,{"$f":"PROPER(A3)","v":"  Jean-Louis  "},"=NOMPROPRE(A3) - Attention à la remarque (*)"]
[]
[null,{"$f":"LEFT(A3,4)","v":"  jE"},"=GAUCHE(A3;4) - Attention à la remarque (*)"]
[null,{"$f":"RIGHT(A3,5)","v":"UiS  "},"=DROITE(A3;5) - Attention à la remarque (*)"]
[null,{"$f":"MID(A3,5,4)","v":"An-l"},"=STXT(A3;5;4) - Attention à la remarque (*)"]
[]
[null,{"$f":"LEN(A3)","v":14},"=NBCAR(A3)"]
[]
[null,{"$f":"TRIM(A3)","v":"jEAn-lOUiS"},"=SUPPRESPACE(A3)"]
[null,{"$f":"LEN(B13)","v":10},"=NBCAR(B13)"]
[null,{"$f":"TRIM(PROPER(A3))","v":"Jean-Louis"},"=SUPPRESPACE(NOMPROPRE(A3))"]
[null,{"$f":"FIND(\"-\",B15)","v":5},"=TROUVE(\"-\";B15)"]
[null,{"$f":"LEFT(B15,LEFT(FIND(\"-\",B15,1)-1))","v":"Jean"},"=GAUCHE(B15;GAUCHE(TROUVE(\"-\";B15;1)-1))"]
[]
["(*)Remarque : Les espaces avt ou/et après le contenu sont toujours présents"]

{"sheet":"WksPasRechercheV","index":6,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8]]}
[]
["Ne pas utiliser la fonction RECHERCHEV"]
["Bien que très souvent utilisé, cette fonction présente certains désavantages qui en font une fonction particulièrement dangereuse. "]
["Si vous ne connaissez pas cette fonction, vous pouvez tout de suite passer à la section suivante, cela ne sert à rien de l'apprendre, car la combinaison de fonction INDEX/EQUIV est beaucoup plus puissante et moins dangereuse ! ;-)"]
["Je plaisante à moitié, car vous risquez de récupérer des fichiers ayant cette formule, donc elle reste utile à connaitre !"]
["La fonction RECHERCHEV permet de renvoyer la valeur d'une cellule située dans la Xème colonne (ou lignes pour RECHERCHEH) d'un tableau de recherche. "]
["Par exemple, vous pouvez rechercher un numéro de client dans une table et renvoyer la valeur situé dans la troisième colonne de ce tableau. Les dangers de cette fonction sont les suivants : "]
["·        Cette fonction va présenter un bug majeur si on ajoute des colonnes à l'intérieur de la plage de recherche."]
["o   En effet, comme on utilise un décalage de colonnes, ce décalage va rester le même et donc entrainer de gros problèmes. "]
["o   En plus, vous n'aurez pas forcément une valeur d'erreur, mais une valeur fausse comme résultat de votre recherche."]
["o   Résultat que vous croirez puisque c’est la machine qui vous le dit. "]
["·        La fonction RECHERCHEV ne permet pas de travailler avec des tableaux à double entrée, donc on lui préférera la\n        combinaison INDEX/EQUIV qui permet de le faire"]
["·        Vous ne pouvez pas non plus faire une recherche renvoyant les valeurs situées à gauche de la colonne de recherche."]
["·        Finalement, vous ne pouvez pas bouger la colonne de recherche sans risquer de rendre la formule inexacte. "]

{"sheet":"WksCheckList","index":7,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Liste de contrôle des règles d'or à suivre pour construire une base de données correctes : "]
["Cette liste vous permet de vérifier rapidement que les règles d'or ont bien été respectées : "]
[null,"1 Une feuille = une table de données et rien d'autre "]
[null,"2 Première ligne : uniquement les titres de colonnes "]
[null,"3 Pas de cellules vides dans les titres de colonnes. "]
[null,"4 Pas de cellules fusionnées "]
[null,"5 Pas de doublons dans les titres de colonnes "]
[null,"6 Une clef primaire dans la première colonne "]
[null,null,"6.1 Ajout manuel"]
[null,null,"6.2 Ajout automatique de la clef en VBA "]
[null,null,"6.3 Pas de cellule vide pour la clef primaire "]
[null,null,"6.4 Mise en forme conditionnelle pour les cellules vides "]
[null,null,"6.5 La Syntaxe Tableaux"]
[null,"7 Pas de lignes et de colonnes vides "]
[null,"8 Pas de totaux, sous-totaux et calculs intermédiaires "]
[null,"9 Utiliser les filtres automatiques et figer les volets "]
[null,null,"9.1 Filtres automatiques "]
[null,null,"9.2 Figer les volets "]
[null,"10 Structurer vos tables "]
[null,null,"10.1 Une seule colonne pour une même dimension "]
[null,null,"10.2 Redondance des données "]
[null,"11 Données numériques et calculs à droite "]
[null,null,"11.1 Position des données numériques - de préference dans les colonnes de  droite de vos tableaux"]
[null,null,"11.2 Dépendances de gauche vers droite "]
[null,null,"11.3 N'utiliser qu'une seule formule par colonne "]
[null,"12 Utiliser les tableaux d'Excel "]
[null,null,"12.1 Les 7 premiers avantages de la mise sous forme de Tableau"]
[null,"13 Utiliser l'outil de validation des données "]
[null,null,"13.1 Liste déroulante dynamique grâce aux Tableaux"]
[null,"14 Retravailler des bases de données mal formatées "]
[null,null,"14.1 Connaître et combiner les fonctions de texte "]
[null,"15 Dynamiser vos noms "]
[null,"16 SOMME.SI"]
[null,null,"16.1 Une variante utile : BDSOMME"]
[null,"17 Ne pas utiliser la fonction RECHERCHEV"]
[null,"18 INDEX et EQUIV "]
[null,"19 Création de listes en cascades "]

{"sheet":"WksUniquementTitre","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Id","Prénoms","Noms","Ville"]
[{"$f":"ROW()-1","v":1},"Albert","EINSTEIN","Bois-de-Villers"]
[{"$f":"ROW()-1","v":2},"Daniel","DEVEAUX","Bois-de-Villers"]
[{"$f":"ROW()-1","v":3},"Gaëan","MOURMANT","Vancouver"]
[{"$f":"ROW()-1","v":4},"Erika","DEVEAUX","Bois-de-Villers"]
[]
["1ère ligne : rien que des titres, quoique…"]
[]
["Rien ne vous empêche d'installer des boutons, des formes"]
["faisant appel à des macros pour \"humaniser votre document\""]

{"sheet":"WksAdministration","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Postes",null,"Pays",null,null,null,"mai"]
["CEO",null,"Algeria",null,null,null,"juin"]
["Commis",null,"Belgium",null,null,null,"juillet"]
["Directeur",null,"France",null,null,null,"août"]
["Secrétaire",null,"Italy",null,null,null,"septembre"]
["Vendeur",null,"Korea",null,null,null,"octobre"]
[null,null,"Morocco",null,null,null,"novembre"]
[null,null,"Netherlands",null,null,null,"décembre"]
[null,null,"Spain",null,null,null,"janvier"]
[null,null,"Switzerland"]

{"sheet":"WksLangageTableaux","index":10,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Lorsque vous saisissez le nom du tableau dans une formule, suivi d'un crochet ouvert =Tableau1[, Excel propose les arguments \n(spécificateurs) disponibles, dans la liste de saisie semi automatique: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["En plus des noms de colonnes, la liste contient des spécificateurs généraux:"]
["[#Tout] fait référence au tableau complet (en-têtes et ligne de totaux compris)."]
["[#Données] fait référence aux données, sans les en-têtes ni la ligne de totaux."]
["[#En-tête] fait référence aux données d'en-tête."]
["[#Totaux] fait référence à la ligne de totaux."]
["[#Cette ligne] fait référence à la même ligne que celle qui contient la formule (est souvent utilisée dans les colonnes calculées). "]
[]
["Pour faire référence à l'entête et aux données de la colonne \"NbHeures\":"]
["Tableau1[[#En-têtes];[#Données];[NbHeures]]"]
["Additionne les valeurs de la colonne \"Montant\":"]
["=SOMME(Tableau1[[#Données];[Montant]])"]
["Affiche la valeur maxi contenue dans la colonne \"NbHeures\":"]
["=MAX(Tableau1[NbHeures])"]
["Divise le résultat de la ligne de totaux \"Montant\" par le résultat de la ligne de totaux \"NbHeures\":"]
["=Tableau1[[#Totaux];[Montant]]/Tableau1[[#Totaux];[NbHeures]]"]

{"sheet":"WksAjoutClePrimaire","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,9]]}
["No","Nom","Prénom","Sexe","Date de naissance","Poste","Ville","Embauche","Age","Salaire"]
[1,"CLOGNE","Aude","F","1966-03-19","Secrétaire","Wépion","1989-04-01",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":51},27567]
[2,"THARE","Maggy","F","1964-03-22","Vendeur","Antwerpen","1986-04-19",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":53},36345]
[3,"COBLAN","Harry","M","1962-07-22","Commis","Antwerpen","1986-05-17",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":55},31678]
[5,"COVERT","Harry","M","1961-01-17","Vendeur","Dendermonde","1984-11-12",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":56},27567]
[6,"DETOUSSE","Aimé","M","1960-12-22","Commis","Bruxelles","1981-01-30",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":57},31222]
[4,"DESFRAISES","Ivan","M","1957-05-21","Secrétaire","Wépion","1984-02-24",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":60},28789]
[7,"PLUDBIERE","Roger","M","1987-12-28","Directeur","Jupille","2017-12-28",{"$f":"DATEDIF(TblMesVendeurs[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":30},27554]
[]
[]
[]
[]
["Sub McrInstallationClePrimaire()"]
["    Dim MonCompteur As Integer"]
["    Application.Goto Reference:=\"ZnAjoutClePrimaire\""]
["    Selection.CurrentRegion.Select"]
["    MonCompteur = Selection.Rows.Count"]
["    ActiveCell.Offset(MonCompteur, 0) = Application.WorksheetFunction. _\n    Max(ActiveSheet.Range(\"A2:A\" & MonCompteur - 1)) + 1"]
["End Sub"]

{"sheet":"WksMiseEnFormePourVide","index":12,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["No","Nom","Prénom","Sexe","Date de naissance","Poste","Ville","Embauche","Age","Salaire"]
[null,"CLOGNE","Aude","F","1966-03-19","Secrétaire","Wépion","1989-04-01",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":51},27567]
[2,"THARE","Maggy","F","1964-03-22","Vendeur","Antwerpen","1986-04-19",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":53},36345]
[3,"COBLAN","Harry",null,"1962-07-22","Commis","Antwerpen","1986-05-17",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":55},31678]
[5,null,"Harry","M",null,"Vendeur","Dendermonde","1984-11-12",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":117},27567]
[6,"DETOUSSE","Aimé","M","1960-12-22","Commis",null,"1981-01-30",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":57},31222]
[4,"DESFRAISES","Ivan","M","1957-05-21","Secrétaire","Wépion","1984-02-24",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":60}]
[7,"PLUDBIERE","Roger","M","1987-12-28","Directeur","Jupille","2017-12-28",{"$f":"DATEDIF(TblMesVendeurs11[[#This Row],[Date de naissance]],TODAY(),\"y\")","v":30},27554]
[]
[]
["La formule appliquée pour la mise en forme conditionnelle"]
["=ESTVIDE(A2)"]
["Sur la plage de cellules A2:J8"]

{"sheet":"WksEquivIndex","index":13,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["No","Nom","Prénom","Sexe","Date de naissance","Poste","Ville","Embauche","Age","Salaire"]
[1,"DAIGNEAULT","Andrée","F","1966-03-19","Secrétaire","Chicoutimi","1989-04-01",{"$f":"(TODAY()-E2)/365","v":51.813698630136983},27567]
[2,"DAIGLE","Jacqueline","F","1964-03-22","Vendeur","Sherbrooke","1986-04-19",53.805479452054797,36345]
[7,"CADIEUX","Denis","M","1962-07-22","Commis","Sherbrooke","1986-05-17",55.473972602739728,31678]
[5,"CHARTRAND","Pierre","M","1961-01-17","Vendeur","Laval","1984-11-12",56.983561643835614,27567]
[6,"DAOUST","Raymond","M","1960-12-22","Commis","Montréal","1981-01-30",57.054794520547944,31222]
[4,"ALARIE","Yvon","M","1957-05-21","Secrétaire","Laval","1984-02-24",60.646575342465752,28789]
[3,"DION","Karine","F","1949-01-28","Directeur","Sherbrooke","1986-01-12",68.961643835616442,50678]
[8,"DEVEAUX","Daniel","M","1952-11-24","CEO","Bois-de-Villers","1996-01-01",{"$f":"(TODAY()-E9)/365","v":65.136986301369859},60000]
[]
[]
["No","Nom"]
[7,{"$f":"MATCH(A13,A2:A9,0)","v":3},"=EQUIV(A13;A2:A9;0)"]
[null,{"$f":"MATCH(B12,A1:J1,0)","v":2},"=EQUIV(B12;A1:J1;0)"]
[null,{"$f":"INDEX(A2:J9,B13,B14)","v":"CADIEUX"},"=INDEX(A2:J9;B13;B14)"]
[null,{"$f":"INDEX(A2:J9,MATCH(A13,A2:A9,0),MATCH(B12,A1:J1,0))","v":"CADIEUX"},"=INDEX(A2:J9;EQUIV(A13;A2:A9;0);EQUIV(B12;A1:J1;0))"]
[null,{"$f":"MATCH(ZnLeNumeroQuJeCherche,TblMonPersonnel[No],0)","v":3},"=EQUIV(ZnLeNumeroQuJeCherche;TblMonPersonnel[No];0)"]
[null,{"$f":"MATCH(ZnLeChampQueJeCherche,TblMonPersonnel[#Headers],0)","v":2},"=EQUIV(ZnLeChampQueJeCherche;TblMonPersonnel[#En-têtes];0)"]
[null,{"$f":"INDEX(TblMonPersonnel[],B17,B18)","v":"CADIEUX"},"=INDEX(TblMonPersonnel;B17;B18)"]
[null,{"$f":"INDEX(TblMonPersonnel[],MATCH(ZnLeNumeroQuJeCherche,TblMonPersonnel[No],0),MATCH(ZnLeChampQueJeCherche,TblMonPersonnel[#Headers],0))","v":"CADIEUX"},"=INDEX(TblMonPersonnel;EQUIV(ZnLeNumeroQuJeCherche;TblMonPersonnel[No];0);EQUIV(ZnLeChampQueJeCherche;TblMonPersonnel[#En-têtes];0))"]

{"sheet":"WksListesConditionnelles","index":14,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Type d'aliment","Aliment",null,"Fruits",null,"Légumes",null,"Type d'aliment"]
["Fruits","Fraise",null,"Banane",null,"Petit pois",null,"Fruits"]
["Légumes","Salade",null,"Poire",null,"Carotte",null,"Légumes"]
[null,null,null,"Pomme",null,"Artichaut"]
[null,null,null,"Fraise",null,"Asperge"]
[null,null,null,"Cerise",null,"Salade"]
[null,null,null,"Groseille",null,"Poireaux"]
[null,null,null,"Mures",null,"Chicon"]
[null,null,null,"Abricot",null,"Lentille"]
[]
[]
["Précautions"]
["Les zones nommées \"Fruits\" et \"Légumes\" doivent correspondre aux contenu de A2 et A3"]
["La formule de validation des données en B2 et B3"]
["=INDIRECT(A2)"]