Calculating by blocks

Matrex applies functions (formulas) to rectangular blocks of data, not to single cells.
We call a block of data with the mathematical term matrix. A Matrex matrix can contain numbers, text, dates, boolean values.

This approach is in general better than the original calculation by cell for big quantities of data like columns of database tables, feeds, csv files. It is always more usual to write spreadsheets containing this kind of data, so this should be the right way to go.

For these data the calculation by blocks gives: