yes, indeed, he mentions ICAO. ICAO must be usance in nineties already.

... until now anything which smells like "state" is omitted in BfX. Storing and managing the relationship between a string and a cell reference is stateful and will lead to a headache (which I will get also with the 6dof). I rather am in favor of letting vba run an additional second...

regarding the metrological conditions of McCoys .22LR work:

- there is no clue in the article, hence it must be the default one of the early nineties
- I have no idea if they adopted ICAO by then (and used the US ARMY Standard Metro instead).

regarding deformation - that indeed is influenced by the rifle, i guess by the friction (surface conditions in barrel) at ingnition and the barrel length

That is easy: =bfx_cd(A1;INDIRECT(A2)) or bfx_cd(A1;INDIRECT($A$2))

yes, that works, probably you have a typo somewhere. Look at the bottom of the included worksheet. Tonight I will reflect on your earlier posts

google for AERODYNAMIC CHARACTERISTICS OF CALIBER .22 LONG RIFLE MATCH AMMUNITION

McCoy made a complete ballistic study of the R50 and the Eley Tenex. Interesting literature ...

Cool!

do you have such a dragfunction for R50?

The Siacci methods needs a parametrization in the form of d= 1461.5128 * a*v^b (or something like that, i have to look it up) where d is the drag function and v is  the (metric) velocity. I calculate with the aid of some logarithms the constants a and b from the tabulated d's and their metric velocities. This is done for the ICAO velocity of sound. One could say that there is a powerlaw  interpolation deployed, although the powerlaw behaves almost linearly in the interval

Presently the only way to correct for temperatures other than ICAO is through adaption of the BC (with bfx_c), there is now no way to communicate the temperature from the excel "space"  to the procedure that uses the mach value to compute drag. At the moment it would require to incorporate the temperature in every BfX function - making them  awkward. I am expecting to introduce a "table" (a range in excel)  for bc. This table contains then the bc, temperature, humidity and pressure, making BfX_C superflous yet keeping the formulas simple. This would be a rather straightforward thing to do now the ground breaking work with the drag tables has been done. However, I find the 6dof implementation much more attractiveto work on - this will happen before X mas I hope. Before that, however, I want to implement neural network software in Excel. Not only do I need it for something else, I think it can be handy for 6dof speedup and - in a  far future - the implementation of software that does the aerodynamics on a more elementary level than what we do with bc's and tables.

the m (3, 2) I added later, and was not included in the screenshot of the prototype you saw on the forum. (However I have to include it in BfX_help() )

For what are you using the drag functions?

thx!

once you have a dragtable put together, give it an Excel name ...

alternatively, send me the spreadsheet and i'll will have a look.

The explanations is in the gettingstarted workbook that you can download at http://www.bfxyz.nl/docs/bfxdownloads.shtml
One of the last worksheets in that workbook.

Lapua's QT: http://www.lapua.com/en/customer-center/lapua-ballistics/download-lapua-edition.html

This works now   ( that is not clear from the first post here )

This is indeed a very good setup of Lapua! Good news.