What's your biggest slot win?
I don't believe the claim, but it is being vigorously pressed while being unmercifully flamed.
Crazy, just flippin' crazy.
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.Quote: MrVI'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 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?
Or a link? Google is coming up empty for me.Quote: MentalI 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.Quote: MrVI'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 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.Quote: MentalI 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.Quote: MrVI'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 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.Quote: MentalI 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.Quote: MrVI'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 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
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.
Quote: UP84I agree...some of the high limit VP machines have the potential to hit 7 figure payouts.Quote: MentalI 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.Quote: MrVI'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 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
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.Quote: rsactuaryThat's only Double Super Times Pay and it's 20xQuote: UP84Also, 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.Quote: UP84I agree...some of the high limit VP machines have the potential to hit 7 figure payouts.Quote: MentalI 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.Quote: MrVI'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 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
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 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.
I was wrong on that...it's only DSTP. My bad.Quote: MentalI 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.
Quote: MentalI 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.Quote: MrVI'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 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.
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!
++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++
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
Quote: JoemanOr 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:
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.
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.Quote: ChumpChangeMr. 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
Quote: MentalTaxable 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.Quote: ChumpChangeMr. 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
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.
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: 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
Quote: IRSWage 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.
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.Quote: Form 4506-TForm 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.
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.
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.Quote: MrVQuote: 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
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.
Quote: MentalThanks, 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.
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
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.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 never had a redraw royal. A friend said he had two redraw royals on one trip.
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.
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.
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.
Ever find out that a casino didnt send the irs your w2-g that you had taxes withheld from?Quote: DRichQuote: MentalThanks, 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
Quote: 100xOddsEver find out that a casino didnt send the irs your w2-g that you had taxes withheld from?Quote: DRichQuote: MentalThanks, 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
link to original post
I have never chosen to have taxes withheld but I believe Louisiana was the state I played that always withheld.
Quote: DRichQuote: MentalThanks, 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
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.Quote: 100xOddsQuote: DRichQuote: MentalThanks, 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.Quote: 100xOddsQuote: DRichQuote: MentalThanks, 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
Any easy way to import into a speadsheet?
or i have to do the old copy/paste?
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.Quote: 100xOddsso 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
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.
Probably be easier to copy/paste the entire w2-g section into a spread sheet and just delete non-relevent rows.Quote: MentalSadly, 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.Quote: 100xOddsso 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
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
ie: casino name/tax id #, then all 'winnings, taxes withheld (if any), and date won' lines for that casino
Probably be easier to copy/paste the entire w2-g section into a spread sheet and just delete non-relevent rows.Quote: 100xOdds
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.
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...
Imported into Excel.Quote: 100xOddsso i logged in. i have a whole bunch of w2-g's.
link to original post
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.
the w2-g's are separated by casino but not in date order :(Quote: 100xOddsImported into Excel.Quote: 100xOddsso i logged in. i have a whole bunch of w2-g's.
link to original post
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
sigh..
Quote: 100xOddsthe w2-g's are separated by casino but not in date order :(Quote: 100xOddsImported into Excel.Quote: 100xOddsso i logged in. i have a whole bunch of w2-g's.
link to original post
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
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
cant do that because the date is in the same column as the $ won.Quote: DogHandQuote: 100xOddsthe w2-g's are separated by casino but not in date order :(Quote: 100xOddsImported into Excel.Quote: 100xOddsso i logged in. i have a whole bunch of w2-g's.
link to original post
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
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
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
Quote: 100xOddsI 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.
I'm in 'text to column' wizard:Quote: MentalQuote: 100xOddsI 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
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?
My bad. I misunderstood you. I thought the data was concatenated in the same row, but you said 'same column'.Quote: 100xOddsI'm in 'text to column' wizard:Quote: MentalQuote: 100xOddsI 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
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
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?
i have no idea how you did that.
Can you show me step by step?
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.
I'll try it when I come back next week
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() )
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.
