Craig Fraser worked on the Public-Health-Scotland/list-localities-profiles repository, where he refactored the HSCP LTC reporting percentage calculation to improve data accuracy and transparency. Using R and his data analysis expertise, Craig redesigned the logic to directly join LTC data with population data, enabling precise computation of reporting percentages at the HSCP level. This approach enhanced the maintainability and scalability of the reporting process, supporting future enhancements and easier updates. By aligning LTC metrics more closely with HSCP business needs, Craig’s work provided a more robust foundation for data-driven planning and decision-making within the public health reporting context.