BfX_Help2(integer) |
(if you see this
information on a web page, click here to go back to the BfX Home page: ) |
http://www.bfxyz.nl/ |
|
Bfx_Help2 informs about unit (e.g. meter to
yard) conversions BfX supports |
|
|
|
|
|
Bfx_Help2 also informs which drag functions can
be used |
|
|
|
|
|
|
|
Other worksheets will elaborate on how to use
these features |
|
|
|
|
|
|
|
To use BfX_Help2(): create a column with
values from 0 … 90 (or so) and then refer to a cell with BfX_Help2(cell to
the left) |
|
|
|
=BfX_Help2(C192) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Ballistics for Excel - use =BfX_Help2(i) with
i=1,2,3,...107 for more |
|
|
|
|
|
1 |
BfX Excel 2015 32bit(C) Lydia Meijer Bld: Jan
15 2019 15:33:34 Release |
|
|
|
2 |
Compiler _MSC_VER 1916, Visual Studio 2017 15.9 |
|
|
|
|
|
3 |
=======Bfx_Help2(0,1,2 ...) specifies supported
units and drag functions======== |
|
|
4 |
Use BfX_Help(0,1,2, ...) for help on BfX
ballistic and other functions |
|
|
|
5 |
==============================BfX_Help2(0,1,2
...)============================== |
|
|
6 |
BfX_Help2 lists available input and output
units as well as supported drag |
|
|
7 |
functions. Units and functions must be
specified in abreviated form, lower case |
|
|
8 |
without spaces and other blanks. If no units
are specified, the metric standards |
|
|
9 |
are used. eg
BfX_D("in";740;1000;"yd";0,22;"g7") calculates
the drop |
|
|
|
10 |
in [inches] for a bullet of 740 [m/s] (units
omitted) at a distance of |
|
|
|
11 |
1000 [yards] with a G7 ballistic coefficient of
0,22 |
|
|
|
|
|
12 |
=================================Drag
functions================================= |
|
|
13 |
Pejsa, use G1 bc, VLD / boat tail bullet (default) -> GP |
|
14 |
G1
-> G1 |
|
15 |
G2
-> G2 |
|
16 |
G5
-> G5 |
|
17 |
G6
-> G6 |
|
18 |
G7, VLD /boat tail bullet
-> G7 |
|
19 |
G8
-> G8 |
|
20 |
GS, sphere (e.g. shotgun)
-> GS |
|
21 |
Ingalls / Mayevski
-> GIM |
|
22 |
RA4, small bore
-> RA4 |
|
23 |
Air rifle, consistent with Chairgun
-> A |
|
24 |
====================================Distance==================================== |
|
|
25 |
km
-> km |
|
26 |
m (default)
-> m |
|
27 |
cm
-> cm |
|
28 |
mm
-> mm |
|
29 |
mile
-> mi |
|
30 |
foot
-> ft |
|
31 |
yard
-> yd |
|
32 |
inch
-> in |
|
33 |
====================================Velocity==================================== |
|
|
34 |
m/s (default)
-> m/s |
|
35 |
foot/s
-> ft/s |
|
36 |
foot/s
-> fps |
|
37 |
=================================Wind
velocity================================== |
|
|
38 |
Beaufort
-> bf |
|
39 |
Beaufort
-> bft |
|
40 |
m/s (default)
-> m/s |
|
41 |
km/h
-> km/h |
|
42 |
km/h
-> kmh |
|
43 |
mile/h
-> mp/h |
|
44 |
mile/h
-> mph |
|
45 |
=====================================Angle====================================== |
|
|
46 |
radian (default)
-> rad |
|
47 |
mili radian (= distance between 2 mildots in
scope recticle)
-> mrad |
|
48 |
mil = mili radian
-> mil |
|
49 |
degrees
-> deg |
|
50 |
minutes of angle = 1/60 degrees
-> moa |
|
51 |
centimeter per 100 meter
-> cphm |
|
52 |
inch per 100 yards
-> iphy |
|
53 |
==================================Target
score================================== |
|
|
54 |
Woerden Integer
-> WI |
|
55 |
ISSF300m Integer
-> 300mI |
|
56 |
==================================Temperature=================================== |
|
|
57 |
Kelvin
-> k |
|
58 |
Fahrenheit
-> f |
|
59 |
Celcius (default)
-> c |
|
60 |
====================================Pressure==================================== |
|
|
61 |
Pascal (default)
-> Pa |
|
62 |
hectoPascal
-> hPa |
|
63 |
mbar
-> mbar |
|
64 |
bar
-> bar |
|
65 |
at
-> atm |
|
66 |
mmHg
-> mmHg |
|
67 |
inchHg
-> inHg |
|
68 |
pounds/inch^2
-> PSI |
|
69 |
====================================Humidity==================================== |
|
|
70 |
fraction of 1 (default)
-> fH |
|
71 |
percentage
-> %H |
|
72 |
======================================Time====================================== |
|
|
73 |
second (default)
-> s |
|
74 |
milisecond
-> ms |
|
75 |
======================================Mass====================================== |
|
|
76 |
kilogram (default)
-> kg |
|
77 |
gram
-> g |
|
78 |
grain
-> gr |
|
79 |
pound
-> lb |
|
80 |
pound
-> lbs |
|
81 |
pound
-> lbm |
|
82 |
pound
-> # |
|
83 |
====================================Density===================================== |
|
|
84 |
kg/m^3 (default)
-> kg/m^3 |
|
85 |
g/m^3
-> g/m^3 |
|
86 |
g/cm^3
-> g/cm^3 |
|
87 |
pounds/ft^3
-> lb/ft^3 |
|
88 |
======================Sectional density =
mass/diameter^2======================= |
|
|
89 |
kg/m^2 (default)
-> kg/m^2 |
|
90 |
pounds/inch^2
-> lb/in^2 |
|
91 |
=====================================Energy===================================== |
|
|
92 |
Joule (default)
-> J |
|
93 |
foot pound
-> ft-lb |
|
94 |
=========================Interpolation output
selectors========================= |
|
|
95 |
interpolated value (default)
-> I |
|
96 |
accuracy obtained
-> A |
|
97 |
number of inputs used for interpolation
-> N |
|
98 |
type of result
-> T |
|
99 |
==============================CRC output
selectors============================== |
|
|
100 |
full check - range dimensions + position of
value and all contents (default)
-> FC |
|
101 |
only values - skip empty cells
-> OV |
|
102 |
only numbers - skip empty cells, booleans and
text, ignore position
-> ON |
|
103 |
only text - skip empty cells, booleans and
numbers, ignore position
-> OT |
|
104 |
only booleans - skip empty cells, text and
numbers, ignore position
-> OB |
|
105 |
only empty cells - skip booleans, text and
numbers, ignore position
-> OE |
|
106 |
only drag table
-> OD |
|
107 |
================================End of
BfX_Help2================================ |
|
|
108 |
Ballistics for Excel - use =BfX_Help2(i) with
i=1,2,3,...107 for more |
|
|
|
109 |
Ballistics for Excel - use =BfX_Help2(i) with
i=1,2,3,...107 for more |
|
|
|
|
|
|
|
|
|
|
|
|
|
|