Tag Archives: UDF

Trigonometric Functions in VBA – Update

Posted on 06/12/2008 by dougaj4

In this post from February a set of VBA trigonometric functions were presented, using the derivations given on the Microsoft Developer Network site: Derived Math Functions Unfortunately two of the functions were wrong; the correct versions are shown below: Inverse Secant … Continue reading →

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

Linking Excel to Fortran – 2

Posted on 04/12/2008 by dougaj4

In this post the procedures described for C++ here will be replicated for Fortran: The spreadsheet, fortran source code, and compiled dll described in this code may be downloaded from Cubic.zip As always, it is better to use the downloaded code, … Continue reading →

Posted in Excel, Fortran, Link to dll, Maths, UDFs, Uncategorized, VBA | Tagged , , , , , | 23 Comments

Finding Prime Numbers with Excel, and using Array Formulas

Posted on 18/11/2008 by dougaj4

Download Primes.zip. Several of the puzzles at Project Euler (see previous post) require the finding of prime numbers, for instance what is the 10,001th prime number?  Searching the Web for some ready made solutions I found this array formula at … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 28 Comments

Reinforced Concrete Section Analysis 7 – rectangular sections

Posted on 05/11/2008 by dougaj4

Previous post The spreadsheets presented in earlier posts in this series have been simplified for use with rectangular sections with two layers of reinforcement.  The functions EStress (for elastic analysis of stresses, strains and crack widths) and UMom (for the … Continue reading →

Posted in Beam Bending, Concrete, Newton, UDFs | Tagged , , , , , | 3 Comments

A Question of Spelling

Posted on 01/11/2008 by dougaj4

The Excel VBA routine below will check the spelling of the text in the current selected cell, and return either TRUE or FALSE in the adjacent cell to the right: Sub SpellChecksub() Dim Checkword As String, Result As Boolean Checkword … Continue reading →

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