Council of Elrond

Here is a tool that I have been use for the past 16 years; had to cut it out of the 50 player file.

There are sheets for all sites for all alignments for all sets including dream card.
A sheet for all non-site cards.

There are 8 sheets for two players for all four alignments.

Then there are the maps! hero haven, minion haven, plain region type with sites and site type.
Also a map for creatures playable to regions! And for characters.
I moved some regions from UtterSouth a bit more northeast to follow MERP and not the
expanded map.

Let me know of feedback and if you like the use of comments.
Basically, if you do not use the comment VBA code, then this file is just a dictionary of cards and map holder.

Save a pint for me at the Green Dragon.

Made an update for the use of the VBA code.
If you have no use of the VBA, then nothing is new from version 3.
If you care not for clicking on region shapes or seeing the card images, then nothing new from the VBA.

With the v4 Excel file, Word and Excel VBA, and the Word file,
you can see the cards!

I added the regions to the ALL sheet if you care to see the regions for movement.
Full instructions to setup and use found the Excel file.

Now I know what you are thinking.
"This is great, but I have no card images on my computer."
If you want to see the cards and have no images, then let me
know and I can write the instructions to get the images from cardnum.net
AND update the file paths for the cards. Yes, this will take me some hours
but I already spent that time on this project. You will spend hours using this game simulator,
so it will be enjoyable for me to help you.

Reply with your feedback to help others decide if this is right for them.

Updated the earth_play excel file due to error on the maps.
With addition of region Chelkar, no more Khand being adjacent to Haruzan.
Fixed this, removed link, on all the maps.

This looks really neat and like a ton of effort, but I think I'll need a 3rd coffee or more to see what it is all about. Can you talk a little more about your project? Are the players/decks being simulated to play against each other?

By the way, it seems like my version of Excel is different since I have different prompts (like, right-click => "View Code").

That might be an issue with us using different versions.
The "right-click, view code" instruction is to view the VBA Editor window.

No for a self-driven simulator.

The idea is to have a layout of cards on the spreadsheet while
seeing the cards' text in a comment while also being able to
see the card images in a Word file.

User has a lot of input to do:
untap/tap/wounded status, character name, stats, corruption points, controlled cards, sites.
Option is there for comments in cells and viewing the card images.

Instructions are there in insert the VBA code. So you need to access the VBA editor;
do you have "tabs"? that is a Developer tab? you can add that tab for faster access.
But once you insert the VBA code, no need to modify it. Does this help?

dirhaval wrote: ↑Wed Apr 05, 2023 2:40 am That might be an issue with us using different versions.
The "right-click, view code" instruction is to view the VBA Editor window.

No for a self-driven simulator.

The idea is to have a layout of cards on the spreadsheet while
seeing the cards' text in a comment while also being able to
see the card images in a Word file.

User has a lot of input to do:
untap/tap/wounded status, character name, stats, corruption points, controlled cards, sites.
Option is there for comments in cells and viewing the card images.

Instructions are there in insert the VBA code. So you need to access the VBA editor;
do you have "tabs"? that is a Developer tab? you can add that tab for faster access.
But once you insert the VBA code, no need to modify it. Does this help?

Thanks for the tips. I was able to see the VBA editor last time I was looking at this. It seems I will have to go back.