Category Archives: UDFs

Frame Analysis with Excel 1 – Single beam

Posted on 31/01/2009 by dougaj4

Download Beam1.zip This is the first of a series of posts in which I will develop a structural frame analysis program operating within Excel.  The first few stages will be mostly spreadsheet based, with later stages using VBA routines to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, Uncategorized | Tagged , , , | 14 Comments

Repeating a set of data

Posted on 21/01/2009 by dougaj4

The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data.  I have written a simple UDF to do this job, and also extract … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | 1 Comment

Significant Figures

Posted on 28/12/2008 by dougaj4

Excel does not provide any built in functions to round values to a specified number of significant figures.  The UDF below, recently posted at the Eng-Tips forum, will do the job: Public Function sigfig(my_num, digits) As Double Dim num_places As Integer … Continue reading →

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

Anniversaries

Posted on 27/12/2008 by dougaj4

It has just come to my notice that this year I missed my half millionth Birthhour, which was also my 30 millionth Birthminute. Luckily I still have plenty of time to prepare for my 2 billionth Birthsecond. To avoid missing … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 3 Comments

Solving simultaneous equations – Fortran dll

Posted on 20/12/2008 by dougaj4

The file simultaneous.zip has been modified to allow access to a Fortran simultaneous equation routine, compiled as a dll.  The original file was posted in solving simultaneous equations.  The advantages of a compiled routine include: Much better performance Greater precision through … Continue reading →

Posted in Arrays, Fortran, Link to dll, Maths, UDFs, VBA | Tagged , , , , , | 3 Comments