Project description MICROSOFT PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Production optimisation - Microsoft Access, VBA

BOSH

MS Access, VBA, Pascal

Robert Bosch GmbH, Zuchwil

PROJECT LINK: Not available
People in the PROJECT: Stefan Tröhler
PROJECT Duration: Jan 1990 - Dec 1991
PROJECT Value: SFR. 240'000.00

MICROSOFT

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Development of various applications for production time recording. As part of a project to optimize the armature winding production lines, some applications were required to measure the cycle times of the production line and to determine the manual interactions of employees on the production lines. For this purpose several applications were developed using Microsoft Access and VBA or using Microsoft Excel and VBA.

  • Creation of various applications for the optimization of the automated and manual production of the company Robert Bosch GmbH in Zuchwil and Deitingen. In Zuchwil, the production of the armature winding (automated production lines) was analyzed, whereby various applications for recording and evaluating the individual machine cycles were developed.
  • The applications were created using Borland Pascal, Microsoft Access, Microsoft Visual Basic for Application, Microsoft Visual Basic and Microsoft Excel
  • Based on the data collected by the applications, significant productivity improvements were achieved.
  • In Deitingen, manual production was monitored, the production times were recorded and the work plans were created based on the recorded and calculated times.
  • An ACTUAL and TARGET value was determined, the calculated times presented in the form of new work plans and introduced into the company.
  • A Microsoft Access 2.0, Microsoft Visual Basic for Application application was created to create the work plans.
  • Based on the saved, individual work steps, the work plan was generated and the time calculated.
  • The work plan was created with Microsoft Word.
  • Requirement Engineering.
  • Create a data model using Dezign.
  • Implementation of customer requirements using Microsoft Access 2.0, Microsoft Visual Basic for Application, Microsoft Excel, Borland Delphi, Microsoft Word.
Testing and documentation (technical).