OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   RaceCensus (http://forums.ozmium.com.au/forumdisplay.php?f=64)
-   -   FAQ (http://forums.ozmium.com.au/showthread.php?t=31721)

Chrome Prince 4th January 2018 04:05 PM

Thought I'd start a thread on FAQ about the database here. Feel free to ask questions on this thread as well.

Q. Was just after an explanation of what the weight ratio is and how it is calculated?

A. Weight ratio is the allocated weight of the top weight by the handicapper minus the allocated second top weight allocated by the handicapper.
Apprentice claims are not taken into consideration because the data is not included in the form source and then of course, there are jockey changes. Itís more of an indication of how good the top weight is compared to the next handicapped horse by the handicapper.

Puntz 4th January 2018 07:38 PM

Good thread CP, interesting reading.
do you have the formula for the ratio to use in excel.


Chrome Prince 4th January 2018 08:36 PM

I use a script trigger from Filemaker Pro Puntz.
You'd have to give me all the cells you have in Excel and I could give you an example formula, and is your data sorted by Date Track Race and Tab Number?

Chrome Prince 4th January 2018 08:38 PM

Q. What do PWLS and PWLTS mean?

A. PWLS is total Prizemoney won last start.
PWLTS is total Prizemoney won last three starts.

Puntz 4th January 2018 10:02 PM

No problemo CP, back to basics, lol
I just swap gear counts for horse weights and use same formula in the above url = ratio between the 2 numbers.
So if a horse top weight is 30 and the next is 20, ya get 1.5
It has nothing to do with TAB No etc..


Chrome Prince 4th January 2018 11:58 PM

Puntz, I also looked at the video on that page, being a gearhead, it's the wrong way to determine the gear ratios. He has aftermarket wheels and low profile tyres, and even if he had a standard setup, it's still prone to error. The simple way is to remove the diff housing cover and look at the diff gears, it's stamped on the gear.
One guy on youtube changed his transmission to a manual in a Mercedes and couldn't work out why it was sluggish in first and second gear. He just needed to change the diff to a higher ratio, as autos always have lower ratios than manuals. Gives you more power on the bottom end on take off but doing 100kph your revs will be high.

The horse weight ratio is simply topweight minus the next weight.
Ratio is probably the wrong term, but that's what I called it.
So if topweight is 57.5 and next weight by tab number is 56, the result is 1.5kg.

Puntz 5th January 2018 12:41 AM

I know CP, gears n boxes , 4wd. We use to make and fit diff locks.

Anyway, "ratio" got me thinking.... improvise from there I suppose.

specific excel formula is,


darkydog2002 9th January 2018 07:52 AM


I,m still with the inkpot and quill.

Chrome Prince 9th January 2018 02:42 PM

Originally Posted by darkydog2002

I,m still with the inkpot and quill.

That's ahead of me Darky, I chisel hieroglyphics, although I do seal envelopes with red wax and use my personal stamp :D

thebeans 21st March 2018 06:09 PM

hi chrome
this maybe a stupid question but how is the placing tab on the general page used as iam getting a little confused

All times are GMT +10. The time now is 02:16 PM.

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