Have any of you "Spreadsheet Boffins" managed to get the Retirement Staking Plan into an excel spreadsheet format yet?
It's proving difficult for a pea brain such as myself.
Many genuine punters consider the retirement plan to be the beast staking plan ever devised.

__________________
why gobble with the turkeys, when you may soar with the eagles!!

wow, you guys look a lot more advanced at this stuff than me. this thread should be interesting.

out of interest, how do you extract the info from Ozeform? I'd have thought you would need a script/bot to do that; ie go to the site, log in, form search, type horse's name (correctly - and if more than one horse with that name in the db, select the right one), etc.

Seems like a lot of hard work to me. Ive been a regular of ozeform for a few years now, but have only used the db on and off as i find the form search tedious.

I created a very basic spreadsheet for the Sportscolour info. It converts the sectionals into a whole number for ease of reading, compares each time to a race average etc. I also have a basic one that converts raw times & 600m sectionals into Time & pace ratings (for Sydney).

I am now working on a new spreadsheet which will use the Ozeform ratings to derive a Class Rating for a race. Any help on extracting info from the site would be appreciated.

Hi there,I have been using Cyberhorse data for a while now do an aweful lot of typing results and other data.Do you have something that might reduce that? It would be fantastic,I can email you the format it comes in if need be...

Ta

__________________

Sorry to dissapoint you mate...but i was lucky enough to stumble on the best forum for help....you just tell them what you need and they well provide answers very quickly http://www.mrexcel.com/board2/index.php

Yeah the guys on there are terrific and very quick to help, mostly U.K. guys.

A great resource!!!

How's this for an idea, this thread can continue with these type of spreadsheet tips. The advantage is it may possibly stay tuned to racing, or just mostly what's commong around here,sports and numbers, right ?!,
Point is, lets say a discussion gets going, and most have their own version of things in a spreadsheet, but there is no common ground, or a common platform to experiment with....
So, let's say Shaun's example, that very formula is used for a number crunch.
Let's say then those that participate have excel, and what's always common with these things, the tedious tasks.
So then the solution would be to "employ" the same name experimental file, same name sheets,and when sheets need to be cleared, just learn to paste a universal macro from here. It's harmless, it simply clears the sheets upon any topic of discussion at the time.
My version of clearing sheets by macro is: (contribution)

'+++++++++++++++++++++++++++++++++
'CLEAR SHEETOING ++
Sheets("SORT1").Select '+
Cells.Select '+
Application.CutCopyMode = False '+
Selection.Delete Shift:=xlUp '+
Range("A1").Select '+
'CLEAR SHEETONE '+
'CLEAR SHEETOING '+
Sheets("SORT2").Select '+
Cells.Select '+
Application.CutCopyMode = False '+
Selection.Delete Shift:=xlUp '+
Range("A1").Select '+
'CLEAR SHEETONE ++
'++++++++++++++++++++++++++++++++
See !!
there is no need to have a diverse array of lingo's when trying to explain something.
SORT1 and SORT2 are just examples,a start.
Two clean sheets in excel with a macro to clear numbers and get on with the next task when trying to explain, in particular, horse racing number crunch issues,in a way it's understood, here.
It may avoid having to RTFM's ,( Help-less files) and may even possibly avoid end up becoming a rocket scientists !, when all ya wanna do is put a bet on !


Perhaps the icons can be avoided to, somehow.

Any formulas that i have or can get for people to extract information or to do what they need in excel i will provide np......i could even create a file that would extract the information you need and show you where you imput your info to creat ratings with out you giving away any information that is private....if anyone needs help let me know.

Hello Shaun, I get my selections based on ratings in the following format.Can you suggest a way or provide a worksheet that I could apply that wil lenable me to match them with actual bets results and profit/loss instead of all the typing out i do every day mate?IT would be fantastic. What I do at the moment is type along side each selection how it went what it paid and what I won lost, qui's etc.

By A Nose - Metro. Race 1, CHELTENHAM 2005, May 28

1st Tip: 1. Delabee

2nd Tip: 5. Jeune Royale

3rd Tip: 6. Pommery Princess

Best Each Way Tip: 1. Delabee

Long Shot tip: 2. Toast to Lenny



Maka

__________________

Well as you can see above, the ratings I use and with some settings I apply I come up with this for each race I rate.With the 3 selections and sometimes a longshot suggestion.What I want to do is have this info in a worksheet, add results, prices,bets and calculate whether or not I won on the race.

I also want to be able to search my data to see what a horse has previously done in my records.What are the chances of something like this???

Cheers

__________________

have not used that for ages will have it for you later today