Open Source Visual Basic for Applications (VBA) Simulation Software

Transient pipe network analysis is a valuable method for the design and dimensioning of large solar thermal systems with regard to operational safety and efficiency . HP-BIG is a free Open Source tool written in VBA under Excel. It contains extendable catalogues for collector modules, pipes, and pumps. Large collector fields of several thousand square meter collector area can be modelled, with network topology in C- or Z-configuration. Stationary pipe network analysis is used to size pipe diameters and pump, and to decide which topology is favorable. Transient pipe network analysis is used to determine hydraulic and thermal time constants, the height of the temperature peak following a pump start, and the location and value of minimum pressure that occurs at pump stop. These values are needed for the dimensioning of pressure maintenance and to design modes of operation and control parameters.

Convert MCNPX binary mesh tally data files to MS Excel (c) database and contour data

HYDRA is an VBA/EXCEL program for pipe network analysis of large solar thermal plants with collector areas of several thousands of square meters. - Hydraulic solar circuits can be modelled in detail. The main capabilities are: - Stationary flow-, temperature- and pressure distribution of large collector fields are calculated under arbitrary boundary conditions - cost-effective pipe routing and pipe dimensioning - automatic generation of diagrams for documentation - Dimensioning of Drainback systems with atmospheric storage tank, including the following tasks: - Pipe dimensioning for proper venting - Dimensioning of overflow valve - Proof of dissipation capability by simulation of steam range - Dimensioning overflow valve