– Forecasting and Data Collection

What is makes excel to a collaborative database. Use it for spreadsheet-based forecasting and smart data collection processes with 100s or 1000s of users.

It is a highly innovative SaaS solution to collect, aggregate and share MS Excel® data – not files – within teams inside and outside your company. is now available as alpha-release. You can test it and companies can acquire special early-bird-rights to use the technology for custom enterprise solutions for forecasting and data collection. Try it and contact us!

Which problem is solved with automatizes those processes, where companies typically (1) use standardized "Excel forms" (2) to collect data from at least 2 people inside or outside the organization, (3) aggregate the data with usually too much ressources, (4) share the results with the management and (5) repeat the process on a daily/weekly/monthly/quarterly/annual basis.

The following sub-steps/pains are automatized and solved:

  1. Manual Duplication of an Excel master file for every single receiver, filling them with reference data (e.g. actuals) and possibly reworking the files with last minute changes
  2. Manual Sending every single file via e-mail to the right receiver(s)
  3. Manual Recollection of the completed files at the closing date incl. „calling-in“ of delinqent collegues
  4. Manual Aggregation of the (finally valid) figures to reports
  5. Manual Repeating the process in the next loops (possibly with adaptions)

The following corporate „smart data“ collection processes are adressed:

  • Rolling Sales-Forecast within the sales team (test the SALES showcase)
  • Personell cost planning with an external tax advisor (test the HR showcase)
  • KPI target values for dashboards and scorecards from all teams
  • Daily or weekly branch reports for non-ERP data
  • Continuous tracking of costs and progress in project teams
  • Complementary collection of operation and quality metrics (CAQ) in production facilities („small data“)
  • Annual Corporate Budgeting (all teams)
  • Monthly collection of timesheet entries of external freelancers
  • and many more …

By automatizing this collection process, adresses also excel-based processes, which (1) need to version data and compare them as scenarios and/or which (2) need to split large Excel files for several users and adding a security system.

Why using data1, what makes it unique?

1. Cloud-based Solution

no initial investment, no infrastructure, pay-as-you-go, simplicity by design, maximum user scaling, maximum data scaling

2. Native Excel Interface

real Excel instead of „similar to Excel“, everyone knows how to use, maximum flexibility, bring your excel files and keep them, no „one-way Import“

3. Real-time Aggregation

Insights in real-time, sum-up by simple double-clicking in dimension trees, no parameter configuration and no nasty waiting for report rendering

4. Workflow-Automation
opening and closing of collection loops, simple e-mail invitation for planners, e-mail notifications for delinquent planners

5. Figures, Comments & Multimedia
entering figures as well as (rich-)text for comments, upload attachments, enrich your business data with multimedia content

6. Service-oriented Architecture
specialised SaaS application for data collection, used as single service or as part of an overall planning system, delivers smart data to dashboard applications, open I/O strategy

What about existing products and solutions, why not using one of them? does not aim to replace other existing solutions but wants to automatize forecasting and data collection processes where existing solutions can not help.

Compared to integrated forecasting modules in CRM-/ERP software … delivers a very attractive licensing model to connect 100s or 1000s of decentralized forecasters and data collectors, additionally the native excel user interface mostly is easier to use.

Compared to tradtional BI planning software … is a solution specialized on only 1 task: decentralized („bottom up“) forecasting and data collection. It delivers a very attractive licensing model for 100s or 1000s of users. Compared to server based software the deployment as SaaS solution does not require any local infrastructure. does not replace BI planning solutions but can complements them.

Compared to traditional Excel VBA-Solutions … is a modern web-based solution with no local client installation and therefore no client maintenance. It can be used also with Excel Online in the Cloud or on-premise with Office Online Server / SharePoint.

Compared to Spreadsheets in SharePoint Libraries or Google Drive … separates the data from the spreadsheet into a BI database, delivers workflow automation, integration of actuals and real-time reports.

Compared to SharePoint Lists and Workflows … uses native – user friendly – excel instead of web forms, delivers a BI database as backbone with integration of actuals, business intelligence and real-time reports.

Compared to individual forecast solutions … can be used very flexible for many usecases, uses native excel instead of a grid and is probably cheaper.

How does it work, which technologies are used? uses Templates in Excel or Excel Online as User Interface (Frontend), a modern Taskpane Add-In for the data exchange (Read/Write) and an Azure hosted webservice to store/retrieve the data in/from the cloud (Backend).

  1. Templates = normal Excel files enriched with data1 parameters in order to enter your data and report the (aggregated) collected data … different use cases are realized with different templates. The data1 system is completely open for any templates that contain the technical data1 definitions.
  2. Excel Add-In = the bi-directional connection between the Excel interface (templates) and the data1 webservice … makes Excel to a Business Intelligence Application. Programmed in Javascript it runs in „normal“ Excel (beginning Excel 2013 SP1) as well as in Excel Online. The Excel Add-In is available in the Microsoft Office Store.
  3. Webservice = the heart and brain of the data1 application. It transforms the collected data to records and writes it to the data1 cloud database. In reading mode, the webservice extracts and optionally aggregates the records for delivery to the Excel Add-In.

How can be used?

First, test the showcases for free.

Test the currently available alpha-version of the data1 application with the Taskpane Add-In from the Office Store and one of our templates. Just download one of the templates, start it in Excel 2013/2016 or in Excel Online, install the data1 Excel Add-In from the Office Store and register/login. Then test the service with the showcases.

Second, get your custom enterprise solution.

At this stage of the development, we offer custom enterprise solutions with special early-bird-rights. This offer enables companies, to deploy individual forecasting and data collection solutions with this new generation of technology. Either in the Microsoft Azure Cloud or on-premises in your private network – as you prefer! Contact us if you have a project in the area of forecasting and data collection and if the technology is interesting for your project.