Gather and Extract Dimensional Data

Any referenced datasets can be downloaded from "Module downloads" in the module overview.

Task 1: Download the dimensional pdf from the manufacturer’s website

If searching the manufacturer’s website does not result in finding the dimensional data, you need. Then do an internet search that will get you better results.

Task 2: Download a price list from the manufacturer’s website

Again, sometimes finding a price list is doing an internet search.

Task 3: Export and clean up the data

Using Bluebeam, Adobe Acrobat or an online program, export the dimensional table into a spreadsheet.

  1. In Excel, select all cells and unmerge the merged cells.
  2. Delete the metric rows by selecting just one cell on each line and under Cells dropdown select Delete Sheet Rows.
  3. Use Ctrl+H to clean up the data any further.