Review for MassHunter and reporting
Double click on the icon and run setup Double the efficiency of your MassHunter data reviewer
Review and document the following time consuming tasks Sequence quality checks Calibration quality checks Sample quality checks Sample results Sequence results Compound results Instant and validated transfer to secured Excel workbooks
No more copy-paste error No more typing errors Securely locked report workbooks Securely locked PDF reports Signature ready reports Freedom to design any template in Excel Password protect the validated templates Example Applications Average multiple samples in one report
Visual subtraction of blank runs Correct concentrations by QC recovery Calculate with RF of any other compound Statistics of compound in a sequence Use Excel to organize your high throughput reviewing And create reports fast Flexible template design
Insert starter example tables MassHunter Excel functions Fully customizable Install Add-in Quick Start Load a MassHunter Quant Batch Open a new Review Template Sample Header in B3 Compound Table in B9 Resize All Columns Click in upper left corner to select all cells
Double click on line between A and B Hide Rows and Column Type HIDE in 4 cells Compound Link Select column B and click Compound Link Conditional Format Select Amount Cells I11:I84 Setup Page Layout Margin Narrow Orientation Landscape Size A4 Width 1 Page Rows to repeat at top $2:$10 Exit Design Mode Optional enter a password to protect the design of the Template Save Template Preview Report Click on sample in Quant Instant update in Review Click on compound in Review Instant navigate in Quant Manual Integrate and Save Instant update in Review Prepare for report Design mode Page layout Margins=Narrow Orientation=Landscape Size=A4 Width=1 page Print titles Header and Footer View Page Layout Insert header text and page numbers View Normal Layout Report Exit Design Mode and save the template Try Preview Report Report Current Sample Explore Report Report All Samples Report All in one Advanced Excel Variables =SampleID =CompoundID Current MassHunter sample
Current MassHunter compound MassHunter Excel Functions Field Browser Table Functions MH.BatchInfo MH.Batch MH.TargetCompound MH.Peak MH.Calibration MH.TargetQualifier MH.PeakQualifier Read MassHunter Quant DVD 1/2 \Additional\Schema\QuantitationDataSet_B_07_01.docx Learn about Quant Tables ID Functions MH.SampleIDByName MH.CompoundIDByName MH.LevelIDByName Tables in MassHunter are linked by ID Use this function to obtain the ID from a name Read MassHunter Quant DVD 1/2 \Additional\Schema\QuantitationDataSet_B_07_01.docx Learn about Relational DataSet Two ways to extract multiple rows
Table functions require IDs By fixed names By array function Names Functions MH.SampleNames MH.CompoundNames MH.LevelNames
Learn about Array functions Excel Array Functions MH.Match Function Use regular expression pattern to filter table rows
Excel Array Functions MH.Lookup Function Use C# string.Format notation to build a table row Select Filter This are Excel Array Functions Transpose This are Excel Array Functions MH.Interval Excel Array Functions HideIF Functions HideIfError HideIfFalse HideIfBlank
Expand Sample list for batches with more samples Hidden Rows and Excel Subtotal
Design mode Review mode Combine tables with different columns widths on one sheet
Sample Header and Compound Table on one page can cause a conflict with different columns widths Solution Put Sample Header on separate sheet Copy Sample Header cells as on to Compound Table sheet Linked Picture Use right click on Sheet Tab to hide Sample Header sheet Reviewer Comment Select cell range, merge, border, text alignment, protection=unlocked Design mode Review mode Add comment and Report Current Sample Hide sheet from Report Hide the tab Or name a cell ADDTOREPORT and set/calculate the value of that cell to FALSE Training, Licenses, Updates