| Pages: [1] 2 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Aeaus
Tabula Rasa Systems
The Star Fraction
   |
Posted - 2006.12.17 02:40:00 -
[1]
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
Revisions
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.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
Tabula Rasa Systems
The Star Fraction
|
Posted - 2006.12.17 02:52:00 -
[2]
Nice  .
|
Tricit
Caldari
Dark Entropy
iPOD Alliance
|
Posted - 2006.12.17 03:06:00 -
[3]
I will follow you forever in a cloaked ship for this like a LOVER!!11
Tricit's dreamy ship statistics. PICTURES SOON MAYBE!!! (NOT YET, but they are drawn) |
Cleron
Antares Fleet Yards
SMASH Alliance
|
Posted - 2006.12.17 05:27:00 -
[4]
Great stuff !!
|
MellaRinn
Veto.
|
Posted - 2006.12.17 05:33:00 -
[5]
awesome... DLzoring
Click |
Goumindong
Amarr
Merch Industrial
|
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.
----------------------------------------
Thou Shalt "Pew Pew" |
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
2SecondsTilMidnight
|
Posted - 2006.12.17 06:08:00 -
[8]
How does it factor in resists? Average damage of the 4 types?
|
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Goumindong
Amarr
Merch Industrial
|
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]
----------------------------------------
Thou Shalt "Pew Pew" |
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Naughty Boy
Chronics of ordinary hate
|
Posted - 2006.12.17 12:22:00 -
[12]
Interesting 
NB.
In Rust We Trust |
Aeaus
Tabula Rasa Systems
The Star Fraction
|
Posted - 2006.12.17 21:17:00 -
[13]
Originally by: Naughty Boy
Interesting
NB.
Unfortunately it looks like whine threads are more interesting for the forum goers =p
Tanking Survivability Calculator
|
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 
|
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.
|
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
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.
Tanking Survivability Calculator
|
Roemy Schneider
BINFORD
|
Posted - 2006.12.18 00:45:00 -
[17]
too bad, signature and velocity can't be squeezed in these spreadsheets without total chaos 
|
Terianna Eri
|
Posted - 2006.12.18 00:59:00 -
[18]
holy crap
i love you 
|
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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
Actually, it's not as difficult as you'd expect. I will add this feature in for the next version
Tanking Survivability Calculator
|
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.
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
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Sokratesz
Guardians of Hell's Gate
Tactical Narcotics Team
|
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.
Basilisk Fitting Link |
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Grez
Minmatar
The Raven Warriors
|
Posted - 2006.12.19 00:26:00 -
[24]
Edited by: Grez on 19/12/2006 00:36:45
Tool rocks :D
---
Cache Clearer
Still waiting for a Wrangler-edit! |
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Aeaus
Tabula Rasa Systems
The Star Fraction
|
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.
Tanking Survivability Calculator
|
Arondor
GalacTECH Unlimited
|
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??"
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.
This is my lazy attempt to make
an uber-signature, please go away!
|
Aeaus
Tabula Rasa Systems
The Star Fraction
|
Posted - 2006.12.29 22:22:00 -
[29]
Originally by: FraXy
* FraXy hugs the new-found excel.. "Where have u been all my life??"
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.
Tanking Survivability Calculator
|
PoPa
Gallente
The Renegade Order
|
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.
---------------------------------------
- Signed, PoPa!
- = Join The Renegade Order Now! = - |
| |
|
| Pages: [1] 2 :: one page |
| First page | Previous page | Next page | Last page |