The Household Module The Urban Sheet
The “Urban Sheet” includes general assumptions and input
data for calculation of urban household size, household number and household
expenditure.
· Click here
to get an animated introduction to this sheet.
· Read the detailed overview of the sheet while
you work on it by clicking here.
Modifications to this sheet can be made simply
by adding more rows for the overview of scenarios.
Once
data has been entered into this sheet, the button in cell G64 should be clicked.
This will adjust the mean household size in each centile so that the national
mean is adjusted to census data and will realize a similar adjustment for the
electrification rate. Small differences in the errors in rows 62 and 65 are
permissible.
The
“Urban Sheet” includes general assumptions and input data for calculation of
urban household size, household number and household expenditure:
• Percentage of urban households with electricity,
• Coefficients for modeling of household size and household number,
• Coefficients for modeling of the urban household increase rate,
• Population per centile.