TRNSYS - Excel link example
Note: Before running this example, you
should modify your TRNSYS DLL to include Type62, as described in the
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
- 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
- You can make excel visible or not by
changing the value of parameter 3 in one of the Type62 units.
Schedule.xls includes 3 cells for which a name
has been defined: Input1, Output1 and Output2. Both outputs are calculated using
the VLOOKUP function
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.
Comments, Questions? Please contact
Jochen Wriske & Markus Oertker
Lehrstuhl für Technische Thermodynamik, RWTH Aachen
Solar Energy Lab, UW-Madison