Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - admin

Updates / Dec 2021 Recompilation
December 29, 2021, 11:12:59 PM
I have recompiled bfx.xll, bfx64.xll with Visual Studio C++ 2022
Updates / Small extension uploaded
February 16, 2021, 08:57:30 PM
one can specify that one wants to use the density of a certain material in BfX_Bcs, eg =bfx_bcs(1;"Cu/m^3";0,5;"in") calculates the ballistic coefficient of an 0.5 inch copper round ball
Updates / Update uploaded Feb 2021
February 11, 2021, 08:57:33 PM
Today I have uploaded a freshly compiled version of BfX.
Furthermore I have added a BfX_Bcs(density of bullet;diameter of bullet) to compute the ballistic coefficient of spherical (round) bullets. These can be used in combination with the GS drag function.
The new version of Getting Started.xls(x) illustrates computations with BfX_Bcs.

E.g the velocity of a .50 inch lead round ball, with muzzle velocity 2012 fps at 100yd: =BfX_Vx("fps";2012;"fps";100;"yd";BfX_Bcs(0,41;"lb/in^3";0,5;"in");"GS") (which would result in 1046 fps)
Updates / New update coming soon
February 10, 2021, 11:08:49 PM
I have added bfx_Bcs
That computes the ballistic coefficient of spherical bullets.
I have to updated  the "Getting started" to and check some other things in the code
Updates / Site problems solved and a new version of BfX
January 03, 2019, 04:16:41 PM
A happy new year!

I have solved the problems with my servers certificate and now is not regarded as a bogus site anymore. 8) Furthermore I have recompiled bfx, so that the software includes the latest upgrades from Microsoft. I also have upgraded the simulator "what do I shoot today". You find the simulator at the bottom of the download page. The simulator is able to simulate a multi target (at multiple distances) match under various range, wind and wind fluctuations ammunition/gun and shooter accuracies. Helas, depending if you run the 32 or 64 bits version of Excel, one has to change the visual basic code to point to the file locations where the bfx.xll and bfx64.xll can be found. Unless you store them as C:\bfx\bfx.xll or C:\bfx\bfx64.xll.

Personally, I use this spreadsheet a lot. Soon to see how much points I gain in typical Dutch rifle matches at 100 and 300m if I upgrade my barrel to a more accurate one. As I am a quite able shooter with the service rife (3rd in the National Championships 2018 @ 100m, 2nd at 300m) and the competition is fierce, an additional point from the accuracy is welcome.
Updates / now fully supports SSL
March 27, 2017, 01:05:39 PM
The site is now only (and automatically) accessible through SSL. You will see https:// (instead of http;//) in the address bar of your browser. Https, through the use of SLL, would make the use of websites secure and private to use.  SSL is used by https as in:
Worksheets / launch angle
February 11, 2017, 12:19:58 PM
straightforward computation of trajectories and launch angles (elevation) for two bullets with different bc zeroed at same target
Updates / BfX is recompiled
January 13, 2017, 06:10:03 PM
Happy 2017  with the recompiled version of BfX!
Updates / Error
January 05, 2017, 10:18:37 AM
Happy 2017.
Something went wrong with the forum. Helas. I had to install the backup of january 2016.
I have updated BfX to support Excel 2015.
Fixed also a bug that might prevented it to support Excel 2013. I cannot test this...
Member projects / Best spreadsheets july 2015
July 21, 2015, 11:41:07 AM
Dear all,
It is getting a mess. Let us collect what we have produced during the years.

can you post your best spreadsheets and a small description here, status 2015?

Some of them I will put them on the download page of
General discussion / LabRadar
April 24, 2015, 08:56:47 PM
... nice to have ...
Updates / Update 2014
July 29, 2014, 01:12:44 PM
Currently I am working on an update.

this would ensure that you run the latest MS software in Excel.

BfX_U will get the possibility to do scoring on several targets: e.g. BfX_U("300mI";12;"cm") would return 8, as the eight ring on that target has a radius of 15 cm and the nine ring has  10 cm radius.

From BfX/Forum users I got several requests  to extend BfX, e.g. spin drift.
Some of you manufactured some Excel software for this.
Please mail me your wishes and the corresponding algorithms.


I have upgraded the software and it supports Excel 2013 now!

I have tested it for the following combinations
windows 7 64bit with 64 bit Excel 2013
windows 7 64bit with the 32 bit Excel 2010,
I cannot test the other versions currently.

Also the site was updated a little.
General discussion / download failure
January 20, 2013, 08:42:41 PM
currently the bfx site has a problem with downloads. I try to understand the problem.
Updates / rebuild of bfx
April 13, 2012, 10:48:23 PM
It was a long time ago since I had build bfx. I have rebuild it to capture any updates of Microsoft.
... the reason I heard from an offical trainer is that the wind does affect less.

this is in contrast to the theories I know?
General discussion / MOVED: 22 LR bc
November 06, 2011, 05:53:20 PM
Since ages it was possible to enter a bc of 0 - excel would crash. Nobody complained, how is that possible? anyhow this is fixed now.

Because of a small project that will end up in another spreadsheet to download  I added the unit mil (=mili radian, = 10 cm per 100 m) well known from scope recticles
Updates / Getting Started updated
August 29, 2011, 12:36:02 PM
More examples on the use of custom drag functions.