OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)
-   -   FVRatings 2012 (http://forums.ozmium.com.au/showthread.php?t=23592)

Shaun 14th March 2012 01:43 PM

small code update, on Data sheet FD2 replace the formula with this.

=IF(FC2="","",IF(1/FC2*MainSheet!$R$11>100,100,1/FC2*MainSheet!$R$11))

Then copy down, this will put a max price of $100

As seen in Doomben race 2 if you had 8 runners selected the bottom runner was $100 but the 7th selection was over $380, makes no sense with the prices like that but the rating order was correct.


All times are GMT +10. The time now is 06:53 AM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.