#1 Principles of Modeling

  • Principles: consistency, clarity, + efficiecny
  • Hacks
    • Windows + E opens up documents/ my computer
    • CTRL + F1 opena nd acloses ribbon

Workbook calculation as “partial” to not re-run data tables each time

Enable iterative calculation:

image
image

Check on aesthetics

  • 1 decimal, they align, negatives in parens, and only top and bottom have $, color coded

ctrl +~ = formula view