search

Heliomance / HeroForge-Anew

An interactive character builder spreadsheet for D&D 3.5, built in Excel.
https://sites.google.com/site/heroforgeanew
76 stars 30 forks source link

Natural Bond from Complete Adventurer #98

Closed ChopperDan closed 7 years ago

ChopperDan commented 8 years ago

I noticed that there was no Fleshraker from MM3 as a Druid companion. So I was trying to add it. (I've almost figured it all out) In the process I added Natural Bond to my character and noticed that it doesn't add the 3 levels for the animal companion. So, naturally, I"m trying to modify it so it does.
I'm kind of stuck. I'm not that good in excel and am googling around looking for the proper formula, syntax etc... I'll gladly share the Fleshraker entry and Natural Bond modifications to the project once I complete them. Thanks! -Dan

ChopperDan commented 8 years ago

So, I fixed it... Maybe. Under the "Creature Info" Tab I modified "CompanionLevel" formula from INDEX(BG$7:BG$226,CompanionIDx) to =IF(Feats!O679,IF((INDEX(BG$7:BG$226,CompanionIDx)-3)<=1,1,INDEX(BG$7:BG$226,CompanionIDx)),INDEX(BG$7:BG$226,CompanionIDx))

I'm sure it could be neater, but it appears to work. for now...

Heliomance commented 8 years ago

CreatureInfo tab is deprecated, I'm in the process of splitting it out into a separate sheet. When that's done, adding more critters should be a lot easier. I'll make a note that I need to double-check the Natural Bond calculations though.

Heliomance commented 7 years ago

Fixed in 8.0.