用伪代码记录电子表格：现金流和贷款的练习
Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans
摘要：
“三思而后行”;“及时一针省九针”;“欲速则不达”。许多谚语都宣扬先计划后行动的智慧。我们建议如何将其应用于Excel，在编码之前解释和指定电子表格，以便始终为审计员和维护程序员提供文档。规范方法使用“伪代码”：为了精确和简洁，类似于程序设计语言但不可执行的代码。然而，它是基于我们的Excelsior电子表格生成器使用的符号，这是可执行的。本文的结构是一个教程，在其中我们开发了一个简单的现金流和贷款电子表格。
英文摘要：
"Look before you leap"; "a stitch in time saves nine"; "more haste, less speed". Many proverbs declare the wisdom of planning before doing. We suggest how to apply this to Excel, by explaining and specifying spreadsheets before coding them, so there will always be documentation for auditors and maintenance programmers. The specification method uses "pseudo-code": code that, for precision and conciseness, resembles a programming language, but is not executable. It is, however, based on the notation used by our Excelsior spreadsheet generator, which is executable. This paper is structured as a tutorial, in which we develop a simple cash-flow and loans spreadsheet.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
