Ballistics for Excel Forum

BfX => Ballistics => Topic started by: gvp on December 21, 2020, 01:15:46 AM

Title: Shotgun Ballistic Calculator
Post by: gvp on December 21, 2020, 01:15:46 AM
I've made a very simple excel file in order to calculate Velocity, Energy and TOF for shotgun BB's.
1. What is the BB's ballistic coefficient ? Can it be calculated ?
2. Any idea how to make this simple excel file more reliable according to atmospheric conditions and the subsonic, transonic and supersonic region ?

Thank you in advance,
Bill
Title: Re: Shotgun Ballistic Calculator
Post by: admin on February 09, 2021, 10:49:05 AM
I couldn't resist googling. Since 2008 some scientific papers were produced on the matter. https://www.sciencedirect.com/science/article/pii/S2214914717301459 has an interesting one which I quickly scanned
you can use it to check your table.
Next posts on the bc calculation
Title: Re: Shotgun Ballistic Calculator
Post by: admin on February 10, 2021, 03:01:36 PM
I have (re)done the research.

The ballistic coefficient is computed from m/(d*d) where m is the mass of the pellet in lb and d its diameter in inch

or bc = density*pi*d/6

density lead = 0.41 lb/in^3
density steel = between 0.280 and 0.291 lb/in^3
The drag function to use is "GS" in bfx which matches the one in the above link

Title: Re: Shotgun Ballistic Calculator
Post by: admin on February 10, 2021, 03:07:15 PM
e.g.  .50 round lead ball bc= 0.107 lb/in^2
Title: Re: Shotgun Ballistic Calculator
Post by: admin on February 10, 2021, 04:09:34 PM
by the way,
bfx looses accuracy for elevations above 15 degrees. In practice this affects max range / long distance calculations.