erian_7's Excel-based Character Sheet


Homebrew and House Rules

1,601 to 1,650 of 1,732 << first < prev | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | next > last >>

Erian, you need all classes data and what else?

I would recommend some kind of topics list (like a to do list). It's easier to see what we need to get everything ready and wont happen 2 ppl doing the same data entry.

Like, for example:

Ftr: Core: Done APG: NEED ALL
Sorc: COre: Done APG: Shadow Done, Need all Other

Stuff like that will help us to help you.

I can do 3 classes for saturday.

(I sent you via email all spells list, did you got it?)


I seem to be having problems with using this spreadsheet to generate a character that uses a shield.

I have the shield equipped on the back tab along with some armour.

When I select the shield-readied option on the front tab it is not giving him any AC from the shield.

Looking at the code it seems to not be looking for the shield value anywhere - it applies all sorts of other bonus's such as focus but still not the base shield ac value.

(I’ve re-coded my own version - using a new named value and also taking out all the extra weird stuff but that doesn't help as my characters will progress levels and need all the weird extra stuff adding back in.

Any advice or potential fix?

Cheers

Jon


Correction - downloaded the most up to date version of the spreadsheet.
Portrait AC and Shield AC now work fine.
Landscape AC isn't working - one of the name refs is missing an _l on it.

Jon

Liberty's Edge

erian_7 wrote:

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

The Exchange

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

Brooks Banks wrote:
erian_7 wrote:

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

Lantern Lodge

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!

The Exchange

erian_7 wrote:

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/


Pathfinder Rulebook Subscriber

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.

Sovereign Court

erian_7 wrote:

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.

Scarab Sages

erian_7 wrote:
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.

Liberty's Edge

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

Liberty's Edge

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:

Spoiler:
DataEquipment!I295=IF(Lvl_Ftr>3,"No","Yes")

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.
Spoiler:
For Medium
=IF(Lvl_Ftr>=3,”No”,”Yes”)
For Heavy
=IF(Lvl_Ftr>=7,”No”,”Yes”)

-Corzat

Liberty's Edge

Hope we get a new version soon! love this sheet


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!


erian_7 wrote:

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

Liberty's Edge

where do you plan on releasing new version of the character sheet, erian? here or on the pathforge group?


Once it gets off the ground, it'll be available here, at the PathForge group, and at other popular PFRPG support sites.

Sovereign Court

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

Liberty's Edge

How is the project coming along? haven't seen any emails on that mailing list recently.


*crickets*

Nothing happening in either forum =(

Thanks Erian for what you have done for us all thus far!


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?

Sovereign Court

Jacob Armoir wrote:
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.


I"m trying to add a formula for the Furious Focus feat. I've added the feat fine as a custom feat, but my excel knowledge and ability to follow Erian's formulas break down when I try to figure out how to add to the fist attack bonus. Rather than modifying the Power Attack feat formulas, all I really want to do add the appropriate bonus back into the first attack bonus in cell E41 on the sheet L-Front. Any pointers?


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. ^_^


Just wondering, does this spreadsheet have the capabilities to write up a ghestal character? Want to play with the pathfinder setting, but will have a small group of players (2-3) and would like them to be a bit tougher then normal.

Also, is there a way to create a custom class that cast spells, but that the PC would have to choose from only three schools?

Liberty's Edge

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.

Scarab Sages

Tanelorn wrote:

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).


Dr z0b wrote:

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 guys,

I dunno if anyone is still using this spreadsheet and/or still reading this thread but I'd like to throw this out anyways.

I'm playing a cleric with the crusader variant, but since the sheet doesn't have the crusader variant, I made my own tweaks to it. The only thing is, I don't know where to add more feats. 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?

Thanks!

Sovereign Court

Erian I noticed you pulled the linky to the sheet in your profile... where is the latest and how can I get it? :)

(i.e. does it include some functionality for the APG stuff now?)

Cheers!


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


general_tao wrote:
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"


Since the Holy Vindicator prestige class isn't pre-loaded in the sheet so I added it in the "custom" class section, except, it's a 3/4 casting class and when I add the levels, it's not reflected in the spell sheet, as in Caster Level and spells per level and what not. Anyone can help me out?


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.


Morgan Champion wrote:
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 are upto 0.15.3 now.

We now have Animal Companions working (PFCR,PFUM,PFBty,PFBty2,PFBty3). Witch (PFAPG Only). As well as the Inquisitor added now.

1,601 to 1,650 of 1,732 << first < prev | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | next > last >>
Community / Forums / Pathfinder / Pathfinder First Edition / Homebrew and House Rules / erian_7's Excel-based Character Sheet All Messageboards

Want to post a reply? Sign in.