Spreadsheet: 18357df8-b6cf-42c0-8b56-eb8a55eb4a2f
Sheet: Instructions

Notes and Instructions for the Completeness of Case Ascertainment Estimate Worksheets
Notes:
1. | The spreadsheet has been loaded with the information from the SEER Incidence and US Mortality cancer databases.
2. | The SEER and US Mortality rates may be suppressed due to publication schedules.
3. | Cancer rates throughout the spreadsheet are per 100,000 and are age-adjusted to the 2000 U.S. Standard.
4. | The cancer rates for Male Prostate (Whites and Blacks) and Melanomas of the Skin (Blacks) are not included
 | in the completeness estimate computations.
5. | The areas requiring information from the Registry are highlighted in yellow.
6. | The Adjustment Terms have been set to .2 and .2, as per the NAACCR Data Evaluation and Publication Committee.
Instructions:
To obtain an estimate of the completeness of case ascertainment for your registry, perform the following steps:
 | A:  Preliminary Steps:
 | A1. | Calculate the total number (count) of reportable cases for your registry for the reporting year.
 | A2. | Complete the NAACCR Duplicate Record Protocol on a sample of all reportable cases.
 | B:  Spreadsheet Setup:
 |  | Enter the following information on the RegistryInfo worksheet:
 | B1. | Enter the Reporting Year for case ascertainment.
 | B2. | Enter the Registry Area from the list provided.
 | B3. | Enter the Total Number of reportable cases for your registry for the reporting year (from Step A1).
 | B4. | Enter the Percent of Duplicate Records per 1,000 records, as per the NAACCR protocol (from Step A2).
 | C:  Registry-specific Incidence and Mortality Rates:
 | C1. | Compute the age-adjusted cancer incidence and cancer mortality rates (adjusted to US Std Population (19 age groups - Census P25-1130) standard) for your registry for:
 |  |  | White Males
 |  |  | White Females
 |  |  | Black Males
 |  |  | Black Females
 |  | Note: | Three sets of rates are required for each of the four race/sex groups:
 |  |  | 1.  Incidence rates, one year only, for the reporting year
 |  |  | 2.  Mortality rates, 2 year average (Current Mortality), for the 2 year period ending in the reporting year*
 |  |  | 3.  Mortality rates, 5 year average (Reference Mortality), for the 5 year period ending in the reporting year
 |  |  | When the Reporting Year and Registry Area are entered in the RegistryInfo worksheet, the column headers
 |  |  | throughout the workbook will display the required year ranges.
 |  |  |  | *  For registries with total populations under 500,000 for one year, use the 3 year average mortality rate
 |  |  |  | for the 3 year period ending in the reporting year.
 |  | Note: | For registries with no information on Race, compute the incidence and mortality rates for All Races Combined,
 |  |  | enter this information in the Whites worksheet, and enter zeroes for all values in the Blacks worksheet.
 |  |  | The RegistryInfo and Completeness Report worksheets will report the All Races information in the
 |  |  | White race areas and zeros in the Black race areas.
 | C2. | Enter the information from step C1 above on these two worksheets:
 |  | Whites
 |  |  | Enter the Age-adjusted Incidence rates for your registry for White Males and White Females in column B.
 |  |  | Enter the Age-adjusted Mortality rates (Current) for your registry for White Males and White Females in column C.
 |  |  | Enter the Age-adjusted Mortality rates (Reference) for your registry for White Males and White Females in column J.
 |  | Blacks
 |  |  | Enter the Age-adjusted Incidence rates for your registry for Black Males and Black Females in column B.
 |  |  | Enter the Age-adjusted Mortality rates (Current) for your registry for Black Males and Black Females in column C.
 |  |  | Enter the Age-adjusted Mortality rates (Reference) for your registry for Black Males and Black Females in column J.
Results:
The completeness of case ascertainment estimates are displayed on the Completeness Report worksheet.
The first set of numbers on the Completeness Report worksheet shows the completeness estimates adjusted for the
reference mortality.  These figures are for:
 | Whites, as calculated on the Whites and RegistryInfo worksheets
 | Blacks, as calculated on the Blacks and RegistryInfo worksheets
 | Race proportional completeness estimates
The second set of numbers on the Completeness Report worksheet show the final completeness estimates results, adjusted for
reference mortality and duplicate records.
For registries with no information on Race, the results for All Races is shown in the area for Whites.
Questions:
Questions regarding this spreadsheet should be directed to the NAACCR Executive Office.
Note:
If you want to save results for each year, do the calculations and then save the spreadsheet
 | with a new name, e.g., complete99PA.xls