Well, in a nutshell, all you do is copy the decklist into Column A. Sort of like a glorified regular word processor. Then, if you start naming different columns for the different play areas (In Play, Hand, Graveyard, etc), you can move groups of cards to the appropriate place. A "draw" would simply be moving the top card from "Library" to "Hand".
Apparently there's a "Hidden Column" feature in Excel which lets you hide your Library so you don't see what's coming. And you can use the random function to "shuffle" by assigning the random function to each card and then sorting high-to-low or whatever.
train sent me a worksheet with all of this stuff so I didn't have to figure it out on my own
Apparently there's a "Hidden Column" feature in Excel which lets you hide your Library so you don't see what's coming. And you can use the random function to "shuffle" by assigning the random function to each card and then sorting high-to-low or whatever.
train sent me a worksheet with all of this stuff so I didn't have to figure it out on my own
L
Limited
Guest
To add a random number to a cell, try either =ASELECT() or =RAND()
(caps or no caps, i forget)
The = causes excell to interpret the rest as a function instead of simple content.
(caps or no caps, i forget)
The = causes excell to interpret the rest as a function instead of simple content.
H
hrothmar
Guest
well it seems i have a deck...
could I get one of those fine worksheets myself? my email is r.menger@student.rug.nl
about the manabase: is that supposed to be highlander as well?
could I get one of those fine worksheets myself? my email is r.menger@student.rug.nl
about the manabase: is that supposed to be highlander as well?
Sorry, yeah, train actually sent me the spreadsheet after already shuffling my deck. I usually add the random function to a separate empty column, copy & paste it to the rest of the corresponding columns for the decklist, and then sort the decklist column and random column in whatever the default is for sorting (I think ascending, but it doesn't matter). Don't worry if, after you sort, the random numbers aren't sorted because every time you "do something" on the spreadsheet, the random number is re-calculated. But it did sort correctly according to the previous random numbers (just look for the high or low number and see if it got to the bottom or top).
hrothmar: We've been doing the mana base as non-Highlander with respect to basic, duals (regular and Ravnica), pain, and fetchlands (I'm not sure if that comprises a "category" so I just listed them).
hrothmar: We've been doing the mana base as non-Highlander with respect to basic, duals (regular and Ravnica), pain, and fetchlands (I'm not sure if that comprises a "category" so I just listed them).
D
DarthFerret
Guest
Actually, I'm pretty sure it's still Highlander-style Spidey, with no duplicates of non-basic lands. Except for the first deck or 2, of course, which was before we decided on the Highlander format and the one posting per day limit...Spiderman said:
Oh, and it took me a while, but I finally figured out what you were trying to say and I know how to shuffle the cards now...
H
hrothmar
Guest
manabase (highlander)
Badlands
Blood crypt
Lake of the Dead
Watery Grave
Underground sea
Steam vents
volcanic island
Izzet boilerworks
Dimir Aquaduct
Rakdos carnarium
Ice floe
bloodstained mire
polluted delta
swamp 4
island 3
mountain 4
any comments?
(spreadsheet) ...received...(thx)
Badlands
Blood crypt
Lake of the Dead
Watery Grave
Underground sea
Steam vents
volcanic island
Izzet boilerworks
Dimir Aquaduct
Rakdos carnarium
Ice floe
bloodstained mire
polluted delta
swamp 4
island 3
mountain 4
any comments?
(spreadsheet) ...received...(thx)
H
hrothmar
Guest
nope...game on spidey!
ill make a thread.
ill make a thread.