When developers write games they might forgot that it’s not necessary to store all the game data in the actual code. Some programmers simply use arrays to store information about weapons or units. I really recommend using Excel or some other external program for this. If you need to store values for real-time strategy or for a role playing game (besides some other genres) then it’s very handy to use some sort of spreadsheet for this, instead of trying to manipulate arrays.
When you store game information (like weapon or armor attributes) to an external spreadsheet you can export them and use the exported file in your game. Besides, when you use some external file format (like .CSV) then you also give players easier chances to create mods for your game. It’s very easy to change weapon and armor values when they are stored like this.
Here’s an example pic on how we are handling strikes for Edoiki game.
When I need to change something, I simply edit values and export .CSV file and the game reads the values using a small code I’ve made. Believe me – it comes extremely handy when there are lots of modifiers and you need to balance game.