C_Vid_User_Srt_CrossW.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 140G0223R0001
View the file
Other files
Show all 31
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Video User Story Crosswalk
| RFP 140G0223R0001 LIMS Solution |
| Attachment C - Video User Story Crosswalk |
| Video component | User Story Number | User | Action | Value |
| 1 | 196 | Lab Manager, Login User | I need the ability to pull reports (Excel formatting) for login that contain: 1) Sample load at the Lab Code level broken down by Lab Code, Logins, associated cost that total the amounts logged each day (by Fiscal Year) and that total the amounts for a given Julian day, and 2) the total number of Lab Code level logins for all Proposals entered into the system broken down by Proposal, Logins, Account number for each Julian Day | So we have information for sample tracking, building price lists based upon trends of previous years, tracing incoming samples with incoming funds, and for workforce planning |
| 2 | 91 | Lab Analyst | I need to generate runs associated with a relevent number of relevant samples in my queue by a predetermined priority, be placed in logical order, and be prepopulated with QC relevant to the method and instrumentation as necessary. Special QC requirements (ex. EQAP) should also be accommodated | So an analyst can quickly generate a daily workload for themselves |
| 2 | 93 | Lab Analyst | The LIMS will need to interface with whatever scheme is in place (or generate a new/comparable scheme) to capture data output from instrumentation for upload preferably by direct instrument communication or with a (data capture unit) or .csv file | So manual entry into LIMS is minimized |
| 2 | 105 | Lab Analyst | I need to be able to create analytical runs in LIMS that are uniquely named, contain samples identified by several factors (e.g., due date, instrument availability, project, or other customized criteria), and be able to change the sample order to create any desired order or sequence | So that I have the foundation of what I will use to eventually report results |
| 2 | 106 | Lab Analyst | I need quality control samples defined within LIMS that I can insert into the created analytical run either manually or by template | To ensure that the required QC specified for a given analysis or project is present in the analytical run |
| 2 | 108 | Lab Analyst | I need LIMS to be able to generate a report in the format my instrument software accepts in order to build a run sequence operable on the instrument | To save time and reduce errors when building an instrument sequence manually |
| 3 | 121 | Lab Manager | I want my LIMS system data to be exportable in open, machine readable formats | So I can integrate data in various manners with other WMA systems, migrate the data to a future LIMS solution, and create backups |
| 3 | 185 | Lab Analyst, QA User | I need the ability to add a comment that can remain internal to the lab or have the option to release to the customer | To communicate non-conformance to customers if needed, or allow for internal comments to be tracked by the lab but not released |
| 3 | 186 | Lab Analyst | I need the ability to add a comment to the individual result/analyte and/or to the sample as a whole | So that comments can be associated with any and all levels |
| 3 | 203 | Lab Analyst | I need the ability to apply the same comment at the "result" level to multiple analytes within the same sample | To save time and ensure continuity across publicly visible comments |
| 3 | 210 | Lab Analyst, Lab Manager, QA User | I need to have predefined comments that can be applied at the result and sample level | So that comments can be consistently applied |
| 3 | 211 | Lab Analyst, Lab Manager, QA User | I need the ability to customize comments when a predefined comment does not capture all relevant information | So all appropriate information can be communicated to the customer |
| 3 | 215 | Lab Analyst | I want to add lab comments at almost any point of the work flow | To document why something failed in order to inform the field |
| 4 | 33 | Lab Analyst | I need to be able to enter QC limits and pass/fail/qualify data based on whether QC has passed or failed | To document consistent and traceable data quality |
| 4 | 62 | QA User | I need the ability to complete internal logic checks for Quality Control and trigger automated requests for re-analysis when logic fails (e.g., filtered > whole water, orthophosphorus > phosphorus) | To ensure data quality and trigger reanalysis withing hold time |
| 4 | 220 | Lab Manager, QA User | I need to ensure all analytes in a report group (e.g., nutrients or major cations/anions) have been determined before logic checks can be completed and data released to customers | So that all data is available for calculations |
| 5 | 16 | Business Analyst | I need LIMS to produce billing reports that can be uploaded to FBMS upon data release and at a desired frequency | So that billing can be executed at the Reston level per IF120 format |
| 5 | 26 | Field User | I need to be able to obtain QA/QC data upon demand (FOIA, posterity) | so that we can optimize lab personnel time |
| 5 | 51 | QA Manager | I need to generate control charts with correct formatting in near-real time (duplicate of line 49) | To monitor analytical performance |
| 5 | 52 | QA Manager | I need to document approved Detection and Reporting levels, including historical ones, for each analyte-method pair | To be able to do trend analyses, to revisit analysis DQIs, and to satisfy the requirement in the NWQL QA/QC Manual |
| 5 | 56 | QA Manager | I need LIMS to maintain control limits for recovery, sensitivity, and accuracy using CCVs | To assess pass/fail of data and to satisfy the requirement in the NWQL QA/QC Manual |
| 5 | 140 | Field User | Simple 'Sample Status' page that provides all analyses in a single table with links to individual results and QC information associated with a given environmental sample | To make lab QC accessible to the field |
| 5 | 141 | Field User | I need ability to retrieve contract lab QC results for given environmental samples in a simple manner, perhaps by station, time frame, analyte group, etc., and preferably in bulk | To increase efficiency |
| 5 | 142 | Field User | I need the ability to retrieve USGS Lab QC data for related environmental samples, including IBLNK, ISPKE, etc. that are readily exported that is also tied to the NWQL QC pages and has tags for easy comparison | To increase data consistency across NWQL-served pages and provide more information to the field to facilitate data interpretation |
| 5 | 51 | QA Manager | I need to generate control charts with correct formatting in near-real time (duplicate of line 49) | To monitor analytical performance |
| 5 | 52 | QA Manager | I need to document approved Detection and Reporting levels, including historical ones, for each analyte-method pair | To be able to do trend analyses, to revisit analysis DQIs, and to satisfy the requirement in the NWQL QA/QC Manual |
| 5 | 56 | QA Manager | I need LIMS to maintain control limits for recovery, sensitivity, and accuracy using CCVs | To assess pass/fail of data and to satisfy the requirement in the NWQL QA/QC Manual |
| 2,3,4,5 | 59 | Lab Analyst | For some analytical lines, I need a template-based system in LIMS to 1) automatically add requisite QC samples to a run, 2) generate QC charts, 3) do data capture that minimizes acceptance of improperly formatted or inaccurate data, 4) does automatic logic checks (ion balance, etc.), 5) calculates and applies consistent rounding and censoring, 6) does certain error corrections, and 7) flags data that is outside specifications | To improve analytical ease and efficiency, ensure acceptable results are entered into LIMS, and to satisfy the requirement in the NWQL QA/QC Manual |
| 2,3,4,5 | 59 | QA Manager | For some analytical lines, I need a template-based system in LIMS to 1) automatically add requisite QC samples to a run, 2) generate QC charts, 3) do data capture that minimizes acceptance of improperly formatted or inaccurate data, 4) does automatic logic checks (ion balance, etc.), 5) calculates and applies consistent rounding and censoring, 6) does certain error corrections, and 7) flags data that is outside specifications | To improve analytical ease and efficiency, ensure acceptable results are entered into LIMS, and to satisfy the requirement in the NWQL QA/QC Manual |
| 5 | 140 | Field User | Simple 'Sample Status' page that provides all analyses in a single table with links to individual results and QC information associated with a given environmental sample | To make lab QC accessible to the field |
| 5 | 147 | Field User | I need to be able to review QC for all runs associated with reported data and receive notification that QC was or was not acceptable (especially CCV, CCB, TPC etc. results) | To increase consistency, traceability, data quality, clarity, and concision in communications with stakeholders/collaborators |
| 5 | 173 | Field User | I needs LIMS to transcribe all relevant QC data from contract lab forms into appropriate LIMS fields analogous to NWQL lab QC | So I don't have to manually review pdf forms from the Contract Labs |
| 7 | 23 | Field User, QA User | We need electronic submission of all ASRs tied together with "header" information prior to submission to NWQL and/or Contract lab | To reduce typographical errors. Allow field to see "exceptions" with any samples submitted. Create backlog of Contract lab analytical for improved traceability |
| 7 | 28 | Contract Lab Cor | I need to enter results of all analyses performed by Contract labs into LIMS or provide the data to the requestor in a specified format | To have adequate traceability and to satisfy the requirement in the NWQL QA/QC Manual |
| 7 | 29 | Contract Lab Cor, Field User | I need the ability to have Contract lab data put into a format that is traceable, update-able, and searchable by header information and/or Contract Lab ID | To improve the ability to trace and search data from contract labs and verify that data has been correctly entered or is reloaded if not |
| 7 | 32 | Lab Manager | I need to ensure all changes to a sample are captured | So that I can trace any modifications, deletions to a sample (version history) |
| 7 | 38 | Lab Manager, QA User | I need the ability or run queries and reports for a number of queries (a SQL type query in a user friendly platform). These reports would include but not be limited to: 1) analyses that are not yet complete, 2) a BOD (bunch of data) query to determine the number of samples received for a single analysis over a defined time period, 3) report the verification requests submitted to communicate with lab, 4) report on samples received by login by week including cost of item requested, 5) number of samples logged to determine projected income based on samples logged | To provide projections to create proactive, rather than retroactive items, and improve traceability and communications |
| 7 | 45 | QA Manager | I need a complete audit trail ("cradle to grave") to record changes made in LIMS | To record any/all user actions made |
| 7 | 47 | QA Manager | National QA/QC needs to be able to trace LAB ids from minimal unique header info (STAID, DATES, TIMES, MEDIM, STYPE) | To be able to crunch the QC data |
| 7 | 71 | QA Manager | I need to demonstrate chain of custody when requested | So that results will meet client project requirements |
| 7 | 89 | Lab Manager | LIMS needs to be able to capture, track, and store products of analytical processes, such as raw instrument output files, calculation sheets, instrument run reports, scans, photos, and raster data, and associate that information with individual and groups of samples | To supplant flat file data systems with traceable artifact groupings |
| 7 | 167 | Lab Manager | I need my LIMS system to support bulk data reduction processes and data collection from my Laser Isotope Spectrometry Systems | So that I can achieve long term accuracy and precision in my isotope measurements and have repeatable analytical processes. Although laser absorption spectrometry (LAS) instrumentation is easy to use, its incorporation into laboratory operations is not easy, owing to extensive offline manipulation of comma-separated-values files for outlier detection, between-sample memory correction, nonlinearity (δ-variation with water amount) correction, drift correction, normalization to VSMOW-SLAP scales, and difficulty in performing long-term QA/QC audits |
| 7 | 168 | Lab Manager | I need my LIMS system to support bulk data reduction processes and data collection from my isotope Ratio Mass Spectrometer systems, including bespoke systems developed by the USGS | So that I can achieve long term accuracy and precision in my isotope measurements and have repeatable analytical processes. The LIMS system must incorporate outlier detection, between-sample memory correction, nonlinearity (δ-variation with water amount) correction, drift correction, normalization to isotope scales, and provide long-term QA/QC audits |
| 7 | 174 | Lab Analyst, Lab Manager, QA Manager | I need to have a barcode for my sample that is associated with a unique ID that is traceable to specific sample information (date/time/location) | To ensure results are linked to a specific sample |
| 7 | 200 | Lab Analyst | I need an electronic capability that allows me to build records for calibration or QC manufacturing, as well as create electronic data packets with audit capabilities for each record | To increase traceability and decrease transcription errors |
| 8 | 25 | Field User | I need to confirm sample information in LIMS is correct for the initial LOGIN of sample information | So that I can correlate data to my other discrete readings in Aquarius Samples |
| 8 | 78 | Field User | I want to establish and save “groups” of “Sample IDs,” “Station IDs,” "Proposal numbers," or other user-defined attributes to make data searching more efficient over time | To streamline data pulls |
| 8 | 132 | Field User | I need my Field crew to obtain a summary from NWQL LIMS via email or alert within one day from opening cooler for verification that everything is logged correctly | So that these updates offer another chance to verify what is entered into LIMS |
| 8 | 133 | Field User | I need scanned, signed chain of custody forms reflecting (NWQL) receipt of samples so that field crews can review, confirm, and document within the record (similar to viewing the ASR submitted) | To streamline workflow and ease burden on LabHelp |
| 8 | 134 | Field User | I need an instant alert or email when there is a record header error or sample issue at log-in (warm sample, broken bottle) that includes include all information from the sample header | So the field can quickly respond by submitting back-up or archived samples and/or resample if possible |
| 8 | 135 | Field User | I want to view Lab and Lab login comments associated with the record | So I know if there were issues |
| 8 | 136 | Field User | I would like to know the status of my data (Logged/Processed/Run/In review/Data Released) in some table that is routinely updated and ideally interfaces with Aquarius Samples so users don't have to check in multiple places (perhaps a 'Sample Status' page would help) | So I can track sample progress/status better |
| 8 | 187 | Field User | I need to be notified automatically that my results are ready and/or receive regular updates on the status of my samples | To manage my project timeline and/or provide timely pressure to achieve my objectives |
| 8 | 195 | Lab Manager, Login User | I need to be able to notify the customer of current sample status information recieved on a daily (or nearly as frequent) basis | To give customers a daily (or nearly as frequent) summary of samples that were received |
| 1,5,6 | 15 | Business Analyst | I need LIMS to make billing adjustments for tests added, cancelled, or destroyed after initial estimate (login) | So that the final invoice is accurate and to eliminate manual billing adjustments |
| 1,7 | 22 | Field User, QA User | We need an entry (login) created in LIMS when sample is sent to Contract Lab [only] so NWQL doesn't have to wait for Contract Lab to submit data to start tracking. Contract lab ID needs to be linked to NWQL ID directly. If Sample requests can be entered electronically before submission to NWQL and Contract lab, analyses linked prior to arrival at NWQL or contract lab | Create backlog of contract lab analytical for improved traceability; improve communication between NWQL and field |
| 2,3,4,5 | 59 | Lab Analyst, QA Manager, Lab Analyst | For some analytical lines, I need a template-based system in LIMS to 1) automatically add requisite QC samples to a run, 2) generate QC charts, 3) do data capture that minimizes acceptance of improperly formatted or inaccurate data, 4) does automatic logic checks (ion balance, etc.), 5) calculates and applies consistent rounding and censoring, 6) does certain error corrections, and 7) flags data that is outside specifications | To improve analytical ease and efficiency, ensure acceptable results are entered into LIMS, and to satisfy the requirement in the NWQL QA/QC Manual |
| 2,4 | 226 | Lab Analyst, Lab Manager, Lab Analyst | I need the ability to assign an instrument to a work unit, and include analyte-specific logic for data capture files and QC limits for all QC samples | So instruments can be linked to specific user groups and information required for analytical review processes are stored with the analytical instrument |
| 5,7 | 34 | Lab Analyst | I need to be able to chart QC trends over time to monitor instrument performance and meet SOP/source method/NELAC requirements | So that data integrity passes any audit |
| 5 | 141 | Field User | I need ability to retrieve contract lab QC results for given environmental samples in a simple manner, perhaps by station, time frame, analyte group, etc., and preferably in bulk | To increase efficiency |
| 2,3 | 93 | Lab Analyst | The LIMS will need to interface with whatever scheme is in place (or generate a new/comparable scheme) to capture data output from instrumentation for upload preferably by direct instrument communication or with a (data capture unit) or .csv file | So manual entry into LIMS is minimized |
| 2,3 | 105 | Lab Analyst | I need to be able to create analytical runs in LIMS that are uniquely named, contain samples identified by several factors (e.g., due date, instrument availability, project, or other customized criteria), and be able to change the sample order to create any desired order or sequence | So that I have the foundation of what I will use to eventually report results |
| 5 | 142 | Field User | I need the ability to retrieve USGS Lab QC data for related environmental samples, including IBLNK, ISPKE, etc. that are readily exported that is also tied to the NWQL QC pages and has tags for easy comparison | To increase data consistency across NWQL-served pages and provide more information to the field to facilitate data interpretation |
| 5 | 147 | Field User | I need to be able to review QC for all runs associated with reported data and receive notification that QC was or was not acceptable (especially CCV, CCB, TPC etc. results) | To increase consistency, traceability, data quality, clarity, and concision in communications with stakeholders/collaborators |
| 5 | 173 | Field User | I needs LIMS to transcribe all relevant QC data from contract lab forms into appropriate LIMS fields analogous to NWQL lab QC | So I don't have to manually review pdf forms from the Contract Labs |
File details come from the government source that posted it. Updated .