OXYCALC electronic spreadsheet program

OXYCALC electronic spreadsheet program

Package Reports 283 facility, interactive data-entry, relational data-base capabilities, macros, a wide range of statistical commands, and expandibi...

206KB Sizes 12 Downloads 396 Views

Package Reports

283

facility, interactive data-entry, relational data-base capabilities, macros, a wide range of statistical commands, and expandibility through a user link facility. Apollo Computer is the creater of DOMAIN processing, the concept of shared computer power over a local area network of dedicated, 32-bit engineering workstations. DOMAIN processing nodes range from the monochromatic DN3000 and DN420 to the color DN6000 workstations. Each node offers up to 3.5 Megabytes of main memory with multiple-window display. The windows can be side-by-side or overlaid in whole or part. Apollos are used worldwide in aerospace research, civil engineering, chemical engineering, interactive computer-aided engineering, software design, financial modeling, and computer science education. P-STAT on the Apollo DOMAIN will offer users in manufacturing, engineering, and business a versatile and powerful combination of analytical software on a desktop computer which is easily networked into a larger configuration. It will be available for the Apollo DOMAIN in November. The license fee for a single Apollo DOMAIN node will be $2000 the first year and $1000 annual renewal. Annual licenses and perpetual licenses are available for multiple nodes. A corporate site license is also available. P-STAT is used internationally by educational, commercial, and government installations. Typical applications include market research, personnel administration, system performance analysis, quality control and clinical studies. For additional information, please contact: P-STAT, Inc., P.O. Box AH, Princeton, NJ 08542; (609) 924-9100. Apollo Computer is located at 15 Elizabeth Drive, Chelmsford, MA 01824. •

OXYCALC ® Electronic Spreadsheet Program The OXYCALC Program Offering is a tool for solving business, scientific, and engineering problems and presenting the results in tabular, spreadsheet report form. Executing under either MVS/TSO or VM/CMS, it is extremely useful for creating financial budgets and reports, performing sales analysis, resource planning, production reporting, preparing lab analysis reports, etc. The program enables a user to create, manipulate and save spreadsheets on a computer with minimal training or assistance. In using OXYCALC, the report required is entered directly on the display screen in the format desired. In addition, OXYCALC provides a convenient mechanism for presenting spreadsheet data in graphical form. ® O X Y C A L C is a t r a d e m a r k o f O c c i d e n t a l P e t r o l e u m Services Inc.

284

Package Reports

The features of O X Y C A L C which make it easy to use include: * An online tutorial. * A H E L P Program Function Key with HELP panels to explain errors. . Extensive use of menus when user input is required. * Full-screen spreadsheet editing. * The use of tab and Program Function Keys to select various spreadsheet areas. O X Y C A L C executes under the control of either the M V S / T S O or V M / C M S operating system and can be used with any IBM 3270 display terminal. It is designed to fully utilize the color highlighting and graphic features of the IBM 3279 Color Display and 3287 Color Printer. O X Y C A L C utilizes the IBM Interactive System Productivity Facility (ISPF) to provide display menu, program function key, H E L P facility and online tutorial support. The Graphical D a t a Display Manager ( G D D M ) and its Interactive Chart Utility Feature (ICU) are used to provide spreadsheet displays and graphic presentation of spreadsheet data. Some of the benefits that may be derived from the use of OXYCALC include: * Quick, straightforward implementation of spreadsheet type reports. * Improved personnel productivity with minimal investment in training. * Easy preparation of graphical displays of spreadsheet data. * Common access to one spreadsheet facility which allows spreadsheet sharing, if authorized. * Reduced software and support costs.

Highlights

An M V S / T S O or V M / C M S user enters ' O X Y C A L C ' on an IBM 3270 display to invoke the program. A primary Option Menu is presented which allows the user to: • Select a tutorial on the use of OXYCALC. • Review program function key assignments. • Change any spreadsheet, chart or report file flefinition. • Operate certain utility functions like selecting spreadsheet display colors, browsing or printing a previously created report file, etc. • Begin viewing a new or previously saved spreadsheet. A highly productive dialogue is maintained with OXYCALC as the user interacts with either selection menus or an active spreadsheet. Each spreadsheet created by the user is comprised of rows and columns of data. O X Y C A L C can be used for spreadsheets, from a few rows and columns up to a currently implemented maximum of 132 columns by 32000 rows (if system resources permit). The intersection of any row and column defines a data CELL wherein is placed a LABEL (TITLE), a VALUE or a formula which computes a value. Data values contained in these cells are often interrelated as a result of arithmetic computations and logical comparisons. To aid the user in defining

Package Reports

285

value relationships, OXYCALC provides a set of arithmetic and logical operators, and a set of mathematical, econometric, trigonometric and logical functions. OXYCALC supports full-screen spreadsheet editing. This permits multiple spreadsheet changes and/or commands to be entered at one time. The IBM 3270 display screen is divided into an upper and lower display area. The upper area (three lines) is used to define new data cells, edit content of existing cells, enter OXYCALC commands and display information and error messages. The lower area displays a window(s) of the currently active spreadsheet and also supports new cell definition, cell editing and OXYCALC command entry.

Primary industry: Cross Industry. Programming system: MVS/TSO or VM/CMS; OS PL/1 Transient Library; ISPF; GDDM including the Presentation Graphics Feature and Interactive Chart Utility. Charge: $8000 one time charge. Testing period: One month. Installation license applies: No. Licensed program materials availability: All modules of this licensed program will be available with source licensed program materials. Central service available until: December 31, 1985. Central service contact: D.P. Meinert, B/O 345, Houston, TX; (713) 940-2384 or 345-2384 (IBM dial network). Documentation: Availability Notice (G320-9167); Program Description/Operations Manual (SH20-0040); 3270 Keyboard Overlay (GX20-0131). Availability date: October 14, 1983. •

STAT/PROTRAN STAT/PROTRAN is a member of the PROTRAN (PROblem TRANslator) family of software systems developed by IMSL, that are designed for ease of use and for flexibility in problem solving. The first three members of the PROTRAN family are STAT/PROTRAN, MATH/PROTRAN and LP/PROTRAN. LP/PROTRAN is used for solving linear programming problems; and MATH/PROTRAN is used for problem solving in various areas of applied mathematics, such as differential equations, optimization, eigenvalues, and several others. STAT/PROTRAN provides for manipulation of statistical data, performs the calculations for statistical analysis, and produces labeled output summarizing the computed statistics. Although the orientations of the systems are different, the syntax of PROTRAN is consistent over the individual members, and all can be used together.