Search for a command to run...
<h3>Background and Importance</h3> Environmental microbiological surveillance (EMS) is a key component in ensuring the quality and safety of sterile injectable preparations. The identification of critical contamination points relies on risk assessment and continuous monitoring. <h3>Aim and Objectives</h3> The objective is to develop a tool for monitoring EMS trends, enabling dynamic visualisation of results. This dashboard allows tracking of contamination points and aims to support the adaptation of the sampling plan according to observed trends. <h3>Material and Methods</h3> Environmental monitoring data from grade A and grade C areas were collected between 17/07/2024 and 31/07/2025. Data were analysed using Visual Basic for Applications (VBA) macros and PivotTables in Excel . The developed automations include: Display of daily positivity rates (PR) in grade A Generation of an alert when a sampling point remains positive for three consecutive days in grade A Identification of the three most recent positive sampling points in grade A. Definition of vigilance (11–25 CFU) and alert (>25 CFU) thresholds for grade C samples. These elements are integrated into an interactive dashboard for real-time visualisation and simplified interpretation. <h3>Results</h3> The dashboard provides a 30-day visualisation of sampling trends and includes : Six boxes summarising overall PR. Six dynamic arrow gauges comparing weekly PR (Week N versus Week N–1) : green for improvement, orange for stability, red for deterioration. An ellipse highlighting points positive for three consecutive days. A colour–coded rectangle displaying vigilance (orange), alert (red), and acceptable (green) thresholds A frame listing the three most recent positive samples. <h3>Conclusion and Relevance</h3> A trend analysis tool is essential for monitoring and improving SME. It is suitable for use in hospital, easy to adapt, and transferrable to various pharmaceutical technology. Its implementation in radiopharmacy will help optimise the sampling plan and enhance staff awareness. <h3>References and/or Acknowledgements</h3> 1. Good Preparation Practices 2023. <h3>Conflict of Interest</h3> No conflict of interest