software

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column Aamp;B have the corrdinates of the devices. Column C has
the formula to calculate the distance. I figured out how to get the distance
from the source to the first device then to the next until you get to the
last one. I just don't know how to get the distance back to the source.
Am I being to vauge???

Hi there,

what do you have so far? (suspect, accumulative sum of distance?)

Best regards,
ANdras
(Hungary)

quot;not brightquot; wrote:

gt; I am trying to produce a wire length calulation sheet for work. The sheet so
gt; far has 25 rows, column Aamp;B have the corrdinates of the devices. Column C has
gt; the formula to calculate the distance. I figured out how to get the distance
gt; from the source to the first device then to the next until you get to the
gt; last one. I just don't know how to get the distance back to the source.
gt; Am I being to vauge???

What I have so far is

X-Corrd. data Y-Corrd. Data Distance
Calculations
A B
C
1 From Source From Source
2 First Device First Device from Source
to First device
3 next device next device from first
device to next device
4 next device next device from next
device to next device
An so on till the last device ( MAX of 25)
What I need is to get the last entered Corrdinate and calculate the distance
back to the Source . Since the amount of devices change I don't know what I
would do to check if there are any Corrdinates less than 25 devices without
doing a huge IF statement.
the formula I am using in the distance calculation is as follows:
=IF(ISNUMBER(B5),ROUNDUP((((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12)*0.2) ((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12),0),0)

quot;ANdrasquot; wrote:

gt; Hi there,
gt;
gt; what do you have so far? (suspect, accumulative sum of distance?)
gt;
gt; Best regards,
gt; ANdras
gt; (Hungary)
gt;
gt; quot;not brightquot; wrote:
gt;
gt; gt; I am trying to produce a wire length calulation sheet for work. The sheet so
gt; gt; far has 25 rows, column Aamp;B have the corrdinates of the devices. Column C has
gt; gt; the formula to calculate the distance. I figured out how to get the distance
gt; gt; from the source to the first device then to the next until you get to the
gt; gt; last one. I just don't know how to get the distance back to the source.
gt; gt; Am I being to vauge???

wont the sum of all the x co ordinates and the sum of all the y coridinates
give you the final coordinates in relation to the source?I assume if you go
left right of last position you would use or - respectively.If there is no
device there wont be any co ordinates so you can display a zero and it wont
be summed
--
paul

remove nospam for email addy!
quot;not brightquot; wrote:

gt; What I have so far is
gt;
gt; X-Corrd. data Y-Corrd. Data Distance
gt; Calculations
gt; A B
gt; C
gt; 1 From Source From Source
gt; 2 First Device First Device from Source
gt; to First device
gt; 3 next device next device from first
gt; device to next device
gt; 4 next device next device from next
gt; device to next device
gt; An so on till the last device ( MAX of 25)
gt; What I need is to get the last entered Corrdinate and calculate the distance
gt; back to the Source . Since the amount of devices change I don't know what I
gt; would do to check if there are any Corrdinates less than 25 devices without
gt; doing a huge IF statement.
gt; the formula I am using in the distance calculation is as follows:
gt; =IF(ISNUMBER(B5),ROUNDUP((((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12)*0.2) ((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12),0),0)
gt;
gt; quot;ANdrasquot; wrote:
gt;
gt; gt; Hi there,
gt; gt;
gt; gt; what do you have so far? (suspect, accumulative sum of distance?)
gt; gt;
gt; gt; Best regards,
gt; gt; ANdras
gt; gt; (Hungary)
gt; gt;
gt; gt; quot;not brightquot; wrote:
gt; gt;
gt; gt; gt; I am trying to produce a wire length calulation sheet for work. The sheet so
gt; gt; gt; far has 25 rows, column Aamp;B have the corrdinates of the devices. Column C has
gt; gt; gt; the formula to calculate the distance. I figured out how to get the distance
gt; gt; gt; from the source to the first device then to the next until you get to the
gt; gt; gt; last one. I just don't know how to get the distance back to the source.
gt; gt; gt; Am I being to vauge???

Well I have another sheet that takes the numbers in column c and uses it in a
point to point voltage drop calculation. So when it gets to the last distance
it takes that Corrdinates of the first and calculates thethe distance from
the last device back to the source.
I think I'm going to use another column with a IF statement to do the cell
check and just hide itquot;paulquot; wrote:

gt; wont the sum of all the x co ordinates and the sum of all the y coridinates
gt; give you the final coordinates in relation to the source?I assume if you go
gt; left right of last position you would use or - respectively.If there is no
gt; device there wont be any co ordinates so you can display a zero and it wont
gt; be summed
gt; --
gt; paul
gt;
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;not brightquot; wrote:
gt;
gt; gt; What I have so far is
gt; gt;
gt; gt; X-Corrd. data Y-Corrd. Data Distance
gt; gt; Calculations
gt; gt; A B
gt; gt; C
gt; gt; 1 From Source From Source
gt; gt; 2 First Device First Device from Source
gt; gt; to First device
gt; gt; 3 next device next device from first
gt; gt; device to next device
gt; gt; 4 next device next device from next
gt; gt; device to next device
gt; gt; An so on till the last device ( MAX of 25)
gt; gt; What I need is to get the last entered Corrdinate and calculate the distance
gt; gt; back to the Source . Since the amount of devices change I don't know what I
gt; gt; would do to check if there are any Corrdinates less than 25 devices without
gt; gt; doing a huge IF statement.
gt; gt; the formula I am using in the distance calculation is as follows:
gt; gt; =IF(ISNUMBER(B5),ROUNDUP((((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12)*0.2) ((SQRT(((B4-B5)^2) ((C4-C5)^2)))/12),0),0)
gt; gt;
gt; gt; quot;ANdrasquot; wrote:
gt; gt;
gt; gt; gt; Hi there,
gt; gt; gt;
gt; gt; gt; what do you have so far? (suspect, accumulative sum of distance?)
gt; gt; gt;
gt; gt; gt; Best regards,
gt; gt; gt; ANdras
gt; gt; gt; (Hungary)
gt; gt; gt;
gt; gt; gt; quot;not brightquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am trying to produce a wire length calulation sheet for work. The sheet so
gt; gt; gt; gt; far has 25 rows, column Aamp;B have the corrdinates of the devices. Column C has
gt; gt; gt; gt; the formula to calculate the distance. I figured out how to get the distance
gt; gt; gt; gt; from the source to the first device then to the next until you get to the
gt; gt; gt; gt; last one. I just don't know how to get the distance back to the source.
gt; gt; gt; gt; Am I being to vauge???