# Steel Plate Cut List Weight Worksheet (Excel Export) > Source: https://netray.co/tools/steel-plate-cut-list-weight-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Fill a cut list row by row and get piece weight, line weight and total order weight for plate, sheet and flat parts. ## Category manufacturing ## Industry Fabrication ## Audience - Estimator - Buyer - Fabrication planner ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Part mark **Key:** mark **Type:** text #### Material **Key:** material **Type:** text #### Qty **Key:** qty **Type:** number #### Length **Key:** len **Type:** number **Unit:** mm #### Width **Key:** wid **Type:** number **Unit:** mm #### Thickness **Key:** thk **Type:** number **Unit:** mm #### Density **Key:** dens **Type:** number **Unit:** kg/m3 **Help:** Steel about 7850, aluminum about 2700, stainless 304 about 8000 #### Weight each **Key:** each **Type:** number **Unit:** kg **Expr:** len * wid * thk * dens / 1000000000 **Format:** decimal #### Line weight **Key:** line **Type:** number **Unit:** kg **Expr:** qty * len * wid * thk * dens / 1000000000 **Format:** decimal **Rows:** **Mark:** BP-01 **Material:** S355 plate **Qty:** 4 **Len:** 600 **Wid:** 400 **Thk:** 20 **Dens:** 7850 **Mark:** GU-02 **Material:** S275 plate **Qty:** 12 **Len:** 250 **Wid:** 120 **Thk:** 10 **Dens:** 7850 **Mark:** CV-03 **Material:** 5083 aluminum **Qty:** 6 **Len:** 800 **Wid:** 500 **Thk:** 8 **Dens:** 2660 **Mark:** SH-04 **Material:** 304 stainless **Qty:** 10 **Len:** 300 **Wid:** 300 **Thk:** 3 **Dens:** 8000 **Mark:** RB-05 **Material:** S355 plate **Qty:** 2 **Len:** 1500 **Wid:** 250 **Thk:** 25 **Dens:** 7850 **Totals:** #### Total pieces **Key:** qty **Agg:** sum **Format:** integer #### Total weight (kg) **Key:** line **Agg:** sum **Format:** decimal **Summary:** #### Total weight in tonnes **Key:** tonnes **Expr:** sum_line / 1000 **Format:** decimal #### Average piece weight (kg) **Key:** avg_piece **Expr:** sum_line / sum_qty **Format:** decimal **Primary:** true **Notes:** Weights are theoretical, based on nominal size and the density you enter. Mill tolerance on plate thickness, kerf and edge trim are not included. ## Content **Intro:** A cut list with weights is the starting point for a steel order, a freight quote and a lifting plan. This worksheet keeps the arithmetic out of your head: enter size and density once per row and the weights follow. **Sections:** #### How to use the cut list **Body:** Enter one row per part mark. Give quantity, length, width and thickness in millimetres, and the density of the alloy in kg per cubic metre. The sheet returns the weight of one piece and the weight of the whole line. Totals and the average piece weight are shown below the table. Use the export button to move the result into Excel for your purchase request or into PDF for a quote file. **Bullets:** - Keep all dimensions in millimetres - Use one row per mark and material - Change the density for each alloy - Add rows for offcuts you plan to keep #### The formula behind the weights **Body:** Weight equals volume times density. With dimensions in millimetres, volume in cubic millimetres divided by one billion gives cubic metres, and multiplying by density in kg per cubic metre gives kilograms. A 600 x 400 x 20 mm plate in steel at 7850 kg/m3 is 4.8 million cubic mm, or 0.0048 cubic metres, which weighs 37.7 kg. The same logic works for any flat part, so you can use it for aluminum, stainless or copper alloys by changing the density. #### Common mistakes and ERP notes **Body:** The most frequent error is mixing units, for example entering thickness in inches against millimetre lengths. The second is using one density for every row on a mixed order. Theoretical weight also differs from mill weight, because plate is rolled to a thickness tolerance and often runs slightly over nominal. When you load parts into an ERP, the net weight field on the item master usually expects the finished part weight, while the purchase weight is the raw plate weight, so keep both columns in your records. **Bullets:** - Do not forget kerf and trim when ordering whole plates - Check whether freight is quoted on theoretical or scale weight - Record the density source on the drawing or spec **Cta:** If your item master weights drift from what you actually buy, we can build an agent that compares ERP net weights to calculated stock weights and flags gaps. **Faq:** #### What density should I use for carbon steel? **Answer:** Use 7850 kg/m3 for carbon and low alloy structural steel. It is the common handbook value and matches most mill weight tables. Stainless steels are slightly higher, about 7900 to 8000, depending on grade and the reference you follow. #### Is the result the same as the weight on the mill invoice? **Answer:** Not exactly. The sheet gives theoretical weight from nominal size. Mills invoice on scale weight, which is usually a little higher because plate is rolled within a thickness tolerance. Expect a small difference and agree the basis with your supplier. #### Can I use inches? **Answer:** Convert to millimetres first, multiplying inches by 25.4. The formula and the density unit assume millimetres and kg per cubic metre. Mixing units in the same row gives wrong weights without any warning. #### Does it account for holes and cutouts? **Answer:** No. It treats each part as a full rectangle. For parts with large cutouts, reduce the dimensions to an equivalent size or subtract the cutout volume by adding a separate negative-quantity row for your own records. ## Search terms plate weight cut list excel, steel cut list template, sheet metal weight worksheet, plate weight calculation spreadsheet, fabrication cut list with weights, steel order weight sheet, aluminum plate cut list weight, material takeoff weight sheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json