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