NOW LIVE! Today's the day you meet your new best friend. You don’t have to leave Wolfy behind... In 'Pets & Sidekicks' your companions level up with you!

Reply to thread

Message: <blockquote data-quote="Tormyr" data-source="post: 6485732" data-attributes="member: 6776887">RE: Excel error. Are you using an older version of Excel?  ?NAME errors occur when Excel does not recognize part of a formula.  The only interesting part of the formula in the ability modifiers section is the FLOOR.MATH() function.  If you do a global search and replace on the file and replace FLOOR.MATH with FLOOR it may work.RE: NPC that needs more teethYou got there, but a few of the calculations are different than what you thought, so you might want to be aware of them in the future.The average damage for lightning bolt is 28 (8d6) so it is doing 56 damage per round.  However, there are two 4th level spell slots, and the CR guidelines use the most efficient damage dealing possible.  So two rounds do 65 damage for an average of 62 damage.  This puts offensive CR at 9 -1 for the low save DC for an offensive CR of 8.You can go up to 84 (13d8 + 26) hit points. The Defensive CR would start at 1 and go up to 4. The average is CR 6.RE: HedrunFor resistances and immunities, even immunity to poison is enough to kick in the immunity multiplier. Cold and fire should probably count in the calculations for effective hp.I only got an average of 83 DPR, but I may have missed something. Even then her DCR with the immunity is 7, and her OCR is still 11. Average CR would be 9.  However, the CR is only 1 different from what you got, so I think you have a pretty good idea of how to calculate CR. Spellcasters are definitely the hardest to figure out.The Abjurer's Armor and Ice Armor in Legacy of the Crystal Shard seem to be keyed to half of the NPCs hit points, but you can choose whatever number you want, and 24 is fine. For Hedrun's Ice Darts and Ice Spear, I used magic missile and melf's acid arrow with cold damage. You might also like to take a look at ice storm. With Hedrun's immunity to cold and difficult terrain, she could drop that in the room and walk through unimpeded and pick off PCs one at a time as they are lost in the storm.</blockquote>

Verification