Datum

A Revolution in Data Collection and Document Management

Datum Services

1. Overview

Up Next

Select Section
  • 1. Overview
  • 2. Core Features
  • 3.Why Datum

In today's data-driven world, organizations face numerous challenges when it comes to collecting, managing, and safeguarding their valuable data. Traditional data collection methods and form builders often fall short, resulting in inefficiency, data corruption, and security concerns. Enter Datum, a groundbreaking solution that redefines the way data is collected, validated, and managed.

Core Features

Create, read, and write Excel and OpenXML files Online Spreadsheet allows you to create high-impact business data analysis solutions that emulate the look, feel and capabilities of Microsoft Excel Online Spreadsheet displays Excel workbooks containing formulas, data sources, pivot tables, charts, and other advanced Excel capabilities with a great deal of precision.
It supports nearly all Microsoft Excel document formats includingXLS, XLSX, XLSM, XLSB, BIFF5, XLT, XLTX, XLTM, CSV, TXT

Minimum Requirements

  • Operating system windows server
  • Hosted on IIS (Internet information services) 7.0 and above
  • Microsoft SQL server (any edition)
  • .NET 4.8 framework
Block Chain
Data Analytics

400+ Formulas & Functions

  • Excel compatible functions are built-in
  • Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds.
  • From basic mathematical functions to complex formulas with statistical and financial functions, Online Spreadsheet includes everything you need to incorporate Excel-inspired data analysis functionality in web app.
Data Analytics

Mail Merge

  • Auto-generate multiple documents at once
  • Automatically create multiple documents based on a single template and include unique data from a data source
  • Supported mail merge functions (placeholders)
Data Analytics

Pivot Tables, Charts, Sparklines

  • Summarize and visualize large amounts of data
  • Supports Excel-like pivot table, shapes, sparklines (Line, Column, Win/Loss), and a wide range of 2D/3D charts
  • Column and Bar Charts
  • Pie and Doughnut Charts
  • Area and Line Charts
  • Scatter, Radar, and Bubble Charts
  • Box and Whisker Charts
  • Histogram and Pareto Charts
  • Treemap and Sunburst Charts
  • Waterfall and Funnel Charts
  • Stock Charts
Data Analytics

Data Editing & Validation

  • Keep your data clear and accurate
  • Online Spreadsheet gives you the total control over cell editing
  • Excel-inspired Data Validation engine helps reduce data entry errors, improve accuracy and data consistency when modifying worksheet cells
  • Just like Microsoft Excel, Online Spreadsheet includes an AutoFilter designed to filter data against column values and to display only those rows that meet specific criteria
  • Online Spreadsheet supports sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, date and time
Data Analytics

Document Security

  • Protect your work, prevent unauthorized access
  • You can password-protect your Excel worksheets/workbooks and prevent unauthorized access
  • Restrict Document Modification
  • Encrypt a Document with a Password
  • Specify a Password to Open or Edit a Document
  • Grant User Permissions
  • Users Management Module
  • External Authentication Integration with Azure AD
  • Invalid Data Highlighting and Commenting empty required fields
  • Required Fields validation (Data Validation Ignore blank)
  • Auto fetch & filling cells from another sheet/data source
  • Disabled Invalid cell Copy operation
  • Disabled cell dragging operation for protected sheet
  • Disabled Cell formatting override for protection
Data Analytics

Other Features

  • Live Data validation
  • Check data validation on Save
  • Save document to temporary folder for later working
  • Searchable Dropdown for List Data Validation
  • Calendar control for Date/Time Validation
  • Email Notification on Submission
  • Document Submission and Approval Process
  • On Approval/In Progress make the document ReadOnly for end users
  • Document Store Integration with SharePoint Online OneDrive
  • Online Users Tracking Module
  • Administrative View for Document Management
  • Clients View for Documents Management
  • Role Base Access Control

Why Datum ?

Data Analytics

Efficient Data Collection

Traditional forms and custom form development can be time-consuming, error-prone, and inefficient. Datum streamlines data collection by utilizing standard Excel file formats, a format familiar to users, and allowing them to design data collection templates within Excel.

Data Analytics

Validation and Integrity

Ensuring data accuracy is crucial, but many solutions struggle to provide robust data validation rules and formulas. Datum empowers organizations to define validation rules, formulas, and password protection within Excel templates, ensuring data integrity.

Data Analytics

Document Security

Protecting sensitive data is paramount, and Datum excels in this area. Datum allows administrators to password-protect entire spreadsheets while still enabling users to edit specific areas.

Data Analytics

Custom Workflows

Datum's customizable workflows for document approval, document management, and role-based access control cater to the unique needs of different projects and departments.