Hi! I’m struggling it setting up a workflow for a multiple dose study (cross-over, no washout). I have predose dose values 1-4, profile 1 (period 1), predose 5-8, profile 2 (period 2). So far so good. Since a switch-over was used, the first predose is coded in the result file to period 2. But I need this value also as the last one for NCA of profile 1. My worflow needs 8 steps: Filter for period 1 Filter for the first PD of period 2 Filter for the remaining values in period 2 Transformations: Substract 1 from period-code in the first PD of period 2 (I get a new column) Subtract the dosing interval (I get a new column) Filter to get rid of the old columns (period, time) New column properties (change the new columns to the old names) Append 4 worksheets (period 1, the transformed values, the first PD of period 2, period 2) Since such a design is not uncommon, do you have a less clumsy way of coding?
Helmut - I think we may be able to rationalise that - however it would be easier for me to visualize if you can attach an example project; would that be possible. Simon
Hi Simon! [quote]Helmut - I think we may be able to rationalise that […][/quote]I‘m sure See attached. I took me nine steps (not eight). The time points of administration in both profiles are set to zero, predose values in the saturation phase have negative values. sample id 125 was original coded as the first predose in period 2; I doubled it to get a 24 h value in period 1. Don’t be shocked by the profile – it’s a pulsatile formulation acting like two IR doses four hours apart. BTW, why is there no marker at -72 h in period 2? Temporarily switch on data labels for #2: nothing there, but a line is drawn… [file name=Multiple_dose.phxproj size=364756]Certara | Drug Development Solutions Congrat’s! Your post # 100!Multiple_dose.phxproj (356 KB)