### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Downloads by category
- Cubic Splines
- Solving the Lagrangian Point equation for the Moon
- Fitting high order polynomials
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads

### Recent Comments

# Tag Archives: continuous beam

## ConbeamU Update; defined support deflections

As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged array entry, Array function entry, ConBeamU, continuous beam, defined support deflections, deflections, Excel, Macaulay's Method, UDF, VBA
12 Comments

## Moving Load Spreadsheet – update and how to use

As noted in the comments on the previous post on this topic, the moving load function (and also the associated continuous beam functions) have been modified to make data entry more flexible; the output results are unchanged. The modified spreadsheet … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, continuous beam, Excel, Macaulay's Method, moving load, Solver, UDF, unit aware, VBA
5 Comments

## Cantilevers with shear deflections

At the end of last year I updated the Macaulay spreadsheet to include shear deflections for continuous beams, but this facility was not added to the Cantilever function. That has now been fixed in the latest version, that can be … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Cantilever, continuous beam, Excel, Macaulay's Method, shear deflection, UDF, VBA
1 Comment

## Continuous Beams With Cantilevers by Macaulay’s Method

Edit 13 Apr 2014: See Continuous Beam Spreadsheet with Moving Load for the latest version, which is now called ConBeamU. I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Cantilever, continuous beam, Excel, Macauley's Method, UDF, VBA
12 Comments

## SplineBeam update

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths. This … Continue reading

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
1 Comment

## Cubic Splines

Cubic splines are used to fit a smooth curve to a series of points with a piecewise series of cubic polynomial curves. In addition to their use in interpolation, they are of particular interest to engineers because the spline is … Continue reading

Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
70 Comments