Loading...
BERT Tookit Structured Data LLC
Use this command to install BERT Tookit:
winget install --id=StructuredData.BERTTookit -e BERT is a tool for connecting Excel with the statistics language R. Specifically, it’s designed to support running R functions from Excel spreadsheet cells. In Excel terms, it’s for writing User-Defined Functions (UDFs) in R. All you have to do is write the function. Everything else – loading the function into Excel, managing parameters, and handling type conversion – is done automatically for you. It really could not be any easier. BERT also has a console that you can use to control Excel in real time, right from your R code. And (if you want), you can call R functions from VBA as well.
BERT Tookit is a software designed to bridge Excel with the statistics language R, enabling users to run R functions directly from Excel spreadsheet cells. This tool simplifies the process of writing User-Defined Functions (UDFs) in R by automating tasks such as loading functions into Excel, managing parameters, and handling type conversion.
Key Features:
- Automatic Function Integration: Write R functions once, and BERT handles all setup and execution within Excel.
- Real-Time Control Console: Use the console to interact with Excel directly from R code for dynamic control.
- VBA Compatibility: Optional integration allows calling R functions from VBA scripts.
Audience & Benefit: Ideal for data analysts, researchers, and professionals who work with Excel and R. BERT Tookit streamlines workflows by enabling seamless statistical analysis within Excel, eliminating the need to switch environments while maintaining data integrity.
BERT Tookit supports Windows 7, 8, or 10 (64-bit) with Excel 2007-2016 (both 32- and 64-bit versions). It can be installed via winget. The current release is version 2.4.4, incorporating R 3.4.4.
Licensed under the GPL v3, BERT Tookit is a powerful tool for integrating data analysis into Excel workflows, making it accessible to both casual users and advanced R programmers.