Weapon damage calculator

[Es78]

Welcome to my weapon damage calculator.
This is basicaly a google sheets that makes you calculate your ship damage against another ships, based on what equipment, races, building, weapons you and your enemy have. It´s also a great way to decide what weapons you wanna focus on depending on your race and tactics.
There is a small guide in the sheet, to explain what you need to fill out and what it does.
Hope you will have fun and great use of it.

There is also a data sheets, with all my calculations. I have locked it. But send me a PM if you want acces to it, only wish to improve it as much as possbile.
Also let me know if i have missed anything there is alot of manuel inputs and i still find weapons that i have missed, stats that i have miss typed and so forth.
This guide does not include PD weapons, fighters and bombers
Link to the sheet can be found here
https://docs.google.com/spreadsheets/d/ ... sp=sharing
When the Sheet is open in Google sheet. Go to files and make a copy. Then you can begin to use the sheet

Weapon damage calculator.PNG (156.32 KiB) Viewed 4377 times

Updated the sheet to display No shields and No armor if they are not on the ship.
Also updated the damage calculation if this happens. Had some errors on weapons with negativ penetration values.
You will now see the following displayed

update.PNG (3.51 KiB) Viewed 4126 times

[Es78]

I have a few questions that i havent figured out yet. Hope anyone out there can help

Damage reduction to hull
Damage redution how does it work excately you can get 70% from components + 40% from races =110% That way you should never get any damage to your ship. But that ain´t true.
Under ship design you can get the 70% I presume that a flat 70% damage reduction to your hull, But that races. How are they added ?
We have
Mortalen 10%
Teekan 10%
Ikkuro 20%

Shield damage reduction
If shields fails and damage goes through. Will it still be reduced by the shields resistance ?
Weapons that have a negative shield bypass values on weapons, will the damage be reduced by this value, if the shield fails and the weapon have a negative value here ?
Example will be a T4 Talassos shield. It has a 10% shield penetratin chance with a 35% shield penetration value and shield resistance of 1.
And you use a T4 Epsilon Torped that has -40% shield Bypass.
If the shield fails will it let 35% of that damage go through, or will it be 35% of the damage reduced by the -40% from the missile. Or will the reduction of damage just be 35-40 = 5% ?
In this calculation i have gone with the -5% as it seemed the most logical, but i am not sure.

Range and to hit chance
Some weapons have a to hit chance. How is this used ?
You have a Point blank accuracy and a max range accuracy. Thats fair simpel to figure out, but some weapons alos have a weapon targeting stat. Like the T2 Rail gun where it have
Weapon targeting -10%
Point blank acc 72% and
Max range acc of 36%
In this calculation i have just changed it to 62% and point blank and 26% on max range. Plus ship targeting - Defending ship counter meassures.
Also how does a bonus to weapon range from admiral and ships maily battleships and bases, impact on the weapon hit chance ?
Will the above Max range acc of 36% for a T2 rail gun just be extende to the new max range.
Lets say you place a T2 Rail hun on a space port that adds 100% range.
The rail gun has a 36% hit chance at 880 range, but now it gets a new range of 1760, will it then be 36% at this new range (What i am using so far) or will it diminish by 76-36=36% per 880, so at 1760 range it will be -4 %

[frankycl]

Hey, that's a super-nice idea - and a great piece of work, too.
Many thanks for sharing this.

Also: I think you could/should post this in the modding-sub-forums, too... - I guess many modders will love this, too.

EDIT: Your sheet has 13 pages (for download) but only 2 are used - why this ??

[Es78]

Thanks
Never shared a dokument like this before. Are you able to save it as your own and edit it and there by Change weapons, equopment ... ?
Can only see it as owner, so hard to see how you see the sheet.
13 pages ? There are 2 pulbic sheets and a hidden data sheet

[Thineboot]

You've done more than I did in Excel, I've only calculated all weapons.

[...]
There is also a data sheets, with all my calculations. I have locked it. But send me a PM if you want acces to it, only wish to improve it as much as possbile.
Also let me know if i have missed anything there is alot of manuel inputs and i still find weapons that i have missed, stats that i have miss typed and so forth.
This guide does not include PD weapons, fighters and bombers
[...]

Unfortunately your Data sheet can't be downloaded or is lost during repair.

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Records: Formula from /xl/worksheets/sheet1.xml part
Removed Records: Formula from /xl/worksheets/sheet3.xml part

If you have Excel go to Data, Get Data, From File, From XML, Import, Transform Data. Remove unnecessary columns, expand tables where necessary aso, you know what you're looking for. That way you won't miss any weapons or hulls and updates will be easy, too.


@13 pages... that's most likely a PDF - it shows 13 pages

[Es78]

Alright i have have unhidden the data sheet. But its stil locked for editing. Not sure that excel can use it. There is some nasty special features in it that i am not sure excel can handle. But let me know.
I have also tried playing a bit around with the permission in the main sheet. Sadly i can´t see the sheet as a non owner. So need some feedback to know that you can use it or just copy the sheet and edit the cells.

[Es78]

You've done more than I did in Excel, I've only calculated all weapons.

Thats also how i started, and well wasent satisfied, so added just a bit more, that opened op for even more. you know how it goes
But i can say one thing, if I today knew how much work there was in this, I wouldent have started doing it. But now it´s done. Though I have a few idears for improvements.

[Thineboot]

Nope, still not working. But Data Sheet will be downloaded.

Check out A291:I311, but that's probably only added for some tests.

B125, ArrayFormula, I guess this is filling in the values in B126:B145, isn't compatible with Excel. Quick lookup: Array Formula: How It Differs in Google Sheets and Excel. A first fast check shows Replicate Google spreadsheet array formula in Excel, but no answer was upvoted, so I guess I have to dig deeper.

[...] Sadly i can´t see the sheet as a non owner. [...]

Either use a private window or another browser without automatically logging into google.

[Es78]

Nope, still not working. But Data Sheet will be downloaded.

Check out A291:I311, but that's probably only added for some tests.

B125, ArrayFormula, I guess this is filling in the values in B126:B145, isn't compatible with Excel. Quick lookup: Array Formula: How It Differs in Google Sheets and Excel. A first fast check shows Replicate Google spreadsheet array formula in Excel, but no answer was upvoted, so I guess I have to dig deeper.

[...] Sadly i can´t see the sheet as a non owner. [...]

Either use a private window or another browser without automatically logging into google.

Aye those lines were just made for testeing, in the beginning i thought i could make it all in one sheet. But nope it got way to big, and yes i had to do alot of testing with Arrayformula and especialy vlookup, not something that i have used before.
I am an old excel user, but don´t have it anymore. So googlesheet it is.
If you can adapt it to excel let me know and ill be happy to place a link to it in the top post. The more that can use it the better.

The ArrayFormula and Vlookup is the main feature in this sheet, as its used to look up in x rows and y collums and find z value and for the weapons multiple values out from a name or number. So you can use the drop down lists for equipment and get the needed data.

Got my working PC and crated a random googleacount. When the sheet is open, go to files and make a copy, then the sheet can be used.

[Thineboot]

You've done more than I did in Excel, I've only calculated all weapons.

Thats also how i started, and well wasent satisfied, so added just a bit more, that opened op for even more. you know how it goes
But i can say one thing, if I today knew how much work there was in this, I wouldent have started doing it. But now it´s done. Though I have a few idears for improvements.

Yes, I know... and I know... which is why I stopped at some point
Still appreciate the time you've invested and would gladly help out with data and/or point out how you could do it yourself.


I forgot to add: importing XML in Excel works on your system. Doing the same in google docs is possible via hyperlink... Therefore I'd stick to Excel and copy'n'paste the necessary extracted data into a google sheet. Those values aren't changed every other day. And any modder can do the same with a copy of your work for himself.

[Thineboot]

[...] But nope it got way to big, and yes i had to do alot of testing with Arrayformula and especialy vlookup, not something that i have used before.
I am an old excel user, but don´t have it anymore. So googlesheet it is.
If you can adapt it to excel let me know and ill be happy to place a link to it in the top post. The more that can use it the better.
[...]

So data it is I could provide right know.

I'll give it a try. While ArrayFormula works very differently, it shouldn't be the only way to do proper lookups in google spreadsheets...

Maybe we should leave the forum thread, not everyone will be interested in our chit-chat

[frankycl]

Your sheet works fine for me in Chrome - but when I try to download it as PDF it shows 13 pages for the main-sheet, 6 pages for the guide (wich is normal/fine) and over 100 pages (!) for the data-sheet (it's the width I guess )
...However I can limit this a bit by manually setting the pagebreaks.

... and when trying to download it as XML (or ODS) Excel tells me that there's a problem and that not all of it
can be imported (and I guess it has to do with the graphs on the main-sheet - because those don't show up at all. )

[Es78]

Your sheet works fine for me in Chrome - but when I try to download it as PDF it shows 13 pages for the main-sheet, 6 pages for the guide (wich is normal/fine) and over 100 pages (!) for the data-sheet (it's the width I guess )
...However I can limit this a bit by manually setting the pagebreaks.

... and when trying to download it as XML (or ODS) Excel tells me that there's a problem and that not all of it
can be imported (and I guess it has to do with the graphs on the main-sheet - because those don't show up at all. )

Well i makes no sence to use in a PDF as you are to input data, which a pdf can´t handle. Other programs besides google sheet, might not convert the formulars used properly, so my advise is to use google sheet.

[frankycl]

Well i makes no sence to use in a PDF as you are to input data, which a pdf can´t handle. Other programs besides google sheet, might not convert the formulars used properly, so my advise is to use google sheet.

Well, not all of it requires input - so it's a nice overview for me, anyway (since I might want to use it in the far future, too... - and I do have stored the link to the online-sheet as well ).

(and when it's perfect/final I might also store the web-site as a whole - so that I can use it, even when your sheet is offline, again. )

[Es78]

Now this is fun, would never have thought of this ship design. Newer used area bombs before. But my god the damage is insane for tier 2 tech. 2-3 of these frigates wipes out a destroyers in one volley and you dont even have to think about PD weapons the Intimidator surge blast will do that for you as well. Infact it´s proberly the best PD weapon out there, taking out a whole squadron of fighters in one volley.
Currelty winning a war against the teakens very early on just spamming these lovely cheap frigates.
Hope you can find some nice cheaky deigns aswell.

[Nightskies]

Something is wrong with torpedoes vs shields calculations. It appears it is adding damage somewhere, observed when there are no shields to damage. It seems other weapons appropriately do 0 damage to shields in that case. And when there are shields, they're doing a multiple more than they should.

It also appears that the calculations against armor is always assuming shields are not overcome- so it doesn't account for the attacking ship's true effectiveness against armor unless the weapon *is intended to penetrate shields enough to bring down structure or armor first. I see that Data Sheet O:14 is left blank, the spot that shield regeneration would be included. Would really like to see an estimation to take the target down through shields, hull and armor as they're repaired and regenerated.

[Es78]

Something is wrong with torpedoes vs shields calculations. It appears it is adding damage somewhere, observed when there are no shields to damage. It seems other weapons appropriately do 0 damage to shields in that case. And when there are shields, they're doing a multiple more than they should.

It also appears that the calculations against armor is always assuming shields are not overcome- so it doesn't account for the attacking ship's true effectiveness against armor unless the weapon *is intended to penetrate shields enough to bring down structure or armor first. I see that Data Sheet O:14 is left blank, the spot that shield regeneration would be included. Would really like to see an estimation to take the target down through shields, hull and armor as they're repaired and regenerated.

Thanks for the input it much appriciated. Did´t think of a scenario where there were no shields.
I have updated the calculator to dispkay No shields and No armor if they are not pressent. Also updated the damage calculation in those scenarios.
You will now see this if they are not pressent.

update.PNG (3.51 KiB) Viewed 4128 times

Regarding the calculation to see how long it will take to bring down a ship, it´s on my todo list, but it´s a quite a big project but i have some idear´s how to do it.

[Nightskies]

I'd recommend doing a simplified estimation, no matter how crude. Since DW2 gets bogged down as more entities populate the galaxy, it takes shortcuts. Even entities on screen will not precisely take damage; I've seen carriers lose shields and then sit on maximum armor for over 10 seconds, defying focused fire and then suddenly start taking appropriate damage- and it occurs frequently. Fighters may not deploy (but are simulated) until the screen is on the fighter-carrying entity.

And, since there are a lot of uncertainties, such as whether or not shield resistance is applied when shields are "0" (probably representing <0). Hence why all your questions are unanswered. We just don't know for sure exactly how it works, and in some cases, if it works at all. Did you know that a hit against armor can damage structure or components, regardless of its armor penetration rating?

Yeah, I don't know exactly how that works either, just that it works. Given all the unknowns, a crude estimation is fine.

[Nightskies]

Discovered that the current version as of 8/11/22 does not account for decreased accuracy beyond point blank range, but once included, appears to be accurate.

[Es78]

It should include decreased at range. Just checked that i did´t broke the formulars. Try adding some targeting bonus to the admiral and you will see that the damage over range will increase.
Regarding the ship damage calculator you asked for, i will try and look into it next week. Will do some testing before that, as i still have some mechanics that i need to check ingame.