RTD function
Retrieves real-time data from a program that supports COM automation.
Lookup and reference · Guided Excel example
Where can you use it?
Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.
Scenario in the workbook
Use a registered COM server. Replace the example ProgID and topic fields with the provider’s values.
A worked example from the workbook
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Second input | Third input |
| 7 | Your.RTD.Server | Temperature | Line1 |
| 8 | Your.RTD.Server | Temperature | Line2 |
| 9 | Your.RTD.Server | Pressure | Line1 |
Record 1
=RTD(A7,,B7,C7)Illustrative outputServer value
See the inputs and instructions for all 3 examplesWorked examples
Use a registered COM server. Replace the example ProgID and topic fields with the provider’s values.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B | C |
|---|---|---|---|
| 6 | Input | Second input | Third input |
| 7 | Your.RTD.Server | Temperature | Line1 |
| 8 | Your.RTD.Server | Temperature | Line2 |
| 9 | Your.RTD.Server | Pressure | Line1 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =RTD(A7,,B7,C7) |
Server value |
| Record 2 | =RTD(A8,,B8,C8) |
Server value |
| Record 3 | =RTD(A9,,B9,C9) |
Server value |