{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Title sheet","Inputs","Inputs Main","Inputs Interventions","Cost Breakdown","Base case","SA","SAAbs","SAProd","SATurnover"],"not_rendered":{"charts":9,"images":4,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Title sheet","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[25,3,25,11],[22,3,24,11],[19,3,20,11],[26,3,27,11],[3,2,3,3],[6,3,8,10],[11,3,16,11]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[null,null,null,"An economic evaluation of mental wellbeing interventions at work in England"]
[]
[]
[null,null,null,"About the model:"]
[]
[null,null,null,"This cost-calculator is intended for use by decision makers to determine if a mental health intervention at work is cost-saving for a specific organisation from the perspective of the employer.  The model is intended to be used as one decision making tool and should be used in conjunction with other tools/information. The baseline costs are provided as a starting point and as an example of the type of inputs that could be used.  However, the baseline inputs have high levels of uncertainty and should be used with care and caution. Each baseline input has a comment in the cell to indicate the input source. A variety of intervention types, based on evidence, have been included as a guide only. It is likely that the information required for the model will differ by organisation. Hence, it is intended that the user will input data specific to their own organisation (or the organisation where the intervention will be implemented) and that the results will supplement decision making.  The model should be used alongside the associated economic model report which is available on the NICE website."]
[]
[]
[]
[]
[]
[null,null,null,"Navigating the model:"]
[]
[null,null,null,"The rectangular buttons to the left hand side allow the user to navigate between sections. Chevron buttons at the top of each sheet allow the user to navigate to sub-sections within each section. "]
[]
[]
[null,null,null,"The 'Inputs' sheet is where all input parameters are displayed. Many of the inputs have a 'user defined input' field allowing the user to enter their own value and bypass the suggested value. Use the chevron button to navigate to the 'Interventions' sheet. The 'Interventions' sheets allows the user to view the underlying data for each intervention type including employee outcomes. The 'Interventions' sheet can also be used to input user defined employee outcomes."]
[]
[]
[]
[null,null,null,"The 'Results' sheet displays the results of the model. Use the chevron button to navigate to the 'Sensitivity Analysis' sheet. The 'Sensitivity Analysis' sheet allows the user to explore the effect of varying each input on the results."]
[]
[]
[null,null,null,"Model functionality:"]
[]
[null,null,null,"Black text",null,"Indicates input cells. These can be changed as appropriate to your requirements."]
[]
[null,null,null,"Red text",null,"Indicates a formula cell. These are dependent upon other cells, and should not be changed. There are no password or protected sheets."]
[]
[null,null,null,"Comments",null,"A red mark in the corner of a cell indicates a comment. To view the comment, hover the pointer over the cell."]
[]
[null,null,null,null,null,"Drop down boxes are used to display different options for the model user to select. The model will automatically update depending on which option is selected. "]
[]
[null,null,null,null,null,"An information logo indicates additional information. To view the information, click the icon and a pop up box will appear."]

{"sheet":"Inputs","index":1,"n_rows":216,"n_cols":45,"rows_kept":216,"cut":false,"hidden":false,"merged":[[3,2,3,3],[18,7,19,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slider chart",null,null,null,null,null,"Sensitivity analysis",null,null,null,null,null,null,"Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIVE","Spin button"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No of employees",{"$f":"IF('Base case'!$E$127=1,Inputs!AG12,Inputs!E17)","v":50},100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of intervention",{"$f":"'Base case'!E20","v":5000},null,null,null,null,null,null,"Incremental"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of intervention per person",{"$f":"IF('Base case'!$E$127=1,Inputs!AG14,Inputs!H17)","v":100},100,null,null,null,0,0,null,null,null,null,null,{"$f":"$D$19","v":"Absenteeism (sick leave)"},{"$f":"H21*E17*E20","v":0}]
[null,null,null,"Intervention type","Manager mental health training",null,{"$f":"LOWER(E15)","v":"manager mental health training"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,5000,null,null,null,null,null,{"$f":"$D$23","v":"Presenteeism"},{"$f":"H22*E17*E24","v":0}]
[null,null,null,null,null,null,null,"Per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spin button default",null,null,200,10000,null,null,null,null,null,{"$f":"$D$27","v":"Staff turnover"},{"$f":"H23*E28","v":0}]
[null,null,null,"Number of employees",{"$f":"'Inputs Main'!E11","v":50},null,"Cost of intervention (person)",{"$f":"IF('Inputs Main'!I110=1,'Inputs Main'!I11/'Inputs Main'!E11,IF('Inputs Main'!I110=2,'Inputs Main'!I11,'Cost Breakdown'!E20/'Inputs Main'!E11))","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism per day",{"$f":"IF('Base case'!$E$127=1,Inputs!AG17,Inputs!E20)","v":153.97999999999999},153.97999999999999,null,null,null,300,15000,null,null,null,null,null,"Intervention cost",{"$f":"H17","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduction in absenteeism",{"$f":"IF('Base case'!$E$127=1,Inputs!AG18,Inputs!H21)","v":0},0,{"$f":"AF18","v":0},null,null,400,20000,null,null,null,null,null,"Total",{"$f":"SUM(AS14:AS17)","v":100}]
[null,null,null,"Absenteeism (sick leave)","Baseline",null,null,"Per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,25000]
[null,null,null,"Cost of absenteeism per day",{"$f":"IF('Inputs Main'!F17=\"\",'Inputs Main'!E17,'Inputs Main'!F17)","v":153.97999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,30000]
[null,null,null,null,null,null,{"$f":"'Inputs Main'!H17","v":"Reduction in absenteeism (in days)"},{"$f":"IF('Inputs Main'!J17=\"\",IF('Inputs Main'!I17=\"No evidence\",0,'Inputs Main'!I17),'Inputs Main'!J17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of presenteeism per day",{"$f":"IF('Base case'!$E$127=1,Inputs!AG21,Inputs!E24)","v":307.95999999999998},307.95999999999998,{"$f":"AF21","v":307.95999999999998},null,null,700,35000]
[null,null,null,null,null,null,{"$f":"'Inputs Main'!H18","v":"Reduction in presenteeism (in days)"},{"$f":"IF('Inputs Main'!J18=\"\",IF('Inputs Main'!I18=\"No evidence\",0,'Inputs Main'!I18),'Inputs Main'!J18)","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduction in presenteeism",{"$f":"IF('Base case'!$E$127=1,(Inputs!AG22/100),Inputs!H22)","v":0},0,{"$f":"AF22","v":0},null,null,800,40000]
[null,null,null,"Presenteeism","Baseline",null,{"$f":"'Inputs Main'!H19","v":"Reduction in staff turnover (%)"},{"$f":"IF('Inputs Main'!J19=\"\",IF('Inputs Main'!I19=\"No evidence\",0,'Inputs Main'!I19),'Inputs Main'!J19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,45000]
[null,null,null,"Cost of presenteeism per day",{"$f":"IF('Inputs Main'!F18=\"\",'Inputs Main'!E18,'Inputs Main'!F18)","v":307.95999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per case of staff turnover",{"$f":"IF('Base case'!$E$127=1,Inputs!AG25,Inputs!E28)","v":14983.71},14983.71,null,null,null,{"$f":"AF14","v":100},{"$f":"AL13","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduction in staff turnover",{"$f":"(IF('Base case'!$E$127=1,(Inputs!AG26/100),Inputs!H23))","v":0},0,{"$f":"AF26","v":0}]
[null,null,null,"Staff turnover","Baseline"]
[null,null,null,"Cost per case of staff turnover",{"$f":"IF('Inputs Main'!F19=\"\",'Inputs Main'!E19,'Inputs Main'!F19)","v":14983.71},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism",{"$f":"'Base case'!E20","v":5000},null,"Reduction in days",{"$f":"'Base case'!E20","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5000,null,-5,43494.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,5000,null,-4,35796]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,5000,null,-3,28096.999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,5000,null,-2,20398]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,5000,null,-1,12699]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,5000,null,0,5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,5000,null,1,-2698.9999999999991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,5000,null,2,-10397.999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,5000,null,3,-18096.999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,5000,null,4,-25795.999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,5000,null,5,-33494.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF17","v":153.97999999999999},{"$f":"AL28","v":5000},null,6,-41193.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,-48892.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,-56591.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,-64290.999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,-71989.999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF18","v":0},{"$f":"AO28","v":5000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presenteeism"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of presenteeism",{"$f":"'Base case'!E20","v":5000},null,"Reduction in days",{"$f":"'Base case'!E20","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5000,null,-10,158979.99999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,5000,null,-8,128183.99999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,5000,null,-6,97387.999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,5000,null,-4,66592]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,5000,null,-2,35796]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,5000,null,0,5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,5000,null,2,-25795.999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,5000,null,4,-56591.999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,5000,null,6,-87387.999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,5000,null,8,-118183.99999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,5000,null,10,-148979.99999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF21","v":307.95999999999998},{"$f":"AL48","v":5000},null,12,-179775.99999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,-210571.99999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,-241367.99999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,-272163.99999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,-302959.99999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF22","v":0},{"$f":"AO48","v":5000}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff turnover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per case",{"$f":"'Base case'!E20","v":5000},null,"Reduction in turnover",{"$f":"'Base case'!E20","v":5000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,5000,null,-0.05,42459.275000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000,5000,null,-0.04,34967.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10000,5000,null,-0.03,27475.564999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15000,5000,null,-0.02,19983.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,5000,null,-0.01,12491.855]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,5000,null,0,5000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30000,5000,null,0.01,-2491.8550000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35000,5000,null,0.02,-9983.7100000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40000,5000,null,0.03,-17475.564999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45000,5000,null,0.04,-24967.420000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000,5000,null,0.05,-32459.275000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF25","v":14983.71},{"$f":"AL69","v":5000},null,0.06,-39951.129999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,-47442.985000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,-54934.840000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,-62426.694999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,-69918.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF26","v":0},{"$f":"AL81","v":5000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Include?"]
[null,null,null,"Absenteeism",{"$f":"IF(H21=0,0,1)","v":0}]
[null,null,null,"Presenteeism",{"$f":"IF(H22=0,0,1)","v":0}]
[null,null,null,"Staff turnover",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Number of days lost per person (absenteeism)"]
[]
[null,null,null,"16-24",1.2E-2]
[null,null,null,"25-34",1.4999999999999999E-2]
[null,null,null,"35-49",0.02]
[null,null,null,"50-64",2.8000000000000001E-2]
[null,null,null,"65+",2.3E-2]
[]
[null,null,null,"http://www.ons.gov.uk/ons/dcp171778_412021.pdf"]
[null,null,null,null,"Number employed (000s)"]
[null,null,null,"16-65",29894,{"$f":"E204/E206","v":0.96326609525037055},{"$f":"AVERAGE(E196:E199)","v":1.8749999999999999E-2}]
[null,null,null,"65+",1140,{"$f":"E205/E206","v":3.673390474962944E-2},{"$f":"E200","v":2.3E-2}]
[null,null,null,null,{"$f":"SUM(E204:E205)","v":31034},{"$f":"SUM(F204:F205)","v":1},{"$f":"SUMPRODUCT(G204:G205,E204:E205)/SUM(E204:E205)","v":1.8906119095185924E-2}]
[null,null,null,null,null,null,{"$f":"253*G206","v":4.7832481310820389}]
[]
[]
[null,null,null,null,"CPI"]
[null,null,null,"2007 Q1",103.7]
[null,null,null,"2015 Dec",128.5]
[null,null,null,null,{"$f":"E212/E211","v":1.2391513982642237}]
[null,null,null,null,{"$f":"11625*E213","v":14405.135004821601}]
[]
[null,null,null,null,{"$f":"528*52","v":27456}]

{"sheet":"Inputs Main","index":2,"n_rows":210,"n_cols":25,"rows_kept":210,"cut":false,"hidden":false,"merged":[[41,23,42,23],[41,24,42,24],[3,2,3,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Number of employees",50,null,null,"Cost of intervention",100]
[null,null,null,null,null,null,null,"Total"]
[null,null,null,"Intervention type",3,null,null,"Per person"]
[null,null,null,null,"(select from dropdown list)",null,null,"Using cost breakdown"]
[]
[null,null,null,null,"Baseline","User defined",null,null,"Effectiveness","User defined"]
[null,null,null,"Cost of absenteeism per day",153.97999999999999,null,null,"Reduction in absenteeism (in days)",{"$f":"IF(VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,3, FALSE)=0, \"No evidence\",VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,3, FALSE))","v":"No evidence"}]
[null,null,null,"Cost of presenteeism per day",307.95999999999998,null,null,"Reduction in presenteeism (in days)",{"$f":"IF(VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,4, FALSE)=0, \"No evidence\",VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,4, FALSE))","v":"No evidence"}]
[null,null,null,"Cost per case of staff turnover",14983.71,null,null,"Reduction in staff turnover (%)",{"$f":"IF(VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,5, FALSE)=0, \"No evidence\",VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$I$27,5, FALSE))","v":"No evidence"}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Reduction in \",D26)","v":"Reduction in "},0.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention cost","Reduction in turnover required to be cost-saving (%)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Always cost saving"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"Always cost saving"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,0.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,"Cost-saving cannot be achieved"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"User defined",true,{"$f":"IF(I108=TRUE, 1, 0)","v":1}]
[]
[null,null,null,null,null,null,null,"Total",2,{"$f":"IF(I110=1, 1, 0)","v":0}]
[null,null,null,null,null,null,null,"Per person",null,{"$f":"IF(I110=2, 1, 0)","v":1}]
[null,null,null,null,null,null,null,"Using cost breakdown",null,{"$f":"IF(I110=3, 1, 0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Number of days lost per person (absenteeism)"]
[]
[null,null,null,"16-24"]
[null,null,null,"25-34",1.2E-2]
[null,null,null,"35-49",1.4999999999999999E-2]
[null,null,null,"50-64",0.02]
[null,null,null,"65+",2.8000000000000001E-2]
[null,null,null,null,2.3E-2]
[null,null,null,"http://www.ons.gov.uk/ons/dcp171778_412021.pdf"]
[]
[null,null,null,"16-65","Number employed (000s)"]
[null,null,null,"65+",29894]
[null,null,null,null,1140]
[null,null,null,null,{"$f":"SUM(E198:E199)","v":31034}]
[]
[]
[]
[null,null,null,"2007 Q1","CPI"]
[null,null,null,"2015 Dec",103.7]
[null,null,null,null,128.5,null,null,{"$f":"AVERAGE(E190:E193)","v":1.8749999999999999E-2}]
[null,null,null,null,{"$f":"E206/E205","v":1.2391513982642237},null,{"$f":"E198/E200","v":0.96326609525037055},{"$f":"E194","v":2.3E-2}]
[null,null,null,null,{"$f":"11625*E207","v":14405.135004821601},null,{"$f":"E199/E200","v":3.673390474962944E-2},{"$f":"SUMPRODUCT(H206:H207,E198:E199)/SUM(E198:E199)","v":1.8906119095185924E-2}]
[null,null,null,null,null,null,{"$f":"#NULL!","v":{"$error":"#NULL!"}},{"$f":"#NULL!","v":{"$error":"#NULL!"}}]
[null,null,null,null,{"$f":"528*52","v":27456}]

{"sheet":"Inputs Interventions","index":3,"n_rows":197,"n_cols":29,"rows_kept":197,"cut":false,"hidden":false,"merged":[[3,2,3,3],[10,6,10,8],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,9,10,27],[94,3,95,3],[94,4,95,4],[94,5,95,5],[94,6,94,8],[94,9,94,28],[117,3,118,3],[117,4,118,4],[117,5,118,5],[117,6,117,8],[117,9,117,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ID","Intervention type","Description","Employer outcomes",null,null,"Employee outcomes"]
[null,null,null,null,null,null,"Reduction in absenteeism (days)","Reduction in presenteeism (days)","Reduction in staff turnover (point %)","Confidence identifying mental health","Uptake of support services","Communication and awareness of support","Managers mental health knowledge","Destigmatisation","Mental wellbeing","Mental wellbeing (based on non RCTs)","Mental health symptoms","Mental health symptoms (based on non RCTs)","Mental health literacy","Job stress","Job stress (based on non RCTs)","Job stress (based on RCTs reporting relative risk)","Job satisfaction","Job satisfaction (based on non RCTs)","Job satisfaction (based on RCTs reporting relative risk)","Work climate","Work climate (based on non RCTs)","Quality of life"]
[null,null,null,1,"Case study: Multicomponent health promotion","Mills (2007)",4.3,9.1999999999999993]
[null,null,null,2,"User defined","User defined"]
[null,null,null,3,"Manager mental health training","Universal manager-level",null,null,null,0.74,1.34,1.28,1.45,0.31]
[null,null,null,4,"Leadership development","Universal organisational-level",null,null,null,null,null,null,null,null,null,-0.09,null,null,null,null,null,null,null,0.01,null,null,0.06]
[null,null,null,5,"Peer support","Universal organisational-level",null,null,null,null,null,null,null,null,0.57999999999999996,null,null,null,null,-0.16,null,null,0.56999999999999995]
[null,null,null,6,"Mental health first aider","Universal organisational-level",null,null,null,null,null,null,null,null,0.06,null,-0.02,null,0.53]
[null,null,null,7,"Participatory approach ","Universal organisational-level",null,null,null,null,null,null,null,null,0.45,null,0.01,0.14000000000000001,null,0.34,0.15,-0.27,0.19,null,0.22,0.18,0.02]
[null,null,null,8,"Targeted cognitive behavioural theory","Targeted individual-level",1.83,4.03,null,null,null,null,null,null,0.48,null,0.36,null,0.02,0.15,null,null,-0.09]
[null,null,null,9,"Targeted mindfulness","Targeted individual-level",2.29,null,null,null,null,null,null,null,0.56999999999999995,null,0.61,null,null,0.91]
[null,null,null,10,"Targeted digital/online stress management","Targeted individual-level",0.71,1.82,null,null,null,null,null,null,null,null,0.77,null,0.51,0.83,null,null,0.2,null,null,null,null,0.57999999999999996]
[]
[null,null,null,"These are suggested inputs based on available data.  "]
[null,null,null,"Your own data can be entered into the table using the 'User defined' row.  For all outcomes, a positive value indicates an improvement."]
[null,null,null,"Default values for employee outcomes are expressed in term of the standardised mean difference, unless otherwise stated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ID","Intervention type","Description","Employer Outcomes",null,null,"Employee Outcomes"]
[null,null,null,null,null,null,"absenteeism","presenteeism","staff turnover","confidence identifying mental health","uptake of support services","communication and awareness of support","managers mental health knowledge","destigmatisation","mental wellbeing","mental wellbeing (based on non RCTs)","mental health symptoms","mental health symptoms (based on non RCTs)","mental health literacy","job stress","job stress (based on non RCTs)","job stress (based on RCTs reporting relative risk)","job satisfaction","job satisfaction (based on non RCTs)","job satisfaction (based on RCTs reporting relative risk)","work climate","work climate (based on non RCTs)","quality of life","SUMMARY"]
[null,null,null,1,{"$f":"E13","v":"Case study: Multicomponent health promotion"},null,null,null,null,{"$f":"IF(J13=\"\",\"\",CONCATENATE(IF(J13>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J13)))","v":""},{"$f":"IF(K13=\"\",\"\",CONCATENATE(IF(K13>0, \"● Improve \", \"● Worsen \"), K$96, \" by \", ABS(K13)))","v":""},"","","","","","","","","","",{"$f":"IF(V13=\"\",\"\",CONCATENATE(IF(V13>0, \"● Improve \", \"● Worsen \"), V$96, \" by \", TEXT(ABS(V13),\"0%\")))","v":""},{"$f":"IF(W13=\"\",\"\",CONCATENATE(IF(W13>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W13)))","v":""},{"$f":"IF(X13=\"\",\"\",CONCATENATE(IF(X13>0, \"● Improve \", \"● Worsen \"), X$96, \" by \", ABS(X13)))","v":""},{"$f":"IF(Y13=\"\",\"\",CONCATENATE(IF(Y13>0, \"● Improve \", \"● Worsen \"), Y$96, \" by \", TEXT(ABS(Y13),\"0%\")))","v":""},{"$f":"IF(Z13=\"\",\"\",CONCATENATE(IF(Z13>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z13)))","v":""},{"$f":"IF(AA13=\"\",\"\",CONCATENATE(IF(AA13>0, \"● Improve \", \"● Worsen \"), AA$96, \" by \", ABS(AA13)))","v":""},"",{"$f":"CONCATENATE(IF(J97=\"\", \"\", CONCATENATE(J97, CHAR(10))), IF(K97=\"\", \"\", CONCATENATE(K97, CHAR(10))), IF(L97=\"\", \"\", CONCATENATE(L97, CHAR(10))), IF(M97=\"\", \"\", CONCATENATE(M97, CHAR(10))), IF(N97=\"\", \"\", CONCATENATE(N97, CHAR(10))), IF(O97=\"\", \"\", CONCATENATE(O97, CHAR(10))),  IF(P97=\"\", \"\", CONCATENATE(P97, CHAR(10))), IF(Q97=\"\", \"\", CONCATENATE(Q97, CHAR(10))),  IF(R97=\"\", \"\", CONCATENATE(R97, CHAR(10))), IF(S97=\"\", \"\", CONCATENATE(S97, CHAR(10))),  IF(T97=\"\", \"\", CONCATENATE(T97, CHAR(10))), IF(U97=\"\", \"\", CONCATENATE(U97, CHAR(10))), IF(V97=\"\", \"\", CONCATENATE(V97, CHAR(10))), IF(W97=\"\", \"\", CONCATENATE(W97, CHAR(10))), IF(X97=\"\", \"\", CONCATENATE(X97, CHAR(10))), IF(Y97=\"\", \"\", CONCATENATE(Y97, CHAR(10))), IF(Z97=\"\", \"\", CONCATENATE(Z97, CHAR(10))), IF(AA97=\"\", \"\", CONCATENATE(AA97, CHAR(10))), IF(AB97=\"\", \"\", CONCATENATE(AB97, CHAR(10))))","v":""}]
[null,null,null,2,{"$f":"E14","v":"User defined"},null,null,null,null,{"$f":"IF(J14=\"\",\"\",CONCATENATE(IF(J14>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J14)))","v":""},"","","","","","","","","","","",{"$f":"IF(V14=\"\",\"\",CONCATENATE(IF(V14>0, \"● Improve \", \"● Worsen \"), V$96, \" by \", TEXT(ABS(V14),\"0%\")))","v":""},{"$f":"IF(W14=\"\",\"\",CONCATENATE(IF(W14>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W14)))","v":""},"",{"$f":"IF(Y14=\"\",\"\",CONCATENATE(IF(Y14>0, \"● Improve \", \"● Worsen \"), Y$96, \" by \", TEXT(ABS(Y14),\"0%\")))","v":""},{"$f":"IF(Z14=\"\",\"\",CONCATENATE(IF(Z14>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z14)))","v":""},"","",{"$f":"CONCATENATE(IF(J98=\"\", \"\", CONCATENATE(J98, CHAR(10))), IF(K98=\"\", \"\", CONCATENATE(K98, CHAR(10))), IF(L98=\"\", \"\", CONCATENATE(L98, CHAR(10))), IF(M98=\"\", \"\", CONCATENATE(M98, CHAR(10))), IF(N98=\"\", \"\", CONCATENATE(N98, CHAR(10))), IF(O98=\"\", \"\", CONCATENATE(O98, CHAR(10))),  IF(P98=\"\", \"\", CONCATENATE(P98, CHAR(10))), IF(Q98=\"\", \"\", CONCATENATE(Q98, CHAR(10))),  IF(R98=\"\", \"\", CONCATENATE(R98, CHAR(10))), IF(S98=\"\", \"\", CONCATENATE(S98, CHAR(10))),  IF(T98=\"\", \"\", CONCATENATE(T98, CHAR(10))), IF(U98=\"\", \"\", CONCATENATE(U98, CHAR(10))), IF(V98=\"\", \"\", CONCATENATE(V98, CHAR(10))), IF(W98=\"\", \"\", CONCATENATE(W98, CHAR(10))), IF(X98=\"\", \"\", CONCATENATE(X98, CHAR(10))), IF(Y98=\"\", \"\", CONCATENATE(Y98, CHAR(10))), IF(Z98=\"\", \"\", CONCATENATE(Z98, CHAR(10))), IF(AA98=\"\", \"\", CONCATENATE(AA98, CHAR(10))), IF(AB98=\"\", \"\", CONCATENATE(AB98, CHAR(10))))","v":""}]
[null,null,null,3,"Manager mental health training",null,null,null,null,{"$f":"IF(J15=\"\",\"\",CONCATENATE(IF(J15>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J15)))","v":"● Improve confidence identifying mental health by 0.74"},"● Improve uptake of support services by 1.34","● Improve communication and awareness of support by 1.28","● Improve managers mental health knowledge by 1.45","● Improve destigmatisation by 0.31","","","","","","","","",{"$f":"IF(W15=\"\",\"\",CONCATENATE(IF(W15>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W15)))","v":""},"","",{"$f":"IF(Z15=\"\",\"\",CONCATENATE(IF(Z15>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z15)))","v":""},"","","● Improve confidence identifying mental health by 0.74\n● Improve uptake of support services by 1.34\n● Improve communication and awareness of support by 1.28\n● Improve managers mental health knowledge by 1.45\n● Improve destigmatisation by 0.31\n"]
[null,null,null,4,"Leadership development",null,null,null,null,{"$f":"IF(J16=\"\",\"\",CONCATENATE(IF(J16>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J16)))","v":""},"","","","","","● Worsen mental wellbeing (based on non RCTs) by 0.09","","","","","","",{"$f":"IF(W16=\"\",\"\",CONCATENATE(IF(W16>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W16)))","v":""},"● Improve job satisfaction (based on non RCTs) by 0.01","",{"$f":"IF(Z16=\"\",\"\",CONCATENATE(IF(Z16>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z16)))","v":""},"● Improve work climate (based on non RCTs) by 0.06","","● Worsen mental wellbeing (based on non RCTs) by 0.09\n● Improve job satisfaction (based on non RCTs) by 0.01\n● Improve work climate (based on non RCTs) by 0.06\n"]
[null,null,null,5,"Peer support",null,null,null,null,{"$f":"IF(J17=\"\",\"\",CONCATENATE(IF(J17>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J17)))","v":""},"","","","","● Improve mental wellbeing by 0.58","","","","","● Worsen job stress by 0.16","","",{"$f":"IF(W17=\"\",\"\",CONCATENATE(IF(W17>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W17)))","v":"● Improve job satisfaction by 0.57"},"","",{"$f":"IF(Z17=\"\",\"\",CONCATENATE(IF(Z17>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z17)))","v":""},"","","● Improve mental wellbeing by 0.58\n● Worsen job stress by 0.16\n● Improve job satisfaction by 0.57\n"]
[null,null,null,6,"Mental health first aider",null,null,null,null,{"$f":"IF(J18=\"\",\"\",CONCATENATE(IF(J18>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J18)))","v":""},"","","","","● Improve mental wellbeing by 0.06","","● Worsen mental health symptoms by 0.02","","● Improve mental health literacy by 0.53","","","",{"$f":"IF(W18=\"\",\"\",CONCATENATE(IF(W18>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W18)))","v":""},"","",{"$f":"IF(Z18=\"\",\"\",CONCATENATE(IF(Z18>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z18)))","v":""},"","","● Improve mental wellbeing by 0.06\n● Worsen mental health symptoms by 0.02\n● Improve mental health literacy by 0.53\n"]
[null,null,null,7,"Participatory approach ",null,null,null,null,{"$f":"IF(J19=\"\",\"\",CONCATENATE(IF(J19>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J19)))","v":""},"","","","","● Improve mental wellbeing by 0.45","","● Improve mental health symptoms by 0.01","● Improve mental health symptoms (based on non RCTs) by 0.14","","● Improve job stress by 0.34","● Improve job stress (based on non RCTs) by 0.15","● Worsen job stress (based on RCTs reporting relative risk) by 27%",{"$f":"IF(W19=\"\",\"\",CONCATENATE(IF(W19>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W19)))","v":"● Improve job satisfaction by 0.19"},"","● Improve job satisfaction (based on RCTs reporting relative risk) by 22%",{"$f":"IF(Z19=\"\",\"\",CONCATENATE(IF(Z19>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z19)))","v":"● Improve work climate by 0.18"},"● Improve work climate (based on non RCTs) by 0.02","","● Improve mental wellbeing by 0.45\n● Improve mental health symptoms by 0.01\n● Improve mental health symptoms (based on non RCTs) by 0.14\n● Improve job stress by 0.34\n● Improve job stress (based on non RCTs) by 0.15\n● Worsen job stress (based on RCTs reporting relative risk) by 27%\n● Improve job satisfaction by 0.19\n● Improve job satisfaction (based on RCTs reporting relative risk) by 22%\n● Improve work climate by 0.18\n● Improve work climate (based on non RCTs) by 0.02\n"]
[null,null,null,8,"Targeted cognitive behavioural theory",null,null,null,null,{"$f":"IF(J20=\"\",\"\",CONCATENATE(IF(J20>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J20)))","v":""},"","","","","● Improve mental wellbeing by 0.48","","● Improve mental health symptoms by 0.36","","● Improve mental health literacy by 0.02","● Improve job stress by 0.15","","",{"$f":"IF(W20=\"\",\"\",CONCATENATE(IF(W20>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W20)))","v":"● Worsen job satisfaction by 0.09"},"","",{"$f":"IF(Z20=\"\",\"\",CONCATENATE(IF(Z20>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z20)))","v":""},"","","● Improve mental wellbeing by 0.48\n● Improve mental health symptoms by 0.36\n● Improve mental health literacy by 0.02\n● Improve job stress by 0.15\n● Worsen job satisfaction by 0.09\n"]
[null,null,null,9,"Targeted mindfulness",null,null,null,null,{"$f":"IF(J21=\"\",\"\",CONCATENATE(IF(J21>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J21)))","v":""},"","","","","● Improve mental wellbeing by 0.57","","● Improve mental health symptoms by 0.61","","","● Improve job stress by 0.91","","",{"$f":"IF(W21=\"\",\"\",CONCATENATE(IF(W21>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W21)))","v":""},"","",{"$f":"IF(Z21=\"\",\"\",CONCATENATE(IF(Z21>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z21)))","v":""},"","","● Improve mental wellbeing by 0.57\n● Improve mental health symptoms by 0.61\n● Improve job stress by 0.91\n"]
[null,null,null,10,"Targeted digital/online stress management",null,null,null,null,{"$f":"IF(J22=\"\",\"\",CONCATENATE(IF(J22>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J22)))","v":""},"","","","","","","● Improve mental health symptoms by 0.77","","● Improve mental health literacy by 0.51","● Improve job stress by 0.83","","",{"$f":"IF(W22=\"\",\"\",CONCATENATE(IF(W22>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W22)))","v":"● Improve job satisfaction by 0.2"},"","",{"$f":"IF(Z22=\"\",\"\",CONCATENATE(IF(Z22>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z22)))","v":""},"","● Improve quality of life by 0.58","● Improve mental health symptoms by 0.77\n● Improve mental health literacy by 0.51\n● Improve job stress by 0.83\n● Improve job satisfaction by 0.2\n● Improve quality of life by 0.58\n"]
[null,null,null,11,0,null,null,null,null,{"$f":"IF(J23=\"\",\"\",CONCATENATE(IF(J23>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J23)))","v":""},"","","","","","","","","","","","",{"$f":"IF(W23=\"\",\"\",CONCATENATE(IF(W23>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W23)))","v":""},"","",{"$f":"IF(Z23=\"\",\"\",CONCATENATE(IF(Z23>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z23)))","v":""},"","",""]
[null,null,null,12,0,null,null,null,null,{"$f":"IF(J24=\"\",\"\",CONCATENATE(IF(J24>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J24)))","v":""},"","","","","","","","","","","","",{"$f":"IF(W24=\"\",\"\",CONCATENATE(IF(W24>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W24)))","v":""},"","",{"$f":"IF(Z24=\"\",\"\",CONCATENATE(IF(Z24>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z24)))","v":""},"","",""]
[null,null,null,13,0,null,null,null,null,{"$f":"IF(J25=\"\",\"\",CONCATENATE(IF(J25>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J25)))","v":""},"","","","","","","","","","","","",{"$f":"IF(W25=\"\",\"\",CONCATENATE(IF(W25>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W25)))","v":""},"","",{"$f":"IF(Z25=\"\",\"\",CONCATENATE(IF(Z25>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z25)))","v":""},"","",""]
[null,null,null,14,0,null,null,null,null,{"$f":"IF(J26=\"\",\"\",CONCATENATE(IF(J26>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J26)))","v":""},"","","","","","","","","","","","",{"$f":"IF(W26=\"\",\"\",CONCATENATE(IF(W26>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W26)))","v":""},"","",{"$f":"IF(Z26=\"\",\"\",CONCATENATE(IF(Z26>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z26)))","v":""},"","",""]
[null,null,null,15,0,null,null,null,null,{"$f":"IF(J27=\"\",\"\",CONCATENATE(IF(J27>0, \"● Improve \", \"● Worsen \"), J$96, \" by \", ABS(J27)))","v":""},"","","","","","","","","","","","",{"$f":"IF(W27=\"\",\"\",CONCATENATE(IF(W27>0, \"● Improve \", \"● Worsen \"), W$96, \" by \", ABS(W27)))","v":""},"","",{"$f":"IF(Z27=\"\",\"\",CONCATENATE(IF(Z27>0, \"● Improve \", \"● Worsen \"), Z$96, \" by \", ABS(Z27)))","v":""},"","",""]
[]
[]
[]
[]
[]
[null,null,null,"DEFAULT VALUES"]
[null,null,null,"ID","Intervention type","Description","Employer outcomes",null,null,"Employee outcomes"]
[null,null,null,null,null,null,"Reduction in absenteeism (days)","Reduction in presenteeism (days)","Reduction in staff turnover (point %)","Confidence identifying mental health","Uptake of support services","Communication and awareness of support","Managers mental health knowledge","Destigmatisation","Mental wellbeing","Mental wellbeing (based on non RCTs)","Mental health symptoms","Mental health symptoms (based on non RCTs)","Mental health literacy","Job stress","Job stress (based on non RCTs)","Job stress (based on RCTs reporting relative risk)","Job satisfaction","Job satisfaction (based on non RCTs)","Job satisfaction (based on RCTs reporting relative risk)","Work climate","Work climate (based on non RCTs)","Quality of life"]
[null,null,null,1,"Case study: Multicomponent health promotion","Mills (2007)",4.3,9.1999999999999993]
[null,null,null,2,"User defined","User defined"]
[null,null,null,3,"Manager mental health training","Universal manager-level",null,null,null,0.74,1.34,1.28,1.45,0.31]
[null,null,null,4,"Leadership development","Universal organisational-level",null,null,null,null,null,null,null,null,null,-0.09,null,null,null,null,null,null,null,0.01,null,null,0.06]
[null,null,null,5,"Peer support","Universal organisational-level",null,null,null,null,null,null,null,null,0.57999999999999996,null,null,null,null,-0.16,null,null,0.56999999999999995]
[null,null,null,6,"Mental health first aider","Universal organisational-level",null,null,null,null,null,null,null,null,0.06,null,-0.02,null,0.53]
[null,null,null,7,"Participatory approach ","Universal organisational-level",null,null,null,null,null,null,null,null,0.45,null,0.01,0.14000000000000001,null,0.34,0.15,-0.27,0.19,null,0.22,0.18,0.02]
[null,null,null,8,"Targeted cognitive behavioural theory","Targeted individual-level",1.83,4.03,null,null,null,null,null,null,0.48,null,0.36,null,0.02,0.15,null,null,-0.09]
[null,null,null,9,"Targeted mindfulness","Targeted individual-level",2.29,null,null,null,null,null,null,null,0.56999999999999995,null,0.61,null,null,0.91]
[null,null,null,10,"Targeted digital/online stress management","Targeted individual-level",0.71,1.82,null,null,null,null,null,null,null,null,0.77,null,0.51,0.83,null,null,0.2,null,null,null,null,0.57999999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1.2E-2]
[null,null,null,"Number of days lost per person (absenteeism)",1.4999999999999999E-2]
[null,null,null,null,0.02]
[null,null,null,"16-24",2.8000000000000001E-2]
[null,null,null,"25-34",2.3E-2]
[null,null,null,"35-49"]
[null,null,null,"50-64"]
[null,null,null,"65+","Number employed (000s)"]
[null,null,null,null,29894]
[null,null,null,"http://www.ons.gov.uk/ons/dcp171778_412021.pdf",1140]
[null,null,null,null,{"$f":"SUM(E179:E180)","v":31034}]
[null,null,null,"16-65"]
[null,null,null,"65+"]
[]
[null,null,null,null,"CPI"]
[null,null,null,null,103.7]
[null,null,null,null,128.5]
[null,null,null,null,{"$f":"E187/E186","v":1.2391513982642237}]
[null,null,null,"2007 Q1",{"$f":"11625*E188","v":14405.135004821601}]
[null,null,null,"2015 Dec"]
[null,null,null,null,{"$f":"528*52","v":27456}]
[]
[]
[]
[null,null,null,null,null,{"$f":"E179/E181","v":0.96326609525037055}]
[null,null,null,null,null,{"$f":"E180/E181","v":3.673390474962944E-2}]
[null,null,null,null,null,{"$f":"SUM(F195:F196)","v":1}]

{"sheet":"Cost Breakdown","index":4,"n_rows":177,"n_cols":6,"rows_kept":177,"cut":false,"hidden":false,"merged":[[3,2,3,3],[12,3,12,4],[7,3,8,4]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Cost breakdown"]
[null,null,null,"If a breakdown of the costs associated with the intervention is available, this section can be used to calculate the overall cost of the intervention."]
[]
[null,null,null,null,"User defined"]
[null,null,null,"Participation costs"]
[null,null,null,"Delivery costs"]
[null,null,null,"Other costs"]
[null,null,null,"Premises hire"]
[null,null,null,"Equipment hire"]
[null,null,null,"Travel expenses"]
[null,null,null,"Accommodation, subsistence etc."]
[null,null,null,"Printing, books, materials etc."]
[null,null,null,"Other"]
[null,null,null,"Total intervention costs",{"$f":"SUM(E11:E19)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1.2E-2]
[null,null,null,"Number of days lost per person (absenteeism)",1.4999999999999999E-2]
[null,null,null,null,0.02]
[null,null,null,"16-24",2.8000000000000001E-2]
[null,null,null,"25-34",2.3E-2]
[null,null,null,"35-49"]
[null,null,null,"50-64"]
[null,null,null,"65+","Number employed (000s)"]
[null,null,null,null,29894]
[null,null,null,"http://www.ons.gov.uk/ons/dcp171778_412021.pdf",1140]
[null,null,null,null,{"$f":"SUM(E162:E163)","v":31034}]
[null,null,null,"16-65"]
[null,null,null,"65+"]
[]
[null,null,null,null,"CPI"]
[null,null,null,null,103.7]
[null,null,null,null,128.5]
[null,null,null,null,{"$f":"E170/E169","v":1.2391513982642237}]
[null,null,null,"2007 Q1",{"$f":"11625*E171","v":14405.135004821601}]
[null,null,null,"2015 Dec"]
[null,null,null,null,{"$f":"528*52","v":27456}]
[null,null,null,null,null,{"$f":"E162/E164","v":0.96326609525037055}]
[null,null,null,null,null,{"$f":"E163/E164","v":3.673390474962944E-2}]
[null,null,null,null,null,{"$f":"SUM(F175:F176)","v":1}]

{"sheet":"Base case","index":5,"n_rows":137,"n_cols":22,"rows_kept":137,"cut":false,"hidden":false,"merged":[[112,3,121,4],[111,3,111,4],[34,3,39,4],[3,2,3,3],[23,3,23,4],[24,3,33,4],[22,3,22,4]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(Inputs!E15=\"Case study: Multicomponent health promotion\", \"The results are based on an unspecified mental wellbeing intervention.\", CONCATENATE(\"The results are based on a \",Inputs!G15, \" intervention.\"))","v":"The results are based on a manager mental health training intervention."}]
[null,null,null,"All results should be interpreted with caution."]
[]
[null,null,null,null,"One-year time horizon,"]
[null,null,null,null,{"$f":"CONCATENATE(\"per \",Inputs!AF12, \" employees\")","v":"per 50 employees"}]
[null,null,null,null,"Incremental cost"]
[null,null,null,"Cost of absenteeism",{"$f":"-Inputs!AF12*Inputs!AF17*Inputs!AF18","v":0}]
[null,null,null,"Cost of presenteeism",{"$f":"-Inputs!AF12*Inputs!AF21*Inputs!AF22","v":0}]
[null,null,null,"Cost of staff turnover",{"$f":"-Inputs!AF12*Inputs!AF25*Inputs!AF26","v":0}]
[null,null,null,"Intervention cost",{"$f":"Inputs!AF14*Inputs!AF12","v":5000}]
[null,null,null,"Total cost",{"$f":"SUM(E16:E19)","v":5000}]
[null,null,null,"Cost per person",{"$f":"E20/Inputs!E17","v":100}]
[]
[null,null,null,"Employee outcomes"]
[null,null,null,{"$f":"IF(D25=\"\",\"There is no evidence relating to employee outcomes.\", \"The intervention would:\")","v":"The intervention would:"}]
[null,null,null,"● Improve confidence identifying mental health by 0.74\n● Improve uptake of support services by 1.34\n● Improve communication and awareness of support by 1.28\n● Improve managers mental health knowledge by 1.45\n● Improve destigmatisation by 0.31\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(D25=\"\", \"\",IF(Inputs!E15=\"user defined\",\"\",E102))","v":"Changes in employee outcomes are expressed in term of the standardised mean difference, unless otherwise stated.\nRCT = randomised control trial"}]
[null,null,null,null,null,null,null,"NB: Data are not available for all outcomes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The results shown are limited to the "]
[]
[]
[null,null,null,{"$f":"IF(Inputs!E117=1,\"absenteeism\",\"\")","v":""},{"$f":"IF(D84=\"\",0,1)","v":0},1]
[null,null,null,{"$f":"IF(Inputs!E118=1,\"presenteeism\",\"\")","v":""},{"$f":"IF(D85=\"\",0,1)","v":0},2]
[null,null,null,{"$f":"IF(Inputs!E119=1,\"staff turnover\",\"\")","v":""},{"$f":"IF(D86=\"\",0,1)","v":0},3]
[null,null,null,{"$f":"SUM(E84:E86)","v":0}]
[null,null,null,{"$f":"VLOOKUP(0,E84:F86,2,FALSE)","v":1}]
[null,null,null,"absenteeism and the cost of the intervention.  However, subject to relevant data being available the user can include productivity and change in staff turnover in the results. "]
[]
[null,null,null,{"$f":"IF(D87=1,1,IF(D87=3,5,IF(D88=1,2,IF(D88=2,3,4))))","v":2}]
[]
[null,null,null,1,{"$f":"CONCATENATE(\"The employer outcomes are limited to the cost of \",D84,D85,D86,\" only.\")","v":"The employer outcomes are limited to the cost of  only."}]
[null,null,null,2,"The employer outcomes are limited to the costs of presenteeism and staff turnover."]
[null,null,null,3,"The employer outcomes are limited to the costs of absenteeism and staff turnover."]
[null,null,null,4,"The employer outcomes are limited to the costs of absenteeism and presenteeism."]
[null,null,null,5,"The employer outcomes are limited to the costs of absenteeism, presenteeism and staff turnover."]
[]
[]
[null,null,null,null,"Changes in employee outcomes are expressed in term of the standardised mean difference, unless otherwise stated."]
[null,null,null,null,"RCT = randomised control trial"]
[null,null,null,null,{"$f":"CONCATENATE(E100, CHAR(10),E101)","v":"Changes in employee outcomes are expressed in term of the standardised mean difference, unless otherwise stated.\nRCT = randomised control trial"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Employee Outcomes"]
[null,null,null,{"$f":"VLOOKUP(Inputs!E15,'Inputs Interventions'!E97:AC111,25, FALSE)","v":"● Improve confidence identifying mental health by 0.74\n● Improve uptake of support services by 1.34\n● Improve communication and awareness of support by 1.28\n● Improve managers mental health knowledge by 1.45\n● Improve destigmatisation by 0.31\n"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Slider chart on/off switch",2]
[null,null,null,"1 = on, 2= off"]
[]
[null,null,null,"Impact"]
[]
[]
[]
[null,null,null,"Confidence identifying mental health","Uptake of support services","Communication and awareness of support","Managers mental health knowledge","Destigmatisation","Mental wellbeing","Mental wellbeing (based on non RCTs)","Mental health symptoms","Mental health symptoms (based on non RCTs)","Mental health literacy","Job stress","Job stress (based on non RCTs)","Job stress (based on RCTs reporting relative risk)","Job satisfaction","Job satisfaction (based on non RCTs)","Job satisfaction (based on RCTs reporting relative risk)","Work climate","Work climate (based on non RCTs)","Quality of life"]
[null,null,null,{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,6, FALSE)","v":0.74},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,7, FALSE)","v":1.34},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,8, FALSE)","v":1.28},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,9, FALSE)","v":1.45},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,10, FALSE)","v":0.31},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,11, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,12, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,13, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,14, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,15, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,16, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,17, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,18, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,19, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,20, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,21, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,22, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,23, FALSE)","v":0},{"$f":"VLOOKUP(Inputs!$E$15,'Inputs Interventions'!$E$13:$AB$22,24, FALSE)","v":0}]
[null,null,null,{"$f":"IF(D135<0,D135,\"\")","v":""},{"$f":"IF(E135<0,E135,\"\")","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(D135>0,D135,\"\")","v":0.74},{"$f":"IF(E135>0,E135,\"\")","v":1.34},1.28,1.45,0.31,"","","","","","","","","","","","","",""]

{"sheet":"SA","index":6,"n_rows":137,"n_cols":49,"rows_kept":137,"cut":false,"hidden":false,"merged":[[3,2,3,3],[121,3,121,7]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before","After","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism",25502.399999999998,22952.16,-2550.239999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income from increased productivity",1185660,1197516.6000000001,-11856.600000000093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of staff turnover",50986.106557377047,42063.537909836065,-8922.5686475409821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Societal costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention cost",0,6000,6000]
[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",1262148.5065573771,1268532.2979098361,-17329.408647541073]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(F125<0,\"Assuming all other inputs remain the same, the intervention cannot be cost saving at any given cost per intervention\",CONCATENATE(\"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when the cost of the intervention per person is \",TEXT(F125,\"£#,##0\")))","v":"Assuming all other inputs remain the same, the intervention cannot be cost saving at any given cost per intervention"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Death",true,{"$f":"IF(AV37=TRUE,E38,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cost of intervention per person"]
[null,null,null,null,{"$f":"Inputs!D19","v":"Absenteeism (sick leave)"}]
[null,null,null,null,{"$f":"Inputs!D23","v":"Presenteeism"}]
[null,null,null,null,{"$f":"Inputs!D27","v":"Staff turnover"}]
[]
[]
[]
[null,null,null,null,4]
[]
[null,null,null,"Calculating cost neutral value"]
[null,null,null,"No of employees",{"$f":"Inputs!AF12","v":50},50,"Cost of absenteeism",{"$f":"-F123*F128*F129","v":-7698.9999999999991}]
[null,null,null,null,null,null,"Cost of presenteeism",{"$f":"-F123*F132*F133","v":-15397.999999999998}]
[null,null,null,"Cost of intervention per person",{"$f":"Inputs!AF14","v":100},-287.24550000000011,"Cost of staff turnover",{"$f":"-F123*F136*F137","v":37459.275000000001}]
[null,null,null,null,null,null,"Intervention cost",{"$f":"F123*F125","v":-14362.275000000005}]
[null,null,null,null,null,null,"Total cost",{"$f":"SUM(H123:H126)","v":0}]
[null,null,null,"Cost of absenteeism per day",{"$f":"Inputs!AF17","v":153.97999999999999},153.97999999999999]
[null,null,null,"Reduction in absenteeism",{"$f":"Inputs!AF18","v":0},1]
[]
[]
[null,null,null,"Cost of presenteeism per day",{"$f":"Inputs!AF21","v":307.95999999999998},307.95999999999998]
[null,null,null,"Reduction in presenteeism",{"$f":"Inputs!AF22","v":0},1]
[]
[]
[null,null,null,"Cost per case of staff turnover",{"$f":"Inputs!AF25","v":14983.71},14983.71]
[null,null,null,"Reduction in staff turnover",{"$f":"Inputs!AF26","v":0},-0.05]

{"sheet":"SAAbs","index":7,"n_rows":137,"n_cols":49,"rows_kept":137,"cut":false,"hidden":false,"merged":[[3,2,3,3],[121,3,121,7]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before","After","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism",25502.399999999998,22952.16,-2550.239999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income from increased productivity",1185660,1197516.6000000001,-11856.600000000093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of staff turnover",50986.106557377047,42063.537909836065,-8922.5686475409821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Societal costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention cost",0,6000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",1262148.5065573771,1268532.2979098361,-17329.408647541073]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is \", IF(F129<0, \"an increase \", \"a reduction \"), \"in absenteeism of \",ABS(ROUND(F129,1)), \" days\")","v":"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is a reduction in absenteeism of 3.5 days"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Death",true,{"$f":"IF(AV37=TRUE,E38,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cost of intervention per person"]
[null,null,null,null,"Absenteeism"]
[null,null,null,null,"Productivity"]
[null,null,null,null,"Staff turnover"]
[null,null,null,null,"Health care costs"]
[null,null,null,null,"Other societal costs"]
[null,null,null,null,5]
[]
[]
[null,null,null,"Calculating cost neutral value"]
[null,null,null,"No of employees",{"$f":"Inputs!AF12","v":50},50,"Cost of absenteeism",{"$f":"-F123*F128*F129","v":-27061.275000000012}]
[null,null,null,null,null,null,"Cost of presenteeism",{"$f":"-F123*F132*F133","v":-15397.999999999998}]
[null,null,null,"Cost of intervention per person",{"$f":"Inputs!AF14","v":100},100,"Cost of staff turnover",{"$f":"-F123*F136*F137","v":37459.275000000001}]
[null,null,null,null,null,null,"Intervention cost",{"$f":"F123*F125","v":5000}]
[null,null,null,null,null,null,"Total cost",{"$f":"SUM(H123:H126)","v":-7.2759576141834259E-12}]
[null,null,null,"Cost of absenteeism per day",{"$f":"Inputs!AF17","v":153.97999999999999},153.97999999999999]
[null,null,null,"Reduction in absenteeism",{"$f":"Inputs!AF18","v":0},3.514907780231201]
[]
[]
[null,null,null,"Cost of presenteeism per day",{"$f":"Inputs!AF21","v":307.95999999999998},307.95999999999998]
[null,null,null,"Reduction in presenteeism",{"$f":"Inputs!AF22","v":0},1]
[]
[]
[null,null,null,"Cost per case of staff turnover",{"$f":"Inputs!AF25","v":14983.71},14983.71]
[null,null,null,"Reduction in staff turnover",{"$f":"Inputs!AF26","v":0},-0.05]

{"sheet":"SAProd","index":8,"n_rows":137,"n_cols":49,"rows_kept":137,"cut":false,"hidden":false,"merged":[[3,2,3,3],[121,3,121,7]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before","After","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism",25502.399999999998,22952.16,-2550.239999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income from increased productivity",1185660,1197516.6000000001,-11856.600000000093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of staff turnover",50986.106557377047,42063.537909836065,-8922.5686475409821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Societal costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention cost",0,6000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",1262148.5065573771,1268532.2979098361,-17329.408647541073]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is \", IF(F133<0, \"an increase \", \"a reduction \"), \"in presenteeism of \",ABS(ROUND(F133,1)), \" days\")","v":"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is a reduction in presenteeism of 2.3 days"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Death",true,{"$f":"IF(AV37=TRUE,E38,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cost of intervention per person"]
[null,null,null,null,"Absenteeism"]
[null,null,null,null,"Productivity"]
[null,null,null,null,"Staff turnover"]
[null,null,null,null,"Health care costs"]
[null,null,null,null,"Other societal costs"]
[null,null,null,null,3]
[]
[]
[null,null,null,"Calculating cost neutral value"]
[null,null,null,"No of employees",{"$f":"Inputs!AF12","v":50},50,"Cost of absenteeism",{"$f":"-F123*F128*F129","v":-7698.9999999999991}]
[null,null,null,null,null,null,"Cost of presenteeism",{"$f":"-F123*F132*F133","v":-34760.275000000001}]
[null,null,null,"Cost of intervention per person",{"$f":"Inputs!AF14","v":100},100,"Cost of staff turnover",{"$f":"-F123*F136*F137","v":37459.275000000001}]
[null,null,null,null,null,null,"Intervention cost",{"$f":"F123*F125","v":5000}]
[null,null,null,null,null,null,"Total cost",{"$f":"SUM(H123:H126)","v":0}]
[null,null,null,"Cost of absenteeism per day",{"$f":"Inputs!AF17","v":153.97999999999999},153.97999999999999]
[null,null,null,"Reduction in absenteeism",{"$f":"Inputs!AF18","v":0},1]
[]
[]
[null,null,null,"Cost of presenteeism per day",{"$f":"Inputs!AF21","v":307.95999999999998},307.95999999999998]
[null,null,null,"Reduction in presenteeism",{"$f":"Inputs!AF22","v":0},2.2574538901155998]
[]
[]
[null,null,null,"Cost per case of staff turnover",{"$f":"Inputs!AF25","v":14983.71},14983.71]
[null,null,null,"Reduction in staff turnover",{"$f":"Inputs!AF26","v":0},-0.05]

{"sheet":"SATurnover","index":9,"n_rows":137,"n_cols":49,"rows_kept":137,"cut":false,"hidden":false,"merged":[[3,2,3,3],[121,3,121,7]]}
[]
[]
[]
[null,null,"XXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before","After","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of absenteeism",25502.399999999998,22952.16,-2550.239999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Income from increased productivity",1185660,1197516.6000000001,-11856.600000000093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of staff turnover",50986.106557377047,42063.537909836065,-8922.5686475409821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Healthcare costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Societal costs",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intervention cost",0,6000,6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",1262148.5065573771,1268532.2979098361,-17329.408647541073]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is \", IF(F137<0, \"an increase \", \"a reduction \"), \"in staff turnover of \",ROUND(ABS(F137*100),1), \"%\")","v":"Assuming all other inputs remain the same, the intervention is cost neutral (i.e. the incremental costs are zero) when there is an increase in staff turnover of 2.4%"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Death",true,{"$f":"IF(AV37=TRUE,E38,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cost of intervention per person"]
[null,null,null,null,"Absenteeism"]
[null,null,null,null,"Productivity"]
[null,null,null,null,"Staff turnover"]
[null,null,null,null,"Health care costs"]
[null,null,null,null,"Other societal costs"]
[null,null,null,null,3]
[]
[]
[null,null,null,"Calculating cost neutral value"]
[null,null,null,"No of employees",{"$f":"Inputs!AF12","v":50},50,"Cost of absenteeism",{"$f":"-F123*F128*F129","v":-7698.9999999999991}]
[null,null,null,null,null,null,"Cost of presenteeism",{"$f":"-F123*F132*F133","v":-15397.999999999998}]
[null,null,null,"Cost of intervention per person",{"$f":"Inputs!AF14","v":100},100,"Cost of staff turnover",{"$f":"-F123*F136*F137","v":18096.999999999993}]
[null,null,null,null,null,null,"Intervention cost",{"$f":"F123*F125","v":5000}]
[null,null,null,null,null,null,"Total cost",{"$f":"SUM(H123:H126)","v":0}]
[null,null,null,"Cost of absenteeism per day",{"$f":"Inputs!AF17","v":153.97999999999999},153.97999999999999]
[null,null,null,"Reduction in absenteeism",{"$f":"Inputs!AF18","v":0},1]
[]
[]
[null,null,null,"Cost of presenteeism per day",{"$f":"Inputs!AF21","v":307.95999999999998},307.95999999999998]
[null,null,null,"Reduction in presenteeism",{"$f":"Inputs!AF22","v":0},1]
[]
[]
[null,null,null,"Cost per case of staff turnover",{"$f":"Inputs!AF25","v":14983.71},14983.71]
[null,null,null,"Reduction in staff turnover",{"$f":"Inputs!AF26","v":0},-2.4155566278311572E-2]