Posted: Tue Mar 27, 2012 9:14 am Post subject: GoogleDocs - Shuffle and Deal Cards
Just mucked about and made this this morning. Don't know if it would be useful to anyone or not (maybe it has been done already). But there is no harm in sharing either way.
You just have to enter the number of players that need to be dealt cards in the gray cell on the first sheet. It's a little tricky, sometimes you might accidentally recalculate the random number generators and lose the shuffle/deal that you were using.
Just hit Ctrl+R to reshuffle/deal.
The codes/functions all seem to work AFAIK. But it could definitely use some cleaning up (I'll get around to making it look prettier at some point).
EDIT: I'm not sure I got the share options right. I think now you should be able to edit/reshuffle (ctrl+R). I made a copy, don't worry 'bout messing it up.
Joined: 17 Dec 2008 Posts: 1066 Location: Decatur, GA
Posted: Tue Mar 27, 2012 11:48 am Post subject:
This is slick! Sharing this during an online game makes it easy, too. I'd like to see a streamlined version with just one round at a time. Is that easy to edit? I haven't looked at the formulas yet.
This is slick! Sharing this during an online game makes it easy, too. I'd like to see a streamlined version with just one round at a time. Is that easy to edit? I haven't looked at the formulas yet.
PS - Does it "shuffle" when a Joker is dealt?
If you want to only draw 1 round at a time, I think it would be a simple matter of making the font WHITE for the other columns. The white font would make those rounds invisible against the white background.
Then, you can simply change the font back to black each round to "reveal" the newly dealt cards (which were actually dealt at the beginning).
Just make the font/background the same color (could be BLACK too) and undo it as the combat rounds proceed.
If a Joker is dealt, you can just reshuffle by hitting CTRL+R, right? I think it would involve a script of some kind for it do reshuffle automatically.
Some more thoughts involving EDGES.
LEVEL-HEADED - Just assume that this player is represented by 2 adjacent rows in the sheet. If you rename the various rows to character names (instead of "PLAYER 1", "PLAYER 2", etc), a Level-Headed character would be listed twice (or three times w/ the improved edge)
QUICK - This one is trickier. Redrawing on a card of 5 or less . . . I'll have to think about that.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum