- Before
- Four studies open and two reports due this month. “I sign for every number. I want to see where each one came from without opening twelve spreadsheets.”
- Now
- Opens a full draft beside the raw data, points at any number to see its cell, fills or states each blank, and signs.
One 28-day study, from raw data to a signed draft
VLT-TOX-028: Veltrimab, a humanised antibody, given subcutaneously once a week to Sprague Dawley rats at 0, 10, 30 and 100 mg/kg/week for 28 days, with a 14-day recovery period — 80 main-study and 20 recovery animals. The data package arrived on 05 Oct 2026 and the report is due on 16 Oct. Here is what happens next, screen by screen, in the working solution.
- 01Next morning
The draft on the left, the raw data on the right
Dr. Lena Ortiz · Study directorOvernight the agents read study plan v2.0 with amendment 1, the 13 raw data tables, repeat-dose template v5.2 and Sam Patel's signed toxicokinetics report, and drafted all 9 sections. Lena opens a split screen: the report in the house template beside the export, read-only and locked. The header reads 156 traced, 1 blank, 2 gaps, 3 of 9 sections approved.
“VLT-TOX-028 drafted overnight — 9 sections, 1 value left blank, 2 gaps.”
- 02Section 4.2
Point at a number and its cell lights
Dr. Lena Ortiz · Study directorIn males at 100 mg/kg/week, body weight gain over Days 1–29 was 142.7 g against 156.8 g in controls (−9.0%; p<0.05). Lena points at the −9.0% and both cells it comes from light in BW_Males — E7 and B7 — with the calculation and every section that uses the cell: 1, 4.2 and 5.
“(142.7 − 156.8) ÷ 156.8 = −9.0% · cells E7 and B7.”
- 03One red blank
The export has no Week 4 weighing — so the report says so
Section drafterCell E5 of FC_Males, Week 4 food consumption for Group 4 males, is empty in the export of 05 Oct 2026. The study log records the weighing on 12 Sep by Ana Kowalski; that day's balance file was never transferred. The drafter wrote no number and no 4-week mean — the sentence reads “not in raw data”.
“The agent left the report blank — no estimate, no carry-forward from the week before.”
- 04Blanks and gaps
What the plan requires and the package does not hold
Gap finderThe gap finder lists the blank, which blocks signature, and a second blocking gap: study plan §9.4 requires microscopic examination of Groups 1R and 4R at the recovery necropsy, and MI_Recovery.xlsx is not in the package. A minor item asks Lena to confirm one excluded value — a Week 3 weighing for cage M-4-07, recorded as spilled — and confirming it adds a note on the exclusion to the food consumption results.
Study plan §9.4: “…examined microscopically for all animals in Groups 1 and 4 at the terminal and recovery necropsies.”
- 05One click
Ask the technician, and the blank becomes a traced number
Ana Kowalski · Study technicianLena clicks “Ask Ana Kowalski”. The corrected export, VLT-TOX-028_FC_v2.xlsx, comes back signed and versioned — the first export stays in the record. Week 4 is 25.9 g/animal/day; the raw data reader checks it against the plan, the section drafter redrafts 4.2 with the 4-week mean of 25.3 against 26.6 g/animal/day in controls (−4.9%), and the consistency checker finds 0 mismatches.
“Blank filled from VLT-TOX-028_FC_v2.xlsx — section 4.2 redrafted.”
- 06Recovery data
Recovery histopathology in, three sections redrafted
Dr. Omar Haddad · Study pathologistLena requests the recovery data from Dr. Omar Haddad. MI_Recovery.xlsx arrives for 20 animals, signed by him. The drafter rewrites 4.5 Histopathology — after 14 days without treatment, no hepatocellular hypertrophy at 100 mg/kg/week (0/5 males, 0/5 females) and a minimal injection-site infiltrate in 1/5 males — and updates the Summary and the Conclusion with reversibility and the NOAEL.
“Gap resolved — recovery findings added to sections 4.5, 1 and 5.”
- 07The proposal
The NOAEL is proposed, not decided
Section drafterFindings at 100 mg/kg/week — lower male weight gain, ALT 53 against 38 U/L and minimal to mild centrilobular hepatocellular hypertrophy in 4 of 10 males — had no degenerative correlate. Before the recovery data, the draft proposed a NOAEL of 100 mg/kg/week, the highest dose tested, “subject to the recovery data”. With the data in, the conclusion states reversibility and that NOAEL — still the study director's call.
The section drafter never decides adversity or the NOAEL on its own — it proposes them and marks them for the study director.
- 08Sign
She signs version 1.0 with a stated meaning
Dr. Lena Ortiz · Study directorThe signature screen shows what she is signing: VLT-TOX-028 study report version 1.0, 166 numbers traced to source, and a warning that 6 sections are not yet marked as reviewed — signing approves the whole report. She chooses the meaning “Study director approval — release to Quality Assurance for audit” and enters her password.
“The signature is linked to this exact version, with your name, the date and time and its meaning, and is kept in the audit trail.”
- 09Signed
Locked, and on its way to the auditor
Dr. Maya Chen · Quality AssuranceThe report is locked as final v1.0 with all 9 sections approved, 166 numbers traced, 0 blanks and 0 gaps. It goes to Dr. Maya Chen for the Quality Assurance audit, and the export carries the number-to-source trace and the gap list, with how each was closed, as appendices.
“Signed — VLT-TOX-028 v1.0 sent to Quality Assurance for audit.”