Skip to content

Subnational Projections Toolkit (SPToolkit) Software

Documentation
  • Documentation
  • Download
Documentation
Component ID: #ti1527182645

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.

Component ID: #ti1893817497

Cohort-component workbooks, step-by-step guides, and method descriptions

LTCSRMig

Estimates intercensal migration based on survival ratio methods.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

MIGSUB

Projects internal and international migrants by sex for subnational areas (e.g., provinces or states) based on a question in the census about residence X years before the census.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

PROJE032

Calculates consistent life expectancies at birth (e(0)) by sex for up to 32 subnational areas given initial levels of subnational area e(0)s and higher administrative level e(0) trends.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

PROJTFR32

Calculates 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).

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

RUPSubAdj

Proportionally 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.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

RUPCompare

Displays 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.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

RUPSTCompare

Extracts 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.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]
Component ID: #ti1929379354

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

SALGST

Projects 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.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]

CTBL32

Adjusts 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.

xls   Workbook   [<1.0 MB]
pdf   Guide   [<1.0 MB]
pdf   Methods   [<1.0 MB]
Component ID: #ti909825629

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.

RUPAGG Aggregates RUP output files to produce consistent sets of projections at multiple geographic levels (e.g., national and subnational projections).

RUPCombine Allows modeling of population changes due to catastrophic events (e.g., famine or civil conflict) when they are confined to one-half of a calendar year.

X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?