How to Document a Spreadsheet: an Exercise with Cash-Flow and Loans

Following Gliders, Hasslers, and the Toadsucker: Writing and Explaining a Structured Excel Life Game, I've been trying more structured spreadsheet programming. This time, a cash-flow spreadsheet which defines several loans — imagine them as credit cards — and, each month, selects the best loan for the amount the user wants to borrow. I'm pleased with it, because it came out as really nice functional code, and the spreadsheet neatly depicts the loan-selection mechanism, Excel tables complementing a textual program. And, as an antidote to the horror story below, I think it shows how one should document a spreadsheet.



March 25, 2009
URL:http://www.drdobbs.com/database/ternary-search-trees/database/how-to-document-a-spreadsheet-an-exercis/228701162

Terms of Service | Privacy Statement | Copyright © 2024 UBM Tech, All rights reserved.