Quickstart: Getting orientated in the L4 spreadsheet user interface¶
The main interface for writing L4 is a Google Sheets spreadsheet, the LegalSS spreadsheet. (The current version of the LegalSS spreadsheet is v0.9.4.6 as of November 2023.)
This tutorial walks you through setting that up, so that you can write L4.
Getting the LegalSS spreadsheet working on your computer¶
1. Set up a Google account, if you don’t already have one¶
You need a Google account to write L4.
If you do not already have one, you can create one by following the instructions at Create a Google Account.
2. Open the LegalSS spreadsheet in a new browser tab¶
Open LegalSS spreadsheet (clicking on the link will open the spreadsheet in a new window)
and then follow the instructions in that spreadsheet.
The spreadsheet works with the 2 most recent versions of:
We will also summarize the instructions below, but it will probably be easier to focus on the spreadsheet and follow the instructions in it, instead of having to look back and forth.
3. What to do, once you have LegalSS spreadsheet open in a new browser tab¶
Again, it will probably be easier to focus just on the spreadsheet and follow the instructions in it. But we will also summarize the most important instructions below, just in case (the spreadsheet will go into more detail).
a. Make a copy of the LegalSS spreadsheet by clicking File > Make a copy.¶
You should get a pop-up like in the image below.
You can rename this copy to a name of your choosing, or leave the default name as it is.
b. Choose where you want to copy the LegalSS spreadsheet¶
Choose where you want to copy the spreadsheet. By default, it is copied to “My Drive”.
This will be your copy of the LegalSS spreadsheet.
Contact the L4 developers for help¶
If you do not see a sidebar, contact the L4 developers for help.
But, again, note that the spreadsheet contains more detailed set-up instructions.
Familiarise yourself with the LegalSS spreadsheet¶
Orange box: Name of your copy of the LegalSS Spreadsheet¶
In this screenshot, the name refers to the original name of LegalSS spreadsheet.
You should either see the default name “Copy of LegalSSv0.9.4.6” or the name you have replaced the default name with.
Numbered steps that show how you can use L4’s output.
Step 1 links to an external web app that can be used to explore whether a legal rule is fulfilled or breached, depending on what is written in the red box.
Step 2 shows a diagram of the generated legal rule, allowing you to easily refer to whether a legal rule is fulfilled or breached.
Step 3 shows a diagram that is clickable and can be expanded to show the logic of why a legal rule is fulfilled or breached.
Steps 4 to 24 are options for you to export the L4 diagram and results into different formats. See Exporting L4 for more information
The area below the numbered steps shows a ‘debugging’ area where you can check the L4 code that you can use to help fix any error you may be facing when writing L4. We are working on creating information about this ‘debugging’ area.
Green box: LegalSS spreadsheet tabs linking to other examples¶
The LegalSS spreadsheet comes with built-in examples that you can navigate to with the tabs at the bottom of the page.
Red box: Environment for writing L4¶
This is where you write your L4 code.
Black box: Liquor exercise example¶
In this particular LegalSS spreadsheet tab is the Liquor exercise, given in grey cells. The grey box with words contains comments; these comments will not run as L4 code.
The light blue box found in the first column shows you what cell is being selected and that will be edited if you type something. In this example screenshot, a cell highlighted in yellow is selected.
You will fill your answer in the cells highlighted in yellow.
Next Steps¶
Once you have finished installation, consider exploring:

