Skip to main content

Speed time and improve accuracy of your analytical results with OpenLab CDS

Calculations Done Your Way, the Right Way - Cut complex and error-prone steps

Custom calculations in OpenLab CDS allow you to reliably and automatically compute unique values directly within the software. This removes repetitive and error-prone calculation steps and allows you to leverage the traceability capabilities of the software. You can also display the values within the software or reports, which ensures they can be reviewed at the appropriate time for your lab's processes. Custom Calculator is the perfect alternative to spreadsheets because, it is:   

Agilent OpenLab
  • EasyEasy: Spend less time performing calculations and
    interpreting data.
  • VersatileVersatile: Perform any calculation while reducing dependency
    on third-party spreadsheets.
  • ReliableReliable: Ensure calculations are performed correctly in the software
    you use to optimize your results.
  • Secure & CompliantSecure & Compliant: Meet the data integrity requirements of GxP regulations with less effort.
Take a sneak peek at
Custom Calculator
for OpenLab CDS
Watch Now
Custom calculator enables fast review of multiple samples

Often analysts are forced to review results without the full context of the analysis. One example: evaluating a value within a report and then opening the originating data file to understand if an integration artifact caused the result. Embedding the calculation within the results data ensures it is available everywhere and that it is useful to the review process. This reduces context shift and ensures a thorough, efficient review of data.  

You can use these calculations to generate application-oriented results (such as NGA/RGA, or Dissolution) or quality-control statistics that reveal problem injections.

Custom calculations allow you to produce new values based on mathematical calculations of system-generated results. Calculations can be made peak-by-peak or across an entire injection set, and complex, multi-variable calculations are also possible. You can incorporate custom calculations into the processing method with a single mouse click.

Quickly see unique calculations correctly computed

This example shows the custom calculation “cumulative drug release” which is calculated entirely within the software based on drug concentration in the sample, sample volume, receiver volume and other values specific to this specific lab protocol.


The graph in this report plots a calculated value “cumulative drug release” for several different capsules over time. Custom calculated values are available for plot creation or further calculations.


Custom calculations can report a pass-fail criteria based on virtually any test. Here deviations beyond the lab’s limits are reported as pass or fail and automatically highlighted yellow to help reviewers identify out of spec results.

Here are a few ways you could use custom calculator
to speed time and improve accuracy: 
  • Perform any calculation based on any signal, peak, injection or sequence value using pre-built formula components.
  • Create logic based on built in summary calculations to highlight out of spec or interesting results.
  • Eliminate the built-in vulnerabilities of spreadsheets with audit trails to document your data production process entirely within OpenLab CDS software, and role based access restrictions that ensure calculations are not erroneously modified.
  • Use custom calculations as an integral part of a data governance and data integrity plan.
Ready to take custom calculations to the next level?
Did you know that Agilent provides custom solutions and consultancy services to embed OpenLab software into your workflows?

Learn how one of the largest pharmaceutical companies set their lab up for success with an automated purity workflow using Custom Calculator for OpenLab CDS. Read the technical note to inspire your custom calculator workflow.
Ready to talk to us?

Agilent OpenLab Software streamlines your information flow and eliminates the need to learn multiple software packages. Contact your local sales representative to learn more. We’ll answer your questions, explore the possibilities, and help you take your lab to a higher level.