open All Channels
seplocked Ships and Modules
blankseplocked Missile Damage / Ship Speed Spreadsheet
 		This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

The Major
Caldari
StateCorp
The State
Posted - 2006.01.06 23:27:00 - [1]
 
Edited by: The Major on 24/01/2006 19:05:39
Edited by: The Major on 13/01/2006 03:52:53
Edited by: The Major on 13/01/2006 03:50:37
Updated!

MissileDamage Calculator v1.02

It should be fairly self explanatory. Change the values in blue and fiddle around.

Screenshot

ChangeLog v1.02:

* Fixed a small bug in the Setup Comparisons sheet that was causing the wrong skill multipliers to be used in some cases.

* Added Citadel Launchers and Torpedos to the spreadsheet.

* Added Siege mode as an option for Dreadnaughts.

Changelog v1.01:

* Data for 119 ships added including sig radius and missile related bonuses.

* Ship and target setup only requires the selection of a ship type from a drop down list. No more manual editing.

* Stealth Bomber bonus is now built into ship bonus rather than a seperate option.

* Setup Comparison sheet now lets you have 5 setups instead of just 2.

* Sheets have been reformatted for snazziness.

* Damage takes into account manually edited resistances.

* Missile range is shown on both sheets and not just the setup comparison sheet.

* Several bugs fixed that lead to misleading results in the comparison graph.

Known Issues:

* The stacking formula used for Target Painters and Ballistic Control Systems is the old system as I just hasen't had tme to change it to the RMR stacking.

* The Comparison sheet lets you "load" launchers with the wrong missile type.

Some feedback would be appreciated. Try and find any other bugs and otherwise enjoy finnally being able to see exactly how your missiles are going to perform with snazzy graphs.

Oh and of course if you really like it feel free to send some ISK my way ;)

The Major
Caldari
StateCorp
The State
Posted - 2006.01.13 03:52:00 - [2]
 
minibump

Jin Entres
Malevolent Intervention
Posted - 2006.01.20 10:35:00 - [3]
 
Nice! Any ETA for up-to-date BCS stacking and citadel torpedoes?

The Major
Caldari
StateCorp
The State
Posted - 2006.01.24 19:04:00 - [4]
 
Originally by: Jin Entres
Nice! Any ETA for up-to-date BCS stacking and citadel torpedoes?


I have in fact updated it today with Citadel Launchers/Torps and Siege mode for dreadnaughts!

See the first post for links. I'll get around to the BCS stacking probably around the same time TomB rolls us back to the old style ;)

Smagd
Encina Technologies
Namtz' aar K'in
Posted - 2006.02.02 23:14:00 - [5]
 
Sigma,

not a bad tool at all. Must have been quite some work going into all those tables.

I endorse this.

Smagd

Randuin MaraL
Minmatar
Encina Technologies
Namtz'aar k'in
Posted - 2006.02.03 10:50:00 - [6]
 
Very useful. Thank you!

Wilm v'Rabe
Posted - 2006.03.07 17:04:00 - [7]
 
Very nice, thanks. Studying it now.

Zapo
Posted - 2006.06.27 12:35:00 - [8]
 
buhuu open office doesn't wanna open it :(
Guess i'll have to take it to a friend or go YARRRR!!
Still even though i haven't tested it yet tnx 4 the trouble

Jet Collins
Dynamic Endeavors
Posted - 2006.06.27 14:04:00 - [9]
 
Edited by: Jet Collins on 27/06/2006 14:22:52
Changes arn;t made to the Phoon :) I would like to do it my self but some much is hiding :(

NVm found where to change it very nice spread :)

Auritt
Caldari
Interplanetary - Expeditions
Posted - 2006.09.30 06:31:00 - [10]
 
A great piece of work. I wish I were half as good at writing spreadsheets as you are. Thank you, I've learned a lot from this.

Auritt

Xasz
The Python Cartel.
Posted - 2006.10.16 23:55:00 - [11]
 
Nice.

The Major
Caldari
StateCorp
The State
Posted - 2006.12.04 14:59:00 - [12]
 
Edited by: The Major on 04/12/2006 15:08:14
I apologise for not updating the spreadsheet sooner. I fully intend to include the new ship classes from revelations as well as assault missiles in the next version which will hopefully be ready this coming weekend.

I'd appreciate any help people can give in bug testing the new spreadsheet. Ideally if you can calculate your own missile damage values so you can double check the graphs (as these are where most bugs tend to creep in).

Apply via this thread and I'll get in touch. Don't be leaving emails or anything I'll contact you ingame.

Thankyou.

Lucian Corvinus
Gallente
Expert Systems
Posted - 2006.12.04 15:05:00 - [13]
 
Looks really nice, and an update would be most welcome, also if you would be able to add the new rigs.
But send me a mail ingame, and I will try to find the time to do some bugtesting on your calculatorSmile

The Major
Caldari
StateCorp
The State
Posted - 2006.12.05 10:18:00 - [14]
 
A new version is currently available for testing (I'll update the first post when I get some confirmations that everything looks correct).

Missile Damage Calculator v1.03b

Changelog v1.03b

* Fixed Siege mode not applying it's damage bonus correctly.
* Added Heavy Assault Launchers and Assault Missiles.
* Added Tier 2 battlecruisers.
* Added Tier 3 Battleships.
* Updated the Typhoons Bonuses.
* Updated the Hawks Bonuses.
* Updated Assault Ship Signature Radius.
* The Missile Comparison Sheet has been removed. Now only setup comparison remains.
* You can only load allowed types of missile into a launcher. This includes Tech 1/2 restrictions.
* Graph scales if Siege mode is active to compensate for the hidden aoeFalloff "Bonus" in Siege mods.
* aoeFalloff "Bonus" now factored into Siege Mode.

There are numerous smaller fixes that are just me streamlining the formulas and lookups.

I'd appreciate if people can download this version and compare the values it gives to their experiences in the game.

arqueturus
Minmatar
EState Holdings
Posted - 2006.12.05 11:11:00 - [15]
 
That's pretty damn cool mate, I'll have a fiddle so I can test various missiley ships I have.

cheers arq


 

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