Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > RaceCensus
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 4th January 2018, 05:05 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,816
Post FAQ

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.
__________________
RaceCensus - powerful system testing software.
Now with over 300,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #2  
Old 4th January 2018, 08:38 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 538
Default

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

Thanks.
Reply With Quote
  #3  
Old 4th January 2018, 09:36 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,816
Default

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?
__________________
RaceCensus - powerful system testing software.
Now with over 300,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #4  
Old 4th January 2018, 09:38 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,816
Default

Q. What do PWLS and PWLTS mean?

A. PWLS is total Prizemoney won last start.
PWLTS is total Prizemoney won last three starts.
__________________
RaceCensus - powerful system testing software.
Now with over 300,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #5  
Old 4th January 2018, 11:02 PM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 538
Default

https://m.wikihow.com/Determine-Gear-Ratio
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..

Thanks.
Reply With Quote
  #6  
Old 5th January 2018, 12:58 AM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,816
Default

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.
__________________
RaceCensus - powerful system testing software.
Now with over 300,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #7  
Old 5th January 2018, 01:41 AM
Puntz Puntz is offline
Member
 
Join Date: Jan 2012
Posts: 538
Default

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,

https://exceljet.net/formula/calcul...rom-two-numbers
Reply With Quote
  #8  
Old 9th January 2018, 08:52 AM
darkydog2002 darkydog2002 is offline
Member
 
Join Date: Nov 1999
Posts: 6,656
Talking

Strewth.

I,m still with the inkpot and quill.
__________________
When you live live in clover . when your dead your dead all over.
Reply With Quote
  #9  
Old 9th January 2018, 03:42 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 5,816
Default

Quote:
Originally Posted by darkydog2002
Strewth.

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
__________________
RaceCensus - powerful system testing software.
Now with over 300,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/06/2018
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #10  
Old 21st March 2018, 07:09 PM
thebeans thebeans is offline
Member
 
Join Date: Feb 2018
Posts: 16
Default placing

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT +10. The time now is 05:52 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655