COMMERCE 3FD3 Chapter Notes - Chapter 12,15,17: Ordinary Income, Tax Bracket, Investment
2 Nov 2016
School
Department
Course
Professor
Document Summary
Chapter 12 building good excel models and debugging them. Realistic: used for actual decisions, assumptions, mathematical relationships, inputs must be realistic. Error-free: test to make sure, use debugging section to help. Flexible: useful if can answer different types of questions, do not want to make major changes each time it is used for something slightly different. Easy to use: clear description of what it does and how to run it, color code input data and clearly label. Easily understandable formulas: avoid writing long formulas, use intermediate calculations, want people to be able to reuse, use descriptive cell and range names. If need to use long complicated formulas consider vba. Judicious formatting: bad formatting reduces usefulness, fonts, borders, patterns, colours make model easier to understand and use. Appropriate numbers formatting: use minimum number of decimal pointes necessary, too many is hard to read and gives false sense of precision. Minimum hard coding: hard to change later.
