{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Feuille de jeu","Carte de la Suisse","Liste des no de ville"],"not_rendered":{"images":32,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Feuille de jeu","index":0,"n_rows":117,"n_cols":21,"rows_kept":117,"merged":[[0,1,0,8],[1,4,1,7],[2,1,2,3],[3,1,3,3],[4,9,5,9],[5,1,5,3],[7,0,8,0],[8,8,26,8],[48,0,48,3]]}
[null,"Villes de Suisse",{"$nulls":7}," ","nb villes",66,"x","canton",null,null,"Ville","ovale"]
[{"$nulls":4},{"$f":"\"Situez sur la carte 60 villes et 6 lacs !        \"","v":"Situez sur la carte 60 villes et 6 lacs !        "},{"$nulls":5},1,"Genève",null,8,null,1,"Aarau",56,36]
[null,{"$f":"IF(O18=0,\"Cliquez sur nouvelle partie\",IF(G4=1,\"Partie terminée !\",\"Cliquez sur \"))","v":"Cliquez sur "},{"$nulls":8},2,"Nyon",null,23,"Indice :",2,"Altdorf",75,49]
[null,"Question",null,null,66,{"$f":"VLOOKUP(E4,K2:N68,4)","v":27},0,{"$f":"IF(O4=TRUE,F4,27)","v":27},null,null,3,"Morges",null,23,true,3,"Appenzell",85,58]
[{"$nulls":9},{"$f":"IF(O11=0,\"Choisir une ville de la liste ci-dessous\",\"Voir le no  \"&O12)","v":"Choisir une ville de la liste ci-dessous"},4,"Lausanne",null,23,"Voir ville :",4,"Baden",57,37]
[{"$f":"IF(O24=1,\"X\",\"\")","v":""},{"$nulls":9},5,"Vevey",null,23,55,5,"Basel",53,33]
[{"$f":"IF(A6=\"X\",\"déjà répondu !\",\"\")","v":""},{"$nulls":9},6,"Monthey",null,24,null,6,"Bellinzona",31,11]
[{"$f":"IF(O24=1,\"→\",\"\")","v":""},{"$nulls":9},7,"Martigny",null,24,"Concan.",7,"Bern",42,22]
[{"$nulls":10},8,"Sion",null,24,{"$f":"VLOOKUP(O6,P2:R61,3)","v":67},8,"Bienne",47,27]
[{"$nulls":10},9,"Brig",null,24,{"$f":"\"Oval \"&O9","v":"Oval 67"},9,"Brig",29,9]
[null,"Score :",{"$nulls":8},10,"Locarno",null,20,0,10,"Buchs",50,30]
[null," 0 / 0",{"$nulls":8},11,"Bellinzona",null,20,{"$f":"VLOOKUP(O6,P2:S61,4)","v":47},11,"Bulle",37,17]
[null,{"$f":"IF(G4=1,\"    Bravo !\",\"\")","v":""},{"$nulls":8},12,"Lugano",null,20,null,12,"Chiasso",33,13]
[null,{"$f":"IF(G4=1,\" Partie terminée\",\"\")","v":""},{"$nulls":8},13,"Chiasso",null,20,"nb tirs",13,"Chur (Coire)",45,25]
[null,{"$f":"IF(G4=1,\"Affichez vos résultats avec\",\"\")","v":""},{"$nulls":8},14,"Le Sentier",null,23,0,14,"Delémont",52,32]
[null,{"$f":"IF(G4=1,\"le bouton ci-dessous !\",\"\")","v":""},{"$nulls":8},15,"Yverdon",null,23,null,15,"Dietikon",59,39]
[{"$nulls":10},16,"Payerne",null,23,"Nouv. par.",16,"Frauenfeld",1,46]
[{"$nulls":10},17,"Bulle",null,7,1,17,"Fribourg",41,21]
[{"$nulls":10},18,"La Chaux-de-Fonds",null,13,null,18,"Genève",4,1]
[{"$nulls":10},19,"Neuchâtel",null,13,"1 réponse",19,"Glaris",82,55]
[{"$nulls":10},20,"Murten (Morat)",null,7,false,20,"Gstaad",79,53,null,"Ville"]
[{"$nulls":10},21,"Fribourg",null,7,null,21,"Interlaken",76,50,null,{"$f":"E4","v":66}]
[{"$nulls":10},22,"Bern",null,6,"flèche",22,"Kreuzlinger",78,52,null,"Canton"]
[{"$nulls":10},23,"Thun",null,6,0,23,"La Chaux-de-Fonds",38,18,null,{"$f":"VLOOKUP(U22,K2:N68,4)","v":27}]
[{"$nulls":10},24,"Luzern",null,12,null,24,"Langenthal",80,54]
[{"$nulls":10},25,"Chur (Coire)",null,10,null,25,"Lausanne",22,4]
[{"$nulls":10},26,"Tramelan",null,6,null,26,"Le Sentier",34,14]
[null,null,"min.","max.",{"$nulls":4},{"$f":"IF(U24=27,\"\",IF(O4=TRUE,VLOOKUP(U24,'Liste des no de ville'!B10:C36,2),\"\"))","v":""},null,27,"Bienne",null,6,null,27,"Liestal",54,34,null,"Nb tirages"]
[null,null,1,66,{"$f":"IF(O15=0,\"← ← Ici, choix d'une série limitée. (max. 66)\",\"\")","v":"← ← Ici, choix d'une série limitée. (max. 66)"},{"$nulls":5},28,"Solothurn",null,18,null,28,"Locarno",30,10,null,{"$f":"D29-C29+1","v":66}]
[1,null,null,{"$f":"IF(C29>D29,\"Pas possible ! Maximum plus petit que minimum\",\"\")","v":""},{"$nulls":6},29,"Zug",null,25,null,29,"Lugano",32,12]
[{"$nulls":8},"        Cantique suisse",null,30,"Buchs",null,19,null,30,"Luzern",44,24]
[{"$nulls":10},31,"Porrentruy",null,11,null,31,"Martigny",27,7]
[{"$nulls":10},32,"Delémont",null,11,null,32,"Monthey",26,6]
[{"$nulls":10},33,"Basel",null,5,null,33,"Morges",20,3]
[{"$nulls":10},34,"Liestal",null,4,null,34,"Murten (Morat)",40,20]
[{"$nulls":10},35,"Olten",null,18,null,35,"Neuchâtel",39,19]
[{"$nulls":10},36,"Aarau",null,1,null,36,"Nyon",21,2]
[null,"Version 1.8",{"$nulls":8},37,"Baden",null,1,null,37,"Oerlikon",61,41]
[null,"© Yvan Péguiron – infodidac.ch – mars 2024",{"$nulls":8},38,"Wohlen",null,1,null,38,"Olten",55,35]
[{"$nulls":10},39,"Dietikon",null,26,null,39,"Payerne",36,16]
[null,"PS : Les 60 villes du quiz ont été choisies pour leur intérêt politique ou géographique.",{"$nulls":8},40,"Schaffhausen",null,16,null,40,"Porrentruy",51,31]
[{"$nulls":10},41,"Oerlikon",null,26,null,41,"Rapperswil",65,45]
[{"$nulls":10},42,"Zürich",null,26,null,42,"Sarnen",84,57]
[{"$nulls":10},43,"Uster",null,26,null,43,"Schaffhausen",60,40]
[{"$nulls":10},44,"Winterthur",null,26,null,44,"Schwyz",83,56]
[{"$nulls":10},45,"Rapperswil",null,19,null,45,"Sempach",87,59]
[{"$nulls":10},46,"Frauenfeld",null,21,null,46,"Sion",28,8]
[{"$nulls":10},47,"Wil",null,19,null,47,"Solothurn",48,28]
["Liste des questions et réponses",{"$nulls":3},"  Retour ",{"$nulls":5},48,"St-Gallen",null,19,null,48,"Stans",77,51]
[{"$nulls":10},49,"Altdorf",null,22,null,49,"St-Gallen",68,48,null,"Rép. v = 1"]
[1,null,{"$f":"IF(B51=\"\",\"\",IF(U51=1,\"v\",\"Pas trouvé !\"))","v":""},{"$nulls":7},50,"Interlaken",null,6,null,50,"St-Moritz",86,60]
[2,null,{"$f":"IF(B52=\"\",\"\",IF(U52=1,\"v\",\"Pas trouvé !\"))","v":""},{"$nulls":7},51,"Stans",null,14,null,51,"Thun",43,23]
[3,null,"",{"$nulls":7},52,"Kreuzlinger",null,21,null,52,"Tramelan",46,26]
[4,null,"",{"$nulls":7},53,"Gstaad",null,6,null,53,"Uster",63,43]
[5,null,"",{"$nulls":7},54,"Langenthal",null,6,null,54,"Vevey",25,5]
[6,null,"",{"$nulls":7},55,"Glaris",null,9,null,55,"Wil",67,47]
[7,null,"",{"$nulls":7},56,"Schwyz",null,17,null,56,"Winterthur",64,44]
[8,null,"",{"$nulls":7},57,"Sarnen",null,15,null,57,"Wohlen",58,38]
[9,null,"",{"$nulls":7},58,"Appenzell",null,3,null,58,"Yverdon",35,15]
[10,null,"",{"$nulls":7},59,"Sempach",null,12,null,59,"Zug",49,29]
[11,null,"",{"$nulls":7},60,"St. Moritz",null,10,null,60,"Zürich",62,42]
[12,null,"",{"$nulls":7},61,"Lac des 4 cantons",null,27]
[13,null,"",{"$nulls":7},62,"Lac de Thune",null,27]
[14,null,"",null,"  Retour ",{"$nulls":5},63,"Lac de Walenstadt",null,27]
[15,null,"",{"$nulls":7},64,"Lac de Brienz",null,27]
[16,null,"",{"$nulls":7},65,"Lac Majeur",null,27]
[17,null,"",{"$nulls":7},66,"Lac de Morat",null,27]
[18,null,"",{"$nulls":7},67,"Suisse",null,27]
[19,null,""]
[20,null,""]
[21,null,""]
[22,null,""]
[23,null,""]
[24,null,""]
[25,null,""]
[26,null,""]
[27,null,""]
[28,null,""]
[29,null,"",null,"  Retour "]
[30,null,""]
[31,null,""]
[32,null,""]
[33,null,""]
[34,null,""]
[35,null,""]
[36,null,""]
[37,null,""]
[38,null,""]
[39,null,""]
[40,null,""]
[41,null,""]
[42,null,""]
[43,null,""]
[44,null,"",null,"  Retour "]
[45,null,""]
[46,null,""]
[47,null,""]
[48,null,""]
[49,null,""]
[50,null,""]
[51,null,""]
[52,null,""]
[53,null,""]
[54,null,""]
[55,null,""]
[56,null,""]
[57,null,""]
[58,null,""]
[59,null,"",null,"  Retour "]
[60,null,""]
[61,null,""]
[62,null,""]
[63,null,""]
[64,null,""]
[65,null,""]
[66,null,{"$f":"IF(B116=\"\",\"\",IF(U116=1,\"v\",\"Pas trouvé !\"))","v":""}]
[null,null,""]

{"sheet":"Carte de la Suisse","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Liste des no de ville","index":2,"n_rows":102,"n_cols":29,"rows_kept":102}
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
[]
[]
[null,"Argovie","Appenzell Rhodes-Extérieures","Appenzell Rhodes-Intérieures","Bâle-Campagne","Bâle-Ville","Berne","Fribourg","Genève","Glaris","Grisons","Jura","Lucerne","Neuchâtel","Nidwald","Obwald","Schaffhouse","Schwytz","Soleure","Saint-Gall","Tessin","Thurgovie","Uri","Vaud","Valais","Zoug","Zurich"]
[]
[]
[null,null,"26 cantons",null,"60 villes",{"$nulls":3},"6 lacs"]
[]
[null,1,"Argovie",1,"Genève",31,"Porrentruy",61,"Lac des 4 cantons"]
[null,2,"Appenzell Rhodes-Extérieures",2,"Nyon",32,"Delémont",62,"Lac de Thune"]
[null,3,"Appenzell Rhodes-Intérieures",3,"Morges",33,"Basel",63,"Lac de Walenstadt"]
[null,4,"Bâle-Campagne",4,"Lausanne",34,"Liestal",64,"Lac de Brienz"]
[null,5,"Bâle-Ville",5,"Vevey",35,"Olten",65,"Lac Majeur"]
[null,6,"Berne",6,"Monthey",36,"Aarau",66,"Lac de Morat"]
[null,7,"Fribourg",7,"Martigny",37,"Baden"]
[null,8,"Genève",8,"Sion",38,"Wohlen"]
[null,9,"Glaris",9,"Brig",39,"Dietikon"]
[null,10,"Grisons",10,"Locarno",40,"Schaffhausen"]
[null,11,"Jura",11,"Bellinzona",41,"Oerlikon"]
[null,12,"Lucerne",12,"Lugano",42,"Zürich"]
[null,13,"Neuchâtel",13,"Chiasso",43,"Uster"]
[null,14,"Nidwald",14,"Le Sentier",44,"Winterthur"]
[null,15,"Obwald",15,"Yverdon",45,"Rapperswil"]
[null,16,"Schaffhouse",16,"Payerne",46,"Frauenfeld"]
[null,17,"Schwytz",17,"Bulle",47,"Wil"]
[null,18,"Soleure",18,"La Chaux-de-Fonds",48,"St-Gallen"]
[null,19,"Saint-Gall",19,"Neuchâtel",49,"Altdorf"]
[null,20,"Tessin",20,"Murten (Morat)",50,"Interlaken"]
[null,21,"Thurgovie",21,"Fribourg",51,"Stans"]
[null,22,"Uri",22,"Bern",52,"Kreuzlinger"]
[null,23,"Vaud",23,"Thun",53,"Gstaad"]
[null,24,"Valais",24,"Luzern",54,"Langenthal"]
[null,25,"Zoug",25,"Chur (Coire)",55,"Glaris"]
[null,26,"Zurich",26,"Tramelan",56,"Schwyz"]
[null,27,"Suisse",27,"Bienne",57,"Sarnen"]
[{"$nulls":3},28,"Solothurn",58,"Appenzell"]
[{"$nulls":3},29,"Zug",59,"Sempach"]
[{"$nulls":3},30,"Buchs",60,"St. Moritz"]
[]
["Liste des villes du quiz par nombre d'habitants (2022)",{"$nulls":3},"Liste alphabétique"]
["Rang","Ville","Nb. Habitants"]
[1,"Zurich",{"v":421878,"d":"421,878"},null,"Aarau"]
[2,"Genève",{"v":203856,"d":"203,856"},null,"Altdorf"]
[3,"Bâle",{"v":173863,"d":"173,863"},null,"Appenzell"]
[4,"Lausanne",{"v":140202,"d":"140,202"},null,"Baden"]
[5,"Berne",{"v":134794,"d":"134,794"},null,"Basel"]
[6,"Winterthour",{"v":114220,"d":"114,220"},null,"Bellinzona"]
[7,"Lucerne",{"v":82620,"d":"82,620"},null,"Bern"]
[8,"Saint-Gall",{"v":76213,"d":"76,213"},null,"Bienne"]
[9,"Lugano",{"v":62315,"d":"62,315"},null,"Brig"]
[10,"Bienne",{"v":55206,"d":"55,206"},null,"Buchs"]
[11,"Neuchâtel",{"v":44531,"d":"44,531"},null,"Bulle"]
[12,"Thoune",{"v":43476,"d":"43,476"},null,"Chiasso"]
[13,"Bellinzone",{"v":43360,"d":"43,360"},null,"Chur (Coire)"]
[15,"Fribourg",{"v":38039,"d":"38,039"},null,"Delémont"]
[16,"Coire",{"v":37424,"d":"37,424"},null,"Dietikon"]
[17,"Schaffhouse",{"v":36952,"d":"36,952"},null,"Frauenfeld"]
[18,"La Chaux-de-Fonds",{"v":36915,"d":"36,915"},null,"Fribourg"]
[19,"Uster",{"v":35337,"d":"35,337"},null,"Genève"]
[20,"Sion",{"v":34978,"d":"34,978"},null,"Glaris"]
[24,"Zoug",{"v":30934,"d":"30,934"},null,"Gstaad"]
[25,"Yverdon-les-Bains",{"v":29955,"d":"29,955"},null,"Interlaken"]
[28,"Dietikon",{"v":28057,"d":"28,057"},null,"Kreuzlinger"]
[29,"Rapperswil",{"v":27483,"d":"27,483"},null,"La Chaux-de-Fonds"]
[32,"Frauenfeld",{"v":25974,"d":"25,974"},null,"Langenthal"]
[36,"Bulle",{"v":24412,"d":"24,412"},null,"Lausanne"]
[37,"Wil",{"v":24132,"d":"24,132"},null,"Le Sentier"]
[40,"Kreuzlingen",{"v":22390,"d":"22,390"},null,"Liestal"]
[42,"Aarau",{"v":21726,"d":"21,726"},null,"Locarno"]
[43,"Nyon",{"v":21718,"d":"21,718"},null,"Lugano"]
[45,"Oerlikon (Quartier de Zurich)",{"v":21658,"d":"21,658"},null,"Luzern"]
[50,"Martigny",{"v":20276,"d":"20,276"},null,"Martigny"]
[52,"Vevey",{"v":19752,"d":"19,752"},null,"Monthey"]
[53,"Baden",{"v":19621,"d":"19,621"},null,"Morges"]
[61,"Olten",{"v":18496,"d":"18,496"},null,"Murten (Morat)"]
[65,"Monthey",{"v":17820,"d":"17,820"},null,"Neuchâtel"]
[71,"Wohlen",{"v":16881,"d":"16,881"},null,"Nyon"]
[73,"Soleure",{"v":16802,"d":"16,802"},null,"Oerlikon"]
[78,"Morges",{"v":16101,"d":"16,101"},null,"Olten"]
[80,"Langenthal",{"v":15959,"d":"15,959"},null,"Payerne"]
[83,"Locarno",{"v":15728,"d":"15,728"},null,"Porrentruy"]
[85,"Schwytz",{"v":15435,"d":"15,435"},null,"Rapperswil"]
[90,"Liestal",{"v":14769,"d":"14,769"},null,"Sarnen"]
[103,"Brig",{"v":13221,"d":"13,221"},null,"Schaffhausen"]
[106,"Buchs",{"v":13053,"d":"13,053"},null,"Schwyz"]
[111,"Delémont",{"v":12618,"d":"12,618"},null,"Sempach"]
[112,"Glaris",{"v":12539,"d":"12,539"},null,"Sion"]
[142,"Sarnen",{"v":10514,"d":"10,514"},null,"Solothurn"]
[151,"Payerne",{"v":10069,"d":"10,069"},null,"St. Moritz"]
[155,"Altdorf",{"v":9565,"d":"9,565"},null,"Stans"]
[159,"Morat",{"v":8244,"d":"8,244"},null,"St-Gallen"]
[160,"Stans",{"v":8171,"d":"8,171"},null,"Thun"]
[162,"Chiasso",{"v":7581,"d":"7,581"},null,"Tramelan"]
[164,"Porrentry",{"v":6434,"d":"6,434"},null,"Uster"]
[166,"Appenzell",{"v":5793,"d":"5,793"},null,"Vevey"]
[167,"Interlaken",{"v":5719,"d":"5,719"},null,"Wil"]
[168,"Saint-Moritz",{"v":4945,"d":"4,945"},null,"Winterthur"]
["?","Tramelan",{"v":4500,"d":"4,500"},null,"Wohlen"]
["?","Sempach",{"v":4000,"d":"4,000"},null,"Yverdon"]
["?","Gstaad",{"v":3500,"d":"3,500"},null,"Zug"]
["?","Le Sentier",{"v":2000,"d":"2,000"},null,"Zürich"]