<aside> 💡 Key concepts in this tutorial: labels; referencing; table computation; programmatic styling.

</aside>

The basic structure of the spreadsheet hasn't changed since VisiCalc was released in 1979. Microsoft Excel, Google Sheets and LibreOffice Calc are in such wide daily use because of their familiar structure, their powerful functionality and their ease of use. But it's this combination of familiarity and power, along with strategic platform incompatibility issues, that makes it next to impossible to change how the world uses and thinks about using spreadsheets.

Planarly applies decades of software engineering thinking to the world of the Sheet and redefines the concept of Sheets:

• Copy/paste is evil. Avoid repeating formulas.
• Everything is a table (including functions, etc.)
• You can see the state

If Excel is dominating the spreadsheet market, then Planarly is the revolution that is just about to launch. Like all revolutions it is bringing something new, something radical: a re-thinking, a re-conceptualisation of the sheet paradigm.

🍭Hints: This is the beginning and the most critical stage of the tutorial. It is less about the many operations available, and more about the novel ideas and the new way of thinking embodied in this spreadsheet. At the end of this tutorial you will understand the concise beauty and elegance of Planarly.

This tutorial will cover: - Label - Style - Index within sheet - Conditional statements - Operator

🔰Calculate the salary of part-timer

The Scenario: The manager asks you to calculate the salary of the part-time staff. You need to highlight the highest salary, hours worked, and hourly salary. They are shown in the figure below. If you want to follow along you can open the Calculate salary of a part-timer sheet.

1.1 Establish a part-time employee data-sheet in Planarly

1.1.1 Part-time staff data-sheet

First, we need to input the data into Planarly. For this we use the Planarly Web Demo Version. Planarly runs in Chrome, Edge, and Firefox, but works best in Chrome.

Just like in Excel and other spreadsheets, a cell is the most basic element in a sheet. Unlike other spreadsheets, the inside of a cell in Planarly is divided into upper and lower parts. The upper part corresponds to the cell's label and the lower part corresponds to its function or value, as shown in the figure below.