Batch Spreadsheet for C Programmers
This work introduces a tool for C programmers to perform spreadsheet-like computations with iterative capabilities, but it is incremental as it builds on existing spreadsheet and programming concepts.
The authors proposed a batch spreadsheet environment that uses C syntax for formulas and supports cyclic computations, enabling iterative algorithms through convergent cycles. The system can integrate with a GUI for enhanced interaction and plotting capabilities.
A computing environment is proposed, based on batch spreadsheet processing, which produces a spreadsheet display from plain text input files of commands, similar to the way documents are created using LaTeX. In this environment, besides the usual spreadsheet rows and columns of cells, variables can be defined and are stored in a separate symbol table. Cell and symbol formulas may contain cycles, and cycles which converge can be used to implement iterative algorithms. Formulas are specified using the syntax of the C programming language, and all of C's numeric operators are supported, with operators such as ++, +=, etc. being implicitly cyclic. User-defined functions can be written in C and are accessed using a dynamic link library. The environment can be combined with a GUI front-end processor to enable easier interaction and graphics including plotting.