Thread Rating:

MrV
MrV
Joined: Feb 13, 2010
  • Threads: 357
  • Posts: 7973
June 13th, 2023 at 2:47:13 PM permalink
I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
"What, me worry?"
ryaanwilliiamss
ryaanwilliiamss
Joined: Jun 12, 2023
  • Threads: 0
  • Posts: 4
June 14th, 2023 at 6:11:37 AM permalink
Wow, winning $1.5 million on a single video poker pull sounds incredible! While it's hard to believe such a claim without concrete evidence, it's interesting to see how people are vigorously discussing and debating it. The online flame wars can get intense, but let's keep the conversation civil and focus on enjoying the excitement of big wins in the gambling world.
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
June 14th, 2023 at 7:31:58 AM permalink
Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
This forum is more enjoyable after I learned how to use the 'Block this user' button.
Joeman
Joeman
Joined: Feb 21, 2014
  • Threads: 35
  • Posts: 2377
June 14th, 2023 at 8:22:53 AM permalink
Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post

Or a link? Google is coming up empty for me.
"Dealer has 'rock'... Pay 'paper!'"
Joeman
Joeman
Joined: Feb 21, 2014
  • Threads: 35
  • Posts: 2377
June 14th, 2023 at 8:22:55 AM permalink
Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post

Or a link? Google is coming up empty for me.
"Dealer has 'rock'... Pay 'paper!'"
UP84
UP84
Joined: May 22, 2012
  • Threads: 3
  • Posts: 366
June 14th, 2023 at 8:48:06 AM permalink
Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post

I agree...some of the high limit VP machines have the potential to hit 7 figure payouts.

Also, on the STP pay you witnessed...I think the STP play rules state that if the player is dealt a Royal and also has a multiplier, the multiplier will automatically be 10x.
ETA...I was wrong on STP, the auto max multiplier is on DSTP only.
Last edited by: UP84 on Jun 14, 2023
rsactuary
rsactuary
Joined: Sep 6, 2014
  • Threads: 29
  • Posts: 2297
Thanks for this post from:
UP84Dieter
June 14th, 2023 at 9:06:36 AM permalink
Quote: UP84

Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post

I agree...some of the high limit VP machines have the potential to hit 7 figure payouts.

Also, on the STP pay you witnessed...I think the STP play rules state that if the player is dealt a Royal and also has a multiplier, the multiplier will automatically be 10x.
link to original post



That's only Double Super Times Pay and it's 20x
UP84
UP84
Joined: May 22, 2012
  • Threads: 3
  • Posts: 366
June 14th, 2023 at 9:28:28 AM permalink
Quote: rsactuary

Quote: UP84

Also, on the STP pay you witnessed...I think the STP play rules state that if the player is dealt a Royal and also has a multiplier, the multiplier will automatically be 10x.
link to original post

That's only Double Super Times Pay and it's 20x

Thanks. I've updated my post.
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
June 14th, 2023 at 9:34:35 AM permalink
Quote: UP84

Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post

I agree...some of the high limit VP machines have the potential to hit 7 figure payouts.

Also, on the STP pay you witnessed...I think the STP play rules state that if the player is dealt a Royal and also has a multiplier, the multiplier will automatically be 10x.
link to original post

I was not aware of the guaranteed 10x multiplier rule. That makes the hand I saw tens of times more probable than if the 10x was earned.

I am checking some UX games online on a site that shows the highest historical wins on its games. I am seeing that some player won 4800 times the bet on a 3-play UX game, so a dealt RF at a 6x multiplier which would pay $1.8M with max bet at the $25 denom. The actual hand was almost certainly played at a very low denom.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
UP84
UP84
Joined: May 22, 2012
  • Threads: 3
  • Posts: 366
June 14th, 2023 at 9:36:55 AM permalink
Quote: Mental

I was not aware of the guaranteed 10x multiplier rule. That makes the hand I saw tens of times more probable than if the 10x was earned.

I was wrong on that...it's only DSTP. My bad.
ChumpChange
ChumpChange
Joined: Jun 15, 2018
  • Threads: 101
  • Posts: 4484
June 14th, 2023 at 10:58:20 AM permalink
Quote: Mental

Quote: MrV

I'm reading accounts of someone winning $1.5 Million on one VP pull at Resorts World.

I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.

Crazy, just flippin' crazy.
link to original post

I am not understanding what is hard to believe about this. Just play $125 a hand on a 3-play game and flop a Royal with a 5x multiplier. 3*125*800*5 = $1.5M. There are so many ways to hit a big hand if you consider bigger multipliers or multiplied multipliers or bigger N-play and you can do it at a $10 or $5 denomination.

I personally saw a dude deal himself a Royal on a 5-play Super Times Pay game with a 10x multiplier. He was playing quarters and 1.25*5*10*800 = $50K.

Are there any details associated with the claim?
link to original post



I'm glad somebody figured out the math before I figured it out wrong.
Talldude90
Talldude90
Joined: Aug 24, 2022
  • Threads: 11
  • Posts: 113
June 14th, 2023 at 8:11:00 PM permalink
To the original point of this thread, since I've never posted in it before:

5800 on a $1.60 pull on a new game (to me) I was doing research on :). Jackpot bonus and it did the thing where it looked like it was gonna just miss the grand for the 5x the bet prize and just stopped!
rxwine
rxwine
Joined: Feb 28, 2010
  • Threads: 200
  • Posts: 11874
July 5th, 2023 at 1:48:32 PM permalink
I hate when this happens.



++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++
Casino offered her a steak dinner for the malfunction.

https://www.msn.com/en-us/news/crime/woman-who-won-43-million-at-casino-offered-steak-dinner-instead-of-her-winnings/ar-AA1dtEKm?ocid=msedgntp&cvid=30f4cea8386340f39b8b53b697e34f0e&ei=14
There's no secret. Just know what you're talking about before you open your mouth.
MrV
MrV
Joined: Feb 13, 2010
  • Threads: 357
  • Posts: 7973
Thanks for this post from:
Joeman
July 5th, 2023 at 4:06:58 PM permalink
Quote: Joeman

Or a link? Google is coming up empty for me.



Just saw this, sorry about the delay.

There is a problem.

The claimant is a banned member, I do not want to run afoul of the rules, so "no names."

I and most others believe the claim was fabricated, but who knows?

But here's a screenshot:

"What, me worry?"
ChumpChange
ChumpChange
Joined: Jun 15, 2018
  • Threads: 101
  • Posts: 4484
July 6th, 2023 at 6:09:10 AM permalink
Mr. Handpay has some taxes to explain (but he doesn't) after all this winning!


He exp[ains his comps & mailers in this video below.


I might try Foxwoods for weekends after watching this video, if I ever get good enough.
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 6th, 2023 at 6:25:20 AM permalink
Quote: ChumpChange

Mr. Handpay has some taxes to explain (but he doesn't) after all this winning!

He explains his comps & mailers in this video below.

I might try Foxwoods for weekends after watching this video, if I ever get good enough.
link to original post

Taxable of $300K in six months is okay, I guess. I am averaging over $500,000 in tax reportable wins per month. I had two jackpots in March that totaled $154K by themselves. I spend about 40 hours per year just collating all of my W2-G information because it is reported in different formats by different casinos and the whole project is a giant PITA.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
DRich
DRich
Joined: Jul 6, 2012
  • Threads: 86
  • Posts: 11061
July 6th, 2023 at 8:08:48 AM permalink
Quote: Mental

Quote: ChumpChange

Mr. Handpay has some taxes to explain (but he doesn't) after all this winning!

He explains his comps & mailers in this video below.

I might try Foxwoods for weekends after watching this video, if I ever get good enough.
link to original post

Taxable of $300K in six months is okay, I guess. I am averaging over $500,000 in tax reportable wins per month. I had two jackpots in March that totaled $154K by themselves. I spend about 40 hours per year just collating all of my W2-G information because it is reported in different formats by different casinos and the whole project is a giant PITA.
link to original post



If you are not aware, the IRS will provide you a list of all reported income that you can use to file your taxes. I was not aware of that until the IRS informed me that I did not claim about $30,000 in W2G's that were filed with them. From that point forward I would go to the IRS in March and request a list of all income reported. I also found out that many times a casino may forget to report some W2G's and therefore some people may also choose not to include that W2G on their taxes.
At my age, a "Life In Prison" sentence is not much of a deterrent.
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 6th, 2023 at 9:20:51 AM permalink
Quote: DRich


If you are not aware, the IRS will provide you a list of all reported income that you can use to file your taxes. I was not aware of that until the IRS informed me that I did not claim about $30,000 in W2G's that were filed with them. From that point forward I would go to the IRS in March and request a list of all income reported. I also found out that many times a casino may forget to report some W2G's and therefore some people may also choose not to include that W2G on their taxes.
link to original post

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.
Quote: IRS

Wage and Income Transcript - shows data from information returns we receive such as Forms W-2, 1098, 1099, and 5498. The transcript is limited to approximately 85 income documents. If you have more documents than that, the transcript will not generate. Youíll receive a notification online stating that your transcript request could not be processed and to complete and submit Form 4506-T. If you see a message of ďNo Record of return filedĒ for the current tax year, it means information has not populated to the transcript yet. Check back in late May. This transcript is available for the current and nine prior tax years using Get Transcript Online or Form 4506-T.


Quote: Form 4506-T

Form W-2, Form 1099 series, Form 1098 series, or Form 5498 series transcript. The IRS can provide a transcript that includes data from these information returns. State or local information is not included with the Form W-2 information. The IRS may be able to provide this transcript information for up to 10 years. Information for the current year is generally not available until the year after it is filed with the IRS. For example, W-2 information for 2016, filed in 2017, will likely not be available from the IRS until 2018. If you need W-2 information for retirement purposes, you should contact the Social Security Administration at 1-800-772-1213. Most requests will be processed within 10 business days.

I also cannot e-file my tax returns because I exceed certain limits. I end up printing about 100 pages that the IRS presumably scans back to electronic form.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
MrV
MrV
Joined: Feb 13, 2010
  • Threads: 357
  • Posts: 7973
July 6th, 2023 at 9:48:54 AM permalink
Quote: Mental



I I spend about 40 hours per year just collating all of my W2-G information because it is reported in different formats by different casinos...



What "different formats?" and how do they work?

All I ever get are the paper W2-G statements provided by staff at the time I am paid.

I assume that at your play level there is some form of electronic wizardry at play?

I know little about such things but I have seen on slot videos how some big players in high limit are able to seemingly avoid the hassle and delay of dealing with staff after a jackpot simply by pushing a button or two.

I've never seen it in play at the tribal casinos I play at in Oregon.
"What, me worry?"
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 6th, 2023 at 10:12:04 AM permalink
Quote: MrV

Quote: Mental



I I spend about 40 hours per year just collating all of my W2-G information because it is reported in different formats by different casinos...



What "different formats?" and how do they work?

All I ever get are the paper W2-G statements provided by staff at the time I am paid.

I assume that at your play level there is some form of electronic wizardry at play?

I know little about such things but I have seen on slot videos how some big players in high limit are able to seemingly avoid the hassle and delay of dealing with staff after a jackpot simply by pushing a button or two.

I've never seen it in play at the tribal casinos I play at in Oregon.
link to original post

Most of my W2-Gs are from online casinos. In some cases, I use a PDF converter to automatically convert downloaded W-2Gs to text and then extract the data into a list that can be imported into a spreadsheet. In some cases, I can get a summary listing of W-2Gs that I process line by line to extract the useful information. For some casinos, I download a log entry for every single transaction and then filter for W-2G data so I don't have to process the paper forms they send me in February of the next year.

Note that the dates on many W-2G forms do not match the date where the online gaming was done. If I want to match the W-2G with the right session, I sometimes have to look at play logs.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
DRich
DRich
Joined: Jul 6, 2012
  • Threads: 86
  • Posts: 11061
July 6th, 2023 at 11:05:28 AM permalink
Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.



I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
At my age, a "Life In Prison" sentence is not much of a deterrent.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 7th, 2023 at 6:50:15 AM permalink


Not my pic but i was walking by when i saw it.
1 card hold and redraws to a Royal.

i think Alan M (Rip) said he threw away all 5 cards and redraw to a Royal once
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 7th, 2023 at 7:10:22 AM permalink
Quote: 100xOdds



Not my pic but i was walking by when i saw it.
1 card hold and redraws to a Royal.

i think Alan M (Rip) said he threw away all 5 cards and redraw to a Royal once
link to original post

I had three of these royals holding one card in a single day in Biloxi. The first was on quarter 10-play and the other two were on nickel 100-play. I have only made about ten 1-card RF draws in my career, so this was a random cluster helped by the fact that there was a playable 100-play game in Biloxi way back when.

I never had a redraw royal. A friend said he had two redraw royals on one trip.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
DRich
DRich
Joined: Jul 6, 2012
  • Threads: 86
  • Posts: 11061
July 7th, 2023 at 7:59:59 AM permalink
Quote: Mental



I never had a redraw royal. A friend said he had two redraw royals on one trip.
link to original post



I have had a few no hold royals through my 20 years of gambling. Probably a lot more if I count 50 and 100 play machines.
At my age, a "Life In Prison" sentence is not much of a deterrent.
rxwine
rxwine
Joined: Feb 28, 2010
  • Threads: 200
  • Posts: 11874
July 7th, 2023 at 11:04:21 AM permalink
Iíve had 2 royals on the deal. 1 sequential royal and about 10 draw to a royals. My least favorite royal was one where I didnít notice my bet had dropped by half when I ran out of money. I put more cash in the machine and didnít realize I wasnít playing a full bet when I hit a royal. My next favorite royal was when I went full house, to 4 of kind to royal in 3 different hands. Once when I was playing a bank, the lady next to me hit the progressive a few seconds after someone hit the high progressive, and she ended up with the reset amount.

Those are all my royal stories. (That I can remember)

Oh, and I hit a royal on Wizardís simulation on this site. You got a code word to send to him, if I remember right and he gave you some sort of credit for it. Now the only credit I get is my name on the suspension list sometimes.
There's no secret. Just know what you're talking about before you open your mouth.
MrV
MrV
Joined: Feb 13, 2010
  • Threads: 357
  • Posts: 7973
July 7th, 2023 at 11:55:23 AM permalink
Quote: Mental

[Most of my W2-Gs are from online casinos.



Do online casinos that are NOT based in the USA issue W2-G's to US-based players?

I only ask because my buddy got paid about $18K from an online casino ostensibly based in Great Britain and he is under the impression that no W2-G would be generated, so he plans not to report the win on his taxes.
"What, me worry?"
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 7th, 2023 at 12:36:53 PM permalink
Quote: DRich

Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.



I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
link to original post

Ever find out that a casino didnt send the irs your w2-g that you had taxes withheld from?
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
DRich
DRich
Joined: Jul 6, 2012
  • Threads: 86
  • Posts: 11061
July 7th, 2023 at 3:43:37 PM permalink
Quote: 100xOdds

Quote: DRich

Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.



I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
link to original post

Ever find out that a casino didnt send the irs your w2-g that you had taxes withheld from?
link to original post



I have never chosen to have taxes withheld but I believe Louisiana was the state I played that always withheld.
At my age, a "Life In Prison" sentence is not much of a deterrent.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 10th, 2023 at 12:37:43 PM permalink
Quote: DRich

Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.


I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
link to original post


you can request transcripts online:
https://www.irs.gov/individuals/transcript-types-and-ways-to-order-them
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 10th, 2023 at 3:23:25 PM permalink
Quote: 100xOdds

Quote: DRich

Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.


I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
link to original post


you can request transcripts online:
https://www.irs.gov/individuals/transcript-types-and-ways-to-order-them
link to original post

Maybe you can. I cannot because I have too many W-2Gs by a factor of about 20 and the online request method will not generate my transcript.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 15th, 2023 at 7:54:04 PM permalink
Quote: 100xOdds

Quote: DRich

Quote: Mental

Thanks, but I was aware of the transcript service. I have tried to use it and the transcripts are not available for me in a timely fashion. I exceed the IRS's document limit by more than an order of magnitude.


I was able to go to my local IRS office in Las Vegas and they would print it out for me on good old green bar computer paper. I had hundreds of W2G's but I don't know exactly how many it was.
link to original post


you can request transcripts online:
https://www.irs.gov/individuals/transcript-types-and-ways-to-order-them
link to original post

so i logged in. i have a whole bunch of w2-g's.

Any easy way to import into a speadsheet?
or i have to do the old copy/paste?
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 16th, 2023 at 6:52:34 AM permalink
Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.

Any easy way to import into a spreadsheet?
or i have to do the old copy/paste?
link to original post

Sadly, the only casino I play at that supported direct creation of spreadsheets for download was Virgin. They discontinued this and replaced it with text listings.

I use cut and paste to download these text listings into a text file. I wrote a C++ text processing program to turn these entries into a spreadsheet. Most people with computer skills might want to use awk or perl to do this text processing.

If you are an experienced spreadsheet user, you might be able to paste these text entries into a spreadsheet and use the spreadsheet text functions to extract the useful data fields. I do this to convert text-based leaderboard data into a useful format. Cut and paste does not extract the table format, so I have to recreate the table from the row elements.

I like to keep my interactions with support to a minimum because I do not want humans to be looking at my activity. However, the only times that I asked support for my tax data, they sent me an e-mail with a spreadsheet. This is probably a good option for most players.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 16th, 2023 at 10:00:51 AM permalink
Quote: Mental

Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.

Any easy way to import into a spreadsheet?
or i have to do the old copy/paste?
link to original post

Sadly, the only casino I play at that supported direct creation of spreadsheets for download was Virgin. They discontinued this and replaced it with text listings.

I use cut and paste to download these text listings into a text file. I wrote a C++ text processing program to turn these entries into a spreadsheet. Most people with computer skills might want to use awk or perl to do this text processing.

If you are an experienced spreadsheet user, you might be able to paste these text entries into a spreadsheet and use the spreadsheet text functions to extract the useful data fields. I do this to convert text-based leaderboard data into a useful format. Cut and paste does not extract the table format, so I have to recreate the table from the row elements.

I like to keep my interactions with support to a minimum because I do not want humans to be looking at my activity. However, the only times that I asked support for my tax data, they sent me an e-mail with a spreadsheet. This is probably a good option for most players.
link to original post

Probably be easier to copy/paste the entire w2-g section into a spread sheet and just delete non-relevent rows.

ie: casino name/tax id #, then all 'winnings, taxes withheld (if any), and date won' lines for that casino
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 16th, 2023 at 12:37:37 PM permalink
Quote: 100xOdds

Probably be easier to copy/paste the entire w2-g section into a spread sheet and just delete non-relevent rows.

ie: casino name/tax id #, then all 'winnings, taxes withheld (if any), and date won' lines for that casino
link to original post


I wish it were that easy. The most common page format runs entries into each other. If you want the numbers to be interpreted as numbers, you need to do some sort of text processing. This is what the paste looks like:

6:32:42 p.m. 07/08/2023NOGS_####
Texas Tea$1,500.00
Wager:$50.00Complete
6:18:47 p.m. 07/08/2023NOGS_####
Texas Tea$2,500.00
Wager:$50.00Complete
6:13:48 p.m. 07/08/2023NOGS_####
Texas Tea$2,500.00
Wager:$50.00Complete
3:26:07 p.m. 07/09/2023NOGS_####
Texas Tea$2,500.00
Wager:$50.00Complete

This is simple to handle in awk or C++. I find it annoying to do it using spreadsheet text functions.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
Talldude90
Talldude90
Joined: Aug 24, 2022
  • Threads: 11
  • Posts: 113
July 19th, 2023 at 12:21:17 AM permalink
I mean you can almost do the same thing with Xcel as with programming, you still have to find the spots your program are looking for and logically describe how to cut it up. Some mid(find( statements aren't that hard...
rxwine
rxwine
Joined: Feb 28, 2010
  • Threads: 200
  • Posts: 11874
July 19th, 2023 at 4:29:50 AM permalink
(slight political statement) Aside from constant complaining about tax reform, I think some leader out there needs to beat the drum much harder on tech reform in our tax reporting. Some dude invented ideas like plug n play decades ago, and we are still using antiquated methods combined with computers. Stop requiring a stone age rock to input data.
There's no secret. Just know what you're talking about before you open your mouth.
TheCapitalShip
TheCapitalShip
Joined: Aug 14, 2021
  • Threads: 7
  • Posts: 73
July 19th, 2023 at 11:30:18 AM permalink
Quote: rxwine

(slight political statement) Aside from constant complaining about tax reform, I think some leader out there needs to beat the drum much harder on tech reform in our tax reporting. Some dude invented ideas like plug n play decades ago, and we are still using antiquated methods combined with computers. Stop requiring a stone age rock to input data.
link to original post


I know right?
One would think it's by design....
Oh wait...
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 23rd, 2023 at 9:34:26 PM permalink
Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.
link to original post

Imported into Excel.
The amount of w2-G the IRS has on file for me is about $4400 more than the w-2g's i recorded receiving.
Sigh.. now i have to go through line by line to see what i'm missing. :(

On the bright side, The amount of tax withheld is the same.
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 24th, 2023 at 3:13:00 PM permalink
Quote: 100xOdds

Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.
link to original post

Imported into Excel.
The amount of w2-G the IRS has on file for me is about $4400 more than the w-2g's i recorded receiving.
Sigh.. now i have to go through line by line to see what i'm missing. :(

On the bright side, The amount of tax withheld is the same.
link to original post

the w2-g's are separated by casino but not in date order :(
sigh..
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
DogHand
DogHand
Joined: Sep 24, 2011
  • Threads: 2
  • Posts: 1316
July 25th, 2023 at 4:40:53 AM permalink
Quote: 100xOdds

Quote: 100xOdds

Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.
link to original post

Imported into Excel.
The amount of w2-G the IRS has on file for me is about $4400 more than the w-2g's i recorded receiving.
Sigh.. now i have to go through line by line to see what i'm missing. :(

On the bright side, The amount of tax withheld is the same.
link to original post

the w2-g's are separated by casino but not in date order :(
sigh..
link to original post


100xOdds,

Excel DOES have sorting capabilities.

Select the entire table, then perform a two-level sort by casino and date.

Hope this helps!

Dog Hand
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 25th, 2023 at 5:38:27 AM permalink
Quote: DogHand

Quote: 100xOdds

Quote: 100xOdds

Quote: 100xOdds

so i logged in. i have a whole bunch of w2-g's.
link to original post

Imported into Excel.
The amount of w2-G the IRS has on file for me is about $4400 more than the w-2g's i recorded receiving.
Sigh.. now i have to go through line by line to see what i'm missing. :(

On the bright side, The amount of tax withheld is the same.
link to original post

the w2-g's are separated by casino but not in date order :(
sigh..
link to original post


100xOdds,

Excel DOES have sorting capabilities.

Select the entire table, then perform a two-level sort by casino and date.

Hope this helps!

Dog Hand
link to original post

cant do that because the date is in the same column as the $ won.
I have to manually move the date field to the next column over.
instead of doing that effort, Might as well go through $ won manually to match up with the wg-2 i have
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 25th, 2023 at 5:41:34 AM permalink
Quote: 100xOdds

I cant do that because the date is in the same column as the $ won.
I have to manually move the date field to the next column over.
instead of doing that effort, Might as well go through $ won manually to match up with the wg-2 i have
link to original post


You can use the text splitting functions to create two new columns with the fields separated, then sort by the new columns. If there are hundreds of items, it might be worth the effort.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 25th, 2023 at 7:01:16 AM permalink
Quote: Mental

Quote: 100xOdds

I cant do that because the date is in the same column as the $ won.
I have to manually move the date field to the next column over.
instead of doing that effort, Might as well go through $ won manually to match up with the wg-2 i have
link to original post


You can use the text splitting functions to create two new columns with the fields separated, then sort by the new columns. If there are hundreds of items, it might be worth the effort.
link to original post

I'm in 'text to column' wizard:

Here's my column:
amount i won (1320), and 3 rows below that is the date.

How do i set the delimiter to the date?
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 25th, 2023 at 9:01:37 AM permalink
Quote: 100xOdds

Quote: Mental

Quote: 100xOdds

I cant do that because the date is in the same column as the $ won.
I have to manually move the date field to the next column over.
instead of doing that effort, Might as well go through $ won manually to match up with the wg-2 i have
link to original post


You can use the text splitting functions to create two new columns with the fields separated, then sort by the new columns. If there are hundreds of items, it might be worth the effort.
link to original post

I'm in 'text to column' wizard:

Here's my column:
amount i won (1320), and 3 rows below that is the date.

How do i set the delimiter to the date?
link to original post

My bad. I misunderstood you. I thought the data was concatenated in the same row, but you said 'same column'.

In that case, you can use simple cell references to cast the data from one row into a table. I use this all the time on leaderboards that cannot be pasted as a table, but end up in one column like your data. I create a 4x7 grid of references that copies data in column A to columns C-F automatically. Then, I can use Paste Special to copy the table to another part of the spreadsheet and use the reference cells over again when the data updates. Sorting the original table will cause the formulas to be shifted around. That destroys the table and I won't be able to reuse it. Just paste Special -> values Only and you can sort the copy normally.

In this picture, cell C2 has the formula =A1, etc. You could make your table big enough to cast all of your data at once, or you could build a small table and keep reusing it until you have all of your W2G data cast to a table. Is this clear?
This forum is more enjoyable after I learned how to use the 'Block this user' button.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 25th, 2023 at 4:05:12 PM permalink
Mental,

i have no idea how you did that.
Can you show me step by step?
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Mental
Mental
Joined: Dec 10, 2018
  • Threads: 10
  • Posts: 978
July 25th, 2023 at 5:26:53 PM permalink
To cast a single column of data into a rectangular grid, first see what the spacing is in the column data. In my case, the spacing is four rows between each repeated element. So, I need a grid 4 columns by N rows. I then decide where I want my grid and where I want to paste my column data. I chose to paste the data from the leaderboard into column A starting in cell A1. I usually paste 13 rows of data (52 data entries), but I only show the header row and 6 data rows in my example to make it simpler. N can be as large as you need for your data.

I chose to put the upper left corner of the grid in cell C2. but I could have put it anywhere -- even another sheet. The top-left cell of the grid, C2, has a reference to the first cell of the data column. I just type the formula '=A1' into cell C2 (without the quotes). This formula causes the '#' in cell A1 to appear in cell C2. I just work through the grid area entering formulas to create the full table. These are the formulas for the cells.

C2 =A1
D2 =A2
E2 =A3
F2 =A4
C3 =A5
D3 =A6
E3 =A7
F3 =A8
.....
.....
F8 =A28

If I paste updated leaderboard scores into column A, the formulas update the grid. If I copy the grid normally, I am only copying the formulas. I need to select the grid area, copy, and then 'Paste Special -- Values Only' which will paste the data, not the formulas, to a new grid area. Since that is now just data, the copy of the grid can be sorted normally. Don't try to sort a grid with formulas that have references outside the grid rows. You won't get the right results.

If you have VBA or macros, you might be able to automatically populate the grid formulas. I don't use Excel or VBA so I create the table by just typing formulas.
This forum is more enjoyable after I learned how to use the 'Block this user' button.
100xOdds
100xOdds
Joined: Feb 5, 2012
  • Threads: 617
  • Posts: 4085
July 26th, 2023 at 9:46:10 AM permalink
Thx.
I'll try it when I come back next week
Craps is paradise (Pair of dice). Lets hear it for the SpeedCount Mathletes :)
Talldude90
Talldude90
Joined: Aug 24, 2022
  • Threads: 11
  • Posts: 113
July 29th, 2023 at 3:21:26 PM permalink
You can also use the following functions =mid(), =find(), =vlookup(), =len().

A mid function would look like this =mid(cell data is in, find("keyword", cell data is in), either a set # of characters or another find() )
TheCapitalShip
TheCapitalShip
Joined: Aug 14, 2021
  • Threads: 7
  • Posts: 73
July 30th, 2023 at 2:03:25 PM permalink
I realized I've forgotten to post these here...I play low stakes so the numbers aren't jaw dropping but these are from this year, same month actually, my first and second royals I've ever gotten and as of today still remain my biggest wins.






The second picture I got after probably one of the most brutal VP sessions I've ever had...
EDIT: Put both pictures into a spoiler.

  • Jump to: