Data Validation and Reconciliation

Measured process data in the metallurgical and chemical processes inevitably contain inaccurate information, since measurements are obtained with imperfect instruments which have their own accuracy. DESTOSOL builds data reconciliation software that improves the consistency, quality, and traceability of production data for the process industries. The software’s performs the following functions:
 Plant-wide and Unit Balance.
Mass, volume, Concentration and energy balances on a unit or plant-wide basis. A gross error detection process precedes the balance.
 Unmeasured Flow Calculation.
Accurately calculate unmeasured flows based on reconciled measurements.
 Production/Yield Accounting.
Incorporates receipts, shipments, inventory, and process data into the plant’s production numbers. Yield reports based on shift, month-to-date, year-to-date or other basis.
 Composition Tracking
Liquids and solids bulk storage composition tracking, based on receipts to storage tanks, feed to the process plant and operation within the offsite and storage units.
 Component balance.
 Extraction and analysis of data for business systems (e.g. Treasury, Accounting, Marketing, Sales, HR, etc.).
 Complex/array formula creation, Data representation with macro, User Forms, Dynamic charts, Pivot table. Writing Complex VBA Macros. Import/Export Data from/to Excel. Create Friendly User-Form to enter/validate/manipulate data in Excel or Database. Manipulate Data from Different sources to Create Any Report/Graph. Interface Programs for single or multiple users, Excel data input with Access database and SQL. Excel calculators for Finance
 Bespoke application design and development.
 System migration to help you exploit the latest Office technologies.
 On-site assistance to support your development efforts and provide on-the-job training for your staff.