Embedded Files
ALGLIB
ALGLIB
ALGLIB is a cross-platform numerical analysis and data processing library.
It supports several programming languages (C++, C#, Pascal, VBA) and several operating systems (Windows, Linux, Solaris).
Excellaneous
Excellaneous
an ad-free, spyware-free web site for Excel users in the physical sciences.
http://www.bowdoin.edu/~rdelevie/excellaneous/#websitecontents
Scientific Applications on NIH HPC Systems
CRAN
CRAN
https://cran.r-project.org/web/packages/available_packages_by_date.html
LAPACK
LAPACK
LAPACK is written in Fortran 90 and provides routines for solving systems of simultaneous linear equations, least-squares solutions of linear systems of equations, eigenvalue problems, and singular value problems. The associated matrix factorizations (LU, Cholesky, QR, SVD, Schur, generalized Schur) are also provided, as are related computations such as reordering of the Schur factorizations and estimating condition numbers. Dense and banded matrices are handled, but not general sparse matrices.
https://xlllapack.codeplex.com/
PopTools
PopTools
PopTools is an add-in for 32 bit PC versions of Microsoft Excel (version 97 and up) that helps with the analysis of matrix population models and simulation of stochastic processes. It was originally written to analyse ecological models, but has much broader application. It has been used for studies of population dynamics, financial modelling, risk analysis, and calculation of bootstrap and resampling statistics.
Excel-DNA
Excel-DNA
Excel-DNA is an independent project to integrate .NET into Excel. I hope it will be useful to Excel users who currently write VBA code for functions and macros, and would like to start using .NET. Also interested would be C/C++ based .xll add-in developers who want to use the .NET framework to develop their add-ins.
http://exceldna.codeplex.com/releases/view/119190
ANACONDA: The Most Popular Python Data Science Platform
ANACONDA: The Most Popular Python Data Science Platform
With over 4.5 million users, Anaconda is the world’s most popular Python data science platform. Anaconda, Inc. continues to lead open source projects like Anaconda, NumPy and SciPy that form the foundation of modern data science. Anaconda’s flagship product, Anaconda Enterprise, allows organizations to secure, govern, scale and extend Anaconda to deliver actionable insights that drive businesses and industries forward.
https://www.anaconda.com/what-is-anaconda/
PyXLL?=python("in excel")
PyXLL?=python("in excel")
Python is a modern dynamic language with great support for scientific computing and data analysis.
Using Python you will be able to solve complex problems faster and in a way that is more easily maintainable than with VBA.
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa:
Scripting: Automate/interact with Excel from Python using a syntax close to VBA.
Macros: Replace VBA macros with clean and powerful Python code.
UDFs: Write User Defined Functions (UDFs) in Python (Windows only).
Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and Mac.
rubyXL
rubyXL
rubyXL is a gem which allows the parsing, creation, and manipulation of Microsoft Excel (.xlsx/.xlsm) Documents
https://rubygems.org/gems/rubyXL/versions/3.3.18
PHPExcel - OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine
PHPExcel - OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine
Project providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.
Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!
https://phpexcel.codeplex.com/
Gnuplot
Gnuplot
Gnuplot is a portable command-line driven graphing utility for Linux, OS/2, MS Windows, OSX, VMS, and many other platforms. The source code is copyrighted but freely distributed (i.e., you don't have to pay for it). It was originally created to allow scientists and students to visualize mathematical functions and data interactively, but has grown to support many non-interactive uses such as web scripting. It is also used as a plotting engine by third-party applications like Octave. Gnuplot has been supported and under active development since 1986.
Maxima
Maxima
Maxima is a system for the manipulation of symbolic and numerical expressions, including differentiation, integration, Taylor series, Laplace transforms, ordinary differential equations, systems of linear equations, polynomials, sets, lists, vectors, matrices and tensors. Maxima yields high precision numerical results by using exact fractions, arbitrary-precision integers and variable-precision floating-point numbers. Maxima can plot functions and data in two and three dimensions.
http://maxima.sourceforge.net/
RStudio
RStudio
RStudio is an integrated development environment (IDE) for R. It includes a console, syntax-highlighting editor that supports direct code execution, as well as tools for plotting, history, debugging and workspace management.
Click here to see more RStudio features.
RStudio is available in open source and commercial editions and runs on the desktop (Windows, Mac, and Linux) or in a browser connected to RStudio Server or RStudio Server Pro (Debian/Ubuntu, RedHat/CentOS, and SUSE Linux).
SciLab
SciLab
Scilab is free and open source software for numerical computation providing a powerful computing environment for engineering and scientific applications.
Scilab is released as open source under the CeCILL license (GPL compatible), and is available for download free of charge. Scilab is available under GNU/Linux, Mac OS X and Windows XP/Vista/7/8
Scilab includes hundreds of mathematical functions. It has a high level programming language allowing access to advanced data structures, 2-D and 3-D graphical functions.
A large number of functionalities is included in Scilab:
For usual engineering and science applications including mathematical operations and data analysis.
Graphics functions to visualize, annotate and export data and many ways to create and customize various types of plots and charts.
Algorithms to solve constrained and unconstrained continuous and discrete optimization problems.
Tools to perform data analysis and modeling
Standard algorithms and tools for control system study
Visualize, analyze and filter signals in time and frequency domains.
Increase Scilab native functionalities and manage data exchanges with external tools.
Modeling mechanical systems, hydraulic circuits, control systems...
Xcos
Xcos
Xcos is a graphical editor to design hybrid dynamical systems models. Models can be designed, loaded, saved, compiled and simulated.
Google Sites
Report abuse