| Issue Number | 3468 |
|---|---|
| Summary | [Summaries] Ad-hoc report of tables and figures |
| Created | 2012-01-03 17:36:44 |
| Issue Type | Improvement |
| Submitted By | Juthe, Robin (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2012-02-02 09:15:14 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107796 |
BZISSUE::5163
BZDATETIME::2012-01-03 17:36:44
BZCREATOR::Robin Juthe
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
This issue relates to OCECDR-3428 (dynamic table and figure numbering).
We would like to get an idea of how many tables and figures we have in the PDQ summaries in order to help us determine the most logical and manageable implementation of the dynamic table & figuring capability once it is ready to be rolled out.
I think the following information would be helpful, if you are able to generate a query to obtain this information:
-Number of tables in each publishable PDQ summary
-Number of media links (figures) in each publishable PDQ summary
-Number of summary fragment refs pointing to tables in each publishable
PDQ summary
-Number of summary fragment refs pointing to media links (figures) in
each publishable PDQ summary
For the last two items, the summary frag ref could point to a table or figure in the same document or in another CDR document. (I'm not sure if the last two will be feasible, but I figured it didn't hurt to ask!)
Please provide the information in an Excel file if possible with the following columns of data (to allow for sorting):
-CDR ID
-Summary Type
-Summary Audience
-Summary Language
-Summary Title
-Number of Tables
-Number of References to Tables
-Number of Figures
-Number of References to Figures
Thank you!
BZDATETIME::2012-01-04 09:33:59
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
We agreed that we'll use "published" summaries (rather than publishable) for the report.
BZDATETIME::2012-01-13 10:20:31
BZCOMMENTOR::Bob Kline
BZCOMMENT::2
Attachment Request5122.xls has been added with description: Requested report
BZDATETIME::2012-01-19 10:56:46
BZCOMMENTOR::Robin Juthe
BZCOMMENT::3
(In reply to comment #2)
> Created attachment 2214 [details]
> Requested report
This looks good, but I'm having trouble totalling the last four columns with a simple summation formula. [for example: =SUM(F2:F598)]
BZDATETIME::2012-01-19 11:06:07
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4
That's really odd. It appears that the sum function doesn't work on these columns. I am guessing the problem may be that the numbers are listed as text instead of numbers but I'm also not able to change the properties for these columns.
BZDATETIME::2012-01-19 11:09:47
BZCOMMENTOR::Volker Englisch
BZCOMMENT::5
(In reply to comment #4)
> I am guessing the problem may be that the numbers are listed as
text
> instead of numbers
That's it. If you re-enter the numbers Excel will convert the cell content to a number and then the sum() function works properly.
BZDATETIME::2012-01-19 13:01:14
BZCOMMENTOR::Bob Kline
BZCOMMENT::6
Attachment Request5122.xls has been added with description: Version with summable numbers
BZDATETIME::2012-02-02 09:14:56
BZCOMMENTOR::Robin Juthe
BZCOMMENT::7
We have been playing around with this data, and I think we have everything we need, so I'm closing this issue. Thanks!
BZDATETIME::2012-02-02 09:15:14
BZCOMMENTOR::Robin Juthe
BZCOMMENT::8
Closed.
| File Name | Posted | User |
|---|---|---|
| Request5122.xls | 2012-01-19 13:01:14 | |
| Request5122.xls | 2012-01-13 10:20:31 |
Elapsed: 0:00:00.001937