Gem Tracking and Probablility Spread Sheet

[rich4man]

I saw a couple of spread sheets for the Gem Hunt already but I decided to create my own. This one lets you track the number of each type of gem. This may be helpful if you want duplicates of each gem for Doug the Dog or to sell back to Arte. It also has probablity to help you determine which mine to select in order to increase you chanes of finding duplicate or non duplicate gems. If anybody does take a look please let me know what you think. Thanks!

[fireflie]

Wow! You have to tell how you did that! I'm trying to help my sister get the last gem that she needs and it is proving to be impossible, but with this, there's no teling what we can get!
I just found one problem though, I have 8 Zingoz Zincoz, and it can only go up to 5 on your spreadsheet. But otherwise, this could really help people out.

[rich4man]

Wow, 8 of one gem. I didn't think anybody would collect that many of one gem. Is Arte low balling his offer? I will increase the numbers. However, it won't affect the duplicate probability. As long as you have 1 of a gem, any number more would still be duplicates. I hope the spread sheet helps. I've been 2 gems away from the crown for a long time now. I created the spread sheet to help me increase my chances. It showed me I should be hunting in the barking mad mine. Hopefully I will find the 2 gems I need.

[fireflie]

Originally Posted by rich4man

Wow, 8 of one gem. I didn't think anybody would collect that many of one gem. Is Arte low balling his offer? I will increase the numbers. However, it won't affect the duplicate probability. As long as you have 1 of a gem, any number more would still be duplicates. I hope the spread sheet helps. I've been 2 gems away from the crown for a long time now. I created the spread sheet to help me increase my chances. It showed me I should be hunting in the barking mad mine. Hopefully I will find the 2 gems I need.

Thank you. I wish you luck on getting the 2 gems that you need. I'm 11 gems away from getting my 3rd one, and my sister is one gem away from getting her first.
Anyways Good Luck!

[rich4man]

Made a few changes to the spread sheet. I also added a data sheet if anyone is interested in founding out the probablity of getting gems for themselves.