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)
-   -   some excel help please (http://forums.ozmium.com.au/showthread.php?t=6808)

Shaun 4th January 2005 08:34 PM

Feather....what you are doing sounds ok....you could try dutching the pair to return an amount for example if you had 2 horses priced at $3.50 and $7.00 and you wanted to return $100 no matter who won you could put $30 on your $3.50 horse and $15 on your $7.00 horse.

Gizzard this has been suggested and i will get to it tonight i hope...make life to easy for you guys

system 4th January 2005 09:57 PM

hey shaun great work mate,i take after win u just reset and start again

Shaun 4th January 2005 10:03 PM

No..if you are familiar with the original Retirement Staking Plan you can just go back to the same divisor you only need to reset when you get to 100 bets or you want to change the the percentage of your bank you wish to bet with

here is the original plan
http://www.grandstand.com.au/retirement.html

system 4th January 2005 10:10 PM

cheers buddy

system 4th January 2005 10:20 PM

shaun check ur email

Shaun 5th January 2005 10:37 AM

Investment Manager
 
1 Attachment(s)
Thought i would add another spread sheet to help you, this spread sheet can keep track of your investments very basic but does the job....one thing is i can't protect the sheet because of a macro i have in there...not sure how to do it so don't type anything in an area that has a formula writen in it...best thing to do is make a copy of the sheet and use that...that way you could have a sheet for each staking plan you use or each type of investment there is plenty of room to type the bet made...if you have any trouble let me know

brave chief 5th January 2005 11:45 AM

hey Shaun,

I've been looking at the info on the CRIS website (waturf.org). You can download race results in excel format, however the 600m sectionals are not formatted as a decimal.

eg, They appear as (34:41) instead of 34.41

At the moment, I have to type the sectional using the correct format, ie as a decimal, in the next column before i can use the figures. Is there a little macro that will do this for me?

Any ideas would be appreciated.

Shaun 5th January 2005 01:24 PM

send me a copy of one of the excel sheets
shaun2166@hotmial.com

Shaun 5th January 2005 01:39 PM

are those the numbers in the last column

=MID(A1,FIND("(",A1)+1,5)

use this formula
A1= the cell where the sectional time is

DR RON 5th January 2005 06:25 PM

Great work with the spreadsheets Shaun, goes to show you dont have to spend big bucks on programs to get want you want. Why pay for features you dont really want or use when you can keep things nice and simple.


All times are GMT +10. The time now is 12:11 PM.

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