Page 1 of 1

Master keying software /web app or Apple app

PostPosted: Wed Jul 26, 2017 1:13 am
by 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?

Re: Master keying software /web app or Apple app

PostPosted: Wed Jul 26, 2017 7:19 pm
by jeffmoss26
Check out mkcalc.com - it's free, fairly basic but good.
Long time no see!

Re: Master keying software /web app or Apple app

PostPosted: Thu Jul 27, 2017 8:53 am
by 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#

Re: Master keying software /web app or Apple app

PostPosted: Thu Jul 27, 2017 11:37 am
by 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

Re: Master keying software /web app or Apple app

PostPosted: Thu Jul 27, 2017 10:56 pm
by MrPharmer2012
Thank you WOuld you be able to share this excel file with the members?

Re: Master keying software /web app or Apple app

PostPosted: Fri Jul 28, 2017 2:00 am
by MrPharmer2012
jeffmoss26 wrote: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

Re: Master keying software /web app or Apple app

PostPosted: Fri Jul 28, 2017 5:19 am
by jimu57
MrPharmer2012 wrote: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?

Re: Master keying software /web app or Apple app

PostPosted: Fri Jul 28, 2017 10:06 am
by jeffmoss26
MrPharmer2012 wrote:
jeffmoss26 wrote: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 :)

Re: Master keying software /web app or Apple app

PostPosted: Fri Jul 28, 2017 7:59 pm
by 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

Re: Master keying software /web app or Apple app

PostPosted: Sat Jul 29, 2017 1:22 am
by MrPharmer2012
Thank you so much I will download and review this weekend

Re: Master keying software /web app or Apple app

PostPosted: Sat Jul 29, 2017 10:01 am
by 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.

Re: Master keying software /web app or Apple app

PostPosted: Sat Jul 29, 2017 10:17 am
by jimu57
MrPharmer2012 wrote:Thank you so much I will download and review this weekend


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

Re: Master keying software /web app or Apple app

PostPosted: Sun Jul 30, 2017 1:01 am
by MrPharmer2012
Great is it on the same above link?

Re: Master keying software /web app or Apple app

PostPosted: Sun Jul 30, 2017 12:22 pm
by jimu57
Yes. Same link.