Software Product Description _________________________________________________________ PRODUCT NAME: VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 DESCRIPTION VAX DECalc-PLUS is a multi-user spreadsheet designed specif- ically for technical, engineering and scientific environ- ments. VAX DECalc-PLUS combines an interactive, easy-to-use spreadsheet with the ability to call external routines writ- ten in any programming language that supports the VMS call- ing standard. From within a VAX DECalc-PLUS session, the user can link in one or more external routines and use the spread- sheet grid boxes to hold parameters to be passed as inputs to the routine, or to receive output from the routine. In addition, users can specify that a routine be iteratively executed for a specified number of times. VAX DECalc-PLUS executes in native mode under the VMS Operating System and drives a VT100, VT200 or VT300 series terminal. VAX DECalc-PLUS is easy to learn and requires little computer experience. The VAX DECalc-PLUS spreadsheet enables users to perform com- mon mathematical, statistical, and financial analyses via builtin functions, including, but not limited to: cosine, tangent, sine, logarithms; average, minimum and maximum value, least squares, standard deviation; payment, payback, depre- ciation, and discounts. The VAX DECalc-PLUS spreadsheet also enables users to manipulate their data via DELETE, INSERT, MOVE and REPRODUCE commands. The spreadsheet contains an ex- tensive set of date manipulation functions and formatting capabilities. Refer to the VAX DECalc Software Product De- scription (SPD 25.79.xx) for a more comprehensive descrip- tion of the spreadsheet functionality. Features DIGITAL August 1991 AE-HU09E-TE VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 VAX DECalc-PLUS contains an extensive set of subroutines that can be linked to and perform many common mathematical and statistical analyses used in technical and engineering en- vironments. Forms which prompt the user for the location of the arguments in the spreadsheet to be passed to and received from these routines are also provided. The routines can be categorized in the following manner: o Parametric and Nonparametric Statistical Analyses includ- ing T test (paired and unpaired), one- and two-way ANOVA, multiple linear regression, Kendall Rank correlation test, Spearman Rank correlation test, and Mann-Whitney U-test. o Matrix mathematics including scalar multiplication, di- vision, addition and subtraction, matrix inversion and transposition, solution of linear equations, Eigenval- ues and vectors of a symmetric matrix. o Numerical analyses including numeric integration, zeroes of polynomials, solutions for differential equations, and Fast Fourier transforms. o Linear and non-linear curve fitting. o Regression analysis and simulation. VAX DECalc-PLUS allows the user to create an interface called a template, so existing routines can be used with VAX DECalc-PLUS. VAX DECalc-PLUS also includes the ca- pability for users to specify how VAX DECalc-PLUS will access external subroutines. Users can: o Specify the name of the routine, the file name and lo- cation where it resides on the system and give a brief description of the routine's functionality. o Specify the text strings to be used to prompt for input and output arguments when the routine is executed from within VAX DECalc-PLUS. 2 VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 o Indicate whether an argument is an input or output for the routine, and if it is an integer, real or text data type. o Specify particular box locations in the VAX DECalc- PLUS grid as default responses for the prompts. This fa- cilitates setting up forms for executing the subroutines that can be used by less experienced users. VAX DECalc-PLUS allows users to access and execute ex- ternal routines by means of the APPLICATION LINK command. With this command, users can: o Include in the VAX DECalc-PLUS image the subroutines to execute. These routines can be the ones provided with the VAX DECalc-PLUS product (whose forms have already been provided), or other routines whose prompting forms have been previously set up. These routines can be either user- written or provided by a standard, commercially avail- able subroutine package. o Obtain a listing of the routines that have been included (loaded) into the VAX DECalc-PLUS image. This listing shows the routine name, file location and a brief description of each. o Define the box locations on the grid for the input and output parameters. Users can specify these locations by means of a special dimensional reference shorthand, which allows the completed form to be used for many different grids. o Save already defined routine forms in a VMS file to be used again. o Execute subroutines from within the VAX DECalc- PLUS session using the parameters specified in the rou- tine's form. The contents of the grid boxes specified as inputs are passed to the routine and the outputs from the 3 VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 routine are placed in output grid box parameters. Rou- tines can be re-executed quickly by means of a single key on the VT200 or VT300 series keyboard. o Execute subroutines with a number-of-iterations control. This enables users to try more than one ``what if'' sce- nario at a time. By using the VAX DECalc-PLUS spreadsheet for data entry, manipulation and formatting, users can perform ``what if'' analyses easily with sophisticated subroutines, and dis- play the results in a variety of formats. Integration with other VMS applications: o VAX DECalc-PLUS can also be used with VAX DECgraph. Spread- sheet data is loaded from VAX DECalc-PLUS into VAX DEC- graph to be manipulated and plotted as desired. o VAX DECalc-PLUS can be used with VAX DATATRIEVE. VAX DECalc-PLUS utilizes VAX DATATRIEVE's callable interface to enable users to re- trieve information from VAX DATATRIEVE for use in VAX DECalc-PLUS and to use VAX DATATRIEVE interactively. o From within VAX DECalc-PLUS users can access: - A mail utility of their choice - An editor of their choice - The VMS DIRECTORY command to view the directory of their choice - VMS DCL (may be disabled if desired) - SPAWN/ATTACH - The SPAWN option allows the user to begin a sub- process without leaving the current DECalc-PLUS ses- sion. 4 VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 - The ATTACH option allows the user to connect to a subprocess without leaving the current DECalc-PLUS session. HARDWARE REQUIREMENTS VAX, MicroVAX, VAXstation, or VAXserver configuration as spec- ified in the System Support Addendum (SSA 27.37.04-x). SOFTWARE REQUIREMENTS For Systems Using Terminals (No DECwindows Interface): VMS Operating System Refer to the System Support Addendum (SSA 27.37.04-x) for availability and required versions of prerequisite/optional software and for information regarding components of VMS DECwin- dows. ORDERING INFORMATION Software Licenses: QL-A98A*-** Software Media: QA-A98A*-** Software Documentation: QA-A98AA-GZ Software Product Services: QT-A98A*-** VAX DECalc-PLUS Upgrade License A VAX DECalc-PLUS Upgrade License is available for customers who are using DECalc and want to upgrade to the advanced func- tionality of DECalc-PLUS. This Upgrade license must be pur- chased with DECalc-PLUS media, documentation, and services. Software License: AL-VDFA*-** 5 VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 * Denotes variant fields. For additional information on avail- able licenses, services, and media, refer to the appro- priate price book. SOFTWARE LICENSING This software is furnished under the licensing provisions of Digital Equipment Corporation's Standard Terms and Con- ditions. For more information about Digital's licensing terms and policies, contact your local Digital office. LICENSE MANAGEMENT FACILITY SUPPORT This layered product supports the VMS License Management Fa- cility. License units for this product are allocated on a CPU-capacity basis. For more information on the License Management Facility, re- fer to the VMS Operating System Software Product Descrip- tion (SPD 25.01.xx) or the License Management Facility man- ual of the VMS Operating System documentation set. For more information about Digital's licensing terms and poli- cies, contact your local Digital office. SOFTWARE PRODUCT SERVICES A variety of service options are available from Digital. For more information, contact your local Digital office. 6 VAX DECalc-PLUS, Version 4.0 SPD 27.37.04 SOFTWARE WARRANTY Warranty for this software product is provided by Digital with the purchase of a license for the product as defined in the Software Warranty Addendum of this SPD. [TM]The DIGITAL Logo, CI, DECalc-PLUS, DCL, DECgraph, MicroVAX, TK50, VAX, VAX DATATRIEVE, VAXserver, VAXs- tation, VAX Xway, VMS, VT100 and VT300 are trademarks of Digital Equipment Corporation. 7 System Support Addendum _________________________________________________________ _________________________________________________________ PRODUCT NAME: VAX DECalc-PLUS, Version 4.0 SSA 27.37.04-A HARDWARE REQUIREMENTS Processors Supported VAX: VAXft 3000 Model 310, VAX 4000 Model 200, VAX 4000 Model 300, VAX 6000 Model 200 Series, VAX 6000 Model 300 Series, VAX 6000 Model 400 Series, VAX 6000 Model 500 Series VAX 8200, VAX 8250, VAX 8300, VAX 8350, VAX 8500, VAX 8530, VAX 8550, VAX 8600, VAX 8650, VAX 8700, VAX 8800, VAX 8810, VAX 8820, VAX 8830, VAX 8840 VAX 9000 Model 210, VAX 9000 Model 400 Series VAX-11/730, VAX-11/750, VAX-11/780, VAX-11/785 MicroVAX: MicroVAX II, MicroVAX 2000, MicroVAX 3100, MicroVAX 3300, MicroVAX 3400, MicroVAX 3500, MicroVAX 3600, MicroVAX 3800, MicroVAX 3900 DIGITAL August 1991 AE-LU02D-TE VAX DECalc-PLUS, Version 4.0 SSA 27.37.04-A VAXstation:VAXstation II, VAXstation 2000, VAXstation 3100 Series, VAXstation 3200, VAXstation 3500, VAXstation 3520, VAXstation 3540 VAXserver: VAXserver 3100, VAXserver 3300, VAXserver 3400, VAXserver 3500, VAXserver 3600, VAXserver 3602, VAXserver 3800, VAXserver 3900, VAXserver 4000 Model 200, VAXserver 4000 Model 300 VAXserver 6000-210, VAXserver 6000-220, VAXserver 6000-310, VAXserver 6000-320, VAXserver 6000-410, VAXserver 6000-420, VAXserver 6000-510, VAXserver 6000-520 Processors Not Supported MicroVAX I, VAXstation I, VAX-11/725, VAX 11/782, VAXstation 8000 Processor Restrictions: A TK50 Tape Drive is required for standalone MicroVAX 2000 and VAXstation 2000 systems. Other Hardware Required: None Disk Space Requirements (Block Cluster Size = 1): Disk space required for 6,000 blocks installation: (3.07M bytes) 2 VAX DECalc-PLUS, Version 4.0 SSA 27.37.04-A Disk space required for 6,000 blocks use (permanent): (3.07M bytes) These counts refer to the disk space required on the sys- tem disk. The sizes are approximate; actual sizes may vary depending on the user's system environment, configuration, and software options. CLUSTER ENVIRONMENT This layered product is fully supported when installed on any valid and licensed VAXcluster* configuration without re- strictions. The HARDWARE REQUIREMENTS sections of this prod- uct's Software Product Description and System Support Ad- dendum detail any special hardware required by this prod- uct. * V5.x VAXcluster configurations are fully described in the VAXcluster Software Product Description (29.78.xx) and include CI, Ethernet and Mixed Interconnect configura- tions. SOFTWARE REQUIREMENTS For Systems Using Terminals (No DECwindows Interface): VMS Operating System V5.4 VMS Tailoring For VMS V5.x systems, the following VMS class is required for full functionality of this layered product: o Utilities For more information on VMS classes and tailoring, refer to the VMS Operating System Software Product Description (SPD 25.01.xx). 3 VAX DECalc-PLUS, Version 4.0 SSA 27.37.04-A OPTIONAL SOFTWARE Certain versions of these products depend upon a specific version of the operating system. Please see the System Sup- port Addendum of the products in question to determine which version is required. VAX DATATRIEVE V5.1 VAX Xway V1.2 Any language which runs under VMS and supports the VAX Pro- cedure Calling Standard. GROWTH CONSIDERATIONS The minimum hardware/software requirements for any future version of this product may be different from the require- ments for the current version. DISTRIBUTION MEDIA 9-track 1600 BPI Magtape (PE), TK50 Streaming Tape This product is also available as part of the VMS Consol- idated Software Distribution on CDROM. ORDERING INFORMATION Software Licenses: QL-A98A*-** Software Media: QA-A98A*-** Software Documentation: QA-A98AA-GZ Software Product Services: QT-A98A*-** VAX DECalc-PLUS Upgrade License A VAX DECalc-PLUS Upgrade License is available for customers who are using DECalc-PLUS. This Upgrade license must be pur- chased with DECalc-PLUS media, documentation, and services. Software License: QL-VDFA*-** 4 VAX DECalc-PLUS, Version 4.0 SSA 27.37.04-A * Denotes variant fields. For additional information on avail- able licenses, services, and media, refer to the appro- priate price book. The above information is valid at time of release. Contact your local Digital office for the most up-to-date informa- tion. [TM]The DIGITAL Logo, CI, DECalc-PLUS, DCL, DECgraph, MicroVAX, TK50, VAX, VAX DATATRIEVE, VAXcluster, VAXserver, VAXstation, VAX Xway, VMS, VT100 and VT300 trademarks of Digital Equipment Corporation. 5