EXCEL PROGRAM THAT MAKES YOUR OWN -1 LINES... SAVE THIS TO YOUR COMPUTER or SUBSCRIBE TO THIS THREAD

Search

"Sit on mah lap!"
Joined
Jun 19, 2006
Messages
3,422
Tokens
thanks, I'm sure this'll come in handy when I get too lazy to calculate on my own.
 
Joined
Jan 19, 2006
Messages
30,208
Tokens
Takes about 3-5 secs to calculate.. I think even mathemticians would rather use this then doing it themselves..

I have a lot of people asking me about this, figured I'd make a thread.
 

New member
Joined
May 16, 2009
Messages
710
Tokens
Can you explain how to use this tool. For ex:

Jays ML (-250)

Jays RL -1.5 (-108)


I entered those into what appear to be the appropriate fields. And then on the bottom table I set it , for "Amount won" on the "Fave 1" = 100.

It says "Risk" = 94.55

How is this possible?? That would make the -1 + money. And if the 1.5 is - money, then the -1 should also be - money.

Can anyone enlighten me on what I am doing wrong. Thanks.
 
Joined
Jan 19, 2006
Messages
30,208
Tokens
Can you explain how to use this tool. For ex:

Jays ML (-250)

Jays RL -1.5 (-108)


I entered those into what appear to be the appropriate fields. And then on the bottom table I set it , for "Amount won" on the "Fave 1" = 100.

It says "Risk" = 94.55

How is this possible?? That would make the -1 + money. And if the 1.5 is - money, then the -1 should also be - money.

Can anyone enlighten me on what I am doing wrong. Thanks.


How much are you wanting to win? I did it for $100 here is what it should look like..


<TABLE style="WIDTH: 321pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=428 border=0 x:str><COLGROUP><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 47pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=62 height=17> </TD><TD class=xl22 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black; WIDTH: 56pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" width=75> </TD><TD class=xl60 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black; WIDTH: 218pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=291 colSpan=3>Scenarios</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Bet</TD><TD class=xl23 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white">Line</TD><TD class=xl24 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white">Fave Loss</TD><TD class=xl25 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white">Fave Win By 1</TD><TD class=xl26 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white">Fave Win By > 1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Fave ML</TD><TD class=xl28 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num>-250</TD><TD class=xl29 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-250" x:fmla="=IF($B$3<0,$B$3,-10000/$B$3)">-$250.00</TD><TD class=xl30 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="100">$100.00</TD><TD class=xl31 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="100">$100.00</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Dog ML</TD><TD class=xl28 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num>-103</TD><TD class=xl29 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="97.087378640776706" x:fmla="=IF($B$4<0,-10000/$B$4,$B$4)">$97.09</TD><TD class=xl30 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-100">-$100.00</TD><TD class=xl31 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-100">-$100.00</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Fave -1.5</TD><TD class=xl28 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num>-108</TD><TD class=xl29 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-100">-$100.00</TD><TD class=xl30 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-100" x:fmla="=-D3">-$100.00</TD><TD class=xl31 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="92.592592592592595" x:fmla="=IF($B$5>0,$B$5,-10000/$B$5)">$92.59</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Dog +1.5</TD><TD class=xl28 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num="120">+120</TD><TD class=xl29 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="100">$100.00</TD><TD class=xl30 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="100">$100.00</TD><TD class=xl31 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-83.333333333333329" x:fmla="=IF($B$6<0,$B$6,-10000/$B$6)">-$83.33</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl32 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Fave -1</TD><TD class=xl33 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-181.7307692307692" x:fmla="=IF(-C7<E7,-E7/C7,C7/E7)*100">-182</TD><TD class=xl34 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="-350" x:fmla="=C3+C5">-$350.00</TD><TD class=xl35 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="0" x:fmla="=D3+D5">$0.00</TD><TD class=xl36 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white" align=right x:num="192.59259259259261" x:fmla="=E3+E5">$192.59</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Dog +1</TD><TD class=xl37 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" align=right x:num="107.50220653133276" x:fmla="=IF(C8<-E8,E8/C8,-C8/E8)*100">+108</TD><TD class=xl38 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" align=right x:num="197.08737864077671" x:fmla="=C4+C6">$197.09</TD><TD class=xl39 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" align=right x:num="0" x:fmla="=D4+D6">$0.00</TD><TD class=xl40 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white" align=right x:num="-183.33333333333331" x:fmla="=E4+E6">-$183.33</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl41 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17> </TD><TD class=xl42 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"> </TD><TD class=xl43 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: white"> </TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl44 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17>Bet</TD><TD class=xl45 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent">Risk $</TD><TD class=xl46 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: white">To Win $</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl47 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:fmla="=A7">Fave -1</TD><TD class=xl48 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="181.7307692307692" x:fmla="=IF(B7<0,-B7/100*C12,100/B7*C12)">$181.73</TD><TD class=xl49 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num="100">$100.00</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:fmla="=A3">Fave ML</TD><TD class=xl50 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="129.80769230769232" x:fmla="=IF(B3<0,-B3/100*C13,100/B3*C13)">$129.81</TD><TD class=xl51 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="51.923076923076927" x:fmla="=C12-C14">$51.92</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl52 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:fmla="=A5">Fave -1.5</TD><TD class=xl53 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="51.92307692307692" x:fmla="=IF(B5<0,-B5/100*C14,100/B5*C14)">$51.92</TD><TD class=xl54 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="48.076923076923073" x:fmla="=E5/(100+E5)*C12">$48.08</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl55 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:fmla="=A8">Dog +1</TD><TD class=xl50 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="288.36617405582922" x:fmla="=IF(B8<0,-B8/100*C15,100/B8*C15)">$288.37</TD><TD class=xl56 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: silver" align=right x:num="310">$310.00</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl57 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:fmla="=A4">Dog ML</TD><TD class=xl50 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="157.29064039408868" x:fmla="=IF(B4<0,-B4/100*C16,100/B4*C16)">$157.29</TD><TD class=xl51 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right x:num="152.70935960591135" x:fmla="=C4/(100+C4)*C15">$152.71</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: black 1.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" height=17 x:fmla="=A6">Dog +1.5</TD><TD class=xl58 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: black; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="131.07553366174056" x:fmla="=IF(B6<0,-B6/100*C17,100/B6*C17)">$131.08</TD><TD class=xl59 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: black 1.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num="157.29064039408865" x:fmla="=C15-C16">$157.29</TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
 

New member
Joined
May 16, 2009
Messages
710
Tokens
I have it set to win 100 as well. And the Fave ML and Fave RL are set the same as yours, but my results in the 2nd table are all incorrect.

And the to win for the DOG +1 I have set at 310 (like yours). But the risk says 449.50....

I don't know, its all whacked out.
 
Joined
Jan 19, 2006
Messages
30,208
Tokens
Only three cells need to be fucked with..

FAVE ML

FAVE -1.5

TO WIN $


do not mess with any others.. Try it again
 

New member
Joined
May 16, 2009
Messages
710
Tokens
Tried it three times, no go. In fact I reclicked your original link and started right from there. Could it have anything to do with the fact that I am running this program on "spreadsheet" and not "excel" ??
 

Forum statistics

Threads
1,119,828
Messages
13,573,630
Members
100,877
Latest member
kiemt5385
The RX is the sports betting industry's leading information portal for bonuses, picks, and sportsbook reviews. Find the best deals offered by a sportsbook in your state and browse our free picks section.FacebookTwitterInstagramContact Usforum@therx.com