The Calc ribbon

Everything in Calc runs from the Calc tab on the Excel ribbon. The tab is context-aware: groups appear and disappear depending on whether you are signed in, and whether the open template is in Use or Design mode.

Always available#

Button	What it does
Log in / Log out	Sign in to or out of your GIMLabs account.
About	Version and application information.

After you sign in#

Group	Button	What it does
Project	Projects	Pick the project to work on.
Templates	Templates	Browse the project's templates and open, edit, create or import one.
Selected	(labels)	Shows the current Project, Configuration and Template.
Mode	(label)	Shows whether you are in Use or Design mode.

You pick a project first; Templates and the Selected and Mode labels then fill in as you choose a project and open a template. Opening a template puts you into one of the two modes, which changes the rest of the ribbon.

Use mode (collecting data)#

When you open a template to collect data:

Group	Button	What it does
Data	Collect	Pull the project's data into the workbook, applying filters and charts.
Data	Clear	Remove the sheets a Collect created and return to the template.

See Collecting data for the full workflow.

Design mode (building templates)#

When you open a template to edit it:

Group	Button	What it does
Build	Tables	Choose a table's columns, filters, sorting, grouping and start cell.
Build	Charts	Map each chart's series to data columns.
Build	Constants	Stamp project values (Project Name, Client, ...) onto the template.
Macros	Macros	Choose which workbook macros run automatically after Collect.
Sheets	Sheets	Choose which worksheets are kept when the template is saved.
Save	Save / Save As	Save changes back to the template, or save a copy as a new one.

See Building templates for the full workflow.