Example: Use Case

You are writing an Excel spreadsheet with some matrices. Excel supports some matrix operations (did you know?) but you need factorization, which is not available.

With the BERT add-in, adding factorization is easy:

1. Open the R source file in your favorite editor

2. Write a method in the source file

   CHOLESKY <- function( mat ){ chol(mat) }

3. Tell BERT to update (it loads automatically on startup, but you need to reload changes)

   

4. Use the function in Excel

   

   there's a handy tooltip

   

and now you can do your factorization! Using BERT, adding R functions to Excel is trivial.