open All Channels
seplocked Ships and Modules
blankseplocked Drone Calculator (final version released 13 June 2007)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3

Author Topic

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.26 20:11:00 - [1]
 

Edited by: Ebedar on 13/06/2007 19:27:52
This spreadsheet is one I have worked on over a period of time, which I have made available to the public. My thanks go out to Merdekka Radaen for helping me to test various EW drones so that I could confirm stacking penalty effects. The stacking penalty formula used is not the official one (since CCP haven't made that available) but the one developed by Akita T.

The spreadsheet should allow you to do the following:

- work out the DPS* of your drones, based on your skills and relevant ship bonuses
- work out the DPS* of your fighters, based on your skills and relevant ship bonuses
- insert the number of drones/fighters of a particular type that you're using to see the total DPS* they put out
- see how resistance affects your DPS*
- work out your drone range based on skills, ship bonuses and modules
- calculate your probability of jamming a target with ECM drones given the target sensor strength
- see how sensor dampening drones affect a target's range and scan resolution
- see how target painting drones affect a target's signature radius
- see how tracking disrupting drones affect a weapon's tracking and optimal range
- see how web drones affect a target's speed
- work out the speed of drones (where applicable) based on your skills and also how Drone Navigation Computers affect drone MWD speed
- work out the optimal range and tracking of drones (where applicable) based on your skills and also how Omnidirectional Tracking Links affect optimal/tracking values

I know there are web pages that offer similar functions, but I also know the value of having your own spreadsheet with such information.

You can download the Drone Calculator from here. If you don't have Excel, then the spreadsheet will still work using the relevant software from OpenOffice (confirmed by users who have replied to this thread).

Hope you find it useful.

* DPS values are theoretical - in actual combat situations they will obviously vary depending on factors such as speed and tracking.

KaptnSparrow
Caldari
Posted - 2007.03.27 07:16:00 - [2]
 

nice and usefull.

but can you put somewhere the ammount of drones you have? Cause some ships can't fit 5 drones. So it would be nice if its better to have 5 x medium drones or 4 x heavy drones

(ok i could do the math my self)

thx and keep it up!

Sanzorz
Amarr
Mark Of Chaos
Posted - 2007.03.27 08:54:00 - [3]
 

Great, was wondering what damage my drones did ^^

Raekone
Absolut Profit
Posted - 2007.03.27 09:23:00 - [4]
 

Nice one.

Question though, I enter carrier (thanatos) 4 and fighters 4, and I get about 108 dps from fighters... is that from each fighter? Because that would mean one carrier can do literally thousands of dps.



Robbie Boozecruise
Caldari
FDF Industries
Hedonistic Imperative
Posted - 2007.03.27 09:59:00 - [5]
 

any chance you could put a box in for number of drone navigation computer fitted. i set up my domi for killing inties by fitting 5 drone links drone links to get my range up to 160km and fitting all my mids with drone navigation computer's to get the speed up

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.27 11:05:00 - [6]
 

Originally by: KaptnSparrow
can you put somewhere the ammount of drones you have? Cause some ships can't fit 5 drones. So it would be nice if its better to have 5 x medium drones or 4 x heavy drones

Sure, I'll try to implement a nice way of doing that. I left it out initially because the 'simple' way of doing it would just show you the drone damage for 5 of the same drones. I think I can modify it to show how a mix of drones works too, so I'll try to add that.

Originally by: Raekone
Question though, I enter carrier (thanatos) 4 and fighters 4, and I get about 108 dps from fighters... is that from each fighter? Because that would mean one carrier can do literally thousands of dps.

Yes that sounds right. You get 80% more damage from the Fighters skill and 20% more damage from the ship skill.

Originally by: Robbie Boozecruise
any chance you could put a box in for number of drone navigation computer fitted. i set up my domi for killing inties by fitting 5 drone links drone links to get my range up to 160km and fitting all my mids with drone navigation computer's to get the speed up

Let me look into this. I need to find out whether there is stacking involved with the computers - if there is, it adds a different set of problems, but I'll see what I can find out.

Robbie Boozecruise
Caldari
FDF Industries
Hedonistic Imperative
Posted - 2007.03.27 18:55:00 - [7]
 

Originally by: Ebedar

Originally by: Robbie Boozecruise
any chance you could put a box in for number of drone navigation computer fitted. i set up my domi for killing inties by fitting 5 drone links drone links to get my range up to 160km and fitting all my mids with drone navigation computer's to get the speed up

Let me look into this. I need to find out whether there is stacking involved with the computers - if there is, it adds a different set of problems, but I'll see what I can find out.


thank you

VanNostrum
Posted - 2007.03.27 19:02:00 - [8]
 

Edited by: VanNostrum on 27/03/2007 18:58:48

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.27 21:07:00 - [9]
 

Originally by: Robbie Boozecruise
any chance you could put a box in for number of drone navigation computer fitted. i set up my domi for killing inties by fitting 5 drone links drone links to get my range up to 160km and fitting all my mids with drone navigation computer's to get the speed up

Ok, I played around with the Drone Navigation Computers and despite the description on the module, the speed increase it gives is actually a percentage value (25% speed increase). However, they're also subject to stacking, which is an issue for me in more than one respect at the moment as regards the spreadsheet. Insofar as figures go, you'll find:

The 1st DNC gives a 25% speed boost.
The 2nd DNC gives a 21.728% speed boost.
The 3rd DNC gives a 14.265% speed boost.
The 4th DNC gives a 7.074% speed boost.
The 5th DNC gives a 2.65% speed boost.

Those are worked out using Akita T's stacking formula (since the devs won't make the official one available).

In terms of working out how that affects your drone speed, you would use:

drone speed x 1.25 x 1.21728 x 1.14265 x 1.07074 x 1.0265

I'll keep tinkering with the spreadsheet and see if I come up with a way of implementing such things that makes me happy. In the meantime, the above should help you to work it out the old fashioned way.

PCX339
STK Scientific
Posted - 2007.03.27 21:11:00 - [10]
 

To the OP: nice work and nice responses to people. Two thumbs up.

To Robbie B (quoted below): Holy Smokes! That must be something to see! I think I'll fit my domi like that and chase some corpmates just to see what 5 warrior IIs with 5 drone nav computers look like. Do you need omnidirectional tracking links if you want to actually hit though?? :)

Originally by: Robbie Boozecruise
any chance you could put a box in for number of drone navigation computer fitted. i set up my domi for killing inties by fitting 5 drone links drone links to get my range up to 160km and fitting all my mids with drone navigation computer's to get the speed up

Alex Under
H A V O C
Against ALL Authorities
Posted - 2007.03.27 21:14:00 - [11]
 

Really slick spreadsheet Ebedar. Nice work went into this.

Robbie Boozecruise
Caldari
FDF Industries
Hedonistic Imperative
Posted - 2007.03.28 10:19:00 - [12]
 

ok with 3x drone speed mods warrior ll get up to 11 km/sec which is fast enough for me

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.28 10:46:00 - [13]
 

Thanks for all the comments. I'll be uploading the version that works out total DPS (for a mixture of drones or fighters) later today.

Originally by: Robbie Boozecruise
ok with 3x drone speed mods warrior ll get up to 11 km/sec which is fast enough for me

Yeah, the extra two computers only just push them above 12 km/sec so you could probably use something else in those slots.

Rinaldo Titano
Caldari
Caldari Elite Force
Apocalypse Now.
Posted - 2007.03.28 11:28:00 - [14]
 

Edited by: Rinaldo Titano on 28/03/2007 11:25:51
Is this calculation spredsheet correct? just because with maxed skills i get from feighter just 5 DPS more than a OGRE II have

But other things seems work well, its a good job. Grat

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.28 11:34:00 - [15]
 

Originally by: Rinaldo Titano
Edited by: Rinaldo Titano on 28/03/2007 11:25:51
Is this calculation spredsheet correct? just because with maxed skills i get from feighter just 5 DPS more than a OGRE II have

I think you need to set the 10% damage/level value to 0: a max skill Ogre II only reaches 95.04 DPS if it is used on a ship that gives 10% drone damage per level and you have the skill to pilot the ship at level 5 (e.g. Gallente BS 5 and you're piloting a Dominix).

Without ship skills, the Ogre II does 63.36 DPS. Fighters do 100 DPS with max skills, before taking ship bonuses into account.

Rinaldo Titano
Caldari
Caldari Elite Force
Apocalypse Now.
Posted - 2007.03.28 13:05:00 - [16]
 

Yes, u right. My fault :)

But the part of what i wrote is right. The sheet is good Job and tnx that u shared with us

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.28 18:24:00 - [17]
 

Originally by: Rinaldo Titano
Yes, u right. My fault :)

But the part of what i wrote is right. The sheet is good Job and tnx that u shared with us

Thank you, I'm genuinely pleased that this has turned out to be useful for people.

I've uploaded the newest version now, which allows you to add the mixture of drones/fighters that you're using and to see the total DPS that results. I'll update the initial post to reflect that change.

Gene Wolfe
Posted - 2007.03.28 18:41:00 - [18]
 

Very nice work.

Simon Jax
Gallente
Battlestars
GoonSwarm
Posted - 2007.03.28 20:02:00 - [19]
 

Nicely done. One comment though. T2 Heavy Drones require Heavy Drone Operation V in order to fly them. Your stats show the DPS for T2 Heavies with <racial> Drone Spec IV regardless of Heavy Drone Operation V.

The Heavy Drone Operation requirement can be easily added to your existing formula using the "+" or command in your IF formula. i.e. =if((B10<4)+($F$6<5),0, ...)

Revolution Rising
Serenity Engineering and Transport Company
Fatal Ascension
Posted - 2007.03.28 20:10:00 - [20]
 

Can someone make this a program? I don't have xl :(

Rev.

Kazuo Ishiguro
House of Marbles
Posted - 2007.03.28 20:14:00 - [21]
 

You should still be able to open the file with openoffice, for free. It looks almost exactly the same as excel.

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.28 20:43:00 - [22]
 

Originally by: Simon Jax
Nicely done. One comment though. T2 Heavy Drones require Heavy Drone Operation V in order to fly them. Your stats show the DPS for T2 Heavies with <racial> Drone Spec IV regardless of Heavy Drone Operation V.

The Heavy Drone Operation requirement can be easily added to your existing formula using the "+" or command in your IF formula. i.e. =if((B10<4)+($F$6<5),0, ...)

Yeah, fair point. I'll add that into the next release.

And yes, it should (hopefully!) work in Open Office if you don't have Excel.

Khaladan
Amarr
GoonFleet
GoonSwarm
Posted - 2007.03.29 14:25:00 - [23]
 

I use the following Drone Calculator to do my calculations but I also use the following figures which have skills maxed out for drone and also has Ammar cruiser 5 to show what an Arbitrator can do damage wise.

Hammerhead ii damage is: 12 Thermal
Base damage modifier is 1.92, so: 12*1.92 = 23.04
Drone Interfacing 5 (+100% dmg): 23.04+23.04*1 = 46.08
Amarr cruiser 5 (10% each lvl?): 46.08 + 46.08*0.5 = 69.12
Combat Drone Operations 5 (5% each lvl?): 69.12+69.12*0.25 = 86.4
Racial Drone spec 10% (2% lvl?): 86.4+86.4*0.1= 95.04

for 5 drones, you get each 2 secs 475.2 damage (thermal)

so you get 237.6 damage each second


This is pretty awesome damage and with a decentish armor tank and NOS you can kill certain BCs .But not them all I run is I see certain BCs Embarassed

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.30 00:44:00 - [24]
 

Just to confirm that the next release will take into account pre-requisite skills for T2 drones of all sizes. I've also implemented a way to see how Drone Navigation Computers affect your drone MWD speed, as requested by Robbie Boozecruise. Hopefully I'll upload it within the next 24 hours.

Ebedar
Gallente
Primary Intelligence
Posted - 2007.03.30 15:18:00 - [25]
 

Latest version has now been uploaded.

As an aside, the top speed your drones are capable of is their MWD speed - the speed at which they move when they go to attack or (supposedly) return. Their orbit speed is different.

Cyrilmak
Gallente
Diversified Imperial Enterprises
Posted - 2007.04.05 03:31:00 - [26]
 

Excellent job m8, I luv you long time! lol.. Well anyways great tool m8. o/

Siigari Kitawa
Gallente
Perditus Peregrinus
Posted - 2007.04.05 15:40:00 - [27]
 

HOT DISH!

Thank you thank you thank you thank you

Ebedar
Gallente
Primary Intelligence
Posted - 2007.04.06 22:35:00 - [28]
 

Originally by: Siigari Kitawa
HOT DISH!

Thank you thank you thank you thank you

You're welcome.

The latest version has now been uploaded. It includes drop down boxes so you can select the skill level rather than having to type it in each time (though you can still type it if you prefer), as well as the tracking values for combat drones. I've also added a box so you can see how Omnidirectional Tracking Links will affect your drones' optimal and tracking values.

Ebedar
Gallente
Primary Intelligence
Posted - 2007.04.10 14:02:00 - [29]
 

The latest version has now been uploaded. This allows you to select up to 5 sensor dampening drones and shows how they will affect a target's range and scan resolution, taking into account the stacking penalty.

Took me a little while to get the interface laid out and working right, but it should all be in order.

Heckelgruber
Quam Singulari
Posted - 2007.04.10 15:22:00 - [30]
 

Thanks for all your hard work, a really useful tool. I'm gonna train myself a NOShkur :)


Pages: [1] 2 3

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only