Control Logix Coversion

[hipoint2 0]

Anyone know how to take a DINT and convert it to a binary value? I am trying to take a Dint and convert it to binary and then put it into excel so I can see each bit that is on.

[TimWilborne 108]

You don't really convert it to binary, you just change the way you view the data. There are two easy ways to do it. 1. Do the binary conversion in Excel 2. If your tags is MyDint then pull each bit into Excel. MyDint.0 through MyDint.31

[hipoint2 0]

For number 2 I thought I could do that, but when I goto RSLinx and find the address to copy and paste the link it does not go down to bit level. I only get the whole word. Whats up with that?

[TimWilborne 108]

Your right. You can't do number 2. I was thinking about something else. I have an Excel sheet doing this. Give me a few hours to find it. Very busy right now. If you I don't get back to you in time here is the basic idea going completely off of memory. (MyDint &1)/1 = Bit 0 (MyDint &2)/2 = Bit 1 (MyDint &4)/4 = Bit 2 (MyDint &8)/8 = Bit 3 (MyDint &16)/16 = Bit 4 (MyDint &32)/32 = Bit 5 ......... (MyDint &2147483648)/2147483648 = Bit 31

[TimWilborne 108]

Ok in Excel you have to put the above code in a macro. I knew there was a catch but couldn't remember where. Excel does not have a bitwise AND but VB does. The other option is to take the 32 bits of your DINT to 32 BOOLs in RsLogix 5000

[mellis 0]

Try this for a binary display in Excel... In cell A1, put the DINT from ControlLogix. In cell A3, put =DEC2HEX(A1,8). In cell A5, put =HEX2BIN(MID($A$3,1,2),8). In cell A6, put =HEX2BIN(MID($A$3,3,2),8). In cell A7, put =HEX2BIN(MID($A$3,5,2),8). In cell A8, put =HEX2BIN(MID($A$3,7,2),8). This will give you 4 groups of 8 bits each. You can't just DEC2BIN the DINT because Excel gives up after 10 digits of binary. Good luck, Mike Ellis

[Stupidav 1]

You can also use the VB Editor from with in Excel and DIM tagname as Boolean There are several examples in the downloads section on who to use VB