Home
About BfX
Install/Update
Downloads
Excel/VBA settings
Entering formulas
Drag functions
Creators
Help Reference
Units & Drag
Rifle Cant Math
|
Quick Tip: In Excel, you can retrieve any of these help lines directly inside a cell by entering =BfX_Help(i) where i is the corresponding line number.
General Usage & Locale
All examples assume a European locale (semicolon parameter separators and comma decimals). Depending on your computer settings, your system might expect commas and dots. Default arguments can be omitted, and typing an empty function =BfX_Xv() will return its help signature.
Core Functions Reference Table
| Category |
Function Syntax |
Description |
| Velocity |
=BfX_Vx(v0; x; c; df=GP) |
Calculates projectile velocity v [m/s] at distance x. |
| Flight Time |
=BfX_Vt(v0; t; c; df=GP) |
Calculates velocity at a given flight time t. |
| Time from Velocity |
=BfX_Tv(v0; v; c; df=GP) |
Calculates flight time t [s] when reaching velocity v. |
| Time from Distance |
=BfX_Tx(v0; x; c; df=GP) |
Calculates flight time t [s] to distance x. |
| Distance from Velocity |
=BfX_Xv(v0; v; c; df=GP) |
Calculates distance x [m] where velocity drops to v. |
| Distance from Time |
=BfX_Xt(v0; t; c; df=GP) |
Calculates distance x [m] covered in flight time t. |
| Bullet Drop |
=BfX_D(v0; x; c; df=GP) |
Calculates bullet drop [m] or converted to an angular unit. |
| Wind Deflection |
=BfX_Y(v0; <xw>; <vw>; x; c; df=GP) |
Calculates wind deflection given ranges and crosswind velocities. |
| Trajectory Height |
=BfX_Zx(v0; s; h; zx; x; c; df=GP) |
Calculates trajectory height at distance x relative to line of sight. |
| Elevation Angle |
=BfX_E(v0; s; h; zx; c; df=GP) |
Calculates required barrel elevation angle [radians]. |
| Cant Corrections |
=BfX_CantShiftE(e; w; t)
=BfX_CantShiftW(e; w; t) |
Calculates elevation and windage shifts caused by rifle canting. |
| Atmosphere & Air |
=BfX_C(T; P; H)
=BfX_AD(T; P; H) |
Calculates ballistic coefficient correction factor and air density. |
| Interpolation |
=BfX_I(<xi>; <gxi>; x; accuracy; m) |
Performs advanced interpolation/extrapolation across data ranges. |
| Random Numbers |
=BfX_Ran(i; <r>)
=BfX_Rang(...) |
Generates non-volatile uniform or normally distributed random values. |
| Range Check |
=BfX_CRC(<r>; m) |
Computes a 32-bit Cyclic Redundancy Check to verify range stability. |
Atmospheric Standards
Calculations assume ICAO standard atmospheric conditions: 15°C, 101325 Pa, and 0% humidity. Use =BfX_Help2(i) to view available drag functions and units.
Error Reporting & Diagnostics
=BfX_IQ(<r>): Returns information regarding your most recent successful or failed calculation.=BfX_Info(i, <r>): Retrieves calculation history and error diagnostics.=BfX_Cell(<r>): Displays cell formulas (note: volatile function).
VBA Interface & Copyright
BfX includes full support for Visual Basic for Applications (VBA) integration using wrapper aliases (e.g., BfX_VB_Zx). The software is protected by copyright ((c) 2008 - 2026 Robert & Lydia Meijer), provided free for private, non-commercial use "as is" without warranty.
|
