open All Channels
seplocked Ships and Modules
blankseplocked Tanking Survivability Calculator (Update!)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.17 02:40:00 - [1]
 

Edited by: Aeaus on 29/12/2006 06:16:51
This is a small Excel Spread Sheet designed to help pod pilots optimize their ship tanks, without actually destroying ships in the process.

Essentially you enter your tanking statistics for up to four setups you want to test. Then the spreadsheet calculates how long your ship will last under various amounts of DPS (50-2500). The spreadsheet takes into calculation…

Shield Hit Points

Shield Recharge
Shield Resists
Shield Boost Rate


Armor Hit Points
Armor Resists
Armor Repair Rate


Structure Hit Points
Structure Resists


As we all know getting your tanks to be able to resist a certain amount of incoming fire is fairly straight forward, but calculating how long your tank will survive when dealing with more then that requires some hefty calculations, this spread sheet is designed to allow you to compare four setups (or even ships) and see which setup is most efficient. You will find many setups outperform in different categories, and thus you want to optimize for how much incoming fire you expect to take.

Example Graph Produced (Custom Values w/0.1.1)
Please visit your user settings to re-enable images.


Revisions
0.1.2
Added DPS to Break Sheet
Added Guide Sheet
Added Modifiers to Time/DPS and Doubled Custom Fields
Better Organization, ETC.

0.1.1
Updated with Tracking Calculations (Moved to 0.1.2)
Fixed Error with III + IV Graphs not factoring in Structure (whoops)
Updated with self-entry DPS

0.1.0
Updated with Shield and Structure calculations
Created separate pages for setups and EVEO graphs

0.0.1 – First Version Posted on SHC


Download
Latest Version : http://dl.eve-files.com/media/corp/Aeaus/TSC_0.1.2.zip
0.1.1 : http://dl.eve-files.com/media/corp/Aeaus/TSC_0.1.1.zip
0.1.0 : http://dl.eve-files.com/media/corp/Aeaus/TSC_0.1.0.zip

Helpful Hints
- For small gang warfare focus on 500-1500 DPS incoming damage, for bigger gang warfare focus on 1500-2500 DPS.
- Enter your setups in Quickfit and transfers resists over to spreadsheet
- Enter zero for Shield, Armor, and Structure to disregard a particular ship (exclude in calculations)

Sakura Nihil
Selective Pressure
Rote Kapelle
Posted - 2006.12.17 02:52:00 - [2]
 

Nice Cool.

Tricit
Caldari
Perkone
Posted - 2006.12.17 03:06:00 - [3]
 

I will follow you forever in a cloaked ship for this like a LOVER!!11

Cleron
Posted - 2006.12.17 05:27:00 - [4]
 

Great stuff !!

MellaRinn
Gallente
Veto.
Veto Corp
Posted - 2006.12.17 05:33:00 - [5]
 

awesome... DLzoringCoolCool

Goumindong
SniggWaffe
Posted - 2006.12.17 05:41:00 - [6]
 

Does it take into account capacitor size, use, and then the cap use of weapons or other systems also running as well as cap boosters?

I ask because that Apoc seems to be running an awful long time compared to that Thron.

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.17 05:44:00 - [7]
 

Originally by: Goumindong
Does it take into account capacitor size, use, and then the cap use of weapons or other systems also running as well as cap boosters?

I ask because that Apoc seems to be running an awful long time compared to that Thron.


No. This is pretty impossible to calculate without getting the calculations too complicated. It purely looks at the DPS the setup can tank. If you decide you want to full a BS full of capacitor charges you can run them for six minutes straight, the graph goes up to ten minutes so you had better hope your capacitor can cope with that. Anyways, you will very rarely get higher tanking times then your capacitor boosters will last for one fight, and if that's the case don't run your repairers continuously.

And yes, that Apocalypse is supposed to run more, it's a Tanking Apocalypse while we have a Ganking Megathron being compared, it's just for show here.

2SecondsTilMidnight
Posted - 2006.12.17 06:08:00 - [8]
 

How does it factor in resists? Average damage of the 4 types?

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.17 06:14:00 - [9]
 

Originally by: 2SecondsTilMidnight
How does it factor in resists? Average damage of the 4 types?


Yes, if you're so inclined you can set all resists to one value if you're focusing on some damage type in particular.

Goumindong
SniggWaffe
Posted - 2006.12.17 07:03:00 - [10]
 

Can you change the axis on the graph? [I dont have access to excell where I am, so i cant check]

It makes more sense to have DPS on the y and time on the x. At least it does to how my mind operates[I, and I assume others, associate length with horisontal movement and time and height with vertical movement and "bigness" which is better represents the damage/second numbers]

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.17 07:29:00 - [11]
 

Originally by: Goumindong
Can you change the axis on the graph? [I dont have access to excell where I am, so i cant check]

It makes more sense to have DPS on the y and time on the x. At least it does to how my mind operates[I, and I assume others, associate length with horisontal movement and time and height with vertical movement and "bigness" which is better represents the damage/second numbers]


I am adding on a graph to do that, but...

Both ways are perfectly valid, you may think of it as...

I can take this much of a beating, how long will I last?
or
I want to last this long, how much DPS should I take?

To me the first way of thinking about it makes more sense, most of the time you want to survive longer and see which tank allows you to do that.

Look at the sheet, it'll make sense.

Naughty Boy
Chronics of ordinary hate
Posted - 2006.12.17 12:22:00 - [12]
 

Interesting Very Happy

NB.

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.17 21:17:00 - [13]
 

Originally by: Naughty Boy
Interesting Very Happy

NB.


Unfortunately it looks like whine threads are more interesting for the forum goers =p


Plymer Ization
Infinitus Odium
Posted - 2006.12.17 22:21:00 - [14]
 

Great little tool, I just downloaded it and messed with some setups on the test server... interesting to see the differences between passive shield tanks and active shield tanks in this way.

Thanks for all your hard work Smile

Brady
Posted - 2006.12.18 00:27:00 - [15]
 

fantastic sheet m8.

Any chance of making the graphs allow for more dps? Some of my set-ups are poorly displayed as you've only allowed a max of 2500dps. Although this is fanatastic for new players and basic set-ups some of us carebears tank a tad more than 2500.


Brilliant piece of work though.Very Happy

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.18 00:32:00 - [16]
 

Originally by: Brady
fantastic sheet m8.

Any chance of making the graphs allow for more dps? Some of my set-ups are poorly displayed as you've only allowed a max of 2500dps. Although this is fanatastic for new players and basic set-ups some of us carebears tank a tad more than 2500.


Brilliant piece of work though.Very Happy


I will expand it later, although if you're refering to missioning or ratting, no mission puts that much DPS out on you (top is about 1500), the only carebearing thing that involves tanking more is doing high end complexes.

Roemy Schneider
Vanishing Point.
Posted - 2006.12.18 00:45:00 - [17]
 

too bad, signature and velocity can't be squeezed in these spreadsheets without total chaos Crying or Very sad

Terianna Eri
Red Federation
RvB - RED Federation
Posted - 2006.12.18 00:59:00 - [18]
 

holy crap
i love you Embarassed

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.18 01:00:00 - [19]
 

Originally by: Roemy Schneider
too bad, signature and velocity can't be squeezed in these spreadsheets without total chaos Crying or Very sad


Actually, it's not as difficult as you'd expect. I will add this feature in for the next version Smile

Ishekk
Posted - 2006.12.18 18:21:00 - [20]
 

Originally by: Aeaus
Originally by: Brady
fantastic sheet m8.

Any chance of making the graphs allow for more dps? Some of my set-ups are poorly displayed as you've only allowed a max of 2500dps. Although this is fanatastic for new players and basic set-ups some of us carebears tank a tad more than 2500.


Brilliant piece of work though.Very Happy


I will expand it later, although if you're refering to missioning or ratting, no mission puts that much DPS out on you (top is about 1500), the only carebearing thing that involves tanking more is doing high end complexes.


Maybe you could add a cell where we can put in our own dps number...for capital tanks etc

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.18 20:35:00 - [21]
 

Originally by: Ishekk
Maybe you could add a cell where we can put in our own dps number...for capital tanks etc


Already ahead of you. Will be releasing 0.1.1 today with custom DPS values, and an update for tracking.

Sokratesz
Rionnag Alba
Northern Coalition.
Posted - 2006.12.18 21:22:00 - [22]
 

Respect. I've been using excel for school and administrational purposes and sometimes it annoys the #*(&^# out of me but on times like this i feel like hugging you and MS.

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.18 21:58:00 - [23]
 

Originally by: Sokratesz
Respect. I've been using excel for school and administrational purposes and sometimes it annoys the #*(&^# out of me but on times like this i feel like hugging you and MS.


^^

I've released an update to the first version.

Bug Fixes:
Graphs III and IV were accidently trying to find non-existant data for structure, thus they did not take structure into account. This has now been fixed.

Features:
I have allowed people to enter their own custom values for DPS (Do I need more fields for this?), as well as created an eve-o style graph for these custom values. These are sorted by order in the sheet and not by values, so if you want nice graphs you will need to enter custom DPS in incrementing order.

Grez
Neo Spartans
Laconian Syndicate
Posted - 2006.12.19 00:26:00 - [24]
 

Edited by: Grez on 19/12/2006 00:36:45
Tool rocks :D

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.19 20:08:00 - [25]
 

Originally by: Grez
Edited by: Grez on 19/12/2006 00:36:45
Tool rocks :D


Great to hear *cough*Bump.

Embarassed

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.29 06:19:00 - [26]
 

Added a major update to the sheet.

A Welcome Screen will provide more abridged information as well as a guide to using the tool, from entering setups to reading the graphs produced, to a rundown of FAQs and known issues.

Surivability Sheet will now allow you to enter custom modifiers to change the DPS values used, as well as custom fields doubled.

DPS to Break Sheet finished and (hopefully) working flawlessly, now comes in a neat blue color.

Arondor
Digital Fury Corporation
Digital Renegades
Posted - 2006.12.29 07:35:00 - [27]
 

looks like a great tool, will test it when I get home from work.

many thanks

FraXy
0utbreak
Posted - 2006.12.29 18:16:00 - [28]
 

* FraXy hugs the new-found excel.. "Where have u been all my life??" Embarassed

Amazing work, i`ll be sending a small donation in-game for the work u`ve put into this to help u get motivated and i advice others to do the same.

Aeaus
The Black Rabbits
The Gurlstas Associates
Posted - 2006.12.29 22:22:00 - [29]
 

Originally by: FraXy
* FraXy hugs the new-found excel.. "Where have u been all my life??" Embarassed

Amazing work, i`ll be sending a small donation in-game for the work u`ve put into this to help u get motivated and i advice others to do the same.


Thanks, bug reports and suggestions are just as appreciated as well =) I'm sure there are quite a few I haven't discovered yet, especially with the program being pretty much doubled.

PoPa
Rionnag Alba
Posted - 2007.01.29 14:41:00 - [30]
 

Oh man.. this rocks! Just had to test out my archon build... this is fantastic.

I wish it would say how much DPS you could tank indefinately tho... it doesnt.


 

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