Frequently Asked Questions

  ADA/508 friendly site


How do I extract employment data for multiple zip codes using the Zip Business Patterns CD/DVD-ROMS?

The Beyond 20/20 software included on the Zip Code Business Patterns CD/DVD-ROMS does not provide a feature which allows data users to download employment data for multiple zip codes at one time. There is a data file included on the CD/DVD-ROM which you can download into Excel (or another spreadsheet program) and obtain data for multiple zip codes. To access the file, follow the below listed steps:

  1. Click the "Explore this CD (or DVD, depending on the media)", from the start-up menu when the Zip Code Business Patterns disk is first installed.
  2. Double click on the folder titled "DataFiles".
  3. Unzip the file named zbpyrrefarea.exe ("yr" refers to the year, for example the file for 2002 is named "zbp02refarea.exe").
  4. When the file unzips, you can save it to the location of choice and retrieve it using Excel or some other software package.

The easiest way to do this is to save the unzipped file to your desktop. When you retrieve it using Excel, be sure to choose "comma delimited" for the format. Once the file is opened, the data items will appear in separate columns allowing you to sum the numeric items for as many zip codes as you need.


Was this answer helpful?