Roulette data

I have created a simple roulette program that just randomizes numbers from 0 to 37 in Row A. I use the number 37 to represent the "double 00". It creates 1000 random numbers in column A.

Bet   Spin   Result   Pot
                      $500       Initial pot
$1      5     Loss    $499       Startng bet $1.00, You spin a 5 and lose since 5 is 12 or less
$2     18     Win     $502       Since you lost your bet doubles. 18 spin. Win 1.5 x bet
$1     24     Win     $503.50    Since you won, you bet $1. You win again 1.5X bet
$1      0     Loss    $502.50    Since you won you bet $1. You lose on 0. You lose $1.00
$2      3     Loss    $500.50    Since you lost youble double bet. You lose again. Loss $2.00
$4      6     Loss    $496.50    Double bet to $4.00. You lose. Loss $4.00
$8      9     Loss    $488.50    Double bet to $8.00. You lose. Loss $8.00
$16    34     Win     $512.50    Double bet to $16.00. You win. Win $24.00
$1     27     Win     $514       Back to base bet since you won. Win $1.00
$1     29     Win     $515       Back to base bet since you won. Win $1.00

I would like to to create column B such that if the random number generated in column A is greater than 12 but less than 37 you win your bet back + 1/2 your bet. In other words if you bet $1.00 you would increase you pot by 50 cents. However if you lost you would then decrease the pot by $2.00 and your next bet would double to $2.00. Each time you won your next be would revert back to $1.00 and start over. This is generally like the doubling ploy many gamblers use. Below is an example of what the spreadsheet would look like:

Staring pot $100


Also I need to revert back to base bet of $1.00 if there are 5loss in a row. Any ideas would be greatly appreciated.