#1
|
|||
|
|||
Grapher for postgreSQL
My PokerGrapher does not like postgreSQL. I don't have excel, but rather OpenOffice (never used their spreadsheet program before, however). I'd like to graph. Help?
|
#2
|
|||
|
|||
Re: Grapher for postgreSQL
The best you can do is graph the points after each session AFAIK. If that's what you want to do, just export hands played and won/loss for the session to an excel file.
In a new column make it something like: Column A - hand session Column B - winnings session Column C - make C1 "=A1" make C2 "=C1+A2" copy C2 into all the rest of column C that you need to Do the same thing for D Now you have a running total of hands, and a running total of winnings. Graph with the hands on the X-axis, and the winnings on the Y-axis. If you want to do BB, make sure you also export the game level, and you can set up an IF statement to change the monetary winnings into BB winnings. |
#3
|
|||
|
|||
Re: Grapher for postgreSQL
you fucking georgia tech students...
thanks bro [img]/images/graemlins/grin.gif[/img] |
#4
|
|||
|
|||
Re: Grapher for postgreSQL
[ QUOTE ]
you fucking georgia tech students... [/ QUOTE ]Hmm. I'm a GATech grad student, and I'm unhappy with this. [img]/images/graemlins/smile.gif[/img] I don't want 8 steps to get a graph. Heck, one of the steps was "paste this as many times as needed". Ick. I want a SQL report. It's a database, dammit. I shouldn't have to export to a spreadsheet. I was going to write something in Crystal, but I'd be happier if somebody else did it for me. [img]/images/graemlins/smile.gif[/img] -Sam |
#5
|
|||
|
|||
Re: Grapher for postgreSQL
Make a backup copy of your access db. Delete the existing tables and then link your Postgres tables into Access. Make sure you rename the link from public_* to *. Pokergrapher should work perfectly then. [img]/images/graemlins/wink.gif[/img]
|
#6
|
|||
|
|||
Re: Grapher for postgreSQL
</font><blockquote><font class="small">En réponse à:</font><hr />
Hmm. I'm a GATech grad student, and I'm unhappy with this. [img]/images/graemlins/smile.gif[/img] [/ QUOTE ] blah blah blah [img]/images/graemlins/cool.gif[/img] </font><blockquote><font class="small">En réponse à:</font><hr /> I don't want 8 steps to get a graph. Heck, one of the steps was "paste this as many times as needed". Ick. [/ QUOTE ] Put it in the top cell. Put the mouse over the bottom right corner of the cell so it turns into a bold cross. Double-click and it'll post it all the way down until there is no more data. You're obviously NOT an IE grad student [img]/images/graemlins/tongue.gif[/img] |
#7
|
|||
|
|||
Re: Grapher for postgreSQL
[ QUOTE ]
You're obviously NOT an IE grad student [img]/images/graemlins/tongue.gif[/img] [/ QUOTE ]You're right. In grad school, we call it IsYE. I'm in the ACO program; that's like IsYE. Oh, except we do Math and ComputerScience, too. [img]/images/graemlins/cool.gif[/img] I agree that it's only a few steps every time you want to export, convert, and graph. But it's still a kludgy use of a database. SQL cries every time you export into a spreadsheet. A friend, who's much better at this stuff than I am, has offered to write a Crystal back-end for Pokertracker with me, mostly for graphing. We'll see how it goes. -Sam |
#8
|
|||
|
|||
Re: Grapher for postgreSQL
Anyone know how to invert a column in Excel? PT exports as the last session first and I want the first session first.
|
#9
|
|||
|
|||
Re: Grapher for postgreSQL
Toolbar/Data/Sort...
|
#10
|
|||
|
|||
Re: Grapher for postgreSQL
Or, you could invert the data in PT, and then have it export that way.
|
|
|