Real-time Data Logging Using RSLinx OPC and Excel

  Рет қаралды 51,534

PLCGurus.NET

PLCGurus.NET

Күн бұрын

Пікірлер: 35
@controlsgirl
@controlsgirl Жыл бұрын
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?
@d3adlyBuzz
@d3adlyBuzz 4 жыл бұрын
This is using DDE and com object access rather than OPC though?
@superezbz
@superezbz 3 жыл бұрын
Windows 10 no longer supports DDE.
@navjotSingh-yd9ke
@navjotSingh-yd9ke Жыл бұрын
also you must share plc program file too
@kcmo1992
@kcmo1992 3 жыл бұрын
What download link below?
@ardentdfender4116
@ardentdfender4116 5 жыл бұрын
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?
@PLCGurusNET
@PLCGurusNET 5 жыл бұрын
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!
@LGrove-ep9yl
@LGrove-ep9yl 10 ай бұрын
7:52 What is the data type for "Data_DDE"? Why do you have ".Time[...]" and [.Data_REAL[....]" under it?
@ramsesramirez1910
@ramsesramirez1910 4 жыл бұрын
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?
@Epsilon9494
@Epsilon9494 4 жыл бұрын
Is it needed to close the connection or something to close the spreadsheet and disconnect the PC from the PLC?
@bitodicontroltechnology4451
@bitodicontroltechnology4451 3 жыл бұрын
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.
@ZacOwens22
@ZacOwens22 3 жыл бұрын
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?
@adelinasimanjuntak3032
@adelinasimanjuntak3032 4 жыл бұрын
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!
@NaserNorouzi
@NaserNorouzi 4 жыл бұрын
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?
@ahmedb8395
@ahmedb8395 5 жыл бұрын
Please do a video and explain how to archive data with excel. many thanks.
@fastabiqhidayatulah9444
@fastabiqhidayatulah9444 4 жыл бұрын
I need this too 😁
@NaserNorouzi
@NaserNorouzi 4 жыл бұрын
i need it as well
@sarathraj6194
@sarathraj6194 5 жыл бұрын
Great job.. may i know how to setup connection in ms_excel.
@blingVolcano
@blingVolcano 4 жыл бұрын
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
@Tevez2367
@Tevez2367 4 жыл бұрын
Very cool video
@ahmedb8395
@ahmedb8395 5 жыл бұрын
very informative video, great job, many thanks.
@daleybread777
@daleybread777 4 жыл бұрын
Great page, hope I'm not too late to win the Raspi!!
@jouellet100
@jouellet100 4 жыл бұрын
this is using DDE, not OPC.
@superezbz
@superezbz 3 жыл бұрын
Unfortunately this will no longer work with Windows 10. Microsoft removed DDE support in 2020.
@yangrong7868
@yangrong7868 5 жыл бұрын
Great job!!!!Thank you so much
@BigTimeCharley1956
@BigTimeCharley1956 4 жыл бұрын
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'
@PLCGurusNET
@PLCGurusNET 4 жыл бұрын
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!
@BigTimeCharley1956
@BigTimeCharley1956 4 жыл бұрын
@@PLCGurusNET LOL thx.
@acluster3411
@acluster3411 3 жыл бұрын
very cool
@LearnSomethingHelpful
@LearnSomethingHelpful 4 жыл бұрын
This no longer works because DDE is no longer allowed for Windows 10. It needs to be OPC & not DDE
@mohammadmajzoub4061
@mohammadmajzoub4061 5 жыл бұрын
thanks
@Freedom1776usa
@Freedom1776usa 3 жыл бұрын
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 KZbinrs get to the point.
@SofianeBENCHARIF-rq5pw
@SofianeBENCHARIF-rq5pw 8 ай бұрын
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"
@timkloehn9887
@timkloehn9887 5 жыл бұрын
Wow !
Read and Write Data in MS Excel, using RSLinx to and from ControlLogix
15:27
Robotics & Automation - Electro-Mechanical
Рет қаралды 39 М.
OPC Servers and RSLinx
14:22
Vern Vanleuven
Рет қаралды 33 М.
Counter-Strike 2 - Новый кс. Cтарый я
13:10
Marmok
Рет қаралды 2,8 МЛН
Data Logging using a PanelView Plus and XL Reporter
8:53
Rumsey Electric
Рет қаралды 22 М.
PLCGurus.NET - Understanding Periodic Tasks
18:55
PLCGurus.NET
Рет қаралды 15 М.
How to get A-B PLC data values into MS Excel using RSLinx
8:48
Insights In Automation
Рет қаралды 65 М.
PLCGurus.NET - Studio 5000 User Defined Types (UDTs)
13:29
PLCGurus.NET
Рет қаралды 16 М.