A thinktank for unconventional innovation!
“Identifying problems, finding solutions, revolutionize everday life!”
University Hospital Vienna
In the course of the SARS-CoV2 pandemic, I was drafted as a civil servant for the purpose of social service. So I came to the University Hospital / Vienna General Hospital, whose authorities provided me with a place of work and accordingly have always accompanied me as mentors. This is how I became interested in medical product development!
I am currently in the situation of developing a new kind of database for the statistical evaluation of Covid 19 for hospital hygiene, in correspondence with the internal Contact Tracing Team. Because of the fact that this complex has more than 10,000 employees and is accordingly as big as a small town, transparent documentation and evaluation of corona data sets became inevitable. But the big problem was rather that this pandemic surprised us and accordingly we had to act out of necessity. So you can hardly believe that we only created a fully functional database from a reprogrammed Excel file.
SARS-CoV2 Internal Database
The goal of this database is to log and statistically evaluate all Covid 19 index cases and K1 indications (contact persons) in order to be able to effectively help research and pandemic control. In this case it concerns Excel macro functions, a so-called programming with VBA coding. Visual Basic for Applications (VBA) is a scripting language that was originally developed for controlling processes in the Microsoft Office program family. It was derived from the BASIC dialect Visual Basic (VB) developed by Microsoft. VBA is regarded as a powerful scripting language and is the most common way of creating programs based on Microsoft Office applications (Excel, Word, Access, etc.). VBA is an interpreted programming language, the syntax of which corresponds to that of Visual Basic (both Visual Basic Classic and Visual Basic .NET).
Of course, the exact structure cannot be explained, as this information is subject to medical and government confidentiality. But that much can be said, this is a three-phase program. First and foremost is the user interface with the necessary user friendliness essential. One can literally speak of the job “idiot-proof”. Then comes the core process, which includes documentation and statistical processing. This is rounded off by the automatic creation of perfectly shaped database extracts including the corresponding separation (quarantine) notices.
Accordingly, this is not the only task. I originally started to work in the central sterilization department, where the primary focus was on medical processing and the provision of instruments. The division manager / head nurse then brought me to the contact tracing team, as my degree in product development and therefore my way of acting & thinking meant that I was suitable for developing a database. My job at the moment is to plan, coordinate and implement the statistical evaluations of SARS-CoV2 on an epidemiological basis. These statistics are passed on to the general management of this health facility in order to be able to make possible tactical decisions to combat pandemics.
In this picture you can see me working in the central sterilization laboratory, where we coordinated the mask reprocessing during the first lockdown in spring with the help of a continuous improvement process.
If you are in the service of the Vienna Health Association or similar and have any questions, please do not hesitate to contact me:
Universitätsklinikum AKH Wien
SARS-CoV2 Interne Datenbank & Statistik
Tätig für die Pflegedirektion, AKH Wien
Student für Produktentwicklung MxD, BSc
Privatuniversität NDU, 2020
Tel.: +43 699 17178044 [Mobil]
Tel.: +43 40400 18617 [AKH-Wien]