{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["7$"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"7$","index":0,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10],[2,9,2,10],[3,9,3,10],[1,6,1,7],[18,10,18,12],[19,10,19,12],[20,10,20,12],[12,2,12,4],[12,6,12,7],[12,8,12,12],[13,10,13,12],[14,10,14,12],[15,10,15,12],[16,10,16,12],[17,10,17,12]]}
[]
[null,"PokerStars 7$",null,"шанс выпадения",null,null,"Вводимые параметры",null,null,"Рассчитываемые параметры"]
[null,1,12000,{"$f":"B3/1000000","v":9.9999999999999995E-7},null,null,"Количество спинов","ChipEV",null,"EV ITM, %"]
[null,50,240,{"$f":"B4/1000000","v":5.0000000000000002E-5},{"$nulls":5},{"$f":"($H$4+500)/1500*100","v":33.333333333333329}]
[null,100,120,1E-4]
[null,1000,25,1E-3]
[null,5000,10,5.0000000000000001E-3]
[null,75000,6,7.4999999999999997E-2]
[null,195651,4,0.19565099999999999]
[null,723198,2,0.72319800000000001]
[]
[]
[null,null,"Рассчитываемые параметры (ввести значение ChipEV)",null,null,null,"Вводимые параметры",null,"Рассчитываемые параметры"]
[null,"Множители","Количество спинов (ожидание, окр.)","Количество выйгранных спинов по EV ITM (окр.)","Денежное ожидание $ (SpinEV)",null,"Количество спинов (по факту)","ChipEV за турнир","ITM, ожидаемый из ChipEV, %","Денежное ожидание $ (ChipEV)","Недодача множителей"]
[null,"x2",{"$f":"$G$4*D10","v":0},{"$f":"C15*(($H$4+500)/1500)","v":0},{"$f":"(D15*14)-(C15*7)","v":0},null,null,null,{"$f":"IF(H15<>0,(H15+500)/1500*100,\"-\")","v":"-"},{"$f":"(G15*((H15+500)/1500)*14)-(G15*7)","v":0},{"$f":"IF(OR(C15>=1, G15>=1), ((C15-G15)*-1), 0)","v":0}]
[null,"x4",{"$f":"$G$4*D9","v":0},{"$f":"C16*(($H$4+500)/1500)","v":0},{"$f":"(D16*28)-(C16*7)","v":0},null,null,null,"-",{"$f":"(G16*((H16+500)/1500)*28)-(G16*7)","v":0},{"$f":"IF(OR(C16>=1, G16>=1), ((C16-G16)*-1), 0)","v":0}]
[null,"x6",{"$f":"$G$4*D8","v":0},0,{"$f":"(D17*42)-(C17*7)","v":0},null,null,null,"-",{"$f":"(G17*((H17+500)/1500)*42)-(G17*7)","v":0},0]
[null,"x10",{"$f":"$G$4*D7","v":0},0,{"$f":"(D18*70)-(C18*7)","v":0},null,null,null,"-",{"$f":"(G18*((H18+500)/1500)*70)-(G18*7)","v":0},0]
[null,"x25",{"$f":"$G$4*D6","v":0},0,{"$f":"(D19*175)-(C19*7)","v":0},null,null,null,{"$f":"IF(H19<>0,(H19+500)/1500*100,\"-\")","v":"-"},{"$f":"(G19*((H19+500)/1500)*175)-(G19*7)","v":0},0]
[null,"x120",{"$f":"$G$4*D5","v":0},0,{"$f":"(D20*700)-(C20*3)+(70*(C20-D20))","v":0},null,null,null,"-",{"$f":"(G20*((H20+500)/1500)*840)-(G20*7)","v":0},0]
[null,"x240",{"$f":"$G$4*D4","v":0},0,{"$f":"(D21*1400)-(C21*3)+(140*(C21-D21))","v":0},null,null,null,"-",{"$f":"(G21*((H21+500)/1500)*1680)-(G21*7)","v":0},0]
[null,null,null,"Итого SpinEV с учетом х120 и х240",{"$f":"SUM(E15:E21)","v":0},null,"Всего спинов (для проверки)","Всего ChipEV (для проерки)",null,"Итого ожидание ChipEV","Итого, перебор байинов","Недодача  денег по множителям с учетом EV ITM","Итого  ChipEV +  множители"]
[null,null,null,"Итого SpinEV без учета джеков",{"$f":"SUM(E15:E19)","v":0},null,{"$f":"SUM(G15:G21)","v":0},{"$f":"(G15*H15+G16*H16+G17*H17+G18*H18+G19*H19+G20*H20+G21*H21)/(G15+G16+G17+G18+G19+G20+G21)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(J15:J21)","v":0},{"$f":"(K15*2)+(K16*4)+(K17*6)+(K18*10)+(K19*25)+(K20*120)+(K21*240)","v":0},{"$f":"((K15*2*7*$J$4/100)+(K16*4*7*$J$4/100)+(K17*6*7*$J$4/100)+(K18*10*7*$J$4/100)+(K19*25*7*$J$4/100)+(K20*120*7*$J$4/100)+(K21*240*7*$J$4/100))*-1","v":0},{"$f":"J23+L23","v":0}]