Search PubMedSearch

PubMed · 1814203

Translating mainframe computer data to spreadsheet format.

Abstract

The translation of mainframe-stored information in ASCII into spreadsheet format for use in Lotus 1-2-3 is explained. Details are presented on how to use the Data Parse command to create a translation template that tells Lotus 1-2-3 how to interpret a file written in ASCII. Lotus 1-2-3 can also translate some files in formats other than ASCII. It can translate files in the Data Interchange Format directly into its own format. Translating mainframe computer data into spreadsheet format is relatively simple and obviates the rekeying of those data.

Explore related subjects

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

T G Burnakis. 1991. Translating mainframe computer data to spreadsheet format.. https://pubmed.ncbi.nlm.nih.gov/1814203/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

Protein classification artificial neural system.

A neural network classification method is developed as an alternative approach to the large database search/organization problem. The system, termed Protein Classification Artificial Neural System (ProCANS), has been implemented on a Cray supercomputer for rapid superfamily classification of unknown proteins based on the information content of the neural interconnections. The system employs an n-gram hashing function that is similar to the k-tuple method for sequence encoding. A collection of modular back-propagation networks is used to store the large amount of sequence patterns. The system has been trained and tested with the first 2,148 of the 8,309 entries of the annotated Protein Identification Resource protein sequence database (release 29). The entries included the electron transfer proteins and the six enzyme groups (oxidoreductases, transferases, hydrolases, lyases, isomerases, and ligases), with a total of 620 superfamilies. After a total training time of seven Cray central processing unit (CPU) hours, the system has reached a predictive accuracy of 90%. The classification is fast (i.e., 0.1 Cray CPU second per sequence), as it only involves a forward-feeding through the networks. The classification time on a full-scale system embedded with all known superfamilies is estimated to be within 1 CPU second. Although the training time will grow linearly with the number of entries, the classification time is expected to remain low even if there is a 10-100-fold increase of sequence entries. The neural database, which consists of a set of weight matrices of the networks, together with the ProCANS software, can be ported to other computers and made available to the genome community. The rapid and accurate superfamily classification would be valuable to the organization of protein sequence databases and to the gene recognition in large sequencing projects.

Computers, Mainframe

GOFCOX: a computer program for the goodness-of-fit analysis of the Cox proportional hazards model.

GOFCOX is a user-friendly FORTRAN program for assessing the adequacy of the Cox proportional hazards model. The underlying methodology is based on the comparison of the maximum partial likelihood estimator and a weighted parameter estimator. The latter is the root to an estimation equation that assigns varying weights to the individual contributions to the partial likelihood score function. The weighted and unweighted parameter estimators have the same expectation under the Cox model, but tend to differ when the model is inappropriate. The GOFCOX program computes a rich class of weighted parameter estimators and corresponding goodness-of-fit test statistics. The program runs on both mainframe computers and microcomputers. The running time is minimal even for large data sets. A simple example is provided to illustrate the features of the program.

Computers, Mainframe

Micro-mainframe-like personal clinical research system.

We constructed a micro-mainframe-link clinical research system for personal use (Personal Clinical Research System). This system was developed with both a mainframe computer and a personal computer (PC). The prepared programs included a database manager (on the mainframe computer), a user interface program (on the PC), and a communication control program that connected the mainframe computer with the PC. The database on the mainframe computer was constructed by two methods. The first method was to transmit data from the PC to the mainframe computer. The second method was to extract data from the patient information database. Using this system, a physician is able to construct a personal research database that contains interesting data for the physician. In addition, the physician is able to accumulate data on a special field using this system. A discharge summary system is now in operation as an example of this system.

Computers, Mainframe