Progression Calculator for dynamic bets (Excel)

[MadMax]

Hello everyone!
Here I want to share my progression calculation sheet with you. I often need progressions, where the numbers of the bets change during progression. (p.e. I bet 4 times 3 straight numbers, than 5 times 4 numbers and so on.) I was searching for a tool to calculate the needed progression for those bets, but couldn´t find one.

So I decided to make one by my own. First I made it only for straight numbers, but as I decided to share it, I have revised it to all chances.
In the sheet, you only have to input things in the yellow fields.
First of all, there is the payout field, where you put in the payout for the chance, you want to have to be calculatet (p.e. 35 for straight numbers, 2 for dozens and so on).
Then there is the "No. of Bets" field. Here you enter the quantity of the bets you want to bet one line beneath the other (p.e. for 2 straight numbers betted you enter 2). In the next column you will be told how much you have to bet to stay in profit after a win. The calculation stops, when you would have to rise your bet over more than 50 units compared with the previous bet. Than you will get the message "Rise >50!".(p.e. this happens, when you calculate the progression for even chances to the 8th step of progression, because it would be the classic Martingale and you would have to raise your bet about 64 units)
The next column shows you the win without the previous losses and the actual stake. The next column shows you the win without any deductions. Then there is a column, where the actual stake would be shown and at least there is also a column, where the total stake will be shown, that was betted during the progression until this stage.
The sheet is reduced to 37 stages of progression. If you need more, you simply have to copy down the formulas (don´t forget the ones in the Prog Calculation sector), there is nothing protected.

I hope, I could explain it clear, but if you use the sheet, it should explain itself.
If you find any error in the calculations or have other questions, please feel free to contact me.
I hope, this will help you a little.
Good luck to all

MadMax

[Chrisbis]

Thanks Max.

Its great when someone goes to this much trouble, for the benefit of EVERYONE here.


Cheers. 

[MadMax]

Thank you Chris for your kind words! 

I do this, because I benefit a lot from the knowledge of these forum and want to give something back.

While I can´t offer a system/strategy to play yet, I like to play around with Excel and try to solve farious problems. For me it´s a naturally thing to share this with others than, when it could help a little. That´s my little share to the big thing! 

[MadMax]

Oh, and by the way, if you can´t write into the sheet:
close it, go to the place, where you have saved the sheet and click it with right mouse button. Here choose properties (I hope, it´s called so in the English Windows, it´s the last option in the list). Remove the check mark at write protection, and it should work!  (also for other sheets)
Just a little hint! 

[ihgl]

Hallo and thanks for a very good bet calculator. My question is. Has anybody possibly seen a bet calculator somewhere where your win amount is the first option. Let us say we bet 1 unit on 5 numbers. At the 7th spin we make 1 unit profit. But from now and on we would like to have 2 units of profit for every coming spin. Next bet will be 1,2 on each number to get 2 units profit and so on. That would be great  - to make the progression starting with the profit you like to have every time you win. It could be anything between 0,1 and 10000   ;-)

[Vittoria]

Just wanted to say thank you for having shared your progression calculation.
Mille grazie

Hello everyone!
Here I want to share my progression calculation sheet with you. I often need progressions, where the numbers of the bets change during progression. (p.e. I bet 4 times 3 straight numbers, than 5 times 4 numbers and so on.) I was searching for a tool to calculate the needed progression for those bets, but couldn´t find one.

So I decided to make one by my own. First I made it only for straight numbers, but as I decided to share it, I have revised it to all chances.
In the sheet, you only have to input things in the yellow fields.
First of all, there is the payout field, where you put in the payout for the chance, you want to have to be calculatet (p.e. 35 for straight numbers, 2 for dozens and so on).
Then there is the "No. of Bets" field. Here you enter the quantity of the bets you want to bet one line beneath the other (p.e. for 2 straight numbers betted you enter 2). In the next column you will be told how much you have to bet to stay in profit after a win. The calculation stops, when you would have to rise your bet over more than 50 units compared with the previous bet. Than you will get the message "Rise >50!".(p.e. this happens, when you calculate the progression for even chances to the 8th step of progression, because it would be the classic Martingale and you would have to raise your bet about 64 units)
The next column shows you the win without the previous losses and the actual stake. The next column shows you the win without any deductions. Then there is a column, where the actual stake would be shown and at least there is also a column, where the total stake will be shown, that was betted during the progression until this stage.
The sheet is reduced to 37 stages of progression. If you need more, you simply have to copy down the formulas (don´t forget the ones in the Prog Calculation sector), there is nothing protected.

I hope, I could explain it clear, but if you use the sheet, it should explain itself.
If you find any error in the calculations or have other questions, please feel free to contact me.
I hope, this will help you a little.
Good luck to all

MadMax