🏥 Medical Report Generator

Required Columns

• STT (e.g., 240126-9797)
• Họ tên
• Bác sĩ
• Tuổi
• G.Tính (M/F)
• Địa chỉ
• Xét nghiệm (test type)

Supported Test Types

• HPV - HPV Genotyping:
• STD - Sexually Transmissible Disease:
• GBS - PCR GBS (Group B Streptococcus):
• CTNG - Neisseria gonorrhoeae-Chlamydia trachomatis DNA:
• HBV - HBV DNA:
• HCV - HCV RNA Realtime:

Supported Labs

• SG - Default lab (all other facilities)
• HN - When "Bác sĩ" contains "TÂM AN HÀ NỘI"
• GIAAN - When "Bác sĩ" contains "BV Đa Khoa Vạn Gia An"
• TĐ - When "Bác sĩ" contains "Tâm An Thủ Đức"
• JIO - When "Bác sĩ" contains "C- Mother Clinic" or "Home Visit"
• MDSG - When "Bác sĩ" contains "PKĐK MEDIC SÀI GÒN"

Lab is auto-detected from the "Bác sĩ" column value.

Auto-generated Fields

• Report ID (from STT)
• Date Received (from Ngày ĐK)
• Report Date (custom or today)
• Template selected by test type