How jiangwy666/qpcr-analysis-tool works
This is a desktop qPCR analysis application that turns instrument-exported Excel data into normalized relative-expression values and Prism-ready outputs. The main workflow is file import, sample grouping and optional biological-replicate pairing, reference-gene normalization and ΔΔCt analysis, then preview, clipboard copy, or Excel export. The graph preserves pairing review, undetected-well handling, and QC/reporting as distinct capabilities. The README documents these features; sampled source confirms the main modules and data structures, but GUI call sites were partly omitted, so uncertain wiring is not shown.
Main entry points: gui.py Analysis window · analysis.py ΔΔCt analysis · reader.py Parsed plate data · replicates.py Replicate pairing
Components 18
User interface
- Application entry
main.py - Analysis window
qpcr_tool/gui.py - Pairing preview
qpcr_tool/gui.py
Data ingestion
- Excel reader
qpcr_tool/reader.py - Parsed plate data
qpcr_tool/reader.py
Sample preparation
- Sample grouping
qpcr_tool/grouping.py - Replicate pairing
qpcr_tool/replicates.py
Analysis and QC
- ΔΔCt analysis
qpcr_tool/analysis.py - Reference normalization
qpcr_tool/analysis.py - Well and replicate QC
qpcr_tool/analysis.py - Analysis results
qpcr_tool/analysis.py
Results and export
- Prism wide table
qpcr_tool/exporter.py - QC Excel report
qpcr_tool/exporter.py
Other components
- Researcher
- Instrument Excel
- System clipboard
- GraphPad Prism
- Exported workbook
Connections 28
- Researcher → Application entry: launches
- Application entry → Analysis window: opens
- Researcher → Analysis window: selects file
- Instrument Excel → Excel reader: provides workbook
- Analysis window → Excel reader: loads file
- Excel reader → Parsed plate data: parses wells
- Parsed plate data → Analysis window: returns plate
- Analysis window → Sample grouping: forms groups
- Analysis window → Replicate pairing: configures pairing
- Replicate pairing → Parsed plate data: annotates wells
- Analysis window → Replicate pairing: requests preview
- Replicate pairing → Pairing preview: builds preview
- Analysis window → ΔΔCt analysis: runs analysis
- Parsed plate data → ΔΔCt analysis: supplies wells
- Sample grouping → ΔΔCt analysis: supplies groups
- ΔΔCt analysis → Reference normalization: calculates baseline
- ΔΔCt analysis → Well and replicate QC: checks wells
- ΔΔCt analysis → Analysis results: produces results
- Analysis window → Prism wide table: builds preview table
- Analysis results → Prism wide table: formats values
- Analysis window → QC Excel report: requests export
- Analysis results → QC Excel report: provides results
- Parsed plate data → QC Excel report: provides source wells
- QC Excel report → Exported workbook: writes workbook
- Analysis window → System clipboard: copies TSV
- Prism wide table → System clipboard: supplies TSV
- Researcher → GraphPad Prism: pastes values
- System clipboard → GraphPad Prism: provides tabular data