So I banged this out over the course of an hour or so, to help me validate some pencil-and-paper progressions I've been doing to sharpen my skill. I'd appreciate some peer review from anyone interested in looking.
The macros are not locked, so you can verify I'm not doing something sneaky in the background before you enable macros.
It really only works for 5 pin systems at the moment, but I have a lot of enhancements that I plan to do to flesh it out (including identifying incidental masters, etc. -- no masters, except TMK are presently displayed)
Excel MK Page Generator.zip
(This is an Access 2010 .xlsx file. I'm not experienced with OpenOffice or LibreOffice but would be willing to convert it if desired)
Thanks for feedback.
Limitations:
Currently only progresses one page of a 5-pin system. Schlage was used as defaults because... reasons... You can adjust min bit, max bit, MACS, parity, SOP, etc. Fields left blank are generated randomly or used Schlage defaults. Setting MFG name doesn't do anything at the moment.
Disclaimer of liability: this program is not necessarily suitable for any particular use and I explicitly disclaim any liability for results arising from your use. Mainly hacking in VBA (which I despise) and trying to get something user friendly in Excel.