RC Design Functions update

Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from:

RC Design Functions7.zip

The main new features in the latest version are:

  • The existing optional “depth” argument has been extended so that an array of reinforcement areas can be entered, which will override the values in the main section data input.
  • My Goal Seek macro has been added, so that the reinforcement areas can be adjusted so that the tensile reinforcement stress, or section bending capacity, match a given value, and the process can be automated over a column of data of any length.
  • Examples of using the Goal Seek macro with the EStress and UMom functions have been added.

The screen shots below show samples from the new examples.  Further details of setting up the data to work with the Goal Seek macro will be given in the next post.

Data input for the Goal Seek macro, in conjunction with the EStress function:RCFunc7-1

Similar input with the UMom function:RCFunc7-2

Reinforcement stresses, and section bending capacities, after adjusting the reinforcement area with Goal Seek:RCFunc7-3

This entry was posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

1 Response to RC Design Functions update

  1. Pingback: Automating Goal Seek with RC Design Functions | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.