Hi Folks...I have been asked at work to try and log the machine speed on 3 of our dryers. I downloaded the PLCDatalogger excell spreadsheet from the download section and through RSLinx configured my topics and copied the links from all three dryers into the 1st 3 data collection cells and everything works great , now I'd like to time stamp my data. I am only collecting every 10 mins. could someone give me a clue as how to alter the spreadsheet to time stamp the data? I've poked around in Excell to try and find it myself but I'm not quite sure where to poke. Any and all help would be appreaceated. {BTW to whoever posted that PLCDatalogger , Many thanks,you saved me lots of time }

Thanks and later....Todd

I did a time stamp with this logger sheet I made:
http://forums.mrplc.com/index.php?autocom=downloads&showfile=134

I copy and paste the rows using VB Script. In the Time Stamp row, I just have an now( ) function. Will that work for you?

Real simple timestamp if the PLC has a clock. When you log the data, log the PLC time

Hi folks....Chakorules...
I checked that out too but couldn't figure out how to do the time stamp from your example {You see...I'm kind of Excell challenged, still trying to learn it} If you could please post some type of instructions for me to follow I'd be much appreaceative.{If it's not too much trouble}
TW controls.. I tried that but couldn't access the S:37 thru 42 bits....or maybe I just missed it. I'll try again tommorow.
Thanks for the replys and later....Todd

I don't think you can access the S:37-42 directly from Excel. MOV the S:37-42 values unconditionally to Integer(N) files, then you can read the Integers with Excel for the timestamp

TWControls....By golly that will work!!!{I think} I 'll check it out tommorow and let you know how it works.

Thanks and later...Todd

Todd,
I sent you a message. In most cases I would recommend logging the data to an SQL database instead of Excel. I would recommend checking out FactorySQL to do this cheaply and easily. You can sign up for a web demonstration to get all of your questions answered at:
http://www.inductiveautomation.com/products/webdemo/

----
Nathan Boeger naboeger@inductiveautomation.com
Integrator, Microsoft Certified Systems Engineer
Inductive Automation
"Design simplicity cures engineered complexity"

I'm am not familiar at all with SQL. I am not trying to condemn or condom your methods, but what would be the advantage of using SQL to do the data logging in this situation? It could be something I'm interested in