| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
I am trying to achieve a Formula to calculate a length that reduces each
time by 2 x a cell value. EG. Starting with a piece of string that is run out 20mtrs between point A & Point B. The string is wrapped around a 250mm round pipe at the ends. Then each time another wrap is placed on top of the previous the round pipe is used, but is placed just short of the previous layer. (IE. Each layer would be 2 x 250mm shorter) I start with values like: A1= OVERALL STRING LENGTH ON ROLL A1=250m B1= MAXIMUM STARTING DISTANCE POINT A IS FROM POINT B B1=20m C1= DIAMETER OF THE PIPE TO BE USED C1=250mm D1= THICKNESS OF THE STRING D1=1.7mm So if i pulled out a length of string from point A to a distance of 20m, and wrapped it around a 250mm pipe(point B) and back, i would have 20m + 1/2 circumrfence of the pipe of string run out, Correct ? If i then placed another 250mm pipe at Point B and ran the string out to ALMOST the Point A pipe and placed another 250mm Pipe just short of the 1st one, i would have ALMOST double the length. But would be short by 2 x 250mm diameters as each Pipe is placed inside the previous, NOT ABOVE it. Is there a formula i can use to give me the TOTAL length of String for ANY Given A1 and B1 values, with considerations of the values in C1 and D1? The TOTAL number of times(or wraps) would be required until the A1 value is run out(taking into consideration the shortening length each wrap)? The total HEIGHT of the over all Top wrap, which would include the Diameter of the Top Pipe + the String thickness x the Number of layers underneath? Corey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Looks like homework to me. What is the practical application of knowing
this! Regards, Howard "Corey ...." wrote in message ... I am trying to achieve a Formula to calculate a length that reduces each time by 2 x a cell value. EG. Starting with a piece of string that is run out 20mtrs between point A & Point B. The string is wrapped around a 250mm round pipe at the ends. Then each time another wrap is placed on top of the previous the round pipe is used, but is placed just short of the previous layer. (IE. Each layer would be 2 x 250mm shorter) I start with values like: A1= OVERALL STRING LENGTH ON ROLL A1=250m B1= MAXIMUM STARTING DISTANCE POINT A IS FROM POINT B B1=20m C1= DIAMETER OF THE PIPE TO BE USED C1=250mm D1= THICKNESS OF THE STRING D1=1.7mm So if i pulled out a length of string from point A to a distance of 20m, and wrapped it around a 250mm pipe(point B) and back, i would have 20m + 1/2 circumrfence of the pipe of string run out, Correct ? If i then placed another 250mm pipe at Point B and ran the string out to ALMOST the Point A pipe and placed another 250mm Pipe just short of the 1st one, i would have ALMOST double the length. But would be short by 2 x 250mm diameters as each Pipe is placed inside the previous, NOT ABOVE it. Is there a formula i can use to give me the TOTAL length of String for ANY Given A1 and B1 values, with considerations of the values in C1 and D1? The TOTAL number of times(or wraps) would be required until the A1 value is run out(taking into consideration the shortening length each wrap)? The total HEIGHT of the over all Top wrap, which would include the Diameter of the Top Pipe + the String thickness x the Number of layers underneath? Corey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Calulating the Height of a stack and the Minimum length between the 2
points. "L. Howard Kittle" wrote in message ... Looks like homework to me. What is the practical application of knowing this! Regards, Howard "Corey ...." wrote in message ... I am trying to achieve a Formula to calculate a length that reduces each time by 2 x a cell value. EG. Starting with a piece of string that is run out 20mtrs between point A & Point B. The string is wrapped around a 250mm round pipe at the ends. Then each time another wrap is placed on top of the previous the round pipe is used, but is placed just short of the previous layer. (IE. Each layer would be 2 x 250mm shorter) I start with values like: A1= OVERALL STRING LENGTH ON ROLL A1=250m B1= MAXIMUM STARTING DISTANCE POINT A IS FROM POINT B B1=20m C1= DIAMETER OF THE PIPE TO BE USED C1=250mm D1= THICKNESS OF THE STRING D1=1.7mm So if i pulled out a length of string from point A to a distance of 20m, and wrapped it around a 250mm pipe(point B) and back, i would have 20m + 1/2 circumrfence of the pipe of string run out, Correct ? If i then placed another 250mm pipe at Point B and ran the string out to ALMOST the Point A pipe and placed another 250mm Pipe just short of the 1st one, i would have ALMOST double the length. But would be short by 2 x 250mm diameters as each Pipe is placed inside the previous, NOT ABOVE it. Is there a formula i can use to give me the TOTAL length of String for ANY Given A1 and B1 values, with considerations of the values in C1 and D1? The TOTAL number of times(or wraps) would be required until the A1 value is run out(taking into consideration the shortening length each wrap)? The total HEIGHT of the over all Top wrap, which would include the Diameter of the Top Pipe + the String thickness x the Number of layers underneath? Corey.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Mama don't do HOMEWORK
"Corey ...." wrote: Calulating the Height of a stack and the Minimum length between the 2 points. "L. Howard Kittle" wrote in message ... Looks like homework to me. What is the practical application of knowing this! Regards, Howard "Corey ...." wrote in message ... I am trying to achieve a Formula to calculate a length that reduces each time by 2 x a cell value. EG. Starting with a piece of string that is run out 20mtrs between point A & Point B. The string is wrapped around a 250mm round pipe at the ends. Then each time another wrap is placed on top of the previous the round pipe is used, but is placed just short of the previous layer. (IE. Each layer would be 2 x 250mm shorter) I start with values like: A1= OVERALL STRING LENGTH ON ROLL A1=250m B1= MAXIMUM STARTING DISTANCE POINT A IS FROM POINT B B1=20m C1= DIAMETER OF THE PIPE TO BE USED C1=250mm D1= THICKNESS OF THE STRING D1=1.7mm So if i pulled out a length of string from point A to a distance of 20m, and wrapped it around a 250mm pipe(point B) and back, i would have 20m + 1/2 circumrfence of the pipe of string run out, Correct ? If i then placed another 250mm pipe at Point B and ran the string out to ALMOST the Point A pipe and placed another 250mm Pipe just short of the 1st one, i would have ALMOST double the length. But would be short by 2 x 250mm diameters as each Pipe is placed inside the previous, NOT ABOVE it. Is there a formula i can use to give me the TOTAL length of String for ANY Given A1 and B1 values, with considerations of the values in C1 and D1? The TOTAL number of times(or wraps) would be required until the A1 value is run out(taking into consideration the shortening length each wrap)? The total HEIGHT of the over all Top wrap, which would include the Diameter of the Top Pipe + the String thickness x the Number of layers underneath? Corey.... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Why wont a "gummy mummy" help with HOMEWORK?
"Teethless mama" wrote: Mama don't do HOMEWORK "Corey ...." wrote: Calulating the Height of a stack and the Minimum length between the 2 points. "L. Howard Kittle" wrote in message ... Looks like homework to me. What is the practical application of knowing this! Regards, Howard "Corey ...." wrote in message ... I am trying to achieve a Formula to calculate a length that reduces each time by 2 x a cell value. EG. Starting with a piece of string that is run out 20mtrs between point A & Point B. The string is wrapped around a 250mm round pipe at the ends. Then each time another wrap is placed on top of the previous the round pipe is used, but is placed just short of the previous layer. (IE. Each layer would be 2 x 250mm shorter) I start with values like: A1= OVERALL STRING LENGTH ON ROLL A1=250m B1= MAXIMUM STARTING DISTANCE POINT A IS FROM POINT B B1=20m C1= DIAMETER OF THE PIPE TO BE USED C1=250mm D1= THICKNESS OF THE STRING D1=1.7mm So if i pulled out a length of string from point A to a distance of 20m, and wrapped it around a 250mm pipe(point B) and back, i would have 20m + 1/2 circumrfence of the pipe of string run out, Correct ? If i then placed another 250mm pipe at Point B and ran the string out to ALMOST the Point A pipe and placed another 250mm Pipe just short of the 1st one, i would have ALMOST double the length. But would be short by 2 x 250mm diameters as each Pipe is placed inside the previous, NOT ABOVE it. Is there a formula i can use to give me the TOTAL length of String for ANY Given A1 and B1 values, with considerations of the values in C1 and D1? The TOTAL number of times(or wraps) would be required until the A1 value is run out(taking into consideration the shortening length each wrap)? The total HEIGHT of the over all Top wrap, which would include the Diameter of the Top Pipe + the String thickness x the Number of layers underneath? Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
