Spreadsheet

Adaptam includes two spreadsheet styles: a regular worksheet with familiar formatting controls, and a MegaSheet that supports very large row counts. Both use Adaptam’s direct data access, intelligent guides, and formula-building features.

Overview

Adaptam spreadsheets give you:

• Familiar worksheet behavior for regular spreadsheet work
• MegaSheets for calculations that need up to 10 million rows
• Data fields that can be used directly inside formulas
• Intelligent guides that only present valid next steps
• BUILD support for constructing and debugging complex formulas

Regular Worksheet

Before you get to Adaptam’s special capabilities, the regular worksheet works and behaves like a conventional spreadsheet.

1. Menu — Works like the traditional spreadsheet menu bar.
2. Ribbon — Provides commonly used spreadsheet features plus Adaptam-specific controls such as Build and Lock.
3. Formula bar — Works like the standard spreadsheet formula bar.
4. Worksheet grid — Supports the expected spreadsheet editing, copy/paste, and shortcut behavior.

Different Menus

The menu bar exposes the main application menus used while working in Spreadsheet.

5. Adaptam — Shows Adaptam version information and Preferences.
6. File — Includes open, close, and Export to Excel for worksheet values.
7. Edit — Provides cell and formula editing operations.
8. Format — Provides formatting options for worksheet cells.
9. View — Includes zoom controls and access to the Visualizer sidebar.

MegaSheet

MegaSheets are calculation worksheets with 10 million rows. They work like regular worksheets for formulas, but formatting controls are disabled because formatting millions of rows is impractical. In most cases, very large datasets are still best handled through field formulas against the data tables.

Data Access

Data access becomes available the moment you begin typing a formula. Once you type =, Adaptam shows a mini guide below the cell, and expanding it opens the full formula-building UI.

Field Search

The field search lets you find fields and examples across all of your available data tables.

2. Field search — Searches table field names and descriptions.
3. View Field Example — Opens an example of a field formula answering a question.
4. View Function Example — Opens an example of a functional formula answering a question.
5. SEE TABLES — Lets you open the tables listed in the guide.
6. DESCRIPTIONS — Shows the description for each table.
7. # FIELDS — Shows the field count for each table.
8. # ROWS — Shows the row count for each table.

Table Guide

Clicking a table opens a guide focused on the fields within that table.

9. Field search — Searches field names and descriptions.
10. View Table — Opens a sample-data view for the selected table.
11. FIELD — Lets you click a field to use it in the formula.
12. DESCRIPTION — Shows the description for each field.
13. DATA EXAMPLES — Shows example field values.

View Table

The View Table guide helps you inspect fields before using them in formulas.

14. Loaded table — Shows the current table and lets you switch to another one.
15. Fields — Lists the selectable fields from the table.
16. Sample data — Shows example values for each field.

Data Formulas

Data formulas query data directly from your tables. You choose the field, add any filters, and then decide whether you want the first, last, or all matching values. For example:

• !1 returns the first or lowest matching value
• !-1 returns the last or largest matching value
• {} means all matching values

Field Formula Example

Examples answering a question using the data.

1. Field formula example — Opens from the View Field Example button.
2. Question — Shows the question being answered.
3. Formula — Shows the generated field formula.
4. What the formula is doing — Shows what is being done with the data.

Functional Formula Example

Examples answering a question using the data and a typical spreadsheet function.

5. Functional formula example — Opens from the View Function Example button.
6. Question — Shows the question being answered.
7. Formula — Shows the generated functional formula, including filters.
8. What the formula is doing — Shows what is being done with the function and the data.

Intelligent Guides

Once a function or data field has been inserted into a formula, the intelligent guides change to show only the next choices that work for that context.

Single Filter Selection

1. Formula — Shows the current formula ready for the next selection.
2. Intelligent guide — Displays the valid filter choices.
3. Field search — Searches fields and descriptions that work in the current formula.
4. Result — Shows the formula result as it is being built.
5. Sentence — Explains what the formula is doing.
6. ADD — Opens access to fields from additional joined tables.
7. FILTER fields — Lists the filterable fields in the current context.
8. FUNCTIONS — Lists the functions that can be used at this point.

Multi-Value Filter Selection

Filters allow the selection of multiple values from the data.

9. Formula — Shows the current formula waiting for filter values.
10. Intelligent guide — Shows the valid values for the selected field.
11. Function syntax — Shows the syntax structure of the selected function.
12. Result — Shows the current result before the multiple select.
13. Sentence — Explains the current formula logic.
14. Multi select — Lets you choose several filter values at once.

Specialized Functions

For the new functions the intelligent guides guide selections and explain the different arguments. Some functions employ argument groups separated by bars (|) which allow varied number of arguments within each group. OPTION argument groups use named arguments which allow option specification in any order.

15. Formula — Shows the specialized function being built.
16. Intelligent guide — Presents the valid next choices for this argument group.
17. Function syntax — Shows the syntax structure of the selected function.
18. Result — Shows OK or an error for functions outputting more than one value.
19. Additional arguments / entry — Shows function-specific next steps.
20. OTHER ACTIONS — Lists the other actions available for specification now.
21. FUNCTIONS — Lists functions that are valid in the current position.
22. FIELDS — Lists fields that are valid in the current position.

Option Selection

Many of the new function have an OPTION argument group allowing specification of a broad set of features, such as is exampled here for a WRITE_CALC_2D function.

23. Formula — Shows the function ready for an option selection.
24. Intelligent guide — Describes the available options.
25. Function syntax — Shows the syntax structure of the selected function.
26. Result — Shows whether the formula is currently valid for functions outputting multiple values.
27. Additional arguments / entry — Shows the remaining action for the formula.
28. OPTIONS — Lists the selectable list of valid options and what they do.

BUILD

BUILD supports breaking a formula into parts, evaluating each part separately, and then combining those parts with Adaptam’s formula integrity-aware help.

Opening BUILD

1. BUILD button — Opens the BUILD formula bar for the selected cell.

2. BUILD formula bar — Opens the special formula-building workspace.
3. Formula parts — Holds the separate formula lines being built.
4. Result part — Evaluates each line independently.
5. Info — Explains how to use BUILD.
6. Done — Finalizes the formula.
7. Cancel — Restores the original formula with no changes.

Combining Formula Parts

8. Combine button — Combines two adjacent BUILD lines.
9. BACKSPACE — Combines the current line with the line above.
10. Blue highlight — Shows the lower-line formula clearly during a combine operation.
11. Intelligence — Adds parentheses where needed to preserve the formula logic.
12. Done — Commits the finished formula back to the cell.