Submit a request
  1. data1.io Help Center
  2. Power User :: Setup your individual Workbook as Web Client

Power User :: Setup your individual Workbook as Web Client

Learn how to use the Workbook Wizard and the data1.io Workbook Framework to transform your existing Excel files to a data collection workbook.

Connect your Excel Files to the Web Client

  • 1. Understand the data1.io Workbook Framework
  • 2. Configure the R/W control panel
  • 3. Configure the <SYSTEM Delta> Parameter
  • 4. Configure Measure Mapping (ByColumn or ByCell Mode)
  • 5. Configure further data entry parameters (recommended)
  • 6. Configure sheet visibility parameters (recommended)
See all 9 articles

Using advanced queries

  • Queries on Aggregated Levels (READ only)
  • Queries on DIM001 Alternative Elements (READ + WRITE)
  • Configure advanced planning parameters

Using List Queries in your workbook

  • How to define Listqueries (in progress)

Using Dynamic Tables in your workbook

  • Integrate a dynamic table into your workbook
  • How to configure your dynamic tables

General information about the spreadsheet

  • Unsupported Excel functions
  • Rules for all named ranges
data1.io Help Center