Abstract: A method for programming a programmable logic controller (PLC) is disclosed. The PLC may be used to control devices of a secured facility, such as a detention center, jail, or prison. The disclosed method may include creating a spreadsheet including information relating to devices and functions of a system to be controlled by the PLC, such as the number and type of door locks and the functionality of the door locks. The method may further include analyzing the spreadsheet to detect errors in the information stored in the spreadsheet. The method may further includes writing PLC logic to control the system based in the information in the spreadsheet.