Article 1 Set up my own ranges
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    May 2009
    Posts
    32

    Default Article 1 Set up my own ranges

    Greetings:

    Again, my compliments to the chef. This series on plugging leaks is awesome. I'm trying to follow and use it with PLO. We believe these ideas will carry forward with of course some exceptions.
    At the very end of the article, Roy sets forth the steps to follow in order to come up with my own ranges and Median bb/100 values.
    My problem is with step 3:"Click on the very top left of the grid to select all, then Press Ctl-C and open Excel and press Ctl-V." I don't get it. I'm on a Player Summary with the Player Name on the top left. I am not given the choice to select all.
    Please help.
    Thank you,
    David

  2. #2
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Im not sure what article your referring to, you can right click the player summary and choose export grid as a csv file and then import it into a spreadsheet app like Excel
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  3. #3
    Senior Member _Loki_'s Avatar
    Join Date
    Jul 2009
    Location
    B/ham UK
    Posts
    2,856

    Default

    This is what Roy G. wrote in 2008 (I think when Roy wrote this HM did not have a better way to export data). Now the situation is different & it's easier to do what Morny suggests.:
    Plugging Leaks using Holdem Manager. Article 1: Determining typical bb/100 ranges based on Stat Ranges
    you can ...come up with your own ranges and Median bb/100 values by following these steps.

    1) Go to the players tab and set the applicable filters
    2) Run the default report
    3) Click on the very top left of the grid to select all, then Press Ctrl-C and open Excel and press Ctrl-V
    4) You can then sort by stats, one at a time and use the median formula to get the median bb/100 scores for each range you split it into. You can also create scatter graphs like I have done for VPIP through Excel
    ################

    This is my explanation of how to get the data into a spreadsheet so that you can sort & analyse it freely: Comma Separated Values (CSV) is text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma

    A] IN HOLD'EM MANAGER:
    To export right-click ANYWHERE in the 'player summary' window & choose 'Export Grid to CSV file' from the mouse context menu
    a file browser window opens
    choose where you want the csv file to be saved to (I save it in my docs)
    click 'OK'
    make a note of the file name when a dialog pops up to tell you it has been saved

    B] IN EXCEL (OR YOUR SPREADSHEET PROGRAM OF CHOICE):
    Open up Excel (or in my case OpenOffice Calc)
    Choose File - Open.
    Locate the CSV file that you have just exported above
    Select the file
    Click 'Open'
    The Text Import dialog opens
    Specify the options to divide the text in the file into columns
    You can preview the layout of the imported data at the bottom of the Text Import dialog
    Right-click a column in the preview to set the format or to hide the column
    Click OK

    Voila ! - the data is now in a spreadsheet table

    ################

  4. #4
    Junior Member
    Join Date
    Jul 2010
    Posts
    5

    Default

    I would also like to know how to do this. We're refering to article 1. The last paragraph sounds like it's an easy deal, but I don't get it. The players tab shows players names and stats, there's no such thing as run the original report there. Can we get a more friendly article on how to build the spreadsheet to get the medians?
    First we need to know how to get the data on HM, then exporting it should be a much easier deal.
    Last edited by du_repi_unda; 07-26-2011 at 07:37 PM. Reason: Fisrt

  5. #5
    Junior Member
    Join Date
    Jul 2010
    Posts
    5

    Default

    Disconsider my previous post. I was looking at the wrong tab: vs players instead of the players tab.

Similar Threads

  1. Article 8 Filters
    By Ajax in forum Manager General
    Replies: 0
    Last Post: 01-07-2010, 08:56 PM
  2. Article 1, Aggression
    By Ajax in forum Manager General
    Replies: 1
    Last Post: 07-08-2009, 01:31 AM
  3. Replies: 3
    Last Post: 07-05-2009, 04:10 PM
  4. Can't print Article 4
    By Squashy in forum Manager General
    Replies: 2
    Last Post: 08-29-2008, 08:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •