How to make a grid solver? Find The treasure

[Ontario_Atl]

Hi Guys,
I am trying to find a way to make a grid solver in excel,
I am playing a game that has a grid of 3x5 tiles and you have to uncover a treasure.
Every time I win or lose I write down where the bonus was, I have seen it repeat a few times now.
Is there a way to plug that information into excel and create an optimised was of guessing the probability of where the treasure should be based on the information i have collected?
I have about 30 different solutions, takes a long time to go through and weed out the where should I check next, so I was hoping to plug the problem into a system and make an odds calculator to let me know what the best tile to uncover would be.
This kind of problem is fun for me to figure out and see if I can "beat" the game, just not sure the best way to make it computerised and digital.
Any and all help is greatly appreciated, all in fun
Thanks in advance

 

[Eric W]

Welcome to the forum.

What are the rules of the puzzle? With 3X5 tiles, there can only be 15 possible places. I assume this is a little like Minesweeper, where once you reveal a tile, it gives you some additional information to use to pick the next tile?

 

[Ontario_Atl]

Welcome to the forum.

What are the rules of the puzzle? With 3X5 tiles, there can only be 15 possible places. I assume this is a little like Minesweeper, where once you reveal a tile, it gives you some additional information to use to pick the next tile?

Your right,similar to mine sweeper.
When you guess its either a treasure chest or a X, you get 2-4 X's per game, depending on bonus, so probably not possible to win every time.
If you uncover a treasure you continue, run out of x's and the game ends. There are 6 x's per board in different patterns
I have mapped out where some are and would like to put that into a file that will then show me the best tile to pick based on what information is currently uncovered

 

[Eric W]

Interesting. Depends on how the boards are generated. If the boards are generated randomly each time, then there's nothing you could do. There are millions of possible combinations (32,432,400 if I did the math right). I could probably figure out the probability of winning if I worked at it. But if there is a finite set of patterns that are used repeatedly, then something could be done. Every time you find a new pattern, you could add it to a table. Then when you play a new game, a program could compare the current state of the playing board with the known patterns, and see which ones are still valid, and choose a tile among them that is either statistically likely to win, or not be an X, or at least narrow down the possible patterns.

So maybe possible, maybe not. It is interesting, but unfortunately it sounds like it would take more time than I have to devote to it. Hopefully someone else might jump in.

Good luck!

 

[Ontario_Atl]

Interesting. Depends on how the boards are generated. If the boards are generated randomly each time, then there's nothing you could do. There are millions of possible combinations (32,432,400 if I did the math right). I could probably figure out the probability of winning if I worked at it. But if there is a finite set of patterns that are used repeatedly, then something could be done. Every time you find a new pattern, you could add it to a table. Then when you play a new game, a program could compare the current state of the playing board with the known patterns, and see which ones are still valid, and choose a tile among them that is either statistically likely to win, or not be an X, or at least narrow down the possible patterns.

So maybe possible, maybe not. It is interesting, but unfortunately it sounds like it would take more time than I have to devote to it. Hopefully someone else might jump in.

Good luck!

Thanks for the look none the less, you are correct, if it is random, im pooched.
I have seen it duplicate a few times which leads me to believe that there are a set number of boards and one is randomly selected.
I have about 30 right now to start to add to a table, just not sure on how to set something like that up. Seems like it might be more time consuming than it is worth.
Im just doing it for fun as well, really don't get anything out of it aside from winning, so I completely understand why it wont be worth the time.
If anyone else feels like weighing in, love to have some more theory discussons
Thanks again Eric.