is there a way to toggle barbarian rage?
Not currerntly.
One of the projects I plan to work on when I return in 12 days is a custom bonuses area on the Custom tab. You will be able to able to set a list of items that will be activated on the Bonuses tab. Additionally, within this framework I will then be able to add stat "sets" which would include selections for rage, all the conditions (frightened, dazed, etc), and many common non-level based spells, like bless.
Thanks for the quick reply;
another thing i noticed the rogue trapfinding ability applies to disable device checks as well as perception to find them, the sheet does not reflect this, as well masterwork theives tools dont generate a skill note, or a change to the skill calculations; on a side note the encumberance calculations on 0.49 are generating a 119 lbs on the page 1 but a 45 lbs on the items tab,with all of the items i am supposed to have;
i will try all of these on the newer version to see if the tweaks mentioned above have fixed these
Could you please reference in the rules where it indicates that Trap Sense also adds to your Perception and Disable Device traps skill checks. I can't find it.
I will be adding a future "weight toggle" on the Items page.
I have not set up general equipment to add bonuses. I think theives tools is the only one that would apply. I also sort of view theives tools as being a conditional bonus. (They are only of benefit when you have them -- however I realize that's like saying all worn magic items are also conditional bonuses.) I'm unsure if I will be adding in an auto bonus for having them in your possession, but I'm now starting to lean towards it.
|
Could you please reference in the rules where it indicates that Trap Sense also adds to your Perception and Disable Device traps skill checks. I can't find it.
Trap Sense doesn't add to Perception and Disable Device - it's the Rogue Trapfinding ability that does this. Core rulebook, p68, 1st column half-way down.
Thanks Phil for the clarification
Kor, makes sense i worked around it with an entry on the bonus tab till a change occurs, if it occurs
Hehe, forgot about that ability. Its even in the spreadsheet -- all I had to do was look at the spreadsheet and it would have shown me the page number :)
Currently the Trapfinding ability does show the bonus in the skill notes for the Perception check to find them, however it does not include the Disable Device skill. I will add that in for the next revision. I also notice that skill notes are not appearing on the summary sheet, so I will add them in as well.
One of the projects I plan to work on when I return in 12 days is a custom bonuses area on the Custom tab. You will be able to able to set a list of items that will be activated on the Bonuses tab. Additionally, within this framework I will then be able to add stat "sets" which would include selections for rage, all the conditions (frightened, dazed, etc), and many common non-level based spells, like bless.
I have a warm and fuzzy feeling all over now. :D
Side note:
* Have you considered adding sub-skills (like a monk has a much higher Jump than general Acrobatics rating)
* Failing that, can you include the appropriate speed-bonus to jumping in the notes section
A few things I've noted:
* a level 20 monk gains DR10/lawful, *not* DR10/magic (new in Pathfinder)
* manual and tomes of (training/understanding/etc) aren't reflected in the stats
* ioun stones (at least the dusty prism) aren't reflected in the stats
Hi all, I'm back from vacation and slowly chipping away at the sheet again. I have been testing it a bit and have noticed a few more minor errors including a problem still with Monk Flurry of Blows calculations. I am positive I have fixed it now though. There are many things I want to work on prior to a revision though, so its going to be a couple days.
A few things I've noted:
* a level 20 monk gains DR10/lawful, *not* DR10/magic (new in Pathfinder)
* manual and tomes of (training/understanding/etc) aren't reflected in the stats
* ioun stones (at least the dusty prism) aren't reflected in the stats
Thanks, I have now revised the DR they get to DR 10/chaos
Manuals and Tomes only provide a bonus once they are read, so I have not included the bonus for being in the character's possession. The bonus should be entered in the ability scores Extra Mod column on the Stats page.
They do seem to be working on my current sheet (I can't remember if I did a fix or not, prior to leaving on vacation.)
Great to have you back :)
Just have a couple of questions. I notice on the Page 1 in the name information section there is a field that says "Template". Is this in anticipation of adding templates to the file?
Also, just looking at some of the sheets and realizing that while I am Excel literate, I am not that Excel literate, it appears that adding a full progression class to the Excel is not real easy to get all the automation pieces. Is that a true statement or am I missing something?
Above you stated that the bonus for abilities should be entered on the Stats page, couldn't they also be added on the Bonuses tab and would track the source of the adjustment? When I have access to a computer during a game, I have a list of bonuses and I leave them in there, but don't put the modifier in until I need it. For example my character had Bull's Strength on him the other night. It's listed on my Bonuses list and when it got activated, I put the 4 in Bonus column and everything adjusts across the sheets.
All of the above said, I have upgraded my current character to your latest Excel release and built him out in that version. The sheet is coming along nicely.
Thanks again.
Just have a couple of questions. I notice on the Page 1 in the name information section there is a field that says "Template". Is this in anticipation of adding templates to the file?
Yes it is. I intend to get most of the Bestiary in the sheet at some point. Perhaps sometime before Bestairy 2 is released :)
Also, just looking at some of the sheets and realizing that while I am Excel literate, I am not that Excel literate, it appears that adding a full progression class to the Excel is not real easy to get all the automation pieces. Is that a true statement or am I missing something?
I'm assuming you are talking about adding your own custom class? If so, then there are mainly 2 sheets that would need to be revised: Classes_DATA and Attributes_DATA. Somethings I couldn't fully automate on these sheets though (like domains), which will require me to edit several sheets anytime another class with domain access is added.
Above you stated that the bonus for abilities should be entered on the Stats page, couldn't they also be added on the Bonuses tab and would track the source of the adjustment? When I have access to a computer during a game, I have a list of bonuses and I leave them in there, but don't put the modifier in until I need it. For example my character had Bull's Strength on him the other night. It's listed on my Bonuses list and when it got activated, I put the 4 in Bonus column and everything adjusts across the sheets.
Yes, it could be. The Stats page "Extra" columns are good for a quick and dirty entry, since the bonus is going to be treated as an untyped bonus. The bonuses sheet is better for routine/constant bonuses that you apply, and would like to know why you are getting the bonus.
All of the above said, I have upgraded my current character to your latest Excel release and built him out in that version. The sheet is coming along nicely.
Thanks for keeping an eye on the sheet. The current version is still a little buggy though. I am doing a lot of little minor fixes all over. I am hoping in 1 weeks time to have the revision out.
My current projects I want to finish before the next revision:
- a re-designed bonuses page (allows for multiple bonuses for 1 selection, and for selection spell and condition bonuses -- more for the paperless-laptop gamers) 95% done
- attribute display listings on the summary sheet 75% done
- linking weapons from Items to the Arms page 0% done
- attack displays on the summary sheet 0% done
- weight tally toggle on the Items page 0% done
Hrmm, now that I have fixed flurry of blows, it has occured to me that you can also flurry of blows with a monk weapon. Right now I have it defaulting to the unarmed strike amount. Hurray. Another thing to revise :)
Hrmm, now that I have fixed flurry of blows, it has occured to me that you can also flurry of blows with a monk weapon. Right now I have it defaulting to the unarmed strike amount. Hurray. Another thing to revise :)
This turned out to be an easy fix. I have now made Flurry of Blows a "wielded" selection.
Is there a way of loading up a stat block and it fill out the spreadsheet automatically?
Unfortunately not. I know other sheets like 3.5's Heroforge basically stored all the user entries into a data file allowing it to be easily copied from version to version. Although this might be something I would consider doing... its on the bottom of the priorities right now... so many things to do... so little time...
When will you add the new base classes from the Advanced Player's Guide? I know that a class like the summoner has dozens of new variables for you to deal with (such as building your eidolon).
When will you add the new base classes from the Advanced Player's Guide? I know that a class like the summoner has dozens of new variables for you to deal with (such as building your eidolon).
As soon as the guide is released, I will begin coding it into the sheet the same day. Although I am planning to go to Gencon, so if its released then (which is what I suspect) then there will be a little delay :)
Any chance of getting the Diabolist from Pathfinder Chronicles: Princes of Darkness, Book of the Damned Vol. I into the sheet as well?
Hey Kor,
Couple of things my group discovered last night when I was going over the sheet.
1) Looks like encumbrance is not affecting the movement rates. Don't know if this is intentional or not, so thought I would mention it.
2) Currently my character has a 1 Strength, so a -5 Strength modifier. Can you say ability damage and really bad save rolls? Anyway, he is now equipped with a light crossbow. The damage is showing as 1d8-5 on Page 3 of the sheet. The discussion that came to light last night is that the only time a negative strength modifier is a problem for ranged weapons is if the weapon is a bow or a sling. According to the discussion, crossbows should be unaffected by this modifier.
Hey Kor,
Couple of things my group discovered last night when I was going over the sheet.
1) Looks like encumbrance is not affecting the movement rates. Don't know if this is intentional or not, so thought I would mention it.2) Currently my character has a 1 Strength, so a -5 Strength modifier. Can you say ability damage and really bad save rolls? Anyway, he is now equipped with a light crossbow. The damage is showing as 1d8-5 on Page 3 of the sheet. The discussion that came to light last night is that the only time a negative strength modifier is a problem for ranged weapons is if the weapon is a bow or a sling. According to the discussion, crossbows should be unaffected by this modifier.
1) I have not yet incorporated encumbrance into the movement rate. So as a side project today, I did :)
2) Thanks for noticing this. I have it fixed now.
Sorry for the delay on the update, everyone. I have the next 3 days off, so it should be out by Tuesday.
Any chance of getting the Diabolist from Pathfinder Chronicles: Princes of Darkness, Book of the Damned Vol. I into the sheet as well?
Eventually I want to get all the resource book info into the sheet. I do move requests up on the "eventually" list though, so perhaps soon :)
Looking forward to it all:)
I noticed that bracers of armor add their AC to the Touch AC in the sheet. As I understand the bracers give an armor bonus and as such do not add to Touch AC - but unlike normal armor they *do* add to the Touch AC vs incorporeal attacks (owing to them also being a force effect).
The latest release is now available on the original post link.
Alpha version 0.52
Many little fixes.
All issues reported to me should have now been fixed. Most of the work I have had to do on the sheet, is "behind the scenes" work, so for the most part the sheet should still appear the same.
Please let me know if you notice any problems with Flurry of Blows calculations. These "might?" finally be fixed :) Note: Flurry of blows is now a "wield" type, since it can be used with monk weapons as well.
I have changed the weapon weild types to hopefully make things a little clearer for the dual-weapon wielders. Actually, I did a large change into the wield categories, and I am hoping that I remembered all instances of references to these categories, through-out the various data sheets. For some reason I think I am forgetting some, so it could be possible that some anomilies could pop up.
The Arms page in general (or rather its data page) has seen a lot of changes. Please keep an eye on weapons information to ensure everything is appearing correctly. I added an option to grab weapon information from the Items page, but this added a fair layer of complication.
I'm hoping to have the weapon selections for the Summary/Stat Block page done soon.
Please let me know if you find any problems, either by posting here or e-mailing me at kor@orcs.ca
I noticed that bracers of armor add their AC to the Touch AC in the sheet. As I understand the bracers give an armor bonus and as such do not add to Touch AC - but unlike normal armor they *do* add to the Touch AC vs incorporeal attacks (owing to them also being a force effect).
I'll get this fixed for the next update. Thanks.
Well, it looks like weapon display is wrong for magic shields/armor/weapons. Its showing them as:
2 spear
as opposed to:
+2 spear
I also notice bastard swords need to perform a martial weapon proficiency check when wielded in two-hands.
I've not checked in .52 - but this has been wrong in the past, so I assume it still is. Albeit, I imagine, a problem that is hard to fix:
If I generate a level 10 monk, then all bonus monk feat slots have the complete list of monk bonus feats. Rather than just the feats available at a specific level. The same applies to feats in general; if you have 6 fighter levels, you can make your first feat "Lunge", in spite of the requirement of minimum 6 BAB.
This isn't a problem if you build a character level-for-level; but it is an issue when you make a character at higher levels (since we are too lazy to do it level-by-level).
I've not checked in .52 - but this has been wrong in the past, so I assume it still is. Albeit, I imagine, a problem that is hard to fix:
If I generate a level 10 monk, then all bonus monk feat slots have the complete list of monk bonus feats. Rather than just the feats available at a specific level. The same applies to feats in general; if you have 6 fighter levels, you can make your first feat "Lunge", in spite of the requirement of minimum 6 BAB.
This isn't a problem if you build a character level-for-level; but it is an issue when you make a character at higher levels (since we are too lazy to do it level-by-level).
Unfortunately, based on how the sheet is designed, I am unable to change this. It is a real annoyance to me, but there's no real "easy" work around. Although, technically it can be done, I would have to build 19 more very large & complex data tables (1 for each level). I suspect the size and performance of the sheet would be of significant concern then.
Sadly, the only way to accurately build a character, is level-for-level.
Monk's Flurry of Blows
Well, once again I had an error in the calculations.
I have now fixed this, by deleting Monks as an available class. Now there will be no further Flurry of Blows problems :)
I'll have an update out tonight with the "latest" Flurry of Blows fix, as well as several other fixes, mostly relating to the Arms sheet.
Monk's Flurry of Blows
Well, once again I had an error in the calculations.
I have now fixed this, by deleting Monks as an available class. Now there will be no further Flurry of Blows problems :)
I'll have an update out tonight with the "latest" Flurry of Blows fix, as well as several other fixes, mostly relating to the Arms sheet.
I created a halfling character and when I equipped some studded leather on the 'items' sheet, the 'arms' sheet gave a bunch of errors when I selected the 'small studded leather' item. I'm guessing it was because of the word 'small', but didn't look into it further.
I created a halfling character and when I equipped some studded leather on the 'items' sheet, the 'arms' sheet gave a bunch of errors when I selected the 'small studded leather' item. I'm guessing it was because of the word 'small', but didn't look into it further.Monk's Flurry of Blows
Well, once again I had an error in the calculations.
I have now fixed this, by deleting Monks as an available class. Now there will be no further Flurry of Blows problems :)
I'll have an update out tonight with the "latest" Flurry of Blows fix, as well as several other fixes, mostly relating to the Arms sheet.
Thanks for reporting this. It was due to an enhancement bonus formula problem, which I had changed on the weapons selections, but had forgotten on the armor & shield selection.
The latest release is now available at www.d20.ca
Alpha version 0.53
I have made a few minor fixes - mostly to the Arms page.
The latest release is now available at www.d20.ca
Alpha version 0.54
A few more fixes, including to the Spells List page and to Dragon Disciple. (Sorry, I can't remember all the fixes... it was a hectic week.)
I have added weapons to the "Summary / Stat Block" sheet. This is only temporary, as there are several things I need to change how weapons are selected and combined. In the very least, GM's should be able to use this for most NPC's now.
Has the Diabolist been added yet?
Hiya.. first of all wonderful work you have here...
second just reporting Dervish dance feat ain't working on either office version with 2007 win 7 32 bit it doesn't show any effects for scimitar as it should.
thanks for wonderful tool
Hiya.. first of all wonderful work you have here...
second just reporting Dervish dance feat ain't working on either office version with 2007 win 7 32 bit it doesn't show any effects for scimitar as it should.
thanks for wonderful tool
Thanks for mentioning this. I have now added this into the next version.
|
Thanks for putting out this sheet.
The only mistake I saw so far is the unit price of shiruken. Its 1gp per 5, so the Unit Price is 0.2 not 1.
Edit: The price of rations, trail (per day) is 0.5 not 0.05.
My 2 cents: have page 2 sectioned off between Racial Abilities, Class Abilities, Feats, Traits, and Notes.
Keep up the great work.
I've been converting some 3.5 NPC's to Pathfinder using the sheet and I was working with a Wizard here today and a couple of things cropped up. This is on .54 sheet BTW.
1) On the levels sheet, when the feat I chose was Spell Mastery, the Feature selection was yellowed in and had a drop down there, but wouldn't drop down. Was it supposed to do anything or was it dependent upon something else on another sheet?
2) On the SpellList sheet, I added the spells to the Spellbook first and then went to the prepared section and when I got there to adding them on the 1st level list it said I had 5/5 slots availalbe. So I started adding the prepared spells. When I added Cause Fear, it deducted two from the available total instead of just the one that I thought it should. I went from 1/5 slots available to -1/5 slots available.
Thanks and keep up the good work.
I've been converting some 3.5 NPC's to Pathfinder using the sheet and I was working with a Wizard here today and a couple of things cropped up. This is on .54 sheet BTW.
1) On the levels sheet, when the feat I chose was Spell Mastery, the Feature selection was yellowed in and had a drop down there, but wouldn't drop down. Was it supposed to do anything or was it dependent upon something else on another sheet?
2) On the SpellList sheet, I added the spells to the Spellbook first and then went to the prepared section and when I got there to adding them on the 1st level list it said I had 5/5 slots availalbe. So I started adding the prepared spells. When I added Cause Fear, it deducted two from the available total instead of just the one that I thought it should. I went from 1/5 slots available to -1/5 slots available.
Thanks and keep up the good work.
Sethvir,
Make sure the spell wasn't a spell from your opposition schools because those count as 2 slots each. If it wasn't from an opposition school then it's a bug.
Ahh. That may be it. I didn't pay that close attention to the school. I'll go back and look. Thanks.
The sheet is excellent! So many kudos first.
I found this sheet yesterday and I am already trying to add some custom pieces of information, I added a few Dieties, and then tried to add languages where I have now run into an issue. Hopefully this has not already been discussed, if it has I am sorry.
I first added the new languages to the Language Data sheet, and then new rows for the languages to the Language sheet, however I noticed that when I then added a language that was more than five characters long to the bonus languages field on the Racial Data sheet (for a human) that it seems to break the languages.
To recreate what I am seeing, start up a Human with some intellegance to get bonus languages. Then simply add the Darkland language of 'Aklo' to the bonus language field on the RacialData sheet, check the language sheet and you should see the bonus field not selectable. However, if you then try to also add 'Canto' on the RacialData sheet, all of the languages 'break'.
I tried to research if there is a character limitation or other restraint, but the cell should hold up to 32K of chars. My only other thought is if the SEACH function is limited in the size of the string that it can search through, but even then the string is not all that long.
#Abyssal
#Aquan
#Auran
#Celestial
#Draconic
#Dwarven
#Elven
#Giant
#Gnoll
#Gnome
#Goblin
#Halfling
#Ignan
#Infernal
#Orc
#Sylvan
#Terran
#Undercommon
#Hallit
#Kelish
#Polygot
#Osiriani
#Tien
#Skald
#Varisian
#Vudrani
#Ancient Osiriani
#Azlanti
#Jistka
#Tekritanin
#Thassilonian
#Aklo
#Canto#
I tried to research if there is a character limitation or other restraint, but the cell should hold up to 32K of chars. My only other thought is if the SEACH function is limited in the size of the string that it can search through, but even then the string is not all that long.
There is a character limitation for MATCH statments. (Something I forgot when I designed some of the section of the sheet). However, there is no character limitation for FIND. I have hunted some of the MATCH statements down, but it looks like I missed the Racial languages reference. I will replace this on the next revision, and this should resolve the problem.
To also help, I have now change the human defaults to all non-secret languages. This will make things a lot easier when I add in new languages to the sheet.
Thanks for mentioning this, and I hope this will fix the problem you noticed.
1) On the levels sheet, when the feat I chose was Spell Mastery, the Feature selection was yellowed in and had a drop down there, but wouldn't drop down. Was it supposed to do anything or was it dependent upon something else on another sheet?
The cell is supposed to be blank, but I had a note for myself there to have it indicate that the user was supposed to type in the desired spells in the blank space. I have now added that in. Thanks for reporting this.
2) On the SpellList sheet, I added the spells to the Spellbook first and then went to the prepared section and when I got there to adding them on the 1st level list it said I had 5/5 slots availalbe. So I started adding the prepared spells. When I added Cause Fear, it deducted two from the available total instead of just the one that I thought it should. I went from 1/5 slots available to -1/5 slots available.
As Eric mentioned, I suspect it was an opposed school spell you were adding. If it wasn't, please let me know.
Thanks for putting out this sheet.
The only mistake I saw so far is the unit price of shiruken. Its 1gp per 5, so the Unit Price is 0.2 not 1.
Edit: The price of rations, trail (per day) is 0.5 not 0.05.
My 2 cents: have page 2 sectioned off between Racial Abilities, Class Abilities, Feats, Traits, and Notes.
Keep up the great work.
Thanks for reporting these, I have fixed the prices now.
Unfortunately, due to some Excel limitations, I can't really section off the Page 2 headings, any more than what I have. (I could do it, but then I would have to allow ample space for a large amount of text in each of these areas, which would then add another sheet or 2 to the character sheet.
On a side note though, I am still having issues with Excel in how it chooses to break text (and some times it chooses not to). I am going to change Page 2 to 2 columns instead of 3 columns which should help... but I'm not certain if its ever going to be perfect.
Has the Diabolist been added yet?
I have laid out the rough frame-work for it, but its still going to be awhile. So many things to do, and so little time... *sighs*
The latest release is now available at www.d20.ca
Alpha version 0.55
Many little fixes all over. (All previously reported problems should have been fixed now.)
I have done several more changes to how the ARMS sheet works, so some errors might pop up... please let me know if they do. I have now "mostly" completed the Summary (Stat Block) sheet. (I have not yet made the "natural attacks" options functional. I am still pondering on the best way to do this. Right now this would only really apply to some of the class abilities that let you have claw or bite attacks).
I wanted to get this update out as soon as possible because of the many little fixes I have done. I am still in the middle of revamping how the sheet checks for class skills, so currently there could be some problems there.
RE: Alpha version 0.55
It appears that weapons are not showing up on the Summary sheet. I'll have a revision out later today.