{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1. Designing","Fig 1. COM-B model","2. Describing","Fig 2. Logic frame","3. Measuring","4. Evaluating","5. Summary","behind the scenes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"1. Designing","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,2,8,2],[21,2,26,2],[15,2,20,2],[9,2,14,2]]}
[null,null,null,null,"Enter text below  ß\nInclude drivers AND barriers as appropriate. Leave cells blank if all 6 rows are not required.","Brief explanatory notes/examples (NB this is a work in progress)"]
[null,null,"What is the problem you have identified and are seeking to address?"]
["Behavior",null,"Thinking specifically of the individuals in the group towards which the intervention is targeted: What behaviour would need to change in order for the intervention to meet the aim specified above? (for example, attendance at vaccination clinic, completion of consent form)."]
["Capability (individual)","Physical and psychological","Physical and psychological capabilities\nThinking specifically of the individuals in the group towards which the intervention is targeted: Are there any abilities (either physical, mental or emotional) that could influence the behaviour in question? (For example, knowledge of disease or vaccine, current state of health).","1.",null,"Knowledge"]
[null,null,null,"2.",null,"Skills, trust in own skills"]
[null,null,null,"3.",null,"Resilience, stamina, will power, surplus energy"]
[null,null,null,"4.",null,"Physical fitness, ability"]
[null,null,null,"5."]
[null,null,null,"6."]
["Motivation (individual)","Automatic and reflective","Automatic and reflective motivations\nThinking specifically of the individuals in the group towards which the intervention is targeted:  Are there any desires to act (such as impulses, emotions, intentions or beliefs) that could influence the behaviour in question? (For example, risk perception of disease and/or vaccine, confidence, concerns or worries).","1.",null,"Attitudes, perceptions, risk assessment"]
[null,null,null,"2.",null,"Intentions"]
[null,null,null,"3.",null,"Values, beliefs"]
[null,null,null,"4.",null,"Emotions, impulses, feelings"]
[null,null,null,"5.",null,"Confidence, trust"]
[null,null,null,"6."]
["Opportunity (contextual)","Social","Social opportunities \nConsidering the context in which the intervention is planned to take place: Are there any social circumstances that could influence the behaviour in question? (For example, social, community and cultural support, values and norms such as religious beliefs or stigma).","1.",null,"Cultural demands, support"]
[null,null,null,"2.",null,"Cultural cues, norms, values"]
[null,null,null,"3."]
[null,null,null,"4."]
[null,null,null,"5."]
[null,null,null,"6."]
[null,"Physical","Physical opportunities\nConsidering the context in which the intervention is planned to take place: are there any situational circumstances involving time, resources and/or locations that could influence the behaviour in question? (For example, legislation, delivery system, vaccine supply, qualified staff, financial resources).","1.",null,"Access, affordability, availability of vaccination"]
[null,null,null,"2.",null,"Convenience, appeal, appropriateness of vaccination"]
[null,null,null,"3.",null,"Rights, regulation, legislation"]
[null,null,null,"4."]
[null,null,null,"5."]
[null,null,null,"6."]

{"sheet":"Fig 1. COM-B model","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2. Describing","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,0,37,0],[4,0,7,0],[9,0,12,0],[14,0,17,0],[19,0,22,0],[29,0,32,0],[24,0,27,0]]}
[null,null,"Enter text below ß\nLeave cells blank if all 5 rows are not required.","Brief explanatory notes/examples (NB this is a work in progress)"]
["What is the title of the intervention? \n(This may be provisional and changed at a later date)."]
["What is the aim of the intervention?"]
["Inputs","1.",null,"Financial resources"]
["What are the resources that will be necessary for the proposed intervention to be implemented? (For example, financial and human resources, training and so on)","2.",null,"E consent intervention functioning"]
[null,"3.",null,"Trained immunisation teams (intervention)"]
[null,"4.",null,"Resources for informing and mobilizing schools"]
[null,"5."]
["Activities","1.",null,"Schools send e-consent invite to parents"]
["What will take place as part of the intervention? (For example, resources supplied in a new format, clinics open extended hours.)","2.",null,"Parents receive e-consent online portal weblink"]
[null,"3."]
[null,"4."]
[null,"5."]
["Pathways","1.",null,"Parents and adolescents read e-consent and information materials"]
["What linking actions are necessary in order for the activities above to lead to the outputs, outcomes and impacts described below? (For example, completion of questionnaires, attendance at events.)","2.",null,"Parents and adolescents discuss HPV vaccination"]
[null,"3.",null,"Parents complete E consent form"]
[null,"4."]
[null,"5."]
["Outputs","1.",null,"Immunisation teams receive e-consent forms and prepare for sessions"]
["What are the staged activities for particular groups of people that are planned and implemented as a result of the inputs, activities and pathways mentioned above? Include detail on the activities and the participation.","2.",null,"Adolescents attend immunisation sessions"]
[null,"3."]
[null,"4."]
[null,"5."]
["Short-term outcomes","1.",null,"Increased return of consent forms"]
["Results of the intervention relevant to a short time frame. ","2."]
[null,"3."]
[null,"4."]
[null,"5."]
["Medium-term outcomes","1."]
["Results of the intervention relevant to a longer time frame (it may help to link the medium-term outcomes to the short-term outcomes mentioned above).","2."]
[null,"3."]
[null,"4."]
[null,"5."]
["Impacts","1.",null,"Increased uptake of HPV vaccination"]
["Long-term results brought about by the intervention.","2."]
[null,"3."]
[null,"4."]
[null,"5."]

{"sheet":"Fig 2. Logic frame","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3. Measuring","index":4,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Evaluation question","Output or outcome \n(list from Logic model)","Measure","Timepoints to be measured \n(for example, baseline, 3, 6, 12 months)","Data source","Routinely collected \nor study-specific ","Ethical \nconsiderations?","Actions/next steps","Who is responsible?"]

{"sheet":"4. Evaluating","index":5,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[null,null,"Please select your level of evaluation Þ\nThe evaluation seeks to understand whether or not your intervention has had an impact, and why this is the case.","Optimal","Level of Evaluation","Type of Evaluation"]
[null,null,null,null,{"$f":"IF(D1=\"Essential\",\"Essential\",\"\")","v":""},{"$f":"IF(OR(D39=\"Process\",D39=\"Process and Impact\",D39=\"Process and Economic\",D39=\"Process, Impact and Economic\"),\"Process\",\"not process\")","v":"Process"}]
[null,null,null,null,{"$f":"IF(D1=\"Essential\",\"Essential\",\"\")","v":""},{"$f":"IF(OR(D39=\"Impact\",D39=\"Process and Impact\",D39=\"Impact and Economic\"),\"Impact\",\"not impact\")","v":"Impact"}]
[null,null,null,"Enter text below ß\nPale grey cells are autopopulated based on your entries into previous form(s)",{"$f":"IF(D1=\"Essential\",\"Essential\",\"\")","v":""},{"$f":"IF(OR(D39=\"Process\",D39=\"Impact\",D39=\"Process and Impact\"),\"All\",\"\")","v":"All"}]
["Level of Evaluation","Type of Evaluation","Part 1: Overview of intervention details"]
["Essential","All","Title or name of intervention",{"$f":"'2. Describing'!C2","v":0}]
["Essential","All","Contact details for project lead"]
["Essential","All","Contact details for key people involved with planning, delivery and evaluation of the intervention"]
["Essential","All","Commissioners of the intervention and sources of funding"]
["Optimal","All","Declaration of interests"]
["Essential","All","Aim",{"$f":"'2. Describing'!C3","v":0}]
["Essential","All",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,\"Objectives (consider activities and pathways):\",'behind the scenes'!E3,'behind the scenes'!E4)","v":"Objectives (consider activities and pathways):\n•\n•"}]
["Essential","All","Short-term outcomes",{"$f":"'behind the scenes'!E6","v":"•"}]
["Essential","All","Medium-term outcomes",{"$f":"'behind the scenes'!E7","v":"•"}]
["Essential","All","Long-term results brought about by the intervention",{"$f":"'behind the scenes'!E8","v":"•"}]
["Essential","All","1a: Intervention description and wider context"]
["Essential","All","Rationale for intervention (why?)\n(Refer to problem statement, capability, opportunity and motivation in COM-B model if relevant. You may wish to refer to any equality impact assessments that have been performed)"]
["Optimal","All","Relevant policy and performance context"]
["Optimal","All","Details of health needs assessments that have been conducted"]
["Essential","All","Short summary description of intervention\n(for example, what? how? and for who? - refer to logic frame figure)"]
["Essential","All","Locations and settings (where?)"]
["Essential","All","Intervention timescale\n(when? Intervention duration, frequency and number of sessions provided)"]
["Essential","All","Intervention delivery dates"]
["Optimal","All","Duration of funding of specific intervention (including dates)"]
["Essential","All","1b: Resources required"]
["Essential","All",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,\"Intervention staff and core competencies required (consider Logic Frame 'inputs'):\",'behind the scenes'!E2)","v":"Intervention staff and core competencies required (consider Logic Frame 'inputs'):\n•"}]
["Essential","All",{"$f":"_xlfn.TEXTJOIN(CHAR(10),TRUE,\"Equipment and resources required (consider Logic Frame 'inputs'):\",'behind the scenes'!E2)","v":"Equipment and resources required (consider Logic Frame 'inputs'):\n•"}]
["Optimal","All","Details of type and extent of any clinical involvement"]
["Optimal","All","Details of resources required for any incentivation of participants or staff"]
["Optimal","All","Details of any costs to participant \n(This could include financial, time and/or emotional costs, and could be actual or potential)"]
["Optimal","All","Detailed breakdown of intervention cost \n(including any developmental costs)"]
["Essential","All","Average estimated cost of intervention per participant"]
["Essential","All","1c: Participant recruitment, confidentiality and ethical considerations"]
["Essential","All","Method of participant recruitment and/or referral (including description of any incentives used)"]
["Essential","All","Participant consent mechanism"]
["Essential","All","Participant inclusion or exclusion criteria \n(including details of demographics of target groups)"]
["Essential","All","Ethical considerations, data privacy or sharing and participant confidentiality"]
["Essential","All","1d: Details of evaluation"]
["Essential","All","Type of evaluation (drop down list)\nYour selection here determines which fields are included below","Process and Impact"]
["Essential","All","Evaluation design \n(including what question the evaluation seeks to answer, the data required and how this data will be collected)"]
["Essential","All","Part 2: Demographics; summary statistics of those reached by intervention. For each criterion, include a measure of average and distribution of data. \n(Data should be collected on an individual level throughout the intervention)"]
["Essential","All","Age"]
["Essential","All","Sex"]
["Essential","All","Ethnicity"]
["Essential","All","Disability"]
["Essential","All","Socioeconomic status (for example, IMD acquired from home postcode)"]
["Essential","All","Religion"]
["Essential","All","Employment status"]
["Essential","All","Sexual orientation"]
["Essential","All","Known co-morbidities"]
["Optimal","All","Additional information (foe example, medical history, marital status, housing tenure, pregnancy, social support needs and so on)"]
["Essential","All","Part 3: Baseline data: summary of population group targeted by intervention.\n(Data should be collected on an individual level throughout the intervention)"]
["Essential","All","Pre-intervention immunisation status (for example, proportion of population immunised; partial or full)"]
["Essential","All","Pre-intervention coverage, %\n(Proportion of eligible population who have been vaccinated)"]
["Essential","All","Pre-intervention uptake, %\n(Proportion who received a vaccine during a specific time period) "]
["Optimal","All","Pre-intervention participant knowledge (for example, of disease, of vaccine)"]
["Optimal","All","Pre-intervention participant intention to vaccinate"]
["Optimal","All","Pre-intervention acceptability or vaccine confidence in target group"]
["Essential","All","Part 4: Follow-up data"]
["Essential","Process","Process evaluation"]
["Essential","Process","Number of interventions staged (for example, training sessions or outreach clinics held)"]
["Essential","Process","Number of people reached by intervention (for example, attendees at training session or clinic)"]
["Essential","Process","Details of any unexpected outcomes and/or adverse events"]
["Essential","Process","Participant's feedback on experience"]
["Optimal","Process","Reasons for non-attendance at intervention"]
["Essential","Process","Acceptability or feasibility of process amongst professional stakeholders"]
["Essential","Process","Plans for sustainability (for example, will the service be offered going forward?)"]
["Essential","Impact","Impact evaluation"]
["Essential","Impact","Post-intervention immunisation status \n(proportion immunised; partial or full)"]
["Essential","Impact","Post-intervention coverage, %\n(Proportion of eligible population who have been vaccinated)"]
["Essential","Impact","Post-intervention uptake, %\n(Proportion who received a vaccine during a specific time period) "]
["Optimal","Impact","Post-intervention participant knowledge (for example, of disease, of vaccine)"]
["Optimal","Impact","Post-intervention participant intention to vaccinate"]
["Optimal","Impact","Post-intervention acceptability/vaccine confidence in target group"]
["Essential","All","Part 5: Analysis and interpretation"]
["Essential","Process","Findings from process evaluation - summary of results"]
["Essential","Impact",{"$f":"_xlfn.TEXTJOIN(CHAR(10), TRUE, \"Findings from impact evaluation - summary of results compared to baseline regarding short-term outcomes:\",'behind the scenes'!E6)","v":"Findings from impact evaluation - summary of results compared to baseline regarding short-term outcomes:\n•"}]
["Essential","Impact",{"$f":"_xlfn.TEXTJOIN(CHAR(10), TRUE, \"Findings from impact evaluation - summary of results compared to baseline regarding medium-term outcomes:\",'behind the scenes'!E7)","v":"Findings from impact evaluation - summary of results compared to baseline regarding medium-term outcomes:\n•"}]
["Optimal","Impact","Findings from impact evaluation: detail of any further analyses or statistical methods used"]
["Essential","All","Findings regarding resource input versus beneficial output (for example, was the cost per successful intervention comparable to other interventions or justifiable for the outcome reached?)"]
["Essential","All","Limitations and generalisability\n(you may wish to consider sample size, availability of data, return or response rate, biases and confounding factors)"]
["Essential","All",{"$f":"_xlfn.TEXTJOIN(CHAR(10), TRUE,\"Conclusions: effectiveness of the intervention at influencing the target behaviour:\",'1. Designing'!E3)","v":"Conclusions: effectiveness of the intervention at influencing the target behaviour:"}]
["Optimal","All","Recommendations: including opportunities for scale up"]

{"sheet":"5. Summary","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'4. Evaluating'!C6","v":"Title or name of intervention"},{"$f":"'4. Evaluating'!D6","v":0}]
[{"$f":"'4. Evaluating'!C7","v":"Contact details for project lead"},{"$f":"'4. Evaluating'!D7","v":0}]
[{"$f":"'4. Evaluating'!C11","v":"Aim"},{"$f":"'4. Evaluating'!D11","v":0}]
["Rationale for the intervention",{"$f":"'4. Evaluating'!D17","v":0}]
["Short summary description of intervention",{"$f":"'4. Evaluating'!D20","v":0}]
["Locations and settings",{"$f":"'4. Evaluating'!D21","v":0}]
["Summary of findings",{"$f":"'behind the scenes'!I2","v":"•"}]
["Resource input versus beneficial output",{"$f":"'4. Evaluating'!D80","v":0}]
["Conclusions",{"$f":"'4. Evaluating'!D82","v":0}]
["Recommendations",{"$f":"'4. Evaluating'!D83","v":0}]

{"sheet":"behind the scenes","index":7,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Essential","Process","COM-B FIGURE",null,"LOGIC FRAME",null,"Measurement Plan",null,"Summary of results"]
["Optimal","Impact",{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'1. Designing'!E4:E9)","v":"•"},{"$f":"'1. Designing'!B4","v":"Physical and psychological"},{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C4:C8)","v":"•"},"Inputs",{"$f":"'2. Describing'!C19","v":0},"Routine",{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'4. Evaluating'!D76:D79)","v":"•"}]
[null,"Process and Impact",{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'1. Designing'!E11:E15)","v":"•"},{"$f":"'1. Designing'!B10","v":"Automatic and reflective"},{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C9:C13)","v":"•"},"Activities",{"$f":"'2. Describing'!C20","v":0},"Study-specific"]
[null,null,{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'1. Designing'!E16:E21)","v":"•"},{"$f":"'1. Designing'!B16","v":"Social"},{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C14:C18)","v":"•"},"Pathways",{"$f":"'2. Describing'!C21","v":0}]
[null,null,{"$f":"CHAR(149)&_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'1. Designing'!E22:E27)","v":"•"},{"$f":"'1. Designing'!B22","v":"Physical"},{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C19:C23)","v":"•"},"Outputs",{"$f":"'2. Describing'!C22","v":0}]
[null,null,null,null,{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C24:C28)","v":"•"},"Short-term Outcomes",{"$f":"'2. Describing'!C23","v":0}]
[null,null,null,null,{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C29:C33)","v":"•"},"Medium-term Outcomes",{"$f":"'2. Describing'!C24","v":0}]
[null,null,null,null,{"$f":"CHAR(149) &_xlfn.TEXTJOIN(CHAR(10)&CHAR(149),TRUE,'2. Describing'!C34:C38)","v":"•"},"Impact",{"$f":"'2. Describing'!C25","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C26","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C27","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C28","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C29","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C30","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C31","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C32","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C33","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C34","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C35","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C36","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C37","v":0}]
[null,null,null,null,null,null,{"$f":"'2. Describing'!C38","v":0}]