Oh, Excel. You try. So hard.
I am a very organized person. Looking at the clutter around my house, you wouldn't think so (or my parents don't think so, when they come visit). But I am incredibly organized, to the point that it wouldn't surprise me to make a list of lists that I have. Part of it comes from my situation in life, I suppose. My full-time job has a myriad of tasks I have to complete each day that is ever-changing, plus I'm often in charge of other people, so I have to get them working as well. On top of that, I'm also a full time college student with online as well as in-class classes, so I have to keep all my homework and tests straightened out. Organization is the key to not falling behind and getting super stressed out.
So, when I first set out to plan my game, I made a very neat Microsoft Excel sheet with various tabs that almost mirrored that of the RPG layout in the maker. There's a tab for classes, enemies, skills, items, etc. And in those tabs, there are various columns. The items tab, for example, has each item name, whether or not it's a key item, where it can be found, and how it can be used. The enemy tab has the enemy name, picture, where it's found, what its stats are, and what level the player should be when they encounter it for a smooth battle. The actors tab has the name of each actor, a small description, a list of key items that go with that actor (if applicable), and their class.
You can see that it makes for a very neat, efficient blueprint for the game, that I can modify easily without having to sort through documents and derp around for too long in the maker itself. It also cuts errors almost in half, since I can change values in the spreadsheet and cross-reference them in the maker, just to make sure that everything is running as smoothly as possible. I even have a page for the scripts that I'm using, and everything that I have to mention in the credits so that I won't forget to... well... credit anyone!
While Excel is fine and dandy for stuff like this (though not hte original purpose of it, I suppose), I do have many, MANY qualms.
1. Enter doesn't work well. Well, Enter doesn't work at all. Maybe it's just too much to ask that when I press the Return key, it goes to the cell beneath the cell I was working in. Why is that so hard? Why does Excel think that I want to go back to the first column, next row? Why? WHY? (clenches fist) At least Tab works the majority of the time.
2. When you make a typo, it's much easier to go up the top and fix it, rather than wrestle with trying to fix it in the cell and having to rewrite the entire thing. Why can you not just edit like you would in Word? It's still ding-dang Microsoft Office, for God's sake! I don't like having to go all the way to the top; it messes with my rhythm. I become... upset.
3. This is more formatting than anything else, because Excel IS supposed to be a math thing, I guess. But the numbers are on the opposite side of the cell compared to words. I wish there was an option to get rid of that. (there may be, and I just don't know about it, but I doubt it)
And these are only some of my grievances, but they're the main three. Still, it's not enough for me to sacrifice Excel for a chart in word, simply because it IS such a neat, organized layout for my database stuff.
Even if I do temporarily become Emperor Kuzco sometimes.