If you find any errors in the finished ships section feel free to share and I will try to fix them.
It should be noted I am using this to organize data for a mod I am working on so the last 20 or so columns are data I am playing with, they do not have any true relation to the game, though if you want to comment on improving those aspects I will likely be starting a thread for the mod within a week or so, or you can post them here.
XML version: (Finished ships sheet only)
https://docs.google.com/file/d/0B_zkf1P ... sp=sharing
ODS version: (All Sheets)
https://docs.google.com/file/d/0B_zkf1P ... sp=sharing
_______________________________________________
Ships Included in Data
275 common ships (99%+ finished data)
33 (odd ships extinct, quest, other mostly finished)
Approx 370 other ships started (mostly variants {raider, vanguard, etc..} lifeforms, goner, khaak)
Most ships from X3TC 3.1.1
Many ships from XTC 2.2
adding more ships and will update when done (1-2 weeks)
_______________________________________________
Spreadsheet has 4 sheets internally:
Finished Ships: has the 275 common ships I have 99%+ finished
All Ships: has every ship I have started work on many are only half finished
Extras: has 3 reference tables for main sheets or my use making this
Next to Do: list of next group of ships I am going to add
_______________________________________________
Fields on spreadsheet: (Using Eclipse as example)
Ship Identification Methods
17 -- #: Every ship is numbered for easy sorting
3.5 -- Size: gives a size number based on ship class, so sorting will group all M3_plus ships for instance.
Argon M3P -- Ship Type: gives Race and Ship Class
SS_SH_A_M3P -- Ship ID: same a seen in Tships
Eclipse -- Name: in game Name
7001 -- Name ID: name reference used by Tships
ships\m3\argon_M3P_scene -- Scene: Ships scene file for the 3D model used
Ship Performance Data Pulled From Tships (many of these are in odd units of measurement check next section for deciphered data)
0.376179 -- Yaw: Sidewards turn rate
0.316667 -- Pitch: Vertical turn rate
0.333333 -- Roll: Rate of spin along ship axis
29000 -- Speed: Base speed of ship
5550 -- Acceleration:
1050 -- Shield Power: used to determine shield regen rate
7300 -- Laser Energy: maximum weapon energy ship can store
0.023288 -- Laser Regen: how fast weapon energy replenishes
25000 -- Shield Type: largest type of shield ship can use by energy (1000 is tiny, 500000 is huge etc...)
6 -- Shield number: How many of these shields can be used
15 -- Speed Ext: How many speed extensions can be bought (10% faster per extension)
15 -- Steering Ext: How many steering extensions can be bought (affect Yaw, Pitch, Roll)
135 -- Min Cargo: Base amount of cargo space
305 -- Max Cargo: Maximum amount cargo space can be expanded to
0 -- Hangers: how many hangers are available (does not give type)
2 -- Cargo Class: 0=T, 1=S, 2=M, 3=L, 4=XL, 5=XXL, 6=ST
12500 -- Hull: How many hull points (armor) ship has
65630 -- Price Rel NPC:
25 -- Price Mod: These three affect ship price (not sure on formula)
65630 -- Price Rel Player:
2000 -- Notoriety: How much reputation you need to purchase ship
Ship Data Modified to Useable Format
Eclipse -- Name: Listed a few times so it easier to see which ships data you are looking at
145 -- Max Speed: Ships speed when all speed extensions are bought
11.1 -- Acceleration: is in MPS/s (meters per second / per second)
22.57074 -- Yaw: in rotations per minute
19.00002 -- Pitch: in rotations per minute
19.99998 -- Roll: in rotations per minute
12500 -- Hull: How many hull points (armor) ship has
150000 -- Max Shield: Shield strength assuming maximum number of shields for ship of the largest standard shield version it can use (using hard or military shields would raise this)
1050 -- Shield Regen: used to determine shield regen rate (same as shield power statistic)
7300 -- Laser Energy: maximum weapon energy ship can store
170.0024 -- Laser Regen: how fast weapon energy replenishes
24.1666666667 -- Base Maneuvering: (Number I made up has no in game existence)
0 -- Hangers: how many hangers are available (does not give type)
Ship Size From Image Export (I used print screen on an image of the ship in GMax to get good front, side, and top views. Then put it in GIMP and removed all but the ship and used histogram to get the number of pixels for each view. Note this is NOT ship size, but that can be calculated from this)
Eclipse -- Name: for reference again
4979 -- Front Pixels: Pixels in image along ships Z axis
11158 -- Side Pixels: Pixels in image along ships X Axis
14769 -- Top Pixels: Pixels in image along ships Y Axis
235 -- Length Pixels: Length of ship in image in Pixels
160 -- Width Pixels: Width of ship in image in Pixels
90 -- Height Pixels: Height of ship in image in Pixels
Ship Size From Model Data (directly pulled from model files)
ships\m3\argon_M3P_scene -- Scene: just for reference again
ships\\m3\\argon_M3P.bod -- Model File: file the scene point to
9982 -- Scale Factor: This tells the game how large to make the model
177432 -- Length Mod: This is the distance from the furthest point to the rear of the model to the point furthest forward
120427 -- Width Mod: This is the distance between the furthest points to each side
68556 -- Height Mod: This is the distance between the furthest points to the top and bottom
72343780518 -- Surface Area Mod: added area of every face in model file
Calculated Lengths, Areas, and Volumes
35.42 -- Length: (EXACT) Length of ship in Meters
24.04 -- Width: (EXACT) Width of ship in Meters
13.69 -- Height: (EXACT) Height of ship in Meters
113.77 -- Front Area M^2: (Accurate) Area in square meters the Front Silhouette of the ship covers
255.77 -- Side Area M^2: (Accurate) Area in square meters the Side Silhouette of the ship covers
334.51 -- Top Area M^2: (Accurate) Area in square meters the Top Silhouette of the ship covers
2883 -- Surface Area: (Accurate) would be exact except rarely a face extends into the model, or is internal
7.17% -- Portion of Box Filled: (Reasonably Accurate) If you made a rectangular box that perfectly fit the ship. This is how much of that box the ship would fill. (Close approximation likely 0-5% off except in rare cases)
835 -- Volume: (Reasonably Accurate) How many cubic meters of space the ship fills
Ship Part Sizes (This is all data I am working with in an effort to make ship sizes and loadouts make more sense and be more balanced these have nothing to do with the game {until I mod it
})1010.98 -- Eng Plasma: Plasma engines, using this term to refer to engines on most small ships
-- Engine Ion: Using this for capital and transport ships
60.65 -- Maneuvering: How much space maneuvering engines add (main engine gives some maneuvering in my present formulas)
42.95 -- Shield: how much space shield power generation and other shield related technology consume
323.62 -- Laser Energy/Regen: Space taken up by weapon energy generation and storage
132.01 -- Hull Space: How much physical space the hull takes up
-- Used Cargo: forgot to delete
-- Hangers: How much space Hangers consume(barely started)
-735.20 -- Total Empty: How much volume is not used by these parts in cubic meters (if negative the ships do not have enough space using these formulas)
-88.05% -- % Empty: Percent of the ships volume empty
Racial Modifications to Ship Part Sizes (These are computed referencing a table in Extras Sheet) {Also so far near everything is a 1 which has no affect}
Eclipse -- Name: Again for reference
1 -- R Eng Mod: How big this races engines are compared to standard
1 -- R Manu Mod: How big this races Maneuvering engines are compared to standard
1 -- R Shield Mod: How big this races shield systems are compared to standard
1 -- R Laser Mod: How big this races weapon systems are compared to standard
1 -- R Hull Mod: How big this races hulls are compared to standard
117059 -- Ship Hanger Size: How big of an internal hanger this ship uses (trying very hard to make this large enough that carriers in there present form make any sense, right now trying ships (Length*Width*Height * 10)+500 and it still way too small hehe)
% Percent of Volume Used (These are same as in Ships Part Sizes except by % of ships total Volume)
121.08% -- Eng Plasma
0.00% -- Engine Ion
7.26% -- Maneuvering
5.14% -- Shield
38.76% -- Laser Energy/Regen
15.81% -- Hull Space
0.00% -- Used Cargo
0.00% -- Hangers
-88.05% -- Total Empty
