Monster CR Calculator

[Tormyr]

*snip*
Next you calculate the monsters DPR which gives you the "expected Attack CR," from the table. This is then adjusted by the attack bonus and traits to give you the Attack CR. These are then averaged to give you the Final CR (which may cause adjustment to proficiency bonuses). That is how I like to work. Your spreadsheet attacks it a little differently that is all. No worries.

Thank you for the quick response and hard work!

Except the Attack Bonus and Save DC are both modified by the proficiency bonus, which is set by CR for a monster and need to be in place before the final CR is calculated. If it makes you feel better, just think of it as "Proficiency Bonus" instead of "Expected CR" as the only actual effect that "Expected CR has is to set the proficiency bonus in the rest of the sheet. All the other information that it sets is advisory only. So you can set it to any of the following values:

Proficiency Bonus	CR Range
2	1-4
3	5-8
4	9-12
5	13-16
6	17-20
7	21-24
8	25-28
9	29-30

And I understand what you mean about not wanting to decide on a CR ahead of time. You can also give the Attack Bonus and Save DC a fixed modifier to simulate the proficiency bonus, but you may need to double check at the end that the monster's CR and proficiency bonus line up if that is important to you.

When I made this tool, I was converting a lot of monsters from 3.5 to 5e for my Age of Worms campaign. I used the Encounter Level of the encounters in the campaign as a guide and set the encounters in the 5e version as medium encounters for a group of 4 PCs of that level. So I knew how many monsters of a certain CR that I wanted. The HP and DPR ranges were more important for me to quickly ballpark the monsters in to a given CR before their special abilities adjusted the effective HP, AC, DPR, attack bonus, and Save DC.

 

[dave2008]

Except the Attack Bonus and Save DC are both modified by the proficiency bonus, which is set by CR for a monster and need to be in place before the final CR is calculated.

Thank you again for your reply. I typically determine CR first (as described in my previous post) and then if the final CR yields a different prof. bonus than the assumptions in the defensive and attack CR calculation i adjust as needed.

Typical it as no effect on the final CR (since it is a best 1/4 of the calculation)

 

[SetArk]

About Traits.

HaiL!
So little question, how about the Traits?
Yeah, I read the bold text about copyrights, but i seriously can't understand how to fill it, so it calculates automatically the OR and DR modifications from the traits.

 

[Tormyr]

HaiL!
So little question, how about the Traits?
Yeah, I read the bold text about copyrights, but i seriously can't understand how to fill it, so it calculates automatically the OR and DR modifications from the traits.

It does not calculate them for you. You fill out the traits page with the names of the traits, and the text of what they do. On the main page you can select one of them from one of the five drop-down lists, and it will remind you what change needs to be made. You then make that change in the appropriate yellow box a couple lines down.

For example, if a CR 15 monster had 3 legendary resistance uses, you would select Legendary Resistance from one of the drop downs. It would remind you to add 30 effective hp per use of Legendary Resistance for a creature of that CR. There is a row of yellow boxes after the traits drop-down lists that let you modify the effective HP, DPR, AC, etc. You would enter 90 into the yellow effective HP box. This would raise the calculated effective HP by 90 which flows through to the calculations at the end.

 

[SetArk]

Hmm
But, when a trait says, "Up the Ofensive Rating by 2", for exemple, the Agressive Trait.
There doesn't seem to be a yellow slot, so i can up the final Ofensive Rating for the monster.
Should i just go to the final Ofensive Rating, the yellow block on the botton, and change it there? Even through it will break the script before it?

 

[Tormyr]

Hmm
But, when a trait says, "Up the Ofensive Rating by 2", for exemple, the Agressive Trait.
There doesn't seem to be a yellow slot, so i can up the final Ofensive Rating for the monster.
Should i just go to the final Ofensive Rating, the yellow block on the botton, and change it there? Even through it will break the script before it?

Aggressive does not say that.

Aggressive
Increase the monster's effective per round damage output by 2.

So you add 2 to the yellow DPR box. If a trait says to only add the damage for one round then you would add it further up where DPR is calculated.