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

Enjoy..

thanks, I'm sure this'll come in handy when I get too lazy to calculate on my own.

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.

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.

badbeat1015 said:

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.

Click to expand...

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>

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.

Only three cells need to be fucked with..

FAVE ML

FAVE -1.5

TO WIN $


do not mess with any others.. Try it again

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" ??

I'm not sure, maybe.. You can't do it the regular way??