Open Source Visual Basic for Applications (VBA) Mathematics Software

Less means - more power. The high performance open source package for statistical data analysis and applied mathematics AtteStat is an add-in for desktop versions of the Microsoft Excel spreadsheets. Both 32-bit and 64-bit in one package. The combination of the unsurpassed convenience of spreadsheets and the effective interception of Microsoft Excel exceptions (frontend) and the maximum speed of the C++ programming language (backend). Winner of contest Microsoft Office Extensions (PC Magazine RE) in 2006. Registered 2002-05-23 with the Federal Service for Intellectual Property. Completely free. No donation required. AtteStat comes with absolutely no warranty.

The wrapper allows to execute OpenCL code on CPU and GPU devices from VBA. Sources are available under https://github.com/Excel-lent/ClooWrapperVBA

Excelsi-R is an Excel add-in that allows Excel spreadsheets to harness the power of the R statistical language by connecting to a running R process. R does not need to be installed on the computer running Excel, but it does require access to an R instance running Rserve (which can be on a remote computer). It supports incorporating R plots and graphs in an Excel workbook.

You may also like some newer work: http://createdatasol.com/ Project imDEV is an application of RExcel, which seamlessly integrates Excel and R for tasks focused on multivariate data visualization, exploration, and analysis. Interactive modules for dimensional reduction (imPCA), prediction (imPLS), feature selection, analysis of correlation (imCorrelations) and generation of networked structures (imGraph) provide an integrated environment for systems level analysis of multivariate data.

Coexlam is a VBA Excel application that performs composite laminate analysis. Laminate theory is used with several strength criteria: maximal stress, maximal strain, Tsaï-Hill and Tasï-Wu. A help including a Getting Started part is now available in the application. The users can add their own formulas or application, an example is provided with a tank under pressure. Several load cases can be calculated in one time in the Print sheet. Laminates can be saved in the Library sheet. Several versions of Coexlam are available on Sourceforge: Coexlam v1.1 and Coexlam v1.2. The version 1.2 directly includes all the version 1.1 + additional features. Coexlam is a freeware under General Public License.Coexlam is developed by Coexpair, an aeronautic company specialised in composite development with RTM process for aeronautic major companies. Coexpair is a Radius Engineering partner. website: www.coexpair.com

Using a sequence of Open Source CAD/CAM and graphics tools, integrated through Excel macro code, "Lego Charts" extends the idea of the Excel 3-D bar chart. It allows the placement, shapes and colours of the bars to represent further dimensions to the data. The chart is presented as a photo-realistic model apparently constructed out of LEGO® [1] bricks. The downloaded package consists of an Excel template to create the charts, an extensive installation and user guide, and two fully-worked samples. Creating eye-catching Lego Charts is easy, fun, and rewarding! Platform: Windows 32 bit (XP onwards) with Microsoft Excel 2003 or later. For more information about Lego Charts, and how to install the package, please see the file README.txt on the the FIles page. --- [1] LEGO® and the LEGO logo are registered trademarks of The Lego Group, which does not sponsor, endorse, or authorize this software package or web page.

F2what is an open source project to translate algorithmic fortran to a variety of languages (java, dotnet and VBA so far). It offers a Fortran77 parser with code transformations, variable disambiguation, and modular output to other programming languages. It also offers already translated versions of Lapack and quadprog to Java, .Net and VBA, to give access to SVD, LU, QR, Cholesky, eigenvalue decomposition, linear system solving and QP optimization in those three languages.

WordMat is an add-on to Microsoft Word which creates a tab with math functionality. Part of the Math functionality is provided by other open-source applications like Maxima, GeoGebra, Graph and GnuPlot.