### Author Topic: Calculating UTP cable length for cabling the building  (Read 7623 times)

0 Members and 1 Guest are viewing this topic.

#### Human

• Newbie
• Posts: 5
##### Calculating UTP cable length for cabling the building
« on: October 01, 2015, 06:24:30 AM »
Hello,
I need to calculate how much of UTP cable is needed for cabling one floor of the building.

A long time ago (10 or more years) I used Visio to do this, but now I forget how.
I remember, it was something like this… I created scaled floor plan on one layer, and then on another layer I draw lines which represents utp cables. For each utp cable (wall socket) I draw one (or more) line from server room.

Then, there was a possibility to automatically calculate all line lengths on that layer, or something similar. I don’t remember how exactly.

Anyone have any idea?

With kind regards,
Human

#### Surrogate

• Hero Member
• Posts: 1015
##### Re: Calculating UTP cable length for cabling the building
« Reply #1 on: October 01, 2015, 06:45:48 AM »
in visio 2010 you can get length of line via shapesheet™ - use function PATHLENGTH
how you calculate length about 10 years before i don't know.  may be you use macros ?
« Last Edit: October 01, 2015, 06:52:26 AM by Surrogate »

#### Human

• Newbie
• Posts: 5
##### Re: Calculating UTP cable length for cabling the building
« Reply #2 on: October 01, 2015, 07:34:23 AM »
in visio 2010 you can get length of line via shapesheet™ - use function PATHLENGTH
how you calculate length about 10 years before i don't know.  may be you use macros ?

Verticals are not important because I need information only for one floor in the building. Server room is on that floor also, and all offices too.
There is maybe 20-30 rooms (offices) and they will need 4 connections per room. So I need only horizontal cabling.
I don’t remember I used macros before. What I used was layers, floor plan shapes, “spacers” and lines. And scaled metrics. Then I’ve put all lines to one separate layer, and somehow get total line lengths on that layer. But, unfortunately, I don’t remember how…
But for sure I was not using any code, any macro. I remember it was simply to get that, but I don’t remember how...

Human

#### Human

• Newbie
• Posts: 5
##### Re: Calculating UTP cable length for cabling the building
« Reply #3 on: October 01, 2015, 07:39:31 AM »
For example, AutoCAD have something what is called "Total length of lines per layer".

And I know for sure that I used Visio to calculate something like this. But not with any code. It was only important to put all lines to one layer. And I used "spacers" to get squared meters of office, but I'm not sure if that "spacers" was related to get line lengths. I don't remember.
I'm getting old..

#### Surrogate

• Hero Member
• Posts: 1015
##### Re: Calculating UTP cable length for cabling the building
« Reply #4 on: October 01, 2015, 07:56:47 AM »
In AutoCAD you can use data extraction method. It can export to Excel lengths or something properties of lines/polylines in layer.

MS Visio have same function Shape Reports, but there impossible get length of line.
« Last Edit: October 01, 2015, 07:59:25 AM by Surrogate »

#### Surrogate

• Hero Member
• Posts: 1015
##### Re: Calculating UTP cable length for cabling the building
« Reply #5 on: October 01, 2015, 08:10:01 AM »
How you draw path from server room to wall socket:
1. As one polygonal line
2. A lot of segments
If as segments you can use Shape Reports feature
Just get width instead length !
« Last Edit: October 01, 2015, 08:12:07 AM by Surrogate »

#### Human

• Newbie
• Posts: 5
##### Re: Calculating UTP cable length for cabling the building
« Reply #6 on: October 01, 2015, 11:30:41 AM »
How you draw path from server room to wall socket:
1. As one polygonal line
2. A lot of segments
If as segments you can use Shape Reports feature
Just get width instead length !
I don't remember if I used Shape Reports before, but I think it will help. I will draw a lot of segments, a lot of lines, and it can calculate "width" (length) of all lines together. I tryed some tests right now, and I think it will be ok.

Thank you very much for your help!

With kind regards,
Human

#### Human

• Newbie
• Posts: 5
##### Re: Calculating UTP cable length for cabling the building
« Reply #7 on: October 01, 2015, 11:52:57 AM »