RFP_CRM_Matrix_03MAY2012.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- R2667
About this file
CRM Matrix
View the file
Other files
Show all 18
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions Sheet
| STANDARDIZED COMMENT MATRIX |
| Column 1 – ITEM |
| Numeric order of comments. Accomplish when all comments from all sources are entered and sorted. To number the matrix rows, highlight this column only and then select the numbering ICON on the formatting tool bar. |
| Column 2 - # |
| Used to track comments by source. Manually enter numbers from the first comment to the last comment. These numbers will stay with the comment and will not change when consolidated with other comments. |
| Column 3 – SOURCE |
| Column 4 – TYPE |
| C – Critical (Contentious issue that will cause non-concurrence with publication) |
| M – Major (Incorrect material that may cause non-concurrence with publication) |
| S – Substantive (Factually incorrect material) |
| A – Administrative (grammar, punctuation, style, etc.) |
| Column 5 – Document |
| What document did comment originate from? |
| Column 6 – Section |
| Section that pertains to the comment expressed. (i.e. 4a, 6g, etc |
| Column 7 – Para |
| Paragraph Number that pertains to the comment expressed. (i.e. 4, 6, etc.) |
| Column 8 – LINE |
| Line number on the designated page that pertains to the comment, expressed in decimal form (i.e., line 1=1, line 4-5 = 4.5, line 45-67 = 45.67, etc.) For figures where there is no line number, use "F" with the figure number expressed in decimal form (i.e. figure II-2 as line number F2.02). For appendices, use the "F" and the appendix letter with the figure number (i.e appendix D, figure 13 as line number FD.13; appendix C, annex A, figure 7 as line number FCA.07) |
| Column 9 – COMMENT |
| To facilitate adjudication of comments, copy and insert complete sentences into the matrix. This makes it unnecessary to refer back to the publication to understand the rationale for the change. Do not use Tools, Track Changes mode to edit the comments in the matrix. Include deleted material in the comment in the strike through mode. Add material in the comment with underlining. Do not combine separate comments into one long comment in the matrix. |
| Column 10 - RATIONALE |
| Provide concise, objective explanation of the rationale for the comment. |
Attachment 2
Tips and Tricks of the Trade
| TIPS AND TRICKS OF THE TRADE | |
| Headers and Footers | |
| 1. | Publication name |
| 2. | Classification (Unclassified/Secret/ etc.) |
| 3. | Column headings |
| 4. | Filename (insert from header/footer drop down menu) |
| 5. | As of “date” (insert from header/footer drop down menu—manually enter date when finalized for tracking purposes) |
| 6. | Page X of Y (insert from header/footer drop down menu—manually enter last page number for Y when finalized—tracks total # of pages and does not default back to actual page #) |
| Combining Matrixes | |
| 1. | Select all and correct for font and font size (Times New Roman, #10). |
| 2. | Copy one entire matrix and paste it a few lines below the last row of another matrix. |
| 3. | Adjust column widths as necessary to match one matrix with the other (use the column headings in the document header as a guide). |
| 4. | Merge the matrices into one by deleting the lines between the two. |
| Item (row) numbering (automatic numbering) | |
| 1. | Highlight column number 1 from top to bottom. |
| 2. | Delete the existing number and then renumber by selecting automatic line numbering on the formatting tool bar. |
| Sorting | |
| 1. | Select: “Table” on top menu toolbar. |
| 2. | Select: “Sort.” |
| 3. | Select: “Sort by, Column 5 (Page column), Number, Ascending.” |
| 4. | Select: “Then by, Column 7 (Line column), Number, Ascending.” |
| 5. | Select: “Then by, Column 4 (Type column), Text, Descending.” |
Attachment 2
CRM
| C2AOS/C2IS Comment Resolution Matrix | |||||||||
| Item | # | Source | Type | Document | Section | Para | Line | Comment | Rationale |
Attachment 2
File details come from the government source that posted it. Updated .