| Pages: [1] 2 3 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Ebedar
Gallente
Primary Intelligence
   |
Posted - 2007.03.26 20:11:00 -
[1]
I've been working on a spreadsheet for the last month or so, which I've now decided to make public. In short, it 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
- 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
- work out the speed and optimal range of drones (where applicable) based on your skills
I know there are web pages that offer similar functions, but I also know the value of having your own spreadsheet with such information.
There are certain features that I would like to implement, but that I don't currently have a nice way of doing so, so I'm releasing this as it is and I may update it at a later point in time.
You can download the Drone Calculator from here.
Hope you find it useful.
Drone Calculator |
KaptnSparrow
Caldari
TARDZ
Gods of Night and Day
|
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!
...eve's worst pirate...
...if I missed killmails of the past, please update the killboard! |
Sanzorz
Amarr
EVEfan.dk
|
Posted - 2007.03.27 08:54:00 -
[3]
Great, was wondering what damage my drones did ^^
---
Currently flying a PvE geared Crusader and Prophecy |
Raekone
|
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
Eve Defence Force
Pure.
|
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.
Drone Calculator |
Robbie Boozecruise
Caldari
Eve Defence Force
Pure.
|
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.
Drone Calculator |
PCX339
Beasts of Burden
YouWhat
|
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
0utbreak
|
Posted - 2007.03.27 21:14:00 -
[11]
Really slick spreadsheet Ebedar. Nice work went into this.
"...Amateurs do it until they get it right, Professionals do it until they can't get it wrong..." |
Robbie Boozecruise
Caldari
Eve Defence Force
Pure.
|
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.
Drone Calculator |
Rinaldo Titano
Caldari
Domus Fatalis
X-PACT
|
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.
Drone Calculator |
Rinaldo Titano
Caldari
Domus Fatalis
X-PACT
|
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.
Drone Calculator |
Gene Wolfe
|
Posted - 2007.03.28 18:41:00 -
[18]
Very nice work.
|
Simon Jax
Gallente
Freedom Guard
Curse Alliance
|
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, ...)
--Wherever you go, there you are.
|
Revolution Rising
Venture Research and Resources
|
Posted - 2007.03.28 20:10:00 -
[20]
Can someone make this a program? I don't have xl :(
Rev.
CEO Venture Research and Resources.
VRR Homepage |
|
|
Kazuo Ishiguro
|
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.
------
Top speed calculation spreadsheet - updated for the recent speed nerf :) Army of doom headcount: 26,045 |
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.
Drone Calculator |
Khaladan
Ministry of War
|
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 
MuHaHaHaaaa |
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.
Drone Calculator |
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.
Drone Calculator |
Cyrilmak
Gallente
Skill Level Six
Ground Zeero
|
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
The Aduro Protocol
|
Posted - 2007.04.05 15:40:00 -
[27]
HOT DISH!
Thank you thank you thank you thank you
_________________
Burn. |
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.
Drone Calculator |
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.
Drone Calculator |
Heckelgruber
|
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 :: one page |
| First page | Previous page | Next page | Last page |