+ Reply to Thread
Results 1 to 7 of 7

math formula...

  1. #1
    Registered User
    Join Date
    08-01-2008
    Location
    uk
    Posts
    12

    math formula...

    Need a bit of help converting the below math formula into a an excel spreadsheet.


    1000(∑(a/b/³√(∑c)


    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,627

    Re: math formula...

    That's not a math formula that I recognize:
    You have three left parentheses and only one right.
    The summation symbol sigma is mis-used, you have not provided the range of summation for a typical example:
    3
    2x
    x=1
    where the range is 1,2,3; the index of summation being 2x...
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-01-2008
    Location
    uk
    Posts
    12

    Re: math formula...

    1000(∑(profit/big blind/³√(∑hands played)

    is how someone else, not me has decided to express this math formula which I would like to put into some form of spreadsheet.

    https://pro.betfair.com/2008/leaderb...sh_tc.php?c=32

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: math formula...

    do you understand the formula as it is presented?
    or are you hopeing someone here will do it for you?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: math formula...

    looks like someone isn't playing with a full deck....
    Last edited by somesoldiers; 03-25-2010 at 08:01 PM.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: math formula...

    I don't see that formula on the site you linked. What is it supposed to calculate?
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    08-01-2008
    Location
    uk
    Posts
    12

    Re: math formula...

    lol - I am playing with a full deck of skill.. just not very much Excel Ninja Math!

    TBH - I dont think the website know what the hell they are on like the first fellow mentioned! Anyway if you click link i've posted then point 4 shows how the leaderboard points are calculated for cash poker games.... which is the formula I would like to play around with in excel. (If at first I can make any sense of it (=profit) <<<lol see what I did? hehe [missed something out for those of you that dont get my kooky sense of tumor.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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