AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        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
Embedding Excel Workbooks In AXIOM User Data
AXIOM User Data is a wonderful thing.  However, we always want more, more, more.  Imagine how much information one could put in an Excel workbook.  We are now only limited by our imagination.  With the help of the programmers from Midwest, C&M Corporation was able to create a user data field user entry routine that would launch an Excel workbook based on the Customer number.  C&M's Customer Maintenance User Data screen looks like:
Note the "Cust Excel" user data field.  As soon as that cell is selected, Excel is instantiated (if it is not already opened) and the following file appears:
The full power of Excel is in play here.
The SMART contribution to this implementation is as follows. First, a customized template was developed to meet the needs of the organization.  As with all of SMART Excel files, the yellow background cells are user editable fields.  The blue background cells are calculated fields, and the green background are fields that are populated from data automatically extracted from AXIOM.  The green fields are automatically updated nightly.  This update includes other user data fields as well as shipment and backlog information.  Also note that from time to time there is a need to refine the template to fit changing requirements.  SMART also has a utility that extracts all information from each Excel file, stores it temporarily, and then build all new files using an updated template.
To view a sample file, click here.
Additionally, SMART provides another summary document that allows users to edit these templates without first logging into AXIOM (saving valuable AXIOM licenses).  This file is part of the standard CART reporting menu and looks like:                    
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:45 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