Professional Context
I still remember the day our lab's EHR system crashed during a critical experiment, and we had to manually log every patient sample and test result. It was chaos, and we were lucky to have a backup system in place. But it got me thinking - what if we could use AI to not only analyze patient data but also optimize our workflows and reduce errors?
💡 Expert Advice & Considerations
Don't bother trying to use Gemini to replace human judgment in lab results - it's just not ready for that level of complexity. But do use it to help with the tedious tasks like data entry and reporting.
Advanced Prompt Library
4 Expert PromptsAutomated Abnormal Result Flagging
Create a Google Sheets script that connects to our EHR system and flags abnormal lab results based on pre-defined criteria. The script should also send an email notification to the lab technician and physician on record. Assume the EHR system has an API for retrieving patient data, and use the following columns: Patient ID, Test Name, Result Value, Reference Range. Use the following logic: if Result Value is outside Reference Range, flag as abnormal. Also, generate a daily report of all abnormal results, including patient demographics and test information.
Lab Test Correlation Analysis
Using a dataset of 10,000 patient lab results, including complete blood count (CBC), basic metabolic panel (BMP), and liver function tests (LFT), create a correlation matrix to identify relationships between different test results. Use Google Data Studio to visualize the correlations and identify patterns that may indicate underlying conditions or diseases. Also, generate a list of the top 10 most correlated test pairs, along with their correlation coefficients and p-values.
Clinical Decision Support System Integration
Design a workflow that integrates our lab's EHR system with a clinical decision support system (CDSS) to provide real-time, evidence-based recommendations for patient care. Use Google Cloud Functions to create an API that receives patient data from the EHR system, sends it to the CDSS, and retrieves recommendations. Then, use Google Sheets to create a dashboard that displays the recommendations and allows lab technicians to document patient care decisions. Assume the CDSS has an API for retrieving recommendations, and use the following patient data: medical history, current medications, lab results.
Quality Control Audit Report Generation
Create a Google Docs template for generating quality control audit reports, including the following sections: introduction, methodology, results, discussion, and conclusions. Use Google Sheets to connect to our lab's quality control database and retrieve data on instrument calibration, control sample results, and proficiency testing. Then, use the data to populate the report template, including tables, figures, and text. Also, generate a summary of key findings and recommendations for quality improvement.