I developed a fully configurable HTML reporting framework that made it possible to develop and operate custom reports efficiently.

This made it possible to move beyond static output and provide interactive, high-performance reporting.

In 2018, the migration from LabWare 6 to LabWare 7 took place. Large amounts of existing LIMS Basic logic had to be analyzed and adapted to the V7 rules.

To support this, I developed a LIMS Basic code comparison tool based on Node.js.

Contact: janus@speth-solutions.de

Modern LIMS systems need to do more than simply manage laboratory values. User acceptance and decision support depend on strong visualization and good integrations.

• Improved visualizations directly in the LIMS
• Context-specific cross-links to external systems such as Spotfire
• Integration of a D3 diagram into visual workflows
• Consistent use of the HTML reporting framework

I developed a fully XML-configurable CSV import interface for heterogeneous data sources.

• Siemens Rapidlab
• Sartorius AMBR (various types)
• Department-specific Excel sheets

I implemented macros for calculating test components in several biopharmaceutical process templates. A subroutine framework enabled more modular and maintainable macro calls.

For copying "PROJECT" entities, I implemented granular control:

• Retaining field contents
• Clearing field contents
• Resetting field contents
• Conditional logic for copy rules at SAMPLE / TEST / RESULT level

For production-related scenarios, an extension was developed to fully control programmatic access to ProdSpec-to-Result mappings.

Since standard calculations only propagate in-sample calls, a cross-sample calculation framework was built in order to:

• enable more flexible calculation propagation
• process cross-sample parameters robustly