• Welcome to the new COTI server. We've moved the Citizens to a new server. Please let us know in the COTI Website issue forum if you find any problems.

Custom Ship Weapons

T

teinedraig

SOC-8
Hi all,

This is my first post to this forum (and I have enjoyed reading the posts already here).

Anyway, I thing I wanted to try out was coming up with a custom system to design weapons for use in the ship design process (must be in my nature - I do reasearch and design on computer systems etc.). After playing around a bit I came up with a spreadsheet that allows me to design weapons that come in close to those in the main book but which allows me more lee way with what each ship has for weapons. I use type, range, TL and USP to determine the final Cost, Volume and EP

I have copied below a table of weapons designed this way - any comments or intrest in this?? (sorry about the format)

Weapon - the weapon name <Name TL Range - USP>
Vol - volume in vehicle units (don't ask _ I have been playing with the whole design process and got carried away)
MCr and EP - guess ;)
# Turret - Max that can fit in a turret
USP - USP of a single weapon (I have a formulae to calculate the USP of multiple weapons)
Range - I used the range in the book as the average and a max range of 2 to 3 times that.
Text - Weapon type

Weapon ID TL Vol Mcr EP # Turret USP Range Text Damage
Mining Laser TL7 15TKm - 1 1 7 324.844 0.344 0.713 3 1 15,000 km Mining Laser D6
Mining Laser TL7 30TKm - 1 1 7 543.375 0.525 1.260 2 1 30,000 km Mining Laser D6
Mining Laser TL9 15TKm - 1 1 9 292.359 0.309 0.641 3 1 15,000 km Mining Laser D6
Mining Laser TL9 30TKm - 1 1 9 489.038 0.473 1.134 2 1 30,000 km Mining Laser D6
Mining Laser TL12 15TKm - 2 1 12 259.875 0.275 0.570 4 2 15,000 km Mining Laser D6
Mining Laser TL12 30TKm - 2 1 12 434.700 0.420 1.008 2 2 30,000 km Mining Laser D6
Beam Laser TL7 30TKm - 1 2 7 328.125 0.625 1.313 3 1 30,000 km Beam Laser D8
Beam Laser TL7 60TKm - 1 2 7 630.000 1.200 2.700 2 1 60,000 km Beam Laser D8
Beam Laser TL9 30TKm - 1 2 9 295.313 0.563 1.181 3 1 30,000 km Beam Laser D8
Beam Laser TL9 60TKm - 1 2 9 567.000 1.080 2.430 2 1 60,000 km Beam Laser D8
Beam Laser TL12 30TKm - 2 2 12 262.500 0.500 1.050 4 2 30,000 km Beam Laser D8
Beam Laser TL12 60TKm - 2 2 12 504.000 0.960 2.160 2 2 60,000 km Beam Laser D8
Beam Laser TL15 30TKm - 3 2 15 196.875 0.375 0.788 4 3 30,000 km Beam Laser D8
Beam Laser TL15 60TKm - 3 2 15 378.000 0.720 1.620 2 3 60,000 km Beam Laser D8
Pulse Laser TL7 45TKm - 1 3 7 326.156 0.350 1.375 3 1 45,000 km Pulse Laser D10
Pulse Laser TL7 90TKm - 1 3 7 625.275 0.690 3.000 2 1 90,000 km Pulse Laser D10
Pulse Laser TL9 45TKm - 1 3 9 293.541 0.315 1.238 3 1 45,000 km Pulse Laser D10
Pulse Laser TL9 90TKm - 1 3 9 562.748 0.621 2.700 2 1 90,000 km Pulse Laser D10
Pulse Laser TL12 45TKm - 2 3 12 260.925 0.280 1.100 4 2 45,000 km Pulse Laser D10
Pulse Laser TL12 90TKm - 2 3 12 500.220 0.552 2.400 2 2 90,000 km Pulse Laser D10
Pulse Laser TL15 45TKm - 3 3 15 195.694 0.210 0.825 4 3 45,000 km Pulse Laser D10
Pulse Laser TL15 90TKm - 3 3 15 375.165 0.414 1.800 2 3 90,000 km Pulse Laser D10
Plasma Gun TL10 4.5TKm - 1 4 10 504.000 0.735 1.010 2 1 4,500 km Plasma Gun D12
Plasma Gun TL12 4.5TKm - 1 4 12 453.600 0.662 0.909 2 1 4,500 km Plasma Gun D12
Plasma Gun TL12 9TKm - 1 4 12 1,045.406 1.485 2.048 1 1 9,000 km Plasma Gun D12
Plasma Gun TL15 4.5TKm - 2 4 15 403.200 0.588 0.808 2 2 4,500 km Plasma Gun D12
Plasma Gun TL15 9TKm - 2 4 15 929.250 1.320 1.820 1 2 9,000 km Plasma Gun D12
Fusion Gun TL12 4.5TKm - 2 5 12 429.975 0.888 1.525 2 2 4,500 km Fusion Gun D20
Fusion Gun TL12 4.5TKm - 4 5 12 655.594 1.234 2.406 2 4 4,500 km Fusion Gun D20
Fusion Gun TL15 4.5TKm - 2 5 15 386.978 0.799 1.373 2 2 4,500 km Fusion Gun D20
Fusion Gun TL15 4.5TKm - 4 5 15 590.034 1.111 2.166 2 4 4,500 km Fusion Gun D20
Particle Accel TL14 30TKm - 2 6 14 347.813 0.725 4.063 3 2 30,000 km Particle Accel D8
Particle Accel TL14 50TKm - 2 6 14 439.688 0.875 5.938 2 2 50,000 km Particle Accel D8
 
Originally posted by teinedraig:
Hi all,
Click to expand...


Hi teinedraig, welcome aboard :D


This is my first post to this forum (and I have enjoyed reading the posts already here).
Click to expand...


And a most useful first post, I like it. Got more ;)

I have copied below a table of weapons designed this way - any comments or intrest in this?? (sorry about the format)
Click to expand...


No problem, or rather there is a fix, allow me to demonstrate the CODE feature (little button in the Instant UBB section).

I did change it a bit, streamlining it, hope I only cut out the repeated data and didn't mess up.

Comments to follow later, gotta get busy again


</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">Weapon TL Vol Mcr EP #/T USP Range Damage

Mining Laser 7 324.844 0.344 0.713 3 1 15,000 km D6
Mining Laser 7 543.375 0.525 1.260 2 1 30,000 km D6
Mining Laser 9 292.359 0.309 0.641 3 1 15,000 km D6
Mining Laser 9 489.038 0.473 1.134 2 1 30,000 km D6
Mining Laser 12 259.875 0.275 0.570 4 2 15,000 km D6
Mining Laser 12 434.700 0.420 1.008 2 2 30,000 km D6

Beam Laser 7 328.125 0.625 1.313 3 1 30,000 km D8
Beam Laser 7 630.000 1.200 2.700 2 1 60,000 km D8
Beam Laser 9 295.313 0.563 1.181 3 1 30,000 km D8
Beam Laser 9 567.000 1.080 2.430 2 1 60,000 km D8
Beam Laser 12 262.500 0.500 1.050 4 2 30,000 km D8
Beam Laser 12 504.000 0.960 2.160 2 2 60,000 km D8
Beam Laser 15 196.875 0.375 0.788 4 3 30,000 km D8
Beam Laser 15 378.000 0.720 1.620 2 3 60,000 km D8

Pulse Laser 7 326.156 0.350 1.375 3 1 45,000 km D10
Pulse Laser 7 625.275 0.690 3.000 2 1 90,000 km D10
Pulse Laser 9 293.541 0.315 1.238 3 1 45,000 km D10
Pulse Laser 9 562.748 0.621 2.700 2 1 90,000 km D10
Pulse Laser 12 260.925 0.280 1.100 4 2 45,000 km D10
Pulse Laser 12 500.220 0.552 2.400 2 2 90,000 km D10
Pulse Laser 15 195.694 0.210 0.825 4 3 45,000 km D10
Pulse Laser 15 375.165 0.414 1.800 2 3 90,000 km D10

Plasma Gun 10 504.000 0.735 1.010 2 1 4,500 km D12
Plasma Gun 12 453.600 0.662 0.909 2 1 4,500 km D12
Plasma Gun 12 1,045.406 1.485 2.048 1 1 9,000 km D12
Plasma Gun 15 403.200 0.588 0.808 2 2 4,500 km D12
Plasma Gun 15 929.250 1.320 1.820 1 2 9,000 km D12

Fusion Gun 12 429.975 0.888 1.525 2 2 4,500 km D20
Fusion Gun 12 655.594 1.234 2.406 2 4 4,500 km D20
Fusion Gun 15 386.978 0.799 1.373 2 2 4,500 km D20
Fusion Gun 15 590.034 1.111 2.166 2 4 4,500 km D20

Particle Accel 14 347.813 0.725 4.063 3 2 30,000 km D8
Particle Accel 14 439.688 0.875 5.938 2 2 50,000 km D8
</pre>[/QUOTE]
 
Thanks for showing me the code button (missed that one).

As to more - I have broken the design of turrets, barbettes (they can now hold all types of goodies and are a nice middle ground between turrets and bays for mid size ships), 50 and 100 ton bays and spinal mounts. I am now working on custom missiles (and adding a torp class as well).

I also saw some discussion on custom computers but never saw an outcome, which got me thinking - so I am working on that part of the spreadsheet as well.

As I am at work right now and all my files are at home I will post some of the new weapons up when I eventually get home.

As a bigger task I am trying to unify the vehicle and star ship construction process (ie use standrad measurements etc. As I am fairly hard core sci oriented I have tweaked a lot of stuff (which means my designs are not standard but given it takes but a couple of minutes to use my spreadsheet - what the hey ;) ).
 
Thanks for that - food for thought. It would be fairly simple to allow for a range of sizes in all areas as the spreadsheet I am using works out the number allowed by calculating the volume of the turret (or bay or spinal mount) usable for weapons (percentage) and then dividing the space by the size of the weapon to get the number allowed (you can specify any number).

Hmmm, love the challenge


Now that it is the weekend (so soon now) I will have time to put up more info and do some mods, and play some more and ..... ;)

Oh yeah - I have made it so that spinal mounts can be like bays etc in that they can be a collection of the same weapon rather then one big one - made more sense. Whoops - clients coming ... :(
 
Hi,

Just a quick post with some sample weapons from all size categories and some missiles. This uses a similar construction rule for all items and factoring an sliding scale for the effect of increasing base USP. For spinals I am playing with using either 125% or 150% of the volume as the final volume of the mount. You can mount more then one unit as a spinal as long as you have the space and can link them like batteries if they are identical.

Factors used are :
</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">TL Difference Modifier (weapons)
TL Gen Mod USP Mod
0 1 0
2 0.9 0
4 0.8 1
7 0.6 2
9 0.4 3
11 0.3 4
13 0.2 5

and for missiles and torps

TL Effect Xtra
TL Diff M Vol M Cost T Vol T Cost Dam Die
0 999 999 999 999 0
7 1 1.25 999 999 0
9 1 1 1 1.25 1
11 0.8 1 1 1 1
13 0.75 0.75 0.8 1 2
15 0.6 0.75 0.75 0.75 2
17 0.5 0.6 0.6 0.75 3
19 0.4 0.5 0.5 0.6 3

Range Mod – applies to Cost and Power and 75% to volume
% Turr Barb 50t 100t Spin
0 1 1 1.5 1.5 2.5
25 1.25 1.25 1.75 1.75 3.5
50 1.5 1.5 2 2 4.5
75 1.75 1.75 2.25 2.25 6.5
100 2 2 2.5 2.5 8

USP Mod – applies to Volume and Power and 50% to Cost
USP Mod
0 1
4 1.25
7 1.75
11 2.75
15 4.5
18 7.25
21 11.5
24 17.75
27 27
30 41.25

You can select the number of damage die for a missile or torp but it effects cost etc.
# Damage Die
# Missile Torp
1 1 0.6
2 1.5 0.8
3 2.5 1
4 4 2.5
5 99 4.5
6 99 7
7 99 10
8 99 99
9 99 99

You can also select the range
Range Table – Half to Vol & Full to Cost
Range Missile Torp
0 0.3 0.2
30000 0.5 0.4
60000 0.75 0.6
90000 1 0.8
120000 1.25 1
150000 1.75 1.4
240000 99 5
270000 99 99

And the USP (mods cost etc)
USP Table
USP Missile Torp
1 1 0.6
2 2 1
3 4 2</pre>[/QUOTE]And the weapons are (No torps yet - still playing with the cost /effect balance) :

</font><blockquote>code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">Turrets ID TL Vol Mcr EP # Turret USP Range Text Damage
Mining Laser TL7 15TKm - 1 1 7 324.844 0.344 0.713 3 1 15,000 km Mining Laser D6
Mining Laser TL7 30TKm - 1 1 7 543.375 0.525 1.260 2 1 30,000 km Mining Laser D6
Mining Laser TL9 15TKm - 1 1 9 292.359 0.309 0.641 3 1 15,000 km Mining Laser D6
Mining Laser TL9 30TKm - 1 1 9 489.038 0.473 1.134 2 1 30,000 km Mining Laser D6
Mining Laser TL12 15TKm - 2 1 12 259.875 0.275 0.570 4 2 15,000 km Mining Laser D6
Mining Laser TL12 30TKm - 2 1 12 434.700 0.420 1.008 2 2 30,000 km Mining Laser D6
Beam Laser TL7 30TKm - 1 2 7 328.125 0.625 1.313 3 1 30,000 km Beam Laser D8
Beam Laser TL7 60TKm - 1 2 7 630.000 1.200 2.700 2 1 60,000 km Beam Laser D8
Beam Laser TL9 30TKm - 1 2 9 295.313 0.563 1.181 3 1 30,000 km Beam Laser D8
Beam Laser TL9 60TKm - 1 2 9 567.000 1.080 2.430 2 1 60,000 km Beam Laser D8
Beam Laser TL12 30TKm - 2 2 12 262.500 0.500 1.050 4 2 30,000 km Beam Laser D8
Beam Laser TL12 60TKm - 2 2 12 504.000 0.960 2.160 2 2 60,000 km Beam Laser D8
Beam Laser TL15 30TKm - 3 2 15 196.875 0.375 0.788 4 3 30,000 km Beam Laser D8
Beam Laser TL15 60TKm - 3 2 15 378.000 0.720 1.620 2 3 60,000 km Beam Laser D8
Pulse Laser TL7 45TKm - 1 3 7 326.156 0.350 1.375 3 1 45,000 km Pulse Laser D10
Pulse Laser TL7 90TKm - 1 3 7 625.275 0.690 3.000 2 1 90,000 km Pulse Laser D10
Pulse Laser TL9 45TKm - 1 3 9 293.541 0.315 1.238 3 1 45,000 km Pulse Laser D10
Pulse Laser TL9 90TKm - 1 3 9 562.748 0.621 2.700 2 1 90,000 km Pulse Laser D10
Pulse Laser TL12 45TKm - 2 3 12 260.925 0.280 1.100 4 2 45,000 km Pulse Laser D10
Pulse Laser TL12 90TKm - 2 3 12 500.220 0.552 2.400 2 2 90,000 km Pulse Laser D10
Pulse Laser TL15 45TKm - 3 3 15 195.694 0.210 0.825 4 3 45,000 km Pulse Laser D10
Pulse Laser TL15 90TKm - 3 3 15 375.165 0.414 1.800 2 3 90,000 km Pulse Laser D10
Plasma Gun TL10 4.5TKm - 1 4 10 504.000 0.735 1.010 2 1 4,500 km Plasma Gun D12
Plasma Gun TL12 4.5TKm - 1 4 12 453.600 0.662 0.909 2 1 4,500 km Plasma Gun D12
Plasma Gun TL12 9TKm - 1 4 12 1,045.40 1.485 2.048 1 1 9,000 km Plasma Gun D12
Plasma Gun TL15 4.5TKm - 2 4 15 403.200 0.588 0.808 2 2 4,500 km Plasma Gun D12
Plasma Gun TL15 9TKm - 2 4 15 929.250 1.320 1.820 1 2 9,000 km Plasma Gun D12
Fusion Gun TL12 4.5TKm - 2 5 12 429.975 0.888 1.525 2 2 4,500 km Fusion Gun D20
Fusion Gun TL12 4.5TKm - 4 5 12 655.594 1.234 2.406 2 4 4,500 km Fusion Gun D20
Fusion Gun TL15 4.5TKm - 2 5 15 386.978 0.799 1.373 2 2 4,500 km Fusion Gun D20
Fusion Gun TL15 4.5TKm - 4 5 15 590.034 1.111 2.166 2 4 4,500 km Fusion Gun D20
Particle Accel TL14 30TKm - 2 6 14 347.813 0.725 4.063 3 2 30,000 km Particle Accel D8
Particle Accel TL14 50TKm - 2 6 14 439.688 0.875 5.938 2 2 50,000 km Particle Accel D8
Missile Launcher TL7 0TKm - 0 20 7 350.000 0.750 0.050 3 0 Missile Launcher
Missile Launcher TL9 0TKm - 0 20 9 315.000 0.675 0.045 3 0 Missile Launcher
Missile Launcher TL12 0TKm - 0 20 12 280.000 0.600 0.040 3 0 Missile Launcher
Missile Launcher TL15 0TKm - 0 20 15 210.000 0.450 0.030 4 0 Missile Launcher


Barbettes ID TL Vol Mcr EP # Barb S USP Range Text Damage
Particle Accel TL13 30TKm - 1 6 13 1,582.000 2.500 4.400 3 1 30,000 km Particle Accel D8
Particle Accel TL15 30TKm - 1 6 15 1,423.800 2.250 3.960 3 1 30,000 km Particle Accel D8
Particle Accel TL16 30TKm - 2 6 16 1,265.600 2.000 3.520 4 2 30,000 km Particle Accel D8
Fusion Gun TL12 6TKm - 2 5 12 722.400 2.300 1.900 7 2 6,000 km Fusion Gun D20

50 ton Bay ID TL Vol Mcr EP # Bay USP Range Text Damage
Fusion Gun TL10 15TKm - 3 5 10 1,617.000 5.450 4.150 32 3 15,000 km Fusion Gun D20
Fusion Gun TL12 15TKm - 3 5 12 1,512.000 4.995 3.915 34 3 15,000 km Fusion Gun D20
Plasma Gun TL12 15TKm - 2 4 12 1,890.000 4.050 2.790 27 2 15,000 km Plasma Gun D12
Meson Gun TL15 90TKm - 3 6 15 4,158.000 6.750 11.700 12 3 90,000 km Meson Gun D20
Particle Accel TL12 6TKm - 2 8 12 3,164.000 5.000 8.800 16 2 6,000 km Particle Accel D8

100 ton Bay ID TL Vol Mcr EP # Bay USP Range Text Damage
Fusion Gun TL10 20TKm - 3 5 10 2,114.000 7.200 5.400 49 3 20,000 km Fusion Gun D20
Fusion Gun TL12 20TKm - 3 5 12 1,959.300 6.570 5.040 53 3 20,000 km Fusion Gun D20
Particle Accel TL12 60TKm - 3 8 12 3,276.000 5.400 9.300 32 3 60,000 km Particle Accel D8


Spinal ID TL Vol Mcr EP # Mount USP Range Text Damage
Meson Gun TL13 360TKm - 21 8 13 1,532,317.500 1,428.300 4,802.400 1 21 360,000 km Meson Gun D20
Meson Gun TL15 360TKm - 21 8 15 1,379,085.750 1,285.470 4,322.160 1 21 360,000 km Meson Gun D20
Particle Accel TL13 105TKm - 21 6 13 202,067.578 226.406 694.313 1 21 105,000 km Particle Accel D8
Particle Accel TL13 480TKm - 21 6 13 2,231,460.000 1,932.000 6,706.800 1 21 480,000 km Particle Accel D8
Particle Accel TL15 105TKm - 21 6 15 181,860.820 203.766 624.881 1 21 105,000 km Particle Accel D8
Particle Accel TL15 480TKm - 21 6 15 2,008,314.000 1,738.800 6,036.120 1 21 480,000 km Particle Accel D8
Disintegrator TL16 360TKm - 21 10 16 1,339,192.969 1,255.800 7,983.300 1 21 360,000 km Disintegrator D20+D6
Disintegrator TL16 480TKm - 21 10 16 2,155,387.500 1,932.000 11,812.800 1 21 480,000 km Disintegrator D20+D6

Missiles ID TL Vol Mcr EP # Mag USP Range Damage
Nuc Missile TL7 90TKm - 2 20 7 50.000 0.0625 0.000 20 2 90,000 km Nuclear-6D6 damage Rad D12
Nuc Missile TL9 90TKm - 2 20 9 50.000 0.0500 0.000 20 2 90,000 km Nuclear-7D6 damage Rad D12
Nuc Missile TL11 90TKm - 2 20 11 40.000 0.0500 0.000 25 2 90,000 km Nuclear-7D6 damage Rad D12
Nuc Missile TL13 90TKm - 2 20 13 37.500 0.0375 0.000 26 2 90,000 km Nuclear-8D6 damage Rad D12
Nuc Missile TL15 90TKm - 2 20 15 30.000 0.0375 0.000 33 2 90,000 km Nuclear-8D6 damage Rad D12 </pre>[/QUOTE]
 
I have it in Open Office but that converts very well to Excel.

The design rules aren't quite finalised yet as I am now playing with allowing the designer to select the G's of the missile and also looking at options for guideance.

Guidance options so far played with are :
</font>
  • Standard (your basic T20 missile which appears to be guided by the gunner)</font>
  • Smart (can actively track a target after you have locked it on - TL gives some bonus to hitting / evading PD)</font>
  • Seeker (fire it off and it finds the target based on it's own scanning - lots of work on this yet)</font>
  • Mine (it waits around and uses IFF to attack targets)</font>
Other options (just ideas I have) could be
</font>
  • Follower (you fire them and they then follow the ship until targets are assigned)</font>
  • Flicker (able to do small jumps - torps only probably)</font>
  • Multi warhead (lots of smaller warheads to overwhelm PD's)</font>
  • ECM and ECCM</font>
  • PD Missiles</font>
You know, every time I post something here I end up coming up with a lot more ideas ..... :D

Anyway, when I have this all sorted out I will put it up somewhere - anyone got any ideas where is a good place to put this up?? :confused:
 
Originally posted by teinedraig:
I have it in Open Office but that converts very well to Excel.

<snip>

Anyway, when I have this all sorted out I will put it up somewhere - anyone got any ideas where is a good place to put this up?? :confused:
Click to expand...
Click the menu tab "fLibrary" right up at the top of the page. Then use the "Add a Resource" button the left. Easy, and thank you in advance :D
 
I have placed the spreadsheet on the download page for epople to play with. It is open office format as excel was 705K as opposed to 28K (ouch).

If you really want the excel version let me know.

The spreadsheet is a beta for the design of custom ship weapons and is a subset of a full spreadsheet for ship design based around integrating the vehicle design process. It allows you to select TL, Range, USP and type and then calculates the Volume (uses volume not dTons - divide by 1400 to get dTons), MCr and EP for the weapon as well as the maximum that can be installed in a turret, barbette or bay. Spinals are also included.

Has a very draft version of a missile creator that has added rockets (smaller missile with short range) and Torps (big missiles) but these are very draft.

Lastly, it has a battery USP calculator - see how it goes


Have fun!!
 
You must log in or register to reply here.

Similar threads

Spinward Flow
CT Only: 16 ton Light Fighter (TL=9)
Replies
12
Views
1K
Spinward Flow
Spinward Flow
A
calculating Hybrid SLM cost
Replies
4
Views
203
Apricus
A
Spinward Flow
CT Only: 30 ton Strike Fighter (TL=11)
Replies
16
Views
1K
kilemall
K
Spinward Flow
CT Only: Five Sisters Clipper (Iderati evolution)
Replies
10
Views
453
Spinward Flow
Spinward Flow
Spinward Flow
CT Only: Long Night Tramp
Replies
18
Views
619
Spinward Flow
Spinward Flow
Back
Top