parameter estimates generated in Chapter 1.
» Joining raw data and modeling output on page 150 combines data from two workbooks into a single table, and shows how to recreate WinNonlin 5.2.1’s table template 9 in Phoenix.
» Using custom tables on page 156 shows how to use one of the custom table types provided with Phoenix.
Final Parameters table
This example uses the Table object to create a report-ready table of the final parameter estimates created under Analyzing Multiple Profiles on page 1. That example computed PK parameters for six subjects for both Tablet and Capsule formulations. It used NCA model 200 and the Final Parameters worksheet.
The input data for this example are located in the Phoenix examples directory.
This example will create a table using the parameters Cmax, Tmax, AUCall and AUClast.
Table Type 3
Data for this example are provided in the Phoenix examples directory, which by default is located at C:\Program
Files\Pharsight\Phoe-nix\application\Examples.
Create a new project:
1. Select File > New Project to create a new project. A new project is created in the Object Browser.
2. Name the new project Tables.
Import the data set:
1. Select File > Import or click the Import button. The Open File(s) dialog is displayed.
2. Navigate to the Phoenix examples directory, which by default is located at C:\Program
Files\Pharsight\Phoenix\applica-tion\Examples.
3. Select Profiles Output.xls and click Open.
The Data Import Wizard is displayed. The wizard is used to assign options for how the data are imported and presented.
4. Click the Forward Arrows button.
5. For Final Parameters Pivoted, select the Has units row check box and click the Forward Arrows button.
6. Click the Forward Arrows button.
7. For Dosing Used, select the Has units row check box and click the Forward Arrows button.
8. Click the Forward Arrows button twice.
9. For Summary Table, select the Has units row check box and click the For-ward Arrows button.
10.Click the Forward Arrows button and click Finish. The NCA results work-book is added to the project’s Data folder.
The file Profiles Output.xls adds the following worksheets to the Data folder:
11.View the worksheets by selecting them in the Data folder. Click the (+) sign beside Profiles Output to view the worksheets. Select a worksheet to dis-play it in the Grid tab, which is located in the right viewing panel.
Create the Table:
1. Select the workflow in the Object Browser and then select Insert > Table >
Table.
Note: The Table object can also be added by right-clicking the workflow and select-ing New > Table > Table. Any object can be added by selectselect-ing New in the workflow menu.
The Table object is added to the workflow in the Object Browser.
2. Map the Profiles Output Final Parameters Pivoted worksheet as the input source for the Table object:
• Use the pointer to drag the Profiles Output Final Parameters Pivoted worksheet from the Data folder to the Table object’s Main Mappings panel.
OR
• In the Table Main Mappings panel click the Select source button to open the Select Object dialog.
• Select the Final Parameters Pivoted worksheet and click Select.
The Final Parameters Pivoted worksheet is mapped to the Table object.
Use the Options tab to specify which table type the Table object uses. The Options tab is located underneath the Setup tab.
3. Select Table 3 - Column Detail and Summary by Row Stratification in the Table Type menu.
4. Use the option buttons in the Main Mappings panel to map the data types to the following contexts:
• Map Subject to the Row ID context.
Table type 3 sorts by the row variable within values of the stratification row variable. Table type 3 does not compute summary statistics for each level of the row variable.
• Map Form to the Stratification Row context.
Table type 3 sorts the data by stratification row variable value and
com-These variables provide data for the body of the table.
Note: Select the Table Preview panel in the Setup list to view an example of the final table output.
Select and format summary statistics
1. Select the Statistics tab, which is located underneath the Setup tab.
2. Select the check boxes in the Display column to select the following sum-mary statistics:
Note: The Precision/Alignment menu item in the Options tab allows users to set the number of decimal places or significant figures for each mapped column header and the selected summary statistics, as well as the alignment of the output within each column.
4. Select Precision/Alignment in the Options menu tree. Click the (+) sign beside Precision/Alignment to view the mapped column headers and click the (+) sign beside Statistics to view the selected summary statistics.
5. Select Precision/Alignment > Subject in the Options menu tree.
6. Select 0 in the Value menu.
7. Select Captions in the Options menu tree.
8. In the Caption field type Table 1.
9. Click the Add button.
10. In the Caption field type Pharmacokinetic Parameters.
11.Click the Add button.
12.Select the Column/Sort Order tab, which is located underneath the Setup tab.
The columns in the final table are displayed in the order set here. Use the up arrow and down arrow buttons to change the order in which the Data columns are displayed.
• Select Row Stratification to view study parameter(s) mapped to Row Stratification.
• Select Row ID to view study parameter(s) mapped to Row ID.
• Select Data to view study parameter(s) mapped to Data.
13.Select Data in the Column/Sort Order menu.
14.Select Cmax in the Column Order list and click the up arrow button.
15.Select AUCall in the Column Order list and click the up arrow button.
The Table object’s Style tab is used to change the table display options. The Style tab is located underneath the Setup tab. Select different items in the Style menu tree to change the font, font size, font color, and alignment. Style selections are not necessary for this example.
16.Click the Execute button. The results are displayed on the Results tab.
Table type 3 results