Calculation Of Pipe Length

CDNWolf

Board Regular
Joined
Nov 14, 2010
Messages
71
Office Version
  1. 365
Platform
  1. Windows
I am looking to calculate the overall pipe length required for manufacturing...

For example, the known data is a Pipe (50mm diameter), a bend with a Radius of 600mm and an ANGLE of 45 degrees.

The Data is laid out as;

Pipe Size 50, Degree 45, Radius 600, Cut Length ???


The sample calculation I have is;

(Radius*Pi)/180*Angle+(Diameter*2)
(600*3.1459)/180*45+(50*2)
=572

However this is not the correct length required for this pipe work...

If possible I'd like another calculation to calculate the RADIUS if the length is already known...

Any help would be appreciated :)
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
If possible I'd like another calculation to calculate the RADIUS if the length is already known...
Which radius... to the inside of the pipe, to the outside of the pipe or to the centerline of the pipe? Also, where is the length of the curved pipe measured... along the inside of the pipe, along the outside of the pipe or along the centerline of the pipe?
 
Last edited:
Upvote 0
Thanks for your reply Rick, much appreciated

The pipe (conduit) is in lengths and needs to be cut before bending into the required size.

If it is cut short it will not meet the requirement of the drawing.

At them moment it is a bit of guess work which is not good.

I would make the assumption that the radius is to the inside of the curve and I presume that we need to calculate to the centre line for an accurate result... (Half the diameter?)

The second calculation would be backwards compatible to give us the Radius if required.

I hope this helps. Any thoughts on the original calculation?
 
Upvote 0
If possible I'd like another calculation to calculate the RADIUS if the length is already known...
If we set up the ratio...
Code:
 Angle          L
-------- = -------------
  360       2 * Pi * R
Then solving for R yields...

R = (180 * L) / (Angle * Pi)

The correct answer, as we discussed earlier, will depend on where the curved length assumed to be after the pipe is bent. I would think it should be at the inside of the curve because, I assume, that when bent, the outer side of the pipe stretches while the inner side maintains the pipes original length (assuming anything else would mean the inner side of the pipe compresses and I don't think metal or plastic does that).
 
Last edited:
Upvote 0
Hi Rick, I'm trying to solve for Length. I have Diameter, Degrees and Radius.
 
Upvote 0
Hi Rick, I'm trying to solve for Length. I have Diameter, Degrees and Radius.
Sorry, I was responding to this question which you asked in Message #1 ... "If possible I'd like another calculation to calculate the RADIUS if the length is already known..."

Solving the relationship I posted in Message #4 and solving for L and replace 2*R with D (the diameter) yields...

L = D * Pi * Angle / 180

Where Angle (both here and in my prior posting) is measured in degrees.
 
Last edited:
Upvote 0
Hi Rick,

Thanks again for responding to my post.

I have been pondering this equation for some time now and I have a simple idea...

If the angle is 45 degrees then there would be 8 segments in a complete circle (360 degrees divided by 45 = 8)

So why can't we simply use the circumference formula of C=Pi*D

Based on the known data being Pipe 50mm DIA, 45 Degrees and 600mm Radius wouldn't the formula be ;

Length = (Pi*Diameter) /(360 Degree Circle / 45 Degree Bend)
Length = 3.14159*(600x2+50)/8
Length = 490.87mm (Based on using the centre line of the circumference)

Does this make any sense to you?
 
Upvote 0
Based on the known data being Pipe 50mm DIA, 45 Degrees and 600mm Radius wouldn't the formula be ;

Length = (Pi*Diameter) /(360 Degree Circle / 45 Degree Bend)
Length = 3.14159*(600x2+50)/8
Length = 490.87mm (Based on using the centre line of the circumference)
Two questions...

1) Are your bends always in increments of 45 degrees?

2) When you bend a pipe that is L mm long, what remains L mm long after the bend? My guess from what you posted is the inner edge of the curved pipe (as opposed to the centerline or outer edge of the curved pipe)... is that correct?
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,286
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top