← Back to listings

BERT

Published by Structured Data LLC

Windows Excel add-in from Structured Data LLC (San Francisco, CA 94103; +1 (866) 804-9703; info@riskamp.com; www.riskamp.com) that connects Microsoft Excel with the statistics language R so you can write R functions and call them from spreadsheet cells as Excel user-defined functions. Homepage title BERT | Basic Excel R Tookit (vendor spelling). Homepage h1 Basic Excel R Toolkit. Vendor copy: 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. 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. Homepage section BERT is Free!: BERT is licensed under the GPL v3; if your organization can’t use GPL software, contact us for additional license options. This listing is the desktop Excel add-in Windows installer BERT-Installer-2.4.4.exe — not RiskAMP (the same publisher’s Monte Carlo add-in, already listed), not RiskAMP web, and not a second catalog row for Julia-in-BERT or BERT Utilities (those are features of the same installer). Not AppSource. Download page title BERT | Download BERT: current release version 2.4.4; this includes R version 3.4.4 (2018-03-15); Windows Installer control points at GitHub release asset BERT-Installer-2.4.4.exe. System Requirements on the download page: Windows 7, 8 or 10 (64-bit) with Excel 2007, 2010, 2013 or 2016. Both 32- and 64-bit versions of Excel are supported, but only on 64-bit Windows. No Excel 2003 and no Mac. GitHub README at tag 2.4.4: BERT is a connector for Excel and the programming languages R and Julia; Put some R functions in a file; open Excel, and use those functions in your spreadsheets; runtime requirements Excel 2010, 2013 and 2016, both 32-bit and 64-bit (but only on 64-bit Windows). GitHub release tag 2.4.4 Performance Update published 2018-06-15T14:23:12Z. Installer HTTP 206 application/octet-stream 157037040 bytes last-modified Tue, 07 Dec 2021; first bytes MZ. Zip asset BERT-Installer-2.4.4.zip 156230621 bytes. Installing (https://bert-toolkit.com/downloading title BERT | Download BERT): the file is an executable installer (exe); zip files are on the GitHub releases page if you can’t download .exe files; run the installer after downloading; by default it installs to your home directory; run the installer as a regular user, not an Administrator; administrative privileges are not necessary. Uninstalling BERT: Windows Add/Remove Programs (Programs and Features); select BERT in the list and click Uninstall. Quick Start title BERT | Quick Start: after you have installed, start Excel; you’ll see the Add-ins tab on the Excel ribbon menu; click the Add-ins tab and you’ll see a button for BERT; BERT Console includes a code editor and an integrated R shell; when BERT exports functions from R to Excel it adds the prefix R. (R-dot), for example the startup file function TestAdd is called as =R.TestAdd(1,2,3). What’s New title BERT | What's New: BERT version 2 rewritten; Julia support; R debugger; connecting 64-bit R to 32-bit Excel because R now runs out-of-process; separate R and Excel processes; xtermjs VT100 console. Contact title BERT | Contact Us: bug reports and feature requests on GitHub issues; questions to info@riskamp.com. GPL text https://bert-toolkit.com/gpl-3.0.txt HTTP 200 text/plain 35149 bytes last-modified Sat, 07 Jul 2018. Public price is free (GPL-3.0). Copyright 2014-2018 Structured Data, LLC; last tagged release 2.4.4 in 2018 (disclosed, still downloadable).