Can you add data to the spreadsheet without having Excel open and running? do the values continue to rollover? anyother nuances for datalogging for if a customer wanted to log leak test values for each part that cycles through the machine?
I know Studio 5000 is a huge application and in what it can do and there are many cool stuff, but i gotta say this is one the coolest features I've ever been made aware of and seen demonstrated. It's also something I don't think i've ever seen anyone made use of the usefulness of this functionality and i'm guessing they maybe didn't quite know how or was aware of it. Question though: Does that data keep being pulled into Excel only when its open? What happen if you close Excel? Is there some limit to which the data stops plotting? Can you make multiple Real-Time Data Logging of different data points?
Hi Ardent, thanks for all the comments. Yes, I'm this scenario Excel need to be open. If data retention was needed then I would certainly opt for a database. Another series perhaps that leverages C#, PLCs and SQL Server!
The information you have provided was very helpful for my PLC studies. I have a question and I do not know if you will be able to help. I realize that you have Factory IO installed in your computer and I was wondering if you have ever try to run factory IO and Emulate 500. The reason I asking is that I have an issue creating filters with the RsLinx OPC server.
you just create a basic line graph chart in excel, change the chart parameters to suit the data you want to see, then do as he does in the video beginning at 9:22
In the real world, we would need to connect the PLC over Ethernet right? Is there any way we could have WiFi instead to create a local network for multiple PLC logging into the same server?
FYI: / is "slash*" and \ is "backslash" * / is also "foward slash," but if the "forward" is left off and there is no "backward" in its place, then "forward" is implied So it's "haitch-tee-tee-pea-colon-slash-slash-..." Just sayin'
Cool. I tried this today with real hardware and it works. However, I can't really get any more then the 120 rows out and then I get garbage in the spreadsheet cells. I tried playing with the polling time and nothing seems to increase the amount of rows I am able to transmit. It fails at 200 for me. Any tips to increase the capture size or is this basically the limit here?
Could have saved me 9 min of my time by stating the most significant point of this and that is having professional version of linx. Instead the first 9 minutes are of you explaining your code and how an emulator is setup. I was more interested in learning about OPC and excell. Please TH-camrs get to the point.
Please change the title , it's not an OPC connection , because here Excel is initiating a DDE conversation with RSLinx , unfortunatly this type of connection is so old not reliable , slow in case of large systems (conversations are updatind clients data one by one for each connection initiation ) not like OPC Asych . well the title should be "Real-time Data Logging Using RSLinx DDE and Excel"
Can you add data to the spreadsheet without having Excel open and running? do the values continue to rollover? anyother nuances for datalogging for if a customer wanted to log leak test values for each part that cycles through the machine?
I know Studio 5000 is a huge application and in what it can do and there are many cool stuff, but i gotta say this is one the coolest features I've ever been made aware of and seen demonstrated. It's also something I don't think i've ever seen anyone made use of the usefulness of this functionality and i'm guessing they maybe didn't quite know how or was aware of it.
Question though: Does that data keep being pulled into Excel only when its open? What happen if you close Excel? Is there some limit to which the data stops plotting? Can you make multiple Real-Time Data Logging of different data points?
Hi Ardent, thanks for all the comments. Yes, I'm this scenario Excel need to be open. If data retention was needed then I would certainly opt for a database. Another series perhaps that leverages C#, PLCs and SQL Server!
This is using DDE and com object access rather than OPC though?
Windows 10 no longer supports DDE.
Very cool video
also you must share plc program file too
Please do a video and explain how to archive data with excel. many thanks.
I need this too 😁
i need it as well
very informative video, great job, many thanks.
very cool
Great job!!!!Thank you so much
Great page, hope I'm not too late to win the Raspi!!
The information you have provided was very helpful for my PLC studies. I have a question and I do not know if you will be able to help. I realize that you have Factory IO installed in your computer and I was wondering if you have ever try to run factory IO and Emulate 500. The reason I asking is that I have an issue creating filters with the RsLinx OPC server.
What download link below?
Great job.. may i know how to setup connection in ms_excel.
you just create a basic line graph chart in excel, change the chart parameters to suit the data you want to see, then do as he does in the video beginning at 9:22
In the real world, we would need to connect the PLC over Ethernet right? Is there any way we could have WiFi instead to create a local network for multiple PLC logging into the same server?
thanks
7:52 What is the data type for "Data_DDE"? Why do you have ".Time[...]" and [.Data_REAL[....]" under it?
FYI: / is "slash*" and \ is "backslash"
* / is also "foward slash," but if the "forward" is left off and there is no "backward" in its place, then "forward" is implied
So it's "haitch-tee-tee-pea-colon-slash-slash-..."
Just sayin'
Lol. That's funny you mentioned that because I realized I was saying it wrong a short time after..lol...you're the first to pick up on it. Well done!
@@PLCGurusNET LOL thx.
Is it needed to close the connection or something to close the spreadsheet and disconnect the PC from the PLC?
Cool. I tried this today with real hardware and it works. However, I can't really get any more then the 120 rows out and then I get garbage in the spreadsheet cells. I tried playing with the polling time and nothing seems to increase the amount of rows I am able to transmit. It fails at 200 for me. Any tips to increase the capture size or is this basically the limit here?
Hi Fred, Thank you for such a useful video, i get an problem in my excel sheet, and it is telling me server error, do you have any clue?
Sir I'd like to know if we can do datalogging from a simulator to excel? not using the real PLC.. sorry Im very new to this hope u dont mind!
Unfortunately this will no longer work with Windows 10. Microsoft removed DDE support in 2020.
this is using DDE, not OPC.
Wow !
This no longer works because DDE is no longer allowed for Windows 10.
It needs to be OPC & not DDE
Could have saved me 9 min of my time by stating the most significant point of this and that is having professional version of linx. Instead the first 9 minutes are of you explaining your code and how an emulator is setup. I was more interested in learning about OPC and excell. Please TH-camrs get to the point.
Please change the title , it's not an OPC connection , because here Excel is initiating a DDE conversation with RSLinx , unfortunatly this type of connection is so old not reliable , slow in case of large systems (conversations are updatind clients data one by one for each connection initiation ) not like OPC Asych . well the title should be "Real-time Data Logging Using RSLinx DDE and Excel"