Excel: Virtual Shooting Range - Sort of

Excel: Virtual Shooting Range - Sort of

This is a discussion on Excel: Virtual Shooting Range - Sort of within the Off Topic & Humor Discussion forums, part of the The Back Porch category; I came across this while trying to figure out something else. I thought it was too neat to let it go to waste and the ...

Results 1 to 3 of 3

Thread: Excel: Virtual Shooting Range - Sort of

  1. #1
    Senior Member Array Caertaker's Avatar
    Join Date
    Mar 2012
    Location
    SE Michigan
    Posts
    1,118

    Excel: Virtual Shooting Range - Sort of

    I came across this while trying to figure out something else. I thought it was too neat to let it go to waste and the only group I could think of who might have a passing interest is right here. Hopefully someone might think it's cool (I desperately crave to be cool again).

    "Hi Folks, As a kid was fascinated with high power rifles, sniper rifles, cannons and in general, fast projectiles. As a kid I’ve been brainwashed with all sorts of urban legends about how far an AK 47 or a pistol can shoot or how thick a steel metal plate a bullet can penetrate at various distances. I’ve also watched some documentary about snipers and there were talking about highly bent trajectories, how much a bullet looses speed in flight and all that stuff. A lot of those questions in my mind were answered last night while making a “virtual tactical shooting range” in Excel. The nice part about this model is that it takes in consideration the aerodynamic drag with a constant Cx (drag coefficient guessed around 0.25 for a typical military bullet). You can select the shooting angle, muzzle velocity and you can also choose between eight different standard rounds whose names, weights and diameters I found on the internet: US military M193 Ball, US military M118 Special Ball, Palma Sierra MatchKing, LRBT J40 Match, Sierra MatchKing 7.62, Sierra MatchKing 8.59, LRBT J40 Match and LRBT J40 Match. Just hit “Fire” after adjusting the aforementioned parameters and you can plot the trajectory and the speed along the trajectory. The plot is auto scaled therefore the visual proportions are not accurate. You can see that a typical bullet has to climb a great deal and loose most of its speed, in order to be able to reach a target say, two miles away. This model completely changed my perspective on ballistics. Enjoy, George"

    2D Projectile Motion Model #1 ? a virtual tactical shooting range « Excel Unusual
    "I believe there are more instances of the abridgment of the freedom of the people by gradual and silent encroachments of those in power, than by violent and sudden usurpations” – James Madison 1788


  2. #2
    VIP Member Array lionround's Avatar
    Join Date
    Jan 2013
    Location
    Memphis
    Posts
    2,074
    OK, Caertaker I'll bite. What were you trying to figure out in Excel that led you to a site like excelunusual.com That is some pretty heady stuff there.
    If Barbie is so popular, why do you have to buy her friends?
    -- Steven Wright
    1950 Colt .38 Police Positive Special
    2013 SCCY 9mm CPX-2 Stainless Steel
    US Army 1973-1977, 95B

  3. #3
    VIP Member
    Array Jeanlouise's Avatar
    Join Date
    Oct 2012
    Location
    Almost Heaven
    Posts
    2,226
    Quote Originally Posted by Caertaker View Post
    I came across this while trying to figure out something else. Hopefully someone might think it's cool (I desperately crave to be cool again).
    again?
    It may be that your sole purpose in life is simply to serve as a warning to others.

    http://www.timeanddate.com/countdown...eaves%20office

Sponsored Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •