2026-06-05T15:14:20Zhttps://riuma.uma.es/rest/oai/request

oai:riuma.uma.es:10630/372282026-02-03T11:06:01Zcom_10630_2254col_10630_37953

00925njm 22002777a 4500 dc Xin, Yiqiao author Robles‑Zurita, José Antonio author Haghpanahan, Houra author Heggie, Robert author Kohli‑Lynch, Ciaran author Briggs, Andrew author McAllister, David A. author Lawson, Kenny D. author Lewsey, Jim author Gray, Ewan author 2021 Given the advantages in transparency, reproducibility, adaptability and computational efficiency in R, there is a growing interest in converting existing spreadsheet-based models into an R script for model re-use and upskilling training among health economic modellers. The objective of this exercise was to convert the Scottish Cardiovascular Disease (CVD) Policy Model from Excel to R and discuss the lessons learnt throughout this process. The CVD model is a competing risk state transition cohort model. Four health economists, with varied experience of R, attempted to replicate an identical model structure in R based on the model in Excel and reproduce the intermediate and final results. Replications varied in their use of specialist health economics packages in addition to standard data management packages. Two versions of the CVD model were created in R along with a Shiny app. Version 1 was developed without health economics specialist packages and produced identical results to the Excel version. Version 2 used the heemod package and did not achieve the same results, possibly due to the non-standard elements of the model and limited time to adapt the functions. The R model requires less than half the computational time than the Excel model. Conversion of the spreadsheet models to script models is feasible for health economists. A step-by-step guide for the conversion process is provided and modellers’ experience is discussed. Coding without specialist packages allows full flexibility, while specialist packages may add convenience if the model structure is suitable. Whichever approach is taken, transparency and replicability remain the key criteria in model programming. Model conversions must maintain standards in these areas regardless of the choice of software. Xin, Y., Gray, E., Robles-Zurita, J. A., Haghpanahan, H., Heggie, R., Kohli-Lynch, C., Briggs, A., McAllister, D. A., Lawson, K. D. and Lewsey, J. (2022) From spreadsheets to script: experiences from converting a Scottish cardiovascular disease policy model into R. Applied Health Economics and Health Policy, 20(2), pp. 149-158. (doi: 10.1007/s40258-021-00684-y) https://hdl.handle.net/10630/37228 10.1007/s40258-021-00684-y Sistema cardiovascular - Enfermedades - Aspectos económicos From Spreadsheets to Script: Experiences From Converting a Scottish Cardiovascular Disease Policy Model into R