Hi guys,
World cup is around the corner and i'd like to do up a spreadsheet that highlights a persistent profit margin. I've done up a basic version of this. But i'd like there to be a column that highlights how much extra we will need to put in if we wanted the payout for each outcome to be $800. Simple version below.
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
MIN Bet Profit is currently the Bet amount multiplied by the odds deducted by the total "Min BET to target" (Capital).
Would there be a way to ensure the Bet Profit is constantly $800 for each outcome?
World cup is around the corner and i'd like to do up a spreadsheet that highlights a persistent profit margin. I've done up a basic version of this. But i'd like there to be a column that highlights how much extra we will need to put in if we wanted the payout for each outcome to be $800. Simple version below.
MINIMUM | TARGET AMOUNT: | $800 | ||||
Players | ODDs | Your Bet Amount | Your Win Amount | Your Profit | Min BET to Target | Min Target Profit |
Harry Kane | $15 | $20 | $300 | $178 | $53 | $528 |
Luis Suarez | $21 | $25 | $525 | $525 | $38 | $528 |
Higuain | $26 | $15 | $390 | $390 | $31 | $528 |
Timo Werner | $15 | $22 | $330 | $330 | $53 | $528 |
Muller | $34 | $20 | $680 | $680 | $24 | $528 |
Griezmann | $11 | $20 | $220 | $220 | $73 | $528 |
Totals | $122 | $272 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
MIN Bet Profit is currently the Bet amount multiplied by the odds deducted by the total "Min BET to target" (Capital).
Would there be a way to ensure the Bet Profit is constantly $800 for each outcome?