Master keying software /web app or Apple app

[MrPharmer2012]

Hi all, I am looking for basic master key software as trial or free it can be an app windows software or a simple excel sheet, I did see one on the forum here that is a 64 page master key but it does not give the pin stacks etc does anyone have a file they created or know of an excel file or program I could use?

[jeffmoss26]

Check out mkcalc.com - it's free, fairly basic but good.
Long time no see!

[MrPharmer2012]

Thanks Jeff, I also came across Master it and App store app, anyone use that? After searching online I also found a 5 pin excel sheet click here https://docs.google.com/spreadsheets/d/ ... drive_web#

[jimu57]

I created an Excel spreadsheet to specifically generate 6 pin Schlage keys for a project of mine. I key in the MK and GMK if needed. It identifies keys that do not meet the MACS. I also have it set up to identify ghost cuts in a matrix for calculating cross keying. And it can take all the change key cuts and generate a random sort. I am working on redoing the spreadsheet to make it more generic.


https://www.dropbox.com/s/w0rdhj7mka6qx ... 1.jpg?dl=0

https://www.dropbox.com/s/psajo4t3e1o9g ... 2.jpg?dl=0

[MrPharmer2012]

Thank you WOuld you be able to share this excel file with the members?

[MrPharmer2012]

Check out mkcalc.com - it's free, fairly basic but good.
Long time no see!

jeff mkcalc isnt bad but i would like one that would export the pinning also so i can print off and just bring with me etc but still going to hold onto, by the way I found one of your locks of doom you sent me years ago last night

[jimu57]

Thank you WOuld you be able to share this excel file with the members?

I will. Almost finished with the modifications. Should I post the link here or is there a better place?

[jeffmoss26]

Check out mkcalc.com - it's free, fairly basic but good.
Long time no see!

jeff mkcalc isnt bad but i would like one that would export the pinning also so i can print off and just bring with me etc but still going to hold onto, by the way I found one of your locks of doom you sent me years ago last night

Awesome! Your name came up when I was looking through my info on the Medeco sidebar keys

[jimu57]

Here is the link to the spreadsheet. Remember, it isnt perfect. Hard to do things like this in Excel. The spreadsheet has lots of hidden columns and some macros. You will see a button to click to recalc the sorted bittings and also randomized bittings.

I set this up for Schlage 6 pins originally. I changed some things to allow some variables to be changed like MACS, smallest and largest pin, step between pins in a chamber.... also determines the parity. The sheets are not protected. The yellow shaded areas are the areas where data needs to be input. Do not override any fields that are not yellow.

You will have to define print areas when you want to print the listings.

I am sure I have some errors. If anyone discovers one, or more, let me know. This is a project in process.

https://www.dropbox.com/s/q2iahm0nm5cf4cs/master%20key%20and%20changes.xlsm?dl=0

[MrPharmer2012]

Thank you so much I will download and review this weekend

[TylerJThomas]

A friendly word of advice: make sure you have an understanding of master keying, especially with regards to cross keying and incidental master keys, if you're using master keying software. It will help you catch any errors (they exist in in some commercial software!) and avoid making any errors yourself.

[jimu57]

Thank you so much I will download and review this weekend

Uploaded an update. It wasnt calculating master pins correctly.... Has been fixed.

[MrPharmer2012]

Great is it on the same above link?

[jimu57]

Yes. Same link.