Most of my spreadsheets use User Defined Functions (UDFs), and these often return an array of results, rather than just one value, and need to be entered as an array function. These things are not difficult to use, but for those not familiar with them they can be off-putting, so the two links below present an overview of using array functions and UDFs. Please leave a comment if anything is not clear.
Using UDFs – Continuous Beam Example
Finally, many of the posts here form series that grow over months or even years. Always have a check at the end of each post for “ping-backs” from more recent posts at this blog, where the topic will be developed further and/or new versions of spreadsheets may be published.
Pingback: Beam actions and deflections, 3D or 2D | Newton Excel Bach, not (just) an Excel Blog
Pingback: Dynamic sorting with Excel, VBA, and Python | Newton Excel Bach, not (just) an Excel Blog
Pingback: Dividing shapes into layers | Newton Excel Bach, not (just) an Excel Blog
Pingback: Reinforced Concrete – ULS capacity under combined axial load and biaxial bending | Newton Excel Bach, not (just) an Excel Blog
Pingback: Range tips | Newton Excel Bach, not (just) an Excel Blog
Pingback: More on Regular Expressions | Newton Excel Bach, not (just) an Excel Blog
Pingback: Working with array functions | Newton Excel Bach, not (just) an Excel Blog
Pingback: Getting concrete shrinkage right | Newton Excel Bach, not (just) an Excel Blog
Pingback: Reinforced Concrete Moment Curvature – Development over time | Newton Excel Bach, not (just) an Excel Blog
Pingback: Solving non-linear equations with two or more unknowns – 2 | Newton Excel Bach, not (just) an Excel Blog
Pingback: Automating Goal Seek with RC Design Functions | Newton Excel Bach, not (just) an Excel Blog
Pingback: RCInteract and RC Design Functions 7.03 | Newton Excel Bach, not (just) an Excel Blog
Pingback: Plotting Freeze-Thaw Data … | Newton Excel Bach, not (just) an Excel Blog
Pingback: More Numpy with Excel and xlwings | Newton Excel Bach, not (just) an Excel Blog