Method for generating source code in a procedural, re-entrant-compatible programming language using a spreadsheet representation

A method for generating a program in a procedural re-entrant compatible programming language for a computer which has access to data of a data source, having the steps:

• creating a spreadsheet using a table calculation program;
• defining logic operations between various cells of the spreadsheet;
• defining an assignment of the data from the data source to the cells of the spreadsheet;
• and
• generating a source code of a procedural, re-entrant-compatible programming language based on exemplary algorithms represented in the spreadsheet using a generator, which when called, reads data from the data source, executes a logic operation on it and outputs the result of the logic operation,
• and in which the logic operation on the data from data sources and the cells of the calculation program and its further use in formulas of other cells is interpreted using example rows in such a way that, in a form which can be predicted by the developer, specific cell areas are respectively newly executed for each logic unit of a source, which is mapped onto cells of a row of the spreadsheet,
• and wherein some of the logic operations which are formed are recursively dependent, and wherein if recursive dependencies of some of the logic operations formed cannot be detected statically, one or more of the following measures are taken:
• making a plausible assumption about the method calculation sequence;
• generating a warning message;
• and allowing the user to influence the calculation sequence by producing data about the position of the addressed area for the cell areas.