Mark E Porter

US Patent:

20110209042, Aug 25, 2011

Filed:

Feb 25, 2010

Appl. No.:

12/712707

Inventors:

Mark A. Porter - Nederland CO, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/00
G06Q 10/00
G06F 3/048

US Classification:

715212, 715227, 705 28, 715764

Abstract:

A method and system for automating the processes of organizing and analyzing client inventory data. Inventory data in a first worksheet format and user-defined mappings between columns in the first worksheet format and columns in a standard format worksheet are received from a client. The inventory data is organized by copying inventory data columns to corresponding mapped columns in the standard format worksheet. A first set of independent subroutines analyzes the organized data by standardizing text in the data and populating columns in the standard format worksheet with data derived from the inventory data. A second set of independent subroutines is applied to the analyzed inventory data to sort inventory assets listed in the standard format worksheet by asset type and determine a total count of types of assets. The sorted asset type data is displayed to a user.