⚠ Work in Progress: We are currently updating and modernizing the website. Some pages might temporarily look older.
BfX Logo

BfX

Ballistics for Excel

F o r u m

Home Visit the BfX forum
What is BfX? Download the bfx64.xll add-in, include it in 64-bit Excel, and you can instantly perform fast, incredibly accurate ballistics calculations right inside your own spreadsheets by simply linking and dragging cells.

Update August 2026: The download system and 64-bit installers have been modernized and are fully operational.

August 2026 - Recompilation with latest modern toolsets

BfX allows shooters familiar with Excel to create customized calculations, graphs, and tables. With BfX, Excel becomes a powerful workspace to calculate rifle settings, calibrate scopes or iron sights, explore trajectories, and study the effects of wind varying in magnitude and direction along the bullet's path. Both metric and imperial units are supported, help is built right in, and BfX is exceptionally accurate and fast.

BfX is deployed as a regular Excel add-in (dynamic link library) designed for modern 64-bit Excel versions. Excel add-ins add new functions to Excel—and with just dragging and linking cells you create your tables and graphs—ballistics tailored exactly 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").

In January 2019 I received a flattering message from an Australian shooter also active on ozfclass.com from which I quote:

"I am a long term user of your software to assist with my F-Class shooting. It is an excellent system and a great idea to allow people with Excel skills to integrate accurate G7 based ballistics calculations into workbooks created to suit their own circumstances. The main use I have had is in an application used to make plot sheets for every shoot I do. An important part of it is to calculate scope sight settings and wind deflections. Because I use many combinations of scope sights, barrels, loads etc. I keep thorough records (in the same workbook) of all the required inputs to BfX. I have used this application extensively at competitions up to and including World Championships, so thank you."
Creator

One of the creators 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 height for a bullet with a muzzle velocity of 740 m/s, shot with a rifle having a front sight height of 3,4 cm. The impact is at 0 cm above the point of aim at 300 m. The path height at 200 yards is calculated. The ballistic coefficient entered is 0,23 lbs/inch² 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 coefficient). Outputs are by default also metric, and can be easily converted to other units by specifying the desired unit as the first parameter.

Formula example

Row 1 shows the BfX feature to 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 ...

Mathematics

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

Drag Functions

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

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. © 2026 Lydia Lisa Meijer, Netherlands