{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["simulation","graphique N=f(t)","modèle","compil des essais"],"not_rendered":{"charts":2,"images":1,"macros":1},"unopened":[{"sheet":"graphique N=f(t)","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"simulation","index":0,"n_rows":55,"n_cols":52,"rows_kept":55,"merged":[[4,12,4,13],[5,21,6,23],[8,22,8,23]]}
["Voici une population de N0 = 1000 dés. La fonction mathématique Alea permet de simuler leur lancement."]
["A chaque tirage de 1000 dés, éliminons les dés qui ont fait un \"1\" "]
["Examinons comment évolue la population N au fil des tirages"]
[]
[{"$nulls":7},"Population initiale",{"$nulls":3},"N0 =",1000,null,"dés"]
[{"$nulls":6},"A chaque tirage, cliquer sur effacer pour supprimer les dés qui ont fait 1,",{"$nulls":14},"Combien de dés reste-t-il ?"]
[{"$nulls":12},"et relancer les dés restant."]
[{"$nulls":8},"Reporter N dans le tableau ci-dessous. Cliquer sur \"entrée\""]
[{"$nulls":21},"N =",{"$f":"1000-COUNTIF(A16:Y55,\"\")","v":1000}]
[]
[]
["tirage",0,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,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["N",1000]
[]
["1000 dés"]
[{"$f":"INT(RAND()*6+1)","v":1},{"$f":"INT(RAND()*6+1)","v":1},5,4,1,3,1,2,6,4,3,4,6,3,2,3,6,1,5,2,1,1,4,6,2]
[{"$f":"INT(RAND()*6+1)","v":2},1,2,5,2,3,4,1,1,3,4,4,2,1,3,5,5,1,3,2,1,5,3,1,2]
[6,1,4,4,6,6,3,1,4,6,1,1,5,4,6,3,2,6,5,3,6,5,6,5,4]
[5,4,5,3,6,1,4,3,1,4,6,3,1,1,3,2,4,6,2,2,1,6,1,4,2]
[2,1,5,2,4,4,2,2,1,2,6,4,3,2,2,2,2,4,4,4,5,1,5,5,3]
[6,3,5,1,2,3,5,3,2,4,5,4,2,6,1,6,6,2,6,1,5,5,3,2,2]
[5,6,1,4,3,3,5,4,3,4,6,6,2,2,2,1,4,4,3,5,5,2,4,3,4]
[6,2,1,6,3,1,2,1,5,6,6,3,2,2,1,5,3,6,6,5,6,1,5,4,5]
[3,4,3,5,2,1,3,3,1,6,1,4,4,2,3,1,2,5,3,3,6,4,6,3,3]
[4,3,2,2,6,5,5,5,2,6,2,6,3,4,5,5,6,1,2,4,5,1,4,4,2]
[1,6,3,2,3,4,1,3,4,2,3,4,4,1,6,1,{"$f":"INT(RAND()*6+1)","v":5},2,2,2,2,4,3,3,2]
[5,1,4,6,4,2,6,4,2,1,2,4,2,1,3,3,2,5,2,3,4,1,1,6,1]
[6,5,3,2,5,4,4,3,6,6,5,3,2,4,2,2,4,4,1,3,4,5,5,3,4]
[1,6,4,6,5,6,6,3,2,6,6,2,3,1,2,6,4,3,2,3,4,6,1,3,1]
[3,4,3,3,3,4,6,2,2,5,2,2,3,5,5,4,1,1,4,2,3,2,4,4,3]
[1,3,5,1,3,6,4,6,3,2,1,1,6,2,2,4,1,5,6,1,3,2,1,4,6]
[4,2,5,5,3,1,6,6,4,4,5,4,6,4,3,5,1,2,6,6,4,2,2,4,6]
[5,6,4,1,3,5,5,3,4,2,1,3,2,1,4,6,5,2,1,3,1,2,6,6,3]
[3,3,4,4,5,4,6,5,6,5,1,1,6,3,5,5,6,3,1,6,1,5,3,2,2]
[2,6,1,5,5,3,6,3,4,1,1,4,3,4,6,2,2,3,3,1,4,2,5,2,1]
[1,3,4,4,5,5,2,4,3,1,2,6,3,2,6,6,1,1,4,2,2,6,5,5,6]
[5,5,5,3,4,1,5,3,1,2,4,6,3,2,1,4,4,2,3,3,6,1,5,2,4]
[6,6,1,4,1,2,1,6,6,3,6,5,5,2,1,1,1,2,1,6,1,3,3,3,2]
[1,2,1,6,6,6,1,4,1,5,3,6,4,4,4,1,3,3,3,1,3,1,5,5,4]
[1,4,4,6,2,3,4,4,4,3,1,3,6,1,3,3,4,3,2,2,3,4,5,1,6]
[2,4,3,1,4,3,2,2,5,2,1,3,5,4,2,6,5,5,6,4,5,3,4,6,4]
[5,2,6,3,1,{"$f":"INT(RAND()*6+1)","v":2},2,1,6,3,4,5,5,1,3,4,1,6,3,6,1,2,5,5,3]
[{"$f":"INT(RAND()*6+1)","v":1},4,2,3,6,6,6,5,3,5,3,6,5,2,3,4,1,4,4,1,3,3,2,2,2]
[5,3,3,3,3,2,2,1,1,6,4,3,4,3,3,4,2,6,6,5,1,5,2,1,2]
[3,4,1,1,1,3,4,2,3,4,1,5,3,2,1,2,4,1,5,4,5,6,4,3,3]
[6,2,1,2,3,5,6,4,2,2,3,6,6,5,4,4,5,3,1,2,5,6,4,4,5]
[5,2,2,3,6,3,5,6,1,6,6,1,2,2,6,6,4,6,3,2,1,4,5,1,2]
[1,2,6,1,1,6,2,2,5,6,5,5,3,2,5,4,3,2,1,4,2,2,2,6,4]
[3,5,4,2,5,1,5,4,3,6,3,1,1,6,3,5,2,5,3,6,2,3,5,3,5]
[1,3,4,1,4,2,6,6,5,4,5,3,6,4,5,2,1,5,3,4,3,3,6,4,6]
[4,6,6,3,1,2,3,6,5,5,1,5,2,1,5,2,1,5,5,6,1,3,1,6,1]
[2,5,6,6,5,6,4,4,1,4,3,3,3,2,3,2,2,5,1,3,6,2,3,1,6]
[2,3,5,3,6,1,6,4,3,4,2,6,5,5,5,5,2,5,6,3,2,6,1,1,6]
[3,2,2,2,3,6,4,6,2,6,2,1,3,4,6,4,5,1,4,4,1,2,6,5,3]
[4,6,4,4,4,1,5,1,5,2,6,6,3,4,1,3,2,2,3,6,1,2,4,4,2]

{"sheet":"modèle","index":2,"n_rows":52,"n_cols":2,"rows_kept":52}
["tirage","N"]
[0,1000]
[1,{"$f":"1000*EXP(-A3/6)","v":846.4817248906141}]
[2,{"$f":"1000*EXP(-A4/6)","v":716.5313105737893}]
[3,606.5306597126335]
[4,513.417119032592]
[5,434.5982085070782]
[6,367.87944117144235]
[7,311.4032239145977]
[8,263.59713811572675]
[9,223.1301601484298]
[10,188.87560283756184]
[11,159.87974607969392]
[12,135.3352832366127]
[13,114.55884399268773]
[14,96.97196786440506]
[15,82.0849986238988]
[16,69.48345122280155]
[17,58.81647164242988]
[18,49.787068367863945]
[19,42.14384350927641]
[20,35.67399334725239]
[21,30.197383422318502]
[22,25.561533206507402]
[23,21.637370719493088]
[24,18.315638888734178]
[25,15.503853599009314]
[26,13.123728736940969]
[27,11.108996538242305]
[28,9.403562551495206]
[29,7.959943848706449]
[30,6.737946999085467]
[31,5.703548998007402]
[32,4.827949993831441]
[33,4.0867714384640665]
[34,3.459377336464758]
[35,2.9282996948181887]
[36,2.4787521766663585]
[37,2.0982184180809025]
[38,1.7761035457343792]
[39,1.5034391929775723]
[40,1.272633801339808]
[41,1.0772612553122203]
[42,0.9118819655545163]
[43,0.7718914190992302]
[44,0.6533919798673806]
[45,0.5530843701478336]
[46,0.4681758116527769]
[47,0.3963022685999061]
[48,0.33546262790251186]
[49,0.28396298390325664]
[50,0.24036947641951406]

{"sheet":"compil des essais","index":3,"n_rows":4,"n_cols":52,"rows_kept":4}
["tirage1",0,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,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["N",1000,821,711,593,490,409,341,282,233,190,164,137,112,93,74,61,50,39,32,21,17,15,12,11,10,6,6,6,5,5,4,2,2,2,2,2,2,2,1,1,1,1,1,0]
["tirage2",0,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,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
["N",1000,845,699,588,484,391,316,267,219,179,150,127,104,82,67,59,45,37,28,24,18,15,10,10,10,10,9,8,8,6,6,5,3,3,3,3,2,2,2,2,2,2,2]