Tag Archives: UDF

Daily Download 14: Curve Fitting 1

Posted on 01/10/2012 by dougaj4

Today’s download topic covers fitting a straight line or curve to scattered data, using the “least squares” method.  Fitting a spline curve to pass exactly through a series of points will be covered in a few days. Use of the … Continue reading →

Posted in AlgLib, Charts, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Daily Download 13: The ALGLIB maths library and Excel

Posted on 30/09/2012 by dougaj4

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip   http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading →

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 7 Comments

Daily Download 10: Excel Digitiser

Posted on 26/09/2012 by dougaj4

See How to digitise a scanned image and Digitising logarithmic scales.  This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:

Posted in Drawing, Excel, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

Daily Download 7: Lateraly loaded pile analysis

Posted on 23/09/2012 by dougaj4

Today’s downloads (the last in the Engineering category) are related to the analysis of piles subject to lateral loads: LatPile – Analysis of Lateral Loads on Piles describes the principles of the analysis. Download file: http://interactiveds.com.au/software/LatPile.zip  P-Y Curve function describes function to … Continue reading →

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Daily Download 6: Working with FEA programs

Posted on 22/09/2012 by dougaj4

Today’s downloads are three programs for working with Finite Element Analysis (FEA) programs.  The first use the Scripting Dictionary Object to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at … Continue reading →

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | Leave a comment