TRNSYS - Excel link example

Note: Before running this example, you should modify your TRNSYS DLL to include Type62, as described in the Type62 manual.

This simple example illustrate the use of 2 Type62 units in a simulation. Outputs from the two units are simply plotted in the online plotter.

The first unit (type62-excel schedules) receives the hour of the day from an equation and generates two different profiles using simple table lookup (similarly to the forcing functions in Type14)
The second unit (type62-excel mouse position) uses a Visual Basic macro and Windows API calls to get the vertical position of the mouse and send it (scaled between -1 and 1) to the online plotter.

Simulation parameters

You can make excel visible or not by changing the value of parameter 3 in one of the Type62 units.

Excel workbooks

First unit: Schedule.xls

Schedule.xls includes 3 cells for which a name has been defined: Input1, Output1 and Output2. Both outputs are calculated using the VLOOKUP function

Second unit: Type155-efficiency plot

MousePos.xls only defines one input and one output. It uses a Visual Basic macro to get the mouse position. The macro can be viewed by pressing ALT-F11.

An example of the online plotter is shown in the figure here below. The "MousePos" variable will vary according to the position of the mouse during the simulation.

Example results

Comments, Questions? Please contact type62@ltt.rwth-aachen.de

Authors:
Jochen Wriske & Markus Oertker
Lehrstuhl für Technische Thermodynamik, RWTH Aachen

Editor:
Michaël Kummert
Solar Energy Lab, UW-Madison
2003-07-23