Calculate the distance of a bullet through water

Closed Posted May 18, 2014 Paid on delivery
Closed Paid on delivery

Hi,

I need help calculating the distance a handgun bullet would travel through water when shot at an angle between 20-30 degrees from a distance of aprox. 10 cm above the surface.

Idealy I would like an excel sheet where I can later edit the ballistic values as well as the angle.

As I have contemplated the problem I realize the calculations are quite straight forward once the bullet has penetrated the water surface. Here is an article online which gives an introduction to it:

[url removed, login to view]

What I understand requires slightly more contemplation is the physics relating to the shape dynamics of the bullet upon collision with the water surface.

To give you a better idea of what I am trying to find out; this video from Myth Busters almost answers my question:

[url removed, login to view]

The first weapon they test is a 9mm hand gun which they conclude is non-lethal at 8 feet depth. The problem is they fire the gun straight down which increases its reach. Later with the heavier weapons they relocate to a swimming pool where they fire at an angle. I want to know the distance the 9mm would travel if shot as in the second part of the show.

Online resources exist for ballistics calculations, they are just not adapted to water or air into water but many are open-source which perhaps might be useful as a starting point:

[url removed, login to view]

// If for example being able to regulate the angle or if a specific ballistic criteria would greatly complicate the job then I am willing to specify more exactly the angle or disregard a variable if the resulting outcome is not greatly affected.

/Regards Victor

Algorithm Excel Mathematics Matlab and Mathematica Physics

Project ID: #5957724

About the project

18 proposals Remote project Active Jun 24, 2014

18 freelancers are bidding on average $99 for this job

ognjen011

A proposal has not yet been provided

$84 USD in 3 days
(43 Reviews)
5.7
VolKa

Hi. I am sure I can do this (spreadsheet in excel) within 2-3 days. Regards, Vova.................. .

$80 USD in 3 days
(47 Reviews)
5.4
wahab14

A proposal has not yet been provided

$60 USD in 3 days
(18 Reviews)
5.1
freelanmohan7

Hi, Expert in numerical programming here. Your problem boils down to how you approximate the drag coefficient. If you have a way to approximate it, rest is simple to work on. The equations of motion for the bullet woul More

$155 USD in 3 days
(25 Reviews)
5.0
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc More

$221 USD in 5 days
(8 Reviews)
4.2
Is88

Hi Mechanical Engineer here. I can handle the task. 100% accuracy is guaranteed. Let the professionals deal with this. thanks

$60 USD in 3 days
(21 Reviews)
4.2
dimitarpartenov

A proposal has not yet been provided

$66 USD in 3 days
(13 Reviews)
4.1
jinjie2121

I am expert in Fluid dynamics. I have many experiences in simulation of bullet's motion in water. I am very familiar with these problem. I can help you well. Regards.

$60 USD in 2 days
(13 Reviews)
3.7
ajaykumar0701

If you want in excel, I will prepare a parameter estimation sheet for such a simulation and draw graphs for dependent variables like speed and distance by changing the independent variables like muzzle velocity, angle More

$54 USD in 3 days
(11 Reviews)
3.5
TheAVashe

I do Matlab projects on a regular basis including university assignments and research paper validations, algorithm implementations etc. involving general science, maths. I do literature survey as well to keep your stuf More

$60 USD in 3 days
(6 Reviews)
3.2
attpls

Hi Victor, You raise an interesting question regarding the dynamics of the bullet's shape once it hits the water. The physics of the bullet travelling through water is relatively simple if you assume the bullet rema More

$45 USD in 3 days
(1 Review)
2.4
uzair11235

i have completed this, i am using G1 standard projectile model and have implemented this in Matlab as an m file if you want i could make a GUI which would be more easier for you if you are not familiar with Matlab. I More

$250 USD in 0 days
(2 Reviews)
2.5
veraks

I am a master in aerospace systems. And have good understanding of dynamics and simulations. Love to explore new areas to learn and simulate them. I am fluent in MATLAB and Python.

$83 USD in 3 days
(0 Reviews)
0.0
DERRIC

I'am good in physics and i would like to solve this problem. saw this post on my mobile phone. as soon as i reach home. i'all solve this.

$222 USD in 3 days
(0 Reviews)
0.0
sajjad84

Hello,I am teacher of physics can solver you puzzles and complete this project in good way. Professionally I am electrical engineer having good knowledge of physics.

$155 USD in 3 days
(0 Reviews)
0.0
fo2shawy001

Aucune proposition n'a encore été fournie.

$50 USD in 2 days
(0 Reviews)
0.0
michailgeorgakis

Chemical Engineer, PhD Computational Chemist Ten years experience as an Academic Researcher and as a Chemical Engineer for the private sector. Experience and expertise in detailed literature/ bibliography Research More

$111 USD in 7 days
(0 Reviews)
0.0
arunpanwar

A proposal has not yet been provided

$55 USD in 3 days
(0 Reviews)
0.0