# Damage Spreadsheet (for 1.2) **URL:** \ **Category:** Fatshark Lounge\ **Created:** [August 26, 2018, 3:22am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593 "2018-08-26T03:22:57Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [August 26, 2018, 3:22am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/1 "2018-08-26T03:22:57Z")
**Edit** : The latest version, for version 1.2 of the game, is here: > **[Vermintide 2 Stats (1.2)](https://docs.google.com/spreadsheets/d/1LGJtOs_ZZag-QGxM6vtjkGsVXuJqXGs0NAuPMIrqrbo/edit?usp=sharing)** > > This Sheet is private I’ve added numbers for damage against superarmor and melee attack reach, as requested by [CommissarTyr](http://forums.fatsharkgames.com/u/CommissarTyr) and [doom\_hamster](http://forums.fatsharkgames.com/u/doom_hamster). These are entirely untested though, so take them with a grain of salt. * * * Here is a new version of the damage spreadsheet, updated for the beta branch (v1.0.5): [https://docs.google.com/spreadsheets/d/1T75N5wYxO9A6ICY2BMwgMHL6-hing6gxhZPVjv6InzY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1T75N5wYxO9A6ICY2BMwgMHL6-hing6gxhZPVjv6InzY/edit?usp=sharing) Notes re the 1.2 changes: - There are a lot of changes, but the majority of them are buffs to headshot damage against armor, damage against large (a.k.a. “monsters”), and increased stagger for pushes. - The (non-elven) 2-handed sword has been overall buffed as per the patch notes, but it did lose the LINESMAN cleave modifier from its heavy attacks. **Edit:** LINESMAN was replaced by HEAVY\_LINESMAN (as per [CommissarTyr](http://forums.fatsharkgames.com/u/CommissarTyr)’s comment below) which isn’t included in the spreadsheet yet. - The charged attack on the drakefire pistols no longer has damage dropoff with range (possibly a bug). - The fireball staff’s charged attack got a buff to headshot damage against berserk rather than armored (again, possibly a bug). Notes from previous versions: - You will probably want to make a copy of the spreadsheet (File → Make a copy …) so you can modify the settings in the top row (Hero Power Level, Difficulty, Values). - Hero power below 120 is not supported because the damage doesn’t scale linearly below that which makes things too difficult for me. - The stagger values are just a relative indication of stagger power. They may let you compare weapons but they don’t let you work out, for example, if a given attack will interrupt an enemy during a particular one of its attacks. Unfortunately that’s a complicated calculation that in some cases is situational, so I doubt it can be put in a spreadsheet (I don’t intend to attempt it, that’s for sure). - The “# Targets” calculation doesn’t currently take into account mass modifiers like LINESMAN, which reduce the mass of applicable enemies by some percentage. - I’ve added a ‘power multiplier’ field you can change to simulate buffs, e.g. for a ‘+7% Power’ buff use a multiplier of 1.07. - The power level caps for difficulties are included in the calculation. ---
**Author:** ![CommissarTyr](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/commissartyr/32/22049_2.png) [@CommissarTyr](https://forums.fatsharkgames.com/u/CommissarTyr)\ **Post date:** [August 26, 2018, 4:22am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/2 "2018-08-26T04:22:05Z")
Thanks for updating 2h Sword heavy attack Linesmen modifier has been replaced by HEAVY\_LINESMAN [https://github.com/Aussiemon/Vermintide-2-Source-Code/blob/d0f0556659c713f840bfecbb62183380e0bd29cc/scripts/settings/equipment/hit\_mass\_counts.lua](https://github.com/Aussiemon/Vermintide-2-Source-Code/blob/d0f0556659c713f840bfecbb62183380e0bd29cc/scripts/settings/equipment/hit_mass_counts.lua) Would it be possible for you to add lines for damage versus super armour on the attacks? ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [August 26, 2018, 6:45am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/3 "2018-08-26T06:45:27Z")
> [@CommissarTyr](#): > > 2h Sword heavy attack Linesmen modifier has been replaced by HEAVY\_LINESMAN Oic, good catch. I’ll fix it next time I update the spreadsheet, which will probably be when 1.2 is officially released. Same for the super-armor stats, which I’ve been meaning to do but haven’t gotten around to. ---
**Author:** ![Wally](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Wally](https://forums.fatsharkgames.com/u/Wally)\ **Post date:** [August 26, 2018, 9:39am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/4 "2018-08-26T09:39:16Z")
How exactly did you calculate the new Headshot damage for non-AP weapons? I cannot, for the life of me, figure this out consistently. Especially in regards to how +headshot damage (namely bodkins) effects it. Cannot seem to find any consistent basis for it. Just asking since I’m trying to figure this out for my own monstrosity of a sheet and yet cannot pin down a good formula. ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [August 26, 2018, 10:09am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/5 "2018-08-26T10:09:05Z")
The values in the spreadsheet are calculated by calling into the game code itself. The damage values come from calling `DamageUtils.calculate_damage`, for example. I only have a dim understanding of the internals of that function. If you’re doing something similar I might be able to help you, but if you’re trying to reproduce the calculations yourself, I doubt that I can be of much use. ---
**Author:** ![doom\_hamster](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/doom_hamster/32/55388_2.png) [@doom\_hamster](https://forums.fatsharkgames.com/u/doom_hamster)\ **Post date:** [August 26, 2018, 11:17am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/6 "2018-08-26T11:17:31Z")
> [@SquattingBear](#): > > The charged attack on the drakefire pistols no longer has damage dropoff with range (possibly a bug). It was like that before * * * I’ve made a comparison sheet (1.1 -\>1.2b): > **[1.1 -> 1.2 beta](https://docs.google.com/spreadsheets/d/1Sjqu_vKiWtIpAcaZgQ7JEw1A07Qk5NFb0Wk0_emRdZ8/edit#gid=1451836907)** > > melee\_120b > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... In tabs that end with “\_compare”, the changes in 1.2b are highlighted with red font. Check dual dagger and dual axes charged attack damage vs monsters, its disgusting. Rep.pistol have ~x1.5 more damage on bullet spray headshot vs armored, nice. Also found one significant undocumented change - exec sword pushstab is buffed immensely, having completely different damage profile (similar to 2h sword charged). * * * To Bear: hope you’ll do super armor damage for 1.2 live! Also, it would be interesting to have push radius values for weapons (or push reach), since they buffed it in beta. ---
**Author:** ![Haxorzist](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/haxorzist/32/16921_2.png) [@Haxorzist](https://forums.fatsharkgames.com/u/Haxorzist)\ **Post date:** [August 26, 2018, 11:49am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/7 "2018-08-26T11:49:55Z")
> [@doom\_hamster](#): > > Check dual dagger and dual axes charged attack damage vs monsters, its disgusting. True > [@Haxorzist](#): > > Infiltrate monster dmg tier list: (no buffs, 600hp) > > 1. 383.5 dmg - Dual Daggers, Sword & Dagger > 2. 255.75 dmg - Two-Hander, Spear (this might be higher as it is suspiciously the old cap) > 3. 219 dmg - Dual Swords > 4. 150 dmg - Sword > 5. 121.5 dmg - Glaive > > Pre 1.2 list: > > ![](http://forums.fatsharkgames.com/user_avatar/forums.fatsharkgames.com/haxorzist/40/15880_1.png)[Melee weapon viability with kerillians weapons as examples](http://forums.fatsharkgames.com/t/melee-weapon-viability-with-kerillians-weapons-as-examples/26275/12) > > > Infiltrate monster dmg tier list: (no buffs, 600hp, rounded down) > > > > 1. 230 dmg - Dual Daggers, Sword & Dagger > > 2. 161 dmg - Two-Hander, Spear > > 3. 131 dmg - Dual Swords > > 4. 121 dmg - Glaive > > 5. 90 dmg - Sword > > Now while I do like the dmg boost on the other weapons I don’t think more then 250 unmodified ult dmg should be a thing. The maximum ult dmg bonus is 2x dmg vs & 2x crit power resulting in **+~50%** (40% crit power ~30% dmg) you clould also stack up barrage for +25% over the whole thing. > That gives you ~720 dmg on dual daggers and answers my question why I was able to 3-shot a boss. ---
**Author:** ![Wally](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Wally](https://forums.fatsharkgames.com/u/Wally)\ **Post date:** [August 26, 2018, 7:23pm UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/8 "2018-08-26T19:23:44Z")
Honestly I find it rather odd they’d increase DD monster damage at all. ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [August 29, 2018, 6:25am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/9 "2018-08-29T06:25:14Z")
An updated spreadsheet for 1.2 is here: > **[Vermintide 2 Stats (1.2)](https://docs.google.com/spreadsheets/d/1LGJtOs_ZZag-QGxM6vtjkGsVXuJqXGs0NAuPMIrqrbo/edit?usp=sharing)** > > melee > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... I’ve added numbers for damage against superarmor and melee attack reach, as requested by [CommissarTyr](http://forums.fatsharkgames.com/u/CommissarTyr) and [doom\_hamster](http://forums.fatsharkgames.com/u/doom_hamster). These are entirely untested though, so take them with a grain of salt. ---
**Author:** ![doom\_hamster](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/doom_hamster/32/55388_2.png) [@doom\_hamster](https://forums.fatsharkgames.com/u/doom_hamster)\ **Post date:** [August 30, 2018, 5:43pm UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/10 "2018-08-30T17:43:21Z")
Comparison weapon sheet 1.1 -\> 1.2 : > **[1.1 -\> 1.2](https://docs.google.com/spreadsheets/d/1iavLJzFzbHfWNGbrAHBvqAC9ndviS3OXoNSb4NLaZpA/edit?usp=sharing)** > > melee\_120 > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... In tabs that end with \_compare, the changed values are highlighted with red font. Had to remove super armor from each attack to compare. ---
**Author:** ![doom\_hamster](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/doom_hamster/32/55388_2.png) [@doom\_hamster](https://forums.fatsharkgames.com/u/doom_hamster)\ **Post date:** [September 3, 2018, 7:04am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/11 "2018-09-03T07:04:46Z")
Found out that hagbane have incorrect damage for this attack: **shoot charged (explosion damage)** sheet shows: | unarmored | 2.828125 | | --- | --- | | armored | 0 | | large | 4.2421875 | | player | 2.828125 | | berserk | 2.828125 | | superarmor | 0 | should be: | unarmored | 0.99 | | --- | --- | | armoured | 0 | | large | 1.48 | | player | | | berserk | 0.99 | | superarmor | 0 | ^numbers from trawnarch’s calc It was wrong before in 1.1 sheet, but beside that i haven’t noticed more incorrect numbers ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [October 25, 2018, 12:34am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/12 "2018-10-25T00:34:22Z")
Here’s a version for the balance beta: > **[Vermintide 2 Stats (1.2 balance beta)](https://docs.google.com/spreadsheets/d/1lyQRgFqwvwfqcjN0WuvwFopdLMqBFyOkgil3WV4tLjo/edit?usp=sharing)** > > melee > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... The Sword and Dagger is now using different damage profiles for left and right hands in its heavy attacks (presumably because one’s holding a sword and the other a dagger). I’m just adding the numbers together for the damage. For the cleave, I’m taking the right hand values only, which is pretty dodgy but I can’t think of anything better that isn’t too complicated. ---
**Author:** ![doom\_hamster](https://dub1.discourse-cdn.com/flex013/user_avatar/forums.fatsharkgames.com/doom_hamster/32/55388_2.png) [@doom\_hamster](https://forums.fatsharkgames.com/u/doom_hamster)\ **Post date:** [October 25, 2018, 9:44am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/13 "2018-10-25T09:44:33Z")
On melee sheet, there’s 5 new rows added, with a new attack: **light attack bopp (DoT damage)** on Flaming Sword. After the Flaming Sword, the thick borders that separate weapons - they’re off, and the last 5 rows associated with halberd charged attack - have no attack name. * * * I’ve made comparison sheet from 1.2 to 1.2 BBB: > **[1.2 -\> 1.2\_BB(Balance beta) -\> 1.2\_BB\_u1(Balance beta update 1)](https://docs.google.com/spreadsheets/d/1xqFnt8Gdpdl34oTcDC_eN_7Hyd00MsnVwc1ueDzCpD4/edit?usp=sharing)** > > m\_120 > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... Inside a tab that have two versions in the name, the changed values are highlighted with red font. * * * UPD: made comparison sheets for 1.2 BBB update 1. ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [October 26, 2018, 1:34pm UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/14 "2018-10-26T13:34:33Z")
> [@doom\_hamster](#): > > After the Flaming Sword, the thick borders that separate weapons - they’re off, and the last 5 rows associated with halberd charged attack - have no attack name. Thanks, I’ve fixed it in a new version that also has the values from the latest update of the beta: > **[Vermintide 2 Stats (1.2 balance beta u1)](https://docs.google.com/spreadsheets/d/1jDdhOLKKwnXn3Q6TrrL55IesWjTW8uINAzgtBXrKTac/edit?usp=sharing)** > > melee > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For... This one also has some extra info for the new and improved “shield slam” attacks in the beta. ---
**Author:** ![SquattingBear](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@SquattingBear](https://forums.fatsharkgames.com/u/SquattingBear)\ **Post date:** [November 28, 2018, 7:51am UTC](https://forums.fatsharkgames.com/t/damage-spreadsheet-for-1-2/26593/15 "2018-11-28T07:51:35Z")
I’ve updated the spreadsheet for v1.3 of the game - you can find the new version here: > **[Vermintide 2 Stats (1.3)](https://docs.google.com/spreadsheets/d/1YAg9z2Sacl42qKn8sOQlMp5lF1mKNrd87VIkz9boUKQ/edit?usp=sharing)** > > melee > > Hero Power Level:,600,Difficulty:,Legend,Values:,Raw,Power Multiplier:,1.000 > Mass Limit,Mass Mod or > DoT Info,# Targets,Damage (target 1 override),Stagger,Damage (target 2 override),Stagger,Damage (target 3 override) > Weapon,Attack,For...