What does “swing hand” mean?
You can play any range you want, and really your range should be adjusted to the specific circumstances of the game you’re in. It’s mainly an abstract concept that can help you have discipline and structure in your game.
I see value in experimenting and exploring. Some games I’ve done well playing with a very wide range, but it all has to do with whether the dealer is generous with my hands postflop, which is a luck based approach, not a skill based one. But some games I just hit every hand, it seems. Or if I don’t, then the table is soft and I can bluff profitably.
Other times, no matter what range I play, I get screwed by the dealer, and every time hand is a mirage. I do well, if I can, by playing as few hands as possible. It’s still a luck based approach in that if I’m playing fewer hands, then I pretty much must win every time, and that depends mostly on the dealer’s generosity and my propensity to pick the right moment to bet, but if I am extremely tight, it helps that to happen. The main thing is that by playing fewer hands, I conserve chips, minimize risk, minimize mistakes, and let the rest of the table make their mistakes before I can make mine. I can do better against a short handed table with a small stack many times than I can against a full table even stacked, because the dealer’s a rotten scumbag who is always setting me up with hands that should be good early on, but end up being one disaster after another.
So if you asked me what my range is, I would have to say that don’t feel like I have a single range. I have a flexible concept of what range I should play, and it depends on the structure of the game, my stack size, how my luck has been running, and a bunch of other things. In other words, it isn’t written in stone, and I’ve never done your spreadsheet exercise, although I have to admit anything you can do to Poker with a spreadsheet piques my interest.
You can try being scientific and rigid with this stuff, and I think that’s worthwhile for educational purposes, but I suspect that coming out of it, you’ll probably conclude as I have that flexibility works better once you have a good grasp of the factors that should be influencing your range.