open All Channels
seplocked Ships and Modules
blankseplocked Spreadsheet - Damage Computations (beta version b.26b)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5 6

Author Topic

Naughty Boy
Chronics of ordinary hate
Posted - 2005.11.16 19:40:00 - [1]
 

Edited by: Naughty Boy on 10/08/2007 22:27:38

Download (zip files with one excel sheet in each)
Last update
* Version b.26b
Previous versions and archive
* Version b.26
* Version b.25
* Version b.24
* Version (a.19)

Utility of the model
It's a model to compare the total damage done by various weapons in various circumstances. It is useful to compare weapons for a particular ship, and to compare ships fitted for a particular role.

Quick description of the model
* The dependent variables are damage over time, cumulative damage, cap consumption and time to destruction;
* The variables/parameters are range, fight time, signature radius, (absolute) velocity and transversal velocity (all showing in yellow in the input sheet, the "variable" selected is the actual variable, other "variables" then are actually parameters).
* Even though all combinations dependent variable=f(variables, parameters) are theoretically possible, some are absurd ("time to destruction as a function of fight time" is a good example).
*All calculations are currently done with maxed skills.

Damage Over Time and Cumulative Damage
All the formulas do not use standard dps calculations, unless the fight time variable is set to "normalized". Instead, cumulative damage done is divided by the total fight time, in order to show the effect of alpha strike/burst damage/reloading when useful (fight time <= 1 shows the alpha strike capabilities). The model simply adds the damage of guns, missiles, and drones in the given circumstances:
* Gun damage: the damage is determined by the tracking formula used in the tracking guide (factoring hit chance), also accounting for the hit quality formula (since the b.23v7 version). Each kind of ammo is compared and the optimal ammo is used for every range.
- T2 ammo is available;
- T1 ammo can be enabled selectively (range and damage types).

* Missile damage: the damage is determined by the missile reduction formula discovered by Electr0freak. In addition is used a damage reduction formula to take flight time into account.
- T2 ammo is available;
- T1 and t2 ammo can be enabled selectively (damage types).

* Drone damage: This formula uses a damage reduction formula similar to the one taking the flight time of missiles into account. There is still a relatively important inaccuracy as drones are supposed to intercept ships in this formula, which is a problem for high speeds since it becomes noticeable that they do not intercept. Also, the damage reduction related to drone tracking is relatively basic and does not factor the absolute velocity of the target. Unfortunately there doesn't seem to be a way simple enough to fix this while keeping the model simple. It is related to the constraint of only changing one variable at a time to present a simple view, when range and velocity are depend on each other if we account for the movement of the "referential".

Interface
Interface (now outdated)
Blue background and white fonts mean that those are parameters that can be changed, yellow fonts shows the value taken by the parameters that can also be used as variables. When used as variables, the "yellow" value is disregarded and the variable varies from the "minimum" (1 except for range as the minimum range can be set arbitrarily) to the maximum.

Guide/FAQ

Thanks
Thanks Chribba for the hosting, Marn Prestoc and Kazuo Ishiguro for taking over and keeping the spreadsheet updated.

NB.

Trelennen
Disturbed Hoggs
Posted - 2005.11.16 20:16:00 - [2]
 

Great work Naughty, this should go into one of the stickies, for sure!

Nyxus
Amarr
Fat J
-Mostly Harmless-
Posted - 2005.11.18 22:25:00 - [3]
 

This isn't just good.

It's omfgfingerlickingyarrbq good! Shocked

Stickie now please. This utility just can't be beat.

Huge kudos to Naughty Boy for all your hard work!!!

Nyxus

Naughty Boy
Chronics of ordinary hate
Posted - 2005.11.18 22:28:00 - [4]
 

Originally by: Nyxus
It's omfgfingerlickingyarrbq good! Shocked


Thanks Razz

I'd be glad if people could report bugs/problems here (as I just fixed a very Embarassed error in the ship DB).

Sincerly Yours, The Naughty Boy.

Zansin
Minmatar
Genji Jump Clones and Research Group
Posted - 2005.11.23 13:58:00 - [5]
 

nice no more long division for me!!! :P

ThundrGod
Knockaround Guys
Posted - 2005.11.23 23:33:00 - [6]
 

Ok, sorry for noob questions but im struggling with the spreadsheet. Is it only meant to chart one weapon at a time or the weapons package in entirety? How do i add multiple weapons of the same type to a ship?

Naughty Boy
Chronics of ordinary hate
Posted - 2005.11.24 01:25:00 - [7]
 

Originally by: ThundrGod
Ok, sorry for noob questions but im struggling with the spreadsheet. Is it only meant to chart one weapon at a time or the weapons package in entirety? How do i add multiple weapons of the same type to a ship?


At the moment (and i doubt it could gain more flexibility without getting too complex) you can only fit one kind of turret and one kind of launcher.
It is supposed to allow a comparison of guns under the effet of ship skills and damage mods, so that, for instance, you can compare how good would be 5 focused medium beams t1 and 2 damage mods t2 when compared to 5 heavy beams fitted on a maller. Or, when fighting a rupture in a thorax, what would be an appropriate range to deal enough damage while not taking to much damage.

I might had features related to skills or cap usage, but it's not certain yet.

Sincerly Yours, The Naughty Boy.

Deja Thoris
Invicta.
Rooks and Kings
Posted - 2005.11.24 03:43:00 - [8]
 

Thats a quality piece of work NaughtyBoy

Rivek
Sniggerdly
Pandemic Legion
Posted - 2005.11.24 03:51:00 - [9]
 

It is quite nice and has some capabilities my own doesn't. Thanks for sharing it. May I recomend you incorporate dropdown menus? It requires using "validation" within excel.

Naughty Boy
Chronics of ordinary hate
Posted - 2005.11.25 19:37:00 - [10]
 

New version is out, I corrected a few problems (see edit in the first post).

Originally by: Deja Thoris
Thats a quality piece of work NaughtyBoy

Thanks, my pleasure. Razz

Originally by: Rivek
It is quite nice and has some capabilities my own doesn't. Thanks for sharing it. May I recomend you incorporate dropdown menus? It requires using "validation" within excel.

This is some very interesting function i had no knowledge about, i'll try using it so that it becomes a bit more user-friendly.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.10 13:55:00 - [11]
 

New version is released (see edit in the first post).
Unfortunately I couldn't really upgrade the interface yet.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.12 00:46:00 - [12]
 

Edited by: Naughty Boy on 13/12/2005 13:16:05
New version (a.12) is released (see edit in the first post).

Edit: 'lil database error, incorrect drone bay volume for megathron/armageddon after conversion for RMR. Corrected version is now available: Link.

Sincerly Yours, The Naughty Boy.

Nyxus
Amarr
Fat J
-Mostly Harmless-
Posted - 2005.12.13 04:52:00 - [13]
 

Edited by: Nyxus on 13/12/2005 04:52:04
If you havent downloaded the new version do it.

Do it now.

I am tired of seeing totally crap numbers and comparisons on the forums. Naughty Boy has created an absolutely fantastic tool that does all the work for you. No more hard maths (I know you only passed becuase you cheated anyway). Plug in what you want to compare and it provides you with numbers and a pretty graph to boot!

Use it's power for good, not ebil. And send Naughty Boy some iskies just like you slipped that nerdy kid some money for doing your homework back in school.

Nyxus

Drunkeh
Caldari
Doomheim
Posted - 2005.12.13 04:59:00 - [14]
 

Naughty, you are easilly my favorite ships and modules poster. Thanks a lot for all of your hard work man.

The list is now
#1 naughty
#2-5: j0, jim, meri, detaurus

honorable mention: thewhizz187 (or whatever random numbers).

Drunkeh
Caldari
Doomheim
Posted - 2005.12.13 05:00:00 - [15]
 

Oh and STICKY

Sarmaul
Brutor Tribe
Posted - 2005.12.13 09:20:00 - [16]
 

there are 2 things in life you need to ***** the Ships and Mods forum effectivly.

1) The QuickFit Tool stickied at the top
2) This spreadsheat

<3

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.13 13:23:00 - [17]
 

Thanks for the kind words. Very Happy

New version is uploaded, the database error is corrected.
There are a few new features, mostly "cosmetic".

Sincerly Yours, The Naughty Boy.

Sarmaul
Brutor Tribe
Posted - 2005.12.13 13:33:00 - [18]
 

and hurry up with the drone damage mods - I have more phoon setup whoring to do!

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.13 15:03:00 - [19]
 

Edited by: Naughty Boy on 14/12/2005 00:16:58
Uploaded again, with drone damage/ tracking mods (in testing).

I've never used them on SISI, so i'm not so sure about the new range (if it changed, can't remember) and effect of the drone tracking mod on range. In case it's not working as it should, just input a high constant for max drone range in input cell to get rid of the impact of the parameter.

Edit: Updated version with a setting (enabled by default) disabling long range ammo for autocannons/blasters

Sincerly yours, The Naughty Boy.

Drunkeh
Caldari
Doomheim
Posted - 2005.12.16 17:29:00 - [20]
 

Why is this not stickied?

Sun Ra
Euphoria Released
HYDRA RELOADED
Posted - 2005.12.19 09:58:00 - [21]
 

T1 drones seem to be doing more damage than t2's?

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.19 10:04:00 - [22]
 

Edited by: Naughty Boy on 20/12/2005 03:55:06
Indeed, they have 1 second ROF in the <mod DB> sheet instead of 2 seconds like they should. I have absolutely no idea how this happened Embarassed.

Thanks for reporting this, Sun Ra.
Edit: link in the first post updated, will be functional as soon as the file can be uploaded on eve-files (edit2: still not uploading at the edit time).

Sincerly Yours, The Naughty Boy.

vile56
Metalworks
Majesta Empire
Posted - 2005.12.21 02:26:00 - [23]
 

i am usualy comp savy but i lack in code so i d/l the program and i am just seeing code after i extract.

help apreciated

Erloas
Posted - 2005.12.21 03:37:00 - [24]
 

the alpha18 version link doesn't work, says file not found

As for the above poster, I got the alpha16 and it works fine, its an excel file though, so if you don't have excel then that would by why its not working

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.21 03:48:00 - [25]
 

Edited by: Naughty Boy on 21/12/2005 17:01:58
Originally by: Erloas
the alpha18 version link doesn't work, says file not found

I've been trying to upload it for a few days already and it still doesn't work. I have no idea if the problem is on my end or if it's normal for eve-files to be so frustrating at the moment.
The next version should add very little, it mainly corrects the too low ROF of the t1 drones (which is incorrect in the .16 version).
Edit: Still impossible to upload the file.

Originally by: Erloas
As for the above poster, I got the alpha16 and it works fine, its an excel file though, so if you don't have excel then that would by why its not working.
Indeed, you need the program for the excel sheet to work. If that's not the problem, can you tell a bit more about what exactly is happening.

Sincerly Yours, The Naughty Boy.

Sky Hunter
0NE
Posted - 2005.12.21 18:02:00 - [26]
 

Is it ok to use old version so far for gun dmg calculations?

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.21 18:12:00 - [27]
 

Aye, it's fine.
You can manually change the t1 drones ROF in the sheet called <Mod DB> from 1 to 2 seconds and all should be fine.

Sincerly Yours, The Naughty Boy.

Sky Hunter
0NE
Posted - 2005.12.21 18:55:00 - [28]
 

Edited by: Sky Hunter on 21/12/2005 18:55:12
Hm just downloaded alpha16 zip archive....it only contains *.xls file....what i do with it?

edit: typo

Naughty Boy
Chronics of ordinary hate
Posted - 2005.12.21 19:05:00 - [29]
 

You open it with Microsoft Excel.

In the first sheet (called "input") there are cells with ships/weapons/mods. Just write the names of the ship/weapon, the number of damage/tracking mods and parameters like range/velocity: the graph(s) should update properly.

Sincerly Yours, The Naughty Boy.

Sky Hunter
0NE
Posted - 2005.12.21 21:16:00 - [30]
 

Originally by: Naughty Boy
You open it with Microsoft Excel.

In the first sheet (called "input") there are cells with ships/weapons/mods. Just write the names of the ship/weapon, the number of damage/tracking mods and parameters like range/velocity: the graph(s) should update properly.

Sincerly Yours, The Naughty Boy.


Thanks, ok now!


Pages: [1] 2 3 4 5 6

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