Hi Simon, I followed the training on Phoenix on site in Beerse (Janssen) given by you. I have a question regarding a calculation I would like to make. I’ve added a file which comes from our bioanalytical department. As you can see one of the headers is called Matrix, with beneath that two matrices plasma and brain. If I’m correct, when you want to make a calculation within phoenix, one needs to divide one column by another column, but in this case the calculation needs to be made within one column, as I would like to calculate the individual brain to plasma ratio. How can a redesign my file in Phoenix so that I can have two matrices columns next to each other. I got as far as splitting it into two workbooks, but as soon as you merge your files Phoenix puts the two matrices on top of each other again. Hope you can help me out, Thanks a lot, Karin Vaarties [file name=question_pharsight.xls size=29184]/extranet/media/kunena/attachments/legacy/files/question_pharsight.xls[/file]question_pharsight.xls (28.5 KB)
Hi Karin, It’s simply a case of getting sufficient ID vars to merge, but not so many that you put them back onto separate lines again e.g. you DO NOT want to include Matrix in the merge sorts; I used the following; but it could probably be refined. /********************************* Begin Mappings *********************************/ Worksheet 1 : raw_data_ratio.Workflow.Split Worksheet.plasma Sort : Compound_dosed, Species, Route, Dose, Subject, Time, Dose_Units, Time_units Included Column : Concentration, Concentration_Units, LLOQ, LLOQ_Units Worksheet 2 : raw_data_ratio.Workflow.Split Worksheet.brain Sort : Compound_dosed, Species, Route, Dose, Dose_Units, Subject, Time, Time_units Included Column : Concentration, Concentration_Units, LLOQ, LLOQ_Units Sort Map :
rawratio.zip (512 KB)rawratio.zip (512 KB)raw_data_ratio63.phxproj (300 KB)raw_data_ratio63.phxproj (300 KB)
