I need a spreadsheet, anyone?

[Duritz]

Hey all

A mate of mine is following a system, and he wants to back the horses in six horse all ups, parlaying all the doubles, trebles, quads, fivers and the six horse all up within it.

Within six bets, there are

15 doubles
20 trebles
15 quads
6 fivers
1 six

He wants to have a set amount on the doubles, and less on the others. Not sure how much, it might be $20 on each of the doubles and $10 on all the others.

He has asked me to write a spreadsheet for him, and I just started, but it's a bit of a task for a novice like me, so I was wondering if anyone knew of a spreadsheet already in existence which would work these bets out?

Thanks.

[geoffro]

Hi duritz,
I have a spread sheet that is an all up calculator but doesn't do up to 6 horses it only does up to 4 but you are more than welcome to have a look at it and see if you can expand on it.
I didn't design it, it was given away for free by a member of a rating's service i was a subcriber too so i cant see the harm in you having a copy.
i will see if i can attach it here if for some reason it doesn't work just give me your e-mail address and i will forward it to you.
cheers
geoffro

[Duritz]

Thanks for that Geoffro, will give it a go.

[Duritz]

Yeah unfortunately I don't think that one will be alterable for my purpose unfortunately. Thanks anyway though Geoffro. Anyone have one for six horses?

[Shaun]

Sounds interesting.....you could try this not exactly what your mate wants but it will work

Say he has $100 to spend on the total of all bets and i assume they are in different states even if they are not he xan still do this.

On the first selection he places 60% of the total bank in this case it is $60 if the horse wins he adds what ever he gets back to the remaining $40 and then bets 60% of that on the next horse here is example of three horse parly for the place

bank $100
first bet $60-remainder $40
winner pays $1.80 return $108 + $40 = $148
second bet 60% of $148 = $88.80 rounded up to $90-remainder $58
winner pays $1.50 retrun $135 + $58 = $193
third bet $60% of $193 =$115.80 rounded to say $115-remainder $78
winner pays $2 return $230 + $78= $308 profit $208

this could be continued for as many bets as you like if you strike a loser just use 60% of the remaining money and continue