vectors end to end to make network diagram

**simonsmith** · 03-03-2010, 01:54 AM

Hi All,
I have a list of 100 or more microwave radio links. These links collectively make a network.
Currently the practice is for people to update an excel list when links are planned, installed or deleted, they then manually add lines to a network drawing. This leads to errors - when the network drawing is not updated or incorrectly updated

The network has a start point and many hubs and daisy chains and end points.

Please see also attachments for better understanding
microwave network maps illustrates an example

The Vector zip from ozgrid shows how endToend vectors can be used which is sort of what I need.

Any ideas to point down the straight and narrow much appreciated

Cheers

Simon

ps
I have heard that excel can be used to drive vectors onto Google Earth using Lats and Longs; this would be ideal but well beyond what is needed.

**pike** · 03-03-2010, 06:50 AM

why dont you use the coordinates of each plot?

**simonsmith** · 03-03-2010, 03:53 PM

Hi Pyke,
a link is has a direction and a distance. I can add GPS co-ordinates for the sites but I still need to draw lines between them to represent the microwave links.
Currently the list of links and their status is manually reviewed then a network map is manually updated using this data. I thought that the two could be linked somehow. the Vector zip class suggested that this might be possible but does not demonstrate multiple vectors coming from one site, only a single set of end to end vectors

Any help appreciated

Cheers

Simon

**pike** · 03-04-2010, 03:58 AM

Arrons vectors does it all
You just need to play around with the code

Please Login or Register  to view this content.

**rwgrietveld** · 03-04-2010, 05:50 AM

Here's what I have after playing around for > 2 hours !!

I'm now of to the pentry to wipe off my forehead.

I must note that this is hacking in someone else's code and it needs optimization.
At least you can play around with it.

**simonsmith** · 03-04-2010, 08:55 PM

Thanks a lot for your help rwgrietveld, I will check it out tonight

Cheers

Simon

**simonsmith** · 03-05-2010, 11:16 AM

Hi rwgrietveld,
when I push the macro button I get a run time 70 error and "permission denied".
Why do you think that would be? This is a work computer but I have run macros on here before.

Cheers

Simon

**rwgrietveld** · 03-09-2010, 11:05 AM

I do not know. If you step into the code with F8, what happens. Where is it giving an error?

**simonsmith** · 03-09-2010, 04:38 PM

Hey there Ricardo,
What I think is the first "1-'2" vector and label 2 are drawn then a then line that looks like vector "1-3", it then produces the error at [Vector1.Draw] in the ['Draw Sequence]
I notice it is an .xlsm file and you use 2007/ 2010, I am using 2003 as does the company. When I open your file it goes through a conversion first, could this be an issue?

Cheers

Simon

**rwgrietveld** · 03-10-2010, 04:34 AM

here is a 2003 version. I'll ask Pike to have a look as well.

**simonsmith** · 03-10-2010, 05:22 PM

Thanks for looking into this Ricardo and indeed changing it to 2003. When I open it and push the macro button without changing any data the same error message 70 comes up. I have tried this on some other people's computers that are not company ones and I get the same problem. Also took off security settings in case this was an issue.

Cheers

Simon

**simonsmith** · 03-16-2010, 03:54 PM

This issue is closed.
No resolution but thank you all anyway. The information gained here has helped a lot anyway.

Cheers

Simon

**shg** · 03-16-2010, 03:58 PM

Don't give up, Simon ...

**Andy Pope** · 03-16-2010, 04:03 PM

FYI the Error 70 is cause by trying to name a shape with one that is already in use.

**shg** · 03-20-2010, 05:13 PM

Try the attached; run Main.

The code is pretty ugly.

**shg** · 03-21-2010, 01:54 PM

Corrected the orientation, did a little cleanup, but the data structures are still lousy.

vectors end to end to make network diagram

LinkBack

Thread Tools

Rate This Thread

Display

vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Re: vectors end to end to make network diagram

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions