Data Logging W/excell And Rslinx {time Stamp}

[ToddM 0]

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

[Chris Elston 79]

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?

[TimWilborne 108]

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

[ToddM 0]

Hi folks....Chakorules... 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

[TimWilborne 108]

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 Edited 25 Mar 2006 by TWControls

[ToddM 0]

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

[Nathan 7]

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"

[TimWilborne 108]

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