Bobconley's page

Yes, I've been thinking on the best way to handle this. Obviously a character might have more than one caster class, so I'll either need multiple sheets or some means of parsing out the information for each class on a single sheet. What do y'all think as far as one vs. multiple Spell sheets?

Multiple sheets seems the quick and dirty fix since you only need 3, one for each casting attribute. Not sure how this would affect multi-attribute casters like the Mystic Theurge though. But going this route lets you have something up and running in the interim, giving you more time to decide how best to combine things into one sheet.

Are calculations on the spells tab planned for a future release? stuff like save DC's, spells known, etc.

Looking good!

One of the things I thought could make the project stand out from the rest (if it hasn't already been suggested) is to allow for different sheet styles, maybe 3 or so. For example you could have the standard style, then a minimalist look to save on printer ink and such, then maybe a style with larger fonts for those who need bigger text. A simple copy/paste special -> link array, then reformat the new style as needed.

Impact on file size should be negligible since there's no new data, and it could add incredible value to the project since a lot of players can be finicky as to the look of their sheet. An option you may want to consider down the road.

Well going back to your first principle of

File Size - I don't want a huge file that is a bear to email and/or performs slowly.

I'd say yes to pulling any erroneus data out of the file that is not needed, or not useful to the goal of the project. Of course you could reference the data in a separate file that could be linked to the primary (I think this is what you might refer to?), but again that would defeat the primary purpose, making the project unwieldly. Most people will be using their own reference material while building anyway, making any such text redundant and unnecessary.

In addition to that, I would go even further by removing other space hoggers like extra formatting, text coloring or anything else that increases file size with negligible value. Adopt the mantra of 'keep it simple' and you can't go wrong.

Bobconley wrote:

Thats what I thought at first but here take a look at this

top page, bottom page

These snaps are from the prior version PFRPG_CS_v_0_6_3.1 in OO, none of these issues existed in that version.

Tried filling in some fields, no success yet...

Okay, I've tracked it down! It appears that OO doesn't like the way i handle the blank Weapon and Armor lookups for things like Max Dex bonus and Weight. Since these flow through into other calculations like Encumbrance, it's throwing the sheet display out of whack. I'll have it fixed for the next release, but for now you can make those go away by putting something in each of the weapon and armor areas.

Nice work! Looking forward to next release :D

Can I Call My Guy Drizzt? wrote:

Do the ones on the weapons not go away once a weapon is chosen in the dropdown?

the NA on the skills are just the ones that can't be used untrained

and do the NA entries on, say, AC change once you start to fill in stats, armor, etc?

I haven't been able to find anything that specifically looks out of place for OO builds. Filling in some information to see if it makes the errors go away is a good idea. You can also try hard-coding (i.e., type directly into a field) to see if it fixes other areas. Starting with Encumbrance might be a good idea--you can type in Light and see what that does for instance. If you can experiment with this and let me know any positive effects, that might help me track down the issue.

Also, any other OO users out there that can confirm having the same issue?

And an update on progress--all PRPG core prestige class abilities have been added. Working on automation now...

Thats what I thought at first but here take a look at this

top page, bottom page

These snaps are from the prior version PFRPG_CS_v_0_6_3.1 in OO, none of these issues existed in that version.

Tried filling in some fields, no success yet...

Here are screenshots from OO. Last two I tried to resize columns a bit to get the errors to appear.

original, resize1, resize2

Bobconley wrote:

This looks absolutely terrific so far, nice job.

Found issues in Open Office 3.1

Issue1
Character Options tab, Favored Class
No longer functions

Issue2
Front tab, multiple boxes

Appear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,Swim

Appear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxes

It appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.

## is usually indicative of the field not being large enough to display the result. Try resizing and see if it goes away. It's fine in Excel but maybe something funky happens in OpenOffice with the sizing.

And, a request for a feature.. would it be possible for the Weapon attack bonus to auto apply the bonus from Weapon Focus and also apply the dmg from Weapon Specialization? It seems to me that since all the fields are there it wouldn't be too difficult, but it's well outside my circle of knowledge. Definitely not too pressing, since I can adjust those things manually, but it's one more thing that would make people go "wow" (and there are plenty already!)

I downloaded a fresh copy just to be sure I hadn't accidentally changed anything.

Then I just tried what you suggested: resizing the columns. Here are my results in Open Office 3.1:

-Boxes that were ## OR ### became #N/A.

-Some of those that were #N/A became Err:504. The following boxes show the error:

Touch AC
Shield
Dex Mod

Bobconley wrote:

This looks absolutely terrific so far, nice job.

Found issues in Open Office 3.1

Issue1
Character Options tab, Favored Class
No longer functions

Looks like the List_Classes_Base is messed up. You can do a quick fix on this by changing the Data Validation for those fields to =List_Classes instead. Fixed for the next version

Bobconley wrote:

Issue2

Front tab, multiple boxes

Appear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,Swim

Appear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxes

It appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.

Was it this way as soon as you opened it? The reason I ask is that sounds more like a piece of data somewhere is missing and if you can tell me what you entered it will help track down any issues.

It was this way as soon as I opened it, nothing was entered. I can post a pic of the issue if needed.

This looks absolutely terrific so far, nice job.

Found issues in Open Office 3.1

Issue1
Character Options tab, Favored Class
No longer functions

Issue2
Front tab, multiple boxes

Appear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,Swim

Appear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxes

It appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.