| A | B | |
|---|---|---|
| 1 | sσ | 1.2 |
| 2 | sτ | 1.3 |
| 3 | sγ | 1.45 |
| 4 | ||
| 5 | s | 1.4203 |
Rendered with
| A | B | C | D | |
|---|---|---|---|---|
| 1 | X | Y | Z | |
| 2 | a | 8 | 12 | 27 |
| 3 | b | 5 | 4 | 15 |
| 4 | c | 7 | 24 | 43 |
| 5 | ||||
| 6 | T = | 2564 |
Rendered with
| A | B | C | |
|---|---|---|---|
| 1 | Fk | 400 | N |
| 2 | f2 | 10 | mm |
| 3 | H1 | 13 | mm |
| 4 | z | 12 | |
| 5 | Fn | 0.0816 | N/mm^2 |
Rendered with
| A | B | C | |
|---|---|---|---|
| 1 | r = | 5 | m |
| 2 | h = | 3.4 | m |
| 3 | |||
| 4 | v = | 89.0118 | m^3 |
PNGSVGMathMLLaTeXC/C++
Rendered with
Names, not coordinates
=(B1*B2)/SQRT(B1^2+B2^2)+SQRT(B3/5) tells you nothing about what is
being calculated. The same formula drawn with the names of its
cells does.
fxRender takes those names from the cell beside each value, or from a
named range, and understands LaTeX in them — so s_\sigma in a
cell becomes a real subscripted sigma in the equation.
It reads your table
Point it at a formula covering a block of cells and it recognises the column and row headings around them, then writes the calculation in the notation a mathematician would use — a product, a sum, a maximum over a range.
This is what makes a dense SUMPRODUCT across a table legible: you
see the shape of the calculation rather than a string of coordinates.
Units carried through
Put the units beside the numbers and fxRender will carry them through the calculation, cancel what cancels, and show you what the answer is actually in. Newtons over millimetres squared, not "0.0816".
It is the quickest dimensional check there is: if the units come out wrong, the formula is wrong.
Then take it with you
Every equation can leave the sheet. Copy it as a picture for a report or an email, save it as a vector, or copy it as MathML — which Word turns into one of its own equations, editable and sharp at any size. Or take the LaTeX straight into a paper. All four are one press away.
And it does not have to stay an equation. The same calculation can be exported as real C/C++ through CodeCogs, compiled to WebAssembly, and embedded in your own page as a live calculator — the actual code running, not a picture of it. Readers change a value and the answer moves.
Which is the honest end of the story: the spreadsheet becomes a document, the document becomes something people can use.
CodeCogs®