Pages: [1] 2 3 4 5 6 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Naughty Boy
|
Posted - 2005.11.16 19:40:00 -
[1]
Edited by: Naughty Boy on 16/11/2005 19:47:08 Download (zip file with one excel sheet) Example of results (previous version).
Utility of the model It's a simple model to compare the total damage done by various weapons in various circumstances, as standard damage calculations are often misleading because of the parameters/factors that are usually left out. 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 variables are total damage and range. The parameters are velocity, transversal velocity, signature radius, and fight time.
The model simply adds the damage of guns, missiles, and drones for each range. * Gun damage: the damage is determined by the tracking formula used in the tracking guide. Each kind of ammo is compared and the optimal ammo is used for every range. Reloading time not taken into account. * 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. * 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, there is no damage reduction related to drone tracking as IÆm not yet comfortable enough with the modelisation of their behaviour when chasing/orbiting a target
All the formulas do not use standard dps calculations. Instead, cumulative damage done is divided by the total fight time, in order to show the effect of alpha strike/burst damage when useful (fight time = 1 shows the alpha strike capabilities).
Known Problems * Partial database (lack of destroyer and t1 frigs mostly) * Missing error checks (the spreadsheet isnÆt really user-friendly, and certainly not idiot-proof... be warned ) * No graph scaling when changing min range (odd bug) * No capacitor use calculation (missing feature) * Explosion radius skill bonus input directly in the database * No damage reduction formula for reloading time (missing feature) * Missile damage calculations assume "right" damage type (workaround: create an alternative ship without the damage bonus in the Ship DB) * Weird way to input drone size
Note about that last point. Ships are assumed to use a "right" drone size. ItÆs a bit tricky. The thorax, in the DB, can use 8 drones. In the right column in the "input" sheet it should be "heavy drone t1" because the thorax can hold 8 heavy drones. Thorax mk2 shows 10, hence the right drone size is "medium drone t1". Vexor shows 15, hence it should be "medium drone t1" whereas ishtar should be "heavy drone t1". I didnÆt include t2 drone stats yet, but itÆs quite easy to add in a spare field in the right sheet.
Interface Screenie. Blue background and white fonts mean that those are parameters that can be changed. Ships/weapons are listed below, they just have to be written properly (no typo). There is very little exception handling, so any error will not necessarily be noticed.
ItÆs still very basic and it was not supposed to be released, moerover there are probably still a few "unexpected features", so donÆt expect something very user-friendly. IÆll try to update the file when bugs are noticed and corrected.
Sincerly Yours, The Naughty Boy.
|
Trelennen
|
Posted - 2005.11.16 20:16:00 -
[2]
Great work Naughty, this should go into one of the stickies, for sure!
Quote: dont fly what you cant afford to lose, always have it insured, make sure you can replace it before you take it into 0.0 or any potentially kaboomish situations.
|
Nyxus
|
Posted - 2005.11.18 22:25:00 -
[3]
This isn't just good.
It's omfgfingerlickingyarrbq good!
Stickie now please. This utility just can't be beat.
Huge kudos to Naughty Boy for all your hard work!!!
Nyxus
Plasmatique> "Cry 'Cartiff' and let slip the dogs of war!" |
Naughty Boy
|
Posted - 2005.11.18 22:28:00 -
[4]
Originally by: Nyxus It's omfgfingerlickingyarrbq good!
Thanks
I'd be glad if people could report bugs/problems here (as I just fixed a very error in the ship DB).
Sincerly Yours, The Naughty Boy. --- Spreadsheet - Damage @ range. |
Zansin
|
Posted - 2005.11.23 13:58:00 -
[5]
nice no more long division for me!!! :P
|
ThundrGod
|
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
|
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. --- Spreadsheet - Damage @ range. |
Deja Thoris
|
Posted - 2005.11.24 03:43:00 -
[8]
Thats a quality piece of work NaughtyBoy
|
Rivek
|
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.
See your name in lights at TunDraGon.com |
Naughty Boy
|
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.
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. --- Spreadsheet - Damage @ range. |
|
Naughty Boy
|
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. --- Spreadsheet - Damage @ range. |
Naughty Boy
|
Posted - 2005.12.12 00:46:00 -
[12]
New version (a.12) is released (see edit in the first post).
Sincerly Yours, The Naughty Boy. --- Spreadsheet - Damage @ range (updated). |
Nyxus
|
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
Plasmatique> "Cry 'Cartiff' and let slip the dogs of war!" |
Drunkeh
|
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).
Originally by: Omeega I R NO WORK.
I SELL MY KIDS FOR ISK.
YAAAAAAAAAAAAAAAR.
|
Drunkeh
|
Posted - 2005.12.13 05:00:00 -
[15]
Oh and STICKY
Originally by: Omeega I R NO WORK.
I SELL MY KIDS FOR ISK.
YAAAAAAAAAAAAAAAR.
|
Sarmaul
|
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
Originally by: Chowdown We camp a lot
|
Naughty Boy
|
Posted - 2005.12.13 13:23:00 -
[17]
Thanks for the kind words.
New version is uploaded, the database error is corrected. There are a few new features, mostly "cosmetic".
Sincerly Yours, The Naughty Boy. --- Spreadsheet - Damage @ range. Check for updates/known issues and report bugs/problems/questions/other feedback. |
Sarmaul
|
Posted - 2005.12.13 13:33:00 -
[18]
and hurry up with the drone damage mods - I have more phoon setup whoring to do!
Originally by: Chowdown We camp a lot
|
Naughty Boy
|
Posted - 2005.12.13 15:03:00 -
[19]
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.
Sincerly yours, The Naughty Boy. --- Spreadsheet - Damage @ range. Check for updates/known issues and report bugs/problems/questions/other feedback. |
Drunkeh
|
Posted - 2005.12.16 17:29:00 -
[20]
Why is this not stickied?
Originally by: Omeega I R NO WORK.
I SELL MY KIDS FOR ISK.
YAAAAAAAAAAAAAAAR.
|
|
Sun Ra
|
Posted - 2005.12.19 09:58:00 -
[21]
T1 drones seem to be doing more damage than t2's?
We're coming for you |
Naughty Boy
|
Posted - 2005.12.19 10:04:00 -
[22]
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 .
I'll post an update soon. Thanks for reporting this, Sun Ra.
Sincerly Yours, The Naughty Boy. --- Spreadsheet - Damage @ range. Check for updates/known issues, feedback welcome. |
vile56
|
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
well walk up to her with your pants down and if she runs away it was never meant to be. |
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
|
Posted - 2005.12.21 03:48:00 -
[25]
Edited by: Naughty Boy on 21/12/2005 03:52:24
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 correct the too low ROF of the t1 drones (which is incorrect in the .16 version).
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. --- Spreadsheet - Damage @ range. Check for updates/known issues, feedback welcome. |
Sky Hunter
|
Posted - 2005.12.21 18:02:00 -
[26]
Is it ok to use old version so far for gun dmg calculations? -=-
|
Naughty Boy
|
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. --- Spreadsheet - Damage @ range. Check for updates/known issues, feedback welcome. |
Sky Hunter
|
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
|
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. --- Spreadsheet - Damage @ range. Check for updates/known issues, feedback welcome. |
Sky Hunter
|
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 :: one page |
First page | Previous page | Next page | Last page |