AirXCell - online programmable spreadsheet and R GUI
by Jerome Kehrli
Posted on Tuesday Mar 27, 2012 at 01:10AM in Computer Science
I want to share an interesting project that has appeared on the Web recently : the AirXCell project.
(As some of you already know, I am somewhat involved in this project :-)
- merges the world of spreadsheet application (e.g. Microsoft Excel, GNUmeric, etc.) and the world of computational software (e.g. Mathematica, Mathlab, etc.) and
- revolutions the usual approach in spreadsheet applications.
- Imagine a spreadsheet application, not limited to typing values or formulas in a cell. What if we could type obviously values and formulas, but also real functional commands - in the form of R programs or scripts - mixed up with formula cell range notations?
- Imagine a spreadsheet whose underlying data matrix would be available in a real statistical environment - the R environment - and usable within any R function.
- Imagine a Web application offering you a complete access to as statistical environment - for instance the R environment - with a code editor, a virtual graphic device, etc.
- Imagine an online web spreadsheet and R environment making you feel like you are working right there on your desktop with a classical rich client application.
- Imagine a spreadsheet application where any calculation - no matter how complex, extended or the volume of manipulated data - is performed within seconds.
- Imagine you have a framework at your disposal enabling you to build any kind of Web application with access to the full power of the R calculation environment.
- a spreadsheet application going much further than other state of the art spreadsheet applications,
- a spreadsheet application giving you access to several thousand of high end statistical functions from within a real statistical environment such as R instead of only a few hundreds of poorly implemented functions,
- a pretty complete R development environment and
- various other custom forms able to trigger significant calculation programs within the R environment.
An example of a dynamic form, this one is for portfolio optimization:
An example of a result of a portfolio optimization backtesting:
The User Documentation of AirXCell is available here.