Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Linking Excel to C - 2
- Finding Prime Numbers with Excel, and using Array Formulas
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Tag Archives: Loc_to_Glob3
Update to Glob_to_loc3 and Loc_to_glob3 functions
Following a comment here I have updated the Glob_to_loc3 and Loc_to_glob3 functions to deal with some problems when the local longitudinal axis is parallel to the global Y or Z axes. The IP2 spreadsheet, including the revised functions, can be downloaded from: … Continue reading
Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Excel, global axes, Glob_to_Loc3, local axes, Loc_to_Glob3, UDF, VBA
6 Comments
Global to Local for plates (and three node beams)
The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading
Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA
Tagged Excel, Glob_to_Loc3, IP2.xls, Loc_to_Glob3, Python, PyXLL, UDF, VBA
3 Comments