Twilight 2013 Weapon Stats

[pmulcahy11b]

I wold love to have Excel spreadsheets for weapon and vehicle creation in T2K13. Someone made some for me for use with T2K 2.2. My personal Excel-Fu in nonexistent, and I can't even fix or add to the spreadsheets I have except by organized fudging. Anyone out there with high Excel-fu belts able to help me out?

[ArmySGT.]

Originally Posted by pmulcahy11b

I wold love to have Excel spreadsheets for weapon and vehicle creation in T2K13. Someone made some for me for use with T2K 2.2. My personal Excel-Fu in nonexistent, and I can't even fix or add to the spreadsheets I have except by organized fudging. Anyone out there with high Excel-fu belts able to help me out?

I use Excel quite a bit for work. What do you need to do?

[Targan]

Originally Posted by ArmySGT.

I use Excel quite a bit for work. What do you need to do?

If I may offer my (albeit limited) assistance here, the main things you'd need to start with for the weapons creation spreadsheets would be a bunch of drop-down tables to reference to, and access to (or being able to reverse-engineer) the algorithms that the designers themselves used to create their T2013 weapon stats. In the latter regard I think Tegyrius' knowledge would be invaluable, but that knowledge may also be proprietary commercial information.

[Medic]

Though not requested, I decided to give a shot in creating another Finnish weapon for 2013.

7.62 KvKK 62

The Finnish light machinegun, now being phased out in the favour of heavier PKM machinegun. It, like the PKM, is used as a SAW and imbedded in every infantry squad. While frontline troops have already been equiped with the PKM, second line of reservists still field this very fast firing and accurate weapon.

The operation is mostly copied from the Czech vz. 52 machinegun. The weapon has no quick-changee barrel, but the hard-chromed barrel can withstand a huge volume of fire before heating up to a degree where it starts to bend (this has been tested by the author ). It has a very high rate of sustainable fire, around 1000-1100 rounds per minute, but individuals with experience with the weapon can actually use it to fire single shots (single shots posible by the decree of the GM).

The weapon has an integrated bipod as well as a carrying handle on the top as well as a suspender styled dual sling that allows stowing the weapon on the back like a rucksack (usefulness can be debated) and the cleaning rod is mounted on the side of the buttstock. For logistical purposes the KvKK, short for Kevyt Konekivääri (=light machinegun), uses the same 7.62x39mm cartridge as the Finnish assault rifle, which allows the squad to allocate ammo for the machinegun from it's own internal stores (and by the time of it's creation, from the most probable enemy, the USSR).

Many of those, who have gotten to handle and fire this weapon learn three or four things very quickly. First, the weapon is very, very accurate. Second, when assembling the weapon after cleaning it, be careful whe attaching the upper reciever to the lower, or you lose some skin as the parts slide in place and the recoil spring and rod asembly can be screwed in to place so that the weapon can neither be loaded or fired. Third, when firing blanks or weaker charges than the normal combat round (the Soviet/Russian M43), the heavy bolt assembly will not far enough to recharge the weapon and thus causing jams. Fourth thing is that the trigger assembly in the older weapons will most probably fail at some point, causing the weapon to cyclic through the remaining belt unless the gunner grasps the belt and yanks it, causing a missfeed.

Caliber 7.62x39mm
Capacity 100
Damage 7
Penetration x2/x3
Range M/S
Rate of Fire B4/B14
Speed 4/6/9
Recoil 6
Bulk 5
Weight 8.5kg
Barter Value GG1,300
Street Price $4,400

Stage III quirks:

Quirky Trigger: Once the Wear-value of the weapon reaches 6 or higher, roll twice for malfunctions with the latter roll recieving +1 to the actual Wear-value. If the second roll fails, the weapon enters in a 'wild fire'-condition, emptying the remaining rounds on the belt at the highest possible rate of fire, unless the gunner uses an action to stop it by yanking the belt. The trigger spring must be replaced after this, either by cannibalizing or manufacturing a new one.

Cold Tolerance: Built on standards to allow reliable operation in the Finnish climate, the weapons maintenance requirements are not raised by cold weather and extreme cold is treated like cold.

[Tegyrius]

Originally Posted by pmulcahy11b

I wold love to have Excel spreadsheets for weapon and vehicle creation in T2K13. Someone made some for me for use with T2K 2.2. My personal Excel-Fu in nonexistent, and I can't even fix or add to the spreadsheets I have except by organized fudging. Anyone out there with high Excel-fu belts able to help me out?

Originally Posted by Targan

If I may offer my (albeit limited) assistance here, the main things you'd need to start with for the weapons creation spreadsheets would be a bunch of drop-down tables to reference to, and access to (or being able to reverse-engineer) the algorithms that the designers themselves used to create their T2013 weapon stats. In the latter regard I think Tegyrius' knowledge would be invaluable, but that knowledge may also be proprietary commercial information.

Two items here.

First, Targan is unfortunately correct (it's not usually unfortunate that he's correct, just unfortunate in this instance). The ballistics formula and other design bible material are proprietary parts of the Reflex System. After 93GS ceased operations, ownership of Reflex reverted to Keith. While RPG.net wisdom is that you can't copyright game mechanics, I'm hesitant to test that beyond my own very limited (and "fair use") forays into supporting the remnants of the fan base. I'm even more hesitant about any action that would undermine any weapon- or vehicle-oriented products that a future owner of Reflex might want to release. I'm aware of four fans or fan groups who've attempted to contact Keith to secure the rights to the system, so that is still a going concern.

Second, a confession: the actual use of formulae, as opposed to guidelines and polite suggestions, is pretty limited. The ballistic characteristics themselves are the result of a formula Justin Stodola produced after I gave him a range of desired effects (which were, in turn, based on expected wound thresholds) and asked him to give me a ballistics calculator that produced those results for solid projectiles. We use the same formula for everything from .22 LR to 125mm tank rounds, albeit with some reducing constants applied for anything above the heavy machine gun class of ammo.

Values for body armor and light vehicle armor, in turn, are "engineered" off of the ballistic values, based on real-world performance. This is why one of my last actions as a member of the design team was to release a major erratum to vehicle armor values - I initially failed to do that for vehicles and we had a problem with battle rifles being able to take out MBTs with lucky hits. As several fans have inferred since, the original vehicle AVs in the core book, as well as those for MBTs and similarly heavy armor, use the same equivalencies that GDW used for the 2.0/2.2 rules.

For the rest of the small arms creation, a couple of other lesser formulas exist, but just as much of it involves comparing real-world performance data to established guidelines and going, "enhh, looks right in this light."

Sorry, guys. I know it's not the answer you were hoping for but it's the best one I can give at this time.

- C.

[pmulcahy11b]

Originally Posted by ArmySGT.

I use Excel quite a bit for work. What do you need to do?

I should probably start by emailing you the spreadsheets I have (which the author himself said were imperfect, but they are useable if used right), so you can get an idea of what I need.

You know, I don't know why I can't learn to use Excel better. I'm pretty good with Access -- it can't be much harder.

[ShadoWarrior]

Excel is easier to learn to use than Access. And there are more self-help books for it.

[DigTw0Grav3s]

Hey Tegyrius. Earlydawn here, from the 93 Games forums.

I was wondering if you could stat out a couple systems for me.

Magpul's Personal Defense Rifle

I'm assuming that I could just stat this out as a 10-inch M4 carbine, but I know you said that bullpups get some kind of revalued speeds on account of ergonomics.

Shoulder-launched Multipurpose Assault Weapon

I'm curious as to how this stacks up against the Carl Gustav. I think it's shorter ranged. The CG can supposedly reach out to 1,000m now with rocket assisted rounds. How would one work the integral spotting rifle into the rules?

As a bonus request, I've got a lot of people by me who have been playing Battlefield 3, so I'm sure I'm going to get some requests for flechette shells. I know these designs never really went anywhere for for shotguns, but if it did, how would you stat them out?

Thanks!