{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cromos"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Cromos","index":0,"n_rows":266,"n_cols":11,"rows_kept":266,"cut":false,"hidden":false,"merged":[]}
["A.Roldán 2012"]
[null,null,"Colección de cromos",null,null,null,null,null,null,null,"Instrucciones"]
[]
[null,null,null,null,null,null,null,null,null,null,"Cálculo con medias"]
[null,null,"Total de la colección",null,250,null,"Tengo ya",163,null,null,"Rellena las celdas con fondo rosado y pulsa sobre el botón"]
[null,null,null,null,null,null,null,null,null,null,"En la celda \"Tengo ya\" aparecerán los cromos nuevos"]
[null,null,"Vienen en cada sobre",null,5,null,"Me quedan",{"$f":"E5-H5","v":87}]
[null,null,"(No más de 20)",null,null,null,null,null,null,null,"Simulación"]
[null,null,"Probabilidad de repe",null,{"$f":"H5/E5","v":0.65200000000000002},null,"Probabilidad de nuevo",null,{"$f":"1-E9","v":0.34799999999999998},null,"Los datos de la simulación serán los mismos de arriba"]
[null,null,null,null,null,null,null,null,null,null,"El dato de \"tengo ya\" se considera CERO"]
[null,null,null,"Esperanza en un sobre",null,null,{"$f":"E7*I9","v":1.7399999999999998},null,null,null,"Verás con rapidez los cromos que salen en cada sobre"]
[null,null,null,null,null,null,null,null,null,null,"y los contadores de la simulación"]
[null,null,"Sobres comprados",null,170,null,"Total cromos comprados",null,{"$f":"E7*E13","v":850},null,"En la columna B puedes consultar las frecuencias de los cromos."]
[]
["Simulación",null,null,null,null,null,null,null,null,null,"Serie"]
["Cromos que ya tengo",null,null,"Sobre","Tengo","Me faltan","Repes","Máximo repe",null,null,"El número de simulaciones lo fijas en la celda H23"]
[1,3,null,162,242,8,608,{"$f":"MAX(B17:B1082)","v":11},null,null,"Debajo aparecerán los totales y los promedios."]
[2,5,null,54]
[3,3,null,176]
[4,1,null,89]
[5,5,null,248]
[6,2,null,null,"Serie"]
[7,2,null,null,null,null,null,10]
[8,3,null,null,"Totales"]
[9,1,null,null,"Tengo","Me faltan","Repes","Máximo repe"]
[10,6,null,null,2413,87,6087,12]
[11,3,null,null,"Medias"]
[12,2,null,null,"Tengo","Me faltan","Repes","Máximo repe"]
[13,2,null,null,241.3,8.6999999999999993,608.70000000000005,10.6]
[14,1]
[15,2]
[16,3]
[17,2]
[18,3]
[19,2]
[20,1]
[21,4]
[22,3]
[23,4]
[24,6]
[25,4]
[26,2]
[27,1]
[28,4]
[29,6]
[30,4]
[31,3]
[32,3]
[33,4]
[34,5]
[35,3]
[36,4]
[37,5]
[38,5]
[39,2]
[40,0]
[41,2]
[42,3]
[43,5]
[44,1]
[45,4]
[46,4]
[47,7]
[48,5]
[49,4]
[50,3]
[51,4]
[52,3]
[53,6]
[54,6]
[55,4]
[56,3]
[57,2]
[58,2]
[59,3]
[60,3]
[61,4]
[62,2]
[63,5]
[64,2]
[65,4]
[66,4]
[67,4]
[68,0]
[69,3]
[70,4]
[71,5]
[72,5]
[73,6]
[74,0]
[75,1]
[76,4]
[77,4]
[78,2]
[79,4]
[80,5]
[81,1]
[82,3]
[83,4]
[84,6]
[85,9]
[86,4]
[87,4]
[88,5]
[89,1]
[90,1]
[91,1]
[92,6]
[93,2]
[94,3]
[95,2]
[96,4]
[97,4]
[98,2]
[99,4]
[100,7]
[101,3]
[102,2]
[103,6]
[104,3]
[105,2]
[106,1]
[107,3]
[108,1]
[109,8]
[110,3]
[111,4]
[112,3]
[113,3]
[114,4]
[115,0]
[116,3]
[117,3]
[118,3]
[119,2]
[120,2]
[121,4]
[122,1]
[123,4]
[124,2]
[125,3]
[126,2]
[127,4]
[128,4]
[129,7]
[130,3]
[131,6]
[132,2]
[133,4]
[134,5]
[135,3]
[136,4]
[137,3]
[138,3]
[139,1]
[140,2]
[141,2]
[142,5]
[143,3]
[144,2]
[145,3]
[146,5]
[147,5]
[148,6]
[149,2]
[150,5]
[151,3]
[152,3]
[153,3]
[154,6]
[155,8]
[156,2]
[157,0]
[158,4]
[159,4]
[160,3]
[161,4]
[162,4]
[163,0]
[164,3]
[165,1]
[166,1]
[167,1]
[168,3]
[169,2]
[170,3]
[171,4]
[172,6]
[173,5]
[174,9]
[175,4]
[176,3]
[177,5]
[178,2]
[179,2]
[180,3]
[181,2]
[182,1]
[183,3]
[184,7]
[185,6]
[186,2]
[187,1]
[188,1]
[189,6]
[190,5]
[191,3]
[192,1]
[193,3]
[194,0]
[195,3]
[196,1]
[197,9]
[198,8]
[199,4]
[200,5]
[201,3]
[202,1]
[203,6]
[204,3]
[205,4]
[206,2]
[207,2]
[208,1]
[209,5]
[210,2]
[211,11]
[212,6]
[213,5]
[214,6]
[215,3]
[216,2]
[217,5]
[218,1]
[219,2]
[220,3]
[221,5]
[222,4]
[223,1]
[224,0]
[225,3]
[226,7]
[227,6]
[228,2]
[229,7]
[230,3]
[231,7]
[232,2]
[233,2]
[234,4]
[235,2]
[236,6]
[237,2]
[238,3]
[239,1]
[240,4]
[241,3]
[242,4]
[243,1]
[244,5]
[245,4]
[246,2]
[247,2]
[248,3]
[249,4]
[250,3]