In This Section

The Toolkit includes Excel workbooks, associated step-by-step guides and methods documentation, as well as the Census Bureau’s Rural-Urban Projection (RUP) program and companion program for combining RUP projections (RUPAGG), and a User’s Guide for the tools included in the Toolkit. Brief descriptions of the User’s Guide and tools are presented below, along with links allowing selection of parts of the Toolkit for downloading.

An Installer file may be downloaded by those who would like to download the Census Bureau’s Population Analysis System (PAS), RUP, and the full Toolkit, and have all of these tools installed and configured to work together on their computers.

User’s Guide

This Guide describes the use of the Toolkit workbooks along with the Census Bureau’s Rural-Urban Projection (RUP) program for preparing both cohort-component and non-cohort-component projections. It also describes the use of cohort-component output to control either mathematical extrapolation of smaller area population totals or extrapolated smaller area totals with age-sex detail.

PROJTFR32Calculates consistent total fertility rates (TFRs) for up to 32 subnational area populations given initial levels of subnational area TFRs and the TFR trend for a higher administrative level (e.g., for the nation).

RUPSubAdjProportionally adjusts subnational populations and components of change by age and sex from RUP projections to agree with a national- or other higher-level RUP. Note: This workbook requires the RUP programs to be properly installed and configured. The Installer will do both installation and configuration of the RUP programs.

RUPCompareDisplays tabulated population, fertility, mortality, and migration output data and charts for each shared year in the projection period of two separate Rural-Urban Projection (RUP) program projections.

RUPSTCompareextracts and displays summary population, fertility, mortality, and migration output data in tables and charts for each year from a selected group of Rural-Urban Projection (RUP) program projections.

Non-cohort-component workbooks, step-by-step guides, and methods

SALGSTProjects the total populations of subnational areas by using a logistic function and controls projected subnational populations to a projected population series for a higher-level geographic area. The resulting projections are consistent with the higher-level series.

CTBL32Adjusts subnational populations by age to match the age distribution of a higher-level total population. The workbook iteratively adjusts subnational populations by age and region with a contingency table.

Cohort-component projection software

RUP and RUPEX The Census Bureau’s Rural and Urban Projection Program (RUP) performs cohort component projections for an unlimited number of populations or areas. The number of subpopulations for which projections may be calculated has been expanded with the addition of a second program, RUPAGG. RUPEX is the Excel user interface for RUP, RUPAGG, and RUPCombine.

[PDF] or denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® available free from Adobe.
[Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer available for free from Microsoft®.