owl
So you can't name a functional difference.

Snit
There are different meanings of the word, function, too... so we could look at "functions" such as SUM and MAX, or the overall function of each table.

* Function of the "Range" table: calculate the partial cost of a spell based on "Range", which consists of adding the values assigned to the size of the target, the distance from the caster, and the speed and movement of the effect. Not sure what the "Sum / Perc = -2" means and I am not going to bug folks to find out. :)

* Function of the "Time" table: calculate the partial cost of a spell based on "Time", which consists of adding the values assigned to the cast time, duration, and delay until the effect happens.

* Function of the "Force" table: calculate the partial cost of a spell based on "Force", which consists of adding the values assigned to the Effects, Elements, and Mass / Volume of what is effected. Details of this are in the text (which serves the function of explanation).

* Function of the "Mana" table: calculate the partial cost of a spell based on "Mana", which consists of *multiplying* the values assigned to the Essence (which can be impacted by the values of the above tables: Range, Time, and Force) and "Amount".

*Function of the "Total" table: Find the total cost of the magic spell by adding the costs from the above tables (Range, Time, Force, and Mana) and then rounding it to the closest five. It also summarizes the input of the other tables.

Each table has a separate, logical function (even though some of the tables use data from others). Makes complete, logical sense to split them... not just as presentation (which it makes sense to do as well) but logically / functionally.

It is sort of like asking what the difference is between text and a word processor: a word processor can handle text (and more, including images and one or more text boxes) but you can also have text in other type of programs (text editors, spread sheets, web browsers, etc.).

owl
No it's not. A word processor actually does more with the text, the data. A table has no less or more capability with the data than does a sheet.

Snit
A single table cannot be separate tables with different logical / functional purposes, though, of course, you can have one table that combines multiple functions.

owl
They both do the exact same thing.

Snit
You can say ALL data does the same thing... adds 1s and 0s, or on and off states, to some media. I suppose it just depends on what level of abstraction you can think in.

As I show above, each of the tables in the real-world example has a separate and distinct and logical function. But, sure, you can put those all into one larger table and LOSE that logical separation (and end up with a lesser visual separation). No matter how you do it, though, you end up with on and off states on some media... so they are, at that level, "functionally" the same... just stored data.

Thankfully modern computers allow us to have higher levels of abstraction without requiring us to think of such things, though!

owl
That's a whole lotta blabber just to avoid admitting that tables and sheets do exactly the same thing.

There is not one thing at the cell level that can be done in a sheet or table that cannot be done with the other.

If you insist otherwise, then name the numerical functions that are unavailable to one but available to the other.