I made an excel 2010 file with a selection list and RE lookup for DPW. I think it needed to be 2007 or above (xlsx) in order to do the lookup.

I also did a E-Factor formula if you enter the mm or penetration
= 48 * 2.5^(3.322*(LOG(B13) - 1.4049))

You can use this if you have a prior version of excel where B13 is the pen value in mm.

I have never really used these formulas (my gaming system uses Guns, Guns, Guns), so if there are errors let me know.

For the excel file enter/select the data in the yellow fields and the results are in the green fields.

When I click on the attachment is downloads attachment.php, but if I rename it to "morrow_ex.xlsx" it works fine.

I'll go thru the formula to see how it stands up.

Thank you.

What browser?

No problem. I am addicted to excel ;)

IE 11.

It is most likely something stupid with IE11 security settings.

I see where I was wrong with my formula in my spreadsheet of formulas.

Nice!

Thanks guys!

That will speed up dropping some new systems to equip Morrow Project encounter groups.

or if there is an Invasion USA! Gamer out there.

Update to Chart
 

Instead of posting a new chart I'll just post the new ones instead;

Name, Key Ingredients, Replaces, RE

IMX-101, DNAN + NTO + NQ, TNT, 0.75
IMX-104, DNAN + NTO + RDX, Comp B. 1.00
PAX-48, DNAN + NTO + HMX, Comp B, 1.00
PAX-21 DNAN + RDX + AP + MNA, Comp B, 1.00
PAX-41 DNAN + RDX + MNA, Comp B, 1.00

** Key ingredients is not really necessary, but interesting to show **

Terms Used;

IMX: Insensitive Munitions eXplosives
PAX: Picatinny Arsenal Explosive
DNAN: Dinitroanisole
NTO: Nitrotriazolone
NQ: Nitroguanidine
RDX: Research Development eXplosive
MNA: n-methyl-p-nitroaniline
AP: Ammonium Perchlorate

Recoilless Rifle Munition M344A1
 

M344A1 HEAT

It uses 2.79lbs or 1 Kg of Comp B.

It will penetrate 300 mm RHA at zero degrees.

Updated!

The Bofors 3A-HEAT-T uses 1 Kg of Octol, so it will have a DPW of 2678.

The M344A1 should be 1.27 Kg of Comp B, not 1.0 Kg as I stated. So it's DPW will be 2962.

If you don't already have one........ get an account for scribd.com.

Many military manuals end up there, I have the ammunition data sheets for reference. Some posted the 2011 World Wide Recognition guide from the DoD there too.

Armor Level Protection to Armor Class
 

I did this a while back, but I worked out based on what various levels are suppose to stop and what E-Factor those weapon had and worked out the following chart.

ARMOR LEVEL PROTECTION

Level I Armor Class: 8
Level IIA Armor Class: 10
Level II Armor Class: 12
Level IIIA Armor Class: 14
Level III Armor Class: 18
Level IV Armor Class: 21


PASGT Helmet
Armor Class: 14
Weight: 1.65 kg
Covers 40% Front and 90% sides and back

PASGT Improved Outer Tactical Vest
Armor Class: 14
Covers: Torso, Shoulders, Upper Arms, Neck and Groin
Armor Class: 21 (4 Critical Plate, front, back and sides of torso, 70% coverage)
Complete Weight: 13.6 kg

PASGT MBAV (Modular Body Armor Vest)
Armor Class: 21
Complete Weight: 7.3 kg
Covers: Torso (4 ridged plates, front, back and sides) 70%

Batlskin Viper P2 Helmet
Armor Class: 14 (Level IIIA)
Weight: 1.15 kg
Covers: 40% Front, 80% sides and rear
Accessories: Viper Front Mount, Viper Three Position Visor (AR: 8)(0.275 kg) and Viper Mandible Guard Kit (AR: 10)(0.385 kg), designed for Comms Headset to be worn under helmet.

I worked this chart up awhile ago, and I like your chart as well. What do you think the AC is NIJ III+?

http://www.thesupplybunker.net/pdf/4...tings_v1.1.pdf

I'm working on an update for this chart as well. Transparent Armor (or Bullet Resistant Glass), is a little harder to find specs on it, but I'm making headway on this front.

NIJ III+??
 

I have the the Ballistic Resistance of Body Armor NIJ Standard - 0101.06 and I couldn't find a listing for Level III+. Technically there isn't even a Level V, but because of the protection provided of the highest level of Dragon Skin Body Armor the term Level V is applied and the specifications are classified by both DOJ, DOS and DOD. I just kind of guesttimated and could be as much as 4 to 6 points higher.

PS> Level III+ may refer to Level III with Stab Protection, So its Level III Ballistic Plus whatever rating of stab protection, normally Level I.

I've looked around for it as well. I see it referenced by a few manufactures, but don't see it in the NIJ standards either. I think it is NIJ III + AK47 resistant, but not completely sure.

I thought Dragon Skin was no longer made? And NIJ had withheld there certification of it as well.

Pinnacle Armor
 

Pinnacle Armor, the maker of Dragon Skin body armor, is still around as far as I have been able to find they are still making the armor along with other products. As of 2007 the Level III armor had NIJ certification of the 6 year operational life and the SOV-4000 (Level V) is made but is restricted to sale to government agencies only. SOV-2000 (Level III) and the SOV-3000 (Level IV).

http://upload.wikimedia.org/wikipedi...t_launcher.jpg

http://www.inetres.com/gp/military/i.../AT4/AT4_2.gif

http://upload.wikimedia.org/wikipedi...-AT4_image.jpg

SYSTEM
Alternative Designations: US M136, Bofors AT 4, FFV AT4
Date of Introduction: INA
Proliferation: At least seven countries
Description:
Crew: 1
Caliber (mm): 84
Weight (kg): 6
Length (mm):
Firing Position: 1,000
Travel Position: 1,000
Rate of Fire (rd/min): N/A (disposable)
Fire From Inside Building: See AT4 CS

SIGHTS
Name: INA
Type: Popup, preset to 200 m
Location: Top left
Night Sights Available: Yes, INA

VARIANTS (see NOTES)
LMAW: Light Multipurpose Assault Weapon, uses HEDP
AT4 CS: Confined space
AT4 HP: High penetration

AMMUNITION
Name: AT4 HEAT
Caliber (mm): 84
Type: HEAT
Range (m):
Effective: 300
Arming Range: INA
Penetration:
Armor (mm CE): 420 (E-factor 1958)
Weight (kg): 6.7
Muzzle Velocity (m/s): 285
Name: LMAW (see VARIANTS)
Caliber (mm): 84

Type: HEDP, modified Carl Gustaf HEPD FFV 502 (with dual mode fuze)
Range (m):
Effective: 300
Arming Range: INA
Penetration:
Armor (mm CE): 150 (E-factor 502)
Concrete (m): INA
Casualty Radius (m): INA
Muzzle Velocity (m/s): 235

Name: AT4 CS (confined space) can fire from confined spaces as small as 22.5 m3
Caliber (mm): 84
Type: HEAT or HEDP (LMAW) warheads
Range (m):
Effective: INA
Arming Range: INA
Penetration:
Armor (mm CE): 500 (E-factor 2466)
Weight (kg): INA
Muzzle Velocity (m/s): INA

Name: AT4 HP (high penetration)
Caliber (mm): 84
Type: HEAT
Range (m):
Effective: INA
Arming Range: INA
Penetration:
Armor (mm CE): 600 (E-factor 3138) (DPW = 1179)
Weight (kg): Less than 7
Muzzle Velocity (m/s): 290

http://i81.photobucket.com/albums/j2.../AT-4specs.png

http://upload.wikimedia.org/wikipedi..._2010_0660.JPG

http://www.imfdb.org/images/thumb/a/..._Grom_BMP1.jpg

http://www.militaryphotos.net/forums...2&d=1308305238

https://encrypted-tbn0.gstatic.com/i...nddoZJbnBxaUOe

Caliber, Type, Name: 73-mm smoothbore gun, 2A28/Grom
Rate of Fire (rd/min): 7-8
Loader Type: Autoloader
Ready/Stowed Rounds: 40 / 0
Elevation (°): -4/ +33
Fire on Move: Yes, but only 10 km/h or less (est)
http://www.kyklotron.com/rocket6.jpg
73-mm HEAT-FS, PG-15VNT (tandem HEAT)
Maximum Aimed Range (m): 1,300
Max Effective Range (m):
Day: 1,300, but 600 or less on the move
Night: 800-1,000
Tactical AA Range: INA
Armor Penetration (mm CE): 550-700 (RHA) (e-factor 2797 - 3847)

http://www.digplc.com/products/1/1.2.11.jpg
73-mm HEAT-FS, PG-15
Maximum Aimed Range (m): 1,300
Max Effective Range (m):
Day: 800, but 600 or less on the move
Night: 800-1,000
Tactical AA Range: INA
Armor Penetration (mm CE): 335 (RHA) (E-factor 1452)

http://www.digplc.com/products/1/1.2.22.jpg
73-mm HE, OG-15BG1
Maximum Aimed Range (m): 1,300, 600 or less on the move
Max Effective Range (m):
Day: 1,300, but 600 or less on the move
Night: 800-1,000
Tactical AA Range: INA
Armor penetration (mm): INA, can damage/defeat APC.
http://www.digplc.com/products/1/1.2.14.jpg
73-mm HE, OG-15VM
Maximum Aimed Range (m): 4,500
Max Effective Range (m):
Day: 1,300, but 600 or less on the move
Night: 800-1,000
Tactical AA Range: INA
Armor Penetration (mm): INA, can damage/defeat APC

United States 106-mm Recoilless Rifle M40

Oops, I have already done this one.

http://upload.wikimedia.org/wikipedi...agh_rocket.JPG

http://upload.wikimedia.org/wikipedi...0px-MGM-51.jpg

http://www.inetres.com/gp/military/c...llelagh_02.jpg
Name MGM-151-C Shillelagh Missile
Cal. 152mm
E-Factor = 2466 48 * 2.5^[3.322(log(500) - 1.4049)] = 2465.731375
DPW = 9643 (3.6kg Octol)
Wt. (Empty) 61.28 lb (27.8 kg)
Min. Range 800 yards (730 m) before the gunner can see it, to guide it. Semi Active Command Line of Sight (SACLOS)
Eff. Range 3000m
Max. Range 3000m
Burst Radius 5m
Type of Fire Breech loaded (M81E1 Gun/Launcher)
Rate of Fire Single
Feed Device n/a
Feed Device Wt. Manually loaded
Basic Load 9 in hull of 29 stowed rounds total (M551)
Load Wt.
Total Wt.
Additional Comments:15 pounds (6.8 kg) Shaped Charge Warhead including 8 pounds (3.6 kg) of Octol Explosives
able to defeat 15.5 inches of RHA at 0º obliquity[2]

Is there a version with the Explosives listed in alphabetical or grouped by type?

Also can A5 (98.5 to 99% RDX) be added?

Thanks!

http://i81.photobucket.com/albums/j2...ect/M430A1.png

CARTRIDGE, 40-MILLIMETER: HEDP, M430, M430A1
This cartridge is a high explosive, dual purpose, impact type round designed to penetrate two inches (three inches for the M430A1) of steel armor at 0 angle of obliquity and inflict personnel casualties in the target area. It is fired from 40mm Machine Gun MK19 Mod 3. Not authorized for use in M129 Grenade Launcher.
Warning! Use in the M203, H&K 469, or M79 will result in destruction of the weapon and severe injury or death of the operator.

Complete round:
Type --------------------------------- HEDP
Weight ------------------------------ 0.75 lb (340 g)
Length ------------------------------ 4.415 in.
Weapons used with ------------- MK19 Mod 1and Mod 3 40mm Grenade Machine Gun

Projectile:
Body material -------------------- Blanked and drawn steel
Color -------------------------------- Olive drab w/yellow markings and yellow ogive.
Filler and wieght ---------------- Comp A5, 38 g (32 g - M430A1) (E-Factor = 117. DPW = 43/ E-factor =201, DPW = 43)
Fuze --------------------------------- PIBD, M549
Propelling charge:
Cartridge case -------------------- M169
Propellant ------------------------- M2, 4.2 g
Primer ------------------------------ Percussion, FED 215

Performance:
Maximum range ----------------- 2,200 m
Muzzle velocity ------------------- 241 mps (790 fps)
Arming distance ----------------- 18 to 40 m (59 -131 ft)
Temperature Limits:
Firing:
Lower limit ------------------------ -65°F (-53.8°C)
Upper limit ------------------------ +125°F(+52.0°C)
Storage:
Lower limit ------------------------ -65°F (-53.8°C)
Upper limit ------------------------ +165°F(+73.9°C)
U.S. Army Pack:
*Packing

*Packing box: ------------------------------ 50 rounds in linked belt
Weight ------------------------------ 53 lb
Dimensions ----------------------- 26-3/8 x 16-1/4 x 6-3/16 in.
cube --------------------------------- 1.5 cu ft

Packing Box: ------ 32 rounds in linked belt
Weight ------------------------------- 42 lb
Dimensions ------------------------ 18.76 x 10.39x 6.36 in.
Cube --------------------------------- 0.72 cu ft

Composition A5 (98.5% RDX + 1.5% Stearic Acid) = 1.01

I am enjoying this discussion, but I do have a question. I was just comparing dpw numbers from the rules versus the calculation given here. There are some fairly large discrepancies. There are a few that I find perplexing and wonder if there is a reason. Take for example a TOW missile. It has about 3kg of LX-14, which is 95.5% HDX. Using the RE of 1.28, we get dpw of 8867 using the calculation. The rules show a dpw of 3120. My question is, would the fact that the warhead is a shaped charge inside a titanium form to direct the charge forward be the reason the dpw is lower? In my mind, that sort of makes sense, but does make dpw calculation just that much more complicated.

The data was classified in the 1970s when third edition was written..... These days the warhead data is much more public. The U.S. arms industries relies heavily on foreign sales to make U.S. equipment and R&D for future equipment so this is disclosed at arms expos.

LX-14 is used in the later models of TOW, the BGM-71A/B (which is most likely what is depicted in the game book) used 2Kg of Octol which is 1.16 which gives you 5357 Dpw, still doesn't come close to the published number, but I would guess based on the time frame the correct information would have been difficult to find based on the bibliography listed.

As you ask does the shaped charge account for the reduced Dpw, most likely this could answer that question.

Russian 82-mm Frag Projectile Model 0-832

Projectile fuzed mass: 3.41 kg
Fuze: M-1 PD
Filler: Schneiderite 0.40 kg
Using weapon(s): Mortar M1937 (M1942-M1943 version)
Remarks: Also uses M-2, M-3, M-4, MP, and MP-82 PD
fuzes

Anyone know what "Schneiderite" is and what the RE might be?

According to wikipedia it is the French name for Amatol with a formula heavy on the ammonium nitrate (7 to 1) and with dinitronaphthalene (DNN) replacing TNT.

Looking at the chart above with .32 for pure AN and .68 for a 50/50 mix with TNT (stronger than DNN i believe), I don't think you would get much past .40 but that is really a guess.

https://books.google.com/books?id=u2...losive&f=false confirms the wiki ratios and ingredients.

It looks like the name went out of favor right after WWI as all published references I can find are before 1917.

Thanks....... For some reason the Defense Intelligence Agency is still using this.......Likely a lazy researcher using direct translations from Soviet manuals. No effort to confirm or use modern terminology. Then again...... Soviet manual and archaic terms are a waltz to the numbers.

Defense Intelligence Reference Document
Projectile and Warhead Identification Guide—Foreign
Information Cutoff Date: January 1997

Range=(v^2*sin(2o))/g

Using as a white board for a moment.

Also, mortars general

To good not to share..... Rounds from 40mm and up. NATO and Soviet... by caliber, what weapon system, explosive filler, and amount.

Happy factoring! Attachment 3514


*Correction* NATO and primarily U.S. only.