Using Excel to calculate scrap
In this video, I walk through how to use Excel to calculate sheet metal scrap area after parts have been nested on a large sheet. I start by setting up columns for sheet area, part area, quantity, and total area for three different parts. I then demonstrate how to input the part areas (which I got from AutoCAD) and set up the multiplication formula to get the total area required for each part quantity. Crucially, I show the final formula to calculate scrap by subtracting the total area of all parts from the initial sheet area. This helps us quickly see how changing the quantity of each part affects the remaining scrap, which is essential for optimizing material usage in sheet metal fabrication.
Video Chapters
[00:00] Setting up the Excel Sheet and Labels
[01:37] Entering Sheet Area and Part Areas
[01:55] Setting up the Quantity and Total Area Columns
[02:08] Creating the Formula for Total Part Area
[02:26] Calculating the Total Scrap Area
[02:40] Testing the Formula with Required Part Quantities
[03:36] Explaining the Excel Cell References and Formulas
[05:33] Final Thoughts on Using Excel for Calculations