Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.02.23 07:23:00 -
[1]
I thought interesting to have some little tool to compare and choose subsystems to build t3 ships (at least before gripen build a new EFT with T3 ships in it :p)
So I've made a calc spreadsheet with : - one tab by subsystem type with stats and bonus for each subsystem and race - one tab by race with all possible combinations of the four subsystems (defense, offensive, electro, engineering) that have an effect on slot layout (by default, each combination uses the 1st propulsion subsystem which only modify speed). All column has been associated with a filter so you can chose which stat you want and see which combination gives it. For intance, to display all subsystems combination that gives 3 low slots, just click the little black arrow next to "lows" and select 3.
The calc spreadsheet for build 80627 is Here. In the zip file there is also a .xls for those of you who don't have Ooo.
Please remember this is SiSi data and not final, I'll try to update it with new build data as soon as they're made public. (for instance some combination of tengu subsystems actually gives 9 med slot, which obviously won't make it M10)
|
Kuromugi
Caldari Beets and Gravy Syndicate The InterBus Initiative
|
Posted - 2009.02.23 07:46:00 -
[2]
Quote: Please remember this is SiSi data and not final, I'll try to update it with new build data as soon as they're made public. (for instance some combination of tengu subsystems actually gives 9 med slot, which obviously won't make it M10)
lol yea noticed it, anyways nice job, I was thinking about taking the time and putting something together but it would of took more time than i had.
|
SSteejans
Blanchards Innovative Technologies
|
Posted - 2009.02.23 08:02:00 -
[3]
neat thing you made there. that will be helpful for finding what kind of combos are valid with a certain other subsystem.
i hope you update it as the stats are updated too _______________ if CCP's logs really never show anything, i have to wonder, do they even have logs? |
Thorson Wiles
Minmatar M3 Co-Op
|
Posted - 2009.02.23 11:36:00 -
[4]
Originally by: SSteejans edit2: can you explain the difference in the two files? one is 76kb and the other is 569kb but they both appear to be identical
The smaller file is an Open Office spreadsheet the other is one of the Excel formats. (Which Open Office can read/write)
And they are identical.
|
Freyya
GeoCorp. Paxton Federation
|
Posted - 2009.02.23 12:04:00 -
[5]
You sir, are epic, won the dev forums and made my day in one.
I was already working on a database myself during work but you just made it better than i would have thought of and will allow me to start doing some actual work again....I am a bit doubtfull if all combo's are actually in but i could be mistaken in my calculations and will take your word on it just because you made my day. It's a bit of a shame though that you didn't include the other 2 propulsion subs in it since they give out bonuses which affect different stats aswell. Might be something for the new update .
Epic, good sir, epic. ___________
NOW COLLECTING ISD AND CCP AUTOGRAPHS It'll be worth something someday. -Rauth
|
Seishi Maru
M. Corp Mostly Harmless
|
Posted - 2009.02.23 12:28:00 -
[6]
Sorry to say it does not match with what you get on sisi.
For example I have a matar setup that have in server less than half the armor HP that is listed in your table
|
Janus Ovellian
Minmatar Calpolli Namtz' aar K'in
|
Posted - 2009.02.23 15:11:00 -
[7]
Originally by: Seishi Maru Sorry to say it does not match with what you get on sisi.
For example I have a matar setup that have in server less than half the armor HP that is listed in your table
This is probably because the armor hitpoints listed on SISI are screwy atm. There are two data types - one called "armor hitpoints", one called "armor hp bonus" - only the second does anything.
Also, mass additions still don't work, and a number of subsystems that should add turrets currently do not.
Interesting times await... |
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.02.23 18:38:00 -
[8]
Originally by: SSteejans
edit: you missed EM resists on shields. there is no column for it.
I was lazy and all shield stats for subsystems were 0 (perhaps I missed something here ?.. ) so I didn't include them in the setups result.
I'll add it in the next version
|
SSteejans
Blanchards Innovative Technologies
|
Posted - 2009.02.23 18:59:00 -
[9]
Originally by: Ol' Delsai
Originally by: SSteejans
edit: you missed EM resists on shields. there is no column for it.
I was lazy and all shield stats for subsystems were 0 (perhaps I missed something here ?.. ) so I didn't include them in the setups result.
I'll add it in the next version
one of the minmitar subsystems gives shield em resists. aka T2 resists. ;) _______________ if CCP's logs really never show anything, i have to wonder, do they even have logs? |
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.02.26 19:54:00 -
[10]
The spreadsheet has been updated with new data from built81762 plus some bug correction and more calculation as asked
The new file can be downloaded Here
|
|
Turiel Demon
Minmatar Inhumation Inc.
|
Posted - 2009.02.26 21:54:00 -
[11]
Great work, thanks! :D
|
Freyya
GeoCorp. Paxton Federation
|
Posted - 2009.02.26 23:29:00 -
[12]
Edited by: Freyya on 26/02/2009 23:32:08 Bump to show epicness to other people...Great work
Hmm eve files is having trouble patching me through to the file... CHRIBBAAAAAA! Hamsters need feeding ___________
NOW COLLECTING ISD AND CCP AUTOGRAPHS It'll be worth something someday. -Rauth
|
Sigras
|
Posted - 2009.02.27 00:45:00 -
[13]
holy data entry
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.02.27 08:56:00 -
[14]
Originally by: Freyya Edited by: Freyya on 27/02/2009 08:17:57
Seems like you removed the selection filters? Or did you forget to add them because they where dandy handy quite alot
oups ... my mistake, they were removed for all races but caldari (caldari rules :p)
corrected - new file to download
|
Pliauga
Gallente Aliastra
|
Posted - 2009.02.27 09:43:00 -
[15]
Thnx, very usefull.
------- "Skynet" is my internet provider, should I be worried? |
Virgo I'Platonicus
Chimera Raiders
|
Posted - 2009.02.27 10:05:00 -
[16]
Take for example examples 85 and 86 in your spreadsheet. They show 3 high slots, but 5 launchers. Can you explain?
V. <3 |
Mrs Snowman
|
Posted - 2009.02.27 11:02:00 -
[17]
Originally by: Virgo I'Platonicus Take for example examples 85 and 86 in your spreadsheet. They show 3 high slots, but 5 launchers. Can you explain?
V.
I think this is something for CCP to explain, because I have had it so I have 6 high slots with 7 turret hard points...
I guess its intentional
|
Virgo I'Platonicus
Chimera Raiders
|
Posted - 2009.02.27 11:22:00 -
[18]
Interesting intentions :))
V. <3 |
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.02.27 16:55:00 -
[19]
Originally by: Sigras holy data entry
yep !!
hopefully, only 3 variations per subsystem will be released M10... With 5 variations per susbsystem there would be 12 times more data oO
|
Turiel Demon
Minmatar Inhumation Inc.
|
Posted - 2009.02.27 21:19:00 -
[20]
You're asking for less content so that it will be easier to spreadsheet?
|
|
Terminus Vindictus
|
Posted - 2009.02.27 22:53:00 -
[21]
Holy spreadsheet, Batman!! That's awesome. I was wondering when someone was going to descipher all the different combinations of modules. Now to make the trillions it'll take to build my very own T3... er... cruiser... LOL
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.03.01 08:24:00 -
[22]
Edited by: Ol'' Delsai on 01/03/2009 08:25:13 Edited by: Ol'' Delsai on 01/03/2009 08:24:52 New build = New spreadsheet.
You can download it Here
Changes :
- Accross the board CPU nerf (was already a big problem on tengu ship, most of them now can't be properly fitted without empty slots even with co-processor and implants)
- Accross the board targetting range boost
- tech 2 resist on all defensive subsystems
- Accross the board Powergrid nerf
- Accross the board Capacitor capacity big boost
- Offensive and Propulsion subsystems untouched
|
Draknishar
Directive XIII
|
Posted - 2009.03.01 11:05:00 -
[23]
lack of CPU aside I think the weirdest thing is having 20mbit bandwith on the amarr ships, even if the fourth and fifth parts would supposedly have more it just feels plain weird to me. :)
my whining aside, great job. :)
|
Mahai Ano
Gallente Center for Advanced Studies
|
Posted - 2009.03.01 12:46:00 -
[24]
AFAIK, there was also a dronebay nerf for Gallente, 175m3 of defense 3 became 150, but can't check now...
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.03.01 13:41:00 -
[25]
Originally by: Mahai Ano AFAIK, there was also a dronebay nerf for Gallente, 175m3 of defense 3 became 150, but can't check now...
Oh yes, you're right I've missed it :/ Will correct that for the next verion
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.03.02 06:36:00 -
[26]
Originally by: Turiel Demon You're asking for less content so that it will be easier to spreadsheet?
Yes, I am
Hmmm wait, ... no, of course I'll love to have more susbsystems to play with... I'm a calc warrior !!!
In fact it was to make the spreadsheet easier to read for the common capsuleer
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.03.04 22:13:00 -
[27]
A great build for Tech 3 ships ==> a new spreadsheet can be find Here
There's a new tab where you can put your subsystems skills (it is names "skills") they are fixed by default at 4 but you can change them. The subsystems bonus are then automatically included in the data with the right skill value
there was a lot of change in this build (CPU boost ... for everyone but matar :p) so there might be some error in the spreadsheet.
Enjoy
|
Ol' Delsai
Caldari Kernel of War Tau Ceti Federation
|
Posted - 2009.03.09 13:19:00 -
[28]
I'll now update the spreadsheet in the ship section. The new thread is There
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |