|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
|
| |
|
|
|
East Greenwich,
RI 02818 |
|
| |
|
|
|
401.885.3631 |
|
| |
|
|
|
401.884.5653 Fax |
|
| |
|
|
|
|
|
|
|
|
|
|
|
401.996.3631 Cell |
|
| AMDG |
|
|
|
"Once you
know it, it's Easy!" |
autosoft@aol.com |
|
| Commercial and custom computer related products spanning the
areas of data acquisition and control, simulation and modeling, numerical
analysis, chemical process design and manufacturing management information
systems design. 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_files/index_0000_image004.gif)
|
|
| 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 04/27/2010 06:58 PM 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|