|
Along that note Brooks, erian_7, I took the liberty of starting a yahoo group, PathForge ;-) http://games.groups.yahoo.com/group/Path_Forge/ if you would be interested in putting it 'out there' to the community.
TT
Oh yes, I'd definitely love to make this a more community-based effort! We've been trying to get something like that going for a while now.
Ken, I shot that spreadsheet with the layout your way.
Thanks!
P.S. No luck on tests on the Adam--the file size is to large for Quickoffice. I'll have to do some sit-down time to figure it out, but that would be after the APG material is done.
There might be a few folks that have contributed to the HeroForge excel character sheet over the years that seem to be growing disenfranchised with the idea that HeroForge Software, LLC has refused to allow them to add Pathfinder to the current HeroForge free excel sheet, and the president of HeroForge Software, LLC was on the forum being somewhat.... difficult.... because he claims that his company actually owns the entire content of the HeroForge free spreadsheet by copyright, even though neither he nor the original creator of HeroForge have contributed anything to it in several years.
If you're really interested in getting additional community based assistance, I'll point the folks at the HeroForge forums over to this forum (or to some other method of getting in touch with you).
Brooks
|
Also on that note I have been out of the loop for a bit, But I would like to volunteer my services, I tried to figure out what might be needed and couldnt be sure what I should start on
Is there any data entry that needs done? Sorry I am not good at programming in excel, so I couldnt help fix bugs
thanks
Also looking at organizing issues, jumping to pathforge for all the people who will be volunteering will likely make that easier, or even google groups or whatever it is called...
| 1 person marked this as a favorite. |
I think getting some folks more involve in overall content creation/function coding would be the best thing we could do for this sheet! I'm actually ramping up for yet another life adventure--adopting from China--and I can already see (as I'm sure you all have...) that my time to do all the work on this sheet will suffer as a result. So long as those contributing continue to respect and utilize the OGL, I support anybody helping out.
So, point away!
|
|
I think getting some folks more involve in overall content creation/function coding would be the best thing we could do for this sheet! I'm actually ramping up for yet another life adventure--adopting from China--and I can already see (as I'm sure you all have...) that my time to do all the work on this sheet will suffer as a result. So long as those contributing continue to respect and utilize the OGL, I support anybody helping out.
So, point away!
http://games.groups.yahoo.com/group/Path_Forge/
The L-Spells tab:
Cells CS16, CS19, CS22, etc are referencing the ability modifier. They should be referencing the (Ability)_Permanent value. I changed the $DB$6>=# to $CX$6&"_Permanent">=[#+10]. The #+10 is the minimum ability score needed to cast each level of spell, ie 10 for level 0, 11 for level 1, etc. I also changed the caster level reference to us the CL_xxx NAME so that prestige classes now contribute to the caster level as they should.
EX (CS16):
=IF(AND($CX$6&"_Permanent">=10,ISNUMBER(VLOOKUP(INDIRECT("CL_"&$ CJ$6),INDIRECT("Table_Spells_Per_Day_"&VLOOKUP($CJ$6,Table_Casters_Abil ity,MATCH("TABLE",Header_Casters_Ability,0),0)),2,0))),VLOOKUP(INDIRECT("CL _"&$CJ$6),INDIRECT("Table_Spells_Per_Day_"&VLOOKUP($CJ$6,Table_Cast ers_Ability,MATCH("TABLE",Header_Casters_Ability,0),0)),2,0),"")
I think I had to fix CX19, etc also. It is trying to find a "1" when it should be looking for "1st".
I forgot what I did, but my cells now show:
=IF(CS19="","",VLOOKUP(INDIRECT($CX$6&"_Permanent"),Table_Abilities,4,0 ))
And I change the "4", to 5, 6, 7, etc for each spell level.
On the DataSkills tab:
In the feat column, the Skill Focus feat is searching for column 32 when it should be looking at column 19.
EX (for the Perception skill):
=IF(ISNUMBER(FIND("Skill Focus ["&A33&"]",Feats_Known)),IF(VLOOKUP(A33,Table_Skills_Known_L,19,0)>9,6,3),0)+Trai ts_Bonus_PerformDance+Skill_Mod_Univ_Cha
On the L_Back tab:
The Other Magic Items are not added to the Magic_Item_Summary_L cell. For some reason, I cannot add to the text string in cell AK3. So, in AK4, I created a new string called Magic_Item_Summary_Other_L and added this NAME to the Summary on the DataMagicItems tab.
Requests:
1. Add ioun stones and the remainder of the Wondorous Magic Items.
2. In the DataMagicItems tab, include columns for each skill competence bonus. This will aid is adding custom magic items. And roll those bonuses over to the DataSkills tab, Magic bonus column
Hey all. I've touched base with the PathForge group and am hopeful that it will serve as the means to move this character sheet into the future. For anyone interested in helping, please visit:
http://games.groups.yahoo.com/group/Path_Forge/
I'll continue to keep this thread open (at least while it's useful) and respond to what I can, but I intend to shift all bug fixes, enhancements, etc. over to this group if possible.
|
Hey all. I've touched base with the PathForge group and am hopeful that it will serve as the means to move this character sheet into the future. For anyone interested in helping, please visit:
http://games.groups.yahoo.com/group/Path_Forge/
I'll continue to keep this thread open (at least while it's useful) and respond to what I can, but I intend to shift all bug fixes, enhancements, etc. over to this group if possible.
awwww.... please *do* keep giving us some updates here once in a while!
Oh, I definitely intend to continue posting here. It's just that I may drive the more technical bits over to the new place for easier handling of issue threads, etc. We could, for instance, have individual threads to capture issues, track them to a solution, then report on completion.
|
Oh, I definitely intend to continue posting here. It's just that I may drive the more technical bits over to the new place for easier handling of issue threads, etc. We could, for instance, have individual threads to capture issues, track them to a solution, then report on completion.
Also, if you could, please let us know when and where an updated sheet is. Thank you.
|
Don't know if this has been covered yet or not but something that I just noticed as I was leveling my fighter...
At level 3 when Armor Training 1 kicks in you are supposed to gain full movement while wearing Medium armor.
My Fighter 3 wearing MW Breastplate is still only showing movement of 20 ft.
I attempted to follow this one, but it's late and didn't want to dig that deep into the sheet to follow what all leads to the movement cell so I brought it here without a solution in hand.
I'll see what I can dig up tomorrow in my free time, but I wanted to post here in case someone had a quick fix before I went digging.
-Corzat
|
|
From the above post, I’ve dug into the sheet and figured out where the problem comes from to cover the Armor Training 1 not being applied to my issue with MW Breastplate…
The issue arises from the formula found in Table_Armor on the DataEquipment sheet that is looking for speed reduction. Beginning in I283 the table is looking for whether or not the armor imposes a speed reduction. Beginning with the medium armors though, the formula used is looking for a Fighter of level higher than 3, not level 3 or higher.
Specifically for my case the cell for Breastplate reads as such:
The cell(s) calculating the Speed Reduction of the Medium and Heavy Armors should have this as the formula so that Armor Training is being applied at the correct level rather level plus one.
=IF(Lvl_Ftr>=3,”No”,”Yes”)
For Heavy
=IF(Lvl_Ftr>=7,”No”,”Yes”)
-Corzat
Hey all, I wanted to let everyone know that we've got a core group of folks together to create a sheet using the best practices from currently available work. As you all know, I've been unable to do much on my sheet of late and my hope is this new project can get a process in place where multiple people provide support so when folks like us have life issues it doesn't shut the project down!
If you are interested, please head over to http://groups.yahoo.com/group/Path_Forge/. We're putting together teams now to handle data, development, user interface, integration, etc. As we progress toward an initial release, I'll update this thread to let everyone know. Given our approach, I believe this new sheet has the potential to be the best free Excel-based sheet available for Pathfinder in the future.
Thanks!
I believe this new sheet has the potential to be the best free Excel-based sheet available for Pathfinder in the future.
Thanks!
Your current one is already the best, so improving it means...umm...its the best! :p
Thanks for the vote of confidence Shifty! we'll definitely do our best! I just noted this regarding a question of joining the group in order to get the sheet (over on the Ogre sheet thread), but figured I'd repost here...
Sorry for the delay, had a bit of a family emergency (highlighting why I want a group of folks supporting this thing!)...
You can join the group in order to contribute to the project--we welcome anyone looking to do data entry, development, user interface design, testing, documentation, etc. However, group membership is not necessary in order to access the sheet. Once a functional version is available, we'll ensure it is widely available from sites like the PF Database and d20 PFSRD. I'll also host links in my profile as I do with my current sheet. Finally, we'll be listed in the community use list as an active development effort (a reminder to me to get that entry in place).
i have just found a error i dont know if this one has been reported yet it is kinda of a obscure one if you are going for mystic theurge and you are playing a necromancer the power of undead and you cleric levels create a error 508 in the Abilities & Feats
Once it gets off the ground, it'll be available here, at the PathForge group, and at other popular PFRPG support sites.
|
|
Erian: do you have or know of a auto-generating sheet for Animal Companions? (i.e. one that would work just like the regular PC sheet, where you would drop-down select the animal's feats as you add hit dice...)
I love your excel sheet but when comes the time to figure out my horsie it's always a pain! :)
Cheers!
PDK
|
|
so, i cant figure out why when i choese a spell caster the bonus spells shows #na as well as spells per day has anyone figured that out?
yeah
in the column showing 1, 2, 3, etc. just type 1st, 2nd, 3rd, etc. and let the magic unfold! :)
(all that's left after that is a minor re-jig of the summing equation in the total spells per day column, then you're golden)
Erian? No one appears to be posting in the yahoo group you posted a link to. Is the project officially dead?
Well I guess that's a yes. Shoot.
Thanks to Berselius's prompting, I remembered I needed to come over and address you fine folks...
Sorry about dropping off the planet (again). Between my dad getting sick, then wife's back surgery, adopting from China, work craziness, etc. I've just not had any time at all for gaming. It's pretty much what I was afraid of in even joining up with the Yahoo group. I truly hope they can get something off the ground as a community effort, but I've got to drop out entirely I think. Obviously my existing work remains available for use at any time.
Thanks for the consideration!
Eric
Aww man. Sad to see ya go but we all definitely understand! And hey! You adopted from an Asian country too eh? Awesome! How many children did you adopt? Me and my GF adopted two little angels from Japan. ^_^
As above.
Sorry to hear this didn't work out. It really set the standard for others and made many peoples play a lot better than it may have otherwise been - it helped me get around character generation when I started pathfinder.
Hope everthing works out for you mate :)
I just hope someone pics up the project where Erian left off. The idea of a excel stat block generator he was proposing sounded promising. ^_^
|
|
Can someone help an Excel-Dummy fix the Landscape AC problem (they do not calculate in v094.) I see the issue referenced above, but do not see a solution.
PS: erian_7, this workbook is a work of art. I hope you have time to come back to it some day.
I think I fixed mine, so I'm going off of memory. The formula for the AC Total -- make sure that all the variables have "_L" at the end of each variable. I think it was missing on a variable or two. I believe the same was true in another location.
Good luck.
Thanks for the great resource, just two bugs I'm having making my 8th level halfling Ranger:
1) doesn't seem to be calculating my Dex bonus (+6) to my AC properly, it's listing it as +5 in P-Front.
2) Animal companion with Skill focus (Stealth) isn't showing a bonus to the skill.
3) Halfling Sling Staff doesn't calculate bonus for str damage unless you set it as "thrown" rather than "ranged" (that may or may not be a bug).
Thanks for the great resource, just two bugs I'm having making my 8th level halfling Ranger:
1) doesn't seem to be calculating my Dex bonus (+6) to my AC properly, it's listing it as +5 in P-Front.
2) Animal companion with Skill focus (Stealth) isn't showing a bonus to the skill.
3) Halfling Sling Staff doesn't calculate bonus for str damage unless you set it as "thrown" rather than "ranged" (that may or may not be a bug).
Ignore 1) it was working fine, I just forgot about the fact he was wearing studded leather which gives a max dex bonus of +5 to AC.
Hey all...sorry I don't monitor this thread as often as I used to!
I was fiddling around with my profile a while back and indeed apparently deleted the link to the latest file. I can't access it at work but should be able to replace the link once I get home. This will be the version that included the APG classes but doesn't have the alternate racial traits and archetypes fully functional.
Profile updated to list v.0.9.4
The manual feat area has only 4 entries and the last one of those entries is bugged to be skills... So my question is, how can I add more feats?
there is a sheet called "Feats" and somwhere around line 796 is the entry
"INSERT NEW FEATS ABOVE THIS LINE & MANUALLY ADJUST ROW NUMBERS"
Thought I would poke my head in over here, and say the project over at http://games.groups.yahoo.com/group/Path_Forge/ is still alive and kicking.
Oh wow cool, where's it up to now?
APG/UC/UM loaded yet?
Not completely - the witch's hexes and the Extra Hex feat aren't added yet.
In fact of all the APG classes,only the class options for the cavalier have been added to the Specifics tab of version 13.6 of the Path Forge Excel sheet.
In fact of all the APG classes,only the class options for the cavalier have been added to the Specifics tab of version 13.6 of the Path Forge Excel sheet.
We now have Animal Companions working (PFCR,PFUM,PFBty,PFBty2,PFBty3). Witch (PFAPG Only). As well as the Inquisitor added now.