- Before
- Spends the days after the data package arrives re-keying tables and checking numbers, not interpreting the study.
- Now
- Starts from a full draft with every number linked to its cell and the gaps listed; spends her time on adversity, the NOAEL and her signature.
One study report, from data package to signature
VLT-TOX-028 is a 28-day subcutaneous toxicity study of Veltrimab in Sprague Dawley rats, with a 14-day recovery period. Its data package arrived on 05 Oct 2026; the report is due Oct 16. Here is what happens next, screen by screen, in the working solution.
- 01Morning
Every report that needs her, on one screen
Dr. Lena Ortiz · Study directorLena opens the solution: 3 reports in scientist review, 3 data packages ready to draft, 1 open gap and 4 reports signed in the last 30 days. VLT-TOX-028 sits at the top of her list — 13 tables received, ready to draft. Two other reports are already being drafted.
Consistency checker: “1,204 numbers re-checked today · 0 mismatches”
- 02Data received
The data package, checked in
Dr. Lena Ortiz · Study directorFour inputs, each marked received: the study plan v2.0 with amendment 1 (18 pages, signed 04 Aug 2026), the raw data package — 13 tables and 3,842 values across BW, FC, CL, LB, OM, MA, MI and TK — the repeat-dose report template v5.2 with its 9 sections, and the toxicokinetics contributing report signed by Sam Patel on 01 Oct 2026.
- 03One click
“Draft the report” — and every step is on screen
The agentsThe study plan reader finds 4 groups, 100 animals plus 42 for toxicokinetics, and 9 report sections required. The raw data reader loads all 13 tables. The table builder fills the report tables straight from the source cells, section drafters write all 9 sections in parallel, and the consistency checker compares 152 numbers with their source — 0 mismatches.
“Report tables built straight from source cells — nothing re-keyed”
- 04Seconds later
A draft ready for review, with its gaps up front
Dr. Lena Ortiz · Study director9 sections drafted, 152 numbers traced to source, 0 tables re-keyed, 2 gaps to resolve. The gap finder puts them first: recovery-group histopathology is missing from section 4.5, which blocks signature, and one food consumption value was excluded in section 4.2, which needs her confirmation.
- 05Review
Section 4.2, where every number is a link
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), with food consumption of 25.3 against 26.6 g/animal/day. Hovering any number shows the table, row, column and cell it came from; a percent change shows both cells and the formula.
Source cell: Food consumption — males (g/animal/day) · Mean Weeks 1–4 · Group 1 · control · FC_Males · B6
- 06One click on a number
The source table, with the cell highlighted
Dr. Lena Ortiz · Study directorClicking 142.7 opens Body weight — males (g) from VLT-TOX-028_BW.xlsx, with group means, SDs and significance markers, and the cell itself highlighted: Gain Day 1–29 · Group 4 · 100 mg/kg/week = 142.7, BW_Males cell E7.
“Raw data is read-only. The agents copy the cell reference, never the typed value.”
- 07Confirmed
A minor gap, stated in the report
Dr. Lena Ortiz · Study directorWeek 3 food consumption for cage M-4-07 (Group 4 males) was left out of the group mean. The raw data note says why: “Food spilled — weighing invalid.” Lena confirms the exclusion, and the section drafter adds a note under Table 4-1 saying so, and that it did not affect the interpretation.
- 08The blocker
Recovery histopathology: required by the plan, missing from the package
Gap finderThe gap quotes its evidence. Study plan v2.0, section 9.4, requires microscopic examination of Groups 1 and 4 “at the terminal and recovery necropsies”. The data package manifest lists MI_Terminal.xlsx, but MI_Recovery.xlsx is not present — so sections 4.5, 1 and 5 cannot state whether the liver findings are reversible.
Two choices on the gap: “Request from pathology” or “Add a statement” — a pending-data statement in the report.
- 09Requested
The recovery data arrives, and only those sections are redrafted
Dr. Omar Haddad · Study pathologistLena chooses “Request from pathology”. Dr. Omar Haddad provides MI_Recovery.xlsx — 20 animals, signed 06 Oct 2026. The section drafter rewrites 4.5 and updates the summary and conclusion; the new numbers are traced to the recovery table with 0 mismatches. After 14 days without treatment, no hepatocellular hypertrophy remained at 100 mg/kg/week (0/5 males, 0/5 females).
- 10Signed · 06 Oct 2026
Approved section by section, then signed
Dr. Lena Ortiz · Study directorLena approves all 9 sections and signs version 1.0: 158 numbers traced to source, no open gaps. She enters her password and picks the meaning of the signature. The signature is linked to that exact version, the report is locked, and it goes to Dr. Maya Chen for the Quality Assurance audit.
“Signed by Dr. Lena Ortiz, Study Director · 06 Oct 2026 · 09:23 UTC” · Meaning: “Study director approval — release to Quality Assurance for audit”