1. 07-18-10 11:37 PM #71
    RaginCajun
    RaginCajun's Avatar Become A Pro!
    Join Date: 06-28-10
    Posts: 87
    Betpoints: 7

    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?
    Reply With Quote Reply With Quote
  2. 07-19-10 12:10 AM #72
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,415
    Betpoints: 187

    You have to install the functions before you can use them.
    Reply With Quote Reply With Quote
  3. 09-25-10 07:58 AM #73
    Kraghen
    Kraghen's Avatar Become A Pro!
    Join Date: 07-08-10
    Posts: 2,509
    Betpoints: 2985

    Hi there! Does it work on Macintosh's excel version?
    Reply With Quote Reply With Quote
  4. 09-25-10 09:54 AM #74
    Flight
    Update your status
    Flight's Avatar Become A Pro!
    Join Date: 01-27-09
    Posts: 1,979
    Betpoints: 1

    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.
    Reply With Quote Reply With Quote
  5. 09-25-10 02:51 PM #75
    sharpcat
    sharpcat's Avatar Become A Pro!
    Join Date: 12-19-09
    Posts: 4,516
    Betpoints: 1

    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.
    Reply With Quote Reply With Quote
  6. 09-26-10 08:46 AM #76
    Shonner
    Shonner's Avatar Become A Pro!
    Join Date: 09-05-10
    Posts: 1,361
    Betpoints: 85

    Anyone have an idea of when the Demo Ganch posted back in August will be ready?
    Last edited by Shonner; 09-26-10 at 09:23 AM.
    Reply With Quote Reply With Quote
  7. 09-27-10 08:56 PM #77
    Flight
    Update your status
    Flight's Avatar Become A Pro!
    Join Date: 01-27-09
    Posts: 1,979
    Betpoints: 1

    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?
    Reply With Quote Reply With Quote
  8. 09-27-10 11:14 PM #78
    Blacke
    Just Livin' the Dream!
    Blacke's Avatar Become A Pro!
    Join Date: 10-26-09
    Posts: 290
    Betpoints: 1276

    nice work, thx
    Reply With Quote Reply With Quote
  9. 02-12-11 01:13 PM #79
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,817
    Betpoints: 455

    does this work on excel 2010?
    Reply With Quote Reply With Quote
  10. 02-24-11 11:24 AM #80
    blackf1re
    blackf1re's Avatar Become A Pro!
    Join Date: 01-31-10
    Posts: 487
    Betpoints: 319

    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."
    Reply With Quote Reply With Quote
  11. 02-24-11 11:37 AM #81
    ArcadeFire
    ArcadeFire's Avatar Become A Pro!
    Join Date: 10-30-10
    Posts: 111
    Betpoints: 0

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

    Whatever happened to Ganchrow?
    Reply With Quote Reply With Quote
  12. 02-24-11 11:41 AM #82
    hubie69
    I am JJs bookie
    hubie69's Avatar Become A Pro!
    Join Date: 09-16-10
    Posts: 7,329
    Betpoints: 617

    Excellent work on these Ganchrow, amazingly helpful.
    Reply With Quote Reply With Quote
  13. 03-31-11 08:57 PM #83
    Ramster
    Ramster's Avatar Become A Pro!
    Join Date: 06-08-09
    Posts: 81
    Betpoints: 1897

    Thank you OP..I downloaded
    Reply With Quote Reply With Quote
  14. 03-31-11 10:43 PM #84
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,011
    Betpoints: 1088

    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. .
    Reply With Quote Reply With Quote
  15. 04-01-11 01:46 AM #85
    mjespoz
    mjespoz's Avatar Become A Pro!
    Join Date: 02-15-11
    Posts: 42
    Betpoints: 543

    Ganchrow! I have learnt so much from your Kelly posts (amongst others). Welcome back!
    Reply With Quote Reply With Quote
  16. 04-01-11 04:51 AM #86
    frankzig
    frankzig's Avatar SBR PRO
    Join Date: 10-26-09
    Posts: 2,249
    Betpoints: 3622

    yea solid we ca axt uamytng
    Reply With Quote Reply With Quote
  17. 04-01-11 04:51 AM #87
    frankzig
    frankzig's Avatar SBR PRO
    Join Date: 10-26-09
    Posts: 2,249
    Betpoints: 3622

    proper english baby your not in the street
    Reply With Quote Reply With Quote
  18. 04-01-11 07:39 AM #88
    jhol3990
    jhol3990's Avatar Become A Pro!
    Join Date: 09-09-08
    Posts: 45
    Betpoints: 3940

    awesome, thanks for this. Just trying to find the gold in this forum and looks like i've struck some here. Thanks again.
    Reply With Quote Reply With Quote
  19. 04-01-11 08:13 AM #89
    jjgold
    jjgold's Avatar Become A Pro!
    Join Date: 07-20-05
    Posts: 388,190
    Betpoints: 10

    Nice work Ganch

    Anyone else would charge for this stuff
    Reply With Quote Reply With Quote
  20. 04-01-11 08:45 AM #90
    cant call it
    BAMA UP!!!
    cant call it's Avatar Become A Pro!
    Join Date: 08-29-10
    Posts: 8,817
    Betpoints: 455

    how do I translate this to english? I dont know anything about this
    Reply With Quote Reply With Quote
  21. 04-02-11 12:23 AM #91
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,415
    Betpoints: 187

    Ganchrow is the final boss.
    Reply With Quote Reply With Quote
  22. 04-18-11 01:11 PM #92
    demens
    Square -910
    demens's Avatar Become A Pro!
    Join Date: 10-22-10
    Posts: 2,785
    Betpoints: 1258

    Can these be used in OO Calc?
    Reply With Quote Reply With Quote
  23. 11-18-11 04:34 PM #93
    Sacamano
    Sacamano's Avatar Become A Pro!
    Join Date: 11-13-11
    Posts: 227
    Betpoints: 184

    Great work..thank you
    Reply With Quote Reply With Quote
  24. 11-29-11 07:08 AM #94
    Inkwell77
    Inkwell77's Avatar Become A Pro!
    Join Date: 02-03-11
    Posts: 3,227
    Betpoints: 2413

    Awesome! Thank you!
    Reply With Quote Reply With Quote
  25. 12-17-11 10:30 PM #95
    allin1
    Update your status
    allin1's Avatar Become A Pro!
    Join Date: 11-07-11
    Posts: 4,555
    Betpoints: 1

    bump and thanks!
    Reply With Quote Reply With Quote
  26. 05-31-12 05:45 PM #96
    mikeorta20
    mikeorta20's Avatar Become A Pro!
    Join Date: 05-21-12
    Posts: 1
    Betpoints: 618

    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.
    Reply With Quote Reply With Quote
  27. 05-31-12 08:23 PM #97
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,011
    Betpoints: 1088

    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.
    Reply With Quote Reply With Quote
  28. 04-01-13 09:01 PM #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
    Reply With Quote Reply With Quote
  29. 04-16-13 12:19 PM #99
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,011
    Betpoints: 1088

    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))
    Reply With Quote Reply With Quote
  30. 06-27-13 11:28 PM #100
    gauchojake
    Have Some Asthma
    gauchojake's Avatar SBR PRO
    Join Date: 09-17-10
    Posts: 33,724
    Betpoints: 13152

    Nice bump hoopy. Gotta get prepped for nfl
    Reply With Quote Reply With Quote
  31. 11-18-13 01:25 PM #101
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 63
    Betpoints: 689

    does this work on google docs spreadsheet?
    Reply With Quote Reply With Quote
  32. 11-20-13 10:08 PM #102
    Lo$t
    BTC go brrrrrr
    Lo$t's Avatar Become A Pro!
    Join Date: 06-03-10
    Posts: 787
    Betpoints: 48

    Can I input Izzo any # into this thing?
    Reply With Quote Reply With Quote
  33. 11-20-13 11:15 PM #103
    kzee89
    kzee89's Avatar Become A Pro!
    Join Date: 03-08-10
    Posts: 78
    Betpoints: 25

    I like the idea of applying VBA knowledge to sports.
    Reply With Quote Reply With Quote
  34. 12-05-13 06:37 PM #104
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 63
    Betpoints: 689

    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 06:43 PM.
    Reply With Quote Reply With Quote
  35. 12-07-13 12:47 PM #105
    satana
    satana's Avatar Become A Pro!
    Join Date: 01-05-13
    Posts: 63
    Betpoints: 689

    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.
    Reply With Quote Reply With Quote
First 1234 Last
Top
« Previous Thread | Handicapper Think Tank | Next Thread »