Recent Comments
Tag Archives: Excel
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
Linking Excel to Fortran
An earlier series of posts described how to link Excel to programs written in C or C++. The same advantages of increased security and performance may be obtained by linking to Fortran programs with the additional advantages: Many specialist engineering and … Continue reading
Silverfrost Personal Fortran
Silverfrost Personal Fortran is a Fortran95 compiler that is free for personal use. According to the suppliers: “With Silverfrost FTN95: Fortran for Windows you can create console based, conventional Windows® and Microsoft .NET applications. Silverfrost FTN95 is the only compiler that … Continue reading
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
Drawing in Excel 7 – Creating drawings from coordinates
Previous Post, Drawing in Excel 6 The file PlotXYcontains routines to plot scale drawings in Excel from a list of XY coordinates of node points, node points for each shape, and formatting details for each shape type. The plot is scaled … Continue reading
Newton Excel Bach, not (just) an Excel Blog 