ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
McGeachie's Muli-Class Average-Case 5e DPR Calculator
2
3
Purpose
4
This is an average-case Damage-per-Round (DPR) calculator for multiclass builds in Dungeons and Dragons 5th Edition.
5
6
Disclaimer
7
Damage per round is not everything. It only considers damage done using the elements modeled. Damage is averaged over the expected length of the fight. DPR is only one tool that may help you to design a character that is enjoyable for you. Only you can pick the character right for you.
8
9
Instructions
10
To edit this spreadsheet, download a copy to your device or drive in Microsoft Excel format. Then open that file using MS Excel or Google Sheets. You can then edit your own copy!
11
the main DPR is done on the page called "Sorcadins." To model a character, edit the Green Box areas in the first 100-150 rows of the sheet. The DPR is listed at the very bottom of the sheet, and at the top row, and is also graphed at the top right.
12
Each column from E to X represents the character and the character's DPR at a specific level, from Level 1 to Level 20.
13
14
Step 1. Enter multiclass levels
15
The character's levels in various classes are represented in the green box labeled Class from E7 to X19. At each Character Level, a character can have Class Levels in one or more classes that sum to the Total Character Level.
16
Input the level of the corresponding class in the column for character level.
17
For example, if at Level 1, your character will have one level of Paladin, enter a "1" in box E7. Make sure there are no non-zero entries in the rows corresponding to other classes.
18
Then at Level 2, if you will have two levels of Paladin, enter a "2" in box F7. If the character will progress only as a Paladin, continue entering the class level of paladin in the column corresponding to total character level, in other words enter the sequence of numbers from 1 to 20 in boxes E7 to X7.
19
Multiclass characters are entered in the same way. At each level, the character's total class levels must sum to the character's Total Character Level.
20
For example, suppose the Paladin at Level 3 decides to multiclass into Warlock. In the column for Character Level 3, enter a "2" in the Paladin row and a "1" in the Warlock row to indicate they have 2 Levels of Paladin and 1 Level of Warlock.
21
22
Step 2. Indicate Subclasses
23
Character subclasses are indicated in the green and white striped boxes from rows 36 to 85.
24
A character's subclass is indicated by a "1" for having the subclass and a "0" for not having the subclass.
25
There should be only one subclass with a "1" indicated for each class at each level.
26
If you wish to model the DPR of a subclass that doesn't contribute to DPR, such as a Bear Totem Barbarian, simply place "0"s in all barbarian subclasses.
27
28
Step 3. Feats and Ability Score Increases (ASIs)
29
Feats and ASI's are indicated in the green box from B5 to B29.
30
The total number of ASI's and/or feats your character has at each Total Character Level is shown in Row 22. This is a guide for you. If your DM awards other ASI's/Feats, it's ok to deviate from this number. This does not include Level-1 Feats awarded by certain races.
31
A feat or ASI is indicated with a non-zero number for the Total Character Level at which the feat or ASI is obtained.
32
For example, if the Paladin/Warlock character takes the Great Weapon Master (GWM) feat at L6, enter a "6" in box B6.
33
If the Paladin/Warlock character is a race that provides a Feat at Level 1, then enter a "1" in (for example) box B8 to indicate that Pole Arm Master feat was taken at Level 1.
34
Ability scores are all treated as having a 16 (or a +3 bonus) at character creation. This is a reasonable assumption if this score is important to the class.
35
For each additional ability score increases resulting in an increase of the ability score bonus (increases to 18 and then to 20), indicate the Level at which this is obtained in the same manner as Feats.
36
For example, if the Paladin/Warlock takes an ASI for Charisma at Level 12, then enter a "12" in box B10.
37
If the Paladin/Warlock's DM lets players roll for stats or start with stats much higher than 16, then indicate this with Level 1 ASI increases.
38
For example, if the Paladin/Warlock started with a 20 charisma, enter a "1" in box B10 and also a "1" in box B11. This shows that at L1, this character has a +5 bonus to Charisma-based abilities and attacks.
39
Half Feats.
40
If a character obtains a Half-Feat (such as Piercer, or Elven Accuracy) and this also results in an increase in an ability score to the next even number, these must be indicated separately.
41
For example, if the Paladin/Warlock is an Elf and at Level 10 takes Elven Accuracy with a +1 Charisma bonus, and this increases his/her charisma to 18, indicate this with a "1" in box B7 and a "1" in box B10.
42
43
Step 4. Weapon Choice
44
Weapon choice is indicated in the green box from B32 to B40. Use a "1" to indicate that the character will use this type of weapon, and a "0" to indicate that he/she will not.
45
Indicate only one weapon!
46
47
Step 5. Fighting Options
48
In the green box from B44 to B47, certain strategic options can be indicated.
49
These are indicated with a "1" for something the character will do, and a "0" for something the character will not do
50
Indicate "Use 2 Weapons" if the character will dual-weild melee weapons
51
Indicate "Force Range" or "Force Melee" if the character will exclusively fight from range or in melee. If both are "0" then DPR simulator will try to guess based on feats and weapon selections.
52
Indicate "Exclude Eld Blast" if your character would qualify for the Eldritch Blast cantrip, but you do not want this to be a source of your DPR.
53
54
Step 6. Racial Traits
55
Racial traits that impact DPR are indicated in the green box from B51 to B53.
56
These are indicated with a "1" for an ability the the character has, and a "0" for an ability the character lacks
57
58
Step 7. Fighting Style (Martial Classes)
59
In the green box from B56 to B63, indicate at what level the character obtains a martial fighting style. These styles are granted from Classes: Fighter, Paladin, and Ranger. Fighting Styles can also be granted by Feats.
60
Indicate in the corresponding box what level the character obtains a particular fighting style. Characters can potentially obtain more than one. Leave other fighting styles with a "0" to indicate the character does not have them.
61
If you wish to model a fighting style that does not contribute to DPR, such as the Defensive style which adds +1 to AC, simply do not select a fighting style. Place "0" in all fighting style boxes.
62
63
Step 8. Spell Casts per Day
64
The large green and white striped box from E88 to X124 indicates which spells will be cast per day.
65
For each spell the character wishes to cast every day, indicate the number of times this spell will be cast.
66
There is some checking for available spells and spell slots, but this works best if the number of spells cast is kept under the limit of spells that the character would have from their class abilities.
67
Spells that can be upcast using a higher level slot for a numerical benefit will automatically be upcast to the highest available slot.
68
Spells take higher priority than other actions, such as attacking. Thus casting a spell that has a sub-optimal effect may decrease your total DRP.
69
70
Step 9. Done! (optionally look at Simulation Parameters)
71
There's no need to look at any sheets besides the main one, "Sorcadins", and the base parameters sheet, "Base Numbers".
72
73
Advanced DPR Simluation Parameters
74
The "Base Numbers" sheet has many parameters used by the DPR calculations here. These can be edited to match the expectations of your DM, playgroup, and adventuring style.
75
The most important numbers for the DPR simulation are the number of fights per day (or per long rest, these terms are used interchangably), the length of those fights in rounds, and the number of short rests per adventuring day.
76
These numbers are in boxes C5 to C7 on the "Base Numbers" sheet
77
Your campaign and DM's style will determine how many fights you have per long rest (or per day). WOTC recommends 9 fights per day, popular DND podcasts such as Critical Role are closer to 1.5 per day. A more typical number is probably 4 or 5 fights per long rest.
78
The average DND combat encounter lasts 3.5 rounds. You can adjust this number based on your DM's style: maybe fights are long and involved, maybe they're more typical.
79
The number of short rests per long rest will determine how effective short-rest characters (monks, warlocks, certain fighters) are relative to long-rest characters (barbarians, paladins, sorcerers, wizards, etc). WOTC recommends 2 short rests per long rest (or 2 short rests per 9 fights), but most campaigns seem to have fewer.
80
Percent of Fights with a Buff Round is the proportion of fights where casters will have a round to prepare and cast something like Bless without taking up an action during the fight itself.
81
Some general modifiers can be set for the DPR simulation, these include global changes to enemy's armor class and magic weapons that a character may have.
82
Enter the average damage dice for "Magic Weapon additional damage dice", for example for a Flame Tongue weapon which does 2d6, enter the average damage "7". For a weapon that adds 1d6 to each hit, enter "3.5"
83
The chance for Booming Blade to deal it's secondary damage, triggered upon the target's voluntary movement, is entered in the "booming blade secondary damage percent" box.
84
Since the publication of Tasha's Cauldron of Everything, it has been against Rules As Written for booming blade to be cast using a shadowblade as the weapon. It seems to be allowed by Rules As Intended, since Jeremy Crawford himself has said he would allow it at his table. There is an option here for you to indicate the ruling used by your DM: enter a "1" if allowed and a "0" if disallowed.
85
There are a number of parameters that reflect the likelihood of a character to be able to execute an opportunity attack on an opponent's turn, and these may be edited. It is recommended to leave them as is.
86
A number of parameters relating to Area of Effect attacks can be indicated.
87
The total number of opportunities to use each Area of Effect skill can be indicated. This limits the total number of, for example, fireballs that can be usefully cast on multiple targets.
88
The number of targets effected by each ability is also indicated here. This is sometimes increased by certain skills which have much larger areas of effect (such as fireball).
89
Simulacrum, when available, tends to dominate DPR calculations. To disable the contribution from Simulacrum, enter a "0" in this box.
90
91
92
Copyright 2021 Michael McGeachie. Permission is given to use this for non-commercial purposes as long as attribution is preserved.
93
Contact me at u/mmcgeach on Reddit with comments, suggestions, error reports, and bugs!
94
95
96
97
98
99
100