- #24 PORT PATCH PANEL LABEL TEMPLATE FULL#
- #24 PORT PATCH PANEL LABEL TEMPLATE CODE#
- #24 PORT PATCH PANEL LABEL TEMPLATE PC#
- #24 PORT PATCH PANEL LABEL TEMPLATE PROFESSIONAL#
Then it was just necessary to go through each of the sub-shapes of Sheet.18 to modify the Geometry X.NoShow formula to =Sheet.5!Prop.UCount=1 for each Geometry section which is in the upper half of the shape.Īt this point, I could see that I had to put this formula into 12 geometry sections of 4 shapes, which is 48 copy and pastes! Therefore, I decided to write some VBA code to do this instead. All of its sub-shapes have a height formula referencing this height, so I decided to modify the PinY formula to =Sheet.5!Height*0.5*(IF(Sheet.5!Prop.UCount=1,2,1)) so that it would move the lower bank of ports up into the correct position if the Prop.UCount equals 1. I found that Sheet.18 contains the port shapes, and that its height is fixed at 2 Us. I actually wanted the number of ports to be halved to 12, so I set about exploring the sub-shapes in the master.
I changed the formula to =BOUND(2,0,FALSE,1,25), and was then able to change the UHeight to 1U, but the 24 ports remained visible: I opened up the ShapeSheet of the Patch Panel master and found that the formula in the cell is imposing 2 as a minimum value with the BOUND() function. However, I have often required a 1U patch Panel, so I decided to look into the Microsoft shape to see if it could be modified to allow it to be reduced to 1U without looking ridiculous. This stencil includes the Patch Panel master which can be stretched from 2U to 25U high.
#24 PORT PATCH PANEL LABEL TEMPLATE PROFESSIONAL#
Microsoft Visio 2007 Professional and 2010 Professional and Premium includes the Network / Rack Diagram template, which opens the Rack-mounted equipment stencil.
#24 PORT PATCH PANEL LABEL TEMPLATE PC#
r/buildapcsales - For sales on building a PC r/linux - All flavors of Linux discussion & news - not for the faint of heart! Try to be specific with your questions if possible. r/linux4noobs - Newbie friendly place to learn Linux! All experience levels. r/datacenter - Talk of anything to do with the datacenter here
#24 PORT PATCH PANEL LABEL TEMPLATE FULL#
Please see the full rules page for details on the rules, but the jist of it is: Labporn Diagrams Tutorials News Subreddit Rules New to Homelab? Start Here! Homelab Wiki HomelabSales