GS-Calc

It is a spreadsheet application that lets you manage complex calculations and large amounts of data.

GS-Calc is a spreadsheet application that will help you organize your data, track your expenses and incomes, create reports, search and edit databases. With this application you could easily use the sophisticated features of Excel such as pivot tables and other advanced functionality. Managing your spreadsheet is simplified by the ability of this tool to let you organize spreadsheets in a tree-structure. Very large data sets, as large as 12 million rows and 4096 columns could be handled easily. Fast pivot tables supporting up to 12 million rows can be implemented as array formulas. You can set up multiple windows to view the sheets. Multi-pane worksheet windows with up to 100 freely sync views and advanced sync options are available.

Around 300 built-in formulas including specialized numerical functions such as matrix decompositions, linear equation sets with improving iterations, least squares (weighted, constrained), regression with orthogonal polynomials, time series analysis, minimization, linear, integer and quadratic programming, array formulas and 3D-formulas, UDF functions accepting and returning arrays, etc. are some sophisticated things included. You could also integrate all these functionality into an application of your own through the COM interfaces provided. This is a very good product and is a good option when you have a need for a tool like this. Go ahead and try it out in your exact work settings. If you have one of the newer processors, this tool will process data faster.

GS-Calc is a spreadsheet application that will help you to organize your data, track your expenses and incomes, create reports, search and edit databases. Using fast GS-Calc pivot tables and other advanced functions you can perform the most demanding statistical calculations and data analysis. Some of its unique features include capability of organizing worksheets in tree structures and working efficiently with very large data sets (12 million rows x 4,096 columns). You can install GS-Calc on any portable storage device and carry it with you. * ODF spreadsheet format as the default file format. * Fast pivot tables supporting up to 12 million rows, implemented as array formulas. * Multi-core recalculations taking full advantage of multiple processor cores. * Around 300 built-in formulas including specialized numerical functions: matrix decompositions; linear equation sets with improving iterations; least squares (weighted, constrained), regression with orthogonal polynomials; time series analysis; minimization; linear, integer and quadratic programming. * Array formulas and 3D-formulas; UDF functions accepting and returning arrays. * Workbooks containing any number of hierarchically organized worksheets. * Multi-pane worksheet windows with up to 100 freely sync views; advanced sync options. * 2D/XY and 3D charts capable of handling very large amounts of data. * Clean installation (no registry entries are required); optional fully portable setup. * Saving workbooks to PDF: saving entire workbooks (with the worksheet tree structure preserved), single worksheets, ranges and single charts; very small output files. * Importing, exporting and editing text, dBase III-IV, Clipper, FoxPro 2.x and Excel 2003 XML files.