{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["HOME","Contents","S1_SC","Page1","Page2","Page3","Page4","Page5","Page6","S2_SC","Poker","MonteCarlo","Annex_SC","Updates","Lookup","Print_Sheets"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":4,"defined_names":670,"comments":0,"pivot_tables":1},"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":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Modelisation fonction Alea()"]
[null,"&"]
[]
[null,{"$f":"\"Last Version: \" & INDEX(Updates!G:G,MATCH(MAX(Tbl_HistoriqueMaj[Date]),Updates!F:F,0))","v":"Last Version: 1.0"}]
[null,{"$f":"MAX(Tbl_HistoriqueMaj[Date])","v":"2015-12-02"}]

{"sheet":"Contents","index":1,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Nom_Modele","v":"Modelisation fonction Alea()"}]
[null,"Sommaire"]
[null,"&",null,"Home"]
[null,"é",null,"è"]
[]
[null,"Sections et titres",null,null,null,null,null,null,"Pages"]
[]
[null,"1.","Six façons d'utiliser la fonction Alea()",null,null,null,null,null,3]
[null,null,null,"Lancer un dé",null,null,null,null,4]
[null,null,null,"Tirer des cartes",null,null,null,null,5]
[null,null,null,"Loi normale inversée",null,null,null,null,6]
[null,null,null,"Valeur aléatoire d'une liste",null,null,null,null,7]
[null,null,null,"Valeur aléatoire d'une liste en fonction d'une autre valeur",null,null,null,null,8]
[null,null,null,"Aléa entre des dates",null,null,null,null,9]
[null,"2.","Cas d'utilisation",null,null,null,null,null,10]
[null,null,null,"Jeu de poker",null,null,null,null,11]
[null,null,null,"Monte Carlo - Lancer n fois",null,null,null,null,12]
[null,"3.","Annexe",null,null,null,null,null,13]
[null,null,null,"Historique des mises à jour",null,null,null,null,14]
[null,null,null,"Lookup",null,null,null,null,15]
[null,null,null,"Impression feuilles",null,null,null,null,16]

{"sheet":"S1_SC","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"E8","v":"Six façons d'utiliser la fonction Alea()"}]
[]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
[]
[]
[null,null,null,null,"Six façons d'utiliser la fonction Alea()"]
[null,null,null,null,"Section 1"]
[]
[]
[null,null,null,null,{"$f":"\"Section: \" & E8","v":"Section: Six façons d'utiliser la fonction Alea()"}]
[null,null,null,null,"1)","Lancer un dé"]
[null,null,null,null,"2)","Tirer des cartes"]
[null,null,null,null,"3)","Loi normale inversée"]
[null,null,null,null,"4)","Valeur aléatoire d'une liste"]
[null,null,null,null,"5)","Valeur aléatoire d'une liste en fonction d'une autre valeur"]
[null,null,null,null,"6)","Aléa entre des dates"]

{"sheet":"Page1","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Lancer un dé"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
[null,"Un dé contient 6 faces. De ce fait le résultat est un entier compris en 1 et 6"]
[]
[null,null,null,null,null,"Minimum",1]
[null,null,null,null,null,"Maximum",6]
[null,null,null,null,null,"Nombre de possibilités",{"$f":"(G9-G8)+1","v":6}]
[]
[null,null,null,null,null,"Calcul de l'Aléa",{"$f":" 2 + INT( 6 * RAND() )","v":7},{"$f":"_xlfn.FORMULATEXT(G12)","v":"= 2 + ENT( 6 * ALEA() )"}]

{"sheet":"Page2","index":4,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Tirer des cartes"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
["Explication"]
[null,"Une carte est composée de deux parties:"]
[null,null,"1. Le numéro de la carte: de 2 à 10, puis Valet, Dame, Roi et As."]
[null,null,"2. La couleur: Cœur, Carreau, Pique, Trèfle"]
[]
["Alea sur numéro de carte"]
[null,"Pour la carte, nous allons considérer des chiffres allant de 1 à 13. "]
[null,"A chaque chiffre devra correspondre une carte."]
[]
[null,null,null,null,"N°","Carte","Chercher le num de carte"]
[null,null,null,null,1,"As",null,"Tout comme pour les dés, nous allons procéder à un tirage compris entre 1 et 13 ce coup-ci"]
[null,null,null,null,2,2,null,"Minimum",1]
[null,null,null,null,3,3,null,"Maximum",13]
[null,null,null,null,4,4,null,"Nombre de possibilités",{"$f":"(I18-I17)+1","v":13}]
[null,null,null,null,5,5,null,"Numéro de la carte:",{"$f":" I17 + INT( I19 * RAND() )","v":8}]
[null,null,null,null,6,6]
[null,null,null,null,7,7,"Récupérer le nom de la carte"]
[null,null,null,null,8,8,null,"Il suffit maintenant de chercher la carte correspondante avec un bon vieux RECHERCHEV !"]
[null,null,null,null,9,9,null,"Carte:",{"$f":"VLOOKUP(NumCarte,Tbl_Cartes,2,FALSE)","v":8}]
[null,null,null,null,10,10]
[null,null,null,null,11,"Valet"]
[null,null,null,null,12,"Dame"]
[null,null,null,null,13,"Roi"]
[]
["Alea sur la couleur de la carte"]
[null,"Nous allons user du même stratatgème pour la couleur:"]
[]
[null,null,null,null,"N°","Couleur","Chercher le num de carte"]
[null,null,null,null,1,"Cœur",null,"Tout comme pour les dés, nous allons procéder à un tirage compris entre 1 et 13 ce coup-ci"]
[null,null,null,null,2,"Carreau",null,"Minimum",1]
[null,null,null,null,3,"Pique",null,"Maximum",4]
[null,null,null,null,4,"Trèfle",null,"Nombre de possibilités",{"$f":"(I36-I35)+1","v":4}]
[null,null,null,null,null,null,null,"Numéro de la couleur:",{"$f":" I35 + INT( I37 * RAND() )","v":4}]
[]
[null,null,null,null,null,null,"Récupérer le nom de la carte"]
[null,null,null,null,null,null,null,"Il suffit maintenant de chercher la carte correspondante avec un bon vieux RECHERCHEV !"]
[null,null,null,null,null,null,null,"Couleur:",{"$f":"VLOOKUP(NumCouleur,Tbl_Couleur,2,FALSE)","v":"Trèfle"}]
[]
["Finalisation"]
[null,"Il suffit à présent de concaténer:"]
[null,null,null,null,null,"Carte:",null,{"$f":"I24","v":8}]
[null,null,null,null,null,"Couleur:",null,{"$f":"I42","v":"Trèfle"}]
[null,null,null,null,null,"Finalisation",null,{"$f":"H46 & \" de \" & H47","v":"8 de Trèfle"}]
[]
[null,null,null,null,null,"Tapez F9 pour faire un nouveau tirage !"]

{"sheet":"Page3","index":5,"n_rows":515,"n_cols":12,"rows_kept":515,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Loi normale inversée"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
["Explication"]
[null,"Pour des besoins statistiques ou pour analyser les prix des marchés comme pour l'aluminium par exemple,"]
[null,"il est possible de combiner la fonction ALEA() et la fonction LOI.NORMALE.INVERSE(…)"]
[]
[null,null,null,null,null,"Valeur:",{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":6},{"$f":"_xlfn.FORMULATEXT(G10)","v":"=ARRONDI(LOI.NORMALE.INVERSE(ALEA();10;3);0)"}]
[]
[null,"Ainsi, en réalisant de nombreux tirages, nous pouvons constater, à travers un graphique, que les données suivent bien une Loi Normale."]
[null,"Et bien entendu, plus nous aurons de valeurs, et plus la loi normale sera marquée sur le graphique."]
[]
[null,null,null,null,null,"Tirage n°","Valeur",null,null,"Nombre de tirages :",{"$f":"MAX(F:F)","v":500},{"$f":"_xlfn.FORMULATEXT(K15)","v":"=MAX(F:F)"}]
[null,null,null,null,null,1,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":13}]
[null,null,null,null,null,2,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":12}]
[null,null,null,null,null,3,10,null,"Valeur ","Qté"]
[null,null,null,null,null,4,9,null,2,2]
[null,null,null,null,null,5,10,null,3,2]
[null,null,null,null,null,6,10,null,4,9]
[null,null,null,null,null,7,9,null,5,26]
[null,null,null,null,null,8,8,null,6,28]
[null,null,null,null,null,9,7,null,7,32]
[null,null,null,null,null,10,8,null,8,59]
[null,null,null,null,null,11,8,null,9,63]
[null,null,null,null,null,12,11,null,10,73]
[null,null,null,null,null,13,7,null,11,57]
[null,null,null,null,null,14,5,null,12,56]
[null,null,null,null,null,15,7,null,13,28]
[null,null,null,null,null,16,7,null,14,24]
[null,null,null,null,null,17,8,null,15,19]
[null,null,null,null,null,18,13,null,16,8]
[null,null,null,null,null,19,11,null,17,8]
[null,null,null,null,null,20,8,null,18,2]
[null,null,null,null,null,21,12,null,19,1]
[null,null,null,null,null,22,11,null,1,1]
[null,null,null,null,null,23,12,null,0,1]
[null,null,null,null,null,24,6,null,21,1]
[null,null,null,null,null,25,16,null,"Total général",500]
[null,null,null,null,null,26,14]
[null,null,null,null,null,27,8]
[null,null,null,null,null,28,10]
[null,null,null,null,null,29,11]
[null,null,null,null,null,30,11]
[null,null,null,null,null,31,10]
[null,null,null,null,null,32,12]
[null,null,null,null,null,33,14]
[null,null,null,null,null,34,11]
[null,null,null,null,null,35,13]
[null,null,null,null,null,36,7]
[null,null,null,null,null,37,12]
[null,null,null,null,null,38,12]
[null,null,null,null,null,39,8]
[null,null,null,null,null,40,9]
[null,null,null,null,null,41,13]
[null,null,null,null,null,42,11]
[null,null,null,null,null,43,17]
[null,null,null,null,null,44,10]
[null,null,null,null,null,45,12]
[null,null,null,null,null,46,10]
[null,null,null,null,null,47,12]
[null,null,null,null,null,48,8]
[null,null,null,null,null,49,14]
[null,null,null,null,null,50,7]
[null,null,null,null,null,51,9]
[null,null,null,null,null,52,10]
[null,null,null,null,null,53,7]
[null,null,null,null,null,54,11]
[null,null,null,null,null,55,14]
[null,null,null,null,null,56,17]
[null,null,null,null,null,57,9]
[null,null,null,null,null,58,10]
[null,null,null,null,null,59,6]
[null,null,null,null,null,60,13]
[null,null,null,null,null,61,3]
[null,null,null,null,null,62,12]
[null,null,null,null,null,63,13]
[null,null,null,null,null,64,9]
[null,null,null,null,null,65,7]
[null,null,null,null,null,66,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":10}]
[null,null,null,null,null,67,12]
[null,null,null,null,null,68,9]
[null,null,null,null,null,69,5]
[null,null,null,null,null,70,12]
[null,null,null,null,null,71,15]
[null,null,null,null,null,72,14]
[null,null,null,null,null,73,13]
[null,null,null,null,null,74,12]
[null,null,null,null,null,75,17]
[null,null,null,null,null,76,10]
[null,null,null,null,null,77,8]
[null,null,null,null,null,78,8]
[null,null,null,null,null,79,12]
[null,null,null,null,null,80,6]
[null,null,null,null,null,81,8]
[null,null,null,null,null,82,7]
[null,null,null,null,null,83,11]
[null,null,null,null,null,84,11]
[null,null,null,null,null,85,12]
[null,null,null,null,null,86,10]
[null,null,null,null,null,87,9]
[null,null,null,null,null,88,8]
[null,null,null,null,null,89,5]
[null,null,null,null,null,90,10]
[null,null,null,null,null,91,10]
[null,null,null,null,null,92,5]
[null,null,null,null,null,93,11]
[null,null,null,null,null,94,5]
[null,null,null,null,null,95,14]
[null,null,null,null,null,96,12]
[null,null,null,null,null,97,8]
[null,null,null,null,null,98,7]
[null,null,null,null,null,99,12]
[null,null,null,null,null,100,6]
[null,null,null,null,null,101,9]
[null,null,null,null,null,102,9]
[null,null,null,null,null,103,11]
[null,null,null,null,null,104,12]
[null,null,null,null,null,105,10]
[null,null,null,null,null,106,10]
[null,null,null,null,null,107,9]
[null,null,null,null,null,108,9]
[null,null,null,null,null,109,8]
[null,null,null,null,null,110,10]
[null,null,null,null,null,111,16]
[null,null,null,null,null,112,7]
[null,null,null,null,null,113,12]
[null,null,null,null,null,114,9]
[null,null,null,null,null,115,11]
[null,null,null,null,null,116,12]
[null,null,null,null,null,117,5]
[null,null,null,null,null,118,12]
[null,null,null,null,null,119,14]
[null,null,null,null,null,120,11]
[null,null,null,null,null,121,8]
[null,null,null,null,null,122,16]
[null,null,null,null,null,123,5]
[null,null,null,null,null,124,14]
[null,null,null,null,null,125,9]
[null,null,null,null,null,126,16]
[null,null,null,null,null,127,12]
[null,null,null,null,null,128,7]
[null,null,null,null,null,129,12]
[null,null,null,null,null,130,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":16}]
[null,null,null,null,null,131,9]
[null,null,null,null,null,132,12]
[null,null,null,null,null,133,15]
[null,null,null,null,null,134,6]
[null,null,null,null,null,135,15]
[null,null,null,null,null,136,12]
[null,null,null,null,null,137,11]
[null,null,null,null,null,138,7]
[null,null,null,null,null,139,2]
[null,null,null,null,null,140,10]
[null,null,null,null,null,141,14]
[null,null,null,null,null,142,13]
[null,null,null,null,null,143,5]
[null,null,null,null,null,144,11]
[null,null,null,null,null,145,7]
[null,null,null,null,null,146,13]
[null,null,null,null,null,147,16]
[null,null,null,null,null,148,10]
[null,null,null,null,null,149,8]
[null,null,null,null,null,150,9]
[null,null,null,null,null,151,9]
[null,null,null,null,null,152,11]
[null,null,null,null,null,153,15]
[null,null,null,null,null,154,11]
[null,null,null,null,null,155,9]
[null,null,null,null,null,156,8]
[null,null,null,null,null,157,15]
[null,null,null,null,null,158,10]
[null,null,null,null,null,159,11]
[null,null,null,null,null,160,14]
[null,null,null,null,null,161,5]
[null,null,null,null,null,162,12]
[null,null,null,null,null,163,13]
[null,null,null,null,null,164,16]
[null,null,null,null,null,165,15]
[null,null,null,null,null,166,6]
[null,null,null,null,null,167,13]
[null,null,null,null,null,168,9]
[null,null,null,null,null,169,9]
[null,null,null,null,null,170,11]
[null,null,null,null,null,171,13]
[null,null,null,null,null,172,14]
[null,null,null,null,null,173,11]
[null,null,null,null,null,174,8]
[null,null,null,null,null,175,13]
[null,null,null,null,null,176,12]
[null,null,null,null,null,177,10]
[null,null,null,null,null,178,11]
[null,null,null,null,null,179,6]
[null,null,null,null,null,180,15]
[null,null,null,null,null,181,9]
[null,null,null,null,null,182,9]
[null,null,null,null,null,183,7]
[null,null,null,null,null,184,11]
[null,null,null,null,null,185,9]
[null,null,null,null,null,186,12]
[null,null,null,null,null,187,14]
[null,null,null,null,null,188,12]
[null,null,null,null,null,189,11]
[null,null,null,null,null,190,8]
[null,null,null,null,null,191,6]
[null,null,null,null,null,192,7]
[null,null,null,null,null,193,8]
[null,null,null,null,null,194,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":7}]
[null,null,null,null,null,195,3]
[null,null,null,null,null,196,8]
[null,null,null,null,null,197,11]
[null,null,null,null,null,198,11]
[null,null,null,null,null,199,12]
[null,null,null,null,null,200,8]
[null,null,null,null,null,201,8]
[null,null,null,null,null,202,8]
[null,null,null,null,null,203,13]
[null,null,null,null,null,204,15]
[null,null,null,null,null,205,14]
[null,null,null,null,null,206,10]
[null,null,null,null,null,207,7]
[null,null,null,null,null,208,8]
[null,null,null,null,null,209,3]
[null,null,null,null,null,210,9]
[null,null,null,null,null,211,7]
[null,null,null,null,null,212,9]
[null,null,null,null,null,213,12]
[null,null,null,null,null,214,11]
[null,null,null,null,null,215,11]
[null,null,null,null,null,216,19]
[null,null,null,null,null,217,12]
[null,null,null,null,null,218,15]
[null,null,null,null,null,219,12]
[null,null,null,null,null,220,10]
[null,null,null,null,null,221,10]
[null,null,null,null,null,222,13]
[null,null,null,null,null,223,8]
[null,null,null,null,null,224,12]
[null,null,null,null,null,225,13]
[null,null,null,null,null,226,13]
[null,null,null,null,null,227,6]
[null,null,null,null,null,228,10]
[null,null,null,null,null,229,13]
[null,null,null,null,null,230,11]
[null,null,null,null,null,231,13]
[null,null,null,null,null,232,4]
[null,null,null,null,null,233,10]
[null,null,null,null,null,234,16]
[null,null,null,null,null,235,10]
[null,null,null,null,null,236,11]
[null,null,null,null,null,237,13]
[null,null,null,null,null,238,13]
[null,null,null,null,null,239,9]
[null,null,null,null,null,240,11]
[null,null,null,null,null,241,8]
[null,null,null,null,null,242,9]
[null,null,null,null,null,243,9]
[null,null,null,null,null,244,6]
[null,null,null,null,null,245,8]
[null,null,null,null,null,246,11]
[null,null,null,null,null,247,14]
[null,null,null,null,null,248,7]
[null,null,null,null,null,249,11]
[null,null,null,null,null,250,12]
[null,null,null,null,null,251,12]
[null,null,null,null,null,252,12]
[null,null,null,null,null,253,14]
[null,null,null,null,null,254,12]
[null,null,null,null,null,255,9]
[null,null,null,null,null,256,11]
[null,null,null,null,null,257,7]
[null,null,null,null,null,258,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":12}]
[null,null,null,null,null,259,8]
[null,null,null,null,null,260,10]
[null,null,null,null,null,261,16]
[null,null,null,null,null,262,7]
[null,null,null,null,null,263,11]
[null,null,null,null,null,264,15]
[null,null,null,null,null,265,11]
[null,null,null,null,null,266,3]
[null,null,null,null,null,267,12]
[null,null,null,null,null,268,9]
[null,null,null,null,null,269,14]
[null,null,null,null,null,270,8]
[null,null,null,null,null,271,7]
[null,null,null,null,null,272,9]
[null,null,null,null,null,273,8]
[null,null,null,null,null,274,11]
[null,null,null,null,null,275,5]
[null,null,null,null,null,276,9]
[null,null,null,null,null,277,5]
[null,null,null,null,null,278,10]
[null,null,null,null,null,279,3]
[null,null,null,null,null,280,16]
[null,null,null,null,null,281,10]
[null,null,null,null,null,282,14]
[null,null,null,null,null,283,15]
[null,null,null,null,null,284,6]
[null,null,null,null,null,285,16]
[null,null,null,null,null,286,9]
[null,null,null,null,null,287,16]
[null,null,null,null,null,288,5]
[null,null,null,null,null,289,10]
[null,null,null,null,null,290,9]
[null,null,null,null,null,291,3]
[null,null,null,null,null,292,6]
[null,null,null,null,null,293,12]
[null,null,null,null,null,294,14]
[null,null,null,null,null,295,10]
[null,null,null,null,null,296,8]
[null,null,null,null,null,297,12]
[null,null,null,null,null,298,6]
[null,null,null,null,null,299,14]
[null,null,null,null,null,300,13]
[null,null,null,null,null,301,14]
[null,null,null,null,null,302,7]
[null,null,null,null,null,303,13]
[null,null,null,null,null,304,6]
[null,null,null,null,null,305,12]
[null,null,null,null,null,306,12]
[null,null,null,null,null,307,11]
[null,null,null,null,null,308,8]
[null,null,null,null,null,309,12]
[null,null,null,null,null,310,15]
[null,null,null,null,null,311,11]
[null,null,null,null,null,312,7]
[null,null,null,null,null,313,12]
[null,null,null,null,null,314,9]
[null,null,null,null,null,315,7]
[null,null,null,null,null,316,10]
[null,null,null,null,null,317,11]
[null,null,null,null,null,318,12]
[null,null,null,null,null,319,11]
[null,null,null,null,null,320,14]
[null,null,null,null,null,321,14]
[null,null,null,null,null,322,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":14}]
[null,null,null,null,null,323,8]
[null,null,null,null,null,324,9]
[null,null,null,null,null,325,13]
[null,null,null,null,null,326,10]
[null,null,null,null,null,327,8]
[null,null,null,null,null,328,7]
[null,null,null,null,null,329,14]
[null,null,null,null,null,330,8]
[null,null,null,null,null,331,5]
[null,null,null,null,null,332,11]
[null,null,null,null,null,333,7]
[null,null,null,null,null,334,13]
[null,null,null,null,null,335,12]
[null,null,null,null,null,336,13]
[null,null,null,null,null,337,9]
[null,null,null,null,null,338,10]
[null,null,null,null,null,339,12]
[null,null,null,null,null,340,8]
[null,null,null,null,null,341,8]
[null,null,null,null,null,342,4]
[null,null,null,null,null,343,14]
[null,null,null,null,null,344,12]
[null,null,null,null,null,345,15]
[null,null,null,null,null,346,14]
[null,null,null,null,null,347,12]
[null,null,null,null,null,348,3]
[null,null,null,null,null,349,15]
[null,null,null,null,null,350,10]
[null,null,null,null,null,351,12]
[null,null,null,null,null,352,9]
[null,null,null,null,null,353,11]
[null,null,null,null,null,354,6]
[null,null,null,null,null,355,9]
[null,null,null,null,null,356,12]
[null,null,null,null,null,357,8]
[null,null,null,null,null,358,9]
[null,null,null,null,null,359,8]
[null,null,null,null,null,360,5]
[null,null,null,null,null,361,6]
[null,null,null,null,null,362,10]
[null,null,null,null,null,363,14]
[null,null,null,null,null,364,13]
[null,null,null,null,null,365,15]
[null,null,null,null,null,366,9]
[null,null,null,null,null,367,9]
[null,null,null,null,null,368,4]
[null,null,null,null,null,369,13]
[null,null,null,null,null,370,12]
[null,null,null,null,null,371,12]
[null,null,null,null,null,372,9]
[null,null,null,null,null,373,4]
[null,null,null,null,null,374,11]
[null,null,null,null,null,375,11]
[null,null,null,null,null,376,7]
[null,null,null,null,null,377,11]
[null,null,null,null,null,378,11]
[null,null,null,null,null,379,11]
[null,null,null,null,null,380,10]
[null,null,null,null,null,381,8]
[null,null,null,null,null,382,8]
[null,null,null,null,null,383,8]
[null,null,null,null,null,384,15]
[null,null,null,null,null,385,8]
[null,null,null,null,null,386,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":11}]
[null,null,null,null,null,387,15]
[null,null,null,null,null,388,9]
[null,null,null,null,null,389,8]
[null,null,null,null,null,390,7]
[null,null,null,null,null,391,8]
[null,null,null,null,null,392,9]
[null,null,null,null,null,393,8]
[null,null,null,null,null,394,7]
[null,null,null,null,null,395,13]
[null,null,null,null,null,396,11]
[null,null,null,null,null,397,15]
[null,null,null,null,null,398,8]
[null,null,null,null,null,399,11]
[null,null,null,null,null,400,13]
[null,null,null,null,null,401,10]
[null,null,null,null,null,402,10]
[null,null,null,null,null,403,12]
[null,null,null,null,null,404,13]
[null,null,null,null,null,405,9]
[null,null,null,null,null,406,11]
[null,null,null,null,null,407,9]
[null,null,null,null,null,408,13]
[null,null,null,null,null,409,16]
[null,null,null,null,null,410,5]
[null,null,null,null,null,411,8]
[null,null,null,null,null,412,6]
[null,null,null,null,null,413,15]
[null,null,null,null,null,414,12]
[null,null,null,null,null,415,8]
[null,null,null,null,null,416,13]
[null,null,null,null,null,417,12]
[null,null,null,null,null,418,11]
[null,null,null,null,null,419,9]
[null,null,null,null,null,420,12]
[null,null,null,null,null,421,11]
[null,null,null,null,null,422,13]
[null,null,null,null,null,423,9]
[null,null,null,null,null,424,12]
[null,null,null,null,null,425,11]
[null,null,null,null,null,426,11]
[null,null,null,null,null,427,14]
[null,null,null,null,null,428,11]
[null,null,null,null,null,429,8]
[null,null,null,null,null,430,10]
[null,null,null,null,null,431,16]
[null,null,null,null,null,432,12]
[null,null,null,null,null,433,8]
[null,null,null,null,null,434,14]
[null,null,null,null,null,435,8]
[null,null,null,null,null,436,11]
[null,null,null,null,null,437,11]
[null,null,null,null,null,438,11]
[null,null,null,null,null,439,17]
[null,null,null,null,null,440,10]
[null,null,null,null,null,441,12]
[null,null,null,null,null,442,12]
[null,null,null,null,null,443,3]
[null,null,null,null,null,444,10]
[null,null,null,null,null,445,8]
[null,null,null,null,null,446,11]
[null,null,null,null,null,447,10]
[null,null,null,null,null,448,12]
[null,null,null,null,null,449,11]
[null,null,null,null,null,450,{"$f":"ROUND(NORMINV(RAND(),10,3),0)","v":8}]
[null,null,null,null,null,451,11]
[null,null,null,null,null,452,12]
[null,null,null,null,null,453,11]
[null,null,null,null,null,454,7]
[null,null,null,null,null,455,9]
[null,null,null,null,null,456,15]
[null,null,null,null,null,457,7]
[null,null,null,null,null,458,3]
[null,null,null,null,null,459,10]
[null,null,null,null,null,460,8]
[null,null,null,null,null,461,16]
[null,null,null,null,null,462,12]
[null,null,null,null,null,463,10]
[null,null,null,null,null,464,9]
[null,null,null,null,null,465,14]
[null,null,null,null,null,466,16]
[null,null,null,null,null,467,13]
[null,null,null,null,null,468,14]
[null,null,null,null,null,469,9]
[null,null,null,null,null,470,9]
[null,null,null,null,null,471,8]
[null,null,null,null,null,472,9]
[null,null,null,null,null,473,9]
[null,null,null,null,null,474,9]
[null,null,null,null,null,475,12]
[null,null,null,null,null,476,9]
[null,null,null,null,null,477,7]
[null,null,null,null,null,478,7]
[null,null,null,null,null,479,10]
[null,null,null,null,null,480,12]
[null,null,null,null,null,481,8]
[null,null,null,null,null,482,5]
[null,null,null,null,null,483,13]
[null,null,null,null,null,484,5]
[null,null,null,null,null,485,17]
[null,null,null,null,null,486,10]
[null,null,null,null,null,487,10]
[null,null,null,null,null,488,6]
[null,null,null,null,null,489,9]
[null,null,null,null,null,490,9]
[null,null,null,null,null,491,8]
[null,null,null,null,null,492,12]
[null,null,null,null,null,493,13]
[null,null,null,null,null,494,8]
[null,null,null,null,null,495,14]
[null,null,null,null,null,496,10]
[null,null,null,null,null,497,12]
[null,null,null,null,null,498,8]
[null,null,null,null,null,499,13]
[null,null,null,null,null,500,11]

{"sheet":"Page4","index":6,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Valeur aléatoire d'une liste"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
["Explication"]
[null,"Dans l'exemple, je souhaite choisir une région au harsard."]
[]
[null,null,null,null,null,"Régions"]
[null,null,null,null,null,"NORD"]
[null,null,null,null,null,"SUD"]
[null,null,null,null,null,"OUEST"]
[null,null,null,null,null,"EST"]
[]
[null,"Notre liste contient 4 valeurs. Il nous faut donc choisir entre la 1ère, la seconde, la troisième our la quatrième."]
[null,"En utilisant la INDEX, nous allons pouvoir choisir une valeur dans une liste en fonction de son numéro:"]
[]
[null,null,null,null,null,"Ligne: ",2,{"$f":"INDEX( $F$10:$F$13, Numéro)","v":"SUD"},{"$f":"_xlfn.FORMULATEXT(H18)","v":"=INDEX( $F$10:$F$13; Numéro)"}]
[]
[null,null,null,null,null,null,"Numéro Aléatoire:",{"$f":"1 + INT( 4 * RAND() )","v":1},{"$f":"_xlfn.FORMULATEXT(H20)","v":"=1 + ENT( 4 * ALEA() )"}]
[null,null,null,null,null,null,"Région:",{"$f":"INDEX( $F$10:$F$13, H20 )","v":"NORD"},{"$f":"_xlfn.FORMULATEXT(H21)","v":"=INDEX( $F$10:$F$13; H20 )"}]
[]
[null,null,null,null,null,null,"En combinant:",{"$f":"INDEX( $F$10:$F$13, 1 + INT( 4 * RAND() ) )","v":"NORD"},{"$f":"_xlfn.FORMULATEXT(H23)","v":"=INDEX( $F$10:$F$13; 1 + ENT( 4 * ALEA() ) )"}]
[]
[null,null,null,null,null,null,"Tapez F9 pour faire un nouveau tirage !"]

{"sheet":"Page5","index":7,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Valeur aléatoire d'une liste en fonction d'une autre valeur"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
["Explication"]
[null,"Nous allons compliquer un peu en choisissant une ville d'après une région."]
[]
[null,null,null,null,null,"Région:",{"$f":"INDEX( Région, 1 + INT( 4 * RAND() ) )","v":"SUD"},"è",{"$f":"INDEX(OFFSET($F$14,MATCH(RegionChoisie,ColonneRegions,0),1,COUNTIF(ColonneRegions,RegionChoisie),1),INT(1+COUNTIF(ColonneRegions,RegionChoisie)*RAND()))","v":"Marseilles"}]
[]
[null,"Il nous faut tout d'abord créer le tableau permettant de lier une ville à une région."]
[null,"La particularité est qu'il faut que les régions soit à la suite. Nous ne pouvons pas mettre par exemple le NORD, puis le SUD puis à nouveau le NORD."]
[]
[null,null,null,null,null,"Région","Ville",null,"Ville au hasard:"]
[null,null,null,null,null,"EST","Grenoble"]
[null,null,null,null,null,"EST","Lyon",null,{"$f":"INDEX(OFFSET($F$14,MATCH(RegionChoisie,ColonneRegions,0),1,COUNTIF(ColonneRegions,RegionChoisie),1),INT(1+COUNTIF(ColonneRegions,RegionChoisie)*RAND()))","v":"Nice"}]
[null,null,null,null,null,"EST","Metz",null,{"$f":"_xlfn.FORMULATEXT(I16)","v":"=INDEX(DECALER($F$14;EQUIV(RegionChoisie;ColonneRegions;0);1;NB.SI(ColonneRegions;RegionChoisie);1);ENT(1+NB.SI(ColonneRegions;RegionChoisie)*ALEA()))"}]
[null,null,null,null,null,"EST","Strasbourg"]
[null,null,null,null,null,"NORD","Lille",null,"La formule paraît un peu longue, nous allons la décomposer."]
[null,null,null,null,null,"NORD","Paris",null,"=INDEX(DECALER($F$14;EQUIV(RegionChoisie;ColonneRegions;0);1;NB.SI(ColonneRegions;RegionChoisie);1);ENT(1+NB.SI(ColonneRegions;RegionChoisie)*ALEA()))"]
[null,null,null,null,null,"OUEST","Bordeaux"]
[null,null,null,null,null,"OUEST","Brest",null,"Step1:"]
[null,null,null,null,null,"OUEST","Nantes",null,"Définir la plage dans laquelle il faut chercher."]
[null,null,null,null,null,"OUEST","Rennes",null,"Nous utiliserons la fonction DECALER."]
[null,null,null,null,null,"OUEST","Toulouse"]
[null,null,null,null,null,"SUD","Aix-En-Provence"]
[null,null,null,null,null,"SUD","Marseilles",null,"On se positionne dans réf: F14"]
[null,null,null,null,null,"SUD","Nice",null,"Puis on se déplace jusqu'à trouver la première occurrence de la région: EQUIV(RegionChoisie;ColonneRegions;0)"]
[null,null,null,null,null,null,null,null,"On se déplace de 1 vers la droite."]
[null,null,null,null,null,null,null,null,"La hauteur de la plage doit correspondre au nombre de valeurs pour la région: NB.SI(ColonneRegions;RegionChoisie)"]
[]
[null,null,null,null,null,null,null,null,"Step2:"]
[null,null,null,null,null,null,null,null,"Nous allons à présent choisir une valeur au hasard."]
[null,null,null,null,null,null,null,null,"Nous savons que la valeur doit être comprise entre 1 et le nombre de villes pour cette région: NB.SI(ColonneRegions;RegionChoisie)"]
[null,null,null,null,null,null,null,null,"D'où la formule suivante:"]
[null,null,null,null,null,null,null,null,null,"ENT(1+NB.SI(ColonneRegions;RegionChoisie)*ALEA())"]

{"sheet":"Page6","index":8,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"1. Six façons d'utiliser la fonction Alea()"]
[null,"Aléa entre des dates"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
["Explication"]
[null,"A présent, nous souhaitons trouver une date au hasard qui serait comprise entre deux dates:"]
[]
[null,null,null,null,null,"Date début:","2015-01-01"]
[null,null,null,null,null,"Date fin:","2015-12-31"]
[]
[null,null,null,null,null,"Date au hasard:",{"$f":" (DateDebut) + INT( (DateFin - DateDebut + 1) * RAND() )","v":"2015-01-01"},{"$f":"_xlfn.FORMULATEXT(G12)","v":"= (DateDebut) + ENT( (DateFin - DateDebut + 1) * ALEA() )"}]
[]
[null,"Si nous reprenons notre premier exemple:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notre minimum est la date de début."]
[null,"Le nombre de possibilités est la différence entre la date de fin et la date de début à laquelle il faut ajouter 1"]

{"sheet":"S2_SC","index":9,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"E8","v":"Cas d'utilisation"}]
[]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
[]
[]
[null,null,null,null,"Cas d'utilisation"]
[null,null,null,null,"Section 2"]
[]
[]
[null,null,null,null,{"$f":"\"Section \" & E8","v":"Section Cas d'utilisation"}]
[null,null,null,null,"-","Jeu de Poker"]
[null,null,null,null,"-","Monte Carlo - Lancer n fois"]

{"sheet":"Poker","index":10,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"2. Cas d'utilisation"]
[null,"Jeu de poker"]
[null,"&",null,"Home"]
[null,"é","ç","è",null,null,null,1,2,3,4,5,null,null,null,null,null,null,null,6,7,8,9,10]
[null,null,null,null,null,null,null,"JOUEUR 1",null,null,null,{"$f":"INDEX(G19:G28,MATCH(Q29,F19:F28,0)) & \" (\" & INDEX(LU_Carte,MATCH(Poker!P29,LU_Carte_Rang,0)) & \")\"","v":"Carte plus haute (10)"},null,null,null,null,null,null,null,"JOUEUR 2",null,null,null,{"$f":"INDEX(G19:G28,MATCH(AC29,F19:F28,0)) & \" (\" & INDEX(LU_Carte,MATCH(AB29,LU_Carte_Rang,0)) & \")\"","v":"Paire (Valet)"}]
[]
[null,null,null,null,null,null,null,"♠ ","♣ ","♦","♥","♥","♠ ","♥","♠ ","♣ ","♣ ",null,null,"♥","♦","♣ ","♦","♣ "]
[null,null,null,null,null,null,"Cartes","10♠ ","7♣ ","3♦","4♥","6♥",null,null,null,null,null,null,null,"V♥","7♦","D♣ ","V♦","4♣ "]
[null,null,null,null,null,null,null,{"$f":"MATCH(H7,LU_Couleur_Abrev,0)","v":4},{"$f":"MATCH(I7,LU_Couleur_Abrev,0)","v":3},{"$f":"MATCH(J7,LU_Couleur_Abrev,0)","v":1},{"$f":"MATCH(K7,LU_Couleur_Abrev,0)","v":2},{"$f":"MATCH(L7,LU_Couleur_Abrev,0)","v":2},null,null,null,null,null,null,null,{"$f":"MATCH(T7,LU_Couleur_Abrev,0)","v":2},{"$f":"MATCH(U7,LU_Couleur_Abrev,0)","v":1},{"$f":"MATCH(V7,LU_Couleur_Abrev,0)","v":3},{"$f":"MATCH(W7,LU_Couleur_Abrev,0)","v":1},{"$f":"MATCH(X7,LU_Couleur_Abrev,0)","v":3}]
[null,null,null,null,null,null,"Abrev",{"$f":"IF(LEFT(H8,2)=\"10\",\"10\",LEFT(H8,1))","v":"10"},{"$f":"IF(LEFT(I8,2)=\"10\",\"10\",LEFT(I8,1))","v":"7"},{"$f":"IF(LEFT(J8,2)=\"10\",\"10\",LEFT(J8,1))","v":"3"},{"$f":"IF(LEFT(K8,2)=\"10\",\"10\",LEFT(K8,1))","v":"4"},{"$f":"IF(LEFT(L8,2)=\"10\",\"10\",LEFT(L8,1))","v":"6"},null,null,null,null,null,null,null,{"$f":"IF(LEFT(T8,2)=\"10\",\"10\",LEFT(T8,1))","v":"V"},{"$f":"IF(LEFT(U8,2)=\"10\",\"10\",LEFT(U8,1))","v":"7"},{"$f":"IF(LEFT(V8,2)=\"10\",\"10\",LEFT(V8,1))","v":"D"},{"$f":"IF(LEFT(W8,2)=\"10\",\"10\",LEFT(W8,1))","v":"V"},{"$f":"IF(LEFT(X8,2)=\"10\",\"10\",LEFT(X8,1))","v":"4"}]
[null,null,null,null,null,null,"Rang",{"$f":"INDEX(LU_Carte_Rang,MATCH(H10,LU_Carte_Abrev,0))","v":10},{"$f":"INDEX(LU_Carte_Rang,MATCH(I10,LU_Carte_Abrev,0))","v":7},{"$f":"INDEX(LU_Carte_Rang,MATCH(J10,LU_Carte_Abrev,0))","v":3},{"$f":"INDEX(LU_Carte_Rang,MATCH(K10,LU_Carte_Abrev,0))","v":4},{"$f":"INDEX(LU_Carte_Rang,MATCH(L10,LU_Carte_Abrev,0))","v":6},null,null,null,null,null,null,null,{"$f":"INDEX(LU_Carte_Rang,MATCH(T10,LU_Carte_Abrev,0))","v":11},{"$f":"INDEX(LU_Carte_Rang,MATCH(U10,LU_Carte_Abrev,0))","v":7},{"$f":"INDEX(LU_Carte_Rang,MATCH(V10,LU_Carte_Abrev,0))","v":12},{"$f":"INDEX(LU_Carte_Rang,MATCH(W10,LU_Carte_Abrev,0))","v":11},{"$f":"INDEX(LU_Carte_Rang,MATCH(X10,LU_Carte_Abrev,0))","v":4}]
[null,null,null,null,null,null,"Occurrences",{"$f":"RANK(H11,$H$11:$L$11)","v":1},{"$f":"RANK(I11,$H$11:$L$11)","v":2},{"$f":"RANK(J11,$H$11:$L$11)","v":5},{"$f":"RANK(K11,$H$11:$L$11)","v":4},{"$f":"RANK(L11,$H$11:$L$11)","v":3},null,null,null,null,null,null,null,{"$f":"RANK(T11,$T$11:$X$11)","v":2},{"$f":"RANK(U11,$T$11:$X$11)","v":4},{"$f":"RANK(V11,$T$11:$X$11)","v":1},{"$f":"RANK(W11,$T$11:$X$11)","v":2},{"$f":"RANK(X11,$T$11:$X$11)","v":5}]
[null,null,null,null,null,null,"Rang2",{"$f":"COUNTIF(OFFSET(H12,0,1,1,4),H12)+H12","v":1},{"$f":"COUNTIF(OFFSET(I12,0,1,1,4),I12)+I12","v":2},{"$f":"COUNTIF(OFFSET(J12,0,1,1,4),J12)+J12","v":5},{"$f":"COUNTIF(OFFSET(K12,0,1,1,4),K12)+K12","v":4},{"$f":"COUNTIF(OFFSET(L12,0,1,1,4),L12)+L12","v":3},null,null,null,null,null,null,null,{"$f":"COUNTIF(OFFSET(T12,0,1,1,4),T12)+T12","v":3},{"$f":"COUNTIF(OFFSET(U12,0,1,1,4),U12)+U12","v":4},{"$f":"COUNTIF(OFFSET(V12,0,1,1,4),V12)+V12","v":1},{"$f":"COUNTIF(OFFSET(W12,0,1,1,4),W12)+W12","v":2},{"$f":"COUNTIF(OFFSET(X12,0,1,1,4),X12)+X12","v":5}]
[null,null,null,null,null,null,"Zone de calcul",1,2,3,4,5,null,null,null,null,null,null,null,1,2,3,4,5]
[]
[null,null,null,null,null,null,"Cartes triées",{"$f":"INDEX($H$8:$L$8,MATCH(H14,$H$13:$L$13,0))","v":"10♠ "},{"$f":"INDEX($H$8:$L$8,MATCH(I14,$H$13:$L$13,0))","v":"7♣ "},{"$f":"INDEX($H$8:$L$8,MATCH(J14,$H$13:$L$13,0))","v":"6♥"},{"$f":"INDEX($H$8:$L$8,MATCH(K14,$H$13:$L$13,0))","v":"4♥"},{"$f":"INDEX($H$8:$L$8,MATCH(L14,$H$13:$L$13,0))","v":"3♦"},null,null,null,null,null,null,null,{"$f":"INDEX($T$8:$X$8,MATCH(T14,$T$13:$X$13,0))","v":"D♣ "},{"$f":"INDEX($T$8:$X$8,MATCH(U14,$T$13:$X$13,0))","v":"V♦"},{"$f":"INDEX($T$8:$X$8,MATCH(V14,$T$13:$X$13,0))","v":"V♥"},{"$f":"INDEX($T$8:$X$8,MATCH(W14,$T$13:$X$13,0))","v":"7♦"},{"$f":"INDEX($T$8:$X$8,MATCH(X14,$T$13:$X$13,0))","v":"4♣ "}]
[]
[null,null,null,null,null,"Score","Mains possibles",null,null,null,null,null,null,null,null,null,"Vrai / Faux",null,null,null,null,null,null,null,null,null,null,null,"Vrai / Faux",null,"Meilleur"]
[null,null,null,null,null,10,"Flush Royale",{"$f":"H28","v":10},null,null,null,null,null,null,null,{"$f":"H19","v":10},{"$f":"AND(Q20,H19=14)","v":false},null,null,{"$f":"T28","v":12},null,null,null,null,null,null,null,{"$f":"T19","v":12},{"$f":"AND(AC20,T19=14)","v":false},null,0]
[null,null,null,null,null,9,"Quinte Flush",{"$f":"H28","v":10},null,null,null,null,null,null,null,{"$f":"H20","v":10},{"$f":"AND(Q23,Q24)","v":false},null,null,{"$f":"T28","v":12},null,null,null,null,null,null,null,{"$f":"T20","v":12},{"$f":"AND(AC23,AC24)","v":false},null,{"$f":"IF(P20>AB20,1,IF(P20=AB20,0,2))","v":2}]
[null,null,null,null,null,8,"Carré",{"$f":"COUNTIF($H$28:$M$28,H28)","v":1},{"$f":"COUNTIF($H$28:$M$28,I28)","v":1},1,1,1,null,null,null,{"$f":"IFERROR(INDEX(H28:L28,MATCH(4,H21:L21,0)),0)","v":0},{"$f":"IF(COUNTIF(H21:L21,4)=4,TRUE,FALSE)","v":false},null,null,{"$f":"COUNTIF($T$28:$X$28,T28)","v":1},{"$f":"COUNTIF($T$28:$X$28,U28)","v":2},2,1,1,null,null,null,{"$f":"IFERROR(INDEX(T28:X28,MATCH(4,T21:X21,0)),0)","v":0},{"$f":"IF(COUNTIF(T21:X21,4)=4,TRUE,FALSE)","v":false},null,0]
[null,null,null,null,null,7,"Full",{"$f":"COUNTIF($H$28:$M$28,H28)","v":1},{"$f":"COUNTIF($H$28:$M$28,I28)","v":1},1,1,1,null,null,null,{"$f":"IFERROR(INDEX(H28:L28,MATCH(2,H22:L22,0)),0)","v":0},{"$f":"AND(Q25,Q27)","v":false},null,null,{"$f":"COUNTIF($T$28:$X$28,T28)","v":1},{"$f":"COUNTIF($T$28:$X$28,U28)","v":2},2,1,1,null,null,null,{"$f":"IFERROR(INDEX(T28:X28,MATCH(2,T22:X22,0)),0)","v":11},{"$f":"AND(AC25,AC27)","v":false},null,2]
[null,null,null,null,null,6,"Couleur",{"$f":"H9","v":4},{"$f":"I9","v":3},1,2,{"$f":"L9","v":2},null,null,null,{"$f":"H23","v":4},{"$f":"IF(AND(H23=I23,I23=J23,J23=K23,K23=L23),TRUE,FALSE)","v":false},null,null,{"$f":"T9","v":2},{"$f":"U9","v":1},3,1,{"$f":"X9","v":3},null,null,null,{"$f":"T23","v":2},{"$f":"IF(AND(T23=U23,U23=V23,V23=W23,W23=X23),TRUE,FALSE)","v":false},null,1]
[null,null,null,null,null,5,"Quinte",{"$f":"IF(AND($H$28=14,$L$28=2),MAX(OFFSET(H28,0,1,1,4)),H28)","v":10},{"$f":"IF(AND($H$28=14,$L$28=2),MAX(OFFSET(I28,0,1,1,4)),I28)","v":7},6,4,{"$f":"IF(AND($H$28=14,$L$28=2),1,L28)","v":3},null,null,null,{"$f":"H24","v":10},{"$f":"IF(AND(H24=I24+1,I24=J24+1,J24=K24+1,K24=L24+1),TRUE,FALSE)","v":false},null,null,{"$f":"IF(AND($T$28=14,$X$28=2),MAX(OFFSET(T28,0,1,1,4)),T28)","v":12},{"$f":"IF(AND($T$28=14,$X$28=2),MAX(OFFSET(U28,0,1,1,4)),U28)","v":11},11,7,{"$f":"IF(AND($T$28=14,$X$28=2),1,X28)","v":4},null,null,null,{"$f":"T24","v":12},{"$f":"IF(AND(T24=U24+1,U24=V24+1,V24=W24+1,W24=X24+1),TRUE,FALSE)","v":false},null,2]
[null,null,null,null,null,4,"Brelan",{"$f":"COUNTIF($H$28:$M$28,H28)","v":1},{"$f":"COUNTIF($H$28:$M$28,I28)","v":1},{"$f":"COUNTIF($H$28:$M$28,J28)","v":1},{"$f":"COUNTIF($H$28:$M$28,K28)","v":1},{"$f":"COUNTIF($H$28:$M$28,L28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($H$28:$L$28,MATCH(3,H25:L25,0)),0)","v":0},{"$f":"COUNTIF(H25:L25,3)=3","v":false},null,null,{"$f":"COUNTIF($T$28:$X$28,T28)","v":1},{"$f":"COUNTIF($T$28:$X$28,U28)","v":2},{"$f":"COUNTIF($T$28:$X$28,V28)","v":2},{"$f":"COUNTIF($T$28:$X$28,W28)","v":1},{"$f":"COUNTIF($T$28:$X$28,X28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($T$28:$X$28,MATCH(3,T25:X25,0)),0)","v":0},{"$f":"COUNTIF(T25:X25,3)=3","v":false},null,0]
[null,null,null,null,null,3,"2 paires",{"$f":"COUNTIF($H$28:$M$28,H28)","v":1},{"$f":"COUNTIF($H$28:$M$28,I28)","v":1},{"$f":"COUNTIF($H$28:$M$28,J28)","v":1},{"$f":"COUNTIF($H$28:$M$28,K28)","v":1},{"$f":"COUNTIF($H$28:$M$28,L28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($H$28:$L$28,MATCH(2,H26:L26,0)),0)","v":0},{"$f":"COUNTIF(H26:L26,2)=4","v":false},null,null,{"$f":"COUNTIF($T$28:$X$28,T28)","v":1},{"$f":"COUNTIF($T$28:$X$28,U28)","v":2},{"$f":"COUNTIF($T$28:$X$28,V28)","v":2},{"$f":"COUNTIF($T$28:$X$28,W28)","v":1},{"$f":"COUNTIF($T$28:$X$28,X28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($T$28:$X$28,MATCH(2,$T$26:$X$26,0)),0)","v":11},{"$f":"COUNTIF(T26:X26,2)=4","v":false},null,{"$f":"IF(P26>AB26,1,IF(P26=AB26,0,2))","v":2}]
[null,null,null,null,null,2,"Paire",{"$f":"COUNTIF($H$28:$M$28,H28)","v":1},{"$f":"COUNTIF($H$28:$M$28,I28)","v":1},{"$f":"COUNTIF($H$28:$M$28,J28)","v":1},{"$f":"COUNTIF($H$28:$M$28,K28)","v":1},{"$f":"COUNTIF($H$28:$M$28,L28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($H$28:$L$28,MATCH(2,$H$27:$L$27,0)),0)","v":0},{"$f":"COUNTIF(H27:L27,2)=2","v":false},null,null,{"$f":"COUNTIF($T$28:$Y$28,T28)","v":1},{"$f":"COUNTIF($T$28:$Y$28,U28)","v":2},{"$f":"COUNTIF($T$28:$Y$28,V28)","v":2},{"$f":"COUNTIF($T$28:$Y$28,W28)","v":1},{"$f":"COUNTIF($T$28:$Y$28,X28)","v":1},null,null,null,{"$f":"IFERROR(INDEX($T$28:$X$28,MATCH(2,$T$27:$X$27,0)),0)","v":11},{"$f":"COUNTIF(T27:X27,2)=2","v":true},null,{"$f":"IF(P27>AB27,1,IF(P27=AB27,0,2))","v":2}]
[null,null,null,null,null,1,"Carte plus haute",{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(H16,2)=\"10\",\"10\",LEFT(H16,1)),LU_Carte_Abrev,0))","v":10},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(I16,2)=\"10\",\"10\",LEFT(I16,1)),LU_Carte_Abrev,0))","v":7},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(J16,2)=\"10\",\"10\",LEFT(J16,1)),LU_Carte_Abrev,0))","v":6},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(K16,2)=\"10\",\"10\",LEFT(K16,1)),LU_Carte_Abrev,0))","v":4},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(L16,2)=\"10\",\"10\",LEFT(L16,1)),LU_Carte_Abrev,0))","v":3},null,null,null,{"$f":"H28","v":10},true,null,null,{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(T16,2)=\"10\",\"10\",LEFT(T16,1)),LU_Carte_Abrev,0))","v":12},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(U16,2)=\"10\",\"10\",LEFT(U16,1)),LU_Carte_Abrev,0))","v":11},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(V16,2)=\"10\",\"10\",LEFT(V16,1)),LU_Carte_Abrev,0))","v":11},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(W16,2)=\"10\",\"10\",LEFT(W16,1)),LU_Carte_Abrev,0))","v":7},{"$f":"INDEX(LU_Carte_Rang,MATCH(IF(LEFT(X16,2)=\"10\",\"10\",LEFT(X16,1)),LU_Carte_Abrev,0))","v":4},{"$f":"IF(LEFT(Y16,2)=\"10\",\"10\",LEFT(Y16,1))","v":""},null,null,{"$f":"T28","v":12},true,null,{"$f":"IF(P28>AB28,1,IF(P28=AB28,0,2))","v":2}]
[null,null,null,null,null,null,"Résultat",null,null,null,null,null,null,null,null,{"$f":"INDEX(P19:P28,MATCH(TRUE,Q19:Q28,0))","v":10},{"$f":"INDEX($F$19:$F$28,MATCH(TRUE,Q19:Q28,0))","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(AB19:AB28,MATCH(TRUE,AC19:AC28,0))","v":11},{"$f":"INDEX($F$19:$F$28,MATCH(TRUE,AC19:AC28,0))","v":2},null,{"$f":"IF(Q29=0,0,IF(Q29=AC29,INDEX($AE$19:$AE$28,MATCH(Q29,F19:F28,0))))","v":false}]
[]
[]
[null,null,null,"Num Carte:",{"$f":"INDEX(LU_Carte_Abrev,1+13*RAND())","v":"10"},null,"GAGNANT",{"$f":"CHOOSE(P32+1,\"Nul\",\"Joueur 1\", \"Joueur 2\")","v":"Joueur 2"},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Q29+AC29+AE29),-1,IF(Q29=AC29,AE29,IF(Q29>AC29,1,2)))","v":2}]
[null,null,null,"Couleur:",{"$f":"INDEX(LU_Couleur_Abrev,1+4*RAND())","v":"♣ "},null,"Meilleure main",{"$f":"INDEX(G19:G28,MATCH(P33,F19:F28,0))","v":"Paire"},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Q29+AC29),-1,MAX(Q29,AC29))","v":2}]
[null,null,null,"Carte:",{"$f":"E32&E33","v":"10♣ "}]

{"sheet":"MonteCarlo","index":11,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"2. Cas d'utilisation"]
[null,"Monte Carlo - Lancer n fois"]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
[null,"Lors d'un prochain article…"]

{"sheet":"Annex_SC","index":12,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"E8","v":"Annexe"}]
[]
[null,"&",null,"Home"]
[null,"é","ç","è"]
[]
[]
[]
[null,null,null,null,"Annexe"]
[null,null,null,null,"Section 3"]
[]
[]
[null,null,null,null,{"$f":"\"Section \" & E8","v":"Section Annexe"}]
[null,null,null,null,"-","Mises à jour"]
[null,null,null,null,"-","Lookup"]
[null,null,null,null,"-","Impression documents"]

{"sheet":"Updates","index":13,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Annex"]
[null,"Historique des mises à jour"]
[null,"&","O","Home"]
[null,"é","ç","è"]
[]
[null,null,null,null,null,"Date","Version","Who?","Description"]
[null,null,null,null,null,"2015-12-02","1.0","Jérémy LAPLAINE","Initialisation du document"]

{"sheet":"Lookup","index":14,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[null,"Annex"]
[null,"Lookup"]
[null,"&","O","Home"]
[null,"é","ç","è"]
[]
[null,null,null,"Yes / No"]
[]
[null,null,null,null,null,"LU_YesNo"]
[null,null,null,null,null,"Oui"]
[null,null,null,null,null,"Non"]
[]
[]
[null,null,null,"Holidays"]
[]
[null,null,null,null,null,{"$f":"TODAY()","v":"2015-12-03"}]
[null,null,null,null,null,{"$f":"YEAR(F15)","v":2015}]
[]
[null,null,null,null,null,"LU_French_Holidays"]
[null,null,null,null,null,{"$f":"DATE(Année,1,1)","v":"2015-01-01"}]
[null,null,null,null,null,{"$f":"FLOOR(DAY(MINUTE(Année/38)/2+56)&\"/5/\"&Année,7)-34","v":"2015-04-05"}]
[null,null,null,null,null,{"$f":"F20+1","v":"2015-04-06"}]
[null,null,null,null,null,{"$f":"F20+39","v":"2015-05-14"}]
[null,null,null,null,null,{"$f":"F22+10","v":"2015-05-24"}]
[null,null,null,null,null,{"$f":"F23+1","v":"2015-05-25"}]
[null,null,null,null,null,{"$f":"DATE(Année,5,1)","v":"2015-05-01"}]
[null,null,null,null,null,{"$f":"F25+7","v":"2015-05-08"}]
[null,null,null,null,null,{"$f":"DATE(Année,7,14)","v":"2015-07-14"}]
[null,null,null,null,null,{"$f":"DATE(Année,8,15)","v":"2015-08-15"}]
[null,null,null,null,null,{"$f":"DATE(Année,11,1)","v":"2015-11-01"}]
[null,null,null,null,null,{"$f":"DATE(Année,11,11)","v":"2015-11-11"}]
[null,null,null,null,null,{"$f":"DATE(Année,12,25)","v":"2015-12-25"}]
[null,null,null,null,null,{"$f":"DATE(Année+1,1,1)","v":"2016-01-01"}]
[null,null,null,null,null,{"$f":"FLOOR(DAY(MINUTE((Année+1)/38)/2+56)&\"/5/\"&(Année+1),7)-34","v":"2016-03-27"}]
[null,null,null,null,null,{"$f":"F33+1","v":"2016-03-28"}]
[null,null,null,null,null,{"$f":"F33+39","v":"2016-05-05"}]
[null,null,null,null,null,{"$f":"F35+10","v":"2016-05-15"}]
[null,null,null,null,null,{"$f":"F36+1","v":"2016-05-16"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),5,1)","v":"2016-05-01"}]
[null,null,null,null,null,{"$f":"F38+7","v":"2016-05-08"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),7,14)","v":"2016-07-14"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),8,15)","v":"2016-08-15"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),11,1)","v":"2016-11-01"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),11,11)","v":"2016-11-11"}]
[null,null,null,null,null,{"$f":"DATE((Année+1),12,25)","v":"2016-12-25"}]
[]
[null,null,null,"Couleurs"]
[]
[null,null,null,null,null,"LU_Couleur","LU_Couleur_Abrev"]
[null,null,null,null,null,"Carreau ♦","♦",null,"♣ "]
[null,null,null,null,null,"Coeur ♥","♥",null,{"$f":"MATCH(I49,LU_Couleur_Abrev,0)","v":3}]
[null,null,null,null,null,"Trèfle ♣ ","♣ "]
[null,null,null,null,null,"Pique ♠ ","♠ "]
[]
[]
[null,null,null,"Cartes"]
[]
[null,null,null,null,null,"LU_Carte","LU_Carte_Rang","LU_Carte_Abrev"]
[null,null,null,null,null,"As",14,"A"]
[null,null,null,null,null,"Roi",13,"R"]
[null,null,null,null,null,"Dame",12,"D"]
[null,null,null,null,null,"Valet",11,"V"]
[null,null,null,null,null,10,10,"10"]
[null,null,null,null,null,9,9,"9"]
[null,null,null,null,null,8,8,"8"]
[null,null,null,null,null,7,7,"7"]
[null,null,null,null,null,6,6,"6"]
[null,null,null,null,null,5,5,"5"]
[null,null,null,null,null,4,4,"4"]
[null,null,null,null,null,3,3,"3"]
[null,null,null,null,null,2,2,"2"]

{"sheet":"Print_Sheets","index":15,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Annex"]
[null,"Impression feuilles"]
[null,"&","O","Home"]
[null,"é","ç"]
[]
[null,null,null,null,null,"Sheet","Print?"]
[null,null,null,null,null,"HOME","Non"]
[null,null,null,null,null,"Contents","Non"]
[null,null,null,null,null,"S1_SC","Non"]
[null,null,null,null,null,"Page1","Non"]
[null,null,null,null,null,"Page2","Non"]
[null,null,null,null,null,"Page3_SC","Non"]
[null,null,null,null,null,"Annex_SC","Non"]
[null,null,null,null,null,"Updates","Non"]
[null,null,null,null,null,"Lookup","Non"]
[null,null,null,null,null,"Annex2","Non"]
[null,null,null,null,null,"Print_Sheets","Non"]
[null,null,null,null,null,"Notice","Non"]
[null,null,null,null,null,"Model_SC","Non"]
[null,null,null,null,null,"Model_Page","Non"]
[null,null,null,null,null,"Model_Page_SC","Non"]