Sports Betting Excel Spreadsheet

[Masterz13]

Hello All,

I have recently aquired Excel 2010 and still getting used to.
As the new football season is about to start I am looking to make a Spreadsheet with my football accumilator selections on. I am hoping to have a column with the odds of each bet, and at the bottom a formula which will calculate my accumilated total based on the Bet Placed and the Odds in the columns.

Hope this makes sense, anyone got a spreadsheet I could use, or have an idea for a formula that will do this for me?

Thanks for the help.

 

[Snakehips]

Masterz13,

Not being a betting man I'm not sure if this is what you want but it may give you a start.
Any number of bets up to 8.

Excel 2007
	A	B	C	D	E	F	G
3							Stake
4	No	Prediction	Result	F	/	A	£ 5.00
5	1	Home Win	Home Win	3	/	1	£ 20.00
6	2	Draw	Draw	5	/	1	£ 120.00
7	3	Away Win	Away Win	1	/	2	£ 180.00
8	4	Draw	Draw	1	/	1	£ 360.00
9	5	Draw	Draw	3	/	1	£ 1,440.00
10	6	Away Win	Away Win	2	/	1	£ 4,320.00
11	7				/		£ -
12	8				/		£ -
13				Winnings			£ 4,320.00
Advantage

Cell Formulas
Range	Formula
G5	=IFERROR(IF(B5=C5,G4*((D5/F5)+1),0),0)
G13	=IF(COUNTIF(G5:G12,">0")=COUNTIF(B5:B12,">"""),MAX(G5:G12),0)

If the sequence of bets results in a loss at any point the winnings are zilch!! (Keep your money in your pocket is your best bet!!)

Excel 2007
	A	B	C	D	E	F	G
3							Stake
4	No	Prediction	Result	F	/	A	£ 5.00
5	1	Home Win	Home Win	3	/	1	£ 20.00
6	2	Draw	Draw	5	/	1	£ 120.00
7	3	Away Win	Away Win	1	/	2	£ 180.00
8	4	Draw	Draw	1	/	1	£ 360.00
9	5	Draw	win	3	/	1	£ -
10	6	Away Win	Away Win	2	/	1	£ -
11	7				/		£ -
12	8				/		£ -
13				Winnings			£ -
Advantage

Hope that helps.