Results 1 to 2 of 2

Thread: refining exsisting formula (long)

  1. #1
    Jun 2007

    refining exsisting formula (long)

    sorry if this is not algebra i think it must be thought,

    i sent this pm to a forum member who is going to take a look at it for me but advised to throww it out there for others ideas.


    my message to member

    hello there i have found you. My name is ashley and im not quite sure if you remember me or not but i am from australia and you hellped me a little over 12 months ago by building a scoring system for my fantsy football league

    to view the original post click here

    anyway it was a big hit this season and was much more authentic that having just player points which was fantastic.

    anyway the reason for my email is is was hoping you could take a look at it for me and hopfully we can refine it a little to make it a touch more authentic

    you see what i discovered over the course of the season was a. it worked fine and no team with a lower points won which was cool but alot of the
    'endiong points were very close which sometimes didnt reflect the size of the win that was achieved.

    as a guide in our sport using real scores (ending scores) a winning margin of 1 - 20 is considered a fairly close game 21 - 40 a comfortable win and 40+ is a bit of a belting. now after analizing the results this season i have come to the following conclusion that as far as starting points go 1-120 is a close game 120 - 300 is comfortable and 300 plus is an esy win.

    at the moment a win of say (starting points) team a 2000 and team b 1700 the end scores are 100 to 85 which is not really enough considering the starting point refelect a big win.

    i suppose what i am trying to get at is this, can the formula be changed to relfect the ranges shown above so that starting point wins of up to 120 pts reflect and ending points win up to 20pts, starting point wins from 120 - 300 reflect a 21-40 pts ending point win and starting pint wins of 300+ pts reflect 40+ pts ending score wins.

    Sorry to be long winded about this its darn hard to explain. if it cant be done thats fine to cause for all intents and purposed the current system does the job but any relpy or help on this would be fantastic

    kind regards ash
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor Quick's Avatar
    May 2006
    New England
    Okay, so I redid it.

    I've posted an attachment of the excel sheet with it.

    The new system:

    $\displaystyle s=$starting points

    $\displaystyle p=$ ending points

    $\displaystyle g=$ ending goals

    $\displaystyle b=$ ending behinds

    $\displaystyle g=\frac{s-800-4\sin{s}}{70}$ <--- Round this value

    $\displaystyle b=\frac{s-800}{10}-6g$ <--- Round this one too

    $\displaystyle p=b+6g$

    The ending behinds and goals have to be rounded.
    Attached Files Attached Files
    Last edited by Quick; Sep 28th 2008 at 05:00 PM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 4
    Last Post: Jul 15th 2011, 01:30 PM
  2. Replies: 8
    Last Post: Sep 5th 2010, 12:11 PM
  3. Replies: 1
    Last Post: Apr 26th 2010, 07:16 PM
  4. Here's a long one
    Posted in the Advanced Algebra Forum
    Replies: 0
    Last Post: Oct 6th 2009, 01:05 PM
  5. I'm so long on this one...
    Posted in the Calculus Forum
    Replies: 5
    Last Post: Sep 26th 2007, 07:34 PM

Search Tags

/mathhelpforum @mathhelpforum