How to Build a Partitioned Survival Model in Excel

Learn step-by-step how to build a Partitioned Survival Model (PSM) in Excel to evaluate oncology treatments, model survival curves, and plot state occupancy in an HTA-ready Cost-Effectiveness Model (CEM). 📊🎗️📉
Want to learn how to build a Markov model in Excel? Watch this 👉    • How to Build a Markov Model in Excel to Co...  
----------------------------------------
CONNECT WITH ME 📲
Twitter: https://x.com/vonHeinMirko
LinkedIn:   / mirko-von-hein-b9885110b  
Instagram:   / mirkovonhein  
Facebook: https://www.facebook.com/profile.php?...
Website: https://mirkovonhein.com/
----------------------------------------
PHARMA GLOSSARY 🔍
A free tool to decode industry terms, abbreviations, and acronyms in pharma. Explore it here:
https://mirkovonhein.com/pharma-gloss...
----------------------------------------
TIMECODES ⏰
0:00 Intro
0:26 Example Dataset: Hypothetical OS and PFS for a New Oncology Treatment
2:00 How to Generate Survival Parameters in R / RStudio
2:45 Model Engine Setup for our PSM
3:43 Adding Half-Cycle Correction in a PSM
5:39 How to Account for Baseline Patient Age in a PSM
6:12 Background Mortality Correction (BGM) / Life Table Setup
8:41 Discounting Costs and Benefits in an Economic Model
9:31 Modelling a Dynamic Time Horizon in Excel
11:02 Pull in Kaplan-Meier (KM) Data and Match it to Cycles
12:13 Parametric Survival Function in Excel: A Quick Guide
14:55 How to Calculate Parametric Hazard / Discrete Hazard
15:30 PFS “In Use” Column: Applying BGM Correction to Survival Data
16:53 Repeating the Process for Overall Survival (OS)
17:13 How to Derive Health State Occupancy in a Partitioned Survival Model (PSM)
18:09 Further Considerations on the Model Engine
18:52 Assigning Payoffs: Costs & Health State Utilities
19:14 Setting Up the Results Sheet
19:18 Plotting Health State Occupancy
20:46 How to Calculate Life Years (LY), Quality-Adjusted Life Years (QALY) and Costs in a PSM
21:47 Model Limitations
22:43 Summary
23:09 Join the Community
----------------------------------------
SUBSCRIBE TO MY CHANNEL 🔔
   / @mirkovonhein  
----------------------------------------
REFERENCES 📚
ONS Life Tables:
https://www.ons.gov.uk/peoplepopulati...
Force of Mortality:
https://en.wikipedia.org/wiki/Force_o....
----------------------------------------
TEMPLATES 🗂️
Download the Partitioned Survival Model (PSM) and all files I used for this Tutorial:
https://github.com/MvonHein/Partition...
----------------------------------------
RELATED VIDEO 📺
Learn how to calculate survival extrapolation parameters in R / RStudio, the essential inputs used in this tutorial 👉 &list=UULFCWndUzziarMjA4pDG1ps2A
----------------------------------------
HASHTAGS 🏷️
#PartitionedSurvivalModel #HealthEconomics #CostEffectiveness