Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- ULS Design Functions 2.13
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: local axes
3DFrame-py update
The Python 3DFrame spreadsheet has been updated to allow for analysis including torsional warping effects. The new spreadsheet and associated Python files can be downloaded from: 3DFrame-py.zip The download file includes four sample spreadsheets comparing analysis results with output from … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame-py, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
Mastan2
Mastan2 is a free frame analysis program based on Matlab. The linked site provides alternative downloads for those with or without Matlab installed. The site also provides a link to the book Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, Strand7
Tagged 3DFrame, Excel, Frame Analysis, global axes, local axes, MASTAN2, principal axes, Torsional warping
1 Comment
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
3D Frames, axes and stiffness matrices
In the course of adding provision for spring end releases to the 3DFrame spreadsheet, I have also tidied up the code for generating the structure stiffness matrix, and added some documentation to the spreadsheet. The revised spreadsheet (version 2.02) can … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3D frame analysis, 3D stiffness matrix, Excel, global axes, local axes, moment release, spring end release, Strand7, VBA
10 Comments
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