Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- About Newton Excel Bach
- Using LINEST for non-linear curve fitting
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Contour plots with Excel and Matplotlib
- Daily Download 2: SLS design of reinforced concrete sections ...
- Retrieving unique values from a range or array ...
- Writing Arrays to the worksheet - VBA function
- Beam actions and deflections by Macaulay's Method
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Tag Archives: Glob_to_Loc3
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