Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- About Newton Excel Bach
- Using LINEST for non-linear curve fitting
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Contour plots with Excel and Matplotlib
- Daily Download 2: SLS design of reinforced concrete sections ...
- Retrieving unique values from a range or array ...
- Writing Arrays to the worksheet - VBA function
- Beam actions and deflections by Macaulay's Method
Recent Comments

Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Installing Adobe Reader non-DC… 
Z on Downloads 
Z on Daily Download 8: Drawing in… py_ConBeamU and Stra… on py_ConBeamU and Strand7 check… 
dougaj4 on Daily Download 8: Drawing in… 
Z on Daily Download 8: Drawing in…
Tag Archives: shear deflections
3D Frame Update
Following a comment here I have updated the code for the 3DFrame spreadsheet to calculate shear deflections correctly for sections with a different shear area for each transverse principal axis. The updated files can be downloaded from: 3DFrame.zip A note … Continue reading
Posted in Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 3DFrame, Excel, section property definitions, Shear area, shear deflections, VBA
2 Comments
Using UDFs – Continuous Beam Example
Recently (well a month ago) a comment was left at Continuous Beams with Shear Deflections asking for a tutorial on how to use the ConBeam User Defined Function (UDF). In this post I will give detailed instructions for the ConBeam function, but similar … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
Leave a comment
Continuous Beams with Shear Deflections
The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
10 Comments