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

Wildshapes #8

Open Nitzahon opened 9 years ago

Nitzahon commented 9 years ago

First of all, I'm very impressed with all the attention, time and effort you've been putting into this sheet since you took over.

Second of all, I noticed you have begun to implement wildshapes, which is awesome, I wanted to know where it takes the wildshape stats from(so I can add my own entries) and also when/if you were planning on adding different wildshape sources?( my 2 favorite forms are dire tortoise and sugauro sentinel, both from sandstorm).

Also, can you add support for the exalted wildshape feat in terms of adding the celestial template to normal animal wildshapes? I noticed I couldn't find plant or elemental wildshapes.

Heliomance commented 9 years ago

Hi, thanks for the kind wishes :)

Wildshape stats are on the hidden Creature Info tab. You may have noticed on the front page of this repository, I'm actually hoping someone would be up for doing some data entry to add more creature stats for me - if you're interested, I can certainly walk you through how to add them, and then if you send them to me I'll stick them in the main sheet.

The code is all in to allow plant and elemental wildshapes at the correct times, as well as supporting Master of Many Forms. The reason you couldn't find the plant or elemental wildshapes is simply because no plants or elementals have had their stats put in yet! Adding celestial versions of normal animals would be tougher, I haven't put coding in to support that. That said though, the Celestial template doesn't actually do all that much, so it's not too hard to just turn into a normal animal and remember the Celestial bonuses.

Nitzahon commented 9 years ago

Happy to help, I could at least at first add stats for creatures I'm personally using, once I finish finals this month I could start adding creatures from specific sources upon request :). most of the table is pretty self explanatory, some parts (like attack+x+x+x) are not. I would love a walkthrough

Heliomance commented 9 years ago

Firstly, when adding a new creature, don't just insert a row - there's stuff to the right of the table that it'll break. You want to insert cells from columns A to CI, and "shift cells down". Then, the columns are filled as follows (note, this is a general guide to the Creature Info tab, some of this information, like most of the things relating to familiars, is going to be unnecessary for adding Wild Shape forms):

Column A: Creature name. Keep it in alphabetical order please. Column B: Not used anywhere, as far as I know. Certainly not used for wildshape. Leave it blank. Columns C-M are fairly self explanatory. A note for Column E: the Cold and Aquatic subtypes are important, don't forget to fill them in if they're there. Cold because it makes the creature eligible for Frozen Wild Shape, Aquatic because you gain it when Wild Shaping. Column N is one of the most complicated ones. What you need to do for each natural attack is unhide the Class Weapons & Armor sheet, and go look at the table starting at J4. Look down the column corresponding to the size of the creature, and find the damage die of the natural attack. Then the number in the left hand column is the damage number you need - so, for a Large creature doing 1d8 damage, it would be 5. The entry you need to put in is constructed like this:

Attack name+[damage number]+0+[strength multiplier]

The last number should be -1 if the attack doesn't take strength into account for damage at all (for touch attacks and the like), +0 if it does half STR bonus damage, +1 if it does full STR bonus damage, +2 if it does 1.5x STR bonus damage, and +3 if it does double STR bonus damage. So a wolf's entry of Bite+5+0+2 means it has a Bite attack dealing 1d6 damage (as it's medium), with 1.5x STR bonus damage.

Ignore Column O, it's deprecated and will be deleted once all the attacks are properly listed in Column N. Columns P-Z are self explanatory. They're not currently referenced, so filling them out won't affect anything for wildshaping, but it will mean that the data's there for when I get round to making them work. Columns AA-AF are easy enough, just stick the abilities in straight out of the book. Don't worry about AG-AV, Wildshape doesn't affect skills and I haven't bothered to decipher the syntax of those columns anyway. Just leave them blank. Columns AW-BC are again self explanatory and with the possible exception of AW, aren't referenced for WIld Shape yet, if at all. BE has the level you have to be to get the creature as a familiar, if applicable, and ditto BF for animal companions. BG is blank if it's not available as a familiar, "Normal" if it's available by default, "Improved" or "Planar" if it requires to appropriate feat to get. If only certain classes can get it as a familiar, put "Restricted" and tell me so I can add the appropriate logic for it.

You can safely ignore BH-BK, though it would be good to put the species name in BK if appropriate - "Dinosaur", "Dire Animal", "Devil", that sort of thing. Obviously not applicable to most critters.

Column BL has the source abbreviation. This must be filled in. Abbreviations can be found on the hidden Options Info tab. Don't misspell it, or it'll break things. BM is the page number it appears on, for reference purposes. Column BN is a second source, if it appears in more than one place. If it doesn't, just leave it blank. Don't put more than one source in here - if the same monster appears in three different sources, just pick the two most likely to be used.

BO-BS, copy the formula from the row above. Also copy it to the row below to avoid breaking references.

BT is for special requirements for having it as a familiar, being non-evil, for example. Probably not relevant for you.

BU-BW, copy from the row above. Like before, copy to the row below as well.

BX is special requirements for having it as an animal companion. If it's an animal available as a companion, you should put =AND(NOT(CMDrdElementalComp),NOT(RslKoRgr4)) in here.

BY-CA, copy from above, copy to below.

CB is for things that you can WIldshape into that you wouldn't normally, like from feats or something. Probably easiest to just tell me if you add anything this would be relevant for, so I can do the logic. This is also used for Elemental Wild Shape, so tell me if you add any of those.

CC-CI, copy from above, copy to below.

That's all you need to know to add creatures to the sheet. It's a lot, I know. Still interested?!

Nitzahon commented 9 years ago

Sounds good, I'll give it a try. Sounds like it might be a fun hobby during spring break. suggestion to you in regards to wildshape requirments/ column CB : adding the megalodon empowerment(stormwrack) spell to the buffs tab for purpose of allowing characters to wildshape 1 size category larger. My current char is a druid6/Lion of Tsalid10 and I use that spell to allow me to wildshape into huge creatures since LoT gives a hit to wildshape use. It's probably to big to implement without breaking the current format.

Anyways, I'll get started and hopefull have some new wildshape info for you sometime next week.

Cheers :)

Heliomance commented 9 years ago

Actually thinking about it, it's probably easiest if you add new creatures at the bottom, say just above Custom Familiar, so they're all in one place for me to copy into the main sheet, rather than having to go "Now, was that one there before?" down the list.

Nitzahon commented 9 years ago

Right, I've added Treant, Saguaro Sentinel and Dite Tortoise to the table, I can start work on adding specific sources starting some time next week. shall I send you the excel file? and if so, how and where to?

Nitzahon commented 9 years ago

well, since I've already added said entries alphabetically and told you which ones I've added, I'll and whatever entries I add next at the bottom. for now were should I send the sheet to?

Heliomance commented 9 years ago

Most sensible way is probably to use the GitHub mechanisms for doing it. Download the GitHub client, clone the repository, then submit your updated sheet as a pull request.

Nitzahon commented 9 years ago

I hope I did it right, sending first pull attempt now. I hope nothing I do can fudge up your version.

On Fri, Feb 20, 2015 at 7:47 PM, Heliomance notifications@github.com wrote:

Most sensible way is probably to use the GitHub mechanisms for doing it. Download the GitHub client, clone the repository, then submit your updated sheet as a pull request.

— Reply to this email directly or view it on GitHub https://github.com/Heliomance/HeroForge-Anew/issues/8#issuecomment-75285842 .

-Nadav

Nitzahon commented 9 years ago

ok, not entirely clear how I create a pull request. So far I cloned the repository, added my updated sheet, and commited the changes, then I only had an option to sync, which failed to push because of lack of permissions. I think I missed a step somewhere. first time using github.

On Sun, Feb 22, 2015 at 2:22 PM, Nadav Gur Arieh nadavga@gmail.com wrote:

I hope I did it right, sending first pull attempt now. I hope nothing I do can fudge up your version.

On Fri, Feb 20, 2015 at 7:47 PM, Heliomance notifications@github.com wrote:

Most sensible way is probably to use the GitHub mechanisms for doing it. Download the GitHub client, clone the repository, then submit your updated sheet as a pull request.

— Reply to this email directly or view it on GitHub https://github.com/Heliomance/HeroForge-Anew/issues/8#issuecomment-75285842 .

-Nadav

-Nadav

Heliomance commented 9 years ago

https://help.github.com/articles/using-pull-requests/ There's the info on how pull requests work :)

amandasearle commented 9 years ago

I've started working on this since I saw your post on the Min/Max boards, but I just ran into a problem. Under Gargantuan (on Class Weapons & Armor sheet), there is no entry for a 2d8 damage die. The Roc is a Gargantuan creature with a 2d8 Bite attack.

"Column N is one of the most complicated ones. What you need to do for each natural attack is unhide the Class Weapons & Armor sheet, and go look at the table starting at J4. Look down the column corresponding to the size of the creature, and find the damage die of the natural attack. Then the number in the left hand column is the damage number you need - so, for a Large creature doing 1d8 damage, it would be 5."

ThAlEdison commented 9 years ago

So the 2d8 damage is consistent with table 5-1 on p. 296 of the MM, it appears that in that table 2d6->2d8->4d6 as size increases. This is different than table 4-3 on page 291 of the MM.

The table at column J in Class Weapons and Armor appears to be a combination of tables 2-2 and 2-3 in the DMG on page 28.

I don't think the DMG tables were intended to apply to natural weapons. On Mar 18, 2015 4:49 PM, "amandasearle" notifications@github.com wrote:

I've started working on this since I saw your post on the Min/Max boards, but I just ran into a problem. Under Gargantuan (on Class Weapons & Armor sheet), there is no entry for a 2d8 damage die. The Roc is a Gargantuan creature with a 2d8 Bite attack.

"Column N is one of the most complicated ones. What you need to do for each natural attack is unhide the Class Weapons & Armor sheet, and go look at the table starting at J4. Look down the column corresponding to the size of the creature, and find the damage die of the natural attack. Then the number in the left hand column is the damage number you need - so, for a Large creature doing 1d8 damage, it would be 5."

Reply to this email directly or view it on GitHub https://github.com/Heliomance/HeroForge-Anew/issues/8#issuecomment-83197038 .

Heliomance commented 9 years ago

I've just checked the sheet - there's room for one more row of weapon damage without having to redefine any names. Either add a row of weapon damage at the bottom of the table, numbered 17, and filled in as best you can work out, or just put 17 in the entry for Roc and I'll add the row myself.

Actually, there's an easier way, potentially. The second number in the entry (the one that's always +0) governs size category changes. So you can fake it by pretending its natural weapon is smaller than it actually is. So "Bite+14-1+0" would produce the right result, I think - it would make it look down the Huge column and find 2d8 in row 14, rather than looking down the Gargantuan column. That would have the slightly odd effect of meaning that it could theoretically be increased in size beyond Colossal, and wouldn't be able to be shrunk to Fine, but as I feel neither of those situations is likely to actually occur, it should be fine.

TwistedFaith84 commented 9 years ago

ok so if the second number is 1 it would increase the size cat by 1? so would .5(point 5) decrease it by 1 size cat or would -1(instead of +) so "Bite+14-1+0" would bring it from Huge to Large?

ThAlEdison commented 9 years ago

-1 should decrease it. The last number controls the strength modifier (0 for off-hand, 1 for one-handed, 2 for two-handed). On Mar 21, 2015 3:37 AM, "TwistedFaith84" notifications@github.com wrote:

ok so if the second number is 1 it would increase the size cat by 1? so would .5(point 5) decrease it by 1 size cat or would -1(instead of +) so "Bite+14-1+0" would bring it from Huge to Large?

Reply to this email directly or view it on GitHub https://github.com/Heliomance/HeroForge-Anew/issues/8#issuecomment-84282822 .

TwistedFaith84 commented 9 years ago

I knew the last one was 4 the strength mod Heliomance all ready pointed that out with her tut on adding new creatures. I just didn't realize that the second number was for size.

timoc commented 9 years ago

Can we get the Shapeshifter 'wildshape' creature stats automatically added?