[troypiggo (Troy)]

Originally Posted by ozstronomer

Nice work Troy,

Thanks for taking the time to work out the engineering aspects, this will be very useful

Geoff

No worries mate. Hope it’s useful.

Originally Posted by RickS

Nice work, Troy. Does it make a correction for Kobe Steel?

imagine if they supplied to VW. You’d drive a car that falls apart and breaks emission targets

Originally Posted by rally

Hi Troy

The results of all formulae in my spreadsheet (running on MS Excel on Mac) for the .xlfn and all dependents are #NAME?
ie I think its either not recognising your custom function for the cantilevered calcs or one or more of the parameters needed isnt available.

So not sure if the function is embedded or mv version of Excel simply isnt reading it properly

Its not a problem as I have my own spreadsheet as you know, but others might have this same problem.

Rally

Thanks for the feedback. The only thing I can think of is for the section selection it uses data validation list as a dropdown, and that may not work on all spreadsheet apps. The other on is a function that may only be avail in Office 365 and not earlier versions. I’ll try rewriting to make it only use basic functions for broader compatibility.