Home

The Basic Excel R Toolkit (BERT) is an Excel add-in designed to run R functions in Excel spreadsheet cells. BERT makes it easy to add your R functions and call them in Excel (it's hard to imagine a way to make it any easier, but if you have any thoughts please let us know).

---

For 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:

• Open the R source file

• Write a method in the source file

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

• Tell BERT to reload the source file

  

• Use the function in Excel

  

  there's a handy tooltip

  

  and now we can factorize within Excel!