322-Player Simulator

Post Reply
dirhaval
Posts: 791
Joined: Tue Feb 06, 2007 5:39 am

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.
Attachments
earth_play_v5.xlsx
Full file; site and card info including dream cards. can use VBA in other file to add comments with card details.
No VBA in this file. Instructions to use file found inside.
(3.53 MiB) Downloaded 44 times
vba_mearth_all.txt
Copy this VBA code into the Excel file's as a module. See instructions in Excel file.
(14.35 KiB) Downloaded 53 times
Last edited by dirhaval on Sun Mar 26, 2023 8:13 pm, edited 1 time in total.
dirhaval
Posts: 791
Joined: Tue Feb 06, 2007 5:39 am

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.
Attachments
OpenMe1.pdf
Example use of the Word file. Layout described in the Excel file.
(3.93 MiB) Downloaded 60 times
OpenMe1.docx
The Word file to receive images/cards from the Excel file. So you need the cards already on your computer.
(15.88 KiB) Downloaded 60 times
CODE_OpenMe.txt
VBA code to use in the Word file; instructions in the Excel file to add and use.
(386 Bytes) Downloaded 57 times
dirhaval
Posts: 791
Joined: Tue Feb 06, 2007 5:39 am

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.
User avatar
CDavis7M
Posts: 2816
Joined: Fri Jul 20, 2018 3:10 am
Location: California

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").
dirhaval
Posts: 791
Joined: Tue Feb 06, 2007 5:39 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?
User avatar
CDavis7M
Posts: 2816
Joined: Fri Jul 20, 2018 3:10 am
Location: California

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.
Post Reply

Return to “Showcase”