Niels Waleson - Leoson - Laboratory Automation Engineer

Home - Niels Waleson - Laboratory Automation Engineer

Review for MassHunter

Powerful Excel functions

A training or experience with Excel functions is required

Value functions

= MH.BatchInfo( ReturnField )
= MH.Batch( ReturnField , SampleID )
= MH.TargetCompound( ReturnField , SampleID , CompoundID )
= MH.Peak( ReturnField , SampleID , CompoundID , PeakID )
= MH.TargetQualifier( ReturnField , SampleID , CompoundID , QualifierID )
= MH.PeakQualifier( ReturnField , SampleID , CompoundID , QualifierID , PeakID )
= MH.Concentration( ReturnField , SampleID , CompoundID , LevelID )

FinalConcentration for Benzene in the current MassHunter Sample
= MH.TargetCompound( "P.FinalConcentration" , SampleID, MH.CompoundIDByName("Benzene") )

Array functions

= { MH.Match( Table , ReturnField , SortField , FilterField , FilterPattern ) }

SampleID list of QC samples, sorted by acquistion time
= { MH.Match( "Batch" , "SampleID" , "AcqDateTime" , "SampleType" , "QC" ) }

Excel functions

MH.Match

Samples

Sample name

Smarter

More samples? Rows will be visible instantly.