I have developed a nice simulator in which the effects of cross wind and shooter accuracy on a match (i.e. a NRA 6 distance full prone course, or the Dutch 300,400,500m match) is calculated. Under Excel 2010 it runs nicely, however the VBA code has a few bugs under Excel 2003 which I have to fix and for which I have no time. Have a preview at its graphical output.

in a few weeks I will release a minor upgrade: bfx_u will be added: =bfx_u(output_unit;value;input_unit) for unit conversion and =bfx_rang(iseed,center, standarddeviation, low,high) that generates a random number between low and high according to the normal or gaussian distribution centered at center with standarddeviation as width).

Furthermore a new workbook will be released that simulates a complex, multitarget shooting match

please report experiences

.... however, it has to be tested. Furthermore, the visual basic definitions have to be adapted.

Dear Downloaders,

give me some feedback. Does the installation work? Why is the iron sight settings downloadable so popular?

I have updated most of the downloads,

• BfX.xll includes now BfX_Cd that allows you to extract the drag function values that BfX uses
• The previous drag function RA contained in BfX overestimated the drag around the speed of sound and has been replaced
• BfX_I interpolates smarter and is able to show some additional information how accurate and how the results are interpolated

See the GettingStarted workbook for explanations

Furthermore, most workbooks are somewhat improved

Users of BfX,

Beginning of may I will release an update of BfX.

I worked a bit on BfX_I so that it can cope with more situations. The function also yield info on the quality of each interpolation.

I improved the implementation of the RA4 (small bore, .22LR) drag function. Due to an error, the one currently in use has to much drag arround the sound velocity.

Another function was added to BfX that yields the drag coeficient (drag function) as a function of bullet velocity for G1, G2.... One use for this is that BfX drag coeficients can be checked with others.

Some Excel filles in the download section will be updated to reflect the new functionality.

Robert

Well,

the forum is online again. See if we are less popular for persons who want to sell things.

Robert

The forum is finally online!

After years of more less then more working at the physics and software of BfX.xll - the Excel 2003 and 2007 addin - and a month or so on the website and forum, I decided to put it all online. My main motivation for providing the BfX.xll is that I thought that the software is as useful to fellow match shooters as it turned out for myself. BfX is great for the calculations of sight settings and in the analysis of the effects of wind.

Do not hesistate to post, although I realy do not know what to expect!

Robert