Trouble with FFTorgASM

[Einlanzer]

So, after successfully teaching myself (with the various tutorials and stuff) how to use the other tools to modify the game, sprites, formations, etc., I've hit a stumbling block with ASM hacking that I don't have the knowledge to resolve on my own.

Basically, I'm trying to edit weapon formulas, etc. using Raven's spreadsheet, but I can't get FFTorgASM to recognize the XML file I created from the spreadsheet.  None of the patch options appear, and I'm not sure if it's a syntax issue, a version incompatibility, etc.  Has anyone had an experience with this and/or any insight into it? 

The main thing I want to do is use the modified formula for random damage (Rdm((PA/2)...PA+(PA/2))*WP) for axes, etc., since it's better than both the vanilla one (which is horrible) and the one in the zodiac xml file (which is too good).  If nothing else, I was hoping someone could at least give me the correct offset for battle.bin and the correct hex value for that offset, since I've had trouble isolating it.

Thanks!

[3lric]

the issue itself may lay within Raven's Workbooks, I've also had issues with them not being read in orgASM.

You might try making sure all letters that should be capitalized in the .xml (when compared to ones on other lines) are capital. as well as making sure the correct " are being used.

This solved the issue for me atleast.

[Einlanzer]

One thing I noticed that seems odd is that it isn't putting any spaces between the offsets, so it appears as one long continuous string of hex values.  Other than that, nothing is jumping out at me when comparing it to the working ones.

[3lric]

are all the correct " being used? my issue was those and a bunch of L's that weren't capitalized

[Einlanzer]

Alright - got it, there were some stray invalid references in the file, removing them fixed it.  Thanks for your help!

[Einlanzer]

Well, scratch that- that was a bad idea.  I got fftorgasm to read the file, but when I applied the patch it screwed up the game, now everything is hitting for 999.  I dunno, it looks like some lookups are screwy in the spreadsheet itself, but I'm close to calling it quits.

Edit - looks like my version of excel can't utilize the dec2hex function.  I also have no idea where the disc is to install it.  Oh well, at least I know what the problem is.

[Pride]

You need to download the plugin Analysis Toolpak for excel to use the function.