Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Curve Graphing
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Curve Graphing
Make that: The trick is going to be change the chart size so that the
amplitude (peak-to-trough) is R inches ( not R/2) -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bernard Liengme" wrote in message ... 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 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Curve Graphing
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphing | New Users to Excel | |||
Graphing | Excel Discussion (Misc queries) | |||
Graphing | Charts and Charting in Excel | |||
graphing | Excel Discussion (Misc queries) | |||
curve fitting a charging capacitor type curve | Excel Discussion (Misc queries) |