The clinical research laboratory I currently work in is serving as an intermediary in the AstraZeneca/Oxford COVID-19 vaccine trial. To solve a logistical and personnel pinch point, I developed an internal application in VBA to facilitate organizing shipments of potentially hundreds of samples per week. This tool has resulted in a reduction of shipment preparation and quality control time from 2 people taking 1-2 hours down to 1 person taking 15 -20 minutes. I reproduced the application in HTML and JavaScript to share with others.
A full blog post on the project can be found HERE