Hi Jean,
I get an error running your worksheet at variable "User".
I also managed to come up with stable solver for both neutral axis depth "na" and neutral axis rotation angle "alpha". Problem is it can take up to 20 seconds per single solution and i potentially need to run it ~50 times. Any pointers on speeding up function calls?
Thanks!
I lost track of the project as finally the bilinear interpolation solves for both mutually.
Pretty easy to construct the data table wrt "na" & "alpha". Try yourself, if not sure,
please give me the respective ranges. The bilinear data table needs not be square.
It can be rectangular horizontal/vertical.
Cheers Alex ... Jean
Project_0 Biaxial Bilinear [jmG] Copy.sm (115 KiB) downloaded 48 time(s).