Category Archives: BREIN

Optoplex SQL spectrum scanner more flexible

We have made the import of measured traverse spectra from the Zeiss SQL database more flexible. Up to now the scanner processed all new spectra not analyzed by BREIN. In order to do so it sends an SQL search command to the Optoplex Q database filtering out spectra with IDs larger than the last processed ID,

You can now inject more search criteria into the SQL search command filtering in a more complex manner. In order to inject additional search conditions you have to add 2 lines to the optoplex_sql_spectrum_scanner,ini file, The first line is ‘Optoplex Q where phrase’ and the second line the injected SQL fragment. Here is an example:

Optoplex Q where phrase
and (measpointindex = 1 or measpointindex = 10)

When you re-start the scanner it will only process spectra recorded at measurement positions 1 and 10 – all other spectra are ignored.

Filtering results table

The table of results can now be filtered: You can type in a pane ID or select a bright eye (or both) and check the ‘filter’ option – the table will then show results for the selection only. Unchecking the filter option brings you back to the display of all results.

Optoplex spectrum scanner: New version

A new version of the scanner has been released. We have verified that this one can process reflectance measurements taken at 55° angle of incidence, in addition to the ‘normal’ transmission and reflectance spectra recorded at 8° angle of incidence.

Make sure that your BREIN product contains 4 spectra, and that you enter Optoplex names correctly in the conversion tables ‘BE assignment’ and ‘Spectrum nicknames’: Sometimes the database column ‘Resultname’ is ‘OFR155° SB Reflection’, and sometimes it appears as ‘OFR155° SB Reflection Glass’.

 

 

Inspection of historic fit results: New BREIN feature

The prediction feature of BREIN transfers the latest fit results and spectra to an internal CODE instance. This can be used to do various kinds of computations, based on the properties of the pane that was investigated last.

In a similar way the new ‘Inspection’ mechanism re-loads historic fit results (and the spectra that were used to obtain these numbers) to a separate CODE instance. This can be configured to let the operators verify the fit results and try what happens if some parameters were modified.

For details please see the updated documentation (page 55 at the moment).

 

ISO 52022-3 (2017) integration

The computation of the total solar heat gain coefficient (g-value) following the rules of standard ISO 52022-3 (2017) has been implemented. The procedure takes into account the temperature change of panes and gases due to absorption and re-emission of solar radiation. The absorbed solar power and the final temperature of each pane are side-results of the routine and are available in addition to the g-value.

Prediction page upgraded

The BREIN prediction page now forwards mouse clicks and mouse moves to the underlying CODE window. This opens the route to interactive operator work.

However, the prediction page of BREIN is updated every second only. This means the user interface is not as responsive as that of CODE itself.

New Optoplex SQL scanner

We have developed a new scanner software that connects the Zeiss Optoplex SQL system to BREIN. The program scans database tables for inline and exsitu spectra and feeds new spectra into the corresponding BREIN input folders.