| klste@hotmail.de |
Log work shift handover work shift change in Excel VBA
This is how it works. Shift handover protocol.
This program is an Excel file programmed in Excel VBA. She creates a shift handover protocol for 3 shifts for every day of the year. The program saves all the entered sequences of the shift days and the saved data can be retrieved from the program for printing in the “Sheet” worksheet.
File structure. Shift handover protocol.
The Excel file contains 3 sheets: “Mask”, “Sheet” and “Legend”.
Everything in the program is done via an input mask. The input mask is activated in the “Mask” sheet using the “Mask” button.
In the “Sheet” worksheet contains whatever is selected: the calendar or schedule of the selected shift.
In the “Legend” sheet in the cells highlighted in yellow there are: names of the production lines, names of the production status and the names of the comments.
Delete database. Shift handover protocol.
There is a red “Delete database” button in the input mask.
With the button all entered protocols of the shift handover are deleted. Delete password is the number three.
Change year. Shift handover protocol.
There is a “Change year” button in the input mask.
A calendar for any year can be created in the input mask using the "Change year " button.
There are sixteen movable holidays in the list. By checking the box, the selected holiday is designated as a day off.
From a list of fifteen fixed holidays, users can choose the name and date of each holiday, and use the checkboxes to designate holidays as days off.
Click the "Take over" button; enter the 4-digit year in the input field, and click "OK." The calendar is created.
Create an annual calendar. Shift handover protocol.
There is a “Calendar” button in the input mask.
This button creates a calendar for the entire year in the "Sheet" worksheet.
Open shift handover protocol form. Shift handover protocol.
The input mask contains a “Shift handover protocol” button.
This button opens a frame with a protocol shift handover form.
The form consists of 4 parts:
Calendar with shifts,
Framework for the first production lines,
Frame for second production lines,
Annotation for 4 areas.
Select date and shift. Shift handover protocol.
Data entry is only possible if date and shift are selected.
The contents of the yellow fields in the form can be entered into the database. All white fields contain data that has already been entered.
In the “Team” field, it is better to simply enter the name of the shift, as there is not much space in the sheet for the content of this field.
Frame for the first production line. Shift handover protocol.
In the “Legend” worksheet allows the user to specify names for multiple areas that appear in the input form and sheet:
The name of the frame for the first production line is in cell A2
Terms for production line status (for both production lines) are in the range B2:B21
Each product is marked with a status, for example “Finished”, “Runs”. The name of the status is entered in the area C2:C21 (for both production lines)
The product name of the first production line is in cell D2
In the first frame, all form fields highlighted in yellow contain data that can be entered into the database. All fields with a white background contain data that has already been entered.
First, a status is selected, for example “Produced” or “Maintenance”.
Only 1000 product numbers can be entered per shift and production line.
Any product number entered cannot be changed; it can only be deleted using the “Delete number” button. The password for deletion is the number 3.
The product number in the list field can be selected by double-clicking with the left mouse button; after double-clicking, the selected number is in the product number combo box.
Frame for the second production line. Shift handover protocol.
In the “Legend” worksheet allows the user to specify names for multiple areas that appear in the input form and sheet:
The name of the frame for the second production line is in cell E2
Terms for production line status (for both production lines) are in the range B2:B21
Each product is marked with a status, for example “Finished”, “Runs”. The name of the status is entered in the area C2:C21 (for both production lines)
The product name of the second production line is in cell F2
In the second frame, all form fields highlighted in yellow contain data that can be entered into the database. All fields with a white background contain data that has already been entered.
First, a status is selected, for example “Produced” or “Maintenance”.
Only 1000 product numbers can be entered per shift and production line.
Any product number entered cannot be changed; it can only be deleted using the “Delete number” button. The password for deletion is the number 3.
The product number in the list field can be selected by double-clicking with the left mouse button; after double-clicking, the selected number is in the product number combo box.
Frame for the annotation. Shift handover protocol.
In the “Legend” worksheet allows the user to specify names for multiple areas that appear in the input form and sheet:
The name of the first section of the annotation is in cell G2
The name of the second section of the annotation is in cell H2
The name of the third section of the annotation is in cell I2
The name of the fourth section of the annotation is in cell J2
Table view. Shift handover protocol.
All entered data for each selected work layer can be entered into the “Sheet” worksheet using the Table View button.