DPM Excel sheet

Talk about Battlefleet Gothic: Armada here!
Demoulius
Posts: 690
Joined: 16 February 2016, 08:15
Contact:

DPM Excel sheet

Postby Demoulius » 16 March 2016, 13:32

Hi all,

Not sure if this works, never really use my google drive :oops: I made an Excel sheet for the DPM yesterday. Included a graph for range and armor effects that they have on this. Id like to share it with you. Would like some feedback if the numbers are ok and if people find this format easily read...

Here is the link: https://drive.google.com/file/d/0Bz7WU3 ... sp=sharing

Looking forward to feedback :mrgreen:

EDIT- Chaos fleet added up until Heavy cruisers. Adjusted terminology to fit with ingame terms a little better.
EDIT2 - Battleships added. Some data still missing. Continuing on tomorrow.
EDIT3 - Chaos ships with TT weapons added in the 3rd tab. Also added the Despoiler.
EDIT4 - TT values normalized for the 3rd tab. Weapons normalized in an equal fashion to the IN.
EDIT5 - Orks added. Chaos fleet changed to their new weaponry.
Last edited by Demoulius on 27 March 2016, 11:32, edited 6 times in total.

VanHoven
Posts: 465
Joined: 13 March 2016, 19:49
Contact:

Re: DPM Excel sheet

Postby VanHoven » 16 March 2016, 14:07

Hey, thanks for your work, very nice information and easy to access and compare.

I don't like to be that guy, but I've found some mistakes :) The light macro turret fires 2 shots every 3 secs per turret, you got that right on the sword, but not on the firestorm and cobra.

And you can discuss if you should give torpedos 1 shot per minute or 1.3, since their cooldown is 45 seconds. especially for them it makes a big difference for damage over time, its 30% higher that way :D Same with Nova Cannon.

The only other weapon systems affected are the 9 sec cooldown lances on some chaos ships, but being accurate here with fractions won't change much.

And maybe including an info that the damage of the batteries is per broadside and not in total?

But again, thanks and very nicely done.

VanHoven
Posts: 465
Joined: 13 March 2016, 19:49
Contact:

Re: DPM Excel sheet

Postby VanHoven » 16 March 2016, 14:11

Do you want the other IN weapon stats to complete the compilation or do you have them and didn't have the time to include them?

Demoulius
Posts: 690
Joined: 16 February 2016, 08:15
Contact:

Re: DPM Excel sheet

Postby Demoulius » 16 March 2016, 14:30

When a weapon fires a number of shots with digits I dont include that, I only included whole numbers. Did this because you cant fire half a volley :lol: Could add them though if people want?

Also not sure on what range ordenance bays have and what the arming range on torps is, hence why they currently have no damage listed.

Dont be afraid to be 'that guy' as im the one who asked for feedback myself :mrgreen: Good catch on the light macro turret data beeing incorrect! The Cobra's data is correct though. It only has a single turret firing 1 shell. The model has 2 barrels but the data doesent confirm this. Unless the ingame tooltip is incorrect? :shock:

I corrected the data on the Firestorm. I would indeed appreciate the data for the overlord and the 2 battleships. I started leveing the battlecruiser and would hate to dump it just to look at the data on the Overlord. :oops: Im halfway through the Chaos fleet but still need battleships for those as well. So if you guys can provide I can complete the data :mrgreen:

VanHoven
Posts: 465
Joined: 13 March 2016, 19:49
Contact:

Re: DPM Excel sheet

Postby VanHoven » 16 March 2016, 14:52

You are correct on the cobra, but in my opinion it's a mistake because it's the exact same light macro turret as on the other escorts and the Light Cruisers.

Maybe include the info somewhere that the actual cooldown on torps and novacannon is 45 seconds then? i can see your point, but again, it's a 33% damage increase over time.

For the Overlord BC: 4 Macro Cannon Batterys, 2 per side, at 8 shots a 12 damage every 12 seconds per Broadside with a 12km range.
2 Lance Turrets with a 270° firing arc at 12 damage every 12 seconds each with 12k max range.
1 Prow torpedo launcher firing 6 torpedos

The Retribution BS: 6 Macron Cannon Batterys, 3 per side, at 12 shots a 12 damage every 12 seconds per Broadside with a 12km range.
3 Lance Turrets with a 270° firing arc at 12 damage every 12 seconds each with 12k mac range.
1 Prow torpedo launcher firing 8 torpedos.

The Emperor BS: 2 Macro Cannon Batterys, 1 per side, at 4 Shots a 18 damage every 12 seconds per Broadside with a 6km range.
3 Macro Cannon Turrets with a 270° firing arc, at 3 shots together a 18 damage every _6_ seconds (thats correct) with a 12km range.
4 Ordenance Bays, 2 per Broadside.
Special Perk: Has 10.000m observation range but only 50% prow armor.

The range of the ordenance is 12k, torpedo launchers are unlimited.
Last edited by VanHoven on 16 March 2016, 15:11, edited 1 time in total.

VanHoven
Posts: 465
Joined: 13 March 2016, 19:49
Contact:

Re: DPM Excel sheet

Postby VanHoven » 16 March 2016, 15:02

And for the Chaos Battleships:

Desolator: 6 merged weapon batterys, 3 per broadside, with 4 macro cannons and 2 lance turrets each (i strongly suspect that they have 2 attacks per turret and not only 1 as the tooltip suggests), the macro cannons, 12 in total per side, at 3 damage each every 6 seconds with a max range of 12k, the lances at 3 damage every 6 seconds with a max range of 12k, when i'm right with 12 shots, if not 6.
Prow torpedo launcher with 8 torpedos.

Despoiler: 4 heavy macro cannon batterys, 2 per side, with _12_ batterys each at 3 damage every 6 seconds and a max range of 12k.
2 heavy macro cannon batterys, 1 per side, with _4_ batterys each at 3 damage every 6 seconds a max range of 12k.
3 top mounted prow lance batterys with a 270° firing arc with 2 attacks each at 4 damage every 8 seconds and a max range of 12k.
1 prow super heavy lance battery with a 90° firing arc to the front with 4 attacks at 8 damage every 8 seconds and a max range of 12k.
3 ordenance bays in total, 1 per broadside and 1 in the prow.

VanHoven
Posts: 465
Joined: 13 March 2016, 19:49
Contact:

Re: DPM Excel sheet

Postby VanHoven » 16 March 2016, 15:06

My reasoning behind suggesting that the Desolator lance turrets have 2 attacks each is that otherwise their dps would be very low. the despoiler has 7 lance dps in his front arc and much more macro cannon dps. with only 1 attack per turret the desolator would have a lance dps of 3,5 which seems very low to me.


what is interesting to me is that the emperor has a higher macro cannon dps on his broadside including his turrets than the retribution (12 dps for retribution and 15 dps for emperor), but it has 3 lance dps. in terms of raw firepower it's about equal. than you get 8 prow torpedos or 4 ordenance bays. torpedos CAN be good if you manage to hit a broadside of an enemy ship with most of your salvo. but thats tougher to manage than it sounds. if the enemy is taking care he can just turbo thrust his ship in the way of the attack, make it that only 1 or max 2 torpedos will hit, and than also turret fire will occure.

comparable with the chaos bs: you get roughly the same lance dps, but the despoiler has roughly 3 times the macro cannon dps. and again you trade ordenance bays for a 8 tube torpedo launcher.

All in all I think the IN BS are closer to each other, but due to the fact that macro cannons are not that usefull beyond 6k range in my opinion the retribution is gimped by having only 12k range broudsides. if he had 6km range 18 dmg a 12sec batteries he would be a brawling monster as described in the lore :)
Last edited by VanHoven on 16 March 2016, 15:22, edited 3 times in total.

Demoulius
Posts: 690
Joined: 16 February 2016, 08:15
Contact:

Re: DPM Excel sheet

Postby Demoulius » 16 March 2016, 15:20

Argh I was just done with all the info I had! :lol:

Gotta say the numbers on the Chaos fleet are...enlightening...

I will update the link in my OP and continue tonight. Right now I need to do some gaming :mrgreen:

Jectulg
Posts: 226
Joined: 14 February 2016, 18:50
Contact:

Re: DPM Excel sheet

Postby Jectulg » 16 March 2016, 15:34


Demoulius
Posts: 690
Joined: 16 February 2016, 08:15
Contact:

Re: DPM Excel sheet

Postby Demoulius » 16 March 2016, 16:30

Alright played a few games so back to the Excel sheet :mrgreen:

Could you explain the Despoiler?
Despoiler: 4 heavy macro cannon batterys, 2 per side, with _12_ batterys each at 3 damage every 6 seconds and a max range of 12k.
2 heavy macro cannon batterys, 1 per side, with _4_ batterys each at 3 damage every 6 seconds a max range of 12k.
3 top mounted prow lance batterys with a 270° firing arc with 2 attacks each at 4 damage every 8 seconds and a max range of 12k.
1 prow super heavy lance battery with a 90° firing arc to the front with 4 attacks at 8 damage every 8 seconds and a max range of 12k.
3 ordenance bays in total, 1 per broadside and 1 in the prow.

It sounds like it has 5 segments compared to the 3 that the other battleships have :shock: could you please put in a different format?


Return to “General Gameplay Discussion”

Who is online

Users browsing this forum: No registered users and 4 guests