Recent Comments
Category Archives: UDFs
Linking Excel to C
One of the reasons often given for preferring programs like Matlab to Excel for scientific and engineering uses is the large body of specialist mathematical and scientific applications available to these programs. In this and following posts I will describe how … Continue reading
Posted in Excel, Link to dll, UDFs, VBA
Tagged C++, dll, Excel, Visual Studio C++ Express
28 Comments
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 