Author Archives: dougaj4

The Old Bridge at Heidelberg

Posted on 23/09/2008 by dougaj4

The “Old Bridge” at the German university city of Heidelberg was constructed in 1788,replacing a wooden bridge that had occupied the same site since 1284, and which was regularly destroyed by ice and floods. On the south bank can be … Continue reading →

Posted in Arch structures, Bach, Historic Bridges, Newton | Tagged , | Leave a comment

Drawing in Excel 6 – getting shape properties

Posted on 17/09/2008 by dougaj4

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 →

Posted in Drawing, Excel, UDFs, VBA | Tagged , , , , | 5 Comments

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

LHC Rap

Posted on 05/09/2008 by dougaj4

The Large Hadron Collider explained:

Posted in Bach, Newton | Tagged , , | 1 Comment

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