Category Archives: UDFs

Linking Excel to C – 3; Avoiding bottlenecks

Posted on 08/09/2008 by dougaj4

The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA.  The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading →

Posted in Arrays, Excel, Link to dll, UDFs, VBA | Tagged , , , | 2 Comments

Linking Excel to C – 2

Posted on 03/09/2008 by dougaj4

In the previous post I decribed how to create four simple functions in Visual C++, and how to link them to an Excel spreadsheet or a VBA User Defined Function (UDF). This post will cover: Accessing arrays created in C++ functions … Continue reading →

Posted in Excel, Link to dll, UDFs, VBA | Tagged , , , | 22 Comments

Linking Excel to C

Posted on 02/09/2008 by dougaj4

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 , , , | 28 Comments

Solving simultaneous equations

Posted on 27/08/2008 by dougaj4

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 →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments

Reinforced Concrete Section Analysis – 5; Ultimate Limit State

Posted on 19/08/2008 by dougaj4

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 , , , , , , , | 5 Comments