Thread: Curve Graphing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Curve Graphing

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!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bruce" wrote in message
...
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