Solving simultaneous equations – Fortran dll

The file has been modified to allow access to a Fortran simultaneous equation routine, compiled as a dll.  The original file was posted in solving simultaneous equations.  The advantages of a compiled routine include:

  • Much better performance
  • Greater precision through use of Fortran 80 bit variables
  • Better security

Performance for solving a set of simultaneous equations with 250 unknowns 10 times is shown in the screen shot below.  The Fortran dll is over 18 times faster than the VBA routine.

Fortran Gaussian Elimination routine

Fortran Gaussian Elimination routine


To install GES() either:
Create a Folder “Spread” under Windows\System32
Copy the file GE5.dll to the new Spread folder
Copy the file GE5.dll to the Windows\System32 folder
Open the Visual Basic Editor and change:
Declare Function GE Lib “..\Spread\GE5.dll”
Declare Function GE Lib “GE5.dll”

The download zip file includes spreadsheet Simultaneous.xls, the dll file GE5.dll, and the Fortran source code GE5.f95

The Fortran routine is based on a program published by CR Bond

This entry was posted in Arrays, Fortran, Link to dll, Maths, UDFs, VBA and tagged , , , , , . Bookmark the permalink.

3 Responses to Solving simultaneous equations – Fortran dll

  1. Pingback: dll file from fortran in excel | keyongtech

  2. Pingback: Distributing Silverfrost Fortran Applications « Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: Daily Download 18: Simultaneous Equations and Matrix Arithmetic Functions | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.