I was tinkering with an Alchemist today, and I noticed that the Feral Mutagen Bite and Claw appear to get non-proficiency penalties when selected.
Erian - firstly, this thing works quite well in Excel 2007. But then I think you probably knew that.
One problem I am having is with Open Office compatibility. Generally speaking, the sheet loads slowly and various fields don't work (lots of Error 502). Do you have a stable Open Office version?
Edit - on account of I'm stupid...
I just DL'd the latest version and it is smooth sailing so far.
Alrighty, I've got the next release ready:
Character Sheet File: PRPG_CS_v_0_8_11.zip
I've added non-slotted magic item sections on the Back pages, and have entered data for those down to the crystal balls. This one also fixes various internal items, including:
- Alchemist Feral Mutagen natural attacks
- Thunder and Fang, Aldori Dueling Mastery, and Cornugon Shield feats
- Misc 2 and Misc 3 AC entries
- Acrobatic and Weapon Finesse feats for animal companions
|
I moved my necromancer to this new sheet. Under my weapons, I am having my ranged weapon and melee weapon (Longbow and Rapier, elf character) all -1 lower than they should be. The character has a ranged bonus of +2 and melee bonus of -1. The longbow is coming out +1 and rapier at -2. Not sure where the phantom -1 is coming from. any ideas?
Thanks for the kinds words! I'm glad to (hopefully) be back in a more regular pace for updates now...
As for the phantom attack penalty, check to see if you have a klar in the Shield block (I left it in by mistake). Removing that took away the penalty for me. Now, I need to find out why it put that penalty in when I set the Shield Readied selector (which is now in the AC section, by the way) to "No"...
EDIT: Found it...needed to put a Shield_Readied check in the ArmorShield_Attack_Penalty calculation. Anybody interested in fixing this before my next release, change the following in the ArmorShield_Attack_Penalty_L and ArmorShield_Attack_Penalty_P formulas:
+IF(Shield_Readied_X="Yes",IF(OR(AND(Shield_X<>"None",OR(ISNUMBER(FIN D("Shield Proficiency",Feats_Known)),Shield_Prof)),AND(Shield_X="Tower Shield",OR(ISNUMBER(FIND("Tower Shield Proficiency",Feats_Known)),Shield_Prof_Tower))),0,Shield_Penalty_X),0)
Where "X" is either "L" or "P" depending on which sheet you are changing...
Oh, and make sure if you copy this from the forum that their are no spaces in the formula.
There's something hinky going on with the ACP. I haven't done a full investigation or looked at the code but it seems if I set P-Back to Stone Plate the ACP shows up on L-Front as well as P-Front. However if I set L-Front to Stone Plate the ACP shows up at the top of the skill list but isn't applied to the pertinent skills. Can clarify further if necessary.
Zo
EDIT: It also seems that the Dex bonus to AC isn't implemented on the L-Front sheet unless armor is added.
|
|
Thanks for the kinds words! I'm glad to (hopefully) be back in a more regular pace for updates now...
As for the phantom attack penalty, check to see if you have a klar in the Shield block (I left it in by mistake). Removing that took away the penalty for me. Now, I need to find out why it put that penalty in when I set the Shield Readied selector (which is now in the AC section, by the way) to "No"...
EDIT: Found it...needed to put a Shield_Readied check in the ArmorShield_Attack_Penalty calculation. Anybody interested in fixing this before my next release, change the following in the ArmorShield_Attack_Penalty_L and ArmorShield_Attack_Penalty_P formulas:
+IF(Shield_Readied_X="Yes",IF(OR(AND(Shield_X<>"None",OR(ISNUMBER(FIN D("Shield Proficiency",Feats_Known)),Shield_Prof)),AND(Shield_X="Tower Shield",OR(ISNUMBER(FIND("Tower Shield Proficiency",Feats_Known)),Shield_Prof_Tower))),0,Shield_Penalty_X),0)
Where "X" is either "L" or "P" depending on which sheet you are changing...
Oh, and make sure if you copy this from the forum that their are no spaces in the formula.
Allow me he chance to tell you that I appreciate all of your hard work! Keep it up! Smurf! (Sorry I had to experiment the smurf post rumor in honor of my 250th post)
Edit: It's True!
There's something hinky going on with the ACP. I haven't done a full investigation or looked at the code but it seems if I set P-Back to Stone Plate the ACP shows up on L-Front as well as P-Front. However if I set L-Front to Stone Plate the ACP shows up at the top of the skill list but isn't applied to the pertinent skills. Can clarify further if necessary.
Zo
EDIT: It also seems that the Dex bonus to AC isn't implemented on the L-Front sheet unless armor is added.
Hmm, do you have the Selector_Active_Sheet (which defaults to Landscape) set to the appropriate sheet? The ACP is now one of the universal calcus. With this selector set, I didn't see any problems right off with ACP or the Dex mod to AC. If it is set properly and you still have problems, we can dig a little further. I did notice that on the P-Front sheet there are values in the Perm Mod for abilities that should be cleared...
Allow me he chance to tell you that I appreciate all of your hard work! Keep it up! Smurf! (Sorry I had to experiment the smurf post rumor in honor of my 250th post)
Edit: It's True!
Thanks. And I'm a fan of smurfing on your smurf-hundred and smurfth post!
|
|
Thanks for the kinds words! I'm glad to (hopefully) be back in a more regular pace for updates now...
As for the phantom attack penalty, check to see if you have a klar in the Shield block (I left it in by mistake). Removing that took away the penalty for me. Now, I need to find out why it put that penalty in when I set the Shield Readied selector (which is now in the AC section, by the way) to "No"...
EDIT: Found it...needed to put a Shield_Readied check in the ArmorShield_Attack_Penalty calculation. Anybody interested in fixing this before my next release, change the following in the ArmorShield_Attack_Penalty_L and ArmorShield_Attack_Penalty_P formulas:
+IF(Shield_Readied_X="Yes",IF(OR(AND(Shield_X<>"None",OR(ISNUMBER(FIN D("Shield Proficiency",Feats_Known)),Shield_Prof)),AND(Shield_X="Tower Shield",OR(ISNUMBER(FIND("Tower Shield Proficiency",Feats_Known)),Shield_Prof_Tower))),0,Shield_Penalty_X),0)
Where "X" is either "L" or "P" depending on which sheet you are changing...
Oh, and make sure if you copy this from the forum that their are no spaces in the formula.
I manually did this one both L and P. The L one did indeed have the Klar(Which I didn't see since I am stuck in my ways and only use Portrait lol). The formula for P was using the _L formula, hence being effected by the shield in L. I changed all the Ls to Ps and everything works now! thanks!
Hmm, do you have the Selector_Active_Sheet (which defaults to Landscape) set to the appropriate sheet?
I apparently did not. Force of habit, setting it to Portrait I guess. Sorry for the false alarm.
Zo
I'm in the process of upgrading my computers to Office 2010 and 2003 is throwing a "too many cell formats" error. In a week or so I won't be b!#%%ing about the 2003 issues anymore ;)
Zo
Just pulled down 8.11, and after re-creating three characters, I've noticed two items:
1) You have the Heavy Flail crit threat range at 18-20, it should be 19-20, but that's no big deal there of course, easily fixed; and
2) Headband of Vast Intellect is setting up for the granted skills, as it should, But... it also looks like it's adding the Int bonus it gives to base skill points, which it's not supposed to. Now, that's easily worked through by simply not adding the extra skills, but it's just something that maybe can be corrected to show 100% accuracy.
Again, erian, thanks ever so much for putting this sheet together.
As for the sling, I'm not sure what you mean? Medium slings deal 1d4 damage. This is with a bullet. Using a rock would actually deal 1d3 damage and suffer a -1 attack penalty. I'm not aware of any bullet that...
You are correct of course. Yet I remember re-reading that entry several times... I must have had my eyes crossed :(
Thanks!
Many thanks again for all of your hard work.
I was wondering if it were possible to have a PRPG stat block page? It woudld make things cool for us GMs.
I was wondering if it were possible to have a PRPG stat block page? It woudld make things cool for us GMs.
+1
|
It looks like the additions you made on _11 finally threw you over the cell format limit for Excel 2003. I remember heroforge running into this back when I was working on it. I also remember it being more work than it's worth to try to eliminate the formats. So I would just suggest that you leave _10 available for those who don't have a modern version of excel.
It looks like the additions you made on _11 finally threw you over the cell format limit for Excel 2003. I remember heroforge running into this back when I was working on it. I also remember it being more work than it's worth to try to eliminate the formats. So I would just suggest that you leave _10 available for those who don't have a modern version of excel.
Meh, it happens from time to time--I rebuild a few sheets and Excel plays nice again...
Also, I noticed with this post that my last response here didn't "take" apparently! In summary, I noted that I've corrected all problems reported to date (except the character limit and Intelligence enhancement bonus), and am working to incorporate the various current errata. I also rebuilt more items on the Front pages to ensure changes aren't only made on the L vs. P formats.
I'll be posting after I get the rest of the errata in place...
I was wondering if it were possible to have a PRPG stat block page? It woudld make things cool for us GMs.
+2, having recently worked on an adventure with a full party of high-level NPCs facing the PCs!
I was wondering if it were possible to have a PRPG stat block page? It woudld make things cool for us GMs.+2, having recently worked on an adventure with a full party of high-level NPCs facing the PCs!
Oh yes, I forgot to mention that (another item eaten in my lost post...)
I am indeed working on a statblock page. The centralization I've done to make the L and P sheets stay in synch helped out a lot toward making this an easy option
I was wondering if it were possible to have a PRPG stat block page? It woudld make things cool for us GMs.+2, having recently worked on an adventure with a full party of high-level NPCs facing the PCs!Oh yes, I forgot to mention that (another item eaten in my lost post...)
I am indeed working on a statblock page. The centralization I've done to make the L and P sheets stay in synch helped out a lot toward making this an easy option
Cool... thanks mate
Okay, bug fixes, stat block view, and style clean-up...
Character Sheet File: PRPG_CS_v_0_8_12.zip
Shooting to get all the OGC from my latest PDFs in place before the APG...
|
|
wooo! new version! found a problem though. setting the sheet to portrait, messes up blocks on both portrait and landscape. the stat bonuses get an error in the SPEED, HP, AC, MELEE, and RANGED sections of the sheet. the spots where a physical stat is supposed to be calculated, gets a "#REF" type error. i've got no skill with excel, so i don't know how to fix it or what the problem is. i'd guess that both pages are using the landscape formula to work from.
Hey Erin. How's your little-spawnling doing? ^_~
Does she still need that gold-based lotion on her tummy?
Hope everything is good.
One question about the generator.
Is it capable now of creating a stat block?
If not, will it be soon?
wooo! new version! found a problem though. setting the sheet to portrait, messes up blocks on both portrait and landscape. the stat bonuses get an error in the SPEED, HP, AC, MELEE, and RANGED sections of the sheet. the spots where a physical stat is supposed to be calculated, gets a "#REF" type error. i've got no skill with excel, so i don't know how to fix it or what the problem is. i'd guess that both pages are using the landscape formula to work from.
Ah, I needed to finish up transferring some sheet-only named cells to be global. Fixed it!
Is there any way to moves character data from one version to another?
Unfortunately, no. I haven't figured out any good way to do this an not use macros...
Hey Erin. How's your little-spawnling doing? ^_~
Does she still need that gold-based lotion on her tummy?
Hope everything is good.
One question about the generator.
Is it capable now of creating a stat block?
If not, will it be soon?
What Shar Tahl said! Note that it's still under development; specifically I'm working on the Offense section to better automate weapons.
Ah, cool. There's a stat block tab now. Awesome. Um, what about adding Templates (aka like Celestial, Fiendish, or Vampire)?
Ah, cool. There's a stat block tab now. Awesome. Um, what about adding Templates (aka like Celestial, Fiendish, or Vampire)?
With the APG coming out, it looks like there will be racial variants that I'll need to add. I'm planning on covering templates at the same time.
Am I just missing it, or has "The Great City" campain not been added to this sheet? It's been driveing me nuts trying to do a half giant on here.
Was the Diabolist imp companion not implemented yet?
Not yet. I shifted away from completing the companions mechanics since I'll likely have to change things again when the APG comes out. I'll be handling the diabolist's imp in that same pass.
Am I just missing it, or has "The Great City" campain not been added to this sheet? It's been driveing me nuts trying to do a half giant on here.
I don't own any of the 0one PRPG products as yet, although they are on my Wishlist. Once I'm able to buy the products (or someone is nice enough to buy me a copy...) I'll be adding that material. I am, of course, assuming there is a half-giant in these somewhere. If I've got the wrong product, let me know more about what you mean!
Am I just missing it, or has "The Great City" campain not been added to this sheet? It's been driveing me nuts trying to do a half giant on here.I don't own any of the 0one PRPG products as yet, although they are on my Wishlist. Once I'm able to buy the products (or someone is nice enough to buy me a copy...) I'll be adding that material. I am, of course, assuming there is a half-giant in these somewhere. If I've got the wrong product, let me know more about what you mean!
It is one of the Campain settings. They have 3 new racesin there. One of which is the Half Giant race. I think I have figured out how to make it work.
Is there an easy way to remove a magic item after it has been added to the sheet? It feels like you need a blank or "none" option for your magic item dropdowns.
Also - you seem to have the headbands in the head slot dropdown instead of the headband slot.
Great work though - I've convinced all players in both of my ongoing games to try this sheet. We're all converts.
It is one of the Campain settings. They have 3 new racesin there. One of which is the Half Giant race. I think I have figured out how to make it work.
Good deal. If you have any other questions, let me know.
Is there an easy way to remove a magic item after it has been added to the sheet? It feels like you need a blank or "none" option for your magic item dropdowns.
Also - you seem to have the headbands in the head slot dropdown instead of the headband slot.
Great work though - I've convinced all players in both of my ongoing games to try this sheet. We're all converts.
Thanks, glad you like it!
For clearing the sheet, that sort of functionality requires the use of macros, and one of my design goals is to not use these because it breaks cross-platform compatibility. Manual deletion is the only option at this time.
And thanks for the heads-up on the headbands...fixed it!
For clearing the sheet, that sort of functionality requires the use of macros, and one of my design goals is to not use these because it breaks cross-platform compatibility. Manual deletion is the only option at this time.
I'm not sure you understand what I was trying to get at. I'll try to explain better:
When selecting a weapon (for example), the dropdown has an option which is blank. If I lose that weapon or sell it, I can just select that "empty" option from the dropdown and it goes away.
Once I've selected a cloak of resistance +1, on the other hand, there is no way (that I can figure out) to have my character not wear some cloak. If I try to manually delete it, it gives me an error that my selection is not valid. Since there is no "empty" option, I can't get rid of it - only replace it with some other cloak.
Does that make more sense?
I'm not sure you understand what I was trying to get at. I'll try to explain better:
When selecting a weapon (for example), the dropdown has an option which is blank. If I lose that weapon or sell it, I can just select that "empty" option from the dropdown and it goes away.
Once I've selected a cloak of resistance +1, on the other hand, there is no way (that I can figure out) to have my character not wear some cloak. If I try to manually delete it, it gives me an error that my selection is not valid. Since there is no "empty" option, I can't get rid of it - only replace it with some other cloak.
Does that make more sense?
Ah, I see. When I delete the entries they work fine. What app are you using? I may need to put some logic in to make it play nice with other apps.
Ah, I see. When I delete the entries they work fine. What app are you using? I may need to put some logic in to make it play nice with other apps.
Excel 2007
The error I get when I try to manually delete one of the magic item entries is:
"The value you have entered is not valid.
A user has restricted values that can be entered into this cell."
Excel 2007
The error I get when I try to manually delete one of the magic item entries is:
"The value you have entered is not valid.
A user has restricted values that can be entered into this cell."
Hmm, it looks like the cells are protected--I had been testing with the sheet unlocked and so didn't catch the issue. I have now marked the cells as unprotected and things look like they're working well.
And as a note, I just got my "your APG will be shipping shortly" message, so should have the PDF in hand soon!
|
|
i noticed something the other day with version 8.11. the mithral quality doesn't seem to work properly when applied to armor. i've got a dwarven 2 barbarian/ 3 fighter, and while planning for future lvls, i started messing around with gear on the sheet. when i throw on mithral full plate, my speed drops to 20ft and it should be 30ft. 20ft for dwarf, 30ft when he's a barbarian wearing medium armor. mithral makes doesn't change the proficiency category, but it does change the weight category for speed dropping it from heavy to medium. so, a dwarf barbarian/fighter should be moving at 30ft in mithral full plate.
i bring this up because i can't test how this works on 8.12 portrait with the cells you said you need to transfer over to global cells. landscape on 8.12 works fine. i know you've got a lot of work with the sheet already, but i just wanted to point it out.
Found a glitch in 0_8_12.
If I select any kind of shield on the Landscape Front area, and set the "Shield_Readied_L" cell (cell J11 on Landscape Front), it returns a #REF error.
Tracing it back to Shield_AC, that cell is pulling an #REF error, and I don't know quite what you're doing well enough to figure out what to fix.
Found another glitch.
When you select Weapon Focus [Shortbow] or Weapon Focus [Longbow], the Landscape page is not adding the +1 to the damage done. Same problem occurs with Weapon Specialization, Greater Weapon Focus and Greater Weapon Specialization.
Typo: Ring of Frie Resistance, Greater needs to be Ring of Fire Resistance, Greater.
Unless it's a dietary aid, in which case "Frie" should be "Fries".