Ballistics for Excel Forum

BfX => Member projects => Topic started by: ThunderDownUnder on February 13, 2011, 06:36:20 AM

Title: Ballistics Displayed My Way
Post by: ThunderDownUnder on February 13, 2011, 06:36:20 AM
BfX provides us with an opportunity to display our ballistic data in a way that makes comparisons easy. I have redone my previous spreadsheet and added some new features. It displays 10 calibres and loads side by side or 10 variations of one load if thats whats wanted.

BfX Functions Used In The Spreadsheet

BfX_Tx() for time of flight (tof) in spin drift calculation.
BfX_Vx() for velocity at 1000 yards.
BfX_Y() for wind deflection.
BfX_D() for bullet drop.
Updated revision now also uses BfX_U() for unit conversion.

Lots more of these functions are available and just waiting for me to try out!

My Spreadsheet Displayed My Way

   * Displays 10 calibres and loads side by side or 10 variations of one load if thats whats wanted.
   * Displays wind deflection.
   * Displays bullet drop.
   * Displays gyroscopic drift (spin drift).
   * Velocity at 1000 yards.
   * Recoil energy.
   * Separate stability calculator.
Updated version now includes metric/imperial unit conversion calculators.

(http://img577.imageshack.us/img577/5428/myballisticss1.jpg) (http://img577.imageshack.us/i/myballisticss1.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

Available for download from here: http://www.safclass.com.au/Spreadsheets/BfX_MyBallisticSpreadsheetR1.xls

Updated version on 18-02-2011 download from here: http://www.safclass.com.au/Spreadsheets/BfX_MyBallisticSpreadsheetR2.xls

Ian


Title: Re: Ballistics Displayed My Way
Post by: admin on February 13, 2011, 10:29:01 AM
Nice!

have look at =bfx_u(output_unit, value, input_unit)
Title: Re: Ballistics Displayed My Way
Post by: ThunderDownUnder on February 13, 2011, 09:12:09 PM
Whoops, I need to make zero appear as an output for gyroscopic drift in columns where Sg has not been entered. The drift value is correct except the value is meaningless if Sg has not been entered.

I looked at BfX_U() but could not see an application for it in the spreadsheet, what have I missed? All suggestions are very welcome!

Ian

Update: Fixed gyro drift to read zero if Sg data cell is empty. I have used the Excel 2007 IFERROR() function for the Recoil output cell and if you are wanting to use this spreadsheet with Excel 2003 just remove this function from the Recoil formula. If you are unsure how to do this then let me know and I'll have a version posted for Excel 2003 use.

I have been thinking about the BfX_U() suggestion and I could make the spreadsheet suitable for both metric and imperial using this function. It would take a little effort or someone else can modify this spreadsheet and post it for all to see.
Title: Re: Ballistics Displayed My Way
Post by: admin on February 14, 2011, 10:43:15 AM
yes, bfx_u allows that the user can specify his/her own units for in and output. This is not only handy for the metric/imperial units, but also if MoA or a distance is desired.
Title: Re: Ballistics Displayed My Way
Post by: ThunderDownUnder on February 14, 2011, 01:12:01 PM
Quote from: admin on February 14, 2011, 10:43:15 AM
yes, bfx_u allows that the user can specify his/her own units for in and output. This is not only handy for the metric/imperial units, but also if MoA or a distance is desired.
Robert could you please give an example of using moa and distance.

I tried =BfX_U("iphy",1,"moa") and the result gave me a NULL, the function works fine in other units for conversion. I am using Excel 2007 with your latest add-in.

Ian
Title: Re: Ballistics Displayed My Way
Post by: admin on February 14, 2011, 01:42:23 PM
can you show me your =bfx_help(1)?

Title: Re: Ballistics Displayed My Way
Post by: admin on February 14, 2011, 02:13:01 PM
it works with my excel2007 on a 32 bit machine:
Title: Re: Ballistics Displayed My Way
Post by: ThunderDownUnder on February 15, 2011, 06:03:54 AM
Works fine on my 32bit machine as well, I'd loaded the update into the wrong location!
Thanks Admin!
Title: Re: Ballistics Displayed My Way
Post by: ThunderDownUnder on February 18, 2011, 01:33:04 AM
I have used nested IF functions to make the spreadsheet compatible with both Excel 2007 and 2003 (also 2010) this allowed me to eliminate the Iferror() function from use. I have also added metric/imperial conversion calculators using BfX_U() functions. I think it is now an improved version and more useful than before.

IanP

http://www.safclass.com.au/Spreadsheets/BfX_MyBallisticSpreadsheetR2.xls
Title: Re: Ballistics Displayed My Way
Post by: ThunderDownUnder on March 05, 2011, 01:07:59 AM
Made some minor improvements to the Compare Calibres spreadsheet.
Download here: http://www.safclass.com.au/Spreadsheets/BfX_MyBallisticSpreadsheetR3.xls

Ian