BfX

F o r u m

Home
Visit the BfX  f o r u m
About BfX
Install/Update
Downloads
Excel/VBA settings
Entering formulas
Drag functions
Robert Meijer

Ballistics for Excel

News, August 2013: New build and extended for Excel 2013.

BfX allows shooters familiar with Excel to create customized calculations, graphs and tables. With BfX, Excel becomes a great way to calculate rifle settings, to calibrate a scope or iron sights, to explore trajectories, to study the effects of wind even if it varies in magnitude and direction along the bullets path. Metric and imperial units can be used, help is at hand, BfX is accurate and  fast. 

BfX works with Windows XP, Windows 2007, Windows 7, Windows 8 (likely, I did not test it),  Excel 2003, 2007, 2010 and Excel 2013. Both 32bit and 64bit versions of Excel are supported.  BfX is used as a regular Excel add-in (dynamic link library). Excel add-ins add new functions to Excel—and with just dragging and linking cells you create your tables and graphs—ballistics as you need it!

What others say ...

In January 2011 the South Australian F-Class Association wrote about BfX and created a bullet comparator ("I ... didn't get a headache or even raise a sweat"), read more.... In Februari 2011 they published an interview.

The creator of BfX at the Dutch 300m prone rifle championships in 2008, read more ...

Contact:
Via the Forum (membership required)

or use

=Bfx_Info(-2)

in Excel to retrieve an email address

Example

The following example shows the ease of use of BfX.The formula entered calculates the trajectory heigth for a bullet with a muzzle velocity of 740 m/s, and which is shot with a rifle having a front sight heigth of 3,4 cm. The impact is at 0 cm above the point at aim at 300 m. The path heigth at 200 yards is calculated. The ballistic coeficient entered is 0,23 lbs/inch2 and the G7 drag function is used. The result is 0,24 m. If no units are given, BfX expects metric ones as input (except for the ballistic coeficient). Outputs are by default also metric, and can be easily converted to other units, by just specifying the desired unit as the first parameter.



Row 1 shows the BfX feature get instant help on a function, here BfX_Zx, and row 2 shows the result. Note that this is a typical European notation for Excel input, elsewhere you may have to type =BfX_Zx(740,3.4,"cm",0,300,200,"yd",0.23,"g7").  Read more about entering formulas here ...


BfX appears as a set of Excel functions (top). BfX is programmed in C++ and is loaded in Excel as an add-in (left).

Visit the download page for Excel workbooks that teach you using BfX and how to use BfX in Visual Basic for Applications (VBA).

The physics behind BfX is carefully derived, the software is cross checked, read more...


BfX supports various drag functions, including G7 and one for air rifles , you even can supply your own !!!, read more...


BfX can be used in VBA programs with which quite complicated applications can be build. Here an example of a multi distance match simulator.
Last modified on:
Sunday, 11-Aug-2013 21:10:07 CEST

Warning. The use of BfX is entirely your responsibility. It is free to use in private and non-commercially — and it comes without any guarantee.

(c) Robert Meijer, Netherlands