Skip to content
TheChatArchiveThe Chat Archive
Grok 4.1 Fast· xaiHugging Face Frontier Reasoning Traces

Build an antimicrobial stewardship analytics cockpit: DOT/DDD trends, bug–drug…

  1. User

    Build an antimicrobial stewardship analytics cockpit: DOT/DDD trends, bug–drug mismatches, IV→PO opportunities, audit-and-feedback, and report-outs.

  2. Assistant
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Antimicrobial Stewardship Analytics Cockpit</title>
        <!-- Bootstrap CSS -->
        <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
        <!-- Chart.js -->
        <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
        <!-- jsPDF for reports -->
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
        <!-- Font Awesome for icons -->
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css">
        <style>
            body { background-color: #f8f9fa; }
            .sidebar { height: 100vh; position: fixed; z-index: 1020; }
            .main-content { margin-left: 280px; padding: 20px; }
            .cockpit-card { border-left: 4px solid #007bff; }
            .metric-badge { font-size: 0.9em; }
            .alert-opportunity { background-color: #fff3cd; }
            .mismatch-highlight { background-color: #f8d7da; }
        </style>
    </head>
    <body>
        <!-- Sidebar Navigation -->
        <div class="sidebar bg-dark text-white p-3" style="width: 280px;">
            <h4 class="text-white mb-4"><i class="fas fa-flask-medical"></i> AMS Cockpit</h4>
            <ul class="nav flex-column">
                <li class="nav-item"><a class="nav-link text-white" href="#overview"><i class="fas fa-chart-line"></i> DOT/DDD Trends</a></li>
                <li class="nav-item"><a class="nav-link text-white" href="#mismatches"><i class="fas fa-bug"></i> Bug-Drug Mismatches</a></li>
                <li class="nav-item"><a class="nav-link text-white" href="#ivpo"><i class="fas fa-pills"></i> IV→PO Opportunities</a></li>
                <li class="nav-item"><a class="nav-link text-white" href="#audit"><i class="fas fa-clipboard-check"></i> Audit & Feedback</a></li>
                <li class="nav-item"><a class="nav-link text-white" href="#reports"><i class="fas fa-file-export"></i> Report-Outs</a></li>
            </ul>
            <hr class="text-white">
            <button class="btn btn-outline-light w-100" onclick="refreshData()"><i class="fas fa-sync"></i> Refresh Data</button>
        </div>
    
        <!-- Main Content -->
        <div class="main-content">
            <!-- Overview Section -->
            <section id="overview">
                <div class="row">
                    <div class="col-12">
                        <div class="card cockpit-card shadow-sm mb-4">
                            <div class="card-header bg-primary text-white">
                                <h5><i class="fas fa-chart-line"></i> DOT/DDD Trends (Last 30 Days)</h5>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-3">
                                        <div class="card text-center">
                                            <div class="card-body">
                                                <h3>245</h3>
                                                <p class="mb-0">Avg DOT/Pt</p>
                                                <span class="badge bg-success metric-badge">↓ 5%</span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3">
                                        <div class="card text-center">
                                            <div class="card-body">
                                                <h3>1,200</h3>
                                                <p class="mb-0">Total DDD</p>
                                                <span class="badge bg-warning metric-badge">↑ 2%</span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <canvas id="trendsChart" height="100"></canvas>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
    
            <!-- Bug-Drug Mismatches -->
            <section id="mismatches" style="display: none;">
                <div class="card cockpit-card shadow-sm">
                    <div class="card-header bg-danger text-white">
                        <h5><i class="fas fa-bug"></i> Bug-Drug Mismatches (High Risk)</h5>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-striped">
                                <thead>
                                    <tr>
                                        <th>Patient ID</th>
                                        <th>Pathogen</th>
                                        <th>Current Drug</th>
                                        <th>Susceptibility</th>
                                        <th>Recommended</th>
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr class="mismatch-highlight">
                                        <td>P12345</td>
                                        <td>MRSA</td>
                                        <td>Vancomycin</td>
                                        <td>Resistant</td>
                                        <td>Daptomycin</td>
                                        <td><button class="btn btn-sm btn-warning">Alert</button></td>
                                    </tr>
                                    <tr class="mismatch-highlight">
                                        <td>P67890</td>
                                        <td>ESBL E.coli</td>
                                        <td>Ceftriaxone</td>
                                        <td>Resistant</td>
                                        <td>Meropenem</td>
                                        <td><button class="btn btn-sm btn-warning">Alert</button></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                        <p class="text-muted">Total Mismatches: 12 | <a href="#" onclick="exportMismatches()">Export CSV</a></p>
                    </div>
                </div>
            </section>
    
            <!-- IV→PO Opportunities -->
            <section id="ivpo" style="display: none;">
                <div class="card cockpit-card shadow-sm alert-opportunity">
                    <div class="card-header bg-warning text-dark">
                        <h5><i class="fas fa-pills"></i> IV→PO Switch Opportunities (n=15)</h5>
                    </div>
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-6">
                                <ul class="list-group">
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        P11111: Levofloxacin IV → PO
                                        <span class="badge bg-success rounded-pill">Eligible</span>
                                    </li>
                                    <li class="list-group-item d-flex justify-content-between align-items-center">
                                        P22222: Metronidazole IV → PO
                                        <span class="badge bg-success rounded-pill">Eligible</span>
                                    </li>
                                </ul>
                            </div>
                            <div class="col-md-6">
                                <canvas id="ivpoChart" height="200"></canvas>
                            </div>
                        </div>
                        <button class="btn btn-success mt-3" onclick="batchSwitchAlert()">Batch Alert Team</button>
                    </div>
                </div>
            </section>
    
            <!-- Audit & Feedback -->
            <section id="audit" style="display: none;">
                <div class="card cockpit-card shadow-sm">
                    <div class="card-header bg-info text-white">
                        <h5><i class="fas fa-clipboard-check"></i> Audit & Feedback</h5>
                    </div>
                    <div class="card-body">
                        <form id="auditForm">
                            <div class="mb-3">
                                <label>Patient ID</label>
                                <input type="text" class="form-control" placeholder="e.g., P12345">
                            </div>
                            <div class="mb-3">
                                <label>Feedback Note</label>
                                <textarea class="form-control" rows="3" placeholder="e.g., Switch to narrower spectrum..."></textarea>
                            </div>
                            <button type="submit" class="btn btn-primary">Submit Feedback</button>
                        </form>
                        <div class="mt-4">
                            <h6>Recent Audits</h6>
                            <ul id="auditList" class="list-group list-group-flush">
                                <li class="list-group-item">P12345: "Narrow spectrum recommended" - Today</li>
                            </ul>
                        </div>
                    </div>
                </div>
            </section>
    
            <!-- Report-Outs -->
            <section id="reports" style="display: none;">
                <div class="card cockpit-card shadow-sm">
                    <div class="card-header bg-success text-white">
                        <h5><i class="fas fa-file-export"></i> Report-Outs</h5>
                    </div>
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-4">
                                <button class="btn btn-outline-primary w-100 mb-2" onclick="generateReport('monthly')">
                                    <i class="fas fa-calendar"></i> Monthly Summary
                                </button>
                            </div>
                            <div class="col-md-4">
                                <button class="btn btn-outline-primary w-100 mb-2" onclick="generateReport('mismatches')">
                                    <i class="fas fa-bug"></i> Mismatches Report
                                </button>
                            </div>
                            <div class="col-md-4">
                                <button class="btn btn-outline-primary w-100 mb-2" onclick="generateReport('ivpo')">
                                    <i class="fas fa-pills"></i> IV→PO Summary
                                </button>
                            </div>
                        </div>
                        <div id="reportPreview" class="mt-3 p-3 border rounded bg-light" style="display: none;">
                            <h6>Preview:</h6>
                            <p id="previewContent">Select a report to preview...</p>
                        </div>
                    </div>
                </div>
            </section>
        </div>
    
        <!-- Bootstrap JS -->
        <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
        <script>
            // Smooth scroll navigation
            document.querySelectorAll('a[href^="#"]').forEach(anchor => {
                anchor.addEventListener('click', function (e) {
                    e.preventDefault();
                    const target = document.querySelector(this.getAttribute('href'));
                    if (target) {
                        target.scrollIntoView({ behavior: 'smooth' });
                        // Hide other sections
                        document.querySelectorAll('section').forEach(sec => sec.style.display = 'none');
                        target.style.display = 'block';
                    }
                });
            });
    
            // DOT/DDD Trends Chart
            const trendsCtx = document.getElementById('trendsChart').getContext('2d');
            const trendsChart = new Chart(trendsCtx, {
                type: 'line',
                data: {
                    labels: ['Day 1', 'Day 7', 'Day 14', 'Day 21', 'Day 30'],
                    datasets: [{
                        label: 'DOT',
                        data: [200, 210, 205, 220, 245],
                        borderColor: '#007bff',
                        tension: 0.1
                    }, {
                        label: 'DDD',
                        data: [900, 950, 980, 1050, 1200],
                        borderColor: '#ffc107',
                        tension: 0.1
                    }]
                },
                options: { responsive: true, scales: { y: { beginAtZero: true } } }
            });
    
            // IV→PO Pie Chart
            const ivpoCtx = document.getElementById('ivpoChart').getContext('2d');
            new Chart(ivpoCtx, {
                type: 'doughnut',
                data: {
                    labels: ['Eligible', 'Ineligible', 'Pending Review'],
                    datasets: [{ data: [15, 5, 8], backgroundColor: ['#28a745', '#dc3545', '#ffc107'] }]
                },
                options: { responsive: true }
            });
    
            // Refresh Data (Mock)
            function refreshData() {
                alert('Data refreshed from EHR/Micro lab! (Mock)');
            }
    
            // Export Mismatches (Mock CSV)
            function exportMismatches() {
                const csv = 'Patient,Pathogen,Drug\nP12345,MRSA,Vancomycin\nP67890,ESBL E.coli,Ceftriaxone';
                const blob = new Blob([csv], { type: 'text/csv' });
                const url = URL.createObjectURL(blob);
                const a = document.createElement('a');
                a.href = url; a.download = 'mismatches.csv'; a.click();
            }
    
            // Batch IV→PO Alert
            function batchSwitchAlert() {
                alert('Alerts sent to 15 prescribers! (Mock)');
            }
    
            // Audit Form Submit
            document.getElementById('auditForm').addEventListener('submit', function(e) {
                e.preventDefault();
                const pid = this.querySelector('input').value;
                const note = this.querySelector('textarea').value;
                const list = document.getElementById('auditList');
                const newItem = document.createElement('li');
                newItem.className = 'list-group-item';
                newItem.textContent = `${pid}: "${note}" - ${new Date().toLocaleDateString()}`;
                list.insertBefore(newItem, list.firstChild);
                this.reset();
                alert('Feedback submitted!');
            });
    
            // Generate Reports with jsPDF
            function generateReport(type) {
                const { jsPDF } = window.jspdf;
                const doc = new jsPDF();
                let title, content;
                switch(type) {
                    case 'monthly':
                        title = 'Monthly AMS Summary';
                        content = 'DOT: 245 avg | DDD: 1200 total | Trends stable.';
                        break;
                    case 'mismatches':
                        title = 'Bug-Drug Mismatches';
                        content = '12 cases identified. Top: MRSA-Vanco.';
                        break;
                    case 'ivpo':
                        title = 'IV→PO Opportunities';
                        content = '15 eligible switches. Potential savings: $5K.';
                        break;
                }
                doc.text(title, 20, 20);
                doc.text(content, 20, 40);
                doc.save(`${type}_report.pdf`);
    
                // Preview
                document.getElementById('previewContent').textContent = `${title}\n\n${content}`;
                document.getElementById('reportPreview').style.display = 'block';
            }
        </script>
    </body>
    </html>
    

    Deployment Instructions

    1. Save as HTML: Copy the code into ams-cockpit.html and open in any browser.
    2. Data Integration: Replace mock data with real APIs (e.g., Epic/ Cerner FHIR for EHR, WHONET for micro).
      • DOT/DDD: Query pharmacy data by ATC codes.
      • Mismatches: Join AST reports with orders.
      • IV→PO: Rules-based (e.g., stable vitals + oral equiv available).
    3. Enhancements:
      • Backend: Node.js/Flask + PostgreSQL for real-time data.
      • Alerts: Integrate Slack/Email via Twilio/SendGrid.
      • Auth: Add OAuth for hospital SSO.
      • Mobile: Already responsive with Bootstrap.

    This is a fully functional prototype—interactive charts, exports, audits, and PDF reports. Ready for stewardship rounds! 🧪📊

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.