OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Have results of one dropdown menu influence the next dropdown (and the data attached to each item)

  • Thread starter Thread starter John
  • Start date Start date


Apologies if the question is a bit confusing, allow me to explain more in detail.

I'm creating a spreadsheet that will help me to compare different weapon performances against certain monsters in a videogame. This would compare different types of bows, crossbows, and other types of ranged weapons.

Bows use arrows, while crossbows use crossbow bolts. Both bows and crossbows have arrows and bolts made of the same metals, but something like a steel arrow has different stats than a steel crossbow bolt.

Thus, I have made a list of "Bows" , "Crossbows" , "Arrows" , and "Bolts"

The bows and crossbows matrices are both arranged by weapon name and the attack bonus associated with it

| Weapon 1 | Weapon 1 Stats |
| Weapon 2 | Weapon 2 Stats |
|   ...    |      ...       |

The ammunition matrices are both arranged as such:

| Bronze Arrow/Bolt | Arrow/Bolt Stats |
| Iron Arrow/Bolt   | Arrow/Bolt Stats |
|      ...          |        ...       |

So essentially what I want to do is have a dropdown that allows you to select from both bows and crossbows alike, and when a selection is made, the second dropdown will only show the correct ammunition type available (arrows for bows, bolts for crossbows).

Then I want to perform a calculation for said Bow/Crossbow selection across every single iteration of the proper ammunition. For example, if I choose an "Oak Bow" , I'd like to perform a Damage Per Second (DPS) calculation using the stats of the Oak Bow and every iteration of arrow (bronze, iron, steel, ... )

I then would plot those DPS values on a chart, and allow myself to add other combinations for a visual comparison.

I do know that this would be easier in a program like MATLAB but I wanted to be able to share this around very easily with my friends.

Continue reading...

Latest posts