Add buildings to new locations in the spreadsheet

Procedure

  1. In the spreadsheet editor, set the Action column to Add.
  2. Leave the Bldg ID column blank, then fill in the other building data columns as needed, until you reach the Loc ID column.
  3. Leave the Loc ID column blank to create a new location for the building.
  4. Fill in the remaining location data columns as needed. Note that to successfully import the location, you must supply a territory code in the Terr Code column that is valid for the specified location. The spreadsheet does not provide a list of territory codes.
  5. Repeat this steps to add more buildings, each at a new location. Upon import, PolicyCenter creates a new location each time it imports a building that has a blank Loc ID field.
  6. Import the spreadsheet.