ENERGY DATA SYSTEM DEVELOPMENT AND MAINTENANCE FINAL REPORT CONTRACT NUMBER 68-02-2399 EPA PROJECT OFFICER: ROBERT L. SHORT STRATEGIES AND AIR STANDARDS DIVISION OFFICE OF AIR QUALITY PLANNING AND STANDARDS RESEARCH TRIANGLE PARK, NC 27711 PREPARED FOR: U.S. ENVIRONMENTAL PROTECTION AGENCY OFFICE OF AIR QUALITY PLANNING AND STANDARDS RESEARCH TRIANGLE PARK, NC 27711 MARCH 1980 CSC COMPUTER SCIENCES CORPORATION ------- EPA 450/5-80-005 March 1980 ENERGY DATA SYSTEM DEVELOPMENT AND MAINTENANCE Final Report By f Thomas' Dessent Computer Sciences Corporation 5529 Chapel Hill Boulevard Durham, North Carolina 27707 Contract Number 68-02-2399 EPA Project Officer: Robert L. Short Strategies and Air Standards Division Office of Air Quality Planning and Standards Research Triangle Park, NC 27711 Prepared For: U.S. ENVIRONMENTAL PROTECTION AGENCY Office of Air Quality Planning and Standards Research Triangle Park, NC 27711 ------- DISCLAIMER This report has been reviewed by the Strategies and Air Standards Division, Office of Air Quality Planning and Standards, U.S. Environmental Protection. Agency, and approved for publication. Approval does not signify that the contents necessarily reflect the views and policies of the U.S. Environmental Protection Agency, nor does mention of trade names or commercial products constitute endorsement or recommendation for use. ii ------- Table of Contents Introduction. Overview of the Energy Data System 3 Status of the Energy Data System 6 Summary of Work Performed 7 Appendix A - Summary of Contract Activities by Task iii ------- INTRODUCTION This report describes the work performed by Computer Sciences Corporation (CSC) for the U.S. Environmental Protection Agency (EPA) under contract number 68-02-2399 during the forty-two month period of performance that began 20 August 1976 and ended 20 February 1980. Under the terms of the contract, CSC provided technical support to the Strategies and Air Standards Division (SASD), Office of Air Quality Planning and Standards (OAQPS), Research Triangle Park, North Carolina, for development, implementation, maintenance, and operation of the Energy Data System (EDS), a computerized data base. Work was performed in units designated "tasks" that were initiated by the EPA Project Officer, who provided verbal and written technical direction that specified the objective or scope of work for each task. In response to the technical directive, CSC prepared and presented to the Project Officer a plan of work that proposed the methodology, resources, and schedule for accomplishing the task objective. After the Project Officer approved the work plan, the work was performed and deliverable items were submitted to him for review. After all deliverable items of the task had been approved, the task was closed and no further resources were expended on it. The Project Officer was informed by CSC of the progress of work by informal discussions during meetings with him at intervals of two weeks (or more frequently if necessary), and by written reports (biweekly status reports and monthly progress summary reports). As a result of those discussions and reports, the Project Officer sometimes altered the scope of work for tasks to take into account new information or changed circumstances. Such alter- ations of scope included both the termination of projects found to be infeasible or impractical, and the expansion of projects to include additional features or to satisfy additional requirements. ------- The tasks performed by CSC included work in the following general categories: (1) EDS software development and maintenance - the implementation of new computer software for loading data into or retrieving data from the EDS data base, the modification or correction of existing software, and of documentation of both. (2) EDS data base maintenance - acquisition of data, execution of updates, validation of data, creation of backups, and related activities contri- buting to the availability, accuracy, and timeliness of information stored in the data base and ancillary data files, (3) Data retrieval and analysis - implementation of procedures for obtaining from EDS information requested by SASD personnel or by others through SASD. (4) Special projects - other work related to EDS but not included in the preceding categories. The following sections of this report present an overview of the Energy Data System, its status at the end of this contract, and a summary of the work performed by CSC. A task-by-task description of technical activities is presented in Appendix A. ------- OVERVIEW OF THE ENERGY DATA SYSTEM The Energy Data System was developed by the Strategies and Air Standards Division as a tool for assessing the effects on air quality of energy policies and environmental legislation. The computerized data system stores information related to the consumption of fossil fuels by electric power plants and large industrial plants, and to their emissions of three atmos- pheric pollutants: suspended particulates, sulfur oxides, and nitrogen oxides. The system also stores summaries of nationwide measurements of ambient air concentrations of those pollutants. The primary sources of information are other computerized data systems maintained by the Power Statistics Branch, Energy Information Administration, U.S. Department of Energy; and by the National Air Data Branch (NADB), Monitoring and Data Analysis Division, OAQPS, U.S. EPA. Additionally, SASD environmental engineers provide information pertaining to emission regulations and environmental policies. EDS has been implemented on the Univac 1100 computer at the EPA National Computer Center, Research Triangle Park, North Carolina. The Energy Data System is comprised of two major parts: a data base that contains -the information, and associated software for maintenanace and use of the data base. Briefly, the associated software consists of programs and procedures for updating the data base, ancillary reference data files, and programs and procedures for extracting, computing, and reporting selected information. The EDS data base has been implemented using the System 2000* data management language, which provides a hierarchial data structure and allows access to the stored information via simple data management language commands as well as computer programs. The EDS data base structure has two major parts: one that contains information related to fossil fuel combustion by power plants and industrial plants, and another that contains information related to ambient air quality measured by pollutant monitoring stations. *System 2000 is a registered trademark of MRI Systems Corporation, Austin, TX. ------- The most comprehensive and detailed type of information in the EDS data base pertains to electric power plants. Much of the power plant data are obtained from the Department of Energy FORM-67 data file, which provides detailed infor- mation about the physical equipment, operating conditions, and the quantity and quality of fuel consumed. Additional data on fuel procurements, fuel use, electric generation, and future generating capacity are obtained from other • Department of Energy data files: FORM-423, FORM-4, and Generating Units Reference File (GURF). New or revised emission regulation data are periodi- cally supplied by SASD engineers. Annual emissions of suspended partlculates, sulfur oxides, and nitrogen oxides are computed for each power plant using FORM-67 data and stored in the data base. Other miscellaneous types of data have been loaded into the data base as they became available and/or were needed for special projects. Such miscellaneous data have included results of diffusion modeling studies, calculated maximum allowable pollutant emissions (based on emission regulations), and designation of geographical areas not in attainment of Federal ambient air quality standards. The information in EDS pertaining to industrial plants is abstracted from the National Emissions Data System (NEDS), a computerized EPA data system maintained by the National Air Data Branch. The industrial plant data abstracted from NEDS pertain to three types of industrial processes: those involving external combustion boilers, internal combustion boilers, and inprocess fuel use. The EDS representation of industrial plant data is the same as for power plant data; that is, a plant is considered to have one or more "boilers" which burn fuel and emit pollutants that may be partially collected by pollution control equipment, and are exhausted through one or more stacks. Thus, the EDS data base contains data which characterizes the "boilers," stacks, and pollution control equipment. In addition, EDS contains vales abstracted from NEDS for calculated "boiler" emissions of suspended particulates, sulfur oxides, and nitrogen oxides; the maximum amounts of those emissions permitted by applicable environ- mental regulations or permits; and the amounts of other "waste products" produced per year of plant operation. ------- Ambient air quality data in EDS is abstracted from the EPA Storage and Retrieval of Aerometrlc Data (SAROAD) system, also maintained by the National Air Data Branch. The SAROAD system contains a huge volume of data, consisting of the ambient air concentrations of numerous pollutants as measured by an extensive nationwide network of air sampling and pollu- tant measurement devices. Only a small subset of those data are abstract- ed from the SAROAD system and stored in the EDS data base. The EDS air quality data consist of yearly summaries of information pertaining to meas- ured atmospheric concentrations of total suspended particulate, sulfur dioxide, nitrogen dioxide, and sulfate; and information characterizing the pollution monitoring equipment in terms of geographical location, measurement method, and sampling frequency. A variety of System 2000 data management language commands have been devel- oped by SASD and CSC personnel for retrieving information from the EDS data base and producing printed reports. The most useful and generally applicable of those commands have been collected together in one file and have been "documented" by storing abstracts of them in another System 2000 data base, named ASSIST. The ASSIST data base may be queried to determine which of the existing EDS data retrieval commands may be applicable to a particular subject area. The command(s) thereby indentified may be obtained from the common command file and used "as is" or with appropriate modifica- tion to retrieve the desired information from EDS and present it in a printed report. The Energy Data System provides a unique combination of related data from disparate sources, organized in a hierarchial logical structure, from which data retrieval may be accomplished with simple directives. EDS therefore represents a valuable information resource for EPA. ------- STATUS OF THE ENERGY DATA SYSTEM As of the end of the period of performance of this contract (February 1980) the Energy Data System was in a static state, and was in the process of being "mothballed." A shift in emphasis of the work of SASD personnel away from matters related to energy strategies greatly diminished the pertinence of EDS to the subjects of work being done. As a consequence, financial support for continuing maintenance of EDS was eliminated from the FY 1980 budget, and SASD implemented procedures for "mothballing" the system. The EDS base will be retained in a state such that it can be accessed by users of the EPA National Computer Center, but no data base updates are planned and most of the supporting software will be removed from the computer system. All the essential and most of the peripheral components of EDS have been stored on magnetic tape so the system could be reactivated at a later time, should that be desired. ------- SUMMARY OF WORK PERFORMED The Energy Data System had been designed and its initial implementation completed prior to inception of Contract #68-02-2399. The data base and major update programs had been developed for SASD by a contractor, prelim- inary documentation had been written, and a few data base updates had been performed. The long-term plan for EDS was that physical maintenance of the data base — performing updates, creating backups, etc. — would be perform- ed by data processing personnel of the National Air Data Branch (NADB) at the direction of the SASD Project Officer, while CSC would undertake further development and "fine tuning" of the system. Accordingly, the first work performed by CSC was directed toward those two objectives: acceptance of existing EDS software into the NADB operating environment, and development of new software for performing necessary additional functions. Eleven of the first sixteen tasks initiated by the Project Officer directed CSC to document according to NADB standards the existing EDS update programs and procedures, to demonstrate they functioned correctly, and to obtain approval of them by NADB for placement into th.e NADB "production" operating system. Most of those tasks involved some program modification and development of new control procedures (runstreams); the software was documented and demonstrated operational within a few weeks to a few months after work was initiated. In two instances, however, extensive program modification and testing were required; those tasks (4 and 7, the SAROAD and FORM-67 updates) took longer to complete. All of these tasks remained open for approximately a year after work was completed pending final action by NADB and the Project Officer. Final action was postponed because a new Project Officer had been assigned who was reconsidering the philosphy of having data base maintenance done by NADB. While the question of maintenance responsi- bility was being re-evaluated, NADB suspended action on acceptance of software and documentation. ------- Consequently, a task was initiated in March 1977 for the purpose of evaluating the potential advantages and disadvantages of that arrange- ment. Based partly on the results of CSC's evaluation, the Project Officer determined that the interests of SASD would be better served if SASD retained responsibility for EDS maintenance, rather than trans- ferring the responsibility to NADB. CSC assisted in the effort to establish SASD production update procedures and documentation standards for future EDS software documentation. <- In June 1977, the Project Officer began assigning to CSC limited respon- sibility for performing updates .of the EDS data base. The updates were performed on an ad hoc basis. The Project Officer scheduled each update, secured any necessary input data, then initiated a task that directed CSC to perform the data processing functions necessary for accomplishing the update. Ten tasks of that nature were initiated and completed during July 1977 through July 1978; however, that procedure for data base maintenance required more technical and administrative effort on the part of the Project Officer than was desirable. Therefore, he initiated in September 1978 a task delegating to CSC total responsibility for EDS maintenance, subject to periodic performance reviews. CSC devel- oped a work plan that was approved by the Project Officer, and assumed responsibility for EDS maintenance on 1 November 1978. Work was performed under that task more or less continuously from then until the end of the contract period of performance. A Methodologies Manual was written that presented in detail the prescribed procedures for accomplishing each kind of data base update, as well as procedures for other maintenance activities. A total of 26 updates were performed, and all EDS-related disk files were backed up on tape on a daily basis. Near the end of the contract, work was performed under this task to "mothball" EDS, as discussed in the preceding section of this report. ------- Approximately fifteen tasks initiated by the Project Officer involved the improvement of existing software or development of new software. Three major new software units were implemented: a projections update procedure, for loading information about future power plants or new generating units into the EDS data base; programs for calculating pollutant emissions from power plants; and a procedure for reorganizing the data base by unloading and selectively reloading data. The programs for computing the maximum amounts of power plant emissions allowed under current pollutant emission regulations were extensively modified to assure correct operation. Several update procedures were modified to correct errors, accommodate changes of the input data format, and to optimize or extend capabilities. Twelve tasks were initiated for the purpose of data retrievals from the EDS data base. They were generally of short duration and required quick response by CSC. The data retrievals were mostly in response to requests by EPA personnel for information pertaining to power plants. The purpose of one retrieval task was response to a Freedom of Information request for emission regulations data. The other tasks initiated under this contract included a variety of projects. One accomplished the conversion of EDS to a new version of the System 2000 data management language, and involved modification of the data base and most update software. Another task directed CSC to revise or rewrite all EDS software documentation (16 documents) to satisfy SASD documentation standards. A third project was the consolidation of all the useful System 2000 data management language commands for data retrieval written by SASD and CSC personnel into one file, creation of an abstract of each command, and loading the abstracts into the ASSIST data base. The final task of this contract was for development of the procedures for "mothballing" and reactivating EDS. A discussion of the objectives and accomplishments of each task is presented in Appendix A. ------- APPENDIX A Summary of Contract Activities by Task ------- EDS TASK SUMMARY Number: Title: General administrative and technical activities Objective: Accomplish the necessary administrative functions of the contract and to perform technical activities not directly related to individual tasks. Work Performed Administrative activities performed under this task consisted of periodic meetings (approximately every two weeks) of CSC personnel with the Project Officer to discuss the status of work in progress and to plan future work; and of writing periodic reports (biweekly status reports and monthly techni- cal reports) and this final report. Technical activities included develop- ment of documentation standards for SASD and extensive revision of the "EDS Terminal User's Manual." A-l ------- Number: EDS TASK SUMMARY Title: Modify and document the regulations update procedure Objective: Modify the existing EDS update procedure for loading regula- tions data and document the revised update procedure according to NADB standards. The update procedure was to be modified by invoking the EDS update utility runstreams EDSOOOA and EDSOOOB, which prepare the data base for an update by loading from backup tape and create a new backup tape of the data base following an update, respectively. Work Performed the controlling runstream of the regulations update procedure, EDS026, was rewritten to invoke utility runstreams EDSOOOA & B. Separate versions were created for use by SASD and NADB that referenced the files appropriate to each operating environment. The program (ED026) and the new runstream were tested to verify correct operation. Documentation of the update proce- dure was written according to NADB standards and was submitted with the test run results to the Project Officer and to NADB for review. The document and runstream were subsequently approved; the program had been previously approved by NADB and accepted into its operating system. A-2 ------- Number: EDS TASK SUMMARY Title: Modify and document the S(>2 units conversion update procedure Objective: Modify the EDS update procedure for converting units of measure of S(>2 regulations, document the update procedure according to NADB standards, and achieve acceptance of the procedure into the NADB operating system. The update procedure was to be modified to invoke the EDS update utility runstreams EDSOOOA and EDSOOOB. Work Performed It was found that the S(>2 units conversion program, ED027A, did not work properly, and it was modified to correct the errors. The Project Offficer requested that six additional program modifications be implemented to improve the quality of the processing and the report produced, and to extend the capabilities of the program. The requested modification were implemented and the program was tested to verify correct operation. A runstream was written that invoked the utility runstreams EDSOOOA and EDSOOOB, and separate versions were created for use by SASD and NADB that referenced the files appropriate to each operating environment. Complete program and runstream documentation was written to NADB standards and submited with test run results to the Project Officer and to NADB for review. The document, program, and runstream were subsequently approved. A-3 ------- Number: EDS TASK SUMMARY Title: Modify and document the FORM-423 update procedure Objective: Modify the program (ED030) and runstream of the EDS update procedure that loads FORM-423 fuel procurement data, and document the update procedure to NADB standards. Program ED030 was to be modified to change the format of the data field for fuel amount, and the runstream was to be modified to invoke the EDS update utility runsteams EDSOOOA and EDSOOOB. Work Performed The program modication specified above was implemented, as well as an addi- tional modification to punch a card containing the year of the data processed by the program. The runstream was rewritten to make use of the "year card" punched by the program and to invoke utility runstreams EDSOOOA&B. Separate versions of the new runstream were created for use by SASD and by NADB, each referencing the files appropriate to the two operating environments. The program and runstreams were tested to verify correct operation. Then complete program and runstream documention was written to NADB standards. The document and test runs were submitted to the Project Officer and to NADB for review, and were subsequently approved. A-4 ------- Number: EDS TASK SUMMARY Title: Modify and document the SAROAD update procedure Objective: Modify the runstreams of the EDS update procedure that loads SAROAD data and document the modification to NADB standards. The runstreams were to be modified to invoke the EDS update utility runstreams EDSOOOA and EDSOOOB. The EDS SAROAD update procedures had already been accepted into the NADB operating system. Work Performed The specified runstream modifications were implemented and NADB "Changes Documentation" was prepared. The revised runstreams and documentation were subsequently reviewed and accepted by NADB. However, a production run of the SAROAD update procedure produced results that indicated the programs were not functioning correctly. The Project Officer extended the scope of this task to include the identification and correction of the program errors. Extensive modification and testing of the SAROAD update programs, ED028A and ED028B, ensued. Correct operation of the programs was verified, and the program and corrected documentation were provided to NADB and the Project Officer. Within a few months, the format of NADB's data files from which SAROAD data are abstracted for loading into EDS was changed, rendering programs ED028A&B inoperable. The Project Officer further extended the scope of this task to include additional program modifications so the new SAROAD data file format could be accessed. The required program modifications were implemented and tested, and the program documentation was revised accordingly. A-5 ------- Number: EDS TASK SUMMARY Title: Document the existing EDS ad hoc update procedure Objective: Document to NADB standards and achieve acceptance into the NADB operating system the existing procedure for ad hoc updates of the EDS data base. Work Performed The EDS ad hoc update procedure consisted of a runstrearn and a methodo- logy for incorporating user-supplied System 2000 Natural Language commands to accomplish a non-standard update. The existing runstrearn was revised to create a new version suitable for use in the NADB production update environment. The runstrearn was documented to NADB standards. After review by NADB and the Project Officer, the document was approved. The runstream was then provided to NADB for acceptance testing. A-6 ------- EDS TASK SUMMARY Number: Title: Develop and document a program for selective data base reloads Objective: Develop and document a program that would provide the capability for creating a "new" copy of the EDS data base by selectively transferring data from an existing copy of the data base. The program was to produce a report summarizing the activities performed. Work Performed Initial program design and implementation was performed, but due to limi- tations imposed by System 2000 on the number of data sets (repeating groups) that could be referenced, and due to other procedural problems, it was decided that program implementation would not be practical. By mutual agreement of CSC and the Project Officer, this task was terminated. Tentative plans were made to implement an equivalent procedure that would utilize the System 2000 Natural Language processor rather than a program (see Task 15). A-7 ------- EDS TASK SUMMARY Number: Title: Modify and document the Form-67 update procedure Objective: Modify the FORM-67 update programs, ED032A and ED032B, to utilize a data base password card; modify the associated runstream to invoke update utility runstreams EDSOOOA and EDSOOOB; document each program and runstream to NADB stan- dards; and achieve acceptance of the FORM-67 update procedure into the NADB operating system by demonstrating correct operation of the programs and runstreams. Work Performed The specified modifications of the existing program were implemented and the runstreams were revised to reference appropriate NADB files and to invoke utility runstreams EDSOOOA and EDSOOOB. When the programs were tested, numerous program logic and functional errors were detected. Considerable effort was expended to identify and correct those errors. Then each program and runstream was documented to NADB standards, and the documents were submitted to NADB and the Project Officer for review. Several rounds of document revision resulted in approval of the documents by NADB. The programs and runstreams were then provided to NADB for inclu- sion in production files. A-8 ------- EDS TASK SUMMARY Number: 8 Title: Modify and document the diffusion modeling update program, ED034 Objective: Modify the diffusion modeling data load program, ED034, and its runstream, EDS034; document the program and runstream to NADB standards; and achieve acceptance of the program into the NADB operating system by demonstrating correct program and runstream operation. The scope of the task was later extended to include program modifications necessitated by a change in format of modeling input data. Work Performed All required program modifications were implemented and tested. The runstream was revised to invoke update utility runstreams EDSOOOA and EDSOOOB. Program and runstream documentation was written to NADB standards and submitted to NADB and the Project Officer for review. The task remained open but inactive for several months during which time it was decided that NADB would not assume responsibility for production maintenance of EDS. The program and documentation were then approved by the Project Officer. A-9 ------- EDS TASK SUMMARY Number: Title: Document the update runstreams EDSOOOA and EDSOOOB Objective: Document to NADB standards and achieve acceptance into the NADB operating system the existing EDS update "utility" runstreams EDSOOOA and EDSOOOB. Work Performed New versions of the existing EDS runstreams were created that referenced file names appropriate for NADB production maintenance of EDS. The new runstreams were each documented to NADB standards. The two documents were reviewed and approved by NADB and the Project Officer. The runstreams were provided to NADB for inclusion in their files and for testing. A-10 ------- EDS TASK SUMMARY Number: 10 Title: Document the update runstreams EDSOOOC and EDSOOOD Objective: Document to NADB standards and achieve acceptance into the NADB operating system the existing EDS update "utility" runstreams EDSOOOC and EDSOOOD. Work Performed New versions of the existing runstreams were created that referenced the appropriate file names for NADB production maintenance of EDS. The new runstreams were each documented to NADB standards. The two runstreams were reviewed and approved by NADB and the Project Officer. The runstreams were provided to NADB for inclusion in their files and for testing. A-ll ------- EDS TASK SUMMARY Number: 11 Title: Document the NEDS update procedure Objective: Document to NADB standards and achieve acceptance into the NADB operating system the existing NEDS update procedure. The objective was later revised to specify documentation to SASD standards after it was decided that maintenance of EDS would not be turned over to NADB. Worked Performed The NEDS update procedure for EDS consisted of four programs and associ- ated runstreams. Some known program and runstream errors were corrected by appropriate modifications, additional program changes were implemented, and the programs were renamed. The modified programs and runs t reams were documented to SASD standards and the document was delivered to the Project Officer for review. Following that review, the document was revised and expanded as requested. The final document was approved by the Project Officer and the corrected programs and runstreams were placed in EDS library files. A-12 ------- EDS TASK SUMMARY Number: 12 Title: Document the FORM-4 update procedure Objective: Document to NADB standards and achieve acceptance into the NADB operating system the existing FORM-4 update procedure. The objective was later revised to specify documentation to SASD standards. Work Performed The FORM-4 update procedure for EDS consisted of four programs and associ- ated runstreams. Work was begun on their documentation to NADB standards, but after it was decided that EDS would not be maintained by NADB, the document format was changed to satisfy SASD standards instead. During the process of developing the detailed program descriptions for the docu- ment, a few program logic errors were detected and corrected. The completed document and revised programs were delivered to the Project Officer for review. After a period of inactivity on this task, the document was returned to CSC for minor revision. The corrected document was approved by the Project Officer. A-13 ------- EDS TASK SUMMARY Number: 13 Title: Develop a procedure for loading diffusion modeling notes Objective: Develop a procedure for loading into the EDS data base notes (explanations, additional information) pertaining to plant diffusion modeling studies data previously inserted into the data base. The notes were not loaded with the other modeling data because the update program, ED034, was not capable of processing the notes at the time it was executed. Work Performed The records containing modeling notes were identified and extracted from the modeling data files. A one-shot program was developed for loading the notes into the EDS data base and was tested. The program, an associ- ated runstream, instructions for using the program, and a data file containing edited diffusion modeling notes were delivered to the Project Officer. A-14 ------- EDS TASK SUMMARY Number: 14 Title: Ranked emissions report program Objective: Development and documentation of one or more programs to retrieve power plant data from the EDS data base and produce a report listing the calculated values for maximum allowable S02 emissions, uncontrolled S(>2 emissions, and the difference between the two for each power plant specified by selection criteria. The report would also include plant identification and location, fuel data, and applicable regulations. Work Performed Preliminary program requirements and design analysis was initiated, but was pre-empted by other tasks with higher priority. The task was later termi- nated at the request of the Project Officer. A-15 ------- EDS TASK SUMMARY Number: 15 Title: Develop and implement procedures for data base unload/reload Objective: Development of a standard procedure utilizing the System 2000 Natural Language processor to accomplish an unload and reload of the EDS data base, and performance of an unload/reload operation using the procedure developed. Work Performed A procedure was developed that facilitated the data base unload and reload processes, and was documented to SASD standards. The procedure employed the Dnivac SSG processor to generate runstreams for accomplishing specific user-directed tasks, such as unloading or reloading designated parts of the data base and creating backup tapes. CSC developed the set of SSG commands, or "skeleton," that caused generation of the appropriate unload or reload runstream based on simple directives supplied by the user. The procedure was then utilized to unload all data from the data base and to reload power plant data. Modifications of the data base definition were also implemented prior to the reload. A-16 ------- EDS TASK SUMMARY Number: 16 Title: Data base turnover review Objective: Review the advantages and disadvantages of turning over to the National Air Data Branch (NADB) responsibility for maintenance of EDS, and produce a report summarizing the findings. Work Performed CSC investigated the potential positive and negative aspects of EDS mainte- nance being performed by NADB personnel. A report stating the findings of the investigation was written and delivered to the Project Officer. A-17 ------- EDS TASK SUMMARY Number: 17 Title: Quick response project #1 - analysis of future power plant sitings Objective: Provide technical support as specified by the Project Officer to assist SASD personnel in the analysis of potential problems associated with the siting of power plants in locations desig- nated by EPA as non-attainment areas. Work Performed CSC performed six projects under this task. (1) Program NE204 was executed from the NADB program library to produce national, regional, and selected state reports of pollutant emissions from industrial plants. (2) A one-shot program was developed and executed that produced a report of summary statistics pertinent to projected power plants using data contained in the Generating Units Reference File (GURF), obtained from the Federal Power Commission. (3) A one-shot program was developed and executed that selected projected power plant data from GURF and loaded it into the PROJECTIONS portion of the EDS data base. (4) A data base update was performed to load ambient air quality data abstracted from the SAROAD system. (5) Several ad hoc data base updates were performed to designate non-attainment areas and to convert the units of measure of pollutant emission regulations. (6) An existing, partially completed program for converting the units of TSP regulations was made operational and was executed (program ED027B). A-18 ------- EDS TASK SUMMARY Number: 18 Title: Documentation of the TSP Units Conversion program (ED027B) Objective: Documentation to NADB standards of program ED027B, which converts TSP regulation values to standard units of measure. Work Performed The required documentation was written and submitted to the Project Officer for review. After a period of inactivity, the task was reactivated and the documentation was revised to meet SASD documentation standards. A-19 ------- EDS TASK SUMMARY Number: 19 Title: Consolidation of files on mass storage devices (discs) Objective: Consolidation of software items related to the development, operation, and maintenance of EDS. Work Performed CSC.evaluated the contents of data files and program files; identified the most recent version of each program and runstream contained in SASD, NADB or CSC files; collected together the most recent versions of those items in designated files; and provided the Project Officer with documenta- tion of the status and location of those items. Following the consolida- tion, numerous files were deleted from the computer system in order to reduce charges for mass storage utilization. A-20 ------- EDS TASK SUMMARY Number: 20 Title: Design and implement controlled emissions report program(s). Objective: Development of one or more programs to retrieve data from the EDS data base, compute particulate emissions on a boiler-by-boiler basis, and produce a printed report. Computation of emissions was to take into account the parameters related to the type of combustion process employed and any applicable pollution control equipment. The Project Officer later extended the scope of the project to include computation of emissions of sulfur oxides and nitrogen oxides. Work Performed Three programs were developed and tested. The first retrieved data from portions of the data base holding boiler design, boiler operation, and plant fuel data; concatenated the data and computed boiler-level fuel consumption data; and created files containing boiler and plant design and operational data, and pollution control equipment data. The second program manipulated the pollution control equipment data and created a file in a format (indexed-sequential) that facilitated data retrieval. The third program utilized that file and the "boiler" file created by the first program to compute emissions and print a controlled emissions report for plants in user-specified geographical regions of the United States, including appropriate subtotals and totals of computed emissions and fuel consumption data. The programs were documented to SASD standards except that detailed program descriptions were not included. The detailed descriptions were written later after several planned program modifications were implemented (see Task 33). A-21 ------- EDS TASK SUMMARY Number: 21 Title: Perform a data base unload, redefinition and reload Objective: Unload in System 2000 value string format all power plant, industrial plant, and monitoring station data; revise the EDS data base definition and create a new "empty" data base; and load the power plant data into the new data base. Work Performed The existing EDS unload/reload procedure was utilized to unload data from the data base. The data base definition was modified to change the sizes of some components and to add a few new components. An empty data base was created employing the revised definition, and the previously unloaded power plant data were loaded into it. A-22 ------- EDS TASK SUMMARY . Number: 22 Title: Quick response project #2 - 1985 air quality estimation Objective: Provide technical support as requested by the Project Officer to assist SASD personnel in the computation of 1975 pollutant emissions from utility power plants and the estimation of emissions in 1985. Work Performed CSC completed a number of activities in response to directives from the Project Officer. Projections data in the EDS data base derived from the Generating Unit Reference file (GURF) were unloaded, edited, and reloaded. All 1975 fuel use data in the EDS data base were unloaded, extensively edited to improve data quality, and re-inserted into the data base. Fuel data from 42 files of the PRMS library was totaled into 10 fuel categories on a county by county basis for the nation; the procedure was repeated each time refinements were made to the PRMS data. Projections data supplied by Environmental Analysis Inc. was edited and loaded into the CONV data base after each of several refinements of those data. Numerous updates of the CONV data base were performed to correct, reorganize, or summarize data contained therein. And several reports were produced that listed consump- tion of coal, oil, and gas in 1975, and calculated emissions of particulates and sulfur dioxide in 1975. Other reports listed the estimated pollutant emissions in 1985 based on several different assumption concerning trends in fuel consumption and on the impact of proposed Federal emissions regula- tions. A-23 ------- EDS TASK SUMMARY Number: 23 Title: Perform a data base update to load NEDS data Objective: Update the EDS data base by loading data pertaining to indus- trial plants abstracted from NEDS. Work Performed The existing EDS update procedure for NEDS data was utilized to update the data base. Several program errors were detected as a result of the update and modifications of the COBOL source code were implemented to eliminate overprinting in the report, to write rejected UTM coordinates information in an alternate print file, and to correct the calculation of minutes of longitude. Since the program that was modified (NEDS6) was originally written in SCORE-IV language, the modifications of the generated COBOL program were retrofitted to the SCORE-IV source code at the Project Officer's request. The pertinent parts of the program documentation were changed to reflect the program modifications. A-24 ------- EDS TASK SUMMARY Number: 24 Title: Conversion of EDS to Level 2.80 of System 2000 Objective: Conversion of the EDS data base and all associated software to operation with the "new" version (Level 2.80) of System 2000 from the current version (Level 2.65). Work Performed CSC proposed and the Project Officer approved a plan for conversion of EDS to Level 2.80 of System 2000. The plan included: revision of runstreams where necessary to reference the Level 2.80 Natural Lanaguage processor; revision of the data base definition to eliminate reserved words from data element names and to reduce the number of keyed components; creation of revised schemas incorporating the new data base definition, and revision of programs using the schemas where necessary; and recompilation of all programs that access the data base. All the above procedures were imple- mented and the revised software was stored in separate files so that normal EDS operations could precede (using Level 2.65) while the conversion work was being done. Then the data base was unloaded to tape using Level 2.65, a new "empty" data base was created under Level 2.80 using the revised definition, and the data base was loaded from the tape files created previ- ously. Finally, all the converted software items (programs and runstreams) were copied into EDS "production" library files. A-25 ------- EDS TASK SUMMARY Number: 25 Title: Modification and documentation of maximum allowable emissions programs Objective: Modify a series of programs developed by SASD for computing the maximum allowable emissions of sulfur dioxide and particulates (based on regulations and fuel data for power plants in the EDS data base), and document those programs to SASD standards. Work Performed The six maximum allowable emissions programs were originally implemented by SASD personnel using the SCORE-IV language and precompiler. CSC modified the COBOL language code, produced by the SCORE-IV precompiler, to improve processing logic and efficiency; to implement county, state, and national totals of pertinent data; and to function properly with Level 2.80 of System 2000. Program documentation was written according to NADB standards (the same standards as required by SASD at the time). The modified programs and the documentation were delivered to the Project Officer for review, during which several program logic errors and document deficlences were found. Meanwhile, another task (48) was undertaken which invoked re-structuring a part of the data base (PROJECTIONS) accessed by the maximum allowable emissions programs; and an effort was initiated to redocument all programs to SASD's own standards (Task 56). A second round of program.modifications was performed by CSC to correct logic errors in the programs, to allow access to the revised structure of the PROJECTIONS portion of the data base, to change .the interpretation of some fields of parameter cards, and to revise the algorithm for computing emissions for plants subject to Federal NSPS regulations. Extensive testing was performed to assure correct program operation. Program documentation was then rewritten according to SASD standards. The Project Officer reviewed and approved both the documentation and the programs. A-26 ------- EDS TASK SUMMARY Number: 26 Title: Implement a program for creating IBM-format tape files Objective: Develop and document a program to read a UNIVAC SDF (card-image) file and create and IBM-compatible magnetic tape file. Work Performed A COBOL program, SDF2IBM, was developed that would read card-image data (UNIVAC SDF format) and write the data on magnetic tape in IBM-compatible format (80-character EBCDIC records, fixed-blocked format). Program documentation was written to SASD standards and approved by the Project Officer. A-27 ------- EDS TASK SUMMARY Number: 27 Title: Develop a plan for an automated task management system Objective: Investigate possible methods for implementing a computerized system to assist in the management of EDS tasks, and recommend an appropriate implementation. Work Performed A preliminary examination of available task management systems by CSC indi- cated that none were suitable for use with EDS due to excessive cost and/or complexity. At the request of the Project Officer, this task was terminated. A-28 ------- EDS TASK SUMMARY Number: 28 Title: Modification of regulations update program, ED026 Objective: Modifiation of the regulations update program, ED026, to improve its data error handling techniques. Work Performed Program ED026 was modified to improve the quality of error messages pertaining to input data errors, and to scan all fields of input data cards instead of terminating the scan when the first error was detected^ A test vesrion of the program and its associated runstream were also created that would permit error checking of the regulations data cards without accessing the data base. The program documentation was revised to reflect the program modifications. A-29 ------- EDS TASK SUMMARY Number: 29 Title: Perform a data base update to load regulations data Objective: Update the EDS data base by loading NOX regulations data. Work Performed The existing EDS update procedure for regualtions data was utilized to accomplish the desired update. The NOX regulations data supplied as an SDF file by the Project Officer were inserted into the data base using the revised ED026 program (see Task 28). The results of the update were reviewed and approved by the Project Officer. A-30 ------- EDS TASK SUMMARY Number: 30 Title: Perform a data base update to load FORM-423 data Objective: Update the EDS data base by inserting FORM-423 fuel procure- ment data for January through September 1977. Work Performed The existing EDS update procedure for FORM-423 data was utilized to accomplish the desired update. FORM-423 data tapes for each of the speci- fied months were obtained from the tape library of the National Air Data Branch. The nine IBM-format tapes were concatenated and sorted to create one UNIVAC-format tape that was used as input for the update program. The results of the update were reviewed and approved by the Project Officer. A-31 ------- EDS TASK SUMMARY Number: 31 Title: Perform a data base update to load NEDS data Objective: Update the EDS data base by loading data pertaining to industrial plants abstracted from NEDS. Work Performed The existing EDS update procedure for NEDS data ws utilized to update the data base. Some runsteam modifications were implemented and the program documentation was modified to reflect those changes. The results of the update were reviewed and approved by the Project Officer. A-32 ------- EDS TASK SUMMARY Number: 32 Title: Perform a data base update to load SAROAD data Objective: Update the EDS data base by loading data pertaining to SAROAD monitoring stations. Work Performed The existing EDS update procedure for SAROAD data was utilized to load SAROAD data for 1973-1978 into the EDS data base. The results of the update were reviewed and approved by the Project Officer. A-33 ------- EDS TASK SUMMARY Number: 33 Title: Modification of Controlled Emissions Programs Objective: Modification of the Controlled Emissions Report programs to improve the format of the printed report and change the names of the programs; and revision of the program documentation to improve the detailed program descriptions and to reflect the changed program names. Work Performed The existing program, TSP-REPORT, was modified to alter the format of the printed Controlled Emissions Report to improve its readability. The program names were changed from TSP-SELECT, TSP-SORT, and TSP-REPORT to SELECT/ CONTR-EMISS, SORT/CONTR-EMISS, and REPORT/CONTR-EMISS respectively; and runstreams and documentation was modified to reference the new program names. Section 4 of the program documentation was revised to present a more detailed description of the processing performed by the three programs. A-34 ------- EDS TASK SUMMARY Number: 34 Title: Develop an approach for transferring EDS maintenance to CSC Objective: Development of a plan by which responsibility for the routine maintenance of EDS could be transferred from SASD to CSC. "Routine maintenance" would include regular periodic updates . of the EDS data base and ad_ hoc updates of the ASSIST data base. Work Performed CSC produced a technical report that recommended the areas of responsi- bility that could be assumed, specific activites that could be performed, and a general plan and schedule for implementation of the recommendations. A-35 ------- EDS TASK SUMMARY Number: 35 Title: Modification of Controlled Emissions Programs Objective: Modification of the existing Controlled Emissions Report pro- grams to generate a card-image file containing the requisite System 2000 Natural Language commands and data to enable loading the pollutant emission values calculated by the programs into the PLANT-EMISSIONS repeating group of the EDS data base. The format and content of the generated file was to be such that, if the file were @ADDed while accessing the data base with the System 2000 Natural Language processor, insertion of the calculated plantwide annual emissions of each pollutant (total suspended particulate, sulfur oxide, and nitrogen oxides) into the data base would be effected. Work Performed Program REPORT/CONTR-EMISS was modified to produce the specified card image output file, and the associated runstream was modified to perform the necessary file assignment. The program was tested after modification to verify corect operation, and the program documentation was updated to include a description of the card-image output file. The modified software was made available to the Project Officer for inclusion in EDS library files. A-36 ------- EDS TASK SUMMARY Number: 36 Title: Perform a data base update to load FORM-423 data Objective: Load FORM-423 fuel procurement data for the months October, November, and December 1977 into the EDS data base. Work Performed Three tapes containing FORM-423 data for the specified months were obtained from the tape library of the National Air Data Branch. A program written by SASD personnel and modified by CSC was executed to concatenate the data from the three IBM-format tapes and create one UNIVAC-format tape containing the concatenated, sorted data. The existing FORM-423 update procedure was then used to load the data into the EDS data base. A-37 ------- EDS TASK SUMMARY Number: 37 Title: Perform a data base update to load FORM-67 data Objective: Load 1974 FORM-67 data into the EDS data base. Work Performed Using the FORM-67 data tape supplied by the Project Officer, CSC executed the FORM-67 update programs to load the data into the data base. The update was unsuccessful in initial attempts due to errors in the update programs, ED032A and ED032B. Considerable effort was expended to identify and correct the errors prior to successful completion of the update. The corrected programs were made available to the Project Officer for inclusion in EDS library files. A-38 ------- EDS TASK SUMMARY Number: 38 Title: Perform a data base update to correct NEDS IDs of power plants Objective: Correct the NEDS identification codes (C21) of certain power plants in the EDS data base. A list of power plants with errroneous NEDS ID codes was supplied to the Project Officer in a memo from Sue Kimbrough, NADB/MDAD. Work Performed CSC constructed the requisite System 2000 Natural Language commands for correcting the erroneous NEDS ID codes, and implemented those corrections by performing an ad hoc update of the EDS data base. A-39 ------- EDS TASK SUMMARY Number: 39 Title: Perform a data base update to load FORM-4 data Objective: Load "preliminary" 1977 FORM-4 fuel use data into the EDS data base. Work Performed Using the FORM-4 data tape supplied by the Project Officer, CSC executed the FORM-4 update programs to load the data into the data base. Some runstream modification and program compilation was necessary to permit successful execution of the update. The corrected software items were made available to the Project Officers for inclusion in EDS library files, A-40 ------- EDS TASK SUMMARY Number: 40 Title: Develop Project Accounting Procedures and Reports Objective: Implementation of an automated procedure for reporting contract costs (primarily computer changes) by work category (primarily the project ID of computer runs). Work Performed It was determined that most of the desired information might be made available through revised computer utilization/cost reports issued by the National Computer Center. The Project Officer cancelled this task and no work was performed. A-41 ------- EDS TASK SUMMARY Number: 41 Title: Revision of flue gas cleaning equipment data Objective: "Clean up" flue gas cleaning equipment data in the EDS data base by unloading, editing, and reloading the corrected data. Work Performed It was decided that the "cleanup" would effectively be accomplished by other planned major updates of the data base. The Project Officer cancelled this task and no work was performed. A-42 ------- EDS TASK SUMMARY Number: 42 Title: Modification of Controlled Emissions Programs Objective: Modification of the existing Controlled Emissions programs to produce a card-image output file containing information pertaining to the age of power plant boilers. One card image was to be created for each boiler processed by program REPORT/CONTR-EMISS that contained the plant and boiler ID codes, the year of boiler installation, and computed boiler emissions. Work Performed Program SELECT/CONTR-EMISS was modified to retrieve from the EDS data base and store in the output file, BOILER-FILE, the year of boiler installation. Program REPORT/CONTR-EMISS was modified to produce the desired card-image output file, and the associated runstream was modified to perform the necessary file assignment. Both programs were tested to verify correct operation after modification, and the program documentation was updated to include a description of the card-image output file. A-43 ------- EDS TASK SUMMARY Number: 43 Title: Maintenance of EDS Objective: The long-term maintenance of the EDS data base and ancillary files by CSC. Maintenance activities were to include: scheduling data base updates, acquiring input data, perform- ing the updates, and verifying their successful completion; periodic updates of the ASSIST data base and the S2K-COMMANDS file; and maintenance of EDS files by daily backup to tape and periodic consolidation (deletion of unnecessary files). Work Performed CSC developed a plan of work for this task, approved by the Project Officer 10/11/78, that proposed three phases of EDS maintenance that commenced 11/01/78. In the first phase, CSC worked closely with the Project Officer to define in detail the maintenance procedures, establish a schedule for updates, and write a Methodologies Manual describing the update procedures and schedule. The Manual was completed in February 1978. In the second phase, CSC assumed the role of Data Base Administrator and began performing updates and daily file backup. Before each update was performed for the first time, CSC presented a detailed plan of work for approval by the Project Officer, executed the planned work, and provided extensive data verifying the validity of the update. It was frequently necessary during this time to revise update programs and/or the associated runstreams to correct errors or impr.ove operational efficiency. In the third phase, CSC continued the activities of the second phase by performing data base updates for the second time (or more, as dictated by the schedule) but without providing a detailed plan of work or extensive verification data to the Project Officer; CSC assumed complete responsibility for the integrity of the data base and for insuring the validity of updates. CSC performed a total of 26 updates of the EDS data base during the course of this task, performed daily file backup and monthly file consolidation, and revised the Methodo- logies Manual several times to reflect changes in operating procedures. The final work performed under this task was implementation of the EDS "mothballing" procedures developed under Task 62. Backup tapes were created that contain copies of all EDS-related files and that can be used to reactivate EDS in the future. A-44 ------- EDS TASK SUMMARY Number: 44 Title: Retrieval of SOX emissions data from the "county" data base Objective: Retrieval from the SASD "county" data base the estimated emissions of sulfur oxides from utility and non-utility sources by fuel type (coal, oil, gas, other) in 1975 and 1985. A report was to be produced that listed the appropriate state totals of SOX emissions. The information was requested by J. Bachmann (SASD). Work Performed The requested information was retrieved from the "county" data base using S2K Natural Language commands. The reports were delivered to the Project Officer for transmittal to the requestor. A-45 ------- EDS TASK SUMMARY Number: 45 Title: Propose work plans for implementation of alternative projections update procedures Objective: Development of a technical report specifying proposed work plans and estimates of reources required for implementation of four alternative PROJECTIONS update procedures suggested by the Project Officer. Work Performed The four procedures were analyzed and the work plans and resource require- ments were developed. A technical report describing the alternative plans/resources was written and delivered to the Project Officer. A-46 ------- EDS TASK SUMMARY Number: 46 Title: Retrieval of regulations data for Gordian Associates, Inc. (FOI request) Objective: Creation of a data tape in IBM-compatible format containing power plant emissions regulations data for particulates, sulfur dioxide, and nitrogen oxides. The information was requested by Gordian Associates, Inc., through the Freedom of Information Act. Work Performed S2K Natural Language commands were used to retrieve the regulations data from the EDS data base and to create a disk file containing the data. The existing program "SDF2IBM" was used to read the disc file and create a tape file having IBM fixed-blocked format. A listing of the tape file contents and documentation of the record format was delivered to the Project Officer with a draft letter of transmittal to the data requestor. The Project Officer forwarded those materials with the tape to the requestor. A-47 ------- EDS TASK SUMMARY Number: 47 Title: Freedom of Information data retrievals Objective: The Project Officer tentatively planned to initiate a long-term task for the purpose of responding to requests for data retrie- vals from EDS made through the Freedom of Information Act. Task number 47 was reserved for that effort. It was later decided that the task would not be initiated, and no charges were incurred under this task number. A-48 ------- EDS TASK SUMMARY Number: 48 Title: Implementation of a PROJECTIONS update procedure Objective: Implementation of a new design of the portion of the EDS data base for power plant projections data; implementation of one or more programs and runstrearns for performing "production" updates of the new projections data base definition; development of program documentation; and execution of the new programs to load currently available projections data into the EDS data base. Work Performed A new definition for the PROJECTIONS portion of the EDS data base was developed, in cooperation with the Project Officer, that would accommodate all pertinent data available from either of two sources: the "Generating Units Reference File" (GURF) and the "New Power Plants File" (NPPF). Design specifications were developed and approved by the Project Officer for two programs. One (COPY/PROJECTIONS) would select appropriate data from either source data file and create an output file containing the selected data in the same format irrespective of the original source (GURF or NPPF). The second program (LOAD/PROJECTIONS) would insert all or part of the selected projections data into the EDS data base. The programs and associated runstreams were written and tested; two updates were performed (one using GURF data, the other using NPPF); and program documentation was prepared. A-49 ------- EDS TASK SUMMARY Number: 49 Title: Optimization of the "controlled emissions" SELECT program Objective: Modify of the "controlled emissions" program, SELECT/CONTR-EMISS, to reduce the amount of time required for its execution; and demonstrate correct program operation following modification. Work Performed The SELECT/CONTR-EMISS program abstracts boiler-related data from the EDS data base and creates a COBOL file used as input to program REPORT/CONTR- EMISS for generation of a "controlled emissions" report. A test version of the SELECT program was created that printed the time required for each S2K retrieval operation when executed. By analysis of that information, it was deduced that an S2K "GET1" retrieval operation was responsible for much of the time used during program execution. The test program was modified to substitute an S2K "GETD" retrieval procedure for the "GET1," an was executed. The resulting timing information revealed a decrease of about 80% in execution time. The original version of the program was similarly modified and executed; the data file thus created was identical with the file produced by the original program. Additionally, the SELECT program was modified to eliminate leading zeros in numeric fields of card output produced by the program (files EMIS-LOADSTR and BOILER-AGE). A-50 ------- EDS TASK SUMMARY Number: 50 Title: Retrieval of data pertaining to oil- and gas-fired power plants Objective: Retrieval of information from EDS that could be used to determine the potential impact on power plants of decreased availability of crude oil from Iran. Three reports were to be produced: (1) a list of oil suppliers from which power plants purchased oil in 1977-78, and the amounts and cost of the purchases; (2) an inventory of power plants that can use both oil and natural gas, and the yearly amounts of each fuel used by them; and (3) an inventory of power plants that use natural gas exclusively, and the yearly amount of gas used. Work Performed The report of oil suppliers was produced, but very little information was available in the EDS data ase with respect to the source of oil procurements. The U.S. Department of Energy and the Federal Energy Administration were contacted by telephone but could provide no additional informaton. The other two reports were produced by execution of versions of existing program "REPORT/CONTR-EMISS" modified to select oil and gas dual-fired boilers and gas-only fired boilers. The reports were delivered to the Project Officer. A-51 ------- EDS TASK SUMMARY Number: 51 Title: Retrieval of data pertaining to power plants affecting visibility Objective: Retrieval of data from EDS pertaining to the relative design generating capacities from coal-fired and oil-fired boilers installed after 1961 in power plants having a total generating capacity of at least 750 megawatts. That information would then be used to identify the plants within 150 kilometers of Federal Class 1 areas (those areas designated by the National Park Service as requiring a high degree of visibility, e.g., National Parks). The information was requested by G. Crane (ESED), Work Performed Two reports were produced, one for coal-fired and the other for oil-fired boilers, using a modified version of an existing program, "LIST-BLR-FIL." The reports listed the name and location of plants and detailed information about boilers that satisfied the constraints given above. The generating capacity of each boiler and the national total (in millions of BTU per hour) was computed and printed. The reports were delivered to the Project Officer, who forwarded them to the requestor along with a list of plants within 150 kilometers of Class I areas. A-52 ------- EDS TASK SUMMARY Number: 52 Title: Creation of a data tape Objective: Creation of a data tape in IBM-compatible format containing the data from a small S2K data base pertaining to chemical storage tanks. Creation of the tape was requested by J. Robson, EPA/RTP. Work Performed A program was written that retrieved all data from the S2K data base "TANKEMIS," sorted the data by tank ID code, wrote one record per tank ID on tape in IBM-compatible format, and printed the contents of each record. Documentation of the record format was also provided. A-53 ------- EDS TASK SUMMARY Number: 53 Title: Retrieval of data pertaining to boiler operation, boiler design, and stacks Objective: Retrieval from EDS of the design and operational data pertaining to power plant boilers and stacks. Work Performed Three reports were produced: (1) a "controlled emissions" report including all available detail for all power plants; (2) a report produced by S2K Natural Language commands listing the design generating capacity and fuel consumption rates for each boiler; and (3) a report produced by S2K Natural Language commands listing the design/measured properties of each stack. Each report included the name and location of each power plant. A-54 ------- EDS TASK SUMMARY Number: 54 Title: Retrieval of data pertaining to distillate oil procurements by power plants in California Objective: Retrieval of information from EDS to identify California power plants having the capability to burn either oil or gas, and to determine the relative amounts of distillate and residual oil used by those plants. The information was requested by J. Schwartz (EPA-Washington, DC). Work Performed The requested information was obtained from two separate data retrievals. One identified the plants that purchased distillate oil in 1977 and the amounts purchased. The other identified plants having boilers capable of burning either oil or gas. From those two retrievals a summary report was manually produced that contained all the requested information. A-55 ------- EDS TASK SUMMARY Number: 55 Title: Retrieval of oil procurement data Objective: Retrieval of data from EDS pertaining to the procurements of distillate and residual oil in 1977 and 1978 by power plants east of the Mississippi River. The relative amounts and the average sulfur content of each oil type for each plant was desired. Work Performed Because of the manner in which fuel procurement data are stored in the EDS data base, it was not possible to obtain the relative amounts of distillate and residual oil procured without writing a special program. A report was produced using S2K Natural Language commands that listed, for each power plant east of 90 degrees longitude that purchased distil- late and/or residual oil in 1977-78: plant name and location, the latest available generating capacity, and the total amount and average percent sulfur content of all oil purchased in 1977 and in the first six months of 1978. (Data were not available for purchases during the last six months of 1978.) A-56 ------- EDS TASK SUMMARY Number: 56 Title: Revision of EDS documentation Objective: Revision of the documentation of EDS programs and of the EDS Methodologies Manual. Work Performed Each of 15 program documents was revised or rewritten to bring it into conformance with SASD documentation standards and to include an accurate description of the current program capabilities and procedures for its use. The Methodologies Manual was updated to reflect current practices and procedures. Each document was extensively reviewed by CSC to insure accuracy of technical content and freedom from typographical errors prior to delivery. After review of the Project Officer, three documents under- went further revision to correct minor errors in style or content. Six copies of each document were delivered. A-57 ------- EDS TASK SUMMARY Number: 57 Title: Retrieval of data to identify power plants with natural draft cooling towers Objective: Identification of all power plants that use natural draft cooling towers. Work Performed Since the type of cooling tower information is not stored in the EDS data base, the required information was abstracted from the 1975 Department of Energy FORM-67 data tape. A program was written to abstract every record that specified cooling tower type (derived from page 17, line 29 of FORM #67). The abstracted records were sorted by cooling tower type so that all "natural draft" records were contiguous. The power plants were then identified from their codes, also present in the records. A-58 ------- EDS TASK SUMMARY Number: 58 Title: Retrieval of power plant S(>2 emissions and related data Objective: Retrieval of information related to power plant SO 2 emissions in order to identify the "dirtiest" plants (those emitting the most S02>. The information was requested by D. Carter (U.S. Department of Energy). Work Performed The requested information was retrieved from EDS by executing S2K Natural Language commands devised for that purpose, and by executing the EDS "Controlled Emissions" report program and the "LIST-BLR-FIL" program. A-59 ------- EDS TASK SUMMARY Number: 59 Title: Retrieval of net heat rate, boiler design, and stack data for coal-fired plants Objective: Rank coal-fired power plants according to their net heat rate (amount of heat input per unit of electricity generated), and provide detailed information about the characteristics of boilers, stacks, and flue gas cleaning equipment. The information was requested by C. Amato, Office of Radiation Programs, EPA. Work Performed S2K Natural Language commands were devised and executed to produce four reports that provided the requested information. The reports contained the following information: (1) net heat rate of coal-fired plants, ordered by plant location and by computed net heat rate; (2) detailed boiler design data for coal-fired boilers, including the design capability for use of fuels other than coal; (3) stack data for all plants, with indication of which boiler was associated with each stack; and (4) flue gas cleaning equipment data on a boiler-by-boiler basis, ranked by equipment efficiency, including estimated emissions of major pollutants. A-60 ------- EDS TASK SUMMARY Number: 60 Title: Retrieval of data related to the variability of sulfur content in coal procurements Objective: Determination of any relationships among the size (generating capacity) of power plants, the sulfur content of coal procured, and calculated SC>2 emissions. The information was requested by B. Steigerwald (OAQPS). Work Performed The Maximum Allowable SC>2 Emissions report program was executed to calculate the maximum amount of SC>2 that could be emitted by power plants based on their 1978 coal procurements. S2K Natural Language retrieval commands were devised and excuted to compute SC>2 emissions for those plants using the same fuel data, and to compute the difference between the computed and maximum allowable S(>2 emissions. These data were used to obtain distributions of the numbers of plants in various categories of plant size, maximum allowable emissions, and sulfur content. A-61 ------- EDS TASK SUMMARY Number: 61 Title: Consolidation of S2K commands and ASSIST data base update Objective: Consolidate into one file, EDS*S2K-COMMANDS, all the useful System 2000 Natural Langauge retrieval and update commands; create a command abstract for each of the consolidated commands; and update the ASSIST data base by insertion of the text and abstract for each consolidated command. Work Performed The user-written S2K commands in files EDS*S2K-COMMANDS, EDS*COMMAND-POOL, EDS*RLS-COMMANDS, EDS*TCH-COMMANDS, EDS*BAA-COMMANDS, EDS*SSS-COMMANDS, and FUEL*TAD-COMMANDS were listed and examined. Those deemed useful were extracted, modified if necessary to correct errors or to improve their quality, and tested. Duplicate commands were eliminated, and all commands were renamed to better connote their functions. An abstract of each command was generated using text editor macro procedures developed for that purpose. The text of all commands were removed from file EDS*S2K-COMMANDS and the abstracts of all commands were removed from the ASSIST data base. Then the new commands and abstracts were loaded into file EDS*S2K-COMMANDS and the ASSIST data base, respectively. A backup tape copy of the ASSIST data base was created, and a listing of all the information in the data base was produced and delivered to the Project Officer. In addition the Project Officer was provided with a cross-reference list that showed the corresponding "old" and "new" file.element/version names of each command. A-62 ------- EDS TASK SUMMARY Number: 62 Title: Develop procedures for mothballing EDS Objective: Development of procedures for "mothballing" EDS and for its reactivation. Work Performed CSC developed a plan for the "mothballing" of EDS and for its potential reacti- vation, and presented the plan in a technical report. The "mothballing" was to be accomplished by creating copies of all EDS-related files on magnetic tape, after which maintenance of those files by SASD would cease. Four tapes were to be created in duplicate — one copy to be retained in the NCC tape library, the other in the NCC archival tape storage area. The first tape would contain a copy of the data base files and all other files necessary for routine operation of EDS. The second and third tapes would contain copies of all files on disk packs DSD061 and DSD089. The fourth tape would contain the EDS data base definition and all data from the data base in System 2000 value string format. The technical report described in general terms the procedures for reactivation of EDS and potential problems that might be encountered. The Project Officer approved the technical report after minor revision, and authorized implementation of the "mothballing" procedures specified therein. A-63 ------- TECHNICAL REPORT DATA (Please read Instructions on the reverse before completing) 1. REPORT NO. EPA 450/5-80-005 3. RECIPIENT'S ACCESSION>NO. s. REPORT DATE (preparation^ March 1980 4. TITLE ANDSUBTITLE ENERGY DATA SYSTEM DEVELOPMENT AND MAINTENANCE Final Report 6. PERFORMING ORGANIZATION COI 7. AUTHOR(S) Thomas Dessent 8. PERFORMING ORGANIZATION REPORT NO. 9. PERFORMING ORGANIZATION NAME AND ADDRESS Computer Sciences Corporation Applied Technology Division 5529 Chapel ?;HilliB6ulevard . .. • Durham, North Carolina 27707 10. PROGRAM ELEMENT NO. 11. CONTRACT/GRANT NO. 68-02-2399 12. SPONSORING AGENCY NAME AND ADDRESS EPA, Office of Air Quality Planning and Standards Strategies and Air Standards Division Research Triangle Park, North Carolina 27711 13. TYPE OF REPORT AND PERIOD COVERED Final; 8/76 - 2/80 14. SPONSORING AGENCY CODE EPA/450/5 15. SUPPLEMENTARY NOTES SASD Project Officer: Robert L. Short, Mail Drop 12, FTS 629-5420 (919/541-5420) 16. ABSTRACT This report summarizes the work pe.rformed by Computer Sciences. Corporation during the 42-month period of performance of contract //68-02T2399. Under the terms o'f the contract, CSC provided technical support to the Strategies and Air Standards Division, Office of Air Quality Planning and Standards, for the development, implementation, maintenance, and operation of the Energy Data System, a computer data base for assessing the effects on air. quality of energy policy and environme' legislation as related to electric power plants and large industrial plants that burn fossil fuels. Work was performed in task units initiated by the EPA Project Officer. 17. KEY WORDS AND DOCUMENT ANALYSIS DESCRIPTORS b.lDENTIFIERS/OPEN ENDED TERMS C. COSATI Field/Group M2. DISTRIBUTION STATEMENT 19. SECURITY CLASS (ThisReport) Unclassified 21. NO. OF PAGE; 75 20. SECURITY CLASS (Thispage) Unclassified 22. PRICE r PA Form 2220-1 (9-73) ------- |