I have been experiencing an issue while reporting Tables.
I correctly formated the table on Phoenix. However, when I report to a word doc (as word table), the table loses the previous format (e.g. subscript, text allignment).
I kindly ask if anyone as a suggestion to solve this issue.
Moreover, I ask if it is possible to create custom table formating in Phoenix, such as removing borderds.
Hi Sara, this is a known issue (QC 17944, QC 17945) that was addressed in 8.3 which has just been released. Please take a look at the online help and look at the release notes to see what else has changed and may help you in planning your upgrade.
I also encountered problems with custom tables.
I customized the Table style through xml, which can be displayed normally in the “Table” results, but the format has changed when I export the Table to Word using “Report”.
I also tried to use the “R shell” to draw the table. Similarly, it can be displayed normally in the “R shell” results, but the format has changed when exporting to the Word using “Report”.
Now I am trying to imitate the css style of the “Table” table, complete the definition of the table style in R language and then use “Report” to export to Word again.(I haven’t implemented it yet)
Hi 0521, I am not sure I follow your problem, if you want to send your project to support with an example of what you are trying to create then we can try to take a look.
PS Sara - at the moment I don’t think you can easily remove the borders with the built in tables, what I have normally done is apply a format afterwards in word if needed. I think some cleints have Word macros to apply a house style in the report.
However I think some futher simple format options could be a possiblity, can you perhaps take the attached Word document and format the table how you would like, and then I will see what I can suggest.
I saw 8.3, I downloaded it and tried to install and use it.
But I encountered some problem.
Phoenix8.2 was originally installed on my computer. I did not uninstall 8.2 and directly started the installation of 8.3.
The installation process was smooth,
But, after completing the installation, the version displayed after starting Phoenix is still 8.2.
I came to the Windows control panel and found that Phoenix is 8.3 in the control panel. Then I tried to uninstall Phoenix in the control panel, but found that it could not be uninstalled. After clicking Uninstall, it came back to the installation interface.
Apologies but if you have already downloaded 8.3 before today (18Jun2020), then please can you re-download https://lp.certara.com/Download-Phoenix-8.3.html , the build itself hasn’t changed but we found a small issue with the installer package.
Since Phoenix does not report the confidence interval for ω, I tried to manually calculate the 95% confidence interval for ω.
Before calculating the confidence interval of ω, I calculated Theta’s 95% confidence interval. When calculating Theta’s 95% confidence interval, I found that Phoenix did not use the “estimated value ±1.96SE” to calculate the 95% confidence interval, but Use the “estimated value ±1.9759SE” to calculate the 95% confidence interval.
Could you explain why this is?
The table below is an example of my calculation using the Theta table of Phoenix’s “Pheno” file.
[attachment=3518:plot.jpg]Compute.xlsx (12.9 KB)
It’s a matter of preference, but I think the t-distribution is more commonly used since it takes into account the degrees of freedom. The Normal and Student’s t distributions are very close when there are at least 30 DF, as you saw in the example you sent.
Another question, regarding tables formation. When creating a table, is it possible to maintain the decimal places defined in the dataset? Because, Precision/Alignment option automatically sets the same decimal places to all elements in a column, and I wanted them to maintain the decimal places defined in the dataset.
Sorry Sara but no I don’t think this is feasible. the presentation control on the worksheets is only controlling to how many places a value is displayed. the true number is still stored underneath and this is totally separate to how the tables are constructed in HTML
However you could template or save object settings for your reporting table to round them to the value you want to display.