Online spreadsheet calculator

Spreadsheet operations

• Click on a cell to focus on it and edit its content.
• To use another cell's value in calculations, type its address in the form A1, B5, C3, or simply click on that cell while holding the Shift key.
• It is advised to add a symbol, title, and units to every cell to make the script more user-friendly. You can also add image and description message if needed.
• Click on Ω to open the cell description table (you have to be focuset on that cell). This is where you create global variables, conditianal comments, or option objects.
• You can use the same image as an illustration for multiple cells. First add it to the gallery in the cell description table. Then focus on the desired cell and click the default image icon in its description.
• Image titles created in the gallery editor are only visible in the report.

Conditional cell value

• if{D2 <= 7}(3.75 + D2^1.7)
• elif{D2 > 7 && D2 < 12}(24.75 + D2^1.85)
• else(125)

Conditional cell comment

• Useful for quickly indicating whether results are correct. Three semaphore colors are supported (optional): g, o, r — green, orange, and red, respectively.
• if{D2 <= 355}(ok)[g]
• elif{D2 > 355 && D2 <= 500}(possible plastic deformation)[o]
• else(high risk of failure)[r]
• Semaphores are shown directly in cells. To see the comment, however, open the cell value table.

Report editor

• Has a built in primitive mark up language.
• $ — cell reference ==> $A2, $F4
• % — symbol definition ==> %{overline-r}(F)[t-v:x-b]
• _ — subscript ==> H_2O — H₂O
• ^ — superscript ==> m^n— mⁿ
• It is possible to show a conditional comment together with the semaphore in the report by using a special type of cell reference such as $A2[sc].