GS-Calc - a spreadsheet with 12 million rows and 16K columns that will let you make the best of your hardware. * Organizing worksheets in a tree form and creating 3D array cell references for worksheets in a given subfolder (by specifying only the folder path in the reference). * Efficient memory usage to quickly load and save large files. (Performance examples: https://citadel5.com/help/gscalc... ) * Pivot tables with up to 12 million rows, built-in reports and filtering options. * Monte Carlo Simulations to easily estimate risk in business, costs, future pensions or simply to reverse-calculate formulas etc. * VLOOKUP, HLOOKUP, MATCH, UNIQUE, FILTER functions using fast binary searching to ensure the best performance for worksheets with millions of rows. For example, one million vlookup() functions in a table with a few million rows can be updated almost instantly even on a slow, old pc with 8GB RAM. * References to external closed workbooks in all functions including the INDIRECT() function and functions written and added by users. * Regular charts and in-cell mini charts with millions of data points, updating instantly. (A sample chart: https://citadel5.com/help/gscalc... ) * Fully configurable cross-highlighting to ensure the best screen readability. * No limitations for using any number of hyperlinks. Workbook hyperlinks are created instantly by the Copy/Paste commands. * Users can specify from 1 to 64 processor cores to be used by GS-Calc for calculations. * Around 390 built-in functions. Users can add their own DLL libraries with new functions or functions replacing the default ones, with the same performance, dynamic array and multi-core calculations. * Each single worksheet window can be split into up to 100 panes (with optionally synchronized rows and/or columns scrolling) to display various regions of that worksheet or other worksheets and to fully maximize the working area. * Loading/editing/saving text/CSV files with up to 12 million rows and up to 1 million columns; GS-Calc will automatically create multiple sheets based on the specified maximum number of columns per sheet and then will be loading/saving such sets of text/CSV files as a zipped (ZIP64) file archive. * Splitting and merging tables to/from text/CSV files and *.xlsx/*.xls workbooks. * Loading, editing in-place, saving text/CSV, dBase, Clipper, Fox Pro, Open Document *.ods, Excel XML file formats. * JScript and VBscript scripts making it easy to mass-merge tables and records from text/csv/xlsx/xbase files. (Script examples: https://citadel5.com/help/gscalc... ) * Optimization/solver formulas: linear programming, mixed integer and binary linear programming, quadratic programming, simplex, for example =LProgBin(A, s, b, c, bin, vector, [epsilon], [m]) with up to 16K variables.

GS-Calc

A spreadsheet with 12 million rows and 16K columns

A spreadsheet with 12 million rows and 16K columns