### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Downloads by category
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings

### Recent Comments

tim on Strand7 API GetNode funct… dougaj4 on Converting from global to loca… Nour on Converting from global to loca… rajith on Running exe files from Ex… dougaj4 on What is VBA good for? … Kazahk SON on What is VBA good for? … #Excel Super Links #… on Solving non-linear equations w… Using Matplotlib fro… on Use Matplotlib from Excel with… #Excel Super Links #… on More on trend line equations o… dougaj4 on Strand7 API GetNode funct… Pietro on Strand7 API GetNode funct… dougaj4 on Non-linear Frame Analysis Arend van Wijngaarde… on Non-linear Frame Analysis dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi…

# Category Archives: Beam Bending

## Non-linear frame analysis; moment curvature and self-weight

The Python/Fortran/Excel frame analysis program (previous version here) now has several new features added to the 2D-solver routines: The beam bending behaviour may now be specified with moment-curvature tables, rather than the linear-plastic behaviour required in the previous version. Beam … Continue reading

Posted in Arch structures, Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, NumPy and SciPy, Strand7, VBA
Tagged Excel, FEA, Fortran, Frame Analysis, link to dll, moment curvature, Non-linear concrete, Non-linear geometry, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment

## Non-linear Frame Analysis – Scipy solvers

The frame analysis spreadsheet presented in the previous post has been updated to use the solvers included in the Scipy package. There is now an option to use either the Cholesky solver, or an iterative sparse solver. The main advantages of … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged Cholesky factorisation, ctypes, Excel, FEA, Fortran, Frame Analysis, link to dll, Non-linear concrete, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment

## Non-linear Frame Analysis

Another example using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)), this post provides a spreadsheet based frame analysis program including non-linear bending behaviour and … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged ctypes, Excel, FEA, Fortran, Frame Analysis, link to dll, Non-linear concrete, Programming the Finite Element Method, Python, VBA, xlwings
5 Comments

## ConbeamU 4.10

The ConbeamU spreadsheet has been updated to Version 4.10, to fix a problem with incorrect default parameters being used if the support stiffness columns had empty cells. The revised spreadsheet (including open-source code) can be downloaded from: ConbeamU.zip Applications in the … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Fixed End Moments, moving load, Restrained End Moments, Strand7, UDF, VBA
22 Comments

## Plane Strain FEA – Non linear staged analysis

Continuing the recent series of posts featuring Fortran based FEA routines, the spreadsheet from the previous post has been revised: The spreadsheet allows for a staged analysis, with additional elements placed in layers for any number of construction stages. Temporary loads … Continue reading

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, UDFs, VBA
Tagged ctypes, Excel, FEA, Fortran, link to dll, plane strain, Programming the Finite Element Method, Python, soil-structure interaction, staged analysis, VBA, xlwings
1 Comment

## PlateStress Update

The functions from the PlateStress spreadsheet (details here) will be incorporated in the FEA spreadsheets currently being presented. In the process of using these functions I made a couple of improvements: The required sequence of the Gauss Points numbers was clarified: … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged Excel, Gauss Points, Mohr's Circle, Plate stresses, Strand7, UDF, VBA
1 Comment

## Automating Goal Seek with RC Design Functions

As promised in the previous post, I will now look in more detail at the process for automating the Excel Goal Seek function with the RC Design Functions spreadsheet, to calculate reinforcement area or section depth for a range of bending … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, Goal Seek, Reinforced Concrete, Reinforced Concrete Design Functions, Section capacity, VBA. UDF
10 Comments