Excel Conditional Movement of Data

Excel Conditional Movement of Data

I have been recently asked how you can move data conditionally on an excel spreadsheet once the information has been obtained from the PLC? Monthly data was being collected from the PLC and put on an excel spreadsheet using Omron CX-Server DDE. They wanted at the beginning of each month to move the data to … Read more

Building a PLC Program – Part 5 – Simon Game

We will now look at the Game of Simon for our part 5 in this series of building a PLC program. Learning all about bit manipulation and sequencers Simon is a memory game introduced in 1978. It has four colored buttons, each producing a particular tone when it is pressed or activated by the device. … Read more

Create a PLC HMI Training Learning Environment

We will now create a PLC with HMI Training and learning environment. We will use the Automation Direct Do-More programming software tied into the Advanced HMI learning package via Modbus TCP. All of the software is free and fully functional. Learn PLC programming and use a powerful HMI (Human Machine Interface) easily and freely. Setting … Read more

How to Implement Modbus TCP Protocol VBA Excel

We are using Modbus TCP protocol, reading ten registers in the PLC, and displaying a bar graph in Excel. e will use Visual Basic for Applications (VBA) to communicate with a PLC. Previously we have used VB6 to communicate Modbus TCP. Sequence for Modbus TCP on Excel using VBA The following steps will be done: … Read more

PLC Programming Example – Process Mixer

We will apply the five steps to PLC Program development to our following programming example of a process mixer. The process mixer will be programmed using ladder logic. We will discuss each step of the PLC program development. 1 – Define the task: How does the process mixer work? A normally open start and normally … Read more

Creating a Flip Flop Circuit in the PLC

A flip-flop circuit in a PLC usually has one input and two outputs. When the input is activated, the two outputs alternately latch on/off opposite each other. It is used to toggle (latch) work on and off with just one input. In the PLC, it is a single input that will toggle an output on … Read more