Edit externally stored bend table using Excel

Use a bend table file that has your units of measure and tolerances to create a bend table for each material thickness.

  1. Browse to the bend table *.xls file, and double-click to open.
  2. Scroll to the line that starts with /S and enter the sheet thickness.
  3. Scroll to the line that starts with /R and enter bend radii.
  4. Edit the value of specific bend deductions, as required.
    Note: A conditional equation determines the bend deduction values provided in the sample spreadsheets. A bend table that is populated with empirical values determined by measuring sample pieces produced on a specific piece of equipment is more valuable.
  5. Highlight the table and then press Ctrl+C to copy. Scroll down to an empty area of the spreadsheet and then press Ctrl+V to paste.
  6. Rename the table and reset the material thickness.
  7. Continue to copy and paste the table, renaming it and setting a new material thickness, as necessary.
  8. Select FileSave As, select .txt file type, and then click OK.
Note: Save the spreadsheet in a text (*.txt) file format because the analyzer uses the text format to calculate bends.