Login    Register
User Information
Username:
Password:
We are a free and open
community, all are welcome.
Click here to Register
Sponsored
Who is online

In total there are 58 users online :: 2 registered, 0 hidden and 56 guests


Most users ever online was 155 on Mon Aug 15, 2016 1:40 am

Registered users: Bing [Bot], Yahoo [Bot] based on users active over the past 5 minutes

The Team
Administrators
Global Moderators
global_moderators.png CS

Pipe ID Calculator

A place to ask general spud cannon related questions.
Sponsored 
  • Author
    Message

Pipe ID Calculator

Unread postAuthor: dewey-1 » Thu May 21, 2009 12:49 pm

Several years ago I created this Excel spreadsheet to generate the ID (inside diameter) of different types of pipe.

It started as just PVC pipe but has been added to include others.

If interested just PM me.

It is complete for PVC pipe including wall tolerance and OD tolerance.
It is in Imperial dimensions, in a decimal format.

It seems awkward to use at first, but is easier to use with more practice.

You basically look up the diameter, wall thickness, diameter tolerance, wall tolerance and enter these into the yellow cells.

The output shows worst case conditions and typical conditions.

It has the capability of comparing three sizes at once.

If some one with more software experience than me, might be able to simplify the "input method".

Post any suggestions or improvements after trying it out!
  • 0

User avatar
dewey-1
Major General
Major General
 
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA
Reputation: 0

Unread postAuthor: john bunsenburner » Thu May 21, 2009 2:43 pm

My only suggestion would be to put it into a visual basic format, if you want you can pm me the no.s and formulas and I can try and do that for you.
  • 0

"Did you ever stop to think that out of the seven deadly sins envy is the only one which doesn't give the sinner even momentary pleasure"-George Will
User avatar
john bunsenburner
Major General
Major General
 
Posts: 1446
Joined: Sun Oct 19, 2008 5:13 am
Reputation: 0

Unread postAuthor: dewey-1 » Thu May 21, 2009 3:17 pm

Thanks john;

I sent an Excel 97-03 format to you.

If you need another format, let me know.
  • 0

User avatar
dewey-1
Major General
Major General
 
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA
Reputation: 0

Unread postAuthor: Moonbogg » Thu May 21, 2009 6:35 pm

Well here is what I use. http://www.tubularsteel.com/docs/schedule_ansi_pipe.pdf
What do you mean a program?
  • 0

User avatar
Moonbogg
Major General
Major General
 
Posts: 1375
Joined: Mon Oct 13, 2008 10:20 pm
Location: whittier, CA USA
Reputation: 0

Unread postAuthor: dewey-1 » Thu May 21, 2009 6:49 pm

Moonbogg wrote:Well here is what I use. http://www.tubularsteel.com/docs/schedule_ansi_pipe.pdf
What do you mean a program?


I will send it to you and it will make much more sense than your chart.

Your chart is great except there are no tolerances.

Have to include manufacturing tolerances don't we?
  • 0

User avatar
dewey-1
Major General
Major General
 
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA
Reputation: 0

Return to General Spud Cannon Related

Who is online

Registered users: Bing [Bot], Yahoo [Bot]

Reputation System ©'