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