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.

 

Overview of the sheet

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.