| klste@hotmail.de |
Work planner with weekly calculation of the hourly difference. Excel VBA.
The Excel file in the program has 2 sheets: “Mask” and “Sheet”.
In this program everything is entered via an input mask. The input mask is activated on the “Mask” worksheet using the “Mask” button.
There are three yellow buttons in the input mask.
The “Legend” button opens the Legend frame. You can enter up to 100 designations and abbreviations/codes in the “Absent due to” and “Workplace” fields. For “Department” you can enter a total of 20 designations.
The “Employee database” button opens the “Employee database” frame. In this framework you can enter 100 employees for each department. The records must not contain the number of contractually agreed hours per week. You can insert or remove an image for each employee.
The “Work planner_Weekly planner” button opens the “Work planner_Weekly planner” frame. Entries in the weekly planner are only possible if the month, date, week, department and personnel number are selected.
In the program you can record up to 10 periods in a working day for each employee. For example, an employee works 12 hours a day. In the first hour he will do one job, then he will do other work and in this way you can record up to 9 work changes per working day.
You can create entries for each calendar week from Monday to Sunday. It doesn't matter whether the week falls in the middle of the month or is divided into two months.
The hours entered minus the breaks are added up for the entire week, the contractual weekly working hours are deducted from the total amount and the difference is calculated.
For days on which the employee did not work due to vacation, illness or other reasons, an abbreviation of the reason is entered; Hours are not entered in this case.
Every incorrect entry is deleted at the push of a button.
The “Change year” button creates a calendar in the program for the selected year with moving and fixed holidays.
Frame “Legend”. Work planner with weekly calculation of the hourly difference. Excel VBA.
The “Legend” button opens the Legend frame. You can enter up to 100 designations and abbreviations/codes in the “Absent due to” and “Workplace” fields. For “Department” you can enter a total of 20 designations.
When the list box in the frame turns blue, yellow, or green, a grey button becomes visible, the label on the button indicates which table view will be created when the button is clicked.
Incorrect names are deleted using dark red buttons. If something is deleted in the program, you will first be asked for the password; the password for deleting is always the number 3. The “Disable warning” checkbox can be seen in the input mask. If a tick is placed in the checkbox, the Warning disabled.
By double-clicking the left mouse button, you can select each line in the list box and display it in input fields that have the same colour as the list box.
The width of all columns in the list box automatically adjusts to the length of the data entered.
Employee database. Work planner with weekly calculation of the hourly difference. Excel VBA.
The “Employee database” button opens the “Employee database” frame. In this framework you can enter 100 employees for each department. The records must not contain the number of contractually agreed hours per week. You can insert or remove an image for each employee.
When the list box in the frame turns green or orange, a grey button becomes visible. The label on the button indicates which table view will be created when the button is clicked.
Incorrect personnel numbers are deleted with a dark red button. If something is deleted in the program, you will first be asked for the password; the password for deleting is always the number 3. The “Disable warning” checkbox can be seen in the input mask. If a tick is placed in the checkbox, the Warning disabled.
By double-clicking the left mouse button, you can select each line in the list box and display it in input fields that have the same colour as the list box.
The width of all columns in the list box automatically adjusts to the length of the data entered.
Create a work plan. Work planner with weekly calculation of the hourly difference. Excel VBA.
The “Work planner_Weekly planner” button opens the “Work planner_Weekly planner” frame. Entries in the weekly planner are only possible if the month, date, week, department and personnel number are selected.
For days on which the employee did not work due to vacation, illness or other reasons, a reason is selected in the “Absent due to” combo box. In this case, hours are not entered; the abbreviation of the reason is entered.
If "Workplace", time from, time until and duration of the break is selected, is entered from\to\location\break, if pause was not selected, the space for break will be empty. In the planner it looks like this: Time -from\ Time -to\ abbreviation from location (workplace)\ and decimal number of break.
In the program you can record up to 10 periods in a working day for each employee. For example, an employee works 12 hours a day. In the first hour he will do one job, then he will do other work and in this way you can record up to 9 work changes per working day.
You can create entries for each calendar week from Monday to Sunday. It doesn't matter whether the week falls in the middle of the month or is divided into two months.
The hours entered minus the breaks are added up for the entire week, the contractual weekly working hours are deducted from the total amount and the difference is calculated.
Each entry can be selected via “ID no.” and “ID no. –Date”. The selection is not changed; it can only be deleted using the “ID no. –Date delete” button. The password for deletion is always the number 3. The “Disable warning” checkbox can be seen in the input mask. If the checkbox is ticked, the warning will be deactivated.
There are four terms to choose from in the “Evaluation” combo box: “Selected weekly schedule with hours”, “Selected weekly schedule without hours”, “Selected employee / selected weekly schedule”, “Selected employee / hours per year” and “Selected Employee / Selected "Absent due to" in the year". When something is selected, a gray “Sheet” button will appear. The button displays the selected item in the spreadsheet.
By double-clicking the left mouse button, you can select each line in the list box and display it in input fields that have the same color as the list box. If color is white, ID no. is selected.
Change year. Work planner with weekly calculation of the hourly difference. Excel VBA.
Before the year or after the year you should delete the database with all calendar week hours using the “Delete hours in the year” button and also delete the database with weekly plans using the “Delete all weekly plans” button. The password for deletion is the number 3.
With the button "Change year" in the program a calendar for selected
Create a year with floating and fixed holidays. The user determines the number and names of the fixed holidays. A maximum of 15 fixed public holidays can be assigned. The program has a list of 16 moveable holidays. Tick the checkbox of public holidays.
Click on the "Enter" button, enter a four-digit year in the input field and click on "OK". The calendar is created.
The public holidays have a red background color in the calendar.
Regional format. Work planner with weekly calculation of the hourly difference. Excel VBA.
If the regional format is changed, a message appears when activating the input mask: "The language settings have changed, the names of the months and days of the week are now different from what was probably entered. In order for the program to work without failures, the year must be changed again”.
After the turn of the year, the calendar adapts to the format of the region and the message no longer appears.