1. 04-30-12 09:28 PM #1
    MexicanStallion
    MexicanStallion's Avatar Become A Pro!
    Join Date: 09-08-08
    Posts: 20,429
    Betpoints: 11153

    Excel Help (Equations)



    How can I update AVG and OBP each week?

    AB (C), Hits (E), SF (M)

    I don't know how to make the right equation other than doing it the super long way by doing E3+E4+E5/C3+C4+C5 etc..
    Reply With Quote Reply With Quote
  2. 04-30-12 09:31 PM #2
    MonkeyF0cker
    Update your status
    MonkeyF0cker's Avatar Become A Pro!
    Join Date: 06-12-07
    Posts: 12,144
    Betpoints: 1127

    =sum(e3:e999999)/sum(c3:c999999)
    Points Awarded:

    MexicanStallion gave MonkeyF0cker 4 SBR Point(s) for this post.

    Chi_archie gave MonkeyF0cker 2 SBR Point(s) for this post.

    Reply With Quote Reply With Quote
  3. 04-30-12 09:37 PM #3
    BIGDAY
    angelman.org
    BIGDAY's Avatar SBR PRO
    Join Date: 02-17-10
    Posts: 48,241
    Betpoints: 24866

    Fuk this Sh!t Stallion!!!

    Pound some MMA.
    Reply With Quote Reply With Quote
  4. 04-30-12 09:38 PM #4
    MexicanStallion
    MexicanStallion's Avatar Become A Pro!
    Join Date: 09-08-08
    Posts: 20,429
    Betpoints: 11153

    Quote Originally Posted by MonkeyF0cker View Post
    =sum(e3:e999999)/sum(c3:c999999)
    Thanks. Makes sense. I was forgetting to add the second SUM.

    And for OBP? H(E)+BB(J)/AB(C)+BB(J)+SF(M)
    Reply With Quote Reply With Quote
  5. 04-30-12 09:43 PM #5
    MonkeyF0cker
    Update your status
    MonkeyF0cker's Avatar Become A Pro!
    Join Date: 06-12-07
    Posts: 12,144
    Betpoints: 1127

    =(sum(e3:e999999)+sum(j3:j999999))/(sum(c3:c999999)+sum(j3:j999999)+sum(m3: m999999))
    Reply With Quote Reply With Quote
  6. 04-30-12 09:49 PM #6
    Chi_archie
    GASPING FOR AIR
    Chi_archie's Avatar SBR PRO
    Join Date: 07-22-08
    Posts: 63,130
    Betpoints: 2368

    fok me

    the think tank is over running PT!!!!!!!

    deep shit here sexy mexy!!!!!











    thanks again for the brackets contest J.S!!!
    Reply With Quote Reply With Quote
  7. 04-30-12 09:58 PM #7
    MexicanStallion
    MexicanStallion's Avatar Become A Pro!
    Join Date: 09-08-08
    Posts: 20,429
    Betpoints: 11153

    Quote Originally Posted by MonkeyF0cker View Post
    =(sum(e3:e999999)+sum(j3:j999999))/(sum(c3:c999999)+sum(j3:j999999)+sum(m3: m999999))
    Appreciate it. Thanks for the help MF
    Reply With Quote Reply With Quote
  8. 04-30-12 11:48 PM #8
    dj_destroyer
    I'm +EV
    dj_destroyer's Avatar Become A Pro!
    Join Date: 07-28-10
    Posts: 3,856
    Betpoints: 383

    MexicanStallion... I've been in the process of crafting a sabermetric formula the past few weeks. Mine is a lot more complex with more varied metrics but that doesn't mean squat! We should see if our formulas spit out similar picks or not.

    Mine will be ready after 20% of the season but also incorporates last season and the average of the last 5 seasons (not including minors).
    Reply With Quote Reply With Quote
Top
« Previous Thread | Players Talk | Next Thread »