The following spreadsheet was configured to display all available point attributes for CWSERV_VIRT, and to let the user perform a setpoint on that point.
The formulas that appear in cells R5C3 through R17C3 are:
|
R5C3 |
=cwserv|point!cwserv_virt.value |
|
R6C3 |
=cwserv|point!cwserv_virt.state |
|
R7C3 |
=cwserv|point!cwserv_virt.disp_format |
|
R8C3 |
=cwserv|point!cwserv_virt.eu_label |
|
R9C3 |
=cwserv|point!cwserv_virt.alarm_high |
|
R10C3 |
=cwserv|point!cwserv_virt.warn_high |
|
R11C3 |
=cwserv|point!cwserv_virt.warn_low |
|
R12C3 |
=cwserv|point!cwserv_virt.alarm_low |
|
R13C3 |
=cwserv|point!cwserv_virt.disp_high |
|
R14C3 |
=cwserv|point!cwserv_virt.disp_low |
|
R15C3 |
=cwserv|point!cwserv_virt.alarm_enabled |
|
R16C3 |
=cwserv|point!cwserv_virt.warn_enabled |
|
R17C3 |
=cwserv|point!cwserv_virt.init_state |
The following macro is the one associated with the Set button above.
set_point
channel=INITIATE("cwserv","point")
=POKE(channel,"cwserv_virt.value",Sheet1!R19C3)
=TERMINATE(channel)
=RETURN()
To change the setpoint, enter the new point value in cell R19C3, then click Set.
|
|
Sample spreadsheets and macros. |
