Wednesday, January 09, 2008

Queen's Blade Reference Sheets Made Public

Even though my set of Queen's Blade Reference Sheets have been posted on the Internet for a while, I've never actually told anyone about them. They've just sat there like my other miscellaneous documents.

Well, now that I've caught up with all of the characters I purchased at GenCon and afterwards and finally split them all into their own page I've gone ahead and posted a message to the lostworlds-rpg mailing list about them.

I hope they find them useful and that I don't get into too much trouble for using images from the books and text from the translations. :)

Thursday, January 03, 2008

New Weapons UI Working

Not too long ago SPARK finally played some Car Wars again, and as a result I've been working on the new weapons page for the CWVD.

And boy, does it suck.

Currently each weapon entry has 16 controls. There's 13 weapon lines. Fixing a weapons block involves right-clicking on each control, pulling up the Properties dialog, putting the cursor in the right block, then either jumping to the end (using the mouse because the normal navigation keys move a cell selection cursor around) and editing the cell address to the right cell or collapsing the dialog box so you can use the mouse to select the right cell, then hitting Return a few times to OK out.

Did I mention that even putting the cursor in that field sometimes scrolls the worksheet so that instead of being right next to the cell you want you're a few pages up? Hope you noticed that when the entire page is 13 nigh-identical chunks of controls and data.

Along with those edits, a couple controls require changes in another block in the Properties dialog (easy to forget when you're going quickly), a simple (yay!) search-and-replace to fix all of the lookups, and a bunch of selecting boxes of cells and changing their Conditional Formatting using the menu and weird cell selection edit textboxes.

This is long, boring, repetitive work that's easy to screw up, but that doesn't matter anymore because it's finally done! Well, almost. I don't have the helper macros hooked up yet. I decided to take a break before doing that, so I've been putting together the proper pricing formulas. That's been going so quickly that all I have left is a couple of the mods.

At this rate, there might be a 10.8 beta before Gen Con! :)