Weekly Pipeline Dashboard Project (Sample Data Used)

Section 1:

Open deal: any deal whose stage is not Closed Won or Closed Lost.
Open pipeline: the total Amount of all open deals.
Weighted pipeline: Amount × Probability for each open deal, added together. It estimates how much revenue is realistically likely to close.
Probability tier: Low (≤35%), Medium (>35% to ≤70%), and High (>70%).
Data source: a Google Sheet of 30 made-up deals (sample data), refreshed manually.
Validation: I compared HubSpot deals board totals with separate formulas in the source sheet and Data Studio, and they matched (screenshot attached).