+ Reply to Thread
Results 1 to 7 of 7

Calculation help needed

Hybrid View

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Letchworth
    MS-Off Ver
    2010
    Posts
    27

    Calculation help needed

    Hi I am trying to create an oods line for horse racing following an example from a racing mag I prescribe to but I can not work out how he gets his total from his calculations.

    Weight carried (in pounds) x -0.004
     The Racing Post Rating or RPR earned by the
    horse in it’s last race x +0.0016
     The Starting Price of the horse (e.g. 5/4 = 1.25)
    x -.1270
     Constant (applied to all horses) = -.5313

    Variable Weighting Value Calculation Score
    ODDS -0.127 1.25 1.25 x -0.127 -0.15875
    RPR1 0.0016 99 99 x 0.0016 0.1584
    WGHTLB -0.004 140 140 x -0.004 -0.56
    Constant -0.5313 0.5313 -0.5313
    Total -1.09165

    Looking at the score and adding this figures I end up with -5313.56
    His total is -1.09165 how did he get that total or what am I doing wrong can any one help please.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: Calculation help needed

    -0.15875+0.1584-0.56 = -0.56035
    -0.56035-0.5313= -1.09165

    The total is correct.

    Where did you get -5313.56 from? The value is -0.5313
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,118

    Re: Calculation help needed

    what do you do with each value

    -0.15875
    0.15875
    -0.56
    -0.5313

    =1.0913

    your calc for
    RPR1 0.0016 99 99 x 0.0016 0.1584
    should be
    99.99 * 0.0016 = 0.159984

    and then you get
    1.09007

    So i suspect he uses maybe different rounding on the numbers
    Attached Files Attached Files
    Last edited by etaf; 03-04-2016 at 06:45 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    Letchworth
    MS-Off Ver
    2010
    Posts
    27

    Re: Calculation help needed

    Thanks for the reply why then when I add them it is not the same what am I doing wrong
    Trying to attach to show but do not know how

    HORSE ODDS RPR WHT LBS CON TOTAL
    1.25 -0.15875 99 0.1584 10 0 140 -0.56 -5313 -5313.56
    Attached Files Attached Files

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,118

    Re: Calculation help needed

    -5313

    should that be
    -0.5313

  6. #6
    Registered User
    Join Date
    07-22-2014
    Location
    Letchworth
    MS-Off Ver
    2010
    Posts
    27

    Re: Calculation help needed

    You are so right I feel such an idiot I did not relize I left out the 0. Thanks for your help

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,118

    Re: Calculation help needed

    you are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Roster calculation help needed!!!
    By nikrollison in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-12-2015, 11:10 PM
  2. Calculation in a Rota - Help Needed Please
    By NMGIBBS in forum Excel General
    Replies: 5
    Last Post: 01-06-2015, 06:47 AM
  3. [SOLVED] Calculation on UserForm help needed
    By WimpieOosthuizen in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2014, 01:36 AM
  4. Help Needed: Calculation Within A Pivot
    By Smtesar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-30-2013, 01:28 PM
  5. Time calculation help needed
    By frustrated in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2013, 07:16 PM
  6. Probability Calculation Help Needed
    By Kiffar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2012, 10:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1