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.
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
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.
| Column | Meaning |
|---|---|
| Material | Material identifier; same on every row in the file. |
| Tool | Tool/process identifier; same on every row. |
| Thickness | Positive thickness, mm. |
| Radius | Positive inside bend radius, mm. |
| Angle | Bend rotation from flat, degrees; greater than 0 and at most 180. |
| Allowance | Positive 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.
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
- Open Sheet metal → Bend allowance table.
- 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.
- Choose Import CSV, then Apply. The file picker opens when Apply is pressed.
- 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
- Thickness must match; there is no interpolation between thicknesses.
- Radius and angle interpolate only within the registered range. The sample covers R=1 and angles 45°–135°, not R=2 or Angle=30°.
- Interpolating both radius and angle requires all four surrounding combinations.
- Duplicate thickness/radius/angle combinations are invalid. Out-of-range requests and missing interpolation corners fail when used.
- The accepted allowance range is
θ×π/180×R ≤ BA ≤ θ×π/180×(R+t), equivalent to K between 0 and 1. Check the dimension definitions if measurements fall outside it.