Home / Community / Forum / Poker Education / Poker Software & Videos & Literature /

Spreadsheet/Graphs

Old
Default
Spreadsheet/Graphs - Thu Dec 22, 2011, 10:47 AM
(#1)
pokerstar671's Avatar
Since: Aug 2010
Posts: 1,206
Im looking for an excel spreadsheet that can calculate my Sit and Go ROI and ITM%

Just something simple so I can just plug in the numbers and it will calculate all that.

Also I am wondering how to make graphs that show games and money won.

I don't know if there is one out there but if anyone has a link or something let me know.

 
Old
Default
Thu Dec 22, 2011, 09:06 PM
(#2)
TrustySam's Avatar
Since: Aug 2010
Posts: 8,291
BronzeStar
Well, this isn't an excel spreadsheet, but before I got the jr version of PT3 I was using this free software I downloaded from cnet: Poker Tracker

I remember worrying though that it might not have been completely accurate though?

Hopefully somebody will come along with something better

EDIT: It used to be free, now I see it costs $5. Meh, not worth the money I don't think

Last edited by TrustySam; Thu Dec 22, 2011 at 09:10 PM..
 
Old
Default
Fri Dec 23, 2011, 08:22 AM
(#3)
pokerstar671's Avatar
Since: Aug 2010
Posts: 1,206
Thanks for your reply TrustySam. I had pt3 before but expired so that might not work. Im gunna try to download that and see if it works tho.
 
Old
Default
Fri Dec 23, 2011, 09:19 AM
(#4)
Tomcrockpot's Avatar
Since: Oct 2011
Posts: 140
This is the sort of thing spreadsheets were made for..

Very easy to do, but then, I used to do spreadsheets for a living..

Anyway, here's the spreadsheet I made to track my cowboy results. Does everything you ask. Took me 5 minutes to create.

The graph is just a line graph of the PnL column
Attached Files
File Type: zip spreadsheet.zip (4.3 KB, 58 views)
 
Old
Default
Fri Dec 23, 2011, 08:27 PM
(#5)
pokerstar671's Avatar
Since: Aug 2010
Posts: 1,206
Wow thank your so much tomcrockpot.

Cool an early christmas gift thanks
 
Old
Default
Sat Dec 24, 2011, 07:37 AM
(#6)
Tomcrockpot's Avatar
Since: Oct 2011
Posts: 140
Quote:
Originally Posted by pokerstar671 View Post
Wow thank your so much tomcrockpot.

Cool an early christmas gift thanks
Happy to help. Merry xmas
 
Old
Default
Mon Dec 26, 2011, 04:24 PM
(#7)
PINOY_HITMAN's Avatar
Since: Oct 2010
Posts: 4,717
Thanks Tomcrockpot it's very useful in tracking your challenge progress with graphic presentation.

I insert new column to add the numbers of games played to make sure i did not miscount the games again buy just looking at the lines numbers only.

Great Help
 
Old
Default
Thu Dec 29, 2011, 03:53 PM
(#8)
PINOY_HITMAN's Avatar
Since: Oct 2010
Posts: 4,717
Tomcrocpot

Anyway i can put code on place finished?

exemple:
1=5.46
2=3.94
so on so forth

so when i put 1(mean 1st place) automatically 5.46 will add on Price.

Thanks in advance.
 
Old
Default
Thu Dec 29, 2011, 06:56 PM
(#9)
Tomcrockpot's Avatar
Since: Oct 2011
Posts: 140
Quote:
Originally Posted by PINOY_HITMAN View Post
Tomcrocpot

Anyway i can put code on place finished?

exemple:
1=5.46
2=3.94
so on so forth

so when i put 1(mean 1st place) automatically 5.46 will add on Price.

Thanks in advance.
Yeah, that's not a bad idea. Lookup tables are the way to go. Lookup the vlookup and hlookup functions.

I'll make the changes tomorrow and upload a new version.
 
Old
Default
Thu Dec 29, 2011, 09:57 PM
(#10)
PINOY_HITMAN's Avatar
Since: Oct 2010
Posts: 4,717
Quote:
Originally Posted by Tomcrockpot View Post
Yeah, that's not a bad idea. Lookup tables are the way to go. Lookup the vlookup and hlookup functions.

I'll make the changes tomorrow and upload a new version.
thanks man it will save a lots of time in updating the table
 
Old
Default
Thu Dec 29, 2011, 11:42 PM
(#11)
PINOY_HITMAN's Avatar
Since: Oct 2010
Posts: 4,717
Got it man, just watched how vlookup was done via video in you tube.
 
Old
Default
Fri Dec 30, 2011, 11:07 AM
(#12)
Tomcrockpot's Avatar
Since: Oct 2011
Posts: 140
Quote:
Originally Posted by PINOY_HITMAN View Post
Got it man, just watched how vlookup was done via video in you tube.


glad you're learning. Excel is not as hard as some people think and you can do a lot with it.

The version I've just attached has multiple tables for the 25c and 50c and formulas to look up the appropriate table for the tournament type you've entered
Attached Files
File Type: zip cowboyChallenge.xls.zip (38.3 KB, 12 views)
 
Old
Default
Fri Dec 30, 2011, 12:55 PM
(#13)
PINOY_HITMAN's Avatar
Since: Oct 2010
Posts: 4,717
Quote:
Originally Posted by Tomcrockpot View Post


glad you're learning. Excel is not as hard as some people think and you can do a lot with it.

The version I've just attached has multiple tables for the 25c and 50c and formulas to look up the appropriate table for the tournament type you've entered

Thanks Tom
 

Getting PokerStars is easy: download and install the PokerStars game software, create your free player account, and validate your email address. Clicking on the download poker button will lead to the installation of compatible poker software on your PC of 51.7 MB, which will enable you to register and play poker on the PokerStars platform. To uninstall PokerStars use the Windows uninstaller: click Start > Control Panel and then select Add or Remove programs > Select PokerStars and click Uninstall or Remove.

Copyright (c) PokerSchoolOnline.com. All rights reserved, Rational Group, Douglas Bay Complex, King Edward Road, Onchan, Isle of Man, IM3 1DZ. You can email us on support@pokerschoolonline.com