Wire Distance Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

not bright - 17 Apr 2006 21:31 GMT

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???

Reply to this Message

ANdras - 17 Apr 2006 21:49 GMT

Hi there,

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

Best regards,
ANdras
(Hungary)

> 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???

Reply to this Message

not bright - 17 Apr 2006 22:59 GMT

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)

> Hi there,
>
[quoted text clipped - 10 lines]
> > last one. I just don't know how to get the distance back to the source.
> > Am I being to vauge???

Reply to this Message

paul - 18 Apr 2006 10:32 GMT

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

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

> What I have so far is
>
[quoted text clipped - 31 lines]
> > > last one. I just don't know how to get the distance back to the source.
> > > Am I being to vauge???

Reply to this Message

not bright - 18 Apr 2006 18:49 GMT

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

> 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
[quoted text clipped - 37 lines]
> > > > last one. I just don't know how to get the distance back to the source.
> > > > Am I being to vauge???

Reply to this Message