Laser Cutting / Welding Automatic Run Calculations
This is a macro to auto-calculate the run time of laser cutting and welding operations. For laser cutting operations the calculation takes into consideration the material thickness, number of pierces, number of inches cut, and a material multiplier cross referencing a custom table that provides some standard values based on material thickness. For welding operations the calculation takes into consideration the material type, type of welding, material thickness, and inches of welding cross referencing a custom table that provides some standard values based on the material, weld type, and thickness.
Description
Laser Cutting
The macro will watch for newly created operations where the resource ID is "LASER" and perform the following action:
- It will gather (and validate) that you have provided values in the following fields:
- USER_1: Material Thickness
- USER_2: Number of Pierces
- USER_3: Inches of Cut
- USER_4: Material Multiplier
- We will next gather the following values from a custom table using a lookup based on the material thickness (this custom table will be described later on):
- Part Pierce Time
- Part Cut Time
- At this point the run time will be calculated like so:
- Total Piercing Time = Number of Pieces * Part Pierce Time
- Total Cutting Time = (Inches of Cut / Part Cut Time) * 60
- Run = 3600 / ((Total Pierce Time + Total Cutting Time) * Material Multiplier)
- Run Type = PCS/HR
Welding
The macro will watch for newly created operations where the resource ID is "WELD" and perform the following action:
- It will gather (and validate) that you have provided values in the following fields:
- USER_1: Material
- USER_2: Type of Welding
- USER_3: Inches of Thickness
- USER_4: Inches of Weld
- We will next gather the following values from a custom table using a lookup based on the material, type of welding, and inches of thickness (this custom table will be described later on):
- Part Start Time
- Part Weld Time
- At this point the run time will be calculated like so:
- Total Weld Time = (12 / Part Weld Time)
- Run = Part Start Time + Total Weld Time
- Run Type = PCS/HR