Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Downloads by category
- Cubic Splines
- Drawing in Excel 7 - Creating drawings from coordinates
- Using the AlgLib ODE (Runge-Kutta) Solver with Excel
- Writing an array to a worksheet range - correction
- Retrieving unique values from a range or array ...
- Finding Prime Numbers with Excel, and using Array Formulas
- Drawing in Excel 5 - Shape List
Recent Comments
dougaj4 on Beam actions and deflections b… Stephen Ward on Beam actions and deflections b… dougaj4 on Beam actions and deflections b… Steve Ward on Beam actions and deflections b… dougaj4 on Using Goal Seek on Multiple… Using Goal Seek on a… on Using Goal Seek on Multiple… John Pollard on Using Goal Seek on Multiple… Using RC Design Func… on Using RC Design Functions… dougaj4 on Using RC Design Functions… Omar Khan on 5 Year Report hadwao on Using RC Design Functions… dougaj4 on Using RC Design Functions… hadwao on Using RC Design Functions… Marina Lindon on More from the Low Countri… China Amazing Archit… on World’s Largest Natural…
Category Archives: Beam Bending
Using RC Design Functions – 1
Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Examples, Excel, RC Design Functions, Reinforced Concrete, UDF, VBA
11 Comments
3DFrame – 3D Frame analysis for Excel
I have now extended the Frame4 spreadsheet to deal with 3D frames. As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, sparse solver, Spreadsheet frame analysis, VBA
6 Comments
Defining beam orientation in 3D
The principal axes of a beam (or any 2D closed shape) are defined as the axes along which an applied load will not cause any deflection in the transverse direction. In mathematical terms, if the beam cross-section is defined in the … Continue reading
Extending Frame4 with on sheet formulas
Still on Frame4, Julien asked if provision could be made for application of local loads, i.e. loads perpendicular to sloping members, rather than just horizontal or vertical. This will actually be incorporated in the spreadsheet “real soon now”, but it … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, Frame4 spreadsheet, local loads, VBA
2 Comments
Frame4 Version 3.05; with support displacements
Hot on the heels of Version 3.04 comes Version 3.05. A few days ago Julien asked if the Frame4 allowed for specified support deflections, to which I replied it would be added in the future. Searching Google on the topic I … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged C# matrix functions, Excel, Frame Analysis, link to dll, VBA
6 Comments