Nurse automatic scheduling method and system based on VBA

An automatic technology for nurses, applied in the field of automatic scheduling methods and systems for nurses based on VBA, which can solve the problems of time-consuming scheduling and inability to guarantee quality, and achieve balance, easy expansion and maintenance, and high modularity. Effect

Active Publication Date: 2021-02-05
SHANDONG NORMAL UNIV
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the number of nurses is large, scheduling is time-consuming and the quality cannot be guaranteed

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
  • Nurse automatic scheduling method and system based on VBA
  • Nurse automatic scheduling method and system based on VBA
  • Nurse automatic scheduling method and system based on VBA

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] Such as figure 1 As shown, Embodiment 1 of the present disclosure provides a method for automatically scheduling nurses based on VBA, including the following steps:

[0056] Get shift demand and nurse staffing data for at least one day;

[0057] According to the obtained shift demand and nurse data, the initial shift result is obtained by random allocation;

[0058] According to the preset scheduling constraints, the initial scheduling results and the scheduling optimization algorithm combining variable neighborhood and local search, the optimal scheduling results are obtained;

[0059] Among them, a two-dimensional array is used in VBA to store the shift schedule, and different characters in the array represent different shifts. The two-dimensional array of the schedule is traversed through the VBA code, and the characters are converted into the name of the shift and filled back into the schedule interface.

[0060] In detail, first construct the scheduling system, the...

Embodiment 2

[0112] Embodiment 2 of the present disclosure provides a nurses automatic scheduling system based on VBA, including:

[0113] A data acquisition module configured to: acquire at least one day's shift demand and nurse staff data;

[0114] The initial scheduling module is configured to: obtain the initial scheduling results by random allocation according to the obtained shift requirements and nurse staff data;

[0115] The optimal scheduling module is configured to: obtain the optimal scheduling result according to the preset scheduling constraints, the initial scheduling results, and the scheduling optimization algorithm combining variable neighborhood and local search;

[0116] Among them, a two-dimensional array is used in VBA to store the shift schedule, and different characters in the array represent different shifts. The two-dimensional array of the schedule is traversed through the VBA code, and the characters are converted into the name of the shift and filled back into ...

Embodiment 3

[0119] Embodiment 3 of the present disclosure provides an electronic device, including the VBA-based automatic shift scheduling system for nurses described in Embodiment 2 of the present disclosure.

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 provides a nurse automatic scheduling method and system based on VBA. The method comprises the following steps: acquiring shift requirements and nurse personnel data of at least one day;obtaining an initial scheduling result by adopting a random allocation mode according to the obtained shift requirements and nurse personnel data; and obtaining an optimal scheduling result accordingto a preset scheduling constraint, the initial scheduling result and a scheduling optimization algorithm combining variable neighborhood and local search, using a two-dimensional array in the VBA tostore the scheduling table, different characters of the array representing different shifts, and the two-dimensional array of the scheduling table being traversed through the VBA code to convert the characters into names of the shifts and fill the names of the shifts back to the scheduling interface; according to the invention, the deployment complexity and cost of the information system can be reduced to the greatest extent, the realization modularization of the system is relatively high, the expansion and maintenance are convenient, and the system does not need the support of any other third-party plug-in.

Description

technical field [0001] The disclosure relates to the technical field of nurse scheduling automation, in particular to a VBA-based automatic nurse scheduling method and system. Background technique [0002] The statements in this section merely provide background information related to the present disclosure and may not necessarily constitute prior art. [0003] The nurse scheduling problem in the hospital is a kind of complicated personnel allocation problem. Although many efficient algorithms have been proposed in recent years, it is still a complex and arduous task to integrate these algorithms into the existing hospital information system or design and develop an independent scheduling software system. [0004] The inventors of the present disclosure found that the design and development of the scheduling system not only needs to implement complex scheduling algorithms, call solvers, and design interactive interfaces, but also requires continuous maintenance and expansio...

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): G16H40/20G06F8/30
CPCG16H40/20G06F8/315Y02P90/30
Inventor 郑自然
Owner SHANDONG NORMAL 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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap