What's New Unreplied Topics Membership About Us Contact Us Privacy Policy
[Ad]

Does anyone use a specialized software to input data from lab tests?

Started by , Dec 27 2023 10:55 PM
4 Replies

Does anyone use a specialized software to input data from lab tests? I'm trying to decide if building my own spreadsheets in excel is just as good as getting a software that costs thousands of dollars. Thanks!

Share this Topic
Topics you might be interested in
Can Data Cutoff Dates Differ for Audits vs. Internal Analysis? Recommended Micro Tests for Pastes and Fermented Batter Products Random high TVC results in otherwise clear micro tests? Cooling CCP Data Gaps Due to Logger Errors – Is Historical Data Acceptable? Best Temperature Data Loggers for Monitoring When Facility is Closed
[Ad]

We use Google sheets and it does the trick

1 Thank

Nothing special for me and the 9 different facilities I monitor and trend lab data for through FSNS.  They have an online portal that can spit out some interesting graphs on the fly, but I live in their raw data downloads.  Throw the data into an Excel table each month, then use separate sheets with pivot charts and timelines and whatnot to filter one sheet for our listeria results and another to check the APC from post-sanitation verifications.  I do have to clean up the APC results in the main table each month:  make sure they'll all 'numbers' in Excel's mind, remove the < and > signs and the Est. on occasion, but it only takes a few minutes to clean the data.

1 Thank

Nope.  Some excel-fu turns the data into charts and heatmaps sufficient to do trend analysis.

You need to make sure they are compliant with Part 11 if you are within the scope of the regulation.  https://www.ecfr.gov...apter-A/part-11

 

If it is a closed system, then you need to have audit trails, operational system checks, etc.  This is why software you use for data needs to be Part 11-compliant.


Similar Discussion Topics
Can Data Cutoff Dates Differ for Audits vs. Internal Analysis? Recommended Micro Tests for Pastes and Fermented Batter Products Random high TVC results in otherwise clear micro tests? Cooling CCP Data Gaps Due to Logger Errors – Is Historical Data Acceptable? Best Temperature Data Loggers for Monitoring When Facility is Closed Validating Seaming Parameters as an OPRP – What Tests Are Needed? Lab Accreditation Issues – Can a Lab Perform Tests Outside Its ISO Scope? Missed Gluten Tests Due to Supply Issues – Does This Require a Non-Conformance? What software do you use for your HACCP flow diagrams? Testing for Ambient Storage of RTE Dips & Sauces – Are These Microbiological Tests Sufficient?