Recent Comments
Tag Archives: UDF
Drawing in Excel 6 – getting shape properties
Previous post One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate … Continue reading
Solving simultaneous equations
Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis. Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading
Reinforced Concrete Section Analysis – 5; Ultimate Limit State
Previous posts in this series have looked at the analysis of beams where the steel stress is within the elastic range, and the concrete stress is sufficiently low that the assumption of linear elastic behaviour in compression is a reasonable approximation. … Continue reading
Posted in Beam Bending, Excel, UDFs
Tagged Beam Bending, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS, Ultimate capacity, VBA
5 Comments
Intersections, interpolations, and rotations
Amongst the many and varied functions provided by Excel (or as far as I know any other spreadsheet) there are none that provide a one step process for linear interpolation, finding the intersection points of lines, or conversion between polar … Continue reading
Posted in Coordinate Geometry, Excel, UDFs, VBA
Tagged Excel, Interpolation, Intersection Points, Polar Coordiantes, Rectangular Coordinates, UDF, VBA
37 Comments
Evaluate Function – update
Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip
Newton Excel Bach, not (just) an Excel Blog 