| 15 people marked this as a favorite. |
I recently had a frustrating experience with a friend of mine where she played a druid and she had a hard time leveling her character due to needing to update all of her wild shape forms. I decided there had to be a better way to level up a character with a significant number of alternate forms. Not finding any I liked I decided to create my own.
Thus, I present: the Polymorph Sheets excel file
What it is: It is a way to quickly level your Polymorph (wild shape) forms via significant automation.
What it is not: It is not a database of creatures, you still have to know the rules. It is not a full character sheet but will handle just about anything polymorph can throw at it.
How is it used? Fill out the base creature information (Ability Scores, Armor Class, some Skills, etc.). This information will be plugged into all of the Polymorphed forms you create and then modified by the size and type of Polymorph effect you use. Then fill out the Polymorph form's attack data (a bit more complex but still automated once you fill it out the first time.)
Extra information: There are four Polymorph sheets per printed page. This allows you to have only a few sheets for all of your polymorph forms.
I am looking for feedback. Anything I missed, anything that is broken, opinions on color scheme, layout, and the clarity of the instructions.
In general, have at it and let me know what I can improve.
Wow thanks. Looks amazing.
Deserves more lookey loos. Works pretty good.
So far, I've gotten a couple dozen downloads. Thank you for trying it out.
I could use more feedback from folks. Even if that feedback is that you like it and what elements you like. :)
Pretty cool just to look at hehe
Kurt, that is odd, which version of Excel were you opening it with?
Taenia, thank you, if you have any suggested improvements please let me know.
Hey i just downloaded that sheet, thanks for all the work. Unfortunately i am having some issues. If i have a character with Dex 10, all the Dexterity related fields just show ### meaning no result when i try to use a form with negative modifiers such as large beast shape creature.
This seems to be a general problem, as the entire results page cannot deal with negative modifiers. Is that an issue you have observed as well or could it be because i am using open office?
Thanks for the info
Ok i am sorry, but it is an issue with the FLOOR function in libre office. a little editing takes care of it. Thanks a ton!
Sorry about that, I will fix the problem and republish it tonight.
Any further feedback would be greatly appreciated.
How does it look in Open Office? I didn't get around to testing it in Open Office.
I have corrected the negative modifier problem.
First of all, sorry for making it sound so demanding. What i wanted to say was, that a little editing on my part would take care of the problem, in no way was i asking for open office support.
Great thanks to you for providing it anyways now it works like a charm!
The problem with libre office was, that the implementation of the FLOOR function in libre office only works for positive numbers, with negative numbers it f%!~s up. Funnily enough, the implementation does not even work as described in the documentation, which is a major f&%* up on their part. For anyone trying to use libre office, do not use FLOOR. Use INT or something. ridiculous
Looks good on libre office, seems that the page layout works just as it should, with 4 statblocks per page.
I think this is an amazing job. By customising different "weapons" you can pretty much play around with whatever bonuses you get, be it power attack, aomf or traits etc. The customisability helps covering pretty much any case scenario i could come up with.
It helps a lot that you included pretty much all the polymorph spells, that way even Shapechange on higher levels is fun to play. The ability to add damage dice or special abilities like trip to the attacks makes it very clean cut.
It saves hours of work tracking your wild shapes and at least for me it let's me prepare more utility forms, seeing as the updating work later on is minimal.
The only thing (and this is minor) is that i couldn't customise the CMD. That would be interesting for the powerful shapes field. I just put it into the special section, which works just as well.
But seriously, i really appreciate your work. I will spread this around my gaming group for whoever wants to use polymorph spells. Once you enter your data, the updating really helps and saves a lot of time for tracking your wild shapes over different levels. Not much more one could ask for :)
Edit: only exporting your shapes into a new version might take some time. And wild armor has no armor check penalty, but that still gets included if wild armor is checked. But considering the sheet is just relevant for wild shape, i just omit it ;)
Shem, you got malware? Could you be specific as to what kind of malware and what you are using to detect it? All you should get is an Excel file so this is concerning.
Perhaps you clicked something besides the green "Download (208 KB)" button near the top right corner?
I have downloaded it to confirm that Mediafire wasn't adding anything and Bitdefender didn't show any problem with the excel file.
Dave Vader,
In my next version I might add CMB and CMD modifier fields in the Optional Modifiers area. That way any unusual bonuses to general CMB and CMD can be factored in.
Regarding Wild Armor there is a great debate on whether or not the armor check penalty is included or not. I chose to include it since it is easier for people to eliminate it if they want.
Perhaps I will add a switch for that in a future version.
About the floor function, it works that way in Excel too. I had a solution for that in the "Character Data" page but I forgot to put that solution in the "Polymorph Sheets" page. That is what I fixed last night.
Thank you for your excellent feedback. Your statements regarding it being easy to level once it is set up is the exact reason I created this.
A little off-topic, but concerning the ACP: Linky
There James Jacobs states, no ACP, no max Dex, but yes non proficiency. At least i have always gone after that ruling... But as i said, that really is nitpicking.
Just a hint concerning the floor function: using INT instead should work without a when/if construction. Whichever you prefer ;)
As i said, the CMD case is something special considering it just really applies for the powerful shape feat. But considering that it is a pretty useful wild shaping feat, in the long run someone else might experience the same ;)
Dave Vader, thanks for the link. I will probably still add the ACP switch just for those that state "James Jacobs is not a rules guy".
Regarding the INT function, I won't bother redoing the IF lines since they are working but thank you for letting me know about INT. I didn't know much about EXCEL before doing this. I researched the tools as needed.
I am by no means an expert, but after being close to desperation yesterday I stumbled upon the solution with INT and just thought I'd share what I found.
Quite the impressive project for a first time excel sheet!
|
Greetings,
I have been enjoying your polymorph sheets as they make keeping track of druid forms easy. I am wondering if you are working on an updated sheet as the recent Core Rulebook FAQ changed how the wild enchant handles max dexterity bonuses, armor check, movement, spell failure penalties. I would love to continue using your excellent sheets in Pathfinder Society play. Thank you for your time.