D&D 5e Monster Builder

[bryantsonnier]

I have just uploaded D&D 5e Monster Builder to the downloads area.

This is a D&D 5e Monster Builder using the statistical data compiled by Surf Archer (https://plus.google.com/+SurfArcher/posts). The file is a Macro enabled excel file. Most everything is protected and some of the sheets are hidden but nothing is password protected so you can easily get to the guts if you like that sort of stuff. Fill in all the green fields on the "Monster Creation" Sheet and it will populate the "Monster Card" sheet. Then either copy and paste or take as screen shot. Hope you like it.

Here is the blog i got the statistical data from: (http://surfarcher.blogspot.com.au/s...d-max=2016-01-01T00:00:00+10:30&max-results=1).

You can find the file here in the downloads section. Please use this thread for comments.

 

[Clockwerk66]

Looks cool bryant! I might give it a try later.

 

[bryantsonnier]

Sorry just noticed an error with the experience listing. Fixed now. sorry about that.

 

[xgene]

Shouldn't the formula for Ability scores follow that for PCs?

So, shouldn't this:
=IF(B7<10,"(","(+") & ROUNDUP(B7-10)/2,0) & ")"
Be:
=IF(B7<9,"(","(+") & ROUNDDOWN((B7-10)/2,0) & ")"

Or do monsters use a different rounding forumla?

Also, the Ability scores on the Monster Card tab aren't linked to the Monster Worksheet inputs.

 

[bryantsonnier]

Thank you for the heads up. Fixed it i think. I went with:

=IF(B7<10,"(","(+") & ROUNDDOWN(B7/2,0)-5 & ")"

that should fix it and i fixed the linking.

Please let me know if you find any other bugs. Thank you.

 

[bryantsonnier]

Released version 1.4 with corrections pointed out by Casey in the comments section. Sorry it took so long.