I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&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)

"not bright" wrote:

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&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???

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)

"ANdras" wrote:

Hi there,

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

Best regards,
ANdras
(Hungary)

"not bright" wrote:

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&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???

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!



"not bright" wrote:

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)

"ANdras" wrote:

Hi there,

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

Best regards,
ANdras
(Hungary)

"not bright" wrote:

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&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???

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 it


"paul" wrote:

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!



"not bright" wrote:

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)

"ANdras" wrote:

Hi there,

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

Best regards,
ANdras
(Hungary)

"not bright" wrote:

I am trying to produce a wire length calulation sheet for work. The sheet so
far has 25 rows, column A&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???