Estimating: Hole punching requirements for rollformed sections

Excel workbook setup in similar style to estimating, and punching sheets used by rollformers. Also contains macros to generate a ACAD LT script in a default location. Highlight the data table for the punching requiremnts, run the Excel macro, then in ACAD LT run the default script ( setup toolbar to run default script).

So far not submitted the Excel version to the rollformers. I started drawing members in ACAD, but used Excel to check string of hole spacing dimensions, and wrote macro to export from Excel. Then decided to  expand the simple data table to reflect the punching forms the rollformers use. Its a bit cumbersome to mark up the sketches in Excel, but ultimately can calculate the required dimensions.

If can find away to do all in Excel then good, otherwise will add further scripting into ACAD.

Estimating hole punching requirements for roll-formed sections involves considering various factors, including the number and size of the holes, the material being punched, the type of punching process, and the desired production speed.

Here's a step-by-step process for estimating hole punching requirements:

1. Determine the roll-formed section dimensions and material:

• Section dimensions (width, height, thickness)
• Material type (steel, aluminum, etc.)

2. Identify the hole pattern:

• Number of holes per section
• Size of holes (diameter or dimensions for non-circular holes)
• Spacing between holes (along the length of the section)

3. Choose the punching method: There are several punching methods, including:

• Turret punch press: This method uses a machine with multiple punching tools that can create various hole sizes and shapes.
• Single-station punch press: This method uses a single punching tool to create one hole size/shape at a time.
• CNC punch press: This method employs computer numerical control to automate the punching process, allowing for high precision and flexibility in hole patterns.

4. Calculate production time: To estimate the production time, consider the following factors:

• Punching speed (number of holes punched per minute)
• Tool change time (if applicable, for turret or CNC punch press)
• Material handling time (loading and unloading of roll-formed sections)

5. Estimate labor costs: Consider the labor costs associated with operating the punching equipment and handling the roll-formed sections.

6. Estimate tooling costs: The cost of punching tools (dies and punches) should be considered, especially if custom tools are required for specific hole sizes or shapes.

7. Calculate material waste: Some material waste may occur during the punching process due to scrap or offcuts. Consider this waste when estimating the overall material requirements for the project.

By taking into account these factors, you can estimate the hole punching requirements for roll-formed sections. This information can help you plan and budget for the punching process and ensure that the required hole patterns are achieved efficiently and cost-effectively.