Nice explanation but you make it sound like mapping in ST puts in the Description automatically when you import it from your spreadsheet. In fact at ~9:30 in the video you even comment about having to create the Description by hand if all those same tags were created in Ladder Logic. But, looking closely at your video, when you went into Controller Tags the Description column was still blank. So, while I do see some time saving advantages, it is still required by the Programmer to Right Click and Create any new tags, confirm the Scope and add a Description.
hye. nice vid.can I say this is the same method as we would do for analog? The following formula is used to convert analog values: Scaled value = (Input value * Rate) + offset Where: Rate = (Scaled max) / (Input max - Input min) Offset = Scaled min - (Input min * Rate) Meaning of individual variables: Scaled value - in physical units Input value - The current value at the analog card input Rate - The conversion constant Scaled max - Maximum value (in physical units eg 100bar) Scaled min - Minimum value (in physical units eg 0bar) Input max - Maximum unit on the analog card input (32767) Input min - Minimum unit on analog card input (0) Offset - Correction of recalculated value
Nice video 😊
Nice explanation but you make it sound like mapping in ST puts in the Description automatically when you import it from your spreadsheet. In fact at ~9:30 in the video you even comment about having to create the Description by hand if all those same tags were created in Ladder Logic. But, looking closely at your video, when you went into Controller Tags the Description column was still blank. So, while I do see some time saving advantages, it is still required by the Programmer to Right Click and Create any new tags, confirm the Scope and add a Description.
hye.
nice vid.can I say this is the same method as we would do for analog?
The following formula is used to convert analog values:
Scaled value = (Input value * Rate) + offset
Where:
Rate = (Scaled max) / (Input max - Input min)
Offset = Scaled min - (Input min * Rate)
Meaning of individual variables:
Scaled value - in physical units
Input value - The current value at the analog card input
Rate - The conversion constant
Scaled max - Maximum value (in physical units eg 100bar)
Scaled min - Minimum value (in physical units eg 0bar)
Input max - Maximum unit on the analog card input (32767)
Input min - Minimum unit on analog card input (0)
Offset - Correction of recalculated value