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 |
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 |
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 |
Curve Graphing
|
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com