Another suggestion is to take all the cells that are black with white text and make them a shade of gray with black text. Inkjet printers don't deal well with tiny-font white letters on a dark field. A small thing, but maybe worth looking at. I changed mine to a light tan with black text and it prints out much better.
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functionsLooks 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
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.Issue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.
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 functionsIssue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt 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!)
|
Following your mention earlier that issues previously reported may not have been fixed, I've done some testing with v0.6.4 and found a few things that I've mentioned before are still wrong/missing. They are:
1. I added a custom race via the Customization tab. The custom race abilities didn't appear on the Feats and Abilities tab. The race abilities summary needs to populate through to the Ability Summary cell (BI12) on tables tab.
2. I entered a custom feat and selected it as the character's 1st level feat. It didn't appear on the Feats and Abilities tab.
3. I reordered the Skill list on Front tab to combine the general skills and the trained-only skills into a single ordered list. The skills all still worked OK but the Senses box above it showed "#NA" for the perception skill. I don't think the VLOOKUP it uses works when skills are reordered.
4. A bard can make all knowledge skills untrained and also gets a bonus of half his level to knowledge skills. Any chance of including that in the skill list?
I've also come across some new bugs most of which seem to have been introduced in 0.6.4:
1. When I open the file I get a security warning about missing links. It's looking for PFRPG_CS_v_0_6_3.1.xls in a folder that looks like your desktop. Sounds like you've fixed that in 0.6.4.1.
2. I created a 1st level paladin. The "Front" tab showed a channel energy level of 1st - should be N/A until level 4.
3. I created a Bard - it gave him heavy armour proficiency instead of light armour proficiency. Also gave him martial weapon proficiencies.
4. I created a Monk and levelled him up a few times. The monk speed increase is mentioned on the Feats and Abilities tab but is not added into the base movement on the front tab.
5. I created a 1st level Paladin. The class abilities box on the Feats and Abilities tab shows #REF!. I've tracked the problem down to the coding of the Aura of Good ability on the Class Abilities tab. You seem to have a few "IF" statements under construction for that ability.
And finally, one that may have been around for a while:
I've been messing around trying to get the spells per day & spells known boxes on the spells tab automated. I've managed to get them all working but I noticed that on the "Tables" tab, you've got the bard spells per day and spells known tables the wrong way round. Both the titles on the tables and the named ranges need to be swapped over.
Thanks for your efforts so far. My CotCT campaign kicks off this weekend, using your sheet for my party of 8 PCs. Keep up the good work!
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functionsIssue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt 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
I would vote to put back in the sample weapons entries. I've used the sheet enough now that I don't need it but it was a big help the first time I looked at it
Now that I've gone to the drop-down and auto-fills, this one is tricky since the data validation only allows items from the chart. I could, I suppose, add an actual entry that states "Example Ranged Weapon" or some such...
Another suggestion is to take all the cells that are black with white text and make them a shade of gray with black text. Inkjet printers don't deal well with tiny-font white letters on a dark field. A small thing, but maybe worth looking at. I changed mine to a light tan with black text and it prints out much better.
Hmm, I'll definitely take that into consideration. I like the contrast from a visual perspective on the screen, but definitely understand the printing concerns.
It was this way as soon as I opened it, nothing was entered. I can post a pic of the issue if needed.
Sounds like a common data element is misfiring somewhere in OO, maybe the encumbrance calculation. I'll dig into it further.
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
If you can screen shot that and send it to me that might help. Thanks!
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!)
Yep, this is definitely a feature I'm adding, along with automation for things like 2-weapon fighting, power attack, combat expertise, etc. My vision right now is to have things like weapon focus auto-calc, and then have selectors for the optional elements like power attack.
Been trying 6.4.1, and noticed the following:Created a 6th level ranger, but some of the class abilities showed "#N/A". I think the problem might be the value in 2n on the Class Ability tab, since after adding the ranger levels it shows a "value not available" error.
This sounds like you haven't selected something like Favored Enemy or Favored Terrain in the Character Options tab. Can you check that, then let me know?
What tab is this under because I am trying to fix this, too?
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
The Character Options favored class data validation pulls from the List_Classes_Base that is on the DataClasses tab. You can either fix the list name range (I tweaked the table on the DataClasses tab to work better as well, keeping all the base classes together) or you can just change the data validation on the Character Options tab to List_Classes instead. This will allow favored class selection to include prestige classes, so isn't the "final" fix but it should get folks through until I release v.0.6.5 (which now includes all of the Remarkable Races, the Shaman class, updates to the LSJ classes and bloodlines, and the Rebrn Soul bloodline--still working on the other Book of Arcane Magic/Divine Might stuff as well as the PRPG core prestige classes).
Some excellent testing!
Great stuff, and very thorough! All issues have been confirmed and corrected. Shoot me your email address and I'll give you a prize...
Here are screenshots from OO. Last two I tried to resize columns a bit to get the errors to appear.
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?
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...
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
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...
Thats what I thought at first but here take a look at this
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.
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.Thats what I thought at first but here take a look at this
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...
Nice work! Looking forward to next release :D
|
This looks absolutely terrific so far, nice job.
Found issues in Open Office 3.1
Issue1
Character Options tab, Favored Class
No longer functionsIssue2
Front tab, multiple boxesAppear as ## or ###:
Armor,Shield,Dex Mod,Other,Touch AC,Other,Acrobatics,Climb,Escape Artist,Fly,Ride,Stealth,SwimAppear as #N/A:
Encumberance,AC,Flatfooted AC,CMD Total,Various Weapon description boxesIt appears all of these share Str or Dex as the common factor. Probably just a missing ] or ( somewhere in the cross-tabulation.
First of all - great work !! I've just started using the spreadsheet and I'm still learning and will have to look back at earlier questions.
I had the same issue2 using OpenOffice - and here is how I solved it.
The issue seems to be missing entries. Once you fill out ALL weapons and also Armor and Shield it calculates the weight - and all the ### disappear. I don't think this is the best behaviour. I'm playing a Wizard - I have no Armour or Shield. I also only have a Quaterstaff and dagger.
I fudged it by using custom for Armour / Shield and added weight 0 and also after running out of weapons (also added unarmed - not it makes much sense with my strength 7) I added weight 0 in the weight fields of the other weapons on the front.
Seems if even one of these fields is ### - what currently is the default if not filled in - then all others depending on them are also becoming ###.
Thod
oops - missed that Erian already answered this one. I thought I checked before writing ...
oops - missed that Erian already answered this one. I thought I checked before writing ...
No problem. Having taken enough time to figure that one out, I bet you'll be great at finding other issues for me...I actually include blank (="") entries in my selection lists that do have 0 values, but it looks like OO doesn't like the fact that that are numerous blank values in these particular lists. Excel does okay because it just stops at the first matching entry.
oops - missed that Erian already answered this one. I thought I checked before writing ...No problem. Having taken enough time to figure that one out, I bet you'll be great at finding other issues for me...I actually include blank (="") entries in my selection lists that do have 0 values, but it looks like OO doesn't like the fact that that are numerous blank values in these particular lists. Excel does okay because it just stops at the first matching entry.
I know you have not finished the customization section, but I've been fooling around with it anyway. Let me know if you would like my list of things that are not working (perhaps it could serve as a todo list :-)
I'm asking because I don't want to bug you about things that you are still in progress on...
Post away! Customization is actually one of the things I'm working on now, so having folks test it out will help me fix it that much faster.
Something you may want to add in the weapons table are things like Sorcerer's elemental rays, Monks flurry of blows, etc
Something you may want to add in the weapons table are things like Sorcerer's elemental rays, Monks flurry of blows, etc
True on the magical attacks--in the "free form" version of the weapons I would actually fill those out for my games with various spells for primary casters. So things like scorching ray, acid arrow, etc. were directly on the front as primary "attacks" for that character. It'll be a while before I could do this fully for spells, but for the attacks tied to class abilities I can definitely do that.
For the flurry of blows, that will be tied into the 2-weapon fighting functionality and I'm looking to have it as a selector/switch for each entry. That way, for example, a monk could have his sai, his unarmed strike, and a flurry of blows with each
|
The Character Options favored class data validation pulls from the List_Classes_Base that is on the DataClasses tab. You can either fix the list name range (I tweaked the table on the DataClasses tab to work better as well, keeping all the base classes together) or you can just change the data validation on the Character Options tab to List_Classes instead. This will allow favored class selection to include prestige classes, so isn't the "final" fix but it should get folks through until I release v.0.6.5 (which now includes all of the Remarkable Races, the Shaman class, updates to the LSJ classes and bloodlines, and the Rebrn Soul bloodline--still working on the other Book of Arcane Magic/Divine Might stuff as well as the PRPG core prestige classes).What tab is this under because I am trying to fix this, too?
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
I guess that I am a dummy. Do you think that you could sems me a pictoral of what you're talking about?
My email is: kevida97 at comcast dot net
I guess that I am a dummy. Do you think that you could sems me a pictoral of what you're talking about?
My email is: kevida97 at comcast dot net
Not dumb at all--data validation can be tricky if you've not worked with it much before. Email sent...
Not dumb at all--data validation can be tricky if you've not worked with it much before. Email sent...I guess that I am a dummy. Do you think that you could sems me a pictoral of what you're talking about?
My email is: kevida97 at comcast dot net
Here are a couple screenshots, just in case others have the same issue. (Office 2007)
Highlight the appropriate cell
http://img156.imageshack.us/img156/240/captureys.jpg
On the Data tab at the top of the screen, Select Data Validation and then edit as shown
http://img43.imageshack.us/img43/2465/capture3zk.jpg
A general question for the group...
As I've been building this sheet, I've always included full text (so long as it's OGC) for things like feats, class features, etc. This has been handy since the sheet can then serve as a sort of sortable, filterable data search in addition to being a character sheet. However as more information is added, this is going to greatly expand the size of the sheet with no specific value to the actual core purpose, i.e. being a character sheet, since I only use the automated/summarized versions in displays and printouts. As such, I'm contemplating pulling the full text out once it's no longer needed. In that case I would continue to maintain a separate sheet that's sole purpose is storing OGC for easy searching. Any thoughts on this one way or the other are welcome. Thanks, as always!
Oh, and I've got he Arcane Archer and Arcane Trickster fully automated. As I used them to work out the "this PrC increases caster level for X base class" logic, I expect the other to go faster. I've also completed entry and general inclusion of all OGC submitted to date, though I have not yet fully automated any feats outside the PRPG core and have only partially automated the domains and bloodlines. Non-automated material displays the full OGC text at this time. I'm still working on the Shaman class, as it's a bit tricky to work in properly. I've got the author working with me so I can properly represent his work. v.0.6.5 should be a very nice release...
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.
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.
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.
I've got a working version now with the PRPG core text removed and it's reduced the overall file size by over 1/6. For the reference tables, I intend for that to be a separate tool entirely and not linked to the character sheet (external file links drive me nuts in spreadsheets!). It will simply be a repository of OGC for Pathfinder that folks can use to find things, research, populate web sites, etc.
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.
I'm of two minds here. I've seen some really slim sheets that are so ugly (whether printed, displayed, or both) that I don't want to use them. In this regard, I want to keep the sheet as aesthetically pleasing as a spreadsheet can be. I also am looking to use some colors as a visual guide to using the sheet (green means a data entry field for instance). Now, with that said I don't want anything unnecessary/unhelpful so if you see anything there specifically do let me know.
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.
I have considered this route for a while now, actually, going back to when folks started asking for landscape character sheets. I'm torn in that I want to keep the actual sheet as functional for in-game use as possible, i.e. I can make dynamic changes as they occur without breaking the sheet. Having multiple styles for viewing/print-out makes this more difficult, but I do think I've landed on a nice way to implement. It's still a version or two away, however.
Agree with earlier poster that ray should be a selectable weapon, and should reflect appropriate weapon focus feats.
Definitely on the list to add.
Make sure it is easy to expand the number of skills and feats (I want to use the sheet for an oriental game with dozens of new feats and skills)
Expansion of feats is pretty easy right now. For folks that just have a few, they can use the Customization tab, but if you are wanting to add dozens then you simply go into the Feats tab and add new lines (I've added a "Don't add below here" marker to help keep folks from breaking tables and lists and pointed out some of the required fields). Adding skills is even easier--just add them directly in the table in alphabetical order. I'm working to pull out some of the data embedded in the skill formulas so that they are easier to modify as well. Once the new version is out, I'll be eager to hear your feedback on these changes.
Not sure what PRPG column is for in the DataEquipment tab (custom equipment). Looks like you either need to put custom equipment in custom area, or better label the tables in the DataEquipment tab.
PRPG simply denotes the source of the item (the new version will have RR for Remarkable Races, and possibly PCCS for the Campaign Setting book if I get to those). The Custom areas are a precursor to having the Customization tab auto-fill these items for folks that don't want to mess around with the full table. If you are adding tons of new items, you can add them directly to the table in the appropriate area (e.g. Simple Martial or Exotic Ranged). Same goes for Armor. I'd definitely like to hear any recommendations for building instructions into the sheet for how to update these.
I’ve temporarily used custom traits to record class abilities. I’ve also put long term effects (like magical tattoos). Not sure if this is the right pane, but I think this type of thing belongs on the Abilities & Feats page.
Class Abilities are the trickiest thing to add right now. My original sheet was very basic and just used Concatenate to join various class abilities into a summary statement. I need a more elegant way to do this and allow vlookups on a Table_Class_Abilities. That would then make it much easier to add more. Still thinking on this one, but your solution (or alternatively using a Custom Feat) should work for now.
Speaking of class abilities, don't see any clues yet on how you plan to handle them.
Not sure what you mean here? Do you mean how I'll handle customization (if so see above) or how they'll display? If the latter, then they should already be displaying on the Abilities and Feats tab. If not, let me know as that's a bug.
Would be nice when the custom trait type is empty, that the sheet would suppress the “[]”.
Mine does not show anything for those. Can you point me to a specific one as this may be a bug?
Custom classes don’t show on "bass classes" box on the front page.
I've fixed this one for the next release.
Earlier versions of the sheet also had some prerequisite calculations fail because the custom class levels were not counted (have not tried this recently, but something to keep in mind).
I've fixed this one for the next release as well, but do give it a test...
Need prestige option for customer classes (so favored class don’t apply, different saving throw progression, etc.)
I've fixed this one for the next release.
I have some prestige classes with a custom BAB. Would it be possible to add this to the custom page?
Hmm, what do you mean there? I'm aiming to keep the released content as official OGC so as to not confuse folks, but I might be able to work something out.
|
|
Looking at the drop-down menus for the weapons might I suggest adding "two-weapon primary", "two-weapon secondary", "two-weapon secondary, light", etc. and have whatever bonuses/penalties be applied? Please don't think that I am nit-picking because this an awesome spreadsheet! I am just suggesting things that would "kick the awesome factor up a notch"! :)
Looking at the drop-down menus for the weapons might I suggest adding "two-weapon primary", "two-weapon secondary", "two-weapon secondary, light", etc. and have whatever bonuses/penalties be applied? Please don't think that I am nit-picking because this an awesome spreadsheet! I am just suggesting things that would "kick the awesome factor up a notch"! :)
I'm looking to add this as a selector for each weapon entry on the Front tab (along with power attack, 2-handed, etc.). It will then modify attack rolls and damage accordingly. This will be in the v.0.7 most likely (i.e. I'd like to get the PrC version out "official" before I start on this).
Is that what you mean, or do you want the weapon groups in the drop-down list itself to include the above mentioned entries?
Okay, not quite done, as I'm still working on some of the Shaman class (from Super genius Games) ability automation with the author, but I've finished adding all of the PRPG core prestige classes, plus of course all the fixes we've discussed. This version also includes all 11 Remarkable Races from Alluria Publishing, the bardic/wizard colleges, bloodlines, feats, and domains and such from 4 Winds Fantasy's Book of Arcane Magic and Book of Divine Magic. The Legend of the Shining Jewel races have been cleaned up a bit, and I've started the process for automating the Aristocrat, Noble, and Temptress classes for that living campaign. Thanks to all these fine 3rd party publishers for making this content available...if you like what you see, go buy their products! This should be a great opportunity for folks to "try before you buy" on these, and I guarantee you there's a lot more useful material in their products than what I can capture in this character sheet.
|
|
Looking at the drop-down menus for the weapons might I suggest adding "two-weapon primary", "two-weapon secondary", "two-weapon secondary, light", etc. and have whatever bonuses/penalties be applied? Please don't think that I am nit-picking because this an awesome spreadsheet! I am just suggesting things that would "kick the awesome factor up a notch"! :)I'm looking to add this as a selector for each weapon entry on the Front tab (along with power attack, 2-handed, etc.). It will then modify attack rolls and damage accordingly. This will be in the v.0.7 most likely (i.e. I'd like to get the PrC version out "official" before I start on this).
Is that what you mean, or do you want the weapon groups in the drop-down list itself to include the above mentioned entries?
Exactly what I meant! :) Again your product is superior to all others but I still want to help you kick it up a notch becasue I know you can do it! How's that for pep talk? :)
Hello Erian you have done a top job as usual.
I don't know if it has already been asked for but is it possible to automate the animal companions/familiars?
Is it also possible to make the class skills click able - If you choose a trait that makes a skill a class skill it would be cool if you could tick the box and make it so.
Exactly what I meant! :) Again your product is superior to all others but I still want to help you kick it up a notch becasue I know you can do it! How's that for pep talk? :)
It is indeed helpful, thanks!
Hello Erian you have done a top job as usual.
I don't know if it has already been asked for but is it possible to automate the animal companions/familiars?
Is it also possible to make the class skills click able - If you choose a trait that makes a skill a class skill it would be cool if you could tick the box and make it so.
Animal companions/familiars are definitely in my sights for the next version. Spellcasters have various attributes that add layers of complication, so I've been focused on the "core" material that affects all classes first and then I'll switch over to these (which also includes spell sheets customized by class).
As for the class skill question, I'm actually planning on going a step further on that and simply automating the traits entirely. The problem I've got right now is that some traits are a "pick this or that" and that is harder to code. Having a generic override for class skills would avoid this problem however, so consider it officially on the list!
Fiddling around while I wait for feedback on the latest version and so I added the "easy" playable races from the Bestiary.
Fiddling around while I wait for feedback on the latest version and so I added the "easy" playable races from the Bestiary.
Grin. Good thing that I made sure I consulted the Bestiary as well when doing some of the LSJ races. :)
I did want to say that I very much like the way the tabs are reorganized. It is definitely easier to add new material as it is now.
One thing I did notice is that you have things getting ready for fields to be influenced by magic items. I certainly can't wait for this option to go into effect. However, I no longer seem to be able to input the armor type/name on the back sheet. I assume that there might be plans for a future "combat" tab as in HeroForge in which you input your weapon and armor information?
For feats when selecting Weapon Focus (or any other feat that has a required specific designator), I get not only the "Weapon Focus []" on the Feats section, but the same "Weapon Focus []" after selecting the type of weapon for the focus on the Character Options tab.
For some reason in the Class Abilities section, Druid Spell/Orison information appears when the Cleric class is selected.
Also, the Aura of Despair (8th level ability for the LSJ Sensation Domain) appears at 1st level.
BTW, can you make a 4th hit point option for the Character Option tab? Max HP for levels 1-2 and 3/4 HD (round down) for level 3 and beyond.
Thanks!
|
|
Eric,
I've spotted a few errors with the latest release (0.6.5). They're getting harder to find these days, which is a good sign!
The new ones I've spotted are:
1. Racial bonus on saves is wrong, the lookup is currently pointing at column 24 of the races table, but needs to use column 25. It currently results in humans getting +1 on all saves but halflings not.
2. I created a cleric. Spells/day on the A&F tab showed under Druid heading - on the DataClasses tab the CL_Cleric and CL_Druid labels are the wrong way round and need to be flipped.
3. Cleric class skills are wrong - Bluff, Disguise, Stealth and a few extra knowledge skills are all flagged as class skills for a cleric, which they shouldn't be.
4. I created a Human Rogue lvl 1 with City Born as his 1st level feat - the text for the feat appeared twice on the A&F tab.
5. I levelled the same rogue up to lvl 3. He took Shingle Runner as his 3rd level feat. The A&F tab showed Run as a selected feat, plus it duplicated the text for Shingle Runner. Renaming Shingle Runner to Shingle Jogger got rid of the Run feat so I think you've got something looking for "Run" in the feats known list that's getting confused by other feats that have "Run" in their name.
Cheers,
Phil
|
|
Am I missing how to select armor and shield? I thought you just chose them on back page, but it's not letting me do that. I don't have an older version available right now to check.
dm4hire,
There are a few locked cells that need to be unlocked. You'll need to unprotect the "back" tab and unlock the dropdown lists in the armour and shield sections. There are 3 dropdowns to do for each - 2 on the top line of each block and 1 on the bottom line of each block (the bottom right-hand cell of the block).
Excel has a nasty habit of locking cells so, as a general rule, if you can't select a cell that you think you should be able to, unprotect the tab, select the cell and have a look to see if there's a formula in it. If there is, then leave it alone unless there's something you want to change. If there's no formula in the cell, then it's generally safe to unlock the cell.
Grin. Good thing that I made sure I consulted the Bestiary as well when doing some of the LSJ races. :)
I did notice the aasimar and tiefling are nearly identical, except for the favored classes. I'm assuming the renaming with an LSJ tags works okay? That's how I've handled things like duplicate Domain names as well. I was wondering on the feats--it looks like some are now duplicates of the Bestiary feats. Should I tag those as LSJ-specific or remove them in favor of the core feats?
I did want to say that I very much like the way the tabs are reorganized. It is definitely easier to add new material as it is now.
Good to hear! That's exactly what I'm going for. As I've been tweaking things I have now broken out some of the other class ability selections--rage powers, bardic music, rogue talents, mercies, and weapon groups. My thinking is that these are all areas likely to be expanded in future products and class variants, so having them as separate tables that feed the Class Abilities tab should make expanding them easier. I'm also adding in Custom rows so folks can easily add their own.
One thing I did notice is that you have things getting ready for fields to be influenced by magic items. I certainly can't wait for this option to go into effect. However, I no longer seem to be able to input the armor type/name on the back sheet. I assume that there might be plans for a future "combat" tab as in HeroForge in which you input your weapon and armor information?
Am I missing how to select armor and shield? I thought you just chose them on back page, but it's not letting me do that. I don't have an older version available right now to check.
Already noted by Phil above, but this is basically just Excel "helping" me out and locking fields when I don't want them locked after I make a change. You should be able to go into these directly and this will be corrected in the next release.
For feats when selecting Weapon Focus (or any other feat that has a required specific designator), I get not only the "Weapon Focus []" on the Feats section, but the same "Weapon Focus []" after selecting the type of weapon for the focus on the Character Options tab.
I think this is working as intended, but let me walk through it to make sure. I've built in three Weapon Focus selectors on the Character Options tab that you use to designate what weapon the feat(s) are covering. Once you select one, it flows through to other feats that require you to have Weapon Focus in a specific weapon (note there are some feats that simply require Weapon Focus without designating a weapon such as Dazzling Display). So, if you select a Dagger as your first Weapon Focus, the feat list will update to show Weapon Focus [Dagger], Weapon Specialization [Dagger], Penetrating Strike [Dagger], etc. It will also still have the Weapon Focus [] entries for the other two selectors unless you've put something in all three boxes on the Character Options tab.
So, is this how it's functioning for you or is something broken that I've missed?
For some reason in the Class Abilities section, Druid Spell/Orison information appears when the Cleric class is selected.
Found by one of our intrepid testers already--looks like I had the CL_Druid and CL_Cleric named fields flip-flopped. Fixed!
Also, the Aura of Despair (8th level ability for the LSJ Sensation Domain) appears at 1st level.
This one is actually functioning properly, at least in part. For material that I haven't yet automated, I reference the entire OGC text block. So, for instance, all of the new 3rd-party domains (well, except Preservation) are pointing at the full text. As I go through and automate these, the proper text will only appear when the character actually qualifies. This holds true for the new Bloodlines, the Class Abilities for the Aristocrat, Noble, and Temptress, as well as all of the non-core Feats. I will definitely automate all of these over time, but didn't want to hold up releasing a version as it'll take a while to plow through everything.
BTW, can you make a 4th hit point option for the Character Option tab? Max HP for levels 1-2 and 3/4 HD (round down) for level 3 and beyond.
Thanks!
Considering all the help the LSJ folks have been, you bet!
Eric,
I've spotted a few errors with the latest release (0.6.5). They're getting harder to find these days, which is a good sign!
The new ones I've spotted are:
Excellent testing as always, and also excellent to hear they are getting harder to find!
1. Racial bonus on saves is wrong, the lookup is currently pointing at column 24 of the races table, but needs to use column 25. It currently results in humans getting +1 on all saves but halflings not.
I thought I already fixed that once...must have saved over my own work! Fixed...
2. I created a cleric. Spells/day on the A&F tab showed under Druid heading - on the DataClasses tab the CL_Cleric and CL_Druid labels are the wrong way round and need to be flipped.
Thanks, helped me fix the problem noted above without even having to research!
3. Cleric class skills are wrong - Bluff, Disguise, Stealth and a few extra knowledge skills are all flagged as class skills for a cleric, which they shouldn't be.
Hmm, looks like I started down the road to automating these for Domains and didn't add in the logic. Fixed (so now a cleric with the Trickery domain gains Bluff, Disguise, and Stealth as class skills, etc.).
4. I created a Human Rogue lvl 1 with City Born as his 1st level feat - the text for the feat appeared twice on the A&F tab.
Took me a bit to find that one--had a set of concatenated text sitting in line with the feat summary formulas. Fixed!
5. I levelled the same rogue up to lvl 3. He took Shingle Runner as his 3rd level feat. The A&F tab showed Run as a selected feat, plus it duplicated the text for Shingle Runner. Renaming Shingle Runner to Shingle Jogger got rid of the Run feat so I think you've got something looking for "Run" in the feats known list that's getting confused by other feats that have "Run" in their name.
Cheers,
Phil
Argh...that one's going to be tricker, considering the rampant use of ISNUMBER(FIND) in the sheet. I'll have to dig into this one more...
A few more errors I have found:
Error on the front page tab under the SENSES section (the Perception modifier). Here is the corrected formula: =VLOOKUP("Perception",Table_Skills_Known,24,0)
I know that the LSJ PrC "Temptress" is not ready, but the cells to calculate the BAB and Saves have a Value Error problem rom the related Custom PrC cells. Under the Class Abilities tab, the Godly Gift ability should be >3 (not >4).
That's all for now. :)