Programing Help Needed plz

Hey guys.

Im really struggling to figure out how to implement some code to get my worksheet to do what I need.

I have a staking plan im working on for a customer that uses a racing system he follows and he needs to automate his result spreedsheet so he doesnt have to input the info manually.

Basically he lays horses on the exchanges.

Example:

Standard stake of £10 to lay horse A at odds of 2.88 if the horse wins he looses £18.80, this £18.80 he then wants to divide by 4 and then include £4.70 into his next 4 bets.

So the standard £10 stake is now £14.70 for the next 4 bets untill the £18.80 is recovered.
Once the £18.80 is recovered it resets back to £10 stakes.

If however he looses again for eg: so £14.70 at odds of 3.25 he looses £33.07. This is then added to the previous loss of 18.80, giving a total loss of £51.87, this new loss is then divided again by 4 (£12.96) and added to the next 4 bets untill the £51.87 is recovered.

I've included a rough sample of a manually calculated plan, but I could do with help on how to make the automated.

Cheers guys.

Steve.