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 new spreadsheet has the following changes:
- In addition to providing a list of output point positions it is now possible to specify the number of points required for each span.
- At support positions output is now provided for the shear and moment on either side of the support.
- VBA routines are now provided to simplify the entry or re-sizing of array functions.
- Behind the scenes, the VBA code has been re-arranged to allow many of the functions to be used in the frame analysis spreadsheets, reducing duplication of code.
Defined support displacements and the new input of output points is shown below:
Note that where the same output point is defined twice, at a support or point load position, the output now returns the shear force and moments immediately to the left of the point, followed by the values immediately to the right.
The array entry routines are illustrated below. Any of the functions may be entered in a single cell:
Then press Ctrl-Shift-S, and the full array will be returned automatically:
The array range may also automatically be reduced in size. Select the required output range and press Ctrl-Shift-R: