Downloads
The latest demo version 3.44 here
Videos
Manuals
A document describing ReviewSheet
A document describing the MassHunter Quantitation Data Set fields
What is it
ReviewSheet is another AddIn for MassHunter Quant. It contains 450+ Excel like functions. There are a handful functions to retrieve data from the MassHunter Quant batch in real-time. With conditional formatting it has all the power to improve reviewing. Another productive feature is bidirectional navigation. Click on the sheet cell will navigate to that sample/compound in MassHunter. And select a sample or compound in MassHunter will update sheet cells in milliseconds. Sample, peak and calibration graphics are available as well. It can be used for Review and Reporting. Reports can be created as PDF or as write protected Excel workbooks.
Use case
There are many use cases for ReviewSheet. Complex dioxin calculations are now possible.
Complex performance reports are made a lot easier. Fast reviewing of large and complete batches will make the lab more productive. etc.
Price
After 31 days a license file is required. Old data files will still work. And there is an early bird test time until Aug 31, 2024.
Price: 2250 euro per MS instrument. Training and co-development of review and report templates: on request.
Screenshots
History
| Date | Version | Fixed/Changed |
|---|---|---|
| 2024-02-19 | 3.2 | Edit tabs in Designer |
| 2024-02-20 | 3.3 | ArgumentNullException GetMostRecentUsedTemplateFileNames |
| 2024-02-21 | 3.4 | Allow users to enter text in unprotected cells before reporting |
| 2024-02-26 | 3.5 | Fix lockups |
| 2024-02-27 | 3.6 | Fix more lockups |
| 2024-02-28 | 3.7 | Report name is now Batch name |
| 2024-03-05 | 3.8 | Increase grace date to Aug 31, 2024 for early bird users |
| 2024-03-07 | 3.9 | Tool bar button Exit renamed to Exit Designer |
| 2024-03-13 | 3.10 | Navigate by value in cells on same column or row |
| 2024-03-25 | 3.11 | Fix crash after deleting or adding sample in the Batch |
| 2024-03-25 | 3.12 | Cosmetic fix |
| 2024-03-26 | 3.13 | Cosmetic fix |
| 2024-03-27 | 3.14 | New Define Report dialog to automate reporting |
| 2024-03-28 | 3.15 | Graphics scaling fixed when some column or rows are hidden |
| 2024-04-02 | 3.16 | Fix graphics printing in Excel |
| 2024-04-09 | 3.17 | Fix Batch name after batch save. Added defined print report |
| 2024-04-10 | 3.18 | Fix defined report for samples and compounds |
| 2024-04-18 | 3.19 | Cosmetic update |
| 2024-04-24 | 3.20 | Fix Defined Reports for Samples and Compounds |
| 2024-04-25 | 3.21 | Fix navigation |
| 2024-04-27 | 3.22 | Double click cell corner like Excel. New Mescius component version |
| 2024-04-29 | 3.23 | Improved logbook/function/values tabs |
| 2024-05-02 | 3.24 | Fixed QC. prefix, fixed double click on field names |
| 2024-05-03 | 3.25 | Reorganized toolbar |
| 2024-05-15 | 3.26 | Fixed defect installer |
| 2024-05-17 | 3.27 | Terrible bug in 3.26, it included 2 DLL’s from MassHunter 10.2. If installed on another MassHunter version, it will overwrite the 2 DLL’s and MassHunter will not work anymore. The DLL’s: BaseMsUtils.dll and QuantAppCmd.dll. Fixed in 3.27 |
| 2024-05-21 | 3.28 | Not recommended with MassHunter, but regional settings with a ‘;’ semi-colon list separator and with a ‘,’ comma as decimal separator is now supported in ReviewSheet |
| 2024-05-22 | 3.29 | Ignore if the same data file was added multiple times to the batch and write an error in the logbook |
| 2024-05-27 | 3.30 | Fix exception when formula editor is open while switch to user mode Set modified flag of a template after define report dialog change Option to require analyze and save batch prior report creation Peak fields: QualifiersPassed, QualfiersFailed Compound fields: CurveA, CurveB, CurveC |
| 2024-06-11 | 3.31 | Allow upgrade from QuantReview and use its licenses |
| 2024-07-29 | 3.32 | Support Quant version 9. Fix Fast Analyze for ESTD compounds. |
| 2024-07-29 | 3.33 | Update on checkbox click |
| 2024-07-31 | 3.34 | Added calibration level residual values. Allow multiple prefixes like: QC.QC.Peak.Accuracy to address the 2nd previous QC. |
| 2024-08-01 | 3.35 | CalculatedConcentrationByHeighestLevel. Disabled Quant version 9 support. |
| 2024-08-02 | 3.36 | Added HighestLevelConcentration and HighestCurveConcentration, etc. |
| 2024-08-02 | 3.37 | Fixed unlikely bug in CalibrationType in MH.Level function |
| 2024-08-05 | 3.38 | Fix crash after deleting a sample from the batch. Set FieldNames as the default tab in the Designer view |
| 2024-08-18 | 3.39 | Added MH.ByRowAndColumn function |
| 2024-08-20 | 3.40 | Improved expire date check |
| 2024-08-20 | 3.41 | Added PEAK.AboveCurve value |
| 2024-09-05 | 3.42 | Added menu item: Designer-File-Import Sheet(s) |
| 2024-09-24 | 3.43 | Show version number in License dialog |
| 2024-10-16 | 3.44 | Link Level table rows to samples based on data file name and folder name instead of the full path |