Author Topic: progress with custom drag tables  (Read 14544 times)

mman

  • Guest
Re: progress with custom drag tables
« Reply #15 on: September 19, 2011, 03:08:21 PM »
Is there a way to use drag tables like BC formats (G1, G2, G5...) when using Bfx functions?

For examble function:

=BfX_Cd(A1;A2) works fine

if A1 = "range" and A2 = "bc format" .

But if A2 = "named range (drag table)" it doesn't work.


admin

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: progress with custom drag tables
« Reply #16 on: September 19, 2011, 05:28:01 PM »
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

mman

  • Guest
Re: progress with custom drag tables
« Reply #17 on: September 19, 2011, 05:47:32 PM »
Yes it works if A2 is named range but it doesn't if A2 is excel cell reference to the cell which includes the name of the named range.. Okay, let the pic do the explaining  ;):

http://i.imgur.com/GGXhg.jpg

admin

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: progress with custom drag tables
« Reply #18 on: September 19, 2011, 08:26:50 PM »
That is easy: =bfx_cd(A1;INDIRECT(A2)) or bfx_cd(A1;INDIRECT($A$2))

admin

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: progress with custom drag tables
« Reply #19 on: September 19, 2011, 08:55:24 PM »
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

mman

  • Guest
Re: progress with custom drag tables
« Reply #20 on: September 19, 2011, 09:46:30 PM »
I hoped you would offer something else instead... Indirect works fine as long as the results are not used via vba code. When they are vba code calculation time will be multiplied...


About McCoy... First I thought it must be metro but there is one mention of ICAO conditions in the article (IV conclusions, point 4).
« Last Edit: September 19, 2011, 09:57:31 PM by mman »

admin

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: progress with custom drag tables
« Reply #21 on: September 19, 2011, 11:21:05 PM »
... 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...
« Last Edit: September 20, 2011, 12:42:03 AM by admin »

admin

  • Administrator
  • Full Member
  • *****
  • Posts: 237
    • View Profile
Re: progress with custom drag tables
« Reply #22 on: September 20, 2011, 09:29:17 AM »
yes, indeed, he mentions ICAO. ICAO must be usance in nineties already.