GS-Calc

GS-Calc is a spreadsheet with capabilities for processing big data sets. It can be used to edit large CSV files with millions of rows, XLSX files that are automatically split and merged, or to build complex data models e.g. with millions of look-up formulas that are opened/updated almost instantly and clean, transform, publish multi-gigabyte data sets.

• 32 million rows x 16,384 columns. The number of worksheets and subfolders is unlimited. No limit for the file size (4GB+). Large text, CSV files exceeding the 32M/16K limits are automatically split into multiple sheets and saved together in one zip64 file.
• A feature of organizing worksheets in a tree form and creating 3D array cell references for subfolders.
• Optimized to process large files. According to the vendor, an over 4GB workbook file with 500 million cells can be loaded in around 30s on an older office pc. Data sets loaded to RAM can be up to about 500GB per worksheet.
• Fast pivot tables with up to 32 million rows, built-in reports, with functions and filtering options.
  
• Monte Carlo Simulations to estimate risk in business, costs, future pensions or simply to reverse-calculate formulas etc.
• Mass modifying/adding/removing parameters/arguments used by functions in large workbooks without the risk of making mistakes in long formulas.
• VLOOKUP, HLOOKUP, MATCH, UNIQUE, FILTER functions using fast binary searching (also for originally unsorted data) to ensure the best performance for worksheets with millions of rows.
• No limitations for using cell references to external closed workbooks in all functions including the INDIRECT() function and functions written and added by users. Closed workbooks are automatically opened in the background when updating formulas and can either remain open in the background for best speed or can be automatically closed to save memory so that only one is loaded at a time.
• Use of regular expressions in the look-up and text functions and in the Find and Replace function.
• The FILTER() function to quickly filter millions of rows (and/or to perform multi-key sorting and searches for duplicates).
• Charts handling millions of data points with custom vertical and horizontal (grid-)lines.
• Fully configurable cross-highlighting to ensure the best screen readability.
• No limitations for the number of hyperlinks and its usage. Workbook hyperlinks created instantly by the Copy/Paste commands. No limitations for conditional formatting - users can create and efficiently use millions of rules.
• Users can specify from 1 to 64 processor cores to be used by GS-Calc for calculations.
• Around 450 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.
• JScript and VBscript scripts making it easy to mass-merge tables and records from csv/text/xlsx/xbase/MySQL/SQLite files.
• Loading/editing/saving CSV, text, xls, xlsx, dBase, Clipper, FoxPro, MySQL, SQLite files with up to 32 million rows (and up to 1 million columns for text files); all existing files are edited in-place, without changing their format or parameters/structure.
  
• Verifying data integrity with SHA256 checksums when switching between file formats.
• Support for JScripts & VBScripts. Organizing scripts hierarchically in trees.
• Solver functions with virtually no limits for the number of variables. Specialized numerical functions: matrix decompositions; linear equation sets with improving iterations; least squares (weighted, constrained), regression with orthogonal polynomials; time series analysis; minimization; linear programming, integer programming and quadratic programming.
  

• GS-Calc can be installed on any portable storage device and used without performing any registry modifications. Fully offline - doesn't need internet connection to install and use.