First of all, I dumped most of the data that Zaraktheus, of GameFAQs, found for SaGa Frontier (I found a bit of it myself), and I made some hack generating spreadsheets for them.http://biolab.warsworldnews.com/index.php
^SaGa Frontier boards - I'm also into all things SaGa, so I'll post my other stuff there too.http://biolab.warsworldnews.com/viewforum.php?f=5
^The hack generating spreadsheets. All I'm missing is half the combo data, and of course all the disassemblies and hex edits Zaraktheus made.
Second, I converted all my hack generating spreadsheets for Ogre Battle - The March of the Black Queen to use a python script, which has the advantage that it actually fucking works and it's automated.http://www.verve-fanworks.com/SMF/index.php?topic=817.0
^You can find them here.
Please note that they don't cover all the data in the game, by any stretch of the imagination. I hope to remedy that in the coming months.
The hack generating spreadsheets I made previously required you to copy hex strings into a hex editor. I thought this was all fine and dandy, until I tried to use one and I found that they don't work, because all the hex editors I tried would randomly switch between overwrite mode and insert mode.
After various discussions on other forums, I decided to re-organize my spreadsheets, to use a *.csv (comma separated value) as the base format from which to apply changes. The only thing I was missing was a way to apply those changes, without having to use a hex editor.
making this request on several different forums, schauerlich, of ubuntuforums, delivered the goods:http://ubuntuforums.org/showthread.php?t=2053233
You can also read more about the (absurdly simple) way I organize the *.csv in that same topic, should you decide that you want to steal this idea for your own game.
If anyone wants to make their own hack generating spreadsheet, then feel free to post here, and I'll tell you what I've learned. If you want to learn on your own, visit the Excel Help Forum:http://www.excelforum.com/
Excel has plenty of bugs - the most notable of which is the inability to concatenate a range of cells - but you have to develop down towards it, because almost everyone uses Windows, and almost everyone uses Excel.
Or talk to some of the people here (specifically, RavenOfRazgriz
The only functions you need to know are:
** The ampersand - & - does exactly the same thing as concatenate(), but it has fewer limitations in Excel. Read this for more info on the difference between the two.
** All the conversion to and from binary is useful when you're dealing with bit toggles.
** This is useful for calculating base addresses for data of relative length, like pointer tables.
* Basic math things, like +, -, *, and /.
* Bitwise operations, though I haven't actually made any spreadsheets that use them, I plan to in the future. I think I could use it to create a more easy to understand interface, or at least a way to preview their changes when it comes to really convoluted data structures.
Importing raw hex data into a spreadsheet is often a pain, so I like to put the raw data in a plain text file, and then use Replace All (Ctrl + h, in most cases) to replace the spaces between the bytes with a space and
a text delimiter, like the apostrophe (') sign. Alternately, you could replace the spaces with a comma and an apostrophe, rename the *.txt to *.csv, and then open it with Excel.
Some plain text editors can't handle Replace All on tens of thousands of entries, so it's often worthwhile to use something like Scite to do your Replace All.http://www.scintilla.org/SciTE.html
To open a file in Scite, you have to change the view from All Sources to All Files.
That's all I can remember about spreadsheeting at the moment. You can do a lot if you put your mind to it, even if you don't know how to program.