The spreadsheet is a Microsoft Excel workbook called CCAS Sub-Panel Meeting 2011 v1.0.xls consisting of five tabbed worksheets. The workbook may be downloaded from the Pay Pool Notices section of 2Net located at . The workbook and must be initially comes “empty” populated with data by importing a file. 2Net, a database application written in Oracle, creates the import files. Any time a file is imported into the workbook, all existing data are cleared The five tabbed worksheets are described in this and replaced with data from the imported file. document in the order in which they appear along the bottom of the workbook. Page 2 Contents ……………………………………..…….. 4 Data ………………………………………………... Assigning Scores on the Data 7 Sheet…………. Data 9 Sheet Column Descriptions...…………. 14 Matrix …………………………………………….... 15 Rails Report ……………………………………….. 16 Current OCS Scatter Plot ………………………….. Inferred OCS Scatter Plot 18 ……………………….. Group into Categories 19 ……...……. ……….………. Prepared by: SRA International, Inc. 1777 410, The views, opinions, and findings contained in this document are those of the authors and should not be construed as an official Department of Defense position, policy, or decision unless so designated by other official documentation. Contents This worksheet, shown below, is the first sheet you will see after you open the workbook and activate the macros. It provides a brief description of the workbook, its purpose, and contents. The right side of the sheet helps you import and export files, navigate around the workbook, and generate Part I of the Appraisal Forms. The cycle year is displayed in the upper left corner just below the red title bar. The date and time of the last import and export of files into and out of the workbook are shown in the upper right corner.
The spreadsheet is a Microsoft Excel workbook called CCAS Sub-Panel Meeting 2011 v1.0.xls consisting of five tabbed worksheets. The workbook may be downloaded from the Pay Pool Notices section of 2Net located at . The workbook initially comes “empty” and must be populated with data by importing a file. 2Net, a database application written in Oracle, creates the import files. Any time a file is imported into the workbook, all existing data are cleared and replaced with data from the imported file. The five tabbed worksheets are described in this document in the order in which they appear along the bottom of the workbook. Page Contents ……………………………………..…….. 2 Data ………………………………………………... 4 Assigning Scores on the Data Sheet…………. 7 Data Sheet Column Descriptions...…………. 9 Matrix …………………………………………….... 14 Rails Report ……………………………………….. 15 Current OCS Scatter Plot ………………………….. 16 Inferred OCS Scatter Plot ……………………….. 18 Group into Categories ……...……. ……….………. 19 Prepared by: SRA International, Inc. 1777 410, The views, opinions, and findings contained in this document are those of the authors and should not be construed as an official Department of Defense position, policy, or decision unless so designated by other official documentation. Contents This worksheet, shown below, is the first sheet you will see after you open the workbook and activate the macros. It provides a brief description of the workbook, its purpose, and contents. The right side of the sheet helps you import and export files, navigate around the workbook, and generate Part I of the Appraisal Forms. The cycle year is displayed in the upper left corner just below the red title bar. The date and time of the last import and export of files into and out of the workbook are shown in the upper right corner.