Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Small Stakes MTT Discussion and analysis of small stakes MTT strategy

Reply
 
Thread Tools Display Modes
Old 07-24-2010, 08:23 AM   #51
TheSpecial1
stranger
 
TheSpecial1's Avatar
 
Join Date: Jul 2010
Posts: 12
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

what a great work! thank you very much
TheSpecial1 is offline   Reply With Quote
Old 07-24-2010, 11:44 AM   #52
TeamTrousers
talks the talk
 
TeamTrousers's Avatar
 
Join Date: Sep 2009
Location: Remembering when stars was good
Posts: 12,899
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

OP just PM'd me. Apparently the chart is filled with errors and he said you should probably all delete it immediately in case you use it again by mistake.

Last edited by TeamTrousers; 07-24-2010 at 11:44 AM. Reason: nh tho OP, grats on 1k
TeamTrousers is offline   Reply With Quote
Old 08-03-2010, 02:08 PM   #53
ppatak
journeyman
 
ppatak's Avatar
 
Join Date: Oct 2009
Posts: 392
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Thank you for sharing!
ppatak is offline   Reply With Quote
Old 08-03-2010, 03:07 PM   #54
Hustlin Donkeys
stranger
 
Join Date: Feb 2010
Posts: 4
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Thank you!
Hustlin Donkeys is offline   Reply With Quote
Old 08-03-2010, 07:35 PM   #55
abracadabrab
veteran
 
abracadabrab's Avatar
 
Join Date: Jul 2009
Location: Samson Simpson, l stick by my story
Posts: 2,572
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

WOW! Thanks so much!!! This is awesome and it is so easy to use. Very user friendly.
abracadabrab is offline   Reply With Quote
Old 08-03-2010, 10:32 PM   #56
ShipItMehr
Pooh-Bah
 
Join Date: Feb 2008
Location: MD...Moco represent!
Posts: 3,639
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

thanks man. i just found your old one 2 days ago and now this one. seems like a lot more stuff so i need to read your manual. really appreciate it very awesome of you. used it yesterday and today and felt a lot more confident about my shoves.
ShipItMehr is offline   Reply With Quote
Old 08-03-2010, 11:39 PM   #57
GoneGrinding
banned
 
Join Date: Oct 2008
Location: P-Town Au$tralia
Posts: 140
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

This is amazing, your hard work is appreciated
GoneGrinding is offline   Reply With Quote
Old 08-15-2010, 07:51 PM   #58
marvs
stranger
 
Join Date: Apr 2008
Posts: 8
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Hi there,

I actually found a bug in your spreadsheet, which wasn't in rev 2.0.

When i change the percentage which stands for green or red cells in for instance pushbot for the second time or more, the percentages in the 2-a a-2 field are not updated and and there isn't a slide in the color patern. As i said in rev 2.0 this is working fine. I don't got a clue can you help me pls?

Greetz
marvs is offline   Reply With Quote
Old 08-15-2010, 08:59 PM   #59
JITxpert
old hand
 
JITxpert's Avatar
 
Join Date: Jun 2009
Location: New Hampshire
Posts: 1,930
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Quote:
Originally Posted by marvs View Post
Hi there,

I actually found a bug in your spreadsheet, which wasn't in rev 2.0.

When i change the percentage which stands for green or red cells in for instance pushbot for the second time or more, the percentages in the 2-a a-2 field are not updated and and there isn't a slide in the color patern. As i said in rev 2.0 this is working fine. I don't got a clue can you help me pls?

Greetz
Hmm....could you please elaborate, or perhaps take a screen shot? I will try to replicate and repair.
JITxpert is offline   Reply With Quote
Old 08-15-2010, 09:12 PM   #60
jessebooy
banned
 
jessebooy's Avatar
 
Join Date: Mar 2010
Location: trying to get high..
Posts: 131
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

thanks for sharing man awesome!
jessebooy is offline   Reply With Quote
Old 08-16-2010, 07:21 AM   #61
marvs
stranger
 
Join Date: Apr 2008
Posts: 8
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Hi Jitexpert,

thx for the help!
So situation before: left is rev 2.0 right is rev 4.2



Now I change the value of the green cells to 25%, notice that rev2.0 change the cell color from for example pocket 6's from green to yellow. In Rev 4.2 6's remain green.



If it's still not clear just let me know.

grtz
marvs is offline   Reply With Quote
Old 08-16-2010, 07:32 AM   #62
JITxpert
old hand
 
JITxpert's Avatar
 
Join Date: Jun 2009
Location: New Hampshire
Posts: 1,930
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

This is very clear. I just downloaded the spreadsheet, and typed in your numbers and got the correct results (which are the results on the left from version 2.0).

I recommend delete the version you have, download it from the link on page 1 of this thread, and try again. PM me if it still doesn't work.
JITxpert is offline   Reply With Quote
Old 08-16-2010, 10:31 AM   #63
ExaMeter
Pooh-Bah
 
ExaMeter's Avatar
 
Join Date: Jul 2006
Posts: 3,986
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

this is great stuff.

i always thought of creating something like your resteal bot myself but i suck at excel.

i have to minor ideas for improvement though.

first i would love to be able to input villains pfr instead of my perceived resteal succes rate.
i.e. have a field called Villain Opening Range (R5) below Villain Calling Range (R4) and have the resteal fold field (E17) be "=(1-R4/R5)".
i would do this myself but i have no idea how to unlock the cells. is that even possible for someone not the author of the file? ive tried looking in open offices help and googled as well but didnt find anything on this.

my other idea is to have more ranges for the call bot. like any2 and 70% and stuff like that. guess i will be using your great tool mostly for postanalysis and not while playing anyways and the calling problems can be easily done in pokerstove but it would be a nice touch.

thanks a lot anyways, this thing is great.
ExaMeter is offline   Reply With Quote
Old 08-16-2010, 12:33 PM   #64
ppatak
journeyman
 
ppatak's Avatar
 
Join Date: Oct 2009
Posts: 392
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Thank you
ppatak is offline   Reply With Quote
Old 08-16-2010, 12:41 PM   #65
Nutty74
journeyman
 
Join Date: Jul 2010
Location: Costa Blanca
Posts: 243
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Hey Guys, long time lurker first time poster etc etc..

I often read the MTT strategy forums, there is always a number of very good contributions imo.

Anyways reason for my first post was to thank OP for the spreadsheet. It is really very good.

I can also use my first post to congratulate you on a very good 1000th post
Nutty74 is offline   Reply With Quote
Old 08-17-2010, 07:06 PM   #66
D_fish
centurion
 
D_fish's Avatar
 
Join Date: Mar 2009
Posts: 134
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Complete newb to MTT's and this has helped a lot! Intresting to see how wide it's profitable to push on the button. Hopefully I can get an answer to a newbish question;

Is ICM only applicable in shorthanded STT? I though it became less certain the more players involved? For example i've just started playing 135man rush tourneys and I am unsure how to apply the ICM bot function in the final stages.
D_fish is offline   Reply With Quote
Old 08-17-2010, 09:04 PM   #67
Stasheft
journeyman
 
Stasheft's Avatar
 
Join Date: Feb 2010
Location: This eternal moment
Posts: 232
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Wow, thanks a ton JIT
Stasheft is offline   Reply With Quote
Old 08-18-2010, 09:39 AM   #68
Jonathan
old hand
 
Join Date: Jan 2004
Posts: 1,711
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

JIT,
I downloaded your spreadsheet and instructions and have a question.

Is this intended for use while you are playing at the table?
Or is it intended for review, like SitandGo Wizard?

Are people inputting these values while they are playing?
Jonathan is offline   Reply With Quote
Old 08-18-2010, 12:46 PM   #69
rpiske
newbie
 
rpiske's Avatar
 
Join Date: May 2010
Location: wait for it..
Posts: 44
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Really great stuff.

Ty, sir!
rpiske is offline   Reply With Quote
Old 08-18-2010, 03:44 PM   #70
JITxpert
old hand
 
JITxpert's Avatar
 
Join Date: Jun 2009
Location: New Hampshire
Posts: 1,930
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Quote:
Originally Posted by Jonathan View Post
JIT,
I downloaded your spreadsheet and instructions and have a question.

Is this intended for use while you are playing at the table?
Or is it intended for review, like SitandGo Wizard?

Are people inputting these values while they are playing?
I def use this when reviewing HHs, and I have been known to timebank at a FT just to see what's up.
JITxpert is offline   Reply With Quote
Old 08-26-2010, 05:44 AM   #71
JITxpert
old hand
 
JITxpert's Avatar
 
Join Date: Jun 2009
Location: New Hampshire
Posts: 1,930
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

bumping so people can find it since the forum split....
JITxpert is offline   Reply With Quote
Old 08-26-2010, 05:50 AM   #72
furo
deviation of equilibrium
 
furo's Avatar
 
Join Date: May 2009
Location: Germany
Posts: 29,644
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

George,

for a future Version (in case there will be one)

is it possible to add certain hands to a specific range?
like if villain will call with 77+ AJ+ in general and KQs ~50% of the time?

cheers
furo is offline   Reply With Quote
Old 08-26-2010, 06:27 AM   #73
JITxpert
old hand
 
JITxpert's Avatar
 
Join Date: Jun 2009
Location: New Hampshire
Posts: 1,930
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Quote:
Originally Posted by furo View Post
George,

for a future Version (in case there will be one)

is it possible to add certain hands to a specific range?
like if villain will call with 77+ AJ+ in general and KQs ~50% of the time?

cheers
To make the data table for the ranges, I had to fix a range in pokerstove, then type in all 169 hand combos, click calculate, then copy and paste into the spreadsheet. So the range data is static. If only I had the source code to pokerstove.....

But anyway, I have found that some suggested ranges are soooo close to one of the ranges in the spreadsheet that it is "close enough" and a good estimate.

Try taking the range you have above and comparing it to a close range (the 7.5% looks right) in the spreadsheet. Check the equity of like 10 hands and see how close it really is. I think you will be surprised. (Try like TT AQs 89s KQo 55 QQ A8s ATo...)

So really, when you are selecting a range, you are ESTIMATING. So maybe the range you are thinking isn't on the spreadsheet, so get one that looks close, and realize that the "fringe" +cEV hands could be affected by the fact that they are not against the exact range.
JITxpert is offline   Reply With Quote
Old 08-26-2010, 06:40 AM   #74
EPortJake
adept
 
EPortJake's Avatar
 
Join Date: Dec 2007
Posts: 809
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Awesome work dude. You are an excel ninja!
EPortJake is offline   Reply With Quote
Old 08-26-2010, 06:46 AM   #75
furo
deviation of equilibrium
 
furo's Avatar
 
Join Date: May 2009
Location: Germany
Posts: 29,644
Re: Updated PushBot Spreadsheet, 1000 Post Thank You

Quote:
Originally Posted by JITxpert View Post
To make the data table for the ranges, I had to fix a range in pokerstove, then type in all 169 hand combos, click calculate, then copy and paste into the spreadsheet. So the range data is static. If only I had the source code to pokerstove.....

But anyway, I have found that some suggested ranges are soooo close to one of the ranges in the spreadsheet that it is "close enough" and a good estimate.

Try taking the range you have above and comparing it to a close range (the 7.5% looks right) in the spreadsheet. Check the equity of like 10 hands and see how close it really is. I think you will be surprised. (Try like TT AQs 89s KQo 55 QQ A8s ATo...)

So really, when you are selecting a range, you are ESTIMATING. So maybe the range you are thinking isn't on the spreadsheet, so get one that looks close, and realize that the "fringe" +cEV hands could be affected by the fact that they are not against the exact range.
yea i know, i already use it this way alot and its really awesome since its done so fast and accurate.

just saying its not perfect yet to calculate the EV and if there was a way to fix that it would be great for the next version of the sheet.
furo is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 07:35 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2010, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online