Building a Radionuclide Metrology Algorithm Comparison Platform (NuCodeComP): Insights from Rapid Integration with Microsoft PowerApps

An essential step in radionuclide activity measurement comparisons is the counting signal processing performed by laboratory-specific software. This has led to initiatives comparing software performance using a unique dataset from a list-mode data structure, as defined in IEC 63047:2021. A virtual Radionuclide Metrology Algorithm Comparison Platform was developed at BIPM to ensure a FAIR approach and facilitate broader laboratory participation. Beyond presenting the final product, this work highlights key insights from its development. The platform was designed to be reliable, adaptable, and future-proof, aligning with the D-SI framework to ensure machine-readable, structured, and interoperable data. A strategic decision was made to investigate Microsoft 365, leveraging its infrastructure to real-test software operations before investing in scalability. However, scalability limitations arise, requiring Azure solutions like SQL Server for big data applications. The drag-and-drop interface simplifies the platform’s development in interface design while utilizing SharePoint tables for data structuring and access control. However, performance constraints exist, particularly with SharePoint’s row-number limitation. Furthermore, non-M365 users face access barriers mitigated through basic M365 plans or per-app licensing. This case study serves as a model for digital metrology projects, balancing cost-effective IT solutions with scalability and accessibility challenges while ensuring alignment with SI Digital transformation.