AXIOM Scrap Reporting

AutoSoft Systems

2 Round Hill Court

East Greenwich, RI 02818

401.885.3631

401.884.5653 Fax

401.996.3631 Cell

AMDG

Decision Ready Information!

autosoft@aol.com

Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems. Founded in 1982.

We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.

Pharmaceutical & Biotech

Construction Management

AMDG

AXIOM Scrap Reporting

We all know that a $1 reduction in scrap converts directly to a $1 improvement in the "bottom line". So why should scrap reporting be so elusive? The SMART Scrap Reporter provides the same SMART user interface to allow one to "slice and dice" the data by:

Facility

Work Center

Machine

Transaction Code

Reason

Operator

Shift

Part Number

Order Number

Date Range

Unit of Measure

Pareto analysis is always very helpful. The Pareto principle (also known as the 80–20 rule, the law of the vital few, and the principle of factor sparsity) states that, for many events, roughly 80% of the effects come from 20% of the causes.

SMART makes Pareto analysis quick, easy and fun. One can Pareto on any of the following parameters:

Work Center

Transaction

Machine

Reason

Work Center + Machine

Transaction + Reason

Part Number

Operator

Work Order

Shift

Using any one of these parameters as the measurement:

Produced Quantity

Scrapped Quantity

Produced Dollars

Scrapped Dollars

Scrapped Percent

A detailed report is generated in seconds!

For those "hard cores" out there, the SQL code used to generate the report is included in the comment of cell A2 above:

This is one line of SQL code, automatically generated by the program based on the user's selections (don't try this at home).

Another click generates a stand alone Excel workbook with both the details and a tabular and graphical summary:

Right clicking on the chosen column instantly graphs that column

AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631

This web page was last updated at 02/21/2014 07:47 AM and is written in EXCEL!

AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach