{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Developer& reviewer comments ","1. Workbook Overview","1.1 Background","1.2 Stakeholders","1.3 Informing NSP priorities ","1.4 Interventions","1.5 Work Tracker","2.1 Literature Review","2.2 Adaptation Calcs","2.3 IBC Unit costs","2.4 IBC Common Ingredients","2.4 Lump Sum","3.1 Unit Cost Table","3.2 Population Indicators","Dropdowns","3.3 NSP Total Costs","4.1 Efficiency","4.2 SA","4.2 Scenario Analysis","4.4 Equity Analysis","5.1 TRAC","5.2 Results Summary"],"not_rendered":{"charts":5,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":12,"pivot_tables":1},"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":"Developer& reviewer comments ","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Notes, questions, comments"]
[]
[2.1,"literature source: needs to include  models"]
[2.1,"NSP Program Area","NSP Interventions","not comprehensive enough and difficult to add categories"]

{"sheet":"1. Workbook Overview","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,1,21,1],[23,1,24,1],[15,1,17,1],[4,1,8,1],[10,1,12,1]]}
[]
[]
[null,"Section","Sheet #","Sheet Name",null,"Guideline Chapter","Purpose"]
[]
[null,"1. Preparatory Work",1.1000000000000001,"Background",null,"Chapter 3,11,12","Summarize costing purpose & overall methodology"]
[null,null,1.2,"Stakeholders",null,"Chapter 3 & 11","Maintain an inventory of all the stakeholders relevant to NSP costing process"]
[null,null,1.3,"NSP prioritisation",null,"Chapter 3  ","Collate CEA evidence and share key efficiency questions with NSP teams"]
[null,null,1.4,"Interventions",null,"Chapter 4","Collect and update information and details on each intervention that needs to be costed"]
[null,null,1.5,"Work Tracker",null,"Chapter 4","Track costing process, decisions, and methodology"]
[]
[null,"2. Building Unit Costs",2.1,"Literature Review",null,"Chapter 7","Review and select most appropriate unit costs from literature"]
[null,null,2.2000000000000002,"Adapting Unit Costs",null,"Chapter 7","Adapt unit costs from literature for inflation, unit of output, and/or programmatic context"]
[null,null,2.2999999999999998,"IBC Unit costs",null,"Chapter 8","Model costs using ingredients based costing"]
[null,null,2.4,"IBC Common ingredients",null,"Chapter 8","List common inputs to ensure consistency"]
[]
[null,"3. Putting it all together",3.1,"Unit Costs",null,"Chapter 9","Collate intervention unit costs from the IBC and Adaptation tabs, inputs for GOALS"]
[null,null,3.3,"Population coverage",null,"Chapter 9","Estimate coverage by population and year"]
[null,null,3.4,"Total Costs",null,"Chapter 9","Estimates the total NSP budget"]
[]
[null,"4. Further Analysis",4.0999999999999996,"Efficiency Analysis",null,"Chapter 10","Identify critical in-efficiencies, solutions and the impact on unit costs"]
[null,null,4.2,"Sensitivity & Scenarios ",null,"Chapter 10","Estimate the impact of internal assumptions and external changes on unit and or total costs"]
[null,null,4.3,"Benefit incidence analysis (only if accompanied by outputs from the Goals model)",null,"NA","Not in this version yet"]
[]
[null,"5. Final Reports",5.0999999999999996,"TRAC",null,"Chapter 11","Transparently report costing and verify key elements considered for each unit cost"]
[null,null,5.2,"Presenting Results",null,"Chapter 11","Generate cost tables and figures to share results"]

{"sheet":"1.1 Background","index":2,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[19,2,19,3],[24,2,24,3],[6,3,6,6],[40,2,40,3],[43,2,43,3]]}
[]
[]
[null,null,"NSP COSTING BACKGROUND"]
[]
[]
[]
[null,null,"Instructions: ","Summarize costing purpose & overall methodology"]
[]
[null,null,"Relevant Guidelines Chapters:","Chapter 3 - Defining scope & purpose"]
[null,null,null,"Chapter 10 - Sensitivity and technical efficiency and budget impact analysis"]
[null,null,null,"Chapter 11 - Transparent reporting and analysis for costing checklist"]
[]
[null,null,"Name of Lead Costing Analyst"]
[null,null,"Submission Date"]
[null,null,"Country"]
[null,null," Title of Project"]
[null,null,"Strategic Plan Start Year"]
[null,null,"Strategic Plan End Year",null,null,null,null,null,null,null,"Indicate that cells are dependencies"]
[]
[null,null,"Country Background"]
[null,null,"Geographic Region"]
[null,null,"Country Income Level"]
[]
[]
[null,null,"Overall Methods"]
[null,null,"Costing Aim","Other (please specify)","Provide additional details here"]
[null,null,"Costing Currency"]
[null,null,"Costing Year"]
[null,null,"Source for currency conversion rates","Historical Currency Converter | OANDA"]
[null,null,"currency per USD",null,"11/3/2025 Oanda"]
[null,null,"Source of historial inflation rates","A Global Database of Inflation","for example: https://www.worldbank.org/en/research/brief/inflation-database"]
[null,null,"average Inflation rate"]
[null,null,"Method for applying inflation adjustments","[Value *(1+average inflation)(Current costing year-Original data year)]","See e.g. Turner 2019  VALUE HEALTH. 2019; 22(9):1026–1032 https://doi.org/10.1016/j.jval.2019.03.021 or Kumaranayake 2000  Health Policy Planning doi: 10.1093/heapol/15.2.230"]
[null,null,"Were costs projected using adjusted inflation to future year costs",null,"If yes, enter annual inflation rate(s) used. If no, justify here. For example: \"Yes, 3%\" or \"No, the costing is all presented in 2024 USD, so will need inflation adjustments when applying to budgetting\""]
[null,null,"Perspective",null,"Specify whose costs are included here, e.g. Only MoH, all governement (includes other sectors to be named), All providers (public, private), societal (includes user costs)"]
[]
[null,null,"Financial/Economic",null,"Specify any exceptions here"]
[null,null,"Full/Incremental",null,"If incremental, specify baseline here. If exceptions specify here"]
[null,null,"Normative/Observed",null,"Are intervention costs estimated based on observed implementation or from best practice/ guidelines (normative). Specify any exceptions here"]
[]
[null,null,"Modeling Software"]
[null,null,"Modeling sofware",null,"Are you using modelling software to estimate impact and or total costs, e.g. Integrated Health Tool, Resource Needs Model?"]
[]
[null,null,"Parameters to explore in Sensitivity, efficiency and scenario analyses"]
[null,null,"Parameter names","Potential Values ","list parameters here, with base value and high and low values in this text to ensure you are able to return to the base value at the end, name these cells so they are used in the analyses. This analysis will be carried out in practice in the sensitivity analysis Tab (4.2). "]
[null,null,"P1",null,"base, low, high"]
[null,null,"P2",null,"base, low, high"]
[null,null,"P3",null,"base, low, high"]
[null,null,"P4",null,"base, low, high"]
[null,null,"P5",null,"base, low, high"]
[null,null,"P6",null,"base, low, high"]
[null,null,"P7",null,"base, low, high"]
[null,null,"P8",null,"base, low, high"]
[null,null,"P9",null,"base, low, high"]
[null,null,"P10",null,"base, low, high"]
[]
[]
[]
[null,null,"Log for assumptions & potential sensitivity, efficiency and scenarios log"]
[]
[null,null,"Days worked per year",217]
[null,null,"Hours worked per day",6]
[null,null,"number of HIV tests a provider can do per day",7]

{"sheet":"1.2 Stakeholders","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,3],[6,4,6,5]]}
[]
[]
[null,null,"CHAPTER 3: COLLABORATION IN THE NSP PROCESS"]
[null,null,"Purpose of this tool: To keep track of all the different stakeholders, key informants, and their contacts throughout the NSP costing process. "]
[]
[]
["NSP Framework",null,null,null,"Contact Information",null,"Data Collection","Communication"]
["Name","Title/Job Function","NSP TWG/Team","NSP Role","Email","Phone","Information needed from individual","Frequency of communication needed"]

{"sheet":"1.3 Informing NSP priorities ","index":4,"n_rows":99,"n_cols":5,"rows_kept":99,"cut":false,"hidden":false,"merged":[[44,2,45,2],[44,3,45,3],[44,4,45,4],[39,2,41,2],[39,3,41,3],[39,4,41,4],[42,2,43,2],[42,3,43,3],[42,4,43,4],[61,2,62,2],[61,3,62,3],[61,4,62,4],[49,2,50,2],[49,3,50,3],[49,4,50,4],[52,2,53,2],[52,3,53,3],[52,4,53,4]]}
[]
[]
[null,"CHAPTER 3: COLLABORATION IN THE COSTING PROCESS"]
[]
[null,"Generating rapid cost-effectiveness evidence for priority setting"]
[]
[]
[null,"1. Template for sharing CEA evidence"]
[null,"Prevention","Evidence on cost","Evidence on cost per HIV infection averted","Source"]
[null,"FSW HIV prevention "]
[null,"FSW PrEP"]
[null,"MSW HIV prevention "]
[null,"MSW PrEP"]
[null,"MSM HIV prevention "]
[null,"MSM PrEP"]
[null,"Transgender HIV prevention"]
[null,"Transgender PrEP"]
[null,"PWID outreach/peer education"]
[null,"PWID PrEP"]
[null,"PWID needle and syringe exchange programme"]
[null,"PWID Opiate Substitution Therapy"]
[null,"Prisoners PrEP"]
[null,"Prisoners NSEP"]
[null,"STI treatment"]
[null,"Prevention of HIV through counselling and provision of condoms and lubricants"]
[null,"AGYW PREP"]
[null,"Comprehensive sexuality education (adolescents)"]
[null,"VMMC"]
[null,"Adult Female PrEP"]
[null,"Adult Male PrEP"]
[null,"Post-exposure prophylaxis (PEP)"]
[null,"Testing, treatment and care"]
[null,"HIV testing"]
[null,null,null,"Evidence on cost per HIV death averted","Source"]
[null,"Adult treatment (Male)"]
[null,"Adult treatment (Female)"]
[null,"Paediatric treatment"]
[]
[null,"Social enablers "]
[null,"Enabling legal environments"]
[null,"Legal literacy (“Know Your Rights”)"]
[null,"Advocacy support and capacity building for community-led organizations,"]
[null,"Increasing access to justice"]
[null,"Paralegal services"]
[null,"Ensuring rights-based law enforcement practices:"]
[null,"Training of law enforcement"]
[null,"Improving laws, regulations and polices relating to HIV and HIV/TB"]
[null,"Review of laws and law enforcement practices to gauge impact"]
[null,"Training and sensitisation of: judges, lawyers; parliamentarians; community leaders including religious leaders."]
[null,"Reduction of stigma and discrimination: "]
[null,"Reducing Human Rights related Barriers to Services"]
[null,"Eliminating stigma and discrimination in all settings"]
[null,"Ensuring non-discriminatory provision of health care"]
[null,"Community led Monitoring"]
[null,"Reduction of harmful gender social norms and promotion of gender-transformative approaches: "]
[null,"Reducing HIV-related gender discrimination, harmful gender norms and violence against women and girls in all their diversity"]
[null,"Increased sexual autonomy of adolescent girls and women of all ages"]
[null,"Reduction in harmful masculinities"]
[null,"Prevention of gender-based violence against adolescent girls, WLHIV, PLHIV, transwomen and men, sex workers, users of drugs (including women users of drugs), gender diverse individuals"]
[null,"Prevention of intimate partner violence"]
[null,"Supporting women’s leadership"]
[null,"Social protection"]
[null,"Socioeconomic support for orphans and vulnerable children"]
[null,"Economic empowerment or cash transfers"]
[null,"Food and nutrition programmes"]
[]
[]
[null,"Basic Efficiency questions for the NSP teams to consider while priority setting: "]
[]
[null,"1. In the budget for the existing NSP, what are the most expensive components?  Which intervention makes up the largest share of the budget? These are likely the areas for greatest efficiency impact. "]
[null,"2. What percentage of all HIV/AIDS funds are allocated to program management?  How does this compare to other similar countries?  How are these distributed to the different levels of the system? "]
[null,"a. Are there plans to either increase or decrease program management costs as a percentage of the entire NSP budget?  "]
[null,"b. How will these resources be allocated to/deducted from program management?"]
[null,"c. What are the risks to programme implementation quality of reducing the management at different levels of the system?"]
[null,"3. What concerns currently exist regarding having a fully functional supply chain system for the delivery of HIV services in the country?  Where is the weakest link? For example, how long does it take commodities to clear customs, then be delivered to central and regional warehouses and to facilities? Are frontline stock-outs frequently reported? "]
[null,"a. How will these concerns be addressed in the new NSP?"]
[null,"4. What opportunities exist for combining HIV interventions with other HIV prevention (e.g., integrating PrEP into AGYW programs) or other health programs (incorporating HIV programs into NCD, child, maternal, SRHR, TB and Covid-19 interventions)?  "]
[null,"a. What data, if any, suggest that this could result in increased efficiency?  "]
[null,"b. To what extent would this affect the costs of each respective intervention? Can certain overhead costs be shared across programs?"]
[null,"c. May combining programmes increase reach and service uptake?"]
[null,"5. Could any of the interventions be delivered more efficiently if they were led and provided by community-led organizations (CLO)?  "]
[null,"a. If so, which interventions and how would this affect the costs of providing these services?"]
[null,"b. Would there also be a change in quality and quantity of coverage? "]
[null,"c. Can this be quantified? "]
[null,"6. Could any of the interventions be delivered more efficiently if they were provided at a community-based location rather than in a facility?  "]
[null,"a. If so, which interventions and how would this affect the costs of providing these services? "]
[null,"b. How would this affect service uptake? "]
[null,"c. Would there also be a change in quality of coverage? Can this be quantified? "]
[null,"7. Have the most efficient service delivery models been adopted: including: "]
[null,"a. targeted testing and prevention to highest incidence populations, geographic regions, and age groups (for VMMC).  "]
[null,"b. Is universal PMTCT in place? "]
[null,"c. Is HIV self-testing available in high burden low coverage testing settings, with support for linkage to care? "]
[null,"d. Are interventions delivered by the most appropriate level of staff?  It should be noted that while task-shifting to lower cadres may appear to save costs, it is not efficient if the quality or uptake of services drop, so careful monitoring of impact will need to be proposed."]
[null,"e. Are there steps in the processes that could be streamlined, for example by reducing the numbers of visits or the number of HCWs attending to clients at each visit?  Reducing the number of required lab tests?"]
[null,"f. Are different staff members experiencing gaps in their workdays due to low demand from clients/ users?  "]
[null,"g. Are all the needed supplies, drugs and diagnostics in stock and available? "]
[null,"8. In reviewing the treatment programme, what are the existing interventions that could be leveraged to make the program more efficient? Past examples that have had large impacts were introduction of: multi-month scripting, differentiated service delivery, changing antiretroviral drugs regimens, etc.)? "]
[null,"9. Are there plans for expanding of Prep, or provision of PrEP as vaginal ring or as long-acting injectable PrEP. These programmes will need close evaluation to understand opportunities for efficiency gains in practice: for them to increase efficiency, there would need to be gains in uptake and/or adherence, as they will likely have higher unit costs, at least in the short term.    "]
[null,"10. Demand constraints: Where are staff not optimally used due to low service uptake and is there an obvious way to increase client uptake/ create demand, with the aim of more optimally using staff resources? "]

{"sheet":"1.4 Interventions","index":5,"n_rows":110,"n_cols":17,"rows_kept":110,"cut":false,"hidden":false,"merged":[[3,2,3,3],[10,14,10,16],[9,2,9,4],[10,6,10,7],[10,9,10,10],[10,12,10,13]]}
[]
[]
[null,null,"CHAPTER 5: REVIEWING INTERVENTIONS TO BE COSTED"]
[null,null,"Purpose of this tool: Collect baseline information on each intervention that needs to be included in the costing. Allows cost analysts to show their due diligence in aligning NSP with costing work, while collecting and documenting key information on each intervention to facilitate costing. "]
[null,null,"Red cells: required information"]
[null,null,"Blue cells: information to keep updated"]
[null,null,"Remaining cells: additional useful information"]
[]
[]
[]
[null,"Intervention #","Intervention Short Name","Objective","Sub-objective","Roll-up Category","Target population(s)",null,"Delivery Platform(s)","Implementer",null,"Scale","New/Routine",null,"Activity Details"]
[null,"Line","List every intervention identified by the TWG","What strategic objective/ intervention category does the intervention belong to?","What program area does the intervention relate to?","Optional: A set of categories that can be used for grouping results.","What population(s) does this intervention seek to target? \nSpecify 'no information provided' if not stated/indicated by TWG","Additional details ","At what site level is this intervention expected to be delivered? (example: facility or community level)\nSpecify 'no information provided' if not stated/indicated by TWG","Who is delivering this intervention?: \nOrganizational type or sector (ex: International NGO, national NGO, government, ","Additional details (ex: name of organization)","At what general scale is this intervention expected to take place?","Is this a new or routine intervention? If new, has it formerly been piloted in the country? If routine, does the TWG expect there to be changes/adaptations to its approach?","Additional Details on expected changes","Who can provide additional details on this intervention, if necessary? ","How will this intervention be delivered? What activities are described? Update cell overtime, as further information is collected. ","Final source(s). May be mix of people & documents."]
[null,1,"Comprehensive HIV testing services - provider initiated","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population","HTS"]
[null,2,"Medical male circumcision","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population","medical male circumcision"]
[null,3,"Curriculum based Comprehensive Sexuality Education in schools using scripted lesson plans","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population","Comprehensive sexuality education in and out of school"]
[null,4,"Strengthen youth friendly services for adolescents and youth through the DOH public health care system","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.3 Provide sensitive and age-appropriate sexual and reproductive health services  (SRH) and comprehensive sexuality education (CSE)","Key and Vulnerable populations (mixed)"]
[null,5,"Provide oral PrEP to young women - 20 - 24","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.3 Provide sensitive and age-appropriate sexual and reproductive health services  (SRH) and comprehensive sexuality education (CSE)","PREP"]
[null,6,"Accelerate ART initiation and retention in care for all PLHIV in a way that ensures equity - Adults","2. Reduce morbidity and mortality by providing treatment, care and adherence support for all.","2.1.2 90% of all people with diagnosed HIV infection receive sustained antiretroviral therapy","Adherence"]
[null,7,"Combination prevention package targeting Adolescent girls and young women - 15 -19 years, in schools - youth club model","1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.4 Provide Pre-Exposure Prophylaxis (PREP) to identified risk populations ","AGYW"]
[null,8,"Social mobilisation and education on rights and laws relevant to HIV and TB","3. Reach all key and vulnerable populations with comprehensive, customised and targeted interventions.","3.1.3  All key and vulnerable population programmes should adopt a peer educator led approach to implementation","Human rights and stigma"]
[null,9,"Programme management costs for core government departments implementing the NSP","5. Ground the response to HIV, TB and STIs in human rights principles and approaches","5.2.1  Improve legal literacy about human rights and laws relevant to HIV and TB","Programme Management, planning, co-ordination and oversight"]
[null,10,"Nationally co-ordinated multi media campaign targeting all risk groups in the general population","9. Critical enablers to maximise the reach and impact of National response to HIV, TB and STIs","9.1.4 Enabler 6: Programme management, planning, co-ordination and oversight","SBCC"]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]

{"sheet":"1.5 Work Tracker","index":6,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[6,4,6,5],[6,6,6,7],[5,4,5,8],[5,9,5,10]]}
[]
[]
[null,null,null,"WORKPLAN/TRACKER"]
[]
[]
[null,null,null,null,"Preparation",null,null,null,null,"Work Tracker"]
[null,null,"Intervention #","Interventions","Include in Costing?",null,"Big-ticket item",null," Costing Method","Status","Notes on Status / Next Steps"]
[null,null,null,"List every intervention identified by the TWG","Is this intervention included in the costing?","If partially or no, justify","Is this a big-ticket item? See Chapter 6 for explanation of big-ticket items","Will you conduct a process map? Note that interventions indicated as big-ticket items should all have process maps done. See chapter 5 for more information on process maps","What methodological approach will you take to cost this intervention? See chapter 6 for more information on costing method. ",null," "]
[null,null,null,{"$f":"'1.4 Interventions'!C13","v":"Comprehensive HIV testing services - provider initiated"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C14","v":"Medical male circumcision"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C15","v":"Curriculum based Comprehensive Sexuality Education in schools using scripted lesson plans"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C16","v":"Strengthen youth friendly services for adolescents and youth through the DOH public health care system"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C17","v":"Provide oral PrEP to young women - 20 - 24"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C18","v":"Accelerate ART initiation and retention in care for all PLHIV in a way that ensures equity - Adults"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C19","v":"Combination prevention package targeting Adolescent girls and young women - 15 -19 years, in schools - youth club model"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C20","v":"Social mobilisation and education on rights and laws relevant to HIV and TB"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C21","v":"Programme management costs for core government departments implementing the NSP"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C22","v":"Nationally co-ordinated multi media campaign targeting all risk groups in the general population"},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C23","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C24","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C25","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C26","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C27","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C28","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C29","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C30","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C31","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C32","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C33","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C34","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C35","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C36","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C37","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C38","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C39","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C40","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C41","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C42","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C43","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C44","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C45","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C46","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C47","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C48","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C49","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C50","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C51","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C52","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C53","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C54","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C55","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C56","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C57","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C58","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C59","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C60","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C61","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C62","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C63","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C64","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C65","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C66","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C67","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C68","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C69","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C70","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C71","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C72","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C73","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C74","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C75","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C76","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C77","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C78","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C79","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C80","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C81","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C82","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C83","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C84","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C85","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C86","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C87","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C88","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C89","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C90","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C91","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C92","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C93","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C94","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C95","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C96","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C97","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C98","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C99","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C100","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C101","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C102","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C103","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C104","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C105","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C106","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C107","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C108","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C109","v":0},null,null,null,null,null,"Not started"]
[null,null,null,{"$f":"'1.4 Interventions'!C110","v":0},null,null,null,null,null,"Not started"]

{"sheet":"2.1 Literature Review","index":7,"n_rows":95,"n_cols":40,"rows_kept":95,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,19,8,20],[8,31,8,33],[8,21,8,23],[8,24,8,28],[8,38,8,39],[8,3,8,8],[8,9,8,12],[3,3,4,11],[8,35,8,36]]}
[]
[]
[null,null,"CHAPTER 7: LITERATURE REVIEW"]
[null,null,"Objective: ","Document findings from literature search by filling in columns A:G. Indicate if source cost will be used in NSP costing. If so, continue filling informations in columns I:AI, to justify use of this source cost and identify areas that may need adapations. "]
[]
[null,null,"Grey text ","Auto-filled, does not require manual entry"]
[]
[]
[null,"NSP",null,"SOURCE",null,null,null,null,null,"UNIT COST",null,null,null,null,null,"INTEGRATED HEALTH TOOL INPUTS, if using IHT",null,null,null,"DATE CHECK",null,"GEOGRAPHY",null,null,"GEO CHECK",null,null,null,null,"POPULATION","POP CHECK","SOURCE METHODOLOGY",null,null,"METHOD CHECK","ACTIVITY SCOPE",null,"SCOPE MATCH","NOTES"]
[null,"NSP Program Area","NSP Interventions","Source Name","Source Link","Primary source?","Source Type","Source Intervention","Use source/unit cost in costing?","Unit Cost","Output Unit","Currency","Year","Today's Year","Data Age","staff time per visit in minutes","nr outpatient visits","cost of medical supplies","nr  inpatient days","Data Age","Need to adjust for inflation?","Country","Region","Country Income Level","NSP Country","NSP Region","NSP Country Income Level",null,"Geographic Suitability","Target Population Category","POP Suitability","Modeled vs. Observed","Financial vs. Economic","Full vs. Incremental","Does this meet cost need/purpose","Activity Scope","Delivery Platform(s)","Does this correspond to the NSP intervention?","Does this unit cost require adaptation?","Notes, explanation"]
[null,"Link to 'Reviewing Interventions'","Link to 'Reviewing Interventions'","Author/Org, Year","Add source url, if possible","Confirm source is primary. If not primary source, justify. ","What kind of source is it?","Intervention costed in source","Indicate if this source is used in NSP Costing. If not, stop data entry here. If yes, please justify use of source by filling in remaining information. ","Indicate reported unit cost in source","What is the unit of output or outcome measure reporeted","Indicate currency cost is reported in","Indicate what year costs are reported in (note, that cost year is not necessarily the same as publication year)","Autofilled","Autofilled",null,null,null,null,"Autofilled","Autofilled","Indicate source country","Indicate source geographic region","Indicate source country income level","Autofilled","Autofilled","Autofilled",null,"Autofilled","Indicate target pouplation in source","Autofilled","Was the source cost estimated by modeling or from observation","Indicate if source cost is financial or economic","Indicate if source cost is full or incremental","Not autofilled. Based on Analyst's judgment. ","Briefly describe the intervention's activity scope ","At what site level is this intervention expected to be delivered? (example: facility or community)\n","Not autofilled. Based on Analyst's judgment. ","Indicate whether this unit cost requires adaptation or not","Add additional details"]
[2,"Prevention Services","VMMC","Investment Case, inf adjusted. Corroborated by Avenir study, 2016"," https://doi.org/10.1371/journal.pone.0169710 ","Yes",null,null,"Yes",1504.0140021677987,"Cost per male circumcision","ZAR",2017,{"$f":"YEAR(TODAY())","v":2025},{"$f":"N12-M12","v":8},null,null,null,null,{"$f":"IF(O12>=10,\"Data 10 years or older\",O12)","v":8},{"$f":"IF(N12=M12, \"No\", \"Yes\")","v":"Yes"},"Malawi","Eastern and Southern Africa","Lower-Middle-Income Country",{"$f":"_xlfn.IFS(V12=\"\", \"\", '1.1 Background'!$D$18=V12, 1, '1.1 Background'!$D$18<>V12, 0)","v":0},{"$f":"_xlfn.IFS(W12=\"\", \"\", '1.1 Background'!$D$21=W12, 1, '1.1 Background'!$D$21<>W12, 0)","v":0},{"$f":"_xlfn.IFS(X12=\"\", \"\", '1.1 Background'!$D$22=X12, 1, '1.1 Background'!$D$22<>X12, 0)","v":0},{"$f":"IF(Y12=\"\", \"\", (SUM(Y12:AA12)))","v":0},{"$f":"_xlfn.IFS(AB12=\"\", \"\", AB12=3, \"Strong match\", AB12=2, \"Ok match\", AB12=1, \"Ok match\", AB12=0, \"No match\")","v":"No match"},"General Population","Match","Observed","Financial","Full","Yes",null,"Community","Yes","No"]
[4,"Integrated Health Services","Health system strengthening","Adolescent & Youth Health Policy Costing Model, 2016. Includes training and provincial visits and assessments",null,"No",null,null,"Yes",17760153.5,"Youth friendly PHC service","ZAR",2017,null,null,null,null,null,null,{"$f":"IF(O13>=10,\"Data 10 years or older\",O13)","v":0},{"$f":"IF(N13=M13, \"No\", \"Yes\")","v":"Yes"},null,null,null,{"$f":"_xlfn.IFS(V13=\"\", \"\", '1.1 Background'!$D$18=V13, 1, '1.1 Background'!$D$18<>V13, 0)","v":""},{"$f":"_xlfn.IFS(W13=\"\", \"\", '1.1 Background'!$D$21=W13, 1, '1.1 Background'!$D$21<>W13, 0)","v":""},{"$f":"_xlfn.IFS(X13=\"\", \"\", '1.1 Background'!$D$22=X13, 1, '1.1 Background'!$D$22<>X13, 0)","v":""},{"$f":"IF(Y13=\"\", \"\", (SUM(Y13:AA13)))","v":""},{"$f":"_xlfn.IFS(AB13=\"\", \"\", AB13=3, \"Strong match\", AB13=2, \"Ok match\", AB13=1, \"Ok match\", AB13=0, \"No match\")","v":""},null,"Match"]
[9,"Integrated Health Services","Health system strengthening","Derived from national and provincial budgets",null,"No",null,null,"Yes",690911879.015342,"Annual programme management cost  per social protection departments","ZAR",2017,null,null,null,null,null,null,0,"Yes",null,null,null,{"$f":"_xlfn.IFS(V14=\"\", \"\", '1.1 Background'!$D$18=V14, 1, '1.1 Background'!$D$18<>V14, 0)","v":""},{"$f":"_xlfn.IFS(W14=\"\", \"\", '1.1 Background'!$D$21=W14, 1, '1.1 Background'!$D$21<>W14, 0)","v":""},{"$f":"_xlfn.IFS(X14=\"\", \"\", '1.1 Background'!$D$22=X14, 1, '1.1 Background'!$D$22<>X14, 0)","v":""},"",{"$f":"_xlfn.IFS(AB14=\"\", \"\", AB14=3, \"Strong match\", AB14=2, \"Ok match\", AB14=1, \"Ok match\", AB14=0, \"No match\")","v":""},null,"Match"]
[null,"Prevention Services","BCC","Source: SA Investment Case. Aggregate of 2 national campaigns. Inflation adjusted",null,"No",null,null,"Yes",8.0899000000000001,"Cost per pp reached by 2 national communication campaign pa","ZAR",2017,null,null,null,null,null,null,0,"Yes",null,null,null,{"$f":"_xlfn.IFS(V15=\"\", \"\", '1.1 Background'!$D$18=V15, 1, '1.1 Background'!$D$18<>V15, 0)","v":""},{"$f":"_xlfn.IFS(W15=\"\", \"\", '1.1 Background'!$D$21=W15, 1, '1.1 Background'!$D$21<>W15, 0)","v":""},{"$f":"_xlfn.IFS(X15=\"\", \"\", '1.1 Background'!$D$22=X15, 1, '1.1 Background'!$D$22<>X15, 0)","v":""},"",{"$f":"_xlfn.IFS(AB15=\"\", \"\", AB15=3, \"Strong match\", AB15=2, \"Ok match\", AB15=1, \"Ok match\", AB15=0, \"No match\")","v":""},null,"Match"]
[null,"Prevention Services","BCC","Source: SA Investment Case. Inflation adjusted",null,"No",null,null,"Yes",10.988808000000001,"Cost per adolescent or youth reached by targeted multi-media communication campaign","ZAR",2017,null,null,null,null,null,null,0,"Yes",null,null,null,{"$f":"_xlfn.IFS(V16=\"\", \"\", '1.1 Background'!$D$18=V16, 1, '1.1 Background'!$D$18<>V16, 0)","v":""},{"$f":"_xlfn.IFS(W16=\"\", \"\", '1.1 Background'!$D$21=W16, 1, '1.1 Background'!$D$21<>W16, 0)","v":""},{"$f":"_xlfn.IFS(X16=\"\", \"\", '1.1 Background'!$D$22=X16, 1, '1.1 Background'!$D$22<>X16, 0)","v":""},"",{"$f":"_xlfn.IFS(AB16=\"\", \"\", AB16=3, \"Strong match\", AB16=2, \"Ok match\", AB16=1, \"Ok match\", AB16=0, \"No match\")","v":""},null,"Match"]
[null,"Integrated Health Services","Sexual Education and Health Services"," Schnippel K et al 2015, Plos One.  Inflation adjusted ",null,"Yes",null,null,"Yes",720,"Cost per youth 15-24 receiving SRH service in non-health care setting ","ZAR",2017,null,null,null,null,null,null,{"$f":"IF(O17>=10,\"Data 10 years or older\",O17)","v":0},{"$f":"IF(N17=M17, \"No\", \"Yes\")","v":"Yes"},null,null,null,{"$f":"_xlfn.IFS(V17=\"\", \"\", '1.1 Background'!$D$18=V17, 1, '1.1 Background'!$D$18<>V17, 0)","v":""},{"$f":"_xlfn.IFS(W17=\"\", \"\", '1.1 Background'!$D$21=W17, 1, '1.1 Background'!$D$21<>W17, 0)","v":""},{"$f":"_xlfn.IFS(X17=\"\", \"\", '1.1 Background'!$D$22=X17, 1, '1.1 Background'!$D$22<>X17, 0)","v":""},"",{"$f":"_xlfn.IFS(AB17=\"\", \"\", AB17=3, \"Strong match\", AB17=2, \"Ok match\", AB17=1, \"Ok match\", AB17=0, \"No match\")","v":""},null,"Match",null,null,null,null,null,null,null,null,"Cost includes fixed costs of fitted mobile vehicle and staff and variable costs of cervical cancer screening, STI management, condoms, contraceptives, HCT, breast exams and general health education."]
[6,"Test & Treat","ART","SAG Costing model NACM Output March 2017. Scenario 1A: Current regimens and adherence strategy implementation",null,"No",null,null,"Yes",3389.740047041952,"Average cost per adult on ART (public and private)","ZAR",2017,null,null,null,null,null,null,0,"Yes",null,null,null,{"$f":"_xlfn.IFS(V18=\"\", \"\", '1.1 Background'!$D$18=V18, 1, '1.1 Background'!$D$18<>V18, 0)","v":""},{"$f":"_xlfn.IFS(W18=\"\", \"\", '1.1 Background'!$D$21=W18, 1, '1.1 Background'!$D$21<>W18, 0)","v":""},{"$f":"_xlfn.IFS(X18=\"\", \"\", '1.1 Background'!$D$22=X18, 1, '1.1 Background'!$D$22<>X18, 0)","v":""},"",{"$f":"_xlfn.IFS(AB18=\"\", \"\", AB18=3, \"Strong match\", AB18=2, \"Ok match\", AB18=1, \"Ok match\", AB18=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V19=\"\", \"\", '1.1 Background'!$D$18=V19, 1, '1.1 Background'!$D$18<>V19, 0)","v":""},{"$f":"_xlfn.IFS(W19=\"\", \"\", '1.1 Background'!$D$21=W19, 1, '1.1 Background'!$D$21<>W19, 0)","v":""},{"$f":"_xlfn.IFS(X19=\"\", \"\", '1.1 Background'!$D$22=X19, 1, '1.1 Background'!$D$22<>X19, 0)","v":""},"",{"$f":"_xlfn.IFS(AB19=\"\", \"\", AB19=3, \"Strong match\", AB19=2, \"Ok match\", AB19=1, \"Ok match\", AB19=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V20=\"\", \"\", '1.1 Background'!$D$18=V20, 1, '1.1 Background'!$D$18<>V20, 0)","v":""},{"$f":"_xlfn.IFS(W20=\"\", \"\", '1.1 Background'!$D$21=W20, 1, '1.1 Background'!$D$21<>W20, 0)","v":""},{"$f":"_xlfn.IFS(X20=\"\", \"\", '1.1 Background'!$D$22=X20, 1, '1.1 Background'!$D$22<>X20, 0)","v":""},"",{"$f":"_xlfn.IFS(AB20=\"\", \"\", AB20=3, \"Strong match\", AB20=2, \"Ok match\", AB20=1, \"Ok match\", AB20=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V21=\"\", \"\", '1.1 Background'!$D$18=V21, 1, '1.1 Background'!$D$18<>V21, 0)","v":""},{"$f":"_xlfn.IFS(W21=\"\", \"\", '1.1 Background'!$D$21=W21, 1, '1.1 Background'!$D$21<>W21, 0)","v":""},{"$f":"_xlfn.IFS(X21=\"\", \"\", '1.1 Background'!$D$22=X21, 1, '1.1 Background'!$D$22<>X21, 0)","v":""},"",{"$f":"_xlfn.IFS(AB21=\"\", \"\", AB21=3, \"Strong match\", AB21=2, \"Ok match\", AB21=1, \"Ok match\", AB21=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V22=\"\", \"\", '1.1 Background'!$D$18=V22, 1, '1.1 Background'!$D$18<>V22, 0)","v":""},{"$f":"_xlfn.IFS(W22=\"\", \"\", '1.1 Background'!$D$21=W22, 1, '1.1 Background'!$D$21<>W22, 0)","v":""},{"$f":"_xlfn.IFS(X22=\"\", \"\", '1.1 Background'!$D$22=X22, 1, '1.1 Background'!$D$22<>X22, 0)","v":""},"",{"$f":"_xlfn.IFS(AB22=\"\", \"\", AB22=3, \"Strong match\", AB22=2, \"Ok match\", AB22=1, \"Ok match\", AB22=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V23=\"\", \"\", '1.1 Background'!$D$18=V23, 1, '1.1 Background'!$D$18<>V23, 0)","v":""},{"$f":"_xlfn.IFS(W23=\"\", \"\", '1.1 Background'!$D$21=W23, 1, '1.1 Background'!$D$21<>W23, 0)","v":""},{"$f":"_xlfn.IFS(X23=\"\", \"\", '1.1 Background'!$D$22=X23, 1, '1.1 Background'!$D$22<>X23, 0)","v":""},"",{"$f":"_xlfn.IFS(AB23=\"\", \"\", AB23=3, \"Strong match\", AB23=2, \"Ok match\", AB23=1, \"Ok match\", AB23=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V24=\"\", \"\", '1.1 Background'!$D$18=V24, 1, '1.1 Background'!$D$18<>V24, 0)","v":""},{"$f":"_xlfn.IFS(W24=\"\", \"\", '1.1 Background'!$D$21=W24, 1, '1.1 Background'!$D$21<>W24, 0)","v":""},{"$f":"_xlfn.IFS(X24=\"\", \"\", '1.1 Background'!$D$22=X24, 1, '1.1 Background'!$D$22<>X24, 0)","v":""},"",{"$f":"_xlfn.IFS(AB24=\"\", \"\", AB24=3, \"Strong match\", AB24=2, \"Ok match\", AB24=1, \"Ok match\", AB24=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V25=\"\", \"\", '1.1 Background'!$D$18=V25, 1, '1.1 Background'!$D$18<>V25, 0)","v":""},{"$f":"_xlfn.IFS(W25=\"\", \"\", '1.1 Background'!$D$21=W25, 1, '1.1 Background'!$D$21<>W25, 0)","v":""},{"$f":"_xlfn.IFS(X25=\"\", \"\", '1.1 Background'!$D$22=X25, 1, '1.1 Background'!$D$22<>X25, 0)","v":""},"",{"$f":"_xlfn.IFS(AB25=\"\", \"\", AB25=3, \"Strong match\", AB25=2, \"Ok match\", AB25=1, \"Ok match\", AB25=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V26=\"\", \"\", '1.1 Background'!$D$18=V26, 1, '1.1 Background'!$D$18<>V26, 0)","v":""},{"$f":"_xlfn.IFS(W26=\"\", \"\", '1.1 Background'!$D$21=W26, 1, '1.1 Background'!$D$21<>W26, 0)","v":""},{"$f":"_xlfn.IFS(X26=\"\", \"\", '1.1 Background'!$D$22=X26, 1, '1.1 Background'!$D$22<>X26, 0)","v":""},"",{"$f":"_xlfn.IFS(AB26=\"\", \"\", AB26=3, \"Strong match\", AB26=2, \"Ok match\", AB26=1, \"Ok match\", AB26=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V27=\"\", \"\", '1.1 Background'!$D$18=V27, 1, '1.1 Background'!$D$18<>V27, 0)","v":""},{"$f":"_xlfn.IFS(W27=\"\", \"\", '1.1 Background'!$D$21=W27, 1, '1.1 Background'!$D$21<>W27, 0)","v":""},{"$f":"_xlfn.IFS(X27=\"\", \"\", '1.1 Background'!$D$22=X27, 1, '1.1 Background'!$D$22<>X27, 0)","v":""},"",{"$f":"_xlfn.IFS(AB27=\"\", \"\", AB27=3, \"Strong match\", AB27=2, \"Ok match\", AB27=1, \"Ok match\", AB27=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V28=\"\", \"\", '1.1 Background'!$D$18=V28, 1, '1.1 Background'!$D$18<>V28, 0)","v":""},{"$f":"_xlfn.IFS(W28=\"\", \"\", '1.1 Background'!$D$21=W28, 1, '1.1 Background'!$D$21<>W28, 0)","v":""},{"$f":"_xlfn.IFS(X28=\"\", \"\", '1.1 Background'!$D$22=X28, 1, '1.1 Background'!$D$22<>X28, 0)","v":""},"",{"$f":"_xlfn.IFS(AB28=\"\", \"\", AB28=3, \"Strong match\", AB28=2, \"Ok match\", AB28=1, \"Ok match\", AB28=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V29=\"\", \"\", '1.1 Background'!$D$18=V29, 1, '1.1 Background'!$D$18<>V29, 0)","v":""},{"$f":"_xlfn.IFS(W29=\"\", \"\", '1.1 Background'!$D$21=W29, 1, '1.1 Background'!$D$21<>W29, 0)","v":""},{"$f":"_xlfn.IFS(X29=\"\", \"\", '1.1 Background'!$D$22=X29, 1, '1.1 Background'!$D$22<>X29, 0)","v":""},"",{"$f":"_xlfn.IFS(AB29=\"\", \"\", AB29=3, \"Strong match\", AB29=2, \"Ok match\", AB29=1, \"Ok match\", AB29=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V30=\"\", \"\", '1.1 Background'!$D$18=V30, 1, '1.1 Background'!$D$18<>V30, 0)","v":""},{"$f":"_xlfn.IFS(W30=\"\", \"\", '1.1 Background'!$D$21=W30, 1, '1.1 Background'!$D$21<>W30, 0)","v":""},{"$f":"_xlfn.IFS(X30=\"\", \"\", '1.1 Background'!$D$22=X30, 1, '1.1 Background'!$D$22<>X30, 0)","v":""},"",{"$f":"_xlfn.IFS(AB30=\"\", \"\", AB30=3, \"Strong match\", AB30=2, \"Ok match\", AB30=1, \"Ok match\", AB30=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V31=\"\", \"\", '1.1 Background'!$D$18=V31, 1, '1.1 Background'!$D$18<>V31, 0)","v":""},{"$f":"_xlfn.IFS(W31=\"\", \"\", '1.1 Background'!$D$21=W31, 1, '1.1 Background'!$D$21<>W31, 0)","v":""},{"$f":"_xlfn.IFS(X31=\"\", \"\", '1.1 Background'!$D$22=X31, 1, '1.1 Background'!$D$22<>X31, 0)","v":""},"",{"$f":"_xlfn.IFS(AB31=\"\", \"\", AB31=3, \"Strong match\", AB31=2, \"Ok match\", AB31=1, \"Ok match\", AB31=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V32=\"\", \"\", '1.1 Background'!$D$18=V32, 1, '1.1 Background'!$D$18<>V32, 0)","v":""},{"$f":"_xlfn.IFS(W32=\"\", \"\", '1.1 Background'!$D$21=W32, 1, '1.1 Background'!$D$21<>W32, 0)","v":""},{"$f":"_xlfn.IFS(X32=\"\", \"\", '1.1 Background'!$D$22=X32, 1, '1.1 Background'!$D$22<>X32, 0)","v":""},"",{"$f":"_xlfn.IFS(AB32=\"\", \"\", AB32=3, \"Strong match\", AB32=2, \"Ok match\", AB32=1, \"Ok match\", AB32=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V33=\"\", \"\", '1.1 Background'!$D$18=V33, 1, '1.1 Background'!$D$18<>V33, 0)","v":""},{"$f":"_xlfn.IFS(W33=\"\", \"\", '1.1 Background'!$D$21=W33, 1, '1.1 Background'!$D$21<>W33, 0)","v":""},{"$f":"_xlfn.IFS(X33=\"\", \"\", '1.1 Background'!$D$22=X33, 1, '1.1 Background'!$D$22<>X33, 0)","v":""},"",{"$f":"_xlfn.IFS(AB33=\"\", \"\", AB33=3, \"Strong match\", AB33=2, \"Ok match\", AB33=1, \"Ok match\", AB33=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V34=\"\", \"\", '1.1 Background'!$D$18=V34, 1, '1.1 Background'!$D$18<>V34, 0)","v":""},{"$f":"_xlfn.IFS(W34=\"\", \"\", '1.1 Background'!$D$21=W34, 1, '1.1 Background'!$D$21<>W34, 0)","v":""},{"$f":"_xlfn.IFS(X34=\"\", \"\", '1.1 Background'!$D$22=X34, 1, '1.1 Background'!$D$22<>X34, 0)","v":""},"",{"$f":"_xlfn.IFS(AB34=\"\", \"\", AB34=3, \"Strong match\", AB34=2, \"Ok match\", AB34=1, \"Ok match\", AB34=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V35=\"\", \"\", '1.1 Background'!$D$18=V35, 1, '1.1 Background'!$D$18<>V35, 0)","v":""},{"$f":"_xlfn.IFS(W35=\"\", \"\", '1.1 Background'!$D$21=W35, 1, '1.1 Background'!$D$21<>W35, 0)","v":""},{"$f":"_xlfn.IFS(X35=\"\", \"\", '1.1 Background'!$D$22=X35, 1, '1.1 Background'!$D$22<>X35, 0)","v":""},"",{"$f":"_xlfn.IFS(AB35=\"\", \"\", AB35=3, \"Strong match\", AB35=2, \"Ok match\", AB35=1, \"Ok match\", AB35=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V36=\"\", \"\", '1.1 Background'!$D$18=V36, 1, '1.1 Background'!$D$18<>V36, 0)","v":""},{"$f":"_xlfn.IFS(W36=\"\", \"\", '1.1 Background'!$D$21=W36, 1, '1.1 Background'!$D$21<>W36, 0)","v":""},{"$f":"_xlfn.IFS(X36=\"\", \"\", '1.1 Background'!$D$22=X36, 1, '1.1 Background'!$D$22<>X36, 0)","v":""},"",{"$f":"_xlfn.IFS(AB36=\"\", \"\", AB36=3, \"Strong match\", AB36=2, \"Ok match\", AB36=1, \"Ok match\", AB36=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V37=\"\", \"\", '1.1 Background'!$D$18=V37, 1, '1.1 Background'!$D$18<>V37, 0)","v":""},{"$f":"_xlfn.IFS(W37=\"\", \"\", '1.1 Background'!$D$21=W37, 1, '1.1 Background'!$D$21<>W37, 0)","v":""},{"$f":"_xlfn.IFS(X37=\"\", \"\", '1.1 Background'!$D$22=X37, 1, '1.1 Background'!$D$22<>X37, 0)","v":""},"",{"$f":"_xlfn.IFS(AB37=\"\", \"\", AB37=3, \"Strong match\", AB37=2, \"Ok match\", AB37=1, \"Ok match\", AB37=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V38=\"\", \"\", '1.1 Background'!$D$18=V38, 1, '1.1 Background'!$D$18<>V38, 0)","v":""},{"$f":"_xlfn.IFS(W38=\"\", \"\", '1.1 Background'!$D$21=W38, 1, '1.1 Background'!$D$21<>W38, 0)","v":""},{"$f":"_xlfn.IFS(X38=\"\", \"\", '1.1 Background'!$D$22=X38, 1, '1.1 Background'!$D$22<>X38, 0)","v":""},"",{"$f":"_xlfn.IFS(AB38=\"\", \"\", AB38=3, \"Strong match\", AB38=2, \"Ok match\", AB38=1, \"Ok match\", AB38=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V39=\"\", \"\", '1.1 Background'!$D$18=V39, 1, '1.1 Background'!$D$18<>V39, 0)","v":""},{"$f":"_xlfn.IFS(W39=\"\", \"\", '1.1 Background'!$D$21=W39, 1, '1.1 Background'!$D$21<>W39, 0)","v":""},{"$f":"_xlfn.IFS(X39=\"\", \"\", '1.1 Background'!$D$22=X39, 1, '1.1 Background'!$D$22<>X39, 0)","v":""},"",{"$f":"_xlfn.IFS(AB39=\"\", \"\", AB39=3, \"Strong match\", AB39=2, \"Ok match\", AB39=1, \"Ok match\", AB39=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V40=\"\", \"\", '1.1 Background'!$D$18=V40, 1, '1.1 Background'!$D$18<>V40, 0)","v":""},{"$f":"_xlfn.IFS(W40=\"\", \"\", '1.1 Background'!$D$21=W40, 1, '1.1 Background'!$D$21<>W40, 0)","v":""},{"$f":"_xlfn.IFS(X40=\"\", \"\", '1.1 Background'!$D$22=X40, 1, '1.1 Background'!$D$22<>X40, 0)","v":""},"",{"$f":"_xlfn.IFS(AB40=\"\", \"\", AB40=3, \"Strong match\", AB40=2, \"Ok match\", AB40=1, \"Ok match\", AB40=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V41=\"\", \"\", '1.1 Background'!$D$18=V41, 1, '1.1 Background'!$D$18<>V41, 0)","v":""},{"$f":"_xlfn.IFS(W41=\"\", \"\", '1.1 Background'!$D$21=W41, 1, '1.1 Background'!$D$21<>W41, 0)","v":""},{"$f":"_xlfn.IFS(X41=\"\", \"\", '1.1 Background'!$D$22=X41, 1, '1.1 Background'!$D$22<>X41, 0)","v":""},"",{"$f":"_xlfn.IFS(AB41=\"\", \"\", AB41=3, \"Strong match\", AB41=2, \"Ok match\", AB41=1, \"Ok match\", AB41=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V42=\"\", \"\", '1.1 Background'!$D$18=V42, 1, '1.1 Background'!$D$18<>V42, 0)","v":""},{"$f":"_xlfn.IFS(W42=\"\", \"\", '1.1 Background'!$D$21=W42, 1, '1.1 Background'!$D$21<>W42, 0)","v":""},{"$f":"_xlfn.IFS(X42=\"\", \"\", '1.1 Background'!$D$22=X42, 1, '1.1 Background'!$D$22<>X42, 0)","v":""},"",{"$f":"_xlfn.IFS(AB42=\"\", \"\", AB42=3, \"Strong match\", AB42=2, \"Ok match\", AB42=1, \"Ok match\", AB42=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V43=\"\", \"\", '1.1 Background'!$D$18=V43, 1, '1.1 Background'!$D$18<>V43, 0)","v":""},{"$f":"_xlfn.IFS(W43=\"\", \"\", '1.1 Background'!$D$21=W43, 1, '1.1 Background'!$D$21<>W43, 0)","v":""},{"$f":"_xlfn.IFS(X43=\"\", \"\", '1.1 Background'!$D$22=X43, 1, '1.1 Background'!$D$22<>X43, 0)","v":""},"",{"$f":"_xlfn.IFS(AB43=\"\", \"\", AB43=3, \"Strong match\", AB43=2, \"Ok match\", AB43=1, \"Ok match\", AB43=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V44=\"\", \"\", '1.1 Background'!$D$18=V44, 1, '1.1 Background'!$D$18<>V44, 0)","v":""},{"$f":"_xlfn.IFS(W44=\"\", \"\", '1.1 Background'!$D$21=W44, 1, '1.1 Background'!$D$21<>W44, 0)","v":""},{"$f":"_xlfn.IFS(X44=\"\", \"\", '1.1 Background'!$D$22=X44, 1, '1.1 Background'!$D$22<>X44, 0)","v":""},"",{"$f":"_xlfn.IFS(AB44=\"\", \"\", AB44=3, \"Strong match\", AB44=2, \"Ok match\", AB44=1, \"Ok match\", AB44=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V45=\"\", \"\", '1.1 Background'!$D$18=V45, 1, '1.1 Background'!$D$18<>V45, 0)","v":""},{"$f":"_xlfn.IFS(W45=\"\", \"\", '1.1 Background'!$D$21=W45, 1, '1.1 Background'!$D$21<>W45, 0)","v":""},{"$f":"_xlfn.IFS(X45=\"\", \"\", '1.1 Background'!$D$22=X45, 1, '1.1 Background'!$D$22<>X45, 0)","v":""},"",{"$f":"_xlfn.IFS(AB45=\"\", \"\", AB45=3, \"Strong match\", AB45=2, \"Ok match\", AB45=1, \"Ok match\", AB45=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V46=\"\", \"\", '1.1 Background'!$D$18=V46, 1, '1.1 Background'!$D$18<>V46, 0)","v":""},{"$f":"_xlfn.IFS(W46=\"\", \"\", '1.1 Background'!$D$21=W46, 1, '1.1 Background'!$D$21<>W46, 0)","v":""},{"$f":"_xlfn.IFS(X46=\"\", \"\", '1.1 Background'!$D$22=X46, 1, '1.1 Background'!$D$22<>X46, 0)","v":""},"",{"$f":"_xlfn.IFS(AB46=\"\", \"\", AB46=3, \"Strong match\", AB46=2, \"Ok match\", AB46=1, \"Ok match\", AB46=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V47=\"\", \"\", '1.1 Background'!$D$18=V47, 1, '1.1 Background'!$D$18<>V47, 0)","v":""},{"$f":"_xlfn.IFS(W47=\"\", \"\", '1.1 Background'!$D$21=W47, 1, '1.1 Background'!$D$21<>W47, 0)","v":""},{"$f":"_xlfn.IFS(X47=\"\", \"\", '1.1 Background'!$D$22=X47, 1, '1.1 Background'!$D$22<>X47, 0)","v":""},"",{"$f":"_xlfn.IFS(AB47=\"\", \"\", AB47=3, \"Strong match\", AB47=2, \"Ok match\", AB47=1, \"Ok match\", AB47=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V48=\"\", \"\", '1.1 Background'!$D$18=V48, 1, '1.1 Background'!$D$18<>V48, 0)","v":""},{"$f":"_xlfn.IFS(W48=\"\", \"\", '1.1 Background'!$D$21=W48, 1, '1.1 Background'!$D$21<>W48, 0)","v":""},{"$f":"_xlfn.IFS(X48=\"\", \"\", '1.1 Background'!$D$22=X48, 1, '1.1 Background'!$D$22<>X48, 0)","v":""},"",{"$f":"_xlfn.IFS(AB48=\"\", \"\", AB48=3, \"Strong match\", AB48=2, \"Ok match\", AB48=1, \"Ok match\", AB48=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V49=\"\", \"\", '1.1 Background'!$D$18=V49, 1, '1.1 Background'!$D$18<>V49, 0)","v":""},{"$f":"_xlfn.IFS(W49=\"\", \"\", '1.1 Background'!$D$21=W49, 1, '1.1 Background'!$D$21<>W49, 0)","v":""},{"$f":"_xlfn.IFS(X49=\"\", \"\", '1.1 Background'!$D$22=X49, 1, '1.1 Background'!$D$22<>X49, 0)","v":""},"",{"$f":"_xlfn.IFS(AB49=\"\", \"\", AB49=3, \"Strong match\", AB49=2, \"Ok match\", AB49=1, \"Ok match\", AB49=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V50=\"\", \"\", '1.1 Background'!$D$18=V50, 1, '1.1 Background'!$D$18<>V50, 0)","v":""},{"$f":"_xlfn.IFS(W50=\"\", \"\", '1.1 Background'!$D$21=W50, 1, '1.1 Background'!$D$21<>W50, 0)","v":""},{"$f":"_xlfn.IFS(X50=\"\", \"\", '1.1 Background'!$D$22=X50, 1, '1.1 Background'!$D$22<>X50, 0)","v":""},"",{"$f":"_xlfn.IFS(AB50=\"\", \"\", AB50=3, \"Strong match\", AB50=2, \"Ok match\", AB50=1, \"Ok match\", AB50=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O51>=10,\"Data 10 years or older\",O51)","v":0},{"$f":"IF(N51=M51, \"No\", \"Yes\")","v":"No"},null,null,null,{"$f":"_xlfn.IFS(V51=\"\", \"\", '1.1 Background'!$D$18=V51, 1, '1.1 Background'!$D$18<>V51, 0)","v":""},{"$f":"_xlfn.IFS(W51=\"\", \"\", '1.1 Background'!$D$21=W51, 1, '1.1 Background'!$D$21<>W51, 0)","v":""},{"$f":"_xlfn.IFS(X51=\"\", \"\", '1.1 Background'!$D$22=X51, 1, '1.1 Background'!$D$22<>X51, 0)","v":""},{"$f":"IF(Y51=\"\", \"\", (SUM(Y51:AA51)))","v":""},{"$f":"_xlfn.IFS(AB51=\"\", \"\", AB51=3, \"Strong match\", AB51=2, \"Ok match\", AB51=1, \"Ok match\", AB51=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V52=\"\", \"\", '1.1 Background'!$D$18=V52, 1, '1.1 Background'!$D$18<>V52, 0)","v":""},{"$f":"_xlfn.IFS(W52=\"\", \"\", '1.1 Background'!$D$21=W52, 1, '1.1 Background'!$D$21<>W52, 0)","v":""},{"$f":"_xlfn.IFS(X52=\"\", \"\", '1.1 Background'!$D$22=X52, 1, '1.1 Background'!$D$22<>X52, 0)","v":""},"",{"$f":"_xlfn.IFS(AB52=\"\", \"\", AB52=3, \"Strong match\", AB52=2, \"Ok match\", AB52=1, \"Ok match\", AB52=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V53=\"\", \"\", '1.1 Background'!$D$18=V53, 1, '1.1 Background'!$D$18<>V53, 0)","v":""},{"$f":"_xlfn.IFS(W53=\"\", \"\", '1.1 Background'!$D$21=W53, 1, '1.1 Background'!$D$21<>W53, 0)","v":""},{"$f":"_xlfn.IFS(X53=\"\", \"\", '1.1 Background'!$D$22=X53, 1, '1.1 Background'!$D$22<>X53, 0)","v":""},"",{"$f":"_xlfn.IFS(AB53=\"\", \"\", AB53=3, \"Strong match\", AB53=2, \"Ok match\", AB53=1, \"Ok match\", AB53=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V54=\"\", \"\", '1.1 Background'!$D$18=V54, 1, '1.1 Background'!$D$18<>V54, 0)","v":""},{"$f":"_xlfn.IFS(W54=\"\", \"\", '1.1 Background'!$D$21=W54, 1, '1.1 Background'!$D$21<>W54, 0)","v":""},{"$f":"_xlfn.IFS(X54=\"\", \"\", '1.1 Background'!$D$22=X54, 1, '1.1 Background'!$D$22<>X54, 0)","v":""},"",{"$f":"_xlfn.IFS(AB54=\"\", \"\", AB54=3, \"Strong match\", AB54=2, \"Ok match\", AB54=1, \"Ok match\", AB54=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V55=\"\", \"\", '1.1 Background'!$D$18=V55, 1, '1.1 Background'!$D$18<>V55, 0)","v":""},{"$f":"_xlfn.IFS(W55=\"\", \"\", '1.1 Background'!$D$21=W55, 1, '1.1 Background'!$D$21<>W55, 0)","v":""},{"$f":"_xlfn.IFS(X55=\"\", \"\", '1.1 Background'!$D$22=X55, 1, '1.1 Background'!$D$22<>X55, 0)","v":""},"",{"$f":"_xlfn.IFS(AB55=\"\", \"\", AB55=3, \"Strong match\", AB55=2, \"Ok match\", AB55=1, \"Ok match\", AB55=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V56=\"\", \"\", '1.1 Background'!$D$18=V56, 1, '1.1 Background'!$D$18<>V56, 0)","v":""},{"$f":"_xlfn.IFS(W56=\"\", \"\", '1.1 Background'!$D$21=W56, 1, '1.1 Background'!$D$21<>W56, 0)","v":""},{"$f":"_xlfn.IFS(X56=\"\", \"\", '1.1 Background'!$D$22=X56, 1, '1.1 Background'!$D$22<>X56, 0)","v":""},"",{"$f":"_xlfn.IFS(AB56=\"\", \"\", AB56=3, \"Strong match\", AB56=2, \"Ok match\", AB56=1, \"Ok match\", AB56=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V57=\"\", \"\", '1.1 Background'!$D$18=V57, 1, '1.1 Background'!$D$18<>V57, 0)","v":""},{"$f":"_xlfn.IFS(W57=\"\", \"\", '1.1 Background'!$D$21=W57, 1, '1.1 Background'!$D$21<>W57, 0)","v":""},{"$f":"_xlfn.IFS(X57=\"\", \"\", '1.1 Background'!$D$22=X57, 1, '1.1 Background'!$D$22<>X57, 0)","v":""},"",{"$f":"_xlfn.IFS(AB57=\"\", \"\", AB57=3, \"Strong match\", AB57=2, \"Ok match\", AB57=1, \"Ok match\", AB57=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V58=\"\", \"\", '1.1 Background'!$D$18=V58, 1, '1.1 Background'!$D$18<>V58, 0)","v":""},{"$f":"_xlfn.IFS(W58=\"\", \"\", '1.1 Background'!$D$21=W58, 1, '1.1 Background'!$D$21<>W58, 0)","v":""},{"$f":"_xlfn.IFS(X58=\"\", \"\", '1.1 Background'!$D$22=X58, 1, '1.1 Background'!$D$22<>X58, 0)","v":""},"",{"$f":"_xlfn.IFS(AB58=\"\", \"\", AB58=3, \"Strong match\", AB58=2, \"Ok match\", AB58=1, \"Ok match\", AB58=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V59=\"\", \"\", '1.1 Background'!$D$18=V59, 1, '1.1 Background'!$D$18<>V59, 0)","v":""},{"$f":"_xlfn.IFS(W59=\"\", \"\", '1.1 Background'!$D$21=W59, 1, '1.1 Background'!$D$21<>W59, 0)","v":""},{"$f":"_xlfn.IFS(X59=\"\", \"\", '1.1 Background'!$D$22=X59, 1, '1.1 Background'!$D$22<>X59, 0)","v":""},"",{"$f":"_xlfn.IFS(AB59=\"\", \"\", AB59=3, \"Strong match\", AB59=2, \"Ok match\", AB59=1, \"Ok match\", AB59=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V60=\"\", \"\", '1.1 Background'!$D$18=V60, 1, '1.1 Background'!$D$18<>V60, 0)","v":""},{"$f":"_xlfn.IFS(W60=\"\", \"\", '1.1 Background'!$D$21=W60, 1, '1.1 Background'!$D$21<>W60, 0)","v":""},{"$f":"_xlfn.IFS(X60=\"\", \"\", '1.1 Background'!$D$22=X60, 1, '1.1 Background'!$D$22<>X60, 0)","v":""},"",{"$f":"_xlfn.IFS(AB60=\"\", \"\", AB60=3, \"Strong match\", AB60=2, \"Ok match\", AB60=1, \"Ok match\", AB60=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V61=\"\", \"\", '1.1 Background'!$D$18=V61, 1, '1.1 Background'!$D$18<>V61, 0)","v":""},{"$f":"_xlfn.IFS(W61=\"\", \"\", '1.1 Background'!$D$21=W61, 1, '1.1 Background'!$D$21<>W61, 0)","v":""},{"$f":"_xlfn.IFS(X61=\"\", \"\", '1.1 Background'!$D$22=X61, 1, '1.1 Background'!$D$22<>X61, 0)","v":""},"",{"$f":"_xlfn.IFS(AB61=\"\", \"\", AB61=3, \"Strong match\", AB61=2, \"Ok match\", AB61=1, \"Ok match\", AB61=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V62=\"\", \"\", '1.1 Background'!$D$18=V62, 1, '1.1 Background'!$D$18<>V62, 0)","v":""},{"$f":"_xlfn.IFS(W62=\"\", \"\", '1.1 Background'!$D$21=W62, 1, '1.1 Background'!$D$21<>W62, 0)","v":""},{"$f":"_xlfn.IFS(X62=\"\", \"\", '1.1 Background'!$D$22=X62, 1, '1.1 Background'!$D$22<>X62, 0)","v":""},"",{"$f":"_xlfn.IFS(AB62=\"\", \"\", AB62=3, \"Strong match\", AB62=2, \"Ok match\", AB62=1, \"Ok match\", AB62=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V63=\"\", \"\", '1.1 Background'!$D$18=V63, 1, '1.1 Background'!$D$18<>V63, 0)","v":""},{"$f":"_xlfn.IFS(W63=\"\", \"\", '1.1 Background'!$D$21=W63, 1, '1.1 Background'!$D$21<>W63, 0)","v":""},{"$f":"_xlfn.IFS(X63=\"\", \"\", '1.1 Background'!$D$22=X63, 1, '1.1 Background'!$D$22<>X63, 0)","v":""},"",{"$f":"_xlfn.IFS(AB63=\"\", \"\", AB63=3, \"Strong match\", AB63=2, \"Ok match\", AB63=1, \"Ok match\", AB63=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V64=\"\", \"\", '1.1 Background'!$D$18=V64, 1, '1.1 Background'!$D$18<>V64, 0)","v":""},{"$f":"_xlfn.IFS(W64=\"\", \"\", '1.1 Background'!$D$21=W64, 1, '1.1 Background'!$D$21<>W64, 0)","v":""},{"$f":"_xlfn.IFS(X64=\"\", \"\", '1.1 Background'!$D$22=X64, 1, '1.1 Background'!$D$22<>X64, 0)","v":""},"",{"$f":"_xlfn.IFS(AB64=\"\", \"\", AB64=3, \"Strong match\", AB64=2, \"Ok match\", AB64=1, \"Ok match\", AB64=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V65=\"\", \"\", '1.1 Background'!$D$18=V65, 1, '1.1 Background'!$D$18<>V65, 0)","v":""},{"$f":"_xlfn.IFS(W65=\"\", \"\", '1.1 Background'!$D$21=W65, 1, '1.1 Background'!$D$21<>W65, 0)","v":""},{"$f":"_xlfn.IFS(X65=\"\", \"\", '1.1 Background'!$D$22=X65, 1, '1.1 Background'!$D$22<>X65, 0)","v":""},"",{"$f":"_xlfn.IFS(AB65=\"\", \"\", AB65=3, \"Strong match\", AB65=2, \"Ok match\", AB65=1, \"Ok match\", AB65=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V66=\"\", \"\", '1.1 Background'!$D$18=V66, 1, '1.1 Background'!$D$18<>V66, 0)","v":""},{"$f":"_xlfn.IFS(W66=\"\", \"\", '1.1 Background'!$D$21=W66, 1, '1.1 Background'!$D$21<>W66, 0)","v":""},{"$f":"_xlfn.IFS(X66=\"\", \"\", '1.1 Background'!$D$22=X66, 1, '1.1 Background'!$D$22<>X66, 0)","v":""},"",{"$f":"_xlfn.IFS(AB66=\"\", \"\", AB66=3, \"Strong match\", AB66=2, \"Ok match\", AB66=1, \"Ok match\", AB66=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V67=\"\", \"\", '1.1 Background'!$D$18=V67, 1, '1.1 Background'!$D$18<>V67, 0)","v":""},{"$f":"_xlfn.IFS(W67=\"\", \"\", '1.1 Background'!$D$21=W67, 1, '1.1 Background'!$D$21<>W67, 0)","v":""},{"$f":"_xlfn.IFS(X67=\"\", \"\", '1.1 Background'!$D$22=X67, 1, '1.1 Background'!$D$22<>X67, 0)","v":""},"",{"$f":"_xlfn.IFS(AB67=\"\", \"\", AB67=3, \"Strong match\", AB67=2, \"Ok match\", AB67=1, \"Ok match\", AB67=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V68=\"\", \"\", '1.1 Background'!$D$18=V68, 1, '1.1 Background'!$D$18<>V68, 0)","v":""},{"$f":"_xlfn.IFS(W68=\"\", \"\", '1.1 Background'!$D$21=W68, 1, '1.1 Background'!$D$21<>W68, 0)","v":""},{"$f":"_xlfn.IFS(X68=\"\", \"\", '1.1 Background'!$D$22=X68, 1, '1.1 Background'!$D$22<>X68, 0)","v":""},"",{"$f":"_xlfn.IFS(AB68=\"\", \"\", AB68=3, \"Strong match\", AB68=2, \"Ok match\", AB68=1, \"Ok match\", AB68=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V69=\"\", \"\", '1.1 Background'!$D$18=V69, 1, '1.1 Background'!$D$18<>V69, 0)","v":""},{"$f":"_xlfn.IFS(W69=\"\", \"\", '1.1 Background'!$D$21=W69, 1, '1.1 Background'!$D$21<>W69, 0)","v":""},{"$f":"_xlfn.IFS(X69=\"\", \"\", '1.1 Background'!$D$22=X69, 1, '1.1 Background'!$D$22<>X69, 0)","v":""},"",{"$f":"_xlfn.IFS(AB69=\"\", \"\", AB69=3, \"Strong match\", AB69=2, \"Ok match\", AB69=1, \"Ok match\", AB69=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V70=\"\", \"\", '1.1 Background'!$D$18=V70, 1, '1.1 Background'!$D$18<>V70, 0)","v":""},{"$f":"_xlfn.IFS(W70=\"\", \"\", '1.1 Background'!$D$21=W70, 1, '1.1 Background'!$D$21<>W70, 0)","v":""},{"$f":"_xlfn.IFS(X70=\"\", \"\", '1.1 Background'!$D$22=X70, 1, '1.1 Background'!$D$22<>X70, 0)","v":""},"",{"$f":"_xlfn.IFS(AB70=\"\", \"\", AB70=3, \"Strong match\", AB70=2, \"Ok match\", AB70=1, \"Ok match\", AB70=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V71=\"\", \"\", '1.1 Background'!$D$18=V71, 1, '1.1 Background'!$D$18<>V71, 0)","v":""},{"$f":"_xlfn.IFS(W71=\"\", \"\", '1.1 Background'!$D$21=W71, 1, '1.1 Background'!$D$21<>W71, 0)","v":""},{"$f":"_xlfn.IFS(X71=\"\", \"\", '1.1 Background'!$D$22=X71, 1, '1.1 Background'!$D$22<>X71, 0)","v":""},"",{"$f":"_xlfn.IFS(AB71=\"\", \"\", AB71=3, \"Strong match\", AB71=2, \"Ok match\", AB71=1, \"Ok match\", AB71=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V72=\"\", \"\", '1.1 Background'!$D$18=V72, 1, '1.1 Background'!$D$18<>V72, 0)","v":""},{"$f":"_xlfn.IFS(W72=\"\", \"\", '1.1 Background'!$D$21=W72, 1, '1.1 Background'!$D$21<>W72, 0)","v":""},{"$f":"_xlfn.IFS(X72=\"\", \"\", '1.1 Background'!$D$22=X72, 1, '1.1 Background'!$D$22<>X72, 0)","v":""},"",{"$f":"_xlfn.IFS(AB72=\"\", \"\", AB72=3, \"Strong match\", AB72=2, \"Ok match\", AB72=1, \"Ok match\", AB72=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V73=\"\", \"\", '1.1 Background'!$D$18=V73, 1, '1.1 Background'!$D$18<>V73, 0)","v":""},{"$f":"_xlfn.IFS(W73=\"\", \"\", '1.1 Background'!$D$21=W73, 1, '1.1 Background'!$D$21<>W73, 0)","v":""},{"$f":"_xlfn.IFS(X73=\"\", \"\", '1.1 Background'!$D$22=X73, 1, '1.1 Background'!$D$22<>X73, 0)","v":""},"",{"$f":"_xlfn.IFS(AB73=\"\", \"\", AB73=3, \"Strong match\", AB73=2, \"Ok match\", AB73=1, \"Ok match\", AB73=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V74=\"\", \"\", '1.1 Background'!$D$18=V74, 1, '1.1 Background'!$D$18<>V74, 0)","v":""},{"$f":"_xlfn.IFS(W74=\"\", \"\", '1.1 Background'!$D$21=W74, 1, '1.1 Background'!$D$21<>W74, 0)","v":""},{"$f":"_xlfn.IFS(X74=\"\", \"\", '1.1 Background'!$D$22=X74, 1, '1.1 Background'!$D$22<>X74, 0)","v":""},"",{"$f":"_xlfn.IFS(AB74=\"\", \"\", AB74=3, \"Strong match\", AB74=2, \"Ok match\", AB74=1, \"Ok match\", AB74=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V75=\"\", \"\", '1.1 Background'!$D$18=V75, 1, '1.1 Background'!$D$18<>V75, 0)","v":""},{"$f":"_xlfn.IFS(W75=\"\", \"\", '1.1 Background'!$D$21=W75, 1, '1.1 Background'!$D$21<>W75, 0)","v":""},{"$f":"_xlfn.IFS(X75=\"\", \"\", '1.1 Background'!$D$22=X75, 1, '1.1 Background'!$D$22<>X75, 0)","v":""},"",{"$f":"_xlfn.IFS(AB75=\"\", \"\", AB75=3, \"Strong match\", AB75=2, \"Ok match\", AB75=1, \"Ok match\", AB75=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V76=\"\", \"\", '1.1 Background'!$D$18=V76, 1, '1.1 Background'!$D$18<>V76, 0)","v":""},{"$f":"_xlfn.IFS(W76=\"\", \"\", '1.1 Background'!$D$21=W76, 1, '1.1 Background'!$D$21<>W76, 0)","v":""},{"$f":"_xlfn.IFS(X76=\"\", \"\", '1.1 Background'!$D$22=X76, 1, '1.1 Background'!$D$22<>X76, 0)","v":""},"",{"$f":"_xlfn.IFS(AB76=\"\", \"\", AB76=3, \"Strong match\", AB76=2, \"Ok match\", AB76=1, \"Ok match\", AB76=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V77=\"\", \"\", '1.1 Background'!$D$18=V77, 1, '1.1 Background'!$D$18<>V77, 0)","v":""},{"$f":"_xlfn.IFS(W77=\"\", \"\", '1.1 Background'!$D$21=W77, 1, '1.1 Background'!$D$21<>W77, 0)","v":""},{"$f":"_xlfn.IFS(X77=\"\", \"\", '1.1 Background'!$D$22=X77, 1, '1.1 Background'!$D$22<>X77, 0)","v":""},"",{"$f":"_xlfn.IFS(AB77=\"\", \"\", AB77=3, \"Strong match\", AB77=2, \"Ok match\", AB77=1, \"Ok match\", AB77=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V78=\"\", \"\", '1.1 Background'!$D$18=V78, 1, '1.1 Background'!$D$18<>V78, 0)","v":""},{"$f":"_xlfn.IFS(W78=\"\", \"\", '1.1 Background'!$D$21=W78, 1, '1.1 Background'!$D$21<>W78, 0)","v":""},{"$f":"_xlfn.IFS(X78=\"\", \"\", '1.1 Background'!$D$22=X78, 1, '1.1 Background'!$D$22<>X78, 0)","v":""},"",{"$f":"_xlfn.IFS(AB78=\"\", \"\", AB78=3, \"Strong match\", AB78=2, \"Ok match\", AB78=1, \"Ok match\", AB78=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V79=\"\", \"\", '1.1 Background'!$D$18=V79, 1, '1.1 Background'!$D$18<>V79, 0)","v":""},{"$f":"_xlfn.IFS(W79=\"\", \"\", '1.1 Background'!$D$21=W79, 1, '1.1 Background'!$D$21<>W79, 0)","v":""},{"$f":"_xlfn.IFS(X79=\"\", \"\", '1.1 Background'!$D$22=X79, 1, '1.1 Background'!$D$22<>X79, 0)","v":""},"",{"$f":"_xlfn.IFS(AB79=\"\", \"\", AB79=3, \"Strong match\", AB79=2, \"Ok match\", AB79=1, \"Ok match\", AB79=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V80=\"\", \"\", '1.1 Background'!$D$18=V80, 1, '1.1 Background'!$D$18<>V80, 0)","v":""},{"$f":"_xlfn.IFS(W80=\"\", \"\", '1.1 Background'!$D$21=W80, 1, '1.1 Background'!$D$21<>W80, 0)","v":""},{"$f":"_xlfn.IFS(X80=\"\", \"\", '1.1 Background'!$D$22=X80, 1, '1.1 Background'!$D$22<>X80, 0)","v":""},"",{"$f":"_xlfn.IFS(AB80=\"\", \"\", AB80=3, \"Strong match\", AB80=2, \"Ok match\", AB80=1, \"Ok match\", AB80=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V81=\"\", \"\", '1.1 Background'!$D$18=V81, 1, '1.1 Background'!$D$18<>V81, 0)","v":""},{"$f":"_xlfn.IFS(W81=\"\", \"\", '1.1 Background'!$D$21=W81, 1, '1.1 Background'!$D$21<>W81, 0)","v":""},{"$f":"_xlfn.IFS(X81=\"\", \"\", '1.1 Background'!$D$22=X81, 1, '1.1 Background'!$D$22<>X81, 0)","v":""},"",{"$f":"_xlfn.IFS(AB81=\"\", \"\", AB81=3, \"Strong match\", AB81=2, \"Ok match\", AB81=1, \"Ok match\", AB81=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V82=\"\", \"\", '1.1 Background'!$D$18=V82, 1, '1.1 Background'!$D$18<>V82, 0)","v":""},{"$f":"_xlfn.IFS(W82=\"\", \"\", '1.1 Background'!$D$21=W82, 1, '1.1 Background'!$D$21<>W82, 0)","v":""},{"$f":"_xlfn.IFS(X82=\"\", \"\", '1.1 Background'!$D$22=X82, 1, '1.1 Background'!$D$22<>X82, 0)","v":""},"",{"$f":"_xlfn.IFS(AB82=\"\", \"\", AB82=3, \"Strong match\", AB82=2, \"Ok match\", AB82=1, \"Ok match\", AB82=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V83=\"\", \"\", '1.1 Background'!$D$18=V83, 1, '1.1 Background'!$D$18<>V83, 0)","v":""},{"$f":"_xlfn.IFS(W83=\"\", \"\", '1.1 Background'!$D$21=W83, 1, '1.1 Background'!$D$21<>W83, 0)","v":""},{"$f":"_xlfn.IFS(X83=\"\", \"\", '1.1 Background'!$D$22=X83, 1, '1.1 Background'!$D$22<>X83, 0)","v":""},"",{"$f":"_xlfn.IFS(AB83=\"\", \"\", AB83=3, \"Strong match\", AB83=2, \"Ok match\", AB83=1, \"Ok match\", AB83=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V84=\"\", \"\", '1.1 Background'!$D$18=V84, 1, '1.1 Background'!$D$18<>V84, 0)","v":""},{"$f":"_xlfn.IFS(W84=\"\", \"\", '1.1 Background'!$D$21=W84, 1, '1.1 Background'!$D$21<>W84, 0)","v":""},{"$f":"_xlfn.IFS(X84=\"\", \"\", '1.1 Background'!$D$22=X84, 1, '1.1 Background'!$D$22<>X84, 0)","v":""},"",{"$f":"_xlfn.IFS(AB84=\"\", \"\", AB84=3, \"Strong match\", AB84=2, \"Ok match\", AB84=1, \"Ok match\", AB84=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V85=\"\", \"\", '1.1 Background'!$D$18=V85, 1, '1.1 Background'!$D$18<>V85, 0)","v":""},{"$f":"_xlfn.IFS(W85=\"\", \"\", '1.1 Background'!$D$21=W85, 1, '1.1 Background'!$D$21<>W85, 0)","v":""},{"$f":"_xlfn.IFS(X85=\"\", \"\", '1.1 Background'!$D$22=X85, 1, '1.1 Background'!$D$22<>X85, 0)","v":""},"",{"$f":"_xlfn.IFS(AB85=\"\", \"\", AB85=3, \"Strong match\", AB85=2, \"Ok match\", AB85=1, \"Ok match\", AB85=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V86=\"\", \"\", '1.1 Background'!$D$18=V86, 1, '1.1 Background'!$D$18<>V86, 0)","v":""},{"$f":"_xlfn.IFS(W86=\"\", \"\", '1.1 Background'!$D$21=W86, 1, '1.1 Background'!$D$21<>W86, 0)","v":""},{"$f":"_xlfn.IFS(X86=\"\", \"\", '1.1 Background'!$D$22=X86, 1, '1.1 Background'!$D$22<>X86, 0)","v":""},"",{"$f":"_xlfn.IFS(AB86=\"\", \"\", AB86=3, \"Strong match\", AB86=2, \"Ok match\", AB86=1, \"Ok match\", AB86=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V87=\"\", \"\", '1.1 Background'!$D$18=V87, 1, '1.1 Background'!$D$18<>V87, 0)","v":""},{"$f":"_xlfn.IFS(W87=\"\", \"\", '1.1 Background'!$D$21=W87, 1, '1.1 Background'!$D$21<>W87, 0)","v":""},{"$f":"_xlfn.IFS(X87=\"\", \"\", '1.1 Background'!$D$22=X87, 1, '1.1 Background'!$D$22<>X87, 0)","v":""},"",{"$f":"_xlfn.IFS(AB87=\"\", \"\", AB87=3, \"Strong match\", AB87=2, \"Ok match\", AB87=1, \"Ok match\", AB87=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V88=\"\", \"\", '1.1 Background'!$D$18=V88, 1, '1.1 Background'!$D$18<>V88, 0)","v":""},{"$f":"_xlfn.IFS(W88=\"\", \"\", '1.1 Background'!$D$21=W88, 1, '1.1 Background'!$D$21<>W88, 0)","v":""},{"$f":"_xlfn.IFS(X88=\"\", \"\", '1.1 Background'!$D$22=X88, 1, '1.1 Background'!$D$22<>X88, 0)","v":""},"",{"$f":"_xlfn.IFS(AB88=\"\", \"\", AB88=3, \"Strong match\", AB88=2, \"Ok match\", AB88=1, \"Ok match\", AB88=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V89=\"\", \"\", '1.1 Background'!$D$18=V89, 1, '1.1 Background'!$D$18<>V89, 0)","v":""},{"$f":"_xlfn.IFS(W89=\"\", \"\", '1.1 Background'!$D$21=W89, 1, '1.1 Background'!$D$21<>W89, 0)","v":""},{"$f":"_xlfn.IFS(X89=\"\", \"\", '1.1 Background'!$D$22=X89, 1, '1.1 Background'!$D$22<>X89, 0)","v":""},"",{"$f":"_xlfn.IFS(AB89=\"\", \"\", AB89=3, \"Strong match\", AB89=2, \"Ok match\", AB89=1, \"Ok match\", AB89=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V90=\"\", \"\", '1.1 Background'!$D$18=V90, 1, '1.1 Background'!$D$18<>V90, 0)","v":""},{"$f":"_xlfn.IFS(W90=\"\", \"\", '1.1 Background'!$D$21=W90, 1, '1.1 Background'!$D$21<>W90, 0)","v":""},{"$f":"_xlfn.IFS(X90=\"\", \"\", '1.1 Background'!$D$22=X90, 1, '1.1 Background'!$D$22<>X90, 0)","v":""},"",{"$f":"_xlfn.IFS(AB90=\"\", \"\", AB90=3, \"Strong match\", AB90=2, \"Ok match\", AB90=1, \"Ok match\", AB90=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(N91=M91, \"No\", \"Yes\")","v":"No"},null,null,null,{"$f":"_xlfn.IFS(V91=\"\", \"\", '1.1 Background'!$D$18=V91, 1, '1.1 Background'!$D$18<>V91, 0)","v":""},{"$f":"_xlfn.IFS(W91=\"\", \"\", '1.1 Background'!$D$21=W91, 1, '1.1 Background'!$D$21<>W91, 0)","v":""},{"$f":"_xlfn.IFS(X91=\"\", \"\", '1.1 Background'!$D$22=X91, 1, '1.1 Background'!$D$22<>X91, 0)","v":""},"",{"$f":"_xlfn.IFS(AB91=\"\", \"\", AB91=3, \"Strong match\", AB91=2, \"Ok match\", AB91=1, \"Ok match\", AB91=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V92=\"\", \"\", '1.1 Background'!$D$18=V92, 1, '1.1 Background'!$D$18<>V92, 0)","v":""},{"$f":"_xlfn.IFS(W92=\"\", \"\", '1.1 Background'!$D$21=W92, 1, '1.1 Background'!$D$21<>W92, 0)","v":""},{"$f":"_xlfn.IFS(X92=\"\", \"\", '1.1 Background'!$D$22=X92, 1, '1.1 Background'!$D$22<>X92, 0)","v":""},"",{"$f":"_xlfn.IFS(AB92=\"\", \"\", AB92=3, \"Strong match\", AB92=2, \"Ok match\", AB92=1, \"Ok match\", AB92=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V93=\"\", \"\", '1.1 Background'!$D$18=V93, 1, '1.1 Background'!$D$18<>V93, 0)","v":""},{"$f":"_xlfn.IFS(W93=\"\", \"\", '1.1 Background'!$D$21=W93, 1, '1.1 Background'!$D$21<>W93, 0)","v":""},{"$f":"_xlfn.IFS(X93=\"\", \"\", '1.1 Background'!$D$22=X93, 1, '1.1 Background'!$D$22<>X93, 0)","v":""},"",{"$f":"_xlfn.IFS(AB93=\"\", \"\", AB93=3, \"Strong match\", AB93=2, \"Ok match\", AB93=1, \"Ok match\", AB93=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,{"$f":"_xlfn.IFS(V94=\"\", \"\", '1.1 Background'!$D$18=V94, 1, '1.1 Background'!$D$18<>V94, 0)","v":""},{"$f":"_xlfn.IFS(W94=\"\", \"\", '1.1 Background'!$D$21=W94, 1, '1.1 Background'!$D$21<>W94, 0)","v":""},{"$f":"_xlfn.IFS(X94=\"\", \"\", '1.1 Background'!$D$22=X94, 1, '1.1 Background'!$D$22<>X94, 0)","v":""},"",{"$f":"_xlfn.IFS(AB94=\"\", \"\", AB94=3, \"Strong match\", AB94=2, \"Ok match\", AB94=1, \"Ok match\", AB94=0, \"No match\")","v":""},null,"Match"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"No",null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(AB95=\"\", \"\", AB95=3, \"Strong match\", AB95=2, \"Ok match\", AB95=1, \"Ok match\", AB95=0, \"No match\")","v":""},null,"Match"]

{"sheet":"2.2 Adaptation Calcs","index":8,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[14,7,15,7],[14,8,15,8],[14,9,15,9],[13,2,13,3],[14,1,15,1],[14,2,14,3],[14,4,15,4],[14,5,15,5],[14,6,15,6]]}
[]
[]
[null,"CHAPTER 7: COLLECTING AND ADAPTING UNIT COSTS"]
[]
[null,"The adaptation approach"]
[]
[]
[]
[null,"Adaptation Calculations for Previously Estimated Unit Costs"]
[null,"This is a template that should be copied and pasted, so that there is recipe for each intervention that is being costed by adapting previous estimates"]
[]
[null,null,null,null,null,null,"INTEGRATED HEALTH TOOL INPUTS, if using IHT"]
["Intervention Master List Line number","Intervention Name","Description",null,"Intervention Output Unit","Unit Cost","staff time per visit in minutes","nr outpatient visits","cost of (medical) supplies","nr  inpatient days"]
[1,{"$f":"'1.4 Interventions'!C19","v":"Combination prevention package targeting Adolescent girls and young women - 15 -19 years, in schools - youth club model"},"Implement age-appropriate life skills, behaviour change and empowerment activities through the peer education and youth club model, focusing on girls in and out of primary schools (8-14 Years).\n1 club per school. 25 participants be club.\nThis is regarded as a \"high norms & standards\" youth club for priority districts.\nAbove site management and overhead costs from a service provider perspective only",null,null,{"$f":"F28","v":0}]
[null,"Adaptation Step","Adaptation Parameters",null,"Calculation Note","Calculation Result"]
[null,null,"Param Name","Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Adapted Cost per Unit of Intervention Output"]
[]
[]
[null,null,null,"2017 ZAR Value",null,"2025 ZAR value","USD value"]
[]
[2,{"$f":"'2.1 Literature Review'!C12","v":"VMMC"},{"$f":"'2.1 Literature Review'!K12","v":"Cost per male circumcision"},{"$f":"'2.1 Literature Review'!J12","v":1504.0140021677987},"adjust for inflation from 2017 to 2025",{"$f":"D33*((1+Inflation)^(2025-2017))","v":1504.0140021677987},{"$f":"F33/XRZar","v":{"$error":"#DIV/0!"}}]
[4,{"$f":"'2.1 Literature Review'!C13","v":"Health system strengthening"},{"$f":"'2.1 Literature Review'!K13","v":"Youth friendly PHC service"},{"$f":"'2.1 Literature Review'!J13","v":17760153.5},"adjust for inflation from 2017 to 2025",17760153.5,{"$error":"#DIV/0!"}]
[9,{"$f":"'2.1 Literature Review'!C14","v":"Health system strengthening"},{"$f":"'2.1 Literature Review'!K14","v":"Annual programme management cost  per social protection departments"},{"$f":"'2.1 Literature Review'!J14","v":690911879.015342},"adjust for inflation from 2017 to 2025",690911879.015342,{"$error":"#DIV/0!"}]
[null,{"$f":"'2.1 Literature Review'!C15","v":"BCC"},{"$f":"'2.1 Literature Review'!K15","v":"Cost per pp reached by 2 national communication campaign pa"},{"$f":"'2.1 Literature Review'!J15","v":8.0899000000000001},"adjust for inflation from 2017 to 2025",8.0899000000000001,{"$error":"#DIV/0!"}]
[10,{"$f":"'2.1 Literature Review'!C16","v":"BCC"},{"$f":"'2.1 Literature Review'!K16","v":"Cost per adolescent or youth reached by targeted multi-media communication campaign"},{"$f":"'2.1 Literature Review'!J16","v":10.988808000000001},"adjust for inflation from 2017 to 2025",10.988808000000001,{"$error":"#DIV/0!"}]
[null,{"$f":"'2.1 Literature Review'!C17","v":"Sexual Education and Health Services"},{"$f":"'2.1 Literature Review'!K17","v":"Cost per youth 15-24 receiving SRH service in non-health care setting "},{"$f":"'2.1 Literature Review'!J17","v":720},"adjust for inflation from 2017 to 2025",720,{"$error":"#DIV/0!"}]
[6,{"$f":"'2.1 Literature Review'!C18","v":"ART"},{"$f":"'2.1 Literature Review'!K18","v":"Average cost per adult on ART (public and private)"},3389.740047041952,"adjust for inflation from 2017 to 2025",3389.740047041952,{"$error":"#DIV/0!"}]

{"sheet":"2.3 IBC Unit costs","index":9,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":false,"merged":[[13,2,13,5],[39,2,39,5],[67,2,67,5]]}
[]
[]
[null,"CHAPTER 8: CONSTRUCTING UNIT COSTS FROM INGREDIENTS"]
[]
[null,"Ingredients based costing of interventions"]
[]
[]
[]
[null,"INGREDIENT BASED COSTING RECIPE NOTES"]
[null,"This is a template that should be copied and pasted, so that there is recipe for each intervention that is being costed by the IBC method"]
[]
[]
["Intervention Master List Line Number","Intervention Name","Description",null,null,null,"Intervention Output Unit","Unit Cost"]
["1 example","Accredited CSE training, including design and distribution of teacher materials",null,null,null,null,{"$f":"G38","v":"Total cost per unit"},{"$f":"H38","v":9559.5068666666666}]
[null,"Ingredient","Measurement Unit","Quantity","Frequency","Ingredient Unit Cost","Note","Total"]
[null,"Accommodation",null,30,6,1150,null,{"$f":"D16*E16*F16","v":207000}]
[null,"Teas",null,30,5,15,null,{"$f":"D17*E17*F17","v":2250}]
[null,"Lunch",null,30,5,90,null,{"$f":"D18*E18*F18","v":13500}]
[null,"Dinner",null,30,6,150,null,{"$f":"F19*E19*D19","v":27000}]
[null,"Venue hire",null,1,5,2000,null,10000]
[null,"Trainers",null,1,5,3000,null,15000]
[null,"Shuttle",null,2,2,1500,"2 shuttles available",6000]
[null,"Service provider administration and overhead",null,1,0.3,{"$f":"H21","v":15000},"30% of facilitator time",4500]
[null,null,null,null,null,null,null,0]
[null,"Scripted lesson plan booklets",null,30,1,17,"Including distribution costs",510]
[null,"Development of plans",null,30,1,34.06,"Assume development costs for 34 200 educators reached",1021.8000000000001]
[null,"Design and illustration",null,1,0.1,{"$f":"F26","v":34.06},"Assume 10% of development costs",3.4060000000000006]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total Cost",{"$f":"SUM(H15:H34)","v":286785.20600000001}]
[null,null,null,null,"teachers trained",null,"Number of units",30]
[null,null,null,null,null,null,"Total cost per unit",{"$f":"H36/H37","v":9559.5068666666666}]
[]
[2,"HIV testing service",null,null,null,null,null,{"$f":"H66","v":110.66155579328506}]
[null,"Ingredient","Measurement Unit","Quantity","Frequency","Ingredient Unit Cost","Note","Total"]
[null,"HR",null,null,null,null,null,{"$f":"D42*E42*F42","v":0}]
[null,"Counsellor & tester","salary pa",10,1,74750,null,{"$f":"D43*E43*F43","v":747500}]
[null,"Professional nurse G1 ","salary pa",1,1,260000,null,{"$f":"D44*E44*F44","v":260000}]
[null,"Data capturers","salary pa",1,1,84000,null,{"$f":"F45*E45*D45","v":84000}]
[null,"Driver for testing events"," salary pa ",0.33,1,72000,null,{"$f":"F46*E46*D46","v":23760}]
[null,"Support HR"," 20% of direct costs ",1,1,0.2,null,{"$f":"SUM(H43:H46)*F47","v":223052},"Note here full cost, as includes an overhead to HR"]
[null,"Consumables",null,null,null,null,null,{"$f":"F48*E48*D48","v":0}]
[null,"Gloves (100)","per test",0.01,{"$f":"$H$65","v":15190},67.95,null,{"$f":"D49*E49*F49","v":10321.605000000001}]
[null,"Lancets (100) ","per test",0.01,{"$f":"$H$65","v":15190},22.05,null,{"$f":"D50*E50*F50","v":3349.3950000000004}]
[null,"Alcohol swabs (200)","per test",5.0000000000000001E-3,15190,26.95,null,{"$f":"F51*E51*D51","v":2046.8525}]
[null,"Cotton wool balls","per test",0.01,15190,68.349999999999994,null,10382.365]
[null,"Hand scrub","per test",0.02,15190,49.95,null,15174.81]
[null,"Sharps container","per test",0.01,15190,54.75,null,8316.5249999999996]
[null,"Cleaning solution","per test",0.01,15190,56.95,null,8650.7049999999999]
[null,"Plasters ","per test",0.01,15190,16.25,null,2468.375]
[null,"HIV Test kits","per test",1,{"$f":"H65","v":15190},6,null,91140]
[null,"overheads","per test",1,{"$f":"H65","v":15190},12.56,null,{"$f":"F58*E58*D58","v":190786.4}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total Cost",{"$f":"SUM(H42:H62)","v":1680949.0325},"unit definition"]
[null,"Quantity = 7 tests per day per counsellor/tester x 10 testers x 217 testing days pa.  Professional nurse quality assurance and supervision for 10 counsellors & testers. 1 data capturer captures data for tests from 10 testers. Driver and manager at 33% LoE for team of 10 testers. Administration overhead refers to the contribution to the management, finance and administration functions of the service provider.",null,null,"HIV testing services",null,"Number of units",{"$f":"D43*WorkingDaysAnnual*TestpDay","v":15190}]
[null,null,null,null,null,null,"Total cost per unit",{"$f":"H64/H65","v":110.66155579328506}]
[]
[2,"Yolo HIV prevention programme",null,null,null,null,null,{"$f":"H94","v":196766.66666666666}]
[null,"Ingredient","Measurement Unit","Quantity","Frequency","Ingredient Unit Cost","Note","Total"]
[null,"Field officers","pm",25,12,5000,"Assume 180 training days pa. 2 FOs per course of 60 youth. 450 youth per FO. Own deduction from source documents. ",{"$f":"D70*E70*F70","v":1500000}]
[null,"Yolo training: Catering","pp",11250,12,60,null,{"$f":"D71*E71*F71","v":8100000}]
[null,"Yolo training: Stationery & materials","pp",11250,1,40,null,450000]
[null,null,null,null,null,null,null,0]
[null,"Yolo Events: Prizes and refreshments",null,{"$f":"D72","v":11250},4,20,"For HCT mobilisation",900000]
[null,null,null,null,null,null,null,0]
[null,"Programme manager","pm",0.5,12,15000,"50% FTE",90000]
[null,"Administrator/Finance","pm",1,12,10000,"50% FTE",120000]
[null,"Program Cordinator ","pm",1,12,12000,null,144000]
[null,"Vehicle allowance","pm",1,12,3000,null,36000]
[null,"water and electricty","pm",1,12,2000,null,24000]
[null,"Fuel & maintanance","pm",1,12,10000,null,120000]
[null,"Telephone","pm",1,12,3000,null,36000]
[null,"IT","pm",1,12,2500,null,30000]
[null,"Rental","pm",1,12,10000,null,120000]
[null,"stationary and printing","pm",1,12,2000,null,24000]
[null,"Accommodation","pm",1,12,{"$f":"1500*5","v":7500},null,90000]
[null,"Bank charges","pm",1,12,1000,null,12000]
[null,"Audit","pa",1,1,10000,null,10000]
[]
[]
[]
[null,null,null,null,null,null,"Total Cost",{"$f":"SUM(H70:H90)","v":11806000}]
[null,null,null,null,"N",null,"number of partricipants",60]
[null,null,null,null,null,null,"Total cost per participant",{"$f":"H92/H93","v":196766.66666666666}]

{"sheet":"2.4 IBC Common Ingredients","index":10,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,1,8,5],[9,1,9,5]]}
[]
[]
[null,"CHAPTER 8: CONSTRUCTING UNIT COSTS FROM INGREDIENTS"]
[]
[null,"Common input prices"]
[]
[]
[]
[null,"List of common ingredients to reference in recipes"]
[null,"This table includes any common ingredients that the analyst wants to reference when building recipes"]
[]
[null,"Ingredient","Measurement Unit","Ingredient Unit Price","Currency","Source","Assumptions"]
["example","Salaries by Cadre"]
[null,"Medical Doctor","full-time equivalent (FTE), pa",1800000,"TZ Shilings","Government salary list, MoH","cost to company: salary + benefits"]
[null,"Registered Nurse","full-time equivalent (FTE), pa",1000000,"TZ Shilings","Government salary list, MoH"]
[null,"Youth club facilitators","full-time equivalent (FTE), pa",300000,"TZ Shilings","….."]
[null,"Youth club facilitator training"]
[]
[null,"Estimated annual working hours per FTE","working hours estimate",{"$f":"220*6","v":1320},"hours","Interview with HR manager MoH, January 29, 2023","6 weeks holiday, 1 week exceptional leave for sickness, funerals, 1 week national holidays. 52 weeks - 8 weeks: 44 weeks= 220 working days.  Working hours:  8 hours - coffee, lunch break, training, general admin, leaves 6 hours. "]
[]
[]
[null,"Common activity costs"]
[null,"Workshops/trainings"]
[null,"Ingredient","Measurement Unit","Ingredient Unit Cost","Currency","Source"]
[]
[]
[]
[]
[null,"Total cost per workshop"]
[null,"total cost per workshop attendee"]
[]
[]
[]
[null,null,null,null,null,null," Tabl"]

{"sheet":"2.4 Lump Sum","index":11,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5]]}
[]
[null,"INTERVENTIONS COSTED AS LUMP SUM"]
[null,"This table is for documentation of interventions being costed by lump sum"]
[]
[]
["Intervention Master List Line Number","Intervention Name","Description",null,null,null,"Lump Sum Amount"]
[1,{"$f":"VLOOKUP($A7,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#REF!"}},"Implement age-appropriate life skills, behaviour change and empowerment activities through the peer education and youth club model, focusing on girls in and out of primary schools (8-14 Years).\n1 club per school. 25 participants be club.\nThis is regarded as a \"high norms & standards\" youth club for priority districts.\nAbove site management and overhead costs from a service provider perspective only",null,null,null,50000]
[null,{"$f":"VLOOKUP($A8,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A9,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A10,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A11,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A12,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A13,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A14,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($A15,'1.4 Interventions'!$B$11:$C$110,5,0)","v":{"$error":"#N/A"}}]

{"sheet":"3.1 Unit Cost Table","index":12,"n_rows":107,"n_cols":16,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CHAPTER 9: BRINGING IT ALL TOGETHER - ESTIMATING TOTAL COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Unit costs"]
[]
[]
[null,null,null,null,null,null,"Year-specific Unit Cost"]
["Line #","Unit definition","Source and Explanation","Costing Method","Unit Cost (Base Year)","Base Year",2025,{"$f":"G9+1","v":2026},{"$f":"H9+1","v":2027},{"$f":"I9+1","v":2028},{"$f":"J9+1","v":2029},{"$f":"K9+1","v":2030},"Notes on Year-specific adjustments"]
["Ex. 1","Average cost per person tested for HIV - PICT","SA HIV Investment Case. Assumes a 10% positivity rate","Ingredients",{"$f":"UCHIVTest","v":110.66155579328506},2024,{"$f":"E10","v":110.66155579328506},{"$f":"G10","v":110.66155579328506},{"$f":"H10","v":110.66155579328506},110.66155579328506,110.66155579328506,110.66155579328506]
["Ex. 2","Cost per male circumcision","Investment Case, inf adjusted. Corroborated by Avenir study, 2016","Literature",{"$f":"'2.1 Literature Review'!J12","v":1504.0140021677987},2024,1504.0140021677987,{"$f":"G11","v":1504.0140021677987},1504.0140021677987,1504.0140021677987,1504.0140021677987,1504.0140021677987]
["Ex. 3","Cost per educator trained on CSE","Source: DBE costing, adapted. Includes development costs and teacher support materials","Ingredients",{"$f":"'2.3 IBC Unit costs'!H14","v":9559.5068666666666},2024,9559.5068666666666,{"$f":"G12","v":9559.5068666666666},9559.5068666666666,9559.5068666666666,9559.5068666666666,9559.5068666666666]
["Ex. 4","Youth friendly PHC service","Adolescent & Youth Health Policy Costing Model, 2016. Includes training and provincial visits and assessments","Literature",17760153.5,2024,17760153.5,{"$f":"G13","v":17760153.5},17760153.5,17760153.5,17760153.5,17760153.5]
["Ex. 5","woman 20-24 receiving PrEP","NDOH (HERO) PrEP costing 2016, applying NSP enrollment scenario","SAG costing model",2978.4323537339983,2024,2978.4323537339983,{"$f":"G14","v":2978.4323537339983},2978.4323537339983,2978.4323537339983,2978.4323537339983,2978.4323537339983]
["Ex. 6","Average cost per adult on ART (public and private)","NACM Output March 2017. Scenario 1A: Current regimens and adherence strategy implementation","SAG costing model",3389.740047041952,2024,3389.740047041952,{"$f":"G15","v":3389.740047041952},3389.740047041952,3389.740047041952,3389.740047041952,3389.740047041952]
["Ex. 7","Cost per adolescent 15-19 participating in club model","SA Global Fund grant portfolio, 2016.\nBased on Rise SCI model","Ingredients",916.25,2024,916.25,{"$f":"G16","v":916.25},916.25,916.25,916.25,916.25]
["Ex. 8","Annual cost of human rights reporting mechanism","Internal budget. Includes establishment of reporting mechanism, IEC dissemination and community advisory desks","Ingredients",5618000,2024,5618000,{"$f":"G17","v":5618000},5618000,5618000,5618000,5618000]
["Ex. 9","Annual programme management cost - social protection departments","Derived from national and provincial budgets","Literature",690911879.015342,2024,690911879.015342,{"$f":"G18","v":690911879.015342},690911879.015342,690911879.015342,690911879.015342,690911879.015342]
["Ex. 10","Cost per pp reached by 2 national communication campaign pa","Source: SA Investment Case. Aggregate of 2 national campaigns. Inflation adjusted","Literature",8.0899000000000001,2024,8.0899000000000001,{"$f":"G19","v":8.0899000000000001},{"$f":"H19","v":8.0899000000000001},{"$f":"I19","v":8.0899000000000001},{"$f":"J19","v":8.0899000000000001},{"$f":"K19","v":8.0899000000000001}]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]

{"sheet":"3.2 Population Indicators","index":13,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CHAPTER 9: BRINGING IT ALL TOGETHER - ESTIMATING TOTAL COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Quantity Calculations"]
[]
[]
[null,null,null,"Year"]
[null,null,null,2025,{"$f":"D9+1","v":2026},{"$f":"E9+1","v":2027},2028,2029,2030]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C13","v":"Comprehensive HIV testing services - provider initiated"}]
[null,"Unit Definition",{"$f":"'3.3 NSP Total Costs'!G10","v":"Persons Tested"}]
[null,null,"Total Quantity in Need",10000000,10000000,10000000,10000000,10000000,10000000]
[null,null,"Coverage Target",0.4,0.4,0.4,0.4,0.4,0.6]
[null,null,"Quantity Reached",{"$f":"D13*D12","v":4000000},{"$f":"E13*E12","v":4000000},4000000,4000000,4000000,6000000]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C14","v":"Medical male circumcision"}]
[null,"Unit Definition",{"$f":"'3.3 NSP Total Costs'!G11","v":"Procedure Completed"}]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C15","v":"Curriculum based Comprehensive Sexuality Education in schools using scripted lesson plans"}]
[null,"Unit Definition","Educator Trained"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C16","v":"Strengthen youth friendly services for adolescents and youth through the DOH public health care system"}]
[null,"Unit Definition","District-wide program"]
[null,null,"Total Quantity in Need",27,27,27,27,27,27]
[null,null,"Coverage Target",1,1,1,1,1,1]
[null,null,"Quantity Reached",{"$f":"D30*D31","v":27},{"$f":"E30*E31","v":27},27,27,27,27]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C17","v":"Provide oral PrEP to young women - 20 - 24"}]
[null,"Unit Definition","Person-Year"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C18","v":"Accelerate ART initiation and retention in care for all PLHIV in a way that ensures equity - Adults"}]
[null,"Unit Definition","Person-Year"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached",4115916,4602275,5086960,5444905,5693632,5868068]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C19","v":"Combination prevention package targeting Adolescent girls and young women - 15 -19 years, in schools - youth club model"}]
[null,"Unit Definition","Participant"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C20","v":"Social mobilisation and education on rights and laws relevant to HIV and TB"}]
[null,"Unit Definition","Nationwide program"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C21","v":"Programme management costs for core government departments implementing the NSP"}]
[null,"Unit Definition","Nationwide program"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]
[]
[null,"Intervention ",{"$f":"'1.4 Interventions'!C22","v":"Nationally co-ordinated multi media campaign targeting all risk groups in the general population"}]
[null,"Unit Definition","Person Reached"]
[null,null,"Total Quantity in Need"]
[null,null,"Coverage Target"]
[null,null,"Quantity Reached"]

{"sheet":"Dropdowns","index":14,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Program Area","Interventions","Target Populations","Implementer","Scale","New/Routine","Include in Costing?","If partially or no, specify ","Big ticket item","Process Map","Costing Method","Primary source?","Source Type","Modeled vs. Observed","Financia vs. Economic","Full vs. Incremental","Does this meet costing purpose?","Region","Country Income Level","Costing Perspective","Costing Aim","Projected inflation to future costs","Normative/Real-world","Source Type","Service-level human resources","Method for Estimation","Source Type","Modeling software","Progress Status"]
["Test & Treat","HIV Testing","N/A","Not specified/no information provided","National","Routine intervention, no adaptations","Yes","Not relevant to costing aims","Yes","Yes","Adapt existing unit cost","Yes","Published peer-reviewed","Modeled","Financial","Full","Yes","Asia and the Pacific ","Low-Income Country ","Provider","Full resource needs estimate of NSP interventions","Yes, annual inflation rate:","Normative costs",null,"Included in cost estimate","Unit cost adapted from literature","Budget",null,"Not started"]
["Paediatric Test & Treat","Early Infant Diagnosis","Not specified/no information provided","Public sector","Regional","Routine intervention, adaptations needed","Partially","Not relevant to costing provider perspective","No","No","Build unit cost from scratch","No","Grey Literature","Observed","Economic","Incremental","No","Eastern Europe and Central Asia","Lower-Middle-Income Country","Societal","Cost a list of prioritized interventions","No. Specify why:","Real world costs",null,"Included elsewhere","Unit cost modeled from ingredient based costing","Expenditure report",null,"In Progress"]
["Integrated Health Services","Paediatric treatment","General Population","Private sector, international, for profit","Targeted Sites","Piloted/recently implemented intervention, adaptations and/or scale-up needed","No","Not repevant to cost type",null,null,"Lumpsum",null,null,"Unsure","Unsure","Unsure","Unsure","Eastern and Southern Africa","Upper-Middle-Income Country",null,"Identifying resource needs gaps to realize NSP targets",null,null,null,"Excluded from NSP costing","Lump Sum","Key Informant Interview",null,"Complete"]
["Prevention Services","ART","Key and/or Vulnerable Populations","Private sector, national, for profit","Other","Novel intervention, no pilot or prior country implementation done",null,null,null,null,"Percentage of direct costs",null,null,null,null,null,null,"Latin America and the Caribbean","High-Income Country",null,"Other (please specify)",null,null,null,null,"%","Peer-reviewed study"]
["Societal Enablers","Laboratory","PLHIV","Private sector, international, non profit",null,null,null,null,null,null,"Other",null,null,null,null,null,null,"Middle East and North Africa",null,null,null,null,null,null,null,null,"Country modeled costing"]
["Support Functions","Retention Support","Adult Men (18 and above)","Private sector, national, non profit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Western and Central Africa"]
[null,"Tuberculosis",null,"Private sector, community or civil society organizations, non profit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Western and Central Europe and North America"]
[null,"Cervical Cancer",null,"Other"]
[null,"VMMC"]
[null,"Condoms, lubricants, and other"]
[null,"Tailored Services"]
[null,"PrEP"]
[null,"Community mobilization"]
[null,"STI"]
[null,"PEP"]
[null,"Sexual Education and Health Services"]
[null,"OVC support"]
[null,"Monitoring and research"]
[null,"Health system strengthening"]
[null,"Stigma & discrimination"]
[null,"Testing & Treatment of pregnant women"]
[null,"Economic empowerment"]
[null,"Hepatitis C"]
[null,"Syphilis"]
[null,"Nutrition support"]
[null,"Hepatitis B & C"]
[null,"TB"]
[null,"Mental Health"]
[null,"Parenting support"]
[null,"Gender Inequality"]
[null,"Human rights"]
[null,"Policy advocacy"]
[null,"Hepatitis B"]
[null,"BCC"]

{"sheet":"3.3 NSP Total Costs","index":15,"n_rows":109,"n_cols":27,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CHAPTER 9: BRINGING IT ALL TOGETHER - ESTIMATING TOTAL COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Total costs"]
[]
[]
[null,null,"NSP Framework",null,null,null,"Intervention Scale (number of output units)",null,null,null,null,null,null,"Unit Cost",null,"Year-specific Unit Cost",null,null,null,null,null,"Annual Costs (Quantities x Prices)"]
["Intervention Master List Line Number","Intervention","NSP Objective","NSP Sub-Objective","Rollup Category","Costing Method","Intervention Output Unit Definition (Population)",{"$f":"StartYear","v":0},{"$f":"H9+1","v":1},{"$f":"I9+1","v":2},{"$f":"J9+1","v":3},{"$f":"K9+1","v":4},{"$f":"L9+1","v":5},"Unit definition","Unit Cost (Base Year)",{"$f":"StartYear","v":0},{"$f":"P9+1","v":1},{"$f":"Q9+1","v":2},{"$f":"R9+1","v":3},{"$f":"S9+1","v":4},{"$f":"T9+1","v":5},{"$f":"StartYear","v":0},{"$f":"V9+1","v":1},{"$f":"W9+1","v":2},{"$f":"X9+1","v":3},{"$f":"Y9+1","v":4},{"$f":"Z9+1","v":5}]
[1,{"$f":"'1.4 Interventions'!C13","v":"Comprehensive HIV testing services - provider initiated"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population\n","Testing","Ingredients","Persons Tested",{"$f":"'3.2 Population Indicators'!D14","v":4000000},{"$f":"'3.2 Population Indicators'!E14","v":4000000},{"$f":"'3.2 Population Indicators'!F14","v":4000000},{"$f":"'3.2 Population Indicators'!G14","v":4000000},{"$f":"'3.2 Population Indicators'!H14","v":4000000},{"$f":"'3.2 Population Indicators'!I14","v":6000000},{"$f":"'3.1 Unit Cost Table'!B10","v":"Average cost per person tested for HIV - PICT"},{"$f":"'3.1 Unit Cost Table'!E10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!G10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!H10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!I10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!J10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!K10","v":110.66155579328506},{"$f":"'3.1 Unit Cost Table'!L10","v":110.66155579328506},{"$f":"H10*P10","v":442646223.17314023},{"$f":"I10*Q10","v":442646223.17314023},442646223.17314023,442646223.17314023,442646223.17314023,663969334.75971031]
[2,{"$f":"'1.4 Interventions'!C14","v":"Medical male circumcision"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population\n","Biomedical Prevention","Literature","Procedure Completed",null,null,null,null,null,null,{"$f":"'3.1 Unit Cost Table'!B11","v":"Cost per male circumcision"},{"$f":"'3.1 Unit Cost Table'!E11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!G11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!H11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!I11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!J11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!K11","v":1504.0140021677987},{"$f":"'3.1 Unit Cost Table'!L11","v":1504.0140021677987}]
[3,{"$f":"'1.4 Interventions'!C15","v":"Curriculum based Comprehensive Sexuality Education in schools using scripted lesson plans"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.2 Implement targeted combination prevention services tailored to setting and population\n","Prevention","Ingredients","Educator Trained",null,null,null,null,null,null,{"$f":"'3.1 Unit Cost Table'!B12","v":"Cost per educator trained on CSE"},{"$f":"'3.1 Unit Cost Table'!E12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!G12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!H12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!I12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!J12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!K12","v":9559.5068666666666},{"$f":"'3.1 Unit Cost Table'!L12","v":9559.5068666666666}]
[4,{"$f":"'1.4 Interventions'!C16","v":"Strengthen youth friendly services for adolescents and youth through the DOH public health care system"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.3 Provide sensitive and age-appropriate sexual and reproductive health services  (SRH) and comprehensive sexuality education (CSE)","Prevention","Literature","District-wide program",{"$f":"'3.2 Population Indicators'!D32","v":27},{"$f":"'3.2 Population Indicators'!E32","v":27},{"$f":"'3.2 Population Indicators'!F32","v":27},{"$f":"'3.2 Population Indicators'!G32","v":27},{"$f":"'3.2 Population Indicators'!H32","v":27},{"$f":"'3.2 Population Indicators'!I32","v":27},{"$f":"'3.1 Unit Cost Table'!B13","v":"Youth friendly PHC service"},{"$f":"'3.1 Unit Cost Table'!E13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!G13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!H13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!I13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!J13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!K13","v":17760153.5},{"$f":"'3.1 Unit Cost Table'!L13","v":17760153.5},{"$f":"H13*P13","v":479524144.5},479524144.5,479524144.5,479524144.5,479524144.5,479524144.5]
[5,{"$f":"'1.4 Interventions'!C17","v":"Provide oral PrEP to young women - 20 - 24"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.3 Provide sensitive and age-appropriate sexual and reproductive health services  (SRH) and comprehensive sexuality education (CSE)","Biomedical Prevention","SAG costing model","Person-Year",null,null,null,null,null,null,{"$f":"'3.1 Unit Cost Table'!B14","v":"woman 20-24 receiving PrEP"},{"$f":"'3.1 Unit Cost Table'!E14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!G14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!H14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!I14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!J14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!K14","v":2978.4323537339983},{"$f":"'3.1 Unit Cost Table'!L14","v":2978.4323537339983}]
[6,{"$f":"'1.4 Interventions'!C18","v":"Accelerate ART initiation and retention in care for all PLHIV in a way that ensures equity - Adults"},"1. Accelerate prevention to reduce new HIV, TB and STI infections.","1.1.4 Provide Pre-Exposure Prophylaxis (PREP) to identified risk populations ","Treatment","SAG costing model","Person-Year",{"$f":"'3.2 Population Indicators'!D44","v":4115916},{"$f":"'3.2 Population Indicators'!E44","v":4602275},{"$f":"'3.2 Population Indicators'!F44","v":5086960},{"$f":"'3.2 Population Indicators'!G44","v":5444905},{"$f":"'3.2 Population Indicators'!H44","v":5693632},{"$f":"'3.2 Population Indicators'!I44","v":5868068},{"$f":"'3.1 Unit Cost Table'!B15","v":"Average cost per adult on ART (public and private)"},{"$f":"'3.1 Unit Cost Table'!E15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!G15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!H15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!I15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!J15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!K15","v":3389.740047041952},{"$f":"'3.1 Unit Cost Table'!L15","v":3389.740047041952}]
[7,{"$f":"'1.4 Interventions'!C19","v":"Combination prevention package targeting Adolescent girls and young women - 15 -19 years, in schools - youth club model"},"2. Reduce morbidity and mortality by providing treatment, care and adherence support for all.","2.1.2 90% of all people with diagnosed HIV infection receive sustained antiretroviral therapy","Prevention","Ingredients","Participant",null,null,null,null,null,null,{"$f":"'3.1 Unit Cost Table'!B16","v":"Cost per adolescent 15-19 participating in club model"},{"$f":"'3.1 Unit Cost Table'!E16","v":916.25},{"$f":"'3.1 Unit Cost Table'!G16","v":916.25},{"$f":"'3.1 Unit Cost Table'!H16","v":916.25},{"$f":"'3.1 Unit Cost Table'!I16","v":916.25},{"$f":"'3.1 Unit Cost Table'!J16","v":916.25},{"$f":"'3.1 Unit Cost Table'!K16","v":916.25},{"$f":"'3.1 Unit Cost Table'!L16","v":916.25}]
[8,{"$f":"'1.4 Interventions'!C20","v":"Social mobilisation and education on rights and laws relevant to HIV and TB"},"3. Reach all key and vulnerable populations with comprehensive, customised and targeted interventions.","3.1.3  All key and vulnerable population programmes should adopt a peer educator led approach to implementation","Enablers","Ingredients","Nationwide program",1,1,1,1,1,1,{"$f":"'3.1 Unit Cost Table'!B17","v":"Annual cost of human rights reporting mechanism"},{"$f":"'3.1 Unit Cost Table'!E17","v":5618000},{"$f":"'3.1 Unit Cost Table'!G17","v":5618000},{"$f":"'3.1 Unit Cost Table'!H17","v":5618000},{"$f":"'3.1 Unit Cost Table'!I17","v":5618000},{"$f":"'3.1 Unit Cost Table'!J17","v":5618000},{"$f":"'3.1 Unit Cost Table'!K17","v":5618000},{"$f":"'3.1 Unit Cost Table'!L17","v":5618000},{"$f":"H17*P17","v":5618000},{"$f":"I17*Q17","v":5618000},{"$f":"J17*R17","v":5618000},{"$f":"K17*S17","v":5618000},{"$f":"L17*T17","v":5618000},{"$f":"M17*U17","v":5618000}]
[9,{"$f":"'1.4 Interventions'!C21","v":"Programme management costs for core government departments implementing the NSP"},"5. Ground the response to HIV, TB and STIs in human rights principles and approaches","5.2.1  Improve legal literacy about human rights and laws relevant to HIV and TB","Program Management","Literature","Nationwide program",1,1,1,1,1,1,{"$f":"'3.1 Unit Cost Table'!B18","v":"Annual programme management cost - social protection departments"},{"$f":"'3.1 Unit Cost Table'!E18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!G18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!H18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!I18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!J18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!K18","v":690911879.015342},{"$f":"'3.1 Unit Cost Table'!L18","v":690911879.015342},690911879.015342,690911879.015342,690911879.015342,690911879.015342,690911879.015342,690911879.015342]
[10,{"$f":"'1.4 Interventions'!C22","v":"Nationally co-ordinated multi media campaign targeting all risk groups in the general population"},"9. Critical enablers to maximise the reach and impact of National response to HIV, TB and STIs","9.1.4 Enabler 6: Programme management, planning, co-ordination and oversight","Enablers","Literature","Person Reached",null,null,null,null,null,null,{"$f":"'3.1 Unit Cost Table'!B19","v":"Cost per pp reached by 2 national communication campaign pa"},{"$f":"'3.1 Unit Cost Table'!E19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!G19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!H19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!I19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!J19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!K19","v":8.0899000000000001},{"$f":"'3.1 Unit Cost Table'!L19","v":8.0899000000000001}]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[]
[null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V10:V108)","v":1618700246.6884823}]

{"sheet":"4.1 Efficiency","index":16,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[16,1,16,3],[27,1,27,2],[28,1,28,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[19,6,24,6],[17,1,17,2],[18,1,18,2],[20,1,20,2],[21,1,21,2]]}
[]
[]
[null,"CHAPTER 10: FURTHER ANALYSIS"]
[]
[null,"Efficiency"]
[]
[]
[]
["Step 1: indentify inefficiencies and solutions"]
["Step 2: identify that top 3 to 5 that can likely lead to the greatest efficiency gains.  "]
["Step 3: identify which inputs change as a result"]
["Step 4: See the impact on the unit costs, input into model to obtain budget impact."]
["Step 5: if you are estimating the full budget using 3.3, then undertake budget impact analysis, by linking the unit cost in 3.1. to the efficient unit cost here.  "]
[]
[]
[null,"Efficiency analysis inputs: operationalising the proposed changes  Example. ",null,"Examples: you can also insert new rows"]
[null,"Draw on Table 9 to identify the top 3-5 areas for potential efficiency gains. Identify the key  cost that would change and the associated change in impact/ uptake/coverage that would ensue. ",null,null,"Current","Efficient","Unit definition"]
["Example","e.g. enhanced retention programmes: leads to change in retention programme cost",null,null,"$20 per person per year on ART","$25 per person year","Retention programme per person on ART per year"]
[null,"change in share of people on 2nd line ART, attributable to improved retention programme",null,null,0.2,0.15,"% of all people on ART on 2nd line treatment"]
[null,"cost of 1st line: $150, cost of 2nd line $500",null,null,null,null,"change in ART cost per year \nwas 80%*150+20%*$500+$20= $240 now 85%*$150+15%*$500+$25=$227.50\n\nNow compare total NSP budget with current cost and efficient cost to obtain impact on total budget to get understand the budget impact"]
[null,"Annual ART cost: weighted average of 1st and 2nd line treatment costs plus the retention programme costs"]
[null,"    % on 1st line * 1st line cost",null,null,{"$f":"0.8*150","v":120},{"$f":"0.85*150","v":127.5}]
[null,"    % on 2nd line * 2nd line cost",null,null,{"$f":"0.2*500","v":100},{"$f":"0.15*500","v":75}]
[null,"    Retention programme cost",null,null,20,25]
[null,"Total annual ART cost per year",null,null,{"$f":"SUM(E22:E24)","v":240},{"$f":"SUM(F22:F24)","v":227.5}]
[null,"% change in unit cost",null,null,null,{"$f":"(F25-E25)/E25","v":-5.2083333333333336E-2}]

{"sheet":"4.2 SA","index":17,"n_rows":85,"n_cols":15,"rows_kept":85,"cut":false,"hidden":false,"merged":[[14,8,18,10],[51,0,51,9]]}
[]
[]
[null,"CHAPTER 10: FURTHER ANALYSIS"]
[]
[null,"Sensitivity analysis"]
[]
[]
["Step 1: identify key variables with uncertaintly: enter them into column C.  "]
["Step 2: name the cells for use in the analysis in column G"]
[]
[null,null,"Key variables that need exploring in the further analyses of sensitivity, and efficiency analysis:"]
[]
[null,null,"Sensitivity analysis assumptions","Input Parameter Values"]
[null,null,"Change in input prices","Low","Base Case ","High ","Named Cell","Define unit"]
[null,"Salaries","Doctors (-20%, +20%",{"$f":"E15-0.1*E15","v":22.5},25,{"$f":"E15+0.1*E15","v":27.5},{"$f":"E15","v":25},"hour","Remember this is per direct working hour: This is annual salary inclusive of any benefits, like pension/ hours worked per year.   Daily working hours do not count breaks and indirect time.  Days per year do not include holiday, sick/funeral days/ training days.  So if a person has 6 weeks of holiday and 2 more weeks off for public holidyas, sick leave, funerals and training, then there are 52 -8 weeks=46 *5 days = 230 days. If the working day is 8 hours but includes 1 hour of breaks, and 1 hour of general administration, then the direct patient time is only 6 hours. The cost per hour is then: = 1380. "]
[null,null,"Nurses",{"$f":"E16-0.1*E16","v":13.5},15,{"$f":"E16+0.1*E16","v":16.5},{"$f":"E16","v":15},"hour"]
[null,null,"Lay provider",7.2,8,8.8000000000000007,8,"hour"]
[null,null,"Lab techs.",13.5,15,16.5,15,"hour"]
[null,null,"Other staff types, insert rows",0,null,0,0]
[null,"Supplies","ART 1st line",null,150,null,null,"Annual supply "]
[null,null,"ART 2nd line",null,500,null,null,"Annual supply "]
[null,null,"PrEP",null,null,null,null,"Monthly supply "]
[null,"Transport","Petrol",null,null,null,null,"per km/liter [removed what is not relevant] "]
[null,"Other inputs"]
[null,null,"Programme cost lump sum changed  by 20%",0.12,0.15,0.18,null,null,null,null,{"$f":"46*5","v":230}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K25*6","v":1380}]
[]
[null,null,"Change in input quantities","Low","Base Case","High ","Named Cell"]
[null,null,"Annual ART visits"]
[null,null,"HIV testing yield"]
[null,null,"Linkage to treatment after testing HIV+ "]
[null,null,"Retention rates"]
[null,null,"% of ART clients on 2nd line therapy ",0.15,0.2,0.25,{"$f":"E33","v":0.2}]
[]
[]
[]
[null,null,"Scenarios","Low","Base Case","High ","Named Cell","State assumptions on what these would mean for your price, quantity and coverage parameters"]
[null,null,"Coverage: variation to coverage targets for [state specific intervention]",0.7,0.8,0.9,{"$f":"E38","v":0.8}]
[null,null,"HIV incidence -% change from base line -10%, +10%",{"$f":"E39-(10%*E39)","v":1.8000000000000002E-2},0.02,{"$f":"E39+(10%*E39)","v":2.1999999999999999E-2}]
[null,null,"Integration of PreP into FSW outreach"]
[null,null,"Integration of HIV testing in STI clinics"]
[]
[]
[]
[]
[]
["Step 3: paste your Base case in E56. "]
[null,"If exploring impact on total costs, then Copy value, and paste special \"value\" from  3.3 Budget Table. Total budget value."]
[null,"If exploring impact on a unit cot, then use the unit cost value from 3.1"]
["Step 4: Run the analyses and use \"paste special - Value\" to document the effect in the table below.  Remember to document what you are varying in Column C, and the range of the variation. "]
[null,"Paste each univariate analysis, high and low values in here, and make sure to note down in column C what you have varied and by ho much. This can be a % change or an absolute change. "]
["Step 5: From the univariate analyis, review which values generate the high and low values, insert them all together to get the best and worst case scenarios. REMEMBER it is not always the low value assumption that leads to the lowest unit/total cost, so you will need to pay close attention as it might be a high input value reduces costs, for example high coverage might reduce unit costs, but will increase total costs. "]
[]
[]
[null,null,"Model Assumptions","Low","Base case Cost","High",null," "]
[null,null,"Unit or Total cost being explored",null,9.85]
[null,null,"order from smallest variation to largest variation to generate the torpedo diagramme below"]
[null,"examples","Change to dolutegraver in 1st line",9.6,null,10.15]
[null,"examples","Discount rate 3% (1%,13%)",9.7799999999999994,null,9.8699999999999992]
[null,"examples","Salary (-10%,+10%)",9.3000000000000007,null,10.4,null,"Format the torpedo graph such that the vertical axis crosses at your base value"]
[null,"examples","Economic life years of other capital 5 yrs (2.5,7.5yrs)",9.64,null,10.43]
[null,"examples","Kit quant up and down (-10%,+10%)",8.93,null,10.97]
[null,"examples","kit price $2.24 ($1,$3.4)",8.6999999999999993,null,10.98]
[null,"examples","Allocation of central cost (% of kits distributed, % of distributors)",8.83,null,11.95]
[null,"set all parameters to the least or most expensive value","Best & worse case scenario",6.45,null,16.91]
[]
[]
[]
[]
[null,null,null," "]
[null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Don't change these cells as it reset the min and max axis value"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(BaseCase-D58)","v":0.25},{"$f":"ABS(BaseCase-F58)","v":0.30000000000000071}]
[null,null,null,null,null,null,null,null," ",null,null,null,7.0000000000000284E-2,1.9999999999999574E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.54999999999999893,0.55000000000000071]
[null,null,null,null,null,null,null,null,null,null,null,null,0.20999999999999908,0.58000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,0.91999999999999993,1.120000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,1.1500000000000004,1.1300000000000008]
[null,null,null,null,null,null,null,null,null,null,null,null,1.0199999999999996,2.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,3.3999999999999995,7.0600000000000005]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(ROUNDDOWN(0.7*(SAMax-BaseCase),0))","v":5},null,{"$f":"Module3.setChartAxis(\"4.2 SA\", \"Tornado\", \"Min\", \"Value\", \"Primary\",M84)","v":"Value Primary Min: 5"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((MAX(M75:N82)+BaseCase), 0)","v":17},null,{"$f":"Module3.setChartAxis(\"4.2 SA\", \"Tornado\", \"Max\", \"Value\", \"Primary\",SAMax)","v":"Value Primary Max: 17"}]

{"sheet":"4.2 Scenario Analysis","index":18,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Fern"]

{"sheet":"4.4 Equity Analysis","index":19,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Fern"]

{"sheet":"5.1 TRAC","index":20,"n_rows":11,"n_cols":25,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,24,6,24],[5,0,5,4],[5,5,5,9],[5,10,5,15],[5,16,5,23]]}
[]
[]
[null,"CHAPTER 11: TRANSPARENT REPORTING AND ANALYSIS FOR COSTINGS (TRAC)"]
[null,"Instructions: Please complete this table as part of final submission for review. "]
[]
["NSP Alignment",null,null,null,null,"REPORTING COST ESTIMATE",null,null,null,null,"COST ESTIMATION TYPE & SOURCES",null,null,null,null,null,"DETAILS ON INGREDIENTS AND ADAPTATIONS",null,null,null,null,null,null,null,"Other Comments"]
["Intervention","Target Populations","Activities","Provider-led or community-led","Included in Costing?","Cost component","Estimated Cost Value ","currency","currency year","Output Unit","Method for Estimation","Primary Source(s)","Source Type","Modeled/Observed","Financial/Economic","Full/Incremental","Service-level human resources","Service-level overhead costs","Above service-level (indirect) costs?","Supplies","Adjusted for historical inflation?","Adapted cost for specific ingredients?","Other adaptations (scale, output, other)?","Assumptions or notes"]
["List every intervention listed in the planning document","Specify population the intervention seeks to target. \n\nN/A for program support or other interventions. ","Specify activities that make up each intervention ","Is this a community led resposed (CLR) driven and delivered by affected communities,  or by health or other professional providers ? ","Ta","Specify which input or activity cost is being reported in this row, e.g. drug costs or staff costs, or post-test counselling. If it is the full cost, enter Full","Insert final  cost(s) value used. ","specify currency "," currency reporting year","per measure of output (example: per person tested) ","Unit cost adapted from literature (adapatation approach), Unit cost modeled from ingredient based costing (IBC), Lump Sum or % of direct costs.","Identify primary source(s) used. If published source: input study author, year, and DOI. If unpublished documents (grey literature): input title, year, author, if available website, data accessed. If Key informant: specify role and institution, date discussed. ","Specify source type: Peer-reviewed study, Expenditure report, Budget,  Key Informant Interview,  Country modeled costing, NASA report. If other, specify. ","Was this unit costs modelled based on how the intervention should work or valued based on observed implementation? ","Is this cost financial (an expenditure) or economic (includes values for donated goods and services)? ","Does this include only the extra costs to add it on to existing services (Incremental) or include the full cost of all activities needed to run the intervention including a shared costs(Full)","Does this estimate include cost of human resources needed to administer intervention or are they accounted for elsewhere? If so specify where in assumptions. If excluded, justify.","Does this estimate include service-level overhead costs or are they accounted for elsewhere? If so specify where in assumptions. If excluded, justify.","Does this estimate include above-service-level (or indirect) costs or are they accounted for elsewhere? If so specify where in assumptions. If excluded, justify.","Does this estimate include cost of supplies or are they accounted for elsewhere? If so specify where in assumptions. If excluded, justify.","Was this estimate adjusted for historical inflation? If Not, justify. ","Was this estimate adapted for differing ingredients or costs?","Where other adaptations made? If yes, specify in assumptions or notes. ","Specify what assumptions were made and data manipulations applied for estimate. ","Provide justifications, or any other comments here. "]
["examples:"]
["VMMC","Men","Facility-based VMMC service including client assessment and counseling and VMMC itself. ","No","Yes","VMMC surgery",25.19,"USD",2023,"per person circumcised","Adapt existing unit cost","Hewett, 2016 https://doi.org/10.1186/s12889-016-3450-x","Published peer-reviewed","Observed","Financial","Full","yes","yes","Yes","Yes","yes","no"]
["VMMC","Men","(1) Demand creation communication;\n(2)  peer promoters; \n(3) separate waiting and group education areas for men aged ≥20 years during service delivery; \n(4) engagement of female partners","Partially","yes","VMMC demand creation",{"$f":"((2960.56+3616.2)/2)*0.85","v":2795.123},"USD",2018,"per region per campaign","Lumpsum","Torres-Rueda 2018 https://journals.lww.com/jaids/fulltext/2018/07010/cost_and_cost_effectiveness_of_a_demand_creation.5.aspx","Published peer-reviewed","Observed","Economic","Incremental","yes","No, included in the main VMMC costs","No, only direct costs for demand creation included","Yes","Yes","Yes, female engement activity removed (roughtly estimated as 15% of cost), ","Yes, Average of the 2 regional costs reported in the paper was taken"]

{"sheet":"5.2 Results Summary","index":21,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CHAPTER 11: PACKAGING THE COST ANALYSIS FOR USE"]
[]
[null,"Presenting intuitive figures and graphs"]
[]
[]
[]
[]
[]
[null,null,2025,{"$f":"C11+1","v":2026},{"$f":"D11+1","v":2027},2028,2029,2030,"Total ","%"]
[null,"Row Labels","Sum of 2025","Sum of 2026","Sum of 2027","Sum of 2028","Sum of 2029","Sum of 2030",null,null,null,null,null,"Total in Millions USD",{"$f":"C11","v":2025},{"$f":"D11","v":2026},2027,2028,2029,2030]
[null,"1. Accelerate prevention to reduce new HIV, TB and STI infections.",878124144.5,878124144.5,878124144.5,878124144.5,878124144.5,479524144.5,{"$f":"SUM(C13:H13)","v":4870144867},{"$f":"I13/I$18","v":0.53817774577055666},null,null,{"$f":"B13","v":"1. Accelerate prevention to reduce new HIV, TB and STI infections."},{"$f":"SUM(O13:T13)","v":4870.144867},{"$f":"C13/1000000","v":878.12414450000006},{"$f":"D13/1000000","v":878.12414450000006},{"$f":"E13/1000000","v":878.12414450000006},{"$f":"F13/1000000","v":878.12414450000006},{"$f":"G13/1000000","v":878.12414450000006},{"$f":"H13/1000000","v":479.52414449999998}]
[null,"2. Reduce morbidity and mortality by providing treatment, care and adherence support for all.",null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":"2. Reduce morbidity and mortality by providing treatment, care and adherence support for all."},{"$f":"SUM(O14:T14)","v":0},{"$f":"C14/1000000","v":0},0,0,0,0,0]
[null,"3. Reach all key and vulnerable populations with comprehensive, customised and targeted interventions.",5618000,5618000,5618000,5618000,5618000,5618000,{"$f":"SUM(C15:H15)","v":33708000},{"$f":"I15/I$18","v":3.7249190629535999E-3},null,null,"3. Reach all key and vulnerable populations with comprehensive, customised and targeted interventions.",33.708000000000006,5.6180000000000003,5.6180000000000003,5.6180000000000003,5.6180000000000003,5.6180000000000003,5.6180000000000003]
[null,"5. Ground the response to HIV, TB and STIs in human rights principles and approaches",690911879.015342,690911879.015342,690911879.015342,690911879.015342,690911879.015342,690911879.015342,{"$f":"SUM(C16:H16)","v":4145471274.0920515},{"$f":"I16/I$18","v":0.45809733516648959},null,null,"5. Ground the response to HIV, TB and STIs in human rights principles and approaches",4145.4712740920522,690.91187901534204,690.91187901534204,690.91187901534204,690.91187901534204,690.91187901534204,690.91187901534204]
[null,"9. Critical enablers to maximise the reach and impact of National response to HIV, TB and STIs",null,null,null,null,null,null,null,null,null,null,"9. Critical enablers to maximise the reach and impact of National response to HIV, TB and STIs",0,0,0,0,0,0,0]
[null,"Grand Total",1574654023.515342,1574654023.515342,1574654023.515342,1574654023.515342,1574654023.515342,1176054023.515342,{"$f":"SUM(C18:H18)","v":9049324141.0920525},null,null,null,{"$f":"B18","v":"Grand Total"},null,{"$f":"C18/1000000","v":1574.654023515342},{"$f":"D18/1000000","v":1574.654023515342},{"$f":"E18/1000000","v":1574.654023515342},{"$f":"F18/1000000","v":1574.654023515342},{"$f":"G18/1000000","v":1574.654023515342},{"$f":"H18/1000000","v":1176.0540235153419}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"c"]