TOPIC: Amorgen's Character Designer (Excel Spreadsheet)

I'm assuming this is user error...but after importing from v26 to v33, all the classes are showing elevated base stats (by 1) for CON, INT, WIS and CHA. Any thoughts on what I'm missing?

Tsaelyn wrote: I'm assuming this is user error...but after importing from v26 to v33, all the classes are showing elevated base stats (by 1) for CON, INT, WIS and CHA. Any thoughts on what I'm missing?

It may be correct?

This year all stats were set to odd, so lots of them (but not all) were bumped up by 1.

CON used to be even for all but Cleric I think, so the other classes all got +1 CON.

Yes, that would appear to be the user error, going off of old stats. Thx.

One other thing that I do think I have right is that Ring of Icy Ki is not getting reflected in the Monk's dmg mod.

What weapons or weapon is your monk using?

Tsaelyn wrote: One other thing that I do think I have right is that Ring of Icy Ki is not getting reflected in the Monk's dmg mod.

For the Ring of Icy Ki +1 Cold to kick in, you have to be using the default Flurry of Blows or a FoB-compatible weapon.

Yeah...I'm going to stop posting now...

As best I can tell, the sheet doesn't work with LibreOffice 4.2 or 5.2. Loading the sheet up blank, it's claiming that the party has an initiative bonus of +48, and that all of the characters are level 5 and are due 11 treasure pulls. Appealing as that sounds, I don't think it's quite correct.

Is there a version of LibreOffice or OpenOffice that is known to work? Sadly, getting access to Excel is non-trivial for me.

Alan wrote: As best I can tell, the sheet doesn't work with LibreOffice 4.2 or 5.2. Loading the sheet up blank, it's claiming that the party has an initiative bonus of +48, and that all of the characters are level 5 and are due 11 treasure pulls. Appealing as that sounds, I don't think it's quite correct.

Is there a version of LibreOffice or OpenOffice that is known to work? Sadly, getting access to Excel is non-trivial for me.

I just tried it in LibreOffice myself. I see what you are referring to although I don't on the surface see why. It's possible that some functions I use are not fully supported in LibreOffice although I can confirm that it works in OpenOffice 4.1.2 (albeit more slowly than Excel).

Ah, OpenOffice 4.1.2 (on running on Linux Kubuntu 14.04) worked a treat, thank you!

For the first time in a number of years, I'm kitting out most of a party, and this will be quite helpful, so thanks for putting it together and maintaining it. I nosed around in the protected/hidden sections, and there is a lot of complexity hiding back there!

(As an aside, for anyone else using OpenOffice, if all of the sheet's background colors are missing, Tools > Options > OpenOffice > Accessibility, disable Automatically detect high contrast mode of operating system.)

Now for the not terribly pleasant task of trying to figure out what about the sheet is confusing LibreOffice so I can submit a bug report to the LibreOffice developers...

I've actually figured out most of it. I make use of the INDIRECT function to use built strings as addresses rather than directly specifying all of the addresses use direct cell references or the ADDRESS function. Excel uses ! as the separator between a sheet (tab) name and the cell reference. Both OpenOffice and LibreOffice use a period (.). Apparently, OpenOffice allows ! to be used interchangeably. LibreOffice does not.

I've figured out a fix for most of my functions and can release these as part of v.2016.34, however I have not figured out why the damage type indicators are all wonky and the check marks show as a different symbol.

You are amazing! You are really going the extra mile on this one!

I thought I was good at excel macros and stuff, but after looking at your implementation, well, I am amazed!

Thanks!!!

Myron

LibreOffice 5.2 is now supported!

Version 2016.34 Notes

• Adjusted formulas and images to conform with LibreOffice
• Fixed display of Retribution Damage when values were two digits
• Fixed hand requirement for Sling of Seeking
• Added Bard to Shield of Prism Offhand