Category Archives: VBA

Evaluating Pi …

Posted on 12/04/2009 by dougaj4

… to 15 decimal places in one easy step (or not too difficult step). In my previous post one of the examples given of the use of the Gaussian Quadrature function was to evaluate the value of Pi.  Let’s look at … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 4 Comments

Gaussian Quadrature

Posted on 10/04/2009 by dougaj4

The previous post on integration provided an Excel User Defined Function (UDF) to perform numerical integration using Simpson’s Rule or the Trapezoidal Rule.  A third method is Gaussian Quadrature which is often much more accurate and/or quicker than Simpson’s Rule.  The UDF GaussInt() … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 27 Comments

Another update to IP.xls

Posted on 07/04/2009 by dougaj4

Following some suggestions from Mike Seymour I have modified my polyline intersection function, and added a new version. The changes are: The data ranges for the new function, IP4(), are entered as four separate ranges, so the X and Y … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 1 Comment

Combining text files

Posted on 01/04/2009 by dougaj4

Updated 3 April 2009. Following Jimmy Pena’s comments I have revised the code to read and write the files in one operation, rather than line by line. I have also added the option to add a numbered separator line between … Continue reading →

Posted in Excel, VBA | 10 Comments

Frame Analysis with Excel – 6; Beam end releases and actions

Posted on 29/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003 Download Frame3.zip – the download file includes complete open source code. The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | 4 Comments