In this section we offer tips that might be useful for developing technical spreadsheets. Many of these tips are based on our experience gained during developing our design spreadheets. The tips are divided into the following groups:

• General Tips
  • Reusability
  • Modular Design
  • ReadMe Tab, Instructions and Documentation
  • Formulas, Input Fields and Color Coding
  • Header and Footer
  • Overall Clarity
  • Database Features
  • Spreadsheets Management
  • Versioning
• Excel Tips
• Visual Basic Tips