1. Description

• Clearly defined and accurate function, industry and application
• Appropriately identified and tagged
• Must have a preview version and screen shots

2. Structural Features (Vumero’s Recommended Model Characteristics)

• Instruction/Dashboard sheet
• Clearly separate inputs from calculations and outputs
• Avoid using constants inside formulae
• Logical flow of calculations (top-down, left-to-right)
• Names, formulas and formats should follow a consistent convention
• Minimise duplication
• Use consistent formulae across rows
• In-built error checks and input validation
• Assumptions documented
• Any complex calculations are broken up into simple pieces
• Hard code only inputs and source data
• Easy to understand, manipulate and find desired information

 
 
Back to Verification