Starting bank $500 you can change to what you like, just copy formulas, if this helps.

Sheet1

	A	B	C	D	E	F	G	H
1	next bet	race	dog	bet	place	price	win/loss	balance
2	10	1	goodthing	$ 10.00	1	3.2	22	522
3	$ 11	2	wins	$ 11	1	5	44	566
4	$ 12	3	dog	$ 12	3	3	-12	554
5	$ 12

Spreadsheet Formulas

Cell Formula A2 =0.02*500 G2 =IF(E2=1,(D2*F2)-D2,-D2) A3 =ROUNDUP(0.02*H2,0) D3 =A3 G3 =IF(E3=1,(D3*F3)-D3,-D3) H3 =H2+G3 A4 =ROUNDUP(0.02*H3,0) D4 =A4 G4 =IF(E4=1,(D4*F4)-D4,-D4) H4 =H3+G4 A5 =ROUNDUP(0.02*H4,0)

Excel tables to the web >> Excel Jeanie HTML 4