![]() | Bovada is the only Internet casino endorsed by the Wizard. Here are my reasons why and my promise of support. |
Data set for Las Vegas Blackjack survey?
| February 23rd, 2010 at 10:41:31 PM permalink | |
| jpr Member since: Feb 23, 2010 Threads: 1 Posts: 2 | Is there any chance of getting an excel file or another format data set for Blackjack survey? I would love to be able to filter the table to find a "best tables" cheat sheet for wherever I end up along the strip. Love the site by the way, I have been using it for years to brush up before each Vegas trip. Just bought your gambling 102 for a friend who never quite learns the rules. Thanks, JPR |
| February 24th, 2010 at 11:48:41 AM permalink | |
| wildqat Member since: Nov 11, 2009 Threads: 4 Posts: 157 | I've just been copypasting the page into Excel. Step by step: 1) Select the entire page 2) Paste Special as text (not HTML) 3) Delete all the extra rows above and below the table and footnotes (including the Key, uness you think you need it) 4) Delete all the extra header rows (easiest way is to sort by "BJ Pays" and delete all the extra headers at the bottom) 5) Change the "6-5", "5-4" and "1-1" entries to "'6-5", "'5-4" and "'1-1" (Excel interprets them as dates instead of text; again, easiest way I've found is sort by "Game", make the edits manually and copy down) 6) Merge the footnotes cells across the table (otherwise they'll mess up the first column if you try to autofit the data) 7) Table it up It takes me about five minutes. |
| February 24th, 2010 at 10:35:54 PM permalink | |
| jpr Member since: Feb 23, 2010 Threads: 1 Posts: 2 | Thanks wildqat! As soon as you said copy and paste into Excel, it reminded me to try the simple solutions before speaking :) Thanks again, JPR |
| March 1st, 2010 at 9:28:09 PM permalink | |
| Wizard Administrator Member since: Oct 14, 2009 Threads: 256 Posts: 5776 | If you buy a subscription at bj21.com you get the blackjack rules for the whole country in either Excel or PDF format. JPR, thanks for buying my book. I heard somebody out there bought a copy. It's not whether you win or lose; it's whether or not you had a good bet. |
![]() | Bovada is the only Internet casino endorsed by the Wizard. Here are my reasons why and my promise of support. |
