I'd recommend downloading into excel, filtering and deleting as you want there, and then reupping into google docs.

Stickied

Joe, could you tell me how you add the links to the casinos in the Venue column?

I am trying to create another sheet for tournaments other than during WSOP time, and when I go to Insert/Comments it replaces the casino name with the url I am trying to add; instead of embedding it within the casino name.

I've checked the Google docs help, but I still am missing something.

Thanks.

Nevermind, I stumbled my way thru and have it.

Thanks again

Yeah I just used the =hyperlink("<full url>";"<displayed text>") function because I think that's the only way you can put links on google docs sheets, or at least it's the only way I know how. In excel you can just copy/paste the url and it will create a hyperlink itself.

Chuckled a bit when I saw you included the $1m tournament on the spreadsheet

Well Galen needs an easy way to keep track of his investors too, right?

its up http://www.venetian.com/uploadedFile...VAGANZAIII.pdf

try this link

I can see Joe making the VDSE updates as he makes them. Google is scary.

lol confirmed scary. They only know everything about everything and everyone, nbd

I just finished updating both spreadsheets (full and nl only) to add the UNOFFICIAL VDSE schedule. V_TD is saying that there are still some changes to be made, but the schedule tourneys, times, and buyins should remain intact anyway. It's not posted on the Venetian site yet, I just found it in MTTc-Live.

If anything else changes/structures are posted then I'll make the necessary changes to the sheets. For now, lets get those packages posted boys and girls!

Random and probably unrelated question (and didn't see a thread where it would have been more appropriate) but:

When will people probably start listing their WSOP packages? I wanna buy action but didn't see any listed yet. Seems odd with the series less than 3 months away.

April is when they normally start picking up. End of April for the heaviest action.

Not sure if anyone has covered this but what is the best way to go about posting a schedule that won't come out to a huge amount total for buyins? I'm talking about like overlap and missed days and whatnot. Like I could put a tourney every day but buyins come out to ~$90k, when in reality I might only play half that, so I'm wondering what the best way to lay out a schedule is. Go every other day and inform investors that you have a right to play $x tourney on whatever day? Maybe I'm making it too hard, but just wondering what other people are doing.

It's been pretty standard in the past to just list everything & say there are probably going to be alot of refunds. Wish there was a better way bc it sucks to have investors extra $$ tied up the whole summer. There can be alot more problems if u play some stuff not specifically listed & people didnt approve or you needed extra funds. So probably best to just schedule an event everyday....

Yeah I was just going to do this. Having money tied up is kinda undesirable for investors, but at least it kinda makes the investment lower variance in a way if you can expect a lot of it to be refunded lol

Just added a Total Buyins cell above the Total Cost cell so that it's easier to relate the total marked up cost of the package to the nominal cost for people who are going to charge different markups on different events. It's basically so you can quickly figure out the total $$$ amount of markup for the whole package.

btw the links in the spreadsheet is an awesome addition.

Tomorrow I'm going to start testing another version of the template that allows sellers to sell different percentages of individual events in a package as well as individual markup. Like Galen said in his thread, I think having an easy way to do this would be a GREAT thing for the MP to have as a standard in selling packages here, not just for WSOP time but for everything.

awesome awesome help! thanks...

I just wanted to say that this template made my life much easier, thanks a lot for taking the time. If we met in Vegas drinks are on me

How much do I love spreadsheets tho?

No problem! I'm more than happy to do it. I'm sure I'll see in you Vegas and take you up on that

As far as the actual template goes, I think I'm finished with a version that allows players to sell different %s for individual tourneys as well as individual markups. I'll post links and tutorials for that tomorrow in case anyone would like to use it. To see an example of how selling like this mike work, see Galen's EPT San Remo/Madrid thread, where he did exactly this. I just did what I could to make it easier to calculate and more transparent.

Here are the links to the newest versions of the template that allow for selling different %s in different tourneys:

2012 Las Vegas Summer Template v2

2012 Las Vegas SUmmer Template NLHE Only v2

They ultimately work pretty much the same way as the original versions of the template, except for a couple small differences.

In this version, I added an extra column in the schedule for sellers to change the % of each tourney that they wish to sell, and another column the automatically calculate the total cost of that tourney to the package based on the markup and % sold for the tourney on the same line. Because selling at different markups and %s may get confusing to investors (especially in big packages), I included cells at the top of the sheet that calculate the weighted average of the markup and % sold so investors could get a better idea of what they are paying for overall.

Sellers still need to manually enter whether they played the tourney and what they cashed for, and the sheet automatically calculates refunds and payout amounts for each tourney. The action summary page also calculates each buyer's payment to be sent at the end of the package, just like the last version. Sellers must also manualy enter how many shares of the package they would like to sell, just like they have to manually input what % of the total package they'd like to sell in the last version. Basically, sellers use this new version exactly the same way they used the original version, except in this one they have the added optionality of selling different %s to maximize value. Therefore, directions for properly using this version are pretty much the same as the other version.

The only real difference to note is that in this version you have to sell shares instead of a total % of the action in the package. This means that people who buy 1% of the package may get more or less than 1% of the cashes, depending on the varying %s sold per tourney. The spreadsheet calculates payouts in real-time, so if anyone who buys or sells a package with this template wants to see what they are owed/owe in the middle of the package all they need to do is check the $ Per Share cell to see how much is being returned per share (or check the Action Summary page if it is being used to see an investor's total payment).

If anyone has any questions/concerns please see Galen's EPT San Remo/Madrid thread to see how a package like this works (linked in my post above), and if you still have questions then please feel free to post them here or PM me.

what a hero

Someone reported a bug in the new versions of the spreadsheet that calculates the payouts incorrectly for cashes, where sometimes it says you owe more from a cash then the actual amount you cashed for. I'll fix this asap and let you know here, but until then don't use the new spreadsheet. Also, for anyone already using it to make packages, you are going to need to redo it, so I'm sorry for that.