Patch Panel Stencils For Visio3/20/2021
This stencil includes the Patch Panel master which can be stretched from 2U to 25U high.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.I opened up the ShapeSheet of the Patch Panel master and found that the formula in the Prop.UCount.Value cell is imposing 2 as a minimum value with the BOUND() function.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 actually wanted the number of ports to be halved to 12, so I set about exploring the sub-shapes in the master.
Patch Panel Stencils For Visio Patch Panel MasterAll of its sub-shapes have a height formula referencing this height, so I decided to modify the PinY formula to Sheet.5Height0.5(IF(Sheet.5Prop.UCount1,2,1)) so that it would move the lower bank of ports up into the correct position if the Prop.UCount equals 1. ![]() Patch Panel Stencils For Visio Code To DoAt 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. This has the advantage that you can run the code on existing documents that already have the Patch panel master in it. Reader Interactions Comments Hernn Silva Olivares says July 22, 2011 at 4:08 pm davidjpp, great example, tanks you, from Chile. Reply davidjpp says July 28, 2011 at 6:15 pm Thanks from England Reply Benny says October 13, 2011 at 3:40 pm Thanks Reply Barny says October 24, 2011 at 9:07 am Thanks for figuring this out. Special thanks for the If you cannot be bothered.vsd link: ) Reply Hasi says December 28, 2011 at 11:38 pm Thx a lot mate Reply clark says January 6, 2012 at 7:01 am Thanks a lot from taiwan Reply John Mitchell says January 16, 2012 at 10:04 am Thanks from George, South Africa Reply ugandran says March 5, 2012 at 4:19 am we need data center and floor idf contaiment stencil to be download in our current visio2007 Reply davidjpp says March 5, 2012 at 8:06 pm Have you checked out the following Reply Lee says May 19, 2012 at 8:06 pm I dont know if its just me, but for some reason the file will only open with powerpoint, where I get an error. I cant believe finding a 1U patch panel has held this thing up 4 hours. Please help. Reply davidjpp says May 21, 2012 at 10:40 am Well, I have generated a new link for you to try: Reply Adrian James says October 18, 2012 at 10:57 am Thanks I copied it works well Reply Juliana says November 27, 2012 at 7:11 am You are so kind in sharing Thanks a lot from SwedenBrazil Reply MrSaphique says December 4, 2012 at 11:26 am I get an error the PinY. Reply davidjpp says March 25, 2013 at 6:27 pm I just tested it it looks live to me. Reply kathars1s says March 25, 2013 at 6:21 pm How do we run this code Where in Visio Reply davidjpp says March 25, 2013 at 6:29 pm Just drag the Microsoft supplied Patch Panel into a document Add the code into the VBA project of the document Run the code Reply damian says April 17, 2013 at 1:44 am A good workaround and I like that youve changed to a VSD, however to make it easy, you can simply change the ShapeSheet data User-defined Cells, User.OneUHeight to half of what it currently is, it will drop the height down. This is my fix for the situation at least, it still looks like its a double panel, but it looks pretty Reply Kassa says June 27, 2013 at 7:53 pm Thank you very much this is really help me. Reply alex says November 28, 2018 at 9:52 am link is down, i need it please Reply davidjpp says November 28, 2018 at 10:35 am Link updated Reply alex says November 28, 2018 at 3:25 pm Thank you so much Reply Norseman says August 2, 2019 at 3:44 pm Brilliant Never ceases to amaze me how companies can miss the little things when marketing their products.dont think it makes a difference to have the Visual Guy use tools branded with your logo Think again His Visuals sell your product to the check writers Your sales reps cant do that Dude, thanks for this nifty tool Couldnt find a 24 port patch stencil anywhere Reply Leave a Reply Cancel reply Your email address will not be published. Required fields are marked Comment Name Email Website Save my name, email, and website in this browser for the next time I comment. Primary Sidebar Search this website LinkedIn Twitter Recent Posts Viewing Visio Document Changes in Git Visio ShapeSheet Functions D-F Visio ShapeSheet Functions A-C Using the CALLTHIS function in Visio Referencing Visio Shapes Categories Categories Select Category Access Accessibility Azure Bing Maps Books Coding C Deployment DevOps Git JavaScript JSON mFormula TypeScript VBA Diagram Types Database Floor Plans Games Geographic Network Diagrams Org Charts Process Flows Ebooks Excel Data Visualizer PowerMap Hardware Microsoft Cognitive Services MixedReality MSIgnite Multi-Language MVP Office 365 Office Mix Power Platform MSFlow Power Automate PowerApps PowerBI PowerPoint Products LayerManager Metro Icons pdSelect SS Plus Visual Risk Analysis visViewer Project Shape Design Callouts Color Connections Connectors Containers Data Graphics External Data FillPattern Hyperlinks Images Layers Lists Save As Scale Selections Shape Data Shape Reports ShapeSheet Formulas Slide Snippets Styles Themes Validation SharePoint SharePoint 2013 SharePoint Online Silverlight Solutions SOP Web Pages TimeTable SQL Server Graph Database Teams Travel Uncategorized Videos Virtual Earth Visio Articles Visio 2010 Visio 2013 Visio 2016 Visio for Desktop Visio for Web Visio Online Visio Plan 2 Visio Pro for Office365 Visio Services Visio Viewer Webcasts Windows App Windows Phone Tags Accessibility Add-Ins Connectors Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes MSIgnite Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Pro for Office365 Visio Services Visio Viewer Web Webinar Footer bVisual Profile The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe. Learn more about bVisual LinkedIn Twitter Search this website Search this website Recent posts Viewing Visio Document Changes in Git Visio ShapeSheet Functions D-F Visio ShapeSheet Functions A-C Using the CALLTHIS function in Visio Referencing Visio Shapes Copyright 2021 Executive Pro on Genesis Framework WordPress Log in We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it. Ok Privacy policy.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |