Using Erlang for Excel

Erlang for Excel introduces eight Erlang functions to Microsoft Excel, thus allowing you to incorporate Erlang calculations into your own spreadsheets.

The functions are provided as Add-ins, rather than macros, and this distinction is important to understand. The code for performing the calculations is installed with Excel's installation rather than within workbooks. This means that workbooks that use Erlang for Excel's functions are not transportable. When you send such a workbook to another computer, you are only sending references to the functions; not the methods of performing the calculations. So, Erlang for Excel must be installed on each computer on which the calculations need to be resolved.

You can enter a function in Excel in the same way as you add a normal data, except that the formula must start with the = sign. This tells Excel that what follows is an Excel function. Each functions takes a number of parameters. As with other Excel functions, you can either enter absolute values as the parameters, or you can add references to other cell on the same workbook or other open workbooks.

Operations limits to the values you can enter have been set to prevent Excel from locking up. It is not possible to perform calculations using parameters higher than these limits.