Skip to content
VanteloqData Studio

Model BY VANTELOQ

Model: spreadsheets for the figures behind your decisions.

Model is the spreadsheet app in Vanteloq Data Studio. Organize assumptions, calculate results across worksheets and reuse selected figures in documents and presentations.

Work through a model, not just a table of values

Use cell formulas, cross-sheet references, supported named ranges and structured table references to connect inputs with results. Formatting, charts and worksheet controls help make a model readable. Unsupported calculations return explicit errors rather than executing imported code.

For a budget, keep assumptions on one worksheet and the summary on another. Change a supported input and review the dependent result before using it in a report.

Create tables and calculate filtered totals

Use Tables and filters to turn a range into a named Excel table, review its header names and fill a calculated column. Structured references stay tied to column names, and relative cell references adjust for each data row. Replacing existing column values requires an explicit choice.

Rename table columns while updating supported structured references. Literal value lists, blanks and numeric comparisons hide nonmatching rows without removing their data. SUBTOTAL excludes filtered rows; codes 101 through 111 also exclude manually hidden rows. Ordinary SUM still includes hidden values. Column insertion and deletion affect the entire worksheet column, including cells outside the table.

Move between Model and Excel deliberately

Import a plain XLSX workbook, review the compatibility report and retain the original. Export genuine XLSX files with supported formulas, tables, filter criteria and formatting. CSV is available for simpler data exchange, while Compose and Deckly can use selected workspace figures.

Start with a clear workflow

  1. Create a workbook or import a plain XLSX file.
  2. Review the warnings, worksheet dimensions, formulas and key totals.
  3. Use Tables and filters to create a table, fill a calculated column or inspect a subset.
  4. Connect a reviewed range to a report, or export an XLSX copy and inspect it.

Know what to expect

  • A workbook supports up to 20 worksheets, 10,000 rows and 256 columns per sheet, and 50,000 populated cells across the workbook. Additional archive and document limits apply.
  • Macros, arbitrary VBA conversion and external workbook execution are unsupported. Keep macro-enabled originals outside Model.
  • Supported validation includes bounded worksheet lists and formulas. External validation references and universal Excel formatting or function compatibility are not supported.
  • Filters hide rows in Model and retain criteria in XLSX. CSV and other reports include all rows.

Common questions

Is Model fully compatible with Excel?

No. It supports a documented subset, including genuine XLSX files, supported formulas, table references and filters. Review the import report and compare important calculations with the original workbook.

Does changing a currency label convert an amount?

No. A currency label changes the interpretation or presentation of a value. It does not supply exchange rates or perform a currency conversion.

Do table filters remove rows?

No. They change visibility while preserving values and formulas. SUM still includes hidden values. Use a supported SUBTOTAL reference formula to total filtered data; SUBTOTAL(109,Sales[Revenue]) also excludes manually hidden rows.

Connected to your next step

Put it into practice