Given the pervasive nature of spreadsheets in today's world, we have no choice but to embrace it but need to manage spreadsheets based data properly. The good

Given the pervasive nature of spreadsheets in today's world, we have no choice but to embrace it but need to manage spreadsheets based data properly. The good news is that Mathematics of Big Data book published by MIT press book is proposing associative array algebra that is capable of properly processing spreadsheets, graph networks, matrices and databases [1], [2]. According to the book this is the first time such system is being proposed. They even provided open source D4M software in Python and Matlab to demonstrate the idea, probably worth checking out [3]. [1] Mathematics of Big Data: https://mitpress.mit.edu/9780262038393/mathematics-of-big-data/ https://mitpress.mit.edu/9780262038393/mathematics-of-big-da... [2] Associative Arrays: Unified Mathematics for Spreadsheets, Databases, Matrices, and Graphs: https://arxiv.org/abs/1501.05709 https://arxiv.org/abs/1501.05709 [3] A D4M module for Python: https://github.com/Accla/D4M.py https://github.com/Accla/D4M.py