I'm shooting for a release tomorrow. I'm trying to figure out if Wayfinder 1 material is OGC. If so, I'll include it in a future release as well. They have the OGL in the document, but there is no actual designation of any open content as required by the license...
Well, as I understand it the whole intent of that publication was for the community to add to the Pathfinder knowledge base. I'd be stunned if anyone gave you any guff for including the Wayfinder stuff.
|
Thanks! I'm getting geared back up now, so hopefully I can address any concerns quickly. For the ranger, my guess is you didn't have a favored terrain selected. I've put some logic in place that points this out rather than just erroring out.
I did have favored terrain on the first one that errored out at 3rd level but did not have favored terrain for the others I tried to start.
Thanks for addressing these issues.
Another issue is for a Half-Elf I added the extra HP and SP on the character ability sheet and it also lit up red - although it does add things correctly on the sheet. Just saying...
Another issue is for a Half-Elf I added the extra HP and SP on the character ability sheet and it also lit up red - although it does add things correctly on the sheet. Just saying...
Are the added HP and SP gained from classes as selected as Favored Classes? The Half-elf get two favored classes. If, however, you advance in one (or more) classes not of the half-elf's favored class, then you won't get the bonus.
Of course, you still have to actually select the favored class(es) so that she sheet knows what classes are bonusable.
I'm shooting for a release tomorrow. I'm trying to figure out if Wayfinder 1 material is OGC. If so, I'll include it in a future release as well. They have the OGL in the document, but there is no actual designation of any open content as required by the license...Well, as I understand it the whole intent of that publication was for the community to add to the Pathfinder knowledge base. I'd be stunned if anyone gave you any guff for including the Wayfinder stuff.
Yes, that's my thinking as well, but by the strict letter of the OGL since they don't have a declaration of what content is open I'm a bit leery. Once I get a positive, written confirmation we should be good to go.
Another issue is for a Half-Elf I added the extra HP and SP on the character ability sheet and it also lit up red - although it does add things correctly on the sheet. Just saying...Are the added HP and SP gained from classes as selected as Favored Classes? The Half-elf get two favored classes. If, however, you advance in one (or more) classes not of the half-elf's favored class, then you won't get the bonus.
Of course, you still have to actually select the favored class(es) so that she sheet knows what classes are bonusable.
Yes, I just tested this (with a half-elf bard 5/fighter 5) and it seemed to be working fine. Can you confirm that you selected both of the favored classes in the drop-down boxes? Once that's done, the cell calculates the total of those two class levels and as long as your bonus HP and SP don't exceed this total it should stay green. Do let me know if that's not the case, however.
Hmm, okay let me walk through the steps I'm doing and see if there's a disconnect somewhere:Yes, I selected a Ranger/Sorcerer and only took levels in those classes.
- On the Character Options tab, set Race to Half-Elf
- Favored Class (in the grey box) auto-sets to "Any Two"
- Enter Ranger in Favored Class 1
- Enter Sorcerer in Favored Class 2
- Select either Ranger or Sorcerer in the Class for each level (I entered 10 levels for Rgr and 10 levels for Sor)
- Enter values in HP and SP under Favored Class that do not exceed total class levels in Rgr and Sor (in my run, I can enter any combination totaling 20 or less).
- On the Front tab, HP and SP totals are increased by the amounts put in their respective Favored Class cells
Sorry I was not clear enough on this. I know about the notes and the pull down for choices (5 or 6 for prestige classes). The problem is that I am using a custom prestige class that has a non-standard BAB progression. So what I am trying to change is the BAB table itself (e.g. what ever gets used when "5" or "6" is selected). This was easy to do in the older versions of the sheet, but I have not figured out how you are doing this calculation in the latest versions.
Same thing for the saving throws - although here my GM is using one of the base class saving throw tables instead. So I don't have to replace the calculation, just allow a prestige class to select the proper base class saving throw progression option instead.
Ah, I see, you want to go to Table_Level_Dependent on the DataClasses tab. You can alter the BAB, Saving Throw, and Prestige Saves columns to get the desired effect. This is one of the areas where I want to move to using a MATCH function in my lookup tables, as you can then just select Low/Medium/High and the lookup will know what to do. Won't have that one in for tonight, however...
Hi all, PRPG_CS_v_0_7_9.zip is now available! This version fixes all items noted to date, incorporates suggested enhancements such as the wealth by level multiplier, adds feats/traits/equipment from various Golarion supplements, and automates most General traits (haven't hit the Campaign, Race Region, or Religion traits as yet). I haven't had a chance to get back to the animal companion sheet, so no changes there for this release.
Hi all, PRPG_CS_v_0_7_9.zip is now available! This version fixes all items noted to date, incorporates suggested enhancements such as the wealth by level multiplier, adds feats/traits/equipment from various Golarion supplements, and automates most General traits (haven't hit the Campaign, Race Region, or Religion traits as yet). I haven't had a chance to get back to the animal companion sheet, so no changes there for this release.
Awesome as always man. Thanks to you, and also to the team of testers that has assembled over time in this thread!
Is there a brief outline of how to go about adding custom feats?
Great work thus far!
What are you planing to implement next? What will it looks like when its "finished".
Thanks! For this release, my goal is to get all the existing content automated (i.e. all of the non-core feats, traits, etc. that are already in the sheet). I'd also like to have the animal companion/familiar tab in a good working state. Once that's all done, I'll release v.0.8 as the new "baseline."
For changes after that, I'm thinking that getting magic effects functional--things like bless and such (a preview is in this release with reduce person and enlarge person). I'd also like to get magic item automation going, so things like belts/headbands/bracers/cloaks are more easily added to characters and the results automatically flow through. And of course I'll be adding additional OGC content as it comes out.
For a "finished" version, that means to me something that I'd proudly call v.1.0. My goal for that release is to, obviously, have all known bugs fixed, have all feats/traits/class abilities/effects automated, and have the important sub-systems for classes (animal companions/familiars/summoned creatures/polymorph) in a usable state. Of course, the sheet has slowly morphed over time thanks to folks on this thread giving some great suggestions, so this is subject to change if better ideas come along!
Awesome as always man. Thanks to you, and also to the team of testers that has assembled over time in this thread!
Thanks! I must say this thread was the best idea I ever had for the spreadsheet!
Is there a brief outline of how to go about adding custom feats?
There are basically three fields you have to fill out for custom feats (the rest are there for consistency and reference--may be used in the future). Obviously you need the Name. Then there is the Qualified field. You can either put in an actual Excel formula to calculate if the character is able to take the feat, or just hard-code TRUE. Finally, the Summary field is where you put the text that will display on the Abilities and Feats tab. As with the Qualified field, you can either put in a formula, or just hard-code the text you want to display.
First - thank you very much for producing this. I'm a fan of The Only Sheet, but the fact that this runs under Mac Excel (and OpenOffice) means yours will definitely displace it for my Pathfinder needs.
Second - congrats on the baby. Hope you are getting some sleep.
Third - and I apologize if this is elsewhere in the forums but a brief search didn't reveal it: just curious what your plan/timeline was for incorporating the other APG classes (in particular, the Inquisitor, as I am putting one together for a new campaign)?
Again - thanks for sharing this, very excited to not have to run virtualized windows just to get a character sheet. :) I know how much work goes into something like this. FWIW, if you have any place to donate to help fund continued development, I'd be happy to contribute.
|
|
Hmm, okay let me walk through the steps I'm doing and see if there's a disconnect somewhere:Yes, I selected a Ranger/Sorcerer and only took levels in those classes.
Is this the process you are using? If so, it could be that I fixed something in this version and didn't know it...
- On the Character Options tab, set Race to Half-Elf
- Favored Class (in the grey box) auto-sets to "Any Two"
- Enter Ranger in Favored Class 1
- Enter Sorcerer in Favored Class 2
- Select either Ranger or Sorcerer in the Class for each level (I entered 10 levels for Rgr and 10 levels for Sor)
- Enter values in HP and SP under Favored Class that do not exceed total class levels in Rgr and Sor (in my run, I can enter any combination totaling 20 or less).
- On the Front tab, HP and SP totals are increased by the amounts put in their respective Favored Class cells
I think what I did was select both HP and SP and it is only supposed to be one of them. Sorry....
A couple things that I've noticed:
When selecting the Noble class, it gives me the information for the Aristocrat class.
Fix:
DataClasses: within cell R44 should say B44 (instead of B45), likewise cell R45 should say B45 (instead of B46). Also, the entire line 45 lists the name file of lvl_ari instead of lvl_nob.
I figure that the Noble class isn't fully automated. It's missing the Noble Archetype options. When making those options go live, don't forget that a couple of them are minor spellcasters and should be set up accordingly.
Just curious, will there be an option to adjust font size for the Abilities section on the Feats & Abilities page? When you get into multiple classes at higher level, the "cup" runneth over. :)
Thanks!
Jay
Third - and I apologize if this is elsewhere in the forums but a brief search didn't reveal it: just curious what your plan/timeline was for incorporating the other APG classes (in particular, the Inquisitor, as I am putting one together for a new campaign)?
i'm sure he'll pop in and answer, but I know there was some time period that Paizo asked people to wait before incorporating the APG stuff. That's why the first couple released are in there and the others aren't yet.
First - thank you very much for producing this. I'm a fan of The Only Sheet, but the fact that this runs under Mac Excel (and OpenOffice) means yours will definitely displace it for my Pathfinder needs.
Thanks! That's quite an accomplish, considering TOS is a paid product. I do think the platform compatibility of this sheet is one of its greatest assets. Plus keeping it macro/VBA code free helps keep the file size way down.
And FYI for folks using Excel 2007 or later--you can save this as a XLSX or XLSB file and get the uncompressed size down to nearly the same as the ZIP file. I don't distribute in these formats as it breaks some of the compaitiblity, but the file will work just fine for folks using newer Excel versions.
Second - congrats on the baby. Hope you are getting some sleep.
Thanks! Not as much sleep as I'd like right now, but we're getting all the kinks worked out over time. Our last child had some pretty severe acid reflux and cholic, so we kind of expected some drama early on...
Third - and I apologize if this is elsewhere in the forums but a brief search didn't reveal it: just curious what your plan/timeline was for incorporating the other APG classes (in particular, the Inquisitor, as I am putting one together for a new campaign)?
i'm sure he'll pop in and answer, but I know there was some time period that Paizo asked people to wait before incorporating the APG stuff. That's why the first couple released are in there and the others aren't yet.
I did indeed have some restrictions on when to release those based on Paizo requests. Those times are past, now, so unfortunately the delay is simply on me now...
I am aiming to have th other Beta classes in the version before it goes "final" as well as having the bugs knocked out of the two already in place.
Again - thanks for sharing this, very excited to not have to run virtualized windows just to get a character sheet. :) I know how much work goes into something like this. FWIW, if you have any place to donate to help fund continued development, I'd be happy to contribute.
Thanks for the thought! I aim to keep this sheet free, both to comply with the Paizo Community Use Policy and in order to keep distribution as broad as possible. What I will take are any volunteers looking to do some formula coding...
;^)
I think what I did was select both HP and SP and it is only supposed to be one of them. Sorry....
No problem. I was hoping that was the case, actually, rather than having a bug somewhere I couldn't find!
A couple things that I've noticed:
When selecting the Noble class, it gives me the information for the Aristocrat class.
Fix:
DataClasses: within cell R44 should say B44 (instead of B45), likewise cell R45 should say B45 (instead of B46). Also, the entire line 45 lists the name file of lvl_ari instead of lvl_nob.I figure that the Noble class isn't fully automated. It's missing the Noble Archetype options. When making those options go live, don't forget that a couple of them are minor spellcasters and should be set up accordingly.
Just curious, will there be an option to adjust font size for the Abilities section on the Feats & Abilities page? When you get into multiple classes at higher level, the "cup" runneth over. :)
Thanks!
Jay
Ah, I should have covered LSJ support in my statement for what I'm looking for in v.0.8 as well...
I'd like to get all of the LSJ classes in place and working if possible. I'll look into the issues you note above, and also aim to get some of the other classes in over the next week.
For the font adjustments, you should be able to do that already by selecting the cell and changing the font size. Is that not working?
erian_7? Could you possibly add an option to allow selection (and weapon usage) of feats from the Beta (specifically Overhand Chop, Backswing, and Devastating Blow)? Also, when one applies the "Deadly Aim" feat to a composite longbow (+3 Str bonus) the feat doesn't seem to take effect. Thanks for all the hard work. ^_^
Ah, I should have covered LSJ support in my statement for what I'm looking for in v.0.8 as well...
I'd like to get all of the LSJ classes in place and working if possible. I'll look into the issues you note above, and also aim to get some of the other classes in over the next week.
That would be a godsend. I play a Cleric of Sorena/Human Paragon and there's just no way to get it to work at the moment.
will you be adding deity adjustments for cleric at some point? Things like, as a cleric of Sorena I gain heavy armor and all shields proficiencies, 4 cast level adjustment for channel vs. undead and the sunbeam spell 1/day per 4 cleric levels.
Also, I have some campaign certs for bonus HP and a bonus feat but I cannot figure a way to add it and use the existing automation.
If there's something I can do to help with all of this I'd be happy to help.
--Mav
Hit points can be adjusted on the Front Page tab in the little green box that says "HP Mods". Bonus feats, I imagine, would be something that's down the road a little bit. Let's get all the material that's currently in the Campaign Guide in the sheet and then we can deal with extra stuff. :) Thanks.
|
first off I would like say great work on this sheet. I've seen and have used it since it was started and it has become a staple of my games.
In the last several versions the skill section has had many little problems. Class skills not being recongnized being the main culprit.
The last version now marks the correct class skills for the Oracle but doesn't impliment the +3 when putting a rank in some of them corresponding to thier focus.
I love the progress that has been made and give high praise to this awesome sheet.
This, too, has replaced The Only Sheet for my needs. Great job!
Bug: The "Halfling Sling Staff" does not show up as proficient when the character is a halfling. When I select the class as "Fighter" my character has a +6 to his attack. When I select the class as "Bard" my character gets +1.
Does anyone know if "sling" proficiency means "sling staff" proficiency?? Otherwise, my reported bug isn't a bug :(
Thanks to all for the praise and encouragement! Our daughter ended up hitting some rough spots, so sleep has been a precious commodity in the last week or so. We've got most of it ironed out now (plus I'm caught up on my backlog at work as of today), so I'm looking forward to having much more time for hammering out this next major release.
erian_7? Could you possibly add an option to allow selection (and weapon usage) of feats from the Beta (specifically Overhand Chop, Backswing, and Devastating Blow)? Also, when one applies the "Deadly Aim" feat to a composite longbow (+3 Str bonus) the feat doesn't seem to take effect. Thanks for all the hard work. ^_^
Hmm, I looked into that issue with Deadly Aim--should work the same across all longbows. Can you walk me through the steps you took, as my tests show it working fine?
As for feats from the Beta, they are indeed OGC and so could be added. I'm thinking I'd put them in a ****Pathfinder Beta**** heading in the feat list?
I've used my sorcerer in the new release(PRPG_CS_v_0_7_9.xls) and perception and survival are treated like class skill (they have the check and the +3 bonus if I put a rank on them)
thank you for all yuor work
Good deal...do let me know if you find any other issues, of course!
Hit points can be adjusted on the Front Page tab in the little green box that says "HP Mods". Bonus feats, I imagine, would be something that's down the road a little bit. Let's get all the material that's currently in the Campaign Guide in the sheet and then we can deal with extra stuff. :) Thanks.Ah, I should have covered LSJ support in my statement for what I'm looking for in v.0.8 as well...
I'd like to get all of the LSJ classes in place and working if possible. I'll look into the issues you note above, and also aim to get some of the other classes in over the next week.
That would be a godsend. I play a Cleric of Sorena/Human Paragon and there's just no way to get it to work at the moment.
will you be adding deity adjustments for cleric at some point? Things like, as a cleric of Sorena I gain heavy armor and all shields proficiencies, 4 cast level adjustment for channel vs. undead and the sunbeam spell 1/day per 4 cleric levels.
Also, I have some campaign certs for bonus HP and a bonus feat but I cannot figure a way to add it and use the existing automation.
If there's something I can do to help with all of this I'd be happy to help.
--Mav
Good advice on priorities--my first work in LSJ revealed there's a LOT in that campaign to tweak. It's actually put me off starting it thus far, but I do want to finish it up in this next major release. As for bonus feats, those were part of my sheet really early on and got dropped unintentionally. I am thinking on the best way to add them back in...
first off I would like say great work on this sheet. I've seen and have used it since it was started and it has become a staple of my games.
In the last several versions the skill section has had many little problems. Class skills not being recongnized being the main culprit.
The last version now marks the correct class skills for the Oracle but doesn't impliment the +3 when putting a rank in some of them corresponding to thier focus.
I love the progress that has been made and give high praise to this awesome sheet.
Yes, I had a major shift in how I tracked class skills (moved the entire data set from DataSkills to DataClasses) and so am continuing to iron out issues from that move. My spot tests for the Oracle focus skills didn't turn up anything--can you point me to some specific issues? The logic I use there is a general text comparison, and I did find an issue with the Flame focus and Perform skills...
This, too, has replaced The Only Sheet for my needs. Great job!
Bug: The "Halfling Sling Staff" does not show up as proficient when the character is a halfling. When I select the class as "Fighter" my character has a +6 to his attack. When I select the class as "Bard" my character gets +1.
Does anyone know if "sling" proficiency means "sling staff" proficiency?? Otherwise, my reported bug isn't a bug :(
Now you guys are going to make my head explode with pride!
For the sling staff, I do not interpret sling proficiency as applying. As such, a halfling will treat the weapon as Martial and so must still have Martial Weapon Proficiency for full use.
Couple more bugs:
- Using a shortbow, with an 8 Strength, does not give you a -1 to damage (Mine still shows 1d4), the rapier does show 1d4 -1 though, so I assume its a ranged weapon issue
- An encumbered halfling does not lower max dex bonus by 1 (my 18 Dex still adds +4 to my AC)
Couple more bugs:
- Using a shortbow, with an 8 Strength, does not give you a -1 to damage (Mine still shows 1d4), the rapier does show 1d4 -1 though, so I assume its a ranged weapon issue
- An encumbered halfling does not lower max dex bonus by 1 (my 18 Dex still adds +4 to my AC)
Good catch on the Str penalty to damage for bows--it doesn't apply to all ranged weapons, just those that are thrown (or treated as thrown, as with the sling and sling staff) and specifically to bows. Fixed that one...
I tested out the encumbrance hit and that seems to be working--can you recheck that one for me? I tested with both a human and a halfling couldn't find any problems.
Hi there, I've been out for the few last months and I've missed some versions of the sheet.
I was updating my Dwarf Fighter to your new 0.7.9 version and found out that some of the Fighter Class Ability Bonus are not automatcally being applied.
I'm using a Dwarven Waraxe and have the Weapon Training "Axes" but no bonus applies, as well as for the Armor Training Bonus.
Sice I've been out for a while, I dont really know if this is a "bug" or you're still working on it. Anyways, I've decided to bring it up.
tnx!!!
First - thank you very much for producing this. I'm a fan of The Only Sheet, but the fact that this runs under Mac Excel (and OpenOffice) means yours will definitely displace it for my Pathfinder needs.
The Only Sheet+ does not function on Excel Mac because Microsoft did not add VBA support for Mac Excel (It turns out they actually removed it!)
TOS+ being extremely powerful, it requires VBA for the most advanced features it posesses: The automation of the Stacking Rules (knowing how to add bonuses from various sources together) and the integration of dynamic effects (the ability to apply spells/feats/effects/etc in real-time on your character)
The good news is, I heard that Microsoft will re-instate VBA in the next release of Mac Excel/Office! That will most likely open the door for TOS+ to run on the Mac!
I tried TOS+ on OpenOffice, but it was simply unable to handle it...
Thanks! That's quite an accomplish, considering TOS is a paid product. I do think the platform compatibility of this sheet is one of its greatest assets. Plus keeping it macro/VBA code free helps keep the file size way down.
Very true: As long as you can avoid any coding, you'll be able to have a broader audience. Interestingly enough, the road you are following is similar to the same road I walked for TOS+. Initially called the "Dual-Class Character Sheet", this first version of my product was also VBA/Macro Free, and worked fine on Macs. That was back in 2003. It was followed by the "Multi-class Character Sheet" in 2004, still VBA/Macro free. Then, I came at a crossroad in 2006: To allow the newly renamed TOS sheet to grow, I would have to use VBA to give the additional power it required... Hence the current version of TOS+ which requires VBA... Time will tell if you come to the same conclusion - best of luck!!
RiTz21
http://TheOnlySheet.com
P.S. And for the record, TOS+ can be acquired for pocket change... and TOS FREE is... well free :)
I tested out the encumbrance hit and that seems to be working--can you recheck that one for me? I tested with both a human and a halfling couldn't find any problems.
I verfied it. The sheet thinks that I still have light load, even though the max weight is 20 and I'm carrying 21.5.
1st lvl Halfling Bard
Stats:
8 (Raw: 10)
18 (Raw: 16)
12
12
7
16 (Raw: 14)
Equipment:
MW Chain Shirt
Shortbow
Rapier
Heavy Wooden Shield
Weight carried: 21.50
Carrying Info/Light load value: 20
Calculated encumbrance value: Light
Hey - I apologize if someone has mentioned this and I missed it (what a massive thread!).
I have been using the 7.8 version and there is a small problem with the oracle class skills. The basic Oracle class skills (not associated with Focus meaning things like Diplomacy, heal, knowledge His, ect) are not being identified as class skills. The sheet only keeps the focus skills (for example wind focus gets fly, acrobatics, ect) as class skills.
Thanks for your hard work on this! It is wonderful.
Another bug (I think):
If I put a shield in the "Shield" section of my sheet, but select "Shield=No" under the "AC" section, then the shield AC is not calculated in the total AC.
This is great.
But, it still adds the armor check penalty to everything (particularly the skills that take armor check penalties).
I would assume the "Shield=Yes/No" toggle should also toggle off AC penalties as well.
Hi there, I've been out for the few last months and I've missed some versions of the sheet.
I was updating my Dwarf Fighter to your new 0.7.9 version and found out that some of the Fighter Class Ability Bonus are not automatcally being applied.
I'm using a Dwarven Waraxe and have the Weapon Training "Axes" but no bonus applies, as well as for the Armor Training Bonus.
Sice I've been out for a while, I dont really know if this is a "bug" or you're still working on it. Anyways, I've decided to bring it up.
tnx!!!
Weapon Training is not in place as yet, so you'd have to put the bonus in manually. I'm thinking on how to best implement this piece, so stay tuned...
The Armor Training seems to be working properly, however.
Time will tell if you come to the same conclusion - best of luck!!
Thanks! With my present design focus (small size, compatibility, and relatively easy customization), I can't see ever expanding into the need for macros/VBA--when I want a tool that has more power I'd rather just buy one!
I verfied it. The sheet thinks that I still have light load, even though the max weight is 20 and I'm carrying 21.5...
Found it! I had modified the "Load" cells on the Back tab without fully modifying the actual Load_Light, et. al. calculations...Fixed!
Hey - I apologize if someone has mentioned this and I missed it (what a massive thread!).
I have been using the 7.8 version and there is a small problem with the oracle class skills. The basic Oracle class skills (not associated with Focus meaning things like Diplomacy, heal, knowledge His, ect) are not being identified as class skills. The sheet only keeps the focus skills (for example wind focus gets fly, acrobatics, ect) as class skills.
Thanks for your hard work on this! It is wonderful.
Fixed in v.0.7.9, so a fresh download will fix this one for you.
Another bug (I think):
If I put a shield in the "Shield" section of my sheet, but select "Shield=No" under the "AC" section, then the shield AC is not calculated in the total AC.
This is great.
But, it still adds the armor check penalty to everything (particularly the skills that take armor check penalties).
I would assume the "Shield=Yes/No" toggle should also toggle off AC penalties as well.
Good catch! I've modified the Armor Check Penalty calculation to properly account for whether the shield is wielded or not.
Bug: Slings should get STR modifier to damage.
Love the fast responses!
Minor enhancement: The ammunition text fields are char size '5' which makes them difficult to read. '10' would be more appropriate.
Also, is there any functionality to this section, w/r/t calculating weight and stuff? I rarely use it anyway because using pulldowns to check off boxes is kind of tedious :P
Bug: Slings should get STR modifier to damage.
Love the fast responses!
They do--note that I've always considered Slings as "Thrown" (same for staff sling and atlatl, though I don't think the later is in PRPG as yet), and so use that setting. Are you setting them as "Ranged" perhaps? I could probably work ou tsome logic such that slings work as either Thrown or Ranged...
Minor enhancement: The ammunition text fields are char size '5' which makes them difficult to read. '10' would be more appropriate.
Also, is there any functionality to this section, w/r/t calculating weight and stuff? I rarely use it anyway because using pulldowns to check off boxes is kind of tedious :P
No functionality at present other than being used as a tick-sheet for ammo use...
They do--note that I've always considered Slings as "Thrown" (same for staff sling and atlatl, though I don't think the later is in PRPG as yet), and so use that setting. Are you setting them as "Ranged" perhaps?
Ya, that was it. Thanks!
The Only Sheet+ does not function on Excel Mac because Microsoft did not add VBA support for Mac Excel (It turns out they actually removed it!)
Just to clarify - I certainly didn't mean to sound like I was criticizing The Only Sheet+ - it's a fantastic product, and I certainly understand that M$FT's decision not to include VBA for Macs is in no way a knock against ToS. I was mainly just holding ToS+ up as a stellar example of such a tool, to say how impressive both sheets are.
I continue to be a subscriber to ToS and espect to keep renewing it for the foreseeable future. I will continue to use both sheets for various needs.
The work that both of you have put into your respective sheets is really impressive, and the gaming community is far better for your efforts.
The work that both of you have put into your respective sheets is really impressive, and the gaming community is far better for your efforts.
As a minor contributor to this one, thank you.
And a big thanks from me as well! I didn't take your previous post as a shot against TOS, and I'm sure RiTz21 would say the same. Our products do vastly different things, and I definitely don't mind pointing folks in other directions when another tool is better suited to their needs. My hope is that we can all basically support one another--when someone's looking for a more powerful spreadsheet, I direct folks to either Kor's work (if they want free but in beta) or TOS (if they don't mind paying and want stable/supported). For folks that want a full-blown character generator, I'm a big fan of HeroLabs (I've got less experience with PCGen, but know it's also a fan-favorite for many). All these tools hit different needs, but in the end we're all OGC...
And on that subject, I wanted to let everyone know I should have the next increment of v.0.7 by tomorrow. This one of course has all bug fixes and minor enhancements requested to date (including three slots for bonus feats...), and also adds the basics (i.e. BAB, skills, saves) for the rest of the Beta classes. I'm holding off on automating more of their class abilities based on the note in the 3rd release that Jason is looking to do a compiled release with changes based on beta feedback. Beyond this, the release will have feat automation for almost all the Paizo/Golarion feats, better handling for weapon proficiency/focus type feats, and the OGC from my latest acquisitions (CoT 5, Andoran, and Classic Horrors). So, get any other bug reports in tonight or tomorrow morning if you want the fix in this release!
Thanks!
Okay folks, v.0.7.10 is now posted. I've still got 82 Paizo OGC feats to automate--I've done nearly 100 so far! Also includes all the items noted in my last post. I may be able to do more tonight/this weekend, but just in case I wanted to go ahead and get this version out since folks have been asking for the other beta classes.
Enjoy!
Ah yes, I remember that request from a while back and forgot to add it in!
The formula for the class ability is:
="Gain +"&MAX(1,FLOOR(Lvl_Rog/2,1))&" to Disable Device checks and to Perception checks to locate traps; may use Disable Device on magic traps"
So, if you wanted to calculate a "Find Traps" skill for rogues, you could use the formula:
=MAX(1,FLOOR(Lvl_Rog/2,1))+VLOOKUP("Perception",Table_Skills_Known,22,0)
This will add the Rogue levels to Perception (I know the hard coded column number isn't great, but MATCH doesn't work well in this case...)
I'll see about having something for this in the next version, and I also need to ensure Disable Device gets that bonus as an auto-calc.
Hi all, PRPG_CS_v_0_7_9.zip is now available! This version fixes all items noted to date, incorporates suggested enhancements such as the wealth by level multiplier, adds feats/traits/equipment from various Golarion supplements, and automates most General traits (haven't hit the Campaign, Race Region, or Religion traits as yet). I haven't had a chance to get back to the animal companion sheet, so no changes there for this release.
Hi Erian, great looking sheet. I DL'ed a previous version but I have not had a chance to use it. Today, a few minutes ago actually, I clicked on the above link and I am getting a message saying that the site is not here. Looking at all the postings in this thread Wouldn't give the impression that it was down. Is this just an error on my end?
Hi Erian
possibly a bug: "DataSkills" sheet, F26 formula should contains "Half-Orc" (capitalized initials) instead of "Half-orc" to trigger +2 racial bonus, when such race is chosen.my 2c, thanks for updating in your next drop if I'm not missing anything...and THANKS for the great work, really very useful to myself + team!
Good eye...fixed it for the next release!
Hi Erian, great looking sheet. I DL'ed a previous version but I have not had a chance to use it. Today, a few minutes ago actually, I clicked on the above link and I am getting a message saying that the site is not here. Looking at all the postings in this thread Wouldn't give the impression that it was down. Is this just an error on my end?
Thanks! We're actually up to v.0.7.10, and as I was running low on space I removed the old files. You can always find a link to my latest version in my Paizo profile.