1. #71
    RaginCajun
    RaginCajun's Avatar Become A Pro!
    Join Date: 06-28-10
    Posts: 87

    Ganchrow, is all of this for excel? i just tried to do the first command in a cell in excel. i typed in US2Dec(-110,-110) and nothing happened. do i need to do anything else?

  2. #72
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,422
    Betpoints: 186

    You have to install the functions before you can use them.

  3. #73
    Kraghen
    Kraghen's Avatar Become A Pro!
    Join Date: 07-09-10
    Posts: 2,509
    Betpoints: 2839

    Hi there! Does it work on Macintosh's excel version?

  4. #74
    Flight
    Update your status
    Flight's Avatar Become A Pro!
    Join Date: 01-28-09
    Posts: 1,979

    If the Mac version supports VBA then yes. I believe it does. Open Excel and push ALT+F11 and see if the VB editor comes up. If it does, you're in business.

  5. #75
    sharpcat
    sharpcat's Avatar Become A Pro!
    Join Date: 12-19-09
    Posts: 4,516

    Quote Originally Posted by Kraghen View Post
    Hi there! Does it work on Macintosh's excel version?
    Excel 2008 for Mac does not support VBA but all other versions do including the upcoming 2010 version.

  6. #76
    Shonner
    Shonner's Avatar Become A Pro!
    Join Date: 09-05-10
    Posts: 1,361
    Betpoints: 84

    Anyone have an idea of when the Demo Ganch posted back in August will be ready?
    Last edited by Shonner; 09-26-10 at 10:23 AM.

  7. #77
    Flight
    Update your status
    Flight's Avatar Become A Pro!
    Join Date: 01-28-09
    Posts: 1,979

    Quote Originally Posted by Shonner View Post
    Anyone have an idea of when the Demo Ganch posted back in August will be ready?
    What are you referring to?

  8. #78
    Blacke
    Just Livin' the Dream!
    Blacke's Avatar SBR PRO
    Join Date: 10-26-09
    Posts: 252
    Betpoints: 64

    nice work, thx

    BTP
    Week 10
    4-1-0 1055 pts

    BTP
    Week 10
    4-1-0 799 pts


  9. #79
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,821
    Betpoints: 454

    does this work on excel 2010?

  10. #80
    blackf1re
    blackf1re's Avatar Become A Pro!
    Join Date: 01-31-10
    Posts: 484
    Betpoints: 204

    Doesn't seem to work on Excel 2010. And when trying to open the .xlt I get this:

    "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

  11. #81
    ArcadeFire
    ArcadeFire's Avatar Become A Pro!
    Join Date: 10-30-10
    Posts: 111

    Yes, I cannot get it to work in current Excel version, bummer.

    Whatever happened to Ganchrow?

  12. #82
    hubie69
    I am JJ's Bookie
    hubie69's Avatar Become A Pro!
    Join Date: 09-16-10
    Posts: 1,784
    Betpoints: 25

    Excellent work on these Ganchrow, amazingly helpful.

  13. #83
    Ramster
    Ramster's Avatar Become A Pro!
    Join Date: 06-08-09
    Posts: 76
    Betpoints: 36

    Thank you OP..I downloaded

  14. #84
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,013
    Betpoints: 926

    http://www.sportsbookreview.com/forum/handicappe...xcel-demo.html

    This above link contains a workbook with a considerably more up to date version of these functions and more.

    The VBA code was greatly refactored with much rewritten in C++ for added speed. WIN32 I'm afraid. .

    SBR Founder Join Date: 8/28/2005


  15. #85
    mjespoz
    mjespoz's Avatar Become A Pro!
    Join Date: 02-15-11
    Posts: 42
    Betpoints: 525

    Ganchrow! I have learnt so much from your Kelly posts (amongst others). Welcome back!

  16. #86
    frankzig
    frankzig's Avatar SBR PRO
    Join Date: 10-26-09
    Posts: 2,038
    Betpoints: 120

    yea solid we ca axt uamytng

    BTP
    Week 11
    3-1-1 383 pts

    BTP
    Week 9
    3-1-1 270 pts


  17. #87
    frankzig
    frankzig's Avatar SBR PRO
    Join Date: 10-26-09
    Posts: 2,038
    Betpoints: 120

    proper english baby your not in the street

    BTP
    Week 11
    3-1-1 383 pts

    BTP
    Week 9
    3-1-1 270 pts


  18. #88
    jhol3990
    jhol3990's Avatar Become A Pro!
    Join Date: 09-09-08
    Posts: 45
    Betpoints: 144

    awesome, thanks for this. Just trying to find the gold in this forum and looks like i've struck some here. Thanks again.

  19. #89
    jjgold
    Player Relations
    jjgold's Avatar Saloon Moderator
    Join Date: 07-20-05
    Posts: 270,214
    Betpoints: 5192

    Nice work Ganch

    Anyone else would charge for this stuff

    Bald
    & Proud
    of Myself -jjgold

    SBR Founder Join Date: 7/20/2005


  20. #90
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,821
    Betpoints: 454

    how do I translate this to english? I dont know anything about this

  21. #91
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,422
    Betpoints: 186

    Ganchrow is the final boss.

  22. #92
    demens
    Square -910
    demens's Avatar Become A Pro!
    Join Date: 10-22-10
    Posts: 2,785

    Can these be used in OO Calc?

  23. #93
    Sacamano
    Sacamano's Avatar Become A Pro!
    Join Date: 11-13-11
    Posts: 227
    Betpoints: 102

    Great work..thank you

  24. #94
    Inkwell77
    Inkwell77's Avatar Become A Pro!
    Join Date: 02-03-11
    Posts: 3,140
    Betpoints: 1295

    Awesome! Thank you!

  25. #95
    allin1
    Update your status
    allin1's Avatar Become A Pro!
    Join Date: 11-07-11
    Posts: 4,560

    bump and thanks!

  26. #96
    mikeorta20
    mikeorta20's Avatar Become A Pro!
    Join Date: 05-21-12
    Posts: 1
    Betpoints: 390

    how come when i us the 'us2fair' function it gives me a negative number for the dog and the favorite. so both cells have a "-184" instead of one +/-. its messing me up when calculating win probablity.

  27. #97
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,013
    Betpoints: 926

    Quote Originally Posted by mikeorta20 View Post
    how come when i us the 'us2fair' function it gives me a negative number for the dog and the favorite. so both cells have a "-184" instead of one +/-. its messing me up when calculating win probablity.
    It's an array formula.

    You need to enter it with CTRL+SHIFT+ENTER.

    Also ... if you just want to calculate win probability you should use US2REAL rather than US2FAIR.

    SBR Founder Join Date: 8/28/2005


  28. #98
    bmurphy003
    bmurphy003's Avatar Become A Pro!
    Join Date: 01-24-12
    Posts: 17
    Betpoints: 336

    Great thread, bit of an excel nerd here but I'm trying to come up with an if function that will return the change in units for each game betted on. Ex: (column 1, column 2, column 3, etc.) = (
    line, result, base amount of units, unit change) = (-1.10, W, 1.00, *should return +1.00)

    works fine unless betting a favorite with a losing result. Tried many combinations of

    =if(AND(line<0,result ="W"),[base amount]* line....etc
    buthavent quite figured it out.

    Any thoughts/comments would be helpful

  29. #99
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,013
    Betpoints: 926

    Quote Originally Posted by bmurphy003 View Post
    I'm trying to come up with an if function that will return the change in units for each game betted on. Ex: (column 1, column 2, column 3, etc.) = (
    line, result, base amount of units, unit change) = (-1.10, W, 1.00, *should return +1.00)

    works fine unless betting a favorite with a losing result. Tried many combinations of

    =if(AND(line<0,result ="W"),[base amount]* line....etc
    buthavent quite figured it out.

    Any thoughts/comments would be helpful
    You can use the function from my template:

    Code:
    =US2Res(, , )
    where is a string that starts with "W" for a winning bet and with "L" for a losing bet.

    If you have your quantities listed as "base" rather than "risk" quantities, then you could use something like:

    Code:
    =quantity*IF(result="W", MAX(1,USOdds/100), (result="L")*MIN(-1,USOdds/100))

    SBR Founder Join Date: 8/28/2005


  30. #100
    gauchojake
    Feet don't fail me now
    gauchojake's Avatar SBR PRO
    Join Date: 09-17-10
    Posts: 14,305
    Betpoints: 280

    Nice bump hoopy. Gotta get prepped for nfl

    BTP
    Week 8
    3-2-0 142 pts


  31. #101
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 40
    Betpoints: 519

    does this work on google docs spreadsheet?

  32. #102
    Lo$t
    Cwissy authorizes
    Lo$t's Avatar Become A Pro!
    Join Date: 06-03-10
    Posts: 778

    Can I input Izzo any # into this thing?

  33. #103
    kzee89
    kzee89's Avatar Become A Pro!
    Join Date: 03-08-10
    Posts: 78
    Betpoints: 24

    I like the idea of applying VBA knowledge to sports.

  34. #104
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 40
    Betpoints: 519

    Quote Originally Posted by satana View Post
    does this work on google docs spreadsheet?
    Ok, I take it as no since I have to save the book.xlt file.
    I've office '07 installed on this old laptop, why can't I find find the Microsoft Office folder under C:\Program Files?
    edit found it

    Last edited by satana; 12-05-13 at 07:43 PM.

  35. #105
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 40
    Betpoints: 519

    Quote Originally Posted by Ganchrow View Post
    Type the following in cell A1:
    =us2prob(-110)
    Hit enter. If the result is 0.52381 then you know the function is working properl
    don't know if Granchow is still around here, but when I try this it doesn't work.
    all macros are enabled, I'm using office '07 and the file has been copied in the right folder.

First 1234 Last
Top