PAHub Helper
Three tools in one desktop app: DecisionFlow, QPath and PathLogic Mapper.
A three-tab Python desktop application for prior-authorization criteria work. It turns structured Excel drug criteria and question sets into interactive, color-coded HTML decision trees with full approval and denial logic - a rules-based decision layer a reviewer can actually read, with zero installation on the end-user side.
Actively deployed inside a Fortune 20 enterprise environment; the walkthrough shows the tools, not live case data.
At a glance
The problem
Specialty drug criteria are branching logic stored in spreadsheets. A reviewer working a complex case has to hold that branch structure in their head while reading the chart. Spreadsheets are the wrong shape for that job: they show rows, not paths.
Three tabs, three friction points
DecisionFlow Builder converts the structured Excel criteria and question sets into an interactive, color-coded HTML flowchart with approval and denial branches rendered explicitly - one click, a file you can open in any browser. QuickClip Pro (QPath) is an auto-advancing clipboard tool with global keyboard detection, for assembling a question set without leaving the case. PathLogic Mapper is a real-time conditional-logic navigator that highlights the live decision path as the reviewer moves through it.
Why desktop and why HTML
Two deliberate constraints. The app is a self-contained Python desktop tool, so it needs no server, no deployment pipeline and no IT ticket. Its output is plain interactive HTML, so the artifact outlives the tool - a reviewer can save a flowchart, share it, or open it two years later without needing anything installed. Zero external dependencies on the end-user side was a requirement, not a nice-to-have.
Built with
Next case study
Clinical Evidence Navigator →
A cited literature research assistant over PubMed and ClinicalTrials.gov.