Recent Comments
Category Archives: Maths
Elegant proofs 3
At The Math Less Travelled it says: “Did you know that the ratio between the side of any triangle and the sine of the opposite angle is equal to the diameter of the triangle’s circumcircle? I didn’t! I just learned it … Continue reading
Trigonometric Functions in VBA – Update
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
Linking Excel to Fortran – 2
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 Cubic, Excel, Fortran, Quadratic, UDF, VBA
23 Comments
Finding Prime Numbers with Excel, and using Array Formulas
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 Array Formulas, Excel, Marths, Prime Numbers, UDF
28 Comments
Project Euler
Whilst tag-surfing I discovered Project Euler, which looks like fun for people who enjoy mathematical puzzles. Here’s what they say about themselves: ” What is Project Euler? Project Euler is a series of challenging mathematical/computer programming problems that will require … Continue reading
Newton Excel Bach, not (just) an Excel Blog 