C
Corey ....
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....
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....