This spreadsheet is specially designed to work with roller or challenge bets and shows how banking your original stake as soon as possible in the process can maximise profits and minimise loss.
How to use this sheet
All you have to do on the summary sheet is enter your starting bankroll in cell B:16. You don’t need to touch anything else as it will be automatically done for you from your individual month sheets.
Fill in your bet’s details as you normally would in the date, bet and odds columns.
Then in the ‘Original Stake’ column, enter the stake you are starting your roller with.
Don’t enter anything into the ‘Roller Stake’ column as these will be calculated and filled out automatically for you.
Choose your bet result once the bet is settled and the return will be calculated for you.
Use the ‘Bank’ column to enter any money you have want to remove from your next stake in the roller, e.g. if you started with £5 and you are now in a position where you have doubled your starting stake, take it out by entering ‘5’ into the bank column next to that bet and it will then be removed from your next stake for you.
Once you have finished a roller, enter the result as either “won” or “lost” in the ‘Roller Result’ column, the ‘Roller Profit’ column will be calculated for you automatically.
The notes column is there for things like noting that you cashed out or a leg of the bet was void etc.
All the stats at the top of the sheet will be calculated for you automatically and you don’t have to touch them.
Remember to do File > Make a Copy to save this to your own Google account so that you can edit and use it.