Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- Using LinEst() on data with gaps
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- About Newton Excel Bach
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: axis rotation
Converting from global to local coordinates (and vice versa)
In 3D structural analysis (as well as many other applications) it is necessary to convert section properties, forces, and deflections between coordinate systems defined by individual structural members (local coordinates) and the common coordinate system defining the entire structure (global … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, UDFs, VBA
Tagged axis rotation, Excel, global axes, local axes, Python, PyXLL, UDF, VBA
22 Comments