equipment mod, shield, weapon/bullet and engine data

[pref]

Game data export of

* Mods
* Weapons, Shields, Engines

in excel format


--- OP -----
I got the macro data for weapons and bullets in SQL, joined them on bullet class.
Just have no idea how could this end up on wiki conveniently (without much manual input i mean). Or if it has a place there at all. Probably has way more columns then necessary.
looks like this (just a sample, the link should have everything):

Spoiler

Show

Code: Select all

"weapontype","macro_name","mk","bullet","heat_overheat","heat_cooldelay","heat_coolrate","heat_reenable","rotationspeed","rotationacc","reload","reload_rate","reload_time","hull","hull_treshold","hull_hittable","storage_capacity","ammo","macro_name","speed","lifetime","bullet_range","amount","barrelamount","timediff","angle","maxhits","ricochet","bullet_scale","bullet_attach","selfdestruct","restitution","heat","heat_initial","reload_rate","reload_time","damage","damage_shield","repair","mining_multiplier","surface_multiplier","areadamage","areadamage_range","areadamage_falloff","areadamage_time","areadamage_lifetime","ammunition","ammunition_reload"
standard,turret_arg_l_laser_01_mk1_macro,"1",bullet_arg_turret_l_laser_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_laser_01_mk1_macro,"2041","3.219",,"1","2","0.001","0.02","1","0","0","0",,,,,,"2.4","367",,"0",,,,,,,,"3","0.5"
standard,turret_arg_m_laser_01_mk1_macro,"1",bullet_gen_turret_m_laser_01_mk1_macro,,,,,"210",,"","1","1",,"0.2",,,,bullet_gen_turret_m_laser_01_mk1_macro,"1855","1.844",,"1","2","0.019","0.32","1","0","0","0",,,,,"6",,"12",,"0",,,,,,,,"3","0.5"
standard,weapon_xen_s_laser_01_mk1_macro,"1",bullet_xen_s_laser_01_mk1_macro,"10000","1.13","2000","9500","101.4","50.7","",,,,,,,,bullet_xen_s_laser_01_mk1_macro,"2880","1.25",,"1","1","0.025","0.2","1","0","0","0",,,"54",,"13",,"18",,"0",,,,,,,,"7","0.65"
heavy,turret_arg_l_plasma_01_mk1_macro,"1",bullet_arg_turret_l_plasma_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_plasma_01_mk1_macro,"440","19.474",,"1","2","0","0.01","1","0","0","0",,,,,,"4.7","2420",,"0",,,,,,,,,
heavy,weapon_tel_s_charge_01_mk2_macro,"2",bullet_tel_s_charge_01_mk2_macro,"10000","1.13","2000","7500","58","29","",,,"500",,"0",,,bullet_tel_s_charge_01_mk2_macro,"1571","1.5",,"3","1","0.16","0.13","3","0.3","0","0",,"0.55","75",,"3",,"176",,"0",,,,,,,,,
energy,turret_arg_l_beam_01_mk1_macro,"1",bullet_arg_turret_l_beam_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_beam_01_mk1_macro,"7000","3","5000","1","1",,,"1","0","1","1",,,,,,"5","147",,"0",,,,,,,,,
energy,weapon_gen_s_burst_01_mk1_macro,"1",bullet_gen_s_burst_01_mk1_macro,"10000","1.13","2000","7500","180","180","",,,"500",,"0",,,bullet_gen_s_burst_01_mk1_macro,"96000","0.15","2000","1","1","0.05","2","1","0","1","1",,"1","718",,"6",,"74",,"0","7",,,,,,,"3","1.3"
energy,weapon_gen_s_burst_01_mk2_macro,"2",bullet_gen_s_burst_01_mk2_macro,"10000","1.2","2500","7500","180","180","",,,"500",,"0",,,bullet_gen_s_burst_01_mk2_macro,"96000","0.15","1800","1","1","0.05","2","1","0","1","1",,"1","720",,"6",,"47",,"0","13",,,,,,,"7","0.5"
capital,weapon_arg_l_destroyer_01_mk1_macro,"1",bullet_arg_l_laser_01_mk1_macro,"10000","1.13","2000","9500","32.3","16.15","",,,"8000",,,,,bullet_arg_l_laser_01_mk1_macro,"1659","6.3",,"1","1","0.002","0.03","1","0","0","0",,,"486",,"1.2",,"2588",,"0",,,,,,,,"3","2"
capital,weapon_tel_l_destroyer_01_mk1_macro,"1",bullet_tel_l_laser_01_mk1_macro,"10000","1.13","2000","9500","29.07","14.535","",,,"8000",,,,,bullet_tel_l_laser_01_mk1_macro,"1659","6.3",,"1","1","0.002","0.03","1","0","0","0",,,"475",,"1.44",,"1169",,"0",,,,,,,,"3","2"
mining,turret_arg_l_mining_01_mk1_macro,"1",bullet_arg_turret_l_mining_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_mining_01_mk1_macro,"7000","4","7000","1","1",,,"1","0","1","1",,,,,,"4","2",,"0",,"450",,,,,,,
mining,weapon_xen_m_mining_01_mk1_macro,"1",bullet_gen_m_mining_01_mk1_macro,,,,,"105",,"",,,,,,,,bullet_gen_m_mining_01_mk1_macro,"7000","4","4364","1","1",,,"1","0","1","1",,,,,,"4","2",,"0",,"300",,,,,,,
dumb,turret_arg_l_dumbfire_01_mk1_macro,"1",missile_dumbfire_heavy_mk1_macro,,,,,"40",,"",,,"5000","0.2",,"300",dumbfire,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
dumb,turret_tel_m_dumbfire_02_mk1_macro,"1",missile_dumbfire_light_mk1_macro,,,,,"60",,"",,,"1650","0.2",,"30",dumbfire,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Full file

[pref]

I had a little more time, made an excel out of it (shields, weapon+bullet, engines).

[GCU Grey Area]

I had a little more time, made an excel out of it (shields, weapon+bullet, engines).

Thanks for posting that. Very useful indeed. In particular was wondering if Split shields might have a particularly short Recharge Delay, to make up for their otherwise rather cruddy stats. Seemed a fair bit quicker in use but Recharge Delay is not in the encyclopedia, so couldn't sure that it wasn't just my imagination. Cheers Pref.

[Witzzard]

Thanks for the info dump.
Didn't realize that the Paranid destroyer main guns differ that much from the others. Though it has been a while since i looked last at them in comparison, so might also just be my memory.

Hm any info on what timediff and maxhits are exactly?

[pref]

Happy you guys could use it. I was hoping for a high split recharge rate and had enough of looking at the macros.
Some params might be AI only, no clue about timediff or hull threshold for ex.

I want to include mods later, it just needs a bit different query so i couldn't just copypaste it like the rest.
Or if that is already available someplace please let me know then i can skip that part.

[GCU Grey Area]

I was hoping for a high split recharge rate and had enough of looking at the macros.

Was really glad to find that there was at least something positive about Split shields. I mean, really didn't have a choice in the matter - I HAD to install them. Just couldn't face even one more landing in my Tuatara on my Cobra & having to look at those Teladi units. They just looked so out of place, spoiled the entire aesthetic. In hindsight though probably didn't need the Traction mod. +65% Recharge Rate is still quite handy, but -67% Recharge Delay is simply unnecessary with Split shields. Would have been quite useful to know about the Recharge Delay beforehand, sort of thing one might expect to be in the encyclopedia.

[pref]

In hindsight though probably didn't need the Traction mod. +65% Recharge Rate is still quite handy

Is there anything else that gets near 70% extra recharge? I really should export the mod data

And yeah i can imagine that ship looks terrible with lizard trash.

[GCU Grey Area]

Is there anything else that gets near 70% extra recharge?

Not that I know of. There's a few others that have Recharge Rate either as their primary function, or one of their potential secondaries, but they're all relatively modest increases (+20% is best I generally expect from green or blue mods, +30% from the purple Targe). Traction's the only real option if increasing Recharge Rate is the primary objective & works well for ludicrously fast ships (such as Cobra) that can easily get out of a fight, but then want to spend the minimum amount of time getting ready to return.

[pref]

Thanks.

Finished the mods excel too.

[GCU Grey Area]

Finished the mods excel too.

Nice one, thanks Pref.

[pref]

Have fun
The online converter i used for mods left out a couple bonus effects, had to update it.
Also on wiki at equipment/macro data.
Couldn't find a way to make a nice table out of it so just uploaded the excels