Sort Controls into Preventive and Detective Checks

Place each model control in the bucket that best describes when it acts. Preventive Detective Data validation limiting scenario names to Base, Upside, or Downside Protected formula cells on the calculation sheet A red flag when assets do not equal liabilities plus equity A warning when modeled revenue does not tie to the ERP source total Input range rule blocking negative headcount assumptions A sign-check line catching positive cost-of-goods values where negatives are expected

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in