AMI knows that the business world still loves spreadsheets.  AssetTrack makes it easy to integrate spreadsheet-based processes in to your asset management program.

The Problem with Spreadsheets

Spreadsheets empower users to easily build databases of their own to automate the capture of bulk sets of data without the constraints of a third-party software tool.  Spreadsheets give freedom to your end users, which is why so many current business processes are based upon spreadsheets.

The problem is just that:  By users having the power to capture whatever data they want using spreadsheets, asset managers lose the ability to enforce a lifecycle process and validate incoming data for quality.

AssetTrack Spreadsheet Processing

AssetTrack solves this problem beautifully by  processing spreadsheets of  data uploaded by end users.  All uploaded data is reconciled against the backend repository, ensuring all data submitted is valid.  AssetTrack’s configurable business rules enable asset managers to ensure spreadsheet data meets asset management requirements, while allowing end users to use the tools they use today.

Use Cases

AMI enterprise customers use AssetTrack Spreadsheet Processing in a variety of asset tracking use cases including:

  • Advance Ship Notices – Import data sent from vendors to streamline receiving and populate the repository with minimal manual intervention.
  • Bulk Data loads and transfers – Easily import data exported from other asset systems with assurance that all data will be reconciled with your master reference tables, ensuring absolute data integrity.
  • Discovery feeds – Easily set up feeds of discovery data into your asset repository via programmatic push of asset data to AssetTrack’s REST API.