This webpage provides links to files that will help you in stochastic modeling. I programmed the .dll file in C and compiled it in Windows. The underlying routines come from the GNU Scientific Library. You may use gslRand.dll for your own use, whether personal or commercial. However, you do not have permission to include the file with any software that you sell.

Most people will use gslRand.dll with Excel. In that case, place gslRand.dll in a directory in your path, such as c:\Windows, and add to a VBA module declares as illustrated in gslRand.xls. The .dll includes routines to generate random variants for the following distributions.

The .dll works under Windows XP/7/8/10 with 32-bit Excel. It will not work with 64-bit Excel. Contact me if you require a 64-bit version.

  1. Binomial
  2. Gamma
  3. Lognormal
  4. Normal
  5. Poisson
  6. Uniform in [0,1)

Available files.

  1. gslRand.dll the executable file.
  2. gslRand.xls an example of generate random variants.

to main index

R.C.W. (Bob) Howard, FSA, FCIA
Waterloo, ON