This example resets the Crystal Ball simulation and fits all distributions to a columnar data set in cells A1 through C500 (including a header row). The selected ranking method is Anderson-Darling. Results are output in a range on the current worksheet, where D1 is the first cell (in the upper left corner). Resulting assumption correlations are displayed in a matrix. Correlations are established for assumptions whose absolute correlation is equal to or greater than 0.2. Goodness-of-fit and assumption reports are created with specified names. The assumption report includes full statistics. The last line of code runs the Batch Fit tool.
CB.ResetND ' Select all distributions CB.BatchFitND cbBftSelectDistAll ' Set input range orientation (data in columns) CB.BatchFitND cbBftInputOrientation, cbBftInputColumns ' Input range has headers CB.BatchFitND cbBftInputHeader, True ' Select input range CB.BatchFitND cbBftInputRange, "A1:C500" ' Select the Anderson-Darling ranking method CB.BatchFitND cbBftRankMethod, cbFitAndersonDarling ' Select output location (starting in cell D1 of a new worksheet) CB.BatchFitND cbBftOutputLocation, cbBftNewWorksheet, False, "D1" ' Show correlation matrix between the data series CB.BatchFitND cbBftOutputCorrelationMatrix, True ' Do not format output CB.BatchFitND cbBftOutputFormat, False ' Correlate assumptions where the absolute correlation is 0.2 or greater CB.BatchFitND cbBftOutputCorrelation, True, 0.2 'Output results to "Batch Fit Results" CB.BatchFitND cbBftOutputSheetName, "Batch Fit Results" 'Fill results downward CB.BatchFitND cbBftOutputOrientation, cbBftOutputColumns ' Create goodness-of-fit report named "Fit Statistics" CB.BatchFitND cbBftOutputGoodnessOfFitReport, True, "Fit Statistics" ' Create assumption report, "Fit Assumption Report", with full statistics CB.BatchFitND cbBftOutputAssumReport, True, "Fit Assumption Report" CB.BatchFitND cbBftOutputAssumFullStatistics, True ' Run the tool CB.BatchFitND cbBftRun