Visualizing & Analyzing Flop Solver Data in Excel

[@jennky8447]

This work is immense, well done. Thankfully I can work with, understand and utilize it. I've struggled to understand flop textures and which player has advantage, it's not been intuitive to me. NOW I see it (finally)! This has been a Saturday well spent.

[@antoniomoraes3163]

This was amazing. Cheers from BRazil

[@eustakko2375]

Forrado

[@michelparmentier3063]

amazing work !

[@SolverSchool]

Thanks very much!

[@michelparmentier3063]

why did you switch from GTO+ to PIO solver ? What benefits / features did you value in PIO that couldn't be done in GTO+ ?

[@SolverSchool]

PioSolver lets you aggregate data across any node over multiple boards. You can do similar work in GTO+, but it's a little more clunky to generate data for more analysis in Excel. So I tend to use Pio for my aggregate, mass-data work. I still use GTO+ for everything else, including single board work.

[@michelparmentier3063]

@@SolverSchool ha, OK. thanks for clarifying.

[@IHTFTIHTDT]

incredible work, just need a copy of excel and ill be purchasing :)

[@PaperPlateParody]

What stakes do you play at?

[@NLHero]

Impressive work. Have you found a good way to aggregate turn/river runouts? I saw kanu7 had all the data on his solver that could be manipulated. I assume PIO is needed for this challenge.

[@SolverSchool]

Thanks for the kind words. I haven’t spent a ton of time on mass data analysis on turns/rivers yet, so I don’t have a specific answer for this question. It’s on my (long) list of things I’d like to get to. This game is too big to tackle everything. :)

[@gianpaolonapolitano5124]

really a great job...i'm waiting for online 100bb deep...but. i'm hoping tha you will send your product right now

[@SolverSchool]

Thank you! I have a few technical things I need to do to productize the sheet. I'm targeting end of May to get that done and up on my site for sale. I plan to have both this deep-stacked version and the online 100BB version up as separate products. Sign up for my mailing list at www.lukich.io for updates as to when this is ready. I'll also put up a separate video here as a promo. Thanks!

[@aniki8884]

Hi, great video it helped me a lot to analyze my own data! I don't understand to what corresponds the highlighted green and red cells in the equity, ev% and EQR columns (ip offense macro), could you please explain? I thought it was green higher than average and red below but it's obviously not. Thanks

[@SolverSchool]

Ah I should have explained that. Those denote cells that are either one standard deviation above or below the average. I was more interested in highlighting outliers.

[@aniki8884]

@@SolverSchool what do you mean by standard deviation?

[@SolverSchool]

It’s a measure of the degree of variation in a sample. More info about that here - en.m.wikipedia.org/wiki/Standard_deviation

[@Nytemaster]

kzbin.info/www/bejne/gHWkn2tqbrCLsMU Noticed Index 4 has an error under the straight category. As Ks Kd should be GUTSHOT and not STRAIGHT. Small detail but worthy of note. Great analysis and something I have done on a much smaller scale. I also tried doing some grouping and ended up with High, Medium, Low and Rag but including an A instead of R would have been better since many of the results with an A play much differently as you have undoubtedly already uncovered.

[@SolverSchool]

Thanks for the comment! I appreciate the call out and I’ve since fixed it!