blank master key hierarchy charts

[cledry]

Just wondering if anyone has Word template or knows a freeware program that can be used to show the hierarchy of a MK system. My customer wants a layout much like a family tree where it will show in visual form what key works which lock. y old MK program used to do that but I can't find a way with my current software.

[Evan]

@cledry:

Sent you an e-mail with some PDF files of something which might help...

~~ Evan

[cledry]

Thanks Evan. That is better than what I had certainly. I have something similar from Sargent.

What I am really trying to do to make it visually simple for them is to use a tree diagram with the GMK at the top, then bellow this say MK A and MK B then below these it would branch off to SMK AA, AB, AC ... and SMK BA, BB, BC... then below it would finally end up at CK AA-1, AA-2 and so on.

[Evan]

@cledry:

Completely charting out a whole master keying system is impractical unless it is very simple and very small...

I understand the type of chart you wish to make but other than creating it yourself using normal desktop publishing type software OR drawing it out yourself with paper and pen/pencil...

How complex a system it is ? Sounds like a Level IV Great Grandmaster System from what you wrote in your last post... You could do a master level schematic of the hierarchy of the master levels then do a page for each of the lowest level master keys showing specific door level detail if necessary...

~~ Evan

[cledry]

@cledry:

Completely charting out a whole master keying system is impractical unless it is very simple and very small...

I understand the type of chart you wish to make but other than creating it yourself using normal desktop publishing type software OR drawing it out yourself with paper and pen/pencil...

How complex a system it is ? Sounds like a Level IV Great Grandmaster System from what you wrote in your last post... You could do a master level schematic of the hierarchy of the master levels then do a page for each of the lowest level master keys showing specific door level detail if necessary...

~~ Evan

It is actually very small, it comprises two buildings each having their own master and controlled by a grand master. One building will only have one single change key but need expansion for @47 changes times two as I always like to double up on the number of changes for future rekeying. The other building will have a single key change for the perimeter, a single change for maintenance doors, a submaster for the office manager with @ 12 change keys, a submaster for child care with @ 8 changes, a submaster for meeting rooms with 12 changes.

It will be Schlage 6 pin with Primus on the perimeter and regular sectional keys for interiors.

[cledry]

I'm thinking an Excel spreadsheet showing door numbers and CK number followed by what other GGMK, GMK, MK and SMK also work the door would suffice instead of a tree.

Any good blank templates out there that aren't brand specific?

[Evan]

It is actually very small, it comprises two buildings each having their own master and controlled by a grand master. One building will only have one single change key but need expansion for @47 changes times two as I always like to double up on the number of changes for future rekeying. The other building will have a single key change for the perimeter, a single change for maintenance doors, a submaster for the office manager with @ 12 change keys, a submaster for child care with @ 8 changes, a submaster for meeting rooms with 12 changes.

It will be Schlage 6 pin with Primus on the perimeter and regular sectional keys for interiors.

@cledry:

This sounds overly complex for such a small system unless you are making use of incidental master keys and thus using them as a level of key in the system when they aren't designed as such...

So starting starting with the perimeter, you are talking Building A and Building B, so only three different keys in the system need to be Primus, the TMK and the two perimeter changes...

Then with such small groups inside, in my opinion I wouldn't create master level keys to accomplish the interoperability required -- create a change key and cross key it into the locks in the group required rather than create separate master key groups... Or you could create a selective master key type system and key the different masters into and out of doors as needed...

Are those figures you are working from the actual need now or are they padded with appropriate expansion/re-key factored in ?

Without knowing more about how the organization functions and the layout of the building I can not be more specific with advice... It does sound like you are trying to key the people rather then the building though...

~~ Evan

[cledry]

Evan, yes you are correct the only Primus keys will be the GMK, the MK for each building and the perimeter key for each building. A total of 4 keys. Everything else will be a corresponding sectional.

This is what they want to accomplish. GMK operates all doors, MK for building A operates all doors in building A, MK for building B operates all doors in Building B.

Building A has the following departments.

Maintenance
Apartment Offices
Child Care
Meeting Rooms
Perimeter

Building B is just one department.

Clinic.

I always include expansion. Right now there are two doors that need crosskeying.

The perimeter will all be KA.
The maintenance will be KA but I foresee them changing their mind and splitting this up so will use a block master.
Meeting rooms will require a MK and individual key, there are 6 meeting rooms and they might each get rekeyed once a year at most.
Child care needs a MK, although most is KA within and it doesn't get rekeyed much.
Apartment offices might need a MK or not depending on a decision to go KA or KD.

Clinic comprises @20 individual offices. At the moment they are not incorporating them into the system, but I assume they will at some point. Usually such offices will be grouped by specialty with a MK for each dept. and individual offices KD.

[Squelchtone]

look into Microsoft Visio, it's great for flow charts, and floor plans.
http://en.wikipedia.org/wiki/Microsoft_Visio

sample Visio chart:


or you can use something similar called Draw from Open Office
http://www.openoffice.org/product/draw.html

hope that helps,
Squelchtone

[cledry]

Thanks Squelchtone.

[Punkty24]

@cledry:

Sent you an e-mail with some PDF files of something which might help...

~~ Evan

Is there any possibility that you could possibly possibly forward the hierarchy chart info to me too please? Struggling to get my head around it tbh

[Jacob Morgan]

There is a free software product named yEd Graph Editor. https://www.yworks.com/downloads#yEd What is nice about it is you can upload an Excel file with two columns of "edges" and "nodes." Then it will graph them for you, and you can select different "looks" to the graphs. There is some learning curve, but a neat way to make family-tree type diagrams very quickly.

There is a video on it here https://www.youtube.com/watch?v=l-ktE8syWUI, although it goes into more detail than what you need. For what you want to do, I could probably write out an ~ 8 step how-to cheat sheet if you are interested.

[Jacob Morgan]

Someone across the pond sent me a PM asking for a walk-through for yEd Graph Editor.

First make an Excel sheet like so. Open Office, etc., should work too, just save as an XLSX file. Do not need column headings. I just made up a quick list of master keys and change keys. I think it is self-explanatory. It probably is not the correct labeling scheme--I did not have a master keying handbook handy to get the preferred naming convention. Note that the order they are in is irrelevant--they just need to be in the correct columns. Change keys and master keys below the top level (if any) to the right and master keys to the left.


Then open yEd Graph Editor and open a new document (from the pop up screen, or go to File in the upper-left hand corner). Open a file and select the Excel file.


On the Data tab, go with Edge List, and uncheck the Names in First Row. Highlight the data range (all the data) and click adopt. Same for Source and Target. Source is the column of keys that are master to other keys. Target is the column of change keys and master keys under the top level. Leave the Node section blank and ignore the "Data Range" is empty or invalid warning.


Then click on the Presentation tab. Select Node Label for the Label Text, and Fit to Size. Ignore the Edges section, and for Layout go with Hierarchical. Then hit OK.


Here is what it makes. It does all the spacing and formatting and such. I kept the text short in this made up example, but you can make it long and descriptive if you want. It looks like I made a mistake in my made up list of keys (not sure what I was thinking with key M-AB).


Or, you can put on a Pink Floyd album and go to layout and select other ways of displaying the data. I think this is the "circular" layout. Some of the layouts are really out there.


You can change the default back ground color of the boxes, etc. If anyone is wondering, there is a way to put labels on the lines as well (using Excel data).

[Squelchtone]

@cledry:

Sent you an e-mail with some PDF files of something which might help...

~~ Evan

Is there any possibility that you could possibly possibly forward the hierarchy chart info to me too please? Struggling to get my head around it tbh

Punkty24: Please check the dates of posts before you ask for stuff, lately I see you asked someone for something from 5 years ago and in this thread its from 6 years ago: This is the date Evan wrote his reply: Sat Jun 09, 2012

Some folks are still around and happy to help, but some are no longer here, please keep that in mind.

Thank you
Squelchtone

[Evan]

@cledry:

Sent you an e-mail with some PDF files of something which might help...

~~ Evan

Is there any possibility that you could possibly possibly forward the hierarchy chart info to me too please? Struggling to get my head around it tbh

Punkty24: Please check the dates of posts before you ask for stuff, lately I see you asked someone for something from 5 years ago and in this thread its from 6 years ago: This is the date Evan wrote his reply: Sat Jun 09, 2012

Some folks are still around and happy to help, but some are no longer here, please keep that in mind.

Thank you
Squelchtone

Hey all:

I don't want to quasi-necropost on an old thread where I contributed, but I am not dead and still stop by on occassion.

@Punkty24: I no longer have the laptop I was using six years old, so the library of files I had compiled on it no longer exists. If I remember correctly what I sent to cledry was a PDF from the Corbin Russwin document library located here:

Corbin Russwin Key System Schematic Forms

Hope this helps even though it is almost two months later.

~~ Evan