backendcode
Member
Hello Everyone,
I work for a company who builds a machine for the automotive industry. Recently, we build a new line at the plant but the line can't achieve the production goal and that company blaming the automation. so what I am trying to do on this line is find a cycle time, robot wait time (Robot waiting for the raw part), machine fault time and all the other valuable information.
I am able to get the information with my PLC, I have calculated the cycle time, robot wait time etc etc but now I want to get that information and put on the server or excel so we can have a history of data and make analysis with recorded values.
My question is what is the best way to do it?
should I connect excel file to RSLINX OPC server and record that value? but then I need to write VBA script to record new values coming from a tag.
or is there any other easiest way to do it and store the tag values of information I needed so I can analyze that data.
I would appreciate your help and feedback
Thank you,
I work for a company who builds a machine for the automotive industry. Recently, we build a new line at the plant but the line can't achieve the production goal and that company blaming the automation. so what I am trying to do on this line is find a cycle time, robot wait time (Robot waiting for the raw part), machine fault time and all the other valuable information.
I am able to get the information with my PLC, I have calculated the cycle time, robot wait time etc etc but now I want to get that information and put on the server or excel so we can have a history of data and make analysis with recorded values.
My question is what is the best way to do it?
should I connect excel file to RSLINX OPC server and record that value? but then I need to write VBA script to record new values coming from a tag.
or is there any other easiest way to do it and store the tag values of information I needed so I can analyze that data.
I would appreciate your help and feedback
Thank you,