eye.jpg
 
                      AutoSoft Systems
        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.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
                            AMDG
MCj00905530000[1]
TagTracker
The goal of the TagTracker is to allow a user to enter a Tag number, and the TagTracker will return all of the Tags that when into the assembly of the Tag in question for all prior operations back to the raw materials. Supplier, lot numbers, date received, all pertinent information will be retrieved. The TagTracker will also list all of the Tags for all subsequent operations that used the Tag in question. All finished goods that were made with the Tag will be listed, as well as when they were shipped and who received them.
The main screen is quite simple:                  
                             
There are two otions for reports, the Dependents Report and the Precedents Report. You can download examples of both below. Note that the Dependents report example generated over 390 direct and indirect dependents beofre the finished goods went out the door. this report took TagTracker 17 minutes to render. I venture to guess that this same report using the AXIOM interface would have taken days if not weeks to generate (if you could do it without losing your mind or making multiple mistakes).
Click here to download a Dependents Report Click here to download a Precedents Report
Dependents Report Screen Shot:
 
                           
                             
                             
Precedents Report Screen Shot:
 
                           
                             
                             
There is also a report listing how many records exist in the Tagtracker table for each day over the last year. This is helpful to determine if there is missing data. Note the color coding to alert the user to values that are not typical. Note, no activity on Christmas day.
                   
                             
                             
                             
                               
                             
                             
                             
                               
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:43 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