Interesting old thread that somehow returned.
Yes, PA is second in gaming revenue. Practically tied with NJ but barely ahead. And I believe also 2nd in Blackjack revenue but I couldn't find that...
VBA7 was introduced to address the issue of 64bit office support, it's not related to xls vs xlsx file format. The xlsx file format has been around since 2003. So I was questioning why was using an...
I suspect ya’ll are missing the most important part of card counting if you’re getting backed off or banned with a 50:10 5:1 bet spread. How you are perceived. I’ve never been backed off at a casino...
I think Secretariat and probably most everyone else with Excel uses newer version. I think newer versions have VBA 7 while I have VBA 6. VBA 7 is backward compatible to VBA 6 so code should work. I...
Javascript is pretty easy, and accessible to everyone. You can write scripts for drills like basic strategy, indices, card counting, etc.
Then when you get good at html you can add fancy...
Yes, friend betting from $10 to $50 on shoe game and be told he can never play BJ again. This is his home base. So he bet modestly. But some casino will ban all counters, including red chippers if...
Usually I hate philly rivers but thanks for the idea X-ray. Head over on my lunch break and up & $325 in under an hour, 2 shoes, 6 deck high limit table, $50 min, $75 starting bet, 4:1 bet spread. ...
Why are you using xls format, this is really old , just switch to the XML xlsx version. This has been around since 2003! And you can have 1 million rows in it!
Not OP, but I wish I had kept all of my receipts and hours / calculated results from when I was full timing it three years ago. I think over the lifetime of my play, I was a winning player, but...
Hi Sec,
What I can do is send you a compressed file with the 304,425 lines (9*25*33*41) and you simply import it into Excel (.xlsx).
Then, you delete all the lines whose sum is less than 39 or...
Hello Cac and K_C
You guys are the best
I just found that the . xls file format has a limit of 65,536 rows (as stated by k_c) in each sheet, while the . xlsx file format has a limit of...
You can input to Excel if VBA is accessible to you:
1. Open Visual Basic Editor: Tools/Macro/Visual Basic Editor - shortcut is alt F11
2. In VB Editor View/Project Explorer - shortcut is ctrl+r...