Sheet-metal help

Bend allowance table: CSV format and dimensions

A table stores measured bend allowances for a material/tool combination, indexed by thickness, inside bend radius and bend angle. It replaces the K-factor calculation for the applicable conditions.

The orange bend band develops into BA. Total length equals the two straight tangent lengths plus BA.

L1 and L2 are straight lengths measured from the bend tangencies, not outside dimensions measured to the virtual sharp corner. Allowance is BA: the developed length of the bend band.

1. CSV format

Use these six headers in this order:

Material,Tool,Thickness,Radius,Angle,Allowance
DEMO,DEMO,1,1,45,1.099557
DEMO,DEMO,1,1,90,2.199115
DEMO,DEMO,1,1,135,3.298672

Save the sample CSV

Calculated example only: thickness 1 mm, inside radius 1 mm, K=0.4. These are not measured manufacturing values. Replace them with measurements for your material and tooling.

ColumnMeaning
MaterialMaterial identifier; same on every row in the file.
ToolTool/process identifier; same on every row.
ThicknessPositive thickness, mm.
RadiusPositive inside bend radius, mm.
AngleBend rotation from flat, degrees; greater than 0 and at most 180.
AllowancePositive developed bend length BA, mm.

In Excel, fill columns A–F and save as CSV UTF-8 (comma delimited). Use decimal points and numeric values without unit suffixes. One file contains one material/tool combination. Names identify the loaded table; they do not automatically select other tables.

Angle is the rotation from flat, not the included opening angle. An included opening of 135° means Angle=45°. An opening of 45° means Angle=135°. Use positive table angles for either bend direction.

2. Bend allowance versus bend deduction

If your shop's value is subtracted from the sum of outside dimensions, it is bend deduction BD and must be converted before entering Allowance.

At 90°: flat length = outside A + outside B − BD
BA = 2 × (R + t) − BD

For t=1, R=1 and BD=1.800885 mm, enter BA=2.199115 mm. Outside dimensions A=20 and B=30 give a flat length of 48.199115 mm. These outside dimensions extend to the virtual sharp corner.

For bend rotation θ in degrees, BA = 2 × (R+t) × tan(θ/2) − BD applies for 0<θ<180°. Do not use this conversion for a 180° hem or for deductions based on other dimension references.

The K-factor relation is BA = θ × π / 180 × (R + K × t). An active table takes precedence.

3. Import and scope

  1. Open Sheet metal → Bend allowance table.
  2. Select the scope. New-part defaults apply to future sheet-metal parts in this document. They do not update all existing parts. Selected part requires one solid picked in CAD.
  3. Choose Import CSV, then Apply. The file picker opens when Apply is pressed.
  4. Check the completion message. Use Remove table and Apply to return the chosen scope to its configured K-factor.

Applying a table to an existing part retains its actual developed blank outline and changes the bend-band boundaries. It does not hold finished outside dimensions fixed while changing the blank size.

Refold partial developments before applying a table. Rolled parts use K-factor and do not accept this press-bend table.

4. Coverage and interpolation