Every rate a scheme depends on, sale price per square metre, hard cost, parking ratio, lives on a usage. The Usages sheet in Spreadsheet lets you edit those rates in a familiar grid and send your changes back to the project, instead of opening the usage editor one field at a time.

Spreadsheet adds a Usages sheet to the workbook as soon as your project has usages. You cannot delete it or rename it. Its cells are plain values, not formulas, so you type over a rate exactly as you would in any spreadsheet.

Edit a cell on the Usages sheet and a Push button appears in the toolbar, showing how many usages changed. Click it to send only what differs to the project. Push merges each field into the usage's existing rates, so it never overwrites a rate you did not touch.

Click Discard instead to throw away your edits and re-read the project's current usages.

A cell whose value is a colour, such as #FBAD27, shows a swatch that opens a colour picker. To change a usage's colour, type or paste the hex value into its colour cell, or click the swatch to pick one. Then click Push to send it to the project.

Type a name into a blank row and click Push to create that usage in the project, along with whatever else you filled in on that row. A new usage with no type does not appear on the map, so Spreadsheet defaults it to a building section and tells you it did.

Right-click a row and choose Delete "usage name". A red Sure? confirmation appears in that same row. Confirming removes the usage from the row, and clicking anything else in the menu cancels it.

Clearing a row's name instead of using the right-click menu marks that usage for deletion on the next Push: the button arms on your first click of Push and carries out the deletion on the second.

Type a new name over an existing one and click Push to rename it. Nothing else needs confirming: typing the new name over the old one is the action, so Push carries it through without asking again.

Deleting or editing rows on the Usages sheet is undoable with Cmd/Ctrl+Z, the same as any other sheet. Only a change that has actually reached the project through Push needs the confirmation step described above.

Point any formula at a cell on the sheet, like =Usages!C8. Type =, click the Usages tab, then click the cell, and Spreadsheet writes the reference for you. To total or average across geometries, use a GI function instead, like =GI.TOTAL("grossArea", "usage=Residential"). GI functions read the project directly, so they don't depend on where a row sits in the sheet.