PortaCalc (AnalytiCalc) Brought to you courtesy of Glenn and Mary Everhart 409 High St. Mt. Holly, NJ. 08060 USA Version 17.1, Spring 1985 Why buy a spreadsheet somebody sells? This program is designed to be superior to the high-priced models for PDP11 and VAX (also on 8088), and is easier to customize if you need to. PortaCalc (AnalytiCalc) now is still faster, has symbolic names and macros, area addressing, random numbers, many new functions including business and logicals, load and relocate, and many more enhancements. This version of AnalytiCalc (PortaCalc) now contains a two page memory paging algorithm for the PDP11 version. It also has a version presented here for the first time containing a Datatrieve-32 interface permitting exchange of data between DTR databases and AnalytiCalc spreadsheets in both directions. This is in addition to the pre-existing data file access capabilities and is implemented both in interactive commands and in functions. AnalytiCalc is fully 3 dimensional as well. This spreadsheet finally can do matrix math and has (in the usrfct.src module which may be optionally included for VAX) some routines for iteratively searching up to 8 dimensional spaces for solutions to problems. In addition, the VAX version permits DCL commands to be spawned so you don't have to leave the spreadsheet to interact with other sorts of applications (e.g., databases, the graphics utility). Numerous additions and bugfixes make the versions of the sheet here more capable than older ones. The database-access facility from each cell has been debugged and improved and the programmability of cells now includes ability to test ascii values of formulae and to execute arbitrary commands from inside a cell program (except help, exit, and interactive mode). In addition, since the advent of V10.9, a powerful text integration feature has been added permitting onscreen display of external files and integration with output, or screen controlled insertion of word processing files into spreadsheet outputs with screen controlled indentation. ABSTRACT: PortaCalc is a powerful 3 dimensional spreadsheet/database and analysis system with easy user extensibility designed to outperform most any commercial package available, running on PDP11 systems able to support the F4P compiler, or VAX systems, needing the VAX FORTRAN compiler to compile. Several terminals are supported, including the VT100 series, VT52, Datamedia Colorscan 10 and Elite 1500, Televideo 925, and ANSI color terminals. A full DTR-32 interface is supported on VAX. The program is designed for portability to other Fortran systems, with peculiarities used documented, and its manual is designed to be turned into a system HELP file so that it can be read online. Tutorials are supplied as well. Recustomizing for other terminals is easy; only direct cursor addressing, screen erase, and line erase are required, though reverse video allows use of the VT100 templates which yield an easier-to-read screen. A data management system interface is built in, permitting spreadsheets to access a potentially unlimited number of files and records or parts of records in those files for user defined functions, numbers, formulas, text, or whatnot. In fact it has many of the attributes of a language. Every cell may contain far more complex formulas than most commercially sold programs, and indeed may be a complete program with the ability to execute most command-level spreadsheet commands, though with minor restrictions. Merging of multiple sheets, matrix algebra, general function solving (a la TK!SOLVER, though with a less polished user interface), and easy document load/unload make this spreadsheet very significantly more powerful than all but the most elaborate mainframe packages, and infinitely easier to customize. User commands may be entered via keyword or function key and are provided with a comprehensive HELP system permitting users to individually tailor commands to their needs. A powerful text integration function permits integration of word processing files with reports, permitting use of AnalytiCalc (PortaCalc) to integrate sections of reports which are edited with any editor. It also simplifies inserting text from external files flexibly over null cells of the spreadsheet. This package runs on PDP11, or on VAX in NATIVE MODE. Versions have been built for RSX11M, RSX11M+, VMS, and RSTS, though supplied build files are for the RSX and VMS versions only. Speed of the VAX versions is higher than many of the expensive commercial ones. An 8088 version is available from the author at a modest cost. There are 2 major versions, though several variants may be selected (read the build files and READMEs): 1. PortaCalc-VM: For VAX only, uses demand-zero pages to eliminate workfile and speed operation. Normal default build supports 16000 or 32000 cells, but size is compiler option. Recommended VAX version. 2. PortaCalc-PC: for PDP11 or VAX, uses a smarter algorithm for storage management and can support a 16,000 cell array even on an RSX system without using memory mapping directives. Recommended PDP11 version. This version is buildable (using the PCCMAKIVD.COM command file) for VAX with a DTR - 32 interface and for DTR sites may be the preferred VAX version too. There is also an older version which is not recommended at this time but is present in case it is desired to use it. 1. PortaCalc-XL: For PDP11 only with mapping directives. Uses virtual arrays to provide a 4000 cell area, which can be split into rows/columns in any way desired. NOTE: only PORTACALC-VM and PortaCalc-PC have all features!!! It is STRONGLY recommended that VAX sites use PortaCalc-VM or -PC and that PDP11 sites use PortaCalc-PC. For PDP11 users, if you experience size difficulties, edit PVKLUGPRM.FOR and reduce the size of the sheet, and also be careful of edits to FCS11M.ODL which are done if you must compile with F4P instead of F77; the supplied ODL file is for F77 and names of OTS modules must be changed for use with F4P according to the DEC docs supplied with F4P. Complete source code for all versions is provided. It is assumed the F4P or F77 compiler is available for PDP11 (uses Fortran 66 for greatest portability; author has an 8088 version), or the DEC VAX FORTRAN compiler for VAX. Object libraries are provided for VAX systems not owning Fortran, and task images for RSX systems without F77. However, these are not guaranteed to be totally current and recompilation is ALWAYS advised. A separate graphics output task is documented in PCG.DOC and provides histograms or scatterplots of any areas of the saved spread sheets with a simple command syntax. SPECIAL HARDWARE: The software must be built for the appropriate terminal. Versions of the UVT100 subroutine for VT100, VT52, Datamedia Elite, and several other types of terminals including VT100 with Advanced Video and Colorscan 10 are supplied, with command files for most combinations. The VT52 version will show what the minimum requirements are for control. Most any terminal can be easily interfaced to the package by editing one of the UVT100 routines to correspond to the terminal's control sequences, provided direct cursor addressing is supported.