Thanks, that post above answered exactly waht i needed to know. Plus, it helped me learn a bit about coding in excel.
Great, I'm very glad it was helpful! I'm self-taught, so by no means an expert. I've definitely found that "doing" is the best way for me to learn. Of course that means over time my older work needs revision to take advantage of new things I've learned. One of the key things I'm focused on at present is only making a calculation once, if possible, then referencing that value rather than making it over and over in other cells. That's one reason I'd suggest using a table for your feat, since you can then use the results from that table in the various weapon entries rather than recalculating each one. AdAstraGames and others on this thread have also been very helpful in using things like VLOOKUP and MATCH, INDEX, OFFSET, etc. in more creative ways than I had before starting this little project...
|
Hmm, I'm not seeing that. Did you set anything else on the sheet other than race and class? I did notice I had left a Draconic entry in the Languages on the Getting Started tab. Is that perhaps throwing you off (although that should show 2 of 1 rather than 1 of 2).
I should of mentioned that it was in the P-Back tab. The L-Back tab is fine.
I created a cleric and here are a few issues that I found:
Selective Channeling is not an option even though my Charisma is 14.
The channel dice shows 0d6 on the abilities tab.
I needed to centralize the Channel_Level value so it works across both portrait and landscape views. Fixed it!
Erian_7, can you put it in your sig?
I'm not sure what you mean? The link to the last file is already in my profile, if that's it. I'm not aware of the Paizo forums having actual signature blocks for posts, but maybe I've just got mine turned off...which is probably a good reason to keep the link in my profile anyway!
I should of mentioned that it was in the P-Back tab. The L-Back tab is fine.
No problem, we worked around to finding the problem, then I realized I don't even need to track that data any more...The language functionality should be much smoother now (and also accommodates tengu and their Gifted Linguist racial ability).
When entering numbers for a custom weapon, the cost and weight are displayed as ####. By the way, creating a named custom weapon and giving a bonus proficiency with it is an easy non-automatic way of implementing the Heirloom Weapon Trait. Just have to change the ENH box and add a "1" to the +ATK box.
Also, is it possible to display the version number on the sheet in a more prominent position than at the top of the Getting Started Tab? I often overwrite the file name with the name of the character. Not a biggie...
One more thing, adding points in the Getting Started tab to Know(Local) and (Nature) doesn't actually add a rank on the landscape sheet, though it does on the Portrait one.
Zo
EDIT: I'm also getting a strange WBL variance. Haven't investigated much.
A minor bug I found
Location:
'L-Front' CU55 and CU57
'P-Front' BR96 and BR98
Problem:
The VLOOKUP function within these cells still use a column_index_num of 2 instead of the proper 10 like all the other rows in the list. This only becomes an issue if you change the order the skills, since these 2 rows are blank by default.
Thanks for all your hard work on this!
When entering numbers for a custom weapon, the cost and weight are displayed as ####. By the way, creating a named custom weapon and giving a bonus proficiency with it is an easy non-automatic way of implementing the Heirloom Weapon Trait. Just have to change the ENH box and add a "1" to the +ATK box.
Put in some formatting for those cells...For the Heirloom Weapon, that's a good idea. On the ENH field, however, changing it to MW (masterwork) should automatically add the +1 attack bonus.
Also, is it possible to display the version number on the sheet in a more prominent position than at the top of the Getting Started Tab? I often overwrite the file name with the name of the character. Not a biggie...
I actually put it there assuming everyone would see it any time a character is started. I'm open to suggestions for other places, though.
One more thing, adding points in the Getting Started tab to Know(Local) and (Nature) doesn't actually add a rank on the landscape sheet, though it does on the Portrait one.
Error in the VLOOKUP. Fixed!
EDIT: I'm also getting a strange WBL variance. Haven't investigated much.
I'm assuming this is on the P-Back tab? It was pointing at some areas on the L_Front tab rather than P-Front. Fixed.
A minor bug I found
Location:
'L-Front' CU55 and CU57
'P-Front' BR96 and BR98Problem:
The VLOOKUP function within these cells still use a column_index_num of 2 instead of the proper 10 like all the other rows in the list. This only becomes an issue if you change the order the skills, since these 2 rows are blank by default.Thanks for all your hard work on this!
This is the error that was hitting DigMarx as well. Fixed!
|
|
When entering numbers for a custom weapon, the cost and weight are displayed as ####. By the way, creating a named custom weapon and giving a bonus proficiency with it is an easy non-automatic way of implementing the Heirloom Weapon Trait. Just have to change the ENH box and add a "1" to the +ATK box.Put in some formatting for those cells...For the Heirloom Weapon, that's a good idea. On the ENH field, however, changing it to MW (masterwork) should automatically add the +1 attack bonus.
I think for this, he was refering to the Heirloom weapon giving a +1 trait bonus to attack with that specific weapon in addition to the +1 from the masterwork quality
I think for this, he was refering to the Heirloom weapon giving a +1 trait bonus to attack with that specific weapon in addition to the +1 from the masterwork quality
Ah, that's right. I forgot about the additional Trait bonus...
I always name my sheets things like:
Rurik_PRPG_CS_8_3.xls
So that the character name AND the sheet version show up.
I think for this, he was refering to the Heirloom weapon giving a +1 trait bonus to attack with that specific weapon in addition to the +1 from the masterwork quality
That is indeed what I was referring to, should have mentioned it more clearly. My Excel skills are somewhat lacking; the furthest I've ever gone with the program is creating a class record for my English students that calculated a few things like current grade, test averages and end of term assessment numbers using a bit of conditional logic. I wish I could help out in a more technical fashion but my coding skills in general are quite rusty as well.
To Erian:
As far as the version number, it's not as though it's hard to find, but you might stick it at the top of the FAQ tab or even on the tab name itself. Just a thought, not important.
Aside from all the current bugfix talk, what features currently missing are you looking at for v1.0? Is that too far off?
Zo
I think for this, he was refering to the Heirloom weapon giving a +1 trait bonus to attack with that specific weapon in addition to the +1 from the masterwork qualityThat is indeed what I was referring to, should have mentioned it more clearly. My Excel skills are somewhat lacking; the furthest I've ever gone with the program is creating a class record for my English students that calculated a few things like current grade, test averages and end of term assessment numbers using a bit of conditional logic. I wish I could help out in a more technical fashion but my coding skills in general are quite rusty as well.
To Erian:
As far as the version number, it's not as though it's hard to find, but you might stick it at the top of the FAQ tab or even on the tab name itself. Just a thought, not important.
Aside from all the current bugfix talk, what features currently missing are you looking at for v1.0? Is that too far off?
Zo
The "final" release should have at a minimum:
- full automation for magic items (in the works now)
- fully automation for spell effects (I'll probably farm that to v.0.9 so I can get releases out to the Pathfinder DB more rapidly)
- full customization options for all major aspects of the sheet
- fully functional animal companion/familiar/eidolon options
So, really we're pretty close to what I'd considered a version worthy to be called something beyond "beta" for the masses. Of course, I'm open to any other suggestions folks here have on what might be necessary for a final release, so let me know! And just so it's not an assumption, I'll also be continuing to add 3PP and Paizo OGC material up to and after the release.
To Erian:
As far as the version number, it's not as though it's hard to find, but you might stick it at the top of the FAQ tab or even on the tab name itself. Just a thought, not important.
Zo
While I'm not Erian, I'm a regular contributor.
One of the things I want to see is a second sheet that's a character copier, that uses Visual Basic to migrate data from older versions to newer versions.
For that to happen, all the tabs have to have the same names between versions, and most of the data has to be in the same place(s) between versions.
Changing the name of the tab to indicate the version number kills this deader than a doornail.
To Erian:
As far as the version number, it's not as though it's hard to find, but you might stick it at the top of the FAQ tab or even on the tab name itself. Just a thought, not important.
Zo
While I'm not Erian, I'm a regular contributor.
One of the things I want to see is a second sheet that's a character copier, that uses Visual Basic to migrate data from older versions to newer versions.
For that to happen, all the tabs have to have the same names between versions, and most of the data has to be in the same place(s) between versions.
Changing the name of the tab to indicate the version number kills this deader than a doornail.
Yeah, I'm also keying off of the cell value to update the actual Version information stored with the file properties, which I couldn't do from a tab name.
For the FAQ, I figured more people would see it on the Getting Started tab than there? Of course, once we get into "final" land I'll have a Revision History tab that shows anything added after the 1.0 baseline. This is my ultimate solution for the version display.
We can't have a v1.0 until the Diabolist's imp is implemented (or perhaps that falls under the umbrella of fully functional animal companion/familiar/eidolon options).
|
I noticed a problem with Weapon Focus. I created a 1st level fighter and armed him with a greatsword on L-Front. I chose Weapon Focus as his 1st level bonus feat. When I checked L-Abilities & Feats it displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls with
+1 bonus on attack rolls with
After I chose greatsword as his Weapon Focus choice the L-Abilities & Feats tab displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls with
And the +1 bonus was not added to the greatsword's attack bonus.
I made a lv 2 halfling rogue, with 18 dex + 2 racial.
Put 2 ranks into disable device, but its showing 8 instead of 10.
20dex = +5
Class skill = +3
Trained = +2
Total = +10
It seems to be this way with all trained class skills.
Am i wrong, is the sheet wrong, or am i missing something?
In future releases, you might want to make an area for custom hard coded items and tables. This way its easy to just copy and past from the old form to the new when upgrading, and there will be no worry about custom rules breaking the new funcitonalities.
I'm thinking that you could have the cells make an IF check to see if there is a custom rule applied to that weapon, armor, magical item, etc. If it has one, it calls that rule, if not it uses the sheet standard.
For example, you could have it so that the you have a "Rule Name" field, a "Type Affected" field with a drop down to select weapon, armor, or magic item, an Items affected field where the specific item names can be added, & a formula field where the replacement formula can be added.
This would make it easier for DMs to extend the sheet for use with any homebrew setting as well as any importing of old 3.5 or earlier rules.
I'd like something along these lines as well.
Okay, just pulled down 8.7 and am working with it a bit. Erian, you've really gone above and beyond here, my friend. I like, in particular, the way you handled the "additional skill point thing" for the Headband of Vast Intellect (or at least what I think you did, it's coming up precisely as it should on the sheet itself). It's a simple mechanic, and it works perfectly. Kudos to you.
We can't have a v1.0 until the Diabolist's imp is implemented (or perhaps that falls under the umbrella of fully functional animal companion/familiar/eidolon options).
Yep, they are in with the general familiar functionality. Just need tweaks to handle the HD and such.
I noticed a problem with Weapon Focus. I created a 1st level fighter and armed him with a greatsword on L-Front. I chose Weapon Focus as his 1st level bonus feat. When I checked L-Abilities & Feats it displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls with
+1 bonus on attack rolls withAfter I chose greatsword as his Weapon Focus choice the L-Abilities & Feats tab displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls withAnd the +1 bonus was not added to the greatsword's attack bonus.
It sounds like you selected Weapon Focus [] before you specified the greatsword. What you have to do is put Greatsword in one of the Weapon Focus Selections fields. Then the Weapon Focus [Greatsword] feat will show as a selectable feat. Once you choose that, it'll aplly the bonus properly. I'll work in some logic to make this more clear.
I made a lv 2 halfling rogue, with 18 dex + 2 racial.
Put 2 ranks into disable device, but its showing 8 instead of 10.
20dex = +5
Class skill = +3
Trained = +2Total = +10
It seems to be this way with all trained class skills.
Am i wrong, is the sheet wrong, or am i missing something?
Hmm, I just ran a test with this and got +11:
20 Dex = +5
Class Skill = +3
Skill Ranks = +2
Trapfinding = +1
Was there anything else going on with the character--an Armor Check Penalty perhaps?
I'd like something along these lines as well.In future releases, you might want to make an area for custom hard coded items and tables. This way its easy to just copy and past from the old form to the new when upgrading, and there will be no worry about custom rules breaking the new funcitonalities.
I'm thinking that you could have the cells make an IF check to see if there is a custom rule applied to that weapon, armor, magical item, etc. If it has one, it calls that rule, if not it uses the sheet standard.
For example, you could have it so that the you have a "Rule Name" field, a "Type Affected" field with a drop down to select weapon, armor, or magic item, an Items affected field where the specific item names can be added, & a formula field where the replacement formula can be added.
This would make it easier for DMs to extend the sheet for use with any homebrew setting as well as any importing of old 3.5 or earlier rules.
I'm not sure I quite follow this request. Would this be on an item-by-item basis? If so, that would be a ton of logic checks to add. I think, rather, that I'm likely not understanding the overall concept properly. Can you give a specific example?
Okay, just pulled down 8.7 and am working with it a bit. Erian, you've really gone above and beyond here, my friend. I like, in particular, the way you handled the "additional skill point thing" for the Headband of Vast Intellect (or at least what I think you did, it's coming up precisely as it should on the sheet itself). It's a simple mechanic, and it works perfectly. Kudos to you.
Thank you, sir. It gets better every day thanks to the dedication of you folks finding all the bugs and giving me such good ideas!
I do indeed have a split in the mechanic for Enhancement bonuses to Intelligence so it doesn't mess up the skill ranks. I'm glad the overall approach is working properly. It's only half-formed right now--I've got to tie it into the magic item automation and also figure out an elegant way to account for the static skills that are pre-loaded into the headband (and also figure out how to work with the scarlet and blue ioun stone since it provides an Enhancement bonus but doesn't have preloaded skills... ).
Oh, and for all...I'm down through Boots of the Winterlands for magic items. Should have all the slotted items in by tomorrow I think.
|
|
I noticed a problem with Weapon Focus. I created a 1st level fighter and armed him with a greatsword on L-Front. I chose Weapon Focus as his 1st level bonus feat. When I checked L-Abilities & Feats it displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls with
+1 bonus on attack rolls withAfter I chose greatsword as his Weapon Focus choice the L-Abilities & Feats tab displayed...
+1 bonus on attack rolls with
+1 bonus on attack rolls withAnd the +1 bonus was not added to the greatsword's attack bonus.
It sounds like you selected Weapon Focus [] before you specified the greatsword. What you have to do is put Greatsword in one of the Weapon Focus Selections fields. Then the Weapon Focus [Greatsword] feat will show as a selectable feat. Once you choose that, it'll aplly the bonus properly. I'll work in some logic to make this more clear.
Okay...that worked. Thanks. It would be nice, however, if it worked both ways. When I pick a feet like Skill Focus or Weapon Focus I usually think of it in terms of left to right. Pick the feat (left)...then pick the skill or weapon (right). It would be similar to writing an application. You type in the name of the function...left parentheses...argument...right parentheses. Does that make sense?
Okay...that worked. Thanks. It would be nice, however, if it worked both ways. When I pick a feet like Skill Focus or Weapon Focus I usually think of it in terms of left to right. Pick the feat (left)...then pick the skill or weapon (right). It would be similar to writing an application. You type in the name of the function...left parentheses...argument...right parentheses. Does that make sense?
What's happening here is this:
The name of the feat (Weapon Focus []) is being used to match both the name of the weapon and the feat list, and it's populated from a drop down list.
Excel can concatenate the name of the feat into the drop down for the feat list, because it's got a 'blank' in that name that gets filled by whatever you select in the Weapon Focus feat.
You have to fill out the drop down there first before Weapon Focus will work, it's one of the limitations of Excel. (Both Erian and I have tried to find a way around this, but it just doesn't happen.)
I'm making an Inquisitor and the domain implementation is a bit wonky. Inquisitors get the domain powers but not the spells, however it's showing in the sheet the other way around. Additionally the Travel domain's +10' to base land speed has to be manually implemented.
Additionally, on the spells tab, the "Total Per Day" boxes should remain 0 until there's an entry in Spells Per Day at each level. As it is, the bonus spells are carrying across.
Zo
This may take a bit of work, and I am not sure the best implementation, but I would love the ability to have a Wild Shaping section.
You could make a dropdown that adds the stat changes throughout the character sheet, but then you have to have a computer there to get your stats if you do wildshape or go back to normal form. Unless you you printed out a bunch of different versions of the character sheet.
I guess you could also make a worksheet that contains just the stats that change when you wildshape. You look there first, if it is not there, you find it on your normal character sheet.
If you need help with this sort of thing or even data entry, let me know. I am fairly proficient with excel.
I'm making an Inquisitor and the domain implementation is a bit wonky. Inquisitors get the domain powers but not the spells, however it's showing in the sheet the other way around. Additionally the Travel domain's +10' to base land speed has to be manually implemented.
Additionally, on the spells tab, the "Total Per Day" boxes should remain 0 until there's an entry in Spells Per Day at each level. As it is, the bonus spells are carrying across.
Zo
Ah, the Inquisitor domains weren't in the logic for the Travel boost. Fixed it (and consolidated all the travel mods to a central formula).
The domain power display issue was a VLOOKUP error. Fixed it with a MATCH function.
I also put a check on the spells tab to ensure the bonus spells don't get counted unless there's a number in the Spells Per Day field (and 0 is a valid number, so classes with the "0" entry should work properly).
This may take a bit of work, and I am not sure the best implementation, but I would love the ability to have a Wild Shaping section.
You could make a dropdown that adds the stat changes throughout the character sheet, but then you have to have a computer there to get your stats if you do wildshape or go back to normal form. Unless you you printed out a bunch of different versions of the character sheet.
I guess you could also make a worksheet that contains just the stats that change when you wildshape. You look there first, if it is not there, you find it on your normal character sheet.
If you need help with this sort of thing or even data entry, let me know. I am fairly proficient with excel.
That's a good idea, definitely something to consider for a future release. Ideally it could be something in the Spells and Effects section on front. Let me think on this one a bit.
As for the assistance, I'm always open to help! Right now I'm focused on getting the slotted magic items in place, as those are the ones requiring the most mechanics in the sheet. Anybody that wants to follow suit with the unslotted items hastens the release of the next version...
And then there's the very similar work of getting the spell effects in (all spells, all classes, all levels). It'll be in a table similar to the magic items, and I'll then do a compare between the item and effect fields to accommodate stacking rules.
|
|
Under the Weapons in the Combat Options dropdown, could "Favored Enemy" be added to the list?
You have such things as Higher Ground and Expertise and Power Attack, etc. It would take 5 new entries on the list though, whether it was a generic Favored Enemy +2, +4, +6, +8, +10; or if you did like the Weapon Focus [] feats and referenced the individual Favored Enemy [] cells. Seems to me the easier of the two would be the generic option, but it sure would be neat to have that specific reference.
I don't know if a more comprehensive list would be beneficial or not, but maybe referencing all the combat options rather than a select few in that list could be something to strive for in a later version.
Now I'm curious as to what that would entail to list ALL the options...
I know I can fill three slots with a ranger using a bow: Point blank shot, Focused Shot, Favored Enemy. Only Point Blank Shot is even in the Combat Options list as of now.
May not be something to tackle right off, but to bear in mind for a later date since you have your hands full with the magic items stuff.
Under the Weapons in the Combat Options dropdown, could "Favored Enemy" be added to the list?
You have such things as Higher Ground and Expertise and Power Attack, etc. It would take 5 new entries on the list though, whether it was a generic Favored Enemy +2, +4, +6, +8, +10; or if you did like the Weapon Focus [] feats and referenced the individual Favored Enemy [] cells. Seems to me the easier of the two would be the generic option, but it sure would be neat to have that specific reference.
I don't know if a more comprehensive list would be beneficial or not, but maybe referencing all the combat options rather than a select few in that list could be something to strive for in a later version.
Now I'm curious as to what that would entail to list ALL the options...
I know I can fill three slots with a ranger using a bow: Point blank shot, Focused Shot, Favored Enemy. Only Point Blank Shot is even in the Combat Options list as of now.
May not be something to tackle right off, but to bear in mind for a later date since you have your hands full with the magic items stuff.
Favored Enemy is a good idea. For feat-based combat options, my actual goal is to have the list dynamic so that only options actually available show up. Once I get that in place, I could add more feats to the list without it getting too unwieldy. Now, I will say that if you come up with that list of ALL the options and can share it, it'll help me plan things out...Thanks!
What's wrong with just using the +ATK and +DMG bonus drop downs for favored enemy? I ask, because the price of additional features like this is greater work in maintaining the sheet...
erian,
i just downloaded your latest version 8.7 and had a question. i am creating a halfling bard lvl 1, with 20 dex and the weapon finesse feat. i am using a whip. i set the ability for the attack type to dex, the weapon to melee and the wielded as to 1-handed. it says my attack mod is +13. am i missing something? or should it be +6 (dex +5 and size +1)
thanks for the time and effort. the sheet is awesome!
|
|
Okay...that worked. Thanks. It would be nice, however, if it worked both ways. When I pick a feet like Skill Focus or Weapon Focus I usually think of it in terms of left to right. Pick the feat (left)...then pick the skill or weapon (right). It would be similar to writing an application. You type in the name of the function...left parentheses...argument...right parentheses. Does that make sense?What's happening here is this:
The name of the feat (Weapon Focus []) is being used to match both the name of the weapon and the feat list, and it's populated from a drop down list.
Excel can concatenate the name of the feat into the drop down for the feat list, because it's got a 'blank' in that name that gets filled by whatever you select in the Weapon Focus feat.
You have to fill out the drop down there first before Weapon Focus will work, it's one of the limitations of Excel. (Both Erian and I have tried to find a way around this, but it just doesn't happen.)
Thanks for the explanation. I'm a Unix guy, so I'm not quite as familiar with Excel's function usage. :)
|
|
Hi Erian!
I was noodling aroind with the sheet to create (or rather "RE-create") Valeros from Rise of the Runelords and when putting 1 rank in climb his total was +11! I noticed that the sheet gives a +10 "off the bat". Futhermore, I noticed that when any class skills that were added did not give the +3 bonus as normal. I apologize for pointing out so many negatives because I know that you've been working so hard on this and doing such a wonderful job!
Ok, I know this might be asking too much, but can you do a changelog of some kind. This way us users/beta testers can know whether we want to worry about upgrading to the lates sheet and making all of our custom formulas work.
I know this thread kind of acts like a changelog, but its really long and sometimes confusing as to what has been changed in the latest version.
I have actually tried that in past projects, but the problem is in this beta stage I am changing so many things that the log either gets really long, I miss logging something, or I forget to do it entirely. Now, if I were using good PM practices of course I'd have better change control (along with documented requirements, a design/specification, and test plans...). I will indeed have a revision history page once I get out of beta, as I shouldn't have as many changes after that point.
erian,
i just downloaded your latest version 8.7 and had a question. i am creating a halfling bard lvl 1, with 20 dex and the weapon finesse feat. i am using a whip. i set the ability for the attack type to dex, the weapon to melee and the wielded as to 1-handed. it says my attack mod is +13. am i missing something? or should it be +6 (dex +5 and size +1)
thanks for the time and effort. the sheet is awesome!
The Weapon Finesse feat is automated--you do not have to set that ability switch in the general attack section to Dexterity as that basically then counts your Dex modifier twice for the final calculation. That switch is more for races and such that universally change the ability used for attacks. I'll build in some logic so this doesn't get double-counted...
Hi Erian!
I was noodling aroind with the sheet to create (or rather "RE-create") Valeros from Rise of the Runelords and when putting 1 rank in climb his total was +11! I noticed that the sheet gives a +10 "off the bat". Futhermore, I noticed that when any class skills that were added did not give the +3 bonus as normal. I apologize for pointing out so many negatives because I know that you've been working so hard on this and doing such a wonderful job!
For the +11, check the Ring slots on the Back tab. It sounds like there's a Ring of Climbing in the mix...
For the +3 from class skills, can you give me more specifics? This is definitely working when I run my tests here.
How hard would it be to add a wildshape page? One that does the stat and nat armor increases for the various beast shapes and elemental forms and has pull downs for special abilities and attacks.
Building a tab to integrate that data with the basics from the character wouldn't be that hard. The most laborious piece would be getting the stats in for all of the wild shape options--I'd need a table that lists every animal/elemental/plant, the various stats relevant to the change, and special abilities.
|
I Just wanted to say, I love the new version. Other than my witches lizard familiar giving him a +13 to climb it works awesome.
I do have three questions/suggestions (all pertaining to the witch lol)...
1. Are there any plans to add the bonus known spells to the familiars?
2. Are there any plans to add a custom familiar? My DM has added a unique familiar to my toon in his campaign. lol
3. The familiars ability to learn spells per level; currently it's set to add all the new spells to the first level spells (under class abilities). The witch can choose what level spells they can add (as long as it is within a spell range known). Are there plans to add the ability to select the spell level learned per witch level?
Again, you have done an awesome job on this sheet, keep up the fantastic work.
Pick the feat (left)...then pick the skill or weapon (right). It would be similar to writing an application. You type in the name of the function...left parentheses...argument...right parentheses. Does that make sense?
....
Thanks for the explanation. I'm a Unix guy, so I'm not quite as familiar with Excel's function usage. :)
Excel is like MacGyver's Pocketknife. It is rarely ever the *best* tool for the job. It is usually good enough to get the job done. It also has the advantage of being the most widely distributed declarative 'almost programming language' environment in the world, as somewhere around 80% of all Windows PCs have Excel of some version or another installed on them, or Open Office Calc.
It even comes with a 'real' programming language installed (VBA). Hoever VBA tends to break Open Office and CAN break Excel for Mac, so we're avoiding putting it into the spreadsheet itself.
|
|
Hi Erian!
I was noodling aroind with the sheet to create (or rather "RE-create") Valeros from Rise of the Runelords and when putting 1 rank in climb his total was +11! I noticed that the sheet gives a +10 "off the bat". Futhermore, I noticed that when any class skills that were added did notFuthermore, I noticed that when any class skills that were added did not give the +3 bonus as normal. I apologize for pointing out so many negatives because I know that you've been working so hard on this and doing such a wonderful job!
For the +11, check the Ring slots on the Back tab. It sounds like there's a Ring of Climbing in the mix...
For the +3 from class skills, can you give me more specifics? This is definitely working when I run my tests here.
Okay the first part I took care of. As for the second part, when I add a rank of...let's say...Intimidate (a Fighter's Class Skill by the way), it only shows up as adding one point as opposed to four (one for adding the rank and three for it being a class skill). I have tried it with other class and skill combinations as well and it is all the same.
I've got another one, took me a long to find it, this is 8.7. Sorc 5/Dragon Disciple 7. Should have two breath weapon uses a day, and that should be at 10d6 damage, one per effective sorc level. I'm showing one use and 12d6. I think we have a little glitch. Everything else I've checked is still correct though, at least so far.
Edit: Whoops! It is 12d6, my mistake, sorry, just checked that. It's just a matter then of getting that second use up that the character is due.
I'm finding that copy/pasting data between the landscape and portrait sheets often throws a too many cell formats error, making it frustrating to change sheet styles. Similarly, the Abilities & Feats tab flows out of the field, throwing the too many cell formats error when I try to modify it to make it legible.
Zo
I Just wanted to say, I love the new version. Other than my witches lizard familiar giving him a +13 to climb it works awesome.
I do have three questions/suggestions (all pertaining to the witch lol)...
1. Are there any plans to add the bonus known spells to the familiars?
2. Are there any plans to add a custom familiar? My DM has added a unique familiar to my toon in his campaign. lol
3. The familiars ability to learn spells per level; currently it's set to add all the new spells to the first level spells (under class abilities). The witch can choose what level spells they can add (as long as it is within a spell range known). Are there plans to add the ability to select the spell level learned per witch level?
Again, you have done an awesome job on this sheet, keep up the fantastic work.
Check for a Ring of Climbing on that +13...
For the familiar, I do want to work in more of rh functionality and should be able to get that in one of the next several releases. I also do plan to add a Custom block for familiars and animal companions,
I did find one other minor bug. On the P-Front page under weapons. On the first weapon I chose light crossbow, ranged and it gave me my Melee attack bonus instead of the ranged attack bonus. I then tried it in the second weapon slot and had the same problem. The L-Front seems to work correctly.
Do you possibly have it set to Wielded As 1-Handed? That imposes a -2 attack penalty. If that's not the problem, we'll walk through some more specifics, but a test run on my sheet here seems to work fine.
Okay the first part I took care of. As for the second part, when I add a rank of...let's say...Intimidate (a Fighter's Class Skill by the way), it only shows up as adding one point as opposed to four (one for adding the rank and three for it being a class skill). I have tried it with other class and skill combinations as well and it is all the same.
Are you possibly looking for it to add to the actual Ranks? The +3 shows in the Calc Mods column--they do not count as actual ranks. I just ran a Human Fighter and it showed up properly on both the P and L Front tabs. If this is not the problem, let me know and we'll need to walk through the character creation step-by-step to see if something along the way is breaking.
I've got another one, took me a long to find it, this is 8.7. Sorc 5/Dragon Disciple 7. Should have two breath weapon uses a day, and that should be at 10d6 damage, one per effective sorc level. I'm showing one use and 12d6. I think we have a little glitch. Everything else I've checked is still correct though, at least so far.
Edit: Whoops! It is 12d6, my mistake, sorry, just checked that. It's just a matter then of getting that second use up that the character is due.
Got it. I was only adding the dragon disciple and sorcerer levels together for the overall uses/day. I've added a "+1 if dragon disciple > level 2" portion that should get it totaled properly.
I'm finding that copy/pasting data between the landscape and portrait sheets often throws a too many cell formats error, making it frustrating to change sheet styles. Similarly, the Abilities & Feats tab flows out of the field, throwing the too many cell formats error when I try to modify it to make it legible.
Zo
Hmm, yeah, I can't recommend moving back and forth between the formats right now. I've tried to keep them as close to one another as possible, but there may be little tweaks between the two that break things. For Abilities and Feats, can you give me more specifics there?
Disenchanter, I'm assuming your version of OO has the <Data-->Group and Outline--Group> menu option? If you use that on another spreadsheet (i.e. select some rows, then click <Group>) what happens?
First, let me apologize for not getting back to you sooner. Real life was messing with me.
Now, thanks to you mentioning this, it got me to figure out that the "+" symbol is OUTSIDE the cell area of the spreadsheet.
That is working.
As for the Err: 502... I have nothing for you. I downloaded 0.8.7 and at first that was no longer a problem. but I noticed other inconsistencies. (Mostly display related in the Landscape Feats and Abilities tab. The left side was offset under the row numbers.)
But when I reloaded to try the above question, the Err: 502 was back again.
I am going to chalk it up to the OS/OS version of Open Office "guessing" how to handle things when it chokes on loading, and doesn't always guess well.
This is why from the beginning I told you I don't expect you to do anything to get the sheet to work for me. I'm going to bow out of testing for you now, and thank you for the effort anyway.
I am going to chalk it up to the OS/OS version of Open Office "guessing" how to handle things when it chokes on loading, and doesn't always guess well.
This is why from the beginning I told you I don't expect you to do anything to get the sheet to work for me. I'm going to bow out of testing for you now, and thank you for the effort anyway.
Dis, if you're willing to keep testing, it would be a GREAT help for us in getting this version-safe for Open Office.
...about my last post...
It's that same old issue from awhile back, the formatting of the text block runs "off" the field.
pseudo-example:
"Uncanny Dodge (Ex): Cannot be caught flat-footed, even if attacker is invisib"
Zo