Dynamically updating MTG Sliver excel sheet


Homebrew and House Rules


As part of a project I was working on, I need to better master some excel functions. To practice, I turned to an old conversion of slivers I had made as part of a mythic second darkness mashup since they were already in a spreadsheet.

Fast forward a couple weeks, and I have a draft ready to go.
Each cell in the table on the right side has two functions:
The right side of the cell is a drop down to select how many slivers of each kind are present.
The left side of the cell selects which sliver's stats are displayed.

The stat block changes depending on the number and types of slivers present and includes a section detailing what abilities the active sliver has and what abilities it can access from the others around it.

Here is the 84 MB version with art
Here is the 300 KB version with no art

No macros or VBA commands were used in the creation of this spreadsheet, though I know that would have made it much, much, much easier. This whole thing is just a happy side effect of needing to learn excel functions.

And since it is an excel sheet, you'll want to use excel to open it since google docs/sheets doesn't have the same capabilities.


If you have attempted to get to my linked file(s) above and found that you needed to ask permission, you have my apology. I was not regularly checking the e-mail address attached to the account.

I have now removed the google security update from hundreds of my shared files, so hopefully no one will have to ask permission to view them.

Community / Forums / Pathfinder / Pathfinder First Edition / Homebrew and House Rules / Dynamically updating MTG Sliver excel sheet All Messageboards

Want to post a reply? Sign in.
Recent threads in Homebrew and House Rules