Sheetless

Getting Started

Start by creating an account at https://sheetless.io.

Creating your first project

After you've created an account at https://sheetless.io and followed the steps to create a new project, then you should have arrived at a screen that looks like this:

App Tour

You can launch a short walkthrough of the main model-building workflow by selecting Help -> App Tour from the main menu.

The Right-click Menu

Right clicking anywhere on the workspace will bring up this menu.

All of these option are explained throughout the documentation, but for this quickstart guide, let's have a look at the first three.

Click on Create Variable to add your first simulation element to the workspace.

Click on this variable, to bring up the element inspector on the right-hand side of the workspace.

Go ahead and create a formula for this variable. For a full list of formulae, you can refer to the documentation. I've used the ramp() function and passed it a value of 5, which means that the value of this variable increases by 5 each time step.

Now let's add a Flow - using either the right-click menu, or simply by pressing the 'f' key on your keyboard - and connect the variable to it by dragging an arrow from the variable.

We can now use the variable inside the formula for the flow. This works a bit like a cell reference in a spreadsheet, only the arrows mean that we can see the relationship between these two elements, and makes it much less likely that we'll make a mistake!

To use the reference to Variable 1, simply click where it appears under the formula bar, and Sheetless will automatically add a reference.

Next, add a Stock and connect the Flow arrow to the Stock. This stock will accumulate the flow values across the simulation.

Adding simulation elements, modifying formulae, and connecting elements are the most basic actions you will undertake in Sheetless. As you get comfortable building simple models, you can start to explore some of the more advanced features in Sheetless - Datatables Submodels, Lookup Tables and Panels. You can also use reporting elements like Charts and Tables to add basic dashboarding functionality to your models.

As you build confidence working with these elements you will see that you are quickly able to build complex simulation models logically and intuitively. You can have a look at one of the many public projects developed by the Sheetless community for insipiration. Here's a current example of a simple COVID-19 model: https://sheetless.io/@sheetless/covid-19-transmission/app

You can use the "Save As" action to add any public model to your own dashboard if you would like to extend or modify it.