Deck Builder's Tools

I wrote up a deck simulator and probability table generator for Magic the Gathering. Both features work for Yu-Gi-Oh! just fine.

Here is the download link as promised.

System Requirements:
Microsoft Excel 2007-10



Tab 1
The first image is the main tab. It is pretty simple and self-explanatory. You enter in the details of your deck, but really all you need to enter are the quantity and card name. The rest would be charting and analysis. When you have finished entering in all the cards in the deck, the key combinations shown will enable you to simulate how the deck will run. Running the clear option will clear the deck list too so be careful.

Tab 2
The second image is another analysis tab. To run this, first enter the information at the top (number of cards in deck, number of draws to analyze, and the other option is explained to the right of the table.)

Mutually exclusive events are events that cannot happen at the same time. An example from a 52-card playing card deck is a red card and a black card being drawn. Both events cannot happen with 1 draw. But a red King can. That is mutually inclusive.

For the first chart, do not worry about the definition of it. The definition is mainly for drawing more than 1 card. When set to true, it calculates the probability of drawing AT LEAST x of the specific card in n draws. When set to false, it calculates the probability of drawing EXACTLY x of the specific card in n draws.

Please note that quantity in deck does not have to be 1 specific card. It could indicate a type of card such as any monster card in general. Another example would be combo alternatives.

The other tables are used for drawing specific combinations of cards. The top table may be used for calculating the probability of drawing all of the cards you put into it. In other words the probability of drawing what you call a combo. The other table is used to determine the probability of drawing a specific card or alternatives with or without mutual exclusiveness.

Also note that this probability chart assumes complete randomness. Some tips on randomizing your deck can be found here.

That's a first. I would like to see some of your creative decks made by your builder ;o

Guess people are more than interested, excited.

Like I said, I made it for building Magic the Gathering decks. I haven't used it for Yu-Gi-Oh!, but I do know you can use it for Yu-Gi-Oh! Deck building. I will change it for Yugioh decks, and post up a download link.

Moved to the top.

mang could u upload it for 2003

2003 does not have a required function. I might be able to program the function but it will take me some time.

EDIT: Seeing as at this time I do not have access to 2003 (I do have it, but its hours from where I am right now), it will probably be a couple weeks before I can get it.

Can you explain how program and Probability Table work?

Moved to the top.