RePPP (Regional Population Projection Program)

* User Guide
Software requirements
Contact to purchase

What is RePPP?

RePPP (Regional Population Projection Program) is an Excel-based program which produces subnational population projections using a state-of-the-art cohort-component model. It generates projections by sex and five year age group for between 2 and 50 subnational regions over a projection horizon of between 5 and 50 years. The program is suitable for regions varying in size from SA2 areas to States and Territories.


Key features 

  • projects populations by sex and five year age group up to age 85+
  • handles between 2 and 50 subnational regions
  • region size can vary from SA2 areas to States / Territories
  • projection horizon of between 5 and 50 years
  • easy to use Excel interface (see example screenshot below)
  • state-of-the-art multi-bi-regional cohort-component projection model
  • low input data requirements compared to standard multiregional models
  • separation of ‘headline’ projection assumptions (e.g. TFR, life expectancy at birth) from age profiles to facilitate easier assumption-setting and scenario creation
  • option to constrain age-sex projections to independent population totals
  • fast run time
  • validation routine to check the validity of input data
  • separate Excel output files containing various tables and graphs for each region (examples shown above)
  • several derived projection variables output (median age, % population by broad age group, population growth rates, components of change, population growth index, sex ratios by age)
  • example input data and projections supplied
  • User Guide with step-by-step instructions
  • assistance with preparing data inputs available on request



Software requirements

  • Excel 2010 or later versions
  • Familiarity with the principles of the cohort component projection model
  • Knowledge of demographic terms and concepts
  • Experience in using Microsoft Excel
  • Good computer literacy generally

On application


For more information and to purchase
Tom Wilson
0423 342 745