Curve Graphing

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am an armature fabricator looking for a graphing spreadsheet to assist me
in fitting intersecting pipes. For example if I have two 1†diameter pipes
and I want one to interest the other at a 90 degree angle the end of the
intersecting pipe needs trimmed on the top and bottom to enable a tight fit.
However, my math and Excel skills have failed me and I can not create a
spreadsheet template that permits me to enter the diameter of both pipes as
well as the degree of intersection and then plot a usable curve graph. I am
looking to print the curve on paper and then wrap the paper around the pipe
that needs trimmed so that I can see the material that needs removed. Any
suggestions on where I may find a tool like this?
 
Bruce,
I am fairly confident that you want a sin wave
In C1 enter R/2, so for a 2" pipe enter 1
In A1 0, in A2 = A1+PI()/50; copy down to about A250 (this give you a good
overlap when you wrap the cut-out.
In B1 enter =C1*sin(A1); copy the column
The trick is going to be change the chart size so that the amplitude
(peak-to-trough) is R/2 inches when printed and the period equal half the
circumference ( 0.5*Pi*R) - the distance between the first and the third
peak is such that they overlap when you warp the cut-out around the rod.
I did this with 'hand-waving' not real math!
Have a lot of fun!
 
Make that: The trick is going to be change the chart size so that the
amplitude
 
Back
Top