What this card shows
The Donor sperm in stock over time, with projection card is a chart of how many donor sperm devices (straws and vials) your clinic held in storage at the end of each month, with a projection three months ahead.
The chart has four parts:
In stock (blue line): the devices in storage at the end of each month. The point for the current month is today's stock, so it matches the Donor sperm in stock card above the chart.
Newly frozen (green bars, right-hand axis): the devices frozen in each month.
Projected at the recent rate (dark pink dashed line): today's stock carried forward at the average net change of the last six complete months, counting both new devices frozen and devices taken out of storage.
Projected with no new donations (light pink dotted line): today's stock carried forward with no new devices frozen and devices still leaving storage at the recent rate. It is a deliberate worst case.
The stock line is rebuilt from each device's history: a device counts from the month it was frozen until the month it was thawed, for any reason, or shipped out to another clinic. A device counts as donor sperm stock when it is recorded as donated. A donor's own samples, frozen for their own future treatment, are not counted.
The projections are a straight-line extrapolation, not a forecast. They assume the recent rate simply continues, and they know nothing about donors you are about to recruit, recipients already booked, consents about to expire, or whether the remaining donors are the ones your recipients can be matched to. Both projections start from the current month, which is still filling in, so they shift as the month goes on. Neither goes below zero.
Reading the card
Hover over a point or bar to see the month and its exact value. The stock line and both projections are read against the left-hand axis, the Newly frozen bars against the right-hand axis.
The chart shows the last 12 months, the current month and the next three months. To show more or fewer months of history, open the card by clicking its title and change Months of history.
The dashboard's Date filter does not apply. The stock at the end of a month depends on everything frozen and taken out before it, so the card always works through the full history.
The Clinic filter at the top of the dashboard narrows the chart to the clinics you choose. Here, clinic means the site the storage tank belongs to, so a device counts toward the clinic where it is physically stored.
A date recorded outside a plausible range is moved to the nearest plausible date rather than dropped: a freeze date in the future counts in the current month. This keeps the line in step with the Donor sperm in stock card.
Where this data comes from
The card reads the cryostorage records in wawa. A device counts as donated when, on the sample's storage devices, its Freeze purpose or Use status is set to a donation value: Donation or Known donation for the freeze purpose, Donation or Donated to bank for the use status. The month a device joins the stock is its Freeze date, or the sample's freeze date when the device has none.
A device leaves the stock when it is thawed, with the Thaw button on the sample page or Thaw in the device's actions menu. The Thawed at date decides the month. Every thaw counts here, whatever its Reason: treatment, discard, test thaw, research or any other.
A device also leaves the stock when it is shipped to another clinic with Ship in the device's actions menu.
Opening this card
In wawa, open Insights from the sidebar, then go to Standard Reports → Donor → Donor and choose the Sperm tab. The Donor sperm in stock over time, with projection card is on the left, below Donor sperm in stock.