Purpose :-
This 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 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 (Blue) quantity column. Lineal feet for pipe and insulation. Enter actual count for fittings, flanges and valves.
  • For hydrotest water add the lineal footage of the pipe plus add in a factor for the fittings and valves.
  • At the bottom of each page there is a note "ADDITONAL 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 (Blue) space allowed. The data from this page and all other 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 worksheet 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 "Blue " box at the bottom of this page. The calculated load for pipe support #1 will be given.
  • After all required date 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.
We can Calculate the NSP of Different size of pipes :- 
  • 2'' NSP
  • 3'' NSP
  • 4'' NSP
  • 6'' NSP
  • 8'' NSP
  • 10'' NSP
  • 12'' NSP
  • 14'' NSP
  • 16'' NSP
  • 18'' NSP
  • 20'' NSP
  • 24'' NSP

Download the Worksheet with the below Download Link

Post a Comment