Option Impacts Analysis - Version 1 Option Impacts Analysis analyzes preferences shares from survey data. It applies when you want to determine the preference structure and flows between options to show from which other options each option immediately draws its share. The program will analyze from three to 30 options. Relevant appraisal data for input from surveys can be in the form of ratings, rankings, selection probabilities, or option selection identifications. Option Impacts Analysis is a Microsoft Excel VBA program than can be run as an Add-In or simply by double-clicking on the program and running it within Microsoft Excel.