{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["MOSAIC","Overview","Inputs & Results","1. Strategy Calcs","2. Strategy Calcs","State Trans Diag","Public Hospital Costs","Dexamethasone Cost","Inpatient Deaths & Utilisation","TP Internal Formulas"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MOSAIC","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,10],[18,1,18,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MOSAIC is a health economic modelling collective established to provide rapid policy guidance and public engagement for the South African Covid-19 response. Members are drawn from the Health Economics Unit, School of Public Health and Family Medicine and Alan J Flisher Centre for Public Mental Health at the University of Cape Town, with the Health Systems Research Unit at the Medical Research Council. In alphabetical order, MOSAIC includes Donela Besada MPH; Susan Cleary PhD; Emmanuelle Daviaud MSc; Sumaiyah Docrat MPH; Darshini Govindasamy PhD; Geetesh Solanki DrPH; Cynthia Tamandjou PhD; and Tommy Wilkinson MSc"]
[null,"Reference for this model:"]
[null,"MOSAIC, 2020 \"A model to assess the cost-effectiveness of dexamethasone for admitted Covid-19 patients in South Africa\" Health Economics Unit, Alan J Flisher Centre for Public Mental Health (UCT) and Health Systems Research Unit (SAMRC), Cape Town."]

{"sheet":"Overview","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"OVERVIEW"]
[null,"1. This excel based cost-effectiveness model is provided to allow for full transparency to the end user"]
[null,"2. Sensitivity analysis can be done by changing the relevant variable(s) or input(s) in \"Inputs & Results\""]
[null,"3. The remaining worksheets in this model provide model workings and background information"]
[null,"4. The function of each worksheet is described below"]
[]
[null,"Worksheet name","Function","Colour-coding"]
[null,"Inputs & Results","Provides model results and an interface for  user driven sensitivity analysis","Green"]
[null,"1. Strategy Calcs","Formulae for status quo model","Red"]
[null,"2. Strategy Calcs","Formulae for dexamethasone model","Red"]
[null,"State Trans Diag","Diagrams of model structure","Red"]
[null,"Public Hospital Costs","Summarizes public hospital unit cots","Blue"]
[null,"Dexamethasone Cost","Summarizes essential medicine list pricing and contracts for dexamethasone","Blue"]
[null,"Inpatient Deaths & Utlisation","Summarizes meta-analysis of inpatient inputs","Blue"]

{"sheet":"Inputs & Results","index":2,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"INSTRUCTIONS"]
[null,"1. Cost-effectiveness results are summarized in 'MODEL RESULTS'"]
[null,"2. Using the 'INPUTS' table, conduct sensitivity analysis and generate new cost-effectiveness results by changing the green highlighted \"Editable Value(s)\" in column C"]
[null,"3. As you change inputs, see whether and how these changes impact on 'MODEL RESULTS'"]
[null,"4. Potential ranges for sensitivity are provided in columns F and G"]
[null,"5. Methods and data sources for 'INPUTS' are summarized in columns H and I"]
[]
[null,"MODEL STRATEGIES"]
[null,"This model assesses costs and outcomes for admitted severe and critical Covid-19 patients from time of admission to discharge or death"]
[null,"Two competing strategies are modelled:"]
[null,"1. The \"status quo\" summarizes costs and outcomes for patients assuming usual care (no dexamethasone)"]
[null,"2. The \"dexamethasone\" comparator summarizes costs and outcomes for patients assuming usual care with dexamethasone at 6mg/day over 10 days"]
[]
[null,"MODEL OUTCOMES"]
[null,"Cost: mean cost (general ward and ICU) per admitted patient from the health care provider's perspective"]
[null,"Health outcomes: mean DALYs and deaths per admitted patient "]
[null,"Other: mean ICU days and inpatient days per admitted patient"]
[]
[null,"MODEL RESULTS"]
[null,"Strategy","Cost","DALYs","Deaths","ICU Days","Inpatient Days","Incr. Cost per DALY Averted","Incr. Cost per Death Averted"]
[null,"Status quo",{"$f":"'1. Strategy Calcs'!I11","v":93868.421625000003},{"$f":"'1. Strategy Calcs'!K11","v":1.1025470500000001},{"$f":"'1. Strategy Calcs'!M11","v":0.20030000000000001},{"$f":"'1. Strategy Calcs'!O11","v":1.8480000000000001},{"$f":"'1. Strategy Calcs'!Q11","v":16.997500000000002}]
[null,"Dexamethasone",{"$f":"'2. Strategy Calcs'!I11","v":94029.271625000008},{"$f":"'2. Strategy Calcs'!K11","v":0.7966878730000001},{"$f":"'2. Strategy Calcs'!M11","v":0.14323000000000002},{"$f":"'2. Strategy Calcs'!O11","v":1.8480000000000001},{"$f":"'2. Strategy Calcs'!Q11","v":16.997500000000002},{"$f":"(C22-C21)/(D21-D22)","v":525.89561502679987},{"$f":"(C22-C21)/(E21-E22)","v":2818.4685473980353}]
[]
[null,"INPUTS","Edit green cells"]
[null,"Description","Editable Value","Reference in TreeAge","Original Value","Low Value","High Value","Method or assumption","Reference or source"]
[null,"Unit costs"]
[null,"Cost per inpatient day public",3727.35,"cIPDpub",{"$f":"'Public Hospital Costs'!L8","v":3727.3526936619046},null,null,"Average weighted expenditure per patient day equivalent","See 'Public Hospital Costs' worksheet"]
[null,"Cost per ICU day public",16511.25,"cICUpub",{"$f":"'Public Hospital Costs'!L9","v":16511.252377356617},{"$f":"E28-0.5*E28","v":8255.6261886783086},{"$f":"E28*1.5","v":24766.878566034924},"Average weighted expenditure per patient day equivalent inflated using ICU/IPD price differential in private sector","See 'Public Hospital Costs' worksheet"]
[null,"Cost per course of dexamethasone",160.85,"cDex",{"$f":"'Dexamethasone Cost'!I8","v":160.8484153188694},null,null,"6mg/day over 10 days = 20 x 4mg vials @ weighted EML price of R6.29 per vial plus R35.00 dispensing fee","See 'Dexamethasone Cost' worksheet"]
[null,"Utilisation "]
[null,"Utilisation of inpatient days",21.25,"uIPD",{"$f":"'Inpatient Deaths & Utilisation'!D62","v":21.25},{"$f":"'Inpatient Deaths & Utilisation'!E62","v":7.25},{"$f":"'Inpatient Deaths & Utilisation'!F62","v":43},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Utilisation of ICU days",8.8000000000000007,"uICU",{"$f":"'Inpatient Deaths & Utilisation'!D55","v":8.8000000000000007},{"$f":"'Inpatient Deaths & Utilisation'!E55","v":4.3},{"$f":"'Inpatient Deaths & Utilisation'!F55","v":13.3},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Utilisation of general ward days for those using ICU",1,"uIPDICU",{"$f":"'Inpatient Deaths & Utilisation'!D66","v":1},{"$f":"'Inpatient Deaths & Utilisation'!E66","v":0},{"$f":"'Inpatient Deaths & Utilisation'!F66","v":3},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Proportion needing ICU",0.21,"pICU",{"$f":"'Inpatient Deaths & Utilisation'!F43","v":0.20737566549798728},{"$f":"'Inpatient Deaths & Utilisation'!F44","v":5.0045495905368519E-2},{"$f":"'Inpatient Deaths & Utilisation'!F45","v":0.5},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Mortality rates"]
[null,"Proportion dying from general ward",0.11,"pdead",{"$f":"'Inpatient Deaths & Utilisation'!G27","v":0.11169298663369899},{"$f":"'Inpatient Deaths & Utilisation'!G28","v":0},{"$f":"'Inpatient Deaths & Utilisation'!G29","v":0.13095238095238096},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Proportion dying from ICU",0.54,"pdeadICU",{"$f":"'Inpatient Deaths & Utilisation'!H15","v":0.53534369995969555},{"$f":"'Inpatient Deaths & Utilisation'!H16","v":0.24},{"$f":"'Inpatient Deaths & Utilisation'!H17","v":0.875},"Literature review","See 'Inpatient Deaths & Utilisation' worksheet"]
[null,"Rate ratio reduction in deaths for those in ICU and ventilated, with dexamethasone",0.65,"rrdexICU",0.65,0.48,0.88,"Secondary data from randomized control trial","https://www.recoverytrial.net/files/recovery_dexamethasone_statement_160620_v2final.pdf"]
[null,"Rate ratio reduction in deaths for those in general wards on oxygen, with dexamethasone",0.8,"rrdexgen",0.8,0.67,0.96,"Secondary data from randomized control trial","https://www.recoverytrial.net/files/recovery_dexamethasone_statement_160620_v2final.pdf"]
[null,"Disability weights, duration of disability and years of life lost"]
[null,"Disability weight for severe patients",0.13,"DWsevere",0.13,0.09,0.19,"Disability weight for severe lower respiratory tract infeciton","Saloman et al 2017"]
[null,"Disability weight for critical patients",0.41,"DWcritical",0.40799999999999997,0.27300000000000002,0.55600000000000005,"Disability weight for ARDS","Saloman et al 2017"]
[null,"Duration of illness in severe patients",0.13,"dursevere",{"$f":"1.5/12","v":0.125},{"$f":"0.75/12","v":6.25E-2},{"$f":"2.25/12","v":0.1875},"1.5 months (range 0.75-2.25); used in DALY calculation","Assumption"]
[null,"Duration of illness in critical patients",0.17,"durcritical",{"$f":"2/12","v":0.16666666666666666},{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"3/12","v":0.25},"2 months (range 1-3); only used in DALY calculation","Assumption"]
[null,"Duration of illness prior to death",0.04,"durdeath",{"$f":"0.5/12","v":4.1666666666666664E-2},{"$f":"0.25/12","v":2.0833333333333332E-2},{"$f":"0.75/12","v":6.25E-2},"0.5 months (range 0.25-0.75); used in DALY calculation","Assumption"]
[null,"Years of life lost if dying from Covid",5.4,"YLL",5.4,null,null,null,"PANDA, 2020"]
[null,"Other"]
[null,"Cost-effectiveness threshold per DALY averted",null,null,38465.46,null,null,"Used to assess value for money; if ICER<CET intervention potentially cost-effective","Edoka et al, 2020"]

{"sheet":"1. Strategy Calcs","index":3,"n_rows":11,"n_cols":41,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,0,6],[3,3,3,5],[4,1,5,1],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,7,4,8],[4,15,4,16],[4,18,5,18],[2,20,2,28],[2,29,2,38],[3,20,3,22],[3,24,3,26],[3,29,3,31],[3,33,3,35]]}
[null,"Strategy",1,"Status quo"]
[null,"States","All"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Severe patients general ward - State 1.1",null,null,null,null,null,null,null,null,"Critical patients ICU - State 1.2",null,null,null,null,null,null,null,null,null,"Recover - State 1.3","Die - State 1.4"]
[null,null,null,"Cohort State Proportions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cohort %",null,null,"Payoff 1 - Provider costs (ZAR)","Payoff 2 - DALYs",null,null,"Payoff 3 - Deaths","Payoff 5 - Count of inpatient days","Cohort %",null,null,"Payoff 1 - Provider costs (ZAR)","Payoff 2 - DALYs",null,null,"Payoff 3 - Deaths","Payoff 4 - Count of ICU days","Payoff 5 - Count of inpatient days","Cohort %","Cohort %"]
[null,"Cycle",null,"Severe patients general ward","Critical patients ICU","Recover","Die","Payoff 1 - Provider costs (ZAR)",null,"Payoff 2 - DALYs",null,"Payoff 3 - Deaths",null,"Payoff 4 - Count of ICU days",null,"Payoff 5 - Count of inpatient days",null,null,"Checksum of Cohort %",null,"1.1\n State","1.1.1\n Transition","1.1.2\n Transition","1.1\nState","1.1.1\nTransition","1.1.2\nTransition","State/Trans","1.1.2\nTransition","1.1\nState","1.2\n State","1.2.1\n Transition","1.2.2\n Transition","1.2\nState","1.2.1\nTransition","1.2.2\nTransition","State/Trans","1.2.2\nTransition","1.2\nState","1.2\nState","1.3\n State","1.4\n State"]
[null,null,null,null,null,null,null,"No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc",null,null,null,"Severe patients general ward","Recover","Die","Severe patients general ward","Recover","Die","State Total","Die","Severe patients general ward","Critical patients ICU","Recover","Die","Critical patients ICU","Recover","Die","State Total","Die","Critical patients ICU","Critical patients ICU","Recover","Die"]
[]
[null,0,null,{"$f":"1-pICU","v":0.79},{"$f":"pICU","v":0.21},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"X8+AG8","v":93868.421625000003},{"$f":"H8","v":93868.421625000003},{"$f":"'1. Strategy Calcs'!AA8 + '1. Strategy Calcs'!AJ8","v":1.1025470500000001},{"$f":"J8","v":1.1025470500000001},{"$f":"'1. Strategy Calcs'!AB8 + '1. Strategy Calcs'!AK8","v":0.20030000000000001},{"$f":"L8","v":0.20030000000000001},{"$f":"'1. Strategy Calcs'!AL8","v":1.8480000000000001},{"$f":"N8","v":1.8480000000000001},{"$f":"'1. Strategy Calcs'!AC8 + '1. Strategy Calcs'!AM8","v":16.997500000000002},{"$f":"P8","v":16.997500000000002},null,{"$f":"SUM(D8:G8)","v":1},null,{"$f":"'1. Strategy Calcs'!D8","v":0.79},{"$f":"U8*(1-(pdead))","v":0.70310000000000006},{"$f":"U8*(pdead)","v":8.6900000000000005E-2},{"$f":"U8*(cIPDpub*uIPD)","v":62572.888125000005},{"$f":"V8*(DWsevere*dursevere)","v":1.1882390000000003E-2},{"$f":"W8*(YLL+(DWsevere*durdeath))","v":0.46971188000000008},{"$f":"SUM(Y8:Z8)","v":0.4815942700000001},{"$f":"W8*(1)","v":8.6900000000000005E-2},{"$f":"U8*(uIPD)","v":16.787500000000001},{"$f":"'1. Strategy Calcs'!E8","v":0.21},{"$f":"AD8*(1-(pdeadICU))","v":9.6599999999999991E-2},{"$f":"AD8*(pdeadICU)","v":0.1134},{"$f":"AD8*(cICUpub*uICU+cIPDpub*uIPDICU)","v":31295.533500000001},{"$f":"AE8*(DWcritical*durcritical)","v":6.7330199999999993E-3},{"$f":"AF8*(YLL+(DWcritical*durdeath))","v":0.61421976},{"$f":"SUM(AH8:AI8)","v":0.62095277999999998},{"$f":"AF8*(1)","v":0.1134},{"$f":"AD8*(uICU)","v":1.8480000000000001},{"$f":"AD8*(uIPDICU)","v":0.21},{"$f":"'1. Strategy Calcs'!F8","v":0},{"$f":"'1. Strategy Calcs'!G8","v":0}]
[null,1,null,{"$f":"U9","v":0},{"$f":"AD9","v":0},{"$f":"AN9","v":0.79970000000000008},{"$f":"AO9","v":0.20030000000000001},{"$f":"X9+AG9","v":0},{"$f":"I8+H9","v":93868.421625000003},{"$f":"'1. Strategy Calcs'!AA9 + '1. Strategy Calcs'!AJ9","v":0},{"$f":"K8 + J9","v":1.1025470500000001},{"$f":"'1. Strategy Calcs'!AB9 + '1. Strategy Calcs'!AK9","v":0},{"$f":"M8 + L9","v":0.20030000000000001},{"$f":"'1. Strategy Calcs'!AL9","v":0},{"$f":"O8 + N9","v":1.8480000000000001},{"$f":"'1. Strategy Calcs'!AC9 + '1. Strategy Calcs'!AM9","v":0},{"$f":"Q8 + P9","v":16.997500000000002},null,{"$f":"SUM(D9:G9)","v":1},null,{"$f":"0","v":0},null,null,{"$f":"0","v":0},null,null,{"$f":"SUM(Y9:Z9)","v":0},null,{"$f":"0","v":0},{"$f":"0","v":0},null,null,{"$f":"0","v":0},null,null,{"$f":"SUM(AH9:AI9)","v":0},null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0 + '1. Strategy Calcs'!V8 + '1. Strategy Calcs'!AE8 + AN8","v":0.79970000000000008},{"$f":"0 + '1. Strategy Calcs'!W8 + '1. Strategy Calcs'!AF8 + AO8","v":0.20030000000000001}]
[]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H8:H9)","v":93868.421625000003},{"$f":"I9","v":93868.421625000003},{"$f":"SUM(J8:J9)","v":1.1025470500000001},{"$f":"K9","v":1.1025470500000001},{"$f":"SUM(L8:L9)","v":0.20030000000000001},{"$f":"M9","v":0.20030000000000001},{"$f":"SUM(N8:N9)","v":1.8480000000000001},{"$f":"O9","v":1.8480000000000001},{"$f":"SUM(P8:P9)","v":16.997500000000002},{"$f":"Q9","v":16.997500000000002}]

{"sheet":"2. Strategy Calcs","index":4,"n_rows":11,"n_cols":41,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,0,6],[3,3,3,5],[4,1,5,1],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,7,4,8],[4,15,4,16],[4,18,5,18],[2,20,2,28],[2,29,2,38],[3,20,3,22],[3,24,3,26],[3,29,3,31],[3,33,3,35]]}
[null,"Strategy",2,"Dexamethasone"]
[null,"States","All"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Severe patients general ward - State 2.1",null,null,null,null,null,null,null,null,"Critical patients ICU - State 2.2",null,null,null,null,null,null,null,null,null,"Recover - State 2.3","Die - State 2.4"]
[null,null,null,"Cohort State Proportions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cohort %",null,null,"Payoff 1 - Provider costs (ZAR)","Payoff 2 - DALYs",null,null,"Payoff 3 - Deaths","Payoff 5 - Count of inpatient days","Cohort %",null,null,"Payoff 1 - Provider costs (ZAR)","Payoff 2 - DALYs",null,null,"Payoff 3 - Deaths","Payoff 4 - Count of ICU days","Payoff 5 - Count of inpatient days","Cohort %","Cohort %"]
[null,"Cycle",null,"Severe patients general ward","Critical patients ICU","Recover","Die","Payoff 1 - Provider costs (ZAR)",null,"Payoff 2 - DALYs",null,"Payoff 3 - Deaths",null,"Payoff 4 - Count of ICU days",null,"Payoff 5 - Count of inpatient days",null,null,"Checksum of Cohort %",null,"2.1\n State","2.1.1\n Transition","2.1.2\n Transition","2.1\nState","2.1.1\nTransition","2.1.2\nTransition","State/Trans","2.1.2\nTransition","2.1\nState","2.2\n State","2.2.1\n Transition","2.2.2\n Transition","2.2\nState","2.2.1\nTransition","2.2.2\nTransition","State/Trans","2.2.2\nTransition","2.2\nState","2.2\nState","2.3\n State","2.4\n State"]
[null,null,null,null,null,null,null,"No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc","No Discount","Cum No Disc",null,null,null,"Severe patients general ward","Recover","Die","Severe patients general ward","Recover","Die","State Total","Die","Severe patients general ward","Critical patients ICU","Recover","Die","Critical patients ICU","Recover","Die","State Total","Die","Critical patients ICU","Critical patients ICU","Recover","Die"]
[]
[null,0,null,{"$f":"1-pICU","v":0.79},{"$f":"pICU","v":0.21},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"'2. Strategy Calcs'!X8 + '2. Strategy Calcs'!AG8","v":94029.271625000008},{"$f":"H8","v":94029.271625000008},{"$f":"'2. Strategy Calcs'!AA8 + '2. Strategy Calcs'!AJ8","v":0.7966878730000001},{"$f":"J8","v":0.7966878730000001},{"$f":"'2. Strategy Calcs'!AB8 + '2. Strategy Calcs'!AK8","v":0.14323000000000002},{"$f":"L8","v":0.14323000000000002},{"$f":"'2. Strategy Calcs'!AL8","v":1.8480000000000001},{"$f":"N8","v":1.8480000000000001},{"$f":"'2. Strategy Calcs'!AC8 + '2. Strategy Calcs'!AM8","v":16.997500000000002},{"$f":"P8","v":16.997500000000002},null,{"$f":"SUM(D8:G8)","v":1},null,{"$f":"'2. Strategy Calcs'!D8","v":0.79},{"$f":"U8*(1-(pdead*rrdexgen))","v":0.72048000000000001},{"$f":"U8*(pdead*rrdexgen)","v":6.9520000000000012E-2},{"$f":"U8*((cIPDpub*uIPD)+cDex)","v":62699.95962500001},{"$f":"V8*(DWsevere*dursevere)","v":1.2176112000000001E-2},{"$f":"W8*(YLL+(DWsevere*durdeath))","v":0.37576950400000009},{"$f":"SUM(Y8:Z8)","v":0.3879456160000001},{"$f":"W8*(1)","v":6.9520000000000012E-2},{"$f":"U8*(uIPD)","v":16.787500000000001},{"$f":"'2. Strategy Calcs'!E8","v":0.21},{"$f":"AD8*(1-(pdeadICU*rrdexICU))","v":0.13628999999999999},{"$f":"AD8*(pdeadICU*rrdexICU)","v":7.3709999999999998E-2},{"$f":"AD8*(cICUpub*uICU+cIPDpub*uIPDICU+cDex)","v":31329.312000000002},{"$f":"AE8*(DWcritical*durcritical)","v":9.499413E-3},{"$f":"AF8*(YLL+(DWcritical*durdeath))","v":0.39924284399999999},{"$f":"SUM(AH8:AI8)","v":0.408742257},{"$f":"AF8*(1)","v":7.3709999999999998E-2},{"$f":"AD8*(uICU)","v":1.8480000000000001},{"$f":"AD8*(uIPDICU)","v":0.21},{"$f":"'2. Strategy Calcs'!F8","v":0},{"$f":"'2. Strategy Calcs'!G8","v":0}]
[null,1,null,{"$f":"'2. Strategy Calcs'!U9","v":0},{"$f":"'2. Strategy Calcs'!AD9","v":0},{"$f":"'2. Strategy Calcs'!AN9","v":0.85677000000000003},{"$f":"'2. Strategy Calcs'!AO9","v":0.14323000000000002},{"$f":"'2. Strategy Calcs'!X9 + '2. Strategy Calcs'!AG9","v":0},{"$f":"I8 + H9","v":94029.271625000008},{"$f":"'2. Strategy Calcs'!AA9 + '2. Strategy Calcs'!AJ9","v":0},{"$f":"K8 + J9","v":0.7966878730000001},{"$f":"'2. Strategy Calcs'!AB9 + '2. Strategy Calcs'!AK9","v":0},{"$f":"M8 + L9","v":0.14323000000000002},{"$f":"'2. Strategy Calcs'!AL9","v":0},{"$f":"O8 + N9","v":1.8480000000000001},{"$f":"'2. Strategy Calcs'!AC9 + '2. Strategy Calcs'!AM9","v":0},{"$f":"Q8 + P9","v":16.997500000000002},null,{"$f":"SUM(D9:G9)","v":1},null,{"$f":"0","v":0},null,null,{"$f":"0","v":0},null,null,{"$f":"SUM(Y9:Z9)","v":0},null,{"$f":"0","v":0},{"$f":"0","v":0},null,null,{"$f":"0","v":0},null,null,{"$f":"SUM(AH9:AI9)","v":0},null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0 + '2. Strategy Calcs'!V8 + '2. Strategy Calcs'!AE8 + AN8","v":0.85677000000000003},{"$f":"0 + '2. Strategy Calcs'!W8 + '2. Strategy Calcs'!AF8 + AO8","v":0.14323000000000002}]
[]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H8:H9)","v":94029.271625000008},{"$f":"I9","v":94029.271625000008},{"$f":"SUM(J8:J9)","v":0.7966878730000001},{"$f":"K9","v":0.7966878730000001},{"$f":"SUM(L8:L9)","v":0.14323000000000002},{"$f":"M9","v":0.14323000000000002},{"$f":"SUM(N8:N9)","v":1.8480000000000001},{"$f":"O9","v":1.8480000000000001},{"$f":"SUM(P8:P9)","v":16.997500000000002},{"$f":"Q9","v":16.997500000000002}]

{"sheet":"State Trans Diag","index":5,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["State Transition Diagram of Strategy:","Status quo",null,null,null,null,null,null,null,null,null,"Tree Diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State Transition Diagram of Strategy:","Dexamethasone"]
[]
[null,"Same As","Status quo"]

{"sheet":"Public Hospital Costs","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Cost per inpatient day"]
[null," Exp per inpatient day (2020) / Source Health Systems Trust (2016/17 prices inflated to 2020)"]
["Hospital Level","EC","FS","GT","KZ","LP","MP","NC","NW","WC","Usable beds","National"]
["Central Hospitals",5873.6136531652783,7464.9353557135482,4782.0136394391957,9335.9207019125115,null,null,null,null,6057.7710270339439,8222,{"$f":"AVERAGE(B4:J4)","v":6702.8508754528957}]
["Regional Hospitals",2367.2956749710665,3298.5757017780616,3339.6776267767705,3808.9814157606038,3501.1199721698586,3448.2760147146741,null,3203.4248519000171,3548.0990185276873,19936,{"$f":"AVERAGE(B5:J5)","v":3314.4312845748423}]
["Tertiary Hospitals",3524.1217196486823,3841.3509027745777,3798.8447511287827,5162.2015850169209,4065.7482043267382,3771.8862477232306,5389.6530401213658,3337.3495878729227,6859.3509036581872,10393,{"$f":"AVERAGE(B6:J6)","v":4416.7229935857131}]
["District Hospitals",2747.7093173562589,2914.0316236258168,3371.1433515867429,3048.4286012503462,3497.6742837785632,2718.3667427822588,2971.8249582929093,2801.4597342346383,2537.5588485232624,30351,{"$f":"AVERAGE(B7:J7)","v":2956.4663846034218}]
["Weighted average (based on usable beds at level of care)",null,null,null,null,null,null,null,null,null,null,{"$f":"L4*$K4/SUM($K4:$K7)+L5*$K5/SUM($K4:$K7)+L6*$K6/SUM($K4:$K7)+L7*$K7/SUM($K4:$K7)","v":3727.3526936619046}]
["Cost per ICU day (based on differential between ICU cost and global cost in private sector)",null,null,null,null,null,null,null,null,null,null,16511.252377356617]

{"sheet":"Dexamethasone Cost","index":7,"n_rows":8,"n_cols":44,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,4,7,7]]}
["Master Procurement Catalogue",null,null,null,null,"DATE: 1 June 2020"]
["Contract","Item number","NSN","Description As per Contract"," INN Generic","Brand as per Contract","Supplier Name","Supplier Code","Price \n15% VAT\n","Lead time","ATC","VEN","EML/Non-EML","Therapeutic Group","Level of care","Qty Awarded","Therapeutic Category","EAN 13 Barcode for Unit Pack","EAN 13 Barcode for Shelf Pack or Shrinkwrap","EAN 13 Barcode for Shelf Pack or Shrinkwrap/Single Unit Qty","ITF14 Barcode for Shipper Pack","ITF14 Barcode for Shipper Pack/Single Unit Qty","Pallet Barcode ","Pallet Barcode/Single Unit Qty","NAPPI","MOQ","Contract Start Date\ndd/mm/yyyy","Contract End Date\ndd/mm/yyyy","Contract extended up to\ndd/mm/yyyy","Description (WHO INN)","UNSPSC","CSD Supplier Number","Latest Addendum Nr","Price effective  date","Description As per Contract"," INN Generic","Generic Name","Strength","Strength Unit","Form","PackSize","PackSize Unit","Form","Split % or limited qty offered"]
["RT297-2019",31,180075759,"Dexamethasone, 4mg, 1ml, injection","dexamethasone","FRESENIUS DEXAMETHASONE 4 mg/1 ml","FRESENIUS KABI SOUTH AFRICA (PTY) LTD","VAJL3",6.32,14,"H02AB02","V","EML",null,"HOSP",567384,"Corticosteroid Therapy",6006267005424,6006267005424,null,16006267005421,null,null,null,720206001,10,"2019-05-01","2021-04-30",null,"Dexamethasone, 4mg, 1ml, injection","51422306-00001","MAAA0007374",32,"2020-05-01",{"$f":"D3","v":"Dexamethasone, 4mg, 1ml, injection"},null,null,null,null,null,null,null,"injection",20]
["RT297-2019",31,180075759,"Dexamethasone, 4mg, 1ml, injection","dexamethasone","Pharma-Q Dexamethasone 4mg","Pharma-Q (Pty) Ltd","V1NK1",5.38,14,"H02AB02","V","EML",null,"HOSP",17150,"Corticosteroid Therapy",6009802416129,6009802416129,null,16009802416126,null,null,null,701589001,100,"2019-05-01","2021-04-30",null,"Dexamethasone, 4mg, 1ml, injection","51422306-00001","MAAA0016762",33,"2020-05-01",{"$f":"D4","v":"Dexamethasone, 4mg, 1ml, injection"},null,null,null,null,null,null,null,"injection",60]
[]
[null,null,null,null,null,null,"Weighted average price",null,{"$f":"I3*P3/(P3+P4)+I4*P4/(P3+P4)","v":6.2924207659434703}]
[]
[null,null,null,null,"6mg/day over 10 days = 20 x 4mg vials @ weighted EML price of R6.29 per vial plus R35.00 dispensing fee",null,null,null,{"$f":"I6*20+35","v":160.8484153188694}]

{"sheet":"Inpatient Deaths & Utilisation","index":8,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[56,0,56,1],[63,0,63,1]]}
["ICU mortality"]
["Data source","Country, city","Total ICU patients","Deaths","Still in ICU","Survived out of ICU","Discharged from hospital","Mortality rate"]
["Intensive care national audit  & research centre, UK","UK ",6143,2872,"NA","NA",3271,{"$f":"D3/(D3+G3)","v":0.46752401106951003}]
["Grasselli et al., 2020","Italy, Lombardy",1591,405,920,"NA",256,{"$f":"D4/(D4+G4)","v":0.61270801815431164}]
["Bhatraju et al., 2020","USA, Seattle",24,12,3,4,5,{"$f":"D5/(D5+F5+G5)","v":0.5714285714285714}]
["Arentz et al., 2020","USA, Washington state",21,14,5,2,"NA",{"$f":"D6/(D6+F6)","v":0.875}]
["Wang et al., 2020","China, Wuhan",36,6,11,10,9,{"$f":"D7/(D7+F7+G7)","v":0.24}]
["Yang et al., 2020","China, Wuhan",52,32,12,"NA",8,{"$f":"D8/(D8+G8)","v":0.8}]
["Zhou et al., 2020","China, Wuhan",50,39,"NA",11,"NA",{"$f":"D9/(D9+F9)","v":0.78}]
["Klok et al., 2020","Netherlands",184,41,{"$f":"C10-D10-G10","v":65},"NA",78,{"$f":"D10/(D10+G10)","v":0.34453781512605042}]
["Richardson et al., 2020","USA, NY City",1281,291,908,"NA",82,{"$f":"D11/(D11+G11)","v":0.78016085790884715}]
["Zhang et al., 2020","China, Wuhan",44,9,12,23,"NA",{"$f":"D12/(D12+E12)","v":0.42857142857142855}]
["Cao et al., 2020","China, Wuhan",18,6,0,"NA",12,{"$f":"D13/(D13+G13)","v":0.33333333333333331}]
[]
[null,null,null,null,null,null,"Base value",{"$f":"(SUMPRODUCT(C3:C13,H3:H13))/(SUM(C3:C13))","v":0.53534369995969555}]
[null,null,null,null,null,null,"Low value",{"$f":"H7","v":0.24}]
[null,null,null,null,null,null,"High value",{"$f":"H6","v":0.875}]
[]
["Inpatient mortality"]
["Data source","Country, city","Total non-ICU patients","Deaths","Still in hospital","Discharged from hospital","Mortality rate"]
["Wang et al., 2020","China, Wuhan",102,0,64,38,{"$f":"D21/(D21+F21)","v":0}]
["Zhou et al., 2020","China, Wuhan",141,15,"NA",126,{"$f":"D22/(D22+F22)","v":0.10638297872340426}]
["Richardson et al., 2020","USA, NY City",4419,262,2186,1999,{"$f":"D23/(D23+F23)","v":0.11587793011941619}]
["Cao et al., 2020","China, Wuhan",84,11,0,73,{"$f":"D24/(D24+F24)","v":0.13095238095238096}]
["Zhang et al., 2020","China, Wuhan",177,3,132,42,{"$f":"D25/(D25+F25)","v":6.6666666666666666E-2}]
[]
[null,null,null,null,null,"Base value",{"$f":"(SUMPRODUCT(C21:C25,G21:G25))/(SUM(C21:C25))","v":0.11169298663369899}]
[null,null,null,null,null,"Low value",{"$f":"G21","v":0}]
[null,null,null,null,null,"High value",{"$f":"G24","v":0.13095238095238096}]
[]
["Proportion of admitted patients needing ICU"]
["Data source","Country, city","Sample size","ICU patients","non-ICU patients","Proportion needing ICU"]
["Wang et al., 2020","China, Wuhan",138,36,102,{"$f":"D33/C33","v":0.2608695652173913}]
["Zhou et al., 2020","China, Wuhan",191,50,141,{"$f":"D34/C34","v":0.26178010471204188}]
["Huang et al., 2020","China, Wuhan",41,13,28,0.31707317073170732]
["Guan et al., 2020","China",1099,55,{"$f":"C36-D36","v":1044},5.0045495905368519E-2]
["Yan et al., 2020","China, Wuhan",193,92,{"$f":"C37-D37","v":101},0.47668393782383417]
["Aggarwal et al., 2020","USA",16,8,8,0.5]
["Richardson et al., 2020","USA, New York city",5700,1281,4419,0.22473684210526315]
["Zhang et al., 2020","China, Wuhan",221,44,{"$f":"C40-D40","v":177},0.19909502262443438]
["Cao et al., 2020","China, Wuhan",102,18,84,0.17647058823529413]
[]
[null,null,null,null,"Base value",{"$f":"(SUMPRODUCT(C33:C41,F33:F41))/(SUM(C33:C41))","v":0.20737566549798728}]
[null,null,null,null,"Low",{"$f":"F36","v":5.0045495905368519E-2}]
[null,null,null,null,"High",{"$f":"F38","v":0.5}]
[]
["Utilisation of ICU days"]
["Data source","Country, city","Sample size","Median LoS ICU","Low IQR","High IQR"]
["ICNARC UK","England, Wales & Northern Ireland",6143,8,4,14]
["Grasseli et al., 2020","Italy, Lombardy region",1591,9,6,13]
["Yang et al., 2020","China, Wuhan",52,7,3,11]
["Zhang et al., 2020","China, Wuhan",44,11,4.5,14.5]
["Bhatraju et al., 2020","USA, Seattle",24,9,4,14]
[null,"Total"]
[null,null,"Average",{"$f":"AVERAGE(D49:D53)","v":8.8000000000000007},{"$f":"AVERAGE(E49:E53)","v":4.3},{"$f":"AVERAGE(F49:F53)","v":13.3}]
[]
["Utilisation of general ward days"]
["Data source","Country, city","Sample size","Median LoS general ward","Low IQR","High IQR"]
["Wang et al., 2020","China, Sichuan",538,19,3,41]
["Liu et al., 2020","China, Wuhan",99,23.5,11.5,45]
[null,"Total"]
[null,null,"Average",{"$f":"AVERAGE(D59:D60)","v":21.25},{"$f":"AVERAGE(E59:E60)","v":7.25},{"$f":"AVERAGE(F59:F60)","v":43}]
[]
["Utilisation of general ward days for those needing ICU"]
["Data source","Country, city","Sample size","Median LoS general ward before ICU","Low IQR","High IQR"]
["Wang et al., 2020","China, Wuhan","36 ICU pts",1,0,3]

{"sheet":"TP Internal Formulas","index":9,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,0,2,10],[3,0,3,10],[28,0,28,10],[32,0,32,2],[33,0,33,2]]}
["EXTRAS"]
[]
["This worksheet includes elements from the TreeAge Pro model that are not actively used in the exported Excel model."]
["They are included here for reference only."]
[]
["TreeAge Pro Variable Sensitivity Analysis Range"]
[]
["Name","Low","High"]
["ppm",0,1]
["cIPDpub",0,3727.35]
["uIPD",7.25,43]
["uICU",4.3,13.3]
["cICUpub",0,15914.73]
["cICUpvt",0,0]
["pdead",0,0.13]
["pdeadICU",0.24,0.88]
["pICU",0.05,0.5]
["uIPDICU",0,3]
["YLL",0,0]
["dursevere",0.06,0.25]
["durcritical",0.08,0.33]
["durdeath",0.02,0.06]
["exmortality",1.0000000000000001E-5,4]
["DWsevere",0.09,0.19]
["DWcritical",0.27,0.56000000000000005]
["uIPDcritical",4.3,13.3]
["cIPDpvt",0,0]
[]
["Sensitivity analysis ranges are used in TreeAge Pro, but not in the converted Excel model."]
[]
[]
[]
["Green cells are editable"]
["Gray cells - no impact on calculation"]