UEDIT-- A Full-Scale, Scrollable APL2 Spreadsheet Input/Output Editor
Lewis, Peter A. W.
Steinfeld, Uwe H.
MetadataShow full item record
A full-screen, scrollable spreadsheet-like editor written in the APL2 language is described for inputting, examining and outputting data. Mixed numeric and character arrays can be read into or read out to formatted DOS files (ASCII) or comma delimited DOS files. Alternatively a bulk mode input facility allows for rapid direct data entry, or data can be examined and edited cell-by- cell in the usual way. Columns, rows or blocks of data can be highlighted in a chosen color, shadowed, moved or copied. In addition APL functions entered on the command line can use the blocks as input or output. A facility for coding missing values is also provided. Major-to-minor (lexicographic) sorts can be performed on selected columns, and conditional or unconditional frequency tabulations and cross-tabulations of selected columns can be performed. Output is obtained as a new spreadsheet, or equivalently, as an APL2 matrix. In particular, two-way cross-tabulations of multiple columns are laid out in the spreadsheet like draftsman plots to facilitate investigation and explanation of multivariate categorical data. No numerical coding of the data is needed. (kr)
RightsThis publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.
NPS Report NumberNPS-55-90-08
Showing items related by title, author, creator and subject.
Draftsmans displays for contingency tables using a full-screen, scrollable APL2 spreadsheet input/output editor with application to the PERSEREC database of Special Background Investigation Steinfeld, Uwe H. (Monterey, California. Naval Postgraduate School, 1990-03);A full-screen, scrollable spreadsheet-like editor written in the APL2 language is described for inputting, examining and outputting data. Mixed numeric and character arrays can be read into or read out to formatted DOS ...
Emmons, Nelson L (Monterey, California. Naval Postgraduate School, 1997-06);The entry into higher mathematics begins with calculus. Rarely, however, does the calculus student recognize the full power and applications for the mathematical concepts and tools that are taught. Frank R. Giordano, Maurice ...
Buttrey, Samuel E. (Monterey, California. Naval Postgraduate School, 2007); NPS-OR-07-002The widely-used Excel spreadsheet program has a linear regression routine, but it has a number of drawbacks: it does not handle categorical predictors; it requires to the user to generate columns for interactions; it ...