Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans

Details Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans

2009-08-08

arxiv.org/abs/0908.1187v1

Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2009 173-183 ISBN 978-1-905617-89-0

Computer Science

Software Engineering

12 Pages

Scientific paper

"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.

Affiliated with

Also associated with

No associations

Rating

Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-426179