|
ü
Conversion of Distributed Control System data to
ABB Mod300 DDE Server using VB and Access as data store.
ü
Application to record consumer information, client
information, disabilities, types and length of services
provided, staff, and other information for Federal and State
funding reports.
ü
Application to record clients served, offenders,
types of services provided to clients, length of service,
offense, presenting issue, client case notes, staff, billing.
ü
Application to record product testing data by machine,
grade, caliper, color, basis weight and customer to provide
history of paper production used to analyze product variation.
ü
Application to record data on non-compliant materials
and their status in the mill. Second application to
record customer complaints, sources of complaint, status
of materials, status of complaint; to allow analysis of
material quality issues over a period of time.
ü
Application to record receipt of coating materials
inventory, conversion of materials received into units consumed
by coating recipes, use in coating batches, remaining materials
in inventory at any given time.
ü
Law Office application to serve as case database
for documentation of over 40,000 civil, criminal, and appeals
cases. In use by an office of 30 attorneys and 10
support staff. Checks for conflicts, tracks client
appointments and case notes, court calendars, and interviewing
statistics.
ü
VB applications using Excel and Access to analyze:
current open orders, late shipments, year to year analysis
of product sold, block orders to be produced, stock orders,
cancelled orders, and annual sales summaries. |
