Pipe ID Calculator

A place for general potato gun questions and discussions.
User avatar
dewey-1
Sergeant 3
Sergeant 3
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA

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!
User avatar
john bunsenburner
Sergeant 5
Sergeant 5
Posts: 1446
Joined: Sun Oct 19, 2008 5:13 am

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.
"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
dewey-1
Sergeant 3
Sergeant 3
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA

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.
User avatar
Moonbogg
Staff Sergeant 3
Staff Sergeant 3
United States of America
Posts: 1737
Joined: Mon Oct 13, 2008 10:20 pm
Location: SoCal
Has thanked: 166 times
Been thanked: 102 times

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?
User avatar
dewey-1
Sergeant 3
Sergeant 3
Posts: 1298
Joined: Wed Mar 28, 2007 10:24 am
Location: NE Wisconsin USA

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?
Post Reply