Add buildings to an existing location 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. Stop when you reach the Loc ID column.
  3. Switch to the worksheet tab named unpopulated entity.CPLocation. This worksheet contains a row for each location that has no buildings.
  4. Locate the row representing the location to which you want to add the building. Select the individual cells that contain all of the location data and copy them to the clipboard.

    Because the worksheets are protected, you cannot copy and paste entire rows. Therefore, you must select and copy only the needed set of individual cells.

  5. Switch back to the Commercial Property Buildings worksheet tab and select the Loc ID cell of the building you are adding.
  6. Paste the clipboard contents to fill in the remaining cells with the exact data that defines the location.
  7. Repeat these steps for additional buildings.

    To add multiple buildings to the same location, paste the same set of location data to as many rows as needed first. Then fill in the remaining building data for each building. If multiple buildings share duplicate values, copy and paste those cells between rows. Remember that you can copy and paste only cell ranges, not entire rows.

  8. Save and import the spreadsheet.