{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Caratula","9.1 Simulado","9.1 Muchas Iteraciones","9.1 Analitico"],"not_rendered":{"charts":0,"images":1,"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":"Caratula","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"9.1 Simulado","index":1,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["F/I","B","R","M"]
[null,0,0,0,"B"]
[null,0.3,0.1,0.05,"R"]
[null,0.9,0.7,0.45,"M"]
[null,1,1,1]
[]
["Resultado Analitico",0.10187128593750001,0.52569836875000009,0.37243034531250008]
[null,null,null,null,null,null,"Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd"]
["P (acum)","B","R","M",null,"Iteracion",0,{"$f":"+G9","v":0},{"$f":"+G9+1","v":1},1,2,2,3,3,4,4,5,5,6,6,7,7]
[null,{"$f":"+COUNTIF($U10:$U$12,B$9)/$F10","v":0},{"$f":"+COUNTIF($U10:$U$12,C$9)/$F10","v":1},{"$f":"+COUNTIF($U10:$U$12,D$9)/$F10","v":0},null,{"$f":"+F11+1","v":3},"B",{"$f":"RAND()","v":0.81868428367238677},{"$f":"IF(G10=\"B\",VLOOKUP(H10,$B$1:$E$5,4,1),IF(G10=\"R\",VLOOKUP(H10,$C$1:$E$5,3,1),IF(G10=\"M\",VLOOKUP(H10,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.63035936852191288},{"$f":"IF(I10=\"B\",VLOOKUP(J10,$B$1:$E$5,4,1),IF(I10=\"R\",VLOOKUP(J10,$C$1:$E$5,3,1),IF(I10=\"M\",VLOOKUP(J10,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.50332852146136664},{"$f":"IF(K10=\"B\",VLOOKUP(L10,$B$1:$E$5,4,1),IF(K10=\"R\",VLOOKUP(L10,$C$1:$E$5,3,1),IF(K10=\"M\",VLOOKUP(L10,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.2889092677092101},{"$f":"IF(M10=\"B\",VLOOKUP(N10,$B$1:$E$5,4,1),IF(M10=\"R\",VLOOKUP(N10,$C$1:$E$5,3,1),IF(M10=\"M\",VLOOKUP(N10,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.78345446538607522},{"$f":"IF(O10=\"B\",VLOOKUP(P10,$B$1:$E$5,4,1),IF(O10=\"R\",VLOOKUP(P10,$C$1:$E$5,3,1),IF(O10=\"M\",VLOOKUP(P10,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},{"$f":"RAND()","v":0.96337286930000621},{"$f":"IF(Q10=\"B\",VLOOKUP(R10,$B$1:$E$5,4,1),IF(Q10=\"R\",VLOOKUP(R10,$C$1:$E$5,3,1),IF(Q10=\"M\",VLOOKUP(R10,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},{"$f":"RAND()","v":5.60575270499718E-2},{"$f":"IF(S10=\"B\",VLOOKUP(T10,$B$1:$E$5,4,1),IF(S10=\"R\",VLOOKUP(T10,$C$1:$E$5,3,1),IF(S10=\"M\",VLOOKUP(T10,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.26099188034732246}]
[null,{"$f":"+COUNTIF($U11:$U$12,B$9)/$F11","v":0},{"$f":"+COUNTIF($U11:$U$12,C$9)/$F11","v":1},{"$f":"+COUNTIF($U11:$U$12,D$9)/$F11","v":0},null,{"$f":"+F12+1","v":2},"B",0.21541790996784149,{"$f":"IF(G11=\"B\",VLOOKUP(H11,$B$1:$E$5,4,1),IF(G11=\"R\",VLOOKUP(H11,$C$1:$E$5,3,1),IF(G11=\"M\",VLOOKUP(H11,$D$1:$E$5,2,1),\"NOTA\")))","v":"B"},4.627454342254067E-2,{"$f":"IF(I11=\"B\",VLOOKUP(J11,$B$1:$E$5,4,1),IF(I11=\"R\",VLOOKUP(J11,$C$1:$E$5,3,1),IF(I11=\"M\",VLOOKUP(J11,$D$1:$E$5,2,1),\"NOTA\")))","v":"B"},0.37748188877475819,{"$f":"IF(K11=\"B\",VLOOKUP(L11,$B$1:$E$5,4,1),IF(K11=\"R\",VLOOKUP(L11,$C$1:$E$5,3,1),IF(K11=\"M\",VLOOKUP(L11,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},0.48112876348616263,{"$f":"IF(M11=\"B\",VLOOKUP(N11,$B$1:$E$5,4,1),IF(M11=\"R\",VLOOKUP(N11,$C$1:$E$5,3,1),IF(M11=\"M\",VLOOKUP(N11,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},0.85824223451983217,{"$f":"IF(O11=\"B\",VLOOKUP(P11,$B$1:$E$5,4,1),IF(O11=\"R\",VLOOKUP(P11,$C$1:$E$5,3,1),IF(O11=\"M\",VLOOKUP(P11,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},9.9234677541985006E-3,{"$f":"IF(Q11=\"B\",VLOOKUP(R11,$B$1:$E$5,4,1),IF(Q11=\"R\",VLOOKUP(R11,$C$1:$E$5,3,1),IF(Q11=\"M\",VLOOKUP(R11,$D$1:$E$5,2,1),\"NOTA\")))","v":"B"},0.56639630067012159,{"$f":"IF(S11=\"B\",VLOOKUP(T11,$B$1:$E$5,4,1),IF(S11=\"R\",VLOOKUP(T11,$C$1:$E$5,3,1),IF(S11=\"M\",VLOOKUP(T11,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},0.64524981084745381]
[null,{"$f":"+COUNTIF($U12:$U$12,B$9)/$F12","v":0},{"$f":"+COUNTIF($U12:$U$12,C$9)/$F12","v":1},{"$f":"+COUNTIF($U12:$U$12,D$9)/$F12","v":0},null,1,"B",0.75307484984499162,"R",0.68881916668079346,"R",0.81888910164722428,"M",0.3140393309824917,"R",0.69621701510688205,"R",0.21863876366561974,"R",0.5065677925733042,"R",1.0991855319334443E-3]

{"sheet":"9.1 Muchas Iteraciones","index":2,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["F/I","B","R","M"]
[null,0,0,0,"B"]
[null,0.3,0.1,0.05,"R"]
[null,0.9,0.7,0.45,"M"]
[null,1,1,1]
[]
["Resultado Analitico",0.10187128593750001,0.52569836875000009,0.37243034531250008]
[null,null,null,null,null,null,"Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd","Est","Rnd"]
["P (acum)","B","R","M",null,"Iteracion",0,{"$f":"+G9","v":0},{"$f":"+G9+1","v":1},1,2,2,3,3,4,4,5,5,6,6,7,7]
[null,0.10288386593920498,0.52672884134705833,0.37038729271373666,null,74414,"B",0.46641437835602684,"R",0.26908283064892757,"R",1.9177726392705541E-2,"B",0.87224904751326071,"R",0.12482215789538031,"R",0.58917538782139012,"R",0.55389230342159623,"R",0.70032023844209079]
[null,0.66666666666666663,0.33333333333333331,0,null,3,"B",0.19865509300884687,"B",0.79061373372811317,"R",0.77362006173994868,"M",0.88122403254909698,"M",0.63272119717917308,"M",0.38224841282418875,"R",5.8639331861909394E-2,"B",3.6412834129817551E-2]
[null,{"$f":"+COUNTIF($U12:$U$13,B$9)/$F12","v":0},{"$f":"+COUNTIF($U12:$U$13,C$9)/$F12","v":1},{"$f":"+COUNTIF($U12:$U$13,D$9)/$F12","v":0},null,{"$f":"+F13+1","v":2},"B",{"$f":"RAND()","v":0.45103945203237561},{"$f":"IF(G12=\"B\",VLOOKUP(H12,$B$1:$E$5,4,1),IF(G12=\"R\",VLOOKUP(H12,$C$1:$E$5,3,1),IF(G12=\"M\",VLOOKUP(H12,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.7282589944724922},{"$f":"IF(I12=\"B\",VLOOKUP(J12,$B$1:$E$5,4,1),IF(I12=\"R\",VLOOKUP(J12,$C$1:$E$5,3,1),IF(I12=\"M\",VLOOKUP(J12,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},{"$f":"RAND()","v":0.88836148735472664},{"$f":"IF(K12=\"B\",VLOOKUP(L12,$B$1:$E$5,4,1),IF(K12=\"R\",VLOOKUP(L12,$C$1:$E$5,3,1),IF(K12=\"M\",VLOOKUP(L12,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},{"$f":"RAND()","v":9.7590788191365685E-2},{"$f":"IF(M12=\"B\",VLOOKUP(N12,$B$1:$E$5,4,1),IF(M12=\"R\",VLOOKUP(N12,$C$1:$E$5,3,1),IF(M12=\"M\",VLOOKUP(N12,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.75558201171260064},{"$f":"IF(O12=\"B\",VLOOKUP(P12,$B$1:$E$5,4,1),IF(O12=\"R\",VLOOKUP(P12,$C$1:$E$5,3,1),IF(O12=\"M\",VLOOKUP(P12,$D$1:$E$5,2,1),\"NOTA\")))","v":"M"},{"$f":"RAND()","v":0.22342243623884472},{"$f":"IF(Q12=\"B\",VLOOKUP(R12,$B$1:$E$5,4,1),IF(Q12=\"R\",VLOOKUP(R12,$C$1:$E$5,3,1),IF(Q12=\"M\",VLOOKUP(R12,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":0.11514352172895426},{"$f":"IF(S12=\"B\",VLOOKUP(T12,$B$1:$E$5,4,1),IF(S12=\"R\",VLOOKUP(T12,$C$1:$E$5,3,1),IF(S12=\"M\",VLOOKUP(T12,$D$1:$E$5,2,1),\"NOTA\")))","v":"R"},{"$f":"RAND()","v":3.356036151847952E-2}]
[null,{"$f":"+COUNTIF($U13:$U$13,B$9)/$F13","v":0},{"$f":"+COUNTIF($U13:$U$13,C$9)/$F13","v":1},{"$f":"+COUNTIF($U13:$U$13,D$9)/$F13","v":0},null,1,"B",0.581474741563616,"R",0.88024357771502493,"M",9.9991686245324618E-2,"R",0.16966720136817248,"R",0.25372734533176478,"R",0.56691852299772805,"R",0.28574472093085945,"R",0.1530578483447832]

{"sheet":"9.1 Analitico","index":3,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"B","R","M",null,null,null,"P0","P1","P2","P3","P4","P5","P6","P7"]
[null,"B",0.3,0.1,0.05,null,null,null,1,{"$f":"+MMULT($C$3:$E$5,I$3:I$5)","v":0.3},{"$f":"+MMULT($C$3:$E$5,J$3:J$5)","v":0.155},{"$f":"+MMULT($C$3:$E$5,K$3:K$5)","v":0.11775000000000001},{"$f":"+MMULT($C$3:$E$5,L$3:L$5)","v":0.10678750000000001},{"$f":"+MMULT($C$3:$E$5,M$3:M$5)","v":0.10334437500000002},{"$f":"+MMULT($C$3:$E$5,N$3:N$5)","v":0.10223346875000001},{"$f":"+MMULT($C$3:$E$5,O$3:O$5)","v":0.10187128593750001}]
[null,"R",0.6,0.6,0.4,null,null,null,0,0.6,0.58000000000000007,0.54700000000000004,0.53295000000000003,0.52794750000000001,0.52625837500000006,0.52569836875000009]
[null,"M",0.1,0.3,0.55000000000000004,null,null,null,0,0.1,0.26500000000000001,0.33525000000000005,0.36026250000000004,0.36870812500000005,0.37150815625000005,0.37243034531250008]