Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
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 27th September 2005, 01:43 PM
Mad Gambler Mad Gambler is offline
Member
 
Join Date: Jun 2005
Posts: 167
Default Excel Help

I'm wondering if someone could me speed my rating of past races with the use of a speadsheet.

The formula is:

CR=Class Rating of the race
BM=Beatem Margin
WT=Weight Carried
LW=Limit Weight

CR-BM*1.5+WT-LW

An example follows 65-(3.5*1.5)+56.5-53=63.25 rounded to 63.5

Mad Gambler
Reply With Quote
  #2  
Old 27th September 2005, 03:12 PM
wesmip1 wesmip1 is offline
Member
 
Join Date: Sep 2005
Posts: 1,601
Default

I can help you out but I am not exaclty sure what you want done ?

Do you want someone to create an excel spreadsheet to do the calculations for you ? Or do you already have an excel sheet and just want to know how to put in the forumlaes ?
Reply With Quote
  #3  
Old 27th September 2005, 03:24 PM
Mad Gambler Mad Gambler is offline
Member
 
Join Date: Jun 2005
Posts: 167
Default

I need a spreadsheet to help with the calculations.


Mad Gambler
Reply With Quote
  #4  
Old 27th September 2005, 03:48 PM
DR RON DR RON is offline
Member
 
Join Date: Jan 1970
Location: victoria
Posts: 562
Default

Try this mad. see if it is what you are after.
Attached Files
File Type: xls spreadsheet 1.xls (13.5 KB, 1521 views)
Reply With Quote
  #5  
Old 27th September 2005, 03:54 PM
Mad Gambler Mad Gambler is offline
Member
 
Join Date: Jun 2005
Posts: 167
Default

Thanks. It's just what I need.


Mad Gambler
Reply With Quote
  #6  
Old 27th September 2005, 04:57 PM
Mad Gambler Mad Gambler is offline
Member
 
Join Date: Jun 2005
Posts: 167
Default

Insead of the TAB number I need to be able to type in the horses name to allow me to check it's previous rating.


Mad Gambler
Reply With Quote
  #7  
Old 27th September 2005, 05:09 PM
DR RON DR RON is offline
Member
 
Join Date: Jan 1970
Location: victoria
Posts: 562
Thumbs up

If the previous ratings are in another spreadsheet, then it is fairly straight forward to type in a formula that will lookup any previous ratings. This of course depends on where they are located.
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 On
Forum Jump



All times are GMT +10. The time now is 09:17 AM.


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