PDA

View Full Version : Basic Profit/ROI/ITM spreadsheet from burningyen

elonkra
06-19-2005, 10:16 PM
http://home.earthlink.net/~burningyen2/images/Poker-public.xls

I downloaded this from burningyen a while back (my computer doesn't seem to have the memory to run any of aleomagus's spreadsheets), and am finally getting around to using it. Can anyone explain what the SNG Profit tab is, or how it works? All I see is a big blue square.
suprblah
06-19-2005, 10:50 PM
It's a line chart plotting total profit vs. # of games. The blue square is the background and the line (surprisingly) is blue as well.
elonkra
06-19-2005, 10:56 PM
The toolbar says my line color is black. Do I have to input data or does it automatically compute from the SNG tab input? If I have to input data, how do I do that?
maddog2030
06-19-2005, 11:19 PM
Why not just use the newest spreadsheet floating around here? It has a lot of handy features, like autoimport from PT and tons of stats.
elonkra
06-20-2005, 12:30 AM
My computer can't handle the Aleomagus spreadsheets, for some inexplicable reason. It takes forever to load/enter dats, or won't load at all (virtual memory low error message). I have no problems with my comptuer speed/memory in any other contexts.
elonkra
06-20-2005, 02:11 PM
[ QUOTE ]
The toolbar says my line color is black. Do I have to input data or does it automatically compute from the SNG tab input? If I have to input data, how do I do that?

[/ QUOTE ]

bump
Slim Pickens
06-20-2005, 02:47 PM
If your computer is slow. You can go to Tools>Options>Calculation and set it to Manual. That way it won't try to calculate all the cells every time you change one thing. Once you've entered data, hit F9 (the manual recalculation button). You might want to try some of those new Soviet-made vacuum tubes too. That should speed things up.

SlimP
Slim Pickens
06-20-2005, 02:49 PM
It should plot the data you entered in the SNG tab. Hit F9?
Iridox
06-20-2005, 02:56 PM
Hood's SNG Tracker (http://sng.pokercomment.com) does everything that spreadsheet does automatically.
Slim Pickens
06-20-2005, 03:07 PM
[ QUOTE ]
Hood's SNG Tracker (http://sng.pokercomment.com) does everything that spreadsheet does automatically.

[/ QUOTE ]

The spreadsheet should be turnkey for most users now, but Hood's program is also nice. It's probably the much better option for those a little low on computing power. I just couldn't get it to correctly calculate my hourly rate so I gave up on it and went to the Excel spreadsheet since that's a program I know well. I don't see rows, columns, and cells anymore. I just see blonde, blonde, redhead, brunette, PROFIT!

SlimP