BERT Tookit Structured Data LLC
winget install --id=StructuredData.BERTTookit -e 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.