6 replies to this topic

[samayaraj]

Dear all,

 

In many of our excel calculations, we use pipe size, schedule and material as an input. I have prepared an excel sheet where I applied some logic to bring you the pipe size & sch. data (For ASME B 36.10/ B 36.19 from size 15NB to 600NB). Using the drop down list, we can select size & Sch. No. and an option button for selecting pipe material.

 

This excel can be used in any of your excel where you need pipe size & matl. data. In some of my previous excels, I've used this excel to select pipe size and matl.

 

Refer the topic "Gravity flow line sizing calculation" in this forum, where I used this consolidated pipe data in my excel calculation.

 

This excel is just protected and there is no password I used.

 

Include this in your excel and reduce the load of searching the pipe data for you calculation!!!

 

Comments are welcome.

 

 

Regards,

Samayaraj

Attached Files

•  9. Pipe Schedule Data.xlsx   34.74KB   241 downloads

[Said Salim]

Hi

Samayraj

It is very useful file

Thanx alot

[shawkat06]

Dear Samayraj,

 

Thanks alot it is very useful...

[Bobby Strain]

So, who knows if the data is correct?

 

Bobby

[samayaraj]

@ Mr. Bobby

 

I took these data from a soft copy of ASME B 36.10/ B 36.19, where I used to take pipe data.

 

I want to make it easy to use the same. So, I prepared this excel. I have cross verified many times and then I posed in this forum.

 

 

Regards,

Samayaraj

[mavilla10]

samarayaj, thanks for share your work, is very usefull.

[Manikandan Dakshinamoorthy]

thanks sam..gud work.. its really useful..