This information is included for reference, but is not something most
users will need to consult. If data that cannot be validated is entered
into the input spreadsheet, you will receive an error message that
describes how to resolve the issue when you attempt to run the
model.
Sheet – PopValues
Column G: InitValue
Expected behaviors
Should not be empty.
Column H: ChangeRate
Expected behavior 1
Should not be empty.
Expected behavior 2
Typically within 1.0 +/- 2%. Large value compounded over long time
horizon produces questionable predictions.
Report
Info (blue); print out all rows with ChangeRate >
1.02 or ChangeRate <0.98 for the user to review and
confirm.
Sheet – SeasonalityCurves
Column B: Malnutrition
Expected behaviors
Column sums to 1.
Column C: TB
Expected behaviors
Column sums to 1.
Column D: Births
Expected behaviors
Column sums to 1.
Column E: Malaria
Expected behaviors
Column sums to 1.
Column F: Diarrhea
Expected behaviors
Column sums to 1.
Sheet – StochasticParameters
Column B: p
Expected behaviors
Typically less than 0.25, value too large may introduce excessive
randomness to the parameters.
Report
Info (blue); print out all rows with p>=0.25 for the user to
review and confirm.
Sheet – TaskValues_ref
Column E: Indicator
Expected behavior
Should not be empty if StartingRateInPop (Column O)
contains a value.
Column J: RelevantPop
Expected behavior 1
Should not be empty.
Expected behavior 2
Should not be ‘–’ if StartingRateInPop (Column O)
contains a value.
Column S: AnnualDeltaRatio
Expected behavior 1
Should not be empty if StartingRateInPop (Column O)
contains a value.
Expected behavior 2
Typically within 1.0 +/- 2%. Large value compounded over long time
horizon produces questionable predictions.
Report
Info (blue); print out all rows with
AnnualDeltaRatio > 1.02 or
AnnualDeltaRatio <0.98 for the user to review and
confirm.
Expected behavior
Should not be empty if StartingRateInPop (Column O) contains
value.
Expected behavior 1
NumContactsPerUnit and
NumContactsAnnual should not both contain values.
Expected behavior 2
If StartingRateInPop (Column O) contains value,
NumContactsPerUnit and
NumContactsAnnual should not both be empty.
Column Z: References/Notes
Expected behavior
Should not be empty, if StartingRateInPop (Column O)
is empty.
Column Q: RateMultiplier
Report
Info (blue); print out all rows with values in
RateMultiplier for the user to review and confirm.