Maximisation of open hospital capacity under shortage of SARS-CoV-2 vaccines

supplement-1 (macro.vba) and supplement-2 (macro.xlsm) of the study

Bosbach WA, Heinrich M, Kolisch R, Heiss C. Maximisation of open hospital capacity under shortage of SARS-CoV-2 vaccines - an open access, stochastic simulation tool. Vaccines. 2021.9(6).546 doi.org/10.3390/vaccines9060546

#####################################################################

READ.ME

#project: Maximization of Open Hospital Capacity under Shortage of SARS-CoV-2 Vaccines

This is the readme file for the VBA implemenation of the study:
Bosbach WA, Heinrich M, Kolisch R, Heiss C. Maximization of Open Hospital Capacity under Shortage of SARS-CoV-2 Vaccines.Vaccines.2021,9(6),546. 
    
The study and the VBA implementation are available open access:
    - zenodo VBA model implementation (macro.vba, and macro.xlsm) doi.org/10.5281/zenodo.4589332, published 08 March 2021
    - medrxiv preprint doi.org/10.1101/2021.03.08.21253150, published 12 March 2021
    - MDPI-vaccines manuscript, peer reviewed, doi.org/10.3390/vaccines9060546, published 22 May 2021

#licence

     '++++++++++++++++++++++++++++++++++++++++++++
        'copyrights and license

        'Copyright 2021 Wolfram A Bosbach, PhD
        
            'This program is free software: you can redistribute it and/or modify
            'it under the terms of the GNU General Public License as published by
            'the Free Software Foundation, either version 3 of the License, or
            'any later version.

            'This program is distributed in the hope that it will be useful,
            'but WITHOUT ANY WARRANTY; without even the implied warranty of
            'MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
            'GNU General Public License for more details.

            'You should have received a copy of the GNU General Public License
            'along with this program.  If not, see <https://www.gnu.org/licenses/>.

        '++++++++++++++++++++++++++++++++++++++++++++

#no installation requied, Microsoft-Excel environment

For running the VBA code, no seperate installation is required.
In its published form, it is embedded in Microsoft-Excel which is part of the Microsoft-Office software package.

"Microsoft-Office Professional Plus 2013" was used during this project.

#macro components

The macro code executes the model as described in the MDPI-Vaccines manuscript.

1. Initial Staff Configuration at t=0
The initial staff is defined as macro input in sheet "01 staff matrix", columns [A-C], line 42 and following
Entries of the staff status string are explained in macro line 38-49:
         'Staff_Status(0)  :  days since infected
         'Staff_Status(1)  :  symptomatic
         'Staff_Status(2)  :  positive in tests
         'Staff_Status(3)  :  infectious for environment
         'Staff_Status(4)  :  number vaccinations
         'Staff_Status(5)  :  assigned unit
         'Staff_Status(6)  :  staff count on unit
         'Staff_Status(7)  :  staff age
         'Staff_Status(8)  :
         'Staff_Status(9)  :
         'Staff_Status(10) :
         '..

2. Implemenated model steps

    2.1 Initiation of VBA variables, line 32-79
    Including the building of the staff status string, line 39-49
    
    2.2 Definition of values for model parameter variation, line 82-148
    
    2.3 Building of model iterator which serves as saving path, line 165-214, save as @ line 1567
    
    2.4 Setting of start and stop values of parameter iteration window and initiation of iteration loop, line 217-273, loop @ line 1581
    
    2.5 Initiation of loop around hospital 100d model (statistical iterations n=500), line 281-283, loop @ line 1383

    2.6 module-1: definition of staff age at t=1, line 288-335
    
    2.7 Initiation of daily staff loop for t=100d, line 342-378, loop @ line 1379
    
    2.8 module-2: assigning of vaccines doses, line 382-508
        by 
        - hierarchy top down rollout, line 434
        - pathogen exposure rollout, line 446
    
    2.9 module-3: calculation of staff's diesease status, line 514-697
        on 
        - A&E, line 591
        - non-A&E, line 620
    
    2.10 module-4: assignment of staff to hospital units, line 703-934
        - chief, line 753
        - executive seniors, line 761
        - seniors, line 794
        - physicians, line 827
        - nurses, line 860
    
    2.11 updating of staff counters, line 942-1268
    2.12 updating of unit status and of open hospital capacity, line 1272-1375
    
    2.13 building averages per run n, line 1384-1554

# future contributions and contact

Feel free to use the code and expand the model.

Email address Wolfram Bosbach: wbosbach@mytum.de