Ballistics Displayed My Way

Started by ThunderDownUnder, February 13, 2011, 06:36:20 AM

Previous topic - Next topic

ThunderDownUnder

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.



Uploaded with 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



admin

#1
Nice!

have look at =bfx_u(output_unit, value, input_unit)

ThunderDownUnder

#2
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.

admin

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.

ThunderDownUnder

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

admin

can you show me your =bfx_help(1)?


admin

it works with my excel2007 on a 32 bit machine:

ThunderDownUnder

Works fine on my 32bit machine as well, I'd loaded the update into the wrong location!
Thanks Admin!

ThunderDownUnder

#8
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

ThunderDownUnder

Made some minor improvements to the Compare Calibres spreadsheet.
Download here: http://www.safclass.com.au/Spreadsheets/BfX_MyBallisticSpreadsheetR3.xls

Ian