Skip to main content

Spreadsheet

How to Use the Spreadsheet App

1 author19 articles
Add the Spreadsheet AppHow to add and open the Spreadsheet app
Rows & Columns in SpreadsheetSelecting, inserting, deleting, moving and resizing rows and columns
Charts in SpreadsheetEvery chart type, the settings panel, moving and resizing, auto-detection from your selection, colors/legend, and blank-row/date handling
Filters in SpreadsheetThe filter argument, its operators, and taking a filter value from a cell with GI.WHERE
Saving in SpreadsheetThe Save button, automatic saving, working with a teammate, and what's actually stored
Schedules in SpreadsheetBuilding a stamped schedule, cross-tabbing two dimensions into a pivot table, correcting how a field aggregates, filtering, sizing, and one-click ready-made schedules
Find in SpreadsheetSearching values and formulas across one sheet or the whole workbook
Units in SpreadsheetThe metric/imperial toolbar control, how conversion works, and GI.UNITS()
Sheets in SpreadsheetAdding, renaming, reordering and deleting sheet tabs
Formatting Cells in SpreadsheetBold, colours, borders, number formats, and more from the Style menu
Column Types in SpreadsheetThe twelve number formats, how typing a value sets its format automatically, and dates and drag-fill
Function List in SpreadsheetEvery function, its arguments defined, a worked example, and a real estate reason to use it
Example Workbooks in SpreadsheetSeven worked pro formas and appraisals built from your live project, from areas by usage to hotel and data centre appraisals
Importing a Workbook in SpreadsheetImporting an .xlsx file, why .xls is not supported, and the Excel/Google Sheets clipboard round-trip
The Usages Sheet in SpreadsheetEditing project usage rates in a grid and pushing changes back
Building a Formula in SpreadsheetWriting a GI.* formula, pointing at cells, and worked examples: plot ratio, efficiency, blended revenue, unit mix, residual land value, cashflow
The Blocks Sheet in SpreadsheetAdding a custom property to a reusable block definition, and the Instances column
The Features Sheet in SpreadsheetReview and edit every geometry in your project from one table
Per-Geometry Calculations in SpreadsheetGI.SUMEACH and its relatives, why a missing field is skipped not zero, measure classes, and weighted averages