Hello guys,
Assuming you're on an OpenCL supported platform and all is set up
correctly, you can use the following test spreadsheets (courtesy of
AMD and MultiCoreWare) to benchmark OpenCL performance on the
spreadsheets.
http://kohei.us/2014/10/02/opencl-test-documents-for-calc/
Pretty non-trivial if your data sets are small. However, if your
datasets are massive AND are coming from a Windows based environment
with massive spreadsheets, recent builds of LibreOffice Calc will
perform extremely well (and favorably so) compared to Excel on both
Windows and Linux.
And by the way, your VBA macros (*cringe*) will work with LibreOffice calc.
-Dennis.