This is the formula from Google Sheet - https://gyazo.com/aa7373a93ff9cab8a28e8faa40ba83e9 and we are trying to make our own EV Won stat with our own breakeven chip EV (48.375). It is similar to Spin EV Won, but differs that it is based on other chip EV. Attached chip EV, Spin EV Won, and NEW EV stat (that we are trying to implement).
Spin EV Won formula:
- Code: Select all
amt_buyin_ttl * ((amt_expected_won_spin / cnt_tourneys) / 1500 * ((1-(amt_fee_spin / amt_buyin_fee_spin)) * 3) - 1)
New EV Won formula we are trying to implement:
- Code: Select all
amt_buyin_ttl * ((amt_expected_won_spin - (cnt_tourneys * 48.375)) / (500 * cnt_tourneys))
- Code: Select all
amt_buyin_curr_conv * ((amt_expected_won_spin - (cnt_tourneys * 48.375)) / (500 * cnt_tourneys)) / 1500
Any help is much appreciated. Thanks!