TGF ROI Refactor Input and Assumption Inventory

Generated from local project CSV inventories on 2026-07-01 09:38:50 EDT.

Print tip: Use your browser print dialog, choose landscape orientation if it is not selected automatically, and keep background graphics enabled for table shading.

Report Purpose

This print-friendly report summarizes the current model-dump, WEO, LEB22, grant-cycle, and model-assumption inputs for the local TGF ROI refactor. It is generated from CSV files so it can be regenerated as the inventory changes.

LEB22 Input Location

/Users/sresch/Projects/TGF ROI 26/data/raw/helpers/LEB22WDI.xlsx

Configured in config.yml as leb22wdi: data/raw/helpers/LEB22WDI.xlsx.

Sheet Data has columns ISO and LEB22. It is read by R/WEOforROI.R and used to derive VSLYUSD.

Core Dump Columns

The three dumpic files use year, modelcentral, indicator, country, and scenariodescriptor. The modelhigh and modellow fields are not used by the current ROI scripts.

Model Assumptions Helper

Source CSV: data/raw/helpers/modelassumptions.csv. A020, A035, A036, and A037 are intentionally omitted from this modifiable assumptions helper.

ID	Scope	Parameter	Subparameter	Value	Type	Units
A001	global	discountrate		0.03	number	rate
A002	global	discountbaseyear		2023	integer	year
A003	global	comparisonscenario	baseline	CC2022	string
A003	global	comparisonscenario	intervention	IC	string
A006	global	combinedperiod	startyear	2024	integer	year
A006	global	combinedperiod	endyear	2030	integer	year
A006	global	combinedperiod	label	2024 to 30	string
A007	global	tgfweightinggrantcycle		GC8	string
A008	global	totalinvestmentamountusd		18000000000	number	USD
A009	HIV	diseaseinvestmentshare		0.48	number	share
A009	TB	diseaseinvestmentshare		0.21	number	share
A009	Malaria	diseaseinvestmentshare		0.31	number	share
A010	global	tgfpctcostcap		1	number	share
A011	HIV	wageadjustment		0.75	number	multiplier
A011	TB	wageadjustment		0.5	number	multiplier
A011	Malaria	wageadjustment		0.5	number	multiplier
A012	global	workdaysperyear		230	number	days
A013	TB	tbcasedurationdays		60	number	days
A014	Malaria	malariacasedurationdays	regular	3	number	days
A014	Malaria	malariacasedurationdays	severe	10	number	days
A015	HIV	hivrelativeproductivitysymptomatic		0.85	number	share
A016	HIV	hivrelativeproductivityart		1	number	share
A017	HIV	productiveyllfactor		1	number	multiplier
A018	HIV	hivdisabilityweight	AIDSonART	0.078	number	weight
A018	HIV	hivdisabilityweight	AIDSNotInCare	0.582	number	weight
A018	HIV	hivdisabilityweight	Symptomatic	0.274	number	weight
A018	HIV	hivdisabilityweight	EarlyHIV	0.012	number	weight
A019	HIV	hivartdalyweightmix	AIDSonART	0.5	number	share
A019	HIV	hivartdalyweightmix	EarlyHIV	0.5	number	share
A021	lifetable	podageidtoagegrp	1	0	number	years
A021	lifetable	podageidtoagegrp	6	5	number	years
A021	lifetable	podageidtoagegrp	7	10	number	years
A021	lifetable	podageidtoagegrp	8	15	number	years
A021	lifetable	podageidtoagegrp	9	20	number	years
A021	lifetable	podageidtoagegrp	10	25	number	years
A021	lifetable	podageidtoagegrp	11	30	number	years
A021	lifetable	podageidtoagegrp	12	35	number	years
A021	lifetable	podageidtoagegrp	13	40	number	years
A021	lifetable	podageidtoagegrp	14	45	number	years
A021	lifetable	podageidtoagegrp	15	50	number	years
A021	lifetable	podageidtoagegrp	16	55	number	years
A021	lifetable	podageidtoagegrp	17	60	number	years
A021	lifetable	podageidtoagegrp	18	65	number	years
A021	lifetable	podageidtoagegrp	19	70	number	years
A021	lifetable	podageidtoagegrp	20	75	number	years
A021	lifetable	podageidtoagegrp	21	80	number	years
A022	lifetable	rleageintervalyears		5	number	years
A022	lifetable	rledeathmidintervalyears		2.5	number	years
A023	productivity	workinglifeterminalage		65	number	years
A024	productivity	childlagtoworkhivtb	0	12.5	number	years
A024	productivity	childlagtoworkhivtb	5	7.5	number	years
A024	productivity	childlagtoworkhivtb	10	2.5	number	years
A024	productivity	childlagtoworkhivtb	default	0	number	years
A025	Malaria	malariaworkinglifefraction		0.75	number	share
A026	Malaria	malariachildlagtowork	0	12.5	number	years
A026	Malaria	malariachildlagtowork	5	7.5	number	years
A026	Malaria	malariachildlagtowork	default	0	number	years
A027	Malaria	malaria15plusrleproxyage		30	number	years
A028	TB	tbcostreverseinflationrate		0.02	number	rate
A028	TB	tbcostreverseinflationanchoryear		2023	integer	year
A028	TB	tbcostreverseinflationapplyafteryear		2022	integer	year
A029	weovsl	vslincomeelasticity		1.5	number	elasticity
A030	weovsl	usvslanchoryear		2023	integer	year
A030	weovsl	usvslanchorvalueusd		12310000	number	USD
A031	weovsl	vslylifeexpectancyfraction		0.5	number	share
A032	weovsl	weoprojectionfillstartyear		2023	integer	year
A032	weovsl	weoprojectionendyear		2030	integer	year
A033	weovsl	weobackfilliso		ERI	string	ISO
A033	weovsl	weobackfilltargetyear		2022	integer	year
A033	weovsl	weobackfillsourceyear		2019	integer	year
A034	weovsl	weoscalemultiplier	Billions	1000000000	number	multiplier
A034	weovsl	weoscalemultiplier	Millions	1000000	number	multiplier
A034	weovsl	weosubjectsuffixdivisor	PCH	100	number	divisor
A034	weovsl	weosubjectsuffixdivisor	NGDP	100	number	divisor
A038	global	excludedmodelyear		2022	integer	year

Original Candidate Review List

Source CSV: docs/hardcodedassumptioncandidates.csv. This is retained as review history and may include items that are now externalized or intentionally not included in the model-assumptions helper.

ID Scope Parameter Current value Location Usage Review question
A001 global discountrate 0.03 R/ROIHIV.R:268; R/ROITB.R:160; R/ROIMAL.R:162; R/WEOforROI.R:221 Discounts costs, DALYs, mortality, productivity gains, benefits, and VSLY denominator. Should one shared discount rate control all disease scripts and WEO/VSLY calculations?

A002 global discountbaseyear 2023 data/raw/helpers/modelassumptions.csv; R/projectpaths.R:160-175; R/ROIHIV.R:254; R/ROITB.R:146; R/ROIMAL.R:154; R/WEOforROI.R:9 Configured base year for discount exponents and WEO real GDP/VSL rebasing; can be overridden for tests with ROIDISCOUNTBASEYEAR. Smoke-tested for 2023-2026. Confirm whether alternate base-year economics are conceptually desired, not only computationally valid.

A003 global comparisonscenarios baseline=CC2022; intervention=IC data/raw/helpers/modelassumptions.csv; R/projectpaths.R:134-158; R/ROIHIV.R:82,265; R/ROITB.R:48,179; R/ROIMAL.R:28,127 Defines incremental impact/cost as intervention scenario minus baseline scenario. Both scenario names are validated against all three dump files. Values can be changed to any scenariodescriptor values present in all three disease dumps.

A004 global gc7years 2024;2025;2026 data/raw/helpers/grantcycleperiods.csv; R/projectpaths.R:27-43 Defines the GC7 reporting period. Externalized in the grant-cycle period mapping table; confirm cycle range and labels.

A005 global gc8years 2027;2028;2029 data/raw/helpers/grantcycleperiods.csv; R/projectpaths.R:27-43 Defines the GC8 reporting period. Externalized in the grant-cycle period mapping table; confirm cycle range and labels.

A006 global combinedperiodyears year > 2023, displayed as 2024 to 30 R/ROIHIV.R:452; R/ROITB.R:378; R/ROIMAL.R:367 Defines the full reporting period used in the RPubs combined table. Should this be explicit start/end years instead of year > 2023?

A007 global tgfweightingcostyears GC8 years from grantcycleperiods.csv R/ROIHIV.R:445-464; R/ROITB.R:371-391; R/ROIMAL.R:360-378 Uses GC8 IC costs to estimate TGF percentage of total intervention cost. Now driven by the grant-cycle period mapping table; confirm TGF weighting should always use GC8.

A008 global totalinvestmentamountusd 18000000000 R/ROIHIV.R:483; R/ROITB.R:410; R/ROIMAL.R:397 Total investment envelope used to allocate TGF-weighted costs. Should this be one global assumption?

A009 disease diseaseinvestmentshares HIV=0.48; TB=0.21; Malaria=0.31 R/ROIHIV.R:484; R/ROITB.R:411; R/ROIMAL.R:398 Splits the total investment amount across diseases. Are these the final shares, and should they sum-validate to 1.0?

A010 global tgfpctcostcap 1 R/ROIHIV.R:497; R/ROITB.R:424; R/ROIMAL.R:411 Caps TGF percentage of intervention cost at 100%. Should the cap be configurable or always enforced?

A011 disease wageadjustment HIV=0.75; TB=0.5; Malaria=0.5 R/ROIHIV.R:399; R/ROITB.R:337; R/ROIMAL.R:326 Adjusts GDP per capita for productivity-gain calculations. Are these wage/productivity adjustment factors correct by disease?

A012 global workdaysperyear 230 R/ROIHIV.R:404; R/ROITB.R:341; R/ROIMAL.R:330 Converts case durations in days to work-year equivalents. Should this be shared globally across disease scripts?

A013 tb tbcasedurationdays 60 R/ROITB.R:340,348 Duration of productivity loss for TB live cases. Should TB duration stay 60 days?

A014 malaria malariacasedurationdays regular=3; severe=10 R/ROIMAL.R:328-329,337 Duration of productivity loss for malaria regular cases and hospitalizations/severe cases. Are 3 and 10 days the desired regular/severe assumptions?

A015 hiv hivrelativeproductivitysymptomatic 0.85 R/ROIHIV.R:405,423 Assumes symptomatic HIV productivity equals 85% of full productivity; lost productivity uses 1 - 0.85. Should this be disease-state specific and configurable?

A016 hiv hivrelativeproductivityart 1 R/ROIHIV.R:406 Declared but not currently used in calculations. Keep as a future assumption, wire it into code, or remove it?

A017 hiv productiveyllfactor 1 R/ROIHIV.R:408 Declared but not currently used in calculations. Keep as a future assumption, wire it into code, or remove it?

A018 hiv hivdisabilityweights AIDSonART=0.078; AIDSNotInCare=0.582; Symptomatic=0.274; EarlyHIV=0.012 R/ROIHIV.R:64-67,151-153 Used to construct HIV YLD rows from ART/symptomatic/AIDS-no-treatment indicators. Should these be a disease-state lookup table with citations?

A019 hiv hivartdalyweightmix AIDSonART share=0.5; EarlyHIV share=0.5 R/ROIHIV.R:68,70 Defines ART disability weight as a 50/50 mix of AIDS on ART and early HIV. Is the 50/50 ART mix still intended?

A020 hiv hivnotxstatemapping symptomatic indicators: notx15plus100to200, notx15plus50to100, notx5to14less200; AIDSnoTx indicators: notx15plusless50, notxless5less5 R/ROIHIV.R:97-111,118-139 Maps CD4/no-treatment model indicators into symptomatic and AIDS-not-in-care states. Should all no-treatment CD4 bands be explicitly mapped through an input table?

A021 lifetable podageidtoagegrpmapping 1=0; 6=5; 7=10; ...; 21=80 R/ROIHIV.R:199-218; R/ROITB.R:92-111; R/ROIMAL.R:74-93 Converts PoD ageid values to age group starts. Should this be an input lookup table instead of repeated casewhen blocks?

A022 lifetable rleageintervalparameters intervalyears=5; deathmidintervalyears=2.5 R/ROIHIV.R:237; R/ROITB.R:130; R/ROIMAL.R:112 Approximates years lived within each 5-year age interval when calculating RLE. Should these life-table interval assumptions be externalized?

A023 productivity hivtbworkinglifeterminalage 65 R/ROIHIV.R:251; R/ROITB.R:144 Calculates working RLE as RLE minus RLE at age 65 for HIV and TB. Should working life terminal age be 65 for both HIV and TB?

A024 productivity hivtbchildlagtoworkyears age 0=12.5; age 5=7.5; age 10=2.5; otherwise=0 R/ROIHIV.R:258-262; R/ROITB.R:151-155 Discounts future productivity for children until working age. Should child lag-to-work be a shared age lookup?

A025 malaria malariaworkinglifefraction 0.75 R/ROIMAL.R:126 Sets malaria working RLE to 75% of remaining life expectancy. Should malaria use this 75% shortcut or the HIV/TB age-65 method?

A026 malaria malariachildlagtoworkyears age 0=12.5; age 5=7.5; otherwise=0 R/ROIMAL.R:132-135 Discounts future malaria productivity for young children. Should malaria use the same age 10 lag as HIV/TB if age 10 exists in inputs?

A027 malaria malaria15plusrleproxyage 30 R/ROIMAL.R:172-186 Temporarily maps malaria age group 15+ to age 30 for RLE/dRLE joins. Is age 30 still the intended proxy for malaria 15+ outcomes?

A028 tb tbcostreverseinflationrate 0.02 R/ROITB.R:176-181 Removes a 2% inflation adjustment from TB costs for years after 2022; intentionally remains anchored to the TB model-dump assumption rather than discountbaseyear. Should this be generalized to all diseases or stay TB-only?

A029 weovsl vslincomeelasticity 1.5 R/WEOforROI.R:165,175,196 Applies income elasticity to grow US VSL and scale VSL by country PPP GDP per capita. Should VSL income elasticity remain 1.5?

A030 weovsl usvslanchor year=2023; valueusd=12310000 data/raw/helpers/modelassumptions.csv; R/WEOforROI.R:12-13,197-198 US VSL anchor year and value used to construct the USVSL series before scaling to countries. Confirm value, year, and source citation.

A031 weovsl vslylifeexpectancyfraction 0.5 R/WEOforROI.R:219,228,236 Uses one-half of life expectancy at birth as the VSLY annuity duration. Should VSLY continue using half of LEB22?

A032 weovsl weoprojectionyears 2023:2030 fill; final output 2023:2030 R/WEOforROI.R:102,108-120,125,148 Fills missing WEO values forward through 2030 and drops 2022 after pivoting. Should projection years be tied to the analysis period inputs?

A033 weovsl eritrea2022weobackfill ERI 2022 = ERI 2019 R/WEOforROI.R:30-31 Country-specific WEO data repair for Eritrea. Should country-specific data repairs be represented in a separate input table?

A034 weovsl weoscaleconversions Billions=1e9; Millions=1e6; PCH=/100; NGDP=/100 R/WEOforROI.R:19-55 Converts WEO units/percentages before valuation calculations. These look like data cleaning rules; should they stay in code or be documented as assumptions?

A035 reporting billionoutputdivisor 1000000000 R/ROIHIV.R:588-626; R/ROITB.R:520-558; R/ROIMAL.R:503-544 Reports costs and benefits in billions. Probably reporting-only; should not be in the model assumptions CSV unless desired.

A036 reporting tableroundingdigits currency mixed; BCR usually 1 digit; alive instrumental BCR often 2 digits R/ROIHIV.R:663-725; R/ROITB.R:598-663; R/ROIMAL.R:584-649 Formats final kable outputs. Probably presentation config rather than model assumptions.

A037 global bcroppositesignrule set BCR to NA when cost and benefit have opposite signs R/ROIHIV.R:441-443; R/ROITB.R:367-369; R/ROIMAL.R:356-358 Suppresses BCR for cost-saving/dominated cases. Should this rule be configurable or documented only?

A038 global excludedmodelyear 2022 R/ROIHIV.R:391; R/ROITB.R:330; R/ROIMAL.R:345; R/WEOforROI.R:109-110 Drops 2022 from ROI summaries after using it as baseline context. Should excluded years be explicit inputs?

Input Variable Inventory

Source CSV: docs/inputvariableinventory.csv

Source Local file Sheet/script Input variable Source name or values Used as Used in Notes
dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R year year Year for grouping joins reporting periods and discount exponents HIV TB Malaria Used directly in all ROI scripts.

dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R centralvalue modelcentral renamed to val Model outcome or cost value by country year scenario indicator HIV TB Malaria Only central model estimate is used.

dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R uncertaintyvalues modelhigh and modellow Not used HIV TB Malaria HIV drops these after read; TB/Malaria skip these at read.

dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R indicator indicator Identifies cost deaths cases YLD and disease-specific states HIV TB Malaria Parsed into agegrp and indicator2.

dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R country country renamed to iso Country ISO code for joins and aggregation HIV TB Malaria Joined to PoD WEO allocation and tier/region data.

dumpic all three model dumps ROIHIV.R; ROITB.R; ROIMAL.R scenario scenariodescriptor renamed to scenario Scenario comparison input HIV TB Malaria Current scripts compare IC vs CC2022.

dumpic HIV dump ROIHIV.R hivcostindicator cost Incremental costs HIV Used to create costIC costCC costdiff disccostdiff.

dumpic HIV dump ROIHIV.R hivdeathindicators deaths* by age group Deaths averted and YLL HIV Parsed by age group and joined to remaining life expectancy.

dumpic HIV dump ROIHIV.R hivartindicator art HIV YLD input HIV Multiplied by DALYwtART to create derived YLD rows.

dumpic HIV dump ROIHIV.R hivsymptomaticsourceindicators notx15plus100to200; notx15plus50to100; notx5to14less200 Derived symptomatic HIV state HIV Summed into a new symptomatic indicator.

dumpic HIV dump ROIHIV.R hivaidsnotxsourceindicators notx15plusless50; notxless5less5 Derived AIDS-no-treatment state HIV Summed into a new AIDSnoTx indicator.

dumpic HIV dump ROIHIV.R hivsymptomaticderivedindicator symptomatic Productivity loss while alive and HIV YLD HIV Derived from selected no-treatment indicators.

dumpic HIV dump ROIHIV.R hivaidsnotxderivedindicator AIDSnoTx HIV YLD HIV Derived from selected no-treatment indicators.

dumpic HIV dump ROIHIV.R hivyldderivedindicator YLD Final HIV YLD difference HIV Created inside script from art symptomatic and AIDSnoTx rows.

dumpic TB dump ROITB.R tbcostindicator cost Incremental costs TB Costs receive TB-only reverse inflation adjustment before ROI calculations.

dumpic TB dump ROITB.R tbyldindicator yldhivneg TB YLD difference TB Used to create YLDIC YLDCC YLDdiff.

dumpic TB dump ROITB.R tbdeathindicators deaths* by age group Deaths averted and YLL TB Parsed by age group and joined to remaining life expectancy.

dumpic TB dump ROITB.R tbcaseindicators cases* by age group Live-case productivity loss TB Aggregated to totwkagecasesIC/CC/diff.

dumpic Malaria dump ROIMAL.R malariacostindicator cost Incremental costs Malaria Used to create costIC costCC costdiff disccostdiff.

dumpic Malaria dump ROIMAL.R malariayldindicator yld Malaria YLD difference Malaria Used to create YLDIC YLDCC YLDdiff.

dumpic Malaria dump ROIMAL.R malariadeathindicators deaths* by age group Deaths averted and YLL Malaria Parsed by age group and joined to remaining life expectancy.

dumpic Malaria dump ROIMAL.R malariacaseindicators cases* by age group Live-case productivity loss Malaria cases15plus is normalized to cases15to80 before parsing.

dumpic Malaria dump ROIMAL.R malariahospitalizationindicator hospitalization Severe/hospitalized case productivity loss Malaria Used with severe-duration assumption.

weo WEOOct24.xlsx WEOOct2024all (1) ISO ISO Country ISO code for WEO/VSL joins HIV TB Malaria via WEOforROI.R Used to join WEO outputs to disease ROI country-year rows.

weo WEOOct24.xlsx WEOOct2024all (1) weosubjectcode WEO Subject Code renamed to indicator WEO variable selector WEOforROI.R Scripts filter to NGDPRPC NGDPRPPPPC NGDPPC NGDPDPC PPPPC.

weo WEOOct24.xlsx WEOOct2024all (1) scale Scale Unit conversion WEOforROI.R Billions multiplied by 1e9; Millions by 1e6.

weo WEOOct24.xlsx WEOOct2024all (1) yearcolumns 2019-2029 plus created 2030 Time-series WEO values WEOforROI.R 2019 only used for ERI 2022 backfill; 2022-2030 are pivoted; final WEO output drops 2022.

weo WEOOct24.xlsx WEOOct2024all (1) realgdppercapitaindex NGDPRPC Computes per-capita growth factor GrwthPC WEOforROI.R Directly used in WEO formulas.

weo WEOOct24.xlsx WEOOct2024all (1) nominalgdppercapitausd NGDPDPC Computes NGDP23DPCR and PPPperUSD23 WEOforROI.R NGDP23DPCR is used by disease scripts for productivity gains.

weo WEOOct24.xlsx WEOOct2024all (1) pppgdppercapitacurrentintl PPPPC Computes PPPPC23R and PPPperUSD23 WEOforROI.R Used in VSL/VSLY construction.

weo WEOOct24.xlsx WEOOct2024all (1) realpppgdppercapita NGDPRPPPPC Loaded and filled but not directly used in current formulas WEOforROI.R Retained in WEOOct24wide but no downstream formula reference found.

weo WEOOct24.xlsx WEOOct2024all (1) nominalgdppercapitangdp NGDPPC Loaded and filled but not directly used in current formulas WEOforROI.R Retained in WEOOct24wide but no downstream formula reference found.

weo derived in WEOforROI.R WEOforROI.R GrwthPC NGDPRPC / lag(NGDPRPC) Per-capita growth factor WEOforROI.R Used to rebase NGDP23DPCR and PPPPC23R around discountbaseyear.

weo derived in WEOforROI.R WEOforROI.R NGDP23DPCR NGDPDPC rebased by GrwthPC around discountbaseyear Real base-year USD GDP per capita HIV TB Malaria Used for productivity gain calculations. Column name is retained for compatibility even when base year is not 2023.

weo derived in WEOforROI.R WEOforROI.R PPPPC23R PPPPC rebased by GrwthPC around discountbaseyear Real base-year PPP GDP per capita WEOforROI.R Used to scale VSL by income. Column name is retained for compatibility even when base year is not 2023.

weo derived in WEOforROI.R WEOforROI.R VSLYUSD VSLUSD divided by discounted half-LEB annuity Intrinsic benefit per DALY HIV TB Malaria Joined into disease ROI scripts and multiplied by DALYs.

leb22 LEB22WDI.xlsx Data ISO ISO Country ISO code WEOforROI.R Joined to WEOOct24wide.

leb22 LEB22WDI.xlsx Data LEB22 LEB22 Life expectancy at birth in 2022 WEOforROI.R Used to compute HalfLEB22 dHalfLEB and VSLYUSD.

grantcycle grantcycleperiods.csv grantcycleperiods.csv grantcycle GC7-GC16 Grant cycle label HIV TB Malaria Used to map model years to grant-cycle reporting periods.

grantcycle grantcycleperiods.csv grantcycleperiods.csv cyclenumber 7-16 Numeric grant cycle number HIV TB Malaria Included for sorting and future cycle logic.

grantcycle grantcycleperiods.csv grantcycleperiods.csv year 2024-2053 Calendar year HIV TB Malaria Joined to summaryresultDALY by year.

grantcycle grantcycleperiods.csv grantcycleperiods.csv cyclestartyear 2024-2051 Grant cycle start year HIV TB Malaria Documents the three-year cycle bounds.

grantcycle grantcycleperiods.csv grantcycleperiods.csv cycleendyear 2026-2053 Grant cycle end year HIV TB Malaria Documents the three-year cycle bounds.

grantcycle grantcycleperiods.csv grantcycleperiods.csv cycleyearindex 1-3 Year position within grant cycle HIV TB Malaria Supports future within-cycle logic.

modelassumptions data/raw/helpers/modelassumptions.csv modelassumptions.csv discountbaseyear 2023 Base year for discount exponents and WEO real GDP/VSL rebasing HIV TB Malaria WEOforROI.R Can be overridden for tests with ROIDISCOUNTBASEYEAR; smoke-tested for 2023-2026.

config environment variable ROIDISCOUNTBASEYEAR discountbaseyearoverride 2023-2026 tested Temporary override for discountbaseyear testing Used by scripts/testdiscountbaseyears.R without editing the assumptions helper.

modelassumptions data/raw/helpers/modelassumptions.csv modelassumptions.csv usvslanchoryear 2023 Anchor year for US VSL series WEOforROI.R Separate from discountbaseyear.

modelassumptions data/raw/helpers/modelassumptions.csv modelassumptions.csv usvslanchorvalueusd 12310000 Anchor US VSL value WEOforROI.R Used to build the USVSL series before country scaling.

Source	Local file	Sheet/script	Input variable	Source name or values	Used as	Used in	Notes
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	year	year	Year for grouping joins reporting periods and discount exponents	HIV TB Malaria	Used directly in all ROI scripts.
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	centralvalue	modelcentral renamed to val	Model outcome or cost value by country year scenario indicator	HIV TB Malaria	Only central model estimate is used.
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	uncertaintyvalues	modelhigh and modellow	Not used	HIV TB Malaria	HIV drops these after read; TB/Malaria skip these at read.
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	indicator	indicator	Identifies cost deaths cases YLD and disease-specific states	HIV TB Malaria	Parsed into agegrp and indicator2.
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	country	country renamed to iso	Country ISO code for joins and aggregation	HIV TB Malaria	Joined to PoD WEO allocation and tier/region data.
dumpic	all three model dumps	ROIHIV.R; ROITB.R; ROIMAL.R	scenario	scenariodescriptor renamed to scenario	Scenario comparison input	HIV TB Malaria	Current scripts compare IC vs CC2022.
dumpic	HIV dump	ROIHIV.R	hivcostindicator	cost	Incremental costs	HIV	Used to create costIC costCC costdiff disccostdiff.
dumpic	HIV dump	ROIHIV.R	hivdeathindicators	deaths* by age group	Deaths averted and YLL	HIV	Parsed by age group and joined to remaining life expectancy.
dumpic	HIV dump	ROIHIV.R	hivartindicator	art	HIV YLD input	HIV	Multiplied by DALYwtART to create derived YLD rows.
dumpic	HIV dump	ROIHIV.R	hivsymptomaticsourceindicators	notx15plus100to200; notx15plus50to100; notx5to14less200	Derived symptomatic HIV state	HIV	Summed into a new symptomatic indicator.
dumpic	HIV dump	ROIHIV.R	hivaidsnotxsourceindicators	notx15plusless50; notxless5less5	Derived AIDS-no-treatment state	HIV	Summed into a new AIDSnoTx indicator.
dumpic	HIV dump	ROIHIV.R	hivsymptomaticderivedindicator	symptomatic	Productivity loss while alive and HIV YLD	HIV	Derived from selected no-treatment indicators.
dumpic	HIV dump	ROIHIV.R	hivaidsnotxderivedindicator	AIDSnoTx	HIV YLD	HIV	Derived from selected no-treatment indicators.
dumpic	HIV dump	ROIHIV.R	hivyldderivedindicator	YLD	Final HIV YLD difference	HIV	Created inside script from art symptomatic and AIDSnoTx rows.
dumpic	TB dump	ROITB.R	tbcostindicator	cost	Incremental costs	TB	Costs receive TB-only reverse inflation adjustment before ROI calculations.
dumpic	TB dump	ROITB.R	tbyldindicator	yldhivneg	TB YLD difference	TB	Used to create YLDIC YLDCC YLDdiff.
dumpic	TB dump	ROITB.R	tbdeathindicators	deaths* by age group	Deaths averted and YLL	TB	Parsed by age group and joined to remaining life expectancy.
dumpic	TB dump	ROITB.R	tbcaseindicators	cases* by age group	Live-case productivity loss	TB	Aggregated to totwkagecasesIC/CC/diff.
dumpic	Malaria dump	ROIMAL.R	malariacostindicator	cost	Incremental costs	Malaria	Used to create costIC costCC costdiff disccostdiff.
dumpic	Malaria dump	ROIMAL.R	malariayldindicator	yld	Malaria YLD difference	Malaria	Used to create YLDIC YLDCC YLDdiff.
dumpic	Malaria dump	ROIMAL.R	malariadeathindicators	deaths* by age group	Deaths averted and YLL	Malaria	Parsed by age group and joined to remaining life expectancy.
dumpic	Malaria dump	ROIMAL.R	malariacaseindicators	cases* by age group	Live-case productivity loss	Malaria	cases15plus is normalized to cases15to80 before parsing.
dumpic	Malaria dump	ROIMAL.R	malariahospitalizationindicator	hospitalization	Severe/hospitalized case productivity loss	Malaria	Used with severe-duration assumption.
weo	WEOOct24.xlsx	WEOOct2024all (1)	ISO	ISO	Country ISO code for WEO/VSL joins	HIV TB Malaria via WEOforROI.R	Used to join WEO outputs to disease ROI country-year rows.
weo	WEOOct24.xlsx	WEOOct2024all (1)	weosubjectcode	WEO Subject Code renamed to indicator	WEO variable selector	WEOforROI.R	Scripts filter to NGDPRPC NGDPRPPPPC NGDPPC NGDPDPC PPPPC.
weo	WEOOct24.xlsx	WEOOct2024all (1)	scale	Scale	Unit conversion	WEOforROI.R	Billions multiplied by 1e9; Millions by 1e6.
weo	WEOOct24.xlsx	WEOOct2024all (1)	yearcolumns	2019-2029 plus created 2030	Time-series WEO values	WEOforROI.R	2019 only used for ERI 2022 backfill; 2022-2030 are pivoted; final WEO output drops 2022.
weo	WEOOct24.xlsx	WEOOct2024all (1)	realgdppercapitaindex	NGDPRPC	Computes per-capita growth factor GrwthPC	WEOforROI.R	Directly used in WEO formulas.
weo	WEOOct24.xlsx	WEOOct2024all (1)	nominalgdppercapitausd	NGDPDPC	Computes NGDP23DPCR and PPPperUSD23	WEOforROI.R	NGDP23DPCR is used by disease scripts for productivity gains.
weo	WEOOct24.xlsx	WEOOct2024all (1)	pppgdppercapitacurrentintl	PPPPC	Computes PPPPC23R and PPPperUSD23	WEOforROI.R	Used in VSL/VSLY construction.
weo	WEOOct24.xlsx	WEOOct2024all (1)	realpppgdppercapita	NGDPRPPPPC	Loaded and filled but not directly used in current formulas	WEOforROI.R	Retained in WEOOct24wide but no downstream formula reference found.
weo	WEOOct24.xlsx	WEOOct2024all (1)	nominalgdppercapitangdp	NGDPPC	Loaded and filled but not directly used in current formulas	WEOforROI.R	Retained in WEOOct24wide but no downstream formula reference found.
weo	derived in WEOforROI.R	WEOforROI.R	GrwthPC	NGDPRPC / lag(NGDPRPC)	Per-capita growth factor	WEOforROI.R	Used to rebase NGDP23DPCR and PPPPC23R around discountbaseyear.
weo	derived in WEOforROI.R	WEOforROI.R	NGDP23DPCR	NGDPDPC rebased by GrwthPC around discountbaseyear	Real base-year USD GDP per capita	HIV TB Malaria	Used for productivity gain calculations. Column name is retained for compatibility even when base year is not 2023.
weo	derived in WEOforROI.R	WEOforROI.R	PPPPC23R	PPPPC rebased by GrwthPC around discountbaseyear	Real base-year PPP GDP per capita	WEOforROI.R	Used to scale VSL by income. Column name is retained for compatibility even when base year is not 2023.
weo	derived in WEOforROI.R	WEOforROI.R	VSLYUSD	VSLUSD divided by discounted half-LEB annuity	Intrinsic benefit per DALY	HIV TB Malaria	Joined into disease ROI scripts and multiplied by DALYs.
leb22	LEB22WDI.xlsx	Data	ISO	ISO	Country ISO code	WEOforROI.R	Joined to WEOOct24wide.
leb22	LEB22WDI.xlsx	Data	LEB22	LEB22	Life expectancy at birth in 2022	WEOforROI.R	Used to compute HalfLEB22 dHalfLEB and VSLYUSD.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	grantcycle	GC7-GC16	Grant cycle label	HIV TB Malaria	Used to map model years to grant-cycle reporting periods.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	cyclenumber	7-16	Numeric grant cycle number	HIV TB Malaria	Included for sorting and future cycle logic.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	year	2024-2053	Calendar year	HIV TB Malaria	Joined to summaryresultDALY by year.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	cyclestartyear	2024-2051	Grant cycle start year	HIV TB Malaria	Documents the three-year cycle bounds.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	cycleendyear	2026-2053	Grant cycle end year	HIV TB Malaria	Documents the three-year cycle bounds.
grantcycle	grantcycleperiods.csv	grantcycleperiods.csv	cycleyearindex	1-3	Year position within grant cycle	HIV TB Malaria	Supports future within-cycle logic.
modelassumptions	data/raw/helpers/modelassumptions.csv	modelassumptions.csv	discountbaseyear	2023	Base year for discount exponents and WEO real GDP/VSL rebasing	HIV TB Malaria WEOforROI.R	Can be overridden for tests with ROIDISCOUNTBASEYEAR; smoke-tested for 2023-2026.
config	environment variable	ROIDISCOUNTBASEYEAR	discountbaseyearoverride	2023-2026 tested	Temporary override for discountbaseyear	testing	Used by scripts/testdiscountbaseyears.R without editing the assumptions helper.
modelassumptions	data/raw/helpers/modelassumptions.csv	modelassumptions.csv	usvslanchoryear	2023	Anchor year for US VSL series	WEOforROI.R	Separate from discountbaseyear.
modelassumptions	data/raw/helpers/modelassumptions.csv	modelassumptions.csv	usvslanchorvalueusd	12310000	Anchor US VSL value	WEOforROI.R	Used to build the USVSL series before country scaling.