Last week Mark Cuban stood in front of a room of policymakers and said, out loud, what practitioners have been saying in private for a decade. The biggest problem in American healthcare is not that the drugs don't exist, or that the doctors don't exist, or that the hospitals don't exist. It is that the money to pay for them — already inside the system — does not reach the people who need it in time to stop their lives from coming apart.

About 530,000 American families a year are driven into bankruptcy by medical bills. That number does not come from a headline or a lobbying deck. It comes from Himmelstein, Lawless, Thorne, Foohey, and Woolhandler in the American Journal of Public Health, which found that roughly two-thirds of all personal bankruptcies in the U.S. involve a medical cause — medical bills, lost income from illness, or both. More recent work — the Commonwealth Fund's 2024 Biennial Survey, KFF's medical debt work, the CFPB's medical debt reports — tells the same story from different angles. There is roughly $200 billion of unpaid medical debt on U.S. household balance sheets, and nearly one in four insured adults is effectively underinsured, meaning their out-of-pocket costs eat more than 10% of household income.

At the same time, the country already carries resources specifically designed to stop this. Roughly $28 billion a year in federal tax breaks to nonprofit hospitals, in exchange for charity care they are legally required to provide. Billions in premium tax credits. Medicaid presumptive eligibility. The No Surprises Act and its Independent Dispute Resolution process. State medical debt programs. And a growing set of nonprofits and startups that exist for no purpose other than getting covered people the coverage they already qualify for.

So why does the plane still crash?

Because the current revenue cycle — the apparatus that moves money between patient, provider, and payer — is structurally asymmetric. It is highly optimized on the side that wants to collect, and almost entirely manual on the side that has to pay. AI has poured into the collect side: denial engines, automated prior auth, coding uplift, clawback automation, dunning. AI has barely touched the pay side: a patient still gets a paper bill, a phone tree, a three-line denial letter, and no model on their team.

This issue is about whether that asymmetry is a permanent feature of the system or a policy choice. The argument below is that it is a policy choice — and that the same infrastructure now being used to maximize revenue from patients can, with different rules and different operators, be turned around to maximize benefits owed to patients. Not as speculation. As a stack that already partly exists.

"Don't be a wimp. Seriously."
— Mark Cuban to lawmakers on breaking up PBMs · Politico Healthcare Summit, April 21, 2026

Cuban's role in this is less about the pharmacy he built than about the permission structure he has been creating. By naming CVS Caremark, Express Scripts, and OptumRx in public, by publishing the list prices his facility pays, by calling out employer CEOs for not negotiating better, he has made it normal to treat healthcare pricing and denial the way we treat any other supplier negotiation: as a leverage problem. That framing is what this issue tries to extend. The hard part is not writing an op-ed. It is building the infrastructure that lets a family who cannot afford a $14,000 emergency department bill have a chance of not being crushed by it.

530,000 families a year — and who they actually are

Medical bankruptcy in the United States is not a tail risk for the uninsured. It is a middle-class event, and the triggers are mundane.

The Himmelstein team's 2019 AJPH paper is still the cleanest number we have: roughly 66.5% of personal bankruptcies in the U.S. cite a medical cause, which translates to about 530,000 families filing for bankruptcy each year with medical bills or illness-driven income loss contributing materially. Subsequent work by the Commonwealth Fund and KFF finds that the underlying affordability crisis has widened, not narrowed, since then.

Three things about that number are worth sitting with before we go any further.

First, most of these families have insurance. The Commonwealth Fund's 2024 Biennial survey found that 23% of insured adults are underinsured — meaning their deductibles and out-of-pocket spending consume more than 10% of household income (5% for lower-income families). Medical bankruptcy is largely an underinsurance story, not an uninsurance story. That is important because the "just get covered" framing — the default political answer for a decade — does not describe what is actually breaking.

Second, the triggers are routine. A single hospitalization is the modal event — one in four bankruptcy filers cite a specific stay. Cancer and chronic disease account for another large share. Commonwealth Fund analyses and KFF data consistently show that unpaid hospital bills are the single largest category of medical debt, followed by out-of-pocket prescription costs and ambulance/ED charges. Dental and behavioral health debt is also material and often invisible in official statistics.

Third, the demographic pattern is not random. Black and Hispanic households are disproportionately represented. Single-parent households are over-represented. Residents of non-Medicaid-expansion states are over-represented. And — this is the quiet one — the age group most likely to carry medical debt in collections is working-age adults between roughly 35 and 54, not retirees. The system is not mostly failing the elderly. It is failing people who are in the middle of building their working lives.

Chart 1
Who ends up bankrupt, and what pushed them there

Two views of the 530,000 families/year — the medical events that triggered filing (left) and the population groups carrying medical debt at higher rates (right).

Triggers of medical bankruptcy and demographic pattern of medical debt CONTRIBUTING CAUSE CITED IN FILINGS (%) Share of medical bankruptcy filers reporting each driver Any medical cause Illness/injury Hospitalization Medical bills ≥$5K Lost income from illness Prescription drug costs Long-term care 66.5% 58% 44% 36% 28% 22% 18% Source: Himmelstein et al., AJPH 2019 (headline 66.5%); CFPB Medical Debt Burden 2022; KFF/SIPP. WHO HOLDS MEDICAL DEBT (vs. overall pop.) Share of group with past-due medical bills · baseline ≈ 1 in 5 adults Uninsured adults Black households Hispanic households Ages 35–54 Single parents Non-expansion states Household <$40K 32% 28% 24% 23% 21% 19% 16% Source: KFF/Peterson-KFF Health Tracker; Urban Institute medical-debt analyses; CFPB 2022.

One more piece of the picture — policy has moved in the wrong direction over the last year. The CFPB's January 2025 rule would have removed roughly $49 billion of medical debt from the credit reports of an estimated 15 million Americans. It was vacated by a federal court in the Eastern District of Texas on July 11, 2025, which also signaled that the Fair Credit Reporting Act preempts state-level medical debt credit bans — putting about fifteen state laws in legal jeopardy. Add to that the post-pandemic Medicaid unwinding (over 25 million redeterminations, many procedural disenrollments), the expiration of enhanced ACA subsidies on the current schedule, and eligibility redeterminations every six months under the "One Big Beautiful Bill" — and the forward trend on medical bankruptcy exposure is worse than the historical data says.

The Asymmetry

Revenue cycle AI is real. But it is not on the patient's side of the table.

The popular framing — "healthcare already has the most sophisticated AI stack in the economy" — is simply not true. Finance, ads, and logistics are further along. What healthcare does have is a narrow, well-capitalized AI capability for one very specific job: moving money from patient to payer to provider faster. That capability has been built almost entirely on the revenue-capture side.

Chart 2
2025 healthcare AI spend is concentrated on the revenue-capture side

Menlo Ventures' 2025 State of AI in Healthcare estimates $1.4B in annual healthcare AI spending. Health systems and outpatient providers dominate. Patient-side tooling — navigation, appeal, bill-audit — is a rounding error.

Healthcare AI spending distribution 2025, with patient-side tools highlighted $0 $200M $400M $600M $800M $1.0B Health systems ~$1.0B Outpatient providers ~$280M Payers (RCM max.) ~$50M Patient-side tools <$20M est. No published sector estimate; figure is our indicative upper bound across Dollar For, Goodbill, Claimable, and similar tools. Source: Menlo Ventures, 2025 State of AI in Healthcare (health systems / outpatient / payer splits). Patient-side tools estimate is indicative.

The RCM AI stack is real. It is also bounded. A peer-reviewed JAMIA 2025 survey of 43 health systems found that only 23% of organizations deploying revenue-cycle AI report a "high degree of success" — the lowest success rate of any AI category surveyed. Vendors' marketing numbers — 23% faster denial appeal drafting from Epic's Penny; 90% faster appeal-package generation from Waystar — are real but represent narrow productivity gains, not an order-of-magnitude transformation of the financial experience.

On the denial side, the evidence of harm is well documented. UnitedHealth's nH Predict algorithm — used to adjudicate post-acute rehab care for Medicare Advantage members — is alleged in the Estate of Lokken class action to have a 90% error rate on appealed denials, with only 0.2% of denied patients appealing — so the reversal rate produces no real pressure back on the algorithm. Cigna's PXDX tool, per a ProPublica investigation, allowed its physicians to reject 300,000 claims in two months at 1.2 seconds per case. MedPAC, via USC Schaeffer analyses, estimates Medicare Advantage upcoding adds roughly $50 billion a year in payments to plans; HHS OIG flagged $7.5 billion in overpayments from MA Health Risk Assessments in 2023 alone.

The structural point is not that every insurer is running nH Predict. It is that the AI money, the AI talent, and the AI product-market fit in healthcare right now all sit on the side of the transaction that has an incentive to collect more, deny more, and appeal less. The other side of the table — 530,000 families a year, and the tens of millions who live one ED visit away from them — is still, for the most part, holding a phone and a paper bill.

The money to prevent this is already in the system

Charity care, subsidies, IDR, state programs — most of the resources designed to keep families out of bankruptcy already exist. Most of them don't reach the people they were built for.

Take the cleanest example. Nonprofit hospitals — about 3,000 facilities, roughly 60% of all U.S. hospitals — receive federal, state, and local tax exemptions collectively worth an estimated $28 billion a year. In exchange, under IRS Section 501(r), they are required to publish a financial assistance policy, screen patients for eligibility before collection actions, and limit what they charge eligible patients.

The Lown Institute's 2024 Fair Share Spending analysis found a $25.7 billion gap between the value of nonprofit hospital tax breaks and the community investment those hospitals reported. Separate research from the nonprofit Dollar For quantifies the charity-care-specific piece: hospitals collectively fail to deliver at least $14 billion a year in charity care they were legally obligated to provide, and only about 29% of eligible patients actually move from discovery to approved financial assistance. More than half of patients surveyed were not given any information about financial assistance by the hospital at all. Black patients were 62% less likely to be approved than patients of other races.

Charity care is only one of the leaky resource pools. A similar pattern shows up across the system:

Chart 3
The gap between resources available and resources captured

Each bar pair shows the resource that already exists (teal) vs. how much of it actually reaches the intended patient (dark). Units differ — this is a picture of take-up, not a dollar-for-dollar comparison.

Resources available vs. captured — charity care, subsidies, Medicaid redeterminations, IDR, financial-assistance screening AVAILABLE (TEAL) · CAPTURED / REACHED (DARK) Bars scaled to 100% within each pair; label shows the ratio. Nonprofit hospital charity care $14B/yr shortfall · only 29% of eligible patients receive it 100% available 29% reach patient ACA premium tax credits (est.) ~5M eligible but unenrolled in marketplace coverage 100% eligible ~68% enrolled Medicaid redeterminations (unwinding) ~70% of disenrollments were procedural, not eligibility-based Entitled to coverage ~30% kept coverage through No Surprises Act IDR disputes 4.8M disputes in 2023–H1 2024 vs. 17K predicted; providers win 85–86% 100% disputes ~85% provider wins (not patient-initiated) Hospital financial-assistance screening Of surveyed patients, 52% received no information about financial assistance at all Legally required 48% were told about it

The pattern is consistent. Resources exist. Take-up is low. The infrastructure that could raise take-up — eligibility checks, application prefill, subsidized enrollment, automated charity-care screening — is technically trivial. It is just not built by anyone whose revenue depends on it.

That last sentence is the one worth reading twice. The same data flows that feed a collection engine could, with different incentives, feed a benefits engine. Eligibility for Medicaid, for hospital charity care, for marketplace subsidies, for state assistance programs, for manufacturer patient-assistance drugs — all of it is computable from information the health system already has: income, household size, residency, insurance status, diagnosis codes, discharge data. The pay-side revenue cycle is not a technical problem. It is an assignment problem: who is accountable for running it, and whose side they sit on.

A three-layer stack for the patient side of the table

The tools to turn RCM inside-out already exist in pieces. They have not been assembled. The structure below maps the pieces to the three moments when the fight is lost — before the bill, at the bill, and after the bill.

The rule of thumb is simple: every dollar a patient is billed is either avoidable, disputable, or bridgeable. Each of those three verbs maps to a distinct AI capability, a distinct operator, and a distinct policy lever. And each has at least one production-grade example — from payer-aligned startups to patient-funded nonprofits — already running.

Layer 1 · Prevent

Before the bill

Pre-service · eligibility · cost estimation · coverage gaps

  • Cedar50M+ patients covered; AI automates Medicaid enrollment, financial counseling, good-faith estimates. Provider-aligned — patient benefit as byproduct.
  • Unite Us / findhelpSocial-care coordination at scale. Unite Us reports 93M+ connections; NC HOP program saves ~$85/PMPM. Mostly provider/payer routed.
  • Cedar Cover, Nuna, RivetPresumptive-eligibility and good-faith-estimate engines. The tech is solid; the incentive alignment is the bottleneck.
Layer 2 · Intercept

At the bill

Bill audit · denial appeal · chargemaster vs. negotiated-rate checks

  • GoodbillAI bill audit and negotiation. Named a Time Best Invention 2023. Has pivoted toward employer/plan market — consumer access now mediated through benefits.
  • Claimable, Fight Health Insurance, Patient Advocate FoundationAI-assisted denial appeals. Claimable drafts individualized appeal letters at fraction of attorney cost; PAF staffs professional case managers.
  • Alaffia Health$55M Series B Feb 2026; 20%+ savings on high-cost facility claims. Payer-aligned — benefit reaches patients indirectly via lower premiums.
Layer 3 · Bridge

After the bill

Charity care capture · hardship · debt abolition · credit protection

  • Dollar ForNonprofit. Erased ~$55M in medical debt in 2025, up from ~$32M in 2024. Charity-care policies database covers 2,000+ hospitals. See spotlight below.
  • Undue Medical DebtHas abolished $22.8B of debt for 14.72M people since 2014. April 2025: largest medical-debt abolishment transaction on record, $30B face value.
  • NeedyMeds, RxAssist, manufacturer PAPsPatient Assistance Programs and co-pay support. Chronically under-publicized at point of care; AI could surface automatically.
Chart 4
Where the stack already produces outcomes, and where it doesn't

Each dot is an operator plotted by (a) how directly patient-facing they are and (b) how much documented patient-side financial outcome they've produced. Dashed oval = unfunded region, where the fight is most often lost.

Counter-RCM operators plotted by patient alignment and documented outcomes PATIENT ALIGNMENT → Direct Indirect DOCUMENTED PATIENT-SIDE OUTCOME → Minimal Substantial THE SHIELD ZONE direct + outcome-producing THE UNDERFUNDED GAP patient-aligned tools without scaled capital or distribution Dollar For $55M/yr erased · charity care Undue Medical Debt $22.8B abolished · 14.7M people Claimable / FightHI AI denial appeals, DTC Patient Advocate Fdn. Professional case mgmt Goodbill Plan-mediated bill audit Cedar 50M+ patients · provider-routed Unite Us Social care · 93M connections Alaffia $55M B · payer-aligned audit CoPatient (defunct) Self-serve bill audit apps CHW-matching tools (seed-stage)
Case Spotlight · Bridge layer

Dollar For — what the patient-side revenue cycle looks like when it actually runs

Dollar For was founded by Jared Walker in Portland, Oregon, in early 2021 after a TikTok video explaining hospital charity care went viral and generated thousands of requests overnight. The organization's core insight: nonprofit hospitals are legally required to offer free or discounted care to patients below income thresholds that, in many states, reach $125,000 for a family of four — yet only 29% of eligible patients actually discover, apply for, and receive that benefit. Dollar For built a database of charity-care policies from more than 2,000 hospitals, launched a public eligibility checker in 2021, and in spring 2025 completed a digital application system that auto-maps patient data to each hospital's specific form — so patients never need to visit the hospital's own website.

~$55M
medical debt erased in 2025 (67% more than 2024)
2,000+
hospital charity-care policies in database
~$1.5M
annual operating budget; lost a third of it in 2025

A separate 2025 Dollar For study found the $14B annual unclaimed charity-care gap represents just 0.7% of hospital revenue — which is to say, the fix requires minimal hospital sacrifice and maximum regulatory pressure. Dollar For is exploring AI-assisted document QC (~$250K build cost) to validate patient income documents before submission, reducing hospital rejection rates, and advocating for state laws requiring automatic charity-care screening before a bill is issued. The point of the spotlight is not that Dollar For, alone, can close the $14B gap. It is that a nonprofit with an operating budget smaller than a single healthcare AI seed round is outperforming the for-profit infrastructure on a capability the for-profit infrastructure was legally obligated to provide. Sources: KFF Health News / An Arm and a Leg podcast, January 2026; Dollar For / Yahoo Finance, May 2024; Spotlight on Poverty, June 2025.

Arming the people already fighting on the patient's side

AI built for the patient cannot mostly be an app. The highest-leverage deployment is giving better tools to the professionals and volunteers who already help families navigate the system one case at a time.

There is a second myth worth naming. Medical bankruptcy is not, mostly, a problem of educated patients making bad choices — it is a problem of ordinary people hitting an intentionally complex administrative wall with no one on their side. The people who are already on that side are underfunded, overloaded, and mostly working on paper and phone calls. Before we ask who the next Dollar For is, we should ask how much more the existing field can do with better tooling.

Community Health Workers (CHWs)

~70,000 CHWs nationally per BLS; embedded in clinics, FQHCs, and public health departments. Primary job is often benefits navigation — Medicaid, SNAP, housing, transportation. Almost none have AI-assisted intake, eligibility pre-screening, or closed-loop referral tooling. A CHW with a well-designed co-pilot could triage 2–3× their current case load, and reach families before the bill is ever issued.

Medical-Legal Partnerships (MLPs)

Network of ~450 MLPs across U.S. hospitals and clinics — lawyers embedded in care settings to address housing, benefits, and denial-of-coverage issues as a medical intervention. The National Center for Medical-Legal Partnership documents better clinical outcomes and lower costs. AI-assisted intake, appeal drafting, and case triage would let existing MLPs serve multiples more patients with the same legal-staff count.

Plaintiffs' counsel and class actions

Clarkson Law Firm and others have built AI-assisted litigation pipelines against payer denial systems. Combined with whistleblowers, journalism like ProPublica and STAT News, and Estate of Lokken–style class actions, the legal layer has become the most effective patient-side counterweight to automated denial — not by replacing the system but by increasing its legal cost of abuse.

Investigative journalism

KFF Health News, ProPublica, STAT News, NPR, and NYT healthcare desks have produced most of the meaningful evidence of automated denial harm. AI-assisted records analysis, document discovery, and pattern detection in large claims datasets is a direct input into this layer — and it is where the reputational cost of bad behavior gets priced.

State AG and CFPB enforcement staff

State attorneys general, the (embattled) CFPB, and state insurance departments make or break enforcement. Where they have tools — medical-debt data sharing, surprise-billing complaint review, market-conduct exam AI — enforcement scales. Where they don't, the same patterns repeat for years. This is the single most under-funded high-leverage layer in the entire stack.

Same technology. Two different sides of the table.

The honest answer to "is AI good or bad for patients?" is that it depends on who pays for it and what problem they told it to solve. Below, the same capability class shown as both shield and weapon — with named examples on each side.

AI as shield · for the patient
Where the technology is already working for families
  • Charity-care capture at scaleDollar For erased ~$55M of medical debt in 2025 on a $1.5M budget. Digital application auto-maps patient data to each hospital's form. Infrastructure that did not exist five years ago.
  • Denial-appeal drafting for patientsClaimable, Fight Health Insurance, and PAF use LLMs to draft individualized appeal letters against denials — a capability that was previously only available through attorneys.
  • Bill-audit for plan membersGoodbill (pivoted to plan-mediated) and Alaffia (payer-aligned) audit high-cost facility claims with 20%+ average savings on high-cost bills. Benefit reaches patients indirectly, but it is real.
  • Debt abolition at industrial scaleUndue Medical Debt has abolished $22.8B of debt for 14.72M people since 2014 — an April 2025 $30B face-value purchase from Pendrick Capital Partners is the largest medical-debt abolishment transaction in history.
  • Evidence through journalism + discoveryAI-assisted records analysis by STAT News and ProPublica turned nH Predict and PXDX from anecdotes into litigatable patterns. This is how the weapon ends up partly disarmed.
AI as weapon · against the patient
Where the technology is already working against families
  • Algorithmic care denialUnitedHealth's nH Predict is alleged to have a 90% error rate on appealed denials, with only 0.2% of denied patients appealing — so the algorithm faces almost no corrective pressure from the patients it is wrong about.
  • Claim-denial at industrial speedCigna's PXDX system allowed physicians to reject 300,000 claims in two months at 1.2 seconds per case — a speed that is only possible with AI pre-adjudication.
  • Upcoding and risk-score inflationMedPAC, via USC Schaeffer, estimates Medicare Advantage upcoding adds roughly $50B/yr in payments to plans; HHS OIG flagged $7.5B in MA Health Risk Assessment overpayments in 2023 alone.
  • PBM rebate gamesThe FTC's 2024 and 2025 interim reports documented ~$7.3B in excess PBM-affiliated pharmacy revenue on insulin and other chronic drugs. This is not technically an "AI" harm, but the optimization engines that price and steer are.
  • Chargemaster inflation as the starting pointCuban, on LinkedIn (April 19, 2026): the chargemaster is "just a made up list price" that hospitals use to bill uninsured patients — a number no insurer actually pays but families in debt do. AI billing is built on top of this.

The real question is not whether AI is good or bad. It is whether the shield side of this table can be funded, mandated, and integrated at anything close to the speed the weapon side already has been. Right now the answer is no. Changing that is a policy problem.

Five things that, together, let AI actually work for patients

No single rule fixes medical bankruptcy. But these five are the smallest complete set of changes that would make the counter-RCM stack above commercially viable and legally durable. Each one has an active hook in existing law or regulation.

1

Machine-readable, fully-enforced hospital price transparency

The hook: CMS Hospital Price Transparency Rule (2021), strengthened in the 2024 IPPS final rule; growing bipartisan push via the Lower Costs, More Transparency Act.

What to change: Enforce real penalties, standardize the schema (so payer-specific negotiated rates are machine-comparable), and extend the rule to ambulatory surgery centers, labs, and imaging. Without this, every downstream AI tool — bill audit, appeal, estimate — is reasoning against opaque list prices.

2

The Symmetry Mandate — patient AI appeal rights

The hook: No federal law yet, but CMS's 2024 Medicare Advantage prior-authorization rule opens the door, and NAIC model laws on AI/algorithmic decisions are advancing at the state level.

What to change: If a payer uses an algorithmic or AI tool to issue an adverse determination, the patient must receive, within 72 hours: machine-readable denial data in FHIR format, the name and version of the model, the specific decision factors flagged, and the explicit right to use their own AI-assisted tools in the appeal. No patient should be denied by a model they cannot see and cannot answer.

3

Put teeth on 501(r) — make charity care real

The hook: IRS Section 501(r), plus the IRS TE/GE Division's March 2024 compliance initiative that audited 35 hospital organizations.

What to change: Statutory minimum community-benefit floor as a condition of tax exemption; automatic charity-care screening before a bill is issued (not after collections); meaningful penalties — including revocation of exemption — for systemic non-compliance. If nonprofit hospitals want $28B/yr in public subsidy, the public should get $28B worth of actual charity care.

4

Keep medical debt off credit reports — federally or, failing that, by state

The hook: The CFPB's January 2025 rule, vacated by an E.D. Texas court in July 2025, plus ~15 state laws (CA SB 1061, NY SB-S4907A, CO HB 23-1126, and others) now in legal jeopardy from federal preemption dicta.

What to change: Congressional FCRA amendment explicitly authorizing state bans and prohibiting medical debt from consumer reports absent consumer consent. In the near term, state-by-state defense of existing laws and continued data-sharing partnerships with organizations like Undue Medical Debt.

5

Patient data access — machine-readable claims and EOBs via FHIR

The hook: ONC Cures Act information-blocking rules; CMS Interoperability and Patient Access Final Rule (CMS-9115-F); FHIR US Core 6.x; the Patient Access API many MA and Medicaid plans already expose.

What to change: Require that every insured American can, via a standardized FHIR endpoint, pull their own claims, EOBs, denial codes, and plan documents into a consumer-authorized application — the way open banking works in the UK. Without this, patient-side AI is reading paper. With it, the counter-RCM stack above becomes commercially viable to build and scale.

"Break up the biggest insurance companies. They don't need thousands of subsidiaries. That's how they game and abuse the system and increase costs for all of us."
— Mark Cuban on the Break Up Big Medicine Act (Hawley-Warren), March 2026

The revenue cycle already runs. We just have to let it run both ways.

There is a version of this story that ends with "and then a brilliant AI startup solved healthcare." Nothing about the evidence above supports that version. 530,000 families a year go bankrupt in this country because of a financing and enforcement structure, not because of a missing app. If anything, the last three years have shown that frontier AI, left to the current incentive structure, tilts the table further — because the side with money to spend on AI is the side already winning, and the side that needs it the most has no budget, no distribution, and no legal access to the data.

The more honest version is quieter. The same signal that powers an RCM engine can power a benefits engine. The same eligibility logic that drives coverage denial can drive automatic charity-care screening. The same natural-language generation that drafts clawback letters can draft appeal letters. The same claims data that identifies high-cost patients for aggressive collection can identify them for presumptive Medicaid enrollment. There is no technical invention missing. There is a set of policy decisions about whose side the infrastructure sits on — and those decisions, unlike physician pipelines or hospital construction, can be made in months.

Cuban's framing, at the end of the day, is the right one. If you are the CEO of a self-insured employer, an elected official with a healthcare committee seat, an attorney general, a hospital CFO, a nonprofit funder — you do not need to wait for the next model release. You need to decide whether the revenue cycle you authorize runs in one direction or both.

Don't be a wimp.

LET'S BUILD SOMETHING
🔧
WEEK 3 OF 13

Your First Comparison View — All Drugs, All Pharmacies, One Glance

Quick note before we start: a few of you sent screenshots of your Week 2 sheets — thank you, I read every one. The most common reaction was some version of "I can't believe the same drug is $4 at one pharmacy and $42 at another two miles away." That reaction is the whole reason this app is worth building. This week we make that gap impossible to ignore.

Right now your tracker is a list. Useful, but you're still scanning row by row to figure out where to fill what. By the end of today, you'll have a single grid — drugs down the side, pharmacies across the top, cheapest price in each row highlighted. One glance and you know where to go.

PHASE 1 · FOUNDATION (WEEKS 1–3)

  • ✅ Week 1 — Set up your AI workspace + data tracker
  • ✅ Week 2 — Connect real-time pricing sources
  • 🟢 Week 3 — Build your first comparison view ← YOU ARE HERE

PHASE 2 · INTELLIGENCE (WEEKS 4–7)

  • ⬜ Weeks 4–7 — Location-aware suggestions, formulary, AI alternatives, price alerts

PHASE 3 · AUTOMATION (WEEKS 8–11)

  • ⬜ Weeks 8–11 — Automated scans, insurance basics, coupon aggregation, refill optimizer

PHASE 4 · YOUR APP (WEEKS 12–13)

  • ⬜ Weeks 12–13 — Full UI build in Bubble.io + launch

⏱️ THIS WEEK: 15 MINUTES TO THE COMPARISON VIEW

1. Add a Second Tab Called "Comparison" — 1 min

At the bottom of your Google Sheet, click the "+" to add a new tab. Rename it Comparison. Your Week 1–2 data stays exactly where it is on the first tab (rename that one Raw Data if you haven't already). The comparison view is a derived view — it reads from Raw Data, it doesn't replace it. Keeping the source of truth separate from the view is the single most important habit we're building this week. Every real app does this.

2. Paste the QUERY Formula in Cell A1 of the Comparison Tab — 3 min

Click cell A1 on the Comparison tab. Paste the formula below exactly — it pivots your Raw Data into a matrix with drugs as rows, pharmacies as columns, and the lowest price in each cell. Adjust the sheet name in the formula if your Raw Data tab is named differently. If it returns an error, that's fine — step 3 is how we debug it.

=QUERY('Raw Data'!A:H, "SELECT A, MIN(D) WHERE A IS NOT NULL GROUP BY A PIVOT C", 1)
3. If It Broke, Ask Claude (The Point of This Step) — 4 min

QUERY is powerful and picky. If you got #VALUE! or #N/A, open Claude and paste in exactly this prompt, including your column headers and the error message. Don't worry about sounding technical — that's what the prompt is for. The goal isn't to learn QUERY syntax today; it's to practice the loop you'll use for every future problem in this build: describe what you have, describe what you want, paste the error, ask for the fix. That loop is the actual skill.

I'm building a pharmacy price tracker in Google Sheets. My "Raw Data" tab has these columns: Drug, Dosage, Pharmacy, Price, Location, Date Checked, Notes, Price Source. I want a second tab called "Comparison" that shows drugs as rows, pharmacies as columns, and the lowest price for each drug/pharmacy combo in each cell. I tried this formula in A1 of Comparison: =QUERY('Raw Data'!A:H, "SELECT A, MIN(D) WHERE A IS NOT NULL GROUP BY A PIVOT C", 1) It returned: [paste your exact error] What's the fix? Explain it in plain English and give me the corrected formula.
4. Highlight the Cheapest Pharmacy in Each Row — 3 min

Select the price cells in your comparison grid (not the drug-name column, not the header row). Format → Conditional formatting → Custom formula. Paste: =B2=MIN($B2:$Z2) — adjust the column range to match your sheet. Set the highlight to green. Now the cheapest pharmacy for each individual drug lights up down the grid. That's the moment this stops being a spreadsheet and starts being a decision tool. Your eye goes straight to where to fill what.

5. Add a "Monthly Savings" Cell — 2 min

In any empty cell below the grid, type: =SUM(cheapest prices) − SUM(most expensive prices) — or more precisely, pick the min and max of each row and sum the differences. Label the cell "Monthly savings if I switch to the cheapest option for every drug." For most readers this number comes out somewhere between $30 and $200 a month. Write it down. Take a screenshot of the full comparison tab — highlights, savings number, everything. That screenshot is your Week 3 proof of work, and it's the artifact you'll send to anyone who asks why you're building this.

✅ WHAT "GOOD" LOOKS LIKE AFTER 15 MINUTES

  • Two tabs: Raw Data (source of truth) and Comparison (derived view)
  • QUERY formula in A1 of Comparison, pivoting drugs × pharmacies
  • At least one Claude debug loop completed (even if your formula worked first try — practice the muscle)
  • Cheapest pharmacy highlighted green in every row via conditional formatting
  • "Monthly savings" cell populated with a real dollar number
  • Screenshot taken — Week 3 proof of work

If you can look at your Comparison tab and instantly tell me which pharmacy to fill each drug at — and roughly how much it saves you each month — you finished Week 3. The tracker has stopped being a list. It's a decision tool.

One question worth sitting with before next week: did the cheapest pharmacy turn out to be the same one across all your drugs, or different for each? That answer tells you whether you're a one-pharmacy household or a multi-pharmacy household — and it matters a lot for what we build next.

Next week: Location-aware pharmacy suggestions. We layer in driving distance so the comparison view doesn't just show you the cheapest price — it shows you the cheapest price within a realistic driving radius. Sometimes saving $8 isn't worth a 30-minute detour, and sometimes it absolutely is. Week 4 is where your tracker starts respecting your actual life.

Primary sources cited in this issue

Inline citations above link to originals. This list is grouped for readers who want to go deeper.