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 - 2006.02.07 14:55:00 - [61]
 

Originally by: Sun Ra
a30 has a slight bug, the 4th ship always shows as a tempest on the graph
Oh, thanks for that, I didn't notice. It's a minor typo in a cell though it has a rather annoying consequence. It will be changed in the next version.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.02.13 00:38:00 - [62]
 

Edited by: Naughty Boy on 13/02/2006 00:39:08
Current version: a.19 (still no change there, the annoying bug from a.30 - that came with the function allowing to set fight time as a variable, and range as a parameter - is still not corrected).

New version in testing
* Minor fixing (including the typo reported by Sun Ra);
* Improved stacking calculator for resistances;
* "Cosmetic" changes (input sheet, with settings and parameters);
* New SISI stacking for tracking computers/enhancers/disruptors (in testing);
Download: "In testing" Version: a.32

Sincerly Yours, The Naughty Boy.

Nyxus
Amarr
Fat J
-Mostly Harmless-
Posted - 2006.02.27 00:58:00 - [63]
 

Have I mentioned recently how much I love this thing? This provides more hard data than a 1000 "omgnerfthis" threads with anecdotal, biased experiences.

Thanks for updating it so religiously Naughty Boy, its very very very much appreciated. I am looking forward to the new stacking fixes and seeing how they affect the numbers.

Suggestion/Question: Is there some way to plug in T2 ammo variations for different weapons? I think some of that data would be very enlightening.

Nyxus

Sarmaul
Brutor Tribe
Posted - 2006.02.27 01:00:00 - [64]
 

NB, I know you're going to hate me for it, but how's about an ammo selector for both missiles and turrets?

Oh, and t2 ammo would be nice too Wink

Naughty Boy
Chronics of ordinary hate
Posted - 2006.02.28 17:52:00 - [65]
 

Edited by: Naughty Boy on 06/03/2006 14:26:08
I've been developping another version with sentry drones, carriers, and t2 ammo. Sentry drones were relatively easy to add, but the other changes will take some time as the current model isn't flexible enough. Also, unfortunately the math behind t2 ammo isn't very obvious (the bonus/modifiers of t2 ammo aren't always very straightforward) so this will take some time.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.03.06 14:10:00 - [66]
 

Edited by: Naughty Boy on 06/03/2006 16:27:34
New version in testing (uploading to eve-files right now, don't forget to help Chribba funding the very first mining titan).
This version is a test version, including many changes that were not extensively tested.

New changes
* The cumulative damage no longer decrease when weapons are reloading (in the particular case of flight time being a variable and range a parameter);
* Bloodline patch & ships bonuses changes: Sacrilege, Nighthawk bonuses changed;
* Modifications to the Resistance Stacking Calculator;
* New "cosmetic" changes (input sheet, with settings and parameters);
* T2 Ammo for turrets and launchers (in testing);
Download: "In testing" Version: a.40

Future plans
As Excel isn't very well suited for that kind of calculations, the spreadsheet became very large (70+ Mb) and very complex (it is common to have calculations in cells take as long as 4 lines). For that reason, future versions will not get more complex, and future changes will mostly be limited to bug correction and minor additions. Including:
* T1 Ammo selector in the interface for turrets and missiles (edit: calculations are already there, just not showing);
* Sentries (the test version including sentry drones was corrupted so the feature didn't make it into this test version).

Sincerly Yours, The Naughty Boy.

Wilm v'Rabe
Posted - 2006.03.07 22:11:00 - [67]
 

Absolutely incredible. So much stuff I'm just working to understand some of it :)

However, I notice there are a number of ships and weapons not listed, toward the low end of the spectrum. Can I just add the data to the DB section or are there conventions?

Naughty Boy
Chronics of ordinary hate
Posted - 2006.03.07 23:02:00 - [68]
 

Originally by: Wilm v'Rabe
Can I just add the data to the DB section or are there conventions?
You shouldn't have problems adding them, make sure that you list the bonuses in a consistant way. Same goes for the weapons.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.04.21 17:01:00 - [69]
 

Edited by: Naughty Boy on 21/04/2006 22:16:33
Download - b.01 (14.8Mb ZIP on eve-files).

Changes in the last version
* Extended choice of variables (previously only range, then range and fight time, now most parameters);
* Addition of t1 sentry drones;
* Addition of an "ammo selector" (t1 for turrets, t1 and t2 for launchers);
* Addition of target painters;
* Spec. skill for tracking disruptors now factored;
* Minor "cosmetic" changes to interface.

Planned/Future changes
From now on, no major features will be added, only updates and minor bugfixing.
* Webber/painter won't be "global" but will be fitted on ships individually;
* addition of a MWD dummy + code so that target painter stacking isn't off when the target painting bonus is applied on a mwding target;
* Update of the DB with upcoming Typhoon bonus/tracking bonuses/blasters/tachyons/AF etc. changes;
* Improvements of the "time to kill a tanked ship" computations;

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.04.23 20:03:00 - [70]
 

Edited by: Naughty Boy on 23/04/2006 21:24:57
Download - b.02.

Changes in the last version
* Bugfix for missile damage computations in b.01 version;
* Webber/painters can be fitted on ships individually;
* Addition of MWD signature bonus related computations to correct target painter stacking on a MWD'ing target;
* Minor "cosmetic" changes to the interface;
* Improvements of the "time to destruction" computations.

Planned/Future changes
* Update of the DB with upcoming Typhoon bonus/tracking bonuses/blasters/tachyons/AF etc. changes;
* EW falloff-related "hit chance" factored for target painters;
* Changes to resistances computations to fit the new "time to destruction" computations.

Sincerly Yours, The Naughty Boy.

Waz Hawat
The Scope
Posted - 2006.04.23 23:13:00 - [71]
 

This really is great work, thank you very much.

Kaylana Syi
Minmatar
Coreli Corporation
Naraka.
Posted - 2006.04.23 23:53:00 - [72]
 

Does this, or will it ever, work in Open Office?

Muthsera
S.A.S
Posted - 2006.04.24 02:43:00 - [73]
 

STICKIE!

Naughty Boy
Chronics of ordinary hate
Posted - 2006.04.25 16:45:00 - [74]
 

Originally by: Kaylana Syi
Does this, or will it ever, work in Open Office?
It does not work in Open Office unfortunately, though I think it shouldn't be too hard to make it work. I don't have much time currently, but I'll think about it.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.04.27 19:19:00 - [75]
 

Download - b.03.
Quick update.

Changes in the last version
* Astarte/Sleipnir falloff changed to 10%;
* Basic stat summary for turrets and launchers (similar to "show info" without ammo loaded);
* Duplication of resistances computations, so that the two tanks that can be compared in the "time to destruction" computations can have different resistances.

Planned/Future changes
* Update of the DB with upcoming bonus/modules stats changes;
* EW falloff-related "hit chance" factored for target painters.

Sincerly Yours, The Naughty Boy.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.04.30 13:20:00 - [76]
 

Originally by: Kaylana Syi
Does this, or will it ever, work in Open Office?
An update about this issue.

I've tried to find which functions couldn't be converted to Open Office automatically, but couldn't find any pattern and hence my suspicion is that the file is simply too big to be converted properly. If this is the issue, some optimisations made for the turret computations could solve the problem.

Sincerly Yours, The Naughty Boy.

Sarmaul
Brutor Tribe
Posted - 2006.04.30 15:33:00 - [77]
 

<3

Sanctus Maleficus
Lambent Enterprises
Enforcers of Serenity
Posted - 2006.05.05 20:07:00 - [78]
 

Originally by: Naughty Boy
Originally by: Kaylana Syi
Does this, or will it ever, work in Open Office?
An update about this issue.

I've tried to find which functions couldn't be converted to Open Office automatically, but couldn't find any pattern and hence my suspicion is that the file is simply too big to be converted properly. If this is the issue, some optimisations made for the turret computations could solve the problem.

Sincerly Yours, The Naughty Boy.


Yeah, I just tried to open it in Open Office and basically, it pegged about 500mb of memory usage and caused my machine to basically lock up. Not sure if its JUST the sheet itself, very well could be this machine, but for what its worth. :)

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.06 14:29:00 - [79]
 

Edited by: Naughty Boy on 06/05/2006 20:33:11
Originally by: Sanctus Maleficus
Yeah, I just tried to open it in Open Office and basically, it pegged about 500mb of memory usage and caused my machine to basically lock up. Not sure if its JUST the sheet itself, very well could be this machine, but for what its worth. :)
Due to how, in Excel, you cannot store and transform data through loops like in "regular code", there is a lot of redundant code and this explains the size of the sheet. I'll have a look at it, as i wrote turret damage computations can be simplified, as can t2 ammo computations.

A slightly unusual update that i'm not going to explain much... Version B.05. This version has got a new option to show the derivatives of the first and second order. It comes with an option to "smooth" the curve as the derivative is a numerical derivation of sometimes discontinuous functions (which aren't supposed to be derived at discontinuities), as well as an option to normalize the graph of the derivative (to make it easier to read). It's mostly interesting in respect to the concept or "optimal range" (in the sense of the best range to fight at, not the turret stat).

Sincerly Yours, The Naughty Boy.

M3ta
Amarr
Giants in the Playground
Privateer Alliance
Posted - 2006.05.09 23:56:00 - [80]
 

Originally by: Naughty Boy

Sincerly Yours, The Naughty Boy.


And one more last detail just so everything is perfect:

From www.dict.org:
"No definitions found for "sincerly", perhaps you mean:

gcide: Sincerely
wn: sincerely
"


Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.10 00:24:00 - [81]
 

It's only "extravagance", fantaisie. I know that it's a typo Razz
This line had its time, let's move to something else...

NB.

xphreakx
Caldari
Black Star Solutions
Posted - 2006.05.10 00:48:00 - [82]
 

Well i did download this, only to my dismay that Excel 2000 is unable to load this (see MS KB article: http://support.microsoft.com/kb/313275/en-us). I think i have a copy of Office 2003 lying around which I can use.

Otherwise this sounds like a great way to do some real good calculations of my setups and compare them.

Thanks!

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.10 00:54:00 - [83]
 

I'm looking into this, it's an issue for Open Office too apparently. I should be able to get the size of the sheet to ~70% of what it's now, maybe even less.
In the meanwhile you can use the alpha19 version which is still on eve-files, linked in the first post, and is much smaller. Of course, it has less features and is maybe a bit outdated, but it might run.

NB.

xphreakx
Caldari
Black Star Solutions
Posted - 2006.05.10 01:36:00 - [84]
 

Edited by: xphreakx on 10/05/2006 01:36:09
Thanks, got a.19 working and managed to hack in the proposed Caldari Tier 3 battleship using 7 425IIs and a T2 cruise launcher (even though i figure it'll probably use 6/2). Awesome spreadsheet.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.19 21:12:00 - [85]
 

Edited by: Naughty Boy on 19/05/2006 21:14:15
Download - b.10.
Mostly a performance related upgrade. The size of the spreadsheet was reduced from ~75Mb to ~40Mb. That was done in order to allow Open Office and older versions of Excel to load the spreadsheet. I could load it with Open Office without any trouble. Unfortunately a few more calculations were needed to shrink the tables, so the computations are a bit slower. This might be improved later.

Changes in the last version
* Siege Bonus for Dread updated;
* Changes to a more user-friendly ammo selector;
* Alteration of the computation tables.

Planned/Future changes
* Fix the basic stat summary for turrets and launchers, removed for the computation changes;
* Update of the DB with upcoming bonus/modules stats changes;
* EW falloff-related "hit chance" factored for target painters.

NB.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.23 22:10:00 - [86]
 

Edited by: Naughty Boy on 26/05/2006 14:13:35
Download - b.11.

Changes in the last version
* Changes to precision cruise and heavy missiles, projectiles, tachyons and blasters (new patch);
* Fix to the basic stat summary for turrets and launchers.

NB.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.31 00:16:00 - [87]
 

Edited by: Naughty Boy on 31/05/2006 00:17:50
Download - b.12.
I suppose that I should wait for the changes to be final, but... what would those forums be without some speculation Razz.

Changes in the last version
Ships and mods (bloodline III patch):
* AFs bonus changes (Wolf, Jaguar, Vengeance, Hawk);
* Typhoon bonus change (optimal bonus -> Launcher ROF bonus);
* Increased ammo capacity of the high tier autocannons (+50%);
* Increased falloff of the focused beam laser t2 (4800m -> 6000m).

NB.

Sarmaul
Brutor Tribe
Posted - 2006.05.31 19:53:00 - [88]
 

bug: small autocannons do not use t2 railgun ammo Wink

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.31 22:50:00 - [89]
 

Edited by: Naughty Boy on 31/05/2006 22:52:47
edit: double post.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.05.31 22:52:00 - [90]
 

Edited by: Naughty Boy on 08/06/2006 23:19:14
Download - b.13
Originally by: Sarmaul
bug: small autocannons do not use t2 railgun ammo Wink
Indeed, thanks for reporting this.

Changes in the last version
* Small AC t2 ammo bug reported above corrected;
* Bloodline III patch: Tracking changes (5% => 7.5% and 7.5% => 10%).

NB.


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