Macro to calculate the raw material required for sheet metal component.

[sagarverma032-cpu]

Maximum X and Y coordinate of components in assyembly is required to calculate the material required to manufacture the sheet metal parts.
For planning and costing of all the components in assembly the requirements are:

1. X and Y coordinate of parts that enclose maximum of parameter in rectangular shape as component will be made from a sheet.(irrespective of the origin).
2. The Thickness of material.
3. Material type specified in the tree.
4. Export them to a excel file with headings S.no, Part name and Part no., Material, Material thickness ,X, Y.