Invisible spreadsheets inside Cache / IRIS InterSystems on globals. There are workbooks, worksheets, columns, rows, cells with formulas. But formulas in the cells are unusual - they are actually M-commands. The interface with users is not directly, but through any “traditional excel” (or through web-browser - is still under development).
Any cell has address: ^workbookNamel(userName,sheetName,row,column).
The possibilities of the glob-worksheets are orders of magnitude higher. Globals spin faster than traditional sheets. All Cache / IRIS resources are available to m-commands (m-formulas) in glob-cells. You can build complex multidimensional data structures and quickly receive analytical reports with a large number of graphic elements. You can create a complex interactive game by only m-formulas (m-commands) in cells.
There is no need to keep a huge archive of workbooks with data from different periods of time. All data is stored in globals of the M-database.
There are important advantages of m-formulas over traditional formulas:
No programming other than m-formulas in cells is required.
It can also be used as an interface for IRIS / CACHE.
You can test on the example of the game ( SUDOKU, sea-battle .. )
If you have Microsoft Excel, download and unzip file
to any folder and run MX-1_TEST.XLSB. Your excel will connect to the remote server CACHE.
To work with your local IRIS / CACHE, more detailed on