Forum Discussion
8 bit binary series fill
hello all. I'm working with FANUC PMC/PLC stuff. I am trying to make a fancy Input Output sheet. PMC uses 000.0 format. Range from 0000.0 to 0000.7 until the whole number flips (to 0001.0 then). I am ...
thank you for the help. Looks like that works.
I found a very long method...definitely not the best, but here we go...first cell is my start (0), next cell takes last cell and adds .1 to it. Copy that cell until I get up to 0000.7. Then next cell in that column is the first cell (0000.0)+1. Copy that +1 cell all the way until the end.
And as a bonus, since I need to copy these values into a text document to import...i can use TEXT(Cell,"0000.0") and Concatenate to pull together all of my values to a single cell. Now copying and pasting into a text file has no spaces between values.
This is a garbled mess. But I'm hoping if you ever need this for PMC ladder, you'll be smart enough to understand it all. Gotta get back to the ladder, thank you and you're welcome!
I found a very long method...definitely not the best, but here we go...first cell is my start (0), next cell takes last cell and adds .1 to it. Copy that cell until I get up to 0000.7. Then next cell in that column is the first cell (0000.0)+1. Copy that +1 cell all the way until the end.
And as a bonus, since I need to copy these values into a text document to import...i can use TEXT(Cell,"0000.0") and Concatenate to pull together all of my values to a single cell. Now copying and pasting into a text file has no spaces between values.
This is a garbled mess. But I'm hoping if you ever need this for PMC ladder, you'll be smart enough to understand it all. Gotta get back to the ladder, thank you and you're welcome!