Category Archives: UDFs

Excel 2007 performance – feedback please

Posted on 06/05/2008 by dougaj4

According to this post at MSDN: http://msdn.microsoft.com/en-us/library/aa730921.aspx#office2007excelperf_ExcelPerformanceImprovements Excel 2007 should be giving significant performance improvements on multi-core processors. Some simple benchmarks on an Acer laptop with 2.0 GHz dual-core processor and 2 GB RAM show some improvement (over Excel 2000), … Continue reading →

Posted in Excel, UDFs | Tagged | 7 Comments

Evaluate Function

Posted on 22/04/2008 by dougaj4

It would often be convenient to evaluate a function entered as text; for instance if we have the function for the deflection of a cantilever under point loading at the end: F*L^3/(3*E*I) then it would be convenient to be able … Continue reading →

Posted in Excel, Maths, UDFs | Tagged , , | 9 Comments

Section Properties of Defined Shapes – Spreadsheet

Posted on 25/03/2008 by dougaj4

Download section properties spreadsheet from: http://www.interactiveds.com.au/software/Section%20Properties03.zip http://www.interactiveds.com.au/software/Section%20Properties07.zip Section properties for 35 defined shapes Section properties from coordinates Section properties UDF Screen shots:

Posted in Excel, Maths, UDFs | Tagged | 29 Comments

Section Properties UDF and UDF charting

Posted on 14/03/2008 by dougaj4

The technique for calculating section properties from coordinates is conveniently coded into a UDF: Function Area(xy_range As Variant) As Double Dim XYcells As Variant Dim N As Long, NumX As Long Dim XD As Double, YSum As Double XYcells = … Continue reading →

Posted in Arrays, Charts, Excel, UDFs | Tagged | 6 Comments

Ranges and Arrays – 2

Posted on 05/03/2008 by dougaj4

Yesterday we looked at how to get data from a worksheet range into a VBA array.  Today’s post looks at the opposite operation; writing an array to a worksheet range.  With a UDF it couldn’t be simpler: Function MyFunction() as … Continue reading →

Posted in Arrays, Excel, UDFs | 1 Comment