{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"not_rendered":{"charts":1,"images":55,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[2,0,2,1],[4,4,5,4],[11,5,11,6]]}
[null,null,"Tirage","Réponse","question","Total juste","%","test juste","rep données","rep juste","pourcentage","rep date","rep chef"]
[null,null,0,0,0,0,{"$f":"IF(G8=0,0,ROUND(G10/G8*100,0))","v":0},{"$f":"IF(K13=3,IF(D2=M2,1,0),IF(K13=4,IF(D2=L2,1,0),IF(C2=D2,1,0)))","v":1},0,0,100,{"$f":"VLOOKUP(C2,Data1,8)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C2,Data2,6)","v":{"$error":"#N/A"}}]
["Blasons des cantons suisses"]
[]
[{"$nulls":4},{"$f":"IF(D2=0,\"8\",IF(H2=1,\"G\",\"H\"))","v":"8"}]
[null," Choix :",{"$nulls":3},"Bonnes réponses :",{"$f":"G2&\" %\"","v":"0 %"}]
[{"$nulls":5},"Nb questions :",{"$f":"E2","v":0},null,null,true,{"$f":"IF(J7=TRUE,27,53)","v":27}]
[{"$nulls":5},"Nb réponses :",{"$f":"I2","v":0},null,null,43804.99484953703]
[{"$nulls":5},"Cantons tirés :",0,null,null,43804.99365740741]
[{"$nulls":5},"Nb réponses justes : ",{"$f":"J2","v":0},"en h:m:s",{"$f":"J10","v":"00:00:00"},{"$f":"IF(J9>J8,J9-J8,0)","v":"00:00:00"}]
[]
[{"$nulls":5},{"$f":"IF(G7>=K7,\"Partie terminée - Bravo !\",\"\")","v":""}]
[{"$nulls":9},"Choix :",1]
[{"$nulls":3},"  ",{"$nulls":5},"Français",1]
[{"$nulls":9},"Allemand",2]
[{"$nulls":9},"Chef-lieu",3]
[{"$nulls":9},"Date d'entrée",4]
[{"$nulls":9},"Abréviation",5]

{"sheet":"Feuil2","index":1,"n_rows":78,"n_cols":28,"rows_kept":78,"merged":[[7,7,8,7],[7,8,8,8]]}
[]
[]
[]
[null,null,"Argovie","Appenzel E.","Appenzel I.","Bâle C.","Bâle V.","Berne","Fribourg","Genève","Glaris","Grisons","Jura","Lucerne","Neuchatel","Nidwald","Obwald","Schaffouse","Schwitz","Soleure","St Gall","Tessin","Thurgovie","Uri","Valais","Vaud","Zoug","Zurich"]
[]
[]
[]
[{"$nulls":6},"Menu :",{"$f":"Feuil1!$K$13+1","v":2},"Data2"]
[]
[1,"       Argovie","       Aargau","       Aarau",1803,"                          AG",{"$f":"IF($H$8=4,VLOOKUP(A10,Data2,$H$8),IF($H$8=5,VLOOKUP(A10,Data2,$H$8-3),VLOOKUP(A10,Data1,$H$8)))","v":"       Argovie"},{"$f":"VLOOKUP(E10,$J$10:$K$21,2)","v":10},1,1291,1,"       Aarau",1,{"$f":"VLOOKUP(D10,$L$10:$M$35,2)","v":1}]
[2,"       Appenzell Rhodes-Extérieures","       Appenzell Ausserrhoden","       Herisau",1513,"                          AR",{"$f":"IF($H$8=4,VLOOKUP(A11,Data2,$H$8),IF($H$8=5,VLOOKUP(A11,Data2,$H$8-3),VLOOKUP(A11,Data1,$H$8)))","v":"       Appenzell Rhodes-Extérieures"},9,2,1332,2,"       Altdorf",2,{"$f":"VLOOKUP(D11,$L$10:$M$35,2)","v":13}]
[3,"       Appenzell Rhodes-Intérieures","       Appenzell Innerrhoden","       Appenzell",1513,"                          AI",{"$f":"IF($H$8=4,VLOOKUP(A12,Data2,$H$8),IF($H$8=5,VLOOKUP(A12,Data2,$H$8-3),VLOOKUP(A12,Data1,$H$8)))","v":"       Appenzell Rhodes-Intérieures"},9,3,1351,3,"       Appenzell",3,3]
[4,"       Bâle-Campagne","       Basel-Landschaft","       Liestal",1501,"                          BL",{"$f":"IF($H$8=4,VLOOKUP(A13,Data2,$H$8),IF($H$8=5,VLOOKUP(A13,Data2,$H$8-3),VLOOKUP(A13,Data1,$H$8)))","v":"       Bâle-Campagne"},7,4,1352,4,"       Bâle",4,15]
[5,"       Bâle-Ville","       Basel-Stadt","       Bâle",1501,"                          BS",{"$f":"IF($H$8=4,VLOOKUP(A14,Data2,$H$8),IF($H$8=5,VLOOKUP(A14,Data2,$H$8-3),VLOOKUP(A14,Data1,$H$8)))","v":"       Bâle-Ville"},7,5,1353,5,"       Bellinzone",5,4]
[6,"       Berne","       Bern","       Berne",1353,"                          BE",{"$f":"IF($H$8=4,VLOOKUP(A15,Data2,$H$8),IF($H$8=5,VLOOKUP(A15,Data2,$H$8-3),VLOOKUP(A15,Data1,$H$8)))","v":"       Berne"},5,6,1481,6,"       Berne",6,6]
[7,"       Fribourg","       Freiburg","       Fribourg",1481,"                          FR",{"$f":"IF($H$8=4,VLOOKUP(A16,Data2,$H$8),IF($H$8=5,VLOOKUP(A16,Data2,$H$8-3),VLOOKUP(A16,Data1,$H$8)))","v":"       Fribourg"},6,7,1501,7,"       Coire",7,10]
[8,"       Genève","       Genf","       Genève",1815,"                          GE",{"$f":"IF($H$8=4,VLOOKUP(A17,Data2,$H$8),IF($H$8=5,VLOOKUP(A17,Data2,$H$8-3),VLOOKUP(A17,Data1,$H$8)))","v":"       Genève"},11,8,1513,8,"       Delémont",8,11]
[9,"       Glaris","       Glarus","       Glaris",1352,"                          GL",{"$f":"IF($H$8=4,VLOOKUP(A18,Data2,$H$8),IF($H$8=5,VLOOKUP(A18,Data2,$H$8-3),VLOOKUP(A18,Data1,$H$8)))","v":"       Glaris"},4,9,1513,9,"       Frauenfeld",9,12]
[10,"       Grisons","       Graubünden","       Coire",1803,"                          GR",{"$f":"IF($H$8=4,VLOOKUP(A19,Data2,$H$8),IF($H$8=5,VLOOKUP(A19,Data2,$H$8-3),VLOOKUP(A19,Data1,$H$8)))","v":"       Grisons"},10,10,1803,10,"       Fribourg",10,7]
[11,"       Jura","       Jura","       Delémont",1979,"                          JU",{"$f":"IF($H$8=4,VLOOKUP(A20,Data2,$H$8),IF($H$8=5,VLOOKUP(A20,Data2,$H$8-3),VLOOKUP(A20,Data1,$H$8)))","v":"       Jura"},12,11,1815,11,"       Genève",11,8]
[12,"       Lucerne","       Luzern","       Lucerne",1332,"                          LU",{"$f":"IF($H$8=4,VLOOKUP(A21,Data2,$H$8),IF($H$8=5,VLOOKUP(A21,Data2,$H$8-3),VLOOKUP(A21,Data1,$H$8)))","v":"       Lucerne"},2,12,1979,12,"       Glaris",12,16]
[13,"       Neuchâtel","       Neuenburg","       Neuchâtel",1815,"                          NE",{"$f":"IF($H$8=4,VLOOKUP(A22,Data2,$H$8),IF($H$8=5,VLOOKUP(A22,Data2,$H$8-3),VLOOKUP(A22,Data1,$H$8)))","v":"       Neuchâtel"},11,13,"----------------------",13,"       Herisau",13,17]
[14,"       Nidwald","       Nidwalden","       Stans",1291,"                          NW",{"$f":"IF($H$8=4,VLOOKUP(A23,Data2,$H$8),IF($H$8=5,VLOOKUP(A23,Data2,$H$8-3),VLOOKUP(A23,Data1,$H$8)))","v":"       Nidwald"},1,14,"   ",14,"       Lausanne",14,24]
[15,"       Obwald","       Obwalden","       Sarnen",1291,"                          OW",{"$f":"IF($H$8=4,VLOOKUP(A24,Data2,$H$8),IF($H$8=5,VLOOKUP(A24,Data2,$H$8-3),VLOOKUP(A24,Data1,$H$8)))","v":"       Obwald"},1,15,"   ",15,"       Liestal",15,19]
[16,"       Schaffhouse","       Schaffhausen","       Schaffhouse",1501,"                          SH",{"$f":"IF($H$8=4,VLOOKUP(A25,Data2,$H$8),IF($H$8=5,VLOOKUP(A25,Data2,$H$8-3),VLOOKUP(A25,Data1,$H$8)))","v":"       Schaffhouse"},7,16,"   ",16,"       Lucerne",16,20]
[17,"       Schwytz","       Schwyz","       Schwytz",1291,"                          SZ",{"$f":"IF($H$8=4,VLOOKUP(A26,Data2,$H$8),IF($H$8=5,VLOOKUP(A26,Data2,$H$8-3),VLOOKUP(A26,Data1,$H$8)))","v":"       Schwytz"},1,17,"   ",17,"       Neuchâtel",17,21]
[18,"       Soleure","       Solothurn","       Soleure",1481,"                          SO",{"$f":"IF($H$8=4,VLOOKUP(A27,Data2,$H$8),IF($H$8=5,VLOOKUP(A27,Data2,$H$8-3),VLOOKUP(A27,Data1,$H$8)))","v":"       Soleure"},6,18,"   ",18,"       Saint-Gall",18,23]
[19,"       Saint-Gall","       St. Gallen","       Saint-Gall",1803,"                          SG",{"$f":"IF($H$8=4,VLOOKUP(A28,Data2,$H$8),IF($H$8=5,VLOOKUP(A28,Data2,$H$8-3),VLOOKUP(A28,Data1,$H$8)))","v":"       Saint-Gall"},10,19,"   ",19,"       Sarnen",19,18]
[20,"       Tessin","       Ticino","       Bellinzone",1803,"                          TI",{"$f":"IF($H$8=4,VLOOKUP(A29,Data2,$H$8),IF($H$8=5,VLOOKUP(A29,Data2,$H$8-3),VLOOKUP(A29,Data1,$H$8)))","v":"       Tessin"},10,20,"   ",20,"       Schaffhouse",20,5]
[21,"       Thurgovie","       Thurgau","       Frauenfeld",1803,"                          TG",{"$f":"IF($H$8=4,VLOOKUP(A30,Data2,$H$8),IF($H$8=5,VLOOKUP(A30,Data2,$H$8-3),VLOOKUP(A30,Data1,$H$8)))","v":"       Thurgovie"},10,21,"   ",21,"       Schwytz",21,9]
[22,"       Uri","       Uri","       Altdorf",1291,"                          UR",{"$f":"IF($H$8=4,VLOOKUP(A31,Data2,$H$8),IF($H$8=5,VLOOKUP(A31,Data2,$H$8-3),VLOOKUP(A31,Data1,$H$8)))","v":"       Uri"},1,22,"   ",22,"       Sion",22,2]
[23,"       Valais","       Wallis","       Sion",1815,"                          VS",{"$f":"IF($H$8=4,VLOOKUP(A32,Data2,$H$8),IF($H$8=5,VLOOKUP(A32,Data2,$H$8-3),VLOOKUP(A32,Data1,$H$8)))","v":"       Valais"},11,23,"   ",23,"       Soleure",23,22]
[24,"       Vaud","       Waadt","       Lausanne",1803,"                          VD",{"$f":"IF($H$8=4,VLOOKUP(A33,Data2,$H$8),IF($H$8=5,VLOOKUP(A33,Data2,$H$8-3),VLOOKUP(A33,Data1,$H$8)))","v":"       Vaud"},10,24,"   ",24,"       Stans",24,14]
[25,"       Zoug","       Zug","       Zoug",1352,"                          ZG",{"$f":"IF($H$8=4,VLOOKUP(A34,Data2,$H$8),IF($H$8=5,VLOOKUP(A34,Data2,$H$8-3),VLOOKUP(A34,Data1,$H$8)))","v":"       Zoug"},4,25,"   ",25,"       Zoug",25,25]
[26,"       Zurich","       Zürich","       Zurich",1351,"                          ZH",{"$f":"IF($H$8=4,VLOOKUP(A35,Data2,$H$8),IF($H$8=5,VLOOKUP(A35,Data2,$H$8-3),VLOOKUP(A35,Data1,$H$8)))","v":"       Zurich"},3,26,"   ",26,"       Zurich",26,26]
[]
[]
[" "]
[{"$nulls":6},{"$f":"\"       \"&B39","v":"       "}]
[{"$nulls":6},"       "]
[{"$nulls":6},"       "]
[" "]
[]
[]
[]
[" "]
[]
[]
[]
[]
[" "]
[]
[]
[]
[" "]
[]
[]
[]
[" "]
{"$rows_empty":10}
[" "]
{"$rows_empty":7}
[" "]