Small Arms damage with range (probelm)

[Milano]

So.. I have broken my ankle and cannot work. All I can really do is go through my old House Rules and such and mess up the rules and system I already have put alot of work into. (Still bored to death.. going to plow ahead however.)

I have changed my weapons program to include Ballistic Coefficients so that damage at a given range can be scientific fact, as opposed to an assumption.

The biggest problem that I am having currently is that many of the values are odd given that the Fire Fusion and Steel formulas don't take into account velocity. I have substituted the real Joules Energy to take affect of this but... now it doesn't accout for differences of caliber. Like 5.56 vs 7.62x39.

I offer this to the community as a FYI program that is interesting. (Maybe only to me but..) I need to automate it but offer it now as a beta test. I have included a XLS document with a listing of different BCs for alot of different bullets. Input the BC1 into the XLS program called "Weapon Creator" Get the info on your favorite rifle form the internet and see how effective it really is. (Please ignore the Sectional Density portion. I am working on the penetration values and that I will go through later, if I don't heal rapidly.)

I have included a few of the standard weapons with different ammunition types. (AKM, M16A2, M24, M2HB)

Please let me know what you think. Or, what I should do (Other than not waste my time because that is REALLY the object of all this.)

Ummm.. New problem.. I figure that if you are reading this you may be interested, or also have broken bones. I cannot upload my two files. If you are interested in these could you please tell me how to do this or why I am not able to upload them.