These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Ships & Modules

 
  • Topic is locked indefinitely.
123Next page
 

Missile Damage vs Target MkII spreadsheet

Author
stoicfaux
#1 - 2013-04-30 04:07:35 UTC  |  Edited by: stoicfaux
Update: (May 17, 2013)
* version 1.1.1: Data fix for CNR Cruise II – Fury – 2xRigor2, Flare2 – Odyssey.
* version 1.1: Added implants. The PDFs have NOT been updated yet.
* version 1.0 of spreadsheet
- this includes a bug fix in the 0.2, 0.3 versions, in which the bottom row of the comparison sheet would select the top row's damage type. Minor but annoying.

Added the following PRE-GENERATED PDF REPORTS for your convenience! (You can see the results without messing with the spreadsheet.)
* cnr_flare_v_rigor_odyssey.pdf
* cnr_rigs_odyssey.pdf
* cnr_v_fleet_typhoon_odyssey.pdf
* cnr_v_typhoon_v_raven_v_fleet_typhoon_v_sni_v_golem_odyssey.pdf
* cruise_cnr_v_torp_golem.pdf
* raven_v_cnr_odyssey.pdf
* tengu_ham_v_hml.pdf

The reports and spreadsheet are available here: https://drive.google.com/folderview?id=0B_CLlTV8bSxNMFVrdXJFdFFqTDA&usp=sharing

The above reports will give you some idea of how the CNR, Raven, Typhoon, Fleet Typhoon, SNI, and Golem will compare after the Odyssey ship and cruise missile changes.


I have updated an old spreadsheet that lets you calculate the expected missile damage against various NPCs in terms of Volleys to Kill, Time to Kill, and Fractional Volleys to Kill. The spreadsheet also displays the two components of the missile damage formula (labeled as MF1 and MF2) to help you see the impact of rigor rigs, flare rigs, and TPs.

You will need to use EFT or PYFA to get the launcher and ammo stats entered into the Missile Profiles sheet.

It was written in LibreOffice 4.0.3.3.


The Comparison tab lets you compare six profiles (e.g. HAM Tengus versus HML Tengus) against multiple target ships. A basic selection of NPC ships has been pre-entered.

The Ships tab contains data from the last CCP database dump to contain NPC information. So no sleeper ships, but you can add the ships yourself.

You may get a macro warning. You can decline to run the macros and inspect them first via Tools -> Macros -> Organize Macros -> ... The only macro that should be there is one to calculate the value of multiple Target Painters which are subject to the stacking penalty.


The main reason for doing this was to get a basic handle on the HML versus HAM Tengu and to get an idea of the Cruise missile buff in Odyssey.

Things to consider:
* All skills at V.
* All ships use 4xCN BCUs.
* TP is PWNAGE.
* No implants.
* NPC shield and armor regeneration are not taken into account.
* I had to enter ship data by hand, but I'm mostly sure the data is correct.
* Assumes target are moving at Orbit speed


Tips and Tricks:
* Remember to set the # of TPs.
* The "fractional volleys to kill" will tell you how close you are to needed one less salvo, which can help justify using faction TPs or implants,
* You can "show" columns D through Z if you want to see the NPC ship stats
* By default, the best damage type is selected. You can override this via "Force Dmg Type".
* You can override the TP bonus via "Force Single TP Bonus". Use a value of 1.x, e.g. 1.3 for a 30% TP.
* MF1 and MF2 are the two components used by the missile damage forumla (http://oldforums.eveonline.com/?a=topic&threadID=901280)


NPC Ships chosen.
Firstly, you can choose your own set of target ships. You can also enter new ships (including PvP ships) on the ships sheet (be sure to sort the ships sheet.) The reports default to the following ships:
* Pith Eliminator - big slow battleship
* Gist General - "small" fast battleship

* Gistatis Tribunus - fast BC
* Pithatis Death Dealer - slow BC

* Pithum Annihilator - big slow cruiser
* Mercenary Commander - small fast cruiser
* Arch Gistum Centurion - fast elite cruiser

* Angel Viper - really annoying elite frigate that webs and scrams and which drones take forever to kill


Remember, with the great "Odyssey: Missile Battleship Homongenization" in which all battleships now have eight effective launchers[1], your choice of missile platform will depend on drones (e.g. Fleet Typhoon), armor or shield tank, utility slots, fitting restrictions, etc., instead of Raw Misisle DPS.


[1] Well the Fleet Typhoon now has 8.25 effective launchers...

Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

stoicfaux
#2 - 2013-05-14 15:28:41 UTC
Here's a PDF comparison with the current CNR versus the CNR + Cruise Buff versus the new Odyssey CNR versus the Golem:
https://docs.google.com/file/d/0B_CLlTV8bSxNMEdQc1RySWZ4Njg/edit?usp=sharing

Spreadsheet changes:
I've reorganized the comparison page to be easier to print as a PDF with a 2x3 format. Click File -> Export as PDF, then choose selection or the current page.

Click the link the OP for the spreadsheet.

Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

CanI haveyourstuff
Native Freshfood
Minmatar Republic
#3 - 2013-05-14 15:49:40 UTC
Could you please add crusie golem stats also? current vs odyssey
Jake Warbird
Republic Military School
Minmatar Republic
#4 - 2013-05-14 17:20:54 UTC
Thanks again for the numbers stoic. I still have your spreadsheet saved up since I first joined Eve.
CanI haveyourstuff
Native Freshfood
Minmatar Republic
#5 - 2013-05-14 18:25:39 UTC  |  Edited by: CanI haveyourstuff
Thank you, I see there golem siege.
I was wondering golem cruises on odyssey... lazy ass l4 ship, cba to run around with max 30km-ish sieges.

or teach me how can I do it myself.. I have no idea about odyssey cruise buff other than it should be better.....


Okay I got my answer, Golem odyssey will 2shot mercenary overlord, CNR odyssey 3 shots.
And that keeps on going with all other targets.

1000 ish golem cruise DPS, thats just epic!!
hellcane
Never Back Down
#6 - 2013-05-14 19:26:45 UTC
The problem with cruise golem is defenders. Losing 1/4 of your DPS every volley = bad
CanI haveyourstuff
Native Freshfood
Minmatar Republic
#7 - 2013-05-14 19:32:47 UTC
hellcane wrote:
The problem with cruise golem is defenders. Losing 1/4 of your DPS every volley = bad


well.. I have been using t2 crusie golem for months and I havent seen any defender flying out ever... okay okay, maybe couple of times.

I just did damsel in distress on SISI with golem cruise buff and every volley hit for max dmg every time.


Now we are talking about CNR crusie here.. which will have 8 launchers, there _WILL_ be 1 defender almost always picking one cruise off always
Deerin
East Trading Co Ltd
#8 - 2013-05-14 20:02:01 UTC
Very nice. Thank you. I would like to point out that the new cnr has +1med. It might make sense to calculate with 2 tps. İs it also possible to see effect of 1 tp rig + 2 rigor rig vs 2 t2 rigor
IIshira
School of Applied Knowledge
Caldari State
#9 - 2013-05-15 11:06:58 UTC
CanI haveyourstuff wrote:
Thank you, I see there golem siege.
I was wondering golem cruises on odyssey... lazy ass l4 ship, cba to run around with max 30km-ish sieges.



Unless they nerfed something the last time I checked the Golem had over 60 KM torpedo range? Are you trying to use T1 launchers?
CanI haveyourstuff
Native Freshfood
Minmatar Republic
#10 - 2013-05-15 12:33:14 UTC
IIshira wrote:
CanI haveyourstuff wrote:
Thank you, I see there golem siege.
I was wondering golem cruises on odyssey... lazy ass l4 ship, cba to run around with max 30km-ish sieges.



Unless they nerfed something the last time I checked the Golem had over 60 KM torpedo range? Are you trying to use T1 launchers?


60 javelins?

why would anyone want to use 60km javs with ******** expl radius because of misle speed flight time rigs over odyssey 170km ish 1000 dps cruises with 2x rigor II -s ?
Heinrich Hoss
Caldari Provisions
Caldari State
#11 - 2013-05-15 12:40:30 UTC
Terrific, thank you :)
stoicfaux
#12 - 2013-05-17 17:17:17 UTC
1.0 Update! I've added PDFs comparing the various Odyssey missile ship changes. The word for the day is Homogenization.

Added the following PRE-GENERATED PDF REPORTS for your convenience! (You can see the results without messing with the spreadsheet.)
* cnr_flare_v_rigor_odyssey.pdf
* cnr_rigs_odyssey.pdf
* cnr_v_fleet_typhoon_odyssey.pdf
* cnr_v_typhoon_v_raven_v_fleet_typhoon_v_sni_v_golem_odyssey.pdf
* cruise_cnr_v_torp_golem.pdf
* raven_v_cnr_odyssey.pdf
* tengu_ham_v_hml.pdf

Enjoy!

Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

Liang Nuren
No Salvation
Divine Damnation
#13 - 2013-05-17 17:29:43 UTC  |  Edited by: Liang Nuren
Do these reports include drones?

-Liang

Ed: Also, Cruise Golem?

I'm an idiot, don't mind me.

stoicfaux
#14 - 2013-05-17 17:43:22 UTC
Liang Nuren wrote:
Do these reports include drones?

-Liang

Ed: Also, Cruise Golem?

The reports do not include drones. Spider Drones are available in the spreadsheet. Player drones would need to be added to the ship sheet.

Yes, the pdf reports have Cruise Golem numbers.



Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

Liang Nuren
No Salvation
Divine Damnation
#15 - 2013-05-17 17:49:49 UTC
Are you only comparing DPS with Fury or am I missing pages to the reports?

-Liang

I'm an idiot, don't mind me.

stoicfaux
#16 - 2013-05-17 18:08:24 UTC
Liang Nuren wrote:
Are you only comparing DPS with Fury or am I missing pages to the reports?

-Liang

Just fury for now. Given how effective fury will be after the 25% damage boost, I'm not sure T1 will be worth the time to load anymore. Plus I ran out of steam.

I'll add T1 and Precision data when I get the time/patience.

Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

Liang Nuren
No Salvation
Divine Damnation
#17 - 2013-05-17 18:18:42 UTC
stoicfaux wrote:

Just fury for now. Given how effective fury will be after the 25% damage boost, I'm not sure T1 will be worth the time to load anymore. Plus I ran out of steam.

I'll add T1 and Precision data when I get the time/patience.


Using Furies to shoot a cruiser results in almost a 40-50% DPS penalty... that seems really steep still. Also, I said I'd bring this up here:

Liang Nuren wrote:

... However, your methodology is just flat wrong because you are ignoring damage application implants. You can say that they affect everyone equally (and be right!), but the problem is exactly illustrated here: The 3 Rigor CNR is just as effective with 1 TP as with 2 TP. That's exactly the same kind of effect that damage application implants have. I also think it's kinda weird to assume only one painter considering we all fit painters already and we're getting an extra mid slot. ...


-Liang

I'm an idiot, don't mind me.

stoicfaux
#18 - 2013-05-17 19:30:33 UTC
Liang Nuren wrote:
stoicfaux wrote:

Just fury for now. Given how effective fury will be after the 25% damage boost, I'm not sure T1 will be worth the time to load anymore. Plus I ran out of steam.

I'll add T1 and Precision data when I get the time/patience.


Using Furies to shoot a cruiser results in almost a 40-50% DPS penalty... that seems really steep still. Also, I said I'd bring this up here:

Liang Nuren wrote:

... However, your methodology is just flat wrong because you are ignoring damage application implants. You can say that they affect everyone equally (and be right!), but the problem is exactly illustrated here: The 3 Rigor CNR is just as effective with 1 TP as with 2 TP. That's exactly the same kind of effect that damage application implants have. I also think it's kinda weird to assume only one painter considering we all fit painters already and we're getting an extra mid slot. ...


-Liang

I've updated the new copy of the spreadsheet that includes implants. There's a "test_implants.pdf" as a preview.

I have NOT (yet) re-run the PDFs with the implant info.


Pon Farr Memorial: once every 7 years, all the carebears in high-sec must PvP or they will be temp-banned.

Sergeant Acht Scultz
School of Applied Knowledge
Caldari State
#19 - 2013-05-17 19:42:34 UTC  |  Edited by: Sergeant Acht Scultz
CCP???

Sticky please Lol

IS it just me or the Tengu pdf still shows CNR one? -maybe an upload issue?

removed inappropriate ASCII art signature - CCP Eterne

Liang Nuren
No Salvation
Divine Damnation
#20 - 2013-05-17 19:57:24 UTC
stoicfaux wrote:

I've updated the new copy of the spreadsheet that includes implants. There's a "test_implants.pdf" as a preview.

I have NOT (yet) re-run the PDFs with the implant info.


I've probably never seen the effect of implants so clearly outlined. Dayum.

-Liang

I'm an idiot, don't mind me.

123Next page