The goal is to use a spreadsheet to display range charts
We will demonstrate the idea using this range:
The range represents BB vs a CO open raise, with no other callers
I have created the spreadsheet, but the instructions for creating it are mega complicated.
I'm going to try to see if I can open it in Google Sheets.
If I can, I'll post the link, and hopefully it can then be opened in LibreOffice or OpenOffice
Well, it is possible to open the spreadsheet in Google Sheets.
You can view it here:
https://docs.google.com/spreadsheets/d/1pZqY_qkPDrzVyAKrWaWwn8otuQ_i2hwHlFOOGfEzAEA/edit?usp=sharing
Download it and upload it to your own Google Drive if you have one.
It may open in other spreadsheet software -- I wouldn't know.
There are 4 sheets -- the template which you copy to make your own scenarios.
The other 3 are examples for:
facing an open raise
as open raiser facing a 3Bet
Raising first in
I hope this is useful to someone -- I did it in response to a question about how to display ranges in LibreOffice.
All I have is Excel, so I used that.
Enjoy...
VS
Hello VorpalF2F why dont use you use one of the excel spredsheets already out there :
You have buttons for every position and vs every position, you dont have to click the sheets like in your template.
Alleen86 made the first spredsheet looking like this here on Pokerstrategy and made it available for all on his blog Croatian BlogBuster - Full-Time Teacher Playing Poker.
After that many people from all over the internet got it from him and change it for their use.
I got in love with this kind of speedsheet since I first laid my eyes on it.
Originally posted by AgapieGheorghe
Hello VorpalF2F why dont use you use one of the excel spredsheets already out there :
Two reasons:
1: I didn't know it existed! Thanks for pointing it out
2: The 2nd goal was to create a tool that did not involve code, since people using Google Sheets, LibreOffice or OpenOffice don't have that ability.
I will check out the existing spreadsheet
Edited: I've downloaded it. I'll go over it after my stream today
I found the Excel Ranges to download, since it is in his footer.
But I cannot figure out how to make changes. Can you tell me how to make changes or where I can find the post where it is explained?
Originally posted by VorpalF2F
I will check out the existing spreadsheet
Edited: I've downloaded it. I'll go over it after my stream today
NARF[1]
I didn't do this.
If I can find the download, I'll do it after today's session (assuming I remember and assuming I can find the download)
Cheers,
VS
[1] Normal Age-Related Forgetfulness
Originally posted by Tyrion88
I found the Excel Ranges to download, since it is in his footer.But I cannot figure out how to make changes. Can you tell me how to make changes or where I can find the post where it is explained?
You ask for the Excel ranges from Alleen86 ?
Yes I do. But I also wrote you on your blog.
I think the Excelsheet is great for having it open while playing. But I would need my own ranges in it.
The sheet is pasword protected I think.
I have that, Ranges3.1.xlms
If you are looking to order any displays I'll need to receive some info one way or another..................................
Originally posted by Tyrion88
Yes I do. But I also wrote you on your blog.
I think the Excelsheet is great for having it open while playing. But I would need my own ranges in it.
The sheet is pasword protected I think.
I have that, Ranges3.1.xlms
I always check my blog after i browse the forum ♦ I made the video i promised.
Hi Asdrubal999,
The link to the sheet is in this post: https://forums.pokerstrategy.com/forum/thread.php?postid=3111688#post3111688
If you have a google account, you can just open it.
When you do, make a copy for yourself.
There is another one here:
https://forums.pokerstrategy.com/forum/thread.php?threadid=252559
That one is provided by another member -- see this post: https://forums.pokerstrategy.com/forum/thread.php?postid=3111855#post3111855
Also, it requires Excel, whereas the Google one should work for anyone.
If you have trouble with any of the links, please let us know...
Cheers,
VS
Hi,
I want to make a spreadsheet with my ranges. Alleen86's link to his was deleted. Was the spreadsheet editable ? Can someone send it to me ?
Originally posted by PawwelPL
Hi,
I want to make a spreadsheet with my ranges. Alleen86's link to his was deleted. Was the spreadsheet editable ? Can someone send it to me ?
Unfortunately, I did not download Alleen86's spreadsheet, and even if I had I don't think I would be comfortable sharing it if he or she no longer wished to make it public.
His spreadsheet required Excel
Here is one I created that can be used in Google sheets, and allows you to input your own ranges.
https://docs.google.com/spreadsheets/d/1pZqY_qkPDrzVyAKrWaWwn8otuQ_i2hwHlFOOGfEzAEA/edit#gid=1071696090
Hopefully it will be of some use.
Just copy it into your own Google workspace.
Cheers,
VS
hey hello, i would like to create an excel just like on the picture. i have my own ranges but i have no idea how to create an excel like that
Hi Hi grinder0912,
Welcome to PokerStrategy.com 
Click this link, and it should take you to a google sheet with instructions:
https://docs.google.com/spreadsheets/d/1pZqY_qkPDrzVyAKrWaWwn8otuQ_i2hwHlFOOGfEzAEA/edit#gid=1071696090
Use the file menu of Google Sheets to save yourself a copy.
Cheers,
VS
hi, thank you for repliying. im pretty noob at excel and the instructions on the shet are to simple to me to understand how to create an excel. is there anywhere a moore detailed explnation?
