{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["deals"],"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":"deals","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,3,17,4]]}
["Исходные данные",null,null,"1. Бекинг с коэффициентом",null,null,"Вероятности заносов"]
["Лимит",5,null,"Бездисперсионный доход игрока",{"$f":"B17*B5*B2*(B19-1)","v":136.26250000000039},null,null,"%попасть","%выиграть"]
["Рейк",7.0000000000000007E-2,null,"Дисперсионный доход игрока",{"$f":"(1-B17)*B12","v":0},null,"топ1 джекпот",{"$f":"(1-(1-3/1000000)^B5)","v":2.9685894580770977E-3},{"$f":"H3*$B$8","v":1.068692204907755E-3}]
["Рейкбек",0.5,null,"Суммарный ожидаемый доход игрока",{"$f":"SUM(E2:E3)","v":136.26250000000039},null,"топ2 джекпот",{"$f":"(1-(1-50/1000000)^B5)","v":4.8343604836221354E-2},{"$f":"H4*$B$8","v":1.7403697741039687E-2}]
["Дистанция в месяц",991,null,"Доход школы за бекинг и обучение",{"$f":"(B18-B19)*B2*B5*B17","v":58.964500000000108},null,"топ3 джекпот",{"$f":"(1-(1-100/1000000)^B5)","v":9.4352349513083578E-2},3.3966845824710087E-2]
["Оценка ЧипЕВ",40,null,"Распределение ожидания игрок-школа:"]
["Результаты",null,null,"Игрок:",{"$f":"(E2+E3)/B12","v":0.69796954314721027}]
["ИТМ%",{"$f":"(500+B6)/1500","v":0.36},null,"Школа:",{"$f":"E5/B12","v":0.30203045685279251},{"$f":"E8/E7","v":0.43272727272727229}]
["РБ (на игру)",{"$f":"B4*B3*B2","v":0.17500000000000002},null,"2. Бекинг с откатом"]
["Профит за игру",{"$f":"B2*((1-B3)*B6/500-B3)+B9","v":0.19699999999999995},null,"Бездисперсионный доход игрока",0]
["EV ROI, %",{"$f":"B10/B2","v":3.9399999999999991E-2},null,"Ожидание игрока",{"$f":"(1-B17)*B12+B17*B12*(1-B21)","v":136.26250000000002}]
["Ожидание за месяц",{"$f":"B5*B10","v":195.22699999999995},null,"… без топ1 множителя",{"$f":"E11-(B12-B14)*E11/B12","v":91.441129441624355}]
["… из него, рейкбек",{"$f":"B9*B5","v":173.42500000000001},null,"… без топ3 множителей",{"$f":"E11-(B12-B15)*E11/B12","v":61.560215736040604}]
["… без топ1 множителя",{"$f":"B12-(B5*B2*B8/1000000)*(3*12000)","v":131.01019999999994},null,"Доход школы за бекинг и обучение",{"$f":"B12-E11","v":58.96449999999993}]
["… без топ3 множителей",{"$f":"B12-(B5*B2*B8/1000000)*(100*120+50*240+3*12000)","v":88.198999999999955},null,"Распределение ожидания игрок-школа:"]
["Детали сделки",null,null,"Игрок:",{"$f":"E11/B12","v":0.69796954314720838}]
["% пакета в продаже",1,null,"Школа:",{"$f":"(B12-E11)/B12","v":0.30203045685279162},{"$f":"E17/E16","v":0.43272727272727218}]
["Макс. коэффициент на бирже",{"$f":"1+B11","v":1.0394000000000001},null,"3. Бекинг с откатом и дележкой с пулом игроков"]
["…из него, коэффициент игрока",1.0275000000000001,null,"Фактический EV игрока в пуле",{"$f":"B12*B17","v":195.22699999999995}]
[null,null,null,"EV пула",40000]
["Или, откат школы от %в продаже",{"$f":"1-(B19-1)/(B18-1)","v":0.30203045685279162},null,"Профит пула",40000]
[null,null,null,"Комиссия школы за обслуживание пула",0.02]
["EV бекера",{"$f":"-(B18-1-B11)*B5*B2","v":-5.5011550870176507E-13},null,"Профит пула к дележке",{"$f":"E21*(1-E22)","v":39200}]
["Сумма покупки",{"$f":"70*15","v":1050},null,"Доля игрока от профита пула",{"$f":"E19/E20","v":4.8806749999999984E-3}]
["ROI бекера",{"$f":"B23/B24","v":-5.2391953209691912E-16},null,"Профит игрока в пуле",{"$f":"E24*E21","v":195.22699999999995}]
[null,null,null,"Общий профит игрока после отката",{"$f":"(1-B17)*B12+E25*(1-B21)","v":136.26250000000002}]
[null,null,null,"Откат школы",{"$f":"E25*B21","v":58.96449999999993}]
[null,null,null,"Игрок:",{"$f":"E26/B12","v":0.69796954314720838}]
[null,null,null,"Школа:",{"$f":"E27/B12+E22","v":0.32203045685279164},{"$f":"E29/E28","v":0.46138181818181767}]