Scheduling attendance method based on VBA and C #

A shift scheduling and shift schedule technology, applied in the field of shift scheduling and attendance based on VBA and C#, can solve the problems of difficult effective management, heavy workload, easy omission, etc., and achieve the goal of increasing legibility, easy handling, and improving flexibility Effect

Pending Publication Date: 2020-11-03
WEST CHINA HOSPITAL SICHUAN UNIV
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Huge workload, easy to miss, difficult to manage effectively

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Scheduling attendance method based on VBA and C #
  • Scheduling attendance method based on VBA and C #
  • Scheduling attendance method based on VBA and C #

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0053] A method for scheduling attendance based on VBA and C#, comprising the following steps:

[0054] Step s1:

[0055]The generation of the original schedule is completed through the schedule generation system, which is an Excel table containing the VBA automatic operation program.

[0056] The system for generating a shift schedule includes: a personnel list worksheet, which is used to list the position information, rotation, vacation and leave information of all members participating in the shift schedule, and generates the respective post labels of all members; the turn status worksheet, which is used to Generate a list that can count the personnel arranged for each position; initialize the setting worksheet, which is used to set the necessary parameter set...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a scheduling attendance method based on VBA and C #, and the method comprises the following steps: s1, completing the generation of an original scheduling table through a scheduling table generation system, wherein the scheduling table generation system is an Excel table comprising a VBA automatic operation program; s2, completing mapping from an original scheduling table in an Excel format to a scheduling table in a Word format and statistics of workloads through a scheduling table processing system, and completing construction based on Visual C # by the scheduling table processing system; and s3, by loading the scheduling table and the clock-in information table, enabling the attendance management system to complete management of attendance personnel, management of attendance data and statistics of late and missing card information, wherein the clock-in information table is collected and generated by the clock-in device. All the steps are clear, compared withmanual scheduling, manpower is saved, and the problems of repeated scheduling and missing scheduling in manual scheduling can be solved.

Description

technical field [0001] The present invention relates to a method for checking attendance on shifts, in particular to a method for checking attendance on shifts based on VBA and C#. Background technique [0002] With the continuous maturity and development of new technologies such as contrast-enhanced ultrasound and interventional surgery, and the advantages of low-cost and non-invasive conventional ultrasound, ultrasound examination has become one of the indispensable items in people's admission examination and physical examination. At the same time, the number of personnel in the Ultrasound Department continues to increase, which makes the scheduling and attendance work of the Ultrasound Medicine Department increasingly complex and arduous. Scheduling and attendance are important links in department management and reform. Effective and reasonable scheduling and attendance are related to improving the overall performance of the department, the department's performance manage...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q10/06G06Q10/10
CPCG06Q10/06311G06Q10/1091
Inventor 罗燕张勇鲁晓邱逦陈杨凌文武
Owner WEST CHINA HOSPITAL SICHUAN UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products