EXCEL TO MOBILE- THE METHOD FOR AUTOMATED MIGRATION OF EXCEL-BASED MARKOV MODELS TO MODERN SOFTWARE PLATFORMS

Author(s)

Kutepov G1, Settenvini M21Fraunhofer IESE, Kaiserslautern, Germany, 2Technische Universität Kaiserslautern, Kaiserslautern, Germany

The objective is to automate the migration of complex health economics Excel models based on Markov chains to modern software platforms, such as Mobile or Web. In this research project, we have developed a software solution that is capable of transforming a Microsoft Excel model into a self-contained platform-independent programming module.  This module fully preserves the original model along with cell values, formulas and dependencies, and is capable of running the model independently from the Microsoft Excel environment. The module is used as a basis for creating web and mobile applications supporting calculations identical to that in Excel model.  These applications will give the user means to manipulate model inputs and see the results of his actions immediately without having the full model delivered, thus preserving the confidentiality of proprietary data and algorithms. By using our method, several Excel based Markov cohort models with more than 1000 cycles were transformed and used as a basis for development of web-based and iPad applications for healthcare decision making.  These applications showed performance comparable to Microsoft Excel and complete outcomes correlation with the original model. With the proposed solution, mature Excel models developed over the years in various institutions can be connected with modern information technologies in a fast and reliable way.  Our method makes automated model transformation possible without human intrusion into a stable model core.  By eliminating the dependency on Microsoft Excel, we open new ways for integration of time-proven Excel models with modern software platforms, such as the Web or Mobile.

Conference/Value in Health Info

2012-11, ISPOR Europe 2012, Berlin, Germany

Value in Health, Vol. 15, No. 7 (November 2012)

Code

PRM178

Topic

Methodological & Statistical Research

Topic Subcategory

Confounding, Selection Bias Correction, Causal Inference

Disease

Multiple Diseases

Explore Related HEOR by Topic


Your browser is out-of-date

ISPOR recommends that you update your browser for more security, speed and the best experience on ispor.org. Update my browser now

×