### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Downloads by category
- Downloads
- Drawing in Excel 7 - Creating drawings from coordinates
- Taming Symbols in Excel

### Recent Comments

Suelio Josileissu on Stepping through Python code c… dougaj4 on Stepping through Python code c… dougaj4 on 3DFrame – 3D Frame analy… jawadcharsadda on 3DFrame – 3D Frame analy… Suelio Josileissu on Stepping through Python code c… pyxll on Stepping through Python code c… More Python Traps |… on The meaning of = in Pytho… More Python Traps |… on Python Traps Using LINEST for non… on LinEstGap with non-linear… dougaj4 on Using LinEst() on data with… LinEstGap with non-l… on Fitting high order polyno… LinEstGap with non-l… on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Charlene Van Wyngaar… on Using LinEst() on data with… dougaj4 on DigitGraph Spreadsheet and Web…

# 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