Blogs about: Vba Excel
Featured Blog
Daniel's XL Toolbox
I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a f… more →
Newton Excel Bach, not (just) an Excel Blog
Daniel's XL Toolbox
dougaj4 wrote 2 days ago: I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, o … more →
Reinforced Concrete Moment-Curvature - 1
dougaj4 wrote 6 days ago: The flexural curvature of any beam composed of material with linear elastic behaviour, subject to a … more →
Reinforced Concrete Section Analysis - with prestress
— 1 comment
dougaj4 wrote 1 month ago: The simplified reinforced concrete section analysis spreadsheet presented here has been revised to a … more →
Reinforced Concrete Section Analysis - with prestress
— 1 comment
dougaj4 wrote 1 month ago: The simplified reinforced concrete section analysis spreadsheet presented here has been revised to a … more →
Three UDFs
— 1 comment
dougaj4 wrote 1 month ago: This post is in response to recent discussions at Daily-Dose-of-Excel where many and various workshe … more →
LatPile - Analysis of Lateral Loads on Piles
dougaj4 wrote 2 months ago: This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles … more →
Approximate Solutions of Polynomial Equations
dougaj4 wrote 2 months ago: Following on from the previous post, this post presents a number of methods of solving polynomial eq … more →
Evaluating Polynomial Functions
— 4 comments
dougaj4 wrote 2 months ago: A polynomial function is a function of the form: a + b*x + c*x^2 + d*x^3 … and the derivative … more →
Randomising a list
dougaj4 wrote 3 months ago: A list can be sorted into random order by inserting a list of random numbers in an adjacent column a … more →
Listing sheet names
— 3 comments
dougaj4 wrote 3 months ago: Answering my own question from the previous post, here is a short UDF that will return a list of wor … more →
Continuous beam with varying stiffness
dougaj4 wrote 3 months ago: Previous Splinebeam post One of my aims in developing the splinebeam function is to carry out non-li … more →
Finding Circle Centres in 3D
dougaj4 wrote 3 months ago: In 2 new functions for IP.xls I described two Excel User Defined Functions (UDFs) to find the radius … more →
Continuous beam with specified end conditions ...
— 1 comment
dougaj4 wrote 3 months ago: … and/or support displacements. The previous post in this series derived cubic splines with sp … more →
Using Goal Seek on Multiple Cells
— 1 comment
dougaj4 wrote 4 months ago: The Excel “goal seek” function is useful and powerful, but the procedure for using it on … more →
Update to Frame4.xls
dougaj4 wrote 4 months ago: It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect … more →
Two new functions for IP.xls
dougaj4 wrote 4 months ago: In response to this thread at the Eng-Tips forum I have added two new functions to my IP.xls spreads … more →
More on cubic splines
— 9 comments
dougaj4 wrote 4 months ago: The previous two posts used cubic splines with the “natural” end condition, that is with … more →
Continuous beam analysis with cubic splines
dougaj4 wrote 4 months ago: The last example in the previous post illustrated the use of cubic splines to find the bending momen … more →
Cubic Splines
— 1 comment
dougaj4 wrote 4 months ago: Cubic splines are used to fit a smooth curve to a series of points with a piecewise series of cubic … more →
