IVRT Validation Formatter

One workbook per run, all of them at once. A validation study is not one experiment but a dozen — repeatability across analysts and days, discrimination across strengths, robustness to stir speed, temperature and receptor solution. Each run is its own workbook; this reads them together into the FDA Sample IVRT SAS Transport dataset — Raw Measurements Data layout, one row per diffusion cell.

1 Load the run workbooks

Drop every run’s workbook here — all of them at once

.xlsx / .xlsm / .csv · one file per run · select them all and drop them together, or add them a few at a time

Choose files…

Your files are read by the browser itself and never leave this machine.

Run	From the workbook	Read	Cells × points	Arms

Add more runs…

3 Define the treatments

One line per distinct value found in each run’s treatment column, so an arm is always read against the run it was measured in. Set what each one means — RANDCODE, TRT, PRODUCT and PRODUCT STRENGTH are all filled from here. PRODUCT is not a separate decision: it follows TRT exactly. Untick Include for anything that is not a treatment arm — a receptor blank or other control — and its cells are left out of the table entirely. If one workbook holds two groups of the same formulation — a dose-variation run dosed at 900 and at 1100 mg under one code — Set by document in step 2 and tick split code for that run; each group is then an arm here with its own RANDCODE. A PRODUCT STRENGTH typed in step 2 fills every arm that has none, and can be changed here per arm.

Include	Run	Value in sheet	Rows	RANDCODE	TRT	PRODUCT	PRODUCT STRENGTH

IVRT Validation Formatter

4 Formatted table

Sample IVRT SAS Transport dataset