Metric Piping Weight Calculation Spreadsheet WorkbookThis Workbook provides a tool that is intended to provide a quick, easy and accurate method for the piping designer to use when calculating piping system weights. The workbook can be used to calculate the weight of the pipe, flanges, fittings, insulation and hydrotest water for a single size or for multi-size configurations.
Notes for use:
- At the bottom of the screen select (and click on) the tab for the size required for the line or system. Do the largest size first then the next size until finished with that line or system
- On the correct size sheet, enter quantities in the (Yellow) quantity column. Lineal meters for Pipe and Insulation. Enter actual count for fittings, flanges and valves.
- For Hydrotest water add the lineal meters of the pipe plus add in a factor for the fittings and valves.
- At the bottom of each page there is a note "ADDITIONAL WEIGHT ITEM". This is the place to add in the weight of items such as Weld-O-Lets or any other previously unlisted items. For record purposes, define the item in the (Yellow) space allowed. The data from all pages will be automatically posted to the summary table at the bottom of this page.
- For record purposes a project number, system or line description, originator and date may be entered at the top of each size sheet used. The same data may also be entered on this sheet.
- Do not try to enter data in any other spaces. This Workbook is password protected.
- For a piping load where the concentrated load is off center between two support points the higher individual load may be given. Example: where the center of the total calculated load is 85% closer to support point # 1 than #2 then input the decimal (.85) into the "Yellow" box at the bottom of this page. The calculated load for Pipe Support #1 will be given.
- After all required data has been entered on a size page a copy should be ran for record purposes when required.
- When all weight work data for a system or individual line is complete and record copies have been run, close the file but do not "save" the changes. All previous data will be erased. You may then open the file again for another line or system.