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
People in the PROJECT: Stefan Tröhler
PROJECT Duration: Jan 1990 - Dec 1991
PROJECT Value: SFR. 240'000.00
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.
Stefan Tröhler
Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development
03 Feb09:57:57 AM
Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development
03 Feb09:57:57 AM
Microsoft SQL Server DWH and SSIS, SSRS, SSAS development
03 Feb09:57:19 AM
Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development
03 Feb09:57:19 AM
Microsoft SQL Server - DBA Admin
03 Feb09:55:44 AM
Microsoft SQL Server Consultant - DBA Admin - Consultant
03 Feb09:55:44 AM
Microsoft SQL Server Specialist
03 Feb09:55:44 AM
Microsoft SQL Server Consultant - Architecture - Consultant
03 Feb09:55:44 AM
Microsoft SQL Server and SSIS, SSRS development
02 Feb09:41:07 AM
Microsoft Excel, VBA Developer / Consultant - Microsoft Excel, VBA
12 Jul04:34:23 PM
Microsoft Excel, VBA Developer / Consultant - Microsoft Excel, VBA
16 Dec03:34:23 PM
Microsoft - SDLC Host based MS Access development, keying
06 Jun04:34:23 PM