Maezar wrote:

Yes, Excel 2007 is likely the issue. The sheet was developed in 2011 and tested in 2010 and 2013. These areas must be using features not supported in the older version. Unfortunately, I don't have 2007 to test with. I'll make a note that v2010 or newer are required.

Maezar,
One of my players monkeyed with this issue a little and found that the Weapon drop-down does not utilize a Named Range. The class drop down does and works fine in 2007. This may be your bug.

Also, he found that slightly widening the Feat of Str/Dex/Con column fixed the issue we were having there.

I have not been home yet to try these fixes, but hope it helps!

Hiya.

  Any chance of getting a 'converted' version for use with OpenOffice? I swore off  MS Office years and years ago...

^_^

Paul L. Ming

Hi Joseph,

Sorry, been totally swamped with work and then had some family vacation. A new version 1.12 is done and ready to release. I just need to update the web site.

-- 

Last edited by Maezar (6/17/2014 11:56 am)

Me too. Thanks Maezar.

It's looking fantastic, Maezar!

Played around with this alittpe this morning and it looks great! Thanks again for all the work you put into this Maezar!

Hi, Maezar--not sure if you're still updating and troubleshooting, but I've done some more work putting the sheet through its paces in making some pregens for GaryCon gaming. A couple of things I've noticed:

--Monk: The quarterstaff is not listed as a favored weapon--possibly because it's two-handed? But the monk description in the Players Manual disallows only "true" two-handed weapons, which I think means those with the + symbol (great axe, great hammer, etc.).
--Cataphract: Similary, the cataphract should start with mastery of the lance and one other weapon, but it seems the sheet anticipates only one weapon of mastery.
--Armor and shields: Not yet in the item database, I think, right?
--I've had to come up with some short spell descriptions to fit on the sheet for these characters, so if you want them to add to the database, let me know.

But I should stress that it's really working like a charm! I combined it with "Waifs of the Boreas" to generate the pregens. Easy-peasy. I haven't finished inputting them all yet, but I did experiment with outputting one to PDF today, and it looked good! I wonder if there's a way to get the first two pages onto one page and spells on a second. I was thinking that if one were to print at 8.5 X 14 (like the regular AS&SH sheet), it might also work well with one fold--and fit in the box set! Anyone experimented with printing?

Great post, Handy.

8 1/2 x 14 is probably not in the cards. I have had some nice experiences using 11x17, offering each player  a "folio."

Oh, a couple of other small things:

This could be my fault--perhaps I don't have fonts installed right?--but the trauma surival seems to be too large for the cell. If I unlock the sheet and reduce the font size there, it displays fine, but otherwise I get the Excel "###" unhappiness.

Also, an odd thing: If one copies a block of equipment and weights from one sheet to another, the weight autocalculator triples the weights! And there doesn't seem to be a way to overwrite this afterward. Deleting the contents of those cells did not get rid of the weight. Now, I only tested this using the first cells of the equipment list, and, again, it is most likely something I am doing wrong.

And I'm not sure that HD type and Crit. Hits are auto-updating by class, though there's a chance I messed this up. As per usual.