Excel Template Report Disclaimers

Q: “Where is the best place to put a note on an export template such as ‘BDL-Below Detection Limit’?”

A: It depends on the Excel template. If the template’s AfterTransferFromLIMS macro inserts new rows before it copies a OneAnalysisResults or OneSampleResults named range then you can put a disclaimer anywhere below these named ranges on the report worksheet. If the template has a SignatureBlock named range on the Settings worksheet then you should put the disclaimer within the SignatureBlock named range making sure the named range encompasses any new rows. When a template has a SignatureBlock named range, its macro does not insert new rows before copying data named ranges on the report sheet.