Excel CR calculator

[Knight Otu]

The one thing I know for certain that does not quite work is restricting the abilities most subtypes grant (Water and Aquatic do check the Swim speed checkbox, but the others don't). But other than that, it should work.

And I don't think I ever used older Excel versions. If so, I can't remember.

 

[Fieari]

One thing I need for my monster is a CR adjustment based on land speed. UK's document says that there should be a +0.2 CR for each doubling of speed, and though the various types of movement give MORE CR plusses, I'm pretty sure land speed does too. Could you add that in to the sheet? I'm debating whether to give my monster 120' movement or 250' movement (basic land movement) and it's medium size, so either way that should effect CR...

 

[RuminDange]

...And I don't think I ever used older Excel versions. If so, I can't remember.

That's a good thing to forget trust me.

 

[juliaromero]

One thing I need for my monster is a CR adjustment based on land speed. UK's document says that there should be a +0.2 CR for each doubling of speed, and though the various types of movement give MORE CR plusses, I'm pretty sure land speed does too. Could you add that in to the sheet? I'm debating whether to give my monster 120' movement or 250' movement (basic land movement) and it's medium size, so either way that should effect CR...

My version did adjust the CR for doubling speed for flying and non-flying speeds. If you were large, then it would be 0 mod up to 79 speed, but then at 80, the first doubling, would be one mod level, then the next one at 160, etc.

I'll have to look at the other one with macros.