1 year ago
Tues May 23, 2023 2:18pm PST
Show HN: GS-Calc – a spreadsheet with 12M rows
Loading a 4GB+ workbook with over 500 million cells with random floating-point numbers and text strings - 8 worksheets, ~12 million rows each should take less than 30s on a computer with 16GB RAM.

Updating 12 million vlookups searching 12 million rows takes seconds.

Effective use of up to 64 processor cores for calculations applying any functions, including any number of user-created functions that can both extend and replace the default built-in set of ~390 functions.

Filtering, regular expressions, Monte Carlo simulations, pivot tables with up to 12 million rows, scripting.

GS-Calc can be installed on any portable storage device and used without performing any registry modifications. The installation folder requires ~8.5MB.

https://citadel5.com/gs-calc.htm (incl. YT videos with examples)

Any suggestions, especially regarding the ETL-related functions, are welcome.

Thanks

read article
comments:
add comment
loading comments...