Home : Lab Cal Spread Report Template Library
Q10713 - INFO: Lab Cal Spread Report Template Library

LABCALRescheduledSamples.hwr  Displays SampleNumber, Name, Original Date, New Date, and who rescheduled.  preview

MDL-Calc-Ongoing.hwr Used to calculate ongoing MDL (Method Detection Limit) using Spiked Blanks and/or Method blanks (i.e. the EPA 2016 revision of the MDL procedure).  preview

LABCALBarcodeLabels.ss3  LABCAL Barcode Labels Report  preview

Reports LABCAL selected samples as barcoded sample labels.  Displays Lab# as barcode, Lab# as human readable, and Sample Name.  Up to 14 selected samples can be reported at a time.  Report is preformatted for Avery 5162 laser printer label stock.  Note that user must install barcode font 3 of 9 on their WIMS client OS to utilize the barcoding feature.  Font can be found at: http://www.barcodesinc.com/free-barcode-font

Note that installation of template requires the user to load template, then set the report properties to specify the report type = COC.  This allows use from inside LABCAL right click sample block selection menus.  Re-locate of Prompt in cell F1 is required also.  User must unhide column F, locate new prompt in F1 with whatever text is desired, set prompt type to SampleID (Internal ID), check the box for comma separated list,press ... and pick a sample to test with, and hit OK button. Hide column F.  Save as report.

To use report from LabCal, highlight block of samples to report (up to 14).  Right click mouse inside of selected block to display quickmenu.  Select "Print COC" from quickmenu.  Select the name of the barcode label report (see above) and click OK.  Output result to preview screen or to printer.  Author: MGM 2008-02-26

LABCALSampSched.ss3  LABCAL Sampling Schedule Report  preview

Reports LABCAL sample schedule for selected month.  Displays Lab#, Sample Descrip, scheduled collection date and actual collection date/time.  Author: MGM 2008-02-05

LABCALOverdueSamples.SS3  LABCAL Overdue Samples Report  preview

Reports LABCAL overdue samples for current day.  Displays Lab#, Sample Descrip, scheduled collection date and notes (on 2nd page).  Author: SPD 2006-02-27

LabCal_Sample_Summary.SS3  LABCAL Overdue Samples Report  preview

Reports all (up to 256) variables that are linked to Labcal Samples/Tests. 
Displays: WIMS Variable Number, Variable Name, LabCal Sample Name, Test Name, and Corresponding Schedule information.
Author: GLS 2008-02-29

LabCalSampleOrder.hwr  LABCAL Sample Order

Displays the information for a sample (similar to a Certificate of Analysis, COA).  Set Report Type to "Sample Order" to make this report available on the LabCal right click menu. 
Author: SPD 2011-5-12

LabCal_COC.hwr  LABCAL Chain of custody report preview

Displays basic information for samples ready for collection (e.g. with SampleStatus = 0).  Set Report Type to "COC" to make this report available on the LabCal right click menu. 
Author: SPD 2012-8-24

LabCal-COC-AllStatus.hwr LABCAL Chain of custody report preview

Displays basic information for samples regardless of Sample Status. Set Report Type to "COC" to make this report available on the LabCal right click menu.
Author: SPD 2014-12-10

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/7/2008 1:14 PM.
Last Modified on 4/5/2022 12:13 PM.
Last Modified by Scott Dorner.
Article has been viewed 10614 times.
Rated 3 out of 10 based on 3 votes.
Print Article
Email Article