Skip to main content
SIMCEL Sheets is a familiar spreadsheet editor built for supply chain work. Data you enter can feed directly into plans, scenarios, and events without leaving the platform.

​
How to access

Navigate to Tools > Spreadsheets from the sidebar.

​
What is a SIMCEL Sheet?

A grid of cells (rows x columns) where each cell can hold:
  • Plain text or numbers - Displayed as entered
  • Formulas - Prefixed with =, evaluated automatically
  • Formatting - Bold, italic, font size, alignment, number format, colors, borders
Sheets are named documents saved to your workspace, and can optionally be linked to a plan or scenario for downstream use.
SIMCEL Sheets editor showing the grid with cells containing text, numbers, and formulas, with the toolbar visible above including font controls, formatting options, and number format selectors, and a formula bar displaying the active cell's formula

​
Editing

​
Grid interactions

ActionHow
Select cellClick
Select rangeClick and drag, or Shift+click
Select whole column/rowClick the header
Edit cellStart typing (overwrite) or F2 (edit without clearing)
Confirm and moveEnter (down), Tab (right), Escape (cancel)
NavigateArrow keys when not editing

​
Toolbar

Font family, size, bold/italic/underline/strikethrough, text alignment, number format (currency, percentage, decimal places), text and background colors, borders, and format painter.

​
Fill handle

Drag the small square at the bottom-right of a selection to auto-fill copies. Formula references increment automatically (e.g., =MASTER(A2) becomes =MASTER(A3)).

​
Copy and paste

Standard shortcuts (Ctrl+C / V / X). Paste supports CSV data from Excel or Google Sheets.

​
Formulas

Start any formula with =. Available categories:
CategoryFunctions
MathSUM, PRODUCT, ROUND, ABS, SQRT, POWER, MOD
StatisticalAVERAGE, MIN, MAX, COUNT, COUNTA, MEDIAN
TextUPPER, LOWER, LEN, CONCATENATE, LEFT, RIGHT, MID, TRIM
LogicalIF

​
The MASTER() formula

=MASTER(ref) fuzzy-matches a cell value against your workspace master data (products, customers, locations) and returns the best canonical match. 
=MASTER(A2)                    → Best-matching canonical name
=MASTER(A2, "brands")          → Brand of the matched product
=MASTER(A2, "productId")       → Product ID of the matched product
=MASTER(A2, "category")        → Category of the matched product
Match confidence:
  • 80%+ - Confident match, resolved value shown directly
  • 20-79% - Uncertain match, shown with ~ prefix
  • Below 20% - #NO_MATCH error
  • In progress - #RESOLVING while lookup runs
Spreadsheet cells showing MASTER formula results: cells with a green highlight for confident matches at 80% or above, cells with a tilde prefix indicating uncertain matches between 20 and 79%, and a #NO_MATCH error for values below the confidence threshold

​
Match to Master workflow

For bulk matching:
  1. Select cells containing raw values
  2. Right-click > Match to SIMCEL
  3. Pick entity type (Products / Customers / Locations)
  4. Click Search - results show original value, best match with score %, and dropdown for alternatives
  5. Review, accept or reject per row, click Apply
Matched cells update with a subtle green highlight. Use Fix All to auto-apply best suggestions for uncertain matches.
Match to Master dialog showing a table with original raw values in one column, best match suggestions with score percentages in another, a dropdown for selecting alternative matches, and Accept and Reject buttons for each row

​
Normal sheets vs. system sheets

TypePurposeDownstream integration
Normal SheetFree-form spreadsheet for calculations, notes, scratch workNone
System SheetCreated from a template, linked to SIMCEL’s planning modelCreates/updates plans, events, or scenarios on submission

​
System sheet templates

Enter demand targets by product and sub-channel across time. Once verified, the sheet becomes a selectable data source in the Plan Drawer.
  • Layout: Header row with Product / Sub-Channel / month columns (Mon-YY format)
  • Submit: Click Verify Forecast Input
  • System checks: at least one data row, valid month headers, sheet saved
  • Success: Green “Validated” badge appears
Capture price changes across products and date range. On submission, creates an event version in Event Management.
  • Metadata: Event name, version name, description in dedicated cells
  • Data: Product x price type x monthly values (YYYY-MM format)
  • Supported price types: Listed Price, Distributor Price, Secondary Price
  • Submit: Click Submit to create/update the event version
Override statistical forecasts with manual targets. Same metadata structure and submission mechanism as other templates.
Define demand for new products without historical data. Same metadata structure and submission mechanism.
System sheet template selector showing available templates including Forecast Input, Pricing Adjustment, Forecast Override, and New Demand Stream, with a preview of the Forecast Input template layout showing the header row and column structure

​
Saving and opening

  • Save - Click Save (top-right); first save prompts for a sheet name
  • Open - Click Open to see the sheet list: New Blank Sheet, New System Sheet (templates), and My Sheets
  • Clear - Empties the current grid

​
Lana AI assistant

An embedded AI assistant that can read selected cells and suggest values:
  1. Select cells
  2. Right-click > Ask Lana
  3. Describe what you need
  4. Lana returns cell-level suggestions
  5. Click Apply All to write suggestions into the grid