Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

VBA-based hospital outpatient pharmacy scheduling method

A technology for outpatient clinics and pharmacies, applied in the field of data statistics, can solve the problems of information leakage, the setting of different shifts, the setting of special shifts and special shift personnel, etc., to achieve low learning difficulty, improve production efficiency, and reduce the risk of information leakage Effect

Pending Publication Date: 2022-01-28
河源市深河人民医院(暨南大学附属第五医院)
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

And the information of the pharmacy staff is connected to the third-party cloud, so there is a risk of information leakage
[0009] Another kind of nursing scheduling [3] is aimed at the nursing post scheduling of each clinical department in the whole hospital. It can be arranged according to different shift times for management posts and clinical posts. However, it does not provide settings for different daily shifts, special shifts and special shift personnel.

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
  • VBA-based hospital outpatient pharmacy scheduling method
  • VBA-based hospital outpatient pharmacy scheduling method
  • VBA-based hospital outpatient pharmacy scheduling method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0099] In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained according to these drawings without creative efforts.

[0100] like figure 1 The present invention provides a VBA-based hospital outpatient pharmacy scheduling method, comprising:

[0101] S1. Combine the three elements of personnel, shifts, and time in the hospital outpatient pharmacy to construct scheduling constraints;

[0102] S2. Based on the scheduling constraints, a preset shift schedule view is set in the Excel sheet, and constructed according to the shift schedule view: "Next Week's Shift Schedule" representin...

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 VBA-based hospital outpatient pharmacy scheduling method, which adopts a greedy algorithm and a backtracking algorithm to obtain an approximate solution of scheduling, accurately realizes full-class and full-period scheduling of all staff of hospital outpatient pharmacy, reduces repeated work of simple work, reduces and checks low-level errors such as missed scheduling, multiple scheduling and wrong scheduling, improves the scheduling efficiency, and enhances the accuracy; meanwhile, a scheduling table checking function is provided, a full scheduling table is checked, and missed scheduling, excessive scheduling and wrong scheduling caused by manual adjustment of the scheduling table are avoided; the preset constraint conditions conform to the hospital outpatient pharmacy scheduling rule, the method can be popularized to the pharmacy in a similar scheduling mode, and the constraint conditions for the work shift and the rest shift can promote the enthusiasm of the pharmacy scheduling personnel in the actual work, relieve the work fatigue and ensure sufficient rest.

Description

technical field [0001] The invention relates to the technical field of data statistics, in particular to a VBA-based method for scheduling a hospital outpatient pharmacy. Background technique [0002] Shift scheduling is an important part of the management of pharmacies and the pharmacy department. Reasonable scheduling is conducive to the steady and orderly development and daily work, which is conducive to promoting the enthusiasm of pharmacy staff, and is conducive to maintaining the fairness of pharmacy staff's workload acquisition. [0003] With the continuous deepening of the transformation of automated pharmacies in hospitals, the changes in prescription review, dispensing, and dispensing modes brought about by automated equipment represented by the pre-examination system and automatic dispensing machines are driven by the prevention and control of the new coronavirus pneumonia. The change of positions and shifts in the pharmacy of fever clinics, and the addition of co...

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/20G06Q10/06
CPCG16H40/20G06Q10/06311G06Q10/06316
Inventor 鲁雨心
Owner 河源市深河人民医院(暨南大学附属第五医院)
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com