HOW TO LINK TIA PORTAL WITH EXCEL | PLC TO EXCEL COMMUNICATION | TIA PORTAL TO EXCEL COMMUNICATION

okay i'm going to double tap here and you can see  the value and i'm changing the value from here and   you can see the updated value after one second so  this is the excel communication if i want to make   it zero i'm going to make it 99 and hit enter the  value will be updated to the hmi and the dlc also   i am changing it to 0 and then the motor will be  off automatically that is the excel communication   and here on the runtime you can see the speed  will be updating over here and i'm going to   insert the m0.0 and you can see it is one and by  clicking it is zero and by changing the speed you   can see 44 i am hitting and then you can see  it is 44 and if you want to change from here   i'm going to change it as 68 and hit  enter you can see the 68 will be up hello all today we are going  to learn how to connect the ta   photon simulation with the excel and also  with hmi so i am going to the plc tags first   to show all tags and i'm going  to add a new tag that will be tag 3. i'm already using the m0.0 and q0.0 tag two  tags one will be the memory and another one will   be the actual output and i'm using an integer  tag that would be m w c mw two so mw2 is my   individual tag and these are to my boolean tags  so i'm going to create an hm screen over here so i'm going to create another  screen right here and you can see the   simatic comfort panel i'm using  a nine inch panel and hit okay and first thing is to connect with the  plc so i'm just connecting as the plc one   and hit enter and that will be connected to the  ethernet and just i'm clicking the finish button now i just configured my root  screen for the hmi and i'm going to   run my plc program so go to the main block  and i'm going to start the simulation first and by starting the simulation you can see have  to check this for plc sim tcp or ip to be sure   for the future configuration with the xl so you  can see the pn or ie the profinet or industrial   ethernet you have to select and the plc simulation  i'm using if you're not using the simulation you   can use the other interfacing cards the drivers  also so i'm going to load my plc program and i have to load it so that has been loaded  and have to go to the check whether it is plcc   and to go for the monitoring mode this time and now we are actually on the monitoring  mode you can see on the orange screen that   will be how we are on the monitoring screen  if you want to run this you can go for the run   and you can see you can make it make this m0.0  on and off on and off this is the honor note   control and i'm going to minimize this and  going to create my html screen right now   go to the root screen from here i'm  going to the root screen this is my   itunes screen and i'm going to use one  switch and the light and the slider also   so this is my switch i'm using switch for  starting the motor so and this will be my   motor that will be showing the on and off control  and this will be the slide that will be used for   controlling the speed of the motor so this will  be the i o field for showing the speed so this   is these two are the digital inputs and zero dot  zero and q zero zero and this will be showing the   speed in the mw to initial memory so i'm using go  for the properties for the switch and you can see   on the general properties you have to use the  plc tag so go to here and go for the plc tags   tag table and this will be the first boolean that  will be the m0.0 and i have to choose that tag one   and hit ok so this is my tag one and i'm going to  configure my light go for the properties and go   to the animations and inside the animation you  have to go to the dynamics colors and flashing   i have to select this and go for the name tag me  inside the tag name that would be q0 that will   be the light or the digital output i'm using for  the motor so during this time the range will be   like this i have to give the range from here for  the tags to q0 the on and off range will be zero   and one have to double click and have to select  the appropriate colors for the all file load   conditions and using the red for roof condition  and using the green for the phone condition   so let's just configure this on button from the  light and switch the boolean control is okay and   i have to go to the properties of the slider and  inside slider i can go for the properties in the   general you can see the process tag the process  tag is the thing that i have varying on the slider   so the tag three that will be integer i'm just  selecting in the default tag table and okay and   for the value display also the tag will be the  tag three the process tag will be the same tag   to show the speed so these are the two things  that i am using and i can go to the simulation   for the checking whether it is  the correct or not i have to go and hit ok and this is my it's my root screen and you can  see i'm going to double tap on the switch and   the light should be on and by changing the speed  you can see the value will be changing and let's   check the simulation also to cross check whether  it is working with the dlc or not so this will   be the mb0 and mw2 that will be working you can  see on this picture in this picture you can see   when the switch is on you can see the memory  which will be also in the city so that will be   good and the speed will be varying from here also  if i want to increase the speed i am using the 38   speed and that you can see that will be hm screen  also the speed will be changing and i'm going   to hit close this dot and i'm going to minimize  this and also i'm going to take the plc program   and now we are going to the real  configuration for the actual communication   so first thing i am going to go for the net to  plc in software so go for the net plc net to   plc same i'm going to right click select it and  right click and you have to run this thing as an administrator tts and for during the  first time use i'm going to add a new user   plc one will be the thing the name and the  network type address i'm going to click here   and this will be default this will be my network  id for the pc i'm just going to copy this ctrl c   just copy this network type address and  the plcc my purpose i have to choose   by here that will be by default 192.168.0.1  by default and hit ok and i have to start my   server right here finish so just start my server  for the plc sim and next thing i'm going to the   cap server the cab server is the opc server i'm  using for fetching the opc details or opc data   from the plc and to share with any other  software's like excel microsoft access and extra   so this is my kept server configuration i'm  going to show you how it can be configured first   i'm going to the file after loading this cap  server can go to the files because cap server took   some time for uh loading and create a new project  and yes an update i have to give can update in the   online mode so first thing i am going to add a  channel first thing is that to create a channel   to select this cell i can go for the s type s and  you can see the siemens tcp or ip ethernet i have   to select the siemens tcp or ip the net and hit  next and the name i am going to add the channel   world and hit next and network adapter i can  choose the default next everything will be next we   don't have to change anything and just finish this  so channel 1 has been created and i have to go for   the creation of the device first i have to use a  device the name will be the device name will i'm   just using the plc plc will be in my device and  hit next and i'm going to use the s7 300 server   and this is my model as upgrader and i can choose  various devices i'm using the sf drainwood model   and next and the ip address ips i have to select  the same from here you can see a plc next to   this using the 168.254.36.133 this is my  appearance of the network address they have   to give the same control v i just copied and  pasted it same here okay and how to see it next   and next next next next everything here next and  i'm going to finish this so i just created the uh   device also and i'm going to give the overplay  the tags here so the first tag will be the digital   or the on off motor motor one oh no  so this is my name of the tag and   what the address that i am using in the ta portal  which is m0.0 for the turning on end of the model   that will be q0 so i'm using the m0.0 here  m0.0 here and hit ok so that's fine that's   clear let's just create a new tag and i am going  to add another tag that will be speed control speed control and this will be the tag will be  mw 2. i am using the mw2 for the speed control   you can see in the plc tags so this might i just  created the third type as an integer that will be   mw2 so i'm using the mw2 here also mw2 that will  be the data type will be word so i'm using word   as an data type and hit okay first thing will be  the boolean because it is m zero dot zero it's   an on off control so that's why it's boolean  and we just created the channel one for plc   and we can go for hit the run type  before uh check the connection is correct so just go to the q client from here and open the  quick line and it can go to the channel bone plc   here you can see the word is 38 and the  boolean is zero now the channel quality is good   if you are not using this simulation net to  sim i'm going to stop the server you can see   the sound quality become bad okay again i'm  starting my server you can see the channel   quality is good because the this is the net  pl system it's the one who creating the server   for the ethernet to create the server for the plc  simulation so the jump quality is good you can see   the channel quality by changing the overland of  control for the boolean here also or by taking   on you can see the boolean will be one and by  changing the value in the mw2 you can see 30   or 48 uh 78 i'm using and hit enter you  can see the 78 will be appeared here   so the channel quality is pretty  good and i'm going to close this   and i'm going to create one more challenge  for the excel communication so go to hit   the connectivity and add a new channel and  they have to use a dd communication channel dd client i'm going to use and hit next the  channel too i'm going to name it as the excel   exel for the excel first one will be the plc and  second one will be the excel so hit next next   next everything will be next is created in  excel channel and i have to go to the add a new   device device i'm going to add will be  also the device name will be excel exel   excel and this second again  give any name it's not important   and it just started as an excel then inside  the excel i have to add a new static tag   that will be first tag tag one for the on off  control on off control that will be a boolean tag   so address will be e x c e l this address  is important you can see i'm sorry   in the caps e x c e l and this line bar uh sheet  one capital sh e t one and an exclamation mark   r one c one row one column one on the first row  and first column it is writing the one of control   okay so hit okay and that could be a  read and write an excel sheet that has   been created the data type will be will  not be double word i have to change it as   a byte or a boolean you can see the boolean over  here boolean apply and okay so just created one   of control for the excel and also i have to  create the speed control for the xl so speed   speed for the excel and i'm  going to add new address here   that will be also sheet sorry excel px cel bar sheet1 exclamation mark r1 c2 row 1 column 2 and  that will be a word that will be word memory   i'm using and hit ok so this will be word and  this will be boolean in the plc itself that one   will be boolean second will be but this is for  the plc and this is for the excel communication   so we can check that quality by going to the  queue client so here you can see the excel   dot xl you can see that quality is pretty bad here  the speed control is bad i can check during the   run time okay i'm just closing this and i'm going  to run the i'm going to link these two tags for   the excel communication so that's why i'm going to  the advanced tags click a new addons tag and i'm   going to link these two tags i'm going to create a  link from here and the input and the output first   thing i am going to make the input from the plc to  the accept so input will be you can see from plc   the motor speed control boolean and apply  and the output will be go for the accent   motor speed control on and off and apply so i  just created the linguanas plc to excel or off plc to excel on off control i just created the  plc to accelerate control and apply and okay   so this is for writing the values from plc to  excel and i am going to create a new link for   name as excel to plc or excel to plc off control and the input  will be from excel so input will be from excel   on off apply and the output will be at the  plc plc moving on and apply apply and okay   so just created two tags and then i have to  create the new link for the speed control   so the input will be at from the plc speed and  apply and the output will be the excel speed okay   so that name will be plc to xl speed  you'll see to excel speed and apply lk   so again i have to create a new  link that will be excel to plc speed excel to blc speed the input will be  excel speed and apply and the output will be   plc speed and apply and if i had okay so we  just created four links for the plc speed and   for the right hand rate control and  i'm going to minimize this sorry   i'm going to check whether the condition is  okay so the string the quality is very good and   you can see this is my advanced tags you can  see the quality is very good for each of them   and i'm going to take the excel sheet from  here excel and i'm going to open pixel   and you can see this will be my excel  sheet and i'm going to put it over here and i'm going to check whether the speed  is happening over the simulation or not so you can see these things here on the runtime  you can see the speed will be updating over here   and i'm going to insert the  m0.0 and you can see it is one   and by clicking it is zero and by changing the  speed you can see 44 i am hitting and then you   can see it is 44 and if you want to change from  here i am going to change it as 68 and hit enter   you can see the 68 will be updated over here  and if you want to start motor from here i   am going to hit one and enter and you can  see the m0.0 will be odd so the simulation   is working pretty good and we can go for the  plc and you can see the plc section over here   so you can see all this stuff i can go to the  main program here on the main program right now and you can see these things the m00 will be on when the slider is the excel  is communicating i'm hitting zero you can see   the plc will be good and we can go to the hms  screen right here i'm going to the hmx screen by   launching it and go to the hmi screen root screen  from here and i'm going to run the simulation so i can control the hms string with  the excel and simultaneously also so this is my atomic screen and  i'm going to minimize these things so this will be my hmi screen so i'm going to reduce the size of the excel  and increasing the size of the hma screen and   you can see i can control the motor from the excel  also okay i'm going to double tap here and we can   see the value and i'm changing the value from here  and you can see the updated value after one second   so this is the excel communication if i want to  make it zero i'm going to make it 99 and hit enter   the value will be updating to the hmi and the  dlc also i am changing it to zero and then   the motor will be of automatically that is the  excel communication and keep in mind if you want   we are not using the simulation you don't have  to do this step yeah the net to plc same if you   are not using the simulator you have to avoid this  if you are using the simulation you have to do it   for sure because otherwise that will be  working so hope you understand this video and   thank you thanks for watching

Channel: Eight Min Automation

Views: 29,793

Keywords: HOW TO COMMUNICATE SIEMENS TIA PORTAL TO EXCEL, HOW TO CONNECT EXCEL WITH TIA PORTAL, HOW TO CONNECT SIEMENS PLC WITH EXCEL, HOW TO CONNECT S7 300 WITH EXCEL, SIMATIC HMI TO EXCEL COMMUNICATION, SIEMENS TO EXCEL, HOW TO LINK EXCEL TO SIEMENS PLC, HOW TO CONNECT EXCEL TO TIA PORTAL, HOW TO SHARE PLC DATA TO EXCEL, HOW TO GET EXCEL DATA ON SIEMENS PLC, TIA EXCEL COMMUNICATION, SIEMENS EXCEL COMMUNICATION, excel tia portal, tia portal excel communication

Id: pc0qiAhEzog

Length: 22min 50sec (1370 seconds)

Published: Sat May 01 2021