D&D 5E Base attack Monster spreadsheet issues

[monsterworkbench]

Well I have run into a snag and it is a big one. I was playing last night using a spreadsheet that has all the monsters and noticed that the to hit mod was wrong on several monsters. I looked back to the spreadsheet and whoever initially made it has some formula in there that clearly is not working. Do you know of a way to create base attack value based on Str/Dex or am I going to need to go through the entire monster manual 1 by 1?

 

[monsterworkbench]

Yea, either need to manifest some magical excel formula or just go 1 monster at a time.

 

[Krachek]

I think I read in Sage Advice that some monster's Bonus attack and DC were simply adjusted and dont fit any formula.

 

[I'm A Banana]

STR/DEX bonus, + proficiency bonus = final attack bonus.

Proficiency bonus varies based on CR.

What part of that are you missing?

 

[monsterworkbench]

So let's use a commoner for example. With that formula I get 0. But his base attack is 3.

 

[FormerlyHemlock]

Eh? CR 0 Commoner has a proficiency bonus of +2, and a Str of 10, which would yield +2 to-hit. That's exactly what I see here: http://www.aidedd.org/dnd/monstres.php?vo=commoner

I'm AFB so it's possible that there's some other Commoner in the MM with different stats; but he wouldn't have a +0 to-hit unless his Str were only 5 or 6.

 

[monsterworkbench]

Maybe I am off on the proficiency bonus. Let's do a Bugbear Chief?

 

[FormerlyHemlock]

Bugbear Chief has Str 16 and CR 3, so his proficiency is +2 and his ability bonus is +3. You'd expect him to have +5 to attack. It turns out that he does.

 

[monsterworkbench]

How are you calculating the proficiency bonus?

 

[FormerlyHemlock]

How are you calculating the proficiency bonus?

From memory. It's +2 for anything up to level (or CR 4), and then an extra +1 for every four levels. CR 5-8 has +3, CR 9-12 has +4, etc.